eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PERSON_LIFE_EVENT_SWI dependencies on HR_API

Line 12: ( p_validate in number default hr_api.g_false_num

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

Line 98: hr_api.constant_to_boolean

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: --

Line 228: (p_validate in number default hr_api.g_false_num

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

Line 261: hr_api.constant_to_boolean

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: --

Line 416: (p_validate in number default hr_api.g_false_num

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

Line 418: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2

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

Line 419: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2

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

Line 420: ,p_lf_evt_ocrd_dt in date default hr_api.g_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

Line 421: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes

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

Line 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

Line 426: ,p_clsd_dt in date default hr_api.g_date

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

Line 427: ,p_ntfn_dt in date default hr_api.g_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
431: ,p_person_id in number default hr_api.g_number

Line 428: ,p_ptnl_ler_for_per_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

Line 429: ,p_bckt_per_in_ler_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

Line 430: ,p_ler_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

Line 431: ,p_person_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

Line 432: ,p_business_group_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

Line 433: ,p_ASSIGNMENT_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

Line 434: ,p_WS_MGR_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
438: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2

Line 435: ,p_GROUP_PL_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
439: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2

Line 436: ,p_MGR_OVRID_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
440: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2

Line 437: ,p_MGR_OVRID_DT in date default hr_api.g_date

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

Line 438: ,p_pil_attribute_category 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

Line 439: ,p_pil_attribute1 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

Line 440: ,p_pil_attribute2 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

Line 441: ,p_pil_attribute3 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

Line 442: ,p_pil_attribute4 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

Line 443: ,p_pil_attribute5 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

Line 444: ,p_pil_attribute6 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

Line 445: ,p_pil_attribute7 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

Line 446: ,p_pil_attribute8 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

Line 447: ,p_pil_attribute9 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

Line 448: ,p_pil_attribute10 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

Line 449: ,p_pil_attribute11 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

Line 450: ,p_pil_attribute12 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

Line 451: ,p_pil_attribute13 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

Line 452: ,p_pil_attribute14 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

Line 453: ,p_pil_attribute15 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

Line 454: ,p_pil_attribute16 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

Line 455: ,p_pil_attribute17 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

Line 456: ,p_pil_attribute18 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

Line 457: ,p_pil_attribute19 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

Line 458: ,p_pil_attribute20 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

Line 459: ,p_pil_attribute21 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

Line 460: ,p_pil_attribute22 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

Line 461: ,p_pil_attribute23 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

Line 462: ,p_pil_attribute24 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

Line 463: ,p_pil_attribute25 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

Line 464: ,p_pil_attribute26 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

Line 465: ,p_pil_attribute27 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

Line 466: ,p_pil_attribute28 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
470: ,p_program_application_id in number default hr_api.g_number

Line 467: ,p_pil_attribute29 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
471: ,p_program_id in number default hr_api.g_number

Line 468: ,p_pil_attribute30 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
472: ,p_program_update_date in date default hr_api.g_date

Line 469: ,p_request_id in number default hr_api.g_number

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

Line 470: ,p_program_application_id in number default hr_api.g_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

Line 471: ,p_program_id in number default hr_api.g_number

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

Line 472: ,p_program_update_date in date default hr_api.g_date

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

Line 505: hr_api.constant_to_boolean

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: --