Get Flag
Use this API to retrieve information about an Oracle DMW flag setting.
Name
DME_PUB_FLAG_DATA.GetFlag
Signature
PROCEDURE GETFLAG ( 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, PO_FLAG_STATE OUT NOCOPY 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 obj_id of the table instance that contains the data record.
- PI_SKEY_VALUE (Mandatory).The surrogate key of the record
- PI_FLAG_ID (Mandatory). The unique ID of the flag (from dme_flag_names)
- PO_FLAG_STATE (Mandatory). This output parameter inherits the flag state for this record.
Parent topic: Flag-Related APIs