[Home] [Help]
2172: --
2173: hr_utility.set_location(' Leaving:'||l_proc, 30);
2174: convert_defs(l_rec);
2175: --
2176: if ben_manage_life_events.g_modified_mode in ('S','U','D') then --ICM
2177: --compare values to decide whether to update or not
2178: --Bug 12964414 assigning the old and new ler_id's to l_old_ler_id and l_new_ler_id
2179: if l_old_ler_id is null and l_new_ler_id is null and
2180: ben_manage_life_events.g_modified_mode in ('S','U') then
2176: if ben_manage_life_events.g_modified_mode in ('S','U','D') then --ICM
2177: --compare values to decide whether to update or not
2178: --Bug 12964414 assigning the old and new ler_id's to l_old_ler_id and l_new_ler_id
2179: if l_old_ler_id is null and l_new_ler_id is null and
2180: ben_manage_life_events.g_modified_mode in ('S','U') then
2181: l_old_ler_id := nvl(ben_pep_shd.g_old_rec.ler_id,-1);
2182: l_new_ler_id := nvl(l_rec.ler_id,-1);
2183: end if;
2184: --Bug 12964414
4204: -- 2. Call the supporting update validate operations.
4205: --
4206: epo_convert_defs(p_rec);
4207: --
4208: if ben_manage_life_events.g_modified_mode in ('U','S','D') then
4209: -- compare the values and if there is no difference come out
4210: if (
4211: nvl(p_rec.per_in_ler_id,-1) <> nvl(ben_epo_shd.g_old_rec.per_in_ler_id,-1) or -- bug 5478994 epo to be updated first-time by unrestricted run
4212: nvl(p_rec.opt_id,-1) <> nvl(ben_epo_shd.g_old_rec.opt_id,-1) or