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