8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_Person_Life_Event >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_Person_Life_Event
12: ( p_validate in number default hr_api.g_false_num
13: ,p_per_in_ler_id out NOCOPY number
14: ,p_per_in_ler_stat_cd in varchar2 default null
15: ,p_prvs_stat_cd in varchar2 default null
16: ,p_lf_evt_ocrd_dt in date default null
94: --
95: -- Convert constant values to their corresponding boolean value
96: --
97: l_validate :=
98: hr_api.constant_to_boolean
99: (p_constant_value => p_validate);
100: --
101: -- Register Surrogate ID or user key values
102: --
224: -- ----------------------------------------------------------------------------
225: -- |----------------------< delete_Person_Life_Event >----------------------|
226: -- ----------------------------------------------------------------------------
227: PROCEDURE delete_Person_Life_Event
228: (p_validate in number default hr_api.g_false_num
229: ,p_per_in_ler_id in number
230: ,p_object_version_number in out NOCOPY number
231: ,p_effective_date in date
232: ,p_return_status out nocopy varchar2
257: --
258: -- Convert constant values to their corresponding boolean value
259: --
260: l_validate :=
261: hr_api.constant_to_boolean
262: (p_constant_value => p_validate);
263: --
264: -- Register Surrogate ID or user key values
265: --
412: -- ----------------------------------------------------------------------------
413: -- |----------------------< update_Person_Life_Event >----------------------|
414: -- ----------------------------------------------------------------------------
415: PROCEDURE update_Person_Life_Event
416: (p_validate in number default hr_api.g_false_num
417: ,p_per_in_ler_id in number
418: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
419: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
420: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
414: -- ----------------------------------------------------------------------------
415: PROCEDURE update_Person_Life_Event
416: (p_validate in number default hr_api.g_false_num
417: ,p_per_in_ler_id in number
418: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
419: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
420: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
421: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
422: ,p_procd_dt out NOCOPY date
415: PROCEDURE update_Person_Life_Event
416: (p_validate in number default hr_api.g_false_num
417: ,p_per_in_ler_id in number
418: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
419: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
420: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
421: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
422: ,p_procd_dt out NOCOPY date
423: ,p_strtd_dt out NOCOPY date
416: (p_validate in number default hr_api.g_false_num
417: ,p_per_in_ler_id in number
418: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
419: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
420: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
421: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
422: ,p_procd_dt out NOCOPY date
423: ,p_strtd_dt out NOCOPY date
424: ,p_voidd_dt out NOCOPY date
417: ,p_per_in_ler_id in number
418: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
419: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
420: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
421: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
422: ,p_procd_dt out NOCOPY date
423: ,p_strtd_dt out NOCOPY date
424: ,p_voidd_dt out NOCOPY date
425: ,p_bckt_dt in date default hr_api.g_date
421: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
422: ,p_procd_dt out NOCOPY date
423: ,p_strtd_dt out NOCOPY date
424: ,p_voidd_dt out NOCOPY date
425: ,p_bckt_dt in date default hr_api.g_date
426: ,p_clsd_dt in date default hr_api.g_date
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
422: ,p_procd_dt out NOCOPY date
423: ,p_strtd_dt out NOCOPY date
424: ,p_voidd_dt out NOCOPY date
425: ,p_bckt_dt in date default hr_api.g_date
426: ,p_clsd_dt in date default hr_api.g_date
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
423: ,p_strtd_dt out NOCOPY date
424: ,p_voidd_dt out NOCOPY date
425: ,p_bckt_dt in date default hr_api.g_date
426: ,p_clsd_dt in date default hr_api.g_date
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
424: ,p_voidd_dt out NOCOPY date
425: ,p_bckt_dt in date default hr_api.g_date
426: ,p_clsd_dt in date default hr_api.g_date
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
425: ,p_bckt_dt in date default hr_api.g_date
426: ,p_clsd_dt in date default hr_api.g_date
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
426: ,p_clsd_dt in date default hr_api.g_date
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
427: ,p_ntfn_dt in date default hr_api.g_date
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
428: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
429: ,p_bckt_per_in_ler_id in number default hr_api.g_number
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
430: ,p_ler_id in number default hr_api.g_number
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
431: ,p_person_id in number default hr_api.g_number
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
432: ,p_business_group_id in number default hr_api.g_number
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
433: ,p_ASSIGNMENT_ID in number default hr_api.g_number
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
434: ,p_WS_MGR_ID in number default hr_api.g_number
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
435: ,p_GROUP_PL_ID in number default hr_api.g_number
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
436: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
437: ,p_MGR_OVRID_DT in date default hr_api.g_date
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
441: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
442: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
443: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
444: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
445: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
446: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
447: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
448: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
449: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
450: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
451: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
452: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
453: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
454: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
455: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
456: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
457: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
458: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
459: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
460: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
461: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
462: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
463: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
471: ,p_program_id in number default hr_api.g_number
464: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
471: ,p_program_id in number default hr_api.g_number
472: ,p_program_update_date in date default hr_api.g_date
465: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
471: ,p_program_id in number default hr_api.g_number
472: ,p_program_update_date in date default hr_api.g_date
473: ,p_object_version_number in out NOCOPY number
466: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
471: ,p_program_id in number default hr_api.g_number
472: ,p_program_update_date in date default hr_api.g_date
473: ,p_object_version_number in out NOCOPY number
474: ,p_effective_date in date
467: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
471: ,p_program_id in number default hr_api.g_number
472: ,p_program_update_date in date default hr_api.g_date
473: ,p_object_version_number in out NOCOPY number
474: ,p_effective_date in date
475: ,p_return_status out nocopy varchar2
468: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
469: ,p_request_id in number default hr_api.g_number
470: ,p_program_application_id in number default hr_api.g_number
471: ,p_program_id in number default hr_api.g_number
472: ,p_program_update_date in date default hr_api.g_date
473: ,p_object_version_number in out NOCOPY number
474: ,p_effective_date in date
475: ,p_return_status out nocopy varchar2
476: ) is
501: --
502: -- Convert constant values to their corresponding boolean value
503: --
504: l_validate :=
505: hr_api.constant_to_boolean
506: (p_constant_value => p_validate);
507: --
508: -- Register Surrogate ID or user key values
509: --