Delete Flag

Use this API to delete an existing DMW Flag state.

Name

DME_PUB_FLAG_DATA.DeleteFlag

Signature

PROCEDURE DELETEFLAG 
(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_COMPANY_ID IN NUMBER,
PI_TAB_OBJ_ID IN NUMBER,
PI_SKEY_VALUE IN VARCHAR2,
PI_FLAG_ID IN NUMBER,

Parameters

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

  • PI_COMPANY_ID (Mandatory). Enter the company ID.
  • PI_TAB_OBJ_ID (Mandatory). This input parameter is an object id for a namings object of type $OBJTYPES$TABLEREF (table instance).
  • PI_SKEY_VALUE (Mandatory). The surrogate key of the record.
  • PI_FLAG_ID (Mandatory). This input parameter is the ID of the flag whose state you want to remove.