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.