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_API dependencies on HR_API

Line 133: and pen.enrt_cvg_thru_dt = hr_api.g_eot

129: --Start Bug 2688172
130: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt
131: --End Bug 2688172
132: and pen.sspndd_flag = 'Y'
133: and pen.enrt_cvg_thru_dt = hr_api.g_eot
134: and pen.effective_end_date = hr_api.g_eot
135: and pen.prtt_enrt_rslt_stat_cd is null
136: and p_effective_date
137: between pen.effective_start_date

Line 134: and pen.effective_end_date = hr_api.g_eot

130: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt
131: --End Bug 2688172
132: and pen.sspndd_flag = 'Y'
133: and pen.enrt_cvg_thru_dt = hr_api.g_eot
134: and pen.effective_end_date = hr_api.g_eot
135: and pen.prtt_enrt_rslt_stat_cd is null
136: and p_effective_date
137: between pen.effective_start_date
138: and pen.effective_end_date;

Line 232: when hr_api.cannot_find_prog_unit then

228: ,p_effective_date => trunc(p_effective_date));
229: --
230: exception
231: --
232: when hr_api.cannot_find_prog_unit then
233: --
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'CREATE_Person_Life_Event'
236: ,p_hook_type => 'BP');

Line 234: hr_api.cannot_find_prog_unit_error

230: exception
231: --
232: when hr_api.cannot_find_prog_unit then
233: --
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'CREATE_Person_Life_Event'
236: ,p_hook_type => 'BP');
237: --
238: -- End of API User Hook for the before hook of create_Person_Life_Event

Line 381: when hr_api.cannot_find_prog_unit then

377: ,p_effective_date => trunc(p_effective_date));
378: --
379: exception
380: --
381: when hr_api.cannot_find_prog_unit then
382: --
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'CREATE_Person_Life_Event'
385: ,p_hook_type => 'AP');

Line 383: hr_api.cannot_find_prog_unit_error

379: exception
380: --
381: when hr_api.cannot_find_prog_unit then
382: --
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'CREATE_Person_Life_Event'
385: ,p_hook_type => 'AP');
386: --
387: -- End of API User Hook for the after hook of create_Person_Life_Event

Line 396: raise hr_api.validate_enabled;

392: --
393: -- When in validation only mode raise the Validate_Enabled exception
394: --
395: if p_validate then
396: raise hr_api.validate_enabled;
397: end if;
398: --
399: -- Set all output arguments
400: --

Line 411: when hr_api.validate_enabled then

407: hr_utility.set_location(' Leaving:'||l_proc, 70);
408: --
409: exception
410: --
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
414: -- we must rollback to the savepoint
415: --

Line 518: and pen.enrt_cvg_thru_dt = hr_api.g_eot

514: --Start Bug 2688172
515: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt
516: -- End Bug 2688172
517: and pen.sspndd_flag = 'Y'
518: and pen.enrt_cvg_thru_dt = hr_api.g_eot
519: and pen.effective_end_date = hr_api.g_eot
520: and pen.prtt_enrt_rslt_stat_cd is null
521: and pen.business_group_id +0 = p_business_group_id
522: and p_effective_date

Line 519: and pen.effective_end_date = hr_api.g_eot

515: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt
516: -- End Bug 2688172
517: and pen.sspndd_flag = 'Y'
518: and pen.enrt_cvg_thru_dt = hr_api.g_eot
519: and pen.effective_end_date = hr_api.g_eot
520: and pen.prtt_enrt_rslt_stat_cd is null
521: and pen.business_group_id +0 = p_business_group_id
522: and p_effective_date
523: between pen.effective_start_date

Line 618: when hr_api.cannot_find_prog_unit then

614: ,p_effective_date => trunc(p_effective_date));
615: --
616: exception
617: --
618: when hr_api.cannot_find_prog_unit then
619: --
620: hr_api.cannot_find_prog_unit_error
621: (p_module_name => 'CREATE_Person_Life_Event'
622: ,p_hook_type => 'BP');

