Execute Transformation Map
Use this API to execute a Transformation Map.
Name
DME_PUB_XFORM_MAP.ExecuteXform
Signature
PROCEDURE EXECUTEXFORM (P_API_VERSION IN VARCHAR2, P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, X_RETURN_STATUS OUT NOCOPY VARCHAR2, X_MSG_COUNT OUT NOCOPY NUMBER, X_MSG_DATA OUT NOCOPY VARCHAR2, PI_MODELCOMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_MODELOBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_MODELOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE, PI_SUBMISSION_TYPE IN VARCHAR2 DEFAULT '$SUBMISSTYPES$IMMEDIATE', PI_CONTEXT IN VARCHAR2 DEFAULT '$LIFECYCLE$DEV', PI_SCHED_START_TS IN DATE DEFAULT NULL, PI_SCHED_END_TS IN DATE DEFAULT NULL, PI_SCHED_REPEAT_INTERVAL IN VARCHAR2 DEFAULT NULL, PI_SCHED_REPEAT_LIST IN VARCHAR2 DEFAULT NULL, PI_FORCE_EXECUTION_FLAG_RC IN VARCHAR2 DEFAULT '$YESNO$NO', PI_RUN_MODE_RC IN VARCHAR2, PI_TRIGGER_DOWNSTREAM IN VARCHAR2, PO_JOBID OUT NOCOPY CDR_JOBS.JOB_ID%TYPE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_MODELCOMPANYID (Mandatory). Company id of Target Data Model.
- PI_MODELOBJID (Mandatory). Object Id of Target Data Model.
- PI_MODELOBJVER (Mandatory). Object Version of Target Data Model
- PI_SUBMISSION_TYPE. Enter '$SUBMISSTYPES$IMMEDIATE or '$SUBMISSTYPES$SCHEDULED' or '$SUBMISSTYPES$DEFERRED'.
- PI_CONTEXT. Lifecycle context values like $LIFECYCLE$DEV, $LIFECYCLE$QC or $LIFECYCLE$PROD.
- PI_SCHED_START_TS. Enter start time if submission is scheduled/deferred.
- PI_SCHED_END_TS. Enter end time if submission is scheduled.
- PI_SCHED_REPEAT_INTERVAL. Enter inerval time if submission is scheduled.
- PI_SCHED_REPEAT_LIST. Enter Unit like Hour(s), Day(s), Week(s).
- PI_FORCE_EXECUTION_FLAG_RC. Enter '$YESNO$NO or '$YESNO$YES'.
- PI_RUN_MODE_RC. Enter '$RUNMODES$FULL' or '$RUNMODES$INCREMENT'
- PI_TRIGGER_DOWNSTREAM. Enter '$YESNO$YES' or '$YESNO$NO'.
Parent topic: Create and Modify Transformation Maps