Oracle Cloud Infrastructure Documentation

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

time_start

(optional) Commitment start date

time_end

(optional) Commitment end date

quantity

(optional) Commitment quantity

available_amount

(optional) Commitment available amount

line_net_amount

(optional) Commitment line net amount

funded_allocation_value

(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

id

(required) SPM internal Commitment ID

time_start

(optional) Commitment start date

time_end

(optional) Commitment end date

quantity

(optional) Commitment quantity

used_amount

(optional) Commitment used amount

available_amount

(optional) Commitment available amount

funded_allocation_value

(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

id

(required) SPM internal Commitment ID

time_start

(optional) Commitment start date

time_end

(optional) Commitment end date

quantity

(optional) Commitment quantity

used_amount

(optional) Commitment used amount

available_amount

(optional) Commitment available amount

funded_allocation_value

(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

name

(optional) Currency name

iso_code

(required) Currency Code

std_precision

(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

code

(required) A short error code that defines the error, meant for programmatic parsing.

message

(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

part_number

(required) Product part numner

name

(required) Product name

unit_of_measure

(required) Unit of measure

billing_category

(optional) Metered service billing category

product_category

(optional) Product category

ucm_rate_card_part_type

(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

up_to_quantity

(optional) Rate card tier quantity range

net_unit_price

(optional) Rate card tier net unit price

overage_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

product

(required)

time_start

(optional) Rate card start date

time_end

(optional) Rate card end date

net_unit_price

(required) Rate card net unit price

discretionary_discount_percentage

(optional) Rate card discretionary discount percentage

overage_price

(required) Rate card overage price

is_tier

(optional) Rate card price tier flag

currency

(optional)

rate_card_tiers

(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

part_number

(required) Product part numner

name

(required) Product name

unit_of_measure

(required) Unit of measure

provisioning_group

(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

id

(required) SPM internal Subscribed Service ID

product

(optional)

quantity

(optional) Subscribed service quantity

status

(optional) Subscribed service status

operation_type

(optional) Subscribed service operation type

net_unit_price

(optional) Subscribed service net unit price

funded_allocation_value

(optional) Funded Allocation line value example: 12000.00

partner_transaction_type

(optional) This field contains the name of the partner to which the subscription belongs - depending on which the invoicing may differ

term_value

(optional) Term value in Months

term_value_uom

(optional) Term value UOM

booking_opty_number

(optional) Booking Opportunity Number of Subscribed Service

total_value

(optional) Subscribed service total value

order_number

(optional) Sales Order Number associated to the subscribed service

data_center_region

(optional) Subscribed service data center region

pricing_model

(optional) Subscribed service pricing model

program_type

(optional) Subscribed service program type

promo_type

(optional) Subscribed service promotion type

csi

(optional) Subscribed service CSI number

is_intent_to_pay

(optional) Subscribed service intent to pay flag

time_start

(optional) Subscribed service start date

time_end

(optional) Subscribed service end date

commitment_services

(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

status

(optional) Status of the plan

time_start

(optional) Represents the date when the first service of the subscription was activated

time_end

(optional) Represents the date when the last service of the subscription ends

currency

(optional)

service_name

(optional) Customer friendly service name provided by PRG

subscribed_services

(optional) List of Subscribed Services of the plan