[Home] [Help]
PACKAGE BODY: APPS.BEN_ENROLLMENT_RATE_API
Source
1 Package Body ben_Enrollment_Rate_api as
2 /* $Header: beecrapi.pkb 115.22 2004/03/23 12:43:03 ikasire ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_Enrollment_Rate_api.';
7 --
8 -- ---------------------------------------------------------------------------
9 -- |----------------------------< person_details >----------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12
13 Procedure person_details(p_elig_per_elctbl_chc_id in number
14 ,p_effective_date in date
15 ,p_person_name out nocopy varchar2
16 )is
17 --
18 l_proc varchar2(72) := g_package||'person_details';
19 l_person_name per_all_people_f.full_name%type;
20 --
21 cursor c_person is
22 select full_name
23 from per_all_people_f per
24 ,ben_per_in_ler pil
25 ,ben_elig_per_elctbl_chc epe
26 where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
27 and epe.per_in_ler_id = pil.per_in_ler_id
28 and pil.person_id = per.person_id
29 and p_effective_date between per.EFFECTIVE_START_DATE and per.EFFECTIVE_END_DATE;
30 --
31 Begin
32 --
33 hr_utility.set_location('Entering:'||l_proc, 5);
34 --
35 open c_person;
36 fetch c_person into l_person_name;
37 close c_person;
38 --
39 p_person_name := l_person_name;
40 --
41 hr_utility.set_location('Leaving:'||l_proc, 10);
42 --
43 End person_details;
44 --
45
46 --
47 -- ---------------------------------------------------------------------------
48 -- |----------------------------< chk_perf_min_max >----------------------------|
49 -- ----------------------------------------------------------------------------
50 --
51 -- Description
52 -- This procedure is used to check that the amount value and issued value is
53 -- between minimum and maximum for that Rate
54 --
55 -- Pre Conditions
56 -- p_perf_min_max_edit should be 'Y'
57 --
58 -- In Parameters
59 -- p_val Defined Amount value
60 -- p_iss_val Defined issued Amount value
61 -- p_mx_elcn_val Defined min value
62 -- p_mn_elcn_val Defined min value
63 -- p_enrt_rt_id PK of record being inserted or updated
64 -- p_object_version_number Object version number of record being
65 -- inserted or updated.
66 -- p_incrmt_elcn_val Defined increment value
67 --
68 -- Post Success
69 -- Processing continues
70 --
71 -- Post Failure
72 -- Errors handled by the procedure
73 --
74 -- Access Status
75 -- Private
76 --
77 Procedure chk_perf_min_max(p_val in number
78 ,p_iss_val in number
79 ,p_mx_elcn_val in number
80 ,p_mn_elcn_val in number
81 ,p_enrt_rt_id in number
82 ,p_object_version_number in number
83 ,p_elig_per_elctbl_chc_id in number
84 ,p_effective_date in date
85 ,p_incrmt_elcn_val in number
86 )is
87 --
88 l_proc varchar2(72) := g_package||'chk_perf_min_max';
89 l_api_updating boolean;
90 l_person_name per_all_people_f.full_name%type;
91 --
92 Begin
93 --
94 hr_utility.set_location('Entering:'||l_proc, 5);
95 hr_utility.set_location('p_val: '||p_val, 5);
96 hr_utility.set_location('p_iss_val: '||p_iss_val, 5);
97 hr_utility.set_location('p_mx_elcn_val:'||p_mx_elcn_val, 5);
98 hr_utility.set_location('p_mn_elcn_val:'||p_mn_elcn_val, 5);
99 hr_utility.set_location('p_incrmt_elcn_val:'||p_incrmt_elcn_val, 5);
100 hr_utility.set_location('l_person_name:'||l_person_name, 5);
101 --
102 person_details(p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
103 ,p_effective_date => p_effective_date
104 ,p_person_name => l_person_name);
105
106 hr_utility.set_location('l_person_name:'||l_person_name, 5);
107 --
108 if (p_val is not null and p_val <> hr_api.g_number)and
109 (p_mx_elcn_val is not null and p_mx_elcn_val <> hr_api.g_number)
110 then
111 --
112 if p_val > p_mx_elcn_val then
113 --
114 fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
115 fnd_message.set_token('VAL',p_val);
116 fnd_message.set_token('MIN',p_mn_elcn_val);
117 fnd_message.set_token('MAX',p_mx_elcn_val);
118 fnd_message.set_token('PERSON',l_person_name);
119 fnd_message.raise_error;
120 --
121 end if;
122 --
123 end if;
124 --
125 if (p_val is not null and p_val <> hr_api.g_number)and
126 (p_mn_elcn_val is not null and p_mn_elcn_val <> hr_api.g_number)
127 then
128 --
129 if p_val < p_mn_elcn_val then
130 --
131 fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
132 fnd_message.set_token('VAL',p_val);
133 fnd_message.set_token('MIN',p_mn_elcn_val);
134 fnd_message.set_token('MAX',p_mx_elcn_val);
135 fnd_message.set_token('PERSON',l_person_name);
136 fnd_message.raise_error;
137 --
138 end if;
139 --
140 end if;
141 --
142 if (p_iss_val is not null and p_iss_val <> hr_api.g_number)and
143 (p_mx_elcn_val is not null and p_mx_elcn_val <> hr_api.g_number)
144 then
145 --
146 if p_iss_val > p_mx_elcn_val then
147 --
148 fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
149 fnd_message.set_token('VAL',p_iss_val);
150 fnd_message.set_token('MIN',p_mn_elcn_val);
151 fnd_message.set_token('MAX',p_mx_elcn_val);
152 fnd_message.set_token('PERSON',l_person_name);
153 fnd_message.raise_error;
154 --
155 end if;
156 --
157 end if;
158 --
159 if (p_iss_val is not null and p_iss_val <> hr_api.g_number)and
160 (p_mn_elcn_val is not null and p_mn_elcn_val <> hr_api.g_number)
161 then
162 --
163 if p_iss_val < p_mn_elcn_val then
164 --
165 fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
166 fnd_message.set_token('VAL',p_iss_val);
167 fnd_message.set_token('MIN',p_mn_elcn_val);
168 fnd_message.set_token('MAX',p_mx_elcn_val);
169 fnd_message.set_token('PERSON',l_person_name);
170 fnd_message.raise_error;
171 --
172 end if;
173 --
174 end if;
175 --
176 if (p_iss_val is not null and p_iss_val <> hr_api.g_number)and
177 (p_incrmt_elcn_val is not null and p_incrmt_elcn_val <> hr_api.g_number)
178 then
179 --
180 if (mod(p_iss_val,p_incrmt_elcn_val)<>0) then
181 --
182 -- raise error is not multiple of increment
183 --
184 fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
185 fnd_message.set_token('VAL',p_iss_val);
186 fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
187 fnd_message.set_token('PERSON',l_person_name);
188 fnd_message.raise_error;
189 --
190 end if;
191 --
192 end if;
193 --
194 if (p_val is not null and p_val <> hr_api.g_number)and
195 (p_incrmt_elcn_val is not null and p_incrmt_elcn_val <> hr_api.g_number)
196 then
197 --
198 if (mod(p_val,p_incrmt_elcn_val)<>0) then
199 --
200 -- raise error is not multiple of increment
201 --
202 fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
203 fnd_message.set_token('VAL',p_val);
204 fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
205 fnd_message.set_token('PERSON',l_person_name);
206 fnd_message.raise_error;
207 --
208 end if;
209 --
210 end if;
211 --
212 hr_utility.set_location('Leaving:'||l_proc, 10);
213 --
214 End chk_perf_min_max;
215 --
216 -- ----------------------------------------------------------------------------
217 -- |------------------------< create_Enrollment_Rate >----------------------|
218 -- ----------------------------------------------------------------------------
219 --
220 procedure create_Enrollment_Rate
221 ( p_validate in boolean default false,
222 p_enrt_rt_id out nocopy NUMBER,
223 p_ordr_num in number default null,
224 p_acty_typ_cd in VARCHAR2 DEFAULT NULL,
225 p_tx_typ_cd in VARCHAR2 DEFAULT NULL,
226 p_ctfn_rqd_flag in VARCHAR2 DEFAULT 'N',
227 p_dflt_flag in VARCHAR2 DEFAULT 'N',
228 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT 'N',
229 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT 'N',
230 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT 'N',
231 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT 'N',
232 p_asn_on_enrt_flag in VARCHAR2 DEFAULT 'N',
233 p_rl_crs_only_flag in VARCHAR2 DEFAULT 'N',
234 p_dflt_val in NUMBER DEFAULT NULL,
235 p_ann_val in NUMBER DEFAULT NULL,
236 p_ann_mn_elcn_val in NUMBER DEFAULT NULL,
237 p_ann_mx_elcn_val in NUMBER DEFAULT NULL,
238 p_val in NUMBER DEFAULT NULL,
239 p_nnmntry_uom in VARCHAR2 DEFAULT NULL,
240 p_mx_elcn_val in NUMBER DEFAULT NULL,
241 p_mn_elcn_val in NUMBER DEFAULT NULL,
242 p_incrmt_elcn_val in NUMBER DEFAULT NULL,
243 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT NULL,
244 p_cmcd_mn_elcn_val in NUMBER DEFAULT NULL,
245 p_cmcd_mx_elcn_val in NUMBER DEFAULT NULL,
246 p_cmcd_val in NUMBER DEFAULT NULL,
247 p_cmcd_dflt_val in NUMBER DEFAULT NULL,
248 p_rt_usg_cd in VARCHAR2 DEFAULT NULL,
249 p_ann_dflt_val in NUMBER DEFAULT NULL,
250 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT NULL,
251 p_rt_mlt_cd in VARCHAR2 DEFAULT NULL,
252 p_dsply_mn_elcn_val in NUMBER DEFAULT NULL,
253 p_dsply_mx_elcn_val in NUMBER DEFAULT NULL,
254 p_entr_ann_val_flag in VARCHAR2 DEFAULT 'N',
255 p_rt_strt_dt in DATE DEFAULT NULL,
256 p_rt_strt_dt_cd in VARCHAR2 DEFAULT NULL,
257 p_rt_strt_dt_rl in NUMBER DEFAULT NULL,
258 p_rt_typ_cd in VARCHAR2 DEFAULT NULL,
259 p_elig_per_elctbl_chc_id in NUMBER DEFAULT NULL,
260 p_acty_base_rt_id in NUMBER DEFAULT NULL,
261 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT NULL,
262 p_enrt_bnft_id in NUMBER DEFAULT NULL,
263 p_prtt_rt_val_id in NUMBER DEFAULT NULL,
264 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT NULL,
265 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT NULL,
266 p_actl_prem_id in NUMBER DEFAULT NULL,
267 p_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
268 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
269 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
270 p_business_group_id in NUMBER,
271 --cwb
272 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
273 p_iss_val in number DEFAULT NULL,
274 p_val_last_upd_date in date DEFAULT NULL,
275 p_val_last_upd_person_id in number DEFAULT NULL,
276 --cwb
277 p_pp_in_yr_used_num in number default null,
278 p_ecr_attribute_category in VARCHAR2 DEFAULT NULL,
279 p_ecr_attribute1 in VARCHAR2 DEFAULT NULL,
280 p_ecr_attribute2 in VARCHAR2 DEFAULT NULL,
281 p_ecr_attribute3 in VARCHAR2 DEFAULT NULL,
282 p_ecr_attribute4 in VARCHAR2 DEFAULT NULL,
283 p_ecr_attribute5 in VARCHAR2 DEFAULT NULL,
284 p_ecr_attribute6 in VARCHAR2 DEFAULT NULL,
285 p_ecr_attribute7 in VARCHAR2 DEFAULT NULL,
286 p_ecr_attribute8 in VARCHAR2 DEFAULT NULL,
287 p_ecr_attribute9 in VARCHAR2 DEFAULT NULL,
288 p_ecr_attribute10 in VARCHAR2 DEFAULT NULL,
289 p_ecr_attribute11 in VARCHAR2 DEFAULT NULL,
290 p_ecr_attribute12 in VARCHAR2 DEFAULT NULL,
291 p_ecr_attribute13 in VARCHAR2 DEFAULT NULL,
292 p_ecr_attribute14 in VARCHAR2 DEFAULT NULL,
293 p_ecr_attribute15 in VARCHAR2 DEFAULT NULL,
294 p_ecr_attribute16 in VARCHAR2 DEFAULT NULL,
295 p_ecr_attribute17 in VARCHAR2 DEFAULT NULL,
296 p_ecr_attribute18 in VARCHAR2 DEFAULT NULL,
297 p_ecr_attribute19 in VARCHAR2 DEFAULT NULL,
298 p_ecr_attribute20 in VARCHAR2 DEFAULT NULL,
299 p_ecr_attribute21 in VARCHAR2 DEFAULT NULL,
300 p_ecr_attribute22 in VARCHAR2 DEFAULT NULL,
301 p_ecr_attribute23 in VARCHAR2 DEFAULT NULL,
302 p_ecr_attribute24 in VARCHAR2 DEFAULT NULL,
303 p_ecr_attribute25 in VARCHAR2 DEFAULT NULL,
304 p_ecr_attribute26 in VARCHAR2 DEFAULT NULL,
305 p_ecr_attribute27 in VARCHAR2 DEFAULT NULL,
306 p_ecr_attribute28 in VARCHAR2 DEFAULT NULL,
307 p_ecr_attribute29 in VARCHAR2 DEFAULT NULL,
308 p_ecr_attribute30 in VARCHAR2 DEFAULT NULL,
309 p_request_id in NUMBER DEFAULT NULL,
310 p_program_application_id in NUMBER DEFAULT NULL,
311 p_program_id in NUMBER DEFAULT NULL,
312 p_program_update_date in DATE DEFAULT NULL,
313 p_object_version_number out nocopy NUMBER,
314 p_effective_date in date
315 ) is
316 --
317 -- Declare cursors and local variables
318 --
319 l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
320 l_proc varchar2(72) := g_package||'create_Enrollment_Rate';
321 l_object_version_number ben_enrt_rt.object_version_number%TYPE;
322 --
323 begin
324 --
325 hr_utility.set_location('Entering:'|| l_proc, 10);
326 --
327 -- Issue a savepoint if operating in validation only mode
328 --
329 savepoint create_Enrollment_Rate;
330 --
331 hr_utility.set_location(l_proc, 20);
332 --
333 -- Process Logic
334 --
335 begin
336 --
337 -- Start of API User Hook for the before hook of create_Enrollment_Rate
338 --
339 ben_Enrollment_Rate_bk1.create_Enrollment_Rate_b
340 (
341 p_enrt_rt_id => l_enrt_rt_id
342 ,p_ordr_num => p_ordr_num
343 ,p_acty_typ_cd => p_acty_typ_cd
344 ,p_tx_typ_cd => p_tx_typ_cd
345 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
346 ,p_dflt_flag => p_dflt_flag
347 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
348 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
349 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
350 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
351 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
352 ,p_rl_crs_only_flag => p_rl_crs_only_flag
353 ,p_dflt_val => p_dflt_val
354 ,p_ann_val => p_ann_val
355 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
356 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
357 ,p_val => p_val
358 ,p_nnmntry_uom => p_nnmntry_uom
359 ,p_mx_elcn_val => p_mx_elcn_val
360 ,p_mn_elcn_val => p_mn_elcn_val
361 ,p_incrmt_elcn_val => p_incrmt_elcn_val
362 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
363 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
364 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
365 ,p_cmcd_val => p_cmcd_val
366 ,p_cmcd_dflt_val => p_cmcd_dflt_val
367 ,p_rt_usg_cd => p_rt_usg_cd
368 ,p_ann_dflt_val => p_ann_dflt_val
369 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
370 ,p_rt_mlt_cd => p_rt_mlt_cd
371 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
372 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
373 ,p_entr_ann_val_flag => p_entr_ann_val_flag
374 ,p_rt_strt_dt => p_rt_strt_dt
375 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
376 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
377 ,p_rt_typ_cd => p_rt_typ_cd
378 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
379 ,p_acty_base_rt_id => p_acty_base_rt_id
380 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
381 ,p_enrt_bnft_id => p_enrt_bnft_id
382 ,p_prtt_rt_val_id => p_prtt_rt_val_id
383 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
384 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
385 ,p_actl_prem_id => p_actl_prem_id
386 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
387 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
388 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
389 ,p_business_group_id => p_business_group_id
390 --cwb
391 ,p_iss_val => p_iss_val
392 ,p_val_last_upd_date => p_val_last_upd_date
393 ,p_val_last_upd_person_id => p_val_last_upd_person_id
394 --cwb
395 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
396 ,p_ecr_attribute_category => p_ecr_attribute_category
397 ,p_ecr_attribute1 => p_ecr_attribute1
398 ,p_ecr_attribute2 => p_ecr_attribute2
399 ,p_ecr_attribute3 => p_ecr_attribute3
400 ,p_ecr_attribute4 => p_ecr_attribute4
401 ,p_ecr_attribute5 => p_ecr_attribute5
402 ,p_ecr_attribute6 => p_ecr_attribute6
403 ,p_ecr_attribute7 => p_ecr_attribute7
404 ,p_ecr_attribute8 => p_ecr_attribute8
405 ,p_ecr_attribute9 => p_ecr_attribute9
406 ,p_ecr_attribute10 => p_ecr_attribute10
407 ,p_ecr_attribute11 => p_ecr_attribute11
408 ,p_ecr_attribute12 => p_ecr_attribute12
409 ,p_ecr_attribute13 => p_ecr_attribute13
410 ,p_ecr_attribute14 => p_ecr_attribute14
411 ,p_ecr_attribute15 => p_ecr_attribute15
412 ,p_ecr_attribute16 => p_ecr_attribute16
413 ,p_ecr_attribute17 => p_ecr_attribute17
414 ,p_ecr_attribute18 => p_ecr_attribute18
415 ,p_ecr_attribute19 => p_ecr_attribute19
416 ,p_ecr_attribute20 => p_ecr_attribute20
417 ,p_ecr_attribute21 => p_ecr_attribute21 ,p_ecr_attribute22 => p_ecr_attribute22
418 ,p_ecr_attribute23 => p_ecr_attribute23
419 ,p_ecr_attribute24 => p_ecr_attribute24
420 ,p_ecr_attribute25 => p_ecr_attribute25
421 ,p_ecr_attribute26 => p_ecr_attribute26
422 ,p_ecr_attribute27 => p_ecr_attribute27
423 ,p_ecr_attribute28 => p_ecr_attribute28
424 ,p_ecr_attribute29 => p_ecr_attribute29
425 ,p_ecr_attribute30 => p_ecr_attribute30
426 ,p_request_id => p_request_id
427 ,p_program_application_id => p_program_application_id
428 ,p_program_id => p_program_id
429 ,p_program_update_date => p_program_update_date
430 ,p_effective_date => trunc(p_effective_date)
431 );
432 exception
433 when hr_api.cannot_find_prog_unit then
434 hr_api.cannot_find_prog_unit_error
435 (
436 p_module_name => 'CREATE_Enrollment_Rate'
437 ,p_hook_type => 'BP'
438 );
439 --
440 -- End of API User Hook for the before hook of create_Enrollment_Rate
441 --
442 end;
443 --
444 ben_ecr_ins.ins
445 (
446 p_enrt_rt_id => l_enrt_rt_id
447 ,p_ordr_num => p_ordr_num
448 ,p_acty_typ_cd => p_acty_typ_cd
449 ,p_tx_typ_cd => p_tx_typ_cd
450 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
451 ,p_dflt_flag => p_dflt_flag
452 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
453 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
454 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
455 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
456 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
457 ,p_rl_crs_only_flag => p_rl_crs_only_flag
458 ,p_dflt_val => p_dflt_val
459 ,p_ann_val => p_ann_val
460 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
461 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
462 ,p_val => p_val
463 ,p_nnmntry_uom => p_nnmntry_uom
464 ,p_mx_elcn_val => p_mx_elcn_val
465 ,p_mn_elcn_val => p_mn_elcn_val
466 ,p_incrmt_elcn_val => p_incrmt_elcn_val
467 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
468 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
469 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
470 ,p_cmcd_val => p_cmcd_val
471 ,p_cmcd_dflt_val => p_cmcd_dflt_val
472 ,p_rt_usg_cd => p_rt_usg_cd
473 ,p_ann_dflt_val => p_ann_dflt_val
474 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
475 ,p_rt_mlt_cd => p_rt_mlt_cd
476 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
477 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
478 ,p_entr_ann_val_flag => p_entr_ann_val_flag
479 ,p_rt_strt_dt => p_rt_strt_dt
480 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
481 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
482 ,p_rt_typ_cd => p_rt_typ_cd
483 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
484 ,p_acty_base_rt_id => p_acty_base_rt_id
485 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
486 ,p_enrt_bnft_id => p_enrt_bnft_id
487 ,p_prtt_rt_val_id => p_prtt_rt_val_id
488 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
489 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
490 ,p_actl_prem_id => p_actl_prem_id
491 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
492 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
493 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
494 ,p_business_group_id => p_business_group_id
495 --cwb
496 ,p_iss_val => p_iss_val
497 ,p_val_last_upd_date => p_val_last_upd_date
498 ,p_val_last_upd_person_id => p_val_last_upd_person_id
499 --cwb
500 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
501 ,p_ecr_attribute_category => p_ecr_attribute_category
502 ,p_ecr_attribute1 => p_ecr_attribute1
503 ,p_ecr_attribute2 => p_ecr_attribute2
504 ,p_ecr_attribute3 => p_ecr_attribute3
505 ,p_ecr_attribute4 => p_ecr_attribute4
506 ,p_ecr_attribute5 => p_ecr_attribute5
507 ,p_ecr_attribute6 => p_ecr_attribute6
508 ,p_ecr_attribute7 => p_ecr_attribute7
509 ,p_ecr_attribute8 => p_ecr_attribute8
510 ,p_ecr_attribute9 => p_ecr_attribute9
511 ,p_ecr_attribute10 => p_ecr_attribute10
512 ,p_ecr_attribute11 => p_ecr_attribute11
513 ,p_ecr_attribute12 => p_ecr_attribute12
514 ,p_ecr_attribute13 => p_ecr_attribute13
515 ,p_ecr_attribute14 => p_ecr_attribute14
516 ,p_ecr_attribute15 => p_ecr_attribute15
517 ,p_ecr_attribute16 => p_ecr_attribute16
518 ,p_ecr_attribute17 => p_ecr_attribute17
519 ,p_ecr_attribute18 => p_ecr_attribute18
520 ,p_ecr_attribute19 => p_ecr_attribute19
521 ,p_ecr_attribute20 => p_ecr_attribute20
522 ,p_ecr_attribute21 => p_ecr_attribute21 ,p_ecr_attribute22 => p_ecr_attribute22
523 ,p_ecr_attribute23 => p_ecr_attribute23
524 ,p_ecr_attribute24 => p_ecr_attribute24
525 ,p_ecr_attribute25 => p_ecr_attribute25
526 ,p_ecr_attribute26 => p_ecr_attribute26
527 ,p_ecr_attribute27 => p_ecr_attribute27
528 ,p_ecr_attribute28 => p_ecr_attribute28
529 ,p_ecr_attribute29 => p_ecr_attribute29
530 ,p_ecr_attribute30 => p_ecr_attribute30
531 ,p_request_id => p_request_id
532 ,p_program_application_id => p_program_application_id
533 ,p_program_id => p_program_id
534 ,p_program_update_date => p_program_update_date
535 ,p_object_version_number => p_object_version_number
536 ,p_effective_date => trunc(p_effective_date)
537 );
538 --
539 begin
540 --
541 -- Start of API User Hook for the after hook of create_Enrollment_Rate
542 --
543 ben_Enrollment_Rate_bk1.create_Enrollment_Rate_a
544 (
545 p_enrt_rt_id => l_enrt_rt_id
546 ,p_ordr_num => p_ordr_num
547 ,p_acty_typ_cd => p_acty_typ_cd
548 ,p_tx_typ_cd => p_tx_typ_cd
549 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
550 ,p_dflt_flag => p_dflt_flag
551 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
552 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
553 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
554 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
555 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
556 ,p_rl_crs_only_flag => p_rl_crs_only_flag
557 ,p_dflt_val => p_dflt_val
558 ,p_ann_val => p_ann_val
559 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
560 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
561 ,p_val => p_val
562 ,p_nnmntry_uom => p_nnmntry_uom
563 ,p_mx_elcn_val => p_mx_elcn_val
564 ,p_mn_elcn_val => p_mn_elcn_val
565 ,p_incrmt_elcn_val => p_incrmt_elcn_val
566 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
567 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
568 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
569 ,p_cmcd_val => p_cmcd_val
570 ,p_cmcd_dflt_val => p_cmcd_dflt_val
571 ,p_rt_usg_cd => p_rt_usg_cd
572 ,p_ann_dflt_val => p_ann_dflt_val
573 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
574 ,p_rt_mlt_cd => p_rt_mlt_cd
575 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
576 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
577 ,p_entr_ann_val_flag => p_entr_ann_val_flag
578 ,p_rt_strt_dt => p_rt_strt_dt
579 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
580 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
581 ,p_rt_typ_cd => p_rt_typ_cd
582 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
583 ,p_acty_base_rt_id => p_acty_base_rt_id
584 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
585 ,p_enrt_bnft_id => p_enrt_bnft_id
586 ,p_prtt_rt_val_id => p_prtt_rt_val_id
587 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
588 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
589 ,p_actl_prem_id => p_actl_prem_id
590 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
591 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
592 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
593 ,p_business_group_id => p_business_group_id
594 --cwb
595 ,p_iss_val => p_iss_val
596 ,p_val_last_upd_date => p_val_last_upd_date
597 ,p_val_last_upd_person_id => p_val_last_upd_person_id
598 --cwb
599 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
600 ,p_ecr_attribute_category => p_ecr_attribute_category
601 ,p_ecr_attribute1 => p_ecr_attribute1
602 ,p_ecr_attribute2 => p_ecr_attribute2
603 ,p_ecr_attribute3 => p_ecr_attribute3
604 ,p_ecr_attribute4 => p_ecr_attribute4
605 ,p_ecr_attribute5 => p_ecr_attribute5
606 ,p_ecr_attribute6 => p_ecr_attribute6
607 ,p_ecr_attribute7 => p_ecr_attribute7
608 ,p_ecr_attribute8 => p_ecr_attribute8
609 ,p_ecr_attribute9 => p_ecr_attribute9
610 ,p_ecr_attribute10 => p_ecr_attribute10
611 ,p_ecr_attribute11 => p_ecr_attribute11
612 ,p_ecr_attribute12 => p_ecr_attribute12
613 ,p_ecr_attribute13 => p_ecr_attribute13
614 ,p_ecr_attribute14 => p_ecr_attribute14
615 ,p_ecr_attribute15 => p_ecr_attribute15
616 ,p_ecr_attribute16 => p_ecr_attribute16
617 ,p_ecr_attribute17 => p_ecr_attribute17
618 ,p_ecr_attribute18 => p_ecr_attribute18
619 ,p_ecr_attribute19 => p_ecr_attribute19
620 ,p_ecr_attribute20 => p_ecr_attribute20
621 ,p_ecr_attribute21 => p_ecr_attribute21
622 ,p_ecr_attribute22 => p_ecr_attribute22
623 ,p_ecr_attribute23 => p_ecr_attribute23
624 ,p_ecr_attribute24 => p_ecr_attribute24
625 ,p_ecr_attribute25 => p_ecr_attribute25
626 ,p_ecr_attribute26 => p_ecr_attribute26
627 ,p_ecr_attribute27 => p_ecr_attribute27
628 ,p_ecr_attribute28 => p_ecr_attribute28
629 ,p_ecr_attribute29 => p_ecr_attribute29
630 ,p_ecr_attribute30 => p_ecr_attribute30
631 ,p_request_id => p_request_id
632 ,p_program_application_id => p_program_application_id
633 ,p_program_id => p_program_id
634 ,p_program_update_date => p_program_update_date
635 ,p_object_version_number => p_object_version_number
636 ,p_effective_date => trunc(p_effective_date)
637 );
638 exception
639 when hr_api.cannot_find_prog_unit then
640 hr_api.cannot_find_prog_unit_error
641 (p_module_name => 'CREATE_Enrollment_Rate'
642 ,p_hook_type => 'AP'
643 );
644 --
645 -- End of API User Hook for the after hook of create_Enrollment_Rate
646 --
647 end;
648 --
649 hr_utility.set_location(l_proc, 60);
650 --
651 -- When in validation only mode raise the Validate_Enabled exception
652 --
653 if p_validate then
654 raise hr_api.validate_enabled;
655 end if;
656 --
657 -- Set all output arguments
658 --
659 p_enrt_rt_id := l_enrt_rt_id;
660 p_object_version_number := l_object_version_number;
661 --
662 hr_utility.set_location(' Leaving:'||l_proc, 70);
663 --
664 exception
665 --
666 when hr_api.validate_enabled then
667 --
668 -- As the Validate_Enabled exception has been raised
669 -- we must rollback to the savepoint
670 --
671 ROLLBACK TO create_Enrollment_Rate;
672 --
673 -- Only set output warning arguments
674 -- (Any key or derived arguments must be set to null
675 -- when validation only mode is being used.)
676 --
677 p_enrt_rt_id := null;
678 p_object_version_number := null;
679 hr_utility.set_location(' Leaving:'||l_proc, 80);
680 --
681 when others then
682 --
683 -- A validation or unexpected error has occured
684 --
685 ROLLBACK TO create_Enrollment_Rate;
686 --
687 p_enrt_rt_id := null;
688 p_object_version_number := null;
689 hr_utility.set_location(' Leaving:'||l_proc, 80);
690 --
691 raise;
692 --
693 end create_Enrollment_Rate;
694 --
695 -- ----------------------------------------------------------------------------
696 -- |------------------------< create_perf_ELIG_DPNT >-------------------------|
697 -- ----------------------------------------------------------------------------
698 --
699 procedure create_perf_Enrollment_Rate
700 (p_validate in boolean default false,
701 p_enrt_rt_id out nocopy NUMBER,
702 p_ordr_num in number default null,
703 p_acty_typ_cd in VARCHAR2 DEFAULT NULL,
704 p_tx_typ_cd in VARCHAR2 DEFAULT NULL,
705 p_ctfn_rqd_flag in VARCHAR2 DEFAULT 'N',
706 p_dflt_flag in VARCHAR2 DEFAULT 'N',
707 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT 'N',
708 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT 'N',
709 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT 'N',
710 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT 'N',
711 p_asn_on_enrt_flag in VARCHAR2 DEFAULT 'N',
712 p_rl_crs_only_flag in VARCHAR2 DEFAULT 'N',
713 p_dflt_val in NUMBER DEFAULT NULL,
714 p_ann_val in NUMBER DEFAULT NULL,
715 p_ann_mn_elcn_val in NUMBER DEFAULT NULL,
716 p_ann_mx_elcn_val in NUMBER DEFAULT NULL,
717 p_val in NUMBER DEFAULT NULL,
718 p_nnmntry_uom in VARCHAR2 DEFAULT NULL,
719 p_mx_elcn_val in NUMBER DEFAULT NULL,
720 p_mn_elcn_val in NUMBER DEFAULT NULL,
721 p_incrmt_elcn_val in NUMBER DEFAULT NULL,
722 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT NULL,
723 p_cmcd_mn_elcn_val in NUMBER DEFAULT NULL,
724 p_cmcd_mx_elcn_val in NUMBER DEFAULT NULL,
725 p_cmcd_val in NUMBER DEFAULT NULL,
726 p_cmcd_dflt_val in NUMBER DEFAULT NULL,
727 p_rt_usg_cd in VARCHAR2 DEFAULT NULL,
728 p_ann_dflt_val in NUMBER DEFAULT NULL,
729 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT NULL,
730 p_rt_mlt_cd in VARCHAR2 DEFAULT NULL,
731 p_dsply_mn_elcn_val in NUMBER DEFAULT NULL,
732 p_dsply_mx_elcn_val in NUMBER DEFAULT NULL,
733 p_entr_ann_val_flag in VARCHAR2,
734 p_rt_strt_dt in DATE DEFAULT NULL,
735 p_rt_strt_dt_cd in VARCHAR2 DEFAULT NULL,
736 p_rt_strt_dt_rl in NUMBER DEFAULT NULL,
737 p_rt_typ_cd in VARCHAR2 DEFAULT NULL,
738 p_elig_per_elctbl_chc_id in NUMBER DEFAULT NULL,
739 p_acty_base_rt_id in NUMBER DEFAULT NULL,
740 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT NULL,
741 p_enrt_bnft_id in NUMBER DEFAULT NULL,
742 p_prtt_rt_val_id in NUMBER DEFAULT NULL,
743 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT NULL,
744 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT NULL,
745 p_actl_prem_id in NUMBER DEFAULT NULL,
746 p_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
747 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
748 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
749 p_business_group_id in NUMBER,
750 --cwb
751 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
752 p_iss_val in number DEFAULT NULL,
753 p_val_last_upd_date in date DEFAULT NULL,
754 p_val_last_upd_person_id in number DEFAULT NULL,
755 --cwb
756 p_pp_in_yr_used_num in number default null,
757 p_ecr_attribute_category in VARCHAR2 DEFAULT NULL,
758 p_ecr_attribute1 in VARCHAR2 DEFAULT NULL,
759 p_ecr_attribute2 in VARCHAR2 DEFAULT NULL,
760 p_ecr_attribute3 in VARCHAR2 DEFAULT NULL,
761 p_ecr_attribute4 in VARCHAR2 DEFAULT NULL,
762 p_ecr_attribute5 in VARCHAR2 DEFAULT NULL,
763 p_ecr_attribute6 in VARCHAR2 DEFAULT NULL,
764 p_ecr_attribute7 in VARCHAR2 DEFAULT NULL,
765 p_ecr_attribute8 in VARCHAR2 DEFAULT NULL,
766 p_ecr_attribute9 in VARCHAR2 DEFAULT NULL,
767 p_ecr_attribute10 in VARCHAR2 DEFAULT NULL,
768 p_ecr_attribute11 in VARCHAR2 DEFAULT NULL,
769 p_ecr_attribute12 in VARCHAR2 DEFAULT NULL,
770 p_ecr_attribute13 in VARCHAR2 DEFAULT NULL,
771 p_ecr_attribute14 in VARCHAR2 DEFAULT NULL,
772 p_ecr_attribute15 in VARCHAR2 DEFAULT NULL,
773 p_ecr_attribute16 in VARCHAR2 DEFAULT NULL,
774 p_ecr_attribute17 in VARCHAR2 DEFAULT NULL,
775 p_ecr_attribute18 in VARCHAR2 DEFAULT NULL,
776 p_ecr_attribute19 in VARCHAR2 DEFAULT NULL,
777 p_ecr_attribute20 in VARCHAR2 DEFAULT NULL,
778 p_ecr_attribute21 in VARCHAR2 DEFAULT NULL,
779 p_ecr_attribute22 in VARCHAR2 DEFAULT NULL,
780 p_ecr_attribute23 in VARCHAR2 DEFAULT NULL,
781 p_ecr_attribute24 in VARCHAR2 DEFAULT NULL,
782 p_ecr_attribute25 in VARCHAR2 DEFAULT NULL,
783 p_ecr_attribute26 in VARCHAR2 DEFAULT NULL,
784 p_ecr_attribute27 in VARCHAR2 DEFAULT NULL,
785 p_ecr_attribute28 in VARCHAR2 DEFAULT NULL,
786 p_ecr_attribute29 in VARCHAR2 DEFAULT NULL,
787 p_ecr_attribute30 in VARCHAR2 DEFAULT NULL,
788 p_request_id in NUMBER DEFAULT NULL,
789 p_program_application_id in NUMBER DEFAULT NULL,
790 p_program_id in NUMBER DEFAULT NULL,
791 p_program_update_date in DATE DEFAULT NULL,
792 p_object_version_number out nocopy NUMBER,
793 p_effective_date in date
794 )
795 is
796 --
797 l_proc varchar2(72) := g_package||'create_perf_Enrollment_Rate';
798 --
799 -- Declare cursors and local variables
800 --
801 l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
802 l_object_version_number ben_enrt_rt.object_version_number%TYPE;
803 --
804 l_created_by ben_enrt_rt.created_by%TYPE;
805 l_creation_date ben_enrt_rt.creation_date%TYPE;
806 l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807 l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808 l_last_update_login ben_enrt_rt.last_update_login%TYPE;
809 --
810 Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;
811 --
812 l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
813 --
814 begin
815 --
816 hr_utility.set_location('Entering:'|| l_proc, 10);
817 --
818 -- Issue a savepoint if operating in validation only mode
819 --
820 savepoint create_perf_Enrollment_Rate;
821 --
822 -- Insert the row
823 --
824 -- Set the object version number for the insert
825 --
826 l_object_version_number := 1;
827 --
828 ben_ecr_shd.g_api_dml := true; -- Set the api dml status
829 --
830 -- Select the next sequence number
831 --
832 hr_utility.set_location('Insert ECR: '||l_proc, 5);
833 insert into ben_enrt_rt
834 (enrt_rt_id
835 ,ordr_num
836 ,acty_typ_cd
837 ,tx_typ_cd
838 ,ctfn_rqd_flag
839 ,dflt_flag
840 ,dflt_pndg_ctfn_flag
841 ,dsply_on_enrt_flag
842 ,use_to_calc_net_flx_cr_flag
843 ,entr_val_at_enrt_flag
844 ,asn_on_enrt_flag
845 ,rl_crs_only_flag
846 ,dflt_val
847 ,ann_val
848 ,ann_mn_elcn_val
849 ,ann_mx_elcn_val
850 ,val
851 ,nnmntry_uom
852 ,mx_elcn_val
853 ,mn_elcn_val
854 ,incrmt_elcn_val
855 ,cmcd_acty_ref_perd_cd
856 ,cmcd_mn_elcn_val
857 ,cmcd_mx_elcn_val
858 ,cmcd_val
859 ,cmcd_dflt_val
860 ,rt_usg_cd
861 ,ann_dflt_val
862 ,bnft_rt_typ_cd
863 ,rt_mlt_cd
864 ,dsply_mn_elcn_val
865 ,dsply_mx_elcn_val
866 ,entr_ann_val_flag
867 ,rt_strt_dt
868 ,rt_strt_dt_cd
869 ,rt_strt_dt_rl
870 ,rt_typ_cd
871 ,elig_per_elctbl_chc_id
872 ,acty_base_rt_id
873 ,spcl_rt_enrt_rt_id
874 ,enrt_bnft_id
875 ,prtt_rt_val_id
876 ,decr_bnft_prvdr_pool_id
877 ,cvg_amt_calc_mthd_id
878 ,actl_prem_id
879 ,comp_lvl_fctr_id
880 ,ptd_comp_lvl_fctr_id
881 ,clm_comp_lvl_fctr_id
882 ,business_group_id
883 --cwb
884 ,iss_val
885 ,val_last_upd_date
886 ,val_last_upd_person_id
887 --cwb
888 ,ecr_attribute_category
889 ,ecr_attribute1
890 ,ecr_attribute2
891 ,ecr_attribute3
892 ,ecr_attribute4
893 ,ecr_attribute5
894 ,ecr_attribute6
895 ,ecr_attribute7
896 ,ecr_attribute8
897 ,ecr_attribute9
898 ,ecr_attribute10
899 ,ecr_attribute11
900 ,ecr_attribute12
901 ,ecr_attribute13
902 ,ecr_attribute14
903 ,ecr_attribute15
904 ,ecr_attribute16
905 ,ecr_attribute17
906 ,ecr_attribute18
907 ,ecr_attribute19
908 ,ecr_attribute20
909 ,ecr_attribute21
910 ,ecr_attribute22
911 ,ecr_attribute23
912 ,ecr_attribute24
913 ,ecr_attribute25
914 ,ecr_attribute26
915 ,ecr_attribute27
916 ,ecr_attribute28
917 ,ecr_attribute29
918 ,ecr_attribute30
919 ,last_update_login
920 ,created_by
921 ,creation_date
922 ,last_updated_by
923 ,last_update_date
924 ,request_id
925 ,program_application_id
926 ,program_id
927 ,program_update_date
928 ,object_version_number
929 )
930 Values
931 (ben_enrt_rt_s.nextval
932 ,p_ordr_num
933 ,p_acty_typ_cd
934 ,p_tx_typ_cd
935 ,p_ctfn_rqd_flag
936 ,p_dflt_flag
937 ,p_dflt_pndg_ctfn_flag
938 ,p_dsply_on_enrt_flag
939 ,p_use_to_calc_net_flx_cr_flag
940 ,p_entr_val_at_enrt_flag
941 ,p_asn_on_enrt_flag
942 ,p_rl_crs_only_flag
943 ,p_dflt_val
944 ,p_ann_val
945 ,p_ann_mn_elcn_val
946 ,p_ann_mx_elcn_val
947 ,p_val
948 ,p_nnmntry_uom
949 ,p_mx_elcn_val
950 ,p_mn_elcn_val
951 ,p_incrmt_elcn_val
952 ,p_cmcd_acty_ref_perd_cd
953 ,p_cmcd_mn_elcn_val
954 ,p_cmcd_mx_elcn_val
955 ,p_cmcd_val
956 ,p_cmcd_dflt_val
957 ,p_rt_usg_cd
958 ,p_ann_dflt_val
959 ,p_bnft_rt_typ_cd
960 ,p_rt_mlt_cd
961 ,p_dsply_mn_elcn_val
962 ,p_dsply_mx_elcn_val
963 ,p_entr_ann_val_flag
964 ,p_rt_strt_dt
965 ,p_rt_strt_dt_cd
966 ,p_rt_strt_dt_rl
967 ,p_rt_typ_cd
968 ,p_elig_per_elctbl_chc_id
969 ,p_acty_base_rt_id
970 ,p_spcl_rt_enrt_rt_id
971 ,p_enrt_bnft_id
972 ,p_prtt_rt_val_id
973 ,p_decr_bnft_prvdr_pool_id
974 ,p_cvg_amt_calc_mthd_id
975 ,p_actl_prem_id
976 ,p_comp_lvl_fctr_id
977 ,p_ptd_comp_lvl_fctr_id
978 ,p_clm_comp_lvl_fctr_id
979 ,p_business_group_id
980 --cwb
981 ,p_iss_val
982 ,p_val_last_upd_date
983 ,p_val_last_upd_person_id
984 --cwb
985 ,p_ecr_attribute_category
986 ,p_ecr_attribute1
987 ,p_ecr_attribute2
988 ,p_ecr_attribute3
989 ,p_ecr_attribute4
990 ,p_ecr_attribute5
991 ,p_ecr_attribute6
992 ,p_ecr_attribute7
993 ,p_ecr_attribute8
994 ,p_ecr_attribute9
995 ,p_ecr_attribute10
996 ,p_ecr_attribute11
997 ,p_ecr_attribute12
998 ,p_ecr_attribute13
999 ,p_ecr_attribute14
1000 ,p_ecr_attribute15
1001 ,p_ecr_attribute16
1002 ,p_ecr_attribute17
1003 ,p_ecr_attribute18
1004 ,p_ecr_attribute19
1005 ,p_ecr_attribute20
1006 ,p_ecr_attribute21
1007 ,p_ecr_attribute22
1008 ,p_ecr_attribute23
1009 ,p_ecr_attribute24
1010 ,p_ecr_attribute25
1011 ,p_ecr_attribute26
1012 ,p_ecr_attribute27
1013 ,p_ecr_attribute28
1014 ,p_ecr_attribute29
1015 ,p_ecr_attribute30
1016 ,l_last_update_login
1017 ,l_created_by
1018 ,l_creation_date
1019 ,l_last_updated_by
1020 ,l_last_update_date
1021 ,p_request_id
1022 ,p_program_application_id
1023 ,p_program_id
1024 ,p_program_update_date
1025 ,l_object_version_number
1026 ) RETURNING enrt_rt_id into l_enrt_rt_id;
1027 hr_utility.set_location('Dn Insert: '||l_proc, 5);
1028 --
1029 ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
1030 --
1031 -- When in validation only mode raise the Validate_Enabled exception
1032 --
1033 if p_validate then
1034 raise hr_api.validate_enabled;
1035 end if;
1036 --
1037 -- Set all output arguments
1038 --
1039 p_enrt_rt_id := l_enrt_rt_id;
1040 p_object_version_number := l_object_version_number;
1041 --
1042 hr_utility.set_location(' Leaving:'||l_proc, 70);
1043 --
1044 exception
1045 --
1046 when hr_api.validate_enabled then
1047 --
1048 -- As the Validate_Enabled exception has been raised
1049 -- we must rollback to the savepoint
1050 --
1051 ROLLBACK TO create_perf_Enrollment_Rate;
1052 --
1053 -- Only set output warning arguments
1054 -- (Any key or derived arguments must be set to null
1055 -- when validation only mode is being used.)
1056 --
1057 p_enrt_rt_id := null;
1058 p_object_version_number := null;
1059 hr_utility.set_location(' Leaving:'||l_proc, 80);
1060 --
1061 when others then
1062 --
1063 -- A validation or unexpected error has occured
1064 --
1065 ROLLBACK TO create_perf_Enrollment_Rate;
1066 --
1067 p_enrt_rt_id := null;
1068 p_object_version_number := null;
1069 hr_utility.set_location(' Leaving:'||l_proc, 80);
1070 --
1071 raise;
1072 --
1073 end create_perf_Enrollment_Rate;
1074
1075 -- ----------------------------------------------------------------------------
1076 -- |------------------------< override_Enrollment_Rate >------------------------|
1077 -- ----------------------------------------------------------------------------
1078 -- {Start Of Comments}
1079 --
1080 -- Description:
1081 --
1082 -- Prerequisites:
1083 --
1084 --
1085 -- Post Success:
1086 --
1087 -- Name Type Description
1088 -- p_object_version_number No number OVN of record
1089 --
1090 -- Post Failure:
1091 --
1092 -- Access Status:
1093 -- Public.
1094 --
1095 -- {End Of Comments}
1096 --
1097 PROCEDURE override_Enrollment_Rate
1098 (
1099 p_validate in boolean default false,
1100 --
1101 p_person_id in NUMBER,
1102 --
1103 p_enrt_rt_id in NUMBER,
1104 p_ordr_num in number default hr_api.g_number,
1105 p_acty_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1106 p_tx_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1107 p_ctfn_rqd_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1108 p_dflt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1109 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1110 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1111 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1112 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1113 p_asn_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1114 p_rl_crs_only_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1115 p_dflt_val in NUMBER DEFAULT hr_api.g_number,
1116 --
1117 p_old_ann_val in NUMBER DEFAULT hr_api.g_number,
1118 --
1119 p_ann_val in NUMBER DEFAULT hr_api.g_number,
1120 p_ann_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1121 p_ann_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1122 --
1123 p_old_val in NUMBER DEFAULT hr_api.g_number,
1124 --
1125 p_val in NUMBER DEFAULT hr_api.g_number,
1126 p_nnmntry_uom in VARCHAR2 DEFAULT hr_api.g_varchar2,
1127 p_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1128 p_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1129 p_incrmt_elcn_val in NUMBER DEFAULT hr_api.g_number,
1130 --
1131 p_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1132 --
1133 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1134 p_cmcd_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1135 p_cmcd_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1136 p_cmcd_val in NUMBER DEFAULT hr_api.g_number,
1137 p_cmcd_dflt_val in NUMBER DEFAULT hr_api.g_number,
1138 p_rt_usg_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1139 p_ann_dflt_val in NUMBER DEFAULT hr_api.g_number,
1140 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1141 p_rt_mlt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1142 p_dsply_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1143 p_dsply_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1144 p_entr_ann_val_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1145 p_rt_strt_dt in DATE DEFAULT hr_api.g_date,
1146 p_rt_strt_dt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1147 p_rt_strt_dt_rl in NUMBER DEFAULT hr_api.g_number,
1148 p_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1149 p_elig_per_elctbl_chc_id in NUMBER DEFAULT hr_api.g_number,
1150 p_acty_base_rt_id in NUMBER DEFAULT hr_api.g_number,
1151 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT hr_api.g_number,
1152 p_enrt_bnft_id in NUMBER DEFAULT hr_api.g_number,
1153 p_prtt_rt_val_id in NUMBER DEFAULT hr_api.g_number,
1154 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT hr_api.g_number,
1155 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT hr_api.g_number,
1156 p_actl_prem_id in NUMBER DEFAULT hr_api.g_number,
1157 p_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
1158 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
1159 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
1160 p_business_group_id in NUMBER DEFAULT hr_api.g_number,
1161 --cwb
1162 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
1163 p_iss_val in number DEFAULT hr_api.g_number,
1164 p_val_last_upd_date in date DEFAULT hr_api.g_date,
1165 p_val_last_upd_person_id in number DEFAULT hr_api.g_number,
1166 --cwb
1167 p_pp_in_yr_used_num in number default hr_api.g_number,
1168 p_ecr_attribute_category in VARCHAR2 DEFAULT hr_api.g_varchar2,
1169 p_ecr_attribute1 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1170 p_ecr_attribute2 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1171 p_ecr_attribute3 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1172 p_ecr_attribute4 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1173 p_ecr_attribute5 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1174 p_ecr_attribute6 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1175 p_ecr_attribute7 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1176 p_ecr_attribute8 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1177 p_ecr_attribute9 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1178 p_ecr_attribute10 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1179 p_ecr_attribute11 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1180 p_ecr_attribute12 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1181 p_ecr_attribute13 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1182 p_ecr_attribute14 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1183 p_ecr_attribute15 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1184 p_ecr_attribute16 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1185 p_ecr_attribute17 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1186 p_ecr_attribute18 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1187 p_ecr_attribute19 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1188 p_ecr_attribute20 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1189 p_ecr_attribute21 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1190 p_ecr_attribute22 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1191 p_ecr_attribute23 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1192 p_ecr_attribute24 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1193 p_ecr_attribute25 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1194 p_ecr_attribute26 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1195 p_ecr_attribute27 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1196 p_ecr_attribute28 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1197 p_ecr_attribute29 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1198 p_ecr_attribute30 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1199 p_request_id in NUMBER DEFAULT hr_api.g_number,
1200 p_program_application_id in NUMBER DEFAULT hr_api.g_number,
1201 p_program_id in NUMBER DEFAULT hr_api.g_number,
1202 p_program_update_date in DATE DEFAULT hr_api.g_date,
1203 p_object_version_number in out nocopy NUMBER,
1204 p_effective_date in date
1205 ) IS
1206 l_ann_val number := p_ann_val;
1207 l_calc_ann_val number ;
1208 l_val number := p_val;
1209 l_cmcd_val number := p_cmcd_val;
1210 /*
1211 l_payroll_id number ;
1212 --
1213 cursor c_ass(p_person_id number,
1214 p_effective_date date ) is
1215 select
1216 payroll_id
1217 from
1218 per_all_assignments_f ass
1219 where
1220 ass.person_id = p_person_id
1221 and p_effective_date between ass.effective_start_date and ass.effective_end_date
1222 and primary_flag = 'Y'
1223 and assignment_type in ( 'E','B' ) ;
1224 */
1225 --
1226 --GEVITY
1227 cursor c_abr(cv_acty_base_rt_id number)
1228 is select rate_periodization_rl
1229 from ben_acty_base_rt_f abr
1230 where abr.acty_base_rt_id = cv_acty_base_rt_id
1231 and p_effective_date between abr.effective_start_date
1232 and abr.effective_end_date ;
1233 --
1234 l_rate_periodization_rl NUMBER;
1235 --
1236 l_dfnd_dummy number;
1237 l_ann_dummy number;
1238 l_cmcd_dummy number;
1239 l_assignment_id per_all_assignments_f.assignment_id%type;
1240 l_payroll_id per_all_assignments_f.payroll_id%type;
1241 l_organization_id per_all_assignments_f.organization_id%type;
1242 --END GEVITY
1243 begin
1244 --
1245 /*
1246 open c_ass(p_person_id,p_effective_date) ;
1247 --
1248 fetch c_ass into l_payroll_id ;
1249 --
1250 close c_ass;
1251 */
1252 ben_element_entry.get_abr_assignment
1253 (p_person_id => p_person_id
1254 ,p_effective_date => p_effective_date
1255 ,p_acty_base_rt_id => p_acty_base_rt_id
1256 ,p_organization_id => l_organization_id
1257 ,p_payroll_id => l_payroll_id
1258 ,p_assignment_id => l_assignment_id
1259 );
1260 --
1261 open c_abr(p_acty_base_rt_id) ;
1262 fetch c_abr into l_rate_periodization_rl ;
1263 close c_abr;
1264 --
1265 hr_utility.set_location(' p_val '||p_val ,99);
1266 hr_utility.set_location(' p_old_val'||p_old_val ,99);
1267 hr_utility.set_location(' p_ann_val '||p_ann_val ,99);
1268 hr_utility.set_location(' p_old_ann_val '||p_old_ann_val ,99);
1269 hr_utility.set_location(' p_cmcd_val '||p_cmcd_val ,99);
1270 --
1271 IF p_rt_typ_cd = 'PCT' then
1272 --
1273 if p_entr_ann_val_flag = 'Y' then
1274 --
1275 -- get values from annual value
1276 --
1277 if p_ann_val <> p_old_ann_val then
1278 --
1279 l_ann_val:=p_ann_val;
1280 l_val:=p_ann_val;
1281 l_cmcd_val:=p_ann_val;
1282 --
1283 end if;
1284 --
1285 else
1286 --
1287 if p_val <> p_old_val then
1288 --
1289 l_ann_val:=p_val;
1290 l_val:=p_val;
1291 l_cmcd_val:=p_val;
1292 --
1293 end if;
1294 --
1295 end if;
1296 --
1297 else -- If not PCT
1298 --
1299 if p_entr_ann_val_flag = 'Y' then
1300 --
1301 if p_ann_val <> p_old_ann_val then
1302 --
1303 -- use ann_val to drive other values
1304 hr_utility.set_location( 'Annula Flag = Y ' ,99);
1305 --
1306 l_ann_val := p_ann_val ;
1307 --GEVITY
1308 IF l_rate_periodization_rl IS NOT NULL THEN
1309 --
1310 l_ann_dummy := l_ann_val;
1311 --
1312 ben_distribute_rates.periodize_with_rule
1313 (p_formula_id => l_rate_periodization_rl
1314 ,p_effective_date => p_effective_date
1315 ,p_assignment_id => l_assignment_id
1316 ,p_convert_from_val => l_ann_dummy
1317 ,p_convert_from => 'ANNUAL'
1318 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1319 ,p_acty_base_rt_id => p_acty_base_rt_id
1320 ,p_business_group_id => p_business_group_id
1321 ,p_enrt_rt_id => p_enrt_rt_id
1322 ,p_ann_val => l_ann_val
1323 ,p_cmcd_val => l_cmcd_val
1324 ,p_val => l_val
1325 );
1326 --
1327 ELSE
1328 --
1329 l_val := ben_distribute_rates.annual_to_period
1330 (p_amount => l_ann_val,
1331 p_enrt_rt_id => p_enrt_rt_id,
1332 p_acty_ref_perd_cd => p_acty_ref_perd_cd,
1333 p_business_group_id => p_business_group_id,
1334 p_effective_date => p_effective_date,
1335 p_complete_year_flag => 'Y',
1336 p_use_balance_flag => 'Y',
1337 p_payroll_id => l_payroll_id);
1338 --
1339 l_calc_ann_val := ben_distribute_rates.period_to_annual
1340 (p_amount => l_val,
1341 p_enrt_rt_id => p_enrt_rt_id,
1342 p_acty_ref_perd_cd => p_acty_ref_perd_cd,
1343 p_business_group_id => p_business_group_id,
1344 p_effective_date => p_effective_date,
1345 p_complete_year_flag => 'Y',
1346 p_payroll_id => l_payroll_id);
1347 --
1348 --
1349 l_cmcd_val := ben_distribute_rates.annual_to_period
1350 (p_amount => l_calc_ann_val,
1351 p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1352 p_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd,
1353 p_business_group_id => p_business_group_id,
1354 p_effective_date => p_effective_date,
1355 -- p_complete_year_flag => 'Y',
1356 p_payroll_id => l_payroll_id);
1357 --
1358 END IF; --GEVITY
1359 hr_utility.set_location('l_calc_ann_val '||to_char(l_calc_ann_val), 319);
1360 hr_utility.set_location('p_cmcd_acty_ref_perd_cd '||p_cmcd_acty_ref_perd_cd, 319);
1361 hr_utility.set_location('l_cmcd_val '||l_cmcd_val , 319);
1362 --
1363 end if;
1364 --
1365 else
1366 --
1367 if p_val <> p_old_val then
1368 --
1369 l_val := p_val ;
1370 --GEVITY
1371 IF l_rate_periodization_rl IS NOT NULL THEN
1372 --
1373 l_dfnd_dummy := l_val;
1374 --
1375 ben_distribute_rates.periodize_with_rule
1376 (p_formula_id => l_rate_periodization_rl
1377 ,p_effective_date => p_effective_date
1378 ,p_assignment_id => l_assignment_id
1379 ,p_convert_from_val => l_dfnd_dummy
1380 ,p_convert_from => 'DEFINED'
1381 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1382 ,p_acty_base_rt_id => p_acty_base_rt_id
1383 ,p_business_group_id => p_business_group_id
1384 ,p_enrt_rt_id => p_enrt_rt_id
1385 ,p_ann_val => l_ann_val
1386 ,p_cmcd_val => l_cmcd_val
1387 ,p_val => l_val
1388 );
1389 --
1390 ELSE
1391 --
1392 l_ann_val := ben_distribute_rates.period_to_annual
1393 (p_amount => l_val,
1394 p_enrt_rt_id => p_enrt_rt_id,
1395 p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1396 p_acty_ref_perd_cd => p_acty_ref_perd_cd,
1397 p_business_group_id => p_business_group_id,
1398 p_effective_date => p_effective_date,
1399 p_complete_year_flag => 'Y',
1400 p_payroll_id => l_payroll_id);
1401
1402 --
1403 hr_utility.set_location( ' l_ann_val '||l_ann_val,99);
1404 hr_utility.set_location( ' l_payroll_id '||l_payroll_id,99);
1405 hr_utility.set_location( ' p_effective_date '||p_effective_date ,99);
1406 hr_utility.set_location( ' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,99);
1407 --
1408 l_cmcd_val := ben_distribute_rates.annual_to_period
1409 (p_amount => l_ann_val,
1410 p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1411 p_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd,
1412 p_business_group_id => p_business_group_id,
1413 p_effective_date => p_effective_date,
1414 p_complete_year_flag => 'Y',
1415 p_payroll_id => l_payroll_id );
1416
1417 --
1418 END IF; --GEVITY
1419 end if;
1420 --
1421 end if;
1422 --
1423 end if; -- PCT
1424 --
1425 --
1426 hr_utility.set_location(' l_val '||l_val ,99);
1427 hr_utility.set_location(' l_old_val'||p_old_val ,99);
1428 hr_utility.set_location(' l_ann_val '||l_ann_val ,99);
1429 hr_utility.set_location(' l_old_ann_val '||p_old_ann_val ,99);
1430 hr_utility.set_location(' l_cmcd_val '||l_cmcd_val ,99);
1431 --
1432
1433 ben_Enrollment_Rate_api.update_Enrollment_Rate
1434 (
1435 p_validate => p_validate
1436 ,p_enrt_rt_id => p_enrt_rt_id
1437 ,p_ordr_num => p_ordr_num
1438 ,p_acty_typ_cd => p_acty_typ_cd
1439 ,p_tx_typ_cd => p_tx_typ_cd
1440 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
1441 ,p_dflt_flag => p_dflt_flag
1442 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
1443 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1444 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
1445 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
1446 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
1447 ,p_rl_crs_only_flag => p_rl_crs_only_flag
1448 ,p_dflt_val => p_dflt_val
1449 ,p_ann_val => l_ann_val
1450 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1451 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1452 ,p_val => l_val
1453 ,p_nnmntry_uom => p_nnmntry_uom
1454 ,p_mx_elcn_val => p_mx_elcn_val
1455 ,p_mn_elcn_val => p_mn_elcn_val
1456 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1457 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
1458 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
1459 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
1460 ,p_cmcd_val => l_cmcd_val
1461 ,p_cmcd_dflt_val => p_cmcd_dflt_val
1462 ,p_rt_usg_cd => p_rt_usg_cd
1463 ,p_ann_dflt_val => p_ann_dflt_val
1464 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1465 ,p_rt_mlt_cd => p_rt_mlt_cd
1466 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
1467 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
1468 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1469 ,p_rt_strt_dt => p_rt_strt_dt
1470 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1471 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1472 ,p_rt_typ_cd => p_rt_typ_cd
1473 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1474 ,p_acty_base_rt_id => p_acty_base_rt_id
1475 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
1476 ,p_enrt_bnft_id => p_enrt_bnft_id
1477 ,p_prtt_rt_val_id => p_prtt_rt_val_id
1478 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
1479 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
1480 ,p_actl_prem_id => p_actl_prem_id
1481 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1482 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1483 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1484 ,p_business_group_id => p_business_group_id
1485 ,p_perf_min_max_edit => p_perf_min_max_edit
1486 ,p_iss_val => p_iss_val
1487 ,p_val_last_upd_date => p_val_last_upd_date
1488 ,p_val_last_upd_person_id => p_val_last_upd_person_id
1489 ,p_ecr_attribute_category => p_ecr_attribute_category
1490 ,p_ecr_attribute1 => p_ecr_attribute1
1491 ,p_ecr_attribute2 => p_ecr_attribute2
1492 ,p_ecr_attribute3 => p_ecr_attribute3
1493 ,p_ecr_attribute4 => p_ecr_attribute4
1494 ,p_ecr_attribute5 => p_ecr_attribute5
1495 ,p_ecr_attribute6 => p_ecr_attribute6
1496 ,p_ecr_attribute7 => p_ecr_attribute7
1497 ,p_ecr_attribute8 => p_ecr_attribute8
1498 ,p_ecr_attribute9 => p_ecr_attribute9
1499 ,p_ecr_attribute10 => p_ecr_attribute10
1500 ,p_ecr_attribute11 => p_ecr_attribute11
1501 ,p_ecr_attribute12 => p_ecr_attribute12
1502 ,p_ecr_attribute13 => p_ecr_attribute13
1503 ,p_ecr_attribute14 => p_ecr_attribute14
1504 ,p_ecr_attribute15 => p_ecr_attribute15
1505 ,p_ecr_attribute16 => p_ecr_attribute16
1506 ,p_ecr_attribute17 => p_ecr_attribute17
1507 ,p_ecr_attribute18 => p_ecr_attribute18
1508 ,p_ecr_attribute19 => p_ecr_attribute19
1509 ,p_ecr_attribute20 => p_ecr_attribute20
1510 ,p_ecr_attribute21 => p_ecr_attribute21
1511 ,p_ecr_attribute22 => p_ecr_attribute22
1512 ,p_ecr_attribute23 => p_ecr_attribute23
1513 ,p_ecr_attribute24 => p_ecr_attribute24
1514 ,p_ecr_attribute25 => p_ecr_attribute25
1515 ,p_ecr_attribute26 => p_ecr_attribute26
1516 ,p_ecr_attribute27 => p_ecr_attribute27
1517 ,p_ecr_attribute28 => p_ecr_attribute28
1518 ,p_ecr_attribute29 => p_ecr_attribute29
1519 ,p_ecr_attribute30 => p_ecr_attribute30
1520 ,p_request_id => p_request_id
1521 ,p_program_application_id => p_program_application_id
1522 ,p_program_id => p_program_id
1523 ,p_program_update_date => p_program_update_date
1524 ,p_object_version_number => p_object_version_number
1525 ,p_effective_date => p_effective_date
1526 );
1527 --
1528 exception
1529 when others then
1530 --
1531 -- A validation or unexpected error has occured
1532 --
1533 raise;
1534 --
1535 end override_Enrollment_Rate ;
1536 -- ----------------------------------------------------------------------------
1537 -- |------------------------< update_Enrollment_Rate >--- ------------------|
1538 -- ----------------------------------------------------------------------------
1539 --
1540 procedure update_Enrollment_Rate
1541 ( p_validate in boolean default false,
1542 p_enrt_rt_id in NUMBER,
1543 p_ordr_num in number default hr_api.g_number,
1544 p_acty_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1545 p_tx_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1546 p_ctfn_rqd_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1547 p_dflt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1548 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1549 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1550 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1551 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1552 p_asn_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1553 p_rl_crs_only_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1554 p_dflt_val in NUMBER DEFAULT hr_api.g_number,
1555 p_ann_val in NUMBER DEFAULT hr_api.g_number,
1556 p_ann_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1557 p_ann_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1558 p_val in NUMBER DEFAULT hr_api.g_number,
1559 p_nnmntry_uom in VARCHAR2 DEFAULT hr_api.g_varchar2,
1560 p_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1561 p_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1562 p_incrmt_elcn_val in NUMBER DEFAULT hr_api.g_number,
1563 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1564 p_cmcd_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1565 p_cmcd_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1566 p_cmcd_val in NUMBER DEFAULT hr_api.g_number,
1567 p_cmcd_dflt_val in NUMBER DEFAULT hr_api.g_number,
1568 p_rt_usg_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1569 p_ann_dflt_val in NUMBER DEFAULT hr_api.g_number,
1570 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1571 p_rt_mlt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1572 p_dsply_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
1573 p_dsply_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
1574 p_entr_ann_val_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
1575 p_rt_strt_dt in DATE DEFAULT hr_api.g_date,
1576 p_rt_strt_dt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1577 p_rt_strt_dt_rl in NUMBER DEFAULT hr_api.g_number,
1578 p_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
1579 p_elig_per_elctbl_chc_id in NUMBER DEFAULT hr_api.g_number,
1580 p_acty_base_rt_id in NUMBER DEFAULT hr_api.g_number,
1581 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT hr_api.g_number,
1582 p_enrt_bnft_id in NUMBER DEFAULT hr_api.g_number,
1583 p_prtt_rt_val_id in NUMBER DEFAULT hr_api.g_number,
1584 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT hr_api.g_number,
1585 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT hr_api.g_number,
1586 p_actl_prem_id in NUMBER DEFAULT hr_api.g_number,
1587 p_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
1588 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
1589 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
1590 p_business_group_id in NUMBER DEFAULT hr_api.g_number,
1591 --cwb
1592 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
1593 p_iss_val in number DEFAULT hr_api.g_number,
1594 p_val_last_upd_date in date DEFAULT hr_api.g_date,
1595 p_val_last_upd_person_id in number DEFAULT hr_api.g_number,
1596 --cwb
1597 p_pp_in_yr_used_num in number default hr_api.g_number,
1598 p_ecr_attribute_category in VARCHAR2 DEFAULT hr_api.g_varchar2,
1599 p_ecr_attribute1 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1600 p_ecr_attribute2 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1601 p_ecr_attribute3 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1602 p_ecr_attribute4 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1603 p_ecr_attribute5 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1604 p_ecr_attribute6 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1605 p_ecr_attribute7 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1606 p_ecr_attribute8 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1607 p_ecr_attribute9 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1608 p_ecr_attribute10 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1609 p_ecr_attribute11 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1610 p_ecr_attribute12 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1611 p_ecr_attribute13 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1612 p_ecr_attribute14 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1613 p_ecr_attribute15 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1614 p_ecr_attribute16 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1615 p_ecr_attribute17 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1616 p_ecr_attribute18 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1617 p_ecr_attribute19 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1618 p_ecr_attribute20 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1619 p_ecr_attribute21 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1620 p_ecr_attribute22 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1621 p_ecr_attribute23 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1622 p_ecr_attribute24 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1623 p_ecr_attribute25 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1624 p_ecr_attribute26 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1625 p_ecr_attribute27 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1626 p_ecr_attribute28 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1627 p_ecr_attribute29 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1628 p_ecr_attribute30 in VARCHAR2 DEFAULT hr_api.g_varchar2,
1629 p_request_id in NUMBER DEFAULT hr_api.g_number,
1630 p_program_application_id in NUMBER DEFAULT hr_api.g_number,
1631 p_program_id in NUMBER DEFAULT hr_api.g_number,
1632 p_program_update_date in DATE DEFAULT hr_api.g_date,
1633 p_object_version_number in out nocopy NUMBER,
1634 p_effective_date in date
1635 ) is
1636 --
1637 -- Declare cursors and local variables
1638 --
1639 cursor c_rate_vals is
1640 select mx_elcn_val , mn_elcn_val , incrmt_elcn_val , elig_per_elctbl_chc_id
1641 from ben_enrt_rt
1642 where enrt_rt_id = p_enrt_rt_id ;
1643 l_rate_vals c_rate_vals%rowtype;
1644 l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
1645 l_object_version_number ben_enrt_rt.object_version_number%TYPE;
1646 --
1647 begin
1648 --
1649 hr_utility.set_location('Entering:'|| l_proc, 10);
1650 --
1651 -- Issue a savepoint if operating in validation only mode
1652 --
1653 savepoint update_Enrollment_Rate;
1654 --
1655 hr_utility.set_location(l_proc, 20);
1656 --
1657 -- Process Logic
1658 --
1659 l_object_version_number := p_object_version_number;
1660 --
1661 begin
1662 --
1663 -- Start of API User Hook for the before hook of update_Enrollment_Rate
1664 --
1665 ben_Enrollment_Rate_bk2.update_Enrollment_Rate_b
1666 (
1667 p_enrt_rt_id => p_enrt_rt_id
1668 ,p_ordr_num => p_ordr_num
1669 ,p_acty_typ_cd => p_acty_typ_cd
1670 ,p_tx_typ_cd => p_tx_typ_cd
1671 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
1672 ,p_dflt_flag => p_dflt_flag
1673 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
1674 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1675 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
1676 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
1677 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
1678 ,p_rl_crs_only_flag => p_rl_crs_only_flag
1679 ,p_dflt_val => p_dflt_val
1680 ,p_ann_val => p_ann_val
1681 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1682 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1683 ,p_val => p_val
1684 ,p_nnmntry_uom => p_nnmntry_uom
1685 ,p_mx_elcn_val => p_mx_elcn_val
1686 ,p_mn_elcn_val => p_mn_elcn_val
1687 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1688 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
1689 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
1690 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
1691 ,p_cmcd_val => p_cmcd_val
1692 ,p_cmcd_dflt_val => p_cmcd_dflt_val
1693 ,p_rt_usg_cd => p_rt_usg_cd
1694 ,p_ann_dflt_val => p_ann_dflt_val
1695 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1696 ,p_rt_mlt_cd => p_rt_mlt_cd
1697 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
1698 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
1699 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1700 ,p_rt_strt_dt => p_rt_strt_dt
1701 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1702 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1703 ,p_rt_typ_cd => p_rt_typ_cd
1704 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1705 ,p_acty_base_rt_id => p_acty_base_rt_id
1706 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
1707 ,p_enrt_bnft_id => p_enrt_bnft_id
1708 ,p_prtt_rt_val_id => p_prtt_rt_val_id
1709 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
1710 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
1711 ,p_actl_prem_id => p_actl_prem_id
1712 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1713 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1714 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1715 ,p_business_group_id => p_business_group_id
1716 --cwb
1717 ,p_iss_val => p_iss_val
1718 ,p_val_last_upd_date => p_val_last_upd_date
1719 ,p_val_last_upd_person_id => p_val_last_upd_person_id
1720 --cwb
1721 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
1722 ,p_ecr_attribute_category => p_ecr_attribute_category
1723 ,p_ecr_attribute1 => p_ecr_attribute1
1724 ,p_ecr_attribute2 => p_ecr_attribute2
1725 ,p_ecr_attribute3 => p_ecr_attribute3
1726 ,p_ecr_attribute4 => p_ecr_attribute4
1727 ,p_ecr_attribute5 => p_ecr_attribute5
1728 ,p_ecr_attribute6 => p_ecr_attribute6
1729 ,p_ecr_attribute7 => p_ecr_attribute7
1730 ,p_ecr_attribute8 => p_ecr_attribute8
1731 ,p_ecr_attribute9 => p_ecr_attribute9
1732 ,p_ecr_attribute10 => p_ecr_attribute10
1733 ,p_ecr_attribute11 => p_ecr_attribute11
1734 ,p_ecr_attribute12 => p_ecr_attribute12
1735 ,p_ecr_attribute13 => p_ecr_attribute13
1736 ,p_ecr_attribute14 => p_ecr_attribute14
1737 ,p_ecr_attribute15 => p_ecr_attribute15
1738 ,p_ecr_attribute16 => p_ecr_attribute16
1739 ,p_ecr_attribute17 => p_ecr_attribute17
1740 ,p_ecr_attribute18 => p_ecr_attribute18
1741 ,p_ecr_attribute19 => p_ecr_attribute19
1742 ,p_ecr_attribute20 => p_ecr_attribute20
1743 ,p_ecr_attribute21 => p_ecr_attribute21
1744 ,p_ecr_attribute22 => p_ecr_attribute22
1745 ,p_ecr_attribute23 => p_ecr_attribute23
1746 ,p_ecr_attribute24 => p_ecr_attribute24
1747 ,p_ecr_attribute25 => p_ecr_attribute25
1748 ,p_ecr_attribute26 => p_ecr_attribute26
1749 ,p_ecr_attribute27 => p_ecr_attribute27
1750 ,p_ecr_attribute28 => p_ecr_attribute28
1751 ,p_ecr_attribute29 => p_ecr_attribute29
1752 ,p_ecr_attribute30 => p_ecr_attribute30
1753 ,p_request_id => p_request_id
1754 ,p_program_application_id => p_program_application_id
1755 ,p_program_id => p_program_id
1756 ,p_program_update_date => p_program_update_date
1757 ,p_object_version_number => p_object_version_number
1758 ,p_effective_date => trunc(p_effective_date)
1759 );
1760 exception
1761 when hr_api.cannot_find_prog_unit then
1762 hr_api.cannot_find_prog_unit_error
1763 (p_module_name => 'UPDATE_Enrollment_Rate'
1764 ,p_hook_type => 'BP'
1765 );
1766 --
1767 -- End of API User Hook for the before hook of update_Enrollment_Rate
1768 --
1769 end;
1770 --
1771 -- Bug : 2214948 -
1772 if p_perf_min_max_edit = 'Y' then
1773 --
1774 open c_rate_vals;
1775 fetch c_rate_vals into l_rate_vals;
1776 close c_rate_vals;
1777
1778 if (p_mx_elcn_val <> hr_api.g_number) then
1779 l_rate_vals.mx_elcn_val := p_mx_elcn_val;
1780 end if;
1781 if (p_mn_elcn_val <> hr_api.g_number ) then
1782 l_rate_vals.mn_elcn_val := p_mn_elcn_val;
1783 end if;
1784 if (p_incrmt_elcn_val <> hr_api.g_number) then
1785 l_rate_vals.incrmt_elcn_val := p_incrmt_elcn_val;
1786 end if;
1787
1788 if(p_elig_per_elctbl_chc_id <> hr_api.g_number) then
1789 l_rate_vals.elig_per_elctbl_chc_id := p_elig_per_elctbl_chc_id;
1790 end if;
1791
1792 chk_perf_min_max(p_val => p_val
1793 ,p_iss_val => p_iss_val
1794 ,p_mx_elcn_val => l_rate_vals.mx_elcn_val
1795 ,p_mn_elcn_val => l_rate_vals.mn_elcn_val
1796 ,p_enrt_rt_id => p_enrt_rt_id
1797 ,p_object_version_number => p_object_version_number
1798 ,p_elig_per_elctbl_chc_id => l_rate_vals.elig_per_elctbl_chc_id
1799 ,p_effective_date => trunc(p_effective_date)
1800 ,p_incrmt_elcn_val => l_rate_vals.incrmt_elcn_val);
1801 --
1802 end if;
1803 --
1804 ben_ecr_upd.upd
1805 (
1806 p_enrt_rt_id => p_enrt_rt_id
1807 ,p_ordr_num => p_ordr_num
1808 ,p_acty_typ_cd => p_acty_typ_cd
1809 ,p_tx_typ_cd => p_tx_typ_cd
1810 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
1811 ,p_dflt_flag => p_dflt_flag
1812 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
1813 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1814 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
1815 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
1816 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
1817 ,p_rl_crs_only_flag => p_rl_crs_only_flag
1818 ,p_dflt_val => p_dflt_val
1819 ,p_ann_val => p_ann_val
1820 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1821 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1822 ,p_val => p_val
1823 ,p_nnmntry_uom => p_nnmntry_uom
1824 ,p_mx_elcn_val => p_mx_elcn_val
1825 ,p_mn_elcn_val => p_mn_elcn_val
1826 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1827 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
1828 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
1829 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
1830 ,p_cmcd_val => p_cmcd_val
1831 ,p_cmcd_dflt_val => p_cmcd_dflt_val
1832 ,p_rt_usg_cd => p_rt_usg_cd
1833 ,p_ann_dflt_val => p_ann_dflt_val
1834 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1835 ,p_rt_mlt_cd => p_rt_mlt_cd
1836 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
1837 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
1838 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1839 ,p_rt_strt_dt => p_rt_strt_dt
1840 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1841 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1842 ,p_rt_typ_cd => p_rt_typ_cd
1843 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1844 ,p_acty_base_rt_id => p_acty_base_rt_id
1845 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
1846 ,p_enrt_bnft_id => p_enrt_bnft_id
1847 ,p_prtt_rt_val_id => p_prtt_rt_val_id
1848 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
1849 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
1850 ,p_actl_prem_id => p_actl_prem_id
1851 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1852 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1853 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1854 ,p_business_group_id => p_business_group_id
1855 --cwb
1856 ,p_iss_val => p_iss_val
1857 ,p_val_last_upd_date => p_val_last_upd_date
1858 ,p_val_last_upd_person_id => p_val_last_upd_person_id
1859 --cwb
1860 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
1861 ,p_ecr_attribute_category => p_ecr_attribute_category
1862 ,p_ecr_attribute1 => p_ecr_attribute1
1863 ,p_ecr_attribute2 => p_ecr_attribute2
1864 ,p_ecr_attribute3 => p_ecr_attribute3
1865 ,p_ecr_attribute4 => p_ecr_attribute4
1866 ,p_ecr_attribute5 => p_ecr_attribute5
1867 ,p_ecr_attribute6 => p_ecr_attribute6
1868 ,p_ecr_attribute7 => p_ecr_attribute7
1869 ,p_ecr_attribute8 => p_ecr_attribute8
1870 ,p_ecr_attribute9 => p_ecr_attribute9
1871 ,p_ecr_attribute10 => p_ecr_attribute10
1872 ,p_ecr_attribute11 => p_ecr_attribute11
1873 ,p_ecr_attribute12 => p_ecr_attribute12
1874 ,p_ecr_attribute13 => p_ecr_attribute13
1875 ,p_ecr_attribute14 => p_ecr_attribute14
1876 ,p_ecr_attribute15 => p_ecr_attribute15
1877 ,p_ecr_attribute16 => p_ecr_attribute16
1878 ,p_ecr_attribute17 => p_ecr_attribute17
1879 ,p_ecr_attribute18 => p_ecr_attribute18
1880 ,p_ecr_attribute19 => p_ecr_attribute19
1881 ,p_ecr_attribute20 => p_ecr_attribute20
1882 ,p_ecr_attribute21 => p_ecr_attribute21
1883 ,p_ecr_attribute22 => p_ecr_attribute22
1884 ,p_ecr_attribute23 => p_ecr_attribute23
1885 ,p_ecr_attribute24 => p_ecr_attribute24
1886 ,p_ecr_attribute25 => p_ecr_attribute25
1887 ,p_ecr_attribute26 => p_ecr_attribute26
1888 ,p_ecr_attribute27 => p_ecr_attribute27
1889 ,p_ecr_attribute28 => p_ecr_attribute28
1890 ,p_ecr_attribute29 => p_ecr_attribute29
1891 ,p_ecr_attribute30 => p_ecr_attribute30
1892 ,p_request_id => p_request_id
1893 ,p_program_application_id => p_program_application_id
1894 ,p_program_id => p_program_id
1895 ,p_program_update_date => p_program_update_date
1896 ,p_object_version_number => p_object_version_number
1897 ,p_effective_date => trunc(p_effective_date)
1898 );
1899 --
1900 begin
1901 --
1902 -- Start of API User Hook for the after hook of update_Enrollment_Rate
1903 --
1904 ben_Enrollment_Rate_bk2.update_Enrollment_Rate_a
1905 (
1906 p_enrt_rt_id => p_enrt_rt_id
1907 ,p_ordr_num => p_ordr_num
1908 ,p_acty_typ_cd => p_acty_typ_cd
1909 ,p_tx_typ_cd => p_tx_typ_cd
1910 ,p_ctfn_rqd_flag => p_ctfn_rqd_flag
1911 ,p_dflt_flag => p_dflt_flag
1912 ,p_dflt_pndg_ctfn_flag => p_dflt_pndg_ctfn_flag
1913 ,p_dsply_on_enrt_flag => p_dsply_on_enrt_flag
1914 ,p_use_to_calc_net_flx_cr_flag => p_use_to_calc_net_flx_cr_flag
1915 ,p_entr_val_at_enrt_flag => p_entr_val_at_enrt_flag
1916 ,p_asn_on_enrt_flag => p_asn_on_enrt_flag
1917 ,p_rl_crs_only_flag => p_rl_crs_only_flag
1918 ,p_dflt_val => p_dflt_val
1919 ,p_ann_val => p_ann_val
1920 ,p_ann_mn_elcn_val => p_ann_mn_elcn_val
1921 ,p_ann_mx_elcn_val => p_ann_mx_elcn_val
1922 ,p_val => p_val
1923 ,p_nnmntry_uom => p_nnmntry_uom
1924 ,p_mx_elcn_val => p_mx_elcn_val
1925 ,p_mn_elcn_val => p_mn_elcn_val
1926 ,p_incrmt_elcn_val => p_incrmt_elcn_val
1927 ,p_cmcd_acty_ref_perd_cd => p_cmcd_acty_ref_perd_cd
1928 ,p_cmcd_mn_elcn_val => p_cmcd_mn_elcn_val
1929 ,p_cmcd_mx_elcn_val => p_cmcd_mx_elcn_val
1930 ,p_cmcd_val => p_cmcd_val
1931 ,p_cmcd_dflt_val => p_cmcd_dflt_val
1932 ,p_rt_usg_cd => p_rt_usg_cd
1933 ,p_ann_dflt_val => p_ann_dflt_val
1934 ,p_bnft_rt_typ_cd => p_bnft_rt_typ_cd
1935 ,p_rt_mlt_cd => p_rt_mlt_cd
1936 ,p_dsply_mn_elcn_val => p_dsply_mn_elcn_val
1937 ,p_dsply_mx_elcn_val => p_dsply_mx_elcn_val
1938 ,p_entr_ann_val_flag => p_entr_ann_val_flag
1939 ,p_rt_strt_dt => p_rt_strt_dt
1940 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1941 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1942 ,p_rt_typ_cd => p_rt_typ_cd
1943 ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
1944 ,p_acty_base_rt_id => p_acty_base_rt_id
1945 ,p_spcl_rt_enrt_rt_id => p_spcl_rt_enrt_rt_id
1946 ,p_enrt_bnft_id => p_enrt_bnft_id
1947 ,p_prtt_rt_val_id => p_prtt_rt_val_id
1948 ,p_decr_bnft_prvdr_pool_id => p_decr_bnft_prvdr_pool_id
1949 ,p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id
1950 ,p_actl_prem_id => p_actl_prem_id
1951 ,p_comp_lvl_fctr_id => p_comp_lvl_fctr_id
1952 ,p_ptd_comp_lvl_fctr_id => p_ptd_comp_lvl_fctr_id
1953 ,p_clm_comp_lvl_fctr_id => p_clm_comp_lvl_fctr_id
1954 ,p_business_group_id => p_business_group_id
1955 --cwb
1956 ,p_iss_val => p_iss_val
1957 ,p_val_last_upd_date => p_val_last_upd_date
1958 ,p_val_last_upd_person_id => p_val_last_upd_person_id
1959 --cwb
1960 ,p_pp_in_yr_used_num => p_pp_in_yr_used_num
1961 ,p_ecr_attribute_category => p_ecr_attribute_category
1962 ,p_ecr_attribute1 => p_ecr_attribute1
1963 ,p_ecr_attribute2 => p_ecr_attribute2
1964 ,p_ecr_attribute3 => p_ecr_attribute3
1965 ,p_ecr_attribute4 => p_ecr_attribute4
1966 ,p_ecr_attribute5 => p_ecr_attribute5
1967 ,p_ecr_attribute6 => p_ecr_attribute6
1968 ,p_ecr_attribute7 => p_ecr_attribute7
1969 ,p_ecr_attribute8 => p_ecr_attribute8
1970 ,p_ecr_attribute9 => p_ecr_attribute9
1971 ,p_ecr_attribute10 => p_ecr_attribute10
1972 ,p_ecr_attribute11 => p_ecr_attribute11
1973 ,p_ecr_attribute12 => p_ecr_attribute12
1974 ,p_ecr_attribute13 => p_ecr_attribute13
1975 ,p_ecr_attribute14 => p_ecr_attribute14
1976 ,p_ecr_attribute15 => p_ecr_attribute15
1977 ,p_ecr_attribute16 => p_ecr_attribute16
1978 ,p_ecr_attribute17 => p_ecr_attribute17
1979 ,p_ecr_attribute18 => p_ecr_attribute18
1980 ,p_ecr_attribute19 => p_ecr_attribute19
1981 ,p_ecr_attribute20 => p_ecr_attribute20
1982 ,p_ecr_attribute21 => p_ecr_attribute21 ,p_ecr_attribute22 => p_ecr_attribute22
1983 ,p_ecr_attribute23 => p_ecr_attribute23
1984 ,p_ecr_attribute24 => p_ecr_attribute24
1985 ,p_ecr_attribute25 => p_ecr_attribute25
1986 ,p_ecr_attribute26 => p_ecr_attribute26
1987 ,p_ecr_attribute27 => p_ecr_attribute27
1988 ,p_ecr_attribute28 => p_ecr_attribute28
1989 ,p_ecr_attribute29 => p_ecr_attribute29
1990 ,p_ecr_attribute30 => p_ecr_attribute30
1991 ,p_request_id => p_request_id
1992 ,p_program_application_id => p_program_application_id
1993 ,p_program_id => p_program_id
1994 ,p_program_update_date => p_program_update_date
1995 ,p_object_version_number => p_object_version_number
1996 ,p_effective_date => trunc(p_effective_date)
1997 );
1998 exception
1999 when hr_api.cannot_find_prog_unit then
2000 hr_api.cannot_find_prog_unit_error
2001 (p_module_name => 'UPDATE_Enrollment_Rate'
2002 ,p_hook_type => 'AP'
2003 );
2004 --
2005 -- End of API User Hook for the after hook of update_Enrollment_Rate
2006 --
2007 end;
2008 --
2009 hr_utility.set_location(l_proc, 60);
2010 --
2011 -- When in validation only mode raise the Validate_Enabled exception
2012 --
2013 if p_validate then
2014 raise hr_api.validate_enabled;
2015 end if;
2016 --
2017 -- Set all output arguments
2018 --
2019 -- p_object_version_number := l_object_version_number;
2020 --
2021 hr_utility.set_location(' Leaving:'||l_proc, 70);
2022 --
2023 exception
2024 --
2025 when hr_api.validate_enabled then
2026 --
2027 -- As the Validate_Enabled exception has been raised
2028 -- we must rollback to the savepoint
2029 --
2030 ROLLBACK TO update_Enrollment_Rate;
2031 --
2032 -- Only set output warning arguments
2033 -- (Any key or derived arguments must be set to null
2034 -- when validation only mode is being used.)
2035 --
2036 hr_utility.set_location(' Leaving:'||l_proc, 80);
2037 --
2038 when others then
2039 --
2040 -- A validation or unexpected error has occured
2041 --
2042 ROLLBACK TO update_Enrollment_Rate;
2043 --
2044 p_object_version_number := l_object_version_number;
2045 hr_utility.set_location(' Leaving:'||l_proc, 80);
2046 --
2047 raise;
2048 --
2049 end update_Enrollment_Rate;
2050 -- ----------------------------------------------------------------------------
2051 -- |------------------------< delete_Enrollment_Rate >----------------------|
2052 -- ----------------------------------------------------------------------------
2053 --
2054 procedure delete_Enrollment_Rate
2055 (p_validate in boolean default false
2056 ,p_enrt_rt_id in number
2057 ,p_object_version_number in out nocopy number
2058 ,p_effective_date in date
2059 ) is
2060 --
2061 -- Declare cursors and local variables
2062 --
2063 l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
2064 l_object_version_number ben_enrt_rt.object_version_number%TYPE;
2065 --
2066 begin
2067 --
2068 hr_utility.set_location('Entering:'|| l_proc, 10);
2069 --
2070 -- Issue a savepoint if operating in validation only mode
2071 --
2072 savepoint delete_Enrollment_Rate;
2073 --
2074 hr_utility.set_location(l_proc, 20);
2075 --
2076 -- Process Logic
2077 --
2078 l_object_version_number := p_object_version_number;
2079 --
2080 --
2081 begin
2082 --
2083 -- Start of API User Hook for the before hook of delete_Enrollment_Rate
2084 --
2085 ben_Enrollment_Rate_bk3.delete_Enrollment_Rate_b
2086 (
2087 p_enrt_rt_id => p_enrt_rt_id
2088 ,p_object_version_number => p_object_version_number
2089 ,p_effective_date => trunc(p_effective_date)
2090 );
2091 exception
2092 when hr_api.cannot_find_prog_unit then
2093 hr_api.cannot_find_prog_unit_error
2094 (p_module_name => 'DELETE_Enrollment_Rate'
2095 ,p_hook_type => 'BP'
2096 );
2097 --
2098 -- End of API User Hook for the before hook of delete_Enrollment_Rate
2099 --
2100 end;
2101 --
2102 ben_ecr_del.del
2103 (
2104 p_enrt_rt_id => p_enrt_rt_id
2105 ,p_object_version_number => l_object_version_number
2106 ,p_effective_date => p_effective_date
2107 );
2108 --
2109 begin
2110 --
2111 -- Start of API User Hook for the after hook of delete_Enrollment_Rate
2112 --
2113 ben_Enrollment_Rate_bk3.delete_Enrollment_Rate_a
2114 (
2115 p_enrt_rt_id => p_enrt_rt_id
2116 ,p_object_version_number => l_object_version_number
2117 ,p_effective_date => trunc(p_effective_date)
2118 );
2119 exception
2120 when hr_api.cannot_find_prog_unit then
2121 hr_api.cannot_find_prog_unit_error
2122 (p_module_name => 'DELETE_Enrollment_Rate'
2123 ,p_hook_type => 'AP'
2124 );
2125 --
2126 -- End of API User Hook for the after hook of delete_Enrollment_Rate
2127 --
2128 end;
2129 --
2130 hr_utility.set_location(l_proc, 60);
2131 --
2132 -- When in validation only mode raise the Validate_Enabled exception
2133 --
2134 if p_validate then
2135 raise hr_api.validate_enabled;
2136 end if;
2137 --
2138 hr_utility.set_location(' Leaving:'||l_proc, 70);
2139 --
2140 exception
2141 --
2142 when hr_api.validate_enabled then
2143 --
2144 -- As the Validate_Enabled exception has been raised
2145 -- we must rollback to the savepoint
2146 --
2147 ROLLBACK TO delete_Enrollment_Rate;
2148 --
2149 -- Only set output warning arguments
2150 -- (Any key or derived arguments must be set to null
2151 -- when validation only mode is being used.)
2152 --
2153 --
2154 when others then
2155 --
2156 -- A validation or unexpected error has occured
2157 --
2158 ROLLBACK TO delete_Enrollment_Rate;
2159 --
2160 p_object_version_number := l_object_version_number;
2161 hr_utility.set_location(' Leaving:'||l_proc, 80);
2162 --
2163 raise;
2164 --
2165 end delete_Enrollment_Rate;
2166 --
2167 -- ----------------------------------------------------------------------------
2168 -- |-------------------------------< lck >------------------------------------|
2169 -- ----------------------------------------------------------------------------
2170 --
2171 procedure lck
2172 (
2173 p_enrt_rt_id in number
2174 ,p_object_version_number in number
2175 ) is
2176 --
2177 --
2178 -- Declare cursors and local variables
2179 --
2180 l_proc varchar2(72) := g_package||'lck';
2181 --
2182 begin
2183 --
2184 hr_utility.set_location('Entering:'|| l_proc, 10);
2185 --
2186 ben_ecr_shd.lck
2187 (
2188 p_enrt_rt_id => p_enrt_rt_id
2189 ,p_object_version_number => p_object_version_number
2190 );
2191 --
2192 hr_utility.set_location(' Leaving:'||l_proc, 70);
2193 --
2194 end lck;
2195 --
2196 end ben_Enrollment_Rate_api;