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 Analytics 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 Analytics 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.