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.)