Line 620: hr_api.cannot_find_prog_unit_error

616: exception
617: --
618: when hr_api.cannot_find_prog_unit then
619: --
620: hr_api.cannot_find_prog_unit_error
621: (p_module_name => 'CREATE_Person_Life_Event'
622: ,p_hook_type => 'BP');
623: --
624: -- End of API User Hook for the before hook of create_Person_Life_Event

Line 668: ,p_datetrack_mode => hr_api.g_delete

664: ,p_effective_start_date => l_dummy_dt
665: ,p_effective_end_date => l_dummy_dt
666: ,p_object_version_number => l_rec.object_version_number
667: ,p_effective_date => p_effective_date
668: ,p_datetrack_mode => hr_api.g_delete
669: ,p_multi_row_validate => TRUE
670: ,p_source => 'bepilapi');
671: --
672: end if;

Line 879: when hr_api.cannot_find_prog_unit then

875: ,p_effective_date =>trunc(p_effective_date));
876: --
877: exception
878: --
879: when hr_api.cannot_find_prog_unit then
880: --
881: hr_api.cannot_find_prog_unit_error
882: (p_module_name => 'ben_per_in_ler'
883: ,p_hook_type => 'AI');

Line 881: hr_api.cannot_find_prog_unit_error

877: exception
878: --
879: when hr_api.cannot_find_prog_unit then
880: --
881: hr_api.cannot_find_prog_unit_error
882: (p_module_name => 'ben_per_in_ler'
883: ,p_hook_type => 'AI');
884: --
885: end;

Line 955: when hr_api.cannot_find_prog_unit then

951: ,p_effective_date => trunc(p_effective_date));
952: --
953: exception
954: --
955: when hr_api.cannot_find_prog_unit then
956: --
957: hr_api.cannot_find_prog_unit_error
958: (p_module_name => 'CREATE_Person_Life_Event'
959: ,p_hook_type => 'AP');

Line 957: hr_api.cannot_find_prog_unit_error

953: exception
954: --
955: when hr_api.cannot_find_prog_unit then
956: --
957: hr_api.cannot_find_prog_unit_error
958: (p_module_name => 'CREATE_Person_Life_Event'
959: ,p_hook_type => 'AP');
960: --
961: -- End of API User Hook for the after hook of create_Person_Life_Event

Line 970: raise hr_api.validate_enabled;

966: --
967: -- When in validation only mode raise the Validate_Enabled exception
968: --
969: if p_validate then
970: raise hr_api.validate_enabled;
971: end if;
972: --
973: -- Set all output arguments
974: --

Line 985: when hr_api.validate_enabled then

981: hr_utility.set_location(' Leaving:'||l_proc, 70);
982: --
983: exception
984: --
985: when hr_api.validate_enabled then
986: --
987: -- As the Validate_Enabled exception has been raised
988: -- we must rollback to the savepoint
989: --

Line 1019: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2

