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.