Oracle Cloud Infrastructure Documentation

OSub Organization Subscription Common Types

DBMS_CLOUD_OCI_OSUB_ORGANIZATION_SUBSCRIPTION_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

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

DBMS_CLOUD_OCI_OSUB_ORGANIZATION_SUBSCRIPTION_CURRENCY_T Type

Currency details

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_organization_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_organization_subscription_currency_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_organization_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_ORGANIZATION_SUBSCRIPTION_ERROR_T Type

Internal error object model.

Syntax

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

Subscription summary

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_osub_organization_subscription_subscription_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  service_name varchar2(32767),
  l_type varchar2(32767),
  status varchar2(32767),
  time_start timestamp with time zone,
  time_end timestamp with time zone,
  currency dbms_cloud_oci_osub_organization_subscription_currency_t,
  total_value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_organization_subscription_subscription_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_osub_organization_subscription_subscription_summary_t (
    id varchar2,
    service_name varchar2,
    l_type varchar2,
    status varchar2,
    time_start timestamp with time zone,
    time_end timestamp with time zone,
    currency dbms_cloud_oci_osub_organization_subscription_currency_t,
    total_value varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required) SPM internal Subscription ID

service_name

(optional) Customer friendly service name provided by PRG

l_type

(optional) Subscription Type i.e. IAAS,SAAS,PAAS

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)

total_value

(optional) Total aggregate TCLV of all lines for the subscription including expired, active, and signed