1 package ben_batch_reporting as
2 /* $Header: benrepor.pkh 120.0 2005/05/28 09:26:12 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Batch Reporting
13 Purpose
14 This package is used to perform reporting for batch processes.
15 History
16 Date Who Version What?
17 ---- --- ------- -----
18 07 Oct 98 G Perry 115.0 Created.
19 14 Nov 99 G Perry 115.2 Added parameter to
20 run certain activity report
21 based on mode. Also added
22 temporal events procedure.
23 12 May 00 jcarpent 115.2 Changed parameters to
24 summary (127645/4424)
25 27 Dec 02 rpillay 115.5 NOCOPY changes
26 27 Dec 02 rpillay 115.6 Fixed GSCC errors
27 15 Jun 04 hmani 115.7 Added six more params
28 to temporal_life_events - Bug 3690166
29 */
30 -----------------------------------------------------------------------
31 procedure standard_header
32 (p_concurrent_request_id in number,
33 p_concurrent_program_name out nocopy varchar2,
34 p_process_date out nocopy date,
35 p_mode out nocopy varchar2,
36 p_derivable_factors out nocopy varchar2,
37 p_validate out nocopy varchar2,
38 p_person out nocopy varchar2,
39 p_person_type out nocopy varchar2,
40 p_program out nocopy varchar2,
41 p_business_group out nocopy varchar2,
42 p_plan out nocopy varchar2,
43 p_popl_enrt_typ_cycl out nocopy varchar2,
44 p_plans_not_in_programs out nocopy varchar2,
45 p_just_programs out nocopy varchar2,
46 p_comp_object_selection_rule out nocopy varchar2,
47 p_person_selection_rule out nocopy varchar2,
48 p_life_event_reason out nocopy varchar2,
49 p_organization out nocopy varchar2,
50 p_postal_zip_range out nocopy varchar2,
51 p_reporting_group out nocopy varchar2,
52 p_plan_type out nocopy varchar2,
53 p_option out nocopy varchar2,
54 p_eligibility_profile out nocopy varchar2,
55 p_variable_rate_profile out nocopy varchar2,
56 p_legal_entity out nocopy varchar2,
57 p_payroll out nocopy varchar2,
58 p_status out nocopy varchar2);
59 -----------------------------------------------------------------------
60 procedure process_information
61 (p_concurrent_request_id in number,
62 p_start_date out nocopy varchar2,
63 p_end_date out nocopy varchar2,
64 p_start_time out nocopy varchar2,
65 p_end_time out nocopy varchar2,
66 p_elapsed_time out nocopy varchar2,
67 p_persons_selected out nocopy varchar2,
68 p_persons_processed out nocopy varchar2,
69 p_persons_unprocessed out nocopy varchar2,
70 p_persons_processed_succ out nocopy varchar2,
71 p_persons_errored out nocopy varchar2);
72 -----------------------------------------------------------------------
73 procedure activity_summary_by_action
74 (p_concurrent_request_id in number,
75 p_without_active_life_event out nocopy varchar2,
76 p_with_active_life_event out nocopy varchar2,
77 p_no_life_event_created out nocopy varchar2,
78 p_life_event_open_and_closed out nocopy varchar2,
79 p_life_event_created out nocopy varchar2,
80 p_life_event_still_active out nocopy varchar2,
81 p_life_event_closed out nocopy varchar2,
82 p_life_event_replaced out nocopy varchar2,
83 p_life_event_dsgn_only out nocopy varchar2,
84 p_life_event_choices out nocopy varchar2,
85 p_life_event_no_effect out nocopy varchar2,
86 p_life_event_rt_pr_chg out nocopy varchar2);
87 -----------------------------------------------------------------------------------------------
88 -- Procedure activity_summary_by_action is overloaded as two more parameters for life
89 -- event collapsed, life event collision added
90 procedure activity_summary_by_action
91 (p_concurrent_request_id in number,
92 p_without_active_life_event out nocopy varchar2,
93 p_with_active_life_event out nocopy varchar2,
94 p_no_life_event_created out nocopy varchar2,
95 p_life_event_open_and_closed out nocopy varchar2,
96 p_life_event_created out nocopy varchar2,
97 p_life_event_still_active out nocopy varchar2,
98 p_life_event_closed out nocopy varchar2,
99 p_life_event_replaced out nocopy varchar2,
100 p_life_event_dsgn_only out nocopy varchar2,
101 p_life_event_choices out nocopy varchar2,
102 p_life_event_no_effect out nocopy varchar2,
103 p_life_event_rt_pr_chg out nocopy varchar2,
104 p_life_event_collapsed out nocopy varchar2,
105 p_life_event_collision out nocopy varchar2);
106
107 ------------------------------------------------------------------------------------------------
108 procedure temporal_life_events
109 (p_concurrent_request_id in number,
110 p_age_changed out nocopy varchar2,
111 p_los_changed out nocopy varchar2,
112 p_comb_age_los_changed out nocopy varchar2,
113 p_pft_changed out nocopy varchar2,
114 p_comp_lvl_changed out nocopy varchar2,
115 p_hrs_wkd_changed out nocopy varchar2,
116 p_loss_of_eligibility out nocopy varchar2,
117 p_late_payment out nocopy varchar2,
118 p_max_enrollment_rchd out nocopy varchar2,
119 p_period_enroll_changed out nocopy varchar2,
120 p_voulntary_end_cvg out nocopy varchar2,
121 p_waiting_satisfied out nocopy varchar2,
122 p_persons_no_potential out nocopy varchar2,
123 p_persons_with_potential out nocopy varchar2,
124 p_number_of_events_created out nocopy varchar2);
125 -----------------------------------------------------------------------
126 procedure batch_reports
127 (p_concurrent_request_id in number,
128 p_mode in varchar2 default 'S',
129 p_report_type in varchar2);
130 -----------------------------------------------------------------------
131 procedure submit_request
132 (errbuf out nocopy varchar2,
133 retcode out nocopy number,
134 p_program_name in varchar2,
135 p_concurrent_request_id in number);
136 -----------------------------------------------------------------------
137 type letotal_rec is record (
138 ler_name ben_ler_f.name%type,
139 new_closed_cd varchar2(1), -- 'N' or 'C'
140 total number
141 );
142 type le_total is table of letotal_rec index by binary_integer;
143 -----------------------------------------------------------------------
144 procedure event_summary(
145 p_concurrent_request_id in number,
146 p_life_event_totals out nocopy ben_batch_reporting.le_total
147 );
148 -----------------------------------------------------------------------
149 end ben_batch_reporting;