1 Package ben_Enrollment_Rate_api as
2 /* $Header: beecrapi.pkh 120.0 2005/05/28 01:52:52 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Enrollment_Rate >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- Post Success:
15 --
16 -- Out Parameters:
17 -- Name Type Description
18 -- p_enrt_rt_id Yes number PK of record
19 -- p_object_version_number No number OVN of record
20 --
21 -- Post Failure:
22 --
23 -- Access Status:
24 -- Public.
25 --
26 -- {End Of Comments}
27 --
28 g_perf_min_max_edit varchar2(30);
29 --
30 procedure create_Enrollment_Rate
31 (
32 p_validate in boolean default false,
33 p_enrt_rt_id out nocopy NUMBER,
34 p_ordr_num in number default null,
35 p_acty_typ_cd in VARCHAR2 DEFAULT NULL,
36 p_tx_typ_cd in VARCHAR2 DEFAULT NULL,
37 p_ctfn_rqd_flag in VARCHAR2 DEFAULT 'N',
38 p_dflt_flag in VARCHAR2 DEFAULT 'N',
39 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT 'N',
40 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT 'N',
41 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT 'N',
42 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT 'N',
43 p_asn_on_enrt_flag in VARCHAR2 DEFAULT 'N',
44 p_rl_crs_only_flag in VARCHAR2 DEFAULT 'N',
45 p_dflt_val in NUMBER DEFAULT NULL,
46 p_ann_val in NUMBER DEFAULT NULL,
47 p_ann_mn_elcn_val in NUMBER DEFAULT NULL,
48 p_ann_mx_elcn_val in NUMBER DEFAULT NULL,
49 p_val in NUMBER DEFAULT NULL,
50 p_nnmntry_uom in VARCHAR2 DEFAULT NULL,
51 p_mx_elcn_val in NUMBER DEFAULT NULL,
52 p_mn_elcn_val in NUMBER DEFAULT NULL,
53 p_incrmt_elcn_val in NUMBER DEFAULT NULL,
54 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT NULL,
55 p_cmcd_mn_elcn_val in NUMBER DEFAULT NULL,
56 p_cmcd_mx_elcn_val in NUMBER DEFAULT NULL,
57 p_cmcd_val in NUMBER DEFAULT NULL,
58 p_cmcd_dflt_val in NUMBER DEFAULT NULL,
59 p_rt_usg_cd in VARCHAR2 DEFAULT NULL,
60 p_ann_dflt_val in NUMBER DEFAULT NULL,
61 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT NULL,
62 p_rt_mlt_cd in VARCHAR2 DEFAULT NULL,
63 p_dsply_mn_elcn_val in NUMBER DEFAULT NULL,
64 p_dsply_mx_elcn_val in NUMBER DEFAULT NULL,
65 p_entr_ann_val_flag in VARCHAR2 DEFAULT 'N',
66 p_rt_strt_dt in DATE DEFAULT NULL,
67 p_rt_strt_dt_cd in VARCHAR2 DEFAULT NULL,
68 p_rt_strt_dt_rl in NUMBER DEFAULT NULL,
69 p_rt_typ_cd in VARCHAR2 DEFAULT NULL,
70 p_elig_per_elctbl_chc_id in NUMBER DEFAULT NULL,
71 p_acty_base_rt_id in NUMBER DEFAULT NULL,
72 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT NULL,
73 p_enrt_bnft_id in NUMBER DEFAULT NULL,
74 p_prtt_rt_val_id in NUMBER DEFAULT NULL,
75 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT NULL,
76 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT NULL,
77 p_actl_prem_id in NUMBER DEFAULT NULL,
78 p_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
79 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
80 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
81 p_business_group_id in NUMBER,
82 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
83 p_iss_val in number DEFAULT NULL,
84 p_val_last_upd_date in date DEFAULT NULL,
85 p_val_last_upd_person_id in number DEFAULT NULL,
86 p_pp_in_yr_used_num in number default null,
87 p_ecr_attribute_category in VARCHAR2 DEFAULT NULL,
88 p_ecr_attribute1 in VARCHAR2 DEFAULT NULL,
89 p_ecr_attribute2 in VARCHAR2 DEFAULT NULL,
90 p_ecr_attribute3 in VARCHAR2 DEFAULT NULL,
91 p_ecr_attribute4 in VARCHAR2 DEFAULT NULL,
92 p_ecr_attribute5 in VARCHAR2 DEFAULT NULL,
93 p_ecr_attribute6 in VARCHAR2 DEFAULT NULL,
94 p_ecr_attribute7 in VARCHAR2 DEFAULT NULL,
95 p_ecr_attribute8 in VARCHAR2 DEFAULT NULL,
96 p_ecr_attribute9 in VARCHAR2 DEFAULT NULL,
97 p_ecr_attribute10 in VARCHAR2 DEFAULT NULL,
98 p_ecr_attribute11 in VARCHAR2 DEFAULT NULL,
99 p_ecr_attribute12 in VARCHAR2 DEFAULT NULL,
100 p_ecr_attribute13 in VARCHAR2 DEFAULT NULL,
101 p_ecr_attribute14 in VARCHAR2 DEFAULT NULL,
102 p_ecr_attribute15 in VARCHAR2 DEFAULT NULL,
103 p_ecr_attribute16 in VARCHAR2 DEFAULT NULL,
104 p_ecr_attribute17 in VARCHAR2 DEFAULT NULL,
105 p_ecr_attribute18 in VARCHAR2 DEFAULT NULL,
106 p_ecr_attribute19 in VARCHAR2 DEFAULT NULL,
107 p_ecr_attribute20 in VARCHAR2 DEFAULT NULL,
108 p_ecr_attribute21 in VARCHAR2 DEFAULT NULL,
109 p_ecr_attribute22 in VARCHAR2 DEFAULT NULL,
110 p_ecr_attribute23 in VARCHAR2 DEFAULT NULL,
111 p_ecr_attribute24 in VARCHAR2 DEFAULT NULL,
112 p_ecr_attribute25 in VARCHAR2 DEFAULT NULL,
113 p_ecr_attribute26 in VARCHAR2 DEFAULT NULL,
114 p_ecr_attribute27 in VARCHAR2 DEFAULT NULL,
115 p_ecr_attribute28 in VARCHAR2 DEFAULT NULL,
116 p_ecr_attribute29 in VARCHAR2 DEFAULT NULL,
117 p_ecr_attribute30 in VARCHAR2 DEFAULT NULL,
118 p_request_id in NUMBER DEFAULT NULL,
119 p_program_application_id in NUMBER DEFAULT NULL,
120 p_program_id in NUMBER DEFAULT NULL,
121 p_program_update_date in DATE DEFAULT NULL,
122 p_object_version_number out nocopy NUMBER,
123 p_effective_date in date
124 );
125 --
126 -- Performance cover
127 --
128 procedure create_perf_Enrollment_Rate
129 (p_validate in boolean default false,
130 p_enrt_rt_id out nocopy NUMBER,
131 p_ordr_num in number default null,
132 p_acty_typ_cd in VARCHAR2 DEFAULT NULL,
133 p_tx_typ_cd in VARCHAR2 DEFAULT NULL,
134 p_ctfn_rqd_flag in VARCHAR2 DEFAULT 'N',
135 p_dflt_flag in VARCHAR2 DEFAULT 'N',
136 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT 'N',
137 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT 'N',
138 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT 'N',
139 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT 'N',
140 p_asn_on_enrt_flag in VARCHAR2 DEFAULT 'N',
141 p_rl_crs_only_flag in VARCHAR2 DEFAULT 'N',
142 p_dflt_val in NUMBER DEFAULT NULL,
143 p_ann_val in NUMBER DEFAULT NULL,
144 p_ann_mn_elcn_val in NUMBER DEFAULT NULL,
145 p_ann_mx_elcn_val in NUMBER DEFAULT NULL,
146 p_val in NUMBER DEFAULT NULL,
147 p_nnmntry_uom in VARCHAR2 DEFAULT NULL,
148 p_mx_elcn_val in NUMBER DEFAULT NULL,
149 p_mn_elcn_val in NUMBER DEFAULT NULL,
150 p_incrmt_elcn_val in NUMBER DEFAULT NULL,
151 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT NULL,
152 p_cmcd_mn_elcn_val in NUMBER DEFAULT NULL,
153 p_cmcd_mx_elcn_val in NUMBER DEFAULT NULL,
154 p_cmcd_val in NUMBER DEFAULT NULL,
155 p_cmcd_dflt_val in NUMBER DEFAULT NULL,
156 p_rt_usg_cd in VARCHAR2 DEFAULT NULL,
157 p_ann_dflt_val in NUMBER DEFAULT NULL,
158 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT NULL,
159 p_rt_mlt_cd in VARCHAR2 DEFAULT NULL,
160 p_dsply_mn_elcn_val in NUMBER DEFAULT NULL,
161 p_dsply_mx_elcn_val in NUMBER DEFAULT NULL,
162 p_entr_ann_val_flag in VARCHAR2,
163 p_rt_strt_dt in DATE DEFAULT NULL,
164 p_rt_strt_dt_cd in VARCHAR2 DEFAULT NULL,
165 p_rt_strt_dt_rl in NUMBER DEFAULT NULL,
166 p_rt_typ_cd in VARCHAR2 DEFAULT NULL,
167 p_elig_per_elctbl_chc_id in NUMBER DEFAULT NULL,
168 p_acty_base_rt_id in NUMBER DEFAULT NULL,
169 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT NULL,
170 p_enrt_bnft_id in NUMBER DEFAULT NULL,
171 p_prtt_rt_val_id in NUMBER DEFAULT NULL,
172 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT NULL,
173 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT NULL,
174 p_actl_prem_id in NUMBER DEFAULT NULL,
175 p_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
176 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
177 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT NULL,
178 p_business_group_id in NUMBER,
179 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
180 p_iss_val in number DEFAULT NULL,
181 p_val_last_upd_date in date DEFAULT NULL,
182 p_val_last_upd_person_id in number DEFAULT NULL,
183 p_pp_in_yr_used_num in number default null,
184 p_ecr_attribute_category in VARCHAR2 DEFAULT NULL,
185 p_ecr_attribute1 in VARCHAR2 DEFAULT NULL,
186 p_ecr_attribute2 in VARCHAR2 DEFAULT NULL,
187 p_ecr_attribute3 in VARCHAR2 DEFAULT NULL,
188 p_ecr_attribute4 in VARCHAR2 DEFAULT NULL,
189 p_ecr_attribute5 in VARCHAR2 DEFAULT NULL,
190 p_ecr_attribute6 in VARCHAR2 DEFAULT NULL,
191 p_ecr_attribute7 in VARCHAR2 DEFAULT NULL,
192 p_ecr_attribute8 in VARCHAR2 DEFAULT NULL,
193 p_ecr_attribute9 in VARCHAR2 DEFAULT NULL,
194 p_ecr_attribute10 in VARCHAR2 DEFAULT NULL,
195 p_ecr_attribute11 in VARCHAR2 DEFAULT NULL,
196 p_ecr_attribute12 in VARCHAR2 DEFAULT NULL,
197 p_ecr_attribute13 in VARCHAR2 DEFAULT NULL,
198 p_ecr_attribute14 in VARCHAR2 DEFAULT NULL,
199 p_ecr_attribute15 in VARCHAR2 DEFAULT NULL,
200 p_ecr_attribute16 in VARCHAR2 DEFAULT NULL,
201 p_ecr_attribute17 in VARCHAR2 DEFAULT NULL,
202 p_ecr_attribute18 in VARCHAR2 DEFAULT NULL,
203 p_ecr_attribute19 in VARCHAR2 DEFAULT NULL,
204 p_ecr_attribute20 in VARCHAR2 DEFAULT NULL,
205 p_ecr_attribute21 in VARCHAR2 DEFAULT NULL,
206 p_ecr_attribute22 in VARCHAR2 DEFAULT NULL,
207 p_ecr_attribute23 in VARCHAR2 DEFAULT NULL,
208 p_ecr_attribute24 in VARCHAR2 DEFAULT NULL,
209 p_ecr_attribute25 in VARCHAR2 DEFAULT NULL,
210 p_ecr_attribute26 in VARCHAR2 DEFAULT NULL,
211 p_ecr_attribute27 in VARCHAR2 DEFAULT NULL,
212 p_ecr_attribute28 in VARCHAR2 DEFAULT NULL,
213 p_ecr_attribute29 in VARCHAR2 DEFAULT NULL,
214 p_ecr_attribute30 in VARCHAR2 DEFAULT NULL,
215 p_request_id in NUMBER DEFAULT NULL,
216 p_program_application_id in NUMBER DEFAULT NULL,
217 p_program_id in NUMBER DEFAULT NULL,
218 p_program_update_date in DATE DEFAULT NULL,
219 p_object_version_number out nocopy NUMBER,
220 p_effective_date in date
221 );
222 -- ----------------------------------------------------------------------------
223 -- |------------------------< update_Enrollment_Rate >------------------------|
224 -- ----------------------------------------------------------------------------
225 -- {Start Of Comments}
226 --
227 -- Description:
228 --
229 -- Prerequisites:
230 --
231 --
232 -- Post Success:
233 --
234 -- Name Type Description
235 -- p_object_version_number No number OVN of record
236 --
237 -- Post Failure:
238 --
239 -- Access Status:
240 -- Public.
241 --
242 -- {End Of Comments}
243 --
244 procedure update_Enrollment_Rate
245 (
246 p_validate in boolean default false,
247 p_enrt_rt_id in NUMBER,
248 p_ordr_num in number default hr_api.g_number,
249 p_acty_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
250 p_tx_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
251 p_ctfn_rqd_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
252 p_dflt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
253 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
254 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
255 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
256 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
257 p_asn_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
258 p_rl_crs_only_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
259 p_dflt_val in NUMBER DEFAULT hr_api.g_number,
260 p_ann_val in NUMBER DEFAULT hr_api.g_number,
261 p_ann_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
262 p_ann_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
263 p_val in NUMBER DEFAULT hr_api.g_number,
264 p_nnmntry_uom in VARCHAR2 DEFAULT hr_api.g_varchar2,
265 p_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
266 p_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
267 p_incrmt_elcn_val in NUMBER DEFAULT hr_api.g_number,
268 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
269 p_cmcd_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
270 p_cmcd_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
271 p_cmcd_val in NUMBER DEFAULT hr_api.g_number,
272 p_cmcd_dflt_val in NUMBER DEFAULT hr_api.g_number,
273 p_rt_usg_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
274 p_ann_dflt_val in NUMBER DEFAULT hr_api.g_number,
275 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
276 p_rt_mlt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
277 p_dsply_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
278 p_dsply_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
279 p_entr_ann_val_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
280 p_rt_strt_dt in DATE DEFAULT hr_api.g_date,
281 p_rt_strt_dt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
282 p_rt_strt_dt_rl in NUMBER DEFAULT hr_api.g_number,
283 p_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
284 p_elig_per_elctbl_chc_id in NUMBER DEFAULT hr_api.g_number,
285 p_acty_base_rt_id in NUMBER DEFAULT hr_api.g_number,
286 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT hr_api.g_number,
287 p_enrt_bnft_id in NUMBER DEFAULT hr_api.g_number,
288 p_prtt_rt_val_id in NUMBER DEFAULT hr_api.g_number,
289 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT hr_api.g_number,
290 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT hr_api.g_number,
291 p_actl_prem_id in NUMBER DEFAULT hr_api.g_number,
292 p_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
293 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
294 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
295 p_business_group_id in NUMBER DEFAULT hr_api.g_number,
296 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
297 p_iss_val in number DEFAULT hr_api.g_number,
298 p_val_last_upd_date in date DEFAULT hr_api.g_date,
299 p_val_last_upd_person_id in number DEFAULT hr_api.g_number,
300 p_pp_in_yr_used_num in number default hr_api.g_number,
301 p_ecr_attribute_category in VARCHAR2 DEFAULT hr_api.g_varchar2,
305 p_ecr_attribute4 in VARCHAR2 DEFAULT hr_api.g_varchar2,
302 p_ecr_attribute1 in VARCHAR2 DEFAULT hr_api.g_varchar2,
303 p_ecr_attribute2 in VARCHAR2 DEFAULT hr_api.g_varchar2,
304 p_ecr_attribute3 in VARCHAR2 DEFAULT hr_api.g_varchar2,
306 p_ecr_attribute5 in VARCHAR2 DEFAULT hr_api.g_varchar2,
307 p_ecr_attribute6 in VARCHAR2 DEFAULT hr_api.g_varchar2,
308 p_ecr_attribute7 in VARCHAR2 DEFAULT hr_api.g_varchar2,
309 p_ecr_attribute8 in VARCHAR2 DEFAULT hr_api.g_varchar2,
310 p_ecr_attribute9 in VARCHAR2 DEFAULT hr_api.g_varchar2,
311 p_ecr_attribute10 in VARCHAR2 DEFAULT hr_api.g_varchar2,
312 p_ecr_attribute11 in VARCHAR2 DEFAULT hr_api.g_varchar2,
313 p_ecr_attribute12 in VARCHAR2 DEFAULT hr_api.g_varchar2,
314 p_ecr_attribute13 in VARCHAR2 DEFAULT hr_api.g_varchar2,
315 p_ecr_attribute14 in VARCHAR2 DEFAULT hr_api.g_varchar2,
316 p_ecr_attribute15 in VARCHAR2 DEFAULT hr_api.g_varchar2,
317 p_ecr_attribute16 in VARCHAR2 DEFAULT hr_api.g_varchar2,
318 p_ecr_attribute17 in VARCHAR2 DEFAULT hr_api.g_varchar2,
319 p_ecr_attribute18 in VARCHAR2 DEFAULT hr_api.g_varchar2,
320 p_ecr_attribute19 in VARCHAR2 DEFAULT hr_api.g_varchar2,
321 p_ecr_attribute20 in VARCHAR2 DEFAULT hr_api.g_varchar2,
322 p_ecr_attribute21 in VARCHAR2 DEFAULT hr_api.g_varchar2,
323 p_ecr_attribute22 in VARCHAR2 DEFAULT hr_api.g_varchar2,
324 p_ecr_attribute23 in VARCHAR2 DEFAULT hr_api.g_varchar2,
325 p_ecr_attribute24 in VARCHAR2 DEFAULT hr_api.g_varchar2,
326 p_ecr_attribute25 in VARCHAR2 DEFAULT hr_api.g_varchar2,
327 p_ecr_attribute26 in VARCHAR2 DEFAULT hr_api.g_varchar2,
328 p_ecr_attribute27 in VARCHAR2 DEFAULT hr_api.g_varchar2,
329 p_ecr_attribute28 in VARCHAR2 DEFAULT hr_api.g_varchar2,
330 p_ecr_attribute29 in VARCHAR2 DEFAULT hr_api.g_varchar2,
331 p_ecr_attribute30 in VARCHAR2 DEFAULT hr_api.g_varchar2,
332 p_request_id in NUMBER DEFAULT hr_api.g_number,
333 p_program_application_id in NUMBER DEFAULT hr_api.g_number,
334 p_program_id in NUMBER DEFAULT hr_api.g_number,
335 p_program_update_date in DATE DEFAULT hr_api.g_date,
336 p_object_version_number in out nocopy NUMBER,
337 p_effective_date in date
338 );
339 --
340 --
341 -- ----------------------------------------------------------------------------
342 -- |------------------------< override_Enrollment_Rate >------------------------|
343 -- ----------------------------------------------------------------------------
344 -- {Start Of Comments}
345 --
346 -- Description:
347 --
348 -- Prerequisites:
349 --
350 --
351 -- Post Success:
352 --
353 -- Name Type Description
354 -- p_object_version_number No number OVN of record
355 --
356 -- Post Failure:
357 --
358 -- Access Status:
359 -- Public.
360 --
361 -- {End Of Comments}
362 --
363 PROCEDURE override_Enrollment_Rate
364 (
365 p_validate in boolean default false,
366 --
367 p_person_id in NUMBER,
368 --
369 p_enrt_rt_id in NUMBER,
370 p_ordr_num in number default hr_api.g_number,
371 p_acty_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
372 p_tx_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
373 p_ctfn_rqd_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
374 p_dflt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
375 p_dflt_pndg_ctfn_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
376 p_dsply_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
377 p_use_to_calc_net_flx_cr_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
378 p_entr_val_at_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
379 p_asn_on_enrt_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
380 p_rl_crs_only_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
381 p_dflt_val in NUMBER DEFAULT hr_api.g_number,
382 --
383 p_old_ann_val in NUMBER DEFAULT hr_api.g_number,
384 --
385 p_ann_val in NUMBER DEFAULT hr_api.g_number,
386 p_ann_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
387 p_ann_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
388 --
389 p_old_val in NUMBER DEFAULT hr_api.g_number,
390 --
391 p_val in NUMBER DEFAULT hr_api.g_number,
392 p_nnmntry_uom in VARCHAR2 DEFAULT hr_api.g_varchar2,
393 p_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
394 p_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
395 p_incrmt_elcn_val in NUMBER DEFAULT hr_api.g_number,
396 --
397 p_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
398 --
399 p_cmcd_acty_ref_perd_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
400 p_cmcd_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
401 p_cmcd_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
405 p_ann_dflt_val in NUMBER DEFAULT hr_api.g_number,
402 p_cmcd_val in NUMBER DEFAULT hr_api.g_number,
403 p_cmcd_dflt_val in NUMBER DEFAULT hr_api.g_number,
404 p_rt_usg_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
406 p_bnft_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
407 p_rt_mlt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
408 p_dsply_mn_elcn_val in NUMBER DEFAULT hr_api.g_number,
409 p_dsply_mx_elcn_val in NUMBER DEFAULT hr_api.g_number,
410 p_entr_ann_val_flag in VARCHAR2 DEFAULT hr_api.g_varchar2,
411 p_rt_strt_dt in DATE DEFAULT hr_api.g_date,
412 p_rt_strt_dt_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
413 p_rt_strt_dt_rl in NUMBER DEFAULT hr_api.g_number,
414 p_rt_typ_cd in VARCHAR2 DEFAULT hr_api.g_varchar2,
415 p_elig_per_elctbl_chc_id in NUMBER DEFAULT hr_api.g_number,
416 p_acty_base_rt_id in NUMBER DEFAULT hr_api.g_number,
417 p_spcl_rt_enrt_rt_id in NUMBER DEFAULT hr_api.g_number,
418 p_enrt_bnft_id in NUMBER DEFAULT hr_api.g_number,
419 p_prtt_rt_val_id in NUMBER DEFAULT hr_api.g_number,
420 p_decr_bnft_prvdr_pool_id in NUMBER DEFAULT hr_api.g_number,
421 p_cvg_amt_calc_mthd_id in NUMBER DEFAULT hr_api.g_number,
422 p_actl_prem_id in NUMBER DEFAULT hr_api.g_number,
423 p_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
424 p_ptd_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
425 p_clm_comp_lvl_fctr_id in NUMBER DEFAULT hr_api.g_number,
426 p_business_group_id in NUMBER DEFAULT hr_api.g_number,
427 p_perf_min_max_edit in VARCHAR2 DEFAULT NULL,
428 p_iss_val in number DEFAULT hr_api.g_number,
429 p_val_last_upd_date in date DEFAULT hr_api.g_date,
430 p_val_last_upd_person_id in number DEFAULT hr_api.g_number,
431 p_pp_in_yr_used_num in number default hr_api.g_number,
432 p_ecr_attribute_category in VARCHAR2 DEFAULT hr_api.g_varchar2,
433 p_ecr_attribute1 in VARCHAR2 DEFAULT hr_api.g_varchar2,
434 p_ecr_attribute2 in VARCHAR2 DEFAULT hr_api.g_varchar2,
435 p_ecr_attribute3 in VARCHAR2 DEFAULT hr_api.g_varchar2,
436 p_ecr_attribute4 in VARCHAR2 DEFAULT hr_api.g_varchar2,
437 p_ecr_attribute5 in VARCHAR2 DEFAULT hr_api.g_varchar2,
438 p_ecr_attribute6 in VARCHAR2 DEFAULT hr_api.g_varchar2,
439 p_ecr_attribute7 in VARCHAR2 DEFAULT hr_api.g_varchar2,
440 p_ecr_attribute8 in VARCHAR2 DEFAULT hr_api.g_varchar2,
441 p_ecr_attribute9 in VARCHAR2 DEFAULT hr_api.g_varchar2,
442 p_ecr_attribute10 in VARCHAR2 DEFAULT hr_api.g_varchar2,
443 p_ecr_attribute11 in VARCHAR2 DEFAULT hr_api.g_varchar2,
444 p_ecr_attribute12 in VARCHAR2 DEFAULT hr_api.g_varchar2,
445 p_ecr_attribute13 in VARCHAR2 DEFAULT hr_api.g_varchar2,
446 p_ecr_attribute14 in VARCHAR2 DEFAULT hr_api.g_varchar2,
447 p_ecr_attribute15 in VARCHAR2 DEFAULT hr_api.g_varchar2,
448 p_ecr_attribute16 in VARCHAR2 DEFAULT hr_api.g_varchar2,
449 p_ecr_attribute17 in VARCHAR2 DEFAULT hr_api.g_varchar2,
450 p_ecr_attribute18 in VARCHAR2 DEFAULT hr_api.g_varchar2,
451 p_ecr_attribute19 in VARCHAR2 DEFAULT hr_api.g_varchar2,
452 p_ecr_attribute20 in VARCHAR2 DEFAULT hr_api.g_varchar2,
453 p_ecr_attribute21 in VARCHAR2 DEFAULT hr_api.g_varchar2,
454 p_ecr_attribute22 in VARCHAR2 DEFAULT hr_api.g_varchar2,
455 p_ecr_attribute23 in VARCHAR2 DEFAULT hr_api.g_varchar2,
456 p_ecr_attribute24 in VARCHAR2 DEFAULT hr_api.g_varchar2,
457 p_ecr_attribute25 in VARCHAR2 DEFAULT hr_api.g_varchar2,
458 p_ecr_attribute26 in VARCHAR2 DEFAULT hr_api.g_varchar2,
459 p_ecr_attribute27 in VARCHAR2 DEFAULT hr_api.g_varchar2,
460 p_ecr_attribute28 in VARCHAR2 DEFAULT hr_api.g_varchar2,
461 p_ecr_attribute29 in VARCHAR2 DEFAULT hr_api.g_varchar2,
462 p_ecr_attribute30 in VARCHAR2 DEFAULT hr_api.g_varchar2,
463 p_request_id in NUMBER DEFAULT hr_api.g_number,
464 p_program_application_id in NUMBER DEFAULT hr_api.g_number,
465 p_program_id in NUMBER DEFAULT hr_api.g_number,
466 p_program_update_date in DATE DEFAULT hr_api.g_date,
467 p_object_version_number in out nocopy NUMBER,
468 p_effective_date in date
469 ) ;
470 -- ----------------------------------------------------------------------------
471 -- |------------------------< delete_Enrollment_Rate >------------------------|
472 -- ----------------------------------------------------------------------------
473 -- {Start Of Comments}
474 --
475 -- Description:
476 --
477 -- Prerequisites:
478 --
479 --
480 -- In Parameters:
481 -- Name Reqd Type Description
482 -- p_validate Yes boolean Commit or Rollback.
483 -- p_enrt_rt_id Yes number PK of record
484 -- p_effective_date Yes date Session Date.
485 --
486 -- Post Success:
487 --
488 -- Name Type Description
489 -- p_object_version_number No number OVN of record
490 --
491 -- Post Failure:
492 --
493 -- Access Status:
494 -- Public.
495 --
496 -- {End Of Comments}
497 --
498 procedure delete_Enrollment_Rate
499 (
500 p_validate in boolean default false
501 ,p_enrt_rt_id in number
502 ,p_object_version_number in out nocopy number
503 ,p_effective_date in date
504 );
505 --
506 -- ----------------------------------------------------------------------------
507 -- |----------------------------------< lck >---------------------------------|
508 -- ----------------------------------------------------------------------------
509 -- {Start Of Comments}
510 --
511 -- Description:
512 --
513 -- Prerequisites:
514 --
515 --
516 -- In Parameters:
517 -- Name Reqd Type Description
518 -- p_enrt_rt_id Yes number PK of record
519 -- p_object_version_number Yes number OVN of record
520 --
521 -- Post Success:
522 --
523 -- Name Type Description
524 --
525 -- Post Failure:
526 --
527 -- Access Status:
528 -- Public.
529 --
530 -- {End Of Comments}
531 --
532 procedure lck
533 (
534 p_enrt_rt_id in number
535 ,p_object_version_number in number
536 );
537 --
538 end ben_Enrollment_Rate_api;