Upgrade All Execution Setups

Use this API to upgrade all the Execution Setups associated with an object.

Name

CDR_PUB_DF_EXECUTIONSETUP.UpgradeExecSetups

Signature

PROCEDURE UPGRADEEXECSETUPS( 
  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_EOICOMPID  IN    NUMBER, 
  PI_EOIOBJID  IN    NUMBER, 
  PI_EOIOBJVER  IN    NUMBER, 
  PO_NOTRUNNABLEESLIST  OUT    CDR_BASE_OBJ_COLL 
); 

Parameters

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

• PI_EOICOMPID (Mandatory) Enter the COMPANY_ID of the executable object instance for which the Execution Setup is intended.
• PI_EOIOBJID (Mandatory) Enter the OBJ_ID of the executable object instance for which the Execution Setup is intended.
• PI_EOIOBJVER (Mandatory) Enter the OBJ_VER of the executable object instance for which the Execution Setup is intended.
• PO_NOTRUNNABLEESLIST This is an output parameter that returns a collection of CDR_BASE_OBJ_TYPE containing Execution Setups whose status has changed from Runnable to Not-Runnable.