PKG_EXPD_RPT - Data Load Package

This package is used to populate PMDA (R3) Global temporary tables referred to in the Oracle Business Intelligence Publisher data model to generate the PMDA (R3) Paper report.

Data Load Package Details

Procedure/Function	Usage
p_ins_expd_rpt	This procedure extracts and inserts XML data from ESM owner's SAFETYREPORT table and stores it in GTT_RPT_EXPD_XML.
p_upd_expd_rpt_decode	This procedure replaces the code value in the xml with decoded descriptions.
p_upd_blinded_elements	Based on the profile, the elements marked for blinded are masked in the XML Data.
p_upd_decade	Handles the patient or parent age when the age unit is in decades.
p_upd_j10_element	Based on the profile, this procedure masks the j10 element in the XML.
f_upd_null_flavor	Null flavor handling for common elements.
p_upd_meddra_terms	Handles the MedDRA terms in the XML.
f_get_m2_descj	Obtains the DESCRIPTION_J value from CFG_M2.
p_upd_country_codes	Updates the country codes in the XML.
f_get_pmda_title	Generates the Title of the report.
f_before_data	This function Populates temp tables used by the report.
f_get_report_id	Function to get the PN_REG_REPORT_ID parameter value.
p_set_report_id	Procedure to set the PN_REG_REPORT_ID parameter value to Global variable.
f_after_report	Function to delete the unwanted rows from the tables.
P_lab_matrix	This Procedure inserts necessary data for Lab Matrix.
p_upd_drug_trtmnt	This Procedure updates XML data for drugtreatmentduration.