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
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;
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');
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
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');
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
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: --
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: --
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
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
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');
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
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;
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');
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;
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');
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
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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;
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;
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: --
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
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: --
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);
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');
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
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');
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
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: --
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: --
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');
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
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');
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
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: --
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: --