PKG_AGG_RPT Data Load Package
The data load package handles the data extraction and derivations that prepare the data for reporting. Table 4-3 provides the complete list of procedures and functions present in this package.
Table 4-3 Data Load Package Details
Procedure/Function | Usage |
---|---|
Global Variables |
Describes all parameters shown or hidden on the BIP report screen as package level variables. Parameter values are automatically stored by the BIP report during execution. |
Lexical Variables |
Normal package variables described according to the lexical parameters used in the BIP report. |
p_pop_psur_case_temp |
Populates the temp table GTT_RPT_AGG_CASE. |
p_pop_psur_drug_temp |
Populates the temp table GTT_RPT_AGG_DRUG. |
p_pop_psur_event_temp |
Populates the temp table GTT_RPT_AGG_EVENT. |
p_pop_psur_ev2drug_temp |
Populates the table GTT_RPT_AGG_EV2DRUG. |
p_pop_psur_healthauthids_temp |
Populates the temp table GTT_RPT_AGG_HEALTHAUTHID. |
p_pop_psur_drugnames_temp |
Populates the table GTT_RPT_AGG_DRUGNAMES. |
f_before_data |
The main function invoked from BI Publisher. Called from the Before Report trigger of the BI Publisher report. |
f_get_report_id |
Retrieves the PN_REG_REPORT_ID parameter value. |
p_set_report_id |
Sets the PN_REG_REPORT_ID parameter value to the global variable so it can be retrieved through f_get_report_id in BIP reports. |
p_check_cs_case_ctr |
Checks the counts of cases needed for the trailer page. |
p_ins_rpt_status |
Inserts the record into PER_RPT_STATUS for log reporting. |
p_upd_rpt_status |
Updates the status of the report on completion with success or failure. |
f_after_report |
Final trigger invoked by Oracle Business Intelligence Publisher. |
f_get_evtseriouscr_list |
Gets the event seriousness criteria list. |
f_get_dose_stringlist |
Generates the dose string list. |
f_get_uniq_patient_id |
Obtains the unique patient ID. |
p_updclinicaldrugrole |
Updates the clinicaldrugrole column in GTT_RPT_AGG_DRUG table. |
p_update_gtt_tables |
Updates the GTT tables for follow-up. |
FindAggRptJobID |
Local procedure that hits theOracle Business Intelligence Publisher metadata repository tables, obtains the blob data, converts into clob for easy processing, and arrives at the Job ID through the supplied parameters to the BIP reports. The Job ID is then inserted into the RPT_AGG_BIP_JOB table. |
pop_user_security_tables |
Populates user security tables based on the user-security level. |
p_populate_cover_params |
Fills in the data for the RPT_AGG_PARAMS table needed for the cover page. |
p_populate_listedness |
Determines and populates listedness for each case-event-product based on the chosen algorithm. |
p_copy_rpt_case_series |
Copies all case series required for report execution into the RPT_AGG_CASE_SERIES and RPT_AGG_CS_CASES tables. |
p_populate_dlp_cases |
Populates DLP cases. |
p_set_lex_conditions |
Handles the conditions used to set lexical parameters. |
p_pop_log_tables |
Populates all RM_ tables. |
p_pop_concurrency_errors |
Populates the Concurrency Error Handling that mentions whether the case series is modified while a report is in progress. |
Parent topic: Packages