1 Package ben_Eligible_Person_api AUTHID CURRENT_USER as
2 /* $Header: bepepapi.pkh 120.0 2005/05/28 10:39:02 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Eligible_Person >------------------------|
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_pl_id No number
19 -- p_pgm_id No number
20 -- p_ler_id No number
21 -- p_person_id Yes number
22 -- p_per_in_ler_id Yes number
23 -- p_dpnt_othr_pl_cvrd_rl_flag Yes varchar2
24 -- p_prtn_ovridn_thru_dt No date
25 -- p_pl_key_ee_flag Yes varchar2
26 -- p_pl_hghly_compd_flag Yes varchar2
27 -- p_elig_flag Yes varchar2
28 -- p_comp_ref_amt No number
29 -- p_cmbn_age_n_los_val No number
30 -- p_comp_ref_uom No varchar2
31 -- p_age_val No number
32 -- p_los_val No number
33 -- p_prtn_end_dt No date
34 -- p_prtn_strt_dt No date
35 -- p_wait_perd_cmpltn_dt No date
36 -- p_wait_perd_strt_dt No date
37 -- p_wv_ctfn_typ_cd No varchar2
38 -- p_hrs_wkd_val No number
39 -- p_hrs_wkd_bndry_perd_cd No varchar2
40 -- p_prtn_ovridn_flag Yes varchar2
41 -- p_no_mx_prtn_ovrid_thru_flag Yes varchar2
42 -- p_prtn_ovridn_rsn_cd No varchar2
43 -- p_age_uom No varchar2
44 -- p_los_uom No varchar2
45 -- p_ovrid_svc_dt No date
46 -- p_frz_los_flag Yes varchar2
47 -- p_frz_age_flag Yes varchar2
48 -- p_frz_cmp_lvl_flag Yes varchar2
49 -- p_frz_pct_fl_tm_flag Yes varchar2
50 -- p_frz_hrs_wkd_flag Yes varchar2
51 -- p_frz_comb_age_and_los_flag Yes varchar2
52 -- p_dstr_rstcn_flag Yes varchar2
53 -- p_pct_fl_tm_val No number
54 -- p_wv_prtn_rsn_cd No varchar2
55 -- p_pl_wvd_flag Yes varchar2
56 -- p_pep_attribute_category No varchar2 Descriptive Flexfield
57 -- p_pep_attribute1 No varchar2 Descriptive Flexfield
58 -- p_pep_attribute2 No varchar2 Descriptive Flexfield
59 -- p_pep_attribute3 No varchar2 Descriptive Flexfield
60 -- p_pep_attribute4 No varchar2 Descriptive Flexfield
61 -- p_pep_attribute5 No varchar2 Descriptive Flexfield
62 -- p_pep_attribute6 No varchar2 Descriptive Flexfield
63 -- p_pep_attribute7 No varchar2 Descriptive Flexfield
64 -- p_pep_attribute8 No varchar2 Descriptive Flexfield
65 -- p_pep_attribute9 No varchar2 Descriptive Flexfield
66 -- p_pep_attribute10 No varchar2 Descriptive Flexfield
67 -- p_pep_attribute11 No varchar2 Descriptive Flexfield
68 -- p_pep_attribute12 No varchar2 Descriptive Flexfield
69 -- p_pep_attribute13 No varchar2 Descriptive Flexfield
70 -- p_pep_attribute14 No varchar2 Descriptive Flexfield
71 -- p_pep_attribute15 No varchar2 Descriptive Flexfield
72 -- p_pep_attribute16 No varchar2 Descriptive Flexfield
73 -- p_pep_attribute17 No varchar2 Descriptive Flexfield
74 -- p_pep_attribute18 No varchar2 Descriptive Flexfield
75 -- p_pep_attribute19 No varchar2 Descriptive Flexfield
76 -- p_pep_attribute20 No varchar2 Descriptive Flexfield
77 -- p_pep_attribute21 No varchar2 Descriptive Flexfield
78 -- p_pep_attribute22 No varchar2 Descriptive Flexfield
79 -- p_pep_attribute23 No varchar2 Descriptive Flexfield
80 -- p_pep_attribute24 No varchar2 Descriptive Flexfield
81 -- p_pep_attribute25 No varchar2 Descriptive Flexfield
82 -- p_pep_attribute26 No varchar2 Descriptive Flexfield
83 -- p_pep_attribute27 No varchar2 Descriptive Flexfield
84 -- p_pep_attribute28 No varchar2 Descriptive Flexfield
85 -- p_pep_attribute29 No varchar2 Descriptive Flexfield
86 -- p_pep_attribute30 No varchar2 Descriptive Flexfield
87 -- p_request_id No number
88 -- p_program_application_id No number
89 -- p_program_id No number
90 -- p_program_update_date No date
91 -- p_effective_date Yes date Session Date.
92 --
93 -- Post Success:
94 --
95 -- Out Parameters:
96 -- Name Type Description
97 -- p_elig_per_id Yes number PK of record
98 -- p_effective_start_date Yes date Effective Start Date of Record
99 -- p_effective_end_date Yes date Effective End Date of Record
100 -- p_object_version_number No number OVN of record
101 --
102 -- Post Failure:
103 --
104 -- Access Status:
105 -- Public.
106 --
107 -- {End Of Comments}
108 --
109 procedure create_Eligible_Person
110 (p_validate in boolean default false
111 ,p_elig_per_id out nocopy number
112 ,p_effective_start_date out nocopy date
113 ,p_effective_end_date out nocopy date
114 ,p_business_group_id in number default null
115 ,p_pl_id in number default null
116 ,p_pgm_id in number default null
117 ,p_plip_id in number default null
118 ,p_ptip_id in number default null
119 ,p_ler_id in number default null
120 ,p_person_id in number default null
121 ,p_per_in_ler_id in number default null
122 ,p_dpnt_othr_pl_cvrd_rl_flag in varchar2 default 'N'
123 ,p_prtn_ovridn_thru_dt in date default null
124 ,p_pl_key_ee_flag in varchar2 default 'N'
125 ,p_pl_hghly_compd_flag in varchar2 default 'N'
126 ,p_elig_flag in varchar2 default 'N'
127 ,p_comp_ref_amt in number default null
128 ,p_cmbn_age_n_los_val in number default null
129 ,p_comp_ref_uom in varchar2 default null
130 ,p_age_val in number default null
131 ,p_los_val in number default null
132 ,p_prtn_end_dt in date default null
133 ,p_prtn_strt_dt in date default null
134 ,p_wait_perd_cmpltn_dt in date default null
135 ,p_wait_perd_strt_dt in date default null
136 ,p_wv_ctfn_typ_cd in varchar2 default null
137 ,p_hrs_wkd_val in number default null
138 ,p_hrs_wkd_bndry_perd_cd in varchar2 default null
139 ,p_prtn_ovridn_flag in varchar2 default null
140 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default 'N'
141 ,p_prtn_ovridn_rsn_cd in varchar2 default null
142 ,p_age_uom in varchar2 default null
143 ,p_los_uom in varchar2 default null
144 ,p_ovrid_svc_dt in date default null
145 ,p_inelg_rsn_cd in varchar2 default null
146 ,p_frz_los_flag in varchar2 default 'N'
147 ,p_frz_age_flag in varchar2 default 'N'
148 ,p_frz_cmp_lvl_flag in varchar2 default 'N'
149 ,p_frz_pct_fl_tm_flag in varchar2 default 'N'
150 ,p_frz_hrs_wkd_flag in varchar2 default 'N'
151 ,p_frz_comb_age_and_los_flag in varchar2 default 'N'
152 ,p_dstr_rstcn_flag in varchar2 default 'N'
153 ,p_pct_fl_tm_val in number default null
154 ,p_wv_prtn_rsn_cd in varchar2 default null
155 ,p_pl_wvd_flag in varchar2 default 'N'
156 ,p_rt_comp_ref_amt in number default null
157 ,p_rt_cmbn_age_n_los_val in number default null
158 ,p_rt_comp_ref_uom in varchar2 default null
159 ,p_rt_age_val in number default null
160 ,p_rt_los_val in number default null
161 ,p_rt_hrs_wkd_val in number default null
162 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default null
163 ,p_rt_age_uom in varchar2 default null
164 ,p_rt_los_uom in varchar2 default null
165 ,p_rt_pct_fl_tm_val in number default null
166 ,p_rt_frz_los_flag in varchar2 default 'N'
167 ,p_rt_frz_age_flag in varchar2 default 'N'
168 ,p_rt_frz_cmp_lvl_flag in varchar2 default 'N'
169 ,p_rt_frz_pct_fl_tm_flag in varchar2 default 'N'
170 ,p_rt_frz_hrs_wkd_flag in varchar2 default 'N'
171 ,p_rt_frz_comb_age_and_los_flag in varchar2 default 'N'
172 ,p_once_r_cntug_cd in varchar2 default null
173 ,p_pl_ordr_num in number default null
174 ,p_plip_ordr_num in number default null
175 ,p_ptip_ordr_num in number default null
176 ,p_pep_attribute_category in varchar2 default null
177 ,p_pep_attribute1 in varchar2 default null
178 ,p_pep_attribute2 in varchar2 default null
179 ,p_pep_attribute3 in varchar2 default null
180 ,p_pep_attribute4 in varchar2 default null
181 ,p_pep_attribute5 in varchar2 default null
182 ,p_pep_attribute6 in varchar2 default null
183 ,p_pep_attribute7 in varchar2 default null
184 ,p_pep_attribute8 in varchar2 default null
185 ,p_pep_attribute9 in varchar2 default null
186 ,p_pep_attribute10 in varchar2 default null
187 ,p_pep_attribute11 in varchar2 default null
188 ,p_pep_attribute12 in varchar2 default null
189 ,p_pep_attribute13 in varchar2 default null
190 ,p_pep_attribute14 in varchar2 default null
191 ,p_pep_attribute15 in varchar2 default null
192 ,p_pep_attribute16 in varchar2 default null
193 ,p_pep_attribute17 in varchar2 default null
194 ,p_pep_attribute18 in varchar2 default null
195 ,p_pep_attribute19 in varchar2 default null
196 ,p_pep_attribute20 in varchar2 default null
197 ,p_pep_attribute21 in varchar2 default null
198 ,p_pep_attribute22 in varchar2 default null
199 ,p_pep_attribute23 in varchar2 default null
200 ,p_pep_attribute24 in varchar2 default null
201 ,p_pep_attribute25 in varchar2 default null
202 ,p_pep_attribute26 in varchar2 default null
203 ,p_pep_attribute27 in varchar2 default null
204 ,p_pep_attribute28 in varchar2 default null
205 ,p_pep_attribute29 in varchar2 default null
206 ,p_pep_attribute30 in varchar2 default null
207 ,p_request_id in number default null
208 ,p_program_application_id in number default null
209 ,p_program_id in number default null
210 ,p_program_update_date in date default null
211 ,p_object_version_number out nocopy number
212 ,p_effective_date in date
213 ,p_override_validation in boolean default false
214 );
215 --
216 -- Performance cover
217 --
218 procedure create_perf_Eligible_Person
219 (p_validate in boolean default false
220 ,p_elig_per_id out nocopy number
221 ,p_effective_start_date out nocopy date
222 ,p_effective_end_date out nocopy date
223 ,p_business_group_id in number default null
224 ,p_pl_id in number default null
225 ,p_pgm_id in number default null
226 ,p_plip_id in number default null
227 ,p_ptip_id in number default null
228 ,p_ler_id in number default null
229 ,p_person_id in number default null
230 ,p_per_in_ler_id in number default null
231 ,p_dpnt_othr_pl_cvrd_rl_flag in varchar2 default 'N'
232 ,p_prtn_ovridn_thru_dt in date default null
233 ,p_pl_key_ee_flag in varchar2 default 'N'
234 ,p_pl_hghly_compd_flag in varchar2 default 'N'
235 ,p_elig_flag in varchar2 default 'N'
236 ,p_comp_ref_amt in number default null
237 ,p_cmbn_age_n_los_val in number default null
241 ,p_prtn_end_dt in date default null
238 ,p_comp_ref_uom in varchar2 default null
239 ,p_age_val in number default null
240 ,p_los_val in number default null
242 ,p_prtn_strt_dt in date default null
243 ,p_wait_perd_cmpltn_dt in date default null
244 ,p_wait_perd_strt_dt in date default null
245 ,p_wv_ctfn_typ_cd in varchar2 default null
246 ,p_hrs_wkd_val in number default null
247 ,p_hrs_wkd_bndry_perd_cd in varchar2 default null
248 ,p_prtn_ovridn_flag in varchar2 default null
249 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default 'N'
250 ,p_prtn_ovridn_rsn_cd in varchar2 default null
251 ,p_age_uom in varchar2 default null
252 ,p_los_uom in varchar2 default null
253 ,p_ovrid_svc_dt in date default null
254 ,p_inelg_rsn_cd in varchar2 default null
255 ,p_frz_los_flag in varchar2 default 'N'
256 ,p_frz_age_flag in varchar2 default 'N'
257 ,p_frz_cmp_lvl_flag in varchar2 default 'N'
258 ,p_frz_pct_fl_tm_flag in varchar2 default 'N'
259 ,p_frz_hrs_wkd_flag in varchar2 default 'N'
260 ,p_frz_comb_age_and_los_flag in varchar2 default 'N'
261 ,p_dstr_rstcn_flag in varchar2 default 'N'
262 ,p_pct_fl_tm_val in number default null
263 ,p_wv_prtn_rsn_cd in varchar2 default null
264 ,p_pl_wvd_flag in varchar2 default 'N'
265 ,p_rt_comp_ref_amt in number default null
266 ,p_rt_cmbn_age_n_los_val in number default null
267 ,p_rt_comp_ref_uom in varchar2 default null
268 ,p_rt_age_val in number default null
269 ,p_rt_los_val in number default null
270 ,p_rt_hrs_wkd_val in number default null
271 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default null
272 ,p_rt_age_uom in varchar2 default null
273 ,p_rt_los_uom in varchar2 default null
274 ,p_rt_pct_fl_tm_val in number default null
275 ,p_rt_frz_los_flag in varchar2 default 'N'
276 ,p_rt_frz_age_flag in varchar2 default 'N'
277 ,p_rt_frz_cmp_lvl_flag in varchar2 default 'N'
278 ,p_rt_frz_pct_fl_tm_flag in varchar2 default 'N'
279 ,p_rt_frz_hrs_wkd_flag in varchar2 default 'N'
280 ,p_rt_frz_comb_age_and_los_flag in varchar2 default 'N'
281 ,p_once_r_cntug_cd in varchar2 default null
282 ,p_pl_ordr_num in number default null
283 ,p_plip_ordr_num in number default null
284 ,p_ptip_ordr_num in number default null
285 ,p_pep_attribute_category in varchar2 default null
286 ,p_pep_attribute1 in varchar2 default null
287 ,p_pep_attribute2 in varchar2 default null
288 ,p_pep_attribute3 in varchar2 default null
289 ,p_pep_attribute4 in varchar2 default null
290 ,p_pep_attribute5 in varchar2 default null
291 ,p_pep_attribute6 in varchar2 default null
292 ,p_pep_attribute7 in varchar2 default null
293 ,p_pep_attribute8 in varchar2 default null
294 ,p_pep_attribute9 in varchar2 default null
295 ,p_pep_attribute10 in varchar2 default null
296 ,p_pep_attribute11 in varchar2 default null
297 ,p_pep_attribute12 in varchar2 default null
298 ,p_pep_attribute13 in varchar2 default null
299 ,p_pep_attribute14 in varchar2 default null
300 ,p_pep_attribute15 in varchar2 default null
301 ,p_pep_attribute16 in varchar2 default null
302 ,p_pep_attribute17 in varchar2 default null
303 ,p_pep_attribute18 in varchar2 default null
304 ,p_pep_attribute19 in varchar2 default null
305 ,p_pep_attribute20 in varchar2 default null
306 ,p_pep_attribute21 in varchar2 default null
307 ,p_pep_attribute22 in varchar2 default null
308 ,p_pep_attribute23 in varchar2 default null
309 ,p_pep_attribute24 in varchar2 default null
310 ,p_pep_attribute25 in varchar2 default null
311 ,p_pep_attribute26 in varchar2 default null
312 ,p_pep_attribute27 in varchar2 default null
313 ,p_pep_attribute28 in varchar2 default null
314 ,p_pep_attribute29 in varchar2 default null
315 ,p_pep_attribute30 in varchar2 default null
316 ,p_request_id in number default null
317 ,p_program_application_id in number default null
318 ,p_program_id in number default null
319 ,p_program_update_date in date default null
320 ,p_object_version_number out nocopy number
321 ,p_effective_date in date
322 ,p_override_validation in boolean default false
323 );
324 -- ----------------------------------------------------------------------------
325 -- |------------------------< update_Eligible_Person >------------------------|
326 -- ----------------------------------------------------------------------------
327 -- {Start Of Comments}
328 --
329 -- Description:
330 --
331 -- Prerequisites:
332 --
333 --
334 -- In Parameters:
335 -- Name Reqd Type Description
336 -- p_validate Yes boolean Commit or Rollback.
337 -- p_elig_per_id Yes number PK of record
338 -- p_business_group_id Yes number Business Group of Record
339 -- p_pl_id No number
340 -- p_pgm_id No number
341 -- p_ler_id No number
342 -- p_person_id Yes number
343 -- p_per_in_ler_id Yes number
344 -- p_dpnt_othr_pl_cvrd_rl_flag Yes varchar2
345 -- p_prtn_ovridn_thru_dt No date
346 -- p_pl_key_ee_flag Yes varchar2
347 -- p_pl_hghly_compd_flag Yes varchar2
348 -- p_elig_flag Yes varchar2
349 -- p_comp_ref_amt No number
350 -- p_cmbn_age_n_los_val No number
351 -- p_comp_ref_uom No varchar2
352 -- p_age_val No number
353 -- p_los_val No number
354 -- p_prtn_end_dt No date
355 -- p_prtn_strt_dt No date
356 -- p_wait_perd_cmpltn_dt No date
357 -- p_wait_perd_strt_dt No date
358 -- p_wv_ctfn_typ_cd No varchar2
359 -- p_hrs_wkd_val No number
360 -- p_hrs_wkd_bndry_perd_cd No varchar2
361 -- p_prtn_ovridn_flag Yes varchar2
362 -- p_no_mx_prtn_ovrid_thru_flag Yes varchar2
363 -- p_prtn_ovridn_rsn_cd No varchar2
364 -- p_age_uom No varchar2
365 -- p_los_uom No varchar2
366 -- p_ovrid_svc_dt No date
367 -- p_frz_los_flag Yes varchar2
368 -- p_frz_age_flag Yes varchar2
369 -- p_frz_cmp_lvl_flag Yes varchar2
370 -- p_frz_pct_fl_tm_flag Yes varchar2
371 -- p_frz_hrs_wkd_flag Yes varchar2
372 -- p_frz_comb_age_and_los_flag Yes varchar2
373 -- p_dstr_rstcn_flag Yes varchar2
374 -- p_pct_fl_tm_val No number
375 -- p_wv_prtn_rsn_cd No varchar2
376 -- p_pl_wvd_flag Yes varchar2
377 -- p_pep_attribute_category No varchar2 Descriptive Flexfield
378 -- p_pep_attribute1 No varchar2 Descriptive Flexfield
379 -- p_pep_attribute2 No varchar2 Descriptive Flexfield
380 -- p_pep_attribute3 No varchar2 Descriptive Flexfield
381 -- p_pep_attribute4 No varchar2 Descriptive Flexfield
382 -- p_pep_attribute5 No varchar2 Descriptive Flexfield
383 -- p_pep_attribute6 No varchar2 Descriptive Flexfield
384 -- p_pep_attribute7 No varchar2 Descriptive Flexfield
385 -- p_pep_attribute8 No varchar2 Descriptive Flexfield
386 -- p_pep_attribute9 No varchar2 Descriptive Flexfield
387 -- p_pep_attribute10 No varchar2 Descriptive Flexfield
388 -- p_pep_attribute11 No varchar2 Descriptive Flexfield
389 -- p_pep_attribute12 No varchar2 Descriptive Flexfield
390 -- p_pep_attribute13 No varchar2 Descriptive Flexfield
391 -- p_pep_attribute14 No varchar2 Descriptive Flexfield
392 -- p_pep_attribute15 No varchar2 Descriptive Flexfield
393 -- p_pep_attribute16 No varchar2 Descriptive Flexfield
394 -- p_pep_attribute17 No varchar2 Descriptive Flexfield
395 -- p_pep_attribute18 No varchar2 Descriptive Flexfield
396 -- p_pep_attribute19 No varchar2 Descriptive Flexfield
397 -- p_pep_attribute20 No varchar2 Descriptive Flexfield
398 -- p_pep_attribute21 No varchar2 Descriptive Flexfield
399 -- p_pep_attribute22 No varchar2 Descriptive Flexfield
400 -- p_pep_attribute23 No varchar2 Descriptive Flexfield
401 -- p_pep_attribute24 No varchar2 Descriptive Flexfield
402 -- p_pep_attribute25 No varchar2 Descriptive Flexfield
403 -- p_pep_attribute26 No varchar2 Descriptive Flexfield
404 -- p_pep_attribute27 No varchar2 Descriptive Flexfield
405 -- p_pep_attribute28 No varchar2 Descriptive Flexfield
406 -- p_pep_attribute29 No varchar2 Descriptive Flexfield
407 -- p_pep_attribute30 No varchar2 Descriptive Flexfield
408 -- p_request_id No number
409 -- p_program_application_id No number
410 -- p_program_id No number
411 -- p_program_update_date No date
412 -- p_effective_date Yes date Session Date.
413 -- p_datetrack_mode Yes varchar2 Datetrack mode.
414 --
415 -- Post Success:
416 --
417 -- Name Type Description
418 -- p_effective_start_date Yes date Effective Start Date of Record
419 -- p_effective_end_date Yes date Effective End Date of Record
420 -- p_object_version_number No number OVN of record
421 --
422 -- Post Failure:
423 --
424 -- Access Status:
425 -- Public.
426 --
427 -- {End Of Comments}
428 --
429 procedure update_Eligible_Person
430 (p_validate in boolean default false
431 ,p_elig_per_id in number
432 ,p_effective_start_date out nocopy date
433 ,p_effective_end_date out nocopy date
434 ,p_business_group_id in number default hr_api.g_number
435 ,p_pl_id in number default hr_api.g_number
436 ,p_pgm_id in number default hr_api.g_number
437 ,p_plip_id in number default hr_api.g_number
438 ,p_ptip_id in number default hr_api.g_number
439 ,p_ler_id in number default hr_api.g_number
440 ,p_person_id in number default hr_api.g_number
441 ,p_per_in_ler_id in number default hr_api.g_number
442 ,p_dpnt_othr_pl_cvrd_rl_flag in varchar2 default hr_api.g_varchar2
443 ,p_prtn_ovridn_thru_dt in date default hr_api.g_date
444 ,p_pl_key_ee_flag in varchar2 default hr_api.g_varchar2
445 ,p_pl_hghly_compd_flag in varchar2 default hr_api.g_varchar2
446 ,p_elig_flag in varchar2 default hr_api.g_varchar2
447 ,p_comp_ref_amt in number default hr_api.g_number
448 ,p_cmbn_age_n_los_val in number default hr_api.g_number
449 ,p_comp_ref_uom in varchar2 default hr_api.g_varchar2
450 ,p_age_val in number default hr_api.g_number
451 ,p_los_val in number default hr_api.g_number
452 ,p_prtn_end_dt in date default hr_api.g_date
453 ,p_prtn_strt_dt in date default hr_api.g_date
454 ,p_wait_perd_cmpltn_dt in date default hr_api.g_date
455 ,p_wait_perd_strt_dt in date default hr_api.g_date
456 ,p_wv_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
457 ,p_hrs_wkd_val in number default hr_api.g_number
458 ,p_hrs_wkd_bndry_perd_cd in varchar2 default hr_api.g_varchar2
459 ,p_prtn_ovridn_flag in varchar2 default hr_api.g_varchar2
460 ,p_no_mx_prtn_ovrid_thru_flag in varchar2 default hr_api.g_varchar2
461 ,p_prtn_ovridn_rsn_cd in varchar2 default hr_api.g_varchar2
462 ,p_age_uom in varchar2 default hr_api.g_varchar2
463 ,p_los_uom in varchar2 default hr_api.g_varchar2
464 ,p_ovrid_svc_dt in date default hr_api.g_date
465 ,p_inelg_rsn_cd in varchar2 default hr_api.g_varchar2
466 ,p_frz_los_flag in varchar2 default hr_api.g_varchar2
467 ,p_frz_age_flag in varchar2 default hr_api.g_varchar2
468 ,p_frz_cmp_lvl_flag in varchar2 default hr_api.g_varchar2
469 ,p_frz_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
470 ,p_frz_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
471 ,p_frz_comb_age_and_los_flag in varchar2 default hr_api.g_varchar2
472 ,p_dstr_rstcn_flag in varchar2 default hr_api.g_varchar2
473 ,p_pct_fl_tm_val in number default hr_api.g_number
474 ,p_wv_prtn_rsn_cd in varchar2 default hr_api.g_varchar2
475 ,p_pl_wvd_flag in varchar2 default hr_api.g_varchar2
476 ,p_rt_comp_ref_amt in number default hr_api.g_number
477 ,p_rt_cmbn_age_n_los_val in number default hr_api.g_number
478 ,p_rt_comp_ref_uom in varchar2 default hr_api.g_varchar2
479 ,p_rt_age_val in number default hr_api.g_number
480 ,p_rt_los_val in number default hr_api.g_number
481 ,p_rt_hrs_wkd_val in number default hr_api.g_number
482 ,p_rt_hrs_wkd_bndry_perd_cd in varchar2 default hr_api.g_varchar2
483 ,p_rt_age_uom in varchar2 default hr_api.g_varchar2
484 ,p_rt_los_uom in varchar2 default hr_api.g_varchar2
485 ,p_rt_pct_fl_tm_val in number default hr_api.g_number
486 ,p_rt_frz_los_flag in varchar2 default hr_api.g_varchar2
487 ,p_rt_frz_age_flag in varchar2 default hr_api.g_varchar2
488 ,p_rt_frz_cmp_lvl_flag in varchar2 default hr_api.g_varchar2
489 ,p_rt_frz_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
490 ,p_rt_frz_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
491 ,p_rt_frz_comb_age_and_los_flag in varchar2 default hr_api.g_varchar2
492 ,p_once_r_cntug_cd in varchar2 default hr_api.g_varchar2
493 ,p_pl_ordr_num in number default hr_api.g_number
494 ,p_plip_ordr_num in number default hr_api.g_number
495 ,p_ptip_ordr_num in number default hr_api.g_number
496 ,p_pep_attribute_category in varchar2 default hr_api.g_varchar2
497 ,p_pep_attribute1 in varchar2 default hr_api.g_varchar2
498 ,p_pep_attribute2 in varchar2 default hr_api.g_varchar2
499 ,p_pep_attribute3 in varchar2 default hr_api.g_varchar2
500 ,p_pep_attribute4 in varchar2 default hr_api.g_varchar2
501 ,p_pep_attribute5 in varchar2 default hr_api.g_varchar2
502 ,p_pep_attribute6 in varchar2 default hr_api.g_varchar2
503 ,p_pep_attribute7 in varchar2 default hr_api.g_varchar2
504 ,p_pep_attribute8 in varchar2 default hr_api.g_varchar2
505 ,p_pep_attribute9 in varchar2 default hr_api.g_varchar2
506 ,p_pep_attribute10 in varchar2 default hr_api.g_varchar2
507 ,p_pep_attribute11 in varchar2 default hr_api.g_varchar2
508 ,p_pep_attribute12 in varchar2 default hr_api.g_varchar2
509 ,p_pep_attribute13 in varchar2 default hr_api.g_varchar2
510 ,p_pep_attribute14 in varchar2 default hr_api.g_varchar2
511 ,p_pep_attribute15 in varchar2 default hr_api.g_varchar2
512 ,p_pep_attribute16 in varchar2 default hr_api.g_varchar2
513 ,p_pep_attribute17 in varchar2 default hr_api.g_varchar2
514 ,p_pep_attribute18 in varchar2 default hr_api.g_varchar2
515 ,p_pep_attribute19 in varchar2 default hr_api.g_varchar2
516 ,p_pep_attribute20 in varchar2 default hr_api.g_varchar2
517 ,p_pep_attribute21 in varchar2 default hr_api.g_varchar2
518 ,p_pep_attribute22 in varchar2 default hr_api.g_varchar2
519 ,p_pep_attribute23 in varchar2 default hr_api.g_varchar2
520 ,p_pep_attribute24 in varchar2 default hr_api.g_varchar2
521 ,p_pep_attribute25 in varchar2 default hr_api.g_varchar2
522 ,p_pep_attribute26 in varchar2 default hr_api.g_varchar2
523 ,p_pep_attribute27 in varchar2 default hr_api.g_varchar2
524 ,p_pep_attribute28 in varchar2 default hr_api.g_varchar2
525 ,p_pep_attribute29 in varchar2 default hr_api.g_varchar2
526 ,p_pep_attribute30 in varchar2 default hr_api.g_varchar2
527 ,p_request_id in number default hr_api.g_number
528 ,p_program_application_id in number default hr_api.g_number
529 ,p_program_id in number default hr_api.g_number
530 ,p_program_update_date in date default hr_api.g_date
531 ,p_object_version_number in out nocopy number
532 ,p_effective_date in date
533 ,p_datetrack_mode in varchar2);
534 --
535 -- ----------------------------------------------------------------------------
536 -- |------------------------< delete_Eligible_Person >------------------------|
537 -- ----------------------------------------------------------------------------
538 -- {Start Of Comments}
539 --
540 -- Description:
541 --
542 -- Prerequisites:
543 --
544 --
545 -- In Parameters:
546 -- Name Reqd Type Description
547 -- p_validate Yes boolean Commit or Rollback.
548 -- p_elig_per_id Yes number PK of record
549 -- p_effective_date Yes date Session Date.
550 -- p_datetrack_mode Yes varchar2 Datetrack mode.
551 --
552 -- Post Success:
553 --
554 -- Name Type Description
555 -- p_effective_start_date Yes date Effective Start Date of Record
556 -- p_effective_end_date Yes date Effective End Date of Record
557 -- p_object_version_number No number OVN of record
558 --
559 -- Post Failure:
560 --
561 -- Access Status:
562 -- Public.
563 --
564 -- {End Of Comments}
565 --
566 procedure delete_Eligible_Person
567 (p_validate in boolean default false
568 ,p_elig_per_id in number
569 ,p_effective_start_date out nocopy date
570 ,p_effective_end_date out nocopy date
571 ,p_object_version_number in out nocopy number
572 ,p_effective_date in date
573 ,p_datetrack_mode in varchar2);
574 --
575 -- ----------------------------------------------------------------------------
576 -- |----------------------------------< lck >---------------------------------|
577 -- ----------------------------------------------------------------------------
578 -- {Start Of Comments}
579 --
580 -- Description:
581 --
582 -- Prerequisites:
583 --
584 --
585 -- In Parameters:
586 -- Name Reqd Type Description
587 -- p_elig_per_id Yes number PK of record
588 -- p_object_version_number Yes number OVN of record
589 -- p_effective_date Yes date Session Date.
590 -- p_datetrack_mode Yes varchar2 Datetrack mode.
591 --
592 -- Post Success:
593 --
594 -- Name Type Description
595 -- p_validation_start_date Yes Derived Effective Start Date.
596 -- p_validation_end_date Yes Derived Effective End Date.
597 --
598 -- Post Failure:
599 --
600 -- Access Status:
601 -- Public.
602 --
603 -- {End Of Comments}
604 --
605 procedure lck
606 (p_elig_per_id in number
607 ,p_object_version_number in number
608 ,p_effective_date in date
609 ,p_datetrack_mode in varchar2
610 ,p_validation_start_date out nocopy date
611 ,p_validation_end_date out nocopy date);
612 --
613 end ben_Eligible_Person_api;
[Home] [Help]