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.