22 Outputs

This package includes APIs for submitting a job for printing, and for retrieving the BLOB and CLOB objects associated with Oracle LSH output.

22.1 Generate Outputs

This section contains the following topics:

• Section 22.1.1, "Submit a Print Request"

• Section 22.1.2, "Get an Output's BLOB"

• Section 22.1.3, "Get an Output's CLOB"

22.1.1 Submit a Print Request

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

Signature 

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; 

Return Type NUMBER

Description Concurrent Request Id

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.

22.1.2 Get an Output's BLOB

Use this API to retrieve the BLOB associated with an output object.

Name CDR_PUB_PRINT_OUTPUT.GetOutPutBlob

Signature 

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; 

Return Type BLOB

Description 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 CDR_DF_PUB_DEF_CONSTANTS.Current_Company_ID.

• 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.

22.1.3 Get an Output's CLOB

Use this API to retrieve the CLOB associated with a specified output object.

Name CDR_PUB_PRINT_OUTPUT.GetOutputCLOB

Signature 

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; 

Return Type CLOB

Description 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.