Remove a Snapshot Label from a Work Area

Use this API to remove a snapshot label from the passing Work Area.

Name

CDR_PUB_EXE_SNAPSHOT.RemoveLabel

Signature

PROCEDURE REMOVELABEL( 
  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, 
  PI_WA_COMPANY_ID   IN CDR_NAMINGS.COMPANY_ID%TYPE,   
  PI_WA_OBJ_ID       IN CDR_NAMINGS.OBJ_ID%TYPE,
  PI_WA_OBJ_VER      IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE,
  PI_WA_TABLES_COLL  in OUT NOCOPY CDR_WA_TABLES_COLL,
  PI_LABEL           IN CDR_TAB_REF_LABELS.LABEL%TYPE,
  X_RETURN_STATUS  OUT    VARCHAR2, 
  X_MSG_COUNT  OUT    NUMBER, 
  X_MSG_DATA  OUT    VARCHAR2, 
); 

Parameters

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

• PI_WA_COMPANY_ID (Mandatory) Enter the Company ID.
• PI_WA_OBJ_ID (Mandatory) Enter the Work Area object ID.
• PI_WA_OBJ_VER (Mandatory) Enter the latest object version.
• PI_WA_TABLES_COLL (Optional) User can pass the collection of table instance of the same Work Area on which user want remove the Snapshot Label.
• PI_LABEL (Mandatory) Label value.