1 Package ben_ELIG_DPNT_api AUTHID CURRENT_USER as
2 /* $Header: beegdapi.pkh 120.5 2009/04/10 04:29:39 pvelvano ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_ELIG_DPNT >------------------------|
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_create_dt Yes date
18 -- p_elig_strt_dt No date
19 -- p_elig_thru_dt No date
20 -- p_ovrdn_flag Yes varchar2
21 -- p_ovrdn_thru_dt No date
22 -- p_inelg_rsn_cd No varchar2
23 -- p_dpnt_inelig_flag Yes varchar2
24 -- p_elig_per_elctbl_chc_id No number
25 -- p_per_in_ler_id No number
26 -- p_elig_per_id No number
27 -- p_elig_per_opt_id No number
28 -- p_elig_cvrd_dpnt_id No number
29 -- p_dpnt_person_id Yes number
30 -- p_business_group_id Yes number Business Group of Record
31 -- p_egd_attribute_category No varchar2 Descriptive Flexfield
32 -- p_egd_attribute1 No varchar2 Descriptive Flexfield
33 -- p_egd_attribute2 No varchar2 Descriptive Flexfield
34 -- p_egd_attribute3 No varchar2 Descriptive Flexfield
35 -- p_egd_attribute4 No varchar2 Descriptive Flexfield
36 -- p_egd_attribute5 No varchar2 Descriptive Flexfield
37 -- p_egd_attribute6 No varchar2 Descriptive Flexfield
38 -- p_egd_attribute7 No varchar2 Descriptive Flexfield
39 -- p_egd_attribute8 No varchar2 Descriptive Flexfield
43 -- p_egd_attribute12 No varchar2 Descriptive Flexfield
40 -- p_egd_attribute9 No varchar2 Descriptive Flexfield
41 -- p_egd_attribute10 No varchar2 Descriptive Flexfield
42 -- p_egd_attribute11 No varchar2 Descriptive Flexfield
44 -- p_egd_attribute13 No varchar2 Descriptive Flexfield
45 -- p_egd_attribute14 No varchar2 Descriptive Flexfield
46 -- p_egd_attribute15 No varchar2 Descriptive Flexfield
47 -- p_egd_attribute16 No varchar2 Descriptive Flexfield
48 -- p_egd_attribute17 No varchar2 Descriptive Flexfield
49 -- p_egd_attribute18 No varchar2 Descriptive Flexfield
50 -- p_egd_attribute19 No varchar2 Descriptive Flexfield
51 -- p_egd_attribute20 No varchar2 Descriptive Flexfield
52 -- p_egd_attribute21 No varchar2 Descriptive Flexfield
53 -- p_egd_attribute22 No varchar2 Descriptive Flexfield
54 -- p_egd_attribute23 No varchar2 Descriptive Flexfield
55 -- p_egd_attribute24 No varchar2 Descriptive Flexfield
56 -- p_egd_attribute25 No varchar2 Descriptive Flexfield
57 -- p_egd_attribute26 No varchar2 Descriptive Flexfield
58 -- p_egd_attribute27 No varchar2 Descriptive Flexfield
59 -- p_egd_attribute28 No varchar2 Descriptive Flexfield
60 -- p_egd_attribute29 No varchar2 Descriptive Flexfield
61 -- p_egd_attribute30 No varchar2 Descriptive Flexfield
62 -- p_request_id No number
63 -- p_program_application_id No number
64 -- p_program_id No number
65 -- p_program_update_date No date
66 -- p_effective_date Yes date Session Date.
67 --
68 -- Post Success:
69 --
70 -- Out Parameters:
71 -- Name Type Description
72 -- p_elig_dpnt_id Yes number PK of record
73 -- p_object_version_number No number OVN of record
74 --
75 -- Post Failure:
76 --
77 -- Access Status:
78 -- Public.
79 --
80 -- {End Of Comments}
81 --
82 procedure create_ELIG_DPNT
83 (
84 p_validate in boolean default false
85 ,p_elig_dpnt_id out nocopy number
86 ,p_create_dt in date default null
87 ,p_elig_strt_dt in date default null
88 ,p_elig_thru_dt in date default null
89 ,p_ovrdn_flag in varchar2 default 'N'
90 ,p_ovrdn_thru_dt in date default null
91 ,p_inelg_rsn_cd in varchar2 default null
92 ,p_dpnt_inelig_flag in varchar2 default 'N'
93 ,p_elig_per_elctbl_chc_id in number default null
94 ,p_per_in_ler_id in number default null
95 ,p_elig_per_id in number default null
96 ,p_elig_per_opt_id in number default null
97 ,p_elig_cvrd_dpnt_id in number default null
98 ,p_dpnt_person_id in number default null
99 ,p_business_group_id in number default null
100 ,p_egd_attribute_category in varchar2 default null
101 ,p_egd_attribute1 in varchar2 default null
102 ,p_egd_attribute2 in varchar2 default null
103 ,p_egd_attribute3 in varchar2 default null
104 ,p_egd_attribute4 in varchar2 default null
105 ,p_egd_attribute5 in varchar2 default null
106 ,p_egd_attribute6 in varchar2 default null
107 ,p_egd_attribute7 in varchar2 default null
108 ,p_egd_attribute8 in varchar2 default null
109 ,p_egd_attribute9 in varchar2 default null
110 ,p_egd_attribute10 in varchar2 default null
111 ,p_egd_attribute11 in varchar2 default null
112 ,p_egd_attribute12 in varchar2 default null
113 ,p_egd_attribute13 in varchar2 default null
114 ,p_egd_attribute14 in varchar2 default null
115 ,p_egd_attribute15 in varchar2 default null
116 ,p_egd_attribute16 in varchar2 default null
117 ,p_egd_attribute17 in varchar2 default null
118 ,p_egd_attribute18 in varchar2 default null
119 ,p_egd_attribute19 in varchar2 default null
120 ,p_egd_attribute20 in varchar2 default null
121 ,p_egd_attribute21 in varchar2 default null
122 ,p_egd_attribute22 in varchar2 default null
123 ,p_egd_attribute23 in varchar2 default null
124 ,p_egd_attribute24 in varchar2 default null
125 ,p_egd_attribute25 in varchar2 default null
126 ,p_egd_attribute26 in varchar2 default null
127 ,p_egd_attribute27 in varchar2 default null
128 ,p_egd_attribute28 in varchar2 default null
129 ,p_egd_attribute29 in varchar2 default null
130 ,p_egd_attribute30 in varchar2 default null
131 ,p_request_id in number default null
132 ,p_program_application_id in number default null
133 ,p_program_id in number default null
134 ,p_program_update_date in date default null
135 ,p_object_version_number out nocopy number
136 ,p_effective_date in date
137 );
138 --
139 -- Performance cover
140 --
141 -- ----------------------------------------------------------------------------
142 -- |------------------------< create_perf_ELIG_DPNT >------------------------|
143 -- ----------------------------------------------------------------------------
147 ,p_create_dt in date default null
144 procedure create_perf_ELIG_DPNT
145 (p_validate in boolean default false
146 ,p_elig_dpnt_id out nocopy number
148 ,p_elig_strt_dt in date default null
149 ,p_elig_thru_dt in date default null
150 ,p_ovrdn_flag in varchar2 default 'N'
151 ,p_ovrdn_thru_dt in date default null
152 ,p_inelg_rsn_cd in varchar2 default null
153 ,p_dpnt_inelig_flag in varchar2 default 'N'
154 ,p_elig_per_elctbl_chc_id in number default null
155 ,p_per_in_ler_id in number default null
156 ,p_elig_per_id in number default null
157 ,p_elig_per_opt_id in number default null
158 ,p_elig_cvrd_dpnt_id in number default null
159 ,p_dpnt_person_id in number default null
160 ,p_business_group_id in number default null
161 ,p_egd_attribute_category in varchar2 default null
162 ,p_egd_attribute1 in varchar2 default null
163 ,p_egd_attribute2 in varchar2 default null
164 ,p_egd_attribute3 in varchar2 default null
165 ,p_egd_attribute4 in varchar2 default null
166 ,p_egd_attribute5 in varchar2 default null
167 ,p_egd_attribute6 in varchar2 default null
168 ,p_egd_attribute7 in varchar2 default null
169 ,p_egd_attribute8 in varchar2 default null
170 ,p_egd_attribute9 in varchar2 default null
171 ,p_egd_attribute10 in varchar2 default null
172 ,p_egd_attribute11 in varchar2 default null
173 ,p_egd_attribute12 in varchar2 default null
174 ,p_egd_attribute13 in varchar2 default null
175 ,p_egd_attribute14 in varchar2 default null
176 ,p_egd_attribute15 in varchar2 default null
177 ,p_egd_attribute16 in varchar2 default null
178 ,p_egd_attribute17 in varchar2 default null
179 ,p_egd_attribute18 in varchar2 default null
180 ,p_egd_attribute19 in varchar2 default null
181 ,p_egd_attribute20 in varchar2 default null
182 ,p_egd_attribute21 in varchar2 default null
183 ,p_egd_attribute22 in varchar2 default null
184 ,p_egd_attribute23 in varchar2 default null
185 ,p_egd_attribute24 in varchar2 default null
186 ,p_egd_attribute25 in varchar2 default null
187 ,p_egd_attribute26 in varchar2 default null
188 ,p_egd_attribute27 in varchar2 default null
189 ,p_egd_attribute28 in varchar2 default null
190 ,p_egd_attribute29 in varchar2 default null
191 ,p_egd_attribute30 in varchar2 default null
192 ,p_request_id in number default null
193 ,p_program_application_id in number default null
194 ,p_program_id in number default null
195 ,p_program_update_date in date default null
196 ,p_object_version_number out nocopy number
197 ,p_effective_date in date
198 );
199 -- ----------------------------------------------------------------------------
200 -- |------------------------< update_ELIG_DPNT >------------------------|
201 -- ----------------------------------------------------------------------------
202 -- {Start Of Comments}
203 --
204 -- Description:
205 --
206 -- Prerequisites:
207 --
208 --
209 -- In Parameters:
210 -- Name Reqd Type Description
211 -- p_validate Yes boolean Commit or Rollback.
212 -- p_elig_dpnt_id Yes number PK of record
213 -- p_create_dt Yes date
214 -- p_elig_strt_dt No date
215 -- p_elig_thru_dt No date
216 -- p_ovrdn_flag Yes varchar2
217 -- p_ovrdn_thru_dt No date
218 -- p_inelg_rsn_cd No varchar2
219 -- p_dpnt_inelig_flag Yes varchar2
220 -- p_elig_per_elctbl_chc_id No number
221 -- p_per_in_ler_id No number
222 -- p_elig_per_id No number
223 -- p_elig_per_opt_id No number
224 -- p_elig_cvrd_dpnt_id No number
225 -- p_dpnt_person_id Yes number
226 -- p_business_group_id Yes number Business Group of Record
227 -- p_egd_attribute_category No varchar2 Descriptive Flexfield
228 -- p_egd_attribute1 No varchar2 Descriptive Flexfield
229 -- p_egd_attribute2 No varchar2 Descriptive Flexfield
230 -- p_egd_attribute3 No varchar2 Descriptive Flexfield
231 -- p_egd_attribute4 No varchar2 Descriptive Flexfield
232 -- p_egd_attribute5 No varchar2 Descriptive Flexfield
233 -- p_egd_attribute6 No varchar2 Descriptive Flexfield
234 -- p_egd_attribute7 No varchar2 Descriptive Flexfield
235 -- p_egd_attribute8 No varchar2 Descriptive Flexfield
236 -- p_egd_attribute9 No varchar2 Descriptive Flexfield
237 -- p_egd_attribute10 No varchar2 Descriptive Flexfield
238 -- p_egd_attribute11 No varchar2 Descriptive Flexfield
239 -- p_egd_attribute12 No varchar2 Descriptive Flexfield
240 -- p_egd_attribute13 No varchar2 Descriptive Flexfield
241 -- p_egd_attribute14 No varchar2 Descriptive Flexfield
242 -- p_egd_attribute15 No varchar2 Descriptive Flexfield
246 -- p_egd_attribute19 No varchar2 Descriptive Flexfield
243 -- p_egd_attribute16 No varchar2 Descriptive Flexfield
244 -- p_egd_attribute17 No varchar2 Descriptive Flexfield
245 -- p_egd_attribute18 No varchar2 Descriptive Flexfield
247 -- p_egd_attribute20 No varchar2 Descriptive Flexfield
248 -- p_egd_attribute21 No varchar2 Descriptive Flexfield
249 -- p_egd_attribute22 No varchar2 Descriptive Flexfield
250 -- p_egd_attribute23 No varchar2 Descriptive Flexfield
251 -- p_egd_attribute24 No varchar2 Descriptive Flexfield
252 -- p_egd_attribute25 No varchar2 Descriptive Flexfield
253 -- p_egd_attribute26 No varchar2 Descriptive Flexfield
254 -- p_egd_attribute27 No varchar2 Descriptive Flexfield
255 -- p_egd_attribute28 No varchar2 Descriptive Flexfield
256 -- p_egd_attribute29 No varchar2 Descriptive Flexfield
257 -- p_egd_attribute30 No varchar2 Descriptive Flexfield
258 -- p_request_id No number
259 -- p_program_application_id No number
260 -- p_program_id No number
261 -- p_program_update_date No date
262 -- p_effective_date Yes date Session Date.
263 --
264 -- Post Success:
265 --
266 -- Name Type Description
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_ELIG_DPNT
277 (
278 p_validate in boolean default false
279 ,p_elig_dpnt_id in number
280 ,p_create_dt in date default hr_api.g_date
281 ,p_elig_strt_dt in date default hr_api.g_date
282 ,p_elig_thru_dt in date default hr_api.g_date
283 ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
284 ,p_ovrdn_thru_dt in date default hr_api.g_date
285 ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
286 ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
287 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
288 ,p_per_in_ler_id in number default hr_api.g_number
289 ,p_elig_per_id in number default hr_api.g_number
290 ,p_elig_per_opt_id in number default hr_api.g_number
291 ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
292 ,p_dpnt_person_id in number default hr_api.g_number
293 ,p_business_group_id in number default hr_api.g_number
294 ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
295 ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
296 ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
297 ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
298 ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
299 ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
300 ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
301 ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
302 ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
303 ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
304 ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
305 ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
306 ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
307 ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
308 ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
309 ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
310 ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
311 ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
312 ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
313 ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
314 ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
315 ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
316 ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
317 ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
318 ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
319 ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
320 ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
321 ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
322 ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
323 ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
324 ,p_egd_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_effective_date in date
331 );
332 --
333 -- Performance cover
334 --
335 -- ----------------------------------------------------------------------------
336 -- |------------------------< update_perf_ELIG_DPNT >------------------------|
340 p_validate in boolean default false
337 -- ----------------------------------------------------------------------------
338 procedure update_perf_ELIG_DPNT
339 (
341 ,p_elig_dpnt_id in number
342 ,p_create_dt in date default hr_api.g_date
343 ,p_elig_strt_dt in date default hr_api.g_date
344 ,p_elig_thru_dt in date default hr_api.g_date
345 ,p_ovrdn_flag in varchar2 default hr_api.g_varchar2
346 ,p_ovrdn_thru_dt in date default hr_api.g_date
347 ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
348 ,p_dpnt_inelig_flag in varchar2 default hr_api.g_varchar2
349 ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
350 ,p_per_in_ler_id in number default hr_api.g_number
351 ,p_elig_per_id in number default hr_api.g_number
352 ,p_elig_per_opt_id in number default hr_api.g_number
353 ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
354 ,p_dpnt_person_id in number default hr_api.g_number
355 ,p_business_group_id in number default hr_api.g_number
356 ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
357 ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
358 ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
359 ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
360 ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
361 ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
362 ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
363 ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
364 ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
365 ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
366 ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
367 ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
368 ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
369 ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
370 ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
371 ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
372 ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
373 ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
374 ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
375 ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
376 ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
377 ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
378 ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
379 ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
380 ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
381 ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
382 ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
383 ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
384 ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
385 ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
386 ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
387 ,p_request_id in number default hr_api.g_number
388 ,p_program_application_id in number default hr_api.g_number
389 ,p_program_id in number default hr_api.g_number
390 ,p_program_update_date in date default hr_api.g_date
391 ,p_object_version_number in out nocopy number
392 ,p_effective_date in date
393 );
394 --
395 -- ----------------------------------------------------------------------------
396 -- |------------------------< delete_ELIG_DPNT >------------------------|
397 -- ----------------------------------------------------------------------------
398 -- {Start Of Comments}
399 --
400 -- Description:
401 --
402 -- Prerequisites:
403 --
404 --
405 -- In Parameters:
406 -- Name Reqd Type Description
407 -- p_validate Yes boolean Commit or Rollback.
408 -- p_elig_dpnt_id Yes number PK of record
409 -- p_effective_date Yes date Session Date.
410 --
411 -- Post Success:
412 --
413 -- Name Type Description
414 -- p_object_version_number No number OVN of record
415 --
416 -- Post Failure:
417 --
418 -- Access Status:
419 -- Public.
420 --
421 -- {End Of Comments}
422 --
423 procedure delete_ELIG_DPNT
424 (
425 p_validate in boolean default false
426 ,p_elig_dpnt_id in number
427 ,p_object_version_number in out nocopy number
428 ,p_effective_date in date
429 );
430 --
431 -- ----------------------------------------------------------------------------
432 -- |----------------------------------< lck >---------------------------------|
433 -- ----------------------------------------------------------------------------
434 -- {Start Of Comments}
435 --
436 -- Description:
437 --
438 -- Prerequisites:
439 --
440 --
441 -- In Parameters:
442 -- Name Reqd Type Description
443 -- p_elig_dpnt_id Yes number PK of record
444 -- p_object_version_number Yes number OVN of record
445 --
446 -- Post Success:
447 --
451 --
448 -- Name Type Description
449 --
450 -- Post Failure:
452 -- Access Status:
453 -- Public.
454 --
455 -- {End Of Comments}
456 --
457 procedure lck
458 (
459 p_elig_dpnt_id in number
460 ,p_object_version_number in number
461 );
462 -- ----------------------------------------------------------------------------
463 -- |---------------------< process_dependent >---------------------------------|
464 -- ----------------------------------------------------------------------------
465 procedure process_dependent(p_validate in boolean default false,
466 p_elig_dpnt_id in number,
467 p_business_group_id in number,
468 p_effective_date in date,
469 p_cvg_strt_dt in date,
470 p_cvg_thru_dt in date,
471 p_datetrack_mode in varchar2,
472 p_pdp_attribute_category in varchar2 default null,
473 p_pdp_attribute1 in varchar2 default null,
474 p_pdp_attribute2 in varchar2 default null,
475 p_pdp_attribute3 in varchar2 default null,
476 p_pdp_attribute4 in varchar2 default null,
477 p_pdp_attribute5 in varchar2 default null,
478 p_pdp_attribute6 in varchar2 default null,
479 p_pdp_attribute7 in varchar2 default null,
480 p_pdp_attribute8 in varchar2 default null,
481 p_pdp_attribute9 in varchar2 default null,
482 p_pdp_attribute10 in varchar2 default null,
483 p_pdp_attribute11 in varchar2 default null,
484 p_pdp_attribute12 in varchar2 default null,
485 p_pdp_attribute13 in varchar2 default null,
486 p_pdp_attribute14 in varchar2 default null,
487 p_pdp_attribute15 in varchar2 default null,
488 p_pdp_attribute16 in varchar2 default null,
489 p_pdp_attribute17 in varchar2 default null,
490 p_pdp_attribute18 in varchar2 default null,
491 p_pdp_attribute19 in varchar2 default null,
492 p_pdp_attribute20 in varchar2 default null,
493 p_pdp_attribute21 in varchar2 default null,
494 p_pdp_attribute22 in varchar2 default null,
495 p_pdp_attribute23 in varchar2 default null,
496 p_pdp_attribute24 in varchar2 default null,
497 p_pdp_attribute25 in varchar2 default null,
498 p_pdp_attribute26 in varchar2 default null,
499 p_pdp_attribute27 in varchar2 default null,
500 p_pdp_attribute28 in varchar2 default null,
501 p_pdp_attribute29 in varchar2 default null,
502 p_pdp_attribute30 in varchar2 default null,
503 p_elig_cvrd_dpnt_id out nocopy number,
504 p_effective_start_date out nocopy date,
505 p_effective_end_date out nocopy date,
506 p_object_version_number in out nocopy number
507 ,p_multi_row_actn in BOOLEAN default FALSE);
508 -- ----------------------------------------------------------------------------
509 -- |---------------------< process_dependent_w >------------------------------|
510 -- ----------------------------------------------------------------------------
511 procedure process_dependent_w(p_validate in varchar2,
512 p_elig_dpnt_id in number,
513 p_business_group_id in number,
514 p_effective_date in date,
515 p_cvg_strt_dt in date,
516 p_cvg_thru_dt in date,
517 p_datetrack_mode in varchar2,
518 p_elig_cvrd_dpnt_id out nocopy number,
519 p_effective_start_date out nocopy date,
520 p_effective_end_date out nocopy date,
521 p_object_version_number in out nocopy number
522 ,p_multi_row_actn in varchar2);
523 -- ----------------------------------------------------------------------------
524 -- |---------------------< store_crt_ord_warnings_ss >------------------------------|
525 -- ----------------------------------------------------------------------------
526 procedure store_crt_ord_warning_ss(p_person_id in number,
527 p_crt_ord_warning in varchar2);
528 -- ----------------------------------------------------------------------------
529 -- |---------------------< store_crt_ord_warng_DDNA >------------------------------|
530 -- ----------------------------------------------------------------------------
531 procedure store_crt_ord_warng_DDNA(p_person_id in number,
532 p_per_in_ler_id in number,
533 p_pgm_id in number,
534 p_effective_date in date,
535 p_business_group_id in number);
539 procedure get_crt_ordr_typ(p_person_id in number,
536 -- ----------------------------------------------------------------------------
537 -- |----------------------< get_crt_ordr_typ >------------------------------|
538 -- ----------------------------------------------------------------------------
540 p_pl_id in number,
541 p_pl_typ_id in number,
542 l_crt_ordr_meaning out nocopy varchar2);
543 -- ----------------------------------------------------------------------------
544 -- |---------------------< get_elig_dpnt_rec >---------------------------------|
545 -- ----------------------------------------------------------------------------
546 function get_elig_dpnt_rec(p_elig_dpnt_id in number,
547 p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
548 return boolean;
549
550 function get_elig_dpnt_rec(p_elig_cvrd_dpnt_id in number,
551 p_effective_date in date,
552 p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
553 return boolean;
554
555 function get_elig_dpnt_rec(p_dpnt_person_id in number,
556 p_prtt_enrt_rslt_id in number,
557 p_effective_date in date,
558 p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
559 return boolean;
560
561 function get_elig_dpnt_rec
562 (p_pgm_id in number default null
563 ,p_pl_id in number default null
564 ,p_oipl_id in number default null
565 ,p_dpnt_person_id in number
566 ,p_effective_date in date
567 --
568 ,p_per_in_ler_id in number default null
569 ,p_elig_per_id in number default null
570 ,p_elig_per_opt_id in number default null
571 ,p_opt_id in number default null
572 --
573 ,p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype
574 )
575 return boolean;
576
577 -- ----------------------------------------------------------------------------
578 -- |------------------------< get_elig_per_id >------------------------|
579 -- ----------------------------------------------------------------------------
580 procedure get_elig_per_id(p_person_id in number,
581 p_pgm_id in number default null,
582 p_pl_id in number default null,
583 p_oipl_id in number default null,
584 p_business_group_id in number,
585 p_effective_date in date,
586 p_elig_per_id out nocopy number,
587 p_elig_per_opt_id out nocopy number);
588
589
590 /*Added the procedure for Bug 8414373 */
591 -- ----------------------------------------------------------------------------
592 -- |---------------------------< chk_enrt_for_dpnt >-----------------|
593 -- ----------------------------------------------------------------------------
594 --
595 procedure chk_enrt_for_dpnt
596 (
597 p_dpnt_person_id in number
598 ,p_dpnt_rltp_id in number
599 ,p_rltp_type in varchar2
600 ,p_business_group_id in number
601 );
602 --
603 --
604 end ben_ELIG_DPNT_api;
[Home] [Help]