1 Package ben_benefit_actions_api AUTHID CURRENT_USER as
2 /* $Header: bebftapi.pkh 120.0 2005/05/28 00:40:35 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_benefit_actions >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_process_date Yes date
18 -- p_uneai_effective_date No date
19 -- p_mode_cd Yes varchar2
20 -- p_derivable_factors_flag Yes varchar2
21 -- p_close_uneai_flag No varchar2
22 -- p_validate_flag Yes varchar2
23 -- p_person_id No number
24 -- p_person_type_id No number
25 -- p_pgm_id No number
26 -- p_business_group_id Yes number Business Group of Record
27 -- p_pl_id No number
28 -- p_popl_enrt_typ_cycl_id No number
29 -- p_no_programs_flag Yes varchar2
30 -- p_no_plans_flag Yes varchar2
31 -- p_comp_selection_rl No number
32 -- p_person_selection_rl No number
33 -- p_ler_id No number
34 -- p_organization_id No number
35 -- p_benfts_grp_id No number
36 -- p_location_id No number
37 -- p_pstl_zip_rng_id No number
38 -- p_rptg_grp_id No number
39 -- p_pl_typ_id No number
40 -- p_opt_id No number
41 -- p_eligy_prfl_id No number
42 -- p_vrbl_rt_prfl_id No number
43 -- p_legal_entity_id No number
44 -- p_payroll_id No number
45 -- p_debug_messages_flag Yes varchar2
46 -- p_cm_trgr_typ_cd No varchar2
47 -- p_cm_typ_id No number
48 -- p_age_fctr_id No number
49 -- p_min_age No number
50 -- p_max_age No number
51 -- p_los_fctr_id No number
52 -- p_min_los No number
53 -- p_max_los No number
54 -- p_cmbn_age_los_fctr_id No number
55 -- p_min_cmbn No number
56 -- p_max_cmbn No number
57 -- p_date_from No date
58 -- p_elig_enrol_cd No varchar2
59 -- p_actn_typ_id No number
60 -- p_use_fctr_to_sel_flag No varchar2
61 -- p_los_det_to_use_cd No varchar2
62 -- p_audit_log_flag No varchar2
63 -- p_lmt_prpnip_by_org_flag No varchar2
64 -- p_bft_attribute_category No varchar2 Descriptive Flexfield
65 -- p_bft_attribute1 No varchar2 Descriptive Flexfield
66 -- p_bft_attribute3 No varchar2 Descriptive Flexfield
67 -- p_bft_attribute4 No varchar2 Descriptive Flexfield
68 -- p_bft_attribute5 No varchar2 Descriptive Flexfield
69 -- p_bft_attribute6 No varchar2 Descriptive Flexfield
70 -- p_bft_attribute7 No varchar2 Descriptive Flexfield
71 -- p_bft_attribute8 No varchar2 Descriptive Flexfield
72 -- p_bft_attribute9 No varchar2 Descriptive Flexfield
73 -- p_bft_attribute10 No varchar2 Descriptive Flexfield
74 -- p_bft_attribute11 No varchar2 Descriptive Flexfield
75 -- p_bft_attribute12 No varchar2 Descriptive Flexfield
76 -- p_bft_attribute13 No varchar2 Descriptive Flexfield
77 -- p_bft_attribute14 No varchar2 Descriptive Flexfield
78 -- p_bft_attribute15 No varchar2 Descriptive Flexfield
79 -- p_bft_attribute16 No varchar2 Descriptive Flexfield
80 -- p_bft_attribute17 No varchar2 Descriptive Flexfield
81 -- p_bft_attribute18 No varchar2 Descriptive Flexfield
82 -- p_bft_attribute19 No varchar2 Descriptive Flexfield
83 -- p_bft_attribute20 No varchar2 Descriptive Flexfield
84 -- p_bft_attribute21 No varchar2 Descriptive Flexfield
85 -- p_bft_attribute22 No varchar2 Descriptive Flexfield
86 -- p_bft_attribute23 No varchar2 Descriptive Flexfield
87 -- p_bft_attribute24 No varchar2 Descriptive Flexfield
88 -- p_bft_attribute25 No varchar2 Descriptive Flexfield
89 -- p_bft_attribute26 No varchar2 Descriptive Flexfield
90 -- p_bft_attribute27 No varchar2 Descriptive Flexfield
91 -- p_bft_attribute28 No varchar2 Descriptive Flexfield
92 -- p_bft_attribute29 No varchar2 Descriptive Flexfield
93 -- p_bft_attribute30 No varchar2 Descriptive Flexfield
94 -- p_effective_date Yes date Session Date.
95 --
96 -- Post Success:
97 --
98 -- Out Parameters:
99 -- Name Type Description
100 -- p_benefit_action_id Yes number PK of record
101 -- p_object_version_number No number OVN of record
102 --
103 -- Post Failure:
104 --
105 -- Access Status:
106 -- Public.
107 --
108 -- {End Of Comments}
109 --
110 procedure create_benefit_actions
111 (
112 p_validate in boolean default false
113 ,p_benefit_action_id out nocopy number
114 ,p_process_date in date default null
115 ,p_uneai_effective_date in date default null
116 ,p_mode_cd in varchar2 default null
117 ,p_derivable_factors_flag in varchar2 default null
118 ,p_close_uneai_flag in varchar2 default 'N'
119 ,p_validate_flag in varchar2 default null
120 ,p_person_id in number default null
121 ,p_person_type_id in number default null
122 ,p_pgm_id in number default null
123 ,p_business_group_id in number default null
124 ,p_pl_id in number default null
125 ,p_popl_enrt_typ_cycl_id in number default null
126 ,p_no_programs_flag in varchar2 default null
127 ,p_no_plans_flag in varchar2 default null
128 ,p_comp_selection_rl in number default null
132 ,p_benfts_grp_id in number default null
129 ,p_person_selection_rl in number default null
130 ,p_ler_id in number default null
131 ,p_organization_id in number default null
133 ,p_location_id in number default null
134 ,p_pstl_zip_rng_id in number default null
135 ,p_rptg_grp_id in number default null
136 ,p_pl_typ_id in number default null
137 ,p_opt_id in number default null
138 ,p_eligy_prfl_id in number default null
139 ,p_vrbl_rt_prfl_id in number default null
140 ,p_legal_entity_id in number default null
141 ,p_payroll_id in number default null
142 ,p_debug_messages_flag in varchar2 default null
143 ,p_cm_trgr_typ_cd in varchar2 default null
144 ,p_cm_typ_id in number default null
145 ,p_age_fctr_id in number default null
146 ,p_min_age in number default null
147 ,p_max_age in number default null
148 ,p_los_fctr_id in number default null
149 ,p_min_los in number default null
150 ,p_max_los in number default null
151 ,p_cmbn_age_los_fctr_id in number default null
152 ,p_min_cmbn in number default null
153 ,p_max_cmbn in number default null
154 ,p_date_from in date default null
155 ,p_elig_enrol_cd in varchar2 default null
156 ,p_actn_typ_id in number default null
157 ,p_use_fctr_to_sel_flag in varchar2 default 'N'
158 ,p_los_det_to_use_cd in varchar2 default null
159 ,p_audit_log_flag in varchar2 default 'N'
160 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
161 ,p_lf_evt_ocrd_dt in date default null
162 ,p_ptnl_ler_for_per_stat_cd in varchar2 default null
163 ,p_bft_attribute_category in varchar2 default null
164 ,p_bft_attribute1 in varchar2 default null
165 ,p_bft_attribute3 in varchar2 default null
166 ,p_bft_attribute4 in varchar2 default null
167 ,p_bft_attribute5 in varchar2 default null
168 ,p_bft_attribute6 in varchar2 default null
169 ,p_bft_attribute7 in varchar2 default null
170 ,p_bft_attribute8 in varchar2 default null
171 ,p_bft_attribute9 in varchar2 default null
172 ,p_bft_attribute10 in varchar2 default null
173 ,p_bft_attribute11 in varchar2 default null
174 ,p_bft_attribute12 in varchar2 default null
175 ,p_bft_attribute13 in varchar2 default null
176 ,p_bft_attribute14 in varchar2 default null
177 ,p_bft_attribute15 in varchar2 default null
178 ,p_bft_attribute16 in varchar2 default null
179 ,p_bft_attribute17 in varchar2 default null
180 ,p_bft_attribute18 in varchar2 default null
181 ,p_bft_attribute19 in varchar2 default null
182 ,p_bft_attribute20 in varchar2 default null
183 ,p_bft_attribute21 in varchar2 default null
184 ,p_bft_attribute22 in varchar2 default null
185 ,p_bft_attribute23 in varchar2 default null
186 ,p_bft_attribute24 in varchar2 default null
187 ,p_bft_attribute25 in varchar2 default null
188 ,p_bft_attribute26 in varchar2 default null
189 ,p_bft_attribute27 in varchar2 default null
190 ,p_bft_attribute28 in varchar2 default null
191 ,p_bft_attribute29 in varchar2 default null
192 ,p_bft_attribute30 in varchar2 default null
193 ,p_request_id in number default null
194 ,p_program_application_id in number default null
195 ,p_program_id in number default null
196 ,p_program_update_date in date default null
197 ,p_object_version_number out nocopy number
198 ,p_effective_date in date
199 ,p_enrt_perd_id in number default null
200 ,p_inelg_action_cd in varchar2 default null
201 ,p_org_hierarchy_id in number default null
202 ,p_org_starting_node_id in number default null
203 ,p_grade_ladder_id in number default null
204 ,p_asg_events_to_all_sel_dt in varchar2 default null
205 ,p_rate_id in number default null
206 ,p_per_sel_dt_cd in varchar2 default null
207 ,p_per_sel_freq_cd in varchar2 default null
208 ,p_per_sel_dt_from in date default null
209 ,p_per_sel_dt_to in date default null
210 ,p_year_from in number default null
211 ,p_year_to in number default null
212 ,p_cagr_id in number default null
213 ,p_qual_type in number default null
214 ,p_qual_status in varchar2 default null
215 ,p_concat_segs in varchar2 default null
216 ,p_grant_price_val in number default null
217 );
218 -- ----------------------------------------------------------------------------
219 -- |------------------------< create_perf_benefit_actions >-------------------|
223 -- Description:
220 -- ----------------------------------------------------------------------------
221 -- {Start Of Comments}
222 --
224 --
225 -- Prerequisites:
226 --
227 --
228 -- In Parameters:
229 -- Name Reqd Type Description
230 -- p_validate Yes boolean Commit or Rollback.
231 -- p_process_date Yes date
232 -- p_uneai_effective_date No date
233 -- p_mode_cd Yes varchar2
234 -- p_derivable_factors_flag Yes varchar2
235 -- p_close_uneai_flag No varchar2
236 -- p_validate_flag Yes varchar2
237 -- p_person_id No number
238 -- p_person_type_id No number
239 -- p_pgm_id No number
240 -- p_business_group_id Yes number Business Group of Record
241 -- p_pl_id No number
242 -- p_popl_enrt_typ_cycl_id No number
243 -- p_no_programs_flag Yes varchar2
244 -- p_no_plans_flag Yes varchar2
245 -- p_comp_selection_rl No number
246 -- p_person_selection_rl No number
247 -- p_ler_id No number
248 -- p_organization_id No number
249 -- p_benfts_grp_id No number
250 -- p_location_id No number
251 -- p_pstl_zip_rng_id No number
252 -- p_rptg_grp_id No number
253 -- p_pl_typ_id No number
254 -- p_opt_id No number
255 -- p_eligy_prfl_id No number
256 -- p_vrbl_rt_prfl_id No number
257 -- p_legal_entity_id No number
258 -- p_payroll_id No number
259 -- p_debug_messages_flag Yes varchar2
260 -- p_cm_trgr_typ_cd No varchar2
261 -- p_cm_typ_id No number
262 -- p_age_fctr_id No number
263 -- p_min_age No number
264 -- p_max_age No number
265 -- p_los_fctr_id No number
266 -- p_min_los No number
267 -- p_max_los No number
268 -- p_cmbn_age_los_fctr_id No number
269 -- p_min_cmbn No number
270 -- p_max_cmbn No number
271 -- p_date_from No date
272 -- p_elig_enrol_cd No varchar2
273 -- p_actn_typ_id No number
274 -- p_use_fctr_to_sel_flag No varchar2
275 -- p_los_det_to_use_cd No varchar2
276 -- p_audit_log_flag No varchar2
277 -- p_lmt_prpnip_by_org_flag No varchar2
278 -- p_bft_attribute_category No varchar2 Descriptive Flexfield
279 -- p_bft_attribute1 No varchar2 Descriptive Flexfield
280 -- p_bft_attribute3 No varchar2 Descriptive Flexfield
281 -- p_bft_attribute4 No varchar2 Descriptive Flexfield
282 -- p_bft_attribute5 No varchar2 Descriptive Flexfield
283 -- p_bft_attribute6 No varchar2 Descriptive Flexfield
284 -- p_bft_attribute7 No varchar2 Descriptive Flexfield
285 -- p_bft_attribute8 No varchar2 Descriptive Flexfield
286 -- p_bft_attribute9 No varchar2 Descriptive Flexfield
287 -- p_bft_attribute10 No varchar2 Descriptive Flexfield
288 -- p_bft_attribute11 No varchar2 Descriptive Flexfield
289 -- p_bft_attribute12 No varchar2 Descriptive Flexfield
290 -- p_bft_attribute13 No varchar2 Descriptive Flexfield
291 -- p_bft_attribute14 No varchar2 Descriptive Flexfield
292 -- p_bft_attribute15 No varchar2 Descriptive Flexfield
293 -- p_bft_attribute16 No varchar2 Descriptive Flexfield
294 -- p_bft_attribute17 No varchar2 Descriptive Flexfield
295 -- p_bft_attribute18 No varchar2 Descriptive Flexfield
296 -- p_bft_attribute19 No varchar2 Descriptive Flexfield
297 -- p_bft_attribute20 No varchar2 Descriptive Flexfield
298 -- p_bft_attribute21 No varchar2 Descriptive Flexfield
299 -- p_bft_attribute22 No varchar2 Descriptive Flexfield
300 -- p_bft_attribute23 No varchar2 Descriptive Flexfield
301 -- p_bft_attribute24 No varchar2 Descriptive Flexfield
302 -- p_bft_attribute25 No varchar2 Descriptive Flexfield
303 -- p_bft_attribute26 No varchar2 Descriptive Flexfield
304 -- p_bft_attribute27 No varchar2 Descriptive Flexfield
305 -- p_bft_attribute28 No varchar2 Descriptive Flexfield
306 -- p_bft_attribute29 No varchar2 Descriptive Flexfield
307 -- p_bft_attribute30 No varchar2 Descriptive Flexfield
308 -- p_effective_date Yes date Session Date.
309 --
310 -- Post Success:
311 --
312 -- Out Parameters:
313 -- Name Type Description
314 -- p_benefit_action_id Yes number PK of record
315 -- p_object_version_number No number OVN of record
316 --
317 -- Post Failure:
318 --
319 -- Access Status:
320 -- Public.
321 --
322 -- {End Of Comments}
323 --
324 procedure create_perf_benefit_actions
325 (
326 p_validate in boolean default false
327 ,p_benefit_action_id out nocopy number
328 ,p_process_date in date default null
329 ,p_uneai_effective_date in date default null
330 ,p_mode_cd in varchar2 default null
331 ,p_derivable_factors_flag in varchar2 default null
332 ,p_close_uneai_flag in varchar2 default 'N'
333 ,p_validate_flag in varchar2 default null
334 ,p_person_id in number default null
335 ,p_person_type_id in number default null
336 ,p_pgm_id in number default null
337 ,p_business_group_id in number default null
338 ,p_pl_id in number default null
339 ,p_popl_enrt_typ_cycl_id in number default null
340 ,p_no_programs_flag in varchar2 default null
341 ,p_no_plans_flag in varchar2 default null
342 ,p_comp_selection_rl in number default null
343 ,p_person_selection_rl in number default null
344 ,p_ler_id in number default null
345 ,p_organization_id in number default null
346 ,p_benfts_grp_id in number default null
347 ,p_location_id in number default null
348 ,p_pstl_zip_rng_id in number default null
349 ,p_rptg_grp_id in number default null
350 ,p_pl_typ_id in number default null
351 ,p_opt_id in number default null
352 ,p_eligy_prfl_id in number default null
353 ,p_vrbl_rt_prfl_id in number default null
354 ,p_legal_entity_id in number default null
355 ,p_payroll_id in number default null
356 ,p_debug_messages_flag in varchar2 default null
357 ,p_cm_trgr_typ_cd in varchar2 default null
358 ,p_cm_typ_id in number default null
359 ,p_age_fctr_id in number default null
360 ,p_min_age in number default null
361 ,p_max_age in number default null
362 ,p_los_fctr_id in number default null
363 ,p_min_los in number default null
364 ,p_max_los in number default null
365 ,p_cmbn_age_los_fctr_id in number default null
366 ,p_min_cmbn in number default null
367 ,p_max_cmbn in number default null
368 ,p_date_from in date default null
369 ,p_elig_enrol_cd in varchar2 default null
370 ,p_actn_typ_id in number default null
371 ,p_use_fctr_to_sel_flag in varchar2 default 'N'
372 ,p_los_det_to_use_cd in varchar2 default null
373 ,p_audit_log_flag in varchar2 default 'N'
374 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
375 ,p_lf_evt_ocrd_dt in date default null
376 ,p_ptnl_ler_for_per_stat_cd in varchar2 default null
377 ,p_bft_attribute_category in varchar2 default null
378 ,p_bft_attribute1 in varchar2 default null
379 ,p_bft_attribute3 in varchar2 default null
380 ,p_bft_attribute4 in varchar2 default null
381 ,p_bft_attribute5 in varchar2 default null
382 ,p_bft_attribute6 in varchar2 default null
383 ,p_bft_attribute7 in varchar2 default null
384 ,p_bft_attribute8 in varchar2 default null
385 ,p_bft_attribute9 in varchar2 default null
386 ,p_bft_attribute10 in varchar2 default null
387 ,p_bft_attribute11 in varchar2 default null
388 ,p_bft_attribute12 in varchar2 default null
389 ,p_bft_attribute13 in varchar2 default null
390 ,p_bft_attribute14 in varchar2 default null
391 ,p_bft_attribute15 in varchar2 default null
392 ,p_bft_attribute16 in varchar2 default null
393 ,p_bft_attribute17 in varchar2 default null
394 ,p_bft_attribute18 in varchar2 default null
395 ,p_bft_attribute19 in varchar2 default null
396 ,p_bft_attribute20 in varchar2 default null
397 ,p_bft_attribute21 in varchar2 default null
398 ,p_bft_attribute22 in varchar2 default null
399 ,p_bft_attribute23 in varchar2 default null
400 ,p_bft_attribute24 in varchar2 default null
401 ,p_bft_attribute25 in varchar2 default null
402 ,p_bft_attribute26 in varchar2 default null
403 ,p_bft_attribute27 in varchar2 default null
404 ,p_bft_attribute28 in varchar2 default null
405 ,p_bft_attribute29 in varchar2 default null
406 ,p_bft_attribute30 in varchar2 default null
407 ,p_request_id in number default null
411 ,p_object_version_number out nocopy number
408 ,p_program_application_id in number default null
409 ,p_program_id in number default null
410 ,p_program_update_date in date default null
412 ,p_effective_date in date
413 ,p_enrt_perd_id in number default null
414 ,p_inelg_action_cd in varchar2 default null
415 ,p_org_hierarchy_id in number default null
416 ,p_org_starting_node_id in number default null
417 ,p_grade_ladder_id in number default null
418 ,p_asg_events_to_all_sel_dt in varchar2 default null
419 ,p_rate_id in number default null
420 ,p_per_sel_dt_cd in varchar2 default null
421 ,p_per_sel_freq_cd in varchar2 default null
422 ,p_per_sel_dt_from in date default null
423 ,p_per_sel_dt_to in date default null
424 ,p_year_from in number default null
425 ,p_year_to in number default null
426 ,p_cagr_id in number default null
427 ,p_qual_type in number default null
428 ,p_qual_status in varchar2 default null
429 ,p_concat_segs in varchar2 default null
430 ,p_grant_price_val in number default null
431 );
432 -- ----------------------------------------------------------------------------
433 -- |------------------------< update_benefit_actions >------------------------|
434 -- ----------------------------------------------------------------------------
435 -- {Start Of Comments}
436 --
437 -- Description:
438 --
439 -- Prerequisites:
440 --
441 --
442 -- In Parameters:
443 -- Name Reqd Type Description
444 -- p_validate Yes boolean Commit or Rollback.
445 -- p_benefit_action_id Yes number PK of record
446 -- p_process_date Yes date
447 -- p_uneai_effective_date Yes date
448 -- p_mode_cd Yes varchar2
449 -- p_derivable_factors_flag Yes varchar2
450 -- p_close_uneai_flag Yes varchar2
451 -- p_validate_flag Yes varchar2
452 -- p_person_id No number
453 -- p_person_type_id No number
454 -- p_pgm_id No number
455 -- p_business_group_id Yes number Business Group of Record
456 -- p_pl_id No number
457 -- p_popl_enrt_typ_cycl_id No number
458 -- p_no_programs_flag Yes varchar2
459 -- p_no_plans_flag Yes varchar2
460 -- p_comp_selection_rl No number
461 -- p_person_selection_rl No number
462 -- p_ler_id No number
463 -- p_organization_id No number
464 -- p_benfts_grp_id No number
465 -- p_location_id No number
466 -- p_pstl_zip_rng_id No number
467 -- p_rptg_grp_id No number
468 -- p_pl_typ_id No number
469 -- p_opt_id No number
470 -- p_eligy_prfl_id No number
471 -- p_vrbl_rt_prfl_id No number
472 -- p_legal_entity_id No number
473 -- p_payroll_id No number
474 -- p_debug_messages_flag Yes varchar2
475 -- p_cm_trgr_typ_cd No varchar2
476 -- p_cm_typ_id No number
477 -- p_age_fctr_id No number
478 -- p_min_age No number
479 -- p_max_age No number
480 -- p_los_fctr_id No number
481 -- p_min_los No number
482 -- p_max_los No number
483 -- p_cmbn_age_los_fctr_id No number
484 -- p_min_cmbn No number
485 -- p_max_cmbn No number
486 -- p_date_from No date
487 -- p_elig_enrol_cd No varchar2
488 -- p_actn_typ_id No number
489 -- p_use_fctr_to_sel_flag No varchar2
490 -- p_los_det_to_use_cd No varchar2
491 -- p_audit_log_flag No varchar2
492 -- p_lmt_prpnip_by_org_flag No varchar2
493 -- p_bft_attribute_category No varchar2 Descriptive Flexfield
494 -- p_bft_attribute1 No varchar2 Descriptive Flexfield
495 -- p_bft_attribute3 No varchar2 Descriptive Flexfield
496 -- p_bft_attribute4 No varchar2 Descriptive Flexfield
497 -- p_bft_attribute5 No varchar2 Descriptive Flexfield
498 -- p_bft_attribute6 No varchar2 Descriptive Flexfield
499 -- p_bft_attribute7 No varchar2 Descriptive Flexfield
500 -- p_bft_attribute8 No varchar2 Descriptive Flexfield
501 -- p_bft_attribute9 No varchar2 Descriptive Flexfield
502 -- p_bft_attribute10 No varchar2 Descriptive Flexfield
503 -- p_bft_attribute11 No varchar2 Descriptive Flexfield
504 -- p_bft_attribute12 No varchar2 Descriptive Flexfield
505 -- p_bft_attribute13 No varchar2 Descriptive Flexfield
506 -- p_bft_attribute14 No varchar2 Descriptive Flexfield
507 -- p_bft_attribute15 No varchar2 Descriptive Flexfield
508 -- p_bft_attribute16 No varchar2 Descriptive Flexfield
509 -- p_bft_attribute17 No varchar2 Descriptive Flexfield
510 -- p_bft_attribute18 No varchar2 Descriptive Flexfield
514 -- p_bft_attribute22 No varchar2 Descriptive Flexfield
511 -- p_bft_attribute19 No varchar2 Descriptive Flexfield
512 -- p_bft_attribute20 No varchar2 Descriptive Flexfield
513 -- p_bft_attribute21 No varchar2 Descriptive Flexfield
515 -- p_bft_attribute23 No varchar2 Descriptive Flexfield
516 -- p_bft_attribute24 No varchar2 Descriptive Flexfield
517 -- p_bft_attribute25 No varchar2 Descriptive Flexfield
518 -- p_bft_attribute26 No varchar2 Descriptive Flexfield
519 -- p_bft_attribute27 No varchar2 Descriptive Flexfield
520 -- p_bft_attribute28 No varchar2 Descriptive Flexfield
521 -- p_bft_attribute29 No varchar2 Descriptive Flexfield
522 -- p_bft_attribute30 No varchar2 Descriptive Flexfield
523 -- p_effective_date Yes date Session Date.
524 --
525 -- Post Success:
526 --
527 -- Name Type Description
528 -- p_object_version_number No number OVN of record
529 --
530 -- Post Failure:
531 --
532 -- Access Status:
533 -- Public.
534 --
535 -- {End Of Comments}
536 --
537 procedure update_benefit_actions
538 (p_validate in boolean default false
539 ,p_benefit_action_id in number
540 ,p_process_date in date default hr_api.g_date
541 ,p_uneai_effective_date in date default hr_api.g_date
542 ,p_mode_cd in varchar2 default hr_api.g_varchar2
543 ,p_derivable_factors_flag in varchar2 default hr_api.g_varchar2
544 ,p_close_uneai_flag in varchar2 default hr_api.g_varchar2
545 ,p_validate_flag in varchar2 default hr_api.g_varchar2
546 ,p_person_id in number default hr_api.g_number
547 ,p_person_type_id in number default hr_api.g_number
548 ,p_pgm_id in number default hr_api.g_number
549 ,p_business_group_id in number default hr_api.g_number
550 ,p_pl_id in number default hr_api.g_number
551 ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
552 ,p_no_programs_flag in varchar2 default hr_api.g_varchar2
553 ,p_no_plans_flag in varchar2 default hr_api.g_varchar2
554 ,p_comp_selection_rl in number default hr_api.g_number
555 ,p_person_selection_rl in number default hr_api.g_number
556 ,p_ler_id in number default hr_api.g_number
557 ,p_organization_id in number default hr_api.g_number
558 ,p_benfts_grp_id in number default hr_api.g_number
559 ,p_location_id in number default hr_api.g_number
560 ,p_pstl_zip_rng_id in number default hr_api.g_number
561 ,p_rptg_grp_id in number default hr_api.g_number
562 ,p_pl_typ_id in number default hr_api.g_number
563 ,p_opt_id in number default hr_api.g_number
564 ,p_eligy_prfl_id in number default hr_api.g_number
565 ,p_vrbl_rt_prfl_id in number default hr_api.g_number
566 ,p_legal_entity_id in number default hr_api.g_number
567 ,p_payroll_id in number default hr_api.g_number
568 ,p_debug_messages_flag in varchar2 default hr_api.g_varchar2
569 ,p_cm_trgr_typ_cd in varchar2 default hr_api.g_varchar2
570 ,p_cm_typ_id in number default hr_api.g_number
571 ,p_age_fctr_id in number default hr_api.g_number
572 ,p_min_age in number default hr_api.g_number
573 ,p_max_age in number default hr_api.g_number
574 ,p_los_fctr_id in number default hr_api.g_number
575 ,p_min_los in number default hr_api.g_number
576 ,p_max_los in number default hr_api.g_number
577 ,p_cmbn_age_los_fctr_id in number default hr_api.g_number
578 ,p_min_cmbn in number default hr_api.g_number
579 ,p_max_cmbn in number default hr_api.g_number
580 ,p_date_from in date default hr_api.g_date
581 ,p_elig_enrol_cd in varchar2 default hr_api.g_varchar2
582 ,p_actn_typ_id in number default hr_api.g_number
583 ,p_use_fctr_to_sel_flag in varchar2 default hr_api.g_varchar2
584 ,p_los_det_to_use_cd in varchar2 default hr_api.g_varchar2
585 ,p_audit_log_flag in varchar2 default hr_api.g_varchar2
586 ,p_lmt_prpnip_by_org_flag in varchar2 default hr_api.g_varchar2
587 ,p_lf_evt_ocrd_dt in date default hr_api.g_date
588 ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
589 ,p_bft_attribute_category in varchar2 default hr_api.g_varchar2
590 ,p_bft_attribute1 in varchar2 default hr_api.g_varchar2
591 ,p_bft_attribute3 in varchar2 default hr_api.g_varchar2
592 ,p_bft_attribute4 in varchar2 default hr_api.g_varchar2
593 ,p_bft_attribute5 in varchar2 default hr_api.g_varchar2
594 ,p_bft_attribute6 in varchar2 default hr_api.g_varchar2
595 ,p_bft_attribute7 in varchar2 default hr_api.g_varchar2
596 ,p_bft_attribute8 in varchar2 default hr_api.g_varchar2
597 ,p_bft_attribute9 in varchar2 default hr_api.g_varchar2
598 ,p_bft_attribute10 in varchar2 default hr_api.g_varchar2
599 ,p_bft_attribute11 in varchar2 default hr_api.g_varchar2
600 ,p_bft_attribute12 in varchar2 default hr_api.g_varchar2
601 ,p_bft_attribute13 in varchar2 default hr_api.g_varchar2
602 ,p_bft_attribute14 in varchar2 default hr_api.g_varchar2
603 ,p_bft_attribute15 in varchar2 default hr_api.g_varchar2
604 ,p_bft_attribute16 in varchar2 default hr_api.g_varchar2
605 ,p_bft_attribute17 in varchar2 default hr_api.g_varchar2
606 ,p_bft_attribute18 in varchar2 default hr_api.g_varchar2
607 ,p_bft_attribute19 in varchar2 default hr_api.g_varchar2
608 ,p_bft_attribute20 in varchar2 default hr_api.g_varchar2
609 ,p_bft_attribute21 in varchar2 default hr_api.g_varchar2
610 ,p_bft_attribute22 in varchar2 default hr_api.g_varchar2
611 ,p_bft_attribute23 in varchar2 default hr_api.g_varchar2
612 ,p_bft_attribute24 in varchar2 default hr_api.g_varchar2
613 ,p_bft_attribute25 in varchar2 default hr_api.g_varchar2
614 ,p_bft_attribute26 in varchar2 default hr_api.g_varchar2
615 ,p_bft_attribute27 in varchar2 default hr_api.g_varchar2
616 ,p_bft_attribute28 in varchar2 default hr_api.g_varchar2
617 ,p_bft_attribute29 in varchar2 default hr_api.g_varchar2
618 ,p_bft_attribute30 in varchar2 default hr_api.g_varchar2
619 ,p_request_id in number default null
620 ,p_program_application_id in number default null
621 ,p_program_id in number default null
622 ,p_program_update_date in date default null
623 ,p_object_version_number in out nocopy number
624 ,p_effective_date in date
625 ,p_enrt_perd_id in number default hr_api.g_number
626 ,p_inelg_action_cd in varchar2 default hr_api.g_varchar2
627 ,p_org_hierarchy_id in number default hr_api.g_number
628 ,p_org_starting_node_id in number default hr_api.g_number
629 ,p_grade_ladder_id in number default hr_api.g_number
630 ,p_asg_events_to_all_sel_dt in varchar2 default hr_api.g_varchar2
631 ,p_rate_id in number default hr_api.g_number
632 ,p_per_sel_dt_cd in varchar2 default hr_api.g_varchar2
633 ,p_per_sel_freq_cd in varchar2 default hr_api.g_varchar2
634 ,p_per_sel_dt_from in date default hr_api.g_date
635 ,p_per_sel_dt_to in date default hr_api.g_date
636 ,p_year_from in number default hr_api.g_number
637 ,p_year_to in number default hr_api.g_number
638 ,p_cagr_id in number default hr_api.g_number
639 ,p_qual_type in number default hr_api.g_number
640 ,p_qual_status in varchar2 default hr_api.g_varchar2
641 ,p_concat_segs in varchar2 default hr_api.g_varchar2
642 ,p_grant_price_val in number default hr_api.g_number);
643 --
644 -- ----------------------------------------------------------------------------
645 -- |------------------------< delete_benefit_actions >------------------------|
646 -- ----------------------------------------------------------------------------
647 -- {Start Of Comments}
648 --
649 -- Description:
650 --
651 -- Prerequisites:
652 --
653 --
654 -- In Parameters:
655 -- Name Reqd Type Description
656 -- p_validate Yes boolean Commit or Rollback.
657 -- p_benefit_action_id Yes number PK of record
658 -- p_effective_date Yes date Session Date.
659 --
660 -- Post Success:
661 --
662 -- Name Type Description
663 -- p_object_version_number No number OVN of record
664 --
665 -- Post Failure:
666 --
667 -- Access Status:
668 -- Public.
669 --
670 -- {End Of Comments}
671 --
672 procedure delete_benefit_actions
673 (p_validate in boolean default false
674 ,p_benefit_action_id in number
675 ,p_object_version_number in out nocopy number
676 ,p_effective_date in date);
677 --
678 -- ----------------------------------------------------------------------------
679 -- |----------------------------------< lck >---------------------------------|
680 -- ----------------------------------------------------------------------------
681 -- {Start Of Comments}
682 --
683 -- Description:
684 --
685 -- Prerequisites:
686 --
687 --
688 -- In Parameters:
689 -- Name Reqd Type Description
690 -- p_benefit_action_id Yes number PK of record
691 -- p_object_version_number Yes number OVN of record
692 --
693 -- Post Success:
694 --
695 -- Name Type Description
696 --
697 -- Post Failure:
698 --
699 -- Access Status:
700 -- Public.
701 --
702 -- {End Of Comments}
703 --
704 procedure lck
705 (p_benefit_action_id in number
706 ,p_object_version_number in number);
707 --
708 end ben_benefit_actions_api;
[Home] [Help]