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. |
Parent topic: Packages