Set Flag

Use this API to set the state of a single flag for a given record.

Name

DME_PUB_FLAG_DATA.SetFlag

Signature

PROCEDURE SETFLAG, 
( 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_TIMESTAMP IN DATE,
PI_FLAG_ID IN NUMBER,
PI_FLAG_STATE IN VARCHAR2,
  );

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). Enter the object ID of the table instance that contains the data record.
• PI_SKEY_VALUE (Mandatory). Enter the surrogate key of the record.
• PI_TIMESTAMP Enter the latest timestamp of the data record. The system tracks which version of the record the flag was initially applied to.
• PI_FLAG_ID (Mandatory). Enter the unique ID of the flag (from dme_flag_names)
• PI_FLAG_STATE (Mandatory). The flag state to be applied for the data record.