Oracle® Life Sciences Data Hub Application Programming Interface Guide Release 2.2.2 E55501-01 |
|
|
PDF · Mobi · ePub |
This is a public interface for operations related to the setting up of utilities in Oracle LSH.
This section contains the following topics:
This is a public interface that is used internally to initialize all other Oracle LSH external API packages. See "Calling the Security API Package" for details. See "Code Example Using Security and Error Message APIs" for an example of a program that calls the initialization API.
This section contains the following topics:
This is used internally to initialize external Oracle LSH API packages.
Name CDR_PUB_API_INITIALIZATION.Initialization
PROCEDURE INITIALIZATION( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_VPKGNAME IN VARCHAR2 );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_VPKGNAME This is used internally to pass the external API package name.
Use this API to find out whether or not the API you want to use is enabled.
Name CDR_PUB_API_INITIALIZATION.IsAPIenabled
True, if the API is enabled or False, if it is disabled.
FUNCTION ISAPIENABLED( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters" for details).
Use this API to enable LSH APIs that you want to use in a session. This API must be called at the beginning of each Program that uses LSH APIs.
Name CDR_PUB_API_INITIALIZATION.EnableAPIs
PROCEDURE ENABLEAPIS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2 );
Parameters This API has standard parameters (see "Standard Parameters" for details).
Use this API to disable LSH APIs that you have used in a session. Call this API at the end of each Program that uses LSH APIs.
Name CDR_PUB_API_INITIALIZATION.DisableAPIs
True, if the API is enabled or False, if it is disabled.
P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 DEFAULT, P_COMMIT IN VARCHAR2 DEFAULT, P_VALIDATION_LEVEL IN NUMBER DEFAULT, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2 );
Parameters This API has standard parameters (see "Standard Parameters" for details).
This package is used to create adapter domains and adapter areas for user defined adapters.
This section contains the following topics:
Use this API to create an Adapter Domain.
Name CDR_PUB_ATK_ADAPTER.CreateAdapterDomain
PROCEDURE CREATEADAPTERDOMAIN( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PIO_ADAPTERDOMAINNAMING IN OUT CDR_NAMING_VERSION_OBJ_TYPE );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_ADAPTERDOMAINNAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE. Enter values for the Adapter Domain that you are creating. For OBJECT_TYPE_RC enter $OBJTYPES$ADAPTERDOMAIN.
The following attributes are required: COMPANY_ID,NAME.
Use this API to modify an Adapter Domain.
Name CDR_PUB_ATK_ADAPTER.ModifyAdapterDomain
PROCEDURE MODIFYADAPTERDOMAIN( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT NOCOPY VARCHAR2, X_MSG_COUNT OUT NOCOPY NUMBER, X_MSG_DATA OUT NOCOPY VARCHAR2, PIO_ADAPTERDOMAINNAMING IN OUT NOCOPY CDR_NAMING_VERSION_OBJ_TYPE );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_ADAPTERDOMAINNAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE. Enter values to identify the Adapter Domain and enter new values for the attributes you want to modify. All attributes are required. For OBJECT_TYPE_RC enter $OBJTYPES$ADAPTERDOMAIN.
Use this API to create an Adapter Area.
Name CDR_PUB_ATK_ADAPTER.CreateAdapterArea
PROCEDURE CREATEADAPTERAREA( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PIO_ADAPTERAREANAMING IN OUT CDR_NAMING_VERSION_OBJ_TYPE, PIO_ADAPTERAREAROW IN OUT CDR_ADAPTER_AREAS%ROWTYPE );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PIO_ADAPTERAREANAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE. Enter values for the adapter area that you are creating.
PIO_ADAPTERAREAROW (Mandatory) This is a parameter of row type CDR_ADAPTER_AREAS table. Enter values specific for the adapter area that you are creating. For OBJECT_TYPE_RC enter $OBJTYPES$ADAPTERAREA.
The following attributes are required: COMPANY_ID,NAME.
Use this API to modify an Adapter Area.
Name CDR_PUB_ATK_ADAPTER.ModifyAdapterArea
PROCEDURE MODIFYADAPTERAREA( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT NOCOPY VARCHAR2, X_MSG_COUNT OUT NOCOPY NUMBER, X_MSG_DATA OUT NOCOPY VARCHAR2, PIO_ADAPTERAREANAMING IN OUT NOCOPY CDR_NAMING_VERSION_OBJ_TYPE, PIO_ADAPTERAREAROW IN OUT NOCOPY CDR_ADAPTER_AREAS%ROWTYPE, );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PIO_ADAPTERDOMAINNAMING (Mandatory) This is a parameter of table-type CDR_NAMING_VERSION_OBJ_TYPE. Enter values to identify the Adapter Area and enter new values for the attributes you want to modify.
All attributes are required.
PIO_ADAPTERAREAROW (Mandatory) This is a parameter of row-type CDR_ADAPTER_AREAS table.
For OBJECT_TYPE_RC enter $OBJTYPES$ADAPTERAREA.
Use this API to populate a Tech Type Table.
Name CDR_PUB_ATK_ADAPTER.PopulateTechTypes
PROCEDURE POPULATETECHTYPES( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PIO_TECHTYPEROW IN OUT CDR_TECH_TYPES%ROWTYPE );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_TECHTYPEROW (Mandatory) This is a parameter of row type cdr_tech_types table. Enter values specific for the tech type that you are creating.
Use this API to modify a Tech Type Table.
Name CDR_PUB_ATK_ADAPTER.ModifyTechTypes
PROCEDURE MODIFYTECHTYPE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT NOCOPY VARCHAR2, X_MSG_COUNT OUT NOCOPY NUMBER, X_MSG_DATA OUT NOCOPY VARCHAR2, PIO_TECHTYPEROW IN OUT NOCOPY CDR_TECH_TYPES%ROWTYPE, );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_TECHTYPEROW (Mandatory) This is a parameter of row type cdr_tech_types table. Enter values specific for the tech type that you want to update.
This is a public interface that hosts definition constants for Oracle LSH APIs.
This is a public interface that hosts utility APIs for other packages.
This section contains the following topics:
Use this API to retrieve a valid CDR_NAMING_VERSION_OBJ_TYPE parameter by passing the primary keys COMPANY_ID, OBJ_ID, and OBJ_VER to it.
Name CDR_PUB_DEF_FACTORY_SUPPORT.GetNamingObject
FUNCTION GETNAMINGOBJECT( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_NCOMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_NOBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_NOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE, PO_CDRNAMING OUT CDR_NAMING_VERSION_OBJ_TYPE ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_NCOMPANYID (Mandatory) Enter the COMPANY_ID of the object. Use "Get a Company ID".
PI_NOBJID (Mandatory) Enter the OBJ_ID of the object.
PI_NOBJVER (Mandatory) Enter the OBJ_VER of the object.
PO_CDRNAMING (Mandatory) This is the output from the API.
Use this API to retrieve a user ID.
Name CDR_PUB_DEF_FACTORY_SUPPORT.GetUserID
Return CDR_DF_NAMING_V.CHECKED_OUT_ID%TYPE
FUNCTION GETUSERID( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL ) RETURN CDR_DF_NAMING_V.CHECKED_OUT_ID%TYPE;
Parameters This API has standard parameters (see "Standard Parameters" for details).
Use this API to retrieve the current user name.
Name CDR_PUB_DEF_FACTORY_SUPPORT.GetUserName
FUNCTION GETUSERNAME( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_USERID IN NUMBER ) RETURN VARCHAR2;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_USERID (Mandatory) Enter the User ID. Use CDR_PUB_DEF_FACTORY_SUPPORT.GETUSERID to get the ID of the current user.
This is a public interface that hosts utility APIs for other packages.
This section contains the following topics:
Use this API to retrieve all details of an object from CDR_BASE_OBJ_TYPE table, by passing the object's primary key values: COMPANY_ID, OBJ_ID, and OBJ_VER.
Name CDR_PUB_DEF_FACTORY_UTILS.GetCDRBaseObject
FUNCTION GETCDRBASEOBJECT( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_COMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_OBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_OBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ) RETURN CDR_BASE_OBJ_TYPE;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_COMPANYID (Mandatory) Enter the COMPANY_ID of the object.
PI_OBJID (Mandatory) Enter the OBJ_ID of the object.
PI_OBJVER (Mandatory) Enter the OBJ_VER of the object.
Use this API to retrieve the COMPANY_ID of a given object. The object is identified from the context that this API is used in.
Name CDR_PUB_DEF_FACTORY_UTILS.GetCompanyID
Returns Company ID from the context.
FUNCTION GETCOMPANYID( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL ) RETURN NUMBER;
Parameters This API has standard parameters (see "Standard Parameters" for details).
This is a public interface that hosts APIs for checking object validation on various objects. These APIs are tools to automatically validate objects without having to manually set their attributes to validate them.
This section contains the following topics:
Use this API to validate whether a given object is created in a valid parent; for example, you may want to check if a Program Definition is a valid parent of a Table Descriptor.
Name CDR_PUB_DEF_FACTORY_VALIDATE.ValidateNamespace
FUNCTION VALIDATENAMESPACE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PIO_SOURCECDRNAMING IN OUT CDR_NAMING_VERSION_OBJ_TYPE ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_SOURCECDRNAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSIONS_OBJ_TYPE that contains CDR Naming Version attributes.
For OBJECT_TYPE_RC enter the appropriate value for the object for which you want to validate a reference.
Other required attributes are: COMPANY_ID,OBJ_ID,OBJ_VER,OBJECT_TYPE_RC,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER,REF_COMPANY_ID,REF_OBJ_ID,REF_OBJ_VER
Use this API to validate the definition specified for the given object id.
Name CDR_PUB_DEF_FACTORY_VALIDATE.ValidateReference
If the function returns True, then the reference is valid, else it's invalid.
FUNCTION VALIDATEREFERENCE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PIO_SOURCECDRNAMING IN OUT CDR_NAMING_VERSION_OBJ_TYPE ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_SOURCECDRNAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSIONS_OBJ_TYPE that contains CDR Naming Version attributes.
For OBJECT_TYPE_RC enter the appropriate value for the object for which you want to validate a reference.
Other required attributes are: COMPANY_ID,OBJ_ID,OBJ_VER,OBJECT_TYPE_RC,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER,REF_COMPANY_ID,REF_OBJ_ID,REF_OBJ_VER
This is a public interface that is used to retrieve data from naming-related tables.
This section contains the following topics:
Use this API to retrieve the latest version available for a given object.
Name CDR_PUB_DF_NAMING_UTIL.GetLastVersion
FUNCTION GETLASTVERSION( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN NUMBER;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to get the maximum versions of a specified object and its namespace.
Name CDR_PUB_DF_NAMING_UTIL.GetMaxObjAndNsVersions
PROCEDURE GETMAXOBJANDNSVERSIONS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_COMPID IN NUMBER, PI_OBJID IN NUMBER, PO_MAXOBJVER OUT NUMBER, PO_MAXNSOBJVER OUT NUMBER );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_COMPID (Mandatory) Enter the COMPANY_ID of the given object.
PI_OBJID (Mandatory) Enter the OBJ_ID of the given object.
PO_MAXOBJVER This is an output parameter. It returns the maximum version of the given object.
PO_MAXNSOBJVER This is an output parameter. It returns the maximum version of the Namespace of the given object.
Use this API to get the type of a specified naming object.
Name CDR_PUB_DF_NAMING_UTIL.GetNamingObjectType
FUNCTION GETNAMINGOBJECTTYPE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PIO_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN VARCHAR2;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE. The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to retrieve an initialized object of table type CDR_NAMING_VERSION_OBJ_TYPE for a given naming object.
Name CDR_PUB_DF_NAMING_UTIL.GetNamingVersionObject
Return Type CDR_NAMING_VERSION_OBJ_TYPE
FUNCTION GETNAMINGVERSIONOBJECT( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN CDR_NAMING_VERSION_OBJ_TYPE;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to retrieve the object subtype ID of a given naming object.
Name CDR_PUB_DF_NAMING_UTIL.GetObjectSubtypeID
FUNCTION GETOBJECTSUBTYPEID( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN NUMBER;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to find out whether or not a naming object is checked out.
Name CDR_PUB_DF_NAMING_UTIL.IsNamingCheckedOut
FUNCTION ISNAMINGCHECKEDOUT( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PIO_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to retrieve the checkout status and implicit checkout property of a specified object.
Name CDR_PUB_DF_NAMING_UTIL.GetChkoutProp
PROCEDURE GETCHKOUTPROP( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_COMPID IN NUMBER, PI_OBJID IN NUMBER, PO_CHKOUTSTATUS OUT VARCHAR2, PO_CHKIMPLPROP OUT VARCHAR2 );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_COMPID (Mandatory) Enter the COMPANY_ID of the given object.
PI_OBJID (Mandatory) Enter the OBJ_ID of the given object.
PO_CHKOUTSTATUS This is an output parameter. It returns the checkout status of the given object
PO_CHKIMPLPROP This is an output parameter. It returns the implicit checkout property of the given object.
Use this API to retrieve the parent object of a given naming object.
Name CDR_PUB_DF_NAMING_UTIL.GetParentNaming
FUNCTION GETPARENTNAMING( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN CDR_BASE_OBJ_TYPE;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to retrieve the parent object of a naming object.
Name CDR_PUB_DF_NAMING_UTIL.GetParentNaming
FUNCTION GETPARENTNAMING( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN CDR_BASE_OBJ_TYPE;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER
Use this API to retrieve the latest version of the parent of the given object.
Name CDR_PUB_DF_NAMING_UTIL.GetLatestVersionOfParent
FUNCTION GETLATESTVERSIONOFPARENT( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN CDR_BASE_OBJ_TYPE;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to get the naming status of the parent object of the specified object
Name CDR_PUB_DF_NAMING_UTIL.GetParentNamingStatus
FUNCTION GETPARENTNAMINGSTATUS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_COMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_NSOBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_NSOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ) RETURN VARCHAR2;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_COMPANYID (Mandatory) Enter the COMPANY_ID of the object.
PI_NSOBJID (Mandatory) Enter the OBJ_ID of the given object.
PI_NSOBJVER (Mandatory) Enter the OBJ_VER of the given object.
Use this API to get the validation status of the parent object of the specified object
Name CDR_PUB_DF_NAMING_UTIL.GetParentValidationStatus
FUNCTION GETPARENTVALIDATIONSTATUS( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_COMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_NSOBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_NSOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ) RETURN VARCHAR2;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_COMPANYID (Mandatory) This refers to the company id of the given object.
PI_NSOBJID (Mandatory) Enter the OBJ_ID of the given object.
PI_NSOBJVER (Mandatory) Enter the OBJ_VER of the given object.
Use this API to retrieve the definition object that the given instance object points to.
Name CDR_PUB_DF_NAMING_UTIL.GetRefNaming
FUNCTION GETREFNAMING( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN CDR_BASE_OBJ_TYPE;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to get the Lookup Meaning for a Lookup Type and Code
Name CDR_PUB_DF_NAMING_UTIL.GetLookupMeaning
PROCEDURE GETLOOKUPMEANING( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_LOOKUPTYPE IN VARCHAR2, PI_LOOKUPCODE IN VARCHAR2, PO_LOOKUPMEANING OUT VARCHAR2 );
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_LOOKUPTYPE (Mandatory) Enter the Lookup Type
PI_LOOKUPCODE (Mandatory) Enter the Lookup Code
PO_LOOKUPMEANING This is an output parameter. It returns the Lookup Meaning.
Use this API to check if the given naming object is an instance.
Name CDR_PUB_DF_NAMING_UTIL.IsInstance
FUNCTION ISINSTANCE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_OBJECT_TYPE_RC IN VARCHAR2 ) RETURN VARCHAR2;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_OBJECT_TYPE_RC (Mandatory) Object Type RC.
Use this API to find out whether the given naming object is checked out by the current user.
Name CDR_PUB_DF_NAMING_UTIL.IsCheckedOutByUser
FUNCTION ISCHECKEDOUTBYUSER( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PIO_BASEOBJECT IN CDR_BASE_OBJ_TYPE ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PIO_BASEOBJECT (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE.
The required attributes are COMPANY_ID,OBJECT_ID,OBJECT_VER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
Use this API to find out if an object is user specific or non-user specific. Only the user who checked out a user specific object can check it in; whereas any user may check in a non-user specific object.
Name CDR_PUB_DF_NAMING_UTIL.IsCheckOutUserSpecific
FUNCTION ISCHECKOUTUSERSPECIFIC( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_SOURCECDRNAMING IN CDR_NAMING_VERSION_OBJ_TYPE ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameter:
PI_SOURCECDRNAMING (Mandatory) This is a parameter of type cdr_naming_versions_obj_type.
The following attributes are required: COMPANY_ID, OBJECT_TYPE_RC, NAME, NAMESPACE_OBJ_ID, NAMESPACE_OBJ_VER, OWNING_LOCATION_RC, OBJECT_SUBTYPE_ID, DESCRIPTION, REF_COMPANY_ID, REF_OBJ_ID, REF_OBJ_VER.
Use this API to find out whether a naming object is checked out implicitly.
Name CDR_PUB_DF_NAMING_UTIL.IsCheckOutImplicit
FUNCTION ISCHECKOUTIMPLICIT( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PI_OBJECT_TYPE_RC IN VARCHAR2, PI_ISINSTONLY IN VARCHAR2 ) RETURN BOOLEAN;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_OBJECT_TYPE_RC (Mandatory) Enter the Object Type.
PI_ISINSTONLY (Mandatory) This will have the value 'YES' or 'NO', to indicate whether it is called from an Instance or a Definition.
This is a public interface for reporting using messages from the system's message stack. See "Code Example Using Security and Error Message APIs" for an example of a program that calls this reporting API.
This section contains the following topics:
Use this API to retrieve messages from the message stack.
Varchar2 Message Text
FUNCTION GET( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, P_MSG_INDEX IN NUMBER := G_NEXT, P_ENCODED IN VARCHAR2 := 'T' ) RETURN VARCHAR2;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
P_MSG_INDEX (Mandatory) Enter the number of the message you want to retrieve; for example, if you enter the number 1, the first message is retrieved from the message stack.
P_ENCODED (Mandatory) Enter T if you want the message to be encoded, and F if you do not.
Use this API to retrieve the count of messages in the message stack. This API returns the G_MSG_COUNT value.
Name CDR_PUB_MSG_PUB.Count_Msg
Number of messages in the stack
FUNCTION COUNT_MSG( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL ) RETURN NUMBER;
Parameters This API has standard parameters (see "Standard Parameters").
Use this API to initialize the global message table. This API clears the G_MSG_TBL and resets all its global variables, except the message level threshold value.
Name CDR_PUB_MSG_PUB.Initialize
PROCEDURE INITIALIZE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2 );
Parameters This API has standard parameters (see "Standard Parameters").