[Home] [Help]
PACKAGE BODY: APPS.BEN_BENCMSUM_XMLP_PKG
Source
1 PACKAGE BODY BEN_BENCMSUM_XMLP_PKG AS
2 /* $Header: BENCMSUMB.pls 120.2 2007/12/21 06:09:22 amakrish noship $ */
3
4 function CF_STANDARD_HEADERFormula return Number is
5 l_concurrent_program_name fnd_concurrent_programs_tl.user_concurrent_program_name%type ; l_process_date varchar2(30);
6 l_mode hr_lookups.meaning%type ;
7 l_validate hr_lookups.meaning%type ;
8 l_person per_people_f.full_name%type ;
9 l_person_type per_person_types.user_person_type%type ;
10 l_program ben_pgm_f.name%type ;
11 l_business_group per_business_groups.name%type ;
12 l_plan ben_pl_f.name%type ;
13 l_person_selection_rule ff_formulas_f.formula_name%type ;
14 l_life_event_reason ben_ler_f.name%type ;
15 l_organization hr_all_organization_units.name%type ;
16 l_status fnd_lookups.meaning%type ;
17 l_cm_trgr_typ hr_lookups.meaning%type ;
18 l_cm_typ hr_lookups.meaning%type ;
19 l_plan_in_program hr_lookups.meaning%type ;
20 l_location hr_locations_all.description%type ;
21 l_actn_typ ben_actn_typ.name%type ;
22 l_elig_enrol hr_lookups.meaning%type ;
23 l_age_fctr ben_age_fctr.name%type ;
24 l_min_age ben_benefit_actions.min_age%type ;
25 l_max_age ben_benefit_actions.max_age%type ;
26 l_los_fctr ben_los_fctr.name%type ;
27 l_min_los ben_benefit_actions.min_los%type ;
28 l_max_los ben_benefit_actions.max_los%type ;
29 l_cmbn_age_los_fctr ben_cmbn_age_los_fctr.name%type ;
30 l_date_from ben_benefit_actions.date_from%type ;
31 l_enrollment_period varchar2(800); l_audit_log hr_lookups.meaning%type ;
32
33 begin
34
35 ben_determine_communications.standard_header(
36 p_concurrent_request_id => p_concurrent_request_id,
37 p_concurrent_program_name => l_concurrent_program_name,
38 p_process_date => l_process_date,
39 p_validate => l_validate,
40 p_business_group => l_business_group,
41 p_mode => l_mode,
42 p_cm_trgr_typ => l_cm_trgr_typ,
43 p_cm_typ => l_cm_typ,
44 p_person => l_person,
45 p_person_type => l_person_type,
46 p_person_selection_rule => l_person_selection_rule,
47 p_organization => l_organization,
48 p_location => l_location,
49 p_ler => l_life_event_reason,
50 p_program => l_program,
51 p_plan => l_plan,
52 p_plan_in_program => l_plan_in_program,
53 p_actn_typ => l_actn_typ,
54 p_elig_enrol => l_elig_enrol,
55 p_age_fctr => l_age_fctr,
56 p_min_age => l_min_age,
57 p_max_age => l_max_age,
58 p_los_fctr => l_los_fctr,
59 p_min_los => l_min_los,
60 p_max_los => l_max_los,
61 p_cmbn_age_los_fctr => l_cmbn_age_los_fctr,
62 p_date_from => l_date_from,
63 p_enrollment_period => l_enrollment_period,
64 p_audit_log => l_audit_log,
65 p_status => l_status );
66 CP_CONCURRENT_PROGRAM_NAME := l_concurrent_program_name;
67 CP_PROCESS_DATE := l_process_date;
68 CP_MODE := l_mode;
69 CP_VALIDATE := l_validate;
70 CP_CM_TRGR_TYP := l_cm_trgr_typ;
71 CP_CM_TYP := l_cm_typ;
72 CP_PERSON := l_person;
73 CP_PERSON_TYPE := l_person_type;
74 CP_PROGRAM := l_program;
75 CP_BUSINESS_GROUP := l_business_group;
76 CP_PLAN := l_plan;
77 CP_ENROLLMENT_PERIOD := l_enrollment_period;
78 CP_PLAN_IN_PROGRAM := l_plan_in_program;
79 CP_PERSON_SELECTION_RULE := l_person_selection_rule;
80 CP_LIFE_EVENT_REASON := l_life_event_reason;
81 CP_ORGANIZATION := l_organization;
82 CP_LOCATION := l_location;
83 CP_ACTN_TYP := l_actn_typ;
84 CP_ELIG_ENROL := l_elig_enrol;
85 CP_AGE_FCTR := l_age_fctr;
86 CP_MIN_AGE := l_min_age;
87 CP_MAX_AGE := l_max_age;
91 CP_CMBN_AGE_LOS_FCTR := l_cmbn_age_los_fctr;
88 CP_LOS_FCTR := l_los_fctr;
89 CP_MIN_LOS := l_min_los;
90 CP_MAX_LOS := l_max_los;
92 CP_DATE_FROM := l_date_from;
93 CP_AUDIT_LOG := l_audit_log;
94 return 1;
95 end;
96
97 function CF_SUMMARY_EVENTFormula return Number is
98 l_rcv_cm_cnt number;
99 l_rcv_1_cm_cnt number;
100 l_rcv_mlt_cm_cnt number;
101 begin
102 ben_determine_communications.summary_by_action
103 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID
104 ,p_rcv_comm_count => l_rcv_cm_cnt
105 ,p_rcv_1_comm_count => l_rcv_1_cm_cnt
106 ,p_rcv_mlt_comm_count => l_rcv_mlt_cm_cnt
107 );
108 CP_RCV_CM_CNT := l_rcv_cm_cnt;
109 CP_RCV_1_CM_CNT := l_rcv_1_cm_cnt;
110 CP_RCV_MLT_CM_CNT := l_rcv_mlt_cm_cnt;
111 CP_RCV_NO_CM_CNT := CP_PERSONS_PROCESSED_SUCC - l_rcv_cm_cnt;
112 return 1;
113 end;
114
115 function CF_1Formula return Number is
116 l_start_date varchar2(30);
117 l_end_date varchar2(30);
118 l_start_time varchar2(30);
119 l_end_time varchar2(30);
120 l_elapsed_time varchar2(30);
121 l_persons_selected varchar2(30);
122 l_persons_processed varchar2(30);
123 l_persons_errored varchar2(30);
124 l_persons_processed_succ varchar2(30);
125 l_persons_unprocessed varchar2(30);
126 begin
127 ben_batch_reporting.process_information
128 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
129 p_start_date => L_START_DATE,
130 p_end_date => L_END_DATE,
131 p_start_time => L_START_TIME,
132 p_end_time => L_END_TIME,
133 p_elapsed_time => L_ELAPSED_TIME,
134 p_persons_selected => L_PERSONS_SELECTED,
135 p_persons_processed => L_PERSONS_PROCESSED,
136 p_persons_unprocessed => L_PERSONS_UNPROCESSED,
137 p_persons_processed_succ => L_PERSONS_PROCESSED_SUCC,
138 p_persons_errored => L_PERSONS_ERRORED);
139 CP_START_DATE := l_start_date;
140 CP_END_DATE := l_end_date;
141 CP_START_TIME := l_start_time;
142 CP_END_TIME := l_end_time;
143 CP_ELAPSED_TIME := l_elapsed_time;
144 CP_PERSONS_SELECTED := l_persons_selected;
145 CP_PERSONS_PROCESSED := l_persons_processed;
146 CP_PERSONS_ERRORED := l_persons_errored;
147 CP_PERSONS_UNPROCESSED := l_persons_unprocessed;
148 CP_PERSONS_PROCESSED_SUCC := l_persons_processed_succ;
149 return 1;
150 end;
151
152 function BeforeReport return boolean is
153 begin
154 --hr_standard.event('BEFORE REPORT');
155 return (TRUE);
156 end;
157
158 function AfterReport return boolean is
159 begin
160 --hr_standard.event('AFTER REPORT');
161 return (TRUE);
162 end;
163
164 function AfterPForm return boolean is
165 begin
166 P_CONC_REQUEST_ID := P_CONCURRENT_REQUEST_ID;
167 return (TRUE);
168 end;
169
170 --Functions to refer Oracle report placeholders--
171
172 Function CP_PROCESS_DATE_p return varchar2 is
173 Begin
174 return CP_PROCESS_DATE;
175 END;
176 Function CP_VALIDATE_p return varchar2 is
177 Begin
178 return CP_VALIDATE;
179 END;
180 Function CP_PERSON_p return varchar2 is
181 Begin
182 return CP_PERSON;
183 END;
184 Function CP_PERSON_TYPE_p return varchar2 is
185 Begin
186 return CP_PERSON_TYPE;
187 END;
188 Function CP_PROGRAM_p return varchar2 is
189 Begin
190 return CP_PROGRAM;
191 END;
192 Function CP_BUSINESS_GROUP_p return varchar2 is
193 Begin
194 return CP_BUSINESS_GROUP;
195 END;
196 Function CP_PLAN_p return varchar2 is
197 Begin
198 return CP_PLAN;
199 END;
200 Function CP_ENROLLMENT_PERIOD_p return varchar2 is
201 Begin
202 return CP_ENROLLMENT_PERIOD;
203 END;
204 Function CP_PLAN_IN_PROGRAM_p return varchar2 is
205 Begin
206 return CP_PLAN_IN_PROGRAM;
207 END;
208 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
209 Begin
210 return CP_PERSON_SELECTION_RULE;
211 END;
212 Function CP_LIFE_EVENT_REASON_p return varchar2 is
213 Begin
214 return CP_LIFE_EVENT_REASON;
215 END;
216 Function CP_ORGANIZATION_p return varchar2 is
217 Begin
218 return CP_ORGANIZATION;
219 END;
220 Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2 is
221 Begin
222 return CP_CONCURRENT_PROGRAM_NAME;
223 END;
224 Function CP_START_DATE_p return varchar2 is
225 Begin
226 return CP_START_DATE;
227 END;
228 Function CP_END_DATE_p return varchar2 is
229 Begin
230 return CP_END_DATE;
231 END;
232 Function CP_ELAPSED_TIME_p return varchar2 is
233 Begin
234 return CP_ELAPSED_TIME;
235 END;
236 Function CP_PERSONS_SELECTED_p return number is
237 Begin
238 return CP_PERSONS_SELECTED;
239 END;
240 Function CP_PERSONS_PROCESSED_p return number is
241 Begin
242 return CP_PERSONS_PROCESSED;
243 END;
244 Function CP_MODE_p return varchar2 is
245 Begin
246 return CP_MODE;
247 END;
248 Function CP_RCV_1_CM_CNT_p return number is
249 Begin
250 return CP_RCV_1_CM_CNT;
251 END;
252 Function CP_RCV_MLT_CM_CNT_p return number is
253 Begin
254 return CP_RCV_MLT_CM_CNT;
255 END;
256 Function CP_END_TIME_p return varchar2 is
257 Begin
258 return CP_END_TIME;
259 END;
260 Function CP_START_TIME_p return varchar2 is
261 Begin
262 return CP_START_TIME;
263 END;
264 Function CP_PERSONS_ERRORED_p return number is
265 Begin
266 return CP_PERSONS_ERRORED;
267 END;
268 Function CP_PERSONS_PROCESSED_SUCC_p return number is
269 Begin
270 return CP_PERSONS_PROCESSED_SUCC;
271 END;
272 Function CP_PERSONS_UNPROCESSED_p return number is
273 Begin
274 return CP_PERSONS_UNPROCESSED;
275 END;
276 Function CP_RCV_NO_CM_CNT_p return number is
277 Begin
278 return CP_RCV_NO_CM_CNT;
279 END;
280 Function CP_RCV_CM_CNT_p return number is
281 Begin
282 return CP_RCV_CM_CNT;
283 END;
284 Function CP_CM_TYP_p return varchar2 is
285 Begin
286 return CP_CM_TYP;
287 END;
288 Function CP_LOCATION_p return varchar2 is
289 Begin
290 return CP_LOCATION;
291 END;
292 Function CP_ACTN_TYP_p return varchar2 is
293 Begin
294 return CP_ACTN_TYP;
295 END;
296 Function CP_ELIG_ENROL_p return varchar2 is
297 Begin
298 return CP_ELIG_ENROL;
299 END;
300 Function CP_AGE_FCTR_p return varchar2 is
301 Begin
302 return CP_AGE_FCTR;
303 END;
304 Function CP_MIN_AGE_p return varchar2 is
305 Begin
306 return CP_MIN_AGE;
307 END;
308 Function CP_MAX_AGE_p return varchar2 is
309 Begin
310 return CP_MAX_AGE;
311 END;
312 Function CP_LOS_FCTR_p return varchar2 is
313 Begin
314 return CP_LOS_FCTR;
315 END;
316 Function CP_MIN_LOS_p return varchar2 is
317 Begin
318 return CP_MIN_LOS;
319 END;
320 Function CP_CMBN_AGE_LOS_FCTR_p return varchar2 is
321 Begin
322 return CP_CMBN_AGE_LOS_FCTR;
323 END;
324 Function CP_DATE_FROM_p return varchar2 is
325 Begin
326 return CP_DATE_FROM;
327 END;
328 Function CP_AUDIT_LOG_p return varchar2 is
329 Begin
330 return CP_AUDIT_LOG;
331 END;
332 Function CP_MAX_LOS_p return varchar2 is
333 Begin
334 return CP_MAX_LOS;
335 END;
336 Function CP_CM_TRGR_TYP_p return varchar2 is
337 Begin
338 return CP_CM_TRGR_TYP;
339 END;
340 END BEN_BENCMSUM_XMLP_PKG ;