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.
Parent topic: Flag-Related APIs