Oracle Cloud Infrastructure Documentation

OSub Billing Schedule Common Types

DBMS_CLOUD_OCI_OSUB_BILLING_SCHEDULE_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_billing_schedule_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

DBMS_CLOUD_OCI_OSUB_BILLING_SCHEDULE_PRODUCT_T Type

Product description

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_billing_schedule_product_t FORCE AUTHID CURRENT_USER IS OBJECT (
  part_number varchar2(32767),
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_billing_schedule_product_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_billing_schedule_product_t (
    part_number varchar2,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

part_number

(required) Indicates the associated AR Invoice Number

name

(required) Product name

DBMS_CLOUD_OCI_OSUB_BILLING_SCHEDULE_BILLING_SCHEDULE_SUMMARY_T Type

Billing schedule details related to Subscription Id

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_billing_schedule_billing_schedule_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  time_invoicing timestamp with time zone,
  invoice_status varchar2(32767),
  quantity varchar2(32767),
  net_unit_price varchar2(32767),
  amount varchar2(32767),
  billing_frequency varchar2(32767),
  ar_invoice_number varchar2(32767),
  ar_customer_transaction_id varchar2(32767),
  order_number varchar2(32767),
  product dbms_cloud_oci_osub_billing_schedule_product_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_billing_schedule_billing_schedule_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_billing_schedule_billing_schedule_summary_t (
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    time_invoicing timestamp with time zone,
    invoice_status varchar2,
    quantity varchar2,
    net_unit_price varchar2,
    amount varchar2,
    billing_frequency varchar2,
    ar_invoice_number varchar2,
    ar_customer_transaction_id varchar2,
    order_number varchar2,
    product dbms_cloud_oci_osub_billing_schedule_product_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

time_start

(optional) Billing schedule start date

time_end

(optional) Billing schedule end date

time_invoicing

(optional) Billing schedule invoicing date

invoice_status

(optional) Billing schedule invoice status

Allowed values are: 'INVOICED', 'NOT_INVOICED'

quantity

(optional) Billing schedule quantity

net_unit_price

(optional) Billing schedule net unit price

amount

(optional) Billing schedule line net amount

billing_frequency

(optional) Billing frequency

ar_invoice_number

(optional) Indicates the associated AR Invoice Number

ar_customer_transaction_id

(optional) Indicates the associated AR Customer transaction id a unique identifier existing on AR.

order_number

(optional) Order number associated with the Subscribed Service

product

(optional)

DBMS_CLOUD_OCI_OSUB_BILLING_SCHEDULE_ERROR_T Type

Internal error object model.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_billing_schedule_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_billing_schedule_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_billing_schedule_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.