PKG_EXPD_RPT_UTIL - Utility Package
This package contains all the accessory procedures and functions required for generating PMDA (R3) paper reports.
Utility Package Details
Procedure/Function | Usage |
---|---|
f_get_biprep_path |
Obtains the BIP report path from configured flexible code lists. |
f_get_codelist_code |
Obtains the Code list CODE from the CODE_LIST_DETAIL_DISCRETE table. |
p_get_expd_rpt_params |
Obtains the records from the CFG_RPT_AGG_PARAMS table for the PMDA (R3) Paper report template (Default template id is 11). |
f_get_rpt_ctr |
Obtains the count from the RPT_SAVED_MSG table for the report to be generated. |
f_get_codelist_val |
Obtains the Code list Display_Value from CODE_LIST_DETAIL_DISCRETE table. |
f_get_rpt_catg |
Function to get the Reporting Category from CMN_REG_REPORTS. |
f_get_ja_date |
Function to convert varchar date column in lab matrix to Japanese date format. |
p_get_blinded_text |
Procedure to get the blinded text and blinded text element for B.4.k.2.2. |
Parent topic: Packages