Oracle® Life Sciences Data Hub Application Programming Interface Guide Release 2.2.2 E55501-01 |
|
|
PDF · Mobi · ePub |
This package includes APIs for submitting a job for printing, and for retrieving the BLOB and CLOB objects associated with Oracle LSH output.
This section contains the following topics:
Use this API to print a specified output. The API submits a request to the Oracle LSH printing concurrent program that prints the specified output.
Name CDR_PUB_PRINT_OUTPUT.SubmitPrintRequest
Description Concurrent Request Id
FUNCTION SUBMITPRINTREQUEST( 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_NCOMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_NOUTPUTID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_NOUTPUTOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE, PI_VPRINTERNAME IN FND_PRINTER.PRINTER_NAME%TYPE := NULL, PI_VCOVERSHEET IN VARCHAR2 := NULL ) RETURN NUMBER;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_NCOMPANYID (Mandatory) Enter your company ID.
To get your company ID, use CDR_DF_PUB_DEF_CONSTANTS.Current_Company_ID.
PI_NOUTPUTID (Mandatory) Enter the obj_id of the output you want to print.
PI_NOUTPUTOBJVER (Mandatory) Enter the obj_ver of the output you want to print.
PI_VPRINTERNAME (Mandatory) Enter the printer name.
PI_VCOVERSHEET (Mandatory) Enter the text for the coversheet. You can enter text only up to 4000 bytes.
Use this API to retrieve the BLOB associated with an output object.
Name CDR_PUB_PRINT_OUTPUT.GetOutPutBlob
Description BLOB
FUNCTION GETOUTPUTBLOB( 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_NOUTPUTID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_NOUTPUTOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ) RETURN BLOB;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_NCOMPANYID (Mandatory) Enter your company ID.
To get your company ID, use the CDR_DF_PUB_DEF_CONSTANTS.Current_Company_ID API.
PI_NOUTPUTID (Mandatory) Enter the obj_ID of the output whose BLOB you want to retrieve.
PI_NOUTPUTOBJVER (Mandatory) Enter the obj_ver of the output whose BLOB you want to retrieve.
Use this API to retrieve the CLOB associated with a specified output object.
Name CDR_PUB_PRINT_OUTPUT.GetOutputCLOB
Description Clob
FUNCTION GETOUTPUTCLOB( 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_NOUTPUTID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_NOUTPUTOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE ) RETURN CLOB;
Parameters This API has standard parameters (see "Standard Parameters") and the following parameters:
PI_NCOMPANYID (Mandatory) Enter your company ID.
To get your company ID, use CDR_DF_PUB_DEF_CONSTANTS.Current_Company_ID.
PI_NOUTPUTID (Mandatory) Enter the obj_ID of the output whose CLOB you want to retrieve.
PI_NOUTPUTOBJVER (Mandatory) Enter the obj_ver of the output whose CLOB you want to retrieve.