Get a PRREF_ID for an Executable in a Workflow

Use this API to get the PRREF_ID and PRREF_VER for an executable Object instance contained in a Workflow. You need these values to run Mapping APIs.

Name

CDR_PUB_DF_MAPPING.GetPRREFIDforObjUnderWF

Signature

PROCEDURE GETPRREFIDFOROBJUNDERWF( 
  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_SIMPLEOBJ  IN    CDR_BASE_OBJ_TYPE, 
  PI_RSIOBJ  IN    CDR_BASE_OBJ_TYPE, 
  PI_WFIOBJ  IN    CDR_BASE_OBJ_TYPE, 
  PO_PRREFID  OUT    CDR_PROGRAM_REFS.PRREF_ID%TYPE, 
  PO_PRREFVER  OUT    CDR_PROGRAM_REFS.PRREF_VER%TYPE 
); 

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PI_SIMPLEOBJ (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE. Enter values to identify the Program, Load Set, or Data Mart instance whose PRREFID you need.

  The following attributes are required: COMPANY_ID, OBJ_ID, OBJ_VER.

• PI_RSIOBJ (Optional) If you are getting the PRREFID for a Program instance contained in a Report Set that within a Workflow, enter values to identify the Report Set instance in which the Program instance is located. This is a parameter of table type CDR_BASE_OBJ_TYPE.

  The following attributes are required: COMPANY_ID, OBJ_ID,OBJ_VER.

• PI_WFIOBJ (Mandatory) This is a parameter of table type CDR_BASE_OBJ_TYPE. Enter values to identify the Workflow instance that contains the Program, Load Set, or Data Mart instance whose PRREFID you need.

  The following attributes are required: COMPANY_ID, OBJ_ID,OBJ_VER.

• PO_PRREFID This output parameter returns the executable object instance's PRREF_ID.
• PO_PRREFVER This output parameter returns the executable object instance's PRREF_VER.