Get Surrogate Key Values for Records in a Flag State
Use this API to get the surrogate keys for all records in a table that have the given state for the given flag.
Name
DME_PUB_FLAG_DATA.getRecordsForFlagState
Signature
PROCEDURE getRecordsForFlagState ( 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_flag_id IN NUMBER , pi_flag_state IN VARCHAR2 , pi_records OUT NOCOPY dme_char_coll);
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 for a namings object of type $OBJTYPES$TABLEREF (table instance) that contains the record.
- PI_FLAG_ID (Mandatory). Enter the ID of the flag.
- PI_FLAG_STATE (Mandatory). Enter the flag state.
- PI_RECORDS This output parameter is a collection of type dme_char_coll.
Parent topic: Flag-Related APIs