PKG_AGG_RPT_UTIL Utility Package
The utility package holds minor utility features for the data load. Table 4-2 provides a list of functions and procedures and their usage.
Table 4-2 Utility Package Details
Procedure/Function | Usage |
---|---|
f_get_query_details |
Populates the case series or query prompts that the user can access. |
f_print_as_text |
Determines the water mark. |
f_get_cs_name |
Returns the case series name for a Case Series ID. |
f_get_agency_name |
Gets the agency name for the passed Agency ID. |
p_fetchrptoutput |
Copies the report output data into Argus tables, updates CMN_REG_REPORTS, updates the report status tables and stores the submission details of the final report. |
f_get_duration |
Returns a formatted duration for printing in a report. For example, 10 days. |
f_get_codelist_val |
Gets the code list display value. |
f_get_enterprises |
Gets the Active Enterprise list on the BIP console. |
f_get_cmn_profile_flag |
Fetches the cmn_profile value on key. |
f_ConvertBlobToClob |
Converts the blob data into clob. |
Parent topic: Packages