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.

This chapter contains the following section:

• Generate Outputs
  

Generate Outputs

This section contains the following topics:

• Submit a Print Request
  
• Get an Output's BLOB
  
• Get an Output's CLOB
  

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.

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.

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.