[Home] [Help]
PACKAGE BODY: APPS.BEN_BENPRDEA_XMLP_PKG
Source
1 PACKAGE BODY BEN_BENPRDEA_XMLP_PKG AS
2 /* $Header: BENPRDEAB.pls 120.1 2007/12/10 08:37:06 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_derivable_factors hr_lookups.meaning%type ;
8 l_validate hr_lookups.meaning%type ;
9 l_person per_people_f.full_name%type ;
10 l_person_type per_person_types.user_person_type%type ;
11 l_program ben_pgm_f.name%type ;
12 l_business_group per_business_groups.name%type ;
13 l_plan ben_pl_f.name%type ;
14 l_enrollment_type_cycle varchar2(800);
15 l_plans_not_in_programs hr_lookups.meaning%type ;
16 l_just_programs hr_lookups.meaning%type ;
17 l_comp_object_selection_rule ff_formulas_f.formula_name%type ;
18 l_person_selection_rule ff_formulas_f.formula_name%type ;
19 l_life_event_reason ben_ler_f.name%type ;
20 l_organization hr_all_organization_units.name%type ;
21 l_postal_zip_range varchar2(80);
22 l_reporting_group ben_rptg_grp.name%type ;
23 l_plan_type ben_pl_typ_f.name%type ;
24 l_option ben_opt_f.name%type ;
25 l_eligibility_profile ben_eligy_prfl_f.name%type ;
26 l_variable_rate_profile ben_vrbl_rt_prfl_f.name%type ;
27 l_legal_entity hr_all_organization_units.name%type ;
28 l_payroll pay_payrolls_f.payroll_name%type ;
29 l_status fnd_lookups.meaning%type ;
30 begin
31 ben_batch_reporting.standard_header
32 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
33 p_concurrent_program_name => L_CONCURRENT_PROGRAM_NAME,
34 p_process_date => L_PROCESS_DATE,
35 p_mode => L_MODE,
36 p_derivable_factors => L_DERIVABLE_FACTORS,
37 p_validate => L_VALIDATE,
38 p_person => L_PERSON,
39 p_person_type => L_PERSON_TYPE,
40 p_program => L_PROGRAM,
41 p_business_group => L_BUSINESS_GROUP,
42 p_plan => L_PLAN,
43 p_popl_enrt_typ_cycl => L_ENROLLMENT_TYPE_CYCLE,
44 p_plans_not_in_programs => L_PLANS_NOT_IN_PROGRAMS,
45 p_just_programs => L_JUST_PROGRAMS,
46 p_comp_object_selection_rule => L_COMP_OBJECT_SELECTION_RULE,
47 p_person_selection_rule => L_PERSON_SELECTION_RULE,
48 p_life_event_reason => L_LIFE_EVENT_REASON,
49 p_organization => L_ORGANIZATION,
50 p_postal_zip_range => L_POSTAL_ZIP_RANGE,
51 p_reporting_group => L_REPORTING_GROUP,
52 p_plan_type => L_PLAN_TYPE,
53 p_option => L_OPTION,
54 p_eligibility_profile => L_ELIGIBILITY_PROFILE,
55 p_variable_rate_profile => L_VARIABLE_RATE_PROFILE,
56 p_legal_entity => L_LEGAL_ENTITY,
57 p_payroll => L_PAYROLL,
58 p_status => L_STATUS);
59 CP_CONCURRENT_PROGRAM_NAME := l_concurrent_program_name;
60 CP_PROCESS_DATE := l_process_date;
61 CP_STATUS := l_status;
62 CP_BUSINESS_GROUP := l_business_group;
63 CP_VALIDATE := l_validate;
64 CP_MODE := l_mode;
65 CP_PERSON := l_person;
66 CP_PROGRAM := l_program;
67 CP_PLAN := l_plan;
68 CP_COMP_OBJECT_SELECTION_RULE := l_comp_object_selection_rule;
69 CP_PERSON_SELECTION_RULE := l_person_selection_rule;
70 CP_ORGANIZATION := l_organization;
71 CP_PLAN_TYPE := l_plan_type;
72 CP_LEGAL_ENTITY := l_legal_entity;
73 CP_STATUS := l_status;
74 return 1;
75 end;
76
77 function CF_PROCESS_INFORMATIONFormula return Number is
78 l_start_date varchar2(30);
79 l_end_date varchar2(30);
80 l_start_time varchar2(30);
81 l_end_time varchar2(30);
82 l_elapsed_time varchar2(30);
83 l_persons_selected varchar2(30);
84 l_persons_processed varchar2(30);
85 l_persons_errored varchar2(30);
86 l_persons_processed_succ varchar2(30);
87 l_persons_unprocessed varchar2(30);
88 begin
89 ben_batch_reporting.process_information
90 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
91 p_start_date => L_START_DATE,
92 p_end_date => L_END_DATE,
93 p_start_time => L_START_TIME,
94 p_end_time => L_END_TIME,
95 p_elapsed_time => L_ELAPSED_TIME,
96 p_persons_selected => L_PERSONS_SELECTED,
97 p_persons_processed => L_PERSONS_PROCESSED,
98 p_persons_unprocessed => L_PERSONS_UNPROCESSED,
99 p_persons_processed_succ => L_PERSONS_PROCESSED_SUCC,
100 p_persons_errored => L_PERSONS_ERRORED);
101 CP_START_DATE := l_start_date;
102 CP_END_DATE := l_end_date;
103 CP_START_TIME := l_start_time;
104 CP_END_TIME := l_end_time;
105 CP_ELAPSED_TIME := l_elapsed_time;
106 CP_PERSONS_SELECTED := l_persons_selected;
107 CP_PERSONS_PROCESSED := l_persons_processed;
108 CP_PERSONS_ERRORED := l_persons_errored;
109 CP_PERSONS_UNPROCESSED := l_persons_unprocessed;
110 CP_PERSONS_PROCESSED_SUCC := l_persons_processed_succ;
111 return 1;
112 end;
113
114 function BeforeReport return boolean is
115 begin
116 --hr_standard.event('BEFORE REPORT');
117
118 select benefit_action_id,process_date
119 into CP_BENEFIT_ACTION_ID,CP_REQ_PROCESS_DATE
120 from ben_benefit_actions
121 where request_id = P_CONCURRENT_REQUEST_ID;
122 return (TRUE);
123 exception
124 WHEN NO_DATA_FOUND
125 THEN RETURN(FALSE);
126 end;
127
128 function AfterReport return boolean is
129 begin
130 --hr_standard.event('AFTER REPORT');
131 return (TRUE);
132 end;
133
134 function AfterPForm return boolean is
135 begin
136 P_CONC_REQUEST_ID := P_CONCURRENT_REQUEST_ID;
137 return (TRUE);
138 end;
139
140 --Functions to refer Oracle report placeholders--
141
142 Function CP_PROCESS_DATE_p return date is
143 Begin
144 return CP_PROCESS_DATE;
145 END;
146 Function CP_BUSINESS_GROUP_p return varchar2 is
147 Begin
148 return CP_BUSINESS_GROUP;
149 END;
150 Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2 is
151 Begin
152 return CP_CONCURRENT_PROGRAM_NAME;
153 END;
154 Function CP_START_DATE_p return varchar2 is
155 Begin
156 return CP_START_DATE;
157 END;
158 Function CP_END_DATE_p return varchar2 is
159 Begin
160 return CP_END_DATE;
161 END;
162 Function CP_ELAPSED_TIME_p return varchar2 is
163 Begin
164 return CP_ELAPSED_TIME;
165 END;
166 Function CP_PERSONS_SELECTED_p return number is
167 Begin
168 return CP_PERSONS_SELECTED;
169 END;
170 Function CP_PERSONS_PROCESSED_p return number is
171 Begin
172 return CP_PERSONS_PROCESSED;
173 END;
174 Function CP_START_TIME_p return varchar2 is
175 Begin
176 return CP_START_TIME;
177 END;
178 Function CP_END_TIME_p return varchar2 is
179 Begin
180 return CP_END_TIME;
181 END;
182 Function CP_PERSONS_UNPROCESSED_p return number is
183 Begin
184 return CP_PERSONS_UNPROCESSED;
185 END;
186 Function CP_PERSONS_PROCESSED_SUCC_p return number is
187 Begin
188 return CP_PERSONS_PROCESSED_SUCC;
189 END;
190 Function CP_PERSONS_ERRORED_p return number is
191 Begin
192 return CP_PERSONS_ERRORED;
193 END;
194 Function CP_STATUS_p return varchar2 is
195 Begin
196 return CP_STATUS;
197 END;
198 Function CP_BENEFIT_ACTION_ID_p return number is
199 Begin
200 return CP_BENEFIT_ACTION_ID;
201 END;
202 Function CP_REQ_PROCESS_DATE_p return date is
203 Begin
204 return CP_REQ_PROCESS_DATE;
205 END;
206 Function CP_PROGRAM_p return varchar2 is
207 Begin
208 return CP_PROGRAM;
209 END;
210 Function CP_PLAN_p return varchar2 is
211 Begin
212 return CP_PLAN;
213 END;
214 Function CP_PLAN_TYPE_p return varchar2 is
215 Begin
216 return CP_PLAN_TYPE;
217 END;
218 Function CP_PERSON_p return varchar2 is
219 Begin
220 return CP_PERSON;
221 END;
222 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
223 Begin
224 return CP_PERSON_SELECTION_RULE;
225 END;
226 Function CP_COMP_OBJECT_SELE_RULE_FUN return varchar2 is
227 Begin
228 return CP_COMP_OBJECT_SELECTION_RULE;
229 END;
230 Function CP_ORGANIZATION_p return varchar2 is
231 Begin
232 return CP_ORGANIZATION;
233 END;
234 Function CP_LEGAL_ENTITY_p return varchar2 is
235 Begin
236 return CP_LEGAL_ENTITY;
237 END;
238 Function CP_VALIDATE_p return varchar2 is
239 Begin
240 return CP_VALIDATE;
241 END;
242 Function CP_MODE_p return varchar2 is
243 Begin
244 return CP_MODE;
245 END;
246 END BEN_BENPRDEA_XMLP_PKG ;