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.
Parent topic: Create and Modify Mappings