[Home] [Help]
PACKAGE BODY: APPS.BEN_BENFRAUD_XMLP_PKG
Source
1 PACKAGE BODY BEN_BENFRAUD_XMLP_PKG AS
2 /* $Header: BENFRAUDB.pls 120.1 2007/12/10 08:33:46 vjaganat noship $ */
3
4 function CF_STANDARD_HEADERFormula return Number is
5 l_concurrent_program_name varchar2(80);
6 l_process_date varchar2(30);
7 l_mode varchar2(80);
8 l_derivable_factors varchar2(80);
9 l_validate varchar2(80);
10 l_person varchar2(80);
11 l_person_type varchar2(80);
12 l_program varchar2(80);
13 l_business_group varchar2(80);
14 l_plan varchar2(80);
15 l_enrollment_type_cycle varchar2(80);
16 l_plans_not_in_programs varchar2(80);
17 l_just_programs varchar2(80);
18 l_comp_object_selection_rule varchar2(80);
19 l_person_selection_rule varchar2(80);
20 l_life_event_reason varchar2(80);
21 l_organization varchar2(80);
22 l_postal_zip_range varchar2(80);
23 l_reporting_group varchar2(80);
24 l_plan_type varchar2(80);
25 l_option varchar2(80);
26 l_eligibility_profile varchar2(80);
27 l_variable_rate_profile varchar2(80);
28 l_legal_entity varchar2(80);
29 l_payroll varchar2(80);
30 l_status varchar2(80);
31 l_all varchar2(80); begin
32
33 ben_batch_reporting.standard_header
34 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
35 p_concurrent_program_name => L_CONCURRENT_PROGRAM_NAME,
36 p_process_date => L_PROCESS_DATE,
37 p_mode => L_MODE,
38 p_derivable_factors => L_DERIVABLE_FACTORS,
39 p_validate => L_VALIDATE,
40 p_person => L_PERSON,
41 p_person_type => L_PERSON_TYPE,
42 p_program => L_PROGRAM,
43 p_business_group => L_BUSINESS_GROUP,
44 p_plan => L_PLAN,
45 p_popl_enrt_typ_cycl => L_ENROLLMENT_TYPE_CYCLE,
46 p_plans_not_in_programs => L_PLANS_NOT_IN_PROGRAMS,
47 p_just_programs => L_JUST_PROGRAMS,
48 p_comp_object_selection_rule => L_COMP_OBJECT_SELECTION_RULE,
49 p_person_selection_rule => L_PERSON_SELECTION_RULE,
50 p_life_event_reason => L_LIFE_EVENT_REASON,
51 p_organization => L_ORGANIZATION,
52 p_postal_zip_range => L_POSTAL_ZIP_RANGE,
53 p_reporting_group => L_REPORTING_GROUP,
54 p_plan_type => L_PLAN_TYPE,
55 p_option => L_OPTION,
56 p_eligibility_profile => L_ELIGIBILITY_PROFILE,
57 p_variable_rate_profile => L_VARIABLE_RATE_PROFILE,
58 p_legal_entity => L_LEGAL_ENTITY,
59 p_payroll => L_PAYROLL,
60 p_status => L_STATUS);
61 CP_CONCURRENT_PROGRAM_NAME := l_concurrent_program_name;
62 CP_PROCESS_DATE := l_process_date;
63 CP_MODE := l_mode;
64 CP_DERIVABLE_FACTORS := l_derivable_factors;
65 CP_VALIDATE := l_validate;
66 CP_PERSON := l_person;
67 CP_PERSON_TYPE := l_person_type;
68 CP_PROGRAM := l_program;
69 CP_BUSINESS_GROUP := l_business_group;
70 CP_PLAN := l_plan;
71 CP_ENROLLMENT_TYPE_CYCLE := l_enrollment_type_cycle;
72 CP_PLANS_NOT_IN_PROGRAMS := l_plans_not_in_programs;
73 CP_JUST_PROGRAMS := l_just_programs;
74 CP_COMP_OBJECT_SELECTION_RULE := l_comp_object_selection_rule;
75 CP_PERSON_SELECTION_RULE := l_person_selection_rule;
76 CP_LIFE_EVENT_REASON := l_life_event_reason;
77 CP_ORGANIZATION := l_organization;
78 CP_POSTAL_ZIP_RANGE := l_postal_zip_range;
79 CP_REPORTING_GROUP := l_reporting_group;
80 CP_PLAN_TYPE := l_plan_type;
81 CP_OPTION := l_option;
82 CP_ELIGIBILITY_PROFILE := l_eligibility_profile;
83 CP_VARIABLE_RATE_PROFILE := l_variable_rate_profile;
84 CP_LEGAL_ENTITY := l_legal_entity;
85 CP_PAYROLL := l_payroll;
86 CP_STATUS := l_status;
87 fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
88 l_all := substrb(fnd_message.get,1,80);
89 begin
90 select bft.process_date,
91 hr2.meaning,
92 nvl(pln.name,l_all),
93 conc.user_concurrent_program_name,
94 fnd1.meaning
95 into CP_PROCESS_DATE, CP_VALIDATE, CP_PLAN, CP_CONCURRENT_PROGRAM_NAME, CP_STATUS
96 from ben_benefit_actions bft,
97 hr_lookups hr2,
98 ben_pl_f pln,
99 fnd_lookups fnd1,
100 fnd_concurrent_requests fnd,
101 fnd_concurrent_programs_tl conc
102 where fnd.request_id = P_CONCURRENT_REQUEST_ID
103 and conc.concurrent_program_id = fnd.concurrent_program_id
104 and conc.application_id = 805
105 and bft.request_id = fnd.request_id
106 and hr2.lookup_code = bft.validate_flag
107 and hr2.lookup_type = 'YES_NO'
108 and fnd.status_code = fnd1.lookup_code
109 and fnd1.lookup_type = 'CP_STATUS_CODE'
110 and pln.pl_id(+) = bft.pl_id
111 and bft.process_date
112 between nvl(pln.effective_start_date,bft.process_date)
113 and nvl(pln.effective_end_date,bft.process_date);
114 exception
115 when others then
116 null;
117 end;
118 return 1;
119 end;
120
121 function CF_SUMMARY_EVENTFormula return Number is
122
123 begin
124
125 return 1;
126 end;
127
128 function CF_1Formula return Number is
129 l_start_date varchar2(30);
130 l_end_date varchar2(30);
131 l_start_time varchar2(30);
132 l_end_time varchar2(30);
133 l_elapsed_time varchar2(30);
134 l_persons_selected varchar2(30);
135 l_persons_processed varchar2(30);
136 l_persons_errored varchar2(30);
137 l_persons_processed_succ varchar2(30);
138 l_persons_unprocessed varchar2(30);
139 begin
140 ben_batch_reporting.process_information
141 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
142 p_start_date => L_START_DATE,
143 p_end_date => L_END_DATE,
144 p_start_time => L_START_TIME,
145 p_end_time => L_END_TIME,
146 p_elapsed_time => L_ELAPSED_TIME,
147 p_persons_selected => L_PERSONS_SELECTED,
148 p_persons_processed => L_PERSONS_PROCESSED,
149 p_persons_unprocessed => L_PERSONS_UNPROCESSED,
150 p_persons_processed_succ => L_PERSONS_PROCESSED_SUCC,
151 p_persons_errored => L_PERSONS_ERRORED);
152 CP_START_DATE := l_start_date;
153 CP_END_DATE := l_end_date;
154 CP_START_TIME := l_start_time;
155 CP_END_TIME := l_end_time;
156 CP_ELAPSED_TIME := l_elapsed_time;
157 CP_PERSONS_SELECTED := l_persons_selected;
158 CP_PERSONS_PROCESSED := l_persons_processed;
159 CP_PERSONS_ERRORED := l_persons_errored;
160 CP_PERSONS_UNPROCESSED := l_persons_unprocessed;
161 CP_PERSONS_PROCESSED_SUCC := l_persons_processed_succ;
162 return 1;
163 end;
164
165 function CP_DEFTOTALFormula return Number is
166 begin
167 return 1;
168 end;
169
170 function BeforeReport return boolean is
171 begin
172 -- hr_standard.event('BEFORE REPORT');
173 return (TRUE);
174 end;
175
176 function AfterReport return boolean is
177 begin
178 -- hr_standard.event('AFTER REPORT');
179 return (TRUE);
180 end;
181
182 function AfterPForm return boolean is
183 begin
184 P_CONC_REQUEST_ID := P_CONCURRENT_REQUEST_ID;
185 return (TRUE);
186 end;
187
188 --Functions to refer Oracle report placeholders--
189
190 Function CP_PROCESS_DATE_p return varchar2 is
191 Begin
192 return CP_PROCESS_DATE;
193 END;
194 Function CP_DERIVABLE_FACTORS_p return varchar2 is
195 Begin
196 return CP_DERIVABLE_FACTORS;
197 END;
198 Function CP_VALIDATE_p return varchar2 is
199 Begin
200 return CP_VALIDATE;
201 END;
202 Function CP_PERSON_p return varchar2 is
203 Begin
204 return CP_PERSON;
205 END;
206 Function CP_PERSON_TYPE_p return varchar2 is
207 Begin
208 return CP_PERSON_TYPE;
209 END;
210 Function CP_PROGRAM_p return varchar2 is
211 Begin
212 return CP_PROGRAM;
213 END;
214 Function CP_BUSINESS_GROUP_p return varchar2 is
215 Begin
216 return CP_BUSINESS_GROUP;
217 END;
218 Function CP_PLAN_p return varchar2 is
219 Begin
220 return CP_PLAN;
221 END;
222 Function CP_ENROLLMENT_TYPE_CYCLE_p return varchar2 is
223 Begin
224 return CP_ENROLLMENT_TYPE_CYCLE;
225 END;
226 Function CP_PLANS_NOT_IN_PROGRAMS_p return varchar2 is
227 Begin
228 return CP_PLANS_NOT_IN_PROGRAMS;
229 END;
230 Function CP_JUST_PROGRAMS_p return varchar2 is
231 Begin
232 return CP_JUST_PROGRAMS;
233 END;
234 Function CP_COMP_OBJECT_SELECTION_RULE1 return varchar2 is
235 Begin
236 return CP_COMP_OBJECT_SELECTION_RULE;
237 END;
238 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
239 Begin
240 return CP_PERSON_SELECTION_RULE;
241 END;
242 Function CP_LIFE_EVENT_REASON_p return varchar2 is
243 Begin
244 return CP_LIFE_EVENT_REASON;
245 END;
246 Function CP_ORGANIZATION_p return varchar2 is
247 Begin
248 return CP_ORGANIZATION;
249 END;
250 Function CP_POSTAL_ZIP_RANGE_p return varchar2 is
251 Begin
252 return CP_POSTAL_ZIP_RANGE;
253 END;
254 Function CP_REPORTING_GROUP_p return varchar2 is
255 Begin
256 return CP_REPORTING_GROUP;
257 END;
258 Function CP_PLAN_TYPE_p return varchar2 is
259 Begin
260 return CP_PLAN_TYPE;
261 END;
262 Function CP_OPTION_p return varchar2 is
263 Begin
264 return CP_OPTION;
265 END;
266 Function CP_ELIGIBILITY_PROFILE_p return varchar2 is
267 Begin
268 return CP_ELIGIBILITY_PROFILE;
269 END;
270 Function CP_VARIABLE_RATE_PROFILE_p return varchar2 is
271 Begin
272 return CP_VARIABLE_RATE_PROFILE;
273 END;
274 Function CP_LEGAL_ENTITY_p return varchar2 is
275 Begin
276 return CP_LEGAL_ENTITY;
277 END;
278 Function CP_PAYROLL_p return varchar2 is
279 Begin
280 return CP_PAYROLL;
281 END;
282 Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2 is
283 Begin
284 return CP_CONCURRENT_PROGRAM_NAME;
285 END;
286 Function CP_START_DATE_p return varchar2 is
287 Begin
288 return CP_START_DATE;
289 END;
290 Function CP_END_DATE_p return varchar2 is
291 Begin
292 return CP_END_DATE;
293 END;
294 Function CP_ELAPSED_TIME_p return varchar2 is
295 Begin
296 return CP_ELAPSED_TIME;
297 END;
298 Function CP_PERSONS_SELECTED_p return number is
299 Begin
300 return CP_PERSONS_SELECTED;
301 END;
302 Function CP_PERSONS_PROCESSED_p return number is
303 Begin
304 return CP_PERSONS_PROCESSED;
305 END;
306 Function CP_MODE_p return varchar2 is
307 Begin
308 return CP_MODE;
309 END;
310 Function CP_PRCURMOP_p return number is
311 Begin
312 return CP_PRCURMOP;
313 END;
314 Function CP_PRRETROP_p return number is
315 Begin
316 return CP_PRRETROP;
317 END;
318 Function CP_END_TIME_p return varchar2 is
319 Begin
320 return CP_END_TIME;
321 END;
322 Function CP_START_TIME_p return varchar2 is
323 Begin
324 return CP_START_TIME;
325 END;
326 Function CP_STATUS_p return varchar2 is
327 Begin
328 return CP_STATUS;
329 END;
330 Function CP_PERSONS_ERRORED_p return number is
331 Begin
332 return CP_PERSONS_ERRORED;
333 END;
334 Function CP_PERSONS_PROCESSED_SUCC_p return number is
335 Begin
336 return CP_PERSONS_PROCESSED_SUCC;
337 END;
338 Function CP_PERSONS_UNPROCESSED_p return number is
339 Begin
340 return CP_PERSONS_UNPROCESSED;
341 END;
342 Function CP_PRTOTAL_p return number is
343 Begin
344 return CP_PRTOTAL;
345 END;
346 Function cp_PRCREDIT_p return number is
347 Begin
348 return cp_PRCREDIT;
349 END;
350 Function CP_PROTHER_p return number is
351 Begin
352 return CP_PROTHER;
353 END;
354 END BEN_BENFRAUD_XMLP_PKG ;