report_pirl

parameters:PROCEDURE runQuarter( an_py                      IN NUMBER     DEFAULT NULL, an_qtr                      IN NUMBER     DEFAULT NULL, ab_generate_entire_file     IN BOOLEAN    DEFAULT FALSE, ab_generate_report_indv_file IN BOOLEAN    DEFAULT FALSE, ab_importUIData             IN BOOLEAN    DEFAULT TRUE, ab_applyUIDate              IN BOOLEAN    DEFAULT TRUE, ad_daily_snapshot_date      IN DATE       DEFAULT NULL, use_pirl_aggregate_query_tab IN BOOLEAN    DEFAULT TRUE, do_finalize                 IN BOOLEAN    DEFAULT TRUE)execution example:report_pirl.runQuarter(  an_py         => 2007,  an_qtr         => 3,  ab_importUIData    => TRUE,  ab_applyUIDate     => TRUE );

PROCEDURE init(an_py IN NUMBER, an_qtr IN NUMBER, ad_daily_snapshot_date IN DATE)execute:init(an_py, an_qtr, ad_daily_snapshot_date);

PROCEDURE runByProgram( an_py                       IN NUMBER     DEFAULT NULL, an_qtr                      IN NUMBER     DEFAULT NULL, as_program_code             IN VARCHAR2   DEFAULT NULL, ab_populate_table           IN BOOLEAN    DEFAULT TRUE, ab_generate_files_by_program IN BOOLEAN    DEFAULT TRUE, ad_daily_snapshot_date      IN DATE       DEFAULT NULL, do_finalize                 IN BOOLEAN    DEFAULT FALSE)Call: runByProgram(util_pirl.periods_rec.rpt_py, util_pirl.periods_rec.rpt_qtr, 'ADULT', ad_daily_snapshot_date => ad_daily_snapshot_date); runByProgram(util_pirl.periods_rec.rpt_py, util_pirl.periods_rec.rpt_qtr, 'DW',   ad_daily_snapshot_date => ad_daily_snapshot_date); runByProgram(util_pirl.periods_rec.rpt_py, util_pirl.periods_rec.rpt_qtr, 'YTH',  ad_daily_snapshot_date => ad_daily_snapshot_date); runByProgram(util_pirl.periods_rec.rpt_py, util_pirl.periods_rec.rpt_qtr, 'ESA',  ad_daily_snapshot_date => ad_daily_snapshot_date); runByProgram(util_pirl.periods_rec.rpt_py, util_pirl.periods_rec.rpt_qtr, 'TAA',  ad_daily_snapshot_date => ad_daily_snapshot_date);

PROCEDURE populateErrorSummaryTable( an_py          IN PLS_INTEGER, an_qtr         IN PLS_INTEGER)Call:populateErrorSummaryTable(util_pirl.periods_rec.rpt_py, util_pirl.periods_rec.rpt_qtr);

Note:1.     The runAnnual() is not being used. It is equivalent to running the runQuarter() for the 4th quarter PROCEDURE runAnnual( an_py                       IN NUMBER     DEFAULT NULL, ab_generate_entire_file     IN BOOLEAN    DEFAULT FALSE, ab_generate_report_indv_file IN BOOLEAN    DEFAULT FALSE, ab_importUIData             IN BOOLEAN    DEFAULT TRUE, ab_applyUIDate              IN BOOLEAN    DEFAULT TRUE)calls:runQuarter(an_py,util_pirl.ANNUAL,ab_generate_entire_file,ab_generate_report_indv_file,ab_importUIData,ab_applyUIDate);Constant Value:util_pirl.ANNUAL                        CONSTANT INTEGER := 5;

The Daily Job is executing on Server around 6PM , and has the follow name "RPT - PIRL YTD Job".The execution call is given as follow example:/* PIRL Reports Daily */ mediated_service_report.report_pirl.runQuarter(   an_py                 => TO_CHAR(ADD_MONTHS(SYSDATE, -6), 'YYYY'),   an_qtr                => TO_CHAR(ADD_MONTHS(SYSDATE, -6), 'Q'),   ad_daily_snapshot_date => SYSDATE);

The follow address are available to tracking job logs execution:developmenthttps://devmis.michworks.org/ms/plsql/web_batch_run.BatchRunCriteriaproductionhttps://services.michworks.org/ms/plsql/web_batch_run.BatchRunCriteria