[Home] [Help]
PACKAGE BODY: APPS.BEN_ENROLLMENT_RATE_SWI
Source
1 Package Body ben_enrollment_rate_swi As
2 /* $Header: beecrswi.pkb 120.3 2006/01/06 05:18:18 narvenka noship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'ben_enrollment_rate_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_enrollment_rate >------------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_enrollment_rate
12 (p_validate in number default hr_api.g_false_num
13 ,p_enrt_rt_id out nocopy number
14 ,p_ordr_num in number default null
15 ,p_acty_typ_cd in varchar2 default null
16 ,p_tx_typ_cd in varchar2 default null
17 ,p_ctfn_rqd_flag in varchar2 default null
18 ,p_dflt_flag in varchar2 default null
19 ,p_dflt_pndg_ctfn_flag in varchar2 default null
20 ,p_dsply_on_enrt_flag in varchar2 default null
21 ,p_use_to_calc_net_flx_cr_flag in varchar2 default null
22 ,p_entr_val_at_enrt_flag in varchar2 default null
23 ,p_asn_on_enrt_flag in varchar2 default null
24 ,p_rl_crs_only_flag in varchar2 default null
25 ,p_dflt_val in number default null
26 ,p_ann_val in number default null
27 ,p_ann_mn_elcn_val in number default null
28 ,p_ann_mx_elcn_val in number default null
29 ,p_val in number default null
30 ,p_nnmntry_uom in varchar2 default null
31 ,p_mx_elcn_val in number default null
32 ,p_mn_elcn_val in number default null
33 ,p_incrmt_elcn_val in number default null
34 ,p_cmcd_acty_ref_perd_cd in varchar2 default null
35 ,p_cmcd_mn_elcn_val in number default null
36 ,p_cmcd_mx_elcn_val in number default null
37 ,p_cmcd_val in number default null
38 ,p_cmcd_dflt_val in number default null
39 ,p_rt_usg_cd in varchar2 default null
40 ,p_ann_dflt_val in number default null
41 ,p_bnft_rt_typ_cd in varchar2 default null
42 ,p_rt_mlt_cd in varchar2 default null
43 ,p_dsply_mn_elcn_val in number default null
44 ,p_dsply_mx_elcn_val in number default null
45 ,p_entr_ann_val_flag in varchar2 default null
46 ,p_rt_strt_dt in date default null
47 ,p_rt_strt_dt_cd in varchar2 default null
48 ,p_rt_strt_dt_rl in number default null
49 ,p_rt_typ_cd in varchar2 default null
50 ,p_elig_per_elctbl_chc_id in number default null
51 ,p_acty_base_rt_id in number default null
52 ,p_spcl_rt_enrt_rt_id in number default null
53 ,p_enrt_bnft_id in number default null
54 ,p_prtt_rt_val_id in number default null
55 ,p_decr_bnft_prvdr_pool_id in number default null
56 ,p_cvg_amt_calc_mthd_id in number default null
57 ,p_actl_prem_id in number default null
58 ,p_comp_lvl_fctr_id in number default null
59 ,p_ptd_comp_lvl_fctr_id in number default null
60 ,p_clm_comp_lvl_fctr_id in number default null
61 ,p_business_group_id in number
62 ,p_perf_min_max_edit in varchar2 default null
63 ,p_iss_val in number default null
64 ,p_val_last_upd_date in date default null
65 ,p_val_last_upd_person_id in number default null
66 ,p_pp_in_yr_used_num in number default null
67 ,p_ecr_attribute_category in varchar2 default null
68 ,p_ecr_attribute1 in varchar2 default null
69 ,p_ecr_attribute2 in varchar2 default null
70 ,p_ecr_attribute3 in varchar2 default null
71 ,p_ecr_attribute4 in varchar2 default null
72 ,p_ecr_attribute5 in varchar2 default null
73 ,p_ecr_attribute6 in varchar2 default null
74 ,p_ecr_attribute7 in varchar2 default null
75 ,p_ecr_attribute8 in varchar2 default null
76 ,p_ecr_attribute9 in varchar2 default null
77 ,p_ecr_attribute10 in varchar2 default null
78 ,p_ecr_attribute11 in varchar2 default null
79 ,p_ecr_attribute12 in varchar2 default null
80 ,p_ecr_attribute13 in varchar2 default null
81 ,p_ecr_attribute14 in varchar2 default null
82 ,p_ecr_attribute15 in varchar2 default null
83 ,p_ecr_attribute16 in varchar2 default null
84 ,p_ecr_attribute17 in varchar2 default null
85 ,p_ecr_attribute18 in varchar2 default null
86 ,p_ecr_attribute19 in varchar2 default null
87 ,p_ecr_attribute20 in varchar2 default null
88 ,p_ecr_attribute21 in varchar2 default null
89 ,p_ecr_attribute22 in varchar2 default null
90 ,p_ecr_attribute23 in varchar2 default null
91 ,p_ecr_attribute24 in varchar2 default null
92 ,p_ecr_attribute25 in varchar2 default null
93 ,p_ecr_attribute26 in varchar2 default null
94 ,p_ecr_attribute27 in varchar2 default null
95 ,p_ecr_attribute28 in varchar2 default null
96 ,p_ecr_attribute29 in varchar2 default null
97 ,p_ecr_attribute30 in varchar2 default null
98 ,p_request_id in number default null
99 ,p_program_application_id in number default null
100 ,p_program_id in number default null
101 ,p_program_update_date in date default null
102 ,p_object_version_number out nocopy number
103 ,p_effective_date in date
104 ,p_return_status out nocopy varchar2
105 ) is
106 --
107 -- Variables for API Boolean parameters
108 l_validate boolean;
109 --
110 -- Variables for IN/OUT parameters
111 --
112 -- Other variables
113 l_proc varchar2(72) := g_package ||'create_enrollment_rate';
114 Begin
115 hr_utility.set_location(' Entering:' || l_proc,10);
116 --
117 -- Issue a savepoint
118 --
119 savepoint create_enrollment_rate_swi;
120 --
121 -- Initialise Multiple Message Detection
122 --
123 hr_multi_message.enable_message_list;
124 --
125 -- Remember IN OUT parameter IN values
126 --
127 --
128 -- Convert constant values to their corresponding boolean value
129 --
130 l_validate :=
131 hr_api.constant_to_boolean
132 (p_constant_value => p_validate);
133 --
134 -- Register Surrogate ID or user key values
135 --
136 --
137 -- Call API
138 --
139 ben_enrollment_rate_api.create_enrollment_rate
140 (p_validate => l_validate
141 ,p_enrt_rt_id => p_enrt_rt_id
142 ,p_ordr_num => p_ordr_num
143 ,p_acty_typ_cd => p_acty_typ_cd
144 ,p_tx_typ_cd => p_tx_typ_cd
145 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
146 ,p_dflt_flag => p_dflt_flag
147 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
148 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
149 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
150 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
151 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
152 ,p_rl_crs_only_flag => p_rl_crs_only_flag
153 ,p_dflt_val => p_dflt_val
154 ,p_ann_val => p_ann_val
155 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
156 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
157 ,p_val => p_val
158 ,p_nnmntry_uom => p_nnmntry_uom
159 ,p_mx_elcn_val => p_mx_elcn_val
160 ,p_mn_elcn_val => p_mn_elcn_val
161 ,p_incrmt_elcn_val => p_incrmt_elcn_val
162 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
163 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
164 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
165 ,p_cmcd_val => p_cmcd_val
166 ,p_cmcd_dflt_val => p_cmcd_dflt_val
167 ,p_rt_usg_cd => p_rt_usg_cd
168 ,p_ann_dflt_val => p_ann_dflt_val
169 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
170 ,p_rt_mlt_cd => p_rt_mlt_cd
171 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
172 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
173 ,p_entr_ann_val_flag => p_entr_ann_val_flag
174 ,p_rt_strt_dt => p_rt_strt_dt
175 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
176 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
177 ,p_rt_typ_cd => p_rt_typ_cd
178 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
179 ,p_acty_base_rt_id => p_acty_base_rt_id
180 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
181 ,p_enrt_bnft_id => p_enrt_bnft_id
182 ,p_prtt_rt_val_id => p_prtt_rt_val_id
183 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
184 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
185 ,p_actl_prem_id => p_actl_prem_id
186 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
187 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
188 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
189 ,p_business_group_id => p_business_group_id
190 ,p_perf_min_max_edit => p_perf_min_max_edit
191 ,p_iss_val => p_iss_val
192 ,p_val_last_upd_date => p_val_last_upd_date
193 ,p_val_last_upd_person_id => p_val_last_upd_person_id
194 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
195 ,p_ecr_attribute_category => p_ecr_attribute_category
196 ,p_ecr_attribute1 => p_ecr_attribute1
197 ,p_ecr_attribute2 => p_ecr_attribute2
198 ,p_ecr_attribute3 => p_ecr_attribute3
199 ,p_ecr_attribute4 => p_ecr_attribute4
200 ,p_ecr_attribute5 => p_ecr_attribute5
201 ,p_ecr_attribute6 => p_ecr_attribute6
202 ,p_ecr_attribute7 => p_ecr_attribute7
203 ,p_ecr_attribute8 => p_ecr_attribute8
204 ,p_ecr_attribute9 => p_ecr_attribute9
205 ,p_ecr_attribute10 => p_ecr_attribute10
206 ,p_ecr_attribute11 => p_ecr_attribute11
207 ,p_ecr_attribute12 => p_ecr_attribute12
208 ,p_ecr_attribute13 => p_ecr_attribute13
209 ,p_ecr_attribute14 => p_ecr_attribute14
210 ,p_ecr_attribute15 => p_ecr_attribute15
211 ,p_ecr_attribute16 => p_ecr_attribute16
212 ,p_ecr_attribute17 => p_ecr_attribute17
213 ,p_ecr_attribute18 => p_ecr_attribute18
214 ,p_ecr_attribute19 => p_ecr_attribute19
215 ,p_ecr_attribute20 => p_ecr_attribute20
216 ,p_ecr_attribute21 => p_ecr_attribute21
217 ,p_ecr_attribute22 => p_ecr_attribute22
218 ,p_ecr_attribute23 => p_ecr_attribute23
219 ,p_ecr_attribute24 => p_ecr_attribute24
220 ,p_ecr_attribute25 => p_ecr_attribute25
221 ,p_ecr_attribute26 => p_ecr_attribute26
222 ,p_ecr_attribute27 => p_ecr_attribute27
223 ,p_ecr_attribute28 => p_ecr_attribute28
224 ,p_ecr_attribute29 => p_ecr_attribute29
225 ,p_ecr_attribute30 => p_ecr_attribute30
226 ,p_request_id => p_request_id
227 ,p_program_application_id => p_program_application_id
228 ,p_program_id => p_program_id
229 ,p_program_update_date => p_program_update_date
230 ,p_object_version_number => p_object_version_number
231 ,p_effective_date => p_effective_date
232 );
233 --
234 -- Convert API warning boolean parameter values to specific
235 -- messages and add them to Multiple Message List
236 --
237 --
238 -- Convert API non-warning boolean parameter values
239 --
240 --
241 -- Derive the API return status value based on whether
242 -- messages of any type exist in the Multiple Message List.
243 -- Also disable Multiple Message Detection.
244 --
245 p_return_status := hr_multi_message.get_return_status_disable;
246 hr_utility.set_location(' Leaving:' || l_proc,20);
247 --
248 exception
249 when hr_multi_message.error_message_exist then
250 --
251 -- Catch the Multiple Message List exception which
252 -- indicates API processing has been aborted because
253 -- at least one message exists in the list.
254 --
255 rollback to create_enrollment_rate_swi;
256 --
257 -- Reset IN OUT parameters and set OUT parameters
258 --
259 p_enrt_rt_id := null;
260 p_object_version_number := null;
261 p_return_status := hr_multi_message.get_return_status_disable;
262 hr_utility.set_location(' Leaving:' || l_proc, 30);
263 when others then
264 --
265 -- When Multiple Message Detection is enabled catch
266 -- any Application specific or other unexpected
267 -- exceptions. Adding appropriate details to the
268 -- Multiple Message List. Otherwise re-raise the
269 -- error.
270 --
271 rollback to create_enrollment_rate_swi;
272 if hr_multi_message.unexpected_error_add(l_proc) then
273 hr_utility.set_location(' Leaving:' || l_proc,40);
274 raise;
275 end if;
276 --
277 -- Reset IN OUT and set OUT parameters
278 --
279 p_enrt_rt_id := null;
280 p_object_version_number := null;
281 p_return_status := hr_multi_message.get_return_status_disable;
282 hr_utility.set_location(' Leaving:' || l_proc,50);
283 end create_enrollment_rate;
284 -- ----------------------------------------------------------------------------
285 -- |----------------------< create_perf_enrollment_rate >---------------------|
286 -- ----------------------------------------------------------------------------
287 PROCEDURE create_perf_enrollment_rate
288 (p_validate in number default hr_api.g_false_num
289 ,p_enrt_rt_id out nocopy number
290 ,p_ordr_num in number default null
291 ,p_acty_typ_cd in varchar2 default null
292 ,p_tx_typ_cd in varchar2 default null
293 ,p_ctfn_rqd_flag in varchar2 default null
294 ,p_dflt_flag in varchar2 default null
295 ,p_dflt_pndg_ctfn_flag in varchar2 default null
296 ,p_dsply_on_enrt_flag in varchar2 default null
297 ,p_use_to_calc_net_flx_cr_flag in varchar2 default null
298 ,p_entr_val_at_enrt_flag in varchar2 default null
299 ,p_asn_on_enrt_flag in varchar2 default null
300 ,p_rl_crs_only_flag in varchar2 default null
301 ,p_dflt_val in number default null
302 ,p_ann_val in number default null
303 ,p_ann_mn_elcn_val in number default null
304 ,p_ann_mx_elcn_val in number default null
305 ,p_val in number default null
306 ,p_nnmntry_uom in varchar2 default null
307 ,p_mx_elcn_val in number default null
308 ,p_mn_elcn_val in number default null
309 ,p_incrmt_elcn_val in number default null
310 ,p_cmcd_acty_ref_perd_cd in varchar2 default null
311 ,p_cmcd_mn_elcn_val in number default null
315 ,p_rt_usg_cd in varchar2 default null
312 ,p_cmcd_mx_elcn_val in number default null
313 ,p_cmcd_val in number default null
314 ,p_cmcd_dflt_val in number default null
316 ,p_ann_dflt_val in number default null
317 ,p_bnft_rt_typ_cd in varchar2 default null
318 ,p_rt_mlt_cd in varchar2 default null
319 ,p_dsply_mn_elcn_val in number default null
320 ,p_dsply_mx_elcn_val in number default null
321 ,p_entr_ann_val_flag in varchar2
322 ,p_rt_strt_dt in date default null
323 ,p_rt_strt_dt_cd in varchar2 default null
324 ,p_rt_strt_dt_rl in number default null
325 ,p_rt_typ_cd in varchar2 default null
326 ,p_elig_per_elctbl_chc_id in number default null
327 ,p_acty_base_rt_id in number default null
328 ,p_spcl_rt_enrt_rt_id in number default null
329 ,p_enrt_bnft_id in number default null
330 ,p_prtt_rt_val_id in number default null
331 ,p_decr_bnft_prvdr_pool_id in number default null
332 ,p_cvg_amt_calc_mthd_id in number default null
333 ,p_actl_prem_id in number default null
334 ,p_comp_lvl_fctr_id in number default null
335 ,p_ptd_comp_lvl_fctr_id in number default null
336 ,p_clm_comp_lvl_fctr_id in number default null
337 ,p_business_group_id in number
338 ,p_perf_min_max_edit in varchar2 default null
339 ,p_iss_val in number default null
340 ,p_val_last_upd_date in date default null
341 ,p_val_last_upd_person_id in number default null
342 ,p_pp_in_yr_used_num in number default null
343 ,p_ecr_attribute_category in varchar2 default null
344 ,p_ecr_attribute1 in varchar2 default null
345 ,p_ecr_attribute2 in varchar2 default null
346 ,p_ecr_attribute3 in varchar2 default null
347 ,p_ecr_attribute4 in varchar2 default null
348 ,p_ecr_attribute5 in varchar2 default null
349 ,p_ecr_attribute6 in varchar2 default null
350 ,p_ecr_attribute7 in varchar2 default null
351 ,p_ecr_attribute8 in varchar2 default null
352 ,p_ecr_attribute9 in varchar2 default null
353 ,p_ecr_attribute10 in varchar2 default null
354 ,p_ecr_attribute11 in varchar2 default null
355 ,p_ecr_attribute12 in varchar2 default null
356 ,p_ecr_attribute13 in varchar2 default null
357 ,p_ecr_attribute14 in varchar2 default null
358 ,p_ecr_attribute15 in varchar2 default null
359 ,p_ecr_attribute16 in varchar2 default null
360 ,p_ecr_attribute17 in varchar2 default null
361 ,p_ecr_attribute18 in varchar2 default null
362 ,p_ecr_attribute19 in varchar2 default null
363 ,p_ecr_attribute20 in varchar2 default null
364 ,p_ecr_attribute21 in varchar2 default null
365 ,p_ecr_attribute22 in varchar2 default null
366 ,p_ecr_attribute23 in varchar2 default null
367 ,p_ecr_attribute24 in varchar2 default null
368 ,p_ecr_attribute25 in varchar2 default null
369 ,p_ecr_attribute26 in varchar2 default null
370 ,p_ecr_attribute27 in varchar2 default null
371 ,p_ecr_attribute28 in varchar2 default null
372 ,p_ecr_attribute29 in varchar2 default null
373 ,p_ecr_attribute30 in varchar2 default null
374 ,p_request_id in number default null
375 ,p_program_application_id in number default null
376 ,p_program_id in number default null
377 ,p_program_update_date in date default null
378 ,p_object_version_number out nocopy number
379 ,p_effective_date in date
380 ,p_return_status out nocopy varchar2
381 ) is
382 --
383 -- Variables for API Boolean parameters
384 l_validate boolean;
385 --
386 -- Variables for IN/OUT parameters
387 --
388 -- Other variables
389 l_proc varchar2(72) := g_package ||'create_perf_enrollment_rate';
390 Begin
391 hr_utility.set_location(' Entering:' || l_proc,10);
392 --
393 -- Issue a savepoint
394 --
395 savepoint creat_perf_enrollment_rate_swi;
396 --
397 -- Initialise Multiple Message Detection
398 --
399 hr_multi_message.enable_message_list;
400 --
401 -- Remember IN OUT parameter IN values
402 --
403 --
404 -- Convert constant values to their corresponding boolean value
405 --
406 l_validate :=
407 hr_api.constant_to_boolean
408 (p_constant_value => p_validate);
409 --
410 -- Register Surrogate ID or user key values
411 --
412 --
413 -- Call API
414 --
415 ben_enrollment_rate_api.create_perf_enrollment_rate
416 (p_validate => l_validate
420 ,p_tx_typ_cd => p_tx_typ_cd
417 ,p_enrt_rt_id => p_enrt_rt_id
418 ,p_ordr_num => p_ordr_num
419 ,p_acty_typ_cd => p_acty_typ_cd
421 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
422 ,p_dflt_flag => p_dflt_flag
423 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
424 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
425 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
426 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
427 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
428 ,p_rl_crs_only_flag => p_rl_crs_only_flag
429 ,p_dflt_val => p_dflt_val
430 ,p_ann_val => p_ann_val
431 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
432 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
433 ,p_val => p_val
434 ,p_nnmntry_uom => p_nnmntry_uom
435 ,p_mx_elcn_val => p_mx_elcn_val
436 ,p_mn_elcn_val => p_mn_elcn_val
437 ,p_incrmt_elcn_val => p_incrmt_elcn_val
438 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
439 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
440 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
441 ,p_cmcd_val => p_cmcd_val
442 ,p_cmcd_dflt_val => p_cmcd_dflt_val
443 ,p_rt_usg_cd => p_rt_usg_cd
444 ,p_ann_dflt_val => p_ann_dflt_val
445 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
446 ,p_rt_mlt_cd => p_rt_mlt_cd
447 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
448 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
449 ,p_entr_ann_val_flag => p_entr_ann_val_flag
450 ,p_rt_strt_dt => p_rt_strt_dt
451 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
452 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
453 ,p_rt_typ_cd => p_rt_typ_cd
454 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
455 ,p_acty_base_rt_id => p_acty_base_rt_id
456 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
457 ,p_enrt_bnft_id => p_enrt_bnft_id
458 ,p_prtt_rt_val_id => p_prtt_rt_val_id
459 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
460 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
461 ,p_actl_prem_id => p_actl_prem_id
462 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
463 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
464 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
465 ,p_business_group_id => p_business_group_id
466 ,p_perf_min_max_edit => p_perf_min_max_edit
467 ,p_iss_val => p_iss_val
468 ,p_val_last_upd_date => p_val_last_upd_date
469 ,p_val_last_upd_person_id => p_val_last_upd_person_id
470 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
471 ,p_ecr_attribute_category => p_ecr_attribute_category
472 ,p_ecr_attribute1 => p_ecr_attribute1
473 ,p_ecr_attribute2 => p_ecr_attribute2
474 ,p_ecr_attribute3 => p_ecr_attribute3
475 ,p_ecr_attribute4 => p_ecr_attribute4
476 ,p_ecr_attribute5 => p_ecr_attribute5
477 ,p_ecr_attribute6 => p_ecr_attribute6
478 ,p_ecr_attribute7 => p_ecr_attribute7
479 ,p_ecr_attribute8 => p_ecr_attribute8
480 ,p_ecr_attribute9 => p_ecr_attribute9
481 ,p_ecr_attribute10 => p_ecr_attribute10
482 ,p_ecr_attribute11 => p_ecr_attribute11
483 ,p_ecr_attribute12 => p_ecr_attribute12
484 ,p_ecr_attribute13 => p_ecr_attribute13
485 ,p_ecr_attribute14 => p_ecr_attribute14
486 ,p_ecr_attribute15 => p_ecr_attribute15
487 ,p_ecr_attribute16 => p_ecr_attribute16
488 ,p_ecr_attribute17 => p_ecr_attribute17
489 ,p_ecr_attribute18 => p_ecr_attribute18
490 ,p_ecr_attribute19 => p_ecr_attribute19
491 ,p_ecr_attribute20 => p_ecr_attribute20
492 ,p_ecr_attribute21 => p_ecr_attribute21
493 ,p_ecr_attribute22 => p_ecr_attribute22
494 ,p_ecr_attribute23 => p_ecr_attribute23
495 ,p_ecr_attribute24 => p_ecr_attribute24
496 ,p_ecr_attribute25 => p_ecr_attribute25
497 ,p_ecr_attribute26 => p_ecr_attribute26
498 ,p_ecr_attribute27 => p_ecr_attribute27
499 ,p_ecr_attribute28 => p_ecr_attribute28
500 ,p_ecr_attribute29 => p_ecr_attribute29
501 ,p_ecr_attribute30 => p_ecr_attribute30
502 ,p_request_id => p_request_id
503 ,p_program_application_id => p_program_application_id
504 ,p_program_id => p_program_id
505 ,p_program_update_date => p_program_update_date
506 ,p_object_version_number => p_object_version_number
507 ,p_effective_date => p_effective_date
508 );
509 --
510 -- Convert API warning boolean parameter values to specific
511 -- messages and add them to Multiple Message List
512 --
513 --
514 -- Convert API non-warning boolean parameter values
515 --
516 --
517 -- Derive the API return status value based on whether
521 p_return_status := hr_multi_message.get_return_status_disable;
518 -- messages of any type exist in the Multiple Message List.
519 -- Also disable Multiple Message Detection.
520 --
522 hr_utility.set_location(' Leaving:' || l_proc,20);
523 --
524 exception
525 when hr_multi_message.error_message_exist then
526 --
527 -- Catch the Multiple Message List exception which
528 -- indicates API processing has been aborted because
529 -- at least one message exists in the list.
530 --
531 rollback to creat_perf_enrollment_rate_swi;
532 --
533 -- Reset IN OUT parameters and set OUT parameters
534 --
535 p_enrt_rt_id := null;
536 p_object_version_number := null;
537 p_return_status := hr_multi_message.get_return_status_disable;
538 hr_utility.set_location(' Leaving:' || l_proc, 30);
539 when others then
540 --
541 -- When Multiple Message Detection is enabled catch
542 -- any Application specific or other unexpected
543 -- exceptions. Adding appropriate details to the
544 -- Multiple Message List. Otherwise re-raise the
545 -- error.
546 --
547 rollback to creat_perf_enrollment_rate_swi;
548 if hr_multi_message.unexpected_error_add(l_proc) then
549 hr_utility.set_location(' Leaving:' || l_proc,40);
550 raise;
551 end if;
552 --
553 -- Reset IN OUT and set OUT parameters
554 --
555 p_enrt_rt_id := null;
556 p_object_version_number := null;
557 p_return_status := hr_multi_message.get_return_status_disable;
558 hr_utility.set_location(' Leaving:' || l_proc,50);
559 end create_perf_enrollment_rate;
560 -- ----------------------------------------------------------------------------
561 -- |------------------------< delete_enrollment_rate >------------------------|
562 -- ----------------------------------------------------------------------------
563 PROCEDURE delete_enrollment_rate
564 (p_validate in number default hr_api.g_false_num
565 ,p_enrt_rt_id in number
566 ,p_object_version_number in out nocopy number
567 ,p_effective_date in date
568 ,p_return_status out nocopy varchar2
569 ) is
570 --
571 -- Variables for API Boolean parameters
572 l_validate boolean;
573 --
574 -- Variables for IN/OUT parameters
575 l_object_version_number number;
576 --
577 -- Other variables
578 l_proc varchar2(72) := g_package ||'delete_enrollment_rate';
579 Begin
580 hr_utility.set_location(' Entering:' || l_proc,10);
581 --
582 -- Issue a savepoint
583 --
584 savepoint delete_enrollment_rate_swi;
585 --
586 -- Initialise Multiple Message Detection
587 --
588 hr_multi_message.enable_message_list;
589 --
590 -- Remember IN OUT parameter IN values
591 --
592 l_object_version_number := p_object_version_number;
593 --
594 -- Convert constant values to their corresponding boolean value
595 --
596 l_validate :=
597 hr_api.constant_to_boolean
598 (p_constant_value => p_validate);
599 --
600 -- Register Surrogate ID or user key values
601 --
602 --
603 -- Call API
604 --
605 ben_enrollment_rate_api.delete_enrollment_rate
606 (p_validate => l_validate
607 ,p_enrt_rt_id => p_enrt_rt_id
608 ,p_object_version_number => p_object_version_number
609 ,p_effective_date => p_effective_date
610 );
611 --
612 -- Convert API warning boolean parameter values to specific
613 -- messages and add them to Multiple Message List
614 --
615 --
616 -- Convert API non-warning boolean parameter values
617 --
618 --
619 -- Derive the API return status value based on whether
620 -- messages of any type exist in the Multiple Message List.
621 -- Also disable Multiple Message Detection.
622 --
623 p_return_status := hr_multi_message.get_return_status_disable;
624 hr_utility.set_location(' Leaving:' || l_proc,20);
625 --
626 exception
627 when hr_multi_message.error_message_exist then
628 --
629 -- Catch the Multiple Message List exception which
630 -- indicates API processing has been aborted because
631 -- at least one message exists in the list.
632 --
633 rollback to delete_enrollment_rate_swi;
634 --
635 -- Reset IN OUT parameters and set OUT parameters
636 --
637 p_object_version_number := l_object_version_number;
638 p_return_status := hr_multi_message.get_return_status_disable;
639 hr_utility.set_location(' Leaving:' || l_proc, 30);
640 when others then
641 --
642 -- When Multiple Message Detection is enabled catch
643 -- any Application specific or other unexpected
644 -- exceptions. Adding appropriate details to the
645 -- Multiple Message List. Otherwise re-raise the
646 -- error.
647 --
648 rollback to delete_enrollment_rate_swi;
649 if hr_multi_message.unexpected_error_add(l_proc) then
650 hr_utility.set_location(' Leaving:' || l_proc,40);
654 -- Reset IN OUT and set OUT parameters
651 raise;
652 end if;
653 --
655 --
656 p_object_version_number := l_object_version_number;
657 p_return_status := hr_multi_message.get_return_status_disable;
658 hr_utility.set_location(' Leaving:' || l_proc,50);
659 end delete_enrollment_rate;
660 -- ----------------------------------------------------------------------------
661 -- |----------------------------------< lck >---------------------------------|
662 -- ----------------------------------------------------------------------------
663 PROCEDURE lck
664 (p_enrt_rt_id in number
665 ,p_object_version_number in number
666 ,p_return_status out nocopy varchar2
667 ) is
668 --
669 -- Variables for API Boolean parameters
670 --
671 -- Variables for IN/OUT parameters
672 --
673 -- Other variables
674 l_proc varchar2(72) := g_package ||'lck';
675 Begin
676 hr_utility.set_location(' Entering:' || l_proc,10);
677 --
678 -- Issue a savepoint
679 --
680 savepoint lck_swi;
681 --
682 -- Initialise Multiple Message Detection
683 --
684 hr_multi_message.enable_message_list;
685 --
686 -- Remember IN OUT parameter IN values
687 --
688 --
689 -- Convert constant values to their corresponding boolean value
690 --
691 --
692 -- Register Surrogate ID or user key values
693 --
694 --
695 -- Call API
696 --
697 ben_enrollment_rate_api.lck
698 (p_enrt_rt_id => p_enrt_rt_id
699 ,p_object_version_number => p_object_version_number
700 );
701 --
702 -- Convert API warning boolean parameter values to specific
703 -- messages and add them to Multiple Message List
704 --
705 --
706 -- Convert API non-warning boolean parameter values
707 --
708 --
709 -- Derive the API return status value based on whether
710 -- messages of any type exist in the Multiple Message List.
711 -- Also disable Multiple Message Detection.
712 --
713 p_return_status := hr_multi_message.get_return_status_disable;
714 hr_utility.set_location(' Leaving:' || l_proc,20);
715 --
716 exception
717 when hr_multi_message.error_message_exist then
718 --
719 -- Catch the Multiple Message List exception which
720 -- indicates API processing has been aborted because
721 -- at least one message exists in the list.
722 --
723 rollback to lck_swi;
724 --
725 -- Reset IN OUT parameters and set OUT parameters
726 --
727 p_return_status := hr_multi_message.get_return_status_disable;
728 hr_utility.set_location(' Leaving:' || l_proc, 30);
729 when others then
730 --
731 -- When Multiple Message Detection is enabled catch
732 -- any Application specific or other unexpected
733 -- exceptions. Adding appropriate details to the
734 -- Multiple Message List. Otherwise re-raise the
735 -- error.
736 --
737 rollback to lck_swi;
738 if hr_multi_message.unexpected_error_add(l_proc) then
739 hr_utility.set_location(' Leaving:' || l_proc,40);
740 raise;
741 end if;
742 --
743 -- Reset IN OUT and set OUT parameters
744 --
745 p_return_status := hr_multi_message.get_return_status_disable;
746 hr_utility.set_location(' Leaving:' || l_proc,50);
747 end lck;
748 -- ----------------------------------------------------------------------------
749 -- |-----------------------< override_enrollment_rate >-----------------------|
750 -- ----------------------------------------------------------------------------
751 PROCEDURE override_enrollment_rate
752 (p_validate in number default hr_api.g_false_num
753 ,p_person_id in number
754 ,p_enrt_rt_id in number
755 ,p_ordr_num in number default hr_api.g_number
756 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
757 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
758 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
759 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
760 ,p_dflt_pndg_ctfn_flag in varchar2 default hr_api.g_varchar2
761 ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
762 ,p_use_to_calc_net_flx_cr_flag in varchar2 default hr_api.g_varchar2
763 ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
764 ,p_asn_on_enrt_flag in varchar2 default hr_api.g_varchar2
765 ,p_rl_crs_only_flag in varchar2 default hr_api.g_varchar2
766 ,p_dflt_val in number default hr_api.g_number
767 ,p_old_ann_val in number default hr_api.g_number
768 ,p_ann_val in number default hr_api.g_number
769 ,p_ann_mn_elcn_val in number default hr_api.g_number
770 ,p_ann_mx_elcn_val in number default hr_api.g_number
771 ,p_old_val in number default hr_api.g_number
772 ,p_val in number default hr_api.g_number
773 ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
777 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
774 ,p_mx_elcn_val in number default hr_api.g_number
775 ,p_mn_elcn_val in number default hr_api.g_number
776 ,p_incrmt_elcn_val in number default hr_api.g_number
778 ,p_cmcd_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
779 ,p_cmcd_mn_elcn_val in number default hr_api.g_number
780 ,p_cmcd_mx_elcn_val in number default hr_api.g_number
781 ,p_cmcd_val in number default hr_api.g_number
782 ,p_cmcd_dflt_val in number default hr_api.g_number
783 ,p_rt_usg_cd in varchar2 default hr_api.g_varchar2
784 ,p_ann_dflt_val in number default hr_api.g_number
785 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
786 ,p_rt_mlt_cd in varchar2 default hr_api.g_varchar2
787 ,p_dsply_mn_elcn_val in number default hr_api.g_number
788 ,p_dsply_mx_elcn_val in number default hr_api.g_number
789 ,p_entr_ann_val_flag in varchar2 default hr_api.g_varchar2
790 ,p_rt_strt_dt in date default hr_api.g_date
791 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
792 ,p_rt_strt_dt_rl in number default hr_api.g_number
793 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
794 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
795 ,p_acty_base_rt_id in number default hr_api.g_number
796 ,p_spcl_rt_enrt_rt_id in number default hr_api.g_number
797 ,p_enrt_bnft_id in number default hr_api.g_number
798 ,p_prtt_rt_val_id in number default hr_api.g_number
799 ,p_decr_bnft_prvdr_pool_id in number default hr_api.g_number
800 ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
801 ,p_actl_prem_id in number default hr_api.g_number
802 ,p_comp_lvl_fctr_id in number default hr_api.g_number
803 ,p_ptd_comp_lvl_fctr_id in number default hr_api.g_number
804 ,p_clm_comp_lvl_fctr_id in number default hr_api.g_number
805 ,p_business_group_id in number default hr_api.g_number
806 ,p_perf_min_max_edit in varchar2 default hr_api.g_varchar2
807 ,p_iss_val in number default hr_api.g_number
808 ,p_val_last_upd_date in date default hr_api.g_date
809 ,p_val_last_upd_person_id in number default hr_api.g_number
810 ,p_pp_in_yr_used_num in number default hr_api.g_number
811 ,p_ecr_attribute_category in varchar2 default hr_api.g_varchar2
812 ,p_ecr_attribute1 in varchar2 default hr_api.g_varchar2
813 ,p_ecr_attribute2 in varchar2 default hr_api.g_varchar2
814 ,p_ecr_attribute3 in varchar2 default hr_api.g_varchar2
815 ,p_ecr_attribute4 in varchar2 default hr_api.g_varchar2
816 ,p_ecr_attribute5 in varchar2 default hr_api.g_varchar2
817 ,p_ecr_attribute6 in varchar2 default hr_api.g_varchar2
818 ,p_ecr_attribute7 in varchar2 default hr_api.g_varchar2
819 ,p_ecr_attribute8 in varchar2 default hr_api.g_varchar2
820 ,p_ecr_attribute9 in varchar2 default hr_api.g_varchar2
821 ,p_ecr_attribute10 in varchar2 default hr_api.g_varchar2
822 ,p_ecr_attribute11 in varchar2 default hr_api.g_varchar2
823 ,p_ecr_attribute12 in varchar2 default hr_api.g_varchar2
824 ,p_ecr_attribute13 in varchar2 default hr_api.g_varchar2
825 ,p_ecr_attribute14 in varchar2 default hr_api.g_varchar2
826 ,p_ecr_attribute15 in varchar2 default hr_api.g_varchar2
827 ,p_ecr_attribute16 in varchar2 default hr_api.g_varchar2
828 ,p_ecr_attribute17 in varchar2 default hr_api.g_varchar2
829 ,p_ecr_attribute18 in varchar2 default hr_api.g_varchar2
830 ,p_ecr_attribute19 in varchar2 default hr_api.g_varchar2
831 ,p_ecr_attribute20 in varchar2 default hr_api.g_varchar2
832 ,p_ecr_attribute21 in varchar2 default hr_api.g_varchar2
833 ,p_ecr_attribute22 in varchar2 default hr_api.g_varchar2
834 ,p_ecr_attribute23 in varchar2 default hr_api.g_varchar2
835 ,p_ecr_attribute24 in varchar2 default hr_api.g_varchar2
836 ,p_ecr_attribute25 in varchar2 default hr_api.g_varchar2
837 ,p_ecr_attribute26 in varchar2 default hr_api.g_varchar2
838 ,p_ecr_attribute27 in varchar2 default hr_api.g_varchar2
839 ,p_ecr_attribute28 in varchar2 default hr_api.g_varchar2
840 ,p_ecr_attribute29 in varchar2 default hr_api.g_varchar2
841 ,p_ecr_attribute30 in varchar2 default hr_api.g_varchar2
842 ,p_request_id in number default hr_api.g_number
843 ,p_program_application_id in number default hr_api.g_number
844 ,p_program_id in number default hr_api.g_number
845 ,p_program_update_date in date default hr_api.g_date
846 ,p_object_version_number in out nocopy number
847 ,p_effective_date in date
848 ,p_return_status out nocopy varchar2
849 ) is
850 --
851 -- Variables for API Boolean parameters
855 l_object_version_number number;
852 l_validate boolean;
853 --
854 -- Variables for IN/OUT parameters
856 --
857 -- Other variables
858 l_proc varchar2(72) := g_package ||'override_enrollment_rate';
859 Begin
860 hr_utility.set_location(' Entering:' || l_proc,10);
861 --
862 -- Issue a savepoint
863 --
864 savepoint override_enrollment_rate_swi;
865 --
866 -- Initialise Multiple Message Detection
867 --
868 hr_multi_message.enable_message_list;
869 --
870 -- Remember IN OUT parameter IN values
871 --
872 l_object_version_number := p_object_version_number;
873 --
874 -- Convert constant values to their corresponding boolean value
875 --
876 l_validate :=
877 hr_api.constant_to_boolean
878 (p_constant_value => p_validate);
879 --
880 -- Register Surrogate ID or user key values
881 --
882 --
883 -- Call API
884 --
885 ben_enrollment_rate_api.override_enrollment_rate
886 (p_validate => l_validate
887 ,p_person_id => p_person_id
888 ,p_enrt_rt_id => p_enrt_rt_id
889 ,p_ordr_num => p_ordr_num
890 ,p_acty_typ_cd => p_acty_typ_cd
891 ,p_tx_typ_cd => p_tx_typ_cd
892 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
893 ,p_dflt_flag => p_dflt_flag
894 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
895 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
896 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
897 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
898 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
899 ,p_rl_crs_only_flag => p_rl_crs_only_flag
900 ,p_dflt_val => p_dflt_val
901 ,p_old_ann_val => p_old_ann_val
902 ,p_ann_val => p_ann_val
903 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
904 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
905 ,p_old_val => p_old_val
906 ,p_val => p_val
907 ,p_nnmntry_uom => p_nnmntry_uom
908 ,p_mx_elcn_val => p_mx_elcn_val
909 ,p_mn_elcn_val => p_mn_elcn_val
910 ,p_incrmt_elcn_val => p_incrmt_elcn_val
911 ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
912 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
913 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
914 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
915 ,p_cmcd_val => p_cmcd_val
916 ,p_cmcd_dflt_val => p_cmcd_dflt_val
917 ,p_rt_usg_cd => p_rt_usg_cd
918 ,p_ann_dflt_val => p_ann_dflt_val
919 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
920 ,p_rt_mlt_cd => p_rt_mlt_cd
921 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
922 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
923 ,p_entr_ann_val_flag => p_entr_ann_val_flag
924 ,p_rt_strt_dt => p_rt_strt_dt
925 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
926 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
927 ,p_rt_typ_cd => p_rt_typ_cd
928 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
929 ,p_acty_base_rt_id => p_acty_base_rt_id
930 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
931 ,p_enrt_bnft_id => p_enrt_bnft_id
932 ,p_prtt_rt_val_id => p_prtt_rt_val_id
933 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
934 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
935 ,p_actl_prem_id => p_actl_prem_id
936 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
937 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
938 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
939 ,p_business_group_id => p_business_group_id
940 ,p_perf_min_max_edit => p_perf_min_max_edit
941 ,p_iss_val => p_iss_val
942 ,p_val_last_upd_date => p_val_last_upd_date
943 ,p_val_last_upd_person_id => p_val_last_upd_person_id
944 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
945 ,p_ecr_attribute_category => p_ecr_attribute_category
946 ,p_ecr_attribute1 => p_ecr_attribute1
947 ,p_ecr_attribute2 => p_ecr_attribute2
948 ,p_ecr_attribute3 => p_ecr_attribute3
949 ,p_ecr_attribute4 => p_ecr_attribute4
950 ,p_ecr_attribute5 => p_ecr_attribute5
951 ,p_ecr_attribute6 => p_ecr_attribute6
952 ,p_ecr_attribute7 => p_ecr_attribute7
953 ,p_ecr_attribute8 => p_ecr_attribute8
954 ,p_ecr_attribute9 => p_ecr_attribute9
955 ,p_ecr_attribute10 => p_ecr_attribute10
956 ,p_ecr_attribute11 => p_ecr_attribute11
957 ,p_ecr_attribute12 => p_ecr_attribute12
958 ,p_ecr_attribute13 => p_ecr_attribute13
959 ,p_ecr_attribute14 => p_ecr_attribute14
960 ,p_ecr_attribute15 => p_ecr_attribute15
961 ,p_ecr_attribute16 => p_ecr_attribute16
965 ,p_ecr_attribute20 => p_ecr_attribute20
962 ,p_ecr_attribute17 => p_ecr_attribute17
963 ,p_ecr_attribute18 => p_ecr_attribute18
964 ,p_ecr_attribute19 => p_ecr_attribute19
966 ,p_ecr_attribute21 => p_ecr_attribute21
967 ,p_ecr_attribute22 => p_ecr_attribute22
968 ,p_ecr_attribute23 => p_ecr_attribute23
969 ,p_ecr_attribute24 => p_ecr_attribute24
970 ,p_ecr_attribute25 => p_ecr_attribute25
971 ,p_ecr_attribute26 => p_ecr_attribute26
972 ,p_ecr_attribute27 => p_ecr_attribute27
973 ,p_ecr_attribute28 => p_ecr_attribute28
974 ,p_ecr_attribute29 => p_ecr_attribute29
975 ,p_ecr_attribute30 => p_ecr_attribute30
976 ,p_request_id => p_request_id
977 ,p_program_application_id => p_program_application_id
978 ,p_program_id => p_program_id
979 ,p_program_update_date => p_program_update_date
980 ,p_object_version_number => p_object_version_number
981 ,p_effective_date => p_effective_date
982 );
983 --
984 -- Convert API warning boolean parameter values to specific
985 -- messages and add them to Multiple Message List
986 --
987 --
988 -- Convert API non-warning boolean parameter values
989 --
990 --
991 -- Derive the API return status value based on whether
992 -- messages of any type exist in the Multiple Message List.
993 -- Also disable Multiple Message Detection.
994 --
995 p_return_status := hr_multi_message.get_return_status_disable;
996 hr_utility.set_location(' Leaving:' || l_proc,20);
997 --
998 exception
999 when hr_multi_message.error_message_exist then
1000 --
1001 -- Catch the Multiple Message List exception which
1002 -- indicates API processing has been aborted because
1003 -- at least one message exists in the list.
1004 --
1005 rollback to override_enrollment_rate_swi;
1006 --
1007 -- Reset IN OUT parameters and set OUT parameters
1008 --
1009 p_object_version_number := l_object_version_number;
1010 p_return_status := hr_multi_message.get_return_status_disable;
1011 hr_utility.set_location(' Leaving:' || l_proc, 30);
1012 when others then
1013 --
1014 -- When Multiple Message Detection is enabled catch
1015 -- any Application specific or other unexpected
1016 -- exceptions. Adding appropriate details to the
1017 -- Multiple Message List. Otherwise re-raise the
1018 -- error.
1019 --
1020 rollback to override_enrollment_rate_swi;
1021 if hr_multi_message.unexpected_error_add(l_proc) then
1022 hr_utility.set_location(' Leaving:' || l_proc,40);
1023 raise;
1024 end if;
1025 --
1026 -- Reset IN OUT and set OUT parameters
1027 --
1028 p_object_version_number := l_object_version_number;
1029 p_return_status := hr_multi_message.get_return_status_disable;
1030 hr_utility.set_location(' Leaving:' || l_proc,50);
1031 end override_enrollment_rate;
1032 -- ----------------------------------------------------------------------------
1033 -- |------------------------< update_enrollment_rate >------------------------|
1034 -- ----------------------------------------------------------------------------
1035 PROCEDURE update_enrollment_rate
1036 (p_validate in number default hr_api.g_false_num
1037 ,p_enrt_rt_id in number
1038 ,p_ordr_num in number default hr_api.g_number
1039 ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
1040 ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
1041 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1042 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1043 ,p_dflt_pndg_ctfn_flag in varchar2 default hr_api.g_varchar2
1044 ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
1045 ,p_use_to_calc_net_flx_cr_flag in varchar2 default hr_api.g_varchar2
1046 ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
1047 ,p_asn_on_enrt_flag in varchar2 default hr_api.g_varchar2
1048 ,p_rl_crs_only_flag in varchar2 default hr_api.g_varchar2
1049 ,p_dflt_val in number default hr_api.g_number
1050 ,p_ann_val in number default hr_api.g_number
1051 ,p_ann_mn_elcn_val in number default hr_api.g_number
1052 ,p_ann_mx_elcn_val in number default hr_api.g_number
1053 ,p_val in number default hr_api.g_number
1054 ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
1055 ,p_mx_elcn_val in number default hr_api.g_number
1056 ,p_mn_elcn_val in number default hr_api.g_number
1057 ,p_incrmt_elcn_val in number default hr_api.g_number
1058 ,p_cmcd_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
1059 ,p_cmcd_mn_elcn_val in number default hr_api.g_number
1060 ,p_cmcd_mx_elcn_val in number default hr_api.g_number
1061 ,p_cmcd_val in number default hr_api.g_number
1062 ,p_cmcd_dflt_val in number default hr_api.g_number
1063 ,p_rt_usg_cd in varchar2 default hr_api.g_varchar2
1064 ,p_ann_dflt_val in number default hr_api.g_number
1065 ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
1069 ,p_entr_ann_val_flag in varchar2 default hr_api.g_varchar2
1066 ,p_rt_mlt_cd in varchar2 default hr_api.g_varchar2
1067 ,p_dsply_mn_elcn_val in number default hr_api.g_number
1068 ,p_dsply_mx_elcn_val in number default hr_api.g_number
1070 ,p_rt_strt_dt in date default hr_api.g_date
1071 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
1072 ,p_rt_strt_dt_rl in number default hr_api.g_number
1073 ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
1074 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
1075 ,p_acty_base_rt_id in number default hr_api.g_number
1076 ,p_spcl_rt_enrt_rt_id in number default hr_api.g_number
1077 ,p_enrt_bnft_id in number default hr_api.g_number
1078 ,p_prtt_rt_val_id in number default hr_api.g_number
1079 ,p_decr_bnft_prvdr_pool_id in number default hr_api.g_number
1080 ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
1081 ,p_actl_prem_id in number default hr_api.g_number
1082 ,p_comp_lvl_fctr_id in number default hr_api.g_number
1083 ,p_ptd_comp_lvl_fctr_id in number default hr_api.g_number
1084 ,p_clm_comp_lvl_fctr_id in number default hr_api.g_number
1085 ,p_business_group_id in number default hr_api.g_number
1086 ,p_perf_min_max_edit in varchar2 default hr_api.g_varchar2
1087 ,p_iss_val in number default hr_api.g_number
1088 ,p_val_last_upd_date in date default hr_api.g_date
1089 ,p_val_last_upd_person_id in number default hr_api.g_number
1090 ,p_pp_in_yr_used_num in number default hr_api.g_number
1091 ,p_ecr_attribute_category in varchar2 default hr_api.g_varchar2
1092 ,p_ecr_attribute1 in varchar2 default hr_api.g_varchar2
1093 ,p_ecr_attribute2 in varchar2 default hr_api.g_varchar2
1094 ,p_ecr_attribute3 in varchar2 default hr_api.g_varchar2
1095 ,p_ecr_attribute4 in varchar2 default hr_api.g_varchar2
1096 ,p_ecr_attribute5 in varchar2 default hr_api.g_varchar2
1097 ,p_ecr_attribute6 in varchar2 default hr_api.g_varchar2
1098 ,p_ecr_attribute7 in varchar2 default hr_api.g_varchar2
1099 ,p_ecr_attribute8 in varchar2 default hr_api.g_varchar2
1100 ,p_ecr_attribute9 in varchar2 default hr_api.g_varchar2
1101 ,p_ecr_attribute10 in varchar2 default hr_api.g_varchar2
1102 ,p_ecr_attribute11 in varchar2 default hr_api.g_varchar2
1103 ,p_ecr_attribute12 in varchar2 default hr_api.g_varchar2
1104 ,p_ecr_attribute13 in varchar2 default hr_api.g_varchar2
1105 ,p_ecr_attribute14 in varchar2 default hr_api.g_varchar2
1106 ,p_ecr_attribute15 in varchar2 default hr_api.g_varchar2
1107 ,p_ecr_attribute16 in varchar2 default hr_api.g_varchar2
1108 ,p_ecr_attribute17 in varchar2 default hr_api.g_varchar2
1109 ,p_ecr_attribute18 in varchar2 default hr_api.g_varchar2
1110 ,p_ecr_attribute19 in varchar2 default hr_api.g_varchar2
1111 ,p_ecr_attribute20 in varchar2 default hr_api.g_varchar2
1112 ,p_ecr_attribute21 in varchar2 default hr_api.g_varchar2
1113 ,p_ecr_attribute22 in varchar2 default hr_api.g_varchar2
1114 ,p_ecr_attribute23 in varchar2 default hr_api.g_varchar2
1115 ,p_ecr_attribute24 in varchar2 default hr_api.g_varchar2
1116 ,p_ecr_attribute25 in varchar2 default hr_api.g_varchar2
1117 ,p_ecr_attribute26 in varchar2 default hr_api.g_varchar2
1118 ,p_ecr_attribute27 in varchar2 default hr_api.g_varchar2
1119 ,p_ecr_attribute28 in varchar2 default hr_api.g_varchar2
1120 ,p_ecr_attribute29 in varchar2 default hr_api.g_varchar2
1121 ,p_ecr_attribute30 in varchar2 default hr_api.g_varchar2
1122 ,p_request_id in number default hr_api.g_number
1123 ,p_program_application_id in number default hr_api.g_number
1124 ,p_program_id in number default hr_api.g_number
1125 ,p_program_update_date in date default hr_api.g_date
1126 ,p_object_version_number in out nocopy number
1127 ,p_effective_date in date
1128 ,p_return_status out nocopy varchar2
1129 ) is
1130 --
1131 -- Variables for API Boolean parameters
1132 l_validate boolean;
1133 --
1134 -- Variables for IN/OUT parameters
1135 l_object_version_number number;
1136 --
1137 -- Other variables
1138 l_proc varchar2(72) := g_package ||'update_enrollment_rate';
1139 Begin
1140 hr_utility.set_location(' Entering:' || l_proc,10);
1141 --
1142 -- Issue a savepoint
1143 --
1144 savepoint update_enrollment_rate_swi;
1145 --
1146 -- Initialise Multiple Message Detection
1147 --
1148 hr_multi_message.enable_message_list;
1149 --
1150 -- Remember IN OUT parameter IN values
1151 --
1152 l_object_version_number := p_object_version_number;
1153 --
1154 -- Convert constant values to their corresponding boolean value
1155 --
1156 l_validate :=
1157 hr_api.constant_to_boolean
1158 (p_constant_value => p_validate);
1159 --
1160 -- Register Surrogate ID or user key values
1161 --
1162 --
1163 -- Call API
1164 --
1165 ben_enrollment_rate_api.update_enrollment_rate
1166 (p_validate => l_validate
1167 ,p_enrt_rt_id => p_enrt_rt_id
1168 ,p_ordr_num => p_ordr_num
1169 ,p_acty_typ_cd => p_acty_typ_cd
1170 ,p_tx_typ_cd => p_tx_typ_cd
1171 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
1172 ,p_dflt_flag => p_dflt_flag
1173 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
1174 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1175 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
1176 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
1177 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
1178 ,p_rl_crs_only_flag => p_rl_crs_only_flag
1179 ,p_dflt_val => p_dflt_val
1180 ,p_ann_val => p_ann_val
1181 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1182 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1183 ,p_val => p_val
1184 ,p_nnmntry_uom => p_nnmntry_uom
1185 ,p_mx_elcn_val => p_mx_elcn_val
1186 ,p_mn_elcn_val => p_mn_elcn_val
1187 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1188 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
1189 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
1190 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
1191 ,p_cmcd_val => p_cmcd_val
1192 ,p_cmcd_dflt_val => p_cmcd_dflt_val
1193 ,p_rt_usg_cd => p_rt_usg_cd
1194 ,p_ann_dflt_val => p_ann_dflt_val
1195 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1196 ,p_rt_mlt_cd => p_rt_mlt_cd
1197 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
1198 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
1199 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1200 ,p_rt_strt_dt => p_rt_strt_dt
1201 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1202 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1203 ,p_rt_typ_cd => p_rt_typ_cd
1204 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1205 ,p_acty_base_rt_id => p_acty_base_rt_id
1206 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
1207 ,p_enrt_bnft_id => p_enrt_bnft_id
1208 ,p_prtt_rt_val_id => p_prtt_rt_val_id
1209 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
1210 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
1211 ,p_actl_prem_id => p_actl_prem_id
1212 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1213 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1214 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1215 ,p_business_group_id => p_business_group_id
1216 ,p_perf_min_max_edit => p_perf_min_max_edit
1217 ,p_iss_val => p_iss_val
1218 ,p_val_last_upd_date => p_val_last_upd_date
1219 ,p_val_last_upd_person_id => p_val_last_upd_person_id
1223 ,p_ecr_attribute2 => p_ecr_attribute2
1220 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
1221 ,p_ecr_attribute_category => p_ecr_attribute_category
1222 ,p_ecr_attribute1 => p_ecr_attribute1
1224 ,p_ecr_attribute3 => p_ecr_attribute3
1225 ,p_ecr_attribute4 => p_ecr_attribute4
1226 ,p_ecr_attribute5 => p_ecr_attribute5
1227 ,p_ecr_attribute6 => p_ecr_attribute6
1228 ,p_ecr_attribute7 => p_ecr_attribute7
1229 ,p_ecr_attribute8 => p_ecr_attribute8
1230 ,p_ecr_attribute9 => p_ecr_attribute9
1231 ,p_ecr_attribute10 => p_ecr_attribute10
1232 ,p_ecr_attribute11 => p_ecr_attribute11
1233 ,p_ecr_attribute12 => p_ecr_attribute12
1234 ,p_ecr_attribute13 => p_ecr_attribute13
1235 ,p_ecr_attribute14 => p_ecr_attribute14
1236 ,p_ecr_attribute15 => p_ecr_attribute15
1237 ,p_ecr_attribute16 => p_ecr_attribute16
1238 ,p_ecr_attribute17 => p_ecr_attribute17
1239 ,p_ecr_attribute18 => p_ecr_attribute18
1240 ,p_ecr_attribute19 => p_ecr_attribute19
1241 ,p_ecr_attribute20 => p_ecr_attribute20
1242 ,p_ecr_attribute21 => p_ecr_attribute21
1243 ,p_ecr_attribute22 => p_ecr_attribute22
1244 ,p_ecr_attribute23 => p_ecr_attribute23
1245 ,p_ecr_attribute24 => p_ecr_attribute24
1246 ,p_ecr_attribute25 => p_ecr_attribute25
1247 ,p_ecr_attribute26 => p_ecr_attribute26
1248 ,p_ecr_attribute27 => p_ecr_attribute27
1249 ,p_ecr_attribute28 => p_ecr_attribute28
1250 ,p_ecr_attribute29 => p_ecr_attribute29
1251 ,p_ecr_attribute30 => p_ecr_attribute30
1252 ,p_request_id => p_request_id
1253 ,p_program_application_id => p_program_application_id
1254 ,p_program_id => p_program_id
1255 ,p_program_update_date => p_program_update_date
1256 ,p_object_version_number => p_object_version_number
1257 ,p_effective_date => p_effective_date
1258 );
1259 --
1260 -- Convert API warning boolean parameter values to specific
1261 -- messages and add them to Multiple Message List
1262 --
1263 --
1264 -- Convert API non-warning boolean parameter values
1265 --
1266 --
1267 -- Derive the API return status value based on whether
1268 -- messages of any type exist in the Multiple Message List.
1269 -- Also disable Multiple Message Detection.
1270 --
1271 p_return_status := hr_multi_message.get_return_status_disable;
1272 hr_utility.set_location(' Leaving:' || l_proc,20);
1273 --
1274 exception
1275 when hr_multi_message.error_message_exist then
1276 --
1277 -- Catch the Multiple Message List exception which
1278 -- indicates API processing has been aborted because
1279 -- at least one message exists in the list.
1280 --
1281 rollback to update_enrollment_rate_swi;
1282 --
1283 -- Reset IN OUT parameters and set OUT parameters
1284 --
1285 p_object_version_number := l_object_version_number;
1286 p_return_status := hr_multi_message.get_return_status_disable;
1287 hr_utility.set_location(' Leaving:' || l_proc, 30);
1288 when others then
1289 --
1290 -- When Multiple Message Detection is enabled catch
1291 -- any Application specific or other unexpected
1292 -- exceptions. Adding appropriate details to the
1293 -- Multiple Message List. Otherwise re-raise the
1294 -- error.
1295 --
1296 rollback to update_enrollment_rate_swi;
1297 if hr_multi_message.unexpected_error_add(l_proc) then
1298 hr_utility.set_location(' Leaving:' || l_proc,40);
1299 raise;
1300 end if;
1301 --
1302 -- Reset IN OUT and set OUT parameters
1303 --
1304 p_object_version_number := l_object_version_number;
1305 p_return_status := hr_multi_message.get_return_status_disable;
1306 hr_utility.set_location(' Leaving:' || l_proc,50);
1307 end update_enrollment_rate;
1308 -- ----------------------------------------------------------------------------
1309 -- |-----------------------------< process_api >------------------------------|
1310 -- ----------------------------------------------------------------------------
1311 procedure process_api
1312 (
1313 p_document in CLOB
1314 ,p_return_status out nocopy VARCHAR2
1315 ,p_validate in number default hr_api.g_false_num
1316 ,p_effective_date in date default null
1317 )
1318 IS
1319 l_postState VARCHAR2(2);
1320 l_return_status VARCHAR2(1);
1321 l_object_version_number number;
1322 l_commitElement xmldom.DOMElement;
1323 l_parser xmlparser.Parser;
1324 l_CommitNode xmldom.DOMNode;
1325 l_proc varchar2(72) := g_package || 'process_api';
1326
1327 --
1328
1329 BEGIN
1330
1331 hr_utility.set_location(' Entering:' || l_proc,10);
1332 hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1333
1334 l_parser := xmlparser.newParser;
1335 xmlparser.ParseCLOB(l_parser,p_document);
1336 l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1337
1338 hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1339
1340 l_commitElement := xmldom.makeElement(l_CommitNode);
1341 l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1342
1343 --Get in/out parameters
1344 l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1345
1346 if l_postState = '2' then
1347 --
1348 ben_enrollment_rate_swi.update_enrollment_rate
1349 (p_validate => p_validate
1350 ,p_enrt_rt_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnrtRtId')
1351 ,p_ordr_num => hr_transaction_swi.getNumberValue(l_CommitNode,'OrdrNum')
1352 ,p_acty_typ_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ActyTypCd')
1353 ,p_tx_typ_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'TxTypCd')
1354 ,p_ctfn_rqd_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CtfnRqdFlag')
1355 ,p_dflt_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DfltFlag')
1356 ,p_dflt_pndg_ctfn_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DfltPndgCtfnFlag')
1357 ,p_dsply_on_enrt_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DsplyOnEnrtFlag')
1358 ,p_use_to_calc_net_flx_cr_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'UseToCalcNetFlxCrFlag')
1359 ,p_entr_val_at_enrt_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EntrValAtEnrtFlag')
1360 ,p_asn_on_enrt_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AsnOnEnrtFlag')
1361 ,p_rl_crs_only_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RlCrsOnlyFlag')
1362 ,p_dflt_val => hr_transaction_swi.getNumberValue(l_CommitNode,'DfltVal')
1363 ,p_ann_val => hr_transaction_swi.getNumberValue(l_CommitNode,'AnnVal')
1364 ,p_ann_mn_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'AnnMnElcnVal')
1365 ,p_ann_mx_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'AnnMxElcnVal')
1366 ,p_val => hr_transaction_swi.getNumberValue(l_CommitNode,'Val')
1367 ,p_nnmntry_uom => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NnmntryUom')
1368 ,p_mx_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'MxElcnVal')
1369 ,p_mn_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'MnElcnVal')
1370 ,p_incrmt_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'IncrmtElcnVal')
1371 ,p_cmcd_acty_ref_perd_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CmcdActyRefPerdCd')
1372 ,p_cmcd_mn_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'CmcdMnElcnVal')
1373 ,p_cmcd_mx_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'CmcdMxElcnVal')
1374 ,p_cmcd_val => hr_transaction_swi.getNumberValue(l_CommitNode,'CmcdVal')
1375 ,p_cmcd_dflt_val => hr_transaction_swi.getNumberValue(l_CommitNode,'CmcdDfltVal')
1376 ,p_rt_usg_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RtUsgCd')
1377 ,p_ann_dflt_val => hr_transaction_swi.getNumberValue(l_CommitNode,'AnnDfltVal')
1378 ,p_bnft_rt_typ_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'BnftRtTypCd')
1379 ,p_rt_mlt_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RtMltCd')
1380 ,p_dsply_mn_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'DsplyMnElcnVal')
1381 ,p_dsply_mx_elcn_val => hr_transaction_swi.getNumberValue(l_CommitNode,'DsplyMxElcnVal')
1382 ,p_entr_ann_val_flag => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EntrAnnValFlag')
1383 ,p_rt_strt_dt => hr_transaction_swi.getDateValue(l_CommitNode,'RtStrtDt')
1384 ,p_rt_strt_dt_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RtStrtDtCd')
1385 ,p_rt_strt_dt_rl => hr_transaction_swi.getNumberValue(l_CommitNode,'RtStrtDtRl')
1386 ,p_rt_typ_cd => hr_transaction_swi.getVarchar2Value(l_CommitNode,'RtTypCd')
1387 ,p_elig_per_elctbl_chc_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EligPerElctblChcId')
1388 ,p_acty_base_rt_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActyBaseRtId')
1389 ,p_spcl_rt_enrt_rt_id => hr_transaction_swi.getNumberValue(l_CommitNode,'SpclRtEnrtRtId')
1390 ,p_enrt_bnft_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnrtBnftId')
1391 ,p_prtt_rt_val_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PrttRtValId')
1392 ,p_decr_bnft_prvdr_pool_id => hr_transaction_swi.getNumberValue(l_CommitNode,'DecrBnftPrvdrPoolId')
1393 ,p_cvg_amt_calc_mthd_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CvgAmtCalcMthdId')
1394 ,p_actl_prem_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActlPremId')
1395 ,p_comp_lvl_fctr_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompLvlFctrId')
1396 ,p_ptd_comp_lvl_fctr_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PtdCompLvlFctrId')
1397 ,p_clm_comp_lvl_fctr_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ClmCompLvlFctrId')
1398 ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId')
1399 ,p_perf_min_max_edit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'PerfMinMaxEdit')
1400 ,p_iss_val => hr_transaction_swi.getNumberValue(l_CommitNode,'IssVal')
1401 ,p_val_last_upd_date => hr_transaction_swi.getDateValue(l_CommitNode,'ValLastUpdDate')
1402 ,p_val_last_upd_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValLastUpdPersonId')
1403 ,p_pp_in_yr_used_num => hr_transaction_swi.getNumberValue(l_CommitNode,'PpInYrUsedNum')
1404 ,p_ecr_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttributeCategory')
1405 ,p_ecr_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute1')
1406 ,p_ecr_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute2')
1407 ,p_ecr_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute3')
1408 ,p_ecr_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute4')
1409 ,p_ecr_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute5')
1410 ,p_ecr_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute6')
1411 ,p_ecr_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute7')
1412 ,p_ecr_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute8')
1413 ,p_ecr_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute9')
1414 ,p_ecr_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute10')
1415 ,p_ecr_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute11')
1416 ,p_ecr_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute12')
1417 ,p_ecr_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute13')
1418 ,p_ecr_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute14')
1419 ,p_ecr_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute15')
1420 ,p_ecr_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute16')
1421 ,p_ecr_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute17')
1422 ,p_ecr_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute18')
1423 ,p_ecr_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute19')
1424 ,p_ecr_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute20')
1425 ,p_ecr_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute21')
1426 ,p_ecr_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute22')
1427 ,p_ecr_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute23')
1428 ,p_ecr_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute24')
1429 ,p_ecr_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute25')
1430 ,p_ecr_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute26')
1431 ,p_ecr_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute27')
1432 ,p_ecr_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute28')
1433 ,p_ecr_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute29')
1434 ,p_ecr_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EcrAttribute30')
1435 ,p_request_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RequestId')
1436 ,p_program_application_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramApplicationId')
1437 ,p_program_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProgramId')
1438 ,p_program_update_date => hr_transaction_swi.getDateValue(l_CommitNode,'ProgramUpdateDate')
1439 ,p_object_version_number => l_object_version_number
1440 ,p_effective_date => p_effective_date
1441 ,p_return_status => l_return_status
1442 );
1443 --
1444 end if;
1445 p_return_status := l_return_status;
1446 hr_utility.set_location('Exiting:' || l_proc,40);
1447
1448 end process_api;
1449
1450 end ben_enrollment_rate_swi;