[Home] [Help]
PACKAGE BODY: APPS.BEN_BENCMAUD_XMLP_PKG
Source
1 PACKAGE BODY BEN_BENCMAUD_XMLP_PKG AS
2 /* $Header: BENCMAUDB.pls 120.1 2007/12/10 08:27:09 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_STATUS := l_status;
68 CP_BUSINESS_GROUP := l_business_group;
69
70
71 return 1;
72 end;
73
74 function CF_PROCESS_INFORMATIONFormula return Number is
75 l_start_date varchar2(30);
76 l_end_date varchar2(30);
77 l_start_time varchar2(30);
78 l_end_time varchar2(30);
79 l_elapsed_time varchar2(30);
80 l_persons_selected varchar2(30);
81 l_persons_processed varchar2(30);
82 l_persons_errored varchar2(30);
83 l_persons_processed_succ varchar2(30);
84 l_persons_unprocessed varchar2(30);
85 l_rcv_cm_cnt number;
86 l_rcv_1_cm_cnt number;
87 l_rcv_mlt_cm_cnt number;
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 ben_determine_communications.summary_by_action
112 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID
113 ,p_rcv_comm_count => l_rcv_cm_cnt
114 ,p_rcv_1_comm_count => l_rcv_1_cm_cnt
115 ,p_rcv_mlt_comm_count => l_rcv_mlt_cm_cnt
116 );
117 CP_RCV_CM_CNT := l_rcv_cm_cnt;
118 CP_RCV_1_CM_CNT := l_rcv_1_cm_cnt;
119 CP_RCV_MLT_CM_CNT := l_rcv_mlt_cm_cnt;
120 CP_RCV_NO_CM_CNT := l_persons_processed_succ - l_rcv_cm_cnt;
121 return 1;
122 end;
123
124 function BeforeReport return boolean is
125 begin
126 -- hr_standard.event('BEFORE REPORT');
127 return (TRUE);
128 end;
129
130 function AfterReport return boolean is
131 begin
132 -- hr_standard.event('AFTER REPORT');
133 return (TRUE);
134 end;
135
136 function AfterPForm return boolean is
137 begin
138 P_CONC_REQUEST_ID := P_CONCURRENT_REQUEST_ID;
139 return (TRUE);
140 end;
141
142 --Functions to refer Oracle report placeholders--
143
144 Function CP_PROCESS_DATE_p return date is
145 Begin
146 return CP_PROCESS_DATE;
147 END;
148 Function CP_BUSINESS_GROUP_p return varchar2 is
149 Begin
150 return CP_BUSINESS_GROUP;
151 END;
152 Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2 is
153 Begin
154 return CP_CONCURRENT_PROGRAM_NAME;
155 END;
156 Function CP_START_DATE_p return varchar2 is
157 Begin
158 return CP_START_DATE;
159 END;
160 Function CP_END_DATE_p return varchar2 is
161 Begin
162 return CP_END_DATE;
163 END;
164 Function CP_ELAPSED_TIME_p return varchar2 is
165 Begin
166 return CP_ELAPSED_TIME;
167 END;
168 Function CP_PERSONS_SELECTED_p return number is
169 Begin
170 return CP_PERSONS_SELECTED;
171 END;
172 Function CP_PERSONS_PROCESSED_p return number is
173 Begin
174 return CP_PERSONS_PROCESSED;
175 END;
176 Function CP_START_TIME_p return varchar2 is
177 Begin
178 return CP_START_TIME;
179 END;
180 Function CP_END_TIME_p return varchar2 is
181 Begin
182 return CP_END_TIME;
183 END;
184 Function CP_PERSONS_UNPROCESSED_p return number is
185 Begin
186 return CP_PERSONS_UNPROCESSED;
187 END;
188 Function CP_PERSONS_PROCESSED_SUCC_p return number is
189 Begin
190 return CP_PERSONS_PROCESSED_SUCC;
191 END;
192 Function CP_PERSONS_ERRORED_p return number is
193 Begin
194 return CP_PERSONS_ERRORED;
195 END;
196 Function CP_STATUS_p return varchar2 is
197 Begin
198 return CP_STATUS;
199 END;
200 Function CP_RCV_CM_CNT_p return number is
201 Begin
202 return CP_RCV_CM_CNT;
203 END;
204 Function CP_RCV_1_CM_CNT_p return number is
205 Begin
206 return CP_RCV_1_CM_CNT;
207 END;
208 Function CP_RCV_MLT_CM_CNT_p return number is
209 Begin
210 return CP_RCV_MLT_CM_CNT;
211 END;
212 Function CP_RCV_NO_CM_CNT_p return number is
213 Begin
214 return CP_RCV_NO_CM_CNT;
215 END;
216 END BEN_BENCMAUD_XMLP_PKG ;