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 |
|---|---|
|
|
(optional) Currency name |
|
|
(required) Currency Code |
|
|
(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 |
|---|---|
|
|
(required) A short error code that defines the error, meant for programmatic parsing. |
|
|
(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 |
|---|---|
|
|
(required) SPM internal Subscription ID |
|
|
(optional) Customer friendly service name provided by PRG |
|
|
(optional) Subscription Type i.e. IAAS,SAAS,PAAS |
|
|
(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) Total aggregate TCLV of all lines for the subscription including expired, active, and signed |