OSub Subscription Common Types
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_VARCHAR2_TBL Type
Nested table type of varchar2(32767).
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_COMMITMENT_T Type
Subscribed service commitment details
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_commitment_t FORCE AUTHID CURRENT_USER IS OBJECT (
time_start timestamp with time zone,
time_end timestamp with time zone,
quantity varchar2(32767),
available_amount varchar2(32767),
line_net_amount varchar2(32767),
funded_allocation_value varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_commitment_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_commitment_t (
time_start timestamp with time zone,
time_end timestamp with time zone,
quantity varchar2,
available_amount varchar2,
line_net_amount varchar2,
funded_allocation_value varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(optional) Commitment start date |
|
|
(optional) Commitment end date |
|
|
(optional) Commitment quantity |
|
|
(optional) Commitment available amount |
|
|
(optional) Commitment line net amount |
|
|
(optional) Funded Allocation line value |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_COMMITMENT_DETAIL_T Type
Subscribed Service commitment summary
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_commitment_detail_t FORCE AUTHID CURRENT_USER IS OBJECT (
id varchar2(32767),
time_start timestamp with time zone,
time_end timestamp with time zone,
quantity varchar2(32767),
used_amount varchar2(32767),
available_amount varchar2(32767),
funded_allocation_value varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_commitment_detail_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_commitment_detail_t (
id varchar2,
time_start timestamp with time zone,
time_end timestamp with time zone,
quantity varchar2,
used_amount varchar2,
available_amount varchar2,
funded_allocation_value varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) SPM internal Commitment ID |
|
|
(optional) Commitment start date |
|
|
(optional) Commitment end date |
|
|
(optional) Commitment quantity |
|
|
(optional) Commitment used amount |
|
|
(optional) Commitment available amount |
|
|
(optional) Funded Allocation line value example: 12000.00 |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_COMMITMENT_SUMMARY_T Type
Subscribed Service commitment summary
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_commitment_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
id varchar2(32767),
time_start timestamp with time zone,
time_end timestamp with time zone,
quantity varchar2(32767),
used_amount varchar2(32767),
available_amount varchar2(32767),
funded_allocation_value varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_commitment_summary_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_commitment_summary_t (
id varchar2,
time_start timestamp with time zone,
time_end timestamp with time zone,
quantity varchar2,
used_amount varchar2,
available_amount varchar2,
funded_allocation_value varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) SPM internal Commitment ID |
|
|
(optional) Commitment start date |
|
|
(optional) Commitment end date |
|
|
(optional) Commitment quantity |
|
|
(optional) Commitment used amount |
|
|
(optional) Commitment available amount |
|
|
(optional) Funded Allocation line value example: 12000.00 |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_CURRENCY_T Type
Currency details
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_currency_t FORCE AUTHID CURRENT_USER IS OBJECT (
name varchar2(32767),
iso_code varchar2(32767),
std_precision number,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_currency_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_currency_t (
name varchar2,
iso_code varchar2,
std_precision number
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(optional) Currency name |
|
|
(required) Currency Code |
|
|
(optional) Standard Precision of the Currency |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_ERROR_T Type
Internal error object model.
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
code varchar2(32767),
message varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_error_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_error_t (
code varchar2,
message varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) A short error code that defines the error, meant for programmatic parsing. |
|
|
(required) A human-readable error string. |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_PRODUCT_T Type
Product description
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_product_t FORCE AUTHID CURRENT_USER IS OBJECT (
part_number varchar2(32767),
name varchar2(32767),
unit_of_measure varchar2(32767),
billing_category varchar2(32767),
product_category varchar2(32767),
ucm_rate_card_part_type varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_product_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_product_t (
part_number varchar2,
name varchar2,
unit_of_measure varchar2,
billing_category varchar2,
product_category varchar2,
ucm_rate_card_part_type varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) Product part numner |
|
|
(required) Product name |
|
|
(required) Unit of measure |
|
|
(optional) Metered service billing category |
|
|
(optional) Product category |
|
|
(optional) Rate card part type of Product |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_RATE_CARD_TIER_T Type
Rate Card Tier details
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_rate_card_tier_t FORCE AUTHID CURRENT_USER IS OBJECT (
up_to_quantity varchar2(32767),
net_unit_price varchar2(32767),
overage_price varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_rate_card_tier_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_rate_card_tier_t (
up_to_quantity varchar2,
net_unit_price varchar2,
overage_price varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(optional) Rate card tier quantity range |
|
|
(optional) Rate card tier net unit price |
|
|
(optional) Rate card tier overage price |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_RATE_CARD_TIER_TBL Type
Nested table type of dbms_cloud_oci_osub_subscription_rate_card_tier_t.
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_rate_card_tier_tbl FORCE IS TABLE OF (dbms_cloud_oci_osub_subscription_rate_card_tier_t) NOT PERSISTABLE;DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_RATE_CARD_SUMMARY_T Type
Rate Card Summary
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_rate_card_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
product dbms_cloud_oci_osub_subscription_product_t,
time_start timestamp with time zone,
time_end timestamp with time zone,
net_unit_price varchar2(32767),
discretionary_discount_percentage varchar2(32767),
overage_price varchar2(32767),
is_tier number,
currency dbms_cloud_oci_osub_subscription_currency_t,
rate_card_tiers dbms_cloud_oci_osub_subscription_rate_card_tier_tbl,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_rate_card_summary_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_rate_card_summary_t (
product dbms_cloud_oci_osub_subscription_product_t,
time_start timestamp with time zone,
time_end timestamp with time zone,
net_unit_price varchar2,
discretionary_discount_percentage varchar2,
overage_price varchar2,
is_tier number,
currency dbms_cloud_oci_osub_subscription_currency_t,
rate_card_tiers dbms_cloud_oci_osub_subscription_rate_card_tier_tbl
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) |
|
|
(optional) Rate card start date |
|
|
(optional) Rate card end date |
|
|
(required) Rate card net unit price |
|
|
(optional) Rate card discretionary discount percentage |
|
|
(required) Rate card overage price |
|
|
(optional) Rate card price tier flag |
|
|
(optional) |
|
|
(optional) List of tiered rate card prices |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_SUBSCRIPTION_PRODUCT_T Type
Product description
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_subscription_product_t FORCE AUTHID CURRENT_USER IS OBJECT (
part_number varchar2(32767),
name varchar2(32767),
unit_of_measure varchar2(32767),
provisioning_group varchar2(32767),
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_subscription_product_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_subscription_product_t (
part_number varchar2,
name varchar2,
unit_of_measure varchar2,
provisioning_group varchar2
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) Product part numner |
|
|
(required) Product name |
|
|
(required) Unit of measure |
|
|
(optional) Product provisioning group |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_COMMITMENT_TBL Type
Nested table type of dbms_cloud_oci_osub_subscription_commitment_t.
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_commitment_tbl FORCE IS TABLE OF (dbms_cloud_oci_osub_subscription_commitment_t) NOT PERSISTABLE;DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_SUBSCRIBED_SERVICE_SUMMARY_T Type
Subscribed Service summary
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_subscribed_service_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
id varchar2(32767),
product dbms_cloud_oci_osub_subscription_subscription_product_t,
quantity varchar2(32767),
status varchar2(32767),
operation_type varchar2(32767),
net_unit_price varchar2(32767),
funded_allocation_value varchar2(32767),
partner_transaction_type varchar2(32767),
term_value number,
term_value_uom varchar2(32767),
booking_opty_number varchar2(32767),
total_value varchar2(32767),
order_number number,
data_center_region varchar2(32767),
pricing_model varchar2(32767),
program_type varchar2(32767),
promo_type varchar2(32767),
csi number,
is_intent_to_pay number,
time_start timestamp with time zone,
time_end timestamp with time zone,
commitment_services dbms_cloud_oci_osub_subscription_commitment_tbl,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_subscribed_service_summary_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_subscribed_service_summary_t (
id varchar2,
product dbms_cloud_oci_osub_subscription_subscription_product_t,
quantity varchar2,
status varchar2,
operation_type varchar2,
net_unit_price varchar2,
funded_allocation_value varchar2,
partner_transaction_type varchar2,
term_value number,
term_value_uom varchar2,
booking_opty_number varchar2,
total_value varchar2,
order_number number,
data_center_region varchar2,
pricing_model varchar2,
program_type varchar2,
promo_type varchar2,
csi number,
is_intent_to_pay number,
time_start timestamp with time zone,
time_end timestamp with time zone,
commitment_services dbms_cloud_oci_osub_subscription_commitment_tbl
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(required) SPM internal Subscribed Service ID |
|
|
(optional) |
|
|
(optional) Subscribed service quantity |
|
|
(optional) Subscribed service status |
|
|
(optional) Subscribed service operation type |
|
|
(optional) Subscribed service net unit price |
|
|
(optional) Funded Allocation line value example: 12000.00 |
|
|
(optional) This field contains the name of the partner to which the subscription belongs - depending on which the invoicing may differ |
|
|
(optional) Term value in Months |
|
|
(optional) Term value UOM |
|
|
(optional) Booking Opportunity Number of Subscribed Service |
|
|
(optional) Subscribed service total value |
|
|
(optional) Sales Order Number associated to the subscribed service |
|
|
(optional) Subscribed service data center region |
|
|
(optional) Subscribed service pricing model |
|
|
(optional) Subscribed service program type |
|
|
(optional) Subscribed service promotion type |
|
|
(optional) Subscribed service CSI number |
|
|
(optional) Subscribed service intent to pay flag |
|
|
(optional) Subscribed service start date |
|
|
(optional) Subscribed service end date |
|
|
(optional) List of Commitment services of a line |
DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_SUBSCRIBED_SERVICE_SUMMARY_TBL Type
Nested table type of dbms_cloud_oci_osub_subscription_subscribed_service_summary_t.
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_subscribed_service_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_osub_subscription_subscribed_service_summary_t) NOT PERSISTABLE;DBMS_CLOUD_OCI_OSUB_SUBSCRIPTION_SUBSCRIPTION_SUMMARY_T Type
Subscription summary
Syntax
CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_subscription_subscription_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
status varchar2(32767),
time_start timestamp with time zone,
time_end timestamp with time zone,
currency dbms_cloud_oci_osub_subscription_currency_t,
service_name varchar2(32767),
subscribed_services dbms_cloud_oci_osub_subscription_subscribed_service_summary_tbl,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_subscription_summary_t
RETURN SELF AS RESULT,
CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_subscription_subscription_summary_t (
status varchar2,
time_start timestamp with time zone,
time_end timestamp with time zone,
currency dbms_cloud_oci_osub_subscription_currency_t,
service_name varchar2,
subscribed_services dbms_cloud_oci_osub_subscription_subscribed_service_summary_tbl
) RETURN SELF AS RESULT
) NOT PERSISTABLE;Fields
| Field | Description |
|---|---|
|
|
(optional) Status of the plan |
|
|
(optional) Represents the date when the first service of the subscription was activated |
|
|
(optional) Represents the date when the last service of the subscription ends |
|
|
(optional) |
|
|
(optional) Customer friendly service name provided by PRG |
|
|
(optional) List of Subscribed Services of the plan |