411: -- Set the object version number for the insert
412: --
413: l_object_version_number := 1;
414: --
415: ben_egd_shd.g_api_dml := true; -- Set the api dml status
416: --
417: hr_utility.set_location('Insert EGD: '||l_proc, 5);
418: insert into ben_elig_dpnt
419: ( elig_dpnt_id,
544: l_new_rec.per_in_ler_id := p_per_in_ler_id; --Bug 5630251
545: --
546: ben_egd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_date);
547: --
548: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
969: --
970: l_old_rec ben_egd_ler.g_egd_ler_rec;
971: l_new_rec ben_egd_ler.g_egd_ler_rec;
972: --
973: l_rec ben_egd_shd.g_rec_type;
974: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
975: --
976: begin
977: --
981: --
982: savepoint update_perf_ELIG_DPNT;
983: --
984: l_rec :=
985: ben_egd_shd.convert_args
986: (
987: p_elig_dpnt_id,
988: p_create_dt,
989: p_elig_strt_dt,
1038: );
1039: --
1040: -- We must lock the row which we need to update.
1041: --
1042: ben_egd_shd.lck
1043: (p_elig_dpnt_id => p_elig_dpnt_id
1044: ,p_object_version_number => p_object_version_number
1045: );
1046: --
1048: --
1049: -- Increment object version number
1050: --
1051: l_object_version_number := p_object_version_number+1;
1052: ben_egd_shd.g_api_dml := true; -- Set the api dml status
1053: --
1054: -- Update the ben_elig_dpnt Row
1055: --
1056: update ben_elig_dpnt
1109: where elig_dpnt_id = l_rec.elig_dpnt_id;
1110: --
1111: -- Call life event trigger
1112: --
1113: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
1114: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1110: --
1111: -- Call life event trigger
1112: --
1113: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
1114: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1111: -- Call life event trigger
1112: --
1113: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
1114: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1112: --
1113: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
1114: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1120: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
1113: l_old_rec.business_group_id := ben_egd_shd.g_old_rec.business_group_id;
1114: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1120: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
1121: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
1114: l_old_rec.dpnt_person_id := ben_egd_shd.g_old_rec.dpnt_person_id;
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1120: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
1121: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
1122:
1115: l_old_rec.elig_strt_dt := ben_egd_shd.g_old_rec.elig_strt_dt;
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1120: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
1121: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
1122:
1123:
1116: l_old_rec.elig_thru_dt := ben_egd_shd.g_old_rec.elig_thru_dt;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1120: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
1121: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
1122:
1123:
1124: l_new_rec.business_group_id := p_business_group_id;
1117: l_old_rec.dpnt_inelig_flag := ben_egd_shd.g_old_rec.dpnt_inelig_flag;
1118: l_old_rec.ovrdn_thru_dt := ben_egd_shd.g_old_rec.ovrdn_thru_dt;
1119: l_old_rec.ovrdn_flag := ben_egd_shd.g_old_rec.ovrdn_flag;
1120: l_old_rec.create_dt := ben_egd_shd.g_old_rec.create_dt;
1121: l_old_rec.per_in_ler_id := ben_egd_shd.g_old_rec.per_in_ler_id;
1122:
1123:
1124: l_new_rec.business_group_id := p_business_group_id;
1125: l_new_rec.dpnt_person_id := p_dpnt_person_id;
1134: hr_utility.set_location(' Old per_in_ler_id from api ' || l_old_rec.per_in_ler_id , 9876 );
1135:
1136: ben_egd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_date);
1137: --
1138: ben_egd_shd.g_api_dml := false; -- Unset the api dml status
1139: --
1140: -- When in validation only mode raise the Validate_Enabled exception
1141: --
1142: if p_validate then
1307: begin
1308: --
1309: hr_utility.set_location('Entering:'|| l_proc, 10);
1310: --
1311: ben_egd_shd.lck
1312: (
1313: p_elig_dpnt_id => p_elig_dpnt_id
1314: ,p_object_version_number => p_object_version_number
1315: );