1015: --
1016: procedure update_Person_Life_Event
1017: (p_validate in boolean default false
1018: ,p_per_in_ler_id in number
1019: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
1020: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
1021: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1022: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
1023: ,p_procd_dt out NOCOPY date

Line 1020: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2

1016: procedure update_Person_Life_Event
1017: (p_validate in boolean default false
1018: ,p_per_in_ler_id in number
1019: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
1020: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
1021: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1022: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
1023: ,p_procd_dt out NOCOPY date
1024: ,p_strtd_dt out NOCOPY date

Line 1021: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

1017: (p_validate in boolean default false
1018: ,p_per_in_ler_id in number
1019: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
1020: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
1021: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1022: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
1023: ,p_procd_dt out NOCOPY date
1024: ,p_strtd_dt out NOCOPY date
1025: ,p_voidd_dt out NOCOPY date

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

1018: ,p_per_in_ler_id in number
1019: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
1020: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
1021: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
1022: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
1023: ,p_procd_dt out NOCOPY date
1024: ,p_strtd_dt out NOCOPY date
1025: ,p_voidd_dt out NOCOPY date
1026: ,p_bckt_dt in date default hr_api.g_date

Line 1026: ,p_bckt_dt in date default hr_api.g_date

1022: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
1023: ,p_procd_dt out NOCOPY date
1024: ,p_strtd_dt out NOCOPY date
1025: ,p_voidd_dt out NOCOPY date
1026: ,p_bckt_dt in date default hr_api.g_date
1027: ,p_clsd_dt in date default hr_api.g_date
1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number

Line 1027: ,p_clsd_dt in date default hr_api.g_date

1023: ,p_procd_dt out NOCOPY date
1024: ,p_strtd_dt out NOCOPY date
1025: ,p_voidd_dt out NOCOPY date
1026: ,p_bckt_dt in date default hr_api.g_date
1027: ,p_clsd_dt in date default hr_api.g_date
1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number

Line 1028: ,p_ntfn_dt in date default hr_api.g_date

1024: ,p_strtd_dt out NOCOPY date
1025: ,p_voidd_dt out NOCOPY date
1026: ,p_bckt_dt in date default hr_api.g_date
1027: ,p_clsd_dt in date default hr_api.g_date
1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number

Line 1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number

1025: ,p_voidd_dt out NOCOPY date
1026: ,p_bckt_dt in date default hr_api.g_date
1027: ,p_clsd_dt in date default hr_api.g_date
1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number

Line 1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number

1026: ,p_bckt_dt in date default hr_api.g_date
1027: ,p_clsd_dt in date default hr_api.g_date
1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number

Line 1031: ,p_ler_id in number default hr_api.g_number

1027: ,p_clsd_dt in date default hr_api.g_date
1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number

Line 1032: ,p_person_id in number default hr_api.g_number

1028: ,p_ntfn_dt in date default hr_api.g_date
1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number

Line 1033: ,p_business_group_id in number default hr_api.g_number

1029: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number

Line 1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number

1030: ,p_bckt_per_in_ler_id in number default hr_api.g_number
1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date

Line 1035: ,p_WS_MGR_ID in number default hr_api.g_number

1031: ,p_ler_id in number default hr_api.g_number
1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2

Line 1036: ,p_GROUP_PL_ID in number default hr_api.g_number

1032: ,p_person_id in number default hr_api.g_number
1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number

1033: ,p_business_group_id in number default hr_api.g_number
1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_MGR_OVRID_DT in date default hr_api.g_date

1034: ,p_ASSIGNMENT_ID in number default hr_api.g_number
1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2

1035: ,p_WS_MGR_ID in number default hr_api.g_number
1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2

1036: ,p_GROUP_PL_ID in number default hr_api.g_number
1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2

1037: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2

1038: ,p_MGR_OVRID_DT in date default hr_api.g_date
1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2

1039: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2

1040: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2

1041: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2

Line 1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2

1042: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2

Line 1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2

1043: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2

Line 1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2

1044: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2

1045: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2

Line 1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2

1046: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2

Line 1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2

1047: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2

Line 1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2

1048: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2

Line 1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2

1049: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2

Line 1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2

1050: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2

Line 1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2

1051: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2

Line 1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2

1052: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2

Line 1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2

1053: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2

Line 1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2

1054: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2

Line 1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2

1055: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2

Line 1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2

1056: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2

Line 1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2

1057: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2

Line 1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2

1058: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2

Line 1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2

1059: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2

Line 1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2

1060: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2

Line 1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2

1061: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2

Line 1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2

1062: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number

Line 1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2

1063: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number

Line 1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2

1064: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number
1072: ,p_program_id in number default hr_api.g_number

Line 1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2

1065: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number
1072: ,p_program_id in number default hr_api.g_number
1073: ,p_program_update_date in date default hr_api.g_date

Line 1070: ,p_request_id in number default hr_api.g_number

1066: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number
1072: ,p_program_id in number default hr_api.g_number
1073: ,p_program_update_date in date default hr_api.g_date
1074: ,p_object_version_number in out NOCOPY number

Line 1071: ,p_program_application_id in number default hr_api.g_number

1067: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number
1072: ,p_program_id in number default hr_api.g_number
1073: ,p_program_update_date in date default hr_api.g_date
1074: ,p_object_version_number in out NOCOPY number
1075: ,p_effective_date in date) is

Line 1072: ,p_program_id in number default hr_api.g_number

1068: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number
1072: ,p_program_id in number default hr_api.g_number
1073: ,p_program_update_date in date default hr_api.g_date
1074: ,p_object_version_number in out NOCOPY number
1075: ,p_effective_date in date) is
1076: --

Line 1073: ,p_program_update_date in date default hr_api.g_date

1069: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
1070: ,p_request_id in number default hr_api.g_number
1071: ,p_program_application_id in number default hr_api.g_number
1072: ,p_program_id in number default hr_api.g_number
1073: ,p_program_update_date in date default hr_api.g_date
1074: ,p_object_version_number in out NOCOPY number
1075: ,p_effective_date in date) is
1076: --
1077: -- Declare cursors and local variables

