Get Flags on Data Fuller

This API retrieves information about all the flag states on a particular record.

Name

DME_PUB_FLAG_DATA.GetFlagsOnDataFuller

Signature

PROCEDURE getFlagsOnDataFuller
  ( 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
  , po_flags OUT NOCOPY dme_flag_show_ver4_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.
• PO_FLAGS (Mandatory). This is a parameter of type DME_FLAG_SHOW_VER4_COLL that returns: or the returned values (names, states, priorities, last category update date and last category update user)
  • Flag Name
  • Flag State Priority Code
  • Flag State Priority Meaning
  • Most Recent Category Update Date (The most recent update of any flag 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.)