902: close c_min_max_dt;
903:
904: if p_end_date < l_min_start_date then
905: l_effective_date := p_effective_date;
906: l_datetrack_mode := hr_api.g_zap;
907: elsif p_end_date < l_max_end_date then
908: l_effective_date := p_end_date;
909: l_datetrack_mode := hr_api.g_delete;
910: --
905: l_effective_date := p_effective_date;
906: l_datetrack_mode := hr_api.g_zap;
907: elsif p_end_date < l_max_end_date then
908: l_effective_date := p_end_date;
909: l_datetrack_mode := hr_api.g_delete;
910: --
911: --get the correct ovn
912: --
913: open c_pea_ovn(l_bnf_types.prtt_enrt_actn_id, p_end_date);
1164: );
1165:
1166: --
1167: -- Bug 8304294,the fix for 7711723 is reverted.
1168: -- l_datetrack_mode := hr_api.g_future_change; ----Bug 7711723
1169: end loop;
1170: --
1171: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1172: (p_validate => FALSE
1188: -- Do not decrease the effective date, when called from 'benelinf',
1189: -- as the date is already modified in delete_enrollment in such cases.
1190: --
1191: if l_bnf_types.effective_start_date < p_effective_date and
1192: p_datetrack_mode = hr_api.g_delete and
1193: nvl(p_source,'benelinf') <> 'benelinf' then
1194: l_datetrack_mode := p_datetrack_mode;
1195: l_effective_date := p_effective_date -1;
1196: -- 4962138
1194: l_datetrack_mode := p_datetrack_mode;
1195: l_effective_date := p_effective_date -1;
1196: -- 4962138
1197: elsif l_bnf_types.effective_start_date <= p_effective_date and
1198: p_datetrack_mode = hr_api.g_delete and
1199: p_source is null then
1200: l_datetrack_mode := hr_api.g_zap;
1201: l_effective_date := p_effective_date;
1202: -- end 4962138
1196: -- 4962138
1197: elsif l_bnf_types.effective_start_date <= p_effective_date and
1198: p_datetrack_mode = hr_api.g_delete and
1199: p_source is null then
1200: l_datetrack_mode := hr_api.g_zap;
1201: l_effective_date := p_effective_date;
1202: -- end 4962138
1203: else
1204: l_datetrack_mode := p_datetrack_mode;
1208: -- Do not attempt dt delete if the row selected already has an effective
1209: -- end date equal to(or less than) the date you are trying to delete it on.
1210: -- Bug 1132739
1211: --
1212: if (p_datetrack_mode = hr_api.g_delete and
1213: l_bnf_types.effective_end_date > l_effective_date) or
1214: p_datetrack_mode <> hr_api.g_delete then
1215: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1216: (p_validate => FALSE
1210: -- Bug 1132739
1211: --
1212: if (p_datetrack_mode = hr_api.g_delete and
1213: l_bnf_types.effective_end_date > l_effective_date) or
1214: p_datetrack_mode <> hr_api.g_delete then
1215: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1216: (p_validate => FALSE
1217: ,p_prtt_enrt_actn_id => l_bnf_types.prtt_enrt_actn_id
1218: ,p_effective_start_date => l_bnf_types.effective_start_date
1284: ,p_update_change_insert => l_dt_update_change_insert
1285: );
1286: --Bug 4431511 calling the find_dt_del_modes
1287: if(p_ler_typ_cd = 'SCHEDDU'
1288: and p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1289:
1290: ben_pen_shd.find_dt_del_modes
1291: (p_effective_date => p_effective_date
1292: ,p_base_key_value => p_base_key_value
1297: );
1298: END if;
1299:
1300: if(p_ler_typ_cd = 'SCHEDDU'
1301: and p_desired_datetrack_mode = hr_api.g_delete) then
1302:
1303: ben_pen_shd.find_dt_del_modes
1304: (p_effective_date => p_effective_date
1305: ,p_base_key_value => p_base_key_value
1350: end if;
1351: end if;
1352:
1353: --
1354: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1355: p_datetrack_allow := hr_api.g_update;
1356: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1357: p_datetrack_allow := hr_api.g_correction;
1358: elsif (l_dt_update) then
1351: end if;
1352:
1353: --
1354: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1355: p_datetrack_allow := hr_api.g_update;
1356: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1357: p_datetrack_allow := hr_api.g_correction;
1358: elsif (l_dt_update) then
1359: p_datetrack_allow := hr_api.g_update;
1352:
1353: --
1354: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1355: p_datetrack_allow := hr_api.g_update;
1356: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1357: p_datetrack_allow := hr_api.g_correction;
1358: elsif (l_dt_update) then
1359: p_datetrack_allow := hr_api.g_update;
1360: --Bug 2739965 In case of unrestricted we need to take the
1353: --
1354: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1355: p_datetrack_allow := hr_api.g_update;
1356: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1357: p_datetrack_allow := hr_api.g_correction;
1358: elsif (l_dt_update) then
1359: p_datetrack_allow := hr_api.g_update;
1360: --Bug 2739965 In case of unrestricted we need to take the
1361: -- l_dt_update_override case also.
1355: p_datetrack_allow := hr_api.g_update;
1356: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1357: p_datetrack_allow := hr_api.g_correction;
1358: elsif (l_dt_update) then
1359: p_datetrack_allow := hr_api.g_update;
1360: --Bug 2739965 In case of unrestricted we need to take the
1361: -- l_dt_update_override case also.
1362: elsif (l_dt_update_override and -- p_ler_typ_cd = 'SCHEDDU' and --Bug 5102337 this applied to LE mode also
1363: p_desired_datetrack_mode = hr_api.g_update) then
1359: p_datetrack_allow := hr_api.g_update;
1360: --Bug 2739965 In case of unrestricted we need to take the
1361: -- l_dt_update_override case also.
1362: elsif (l_dt_update_override and -- p_ler_typ_cd = 'SCHEDDU' and --Bug 5102337 this applied to LE mode also
1363: p_desired_datetrack_mode = hr_api.g_update) then
1364: p_datetrack_allow := hr_api.g_update_override;
1365: --Bug 4431511 Added this check to ensure update_override is passed as
1366: --effective datetrack mode if the desired date track mode is
1367: --delete next change in case of unrestricted enrollments
1360: --Bug 2739965 In case of unrestricted we need to take the
1361: -- l_dt_update_override case also.
1362: elsif (l_dt_update_override and -- p_ler_typ_cd = 'SCHEDDU' and --Bug 5102337 this applied to LE mode also
1363: p_desired_datetrack_mode = hr_api.g_update) then
1364: p_datetrack_allow := hr_api.g_update_override;
1365: --Bug 4431511 Added this check to ensure update_override is passed as
1366: --effective datetrack mode if the desired date track mode is
1367: --delete next change in case of unrestricted enrollments
1368: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1365: --Bug 4431511 Added this check to ensure update_override is passed as
1366: --effective datetrack mode if the desired date track mode is
1367: --delete next change in case of unrestricted enrollments
1368: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1369: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1370: p_datetrack_allow := hr_api.g_update_override;
1371: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1372: p_desired_datetrack_mode = hr_api.g_delete) then
1373: p_datetrack_allow := hr_api.g_update_override;
1366: --effective datetrack mode if the desired date track mode is
1367: --delete next change in case of unrestricted enrollments
1368: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1369: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1370: p_datetrack_allow := hr_api.g_update_override;
1371: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1372: p_desired_datetrack_mode = hr_api.g_delete) then
1373: p_datetrack_allow := hr_api.g_update_override;
1374: --End Bug 4431511
1368: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1369: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1370: p_datetrack_allow := hr_api.g_update_override;
1371: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1372: p_desired_datetrack_mode = hr_api.g_delete) then
1373: p_datetrack_allow := hr_api.g_update_override;
1374: --End Bug 4431511
1375: elsif (l_dt_correction) then
1376: p_datetrack_allow := hr_api.g_correction;
1369: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1370: p_datetrack_allow := hr_api.g_update_override;
1371: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1372: p_desired_datetrack_mode = hr_api.g_delete) then
1373: p_datetrack_allow := hr_api.g_update_override;
1374: --End Bug 4431511
1375: elsif (l_dt_correction) then
1376: p_datetrack_allow := hr_api.g_correction;
1377: else
1372: p_desired_datetrack_mode = hr_api.g_delete) then
1373: p_datetrack_allow := hr_api.g_update_override;
1374: --End Bug 4431511
1375: elsif (l_dt_correction) then
1376: p_datetrack_allow := hr_api.g_correction;
1377: else
1378: rpt_error(p_proc => l_proc, p_step => l_step);
1379: fnd_message.set_name('BEN', 'BEN_91700_DATETRACK_NOT_ALWD');
1380: fnd_message.set_token('MODE',p_desired_datetrack_mode);
1483: ,p_enrt_ovridn_flag in varchar2 default 'N'
1484: ,p_enrt_ovrid_rsn_cd in varchar2 default null
1485: ,p_erlst_deenrt_dt in date default null
1486: ,p_enrt_cvg_strt_dt in date default null
1487: ,p_enrt_cvg_thru_dt in date default hr_api.g_eot
1488: ,p_enrt_ovrid_thru_dt in date default null
1489: ,p_pl_ordr_num in number default null
1490: ,p_plip_ordr_num in number default null
1491: ,p_ptip_ordr_num in number default null
1603: pen.business_group_id =p_business_group_id and
1604: pen.prtt_enrt_rslt_stat_cd is null and
1605: pen.sspndd_flag='N' and
1606: pen.prtt_enrt_rslt_id <> l_prtt_enrt_rslt_id and
1607: pen.effective_end_date = hr_api.g_eot and
1608: p_enrt_cvg_strt_dt-1 <=
1609: pen.enrt_cvg_thru_dt and
1610: pen.enrt_cvg_strt_dt < pen.effective_end_date and
1611: p_ptip_id=pen.ptip_id;
1701: between pdp.effective_start_date and pdp.effective_end_date
1702: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1703: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
1704: and pen.prtt_enrt_rslt_stat_cd is null
1705: and pdp.cvg_thru_dt = hr_api.g_eot
1706: and pen.pgm_id = p_pgm_id
1707: and pen.pgm_id = pgm.pgm_id
1708: and pen.prtt_enrt_rslt_stat_cd is null
1709: and pgm.pgm_typ_cd like 'COBRA%'
1757: End if;
1758: --
1759: -- Ensure elctbl_chc_id is not NULL.
1760: --
1761: hr_api.mandatory_arg_error
1762: (p_api_name => l_proc
1763: ,p_argument => 'elig_per_elctbl_chc_id'
1764: ,p_argument_value => p_elig_per_elctbl_chc_id
1765: );
1853: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1854: fnd_message.raise_error;
1855: else
1856: close c_pen;
1857: if (p_datetrack_mode = hr_api.g_correction) then
1858: l_effective_date := l_pen_o.effective_start_date;
1859: else
1860: l_effective_date := p_effective_date;
1861: end if;
2088: p_update_change_insert => lb_update_change_insert);
2089:
2090: if lb_update_override then
2091: --
2092: l_ppe_datetrack_mode := hr_api.g_update_override;
2093: --
2094: elsif lb_update then
2095: --
2096: l_ppe_datetrack_mode := hr_api.g_update;
2092: l_ppe_datetrack_mode := hr_api.g_update_override;
2093: --
2094: elsif lb_update then
2095: --
2096: l_ppe_datetrack_mode := hr_api.g_update;
2097: --
2098: else
2099: --
2100: l_ppe_datetrack_mode := hr_api.g_correction;
2096: l_ppe_datetrack_mode := hr_api.g_update;
2097: --
2098: else
2099: --
2100: l_ppe_datetrack_mode := hr_api.g_correction;
2101: end if;
2102: /* End of Changes for WWBUG: 1646442 */
2103:
2104: ben_prtt_prem_api.update_prtt_prem
2420: --
2421: -- When in validation only mode raise the Validate_Enabled exception
2422: --
2423: if p_validate then
2424: raise hr_api.validate_enabled;
2425: end if;
2426: --
2427: -- Set all output arguments
2428: --
2448: if g_debug then
2449: hr_utility.set_location(' Leaving:'||l_proc, 999);
2450: end if;
2451: exception
2452: when hr_api.validate_enabled then
2453: -- As the Validate_Enabled exception has been raised
2454: -- we must rollback to the savepoint
2455: --
2456:
2531: ,p_enrt_ovridn_flag in varchar2 default 'N'
2532: ,p_enrt_ovrid_rsn_cd in varchar2 default null
2533: ,p_erlst_deenrt_dt in date default null
2534: ,p_enrt_cvg_strt_dt in date default null
2535: ,p_enrt_cvg_thru_dt in date default hr_api.g_eot
2536: ,p_enrt_ovrid_thru_dt in date default null
2537: ,p_pl_ordr_num in number default null
2538: ,p_plip_ordr_num in number default null
2539: ,p_ptip_ordr_num in number default null
2697: ,p_comp_lvl_cd => p_comp_lvl_cd
2698: ,p_effective_date => trunc(p_effective_date)
2699: );
2700: exception
2701: when hr_api.cannot_find_prog_unit then
2702: hr_api.cannot_find_prog_unit_error
2703: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2704: ,p_hook_type => 'BP'
2705: );
2698: ,p_effective_date => trunc(p_effective_date)
2699: );
2700: exception
2701: when hr_api.cannot_find_prog_unit then
2702: hr_api.cannot_find_prog_unit_error
2703: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2704: ,p_hook_type => 'BP'
2705: );
2706: --
2861: ,p_comp_lvl_cd => p_comp_lvl_cd
2862: ,p_effective_date => trunc(p_effective_date)
2863: );
2864: exception
2865: when hr_api.cannot_find_prog_unit then
2866: hr_api.cannot_find_prog_unit_error
2867: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2868: ,p_hook_type => 'AP'
2869: );
2862: ,p_effective_date => trunc(p_effective_date)
2863: );
2864: exception
2865: when hr_api.cannot_find_prog_unit then
2866: hr_api.cannot_find_prog_unit_error
2867: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2868: ,p_hook_type => 'AP'
2869: );
2870: end;
2874: --
2875: -- When in validation only mode raise the Validate_Enabled exception
2876: --
2877: if p_validate then
2878: raise hr_api.validate_enabled;
2879: end if;
2880: --
2881: -- Set all output arguments
2882: --
2887: if g_debug then
2888: hr_utility.set_location(' Leaving:'||l_proc, 70);
2889: end if;
2890: exception
2891: when hr_api.validate_enabled then
2892: --
2893: -- As the Validate_Enabled exception has been raised
2894: -- we must rollback to the savepoint
2895: --
2927: (p_validate in boolean default false
2928: ,p_prtt_enrt_rslt_id in number
2929: ,p_effective_start_date out nocopy date
2930: ,p_effective_end_date out nocopy date
2931: ,p_business_group_id in number default hr_api.g_number
2932: ,p_oipl_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2928: ,p_prtt_enrt_rslt_id in number
2929: ,p_effective_start_date out nocopy date
2930: ,p_effective_end_date out nocopy date
2931: ,p_business_group_id in number default hr_api.g_number
2932: ,p_oipl_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2929: ,p_effective_start_date out nocopy date
2930: ,p_effective_end_date out nocopy date
2931: ,p_business_group_id in number default hr_api.g_number
2932: ,p_oipl_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2930: ,p_effective_end_date out nocopy date
2931: ,p_business_group_id in number default hr_api.g_number
2932: ,p_oipl_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2931: ,p_business_group_id in number default hr_api.g_number
2932: ,p_oipl_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2932: ,p_oipl_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2933: ,p_person_id in number default hr_api.g_number
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2934: ,p_assignment_id in number default hr_api.g_number
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2935: ,p_pgm_id in number default hr_api.g_number
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2936: ,p_pl_id in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2937: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2938: ,p_ptip_id in number default hr_api.g_number
2939: ,p_pl_typ_id in number default hr_api.g_number
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2940: ,p_ler_id in number default hr_api.g_number
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2941: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2942: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2943: ,p_enrt_bnft_id in number default NULL
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2944: ,p_bnft_amt in number default hr_api.g_number
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2945: ,p_uom in varchar2 default hr_api.g_varchar2
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2946: ,p_orgnl_enrt_dt in date default hr_api.g_date
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2947: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2948: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2949: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2950: ,p_erlst_deenrt_dt in date default hr_api.g_date
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2951: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2952: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2953: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2954: ,p_pl_ordr_num in number default hr_api.g_number
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2955: ,p_plip_ordr_num in number default hr_api.g_number
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2956: ,p_ptip_ordr_num in number default hr_api.g_number
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2957: ,p_oipl_ordr_num in number default hr_api.g_number
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2958: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2959: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2960: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2961: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2962: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2963: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2964: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2965: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2966: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2967: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2968: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2969: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2970: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2971: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2972: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2973: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2974: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2975: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2976: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2977: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2978: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2979: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2980: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2981: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2982: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2983: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2984: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2985: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2986: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2987: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2988: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2989: ,p_request_id in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2990: ,p_program_application_id in number default hr_api.g_number
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2997: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2998: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2991: ,p_program_id in number default hr_api.g_number
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2997: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2998: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2999: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2992: ,p_program_update_date in date default hr_api.g_date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2997: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2998: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2999: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
3000: ,p_effective_date in date
2993: ,p_object_version_number in out nocopy number
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2997: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2998: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2999: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
3000: ,p_effective_date in date
3001: ,p_datetrack_mode in varchar2
2994: ,p_per_in_ler_id in number default hr_api.g_number
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2997: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2998: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2999: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
3000: ,p_effective_date in date
3001: ,p_datetrack_mode in varchar2
3002: ,p_multi_row_validate in boolean default TRUE
2995: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2996: ,p_bnft_ordr_num in number default hr_api.g_number
2997: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2998: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2999: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
3000: ,p_effective_date in date
3001: ,p_datetrack_mode in varchar2
3002: ,p_multi_row_validate in boolean default TRUE
3003: ,p_suspend_flag out nocopy varchar2
3148: ben_prtt_enrt_rslt_f pen
3149: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3150: and pdp.elig_cvrd_dpnt_id = p_pdp_id
3151: and pdp.per_in_ler_id = p_per_in_ler_id
3152: and pdp.cvg_thru_dt <> hr_api.g_eot
3153: and pdp.effective_end_date = hr_api.g_eot
3154: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
3155: and pen.per_in_ler_id = pdp.per_in_ler_id
3156: and pen.prtt_enrt_rslt_stat_cd is null
3149: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3150: and pdp.elig_cvrd_dpnt_id = p_pdp_id
3151: and pdp.per_in_ler_id = p_per_in_ler_id
3152: and pdp.cvg_thru_dt <> hr_api.g_eot
3153: and pdp.effective_end_date = hr_api.g_eot
3154: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
3155: and pen.per_in_ler_id = pdp.per_in_ler_id
3156: and pen.prtt_enrt_rslt_stat_cd is null
3157: and pen.effective_end_date = hr_api.g_eot
3153: and pdp.effective_end_date = hr_api.g_eot
3154: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
3155: and pen.per_in_ler_id = pdp.per_in_ler_id
3156: and pen.prtt_enrt_rslt_stat_cd is null
3157: and pen.effective_end_date = hr_api.g_eot
3158: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
3159:
3160: l_check_dup_dep c_check_dup_dep%rowtype;
3161:
3154: and pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
3155: and pen.per_in_ler_id = pdp.per_in_ler_id
3156: and pen.prtt_enrt_rslt_stat_cd is null
3157: and pen.effective_end_date = hr_api.g_eot
3158: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
3159:
3160: l_check_dup_dep c_check_dup_dep%rowtype;
3161:
3162: cursor c_get_last_pil is
3382: ,p_inst_row => l_oipl_rec);
3383: end if;
3384: --
3385: l_step := 30;
3386: if (p_oipl_id <> hr_api.g_number and
3387: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3388: nvl(p_oipl_id,hr_api.g_number)) then
3389: l_chg := TRUE;
3390: end if;
3383: end if;
3384: --
3385: l_step := 30;
3386: if (p_oipl_id <> hr_api.g_number and
3387: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3388: nvl(p_oipl_id,hr_api.g_number)) then
3389: l_chg := TRUE;
3390: end if;
3391: if (p_assignment_id <> hr_api.g_number and
3384: --
3385: l_step := 30;
3386: if (p_oipl_id <> hr_api.g_number and
3387: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3388: nvl(p_oipl_id,hr_api.g_number)) then
3389: l_chg := TRUE;
3390: end if;
3391: if (p_assignment_id <> hr_api.g_number and
3392: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3387: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3388: nvl(p_oipl_id,hr_api.g_number)) then
3389: l_chg := TRUE;
3390: end if;
3391: if (p_assignment_id <> hr_api.g_number and
3392: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3393: nvl(p_assignment_id,hr_api.g_number)) then
3394: l_chg := TRUE;
3395: end if;
3388: nvl(p_oipl_id,hr_api.g_number)) then
3389: l_chg := TRUE;
3390: end if;
3391: if (p_assignment_id <> hr_api.g_number and
3392: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3393: nvl(p_assignment_id,hr_api.g_number)) then
3394: l_chg := TRUE;
3395: end if;
3396: if (p_pgm_id <> hr_api.g_number and
3389: l_chg := TRUE;
3390: end if;
3391: if (p_assignment_id <> hr_api.g_number and
3392: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3393: nvl(p_assignment_id,hr_api.g_number)) then
3394: l_chg := TRUE;
3395: end if;
3396: if (p_pgm_id <> hr_api.g_number and
3397: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3392: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3393: nvl(p_assignment_id,hr_api.g_number)) then
3394: l_chg := TRUE;
3395: end if;
3396: if (p_pgm_id <> hr_api.g_number and
3397: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3398: nvl(p_pgm_id,hr_api.g_number)) then
3399: l_chg := TRUE;
3400: end if;
3393: nvl(p_assignment_id,hr_api.g_number)) then
3394: l_chg := TRUE;
3395: end if;
3396: if (p_pgm_id <> hr_api.g_number and
3397: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3398: nvl(p_pgm_id,hr_api.g_number)) then
3399: l_chg := TRUE;
3400: end if;
3401: if (p_pl_id <> hr_api.g_number and
3394: l_chg := TRUE;
3395: end if;
3396: if (p_pgm_id <> hr_api.g_number and
3397: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3398: nvl(p_pgm_id,hr_api.g_number)) then
3399: l_chg := TRUE;
3400: end if;
3401: if (p_pl_id <> hr_api.g_number and
3402: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3397: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3398: nvl(p_pgm_id,hr_api.g_number)) then
3399: l_chg := TRUE;
3400: end if;
3401: if (p_pl_id <> hr_api.g_number and
3402: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3403: nvl(p_pl_id, hr_api.g_number)) then
3404: l_chg := TRUE;
3405: end if;
3398: nvl(p_pgm_id,hr_api.g_number)) then
3399: l_chg := TRUE;
3400: end if;
3401: if (p_pl_id <> hr_api.g_number and
3402: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3403: nvl(p_pl_id, hr_api.g_number)) then
3404: l_chg := TRUE;
3405: end if;
3406: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3399: l_chg := TRUE;
3400: end if;
3401: if (p_pl_id <> hr_api.g_number and
3402: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3403: nvl(p_pl_id, hr_api.g_number)) then
3404: l_chg := TRUE;
3405: end if;
3406: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3407: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3402: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3403: nvl(p_pl_id, hr_api.g_number)) then
3404: l_chg := TRUE;
3405: end if;
3406: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3407: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3408: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3409: l_chg := TRUE;
3410: end if;
3403: nvl(p_pl_id, hr_api.g_number)) then
3404: l_chg := TRUE;
3405: end if;
3406: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3407: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3408: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3409: l_chg := TRUE;
3410: end if;
3411: l_step := 35;
3404: l_chg := TRUE;
3405: end if;
3406: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3407: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3408: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3409: l_chg := TRUE;
3410: end if;
3411: l_step := 35;
3412: if (p_ptip_id <> hr_api.g_number and
3408: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3409: l_chg := TRUE;
3410: end if;
3411: l_step := 35;
3412: if (p_ptip_id <> hr_api.g_number and
3413: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3414: nvl(p_ptip_id,hr_api.g_number)) then
3415: l_chg := TRUE;
3416: end if;
3409: l_chg := TRUE;
3410: end if;
3411: l_step := 35;
3412: if (p_ptip_id <> hr_api.g_number and
3413: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3414: nvl(p_ptip_id,hr_api.g_number)) then
3415: l_chg := TRUE;
3416: end if;
3417: if (p_pl_typ_id <> hr_api.g_number and
3410: end if;
3411: l_step := 35;
3412: if (p_ptip_id <> hr_api.g_number and
3413: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3414: nvl(p_ptip_id,hr_api.g_number)) then
3415: l_chg := TRUE;
3416: end if;
3417: if (p_pl_typ_id <> hr_api.g_number and
3418: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3413: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3414: nvl(p_ptip_id,hr_api.g_number)) then
3415: l_chg := TRUE;
3416: end if;
3417: if (p_pl_typ_id <> hr_api.g_number and
3418: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3419: nvl(p_pl_typ_id,hr_api.g_number)) then
3420: l_chg := TRUE;
3421: end if;
3414: nvl(p_ptip_id,hr_api.g_number)) then
3415: l_chg := TRUE;
3416: end if;
3417: if (p_pl_typ_id <> hr_api.g_number and
3418: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3419: nvl(p_pl_typ_id,hr_api.g_number)) then
3420: l_chg := TRUE;
3421: end if;
3422: if (p_ler_id <> hr_api.g_number and
3415: l_chg := TRUE;
3416: end if;
3417: if (p_pl_typ_id <> hr_api.g_number and
3418: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3419: nvl(p_pl_typ_id,hr_api.g_number)) then
3420: l_chg := TRUE;
3421: end if;
3422: if (p_ler_id <> hr_api.g_number and
3423: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3418: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3419: nvl(p_pl_typ_id,hr_api.g_number)) then
3420: l_chg := TRUE;
3421: end if;
3422: if (p_ler_id <> hr_api.g_number and
3423: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3424: nvl(p_ler_id,hr_api.g_number)) then
3425: l_chg := TRUE;
3426: end if;
3419: nvl(p_pl_typ_id,hr_api.g_number)) then
3420: l_chg := TRUE;
3421: end if;
3422: if (p_ler_id <> hr_api.g_number and
3423: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3424: nvl(p_ler_id,hr_api.g_number)) then
3425: l_chg := TRUE;
3426: end if;
3427: if (p_sspndd_flag <> hr_api.g_varchar2 and
3420: l_chg := TRUE;
3421: end if;
3422: if (p_ler_id <> hr_api.g_number and
3423: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3424: nvl(p_ler_id,hr_api.g_number)) then
3425: l_chg := TRUE;
3426: end if;
3427: if (p_sspndd_flag <> hr_api.g_varchar2 and
3428: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3423: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3424: nvl(p_ler_id,hr_api.g_number)) then
3425: l_chg := TRUE;
3426: end if;
3427: if (p_sspndd_flag <> hr_api.g_varchar2 and
3428: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3429: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3430: l_chg := TRUE;
3431: end if;
3424: nvl(p_ler_id,hr_api.g_number)) then
3425: l_chg := TRUE;
3426: end if;
3427: if (p_sspndd_flag <> hr_api.g_varchar2 and
3428: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3429: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3430: l_chg := TRUE;
3431: end if;
3432: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3425: l_chg := TRUE;
3426: end if;
3427: if (p_sspndd_flag <> hr_api.g_varchar2 and
3428: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3429: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3430: l_chg := TRUE;
3431: end if;
3432: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3433: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3428: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3429: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3430: l_chg := TRUE;
3431: end if;
3432: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3433: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3434: nvl(p_prtt_is_cvrd_flag,hr_api.g_varchar2)) then
3435: l_chg := TRUE;
3436: end if;
3429: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3430: l_chg := TRUE;
3431: end if;
3432: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3433: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3434: nvl(p_prtt_is_cvrd_flag,hr_api.g_varchar2)) then
3435: l_chg := TRUE;
3436: end if;
3437: --
3430: l_chg := TRUE;
3431: end if;
3432: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3433: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3434: nvl(p_prtt_is_cvrd_flag,hr_api.g_varchar2)) then
3435: l_chg := TRUE;
3436: end if;
3437: --
3438: -- Bug 4723828 : If benefit amount changes from non-zero value to NULL
3438: -- Bug 4723828 : If benefit amount changes from non-zero value to NULL
3439: -- we need to detect that nullify the coverage. So added
3440: -- nvl(p_bnft_amt, -9999)
3441: --
3442: if (nvl(p_bnft_amt, -9999) <> hr_api.g_number and
3443: nvl(l_global_pen_rec.bnft_amt,hr_api.g_number) <>
3444: nvl(p_bnft_amt,hr_api.g_number)) then
3445: l_chg := TRUE;
3446: end if;
3439: -- we need to detect that nullify the coverage. So added
3440: -- nvl(p_bnft_amt, -9999)
3441: --
3442: if (nvl(p_bnft_amt, -9999) <> hr_api.g_number and
3443: nvl(l_global_pen_rec.bnft_amt,hr_api.g_number) <>
3444: nvl(p_bnft_amt,hr_api.g_number)) then
3445: l_chg := TRUE;
3446: end if;
3447: l_step := 40;
3440: -- nvl(p_bnft_amt, -9999)
3441: --
3442: if (nvl(p_bnft_amt, -9999) <> hr_api.g_number and
3443: nvl(l_global_pen_rec.bnft_amt,hr_api.g_number) <>
3444: nvl(p_bnft_amt,hr_api.g_number)) then
3445: l_chg := TRUE;
3446: end if;
3447: l_step := 40;
3448: if (p_uom <> hr_api.g_varchar2 and
3444: nvl(p_bnft_amt,hr_api.g_number)) then
3445: l_chg := TRUE;
3446: end if;
3447: l_step := 40;
3448: if (p_uom <> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3450: nvl(p_uom,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3445: l_chg := TRUE;
3446: end if;
3447: l_step := 40;
3448: if (p_uom <> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3450: nvl(p_uom,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (p_orgnl_enrt_dt <> hr_api.g_date and
3446: end if;
3447: l_step := 40;
3448: if (p_uom <> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3450: nvl(p_uom,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (p_orgnl_enrt_dt <> hr_api.g_date and
3454: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3449: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3450: nvl(p_uom,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (p_orgnl_enrt_dt <> hr_api.g_date and
3454: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3455: nvl(p_orgnl_enrt_dt,hr_api.g_date)) then
3456: l_chg := TRUE;
3457: end if;
3450: nvl(p_uom,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (p_orgnl_enrt_dt <> hr_api.g_date and
3454: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3455: nvl(p_orgnl_enrt_dt,hr_api.g_date)) then
3456: l_chg := TRUE;
3457: end if;
3458: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3451: l_chg := TRUE;
3452: end if;
3453: if (p_orgnl_enrt_dt <> hr_api.g_date and
3454: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3455: nvl(p_orgnl_enrt_dt,hr_api.g_date)) then
3456: l_chg := TRUE;
3457: end if;
3458: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3459: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3456: l_chg := TRUE;
3457: end if;
3458: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3459: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3460: if (p_enrt_mthd_cd <> hr_api.g_varchar2 and
3461: nvl(l_global_pen_rec.enrt_mthd_cd,hr_api.g_varchar2) <>
3462: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3463: l_chg := TRUE;
3464: end if;
3457: end if;
3458: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3459: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3460: if (p_enrt_mthd_cd <> hr_api.g_varchar2 and
3461: nvl(l_global_pen_rec.enrt_mthd_cd,hr_api.g_varchar2) <>
3462: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3463: l_chg := TRUE;
3464: end if;
3465: end if;
3458: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3459: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3460: if (p_enrt_mthd_cd <> hr_api.g_varchar2 and
3461: nvl(l_global_pen_rec.enrt_mthd_cd,hr_api.g_varchar2) <>
3462: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3463: l_chg := TRUE;
3464: end if;
3465: end if;
3466: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3462: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3463: l_chg := TRUE;
3464: end if;
3465: end if;
3466: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3467: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3468: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3469: l_chg := TRUE;
3470: end if;
3463: l_chg := TRUE;
3464: end if;
3465: end if;
3466: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3467: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3468: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3469: l_chg := TRUE;
3470: end if;
3471: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3464: end if;
3465: end if;
3466: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3467: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3468: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3469: l_chg := TRUE;
3470: end if;
3471: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3472: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3467: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3468: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3469: l_chg := TRUE;
3470: end if;
3471: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3472: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3473: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3474: l_chg := TRUE;
3475: end if;
3468: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3469: l_chg := TRUE;
3470: end if;
3471: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3472: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3473: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3474: l_chg := TRUE;
3475: end if;
3476: if (p_erlst_deenrt_dt <> hr_api.g_date and
3469: l_chg := TRUE;
3470: end if;
3471: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3472: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3473: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3474: l_chg := TRUE;
3475: end if;
3476: if (p_erlst_deenrt_dt <> hr_api.g_date and
3477: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3472: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3473: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3474: l_chg := TRUE;
3475: end if;
3476: if (p_erlst_deenrt_dt <> hr_api.g_date and
3477: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3478: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3479: l_chg := TRUE;
3480: end if;
3473: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3474: l_chg := TRUE;
3475: end if;
3476: if (p_erlst_deenrt_dt <> hr_api.g_date and
3477: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3478: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3479: l_chg := TRUE;
3480: end if;
3481: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3474: l_chg := TRUE;
3475: end if;
3476: if (p_erlst_deenrt_dt <> hr_api.g_date and
3477: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3478: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3479: l_chg := TRUE;
3480: end if;
3481: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3482: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3477: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3478: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3479: l_chg := TRUE;
3480: end if;
3481: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3482: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3483: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3484: l_chg := TRUE;
3485: end if;
3478: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3479: l_chg := TRUE;
3480: end if;
3481: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3482: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3483: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3484: l_chg := TRUE;
3485: end if;
3486: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3479: l_chg := TRUE;
3480: end if;
3481: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3482: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3483: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3484: l_chg := TRUE;
3485: end if;
3486: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3487: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3482: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3483: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3484: l_chg := TRUE;
3485: end if;
3486: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3487: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3488: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3489: l_chg := TRUE;
3490: end if;
3483: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3484: l_chg := TRUE;
3485: end if;
3486: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3487: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3488: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3489: l_chg := TRUE;
3490: end if;
3491: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3484: l_chg := TRUE;
3485: end if;
3486: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3487: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3488: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3489: l_chg := TRUE;
3490: end if;
3491: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3492: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3487: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3488: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3489: l_chg := TRUE;
3490: end if;
3491: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3492: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3493: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3494: l_chg := TRUE;
3495: end if;
3488: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3489: l_chg := TRUE;
3490: end if;
3491: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3492: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3493: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3494: l_chg := TRUE;
3495: end if;
3496: l_step := 50;
3489: l_chg := TRUE;
3490: end if;
3491: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3492: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3493: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3494: l_chg := TRUE;
3495: end if;
3496: l_step := 50;
3497: if (p_per_in_ler_id <> hr_api.g_number and
3493: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3494: l_chg := TRUE;
3495: end if;
3496: l_step := 50;
3497: if (p_per_in_ler_id <> hr_api.g_number and
3498: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3499: nvl(p_per_in_ler_id,hr_api.g_number)) then
3500: l_chg := TRUE;
3501: end if;
3494: l_chg := TRUE;
3495: end if;
3496: l_step := 50;
3497: if (p_per_in_ler_id <> hr_api.g_number and
3498: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3499: nvl(p_per_in_ler_id,hr_api.g_number)) then
3500: l_chg := TRUE;
3501: end if;
3502: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3495: end if;
3496: l_step := 50;
3497: if (p_per_in_ler_id <> hr_api.g_number and
3498: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3499: nvl(p_per_in_ler_id,hr_api.g_number)) then
3500: l_chg := TRUE;
3501: end if;
3502: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3503: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3498: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3499: nvl(p_per_in_ler_id,hr_api.g_number)) then
3500: l_chg := TRUE;
3501: end if;
3502: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3503: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3504: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3505: l_chg := TRUE;
3506: end if;
3499: nvl(p_per_in_ler_id,hr_api.g_number)) then
3500: l_chg := TRUE;
3501: end if;
3502: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3503: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3504: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3505: l_chg := TRUE;
3506: end if;
3507: if (p_bnft_ordr_num <> hr_api.g_number and
3500: l_chg := TRUE;
3501: end if;
3502: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3503: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3504: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3505: l_chg := TRUE;
3506: end if;
3507: if (p_bnft_ordr_num <> hr_api.g_number and
3508: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3503: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3504: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3505: l_chg := TRUE;
3506: end if;
3507: if (p_bnft_ordr_num <> hr_api.g_number and
3508: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3509: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3510: l_chg := TRUE;
3511: end if;
3504: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3505: l_chg := TRUE;
3506: end if;
3507: if (p_bnft_ordr_num <> hr_api.g_number and
3508: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3509: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3510: l_chg := TRUE;
3511: end if;
3512: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3505: l_chg := TRUE;
3506: end if;
3507: if (p_bnft_ordr_num <> hr_api.g_number and
3508: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3509: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3510: l_chg := TRUE;
3511: end if;
3512: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3513: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3508: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3509: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3510: l_chg := TRUE;
3511: end if;
3512: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3513: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3514: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3515: l_chg := TRUE;
3516: end if;
3509: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3510: l_chg := TRUE;
3511: end if;
3512: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3513: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3514: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3515: l_chg := TRUE;
3516: end if;
3517: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3510: l_chg := TRUE;
3511: end if;
3512: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3513: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3514: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3515: l_chg := TRUE;
3516: end if;
3517: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3518: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3513: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3514: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3515: l_chg := TRUE;
3516: end if;
3517: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3518: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3519: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3520: l_chg := TRUE;
3521: end if;
3514: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3515: l_chg := TRUE;
3516: end if;
3517: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3518: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3519: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3520: l_chg := TRUE;
3521: end if;
3522: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3515: l_chg := TRUE;
3516: end if;
3517: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3518: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3519: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3520: l_chg := TRUE;
3521: end if;
3522: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3523: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3518: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3519: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3520: l_chg := TRUE;
3521: end if;
3522: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3523: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3524: nvl(p_comp_lvl_cd,hr_api.g_varchar2)) then
3525: l_chg := TRUE;
3526: end if;
3519: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3520: l_chg := TRUE;
3521: end if;
3522: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3523: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3524: nvl(p_comp_lvl_cd,hr_api.g_varchar2)) then
3525: l_chg := TRUE;
3526: end if;
3527: --
3520: l_chg := TRUE;
3521: end if;
3522: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3523: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3524: nvl(p_comp_lvl_cd,hr_api.g_varchar2)) then
3525: l_chg := TRUE;
3526: end if;
3527: --
3528: -- bug 1712890 added the following columns
3534: --If DFF field changes from non-zero value to NULL
3535: -- we need to detect that nullify the coverage. So added
3536: -- nvl(p_pen_attributexx, '~')
3537:
3538: if (nvl(p_pen_attribute1 ,'~')<> hr_api.g_varchar2 and
3539: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3540: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3541: l_chg := TRUE;
3542: end if;
3535: -- we need to detect that nullify the coverage. So added
3536: -- nvl(p_pen_attributexx, '~')
3537:
3538: if (nvl(p_pen_attribute1 ,'~')<> hr_api.g_varchar2 and
3539: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3540: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3541: l_chg := TRUE;
3542: end if;
3543: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3536: -- nvl(p_pen_attributexx, '~')
3537:
3538: if (nvl(p_pen_attribute1 ,'~')<> hr_api.g_varchar2 and
3539: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3540: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3541: l_chg := TRUE;
3542: end if;
3543: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3544: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3539: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3540: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3541: l_chg := TRUE;
3542: end if;
3543: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3544: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3545: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3546: l_chg := TRUE;
3547: end if;
3540: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3541: l_chg := TRUE;
3542: end if;
3543: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3544: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3545: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3546: l_chg := TRUE;
3547: end if;
3548: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3541: l_chg := TRUE;
3542: end if;
3543: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3544: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3545: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3546: l_chg := TRUE;
3547: end if;
3548: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3549: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3544: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3545: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3546: l_chg := TRUE;
3547: end if;
3548: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3549: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3550: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3551: l_chg := TRUE;
3552: end if;
3545: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3546: l_chg := TRUE;
3547: end if;
3548: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3549: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3550: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3551: l_chg := TRUE;
3552: end if;
3553: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3546: l_chg := TRUE;
3547: end if;
3548: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3549: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3550: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3551: l_chg := TRUE;
3552: end if;
3553: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3554: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3549: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3550: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3551: l_chg := TRUE;
3552: end if;
3553: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3554: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3555: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3556: l_chg := TRUE;
3557: end if;
3550: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3551: l_chg := TRUE;
3552: end if;
3553: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3554: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3555: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3556: l_chg := TRUE;
3557: end if;
3558: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3551: l_chg := TRUE;
3552: end if;
3553: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3554: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3555: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3556: l_chg := TRUE;
3557: end if;
3558: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3559: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3554: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3555: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3556: l_chg := TRUE;
3557: end if;
3558: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3559: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3560: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3561: l_chg := TRUE;
3562: end if;
3555: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3556: l_chg := TRUE;
3557: end if;
3558: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3559: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3560: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3561: l_chg := TRUE;
3562: end if;
3563: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3556: l_chg := TRUE;
3557: end if;
3558: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3559: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3560: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3561: l_chg := TRUE;
3562: end if;
3563: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3564: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3559: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3560: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3561: l_chg := TRUE;
3562: end if;
3563: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3564: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3565: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3566: l_chg := TRUE;
3567: end if;
3560: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3561: l_chg := TRUE;
3562: end if;
3563: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3564: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3565: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3566: l_chg := TRUE;
3567: end if;
3568: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3561: l_chg := TRUE;
3562: end if;
3563: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3564: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3565: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3566: l_chg := TRUE;
3567: end if;
3568: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3569: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3564: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3565: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3566: l_chg := TRUE;
3567: end if;
3568: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3569: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3570: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3571: l_chg := TRUE;
3572: end if;
3565: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3566: l_chg := TRUE;
3567: end if;
3568: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3569: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3570: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3571: l_chg := TRUE;
3572: end if;
3573: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3566: l_chg := TRUE;
3567: end if;
3568: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3569: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3570: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3571: l_chg := TRUE;
3572: end if;
3573: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3574: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3569: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3570: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3571: l_chg := TRUE;
3572: end if;
3573: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3574: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3575: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3576: l_chg := TRUE;
3577: end if;
3570: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3571: l_chg := TRUE;
3572: end if;
3573: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3574: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3575: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3576: l_chg := TRUE;
3577: end if;
3578: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3571: l_chg := TRUE;
3572: end if;
3573: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3574: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3575: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3576: l_chg := TRUE;
3577: end if;
3578: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3579: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3574: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3575: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3576: l_chg := TRUE;
3577: end if;
3578: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3579: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3580: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3581: l_chg := TRUE;
3582: end if;
3575: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3576: l_chg := TRUE;
3577: end if;
3578: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3579: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3580: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3581: l_chg := TRUE;
3582: end if;
3583: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3576: l_chg := TRUE;
3577: end if;
3578: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3579: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3580: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3581: l_chg := TRUE;
3582: end if;
3583: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3584: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3579: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3580: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3581: l_chg := TRUE;
3582: end if;
3583: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3584: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3585: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3586: l_chg := TRUE;
3587: end if;
3580: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3581: l_chg := TRUE;
3582: end if;
3583: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3584: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3585: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3586: l_chg := TRUE;
3587: end if;
3588: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3581: l_chg := TRUE;
3582: end if;
3583: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3584: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3585: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3586: l_chg := TRUE;
3587: end if;
3588: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3589: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3584: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3585: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3586: l_chg := TRUE;
3587: end if;
3588: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3589: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3590: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3591: l_chg := TRUE;
3592: end if;
3585: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3586: l_chg := TRUE;
3587: end if;
3588: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3589: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3590: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3591: l_chg := TRUE;
3592: end if;
3593: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3586: l_chg := TRUE;
3587: end if;
3588: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3589: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3590: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3591: l_chg := TRUE;
3592: end if;
3593: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3594: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3589: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3590: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3591: l_chg := TRUE;
3592: end if;
3593: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3594: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3595: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3596: l_chg := TRUE;
3597: end if;
3590: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3591: l_chg := TRUE;
3592: end if;
3593: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3594: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3595: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3596: l_chg := TRUE;
3597: end if;
3598: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3591: l_chg := TRUE;
3592: end if;
3593: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3594: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3595: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3596: l_chg := TRUE;
3597: end if;
3598: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3599: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3594: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3595: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3596: l_chg := TRUE;
3597: end if;
3598: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3599: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3600: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3601: l_chg := TRUE;
3602: end if;
3595: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3596: l_chg := TRUE;
3597: end if;
3598: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3599: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3600: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3601: l_chg := TRUE;
3602: end if;
3603: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3596: l_chg := TRUE;
3597: end if;
3598: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3599: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3600: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3601: l_chg := TRUE;
3602: end if;
3603: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3604: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3599: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3600: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3601: l_chg := TRUE;
3602: end if;
3603: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3604: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3605: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3606: l_chg := TRUE;
3607: end if;
3600: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3601: l_chg := TRUE;
3602: end if;
3603: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3604: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3605: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3606: l_chg := TRUE;
3607: end if;
3608: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3601: l_chg := TRUE;
3602: end if;
3603: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3604: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3605: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3606: l_chg := TRUE;
3607: end if;
3608: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3609: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3604: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3605: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3606: l_chg := TRUE;
3607: end if;
3608: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3609: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3610: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3611: l_chg := TRUE;
3612: end if;
3605: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3606: l_chg := TRUE;
3607: end if;
3608: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3609: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3610: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3611: l_chg := TRUE;
3612: end if;
3613: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3606: l_chg := TRUE;
3607: end if;
3608: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3609: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3610: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3611: l_chg := TRUE;
3612: end if;
3613: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3614: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3609: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3610: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3611: l_chg := TRUE;
3612: end if;
3613: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3614: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3615: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3616: l_chg := TRUE;
3617: end if;
3610: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3611: l_chg := TRUE;
3612: end if;
3613: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3614: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3615: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3616: l_chg := TRUE;
3617: end if;
3618: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3611: l_chg := TRUE;
3612: end if;
3613: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3614: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3615: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3616: l_chg := TRUE;
3617: end if;
3618: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3619: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3614: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3615: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3616: l_chg := TRUE;
3617: end if;
3618: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3619: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3620: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3621: l_chg := TRUE;
3622: end if;
3615: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3616: l_chg := TRUE;
3617: end if;
3618: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3619: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3620: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3621: l_chg := TRUE;
3622: end if;
3623: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3616: l_chg := TRUE;
3617: end if;
3618: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3619: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3620: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3621: l_chg := TRUE;
3622: end if;
3623: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3624: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3619: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3620: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3621: l_chg := TRUE;
3622: end if;
3623: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3624: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3625: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3626: l_chg := TRUE;
3627: end if;
3620: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3621: l_chg := TRUE;
3622: end if;
3623: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3624: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3625: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3626: l_chg := TRUE;
3627: end if;
3628: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3621: l_chg := TRUE;
3622: end if;
3623: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3624: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3625: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3626: l_chg := TRUE;
3627: end if;
3628: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3629: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3624: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3625: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3626: l_chg := TRUE;
3627: end if;
3628: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3629: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3630: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3631: l_chg := TRUE;
3632: end if;
3625: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3626: l_chg := TRUE;
3627: end if;
3628: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3629: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3630: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3631: l_chg := TRUE;
3632: end if;
3633: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3626: l_chg := TRUE;
3627: end if;
3628: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3629: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3630: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3631: l_chg := TRUE;
3632: end if;
3633: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3634: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3629: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3630: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3631: l_chg := TRUE;
3632: end if;
3633: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3634: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3635: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3636: l_chg := TRUE;
3637: end if;
3630: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3631: l_chg := TRUE;
3632: end if;
3633: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3634: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3635: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3636: l_chg := TRUE;
3637: end if;
3638: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3631: l_chg := TRUE;
3632: end if;
3633: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3634: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3635: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3636: l_chg := TRUE;
3637: end if;
3638: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3639: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3634: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3635: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3636: l_chg := TRUE;
3637: end if;
3638: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3639: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3640: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3641: l_chg := TRUE;
3642: end if;
3635: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3636: l_chg := TRUE;
3637: end if;
3638: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3639: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3640: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3641: l_chg := TRUE;
3642: end if;
3643: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3636: l_chg := TRUE;
3637: end if;
3638: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3639: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3640: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3641: l_chg := TRUE;
3642: end if;
3643: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3644: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3639: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3640: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3641: l_chg := TRUE;
3642: end if;
3643: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3644: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3645: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3646: l_chg := TRUE;
3647: end if;
3640: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3641: l_chg := TRUE;
3642: end if;
3643: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3644: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3645: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3646: l_chg := TRUE;
3647: end if;
3648: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3641: l_chg := TRUE;
3642: end if;
3643: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3644: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3645: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3646: l_chg := TRUE;
3647: end if;
3648: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3649: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3644: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3645: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3646: l_chg := TRUE;
3647: end if;
3648: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3649: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3650: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3651: l_chg := TRUE;
3652: end if;
3645: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3646: l_chg := TRUE;
3647: end if;
3648: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3649: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3650: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3651: l_chg := TRUE;
3652: end if;
3653: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3646: l_chg := TRUE;
3647: end if;
3648: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3649: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3650: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3651: l_chg := TRUE;
3652: end if;
3653: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3654: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3649: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3650: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3651: l_chg := TRUE;
3652: end if;
3653: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3654: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3655: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3656: l_chg := TRUE;
3657: end if;
3650: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3651: l_chg := TRUE;
3652: end if;
3653: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3654: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3655: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3656: l_chg := TRUE;
3657: end if;
3658: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3651: l_chg := TRUE;
3652: end if;
3653: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3654: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3655: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3656: l_chg := TRUE;
3657: end if;
3658: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3659: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3654: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3655: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3656: l_chg := TRUE;
3657: end if;
3658: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3659: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3660: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3661: l_chg := TRUE;
3662: end if;
3655: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3656: l_chg := TRUE;
3657: end if;
3658: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3659: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3660: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3661: l_chg := TRUE;
3662: end if;
3663: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3656: l_chg := TRUE;
3657: end if;
3658: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3659: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3660: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3661: l_chg := TRUE;
3662: end if;
3663: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3664: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3659: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3660: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3661: l_chg := TRUE;
3662: end if;
3663: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3664: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3665: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3666: l_chg := TRUE;
3667: end if;
3660: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3661: l_chg := TRUE;
3662: end if;
3663: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3664: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3665: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3666: l_chg := TRUE;
3667: end if;
3668: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3661: l_chg := TRUE;
3662: end if;
3663: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3664: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3665: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3666: l_chg := TRUE;
3667: end if;
3668: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3669: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3664: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3665: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3666: l_chg := TRUE;
3667: end if;
3668: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3669: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3670: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3671: l_chg := TRUE;
3672: end if;
3665: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3666: l_chg := TRUE;
3667: end if;
3668: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3669: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3670: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3671: l_chg := TRUE;
3672: end if;
3673: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3666: l_chg := TRUE;
3667: end if;
3668: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3669: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3670: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3671: l_chg := TRUE;
3672: end if;
3673: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3674: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3669: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3670: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3671: l_chg := TRUE;
3672: end if;
3673: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3674: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3675: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3676: l_chg := TRUE;
3677: end if;
3670: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3671: l_chg := TRUE;
3672: end if;
3673: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3674: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3675: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3676: l_chg := TRUE;
3677: end if;
3678: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3671: l_chg := TRUE;
3672: end if;
3673: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3674: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3675: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3676: l_chg := TRUE;
3677: end if;
3678: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3679: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3674: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3675: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3676: l_chg := TRUE;
3677: end if;
3678: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3679: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3680: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3681: l_chg := TRUE;
3682: end if;
3675: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3676: l_chg := TRUE;
3677: end if;
3678: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3679: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3680: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3681: l_chg := TRUE;
3682: end if;
3683: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3676: l_chg := TRUE;
3677: end if;
3678: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3679: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3680: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3681: l_chg := TRUE;
3682: end if;
3683: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3684: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3679: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3680: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3681: l_chg := TRUE;
3682: end if;
3683: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3684: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3685: nvl(p_pen_attribute30,hr_api.g_varchar2)) then
3686: l_chg := TRUE;
3687: end if;
3680: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3681: l_chg := TRUE;
3682: end if;
3683: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3684: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3685: nvl(p_pen_attribute30,hr_api.g_varchar2)) then
3686: l_chg := TRUE;
3687: end if;
3688: --End Bug 4770367
3681: l_chg := TRUE;
3682: end if;
3683: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3684: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3685: nvl(p_pen_attribute30,hr_api.g_varchar2)) then
3686: l_chg := TRUE;
3687: end if;
3688: --End Bug 4770367
3689:
3704: p_update_change_insert => l_update_change_insert);
3705: --
3706: if l_update_override then
3707: --
3708: l_datetrack_mode := hr_api.g_update_override;
3709: --
3710: elsif l_update then
3711: --
3712: l_datetrack_mode := hr_api.g_update;
3708: l_datetrack_mode := hr_api.g_update_override;
3709: --
3710: elsif l_update then
3711: --
3712: l_datetrack_mode := hr_api.g_update;
3713: --
3714: else
3715: --
3716: l_datetrack_mode := hr_api.g_correction;
3712: l_datetrack_mode := hr_api.g_update;
3713: --
3714: else
3715: --
3716: l_datetrack_mode := hr_api.g_correction;
3717: --
3718: end if;
3719: --
3720: -- Start of API User Hook for the before hook of
3916: p_update_change_insert => l_update_change_insert);
3917: --
3918: if l_update_override then
3919: --
3920: l_ppe_datetrack_mode := hr_api.g_update_override;
3921: --
3922: elsif l_update then
3923: --
3924: l_ppe_datetrack_mode := hr_api.g_update;
3920: l_ppe_datetrack_mode := hr_api.g_update_override;
3921: --
3922: elsif l_update then
3923: --
3924: l_ppe_datetrack_mode := hr_api.g_update;
3925: --
3926: else
3927: --
3928: l_ppe_datetrack_mode := hr_api.g_correction;
3924: l_ppe_datetrack_mode := hr_api.g_update;
3925: --
3926: else
3927: --
3928: l_ppe_datetrack_mode := hr_api.g_correction;
3929: end if;
3930: ********************* END CODE PRIOR TO WWBUG: 1646442 *********/
3931: -- Because the benefit amount could have changed, and the premiums
3932: -- can be based on the benefit amount, re-calc it. It does a recalc
4114: p_update_change_insert => l_update_change_insert);
4115:
4116: if l_update_override then
4117: --
4118: l_ppe_datetrack_mode := hr_api.g_update_override;
4119: --
4120: elsif l_update then
4121: --
4122: l_ppe_datetrack_mode := hr_api.g_update;
4118: l_ppe_datetrack_mode := hr_api.g_update_override;
4119: --
4120: elsif l_update then
4121: --
4122: l_ppe_datetrack_mode := hr_api.g_update;
4123: --
4124: else
4125: --
4126: l_ppe_datetrack_mode := hr_api.g_correction;
4122: l_ppe_datetrack_mode := hr_api.g_update;
4123: --
4124: else
4125: --
4126: l_ppe_datetrack_mode := hr_api.g_correction;
4127: end if;
4128: /* End of Changes for WWBUG: 1646442 */
4129:
4130: ben_prtt_prem_api.update_prtt_prem
4268: ,p_business_group_id => p_business_group_id
4269: ,p_effective_end_date => p_effective_end_date
4270: ,p_object_version_number => l_last_pil_pdp.object_version_number
4271: ,p_effective_date => l_last_pil_pdp.effective_start_date
4272: ,p_datetrack_mode => hr_api.g_future_change
4273: ,p_multi_row_actn => FALSE
4274: ,p_called_from => 'UPDATE_ENROLLMENT'
4275: );
4276: end if;
4301: p_update_override => l_update_override,
4302: p_update_change_insert => l_update_change_insert);
4303:
4304: if l_update_override then
4305: l_egd_datetrack_mode := hr_api.g_update_override;
4306: elsif l_update then
4307: l_egd_datetrack_mode := hr_api.g_update;
4308: else
4309: l_egd_datetrack_mode := hr_api.g_correction;
4303:
4304: if l_update_override then
4305: l_egd_datetrack_mode := hr_api.g_update_override;
4306: elsif l_update then
4307: l_egd_datetrack_mode := hr_api.g_update;
4308: else
4309: l_egd_datetrack_mode := hr_api.g_correction;
4310: end if;
4311:
4305: l_egd_datetrack_mode := hr_api.g_update_override;
4306: elsif l_update then
4307: l_egd_datetrack_mode := hr_api.g_update;
4308: else
4309: l_egd_datetrack_mode := hr_api.g_correction;
4310: end if;
4311:
4312: --9881657
4313: l_new_dpnt_cvg_thru_dt := hr_api.g_eot;
4309: l_egd_datetrack_mode := hr_api.g_correction;
4310: end if;
4311:
4312: --9881657
4313: l_new_dpnt_cvg_thru_dt := hr_api.g_eot;
4314: if l_egd.cvg_thru_dt <> hr_api.g_eot then
4315: l_new_dpnt_cvg_thru_dt := l_dpnt_cvg_thru_dt;
4316: end if;
4317: hr_utility.set_location('9881657 l_new_dpnt_cvg_thru_dt' || l_new_dpnt_cvg_thru_dt, 123.123);
4310: end if;
4311:
4312: --9881657
4313: l_new_dpnt_cvg_thru_dt := hr_api.g_eot;
4314: if l_egd.cvg_thru_dt <> hr_api.g_eot then
4315: l_new_dpnt_cvg_thru_dt := l_dpnt_cvg_thru_dt;
4316: end if;
4317: hr_utility.set_location('9881657 l_new_dpnt_cvg_thru_dt' || l_new_dpnt_cvg_thru_dt, 123.123);
4318: --9881657
4448: --
4449: -- When in validation only mode raise the Validate_Enabled exception
4450: --
4451: if p_validate then
4452: raise hr_api.validate_enabled;
4453: end if;
4454: --
4455: -- Set all output arguments
4456: --
4460: if g_debug then
4461: hr_utility.set_location(' Leaving:'||l_proc, 70);
4462: end if;
4463: exception
4464: when hr_api.validate_enabled then
4465: --
4466: -- As the Validate_Enabled exception has been raised
4467: -- we must rollback to the savepoint
4468: --
4494: (p_validate in boolean default false
4495: ,p_prtt_enrt_rslt_id in number
4496: ,p_effective_start_date out nocopy date
4497: ,p_effective_end_date out nocopy date
4498: ,p_business_group_id in number default hr_api.g_number
4499: ,p_oipl_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4495: ,p_prtt_enrt_rslt_id in number
4496: ,p_effective_start_date out nocopy date
4497: ,p_effective_end_date out nocopy date
4498: ,p_business_group_id in number default hr_api.g_number
4499: ,p_oipl_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4496: ,p_effective_start_date out nocopy date
4497: ,p_effective_end_date out nocopy date
4498: ,p_business_group_id in number default hr_api.g_number
4499: ,p_oipl_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4497: ,p_effective_end_date out nocopy date
4498: ,p_business_group_id in number default hr_api.g_number
4499: ,p_oipl_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4498: ,p_business_group_id in number default hr_api.g_number
4499: ,p_oipl_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4499: ,p_oipl_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4500: ,p_person_id in number default hr_api.g_number
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4501: ,p_assignment_id in number default hr_api.g_number
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4502: ,p_pgm_id in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4503: ,p_pl_id in number default hr_api.g_number
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4504: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4505: ,p_ptip_id in number default hr_api.g_number
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4506: ,p_pl_typ_id in number default hr_api.g_number
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4507: ,p_ler_id in number default hr_api.g_number
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4508: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4509: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4510: ,p_bnft_amt in number default hr_api.g_number
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4511: ,p_uom in varchar2 default hr_api.g_varchar2
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4512: ,p_orgnl_enrt_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4513: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4514: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4515: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4516: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4517: ,p_erlst_deenrt_dt in date default hr_api.g_date
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4518: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4519: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4520: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4521: ,p_pl_ordr_num in number default hr_api.g_number
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4522: ,p_plip_ordr_num in number default hr_api.g_number
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4523: ,p_ptip_ordr_num in number default hr_api.g_number
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4524: ,p_oipl_ordr_num in number default hr_api.g_number
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4525: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4526: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4527: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4528: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4529: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4530: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4531: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4532: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4533: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4534: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4535: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4536: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4537: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4538: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4539: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4540: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4541: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4542: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4543: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4544: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4545: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4546: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4547: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4548: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4549: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4550: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4551: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4552: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4553: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4554: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4555: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4556: ,p_request_id in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4557: ,p_program_application_id in number default hr_api.g_number
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4564: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4565: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4558: ,p_program_id in number default hr_api.g_number
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4564: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4565: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4566: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4559: ,p_program_update_date in date default hr_api.g_date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4564: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4565: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4566: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4567: ,p_effective_date in date
4560: ,p_object_version_number in out nocopy number
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4564: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4565: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4566: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4567: ,p_effective_date in date
4568: ,p_datetrack_mode in varchar2
4561: ,p_per_in_ler_id in number default hr_api.g_number
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4564: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4565: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4566: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4567: ,p_effective_date in date
4568: ,p_datetrack_mode in varchar2
4569: ,p_multi_row_validate in boolean default TRUE
4562: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4563: ,p_bnft_ordr_num in number default hr_api.g_number
4564: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4565: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4566: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4567: ,p_effective_date in date
4568: ,p_datetrack_mode in varchar2
4569: ,p_multi_row_validate in boolean default TRUE
4570: ) is
4636: --
4637: savepoint update_PRTT_ENRT_RESULT;
4638: --
4639: if fnd_global.conc_request_id in (0,-1) and
4640: p_business_group_id <> hr_api.g_number then
4641: --
4642: --bug#3568529
4643: ben_env_object.get(p_rec => l_env_rec);
4644: if l_env_rec.benefit_action_id is null then
4672: -- when the open LE then gain dpnt ,then process the opne on the same dt of GD
4673: -- the result of GD are lost. because the per_in_ler id of open updated in gd
4674:
4675: --bug # 3086161
4676: if p_datetrack_mode = hr_api.g_correction and p_per_in_ler_id <> hr_api.g_number then
4677: open c_old_rslt ;
4678: fetch c_old_rslt into l_old_rslt ;
4679: close c_old_rslt ;
4680: if l_old_rslt.per_in_ler_id <> p_per_in_ler_id
4953: ,p_effective_date => trunc(p_effective_date)
4954: ,p_datetrack_mode => p_datetrack_mode
4955: );
4956: exception
4957: when hr_api.cannot_find_prog_unit then
4958: hr_api.cannot_find_prog_unit_error
4959: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
4960: ,p_hook_type => 'BP'
4961: );
4954: ,p_datetrack_mode => p_datetrack_mode
4955: );
4956: exception
4957: when hr_api.cannot_find_prog_unit then
4958: hr_api.cannot_find_prog_unit_error
4959: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
4960: ,p_hook_type => 'BP'
4961: );
4962: --
5125: ,p_effective_date => trunc(p_effective_date)
5126: ,p_datetrack_mode => p_datetrack_mode
5127: );
5128: exception
5129: when hr_api.cannot_find_prog_unit then
5130: hr_api.cannot_find_prog_unit_error
5131: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
5132: ,p_hook_type => 'AP'
5133: );
5126: ,p_datetrack_mode => p_datetrack_mode
5127: );
5128: exception
5129: when hr_api.cannot_find_prog_unit then
5130: hr_api.cannot_find_prog_unit_error
5131: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
5132: ,p_hook_type => 'AP'
5133: );
5134: --
5142: --
5143: -- When in validation only mode raise the Validate_Enabled exception
5144: --
5145: if p_validate then
5146: raise hr_api.validate_enabled;
5147: end if;
5148: --
5149: -- Set all output arguments
5150: --
5157: end if;
5158: --
5159: exception
5160: --
5161: when hr_api.validate_enabled then
5162: --
5163: -- As the Validate_Enabled exception has been raised
5164: -- we must rollback to the savepoint
5165: --
5239: ,p_effective_date => trunc(p_effective_date)
5240: ,p_datetrack_mode => p_datetrack_mode
5241: );
5242: exception
5243: when hr_api.cannot_find_prog_unit then
5244: hr_api.cannot_find_prog_unit_error
5245: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
5246: ,p_hook_type => 'BP'
5247: );
5240: ,p_datetrack_mode => p_datetrack_mode
5241: );
5242: exception
5243: when hr_api.cannot_find_prog_unit then
5244: hr_api.cannot_find_prog_unit_error
5245: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
5246: ,p_hook_type => 'BP'
5247: );
5248: --
5273: ,p_effective_date => trunc(p_effective_date)
5274: ,p_datetrack_mode => p_datetrack_mode
5275: );
5276: exception
5277: when hr_api.cannot_find_prog_unit then
5278: hr_api.cannot_find_prog_unit_error
5279: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
5280: ,p_hook_type => 'AP'
5281: );
5274: ,p_datetrack_mode => p_datetrack_mode
5275: );
5276: exception
5277: when hr_api.cannot_find_prog_unit then
5278: hr_api.cannot_find_prog_unit_error
5279: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
5280: ,p_hook_type => 'AP'
5281: );
5282: --
5290: --
5291: -- When in validation only mode raise the Validate_Enabled exception
5292: --
5293: if p_validate then
5294: raise hr_api.validate_enabled;
5295: end if;
5296: --
5297: p_effective_start_date := l_effective_start_date;
5298: p_effective_end_date := l_effective_end_date;
5303: end if;
5304: --
5305: exception
5306: --
5307: when hr_api.validate_enabled then
5308: --
5309: -- As the Validate_Enabled exception has been raised
5310: -- we must rollback to the savepoint
5311: --
5711: Begin
5712: Open c1;
5713: Fetch c1 into l_date,l_pil_id;
5714: If c1%notfound then
5715: l_date := hr_api.g_date;
5716: l_pil_id := to_number(null);
5717: End if;
5718: Close c1;
5719: p_date := l_date;
5882: from ben_prtt_rt_val prv,
5883: ben_enrt_rt ecr
5884: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5885: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5886: and prv.rt_end_dt <> hr_api.g_eot
5887: and prv.business_group_id = p_business_group_id
5888: and prv.per_in_ler_id = p_per_in_ler_id
5889: and prv.prtt_rt_val_stat_cd is null;
5890: --
5945: from ben_prmry_care_prvdr_f pcp
5946: where pcp.business_group_id = p_business_group_id
5947: and pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5948: and p_effective_date < pcp.effective_start_date
5949: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot
5950: ;
5951: -- 3574168
5952:
5953: l_abr c_abr%rowtype;
6091: ,P_EFFECTIVE_START_DATE => l_pcp.effective_start_date
6092: ,P_EFFECTIVE_END_DATE => l_pcp.effective_end_date
6093: ,P_OBJECT_VERSION_NUMBER => l_pcp.object_version_number
6094: ,P_EFFECTIVE_DATE => p_effective_date
6095: ,P_DATETRACK_MODE => hr_api.g_zap
6096: ,p_called_from => 'delete_enrollment'
6097: );
6098: --
6099: End loop;
6112: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
6113: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
6114: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
6115: ,P_EFFECTIVE_DATE => l_pcp_effective_date
6116: ,P_DATETRACK_MODE => hr_api.g_zap
6117: ,p_called_from => 'delete_enrollment'
6118: );
6119: --
6120: End loop;
6147: p_effective_start_date => l_effective_start_date,
6148: p_effective_end_date => l_effective_end_date,
6149: p_object_version_number => l_pen.object_version_number,
6150: p_effective_date => p_effective_date,
6151: p_datetrack_mode => hr_api.g_future_change,
6152: p_multi_row_validate => FALSE);
6153: --
6154: open c_pen;
6155: fetch c_pen into l_pen;
6203: -- leslie code begin:
6204: -- when result is voided in correction mode, we can't compute premium
6205: -- credits. Tell use that they may want to manually.
6206: -- If in correction and esd of result is before first day of this month...
6207: if l_datetrack_mode = hr_api.g_correction and l_pen.effective_start_date <
6208: to_date(to_char(p_effective_date, 'mm-yyyy'), 'mm-yyyy') then
6209: ben_prem_prtt_monthly.premium_warning
6210: (p_person_id => l_pen.person_id
6211: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
6245: --
6246: -- When in validation only mode raise the Validate_Enabled exception
6247: --
6248: if p_validate then
6249: raise hr_api.validate_enabled;
6250: end if;
6251: --
6252: if g_debug then
6253: hr_utility.set_location(' Leaving:'||l_proc, 70);
6254: end if;
6255: --
6256: Exception
6257: --
6258: when hr_api.validate_enabled
6259: then
6260: --
6261: -- As the Validate_Enabled exception has been raised
6262: -- we must rollback to the savepoint
6455: ,abr.input_value_id
6456: from ben_prtt_rt_val prv
6457: ,ben_acty_base_rt_f abr
6458: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6459: and prv.rt_end_dt = hr_api.g_eot
6460: and prv.business_group_id = p_business_group_id
6461: and prv.acty_base_rt_id = abr.acty_base_rt_id
6462: and p_effective_date between abr.effective_start_date
6463: and abr.effective_end_date
6478: ,ben_per_in_ler pil -- Bug 8573195,not to pick the rows of backed out lifevent for rate adjustment
6479: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6480: and prv.rt_end_dt > p_rt_end_dt
6481: and prv.per_in_ler_id <> p_per_in_ler_id
6482: and prv.rt_end_dt <> hr_api.g_eot
6483: and prv.business_group_id = p_business_group_id
6484: and prv.acty_base_rt_id = abr.acty_base_rt_id
6485: and pil.per_in_ler_id = prv.per_in_ler_id
6486: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
6535: from ben_prtt_rt_val prv,
6536: ben_enrt_rt ecr
6537: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6538: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
6539: and prv.rt_end_dt <> hr_api.g_eot
6540: and prv.business_group_id = p_business_group_id
6541: and prv.per_in_ler_id = p_per_in_ler_id
6542: and prv.prtt_rt_val_stat_cd is null;
6543: --
6602: from ben_prmry_care_prvdr_f pcp
6603: where business_group_id = p_business_group_id
6604: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6605: and c_pcp_effective_date < effective_start_date ----3631067: Changed p_effective_date to c_pcp_effective_date
6606: and NVL(effective_end_date, hr_api.g_eot) = hr_api.g_eot
6607: ;
6608: -- 3574168
6609:
6610: --
6612: --
6613: -- ikasire: deleted the condition
6614: -- pen.enrt_cvg_strt_dt >= p_effective_date
6615: -- since it may not be always true. Instead added the
6616: -- condition pen.ENRT_CVG_THRU_DT = hr_api.g_eot
6617: -- to get the new prtt enrt record. Still there is a
6618: -- gap in this '1 prior' coding, which has to be
6619: -- handled with more detailed study.
6620: --Bug 2847110
6648: exists (select * from ben_prtt_enrt_rslt_f
6649: where per_in_ler_id = p_per_in_ler_id
6650: and pl_id = l_pl_id
6651: and pl_typ_id = l_pl_typ_id
6652: and ENRT_CVG_THRU_DT = hr_api.g_eot
6653: and effective_end_date = hr_api.g_eot))
6654: or (l_pl_id <> pen.pl_id
6655: and pen.effective_start_date >= p_effective_date)) -- 14599287
6656:
6649: where per_in_ler_id = p_per_in_ler_id
6650: and pl_id = l_pl_id
6651: and pl_typ_id = l_pl_typ_id
6652: and ENRT_CVG_THRU_DT = hr_api.g_eot
6653: and effective_end_date = hr_api.g_eot))
6654: or (l_pl_id <> pen.pl_id
6655: and pen.effective_start_date >= p_effective_date)) -- 14599287
6656:
6657: )
6663: or ((nvl(pen.oipl_id, -1) <> nvl(l_oipl_id, -1) and pen.pl_id = l_pl_id)
6664: and not exists (select * from ben_prtt_enrt_rslt_f
6665: where oipl_id = l_oipl_id
6666: and per_in_ler_id = p_per_in_ler_id
6667: and ENRT_CVG_THRU_DT = hr_api.g_eot
6668: and EFFECTIVE_END_DATE = hr_api.g_eot
6669: and prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id))--12876320
6670: )
6671: --Bug #12662110 end
6664: and not exists (select * from ben_prtt_enrt_rslt_f
6665: where oipl_id = l_oipl_id
6666: and per_in_ler_id = p_per_in_ler_id
6667: and ENRT_CVG_THRU_DT = hr_api.g_eot
6668: and EFFECTIVE_END_DATE = hr_api.g_eot
6669: and prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id))--12876320
6670: )
6671: --Bug #12662110 end
6672: and pen.prtt_enrt_rslt_stat_cd is null
6670: )
6671: --Bug #12662110 end
6672: and pen.prtt_enrt_rslt_stat_cd is null
6673: -- and pen.enrt_cvg_strt_dt >= p_effective_date
6674: and pen.ENRT_CVG_THRU_DT = hr_api.g_eot
6675: and pen.effective_end_date = hr_api.g_eot
6676: -- and pen.business_group_id = p_business_group_id
6677: --and p_effective_date between pen.effective_start_date
6678: -- and pen.effective_end_date
6671: --Bug #12662110 end
6672: and pen.prtt_enrt_rslt_stat_cd is null
6673: -- and pen.enrt_cvg_strt_dt >= p_effective_date
6674: and pen.ENRT_CVG_THRU_DT = hr_api.g_eot
6675: and pen.effective_end_date = hr_api.g_eot
6676: -- and pen.business_group_id = p_business_group_id
6677: --and p_effective_date between pen.effective_start_date
6678: -- and pen.effective_end_date
6679: and pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
6684: from ben_prtt_enrt_rslt_f pen
6685: where pen.rplcs_sspndd_rslt_id = l_pen.rplcs_sspndd_rslt_id
6686: and pen.business_group_id = p_business_group_id
6687: and pen.sspndd_flag = 'Y'
6688: and pen.enrt_cvg_thru_dt = hr_api.g_eot
6689: and pen.effective_end_date = hr_api.g_eot
6690: and pen.prtt_enrt_rslt_stat_cd is null
6691: and p_effective_date between
6692: pen.effective_start_date and pen.effective_end_date
6685: where pen.rplcs_sspndd_rslt_id = l_pen.rplcs_sspndd_rslt_id
6686: and pen.business_group_id = p_business_group_id
6687: and pen.sspndd_flag = 'Y'
6688: and pen.enrt_cvg_thru_dt = hr_api.g_eot
6689: and pen.effective_end_date = hr_api.g_eot
6690: and pen.prtt_enrt_rslt_stat_cd is null
6691: and p_effective_date between
6692: pen.effective_start_date and pen.effective_end_date
6693: -- Bug 6165501 : Added union clause if its a Correction case, and interim has already
6696: select 'Y'
6697: from ben_prtt_enrt_rslt_f pen, ben_le_clsn_n_rstr cls
6698: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6699: and pen.prtt_enrt_rslt_stat_cd is null
6700: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6701: and pen.per_in_ler_id = p_per_in_ler_id
6702: and cls.bkup_tbl_id = pen.prtt_enrt_rslt_id
6703: and cls.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F_CORR'
6704: and cls.per_in_ler_ended_id = p_per_in_ler_id;
6728: where pen2.per_in_ler_id = p_per_in_ler_id
6729: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6730: and pen2.sspndd_flag = 'Y'
6731: and pen2.prtt_enrt_rslt_stat_cd is null
6732: and pen2.effective_end_date <> hr_api.g_eot
6733: and pen2.business_group_id = p_business_group_id)
6734: and pen.business_group_id = p_business_group_id
6735: -- and pen.prtt_enrt_rslt_stat_cd is null
6736: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6732: and pen2.effective_end_date <> hr_api.g_eot
6733: and pen2.business_group_id = p_business_group_id)
6734: and pen.business_group_id = p_business_group_id
6735: -- and pen.prtt_enrt_rslt_stat_cd is null
6736: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6737: and pen.per_in_ler_id = p_per_in_ler_id
6738: and p_effective_date between
6739: pen.effective_start_date and pen.effective_end_date;
6740:
6756: and pen.prtt_enrt_rslt_stat_cd is null
6757: and pen.sspndd_flag = 'N'
6758: and p_effective_date > pen.effective_start_date
6759: and pen.enrt_cvg_thru_dt > p_effective_date -- 4919591
6760: and pen.effective_end_date = hr_api.g_eot; --4919591
6761:
6762:
6763: cursor c_rslt_pl ( p_person_id number ,
6764: p_pgm_id number ,
6780: /*Bug : Commented below conditions. Check only for if erlst_deenrt_dt is greater than
6781: p_effective_date for previous per_in_ler's
6782: /*
6783: and pen.enrt_cvg_thru_dt > p_effective_date -- 4919591
6784: and pen.effective_end_date = hr_api.g_eot; -- 4919591------------7458990
6785: */
6786:
6787: cursor c_rslt_ptip( p_person_id number ,
6788: p_pgm_id number ,
6800: and pen.prtt_enrt_rslt_stat_cd is null
6801: and pen.sspndd_flag = 'N'
6802: and p_effective_date > pen.effective_start_date
6803: and pen.enrt_cvg_thru_dt > p_effective_date
6804: and pen.effective_end_date = hr_api.g_eot;
6805: --
6806: cursor c_per_in_ler (p_per_in_ler_id number) is
6807: select *
6808: from ben_per_in_ler
6874: and nvl(p_pl_id ,-1) = nvl(pen.pl_id,-1)
6875: and nvl(p_oipl_id,-1) = nvl(pen.oipl_id, -1)
6876: and p_per_in_ler_id = pen.per_in_ler_id
6877: and pen.prtt_enrt_rslt_stat_cd is null
6878: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6879: ;
6880: --
6881: l_current_result_id number ;
6882: --
6896: where bkup_tbl_id = c_pen_id
6897: and per_in_ler_ended_id = c_pil_id
6898: and per_in_ler_id <> c_pil_id
6899: and effective_start_date = c_pen_effective_start_date -- bug 7197868
6900: and enrt_cvg_thru_dt = hr_api.g_eot;
6901: l_corr_pil_id BEN_LE_CLSN_N_RSTR.per_in_ler_id%type ;
6902:
6903: cursor c_pen_obj_no (c_pil_id number
6904: ,c_pen_id number ) is
6920: and epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6921: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id
6922: and pen.per_in_ler_id=p_per_in_ler_id
6923: and pen.ler_id = ler.ler_id
6924: and nvl(epe.erlst_deenrt_dt,hr_api.g_sot) > p_effective_date;
6925:
6926: l_crntly_enrd_flag varchar2(10);
6927: l_ler_type_cd varchar2(20);
6928:
6937: and epe.per_in_ler_id=p_per_in_ler_id
6938: and pen.ler_id = ler.ler_id
6939: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id
6940: and pen.per_in_ler_id=p_per_in_ler_id
6941: and nvl(epe.erlst_deenrt_dt,hr_api.g_sot) > p_effective_date;
6942:
6943: l_typ_cd varchar2(20);
6944: --
6945:
6971: ben_prtt_rt_val curprv,
6972: ben_acty_base_rt_f abr
6973: WHERE curprv.business_group_id=oldprv.business_group_id
6974: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id
6975: AND oldprv.rt_end_dt <> hr_api.g_eot
6976: AND oldprv.acty_base_rt_id = curprv.acty_base_rt_id
6977: AND oldprv.prtt_rt_val_stat_cd IS NULL
6978: and curprv.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
6979: AND abr.acty_base_rt_id = oldprv.acty_base_rt_id
6994: AND pen.business_group_id = p_business_group_id
6995: AND epe.per_in_ler_id = pen.per_in_ler_id
6996: AND epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
6997: and pen.pl_typ_id = p_pl_typ_id
6998: AND pen.effective_end_date = hr_api.g_eot
6999: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
7000: ORDER BY pen.effective_start_date desc;
7001: l_get_epe c_get_epe%rowtype;
7002:
6995: AND epe.per_in_ler_id = pen.per_in_ler_id
6996: AND epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
6997: and pen.pl_typ_id = p_pl_typ_id
6998: AND pen.effective_end_date = hr_api.g_eot
6999: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
7000: ORDER BY pen.effective_start_date desc;
7001: l_get_epe c_get_epe%rowtype;
7002:
7003: cursor c_get_old_prv1 is
7012: ben_acty_base_rt_f abr2 ,
7013: ben_prtt_enrt_rslt_f pen
7014: WHERE curprv.business_group_id=oldprv.business_group_id
7015: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id
7016: AND oldprv.rt_end_dt <> hr_api.g_eot
7017: AND oldprv.prtt_rt_val_stat_cd IS NULL
7018: AND abr.acty_base_rt_id = oldprv.acty_base_rt_id
7019: AND p_effective_date BETWEEN abr.effective_start_date
7020: AND abr.effective_end_date
7034: WHERE pen1.business_group_id = pen.business_group_id
7035: AND pen1.per_in_ler_id = curprv.per_in_ler_id
7036: AND pen1.pl_typ_id = pen.pl_typ_id
7037: AND pen1.prtt_enrt_rslt_id = curprv.prtt_enrt_rslt_id
7038: AND pen1.effective_end_date = hr_api.g_eot
7039: AND pen1.enrt_cvg_thru_dt = hr_api.g_eot);
7040: -- l_get_old_prv1 c_get_old_prv1%rowtype; ---Bug 9290518
7041: l_rt_strt_dt1 date;
7042: l_enrt_cvg_end_dt1 date;
7035: AND pen1.per_in_ler_id = curprv.per_in_ler_id
7036: AND pen1.pl_typ_id = pen.pl_typ_id
7037: AND pen1.prtt_enrt_rslt_id = curprv.prtt_enrt_rslt_id
7038: AND pen1.effective_end_date = hr_api.g_eot
7039: AND pen1.enrt_cvg_thru_dt = hr_api.g_eot);
7040: -- l_get_old_prv1 c_get_old_prv1%rowtype; ---Bug 9290518
7041: l_rt_strt_dt1 date;
7042: l_enrt_cvg_end_dt1 date;
7043: l_enrt_cvg_strt_dt1 date;
7276: FROM ben_prtt_enrt_rslt_f pen
7277: WHERE pen.per_in_ler_id = p_per_in_ler_id
7278: AND pen.pl_typ_id = p_pl_typ_id
7279: AND pen.pgm_id = p_pgm_id
7280: AND enrt_cvg_thru_dt <> hr_api.g_eot
7281: AND pen.prtt_enrt_rslt_stat_cd IS NULL;
7282:
7283: type l_get_ended_pen1 is table of c_get_ended_pen%rowtype;
7284: l_get_ended_pen l_get_ended_pen1;
7822: -- **** By-pass the check.
7823: --
7824: null;
7825: --
7826: --elsif (p_effective_date < nvl(l_pen.erlst_deenrt_dt,hr_api.g_sot) and
7827: -- on the erlst_deenrt_dt then deenrt is allowd so -1 is compared
7828: if g_debug then
7829: hr_utility.set_location('cvg end dt ' || l_enrt_cvg_end_dt , 7086);
7830: hr_utility.set_location('denrt ' || l_pen.erlst_deenrt_dt , 7086);
7828: if g_debug then
7829: hr_utility.set_location('cvg end dt ' || l_enrt_cvg_end_dt , 7086);
7830: hr_utility.set_location('denrt ' || l_pen.erlst_deenrt_dt , 7086);
7831: end if;
7832: elsif (l_enrt_cvg_end_dt < nvl(l_pen.erlst_deenrt_dt,hr_api.g_sot)-1 and
7833: l_pen.sspndd_flag = 'N' /*and p_effective_date > l_pen.enrt_cvg_strt_dt */) then
7834: --
7835: -- Must now check if can deenroll legally. If an enrollment is
7836: -- found for the level at which the the required period of enrollment
8027: end if;
8028: close get_lf_evt_dt;
8029: --
8030: If ((p_effective_date between
8031: l_pen.ENRT_CVG_STRT_DT and nvl(l_pen.enrt_cvg_thru_dt, hr_api.g_eot))
8032: and ( (l_pen.SSPNDD_FLAG = 'N') or
8033: ( nvl(p_source,'x') <> 'benuneai' and l_pen.SSPNDD_FLAG = 'Y') --CFW
8034: )) or
8035: ((l_lf_evt_ocrd_dt between
8032: and ( (l_pen.SSPNDD_FLAG = 'N') or
8033: ( nvl(p_source,'x') <> 'benuneai' and l_pen.SSPNDD_FLAG = 'Y') --CFW
8034: )) or
8035: ((l_lf_evt_ocrd_dt between
8036: l_pen.ENRT_CVG_STRT_DT and nvl(l_pen.enrt_cvg_thru_dt, hr_api.g_eot))
8037: and l_pil_id <> p_per_in_ler_id
8038: and ( (l_pen.SSPNDD_FLAG = 'N') or
8039: ( nvl(p_source,'x') <> 'benuneai' and l_pen.SSPNDD_FLAG = 'Y') --CFW
8040: )) or
8089: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8090: ,p_effective_date => p_effective_date
8091: ,p_business_group_id => p_business_group_id
8092: ,p_validate => FALSE
8093: ,p_datetrack_mode => hr_api.g_delete
8094: );
8095: end if;
8096: hr_utility.set_location('l_benmngle_parm_rec.mode_cd '|| l_benmngle_parm_rec.mode_cd , 100);
8097: hr_utility.set_location('l_env_rec.mode_cd '|| l_env_rec.mode_cd , 100);
8290: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8291: ,p_effective_date => p_effective_date
8292: ,p_business_group_id => p_business_group_id
8293: ,p_validate => FALSE
8294: ,p_datetrack_mode => hr_api.g_zap
8295: ,p_source => p_source
8296: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
8297: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
8298: );
8414: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8415: ,p_effective_date => p_effective_date
8416: ,p_business_group_id => p_business_group_id
8417: ,p_validate => FALSE
8418: ,p_datetrack_mode => hr_api.g_zap
8419: ,p_source => p_source
8420: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
8421: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
8422: );
8427: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8428: ,p_effective_date => p_effective_date
8429: ,p_business_group_id => p_business_group_id
8430: ,p_validate => FALSE
8431: ,p_datetrack_mode => hr_api.g_zap
8432: ,p_source => p_source
8433: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
8434: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
8435: );*/
8578: ,P_EFFECTIVE_DATE => p_effective_date
8579: );
8580: end loop;
8581: ---Bug 9290518
8582: hr_utility.set_location('P_RT_END_DT :'||hr_api.g_eot,3455);
8583: -- else ------------Bug 7209243
8584: if not(l_old_prv_found) then --Bug 9290518
8585: hr_utility.set_location('c_get_old_prv not found',3455);
8586: ---get the new rt start dat to compute the end date
8641: end if;
8642: close c_get_epe; -------------Bug 7209243
8643: end if;
8644: -- close c_get_old_prv; ---Bug 9290518
8645: hr_utility.set_location('P_RT_END_DT not fund :'||hr_api.g_eot,3455);
8646: hr_utility.set_location('p_effective_start_date :'||p_effective_start_date,3455);
8647: hr_utility.set_location('p_effective_date :'||p_effective_date,3455);
8648: end if;
8649: -----Bug 6925893
8650: end if;
8651: end if;
8652: --End Bug 5499809
8653:
8654: hr_utility.set_location('P_RT_END_DT not fund1 :'||hr_api.g_eot,3455);
8655: --
8656: l_step := 35;
8657: if g_debug then
8658: hr_utility.set_location(l_proc,3456);
8818: --
8819: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);
8820: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);
8821: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);
8822: hr_utility.set_location('DATETRACK_MODE '|| hr_api.g_delete, 15);
8823: -- Since, deletion automatically sets end-date to 1 day less than effective-date,
8824: -- call the delete-api with effective_date = cvg_thru_date+1.
8825: --
8826: ben_prmry_care_prvdr_api.delete_prmry_care_prvdr
8829: ,P_EFFECTIVE_START_DATE => l_pcp.effective_start_date
8830: ,P_EFFECTIVE_END_DATE => l_pcp.effective_end_date
8831: ,P_OBJECT_VERSION_NUMBER => l_pcp.object_version_number
8832: ,P_EFFECTIVE_DATE => l_pcp_effective_date
8833: ,P_DATETRACK_MODE => hr_api.g_delete
8834: ,p_called_from => 'delete_enrollment'
8835: );
8836: --
8837: End loop;
8852: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
8853: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
8854: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
8855: ,P_EFFECTIVE_DATE => l_pcp_effective_start_date
8856: ,P_DATETRACK_MODE => hr_api.g_zap
8857: ,p_called_from => 'delete_enrollment'
8858: );
8859: End loop;
8860: -- 3574168
9028: ,p_effective_date => p_effective_date
9029: ,p_end_date => l_enrt_cvg_end_dt
9030: ,p_business_group_id => p_business_group_id
9031: ,p_validate => FALSE
9032: ,p_datetrack_mode => hr_api.g_delete
9033: ,p_source => p_source
9034: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
9035: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
9036: );
9153: ,p_effective_date => p_effective_date
9154: ,p_end_date => l_enrt_cvg_end_dt
9155: ,p_business_group_id => p_business_group_id
9156: ,p_validate => FALSE
9157: ,p_datetrack_mode => hr_api.g_delete
9158: ,p_source => p_source
9159: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
9160: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
9161: );
9167: ,p_effective_date => p_effective_date
9168: ,p_end_date => l_enrt_cvg_end_dt
9169: ,p_business_group_id => p_business_group_id
9170: ,p_validate => FALSE
9171: ,p_datetrack_mode => hr_api.g_delete
9172: ,p_source => p_source
9173: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
9174: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
9175: );*/
9196: end if;
9197: --
9198: --CFW. If deleting a suspended result, remove interim pen id
9199: -- below code is commenetd as part of 5347887.
9200: /*l_rplcs_sspndd_rslt_id := hr_api.g_number;
9201: if l_pen.sspndd_flag = 'Y' then
9202: l_rplcs_sspndd_rslt_id := null;
9203: end if;*/
9204: -- bug#5363388
9293: p_effective_start_date => p_effective_start_date,
9294: p_effective_end_date => p_effective_end_date,
9295: p_object_version_number => l_del_next_chg_pen.object_version_number,
9296: p_effective_date => l_del_next_chg_pen.effective_start_date,
9297: p_datetrack_mode => hr_api.g_delete_next_change,
9298: p_multi_row_validate => FALSE);
9299:
9300: end if;
9301: close c_get_last_pil;
9351: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
9352: ,p_effective_date => p_effective_date
9353: ,p_business_group_id => p_business_group_id
9354: ,p_validate => FALSE
9355: ,p_datetrack_mode => hr_api.g_delete
9356: );
9357: end if;
9358: --
9359: end if;
9385: -- Bug 2537720
9386: -- This is not allowing to update the enrollment on the same date for
9387: -- the suspended enrollment.So added the l_pen.effective_start_date < p_effective_date
9388: -- condition.
9389: if p_datetrack_mode=hr_api.g_update
9390: and l_pen.effective_start_date < p_effective_date
9391: and p_per_in_ler_id <> l_pil_id then -----Added for the Bug 7311284
9392: --
9393: l_eff_dt:=p_effective_date-1;
9702: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
9703: ,p_effective_date => p_effective_date
9704: ,p_business_group_id => p_business_group_id
9705: ,p_validate => FALSE
9706: ,p_datetrack_mode => hr_api.g_delete
9707: );
9708: end if;
9709: --
9710: --- # 2546259
9723: IF l_get_correction_info.place_holder='X' THEN
9724: l_prtt_enrt_rslt_Stat_cd:=NULL;
9725: l_datetrack_mode:='CORRECTION';
9726: ELSE
9727: l_datetrack_mode := hr_api.g_zap;
9728: END IF;
9729: --
9730: if p_source = 'beninelg' then
9731: l_datetrack_mode := hr_api.g_delete;
9727: l_datetrack_mode := hr_api.g_zap;
9728: END IF;
9729: --
9730: if p_source = 'beninelg' then
9731: l_datetrack_mode := hr_api.g_delete;
9732: elsif p_source is null or --CFW
9733: p_source = 'benuneai' then
9734: l_datetrack_mode := p_datetrack_mode;
9735: end if;
10290: -- delete child ben_prtt_prem_by_mo_f records
10291: --
10292: for l_prm in c_prm loop
10293: --
10294: if (l_datetrack_mode = hr_api.g_delete and
10295: l_prm.effective_end_date > l_eff_dt) or
10296: l_datetrack_mode <> hr_api.g_delete then
10297: --
10298: ben_prtt_prem_by_mo_api.delete_prtt_prem_by_mo
10292: for l_prm in c_prm loop
10293: --
10294: if (l_datetrack_mode = hr_api.g_delete and
10295: l_prm.effective_end_date > l_eff_dt) or
10296: l_datetrack_mode <> hr_api.g_delete then
10297: --
10298: ben_prtt_prem_by_mo_api.delete_prtt_prem_by_mo
10299: (p_validate => false,
10300: p_prtt_prem_by_mo_id => l_prm.prtt_prem_by_mo_id,
10309: --
10310: end loop;
10311: ******************** END CODE PRIOR TO WWBUG: 1646442 ************/
10312: --
10313: if (l_datetrack_mode = hr_api.g_delete and
10314: l_ppe.effective_end_date > l_eff_dt) or
10315: l_datetrack_mode <> hr_api.g_delete then
10316: --
10317: /* Start of Changes for WWBUG: 1646442: added */
10311: ******************** END CODE PRIOR TO WWBUG: 1646442 ************/
10312: --
10313: if (l_datetrack_mode = hr_api.g_delete and
10314: l_ppe.effective_end_date > l_eff_dt) or
10315: l_datetrack_mode <> hr_api.g_delete then
10316: --
10317: /* Start of Changes for WWBUG: 1646442: added */
10318: l_ppe_dt_to_use := least(l_enrt_cvg_end_dt,l_rt_end_dt);
10319: l_ppe_datetrack_mode := l_datetrack_mode;
10319: l_ppe_datetrack_mode := l_datetrack_mode;
10320: if l_ppe_dt_to_use < l_ppe.effective_start_date
10321: then
10322: l_ppe_dt_to_use := l_ppe.effective_start_date;
10323: l_ppe_datetrack_mode := hr_api.g_zap;
10324: end if;
10325: /* End of Changes for WWBUG: 1646442 */
10326: /***************** BEGIN CODE PRIOR TO WWBUG: 1646442 **********
10327: ben_prtt_prem_api.delete_prtt_prem
10366: --changing to option 2 ] we don't want to keep the pen id on the enb record.
10367: --When we are zaping the records for the call from election information we
10368: --we want to remove the penid from enb also.
10369: --
10370: if p_source = 'benelinf' and l_datetrack_mode = hr_api.g_zap then
10371: --
10372: ben_election_information.manage_enrt_bnft
10373: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
10374: ,p_business_group_id => p_business_group_id
10398: -- Bug 1132739
10399: -- Bug 2386000 If the result got update as part of on of the above calls,
10400: -- we need to get the latest object_version_number
10401: --
10402: if (l_datetrack_mode = hr_api.g_delete and
10403: l_pen.effective_end_date > l_eff_dt) or
10404: l_datetrack_mode <> hr_api.g_delete then
10405: --
10406: -- 4663971
10400: -- we need to get the latest object_version_number
10401: --
10402: if (l_datetrack_mode = hr_api.g_delete and
10403: l_pen.effective_end_date > l_eff_dt) or
10404: l_datetrack_mode <> hr_api.g_delete then
10405: --
10406: -- 4663971
10407: open c_pen_ovn( p_prtt_enrt_rslt_id,l_eff_dt ) ;
10408: fetch c_pen_ovn into l_pen_ovn.object_version_number,l_pen_ovn.effective_start_date ;
10411: -- BUG 4663971 we should never call delete process with other than zap mode
10412: -- if the datetrack mode is other than zap we need to call
10413: -- update_prtt_enrt_result procedure
10414: --
10415: if p_source = 'benuneai' or l_datetrack_mode <> hr_api.g_zap then
10416: hr_utility.set_location('called from benuneai',99);
10417: --
10418: -- 4663971
10419: if l_pen_ovn.effective_start_date = l_eff_dt
10417: --
10418: -- 4663971
10419: if l_pen_ovn.effective_start_date = l_eff_dt
10420: or l_datetrack_mode='CORRECTION' then
10421: l_datetrack_mode := hr_api.g_correction ;
10422: l_temp_date:=l_enrt_cvg_end_dt;
10423: --Bug#:6641853
10424: else
10425: l_datetrack_mode := hr_api.g_update ;
10421: l_datetrack_mode := hr_api.g_correction ;
10422: l_temp_date:=l_enrt_cvg_end_dt;
10423: --Bug#:6641853
10424: else
10425: l_datetrack_mode := hr_api.g_update ;
10426: l_temp_date:=l_pen.enrt_cvg_strt_dt-1;
10427: end if;
10428: --
10429: ben_prtt_enrt_result_api.update_prtt_enrt_result
10452: hr_utility.set_location('stee l_prtt_enrt_rslt_Stat_cd '||l_prtt_enrt_rslt_Stat_cd,60);
10453: if l_pen.sspndd_flag = 'N' and
10454: (p_source is null or
10455: p_source = 'benelinf') and
10456: l_datetrack_mode = hr_api.g_zap then
10457: --
10458: -- Check if enrollment was previously suspended in the current
10459: -- event
10460: --
10539: ,p_per_in_ler_id => l_corr_pil_id
10540: ,p_ler_id => l_pen.ler_id
10541: ,p_object_version_number => l_object_version_number
10542: ,p_effective_date => p_effective_date
10543: ,p_datetrack_mode => hr_api.g_correction
10544: ,p_multi_row_validate => FALSE
10545: ,p_business_group_id => p_business_group_id
10546: );
10547: end if ;
10624: if l_pen.sspndd_flag = 'N' and
10625: (p_source is null or
10626: p_source = 'benelinf') and
10627: (l_prtt_enrt_rslt_stat_cd = 'VOIDD'
10628: and l_datetrack_mode = hr_api.g_update) then
10629: --
10630: -- Check if enrollment was previously suspended in the current
10631: -- event
10632: --
10676: --
10677: -- When in validation only mode raise the Validate_Enabled exception
10678: --
10679: if p_validate then
10680: raise hr_api.validate_enabled;
10681: end if;
10682: --
10683: if g_debug then
10684: hr_utility.set_location(' Leaving:'||l_proc, 70);
10685: end if;
10686: --
10687: Exception
10688: --
10689: when hr_api.validate_enabled
10690: then
10691: --
10692: -- As the Validate_Enabled exception has been raised
10693: -- we must rollback to the savepoint
10819: --
10820: if l_last=-1 or l_last<>orec.pl_bnf_id then
10821: l_last:=orec.pl_bnf_id;
10822: l_effective_date:=p_effective_date;
10823: if (p_effective_date
10825: l_datetrack_mode := hr_api.g_zap;
10826: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
10827: l_datetrack_mode := hr_api.g_correction;
10821: l_last:=orec.pl_bnf_id;
10822: l_effective_date:=p_effective_date;
10823: if (p_effective_date
10825: l_datetrack_mode := hr_api.g_zap;
10826: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
10827: l_datetrack_mode := hr_api.g_correction;
10828: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10829: l_datetrack_mode := hr_api.g_correction;
10822: l_effective_date:=p_effective_date;
10823: if (p_effective_date
10825: l_datetrack_mode := hr_api.g_zap;
10826: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
10827: l_datetrack_mode := hr_api.g_correction;
10828: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10829: l_datetrack_mode := hr_api.g_correction;
10830: Else
10823: if (p_effective_date
10825: l_datetrack_mode := hr_api.g_zap;
10826: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
10827: l_datetrack_mode := hr_api.g_correction;
10828: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10829: l_datetrack_mode := hr_api.g_correction;
10830: Else
10831: l_datetrack_mode := hr_api.g_update;
10824: l_effective_date:=orec.effective_start_date;
10825: l_datetrack_mode := hr_api.g_zap;
10826: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
10827: l_datetrack_mode := hr_api.g_correction;
10828: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10829: l_datetrack_mode := hr_api.g_correction;
10830: Else
10831: l_datetrack_mode := hr_api.g_update;
10832: End if;
10825: l_datetrack_mode := hr_api.g_zap;
10826: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
10827: l_datetrack_mode := hr_api.g_correction;
10828: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10829: l_datetrack_mode := hr_api.g_correction;
10830: Else
10831: l_datetrack_mode := hr_api.g_update;
10832: End if;
10833: --
10827: l_datetrack_mode := hr_api.g_correction;
10828: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10829: l_datetrack_mode := hr_api.g_correction;
10830: Else
10831: l_datetrack_mode := hr_api.g_update;
10832: End if;
10833: --
10834: --
10835: If (p_effective_date between nvl(orec.dsgn_strt_dt, p_effective_date+1)
10832: End if;
10833: --
10834: --
10835: If (p_effective_date between nvl(orec.dsgn_strt_dt, p_effective_date+1)
10836: and nvl(orec.dsgn_thru_dt, hr_api.g_eot)
10837: and not p_rslt_delete_flag
10838: and l_datetrack_mode<>hr_api.g_zap
10839: ) then
10840: --
10834: --
10835: If (p_effective_date between nvl(orec.dsgn_strt_dt, p_effective_date+1)
10836: and nvl(orec.dsgn_thru_dt, hr_api.g_eot)
10837: and not p_rslt_delete_flag
10838: and l_datetrack_mode<>hr_api.g_zap
10839: ) then
10840: --
10841: -- If Coverage started, then end the coverage by set the coverage
10842: -- thru date.
10853: p_update_change_insert => l_update_change_insert);
10854: --
10855: if l_update_override then
10856: --
10857: l_datetrack_mode := hr_api.g_update_override;
10858: --
10859: elsif l_update then
10860: --
10861: l_datetrack_mode := hr_api.g_update;
10857: l_datetrack_mode := hr_api.g_update_override;
10858: --
10859: elsif l_update then
10860: --
10861: l_datetrack_mode := hr_api.g_update;
10862: --
10863: else
10864: --
10865: l_datetrack_mode := hr_api.g_correction;
10861: l_datetrack_mode := hr_api.g_update;
10862: --
10863: else
10864: --
10865: l_datetrack_mode := hr_api.g_correction;
10866: --
10867: end if;
10868: if g_debug then
10869: hr_utility.set_location('dt_mode='||l_datetrack_mode,11);
10909: -- to NULL and coverage flag to 'N'
10910: --
10911: l_step := 40;
10912: --
10913: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
10914: l_datetrack_mode := hr_api.g_zap;
10915: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10916: l_datetrack_mode := hr_api.g_zap;
10917: Else
10910: --
10911: l_step := 40;
10912: --
10913: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
10914: l_datetrack_mode := hr_api.g_zap;
10915: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10916: l_datetrack_mode := hr_api.g_zap;
10917: Else
10918: l_datetrack_mode := hr_api.g_delete;
10911: l_step := 40;
10912: --
10913: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
10914: l_datetrack_mode := hr_api.g_zap;
10915: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10916: l_datetrack_mode := hr_api.g_zap;
10917: Else
10918: l_datetrack_mode := hr_api.g_delete;
10919:
10912: --
10913: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
10914: l_datetrack_mode := hr_api.g_zap;
10915: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10916: l_datetrack_mode := hr_api.g_zap;
10917: Else
10918: l_datetrack_mode := hr_api.g_delete;
10919:
10920: End if;
10914: l_datetrack_mode := hr_api.g_zap;
10915: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
10916: l_datetrack_mode := hr_api.g_zap;
10917: Else
10918: l_datetrack_mode := hr_api.g_delete;
10919:
10920: End if;
10921: --
10922: -- Start of fix for INTERNAL bug 4924
10920: End if;
10921: --
10922: -- Start of fix for INTERNAL bug 4924
10923: --
10924: if l_datetrack_mode = hr_api.g_delete and
10925: p_effective_date = orec.effective_end_date then
10926: --
10927: -- Already end dated
10928: --
10994: from ben_elig_cvrd_dpnt_f ecd,
10995: ben_per_in_ler pil
10996: where ecd.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
10997: and ecd.cvg_strt_dt is not null
10998: -- and ecd.cvg_thru_dt = hr_api.g_eot
10999: and ecd.business_group_id=p_business_group_id
11000: -- and p_effective_date between
11001: -- ecd.effective_start_date and ecd.effective_end_date
11002: and p_effective_date <= ecd.effective_end_date
11047: from ben_prmry_care_prvdr_f pcp
11048: where pcp.business_group_id = p_business_group_id
11049: and pcp.elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
11050: and p_effective_date < pcp.effective_start_date
11051: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot
11052: ;
11053: -- 3574168
11054:
11055: l_proc varchar2(72); -- := g_package||'unhook_dpnt';
11093: if l_last=-1 or
11094: l_last<>orec.elig_cvrd_dpnt_id then
11095: l_last:=orec.elig_cvrd_dpnt_id;
11096: l_effective_date:=p_effective_date;
11097: if (p_effective_date
11099: l_datetrack_mode := hr_api.g_zap;
11100: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
11101: l_datetrack_mode := hr_api.g_correction;
11095: l_last:=orec.elig_cvrd_dpnt_id;
11096: l_effective_date:=p_effective_date;
11097: if (p_effective_date
11099: l_datetrack_mode := hr_api.g_zap;
11100: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
11101: l_datetrack_mode := hr_api.g_correction;
11102: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11103: l_datetrack_mode := hr_api.g_correction;
11096: l_effective_date:=p_effective_date;
11097: if (p_effective_date
11099: l_datetrack_mode := hr_api.g_zap;
11100: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
11101: l_datetrack_mode := hr_api.g_correction;
11102: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11103: l_datetrack_mode := hr_api.g_correction;
11104: Else
11097: if (p_effective_date
11099: l_datetrack_mode := hr_api.g_zap;
11100: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
11101: l_datetrack_mode := hr_api.g_correction;
11102: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11103: l_datetrack_mode := hr_api.g_correction;
11104: Else
11105: l_datetrack_mode := hr_api.g_update;
11098: l_effective_date:=orec.effective_start_date;
11099: l_datetrack_mode := hr_api.g_zap;
11100: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
11101: l_datetrack_mode := hr_api.g_correction;
11102: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11103: l_datetrack_mode := hr_api.g_correction;
11104: Else
11105: l_datetrack_mode := hr_api.g_update;
11106: End if;
11099: l_datetrack_mode := hr_api.g_zap;
11100: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
11101: l_datetrack_mode := hr_api.g_correction;
11102: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11103: l_datetrack_mode := hr_api.g_correction;
11104: Else
11105: l_datetrack_mode := hr_api.g_update;
11106: End if;
11107: --
11101: l_datetrack_mode := hr_api.g_correction;
11102: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11103: l_datetrack_mode := hr_api.g_correction;
11104: Else
11105: l_datetrack_mode := hr_api.g_update;
11106: End if;
11107: --
11108: --Bug 9534364,modified the IF condition.
11109: If ( ((p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
11106: End if;
11107: --
11108: --Bug 9534364,modified the IF condition.
11109: If ( ((p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
11110: and nvl(orec.cvg_thru_dt, hr_api.g_eot) )
11111: or (nvl(orec.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
11112: and p_effective_date between nvl(orec.effective_start_date, p_effective_date+1)
11113: and nvl(orec.effective_end_date, hr_api.g_eot)))
11114: and orec.CVG_PNDG_FLAG = 'N'
11107: --
11108: --Bug 9534364,modified the IF condition.
11109: If ( ((p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
11110: and nvl(orec.cvg_thru_dt, hr_api.g_eot) )
11111: or (nvl(orec.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
11112: and p_effective_date between nvl(orec.effective_start_date, p_effective_date+1)
11113: and nvl(orec.effective_end_date, hr_api.g_eot)))
11114: and orec.CVG_PNDG_FLAG = 'N'
11115: and not p_rslt_delete_flag
11109: If ( ((p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
11110: and nvl(orec.cvg_thru_dt, hr_api.g_eot) )
11111: or (nvl(orec.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
11112: and p_effective_date between nvl(orec.effective_start_date, p_effective_date+1)
11113: and nvl(orec.effective_end_date, hr_api.g_eot)))
11114: and orec.CVG_PNDG_FLAG = 'N'
11115: and not p_rslt_delete_flag
11116: and l_datetrack_mode<>hr_api.g_zap
11117: ) then
11112: and p_effective_date between nvl(orec.effective_start_date, p_effective_date+1)
11113: and nvl(orec.effective_end_date, hr_api.g_eot)))
11114: and orec.CVG_PNDG_FLAG = 'N'
11115: and not p_rslt_delete_flag
11116: and l_datetrack_mode<>hr_api.g_zap
11117: ) then
11118: --
11119: -- If Coverage started, then end the coverage by set the coverage
11120: -- thru date.
11130: p_update_change_insert => l_update_change_insert);
11131: --
11132: if l_update_override then
11133: --
11134: l_datetrack_mode := hr_api.g_update_override;
11135: --
11136: elsif l_update then
11137: --
11138: l_datetrack_mode := hr_api.g_update;
11134: l_datetrack_mode := hr_api.g_update_override;
11135: --
11136: elsif l_update then
11137: --
11138: l_datetrack_mode := hr_api.g_update;
11139:
11140: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode )*/
11141: -- l_datetrack_mode := hr_api.g_correction;
11142: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode) */
11137: --
11138: l_datetrack_mode := hr_api.g_update;
11139:
11140: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode )*/
11141: -- l_datetrack_mode := hr_api.g_correction;
11142: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode) */
11143: --
11144: else
11145: --
11142: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode) */
11143: --
11144: else
11145: --
11146: l_datetrack_mode := hr_api.g_correction;
11147: --
11148:
11149: end if;
11150: if g_debug then
11193: -- to NULL and coverage flag to 'N'
11194: --
11195: l_step := 40;
11196: --
11197: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
11198: l_datetrack_mode := hr_api.g_zap;
11199: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11200: l_datetrack_mode := hr_api.g_zap;
11201: Else
11194: --
11195: l_step := 40;
11196: --
11197: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
11198: l_datetrack_mode := hr_api.g_zap;
11199: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11200: l_datetrack_mode := hr_api.g_zap;
11201: Else
11202: l_datetrack_mode := hr_api.g_delete;
11195: l_step := 40;
11196: --
11197: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
11198: l_datetrack_mode := hr_api.g_zap;
11199: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11200: l_datetrack_mode := hr_api.g_zap;
11201: Else
11202: l_datetrack_mode := hr_api.g_delete;
11203: if g_debug then
11196: --
11197: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
11198: l_datetrack_mode := hr_api.g_zap;
11199: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11200: l_datetrack_mode := hr_api.g_zap;
11201: Else
11202: l_datetrack_mode := hr_api.g_delete;
11203: if g_debug then
11204: hr_utility.set_location('in dt_mode='||l_datetrack_mode,11);
11198: l_datetrack_mode := hr_api.g_zap;
11199: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
11200: l_datetrack_mode := hr_api.g_zap;
11201: Else
11202: l_datetrack_mode := hr_api.g_delete;
11203: if g_debug then
11204: hr_utility.set_location('in dt_mode='||l_datetrack_mode,11);
11205: end if;
11206: End if;
11209: --
11210: if g_debug then
11211: hr_utility.set_location('dt_mode='||l_datetrack_mode,11);
11212: end if;
11213: if l_datetrack_mode = hr_api.g_delete and
11214: p_effective_date = orec.effective_end_date then
11215: --
11216: -- Already end dated
11217: --
11254: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
11255: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
11256: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
11257: ,P_EFFECTIVE_DATE => l_pcp_effective_date
11258: ,P_DATETRACK_MODE => hr_api.g_zap
11259: ,p_called_from => 'delete_enrollment'
11260: );
11261: End loop;
11262: -- 3574168
11368: where prt.pgm_id = p_pgm_id
11369: and prt.person_id = p_person_id
11370: and prt.sspndd_flag = 'N' -- # 3626176
11371: and prt.prtt_enrt_rslt_stat_cd is null
11372: and prt.effective_end_date = hr_api.g_eot
11373: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11374: and p_effective_date between
11375: prt.effective_start_date and prt.effective_end_date
11376: and prt.business_group_id = p_business_group_id
11369: and prt.person_id = p_person_id
11370: and prt.sspndd_flag = 'N' -- # 3626176
11371: and prt.prtt_enrt_rslt_stat_cd is null
11372: and prt.effective_end_date = hr_api.g_eot
11373: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11374: and p_effective_date between
11375: prt.effective_start_date and prt.effective_end_date
11376: and prt.business_group_id = p_business_group_id
11377: and p_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
11401: and prt1.per_in_ler_id = prt.per_in_ler_id
11402: and prt1.sspndd_flag = 'Y'
11403: and p_lf_evt_ocrd_dt between
11404: prt1.effective_start_date and prt1.effective_end_date
11405: and prt1.effective_end_date = hr_api.g_eot
11406: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11407: and prt1.prtt_enrt_rslt_stat_cd is null)))
11408: and prt.prtt_enrt_rslt_stat_cd is null
11409: and prt.effective_end_date = hr_api.g_eot
11402: and prt1.sspndd_flag = 'Y'
11403: and p_lf_evt_ocrd_dt between
11404: prt1.effective_start_date and prt1.effective_end_date
11405: and prt1.effective_end_date = hr_api.g_eot
11406: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11407: and prt1.prtt_enrt_rslt_stat_cd is null)))
11408: and prt.prtt_enrt_rslt_stat_cd is null
11409: and prt.effective_end_date = hr_api.g_eot
11410: and prt.enrt_cvg_thru_dt = hr_api.g_eot
11405: and prt1.effective_end_date = hr_api.g_eot
11406: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11407: and prt1.prtt_enrt_rslt_stat_cd is null)))
11408: and prt.prtt_enrt_rslt_stat_cd is null
11409: and prt.effective_end_date = hr_api.g_eot
11410: and prt.enrt_cvg_thru_dt = hr_api.g_eot
11411: and p_effective_date between
11412: prt.effective_start_date and prt.effective_end_date
11413: and prt.business_group_id = p_business_group_id
11406: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11407: and prt1.prtt_enrt_rslt_stat_cd is null)))
11408: and prt.prtt_enrt_rslt_stat_cd is null
11409: and prt.effective_end_date = hr_api.g_eot
11410: and prt.enrt_cvg_thru_dt = hr_api.g_eot
11411: and p_effective_date between
11412: prt.effective_start_date and prt.effective_end_date
11413: and prt.business_group_id = p_business_group_id
11414: and p_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
11598: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11599: and r.per_in_ler_id <> c.per_in_ler_id
11600: and r.person_id = p_person_id
11601: and nvl(r.pgm_id,-1) = p_pgm_id
11602: and r.effective_end_date = hr_api.g_eot
11603: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11604: and r.prtt_enrt_rslt_stat_cd is null
11605: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11606: and c.elctbl_flag = 'Y'
11599: and r.per_in_ler_id <> c.per_in_ler_id
11600: and r.person_id = p_person_id
11601: and nvl(r.pgm_id,-1) = p_pgm_id
11602: and r.effective_end_date = hr_api.g_eot
11603: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11604: and r.prtt_enrt_rslt_stat_cd is null
11605: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11606: and c.elctbl_flag = 'Y'
11607: /* BUG 3939785
11609: r.ENRT_OVRID_THRU_DT < p_effective_date)
11610: */
11611: and ( r.enrt_ovridn_flag = 'N' /* Bug 3958064 */
11612: or
11613: ( r.enrt_ovridn_flag = 'Y' and nvl(r.ENRT_OVRID_THRU_DT,hr_api.g_eot) <= l_lf_evt_ocrd_dt ) -- 9114147
11614: )
11615: and oipl.oipl_id(+)=r.oipl_id
11616: and oipl.business_group_id(+)=r.business_group_id
11617: and p_effective_date between
11637: ben_oipl_f oipl
11638: Where r.per_in_ler_id <> p_per_in_ler_id
11639: and r.person_id = p_person_id
11640: and nvl(r.pgm_id,-1) = p_pgm_id
11641: and r.effective_end_date = hr_api.g_eot
11642: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11643: and r.prtt_enrt_rslt_stat_cd is null
11644: and r.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11645: /* BUG 3939785
11638: Where r.per_in_ler_id <> p_per_in_ler_id
11639: and r.person_id = p_person_id
11640: and nvl(r.pgm_id,-1) = p_pgm_id
11641: and r.effective_end_date = hr_api.g_eot
11642: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11643: and r.prtt_enrt_rslt_stat_cd is null
11644: and r.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11645: /* BUG 3939785
11646: and (r.ENRT_OVRID_THRU_DT is null or
11647: r.ENRT_OVRID_THRU_DT < p_effective_date)
11648: */
11649: and ( r.enrt_ovridn_flag = 'N' /* Bug 3958064 */
11650: or
11651: ( r.enrt_ovridn_flag = 'Y' and nvl(r.ENRT_OVRID_THRU_DT,hr_api.g_eot) <= l_lf_evt_ocrd_dt) -- 9114147
11652: )
11653: and oipl.oipl_id(+)=r.oipl_id
11654: and oipl.business_group_id(+)=r.business_group_id
11655: and p_effective_date between
11706: and pel.pgm_id is NULL
11707: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)
11708: and pel.pl_id = r.pl_id
11709: and c.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
11710: and r.effective_end_date = hr_api.g_eot
11711: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11712: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11713: and c.elctbl_flag = 'Y'
11714: /*
11707: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)
11708: and pel.pl_id = r.pl_id
11709: and c.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
11710: and r.effective_end_date = hr_api.g_eot
11711: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11712: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11713: and c.elctbl_flag = 'Y'
11714: /*
11715: and (r.ENRT_OVRID_THRU_DT is null or
11716: r.ENRT_OVRID_THRU_DT < p_effective_date)
11717: */
11718: and ( r.enrt_ovridn_flag = 'N' /* Bug 3958064 */
11719: or
11720: ( r.enrt_ovridn_flag = 'Y' and nvl(r.ENRT_OVRID_THRU_DT,hr_api.g_eot) <= l_lf_evt_ocrd_dt) -- 9114147
11721: )
11722: and oipl.oipl_id(+)=r.oipl_id
11723: and oipl.business_group_id(+)=r.business_group_id
11724: and p_effective_date between
11766: where pen.per_in_ler_id = p_per_in_ler_id
11767: and pen.pgm_id = p_pgm_id
11768: and pen.prtt_enrt_rslt_stat_cd is null
11769: and pen.no_lngr_elig_flag = 'Y'
11770: and pen.effective_end_date = hr_api.g_eot
11771: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11772: and pen.business_group_id = p_business_group_id;
11773: --
11774: -- For plan not in program (p_pgm_id is null)
11767: and pen.pgm_id = p_pgm_id
11768: and pen.prtt_enrt_rslt_stat_cd is null
11769: and pen.no_lngr_elig_flag = 'Y'
11770: and pen.effective_end_date = hr_api.g_eot
11771: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11772: and pen.business_group_id = p_business_group_id;
11773: --
11774: -- For plan not in program (p_pgm_id is null)
11775: --
11795: and pl_typ_id = l_pl_typ_id
11796: and pen.per_in_ler_id = p_per_in_ler_id
11797: and pen.prtt_enrt_rslt_stat_cd is null
11798: and pen.no_lngr_elig_flag = 'Y'
11799: and pen.effective_end_date = hr_api.g_eot
11800: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11801: and pen.business_group_id = p_business_group_id;
11802: --
11803: cursor c_acrs_ptip is
11796: and pen.per_in_ler_id = p_per_in_ler_id
11797: and pen.prtt_enrt_rslt_stat_cd is null
11798: and pen.no_lngr_elig_flag = 'Y'
11799: and pen.effective_end_date = hr_api.g_eot
11800: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11801: and pen.business_group_id = p_business_group_id;
11802: --
11803: cursor c_acrs_ptip is
11804: select acrs_ptip_cvg_id,
11836: where prt.pgm_id = p_pgm_id
11837: and prt.person_id = p_person_id
11838: and prt.sspndd_flag = 'N' -- # 3626176
11839: and prt.prtt_enrt_rslt_stat_cd is null
11840: and prt.effective_end_date = hr_api.g_eot
11841: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11842: and p_effective_date between
11843: prt.effective_start_date and prt.effective_end_date
11844: and prt.business_group_id = p_business_group_id
11837: and prt.person_id = p_person_id
11838: and prt.sspndd_flag = 'N' -- # 3626176
11839: and prt.prtt_enrt_rslt_stat_cd is null
11840: and prt.effective_end_date = hr_api.g_eot
11841: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
11842: and p_effective_date between
11843: prt.effective_start_date and prt.effective_end_date
11844: and prt.business_group_id = p_business_group_id
11845: and l_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
11869: and prt1.per_in_ler_id = prt.per_in_ler_id
11870: and prt1.sspndd_flag = 'Y'
11871: and l_lf_evt_ocrd_dt between
11872: prt1.effective_start_date and prt1.effective_end_date
11873: and prt1.effective_end_date = hr_api.g_eot
11874: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11875: and prt1.prtt_enrt_rslt_stat_cd is null)))
11876: and prt.prtt_enrt_rslt_stat_cd is null
11877: and prt.effective_end_date = hr_api.g_eot
11870: and prt1.sspndd_flag = 'Y'
11871: and l_lf_evt_ocrd_dt between
11872: prt1.effective_start_date and prt1.effective_end_date
11873: and prt1.effective_end_date = hr_api.g_eot
11874: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11875: and prt1.prtt_enrt_rslt_stat_cd is null)))
11876: and prt.prtt_enrt_rslt_stat_cd is null
11877: and prt.effective_end_date = hr_api.g_eot
11878: and prt.enrt_cvg_thru_dt = hr_api.g_eot
11873: and prt1.effective_end_date = hr_api.g_eot
11874: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11875: and prt1.prtt_enrt_rslt_stat_cd is null)))
11876: and prt.prtt_enrt_rslt_stat_cd is null
11877: and prt.effective_end_date = hr_api.g_eot
11878: and prt.enrt_cvg_thru_dt = hr_api.g_eot
11879: and p_effective_date between
11880: prt.effective_start_date and prt.effective_end_date
11881: and prt.business_group_id = p_business_group_id
11874: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
11875: and prt1.prtt_enrt_rslt_stat_cd is null)))
11876: and prt.prtt_enrt_rslt_stat_cd is null
11877: and prt.effective_end_date = hr_api.g_eot
11878: and prt.enrt_cvg_thru_dt = hr_api.g_eot
11879: and p_effective_date between
11880: prt.effective_start_date and prt.effective_end_date
11881: and prt.business_group_id = p_business_group_id
11882: and l_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
11909: Where r.pl_typ_id = p_pl_typ_id
11910: and r.per_in_ler_id = p_per_in_ler_id
11911: and r.pgm_id = p_pgm_id
11912: and r.person_id = p_person_id
11913: and r.effective_end_date = hr_api.g_eot
11914: and r.enrt_cvg_thru_dt = hr_api.g_eot
11915: and r.prtt_enrt_rslt_stat_cd is null
11916: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11917: and r.per_in_ler_id = c.per_in_ler_id
11910: and r.per_in_ler_id = p_per_in_ler_id
11911: and r.pgm_id = p_pgm_id
11912: and r.person_id = p_person_id
11913: and r.effective_end_date = hr_api.g_eot
11914: and r.enrt_cvg_thru_dt = hr_api.g_eot
11915: and r.prtt_enrt_rslt_stat_cd is null
11916: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11917: and r.per_in_ler_id = c.per_in_ler_id
11918: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
12101: ,p_dpnt_cvg_strt_dt_rl => l_needs_dpnts.dpnt_cvg_strt_dt_rl
12102: ,p_business_group_id => p_business_group_id
12103: ,p_ENRT_CVG_STRT_DT => l_needs_dpnts.enrt_cvg_strt_dt
12104: ,p_effective_date => p_effective_date
12105: ,p_datetrack_mode => hr_api.g_update -- note below
12106: ,p_process_dpnt => l_process_dpnt
12107: ,p_process_bnf => l_process_bnf);
12108: -- if the datetrack mode of update causes problems, then we'll need
12109: -- to pass the datetrack mode in from the form. Each enrollment
12130: ,p_effective_start_date => l_rec(i).effective_start_date
12131: ,p_effective_end_date => l_rec(i).effective_end_date
12132: ,p_object_version_number => l_rec(i).object_version_number
12133: ,p_effective_date => l_effective_date
12134: ,p_datetrack_mode => hr_api.g_delete
12135: ,p_multi_row_validate => FALSE
12136: ,p_source => 'bepenapi'
12137: );
12138: end if;
12170: ,p_effective_start_date => l_effective_start_date
12171: ,p_effective_end_date => l_effective_end_date
12172: ,p_object_version_number => rslt.object_version_number
12173: ,p_effective_date => l_effective_date
12174: ,p_datetrack_mode => hr_api.g_delete
12175: ,p_multi_row_validate => FALSE
12176: ,p_source => 'bepenapi'
12177: );
12178: --
12207: ,p_effective_start_date => l_effective_start_date
12208: ,p_effective_end_date => l_effective_end_date
12209: ,p_object_version_number => rslt.object_version_number
12210: ,p_effective_date => l_effective_date
12211: ,p_datetrack_mode => hr_api.g_delete
12212: ,p_multi_row_validate => FALSE
12213: ,p_source => 'bepenapi'
12214: );
12215: --