Line 1082: l_procd_dt date := hr_api.g_date;

1078: --
1079: l_proc varchar2(72) := g_package||'update_Person_Life_Event';
1080: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
1081: --
1082: l_procd_dt date := hr_api.g_date;
1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;
1085: l_bckt_dt date := hr_api.g_date;
1086: l_clsd_dt date := hr_api.g_date;

Line 1083: l_strtd_dt date := hr_api.g_date;

1079: l_proc varchar2(72) := g_package||'update_Person_Life_Event';
1080: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
1081: --
1082: l_procd_dt date := hr_api.g_date;
1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;
1085: l_bckt_dt date := hr_api.g_date;
1086: l_clsd_dt date := hr_api.g_date;
1087: l_ntfn_dt date := hr_api.g_date;

Line 1084: l_voidd_dt date := hr_api.g_date;

1080: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
1081: --
1082: l_procd_dt date := hr_api.g_date;
1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;
1085: l_bckt_dt date := hr_api.g_date;
1086: l_clsd_dt date := hr_api.g_date;
1087: l_ntfn_dt date := hr_api.g_date;
1088: --

Line 1085: l_bckt_dt date := hr_api.g_date;

1081: --
1082: l_procd_dt date := hr_api.g_date;
1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;
1085: l_bckt_dt date := hr_api.g_date;
1086: l_clsd_dt date := hr_api.g_date;
1087: l_ntfn_dt date := hr_api.g_date;
1088: --
1089: begin

Line 1086: l_clsd_dt date := hr_api.g_date;

1082: l_procd_dt date := hr_api.g_date;
1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;
1085: l_bckt_dt date := hr_api.g_date;
1086: l_clsd_dt date := hr_api.g_date;
1087: l_ntfn_dt date := hr_api.g_date;
1088: --
1089: begin
1090: --

Line 1087: l_ntfn_dt date := hr_api.g_date;

1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;
1085: l_bckt_dt date := hr_api.g_date;
1086: l_clsd_dt date := hr_api.g_date;
1087: l_ntfn_dt date := hr_api.g_date;
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1169: when hr_api.cannot_find_prog_unit then

1165: ,p_effective_date => trunc(p_effective_date));
1166: --
1167: exception
1168: --
1169: when hr_api.cannot_find_prog_unit then
1170: --
1171: hr_api.cannot_find_prog_unit_error
1172: (p_module_name => 'UPDATE_Person_Life_Event'
1173: ,p_hook_type => 'BP');

Line 1171: hr_api.cannot_find_prog_unit_error

