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.