Get Flags on Data
This API retrieves all the flags and their states, assigned to a particular data record, plus the latest update timestamp for each flag category per record.
It does not provide a timestamp for each individual flag update. If you want to see the update timestamp for a particular flag, you can create a category for that one flag.
Name
DME_PUB_FLAG_DATA.GetFlagsOnDataMore
Signature
PROCEDURE getFlagsOnDataMore ( 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_include_nulls IN NUMBER , po_flags OUT NOCOPY dme_flag_show_more_coll ) ;
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). This input parameter is an object ID for a namings object of type $OBJTYPES$TABLEREF (table instance).
- PI_SKEY_VALUE (Mandatory). Enter the surrogate key of the record whose flags you want to retrieve.
- PI_INCLUDE_NULLS (Mandatory). Set this input parameter to 1 to include information for flags with NULL state, else 0.
- PO_FLAGS (Output). This is a parameter of type DME_FLAG_SHOW_MORE_COLL that
returns:
- Flag ID
- Flag Name
- Flag Value
- Flag State Priority Code
- Flag State Priority Meaning
- Category ID
- Most Recent Category Update Date (The most recent update of any flag in the category.)
- Category Update User ID (The user ID of the user or validation check that performed the most recent flag assignment update in the category.)
- Category Update Username (The name of the user or validation check that performed the most recent flag assignment update in the category.)
Parent topic: Flag-Related APIs