1 Package ben_Benefit_Prvdd_Ledger_api AUTHID CURRENT_USER as
2 /* $Header: bebplapi.pkh 120.0.12000000.1 2007/01/19 01:23:08 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Benefit_Prvdd_Ledger >------------------------|
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_prtt_ro_of_unusd_amt_flag Yes varchar2
18 -- p_frftd_val No number
19 -- p_prvdd_val No number
20 -- p_used_val No number
21 -- p_bnft_prvdr_pool_id No number
22 -- p_acty_base_rt_id Yes number
23 -- p_per_in_ler_id Yes number
24 -- p_prtt_enrt_rslt_id No number
25 -- p_business_group_id Yes number Business Group of Record
26 -- p_bpl_attribute_category No varchar2 Descriptive Flexfield
27 -- p_bpl_attribute1 No varchar2 Descriptive Flexfield
28 -- p_bpl_attribute2 No varchar2 Descriptive Flexfield
29 -- p_bpl_attribute3 No varchar2 Descriptive Flexfield
30 -- p_bpl_attribute4 No varchar2 Descriptive Flexfield
31 -- p_bpl_attribute5 No varchar2 Descriptive Flexfield
32 -- p_bpl_attribute6 No varchar2 Descriptive Flexfield
33 -- p_bpl_attribute7 No varchar2 Descriptive Flexfield
34 -- p_bpl_attribute8 No varchar2 Descriptive Flexfield
35 -- p_bpl_attribute9 No varchar2 Descriptive Flexfield
36 -- p_bpl_attribute10 No varchar2 Descriptive Flexfield
37 -- p_bpl_attribute11 No varchar2 Descriptive Flexfield
38 -- p_bpl_attribute12 No varchar2 Descriptive Flexfield
39 -- p_bpl_attribute13 No varchar2 Descriptive Flexfield
40 -- p_bpl_attribute14 No varchar2 Descriptive Flexfield
41 -- p_bpl_attribute15 No varchar2 Descriptive Flexfield
42 -- p_bpl_attribute16 No varchar2 Descriptive Flexfield
43 -- p_bpl_attribute17 No varchar2 Descriptive Flexfield
44 -- p_bpl_attribute18 No varchar2 Descriptive Flexfield
48 -- p_bpl_attribute22 No varchar2 Descriptive Flexfield
45 -- p_bpl_attribute19 No varchar2 Descriptive Flexfield
46 -- p_bpl_attribute20 No varchar2 Descriptive Flexfield
47 -- p_bpl_attribute21 No varchar2 Descriptive Flexfield
49 -- p_bpl_attribute23 No varchar2 Descriptive Flexfield
50 -- p_bpl_attribute24 No varchar2 Descriptive Flexfield
51 -- p_bpl_attribute25 No varchar2 Descriptive Flexfield
52 -- p_bpl_attribute26 No varchar2 Descriptive Flexfield
53 -- p_bpl_attribute27 No varchar2 Descriptive Flexfield
54 -- p_bpl_attribute28 No varchar2 Descriptive Flexfield
55 -- p_bpl_attribute29 No varchar2 Descriptive Flexfield
56 -- p_bpl_attribute30 No varchar2 Descriptive Flexfield
57 -- p_cash_recd_val No number
58 -- p_rld_up_val No number
59 -- p_acty_ref_perd_cd Yes varchar2
60 -- p_cmcd_frftd_val No number
61 -- p_cmcd_prvdd_val No number
62 -- p_cmcd_rld_up_val No number
63 -- p_cmcd_used_val No number
64 -- p_cmcd_cash_recd_val No number
65 -- p_cmcd_ref_perd_cd Yes varchar2
66 -- p_ann_frftd_val No number
67 -- p_ann_prvdd_val No number
68 -- p_ann_rld_up_val No number
69 -- p_ann_used_val No number
70 -- p_ann_cash_recd_val No number
71 -- p_effective_date Yes date Session Date.
72 -- p_process_enrt_flag No varchar2 Process related enrollments.
73 --
74 -- Post Success:
75 --
76 -- Out Parameters:
77 -- Name Type Description
78 -- p_bnft_prvdd_ldgr_id Yes number PK of record
79 -- p_effective_start_date Yes date Effective Start Date of Record
80 -- p_effective_end_date Yes date Effective End Date of Record
81 -- p_object_version_number No number OVN of record
82 --
83 -- Post Failure:
84 --
85 -- Access Status:
86 -- Public.
87 --
88 -- {End Of Comments}
89 --
90 procedure create_Benefit_Prvdd_Ledger
91 (
92 p_validate in boolean default false
93 ,p_bnft_prvdd_ldgr_id out nocopy number
94 ,p_effective_start_date out nocopy date
95 ,p_effective_end_date out nocopy date
96 ,p_prtt_ro_of_unusd_amt_flag in varchar2 default null
97 ,p_frftd_val in number default null
98 ,p_prvdd_val in number default null
99 ,p_used_val in number default null
100 ,p_person_id in number default null
101 ,p_enrt_mthd_cd in varchar2 default null
102 ,p_bnft_prvdr_pool_id in number default null
103 ,p_acty_base_rt_id in number default null
104 ,p_per_in_ler_id in number default null
105 ,p_prtt_enrt_rslt_id in number default null
106 ,p_business_group_id in number default null
107 ,p_bpl_attribute_category in varchar2 default null
108 ,p_bpl_attribute1 in varchar2 default null
109 ,p_bpl_attribute2 in varchar2 default null
110 ,p_bpl_attribute3 in varchar2 default null
111 ,p_bpl_attribute4 in varchar2 default null
112 ,p_bpl_attribute5 in varchar2 default null
113 ,p_bpl_attribute6 in varchar2 default null
114 ,p_bpl_attribute7 in varchar2 default null
115 ,p_bpl_attribute8 in varchar2 default null
116 ,p_bpl_attribute9 in varchar2 default null
117 ,p_bpl_attribute10 in varchar2 default null
118 ,p_bpl_attribute11 in varchar2 default null
119 ,p_bpl_attribute12 in varchar2 default null
120 ,p_bpl_attribute13 in varchar2 default null
121 ,p_bpl_attribute14 in varchar2 default null
122 ,p_bpl_attribute15 in varchar2 default null
123 ,p_bpl_attribute16 in varchar2 default null
124 ,p_bpl_attribute17 in varchar2 default null
125 ,p_bpl_attribute18 in varchar2 default null
126 ,p_bpl_attribute19 in varchar2 default null
127 ,p_bpl_attribute20 in varchar2 default null
128 ,p_bpl_attribute21 in varchar2 default null
129 ,p_bpl_attribute22 in varchar2 default null
130 ,p_bpl_attribute23 in varchar2 default null
131 ,p_bpl_attribute24 in varchar2 default null
132 ,p_bpl_attribute25 in varchar2 default null
133 ,p_bpl_attribute26 in varchar2 default null
134 ,p_bpl_attribute27 in varchar2 default null
135 ,p_bpl_attribute28 in varchar2 default null
136 ,p_bpl_attribute29 in varchar2 default null
137 ,p_bpl_attribute30 in varchar2 default null
138 ,p_cash_recd_val in number default null
139 ,p_rld_up_val in number default null
140 ,p_effective_date in date
141 ,p_process_enrt_flag in varchar2 default 'Y'
142 ,p_from_reinstate_enrt_flag in varchar2 default 'N',
143 p_acty_ref_perd_cd in varchar2 default null,
144 p_cmcd_frftd_val in number default null,
145 p_cmcd_prvdd_val in number default null,
146 p_cmcd_rld_up_val in number default null,
147 p_cmcd_used_val in number default null,
148 p_cmcd_cash_recd_val in number default null,
152 p_ann_rld_up_val in number default null,
149 p_cmcd_ref_perd_cd in varchar2 default null,
150 p_ann_frftd_val in number default null,
151 p_ann_prvdd_val in number default null,
153 p_ann_used_val in number default null,
154 p_ann_cash_recd_val in number default null,
155 p_object_version_number out nocopy number
156 );
157 --
158 -- ----------------------------------------------------------------------------
159 -- |------------------------< create_Benefit_Prvdd_Ledger_w >-----------------|
160 -- ----------------------------------------------------------------------------
161 -- {Start Of Comments}
162 --
163 -- Description: Self Service wrapper called from Java code.
164 --
165 -- {End Of Comments}
166 --
167 procedure create_Benefit_Prvdd_Ledger_w
168 (
169 p_validate in varchar2 default 'FALSE'
170 ,p_bnft_prvdd_ldgr_id out nocopy number
171 ,p_effective_start_date out nocopy date
172 ,p_effective_end_date out nocopy date
173 ,p_prtt_ro_of_unusd_amt_flag in varchar2 default null
174 ,p_frftd_val in number default null
175 ,p_prvdd_val in number default null
176 ,p_used_val in number default null
177 ,p_person_id in number default null
178 ,p_enrt_mthd_cd in varchar2 default null
179 ,p_bnft_prvdr_pool_id in number default null
180 ,p_acty_base_rt_id in number default null
181 ,p_per_in_ler_id in number default null
182 ,p_prtt_enrt_rslt_id in number default null
183 ,p_business_group_id in number default null
184 ,p_cash_recd_val in number default null
185 ,p_rld_up_val in number default null
186 ,p_effective_date in date
187 ,p_process_enrt_flag in varchar2 default 'Y'
188 ,p_from_reinstate_enrt_flag in varchar2 default 'N',
189 p_acty_ref_perd_cd in varchar2 default null,
190 p_cmcd_frftd_val in number default null,
191 p_cmcd_prvdd_val in number default null,
192 p_cmcd_rld_up_val in number default null,
193 p_cmcd_used_val in number default null,
194 p_cmcd_cash_recd_val in number default null,
195 p_cmcd_ref_perd_cd in varchar2 default null,
196 p_ann_frftd_val in number default null,
197 p_ann_prvdd_val in number default null,
198 p_ann_rld_up_val in number default null,
199 p_ann_used_val in number default null,
200 p_ann_cash_recd_val in number default null,
201 p_object_version_number out nocopy number
202 );
203 --
204 -- ----------------------------------------------------------------------------
205 -- |------------------------< update_Benefit_Prvdd_Ledger >-------------------|
206 -- ----------------------------------------------------------------------------
207 -- {Start Of Comments}
208 --
209 -- Description:
210 --
211 -- Prerequisites:
212 --
213 --
214 -- In Parameters:
215 -- Name Reqd Type Description
216 -- p_validate Yes boolean Commit or Rollback.
217 -- p_bnft_prvdd_ldgr_id Yes number PK of record
218 -- p_prtt_ro_of_unusd_amt_flag Yes varchar2
219 -- p_frftd_val No number
220 -- p_prvdd_val No number
221 -- p_used_val No number
222 -- p_bnft_prvdr_pool_id No number
223 -- p_acty_base_rt_id Yes number
224 -- p_per_in_ler_id Yes number
225 -- p_prtt_enrt_rslt_id No number
226 -- p_business_group_id Yes number Business Group of Record
227 -- p_bpl_attribute_category No varchar2 Descriptive Flexfield
228 -- p_bpl_attribute1 No varchar2 Descriptive Flexfield
229 -- p_bpl_attribute2 No varchar2 Descriptive Flexfield
230 -- p_bpl_attribute3 No varchar2 Descriptive Flexfield
231 -- p_bpl_attribute4 No varchar2 Descriptive Flexfield
232 -- p_bpl_attribute5 No varchar2 Descriptive Flexfield
233 -- p_bpl_attribute6 No varchar2 Descriptive Flexfield
234 -- p_bpl_attribute7 No varchar2 Descriptive Flexfield
235 -- p_bpl_attribute8 No varchar2 Descriptive Flexfield
236 -- p_bpl_attribute9 No varchar2 Descriptive Flexfield
237 -- p_bpl_attribute10 No varchar2 Descriptive Flexfield
238 -- p_bpl_attribute11 No varchar2 Descriptive Flexfield
239 -- p_bpl_attribute12 No varchar2 Descriptive Flexfield
240 -- p_bpl_attribute13 No varchar2 Descriptive Flexfield
241 -- p_bpl_attribute14 No varchar2 Descriptive Flexfield
242 -- p_bpl_attribute15 No varchar2 Descriptive Flexfield
243 -- p_bpl_attribute16 No varchar2 Descriptive Flexfield
244 -- p_bpl_attribute17 No varchar2 Descriptive Flexfield
245 -- p_bpl_attribute18 No varchar2 Descriptive Flexfield
246 -- p_bpl_attribute19 No varchar2 Descriptive Flexfield
247 -- p_bpl_attribute20 No varchar2 Descriptive Flexfield
248 -- p_bpl_attribute21 No varchar2 Descriptive Flexfield
249 -- p_bpl_attribute22 No varchar2 Descriptive Flexfield
250 -- p_bpl_attribute23 No varchar2 Descriptive Flexfield
254 -- p_bpl_attribute27 No varchar2 Descriptive Flexfield
251 -- p_bpl_attribute24 No varchar2 Descriptive Flexfield
252 -- p_bpl_attribute25 No varchar2 Descriptive Flexfield
253 -- p_bpl_attribute26 No varchar2 Descriptive Flexfield
255 -- p_bpl_attribute28 No varchar2 Descriptive Flexfield
256 -- p_bpl_attribute29 No varchar2 Descriptive Flexfield
257 -- p_bpl_attribute30 No varchar2 Descriptive Flexfield
258 -- p_cash_recd_val No number
259 -- p_rld_up_val No number
260 -- p_acty_ref_perd_cd Yes varchar2
261 -- p_cmcd_frftd_val No number
262 -- p_cmcd_prvdd_val No number
263 -- p_cmcd_rld_up_val No number
264 -- p_cmcd_used_val No number
265 -- p_cmcd_cash_recd_val No number
266 -- p_cmcd_ref_perd_cd Yes varchar2
267 -- p_ann_frftd_val No number
268 -- p_ann_prvdd_val No number
269 -- p_ann_rld_up_val No number
270 -- p_ann_used_val No number
271 -- p_ann_cash_recd_val No number
272 -- p_effective_date Yes date Session Date.
273 -- p_datetrack_mode Yes varchar2 Datetrack mode.
274 -- p_process_enrt_flag No varchar2 Process related enrollments.
275 --
276 -- Post Success:
277 --
278 -- Name Type Description
279 -- p_effective_start_date Yes date Effective Start Date of Record
280 -- p_effective_end_date Yes date Effective End Date of Record
281 -- p_object_version_number No number OVN of record
282 --
283 -- Post Failure:
284 --
285 -- Access Status:
286 -- Public.
287 --
288 -- {End Of Comments}
289 --
290 procedure update_Benefit_Prvdd_Ledger
291 (
292 p_validate in boolean default false
293 ,p_bnft_prvdd_ldgr_id in number
294 ,p_effective_start_date out nocopy date
295 ,p_effective_end_date out nocopy date
296 ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
297 ,p_frftd_val in number default hr_api.g_number
298 ,p_prvdd_val in number default hr_api.g_number
299 ,p_used_val in number default hr_api.g_number
300 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
301 ,p_acty_base_rt_id in number default hr_api.g_number
302 ,p_per_in_ler_id in number default hr_api.g_number
303 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
304 ,p_business_group_id in number default hr_api.g_number
305 ,p_bpl_attribute_category in varchar2 default hr_api.g_varchar2
306 ,p_bpl_attribute1 in varchar2 default hr_api.g_varchar2
307 ,p_bpl_attribute2 in varchar2 default hr_api.g_varchar2
308 ,p_bpl_attribute3 in varchar2 default hr_api.g_varchar2
309 ,p_bpl_attribute4 in varchar2 default hr_api.g_varchar2
310 ,p_bpl_attribute5 in varchar2 default hr_api.g_varchar2
311 ,p_bpl_attribute6 in varchar2 default hr_api.g_varchar2
312 ,p_bpl_attribute7 in varchar2 default hr_api.g_varchar2
313 ,p_bpl_attribute8 in varchar2 default hr_api.g_varchar2
314 ,p_bpl_attribute9 in varchar2 default hr_api.g_varchar2
315 ,p_bpl_attribute10 in varchar2 default hr_api.g_varchar2
316 ,p_bpl_attribute11 in varchar2 default hr_api.g_varchar2
317 ,p_bpl_attribute12 in varchar2 default hr_api.g_varchar2
318 ,p_bpl_attribute13 in varchar2 default hr_api.g_varchar2
319 ,p_bpl_attribute14 in varchar2 default hr_api.g_varchar2
320 ,p_bpl_attribute15 in varchar2 default hr_api.g_varchar2
321 ,p_bpl_attribute16 in varchar2 default hr_api.g_varchar2
322 ,p_bpl_attribute17 in varchar2 default hr_api.g_varchar2
323 ,p_bpl_attribute18 in varchar2 default hr_api.g_varchar2
324 ,p_bpl_attribute19 in varchar2 default hr_api.g_varchar2
325 ,p_bpl_attribute20 in varchar2 default hr_api.g_varchar2
326 ,p_bpl_attribute21 in varchar2 default hr_api.g_varchar2
327 ,p_bpl_attribute22 in varchar2 default hr_api.g_varchar2
328 ,p_bpl_attribute23 in varchar2 default hr_api.g_varchar2
329 ,p_bpl_attribute24 in varchar2 default hr_api.g_varchar2
330 ,p_bpl_attribute25 in varchar2 default hr_api.g_varchar2
331 ,p_bpl_attribute26 in varchar2 default hr_api.g_varchar2
332 ,p_bpl_attribute27 in varchar2 default hr_api.g_varchar2
333 ,p_bpl_attribute28 in varchar2 default hr_api.g_varchar2
334 ,p_bpl_attribute29 in varchar2 default hr_api.g_varchar2
335 ,p_bpl_attribute30 in varchar2 default hr_api.g_varchar2
336 ,p_cash_recd_val in number default hr_api.g_number
337 ,p_rld_up_val in number default hr_api.g_number
338 ,p_effective_date in date
339 ,p_datetrack_mode in varchar2
340 ,p_process_enrt_flag in varchar2 default 'Y'
341 ,p_from_reinstate_enrt_flag in varchar2 default 'N',
342 p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
343 p_cmcd_frftd_val in number default hr_api.g_number,
344 p_cmcd_prvdd_val in number default hr_api.g_number,
345 p_cmcd_rld_up_val in number default hr_api.g_number,
346 p_cmcd_used_val in number default hr_api.g_number,
350 p_ann_prvdd_val in number default hr_api.g_number,
347 p_cmcd_cash_recd_val in number default hr_api.g_number,
348 p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
349 p_ann_frftd_val in number default hr_api.g_number,
351 p_ann_rld_up_val in number default hr_api.g_number,
352 p_ann_used_val in number default hr_api.g_number,
353 p_ann_cash_recd_val in number default hr_api.g_number,
354 p_object_version_number in out nocopy number
355 );
356 --
357 -- ----------------------------------------------------------------------------
358 -- |------------------------< update_Benefit_Prvdd_Ledger_w >-----------------|
359 -- ----------------------------------------------------------------------------
360 -- {Start Of Comments}
361 --
362 -- Description: Self Service wrapper called from Java code.
363 --
364 --
365 -- {End Of Comments}
366 --
367 procedure update_Benefit_Prvdd_Ledger_w
368 (
369 p_validate in varchar2 default 'FALSE'
370 ,p_bnft_prvdd_ldgr_id in number
371 ,p_effective_start_date out nocopy date
372 ,p_effective_end_date out nocopy date
373 ,p_prtt_ro_of_unusd_amt_flag in varchar2 default hr_api.g_varchar2
374 ,p_frftd_val in number default hr_api.g_number
375 ,p_prvdd_val in number default hr_api.g_number
376 ,p_used_val in number default hr_api.g_number
377 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378 ,p_acty_base_rt_id in number default hr_api.g_number
379 ,p_per_in_ler_id in number default hr_api.g_number
380 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
381 ,p_business_group_id in number default hr_api.g_number
382 ,p_cash_recd_val in number default hr_api.g_number
383 ,p_rld_up_val in number default hr_api.g_number
384 ,p_effective_date in date
385 ,p_datetrack_mode in varchar2
386 ,p_process_enrt_flag in varchar2 default 'Y'
387 ,p_from_reinstate_enrt_flag in varchar2 default 'N',
388 p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
389 p_cmcd_frftd_val in number default hr_api.g_number,
390 p_cmcd_prvdd_val in number default hr_api.g_number,
391 p_cmcd_rld_up_val in number default hr_api.g_number,
392 p_cmcd_used_val in number default hr_api.g_number,
393 p_cmcd_cash_recd_val in number default hr_api.g_number,
394 p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
395 p_ann_frftd_val in number default hr_api.g_number,
396 p_ann_prvdd_val in number default hr_api.g_number,
397 p_ann_rld_up_val in number default hr_api.g_number,
398 p_ann_used_val in number default hr_api.g_number,
399 p_ann_cash_recd_val in number default hr_api.g_number,
400 p_object_version_number in out nocopy number
401 );
402 --
403 -- ----------------------------------------------------------------------------
404 -- |------------------------< delete_Benefit_Prvdd_Ledger >------------------------|
405 -- ----------------------------------------------------------------------------
406 -- {Start Of Comments}
407 --
408 -- Description:
409 --
410 -- Prerequisites:
411 --
412 --
413 -- In Parameters:
414 -- Name Reqd Type Description
415 -- p_validate Yes boolean Commit or Rollback.
416 -- p_bnft_prvdd_ldgr_id Yes number PK of record
417 -- p_effective_date Yes date Session Date.
418 -- p_datetrack_mode Yes varchar2 Datetrack mode.
419 -- p_process_enrt_flag No varchar2 Process related enrollments.
420 --
421 -- Post Success:
422 --
423 -- Name Type Description
424 -- p_effective_start_date Yes date Effective Start Date of Record
425 -- p_effective_end_date Yes date Effective End Date of Record
426 -- p_object_version_number No number OVN of record
427 --
428 -- Post Failure:
429 --
430 -- Access Status:
431 -- Public.
432 --
433 -- {End Of Comments}
434 --
435 procedure delete_Benefit_Prvdd_Ledger
436 (
437 p_validate in boolean default false
438 ,p_bnft_prvdd_ldgr_id in number
439 ,p_effective_start_date out nocopy date
440 ,p_effective_end_date out nocopy date
441 ,p_object_version_number in out nocopy number
442 ,p_effective_date in date
443 ,p_datetrack_mode in varchar2
444 ,p_business_group_id in number
445 ,p_process_enrt_flag in varchar2 default 'Y'
446 ,p_from_reinstate_enrt_flag in varchar2 default 'N'
447 );
448 --
449 -- ----------------------------------------------------------------------------
450 -- |------------------------< delete_Benefit_Prvdd_Ledger_w >-----------------|
451 -- ----------------------------------------------------------------------------
452 -- {Start Of Comments}
453 --
454 -- Description: Self Service wrapper called from Java code.
455 --
456 -- Prerequisites:
457 --
458 --
459 -- In Parameters:
460 -- Name Reqd Type Description
461 -- p_validate Yes varchar2 TRUE or FALSE
462 -- p_bnft_prvdd_ldgr_id Yes number PK of record
463 -- p_effective_date Yes date Session Date.
464 -- p_datetrack_mode Yes varchar2 Datetrack mode.
465 -- p_process_enrt_flag No varchar2 Process related enrollments.
466 --
467 -- Post Success:
468 --
469 -- Name Type Description
470 -- p_effective_start_date Yes date Effective Start Date of Record
471 -- p_effective_end_date Yes date Effective End Date of Record
472 -- p_object_version_number No number OVN of record
473 --
474 -- Post Failure:
475 --
476 -- Access Status:
477 -- Public.
478 --
479 -- {End Of Comments}
480 --
481 procedure delete_Benefit_Prvdd_Ledger_w
482 (
483 p_validate in varchar2 default 'FALSE'
484 ,p_bnft_prvdd_ldgr_id in number
485 ,p_effective_start_date out nocopy date
486 ,p_effective_end_date out nocopy date
487 ,p_object_version_number in out nocopy number
488 ,p_effective_date in date
489 ,p_datetrack_mode in varchar2
490 ,p_business_group_id in number
491 ,p_process_enrt_flag in varchar2 default 'Y'
492 ,p_from_reinstate_enrt_flag in varchar2 default 'N'
493 );
494 --
495 -- ----------------------------------------------------------------------------
496 -- |----------------------------------< lck >---------------------------------|
497 -- ----------------------------------------------------------------------------
498 -- {Start Of Comments}
499 --
500 -- Description:
501 --
502 -- Prerequisites:
503 --
504 --
505 -- In Parameters:
506 -- Name Reqd Type Description
507 -- p_bnft_prvdd_ldgr_id Yes number PK of record
508 -- p_object_version_number Yes number OVN of record
509 -- p_effective_date Yes date Session Date.
510 -- p_datetrack_mode Yes varchar2 Datetrack mode.
511 --
512 -- Post Success:
513 --
514 -- Name Type Description
515 -- p_validation_start_date Yes Derived Effective Start Date.
516 -- p_validation_end_date Yes Derived Effective End Date.
517 --
518 -- Post Failure:
519 --
520 -- Access Status:
521 -- Public.
522 --
523 -- {End Of Comments}
524 --
525 procedure lck
526 (
527 p_bnft_prvdd_ldgr_id in number
528 ,p_object_version_number in number
529 ,p_effective_date in date
530 ,p_datetrack_mode in varchar2
531 ,p_validation_start_date out nocopy date
532 ,p_validation_end_date out nocopy date
533 );
534 --
535 end ben_Benefit_Prvdd_Ledger_api;