1 Package ben_PLAN_BENEFICIARY_api as
2 /* $Header: bepbnapi.pkh 120.2 2006/11/29 12:35:05 gsehgal noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_PLAN_BENEFICIARY >------------------------|
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_business_group_id Yes number Business Group of Record
18 -- p_prtt_enrt_rslt_id Yes number
19 -- p_bnf_person_id Yes number
20 -- p_organization_id No number
21 -- p_ttee_person_id No number
22 -- p_prmry_cntngnt_cd Yes varchar2
23 -- p_pct_dsgd_num No number
24 -- p_amt_dsgd_val No number
25 -- p_amt_dsgd_uom No varchar2
26 -- p_dsgn_strt_dt No date
27 -- p_dsgn_thru_dt No date
28 -- p_addl_instrn_txt No varchar2
29 -- p_pbn_attribute_category No varchar2 Descriptive Flexfield
30 -- p_pbn_attribute1 No varchar2 Descriptive Flexfield
31 -- p_pbn_attribute2 No varchar2 Descriptive Flexfield
32 -- p_pbn_attribute3 No varchar2 Descriptive Flexfield
33 -- p_pbn_attribute4 No varchar2 Descriptive Flexfield
34 -- p_pbn_attribute5 No varchar2 Descriptive Flexfield
35 -- p_pbn_attribute6 No varchar2 Descriptive Flexfield
36 -- p_pbn_attribute7 No varchar2 Descriptive Flexfield
37 -- p_pbn_attribute8 No varchar2 Descriptive Flexfield
38 -- p_pbn_attribute9 No varchar2 Descriptive Flexfield
39 -- p_pbn_attribute10 No varchar2 Descriptive Flexfield
40 -- p_pbn_attribute11 No varchar2 Descriptive Flexfield
41 -- p_pbn_attribute12 No varchar2 Descriptive Flexfield
42 -- p_pbn_attribute13 No varchar2 Descriptive Flexfield
43 -- p_pbn_attribute14 No varchar2 Descriptive Flexfield
44 -- p_pbn_attribute15 No varchar2 Descriptive Flexfield
45 -- p_pbn_attribute16 No varchar2 Descriptive Flexfield
46 -- p_pbn_attribute17 No varchar2 Descriptive Flexfield
47 -- p_pbn_attribute18 No varchar2 Descriptive Flexfield
48 -- p_pbn_attribute19 No varchar2 Descriptive Flexfield
49 -- p_pbn_attribute20 No varchar2 Descriptive Flexfield
50 -- p_pbn_attribute21 No varchar2 Descriptive Flexfield
51 -- p_pbn_attribute22 No varchar2 Descriptive Flexfield
52 -- p_pbn_attribute23 No varchar2 Descriptive Flexfield
53 -- p_pbn_attribute24 No varchar2 Descriptive Flexfield
54 -- p_pbn_attribute25 No varchar2 Descriptive Flexfield
55 -- p_pbn_attribute26 No varchar2 Descriptive Flexfield
56 -- p_pbn_attribute27 No varchar2 Descriptive Flexfield
57 -- p_pbn_attribute28 No varchar2 Descriptive Flexfield
58 -- p_pbn_attribute29 No varchar2 Descriptive Flexfield
59 -- p_pbn_attribute30 No varchar2 Descriptive Flexfield
60 -- p_effective_date Yes date Session Date.
61 -- p_per_in_ler_id No number
62 -- p_multi_row_actn
63 --
64 -- Post Success:
65 --
66 -- Out Parameters:
67 -- Name Type Description
68 -- p_pl_bnf_id Yes number PK of record
69 -- p_effective_start_date Yes date Effective Start Date of Record
70 -- p_effective_end_date Yes date Effective End Date of Record
71 -- p_object_version_number No number OVN of record
72 --
73 -- Post Failure:
74 --
75 -- Access Status:
76 -- Public.
77 --
78 -- {End Of Comments}
79 --
80 procedure create_PLAN_BENEFICIARY
81 (
82 p_validate in boolean default false
83 ,p_pl_bnf_id out nocopy number
84 ,p_effective_start_date out nocopy date
85 ,p_effective_end_date out nocopy date
86 ,p_business_group_id in number default null
87 ,p_prtt_enrt_rslt_id in number default null
88 ,p_bnf_person_id in number default null
89 ,p_organization_id in number default null
90 ,p_ttee_person_id in number default null
91 ,p_prmry_cntngnt_cd in varchar2 default null
92 ,p_pct_dsgd_num in number default null
93 ,p_amt_dsgd_val in number default null
94 ,p_amt_dsgd_uom in varchar2 default null
95 ,p_dsgn_strt_dt in date default null
96 ,p_dsgn_thru_dt in date default null
97 ,p_addl_instrn_txt in varchar2 default null
98 ,p_pbn_attribute_category in varchar2 default null
99 ,p_pbn_attribute1 in varchar2 default null
100 ,p_pbn_attribute2 in varchar2 default null
101 ,p_pbn_attribute3 in varchar2 default null
102 ,p_pbn_attribute4 in varchar2 default null
103 ,p_pbn_attribute5 in varchar2 default null
104 ,p_pbn_attribute6 in varchar2 default null
105 ,p_pbn_attribute7 in varchar2 default null
106 ,p_pbn_attribute8 in varchar2 default null
107 ,p_pbn_attribute9 in varchar2 default null
108 ,p_pbn_attribute10 in varchar2 default null
109 ,p_pbn_attribute11 in varchar2 default null
110 ,p_pbn_attribute12 in varchar2 default null
111 ,p_pbn_attribute13 in varchar2 default null
112 ,p_pbn_attribute14 in varchar2 default null
113 ,p_pbn_attribute15 in varchar2 default null
114 ,p_pbn_attribute16 in varchar2 default null
115 ,p_pbn_attribute17 in varchar2 default null
116 ,p_pbn_attribute18 in varchar2 default null
117 ,p_pbn_attribute19 in varchar2 default null
118 ,p_pbn_attribute20 in varchar2 default null
119 ,p_pbn_attribute21 in varchar2 default null
120 ,p_pbn_attribute22 in varchar2 default null
121 ,p_pbn_attribute23 in varchar2 default null
122 ,p_pbn_attribute24 in varchar2 default null
123 ,p_pbn_attribute25 in varchar2 default null
124 ,p_pbn_attribute26 in varchar2 default null
125 ,p_pbn_attribute27 in varchar2 default null
126 ,p_pbn_attribute28 in varchar2 default null
127 ,p_pbn_attribute29 in varchar2 default null
128 ,p_pbn_attribute30 in varchar2 default null
129 ,p_request_id in number default null
130 ,p_program_application_id in number default null
131 ,p_program_id in number default null
132 ,p_program_update_date in date default null
133 ,p_object_version_number out nocopy number
134 ,p_per_in_ler_id in number default null
135 ,p_effective_date in date
136 ,p_multi_row_actn in boolean default TRUE
137 );
138 --
139 -- ----------------------------------------------------------------------------
140 -- |------------------------< create_PLAN_BENEFICIARY_W >------------------------|
141 -- ----------------------------------------------------------------------------
142 -- {Start Of Comments}
143 --
144 -- Description: Wrapper for self service development as currently cannot
145 -- pass booleans.
146 --
147 -- Prerequisites:
148 --
149 --
150 -- In Parameters:
151 -- Name Reqd Type Description
152 -- p_validate Yes boolean Commit or Rollback.
153 -- p_business_group_id Yes number Business Group of Record
154 -- p_prtt_enrt_rslt_id Yes number
155 -- p_bnf_person_id No number either bnf_person or org is required
156 -- p_organization_id No number
157 -- p_prmry_cntngnt_cd Yes varchar2
158 -- p_pct_dsgd_num No number
159 -- p_dsgn_strt_dt No date
160 -- p_dsgn_thru_dt No date
161 -- p_effective_date Yes date
162 -- p_per_in_ler_id No number
163 -- p_multi_row_actn
164 --
165 -- Post Success:
166 --
167 -- Out Parameters:
168 -- Name Type Description
169 -- p_pl_bnf_id Yes number PK of record
170 -- p_effective_start_date Yes date Effective Start Date of Record
171 -- p_effective_end_date Yes date Effective End Date of Record
172 -- p_object_version_number No number OVN of record
173 --
174 -- Post Failure:
175 --
176 -- Access Status:
177 -- Public.
178 --
179 -- {End Of Comments}
180 --
181 procedure create_PLAN_BENEFICIARY_w
182 (
183 p_validate in varchar2
184 ,p_pl_bnf_id out nocopy number
185 ,p_effective_start_date out nocopy date
186 ,p_effective_end_date out nocopy date
187 ,p_business_group_id in number
188 ,p_prtt_enrt_rslt_id in number
189 ,p_bnf_person_id in number default null
190 ,p_organization_id in number default null
191 ,p_prmry_cntngnt_cd in varchar2
192 ,p_pct_dsgd_num in number
193 ,p_dsgn_strt_dt in date
194 ,p_dsgn_thru_dt in date
195 ,p_object_version_number out nocopy number
196 ,p_per_in_ler_id in number
197 ,p_effective_date in date
198 ,p_multi_row_actn in varchar2
199 );
200 --
201 -- ----------------------------------------------------------------------------
202 -- |------------------------< update_PLAN_BENEFICIARY >------------------------|
203 -- ----------------------------------------------------------------------------
204 -- {Start Of Comments}
205 --
206 -- Description:
207 --
208 -- Prerequisites:
209 --
210 --
211 -- In Parameters:
212 -- Name Reqd Type Description
213 -- p_validate Yes boolean Commit or Rollback.
214 -- p_pl_bnf_id Yes number PK of record
215 -- p_business_group_id Yes number Business Group of Record
216 -- p_prtt_enrt_rslt_id Yes number
217 -- p_bnf_person_id Yes number
218 -- p_organization_id No number
219 -- p_ttee_person_id No number
220 -- p_prmry_cntngnt_cd Yes varchar2
221 -- p_pct_dsgd_num No number
222 -- p_amt_dsgd_val No number
223 -- p_amt_dsgd_uom No varchar2
224 -- p_dsgn_strt_dt No date
225 -- p_dsgn_thru_dt No date
226 -- p_addl_instrn_txt No varchar2
227 -- p_pbn_attribute_category No varchar2 Descriptive Flexfield
228 -- p_pbn_attribute1 No varchar2 Descriptive Flexfield
229 -- p_pbn_attribute2 No varchar2 Descriptive Flexfield
230 -- p_pbn_attribute3 No varchar2 Descriptive Flexfield
231 -- p_pbn_attribute4 No varchar2 Descriptive Flexfield
232 -- p_pbn_attribute5 No varchar2 Descriptive Flexfield
233 -- p_pbn_attribute6 No varchar2 Descriptive Flexfield
234 -- p_pbn_attribute7 No varchar2 Descriptive Flexfield
235 -- p_pbn_attribute8 No varchar2 Descriptive Flexfield
236 -- p_pbn_attribute9 No varchar2 Descriptive Flexfield
237 -- p_pbn_attribute10 No varchar2 Descriptive Flexfield
238 -- p_pbn_attribute11 No varchar2 Descriptive Flexfield
239 -- p_pbn_attribute12 No varchar2 Descriptive Flexfield
240 -- p_pbn_attribute13 No varchar2 Descriptive Flexfield
241 -- p_pbn_attribute14 No varchar2 Descriptive Flexfield
242 -- p_pbn_attribute15 No varchar2 Descriptive Flexfield
243 -- p_pbn_attribute16 No varchar2 Descriptive Flexfield
244 -- p_pbn_attribute17 No varchar2 Descriptive Flexfield
245 -- p_pbn_attribute18 No varchar2 Descriptive Flexfield
246 -- p_pbn_attribute19 No varchar2 Descriptive Flexfield
247 -- p_pbn_attribute20 No varchar2 Descriptive Flexfield
248 -- p_pbn_attribute21 No varchar2 Descriptive Flexfield
249 -- p_pbn_attribute22 No varchar2 Descriptive Flexfield
250 -- p_pbn_attribute23 No varchar2 Descriptive Flexfield
251 -- p_pbn_attribute24 No varchar2 Descriptive Flexfield
252 -- p_pbn_attribute25 No varchar2 Descriptive Flexfield
253 -- p_pbn_attribute26 No varchar2 Descriptive Flexfield
254 -- p_pbn_attribute27 No varchar2 Descriptive Flexfield
255 -- p_pbn_attribute28 No varchar2 Descriptive Flexfield
256 -- p_pbn_attribute29 No varchar2 Descriptive Flexfield
257 -- p_pbn_attribute30 No varchar2 Descriptive Flexfield
258 -- p_per_in_ler_id No number
259 -- p_effective_date Yes date Session Date.
260 -- p_datetrack_mode Yes varchar2 Datetrack mode.
261 --
262 -- Post Success:
263 --
264 -- Name Type Description
265 -- p_effective_start_date Yes date Effective Start Date of Record
266 -- p_effective_end_date Yes date Effective End Date of Record
267 -- p_object_version_number No number OVN of record
268 --
269 -- Post Failure:
270 --
271 -- Access Status:
272 -- Public.
273 --
274 -- {End Of Comments}
275 --
276 procedure update_PLAN_BENEFICIARY
277 (
278 p_validate in boolean default false
279 ,p_pl_bnf_id in number
280 ,p_effective_start_date out nocopy date
281 ,p_effective_end_date out nocopy date
282 ,p_business_group_id in number default hr_api.g_number
283 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
284 ,p_bnf_person_id in number default hr_api.g_number
285 ,p_organization_id in number default hr_api.g_number
286 ,p_ttee_person_id in number default hr_api.g_number
287 ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
288 ,p_pct_dsgd_num in number default hr_api.g_number
289 ,p_amt_dsgd_val in number default hr_api.g_number
290 ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
291 ,p_dsgn_strt_dt in date default hr_api.g_date
292 ,p_dsgn_thru_dt in date default hr_api.g_date
293 ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
294 ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
295 ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
296 ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
297 ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
298 ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
299 ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
300 ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
301 ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
302 ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
303 ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
304 ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
308 ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
305 ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
306 ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
307 ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
309 ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
310 ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
311 ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
312 ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
313 ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
314 ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
315 ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
316 ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
317 ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
318 ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
319 ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
320 ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
321 ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
322 ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
323 ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
324 ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
325 ,p_request_id in number default hr_api.g_number
326 ,p_program_application_id in number default hr_api.g_number
327 ,p_program_id in number default hr_api.g_number
328 ,p_program_update_date in date default hr_api.g_date
329 ,p_object_version_number in out nocopy number
330 ,p_per_in_ler_id in number default hr_api.g_number
331 ,p_effective_date in date
332 ,p_datetrack_mode in varchar2
333 ,p_multi_row_actn in boolean default TRUE
334 );
335 --
336 -- ----------------------------------------------------------------------------
337 -- |------------------------< update_PLAN_BENEFICIARY_W >------------------------|
338 -- ----------------------------------------------------------------------------
339 -- {Start Of Comments}
340 --
341 -- Description: Wrapper for self service development as currently cannot
342 -- pass booleans.
343 --
344 -- Prerequisites:
345 --
346 --
347 -- In Parameters:
348 -- Name Reqd Type Description
349 -- p_validate Yes varchar2 Commit or Rollback.
350 -- p_pl_bnf_id Yes number PK of record
351 -- p_business_group_id Yes number Business Group of Record
352 -- p_prtt_enrt_rslt_id Yes number
353 -- p_bnf_person_id No number
354 -- p_organization_id No number
355 -- p_prmry_cntngnt_cd Yes varchar2
356 -- p_pct_dsgd_num No number
357 -- p_dsgn_strt_dt No date
358 -- p_dsgn_thru_dt No date
359 -- p_per_in_ler_id No number
360 -- p_effective_date Yes date
361 -- p_datetrack_mode Yes varchar2 Datetrack mode.
362 --
363 -- Post Success:
364 --
365 -- Name Type Description
366 -- p_effective_start_date Yes date Effective Start Date of Record
367 -- p_effective_end_date Yes date Effective End Date of Record
368 -- p_object_version_number No number OVN of record
369 --
370 -- Post Failure:
371 --
372 -- Access Status:
373 -- Public.
374 --
375 -- {End Of Comments}
376 --
377 procedure update_PLAN_BENEFICIARY_w
378 (
379 p_validate in varchar2
380 ,p_pl_bnf_id in number
381 ,p_effective_start_date out nocopy date
382 ,p_effective_end_date out nocopy date
383 ,p_business_group_id in number
384 ,p_prtt_enrt_rslt_id in number
385 ,p_bnf_person_id in number default hr_api.g_number
386 ,p_organization_id in number default hr_api.g_number
387 ,p_prmry_cntngnt_cd in varchar2
388 ,p_pct_dsgd_num in number
389 ,p_dsgn_strt_dt in date
390 ,p_dsgn_thru_dt in date
391 ,p_object_version_number in out nocopy number
392 ,p_per_in_ler_id in number
393 ,p_effective_date in date
394 ,p_datetrack_mode in varchar2
395 ,p_multi_row_actn in varchar2
396 );
397 --
398 -- ----------------------------------------------------------------------------
399 -- |------------------------< delete_PLAN_BENEFICIARY >------------------------|
400 -- ----------------------------------------------------------------------------
401 -- {Start Of Comments}
402 --
403 -- Description:
404 --
405 -- Prerequisites:
406 --
407 --
408 -- In Parameters:
409 -- Name Reqd Type Description
410 -- p_validate Yes boolean Commit or Rollback.
411 -- p_pl_bnf_id Yes number PK of record
412 -- p_effective_date Yes date Session Date.
416 -- Post Success:
413 -- p_datetrack_mode Yes varchar2 Datetrack mode.
414 -- p_business_group_id Yes number Business Group
415 --
417 --
418 -- Name Type Description
419 -- p_effective_start_date Yes date Effective Start Date of Record
420 -- p_effective_end_date Yes date Effective End Date of Record
421 -- p_object_version_number No number OVN of record
422 --
423 -- Post Failure:
424 --
425 -- Access Status:
426 -- Public.
427 --
428 -- {End Of Comments}
429 --
430 procedure delete_PLAN_BENEFICIARY
431 (
432 p_validate in boolean default false
433 ,p_pl_bnf_id in number
434 ,p_effective_start_date out nocopy date
435 ,p_effective_end_date out nocopy date
436 ,p_object_version_number in out nocopy number
437 ,p_business_group_id in number
438 ,p_effective_date in date
439 ,p_datetrack_mode in varchar2
440 ,p_multi_row_actn in boolean default TRUE
441 );
442 --
443 -- ----------------------------------------------------------------------------
444 -- |---------------------< delete_PLAN_BENEFICIARY_w >------------------------|
445 -- ----------------------------------------------------------------------------
446 -- {Start Of Comments}
447 --
448 -- Description: Wrapper for self service development as currently cannot
449 -- pass booleans.
450 --
451 -- Prerequisites:
452 --
453 --
454 -- In Parameters:
455 -- Name Reqd Type Description
456 -- p_validate Yes varchar2 Commit or Rollback.
457 -- p_pl_bnf_id Yes number PK of record
458 -- p_effective_date Yes date Session Date.
459 -- p_datetrack_mode Yes varchar2 Datetrack mode.
460 -- p_business_group_id Yes number Business Group
461 --
462 -- Post Success:
463 --
464 -- Name Type Description
465 -- p_effective_start_date Yes date Effective Start Date of Record
466 -- p_effective_end_date Yes date Effective End Date of Record
467 -- p_object_version_number No number OVN of record
468 --
469 -- Post Failure:
470 --
471 -- Access Status:
472 -- Public.
473 --
474 -- {End Of Comments}
475 --
476 procedure delete_PLAN_BENEFICIARY_w
477 (
478 p_validate in varchar2
479 ,p_pl_bnf_id in number
480 ,p_effective_start_date out nocopy date
481 ,p_effective_end_date out nocopy date
482 ,p_object_version_number in out nocopy number
483 ,p_business_group_id in number
484 ,p_effective_date in date
485 ,p_datetrack_mode in varchar2
486 ,p_prtt_enrt_rslt_id in number --4879576
487 ,p_multi_row_actn in varchar2
488 );
489 --
490 -- ----------------------------------------------------------------------------
491 -- |----------------------------------< lck >---------------------------------|
492 -- ----------------------------------------------------------------------------
493 -- {Start Of Comments}
494 --
495 -- Description:
496 --
497 -- Prerequisites:
498 --
499 --
500 -- In Parameters:
501 -- Name Reqd Type Description
502 -- p_pl_bnf_id Yes number PK of record
503 -- p_object_version_number Yes number OVN of record
504 -- p_effective_date Yes date Session Date.
505 -- p_datetrack_mode Yes varchar2 Datetrack mode.
506 --
507 -- Post Success:
508 --
509 -- Name Type Description
510 -- p_validation_start_date Yes Derived Effective Start Date.
511 -- p_validation_end_date Yes Derived Effective End Date.
512 --
513 -- Post Failure:
514 --
515 -- Access Status:
516 -- Public.
517 --
518 -- {End Of Comments}
519 --
520 procedure lck
521 (
522 p_pl_bnf_id in number
523 ,p_object_version_number in number
524 ,p_effective_date in date
525 ,p_datetrack_mode in varchar2
526 ,p_validation_start_date out nocopy date
527 ,p_validation_end_date out nocopy date
528 );
529 --
530 -- ----------------------------------------------------------------------------
531 -- |---------------------------< bnf_actn_items >-----------------|
532 -- ----------------------------------------------------------------------------
533 procedure bnf_actn_items
534 (
535 p_prtt_enrt_rslt_id in number
536 ,p_pl_bnf_id in number
537 ,p_effective_date in date
538 ,p_business_group_id in number
539 ,p_validate in boolean default false
540 ,p_datetrack_mode in varchar2
541 ,p_delete_flag in varchar2 default 'N'
542 );
543 --
544 -- ----------------------------------------------------------------------------
545 -- |---------------------------< add_usage >-----------------|
546 -- ----------------------------------------------------------------------------
547 procedure add_usage
548 (
549 p_validate in boolean default false
550 ,p_pl_bnf_id in number
551 ,p_bnf_person_id in number
552 ,p_prtt_enrt_rslt_id in number
553 ,p_business_group_id in number
554 ,p_effective_date in date
555 ,p_datetrack_mode in varchar2
556 );
557 --
558 -- ----------------------------------------------------------------------------
559 -- |-------------------------------< remove_usage >--------------------------|
560 -- ----------------------------------------------------------------------------
561 --
562 procedure remove_usage (
563 p_validate in boolean default false
564 ,p_pl_bnf_id in number
565 ,p_effective_date in date
566 ,p_datetrack_mode in varchar2
567 ,p_business_group_id in number
568 -- bug 5668052
569 ,p_dsgn_thru_dt in date
570 ) ;
571 --
572 end ben_PLAN_BENEFICIARY_api;
573 --
[Home] [Help]