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