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