1167: exception
1168: --
1169: when hr_api.cannot_find_prog_unit then
1170: --
1171: hr_api.cannot_find_prog_unit_error
1172: (p_module_name => 'UPDATE_Person_Life_Event'
1173: ,p_hook_type => 'BP');
1174: --
1175: -- End of API User Hook for the before hook of update_Person_Life_Event

Line 1319: when hr_api.cannot_find_prog_unit then

1315: ,p_effective_date => trunc(p_effective_date));
1316: --
1317: exception
1318: --
1319: when hr_api.cannot_find_prog_unit then
1320: --
1321: hr_api.cannot_find_prog_unit_error
1322: (p_module_name => 'UPDATE_Person_Life_Event'
1323: ,p_hook_type => 'AP');

Line 1321: hr_api.cannot_find_prog_unit_error

1317: exception
1318: --
1319: when hr_api.cannot_find_prog_unit then
1320: --
1321: hr_api.cannot_find_prog_unit_error
1322: (p_module_name => 'UPDATE_Person_Life_Event'
1323: ,p_hook_type => 'AP');
1324: --
1325: -- End of API User Hook for the after hook of update_Person_Life_Event

Line 1334: raise hr_api.validate_enabled;

1330: --
1331: -- When in validation only mode raise the Validate_Enabled exception
1332: --
1333: if p_validate then
1334: raise hr_api.validate_enabled;
1335: end if;
1336: --
1337: -- Set all output arguments
1338: --

Line 1348: when hr_api.validate_enabled then

1344: hr_utility.set_location(' Leaving:'||l_proc, 70);
1345: --
1346: exception
1347: --
1348: when hr_api.validate_enabled then
1349: --
1350: -- As the Validate_Enabled exception has been raised
1351: -- we must rollback to the savepoint
1352: --

Line 1416: when hr_api.cannot_find_prog_unit then

1412: ,p_effective_date => trunc(p_effective_date));
1413: --
1414: exception
1415: --
1416: when hr_api.cannot_find_prog_unit then
1417: --
1418: hr_api.cannot_find_prog_unit_error
1419: (p_module_name => 'DELETE_Person_Life_Event'
1420: ,p_hook_type => 'BP');

Line 1418: hr_api.cannot_find_prog_unit_error

1414: exception
1415: --
1416: when hr_api.cannot_find_prog_unit then
1417: --
1418: hr_api.cannot_find_prog_unit_error
1419: (p_module_name => 'DELETE_Person_Life_Event'
1420: ,p_hook_type => 'BP');
1421: --
1422: -- End of API User Hook for the before hook of delete_Person_Life_Event

Line 1442: when hr_api.cannot_find_prog_unit then

1438: ,p_effective_date => trunc(p_effective_date));
1439: --
1440: exception
1441: --
1442: when hr_api.cannot_find_prog_unit then
1443: --
1444: hr_api.cannot_find_prog_unit_error
1445: (p_module_name => 'DELETE_Person_Life_Event'
1446: ,p_hook_type => 'AP');

Line 1444: hr_api.cannot_find_prog_unit_error

1440: exception
1441: --
1442: when hr_api.cannot_find_prog_unit then
1443: --
1444: hr_api.cannot_find_prog_unit_error
1445: (p_module_name => 'DELETE_Person_Life_Event'
1446: ,p_hook_type => 'AP');
1447: --
1448: -- End of API User Hook for the after hook of delete_Person_Life_Event

Line 1457: raise hr_api.validate_enabled;

1453: --
1454: -- When in validation only mode raise the Validate_Enabled exception
1455: --
1456: if p_validate then
1457: raise hr_api.validate_enabled;
1458: end if;
1459: --
1460: hr_utility.set_location(' Leaving:'||l_proc, 70);
1461: --

Line 1464: when hr_api.validate_enabled then

1460: hr_utility.set_location(' Leaving:'||l_proc, 70);
1461: --
1462: exception
1463: --
1464: when hr_api.validate_enabled then
1465: --
1466: -- As the Validate_Enabled exception has been raised
1467: -- we must rollback to the savepoint
1468: --