[Home] [Help]
831: close c_min_max_dt;
832:
833: if p_end_date < l_min_start_date then
834: l_effective_date := p_effective_date;
835: l_datetrack_mode := hr_api.g_zap;
836: elsif p_end_date < l_max_end_date then
837: l_effective_date := p_end_date;
838: l_datetrack_mode := hr_api.g_delete;
839: --
834: l_effective_date := p_effective_date;
835: l_datetrack_mode := hr_api.g_zap;
836: elsif p_end_date < l_max_end_date then
837: l_effective_date := p_end_date;
838: l_datetrack_mode := hr_api.g_delete;
839: --
840: --get the correct ovn
841: --
842: open c_pea_ovn(l_bnf_types.prtt_enrt_actn_id, p_end_date);
1115: -- Do not decrease the effective date, when called from 'benelinf',
1116: -- as the date is already modified in delete_enrollment in such cases.
1117: --
1118: if l_bnf_types.effective_start_date < p_effective_date and
1119: p_datetrack_mode = hr_api.g_delete and
1120: nvl(p_source,'benelinf') <> 'benelinf' then
1121: l_datetrack_mode := p_datetrack_mode;
1122: l_effective_date := p_effective_date -1;
1123: -- 4962138
1121: l_datetrack_mode := p_datetrack_mode;
1122: l_effective_date := p_effective_date -1;
1123: -- 4962138
1124: elsif l_bnf_types.effective_start_date <= p_effective_date and
1125: p_datetrack_mode = hr_api.g_delete and
1126: p_source is null then
1127: l_datetrack_mode := hr_api.g_zap;
1128: l_effective_date := p_effective_date;
1129: -- end 4962138
1123: -- 4962138
1124: elsif l_bnf_types.effective_start_date <= p_effective_date and
1125: p_datetrack_mode = hr_api.g_delete and
1126: p_source is null then
1127: l_datetrack_mode := hr_api.g_zap;
1128: l_effective_date := p_effective_date;
1129: -- end 4962138
1130: else
1131: l_datetrack_mode := p_datetrack_mode;
1135: -- Do not attempt dt delete if the row selected already has an effective
1136: -- end date equal to(or less than) the date you are trying to delete it on.
1137: -- Bug 1132739
1138: --
1139: if (p_datetrack_mode = hr_api.g_delete and
1140: l_bnf_types.effective_end_date > l_effective_date) or
1141: p_datetrack_mode <> hr_api.g_delete then
1142: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1143: (p_validate => FALSE
1137: -- Bug 1132739
1138: --
1139: if (p_datetrack_mode = hr_api.g_delete and
1140: l_bnf_types.effective_end_date > l_effective_date) or
1141: p_datetrack_mode <> hr_api.g_delete then
1142: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
1143: (p_validate => FALSE
1144: ,p_prtt_enrt_actn_id => l_bnf_types.prtt_enrt_actn_id
1145: ,p_effective_start_date => l_bnf_types.effective_start_date
1211: ,p_update_change_insert => l_dt_update_change_insert
1212: );
1213: --Bug 4431511 calling the find_dt_del_modes
1214: if(p_ler_typ_cd = 'SCHEDDU'
1215: and p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1216:
1217: ben_pen_shd.find_dt_del_modes
1218: (p_effective_date => p_effective_date
1219: ,p_base_key_value => p_base_key_value
1224: );
1225: END if;
1226:
1227: if(p_ler_typ_cd = 'SCHEDDU'
1228: and p_desired_datetrack_mode = hr_api.g_delete) then
1229:
1230: ben_pen_shd.find_dt_del_modes
1231: (p_effective_date => p_effective_date
1232: ,p_base_key_value => p_base_key_value
1277: end if;
1278: end if;
1279:
1280: --
1281: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1282: p_datetrack_allow := hr_api.g_update;
1283: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1284: p_datetrack_allow := hr_api.g_correction;
1285: elsif (l_dt_update) then
1278: end if;
1279:
1280: --
1281: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1282: p_datetrack_allow := hr_api.g_update;
1283: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1284: p_datetrack_allow := hr_api.g_correction;
1285: elsif (l_dt_update) then
1286: p_datetrack_allow := hr_api.g_update;
1279:
1280: --
1281: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1282: p_datetrack_allow := hr_api.g_update;
1283: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1284: p_datetrack_allow := hr_api.g_correction;
1285: elsif (l_dt_update) then
1286: p_datetrack_allow := hr_api.g_update;
1287: --Bug 2739965 In case of unrestricted we need to take the
1280: --
1281: if (p_desired_datetrack_mode = hr_api.g_update and l_dt_update) then
1282: p_datetrack_allow := hr_api.g_update;
1283: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1284: p_datetrack_allow := hr_api.g_correction;
1285: elsif (l_dt_update) then
1286: p_datetrack_allow := hr_api.g_update;
1287: --Bug 2739965 In case of unrestricted we need to take the
1288: -- l_dt_update_override case also.
1282: p_datetrack_allow := hr_api.g_update;
1283: elsif (p_desired_datetrack_mode = hr_api.g_correction and l_dt_correction) then
1284: p_datetrack_allow := hr_api.g_correction;
1285: elsif (l_dt_update) then
1286: p_datetrack_allow := hr_api.g_update;
1287: --Bug 2739965 In case of unrestricted we need to take the
1288: -- l_dt_update_override case also.
1289: elsif (l_dt_update_override and -- p_ler_typ_cd = 'SCHEDDU' and --Bug 5102337 this applied to LE mode also
1290: p_desired_datetrack_mode = hr_api.g_update) then
1286: p_datetrack_allow := hr_api.g_update;
1287: --Bug 2739965 In case of unrestricted we need to take the
1288: -- l_dt_update_override case also.
1289: elsif (l_dt_update_override and -- p_ler_typ_cd = 'SCHEDDU' and --Bug 5102337 this applied to LE mode also
1290: p_desired_datetrack_mode = hr_api.g_update) then
1291: p_datetrack_allow := hr_api.g_update_override;
1292: --Bug 4431511 Added this check to ensure update_override is passed as
1293: --effective datetrack mode if the desired date track mode is
1294: --delete next change in case of unrestricted enrollments
1287: --Bug 2739965 In case of unrestricted we need to take the
1288: -- l_dt_update_override case also.
1289: elsif (l_dt_update_override and -- p_ler_typ_cd = 'SCHEDDU' and --Bug 5102337 this applied to LE mode also
1290: p_desired_datetrack_mode = hr_api.g_update) then
1291: p_datetrack_allow := hr_api.g_update_override;
1292: --Bug 4431511 Added this check to ensure update_override is passed as
1293: --effective datetrack mode if the desired date track mode is
1294: --delete next change in case of unrestricted enrollments
1295: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1292: --Bug 4431511 Added this check to ensure update_override is passed as
1293: --effective datetrack mode if the desired date track mode is
1294: --delete next change in case of unrestricted enrollments
1295: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1296: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1297: p_datetrack_allow := hr_api.g_update_override;
1298: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1299: p_desired_datetrack_mode = hr_api.g_delete) then
1300: p_datetrack_allow := hr_api.g_update_override;
1293: --effective datetrack mode if the desired date track mode is
1294: --delete next change in case of unrestricted enrollments
1295: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1296: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1297: p_datetrack_allow := hr_api.g_update_override;
1298: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1299: p_desired_datetrack_mode = hr_api.g_delete) then
1300: p_datetrack_allow := hr_api.g_update_override;
1301: --End Bug 4431511
1295: elsif (l_dt_delete_next_change and p_ler_typ_cd = 'SCHEDDU' and
1296: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1297: p_datetrack_allow := hr_api.g_update_override;
1298: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1299: p_desired_datetrack_mode = hr_api.g_delete) then
1300: p_datetrack_allow := hr_api.g_update_override;
1301: --End Bug 4431511
1302: elsif (l_dt_correction) then
1303: p_datetrack_allow := hr_api.g_correction;
1296: p_desired_datetrack_mode = hr_api.g_delete_next_change) then
1297: p_datetrack_allow := hr_api.g_update_override;
1298: elsif (l_dt_delete and p_ler_typ_cd = 'SCHEDDU' and
1299: p_desired_datetrack_mode = hr_api.g_delete) then
1300: p_datetrack_allow := hr_api.g_update_override;
1301: --End Bug 4431511
1302: elsif (l_dt_correction) then
1303: p_datetrack_allow := hr_api.g_correction;
1304: else
1299: p_desired_datetrack_mode = hr_api.g_delete) then
1300: p_datetrack_allow := hr_api.g_update_override;
1301: --End Bug 4431511
1302: elsif (l_dt_correction) then
1303: p_datetrack_allow := hr_api.g_correction;
1304: else
1305: rpt_error(p_proc => l_proc, p_step => l_step);
1306: fnd_message.set_name('BEN', 'BEN_91700_DATETRACK_NOT_ALWD');
1307: fnd_message.set_token('MODE',p_desired_datetrack_mode);
1410: ,p_enrt_ovridn_flag in varchar2 default 'N'
1411: ,p_enrt_ovrid_rsn_cd in varchar2 default null
1412: ,p_erlst_deenrt_dt in date default null
1413: ,p_enrt_cvg_strt_dt in date default null
1414: ,p_enrt_cvg_thru_dt in date default hr_api.g_eot
1415: ,p_enrt_ovrid_thru_dt in date default null
1416: ,p_pl_ordr_num in number default null
1417: ,p_plip_ordr_num in number default null
1418: ,p_ptip_ordr_num in number default null
1530: pen.business_group_id =p_business_group_id and
1531: pen.prtt_enrt_rslt_stat_cd is null and
1532: pen.sspndd_flag='N' and
1533: pen.prtt_enrt_rslt_id <> l_prtt_enrt_rslt_id and
1534: pen.effective_end_date = hr_api.g_eot and
1535: p_enrt_cvg_strt_dt-1 <=
1536: pen.enrt_cvg_thru_dt and
1537: pen.enrt_cvg_strt_dt < pen.effective_end_date and
1538: p_ptip_id=pen.ptip_id;
1628: between pdp.effective_start_date and pdp.effective_end_date
1629: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1630: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
1631: and pen.prtt_enrt_rslt_stat_cd is null
1632: and pdp.cvg_thru_dt = hr_api.g_eot
1633: and pen.pgm_id = p_pgm_id
1634: and pen.pgm_id = pgm.pgm_id
1635: and pen.prtt_enrt_rslt_stat_cd is null
1636: and pgm.pgm_typ_cd like 'COBRA%'
1684: End if;
1685: --
1686: -- Ensure elctbl_chc_id is not NULL.
1687: --
1688: hr_api.mandatory_arg_error
1689: (p_api_name => l_proc
1690: ,p_argument => 'elig_per_elctbl_chc_id'
1691: ,p_argument_value => p_elig_per_elctbl_chc_id
1692: );
1780: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1781: fnd_message.raise_error;
1782: else
1783: close c_pen;
1784: if (p_datetrack_mode = hr_api.g_correction) then
1785: l_effective_date := l_pen_o.effective_start_date;
1786: else
1787: l_effective_date := p_effective_date;
1788: end if;
2006: p_update_change_insert => lb_update_change_insert);
2007:
2008: if lb_update_override then
2009: --
2010: l_ppe_datetrack_mode := hr_api.g_update_override;
2011: --
2012: elsif lb_update then
2013: --
2014: l_ppe_datetrack_mode := hr_api.g_update;
2010: l_ppe_datetrack_mode := hr_api.g_update_override;
2011: --
2012: elsif lb_update then
2013: --
2014: l_ppe_datetrack_mode := hr_api.g_update;
2015: --
2016: else
2017: --
2018: l_ppe_datetrack_mode := hr_api.g_correction;
2014: l_ppe_datetrack_mode := hr_api.g_update;
2015: --
2016: else
2017: --
2018: l_ppe_datetrack_mode := hr_api.g_correction;
2019: end if;
2020: /* End of Changes for WWBUG: 1646442 */
2021:
2022: ben_prtt_prem_api.update_prtt_prem
2338: --
2339: -- When in validation only mode raise the Validate_Enabled exception
2340: --
2341: if p_validate then
2342: raise hr_api.validate_enabled;
2343: end if;
2344: --
2345: -- Set all output arguments
2346: --
2351: if g_debug then
2352: hr_utility.set_location(' Leaving:'||l_proc, 999);
2353: end if;
2354: exception
2355: when hr_api.validate_enabled then
2356: -- As the Validate_Enabled exception has been raised
2357: -- we must rollback to the savepoint
2358: --
2359: if p_called_from_sspnd = 'N' then
2421: ,p_enrt_ovridn_flag in varchar2 default 'N'
2422: ,p_enrt_ovrid_rsn_cd in varchar2 default null
2423: ,p_erlst_deenrt_dt in date default null
2424: ,p_enrt_cvg_strt_dt in date default null
2425: ,p_enrt_cvg_thru_dt in date default hr_api.g_eot
2426: ,p_enrt_ovrid_thru_dt in date default null
2427: ,p_pl_ordr_num in number default null
2428: ,p_plip_ordr_num in number default null
2429: ,p_ptip_ordr_num in number default null
2587: ,p_comp_lvl_cd => p_comp_lvl_cd
2588: ,p_effective_date => trunc(p_effective_date)
2589: );
2590: exception
2591: when hr_api.cannot_find_prog_unit then
2592: hr_api.cannot_find_prog_unit_error
2593: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2594: ,p_hook_type => 'BP'
2595: );
2588: ,p_effective_date => trunc(p_effective_date)
2589: );
2590: exception
2591: when hr_api.cannot_find_prog_unit then
2592: hr_api.cannot_find_prog_unit_error
2593: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2594: ,p_hook_type => 'BP'
2595: );
2596: --
2751: ,p_comp_lvl_cd => p_comp_lvl_cd
2752: ,p_effective_date => trunc(p_effective_date)
2753: );
2754: exception
2755: when hr_api.cannot_find_prog_unit then
2756: hr_api.cannot_find_prog_unit_error
2757: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2758: ,p_hook_type => 'AP'
2759: );
2752: ,p_effective_date => trunc(p_effective_date)
2753: );
2754: exception
2755: when hr_api.cannot_find_prog_unit then
2756: hr_api.cannot_find_prog_unit_error
2757: (p_module_name => 'CREATE_PRTT_ENRT_RESULT'
2758: ,p_hook_type => 'AP'
2759: );
2760: end;
2764: --
2765: -- When in validation only mode raise the Validate_Enabled exception
2766: --
2767: if p_validate then
2768: raise hr_api.validate_enabled;
2769: end if;
2770: --
2771: -- Set all output arguments
2772: --
2777: if g_debug then
2778: hr_utility.set_location(' Leaving:'||l_proc, 70);
2779: end if;
2780: exception
2781: when hr_api.validate_enabled then
2782: --
2783: -- As the Validate_Enabled exception has been raised
2784: -- we must rollback to the savepoint
2785: --
2817: (p_validate in boolean default false
2818: ,p_prtt_enrt_rslt_id in number
2819: ,p_effective_start_date out nocopy date
2820: ,p_effective_end_date out nocopy date
2821: ,p_business_group_id in number default hr_api.g_number
2822: ,p_oipl_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2818: ,p_prtt_enrt_rslt_id in number
2819: ,p_effective_start_date out nocopy date
2820: ,p_effective_end_date out nocopy date
2821: ,p_business_group_id in number default hr_api.g_number
2822: ,p_oipl_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2819: ,p_effective_start_date out nocopy date
2820: ,p_effective_end_date out nocopy date
2821: ,p_business_group_id in number default hr_api.g_number
2822: ,p_oipl_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2820: ,p_effective_end_date out nocopy date
2821: ,p_business_group_id in number default hr_api.g_number
2822: ,p_oipl_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2821: ,p_business_group_id in number default hr_api.g_number
2822: ,p_oipl_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2822: ,p_oipl_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2823: ,p_person_id in number default hr_api.g_number
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2824: ,p_assignment_id in number default hr_api.g_number
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2825: ,p_pgm_id in number default hr_api.g_number
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2826: ,p_pl_id in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2827: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2828: ,p_ptip_id in number default hr_api.g_number
2829: ,p_pl_typ_id in number default hr_api.g_number
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2830: ,p_ler_id in number default hr_api.g_number
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2831: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2832: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2833: ,p_enrt_bnft_id in number default NULL
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2834: ,p_bnft_amt in number default hr_api.g_number
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2835: ,p_uom in varchar2 default hr_api.g_varchar2
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2836: ,p_orgnl_enrt_dt in date default hr_api.g_date
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2837: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2838: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2839: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2840: ,p_erlst_deenrt_dt in date default hr_api.g_date
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2841: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2842: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2843: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2844: ,p_pl_ordr_num in number default hr_api.g_number
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2845: ,p_plip_ordr_num in number default hr_api.g_number
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2846: ,p_ptip_ordr_num in number default hr_api.g_number
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2847: ,p_oipl_ordr_num in number default hr_api.g_number
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2848: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2849: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2850: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2851: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2852: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2853: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2854: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2855: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2856: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2857: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2858: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2859: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2860: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2861: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2862: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2863: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2864: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2865: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2866: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2867: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2868: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2869: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2870: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2871: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2872: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2873: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2874: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2875: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2876: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2877: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2878: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
2879: ,p_request_id in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2880: ,p_program_application_id in number default hr_api.g_number
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2887: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2888: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2881: ,p_program_id in number default hr_api.g_number
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2887: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2888: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2889: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2882: ,p_program_update_date in date default hr_api.g_date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2887: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2888: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2889: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2890: ,p_effective_date in date
2883: ,p_object_version_number in out nocopy number
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2887: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2888: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2889: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2890: ,p_effective_date in date
2891: ,p_datetrack_mode in varchar2
2884: ,p_per_in_ler_id in number default hr_api.g_number
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2887: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2888: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2889: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2890: ,p_effective_date in date
2891: ,p_datetrack_mode in varchar2
2892: ,p_multi_row_validate in boolean default TRUE
2885: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
2886: ,p_bnft_ordr_num in number default hr_api.g_number
2887: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
2888: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
2889: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2890: ,p_effective_date in date
2891: ,p_datetrack_mode in varchar2
2892: ,p_multi_row_validate in boolean default TRUE
2893: ,p_suspend_flag out nocopy varchar2
3187: ,p_inst_row => l_oipl_rec);
3188: end if;
3189: --
3190: l_step := 30;
3191: if (p_oipl_id <> hr_api.g_number and
3192: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3193: nvl(p_oipl_id,hr_api.g_number)) then
3194: l_chg := TRUE;
3195: end if;
3188: end if;
3189: --
3190: l_step := 30;
3191: if (p_oipl_id <> hr_api.g_number and
3192: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3193: nvl(p_oipl_id,hr_api.g_number)) then
3194: l_chg := TRUE;
3195: end if;
3196: if (p_assignment_id <> hr_api.g_number and
3189: --
3190: l_step := 30;
3191: if (p_oipl_id <> hr_api.g_number and
3192: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3193: nvl(p_oipl_id,hr_api.g_number)) then
3194: l_chg := TRUE;
3195: end if;
3196: if (p_assignment_id <> hr_api.g_number and
3197: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3192: nvl(l_global_pen_rec.oipl_id,hr_api.g_number) <>
3193: nvl(p_oipl_id,hr_api.g_number)) then
3194: l_chg := TRUE;
3195: end if;
3196: if (p_assignment_id <> hr_api.g_number and
3197: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3198: nvl(p_assignment_id,hr_api.g_number)) then
3199: l_chg := TRUE;
3200: end if;
3193: nvl(p_oipl_id,hr_api.g_number)) then
3194: l_chg := TRUE;
3195: end if;
3196: if (p_assignment_id <> hr_api.g_number and
3197: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3198: nvl(p_assignment_id,hr_api.g_number)) then
3199: l_chg := TRUE;
3200: end if;
3201: if (p_pgm_id <> hr_api.g_number and
3194: l_chg := TRUE;
3195: end if;
3196: if (p_assignment_id <> hr_api.g_number and
3197: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3198: nvl(p_assignment_id,hr_api.g_number)) then
3199: l_chg := TRUE;
3200: end if;
3201: if (p_pgm_id <> hr_api.g_number and
3202: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3197: nvl(l_global_pen_rec.assignment_id,hr_api.g_number) <>
3198: nvl(p_assignment_id,hr_api.g_number)) then
3199: l_chg := TRUE;
3200: end if;
3201: if (p_pgm_id <> hr_api.g_number and
3202: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3203: nvl(p_pgm_id,hr_api.g_number)) then
3204: l_chg := TRUE;
3205: end if;
3198: nvl(p_assignment_id,hr_api.g_number)) then
3199: l_chg := TRUE;
3200: end if;
3201: if (p_pgm_id <> hr_api.g_number and
3202: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3203: nvl(p_pgm_id,hr_api.g_number)) then
3204: l_chg := TRUE;
3205: end if;
3206: if (p_pl_id <> hr_api.g_number and
3199: l_chg := TRUE;
3200: end if;
3201: if (p_pgm_id <> hr_api.g_number and
3202: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3203: nvl(p_pgm_id,hr_api.g_number)) then
3204: l_chg := TRUE;
3205: end if;
3206: if (p_pl_id <> hr_api.g_number and
3207: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3202: nvl(l_global_pen_rec.pgm_id,hr_api.g_number) <>
3203: nvl(p_pgm_id,hr_api.g_number)) then
3204: l_chg := TRUE;
3205: end if;
3206: if (p_pl_id <> hr_api.g_number and
3207: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3208: nvl(p_pl_id, hr_api.g_number)) then
3209: l_chg := TRUE;
3210: end if;
3203: nvl(p_pgm_id,hr_api.g_number)) then
3204: l_chg := TRUE;
3205: end if;
3206: if (p_pl_id <> hr_api.g_number and
3207: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3208: nvl(p_pl_id, hr_api.g_number)) then
3209: l_chg := TRUE;
3210: end if;
3211: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3204: l_chg := TRUE;
3205: end if;
3206: if (p_pl_id <> hr_api.g_number and
3207: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3208: nvl(p_pl_id, hr_api.g_number)) then
3209: l_chg := TRUE;
3210: end if;
3211: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3212: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3207: nvl(l_global_pen_rec.pl_id,hr_api.g_number) <>
3208: nvl(p_pl_id, hr_api.g_number)) then
3209: l_chg := TRUE;
3210: end if;
3211: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3212: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3213: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3214: l_chg := TRUE;
3215: end if;
3208: nvl(p_pl_id, hr_api.g_number)) then
3209: l_chg := TRUE;
3210: end if;
3211: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3212: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3213: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3214: l_chg := TRUE;
3215: end if;
3216: l_step := 35;
3209: l_chg := TRUE;
3210: end if;
3211: if (p_rplcs_sspndd_rslt_id <> hr_api.g_number and
3212: nvl(l_global_pen_rec.rplcs_sspndd_rslt_id,hr_api.g_number) <>
3213: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3214: l_chg := TRUE;
3215: end if;
3216: l_step := 35;
3217: if (p_ptip_id <> hr_api.g_number and
3213: nvl(p_rplcs_sspndd_rslt_id,hr_api.g_number) ) then
3214: l_chg := TRUE;
3215: end if;
3216: l_step := 35;
3217: if (p_ptip_id <> hr_api.g_number and
3218: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3219: nvl(p_ptip_id,hr_api.g_number)) then
3220: l_chg := TRUE;
3221: end if;
3214: l_chg := TRUE;
3215: end if;
3216: l_step := 35;
3217: if (p_ptip_id <> hr_api.g_number and
3218: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3219: nvl(p_ptip_id,hr_api.g_number)) then
3220: l_chg := TRUE;
3221: end if;
3222: if (p_pl_typ_id <> hr_api.g_number and
3215: end if;
3216: l_step := 35;
3217: if (p_ptip_id <> hr_api.g_number and
3218: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3219: nvl(p_ptip_id,hr_api.g_number)) then
3220: l_chg := TRUE;
3221: end if;
3222: if (p_pl_typ_id <> hr_api.g_number and
3223: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3218: nvl(l_global_pen_rec.ptip_id,hr_api.g_number) <>
3219: nvl(p_ptip_id,hr_api.g_number)) then
3220: l_chg := TRUE;
3221: end if;
3222: if (p_pl_typ_id <> hr_api.g_number and
3223: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3224: nvl(p_pl_typ_id,hr_api.g_number)) then
3225: l_chg := TRUE;
3226: end if;
3219: nvl(p_ptip_id,hr_api.g_number)) then
3220: l_chg := TRUE;
3221: end if;
3222: if (p_pl_typ_id <> hr_api.g_number and
3223: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3224: nvl(p_pl_typ_id,hr_api.g_number)) then
3225: l_chg := TRUE;
3226: end if;
3227: if (p_ler_id <> hr_api.g_number and
3220: l_chg := TRUE;
3221: end if;
3222: if (p_pl_typ_id <> hr_api.g_number and
3223: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3224: nvl(p_pl_typ_id,hr_api.g_number)) then
3225: l_chg := TRUE;
3226: end if;
3227: if (p_ler_id <> hr_api.g_number and
3228: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3223: nvl(l_global_pen_rec.pl_typ_id,hr_api.g_number) <>
3224: nvl(p_pl_typ_id,hr_api.g_number)) then
3225: l_chg := TRUE;
3226: end if;
3227: if (p_ler_id <> hr_api.g_number and
3228: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3229: nvl(p_ler_id,hr_api.g_number)) then
3230: l_chg := TRUE;
3231: end if;
3224: nvl(p_pl_typ_id,hr_api.g_number)) then
3225: l_chg := TRUE;
3226: end if;
3227: if (p_ler_id <> hr_api.g_number and
3228: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3229: nvl(p_ler_id,hr_api.g_number)) then
3230: l_chg := TRUE;
3231: end if;
3232: if (p_sspndd_flag <> hr_api.g_varchar2 and
3225: l_chg := TRUE;
3226: end if;
3227: if (p_ler_id <> hr_api.g_number and
3228: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3229: nvl(p_ler_id,hr_api.g_number)) then
3230: l_chg := TRUE;
3231: end if;
3232: if (p_sspndd_flag <> hr_api.g_varchar2 and
3233: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3228: nvl(l_global_pen_rec.ler_id,hr_api.g_number) <>
3229: nvl(p_ler_id,hr_api.g_number)) then
3230: l_chg := TRUE;
3231: end if;
3232: if (p_sspndd_flag <> hr_api.g_varchar2 and
3233: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3234: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3235: l_chg := TRUE;
3236: end if;
3229: nvl(p_ler_id,hr_api.g_number)) then
3230: l_chg := TRUE;
3231: end if;
3232: if (p_sspndd_flag <> hr_api.g_varchar2 and
3233: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3234: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3235: l_chg := TRUE;
3236: end if;
3237: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3230: l_chg := TRUE;
3231: end if;
3232: if (p_sspndd_flag <> hr_api.g_varchar2 and
3233: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3234: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3235: l_chg := TRUE;
3236: end if;
3237: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3238: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3233: nvl(l_global_pen_rec.sspndd_flag,hr_api.g_varchar2) <>
3234: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3235: l_chg := TRUE;
3236: end if;
3237: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3238: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3239: nvl(p_prtt_is_cvrd_flag,hr_api.g_varchar2)) then
3240: l_chg := TRUE;
3241: end if;
3234: nvl(p_sspndd_flag,hr_api.g_varchar2)) then
3235: l_chg := TRUE;
3236: end if;
3237: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3238: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3239: nvl(p_prtt_is_cvrd_flag,hr_api.g_varchar2)) then
3240: l_chg := TRUE;
3241: end if;
3242: --
3235: l_chg := TRUE;
3236: end if;
3237: if (p_prtt_is_cvrd_flag <> hr_api.g_varchar2 and
3238: nvl(l_global_pen_rec.prtt_is_cvrd_flag,hr_api.g_varchar2) <>
3239: nvl(p_prtt_is_cvrd_flag,hr_api.g_varchar2)) then
3240: l_chg := TRUE;
3241: end if;
3242: --
3243: -- Bug 4723828 : If benefit amount changes from non-zero value to NULL
3243: -- Bug 4723828 : If benefit amount changes from non-zero value to NULL
3244: -- we need to detect that nullify the coverage. So added
3245: -- nvl(p_bnft_amt, -9999)
3246: --
3247: if (nvl(p_bnft_amt, -9999) <> hr_api.g_number and
3248: nvl(l_global_pen_rec.bnft_amt,hr_api.g_number) <>
3249: nvl(p_bnft_amt,hr_api.g_number)) then
3250: l_chg := TRUE;
3251: end if;
3244: -- we need to detect that nullify the coverage. So added
3245: -- nvl(p_bnft_amt, -9999)
3246: --
3247: if (nvl(p_bnft_amt, -9999) <> hr_api.g_number and
3248: nvl(l_global_pen_rec.bnft_amt,hr_api.g_number) <>
3249: nvl(p_bnft_amt,hr_api.g_number)) then
3250: l_chg := TRUE;
3251: end if;
3252: l_step := 40;
3245: -- nvl(p_bnft_amt, -9999)
3246: --
3247: if (nvl(p_bnft_amt, -9999) <> hr_api.g_number and
3248: nvl(l_global_pen_rec.bnft_amt,hr_api.g_number) <>
3249: nvl(p_bnft_amt,hr_api.g_number)) then
3250: l_chg := TRUE;
3251: end if;
3252: l_step := 40;
3253: if (p_uom <> hr_api.g_varchar2 and
3249: nvl(p_bnft_amt,hr_api.g_number)) then
3250: l_chg := TRUE;
3251: end if;
3252: l_step := 40;
3253: if (p_uom <> hr_api.g_varchar2 and
3254: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3255: nvl(p_uom,hr_api.g_varchar2)) then
3256: l_chg := TRUE;
3257: end if;
3250: l_chg := TRUE;
3251: end if;
3252: l_step := 40;
3253: if (p_uom <> hr_api.g_varchar2 and
3254: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3255: nvl(p_uom,hr_api.g_varchar2)) then
3256: l_chg := TRUE;
3257: end if;
3258: if (p_orgnl_enrt_dt <> hr_api.g_date and
3251: end if;
3252: l_step := 40;
3253: if (p_uom <> hr_api.g_varchar2 and
3254: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3255: nvl(p_uom,hr_api.g_varchar2)) then
3256: l_chg := TRUE;
3257: end if;
3258: if (p_orgnl_enrt_dt <> hr_api.g_date and
3259: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3254: nvl(l_global_pen_rec.uom,hr_api.g_varchar2) <>
3255: nvl(p_uom,hr_api.g_varchar2)) then
3256: l_chg := TRUE;
3257: end if;
3258: if (p_orgnl_enrt_dt <> hr_api.g_date and
3259: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3260: nvl(p_orgnl_enrt_dt,hr_api.g_date)) then
3261: l_chg := TRUE;
3262: end if;
3255: nvl(p_uom,hr_api.g_varchar2)) then
3256: l_chg := TRUE;
3257: end if;
3258: if (p_orgnl_enrt_dt <> hr_api.g_date and
3259: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3260: nvl(p_orgnl_enrt_dt,hr_api.g_date)) then
3261: l_chg := TRUE;
3262: end if;
3263: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3256: l_chg := TRUE;
3257: end if;
3258: if (p_orgnl_enrt_dt <> hr_api.g_date and
3259: nvl(l_global_pen_rec.orgnl_enrt_dt,hr_api.g_date) <>
3260: nvl(p_orgnl_enrt_dt,hr_api.g_date)) then
3261: l_chg := TRUE;
3262: end if;
3263: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3264: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3261: l_chg := TRUE;
3262: end if;
3263: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3264: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3265: if (p_enrt_mthd_cd <> hr_api.g_varchar2 and
3266: nvl(l_global_pen_rec.enrt_mthd_cd,hr_api.g_varchar2) <>
3267: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3268: l_chg := TRUE;
3269: end if;
3262: end if;
3263: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3264: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3265: if (p_enrt_mthd_cd <> hr_api.g_varchar2 and
3266: nvl(l_global_pen_rec.enrt_mthd_cd,hr_api.g_varchar2) <>
3267: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3268: l_chg := TRUE;
3269: end if;
3270: end if;
3263: -- 5417132 by pass enrt_mthd_cd chk for Imputed/flex rows
3264: if p_comp_lvl_cd not in ('PLANFC','PLANIMP') then
3265: if (p_enrt_mthd_cd <> hr_api.g_varchar2 and
3266: nvl(l_global_pen_rec.enrt_mthd_cd,hr_api.g_varchar2) <>
3267: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3268: l_chg := TRUE;
3269: end if;
3270: end if;
3271: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3267: nvl(p_enrt_mthd_cd,hr_api.g_varchar2)) then
3268: l_chg := TRUE;
3269: end if;
3270: end if;
3271: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3272: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3273: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3274: l_chg := TRUE;
3275: end if;
3268: l_chg := TRUE;
3269: end if;
3270: end if;
3271: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3272: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3273: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3274: l_chg := TRUE;
3275: end if;
3276: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3269: end if;
3270: end if;
3271: if (p_enrt_ovridn_flag <> hr_api.g_varchar2 and
3272: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3273: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3274: l_chg := TRUE;
3275: end if;
3276: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3277: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3272: nvl(l_global_pen_rec.enrt_ovridn_flag,hr_api.g_varchar2) <>
3273: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3274: l_chg := TRUE;
3275: end if;
3276: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3277: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3278: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3279: l_chg := TRUE;
3280: end if;
3273: nvl(p_enrt_ovridn_flag,hr_api.g_varchar2)) then
3274: l_chg := TRUE;
3275: end if;
3276: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3277: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3278: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3279: l_chg := TRUE;
3280: end if;
3281: if (p_erlst_deenrt_dt <> hr_api.g_date and
3274: l_chg := TRUE;
3275: end if;
3276: if (p_enrt_ovrid_rsn_cd <> hr_api.g_varchar2 and
3277: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3278: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3279: l_chg := TRUE;
3280: end if;
3281: if (p_erlst_deenrt_dt <> hr_api.g_date and
3282: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3277: nvl(l_global_pen_rec.enrt_ovrid_rsn_cd,hr_api.g_varchar2) <>
3278: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3279: l_chg := TRUE;
3280: end if;
3281: if (p_erlst_deenrt_dt <> hr_api.g_date and
3282: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3283: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3284: l_chg := TRUE;
3285: end if;
3278: nvl(p_enrt_ovrid_rsn_cd,hr_api.g_varchar2)) then
3279: l_chg := TRUE;
3280: end if;
3281: if (p_erlst_deenrt_dt <> hr_api.g_date and
3282: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3283: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3284: l_chg := TRUE;
3285: end if;
3286: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3279: l_chg := TRUE;
3280: end if;
3281: if (p_erlst_deenrt_dt <> hr_api.g_date and
3282: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3283: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3284: l_chg := TRUE;
3285: end if;
3286: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3287: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3282: nvl(l_global_pen_rec.erlst_deenrt_dt,hr_api.g_date) <>
3283: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3284: l_chg := TRUE;
3285: end if;
3286: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3287: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3288: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3289: l_chg := TRUE;
3290: end if;
3283: nvl(p_erlst_deenrt_dt,hr_api.g_date)) then
3284: l_chg := TRUE;
3285: end if;
3286: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3287: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3288: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3289: l_chg := TRUE;
3290: end if;
3291: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3284: l_chg := TRUE;
3285: end if;
3286: if (p_enrt_cvg_strt_dt <> hr_api.g_date and
3287: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3288: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3289: l_chg := TRUE;
3290: end if;
3291: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3292: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3287: nvl(l_global_pen_rec.enrt_cvg_strt_dt,hr_api.g_date) <>
3288: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3289: l_chg := TRUE;
3290: end if;
3291: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3292: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3293: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3294: l_chg := TRUE;
3295: end if;
3288: nvl(p_enrt_cvg_strt_dt,hr_api.g_date)) then
3289: l_chg := TRUE;
3290: end if;
3291: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3292: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3293: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3294: l_chg := TRUE;
3295: end if;
3296: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3289: l_chg := TRUE;
3290: end if;
3291: if (p_enrt_cvg_thru_dt <> hr_api.g_date and
3292: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3293: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3294: l_chg := TRUE;
3295: end if;
3296: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3297: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3292: nvl(l_global_pen_rec.enrt_cvg_thru_dt,hr_api.g_date) <>
3293: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3294: l_chg := TRUE;
3295: end if;
3296: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3297: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3298: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3299: l_chg := TRUE;
3300: end if;
3293: nvl(p_enrt_cvg_thru_dt,hr_api.g_date)) then
3294: l_chg := TRUE;
3295: end if;
3296: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3297: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3298: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3299: l_chg := TRUE;
3300: end if;
3301: l_step := 50;
3294: l_chg := TRUE;
3295: end if;
3296: if (p_enrt_ovrid_thru_dt <> hr_api.g_date and
3297: nvl(l_global_pen_rec.enrt_ovrid_thru_dt,hr_api.g_date) <>
3298: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3299: l_chg := TRUE;
3300: end if;
3301: l_step := 50;
3302: if (p_per_in_ler_id <> hr_api.g_number and
3298: nvl(p_enrt_ovrid_thru_dt,hr_api.g_date)) then
3299: l_chg := TRUE;
3300: end if;
3301: l_step := 50;
3302: if (p_per_in_ler_id <> hr_api.g_number and
3303: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3304: nvl(p_per_in_ler_id,hr_api.g_number)) then
3305: l_chg := TRUE;
3306: end if;
3299: l_chg := TRUE;
3300: end if;
3301: l_step := 50;
3302: if (p_per_in_ler_id <> hr_api.g_number and
3303: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3304: nvl(p_per_in_ler_id,hr_api.g_number)) then
3305: l_chg := TRUE;
3306: end if;
3307: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3300: end if;
3301: l_step := 50;
3302: if (p_per_in_ler_id <> hr_api.g_number and
3303: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3304: nvl(p_per_in_ler_id,hr_api.g_number)) then
3305: l_chg := TRUE;
3306: end if;
3307: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3308: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3303: nvl(l_global_pen_rec.per_in_ler_id,hr_api.g_number) <>
3304: nvl(p_per_in_ler_id,hr_api.g_number)) then
3305: l_chg := TRUE;
3306: end if;
3307: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3308: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3309: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3310: l_chg := TRUE;
3311: end if;
3304: nvl(p_per_in_ler_id,hr_api.g_number)) then
3305: l_chg := TRUE;
3306: end if;
3307: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3308: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3309: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3310: l_chg := TRUE;
3311: end if;
3312: if (p_bnft_ordr_num <> hr_api.g_number and
3305: l_chg := TRUE;
3306: end if;
3307: if (p_bnft_typ_cd <> hr_api.g_varchar2 and
3308: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3309: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3310: l_chg := TRUE;
3311: end if;
3312: if (p_bnft_ordr_num <> hr_api.g_number and
3313: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3308: nvl(l_global_pen_rec.bnft_typ_cd,hr_api.g_varchar2) <>
3309: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3310: l_chg := TRUE;
3311: end if;
3312: if (p_bnft_ordr_num <> hr_api.g_number and
3313: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3314: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3315: l_chg := TRUE;
3316: end if;
3309: nvl(p_bnft_typ_cd,hr_api.g_varchar2)) then
3310: l_chg := TRUE;
3311: end if;
3312: if (p_bnft_ordr_num <> hr_api.g_number and
3313: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3314: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3315: l_chg := TRUE;
3316: end if;
3317: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3310: l_chg := TRUE;
3311: end if;
3312: if (p_bnft_ordr_num <> hr_api.g_number and
3313: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3314: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3315: l_chg := TRUE;
3316: end if;
3317: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3318: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3313: nvl(l_global_pen_rec.bnft_ordr_num,hr_api.g_number) <>
3314: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3315: l_chg := TRUE;
3316: end if;
3317: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3318: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3319: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3320: l_chg := TRUE;
3321: end if;
3314: nvl(p_bnft_ordr_num,hr_api.g_number)) then
3315: l_chg := TRUE;
3316: end if;
3317: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3318: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3319: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3320: l_chg := TRUE;
3321: end if;
3322: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3315: l_chg := TRUE;
3316: end if;
3317: if (p_prtt_enrt_rslt_stat_cd <> hr_api.g_varchar2 and
3318: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3319: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3320: l_chg := TRUE;
3321: end if;
3322: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3323: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3318: nvl(l_global_pen_rec.prtt_enrt_rslt_stat_cd,hr_api.g_varchar2) <>
3319: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3320: l_chg := TRUE;
3321: end if;
3322: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3323: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3324: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3325: l_chg := TRUE;
3326: end if;
3319: nvl(p_prtt_enrt_rslt_stat_cd,hr_api.g_varchar2)) then
3320: l_chg := TRUE;
3321: end if;
3322: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3323: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3324: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3325: l_chg := TRUE;
3326: end if;
3327: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3320: l_chg := TRUE;
3321: end if;
3322: if (p_bnft_nnmntry_uom <> hr_api.g_varchar2 and
3323: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3324: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3325: l_chg := TRUE;
3326: end if;
3327: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3328: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3323: nvl(l_global_pen_rec.bnft_nnmntry_uom,hr_api.g_varchar2) <>
3324: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3325: l_chg := TRUE;
3326: end if;
3327: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3328: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3329: nvl(p_comp_lvl_cd,hr_api.g_varchar2)) then
3330: l_chg := TRUE;
3331: end if;
3324: nvl(p_bnft_nnmntry_uom,hr_api.g_varchar2)) then
3325: l_chg := TRUE;
3326: end if;
3327: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3328: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3329: nvl(p_comp_lvl_cd,hr_api.g_varchar2)) then
3330: l_chg := TRUE;
3331: end if;
3332: --
3325: l_chg := TRUE;
3326: end if;
3327: if (p_comp_lvl_cd <> hr_api.g_varchar2 and
3328: nvl(l_global_pen_rec.comp_lvl_cd,hr_api.g_varchar2) <>
3329: nvl(p_comp_lvl_cd,hr_api.g_varchar2)) then
3330: l_chg := TRUE;
3331: end if;
3332: --
3333: -- bug 1712890 added the following columns
3339: --If DFF field changes from non-zero value to NULL
3340: -- we need to detect that nullify the coverage. So added
3341: -- nvl(p_pen_attributexx, '~')
3342:
3343: if (nvl(p_pen_attribute1 ,'~')<> hr_api.g_varchar2 and
3344: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3345: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3346: l_chg := TRUE;
3347: end if;
3340: -- we need to detect that nullify the coverage. So added
3341: -- nvl(p_pen_attributexx, '~')
3342:
3343: if (nvl(p_pen_attribute1 ,'~')<> hr_api.g_varchar2 and
3344: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3345: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3346: l_chg := TRUE;
3347: end if;
3348: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3341: -- nvl(p_pen_attributexx, '~')
3342:
3343: if (nvl(p_pen_attribute1 ,'~')<> hr_api.g_varchar2 and
3344: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3345: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3346: l_chg := TRUE;
3347: end if;
3348: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3349: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3344: nvl(l_global_pen_rec.pen_attribute1,hr_api.g_varchar2) <>
3345: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3346: l_chg := TRUE;
3347: end if;
3348: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3349: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3350: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3351: l_chg := TRUE;
3352: end if;
3345: nvl(p_pen_attribute1,hr_api.g_varchar2)) then
3346: l_chg := TRUE;
3347: end if;
3348: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3349: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3350: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3351: l_chg := TRUE;
3352: end if;
3353: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3346: l_chg := TRUE;
3347: end if;
3348: if (nvl(p_pen_attribute2 ,'~')<> hr_api.g_varchar2 and
3349: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3350: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3351: l_chg := TRUE;
3352: end if;
3353: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3354: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3349: nvl(l_global_pen_rec.pen_attribute2,hr_api.g_varchar2) <>
3350: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3351: l_chg := TRUE;
3352: end if;
3353: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3354: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3355: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3356: l_chg := TRUE;
3357: end if;
3350: nvl(p_pen_attribute2,hr_api.g_varchar2)) then
3351: l_chg := TRUE;
3352: end if;
3353: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3354: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3355: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3356: l_chg := TRUE;
3357: end if;
3358: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3351: l_chg := TRUE;
3352: end if;
3353: if (nvl(p_pen_attribute3 ,'~')<> hr_api.g_varchar2 and
3354: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3355: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3356: l_chg := TRUE;
3357: end if;
3358: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3359: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3354: nvl(l_global_pen_rec.pen_attribute3,hr_api.g_varchar2) <>
3355: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3356: l_chg := TRUE;
3357: end if;
3358: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3359: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3360: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3361: l_chg := TRUE;
3362: end if;
3355: nvl(p_pen_attribute3,hr_api.g_varchar2)) then
3356: l_chg := TRUE;
3357: end if;
3358: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3359: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3360: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3361: l_chg := TRUE;
3362: end if;
3363: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3356: l_chg := TRUE;
3357: end if;
3358: if (nvl(p_pen_attribute4 ,'~')<> hr_api.g_varchar2 and
3359: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3360: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3361: l_chg := TRUE;
3362: end if;
3363: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3364: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3359: nvl(l_global_pen_rec.pen_attribute4,hr_api.g_varchar2) <>
3360: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3361: l_chg := TRUE;
3362: end if;
3363: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3364: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3365: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3366: l_chg := TRUE;
3367: end if;
3360: nvl(p_pen_attribute4,hr_api.g_varchar2)) then
3361: l_chg := TRUE;
3362: end if;
3363: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3364: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3365: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3366: l_chg := TRUE;
3367: end if;
3368: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3361: l_chg := TRUE;
3362: end if;
3363: if (nvl(p_pen_attribute5 ,'~')<> hr_api.g_varchar2 and
3364: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3365: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3366: l_chg := TRUE;
3367: end if;
3368: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3369: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3364: nvl(l_global_pen_rec.pen_attribute5,hr_api.g_varchar2) <>
3365: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3366: l_chg := TRUE;
3367: end if;
3368: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3369: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3370: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3371: l_chg := TRUE;
3372: end if;
3365: nvl(p_pen_attribute5,hr_api.g_varchar2)) then
3366: l_chg := TRUE;
3367: end if;
3368: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3369: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3370: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3371: l_chg := TRUE;
3372: end if;
3373: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3366: l_chg := TRUE;
3367: end if;
3368: if (nvl(p_pen_attribute6 ,'~')<> hr_api.g_varchar2 and
3369: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3370: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3371: l_chg := TRUE;
3372: end if;
3373: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3374: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3369: nvl(l_global_pen_rec.pen_attribute6,hr_api.g_varchar2) <>
3370: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3371: l_chg := TRUE;
3372: end if;
3373: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3374: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3375: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3376: l_chg := TRUE;
3377: end if;
3370: nvl(p_pen_attribute6,hr_api.g_varchar2)) then
3371: l_chg := TRUE;
3372: end if;
3373: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3374: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3375: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3376: l_chg := TRUE;
3377: end if;
3378: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3371: l_chg := TRUE;
3372: end if;
3373: if (nvl(p_pen_attribute7 ,'~')<> hr_api.g_varchar2 and
3374: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3375: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3376: l_chg := TRUE;
3377: end if;
3378: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3379: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3374: nvl(l_global_pen_rec.pen_attribute7,hr_api.g_varchar2) <>
3375: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3376: l_chg := TRUE;
3377: end if;
3378: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3379: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3380: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3381: l_chg := TRUE;
3382: end if;
3375: nvl(p_pen_attribute7,hr_api.g_varchar2)) then
3376: l_chg := TRUE;
3377: end if;
3378: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3379: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3380: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3381: l_chg := TRUE;
3382: end if;
3383: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3376: l_chg := TRUE;
3377: end if;
3378: if (nvl(p_pen_attribute8 ,'~')<> hr_api.g_varchar2 and
3379: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3380: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3381: l_chg := TRUE;
3382: end if;
3383: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3384: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3379: nvl(l_global_pen_rec.pen_attribute8,hr_api.g_varchar2) <>
3380: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3381: l_chg := TRUE;
3382: end if;
3383: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3384: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3385: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3386: l_chg := TRUE;
3387: end if;
3380: nvl(p_pen_attribute8,hr_api.g_varchar2)) then
3381: l_chg := TRUE;
3382: end if;
3383: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3384: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3385: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3386: l_chg := TRUE;
3387: end if;
3388: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3381: l_chg := TRUE;
3382: end if;
3383: if (nvl(p_pen_attribute9 ,'~')<> hr_api.g_varchar2 and
3384: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3385: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3386: l_chg := TRUE;
3387: end if;
3388: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3389: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3384: nvl(l_global_pen_rec.pen_attribute9,hr_api.g_varchar2) <>
3385: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3386: l_chg := TRUE;
3387: end if;
3388: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3389: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3390: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3391: l_chg := TRUE;
3392: end if;
3385: nvl(p_pen_attribute9,hr_api.g_varchar2)) then
3386: l_chg := TRUE;
3387: end if;
3388: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3389: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3390: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3391: l_chg := TRUE;
3392: end if;
3393: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3386: l_chg := TRUE;
3387: end if;
3388: if (nvl(p_pen_attribute10 ,'~')<> hr_api.g_varchar2 and
3389: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3390: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3391: l_chg := TRUE;
3392: end if;
3393: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3394: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3389: nvl(l_global_pen_rec.pen_attribute10,hr_api.g_varchar2) <>
3390: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3391: l_chg := TRUE;
3392: end if;
3393: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3394: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3395: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3396: l_chg := TRUE;
3397: end if;
3390: nvl(p_pen_attribute10,hr_api.g_varchar2)) then
3391: l_chg := TRUE;
3392: end if;
3393: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3394: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3395: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3396: l_chg := TRUE;
3397: end if;
3398: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3391: l_chg := TRUE;
3392: end if;
3393: if (nvl(p_pen_attribute11 ,'~')<> hr_api.g_varchar2 and
3394: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3395: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3396: l_chg := TRUE;
3397: end if;
3398: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3399: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3394: nvl(l_global_pen_rec.pen_attribute11,hr_api.g_varchar2) <>
3395: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3396: l_chg := TRUE;
3397: end if;
3398: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3399: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3400: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3401: l_chg := TRUE;
3402: end if;
3395: nvl(p_pen_attribute11,hr_api.g_varchar2)) then
3396: l_chg := TRUE;
3397: end if;
3398: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3399: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3400: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3401: l_chg := TRUE;
3402: end if;
3403: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3396: l_chg := TRUE;
3397: end if;
3398: if (nvl(p_pen_attribute12 ,'~')<> hr_api.g_varchar2 and
3399: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3400: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3401: l_chg := TRUE;
3402: end if;
3403: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3404: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3399: nvl(l_global_pen_rec.pen_attribute12,hr_api.g_varchar2) <>
3400: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3401: l_chg := TRUE;
3402: end if;
3403: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3404: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3405: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3406: l_chg := TRUE;
3407: end if;
3400: nvl(p_pen_attribute12,hr_api.g_varchar2)) then
3401: l_chg := TRUE;
3402: end if;
3403: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3404: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3405: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3406: l_chg := TRUE;
3407: end if;
3408: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3401: l_chg := TRUE;
3402: end if;
3403: if (nvl(p_pen_attribute13 ,'~')<> hr_api.g_varchar2 and
3404: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3405: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3406: l_chg := TRUE;
3407: end if;
3408: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3409: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3404: nvl(l_global_pen_rec.pen_attribute13,hr_api.g_varchar2) <>
3405: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3406: l_chg := TRUE;
3407: end if;
3408: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3409: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3410: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3411: l_chg := TRUE;
3412: end if;
3405: nvl(p_pen_attribute13,hr_api.g_varchar2)) then
3406: l_chg := TRUE;
3407: end if;
3408: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3409: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3410: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3411: l_chg := TRUE;
3412: end if;
3413: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3406: l_chg := TRUE;
3407: end if;
3408: if (nvl(p_pen_attribute14 ,'~')<> hr_api.g_varchar2 and
3409: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3410: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3411: l_chg := TRUE;
3412: end if;
3413: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3414: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3409: nvl(l_global_pen_rec.pen_attribute14,hr_api.g_varchar2) <>
3410: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3411: l_chg := TRUE;
3412: end if;
3413: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3414: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3415: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3416: l_chg := TRUE;
3417: end if;
3410: nvl(p_pen_attribute14,hr_api.g_varchar2)) then
3411: l_chg := TRUE;
3412: end if;
3413: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3414: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3415: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3416: l_chg := TRUE;
3417: end if;
3418: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3411: l_chg := TRUE;
3412: end if;
3413: if (nvl(p_pen_attribute15 ,'~')<> hr_api.g_varchar2 and
3414: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3415: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3416: l_chg := TRUE;
3417: end if;
3418: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3419: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3414: nvl(l_global_pen_rec.pen_attribute15,hr_api.g_varchar2) <>
3415: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3416: l_chg := TRUE;
3417: end if;
3418: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3419: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3420: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3421: l_chg := TRUE;
3422: end if;
3415: nvl(p_pen_attribute15,hr_api.g_varchar2)) then
3416: l_chg := TRUE;
3417: end if;
3418: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3419: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3420: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3421: l_chg := TRUE;
3422: end if;
3423: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3416: l_chg := TRUE;
3417: end if;
3418: if (nvl(p_pen_attribute16 ,'~')<> hr_api.g_varchar2 and
3419: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3420: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3421: l_chg := TRUE;
3422: end if;
3423: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3424: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3419: nvl(l_global_pen_rec.pen_attribute16,hr_api.g_varchar2) <>
3420: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3421: l_chg := TRUE;
3422: end if;
3423: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3424: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3425: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3426: l_chg := TRUE;
3427: end if;
3420: nvl(p_pen_attribute16,hr_api.g_varchar2)) then
3421: l_chg := TRUE;
3422: end if;
3423: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3424: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3425: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3426: l_chg := TRUE;
3427: end if;
3428: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3421: l_chg := TRUE;
3422: end if;
3423: if (nvl(p_pen_attribute17 ,'~')<> hr_api.g_varchar2 and
3424: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3425: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3426: l_chg := TRUE;
3427: end if;
3428: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3429: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3424: nvl(l_global_pen_rec.pen_attribute17,hr_api.g_varchar2) <>
3425: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3426: l_chg := TRUE;
3427: end if;
3428: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3429: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3430: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3431: l_chg := TRUE;
3432: end if;
3425: nvl(p_pen_attribute17,hr_api.g_varchar2)) then
3426: l_chg := TRUE;
3427: end if;
3428: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3429: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3430: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3431: l_chg := TRUE;
3432: end if;
3433: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3426: l_chg := TRUE;
3427: end if;
3428: if (nvl(p_pen_attribute18 ,'~')<> hr_api.g_varchar2 and
3429: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3430: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3431: l_chg := TRUE;
3432: end if;
3433: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3434: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3429: nvl(l_global_pen_rec.pen_attribute18,hr_api.g_varchar2) <>
3430: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3431: l_chg := TRUE;
3432: end if;
3433: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3434: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3435: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3436: l_chg := TRUE;
3437: end if;
3430: nvl(p_pen_attribute18,hr_api.g_varchar2)) then
3431: l_chg := TRUE;
3432: end if;
3433: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3434: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3435: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3436: l_chg := TRUE;
3437: end if;
3438: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3431: l_chg := TRUE;
3432: end if;
3433: if (nvl(p_pen_attribute19 ,'~')<> hr_api.g_varchar2 and
3434: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3435: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3436: l_chg := TRUE;
3437: end if;
3438: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3439: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3434: nvl(l_global_pen_rec.pen_attribute19,hr_api.g_varchar2) <>
3435: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3436: l_chg := TRUE;
3437: end if;
3438: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3439: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3440: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3441: l_chg := TRUE;
3442: end if;
3435: nvl(p_pen_attribute19,hr_api.g_varchar2)) then
3436: l_chg := TRUE;
3437: end if;
3438: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3439: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3440: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3441: l_chg := TRUE;
3442: end if;
3443: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3436: l_chg := TRUE;
3437: end if;
3438: if (nvl(p_pen_attribute20 ,'~')<> hr_api.g_varchar2 and
3439: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3440: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3441: l_chg := TRUE;
3442: end if;
3443: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3444: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3439: nvl(l_global_pen_rec.pen_attribute20,hr_api.g_varchar2) <>
3440: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3441: l_chg := TRUE;
3442: end if;
3443: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3444: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3445: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3446: l_chg := TRUE;
3447: end if;
3440: nvl(p_pen_attribute20,hr_api.g_varchar2)) then
3441: l_chg := TRUE;
3442: end if;
3443: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3444: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3445: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3446: l_chg := TRUE;
3447: end if;
3448: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3441: l_chg := TRUE;
3442: end if;
3443: if (nvl(p_pen_attribute21 ,'~')<> hr_api.g_varchar2 and
3444: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3445: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3446: l_chg := TRUE;
3447: end if;
3448: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3444: nvl(l_global_pen_rec.pen_attribute21,hr_api.g_varchar2) <>
3445: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3446: l_chg := TRUE;
3447: end if;
3448: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3450: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3445: nvl(p_pen_attribute21,hr_api.g_varchar2)) then
3446: l_chg := TRUE;
3447: end if;
3448: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3450: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3446: l_chg := TRUE;
3447: end if;
3448: if (nvl(p_pen_attribute22 ,'~')<> hr_api.g_varchar2 and
3449: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3450: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3454: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3449: nvl(l_global_pen_rec.pen_attribute22,hr_api.g_varchar2) <>
3450: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3454: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3455: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3456: l_chg := TRUE;
3457: end if;
3450: nvl(p_pen_attribute22,hr_api.g_varchar2)) then
3451: l_chg := TRUE;
3452: end if;
3453: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3454: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3455: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3456: l_chg := TRUE;
3457: end if;
3458: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3451: l_chg := TRUE;
3452: end if;
3453: if (nvl(p_pen_attribute23 ,'~')<> hr_api.g_varchar2 and
3454: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3455: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3456: l_chg := TRUE;
3457: end if;
3458: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3459: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3454: nvl(l_global_pen_rec.pen_attribute23,hr_api.g_varchar2) <>
3455: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3456: l_chg := TRUE;
3457: end if;
3458: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3459: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3460: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3461: l_chg := TRUE;
3462: end if;
3455: nvl(p_pen_attribute23,hr_api.g_varchar2)) then
3456: l_chg := TRUE;
3457: end if;
3458: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3459: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3460: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3461: l_chg := TRUE;
3462: end if;
3463: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3456: l_chg := TRUE;
3457: end if;
3458: if (nvl(p_pen_attribute24 ,'~')<> hr_api.g_varchar2 and
3459: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3460: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3461: l_chg := TRUE;
3462: end if;
3463: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3464: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3459: nvl(l_global_pen_rec.pen_attribute24,hr_api.g_varchar2) <>
3460: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3461: l_chg := TRUE;
3462: end if;
3463: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3464: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3465: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3466: l_chg := TRUE;
3467: end if;
3460: nvl(p_pen_attribute24,hr_api.g_varchar2)) then
3461: l_chg := TRUE;
3462: end if;
3463: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3464: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3465: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3466: l_chg := TRUE;
3467: end if;
3468: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3461: l_chg := TRUE;
3462: end if;
3463: if (nvl(p_pen_attribute25 ,'~')<> hr_api.g_varchar2 and
3464: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3465: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3466: l_chg := TRUE;
3467: end if;
3468: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3469: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3464: nvl(l_global_pen_rec.pen_attribute25,hr_api.g_varchar2) <>
3465: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3466: l_chg := TRUE;
3467: end if;
3468: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3469: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3470: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3471: l_chg := TRUE;
3472: end if;
3465: nvl(p_pen_attribute25,hr_api.g_varchar2)) then
3466: l_chg := TRUE;
3467: end if;
3468: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3469: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3470: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3471: l_chg := TRUE;
3472: end if;
3473: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3466: l_chg := TRUE;
3467: end if;
3468: if (nvl(p_pen_attribute26 ,'~')<> hr_api.g_varchar2 and
3469: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3470: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3471: l_chg := TRUE;
3472: end if;
3473: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3474: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3469: nvl(l_global_pen_rec.pen_attribute26,hr_api.g_varchar2) <>
3470: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3471: l_chg := TRUE;
3472: end if;
3473: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3474: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3475: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3476: l_chg := TRUE;
3477: end if;
3470: nvl(p_pen_attribute26,hr_api.g_varchar2)) then
3471: l_chg := TRUE;
3472: end if;
3473: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3474: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3475: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3476: l_chg := TRUE;
3477: end if;
3478: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3471: l_chg := TRUE;
3472: end if;
3473: if (nvl(p_pen_attribute27 ,'~')<> hr_api.g_varchar2 and
3474: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3475: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3476: l_chg := TRUE;
3477: end if;
3478: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3479: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3474: nvl(l_global_pen_rec.pen_attribute27,hr_api.g_varchar2) <>
3475: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3476: l_chg := TRUE;
3477: end if;
3478: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3479: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3480: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3481: l_chg := TRUE;
3482: end if;
3475: nvl(p_pen_attribute27,hr_api.g_varchar2)) then
3476: l_chg := TRUE;
3477: end if;
3478: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3479: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3480: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3481: l_chg := TRUE;
3482: end if;
3483: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3476: l_chg := TRUE;
3477: end if;
3478: if (nvl(p_pen_attribute28 ,'~')<> hr_api.g_varchar2 and
3479: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3480: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3481: l_chg := TRUE;
3482: end if;
3483: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3484: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3479: nvl(l_global_pen_rec.pen_attribute28,hr_api.g_varchar2) <>
3480: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3481: l_chg := TRUE;
3482: end if;
3483: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3484: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3485: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3486: l_chg := TRUE;
3487: end if;
3480: nvl(p_pen_attribute28,hr_api.g_varchar2)) then
3481: l_chg := TRUE;
3482: end if;
3483: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3484: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3485: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3486: l_chg := TRUE;
3487: end if;
3488: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3481: l_chg := TRUE;
3482: end if;
3483: if (nvl(p_pen_attribute29 ,'~')<> hr_api.g_varchar2 and
3484: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3485: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3486: l_chg := TRUE;
3487: end if;
3488: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3489: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3484: nvl(l_global_pen_rec.pen_attribute29,hr_api.g_varchar2) <>
3485: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3486: l_chg := TRUE;
3487: end if;
3488: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3489: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3490: nvl(p_pen_attribute30,hr_api.g_varchar2)) then
3491: l_chg := TRUE;
3492: end if;
3485: nvl(p_pen_attribute29,hr_api.g_varchar2)) then
3486: l_chg := TRUE;
3487: end if;
3488: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3489: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3490: nvl(p_pen_attribute30,hr_api.g_varchar2)) then
3491: l_chg := TRUE;
3492: end if;
3493: --End Bug 4770367
3486: l_chg := TRUE;
3487: end if;
3488: if (nvl(p_pen_attribute30 ,'~')<> hr_api.g_varchar2 and
3489: nvl(l_global_pen_rec.pen_attribute30,hr_api.g_varchar2) <>
3490: nvl(p_pen_attribute30,hr_api.g_varchar2)) then
3491: l_chg := TRUE;
3492: end if;
3493: --End Bug 4770367
3494:
3509: p_update_change_insert => l_update_change_insert);
3510: --
3511: if l_update_override then
3512: --
3513: l_datetrack_mode := hr_api.g_update_override;
3514: --
3515: elsif l_update then
3516: --
3517: l_datetrack_mode := hr_api.g_update;
3513: l_datetrack_mode := hr_api.g_update_override;
3514: --
3515: elsif l_update then
3516: --
3517: l_datetrack_mode := hr_api.g_update;
3518: --
3519: else
3520: --
3521: l_datetrack_mode := hr_api.g_correction;
3517: l_datetrack_mode := hr_api.g_update;
3518: --
3519: else
3520: --
3521: l_datetrack_mode := hr_api.g_correction;
3522: --
3523: end if;
3524: --
3525: -- Start of API User Hook for the before hook of
3721: p_update_change_insert => l_update_change_insert);
3722: --
3723: if l_update_override then
3724: --
3725: l_ppe_datetrack_mode := hr_api.g_update_override;
3726: --
3727: elsif l_update then
3728: --
3729: l_ppe_datetrack_mode := hr_api.g_update;
3725: l_ppe_datetrack_mode := hr_api.g_update_override;
3726: --
3727: elsif l_update then
3728: --
3729: l_ppe_datetrack_mode := hr_api.g_update;
3730: --
3731: else
3732: --
3733: l_ppe_datetrack_mode := hr_api.g_correction;
3729: l_ppe_datetrack_mode := hr_api.g_update;
3730: --
3731: else
3732: --
3733: l_ppe_datetrack_mode := hr_api.g_correction;
3734: end if;
3735: ********************* END CODE PRIOR TO WWBUG: 1646442 *********/
3736: -- Because the benefit amount could have changed, and the premiums
3737: -- can be based on the benefit amount, re-calc it. It does a recalc
3919: p_update_change_insert => l_update_change_insert);
3920:
3921: if l_update_override then
3922: --
3923: l_ppe_datetrack_mode := hr_api.g_update_override;
3924: --
3925: elsif l_update then
3926: --
3927: l_ppe_datetrack_mode := hr_api.g_update;
3923: l_ppe_datetrack_mode := hr_api.g_update_override;
3924: --
3925: elsif l_update then
3926: --
3927: l_ppe_datetrack_mode := hr_api.g_update;
3928: --
3929: else
3930: --
3931: l_ppe_datetrack_mode := hr_api.g_correction;
3927: l_ppe_datetrack_mode := hr_api.g_update;
3928: --
3929: else
3930: --
3931: l_ppe_datetrack_mode := hr_api.g_correction;
3932: end if;
3933: /* End of Changes for WWBUG: 1646442 */
3934:
3935: ben_prtt_prem_api.update_prtt_prem
4021: p_update_override => l_update_override,
4022: p_update_change_insert => l_update_change_insert);
4023:
4024: if l_update_override then
4025: l_egd_datetrack_mode := hr_api.g_update_override;
4026: elsif l_update then
4027: l_egd_datetrack_mode := hr_api.g_update;
4028: else
4029: l_egd_datetrack_mode := hr_api.g_correction;
4023:
4024: if l_update_override then
4025: l_egd_datetrack_mode := hr_api.g_update_override;
4026: elsif l_update then
4027: l_egd_datetrack_mode := hr_api.g_update;
4028: else
4029: l_egd_datetrack_mode := hr_api.g_correction;
4030: end if;
4031:
4025: l_egd_datetrack_mode := hr_api.g_update_override;
4026: elsif l_update then
4027: l_egd_datetrack_mode := hr_api.g_update;
4028: else
4029: l_egd_datetrack_mode := hr_api.g_correction;
4030: end if;
4031:
4032: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt(
4033: p_elig_cvrd_dpnt_id => l_egd.elig_cvrd_dpnt_id,
4034: p_effective_start_date => p_effective_start_date,
4035: p_effective_end_date => p_effective_end_date,
4036: p_business_group_id => p_business_group_id,
4037: p_per_in_ler_id => p_per_in_ler_id,
4038: p_cvg_thru_dt => hr_api.g_eot,
4039: p_object_version_number => l_egd.object_version_number,
4040: p_datetrack_mode => l_egd_datetrack_mode,
4041: p_request_id => fnd_global.conc_request_id,
4042: p_program_application_id => fnd_global.prog_appl_id,
4160: --
4161: -- When in validation only mode raise the Validate_Enabled exception
4162: --
4163: if p_validate then
4164: raise hr_api.validate_enabled;
4165: end if;
4166: --
4167: -- Set all output arguments
4168: --
4172: if g_debug then
4173: hr_utility.set_location(' Leaving:'||l_proc, 70);
4174: end if;
4175: exception
4176: when hr_api.validate_enabled then
4177: --
4178: -- As the Validate_Enabled exception has been raised
4179: -- we must rollback to the savepoint
4180: --
4206: (p_validate in boolean default false
4207: ,p_prtt_enrt_rslt_id in number
4208: ,p_effective_start_date out nocopy date
4209: ,p_effective_end_date out nocopy date
4210: ,p_business_group_id in number default hr_api.g_number
4211: ,p_oipl_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4207: ,p_prtt_enrt_rslt_id in number
4208: ,p_effective_start_date out nocopy date
4209: ,p_effective_end_date out nocopy date
4210: ,p_business_group_id in number default hr_api.g_number
4211: ,p_oipl_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4208: ,p_effective_start_date out nocopy date
4209: ,p_effective_end_date out nocopy date
4210: ,p_business_group_id in number default hr_api.g_number
4211: ,p_oipl_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4209: ,p_effective_end_date out nocopy date
4210: ,p_business_group_id in number default hr_api.g_number
4211: ,p_oipl_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4210: ,p_business_group_id in number default hr_api.g_number
4211: ,p_oipl_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4211: ,p_oipl_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4212: ,p_person_id in number default hr_api.g_number
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4213: ,p_assignment_id in number default hr_api.g_number
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4214: ,p_pgm_id in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4215: ,p_pl_id in number default hr_api.g_number
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4216: ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4217: ,p_ptip_id in number default hr_api.g_number
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4218: ,p_pl_typ_id in number default hr_api.g_number
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4219: ,p_ler_id in number default hr_api.g_number
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4220: ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4221: ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4222: ,p_bnft_amt in number default hr_api.g_number
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4223: ,p_uom in varchar2 default hr_api.g_varchar2
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4224: ,p_orgnl_enrt_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4225: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4226: ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4227: ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4228: ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4229: ,p_erlst_deenrt_dt in date default hr_api.g_date
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4230: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4231: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4232: ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4233: ,p_pl_ordr_num in number default hr_api.g_number
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4234: ,p_plip_ordr_num in number default hr_api.g_number
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4235: ,p_ptip_ordr_num in number default hr_api.g_number
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4236: ,p_oipl_ordr_num in number default hr_api.g_number
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4243: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4244: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4245: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4246: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4247: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4248: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4249: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4250: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4251: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4252: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4253: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4254: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4255: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4256: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4257: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4258: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4259: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4260: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4261: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4262: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4263: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4264: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4265: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4266: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4267: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4268: ,p_request_id in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4269: ,p_program_application_id in number default hr_api.g_number
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4276: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4277: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4270: ,p_program_id in number default hr_api.g_number
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4276: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4277: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4278: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4271: ,p_program_update_date in date default hr_api.g_date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4276: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4277: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4278: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4279: ,p_effective_date in date
4272: ,p_object_version_number in out nocopy number
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4276: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4277: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4278: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4279: ,p_effective_date in date
4280: ,p_datetrack_mode in varchar2
4273: ,p_per_in_ler_id in number default hr_api.g_number
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4276: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4277: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4278: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4279: ,p_effective_date in date
4280: ,p_datetrack_mode in varchar2
4281: ,p_multi_row_validate in boolean default TRUE
4274: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
4275: ,p_bnft_ordr_num in number default hr_api.g_number
4276: ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
4277: ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
4278: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
4279: ,p_effective_date in date
4280: ,p_datetrack_mode in varchar2
4281: ,p_multi_row_validate in boolean default TRUE
4282: ) is
4347: --
4348: savepoint update_PRTT_ENRT_RESULT;
4349: --
4350: if fnd_global.conc_request_id in (0,-1) and
4351: p_business_group_id <> hr_api.g_number then
4352: --
4353: --bug#3568529
4354: ben_env_object.get(p_rec => l_env_rec);
4355: if l_env_rec.benefit_action_id is null then
4383: -- when the open LE then gain dpnt ,then process the opne on the same dt of GD
4384: -- the result of GD are lost. because the per_in_ler id of open updated in gd
4385:
4386: --bug # 3086161
4387: if p_datetrack_mode = hr_api.g_correction and p_per_in_ler_id <> hr_api.g_number then
4388: open c_old_rslt ;
4389: fetch c_old_rslt into l_old_rslt ;
4390: close c_old_rslt ;
4391: if l_old_rslt.per_in_ler_id <> p_per_in_ler_id
4664: ,p_effective_date => trunc(p_effective_date)
4665: ,p_datetrack_mode => p_datetrack_mode
4666: );
4667: exception
4668: when hr_api.cannot_find_prog_unit then
4669: hr_api.cannot_find_prog_unit_error
4670: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
4671: ,p_hook_type => 'BP'
4672: );
4665: ,p_datetrack_mode => p_datetrack_mode
4666: );
4667: exception
4668: when hr_api.cannot_find_prog_unit then
4669: hr_api.cannot_find_prog_unit_error
4670: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
4671: ,p_hook_type => 'BP'
4672: );
4673: --
4836: ,p_effective_date => trunc(p_effective_date)
4837: ,p_datetrack_mode => p_datetrack_mode
4838: );
4839: exception
4840: when hr_api.cannot_find_prog_unit then
4841: hr_api.cannot_find_prog_unit_error
4842: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
4843: ,p_hook_type => 'AP'
4844: );
4837: ,p_datetrack_mode => p_datetrack_mode
4838: );
4839: exception
4840: when hr_api.cannot_find_prog_unit then
4841: hr_api.cannot_find_prog_unit_error
4842: (p_module_name => 'UPDATE_PRTT_ENRT_RESULT'
4843: ,p_hook_type => 'AP'
4844: );
4845: --
4853: --
4854: -- When in validation only mode raise the Validate_Enabled exception
4855: --
4856: if p_validate then
4857: raise hr_api.validate_enabled;
4858: end if;
4859: --
4860: -- Set all output arguments
4861: --
4868: end if;
4869: --
4870: exception
4871: --
4872: when hr_api.validate_enabled then
4873: --
4874: -- As the Validate_Enabled exception has been raised
4875: -- we must rollback to the savepoint
4876: --
4950: ,p_effective_date => trunc(p_effective_date)
4951: ,p_datetrack_mode => p_datetrack_mode
4952: );
4953: exception
4954: when hr_api.cannot_find_prog_unit then
4955: hr_api.cannot_find_prog_unit_error
4956: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
4957: ,p_hook_type => 'BP'
4958: );
4951: ,p_datetrack_mode => p_datetrack_mode
4952: );
4953: exception
4954: when hr_api.cannot_find_prog_unit then
4955: hr_api.cannot_find_prog_unit_error
4956: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
4957: ,p_hook_type => 'BP'
4958: );
4959: --
4984: ,p_effective_date => trunc(p_effective_date)
4985: ,p_datetrack_mode => p_datetrack_mode
4986: );
4987: exception
4988: when hr_api.cannot_find_prog_unit then
4989: hr_api.cannot_find_prog_unit_error
4990: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
4991: ,p_hook_type => 'AP'
4992: );
4985: ,p_datetrack_mode => p_datetrack_mode
4986: );
4987: exception
4988: when hr_api.cannot_find_prog_unit then
4989: hr_api.cannot_find_prog_unit_error
4990: (p_module_name => 'DELETE_PRTT_ENRT_RESULT'
4991: ,p_hook_type => 'AP'
4992: );
4993: --
5001: --
5002: -- When in validation only mode raise the Validate_Enabled exception
5003: --
5004: if p_validate then
5005: raise hr_api.validate_enabled;
5006: end if;
5007: --
5008: p_effective_start_date := l_effective_start_date;
5009: p_effective_end_date := l_effective_end_date;
5014: end if;
5015: --
5016: exception
5017: --
5018: when hr_api.validate_enabled then
5019: --
5020: -- As the Validate_Enabled exception has been raised
5021: -- we must rollback to the savepoint
5022: --
5422: Begin
5423: Open c1;
5424: Fetch c1 into l_date,l_pil_id;
5425: If c1%notfound then
5426: l_date := hr_api.g_date;
5427: l_pil_id := to_number(null);
5428: End if;
5429: Close c1;
5430: p_date := l_date;
5593: from ben_prtt_rt_val prv,
5594: ben_enrt_rt ecr
5595: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5596: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5597: and prv.rt_end_dt <> hr_api.g_eot
5598: and prv.business_group_id = p_business_group_id
5599: and prv.per_in_ler_id = p_per_in_ler_id
5600: and prv.prtt_rt_val_stat_cd is null;
5601: --
5656: from ben_prmry_care_prvdr_f pcp
5657: where pcp.business_group_id = p_business_group_id
5658: and pcp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5659: and p_effective_date < pcp.effective_start_date
5660: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot
5661: ;
5662: -- 3574168
5663:
5664: l_abr c_abr%rowtype;
5802: ,P_EFFECTIVE_START_DATE => l_pcp.effective_start_date
5803: ,P_EFFECTIVE_END_DATE => l_pcp.effective_end_date
5804: ,P_OBJECT_VERSION_NUMBER => l_pcp.object_version_number
5805: ,P_EFFECTIVE_DATE => p_effective_date
5806: ,P_DATETRACK_MODE => hr_api.g_zap
5807: ,p_called_from => 'delete_enrollment'
5808: );
5809: --
5810: End loop;
5823: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
5824: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
5825: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
5826: ,P_EFFECTIVE_DATE => l_pcp_effective_date
5827: ,P_DATETRACK_MODE => hr_api.g_zap
5828: ,p_called_from => 'delete_enrollment'
5829: );
5830: --
5831: End loop;
5858: p_effective_start_date => l_effective_start_date,
5859: p_effective_end_date => l_effective_end_date,
5860: p_object_version_number => l_pen.object_version_number,
5861: p_effective_date => p_effective_date,
5862: p_datetrack_mode => hr_api.g_future_change,
5863: p_multi_row_validate => FALSE);
5864: --
5865: open c_pen;
5866: fetch c_pen into l_pen;
5914: -- leslie code begin:
5915: -- when result is voided in correction mode, we can't compute premium
5916: -- credits. Tell use that they may want to manually.
5917: -- If in correction and esd of result is before first day of this month...
5918: if l_datetrack_mode = hr_api.g_correction and l_pen.effective_start_date <
5919: to_date(to_char(p_effective_date, 'mm-yyyy'), 'mm-yyyy') then
5920: ben_prem_prtt_monthly.premium_warning
5921: (p_person_id => l_pen.person_id
5922: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
5956: --
5957: -- When in validation only mode raise the Validate_Enabled exception
5958: --
5959: if p_validate then
5960: raise hr_api.validate_enabled;
5961: end if;
5962: --
5963: if g_debug then
5964: hr_utility.set_location(' Leaving:'||l_proc, 70);
5965: end if;
5966: --
5967: Exception
5968: --
5969: when hr_api.validate_enabled
5970: then
5971: --
5972: -- As the Validate_Enabled exception has been raised
5973: -- we must rollback to the savepoint
6166: ,abr.input_value_id
6167: from ben_prtt_rt_val prv
6168: ,ben_acty_base_rt_f abr
6169: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6170: and prv.rt_end_dt = hr_api.g_eot
6171: and prv.business_group_id = p_business_group_id
6172: and prv.acty_base_rt_id = abr.acty_base_rt_id
6173: and p_effective_date between abr.effective_start_date
6174: and abr.effective_end_date
6188: ,ben_acty_base_rt_f abr
6189: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6190: and prv.per_in_ler_id <> p_per_in_ler_id -- basu
6191: and prv.rt_end_dt > p_rt_end_dt
6192: and prv.rt_end_dt <> hr_api.g_eot
6193: and prv.business_group_id = p_business_group_id
6194: and prv.acty_base_rt_id = abr.acty_base_rt_id
6195: and p_effective_date between abr.effective_start_date
6196: and abr.effective_end_date
6201: Cursor c_enrt_in_curr_le is
6202: select 'Y'
6203: from ben_prtt_enrt_rslt_f pen
6204: where pen.per_in_ler_id = p_per_in_ler_id
6205: and pen.effective_end_date = hr_api.g_eot
6206: and pen.enrt_cvg_thru_dt = hr_api.g_eot
6207: and pen.prtt_enrt_rslt_stat_cd is null;
6208: --
6209: l_enrt_in_curr_le varchar2(2);
6202: select 'Y'
6203: from ben_prtt_enrt_rslt_f pen
6204: where pen.per_in_ler_id = p_per_in_ler_id
6205: and pen.effective_end_date = hr_api.g_eot
6206: and pen.enrt_cvg_thru_dt = hr_api.g_eot
6207: and pen.prtt_enrt_rslt_stat_cd is null;
6208: --
6209: l_enrt_in_curr_le varchar2(2);
6210: -- basu
6217: ,ben_ptip_f ptip
6218: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id -- 245535
6219: and pen.per_in_ler_id <> p_per_in_ler_id -- basu
6220: and pen.enrt_cvg_thru_dt > p_cvg_end_dt -- '20-jan-2008'
6221: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
6222: and pen.business_group_id = p_business_group_id --81545
6223: and pen.ptip_id = ptip.ptip_id
6224: and p_effective_date between ptip.effective_start_date
6225: and ptip.effective_end_date;
6284: from ben_prtt_rt_val prv,
6285: ben_enrt_rt ecr
6286: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6287: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
6288: and prv.rt_end_dt <> hr_api.g_eot
6289: and prv.business_group_id = p_business_group_id
6290: and prv.per_in_ler_id = p_per_in_ler_id
6291: and prv.prtt_rt_val_stat_cd is null;
6292: --
6351: from ben_prmry_care_prvdr_f pcp
6352: where business_group_id = p_business_group_id
6353: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6354: and c_pcp_effective_date < effective_start_date ----3631067: Changed p_effective_date to c_pcp_effective_date
6355: and NVL(effective_end_date, hr_api.g_eot) = hr_api.g_eot
6356: ;
6357: -- 3574168
6358:
6359: --
6361: --
6362: -- ikasire: deleted the condition
6363: -- pen.enrt_cvg_strt_dt >= p_effective_date
6364: -- since it may not be always true. Instead added the
6365: -- condition pen.ENRT_CVG_THRU_DT = hr_api.g_eot
6366: -- to get the new prtt enrt record. Still there is a
6367: -- gap in this '1 prior' coding, which has to be
6368: -- handled with more detailed study.
6369: --Bug 2847110
6385: and ((l_pl_id =-999 and pen.enrt_cvg_strt_dt >= p_enrt_cvg_strt_dt)
6386: or pen.pl_id = l_pl_id ) -- Bug 2847110
6387: and pen.prtt_enrt_rslt_stat_cd is null
6388: -- and pen.enrt_cvg_strt_dt >= p_effective_date
6389: and pen.ENRT_CVG_THRU_DT = hr_api.g_eot
6390: and pen.effective_end_date = hr_api.g_eot
6391: -- and pen.business_group_id = p_business_group_id
6392: --and p_effective_date between pen.effective_start_date
6393: -- and pen.effective_end_date
6386: or pen.pl_id = l_pl_id ) -- Bug 2847110
6387: and pen.prtt_enrt_rslt_stat_cd is null
6388: -- and pen.enrt_cvg_strt_dt >= p_effective_date
6389: and pen.ENRT_CVG_THRU_DT = hr_api.g_eot
6390: and pen.effective_end_date = hr_api.g_eot
6391: -- and pen.business_group_id = p_business_group_id
6392: --and p_effective_date between pen.effective_start_date
6393: -- and pen.effective_end_date
6394: and pen.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id
6399: from ben_prtt_enrt_rslt_f pen
6400: where pen.rplcs_sspndd_rslt_id = l_pen.rplcs_sspndd_rslt_id
6401: and pen.business_group_id = p_business_group_id
6402: and pen.sspndd_flag = 'Y'
6403: and pen.enrt_cvg_thru_dt = hr_api.g_eot
6404: and pen.effective_end_date = hr_api.g_eot
6405: and pen.prtt_enrt_rslt_stat_cd is null
6406: and p_effective_date between
6407: pen.effective_start_date and pen.effective_end_date
6400: where pen.rplcs_sspndd_rslt_id = l_pen.rplcs_sspndd_rslt_id
6401: and pen.business_group_id = p_business_group_id
6402: and pen.sspndd_flag = 'Y'
6403: and pen.enrt_cvg_thru_dt = hr_api.g_eot
6404: and pen.effective_end_date = hr_api.g_eot
6405: and pen.prtt_enrt_rslt_stat_cd is null
6406: and p_effective_date between
6407: pen.effective_start_date and pen.effective_end_date
6408: -- Bug 6165501 : Added union clause if its a Correction case, and interim has already
6411: select 'Y'
6412: from ben_prtt_enrt_rslt_f pen, ben_le_clsn_n_rstr cls
6413: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6414: and pen.prtt_enrt_rslt_stat_cd is null
6415: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6416: and pen.per_in_ler_id = p_per_in_ler_id
6417: and cls.bkup_tbl_id = pen.prtt_enrt_rslt_id
6418: and cls.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F_CORR'
6419: and cls.per_in_ler_ended_id = p_per_in_ler_id;
6450: and pen.prtt_enrt_rslt_stat_cd is null
6451: and pen.sspndd_flag = 'N'
6452: and p_effective_date > pen.effective_start_date
6453: and pen.enrt_cvg_thru_dt > p_effective_date -- 4919591
6454: and pen.effective_end_date = hr_api.g_eot; --4919591
6455:
6456:
6457: cursor c_rslt_pl ( p_person_id number ,
6458: p_pgm_id number ,
6470: and pen.prtt_enrt_rslt_stat_cd is null
6471: and pen.sspndd_flag = 'N'
6472: and p_effective_date > pen.effective_start_date
6473: and pen.enrt_cvg_thru_dt > p_effective_date; -- 4919591
6474: -- and pen.effective_end_date = hr_api.g_eot; -- 4919591------------7458990
6475:
6476: cursor c_rslt_ptip( p_person_id number ,
6477: p_pgm_id number ,
6478: p_ptip_id number ,
6489: and pen.prtt_enrt_rslt_stat_cd is null
6490: and pen.sspndd_flag = 'N'
6491: and p_effective_date > pen.effective_start_date
6492: and pen.enrt_cvg_thru_dt > p_effective_date
6493: and pen.effective_end_date = hr_api.g_eot;
6494: --
6495: cursor c_per_in_ler (p_per_in_ler_id number) is
6496: select *
6497: from ben_per_in_ler
6562: and nvl(p_pl_id ,-1) = nvl(pen.pl_id,-1)
6563: and nvl(p_oipl_id,-1) = nvl(pen.oipl_id, -1)
6564: and p_per_in_ler_id = pen.per_in_ler_id
6565: and pen.prtt_enrt_rslt_stat_cd is null
6566: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6567: ;
6568: --
6569: l_current_result_id number ;
6570: --
6584: where bkup_tbl_id = c_pen_id
6585: and per_in_ler_ended_id = c_pil_id
6586: and per_in_ler_id <> c_pil_id
6587: and effective_start_date = c_pen_effective_start_date -- bug 7197868
6588: and enrt_cvg_thru_dt = hr_api.g_eot;
6589: l_corr_pil_id BEN_LE_CLSN_N_RSTR.per_in_ler_id%type ;
6590:
6591: cursor c_pen_obj_no (c_pil_id number
6592: ,c_pen_id number ) is
6608: and epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6609: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id
6610: and pen.per_in_ler_id=p_per_in_ler_id
6611: and pen.ler_id = ler.ler_id
6612: and nvl(epe.erlst_deenrt_dt,hr_api.g_sot) > p_effective_date;
6613:
6614: l_crntly_enrd_flag varchar2(10);
6615: l_ler_type_cd varchar2(20);
6616:
6625: and epe.per_in_ler_id=p_per_in_ler_id
6626: and pen.ler_id = ler.ler_id
6627: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id
6628: and pen.per_in_ler_id=p_per_in_ler_id
6629: and nvl(epe.erlst_deenrt_dt,hr_api.g_sot) > p_effective_date;
6630:
6631: l_typ_cd varchar2(20);
6632: --
6633:
6659: ben_prtt_rt_val curprv,
6660: ben_acty_base_rt_f abr
6661: WHERE curprv.business_group_id=oldprv.business_group_id
6662: AND curprv.per_in_ler_id = oldprv.ended_per_in_ler_id
6663: AND oldprv.rt_end_dt <> hr_api.g_eot
6664: AND oldprv.acty_base_rt_id = curprv.acty_base_rt_id
6665: AND oldprv.prtt_rt_val_stat_cd IS NULL
6666: and curprv.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
6667: AND abr.acty_base_rt_id = oldprv.acty_base_rt_id
7177: -- **** By-pass the check.
7178: --
7179: null;
7180: --
7181: --elsif (p_effective_date < nvl(l_pen.erlst_deenrt_dt,hr_api.g_sot) and
7182: -- on the erlst_deenrt_dt then deenrt is allowd so -1 is compared
7183: if g_debug then
7184: hr_utility.set_location('cvg end dt ' || l_enrt_cvg_end_dt , 7086);
7185: hr_utility.set_location('denrt ' || l_pen.erlst_deenrt_dt , 7086);
7183: if g_debug then
7184: hr_utility.set_location('cvg end dt ' || l_enrt_cvg_end_dt , 7086);
7185: hr_utility.set_location('denrt ' || l_pen.erlst_deenrt_dt , 7086);
7186: end if;
7187: elsif (l_enrt_cvg_end_dt < nvl(l_pen.erlst_deenrt_dt,hr_api.g_sot)-1 and
7188: l_pen.sspndd_flag = 'N' /*and p_effective_date > l_pen.enrt_cvg_strt_dt */) then
7189: --
7190: -- Must now check if can deenroll legally. If an enrollment is
7191: -- found for the level at which the the required period of enrollment
7382: end if;
7383: close get_lf_evt_dt;
7384: --
7385: If ((p_effective_date between
7386: l_pen.ENRT_CVG_STRT_DT and nvl(l_pen.enrt_cvg_thru_dt, hr_api.g_eot))
7387: and ( (l_pen.SSPNDD_FLAG = 'N') or
7388: ( nvl(p_source,'x') <> 'benuneai' and l_pen.SSPNDD_FLAG = 'Y') --CFW
7389: )) or
7390: ((l_lf_evt_ocrd_dt between
7387: and ( (l_pen.SSPNDD_FLAG = 'N') or
7388: ( nvl(p_source,'x') <> 'benuneai' and l_pen.SSPNDD_FLAG = 'Y') --CFW
7389: )) or
7390: ((l_lf_evt_ocrd_dt between
7391: l_pen.ENRT_CVG_STRT_DT and nvl(l_pen.enrt_cvg_thru_dt, hr_api.g_eot))
7392: and l_pil_id <> p_per_in_ler_id
7393: and ( (l_pen.SSPNDD_FLAG = 'N') or
7394: ( nvl(p_source,'x') <> 'benuneai' and l_pen.SSPNDD_FLAG = 'Y') --CFW
7395: )) or
7444: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
7445: ,p_effective_date => p_effective_date
7446: ,p_business_group_id => p_business_group_id
7447: ,p_validate => FALSE
7448: ,p_datetrack_mode => hr_api.g_delete
7449: );
7450: end if;
7451: hr_utility.set_location('l_benmngle_parm_rec.mode_cd '|| l_benmngle_parm_rec.mode_cd , 100);
7452: hr_utility.set_location('l_env_rec.mode_cd '|| l_env_rec.mode_cd , 100);
7540: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
7541: ,p_effective_date => p_effective_date
7542: ,p_business_group_id => p_business_group_id
7543: ,p_validate => FALSE
7544: ,p_datetrack_mode => hr_api.g_zap
7545: ,p_source => p_source
7546: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
7547: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
7548: );
7680: ,p_business_group_id => p_business_group_id
7681: ,P_OBJECT_VERSION_NUMBER => l_get_old_prv.object_version_number
7682: ,P_EFFECTIVE_DATE => p_effective_date
7683: );
7684: hr_utility.set_location('P_RT_END_DT,srav :'||hr_api.g_eot,3455);
7685: end if;
7686: close c_get_old_prv;
7687: hr_utility.set_location('P_RT_END_DT,srav,not fund :'||hr_api.g_eot,3455);
7688: hr_utility.set_location('p_effective_start_date :'||p_effective_start_date,3455);
7683: );
7684: hr_utility.set_location('P_RT_END_DT,srav :'||hr_api.g_eot,3455);
7685: end if;
7686: close c_get_old_prv;
7687: hr_utility.set_location('P_RT_END_DT,srav,not fund :'||hr_api.g_eot,3455);
7688: hr_utility.set_location('p_effective_start_date :'||p_effective_start_date,3455);
7689: hr_utility.set_location('p_effective_date :'||p_effective_date,3455);
7690: end if;
7691: -----Bug 6925893
7692: end if;
7693: end if;
7694: --End Bug 5499809
7695:
7696: hr_utility.set_location('P_RT_END_DT,srav,not fund1 :'||hr_api.g_eot,3455);
7697: --
7698: l_step := 35;
7699: if g_debug then
7700: hr_utility.set_location(l_proc,3456);
7820: p_effective_end_date => l_effective_end_date,
7821: p_business_group_id => p_business_group_id,
7822: p_object_version_number => l_pen5.object_version_number,
7823: p_effective_date => p_effective_date,
7824: p_datetrack_mode => hr_api.g_correction,
7825: p_multi_row_validate => FALSE,
7826: p_enrt_cvg_thru_dt => l_enrt_cvg_end_dt,
7827: p_person_id => l_pen.person_id
7828: );
7904: --
7905: hr_utility.set_location('DELETE prmry_care_prvdr_id '|| l_pcp.prmry_care_prvdr_id, 15);
7906: hr_utility.set_location('PCP ESD: EED '|| l_pcp.effective_start_date ||': '||l_pcp.effective_end_date, 15);
7907: hr_utility.set_location('Effective Date to delete '|| l_pcp_effective_date, 15);
7908: hr_utility.set_location('DATETRACK_MODE '|| hr_api.g_delete, 15);
7909: -- Since, deletion automatically sets end-date to 1 day less than effective-date,
7910: -- call the delete-api with effective_date = cvg_thru_date+1.
7911: --
7912: ben_prmry_care_prvdr_api.delete_prmry_care_prvdr
7915: ,P_EFFECTIVE_START_DATE => l_pcp.effective_start_date
7916: ,P_EFFECTIVE_END_DATE => l_pcp.effective_end_date
7917: ,P_OBJECT_VERSION_NUMBER => l_pcp.object_version_number
7918: ,P_EFFECTIVE_DATE => l_pcp_effective_date
7919: ,P_DATETRACK_MODE => hr_api.g_delete
7920: ,p_called_from => 'delete_enrollment'
7921: );
7922: --
7923: End loop;
7938: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
7939: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
7940: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
7941: ,P_EFFECTIVE_DATE => l_pcp_effective_start_date
7942: ,P_DATETRACK_MODE => hr_api.g_zap
7943: ,p_called_from => 'delete_enrollment'
7944: );
7945: End loop;
7946: -- 3574168
8004: ,p_effective_date => p_effective_date
8005: ,p_end_date => l_enrt_cvg_end_dt
8006: ,p_business_group_id => p_business_group_id
8007: ,p_validate => FALSE
8008: ,p_datetrack_mode => hr_api.g_delete
8009: ,p_source => p_source
8010: ,p_per_in_ler_id => l_pen.pen_per_in_ler_id
8011: ,p_per_in_ler_ended_id=> l_pen.per_in_ler_id
8012: );
8030: end if;
8031: --
8032: --CFW. If deleting a suspended result, remove interim pen id
8033: -- below code is commenetd as part of 5347887.
8034: /*l_rplcs_sspndd_rslt_id := hr_api.g_number;
8035: if l_pen.sspndd_flag = 'Y' then
8036: l_rplcs_sspndd_rslt_id := null;
8037: end if;*/
8038: -- bug#5363388
8123: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8124: ,p_effective_date => p_effective_date
8125: ,p_business_group_id => p_business_group_id
8126: ,p_validate => FALSE
8127: ,p_datetrack_mode => hr_api.g_delete
8128: );
8129: end if;
8130: --
8131: end if;
8157: -- Bug 2537720
8158: -- This is not allowing to update the enrollment on the same date for
8159: -- the suspended enrollment.So added the l_pen.effective_start_date < p_effective_date
8160: -- condition.
8161: if p_datetrack_mode=hr_api.g_update
8162: and l_pen.effective_start_date < p_effective_date
8163: and p_per_in_ler_id <> l_pil_id then -----Added for the Bug 7311284
8164: --
8165: l_eff_dt:=p_effective_date-1;
8359: p_effective_end_date => l_effective_end_date,
8360: p_business_group_id => p_business_group_id,
8361: p_object_version_number => l_pen5.object_version_number,
8362: p_effective_date => p_effective_date,
8363: p_datetrack_mode => hr_api.g_correction,
8364: p_multi_row_validate => FALSE,
8365: p_enrt_cvg_thru_dt => l_enrt_cvg_end_dt,
8366: p_person_id => l_pen.person_id
8367: );
8514: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8515: ,p_effective_date => p_effective_date
8516: ,p_business_group_id => p_business_group_id
8517: ,p_validate => FALSE
8518: ,p_datetrack_mode => hr_api.g_delete
8519: );
8520: end if;
8521: --
8522: --- # 2546259
8534: IF l_get_correction_info.place_holder='X' THEN
8535: l_prtt_enrt_rslt_Stat_cd:=NULL;
8536: l_datetrack_mode:='CORRECTION';
8537: ELSE
8538: l_datetrack_mode := hr_api.g_zap;
8539: END IF;
8540: --
8541: if p_source = 'beninelg' then
8542: l_datetrack_mode := hr_api.g_delete;
8538: l_datetrack_mode := hr_api.g_zap;
8539: END IF;
8540: --
8541: if p_source = 'beninelg' then
8542: l_datetrack_mode := hr_api.g_delete;
8543: elsif p_source is null or --CFW
8544: p_source = 'benuneai' then
8545: l_datetrack_mode := p_datetrack_mode;
8546: end if;
8798: -- delete child ben_prtt_prem_by_mo_f records
8799: --
8800: for l_prm in c_prm loop
8801: --
8802: if (l_datetrack_mode = hr_api.g_delete and
8803: l_prm.effective_end_date > l_eff_dt) or
8804: l_datetrack_mode <> hr_api.g_delete then
8805: --
8806: ben_prtt_prem_by_mo_api.delete_prtt_prem_by_mo
8800: for l_prm in c_prm loop
8801: --
8802: if (l_datetrack_mode = hr_api.g_delete and
8803: l_prm.effective_end_date > l_eff_dt) or
8804: l_datetrack_mode <> hr_api.g_delete then
8805: --
8806: ben_prtt_prem_by_mo_api.delete_prtt_prem_by_mo
8807: (p_validate => false,
8808: p_prtt_prem_by_mo_id => l_prm.prtt_prem_by_mo_id,
8817: --
8818: end loop;
8819: ******************** END CODE PRIOR TO WWBUG: 1646442 ************/
8820: --
8821: if (l_datetrack_mode = hr_api.g_delete and
8822: l_ppe.effective_end_date > l_eff_dt) or
8823: l_datetrack_mode <> hr_api.g_delete then
8824: --
8825: /* Start of Changes for WWBUG: 1646442: added */
8819: ******************** END CODE PRIOR TO WWBUG: 1646442 ************/
8820: --
8821: if (l_datetrack_mode = hr_api.g_delete and
8822: l_ppe.effective_end_date > l_eff_dt) or
8823: l_datetrack_mode <> hr_api.g_delete then
8824: --
8825: /* Start of Changes for WWBUG: 1646442: added */
8826: l_ppe_dt_to_use := least(l_enrt_cvg_end_dt,l_rt_end_dt);
8827: l_ppe_datetrack_mode := l_datetrack_mode;
8827: l_ppe_datetrack_mode := l_datetrack_mode;
8828: if l_ppe_dt_to_use < l_ppe.effective_start_date
8829: then
8830: l_ppe_dt_to_use := l_ppe.effective_start_date;
8831: l_ppe_datetrack_mode := hr_api.g_zap;
8832: end if;
8833: /* End of Changes for WWBUG: 1646442 */
8834: /***************** BEGIN CODE PRIOR TO WWBUG: 1646442 **********
8835: ben_prtt_prem_api.delete_prtt_prem
8872: --changing to option 2 ] we don't want to keep the pen id on the enb record.
8873: --When we are zaping the records for the call from election information we
8874: --we want to remove the penid from enb also.
8875: --
8876: if p_source = 'benelinf' and l_datetrack_mode = hr_api.g_zap then
8877: --
8878: ben_election_information.manage_enrt_bnft
8879: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
8880: ,p_business_group_id => p_business_group_id
8904: -- Bug 1132739
8905: -- Bug 2386000 If the result got update as part of on of the above calls,
8906: -- we need to get the latest object_version_number
8907: --
8908: if (l_datetrack_mode = hr_api.g_delete and
8909: l_pen.effective_end_date > l_eff_dt) or
8910: l_datetrack_mode <> hr_api.g_delete then
8911: --
8912: -- 4663971
8906: -- we need to get the latest object_version_number
8907: --
8908: if (l_datetrack_mode = hr_api.g_delete and
8909: l_pen.effective_end_date > l_eff_dt) or
8910: l_datetrack_mode <> hr_api.g_delete then
8911: --
8912: -- 4663971
8913: open c_pen_ovn( p_prtt_enrt_rslt_id,l_eff_dt ) ;
8914: fetch c_pen_ovn into l_pen_ovn.object_version_number,l_pen_ovn.effective_start_date ;
8917: -- BUG 4663971 we should never call delete process with other than zap mode
8918: -- if the datetrack mode is other than zap we need to call
8919: -- update_prtt_enrt_result procedure
8920: --
8921: if p_source = 'benuneai' or l_datetrack_mode <> hr_api.g_zap then
8922: hr_utility.set_location('called from benuneai',99);
8923: --
8924: -- 4663971
8925: if l_pen_ovn.effective_start_date = l_eff_dt
8923: --
8924: -- 4663971
8925: if l_pen_ovn.effective_start_date = l_eff_dt
8926: or l_datetrack_mode='CORRECTION' then
8927: l_datetrack_mode := hr_api.g_correction ;
8928: l_temp_date:=l_enrt_cvg_end_dt;
8929: --Bug#:6641853
8930: else
8931: l_datetrack_mode := hr_api.g_update ;
8927: l_datetrack_mode := hr_api.g_correction ;
8928: l_temp_date:=l_enrt_cvg_end_dt;
8929: --Bug#:6641853
8930: else
8931: l_datetrack_mode := hr_api.g_update ;
8932: l_temp_date:=l_pen.enrt_cvg_strt_dt-1;
8933: end if;
8934: --
8935: ben_prtt_enrt_result_api.update_prtt_enrt_result
9000: ,p_per_in_ler_id => l_corr_pil_id
9001: ,p_ler_id => l_pen.ler_id
9002: ,p_object_version_number => l_object_version_number
9003: ,p_effective_date => p_effective_date
9004: ,p_datetrack_mode => hr_api.g_correction
9005: ,p_multi_row_validate => FALSE
9006: ,p_business_group_id => p_business_group_id
9007: );
9008: end if ;
9082: --
9083: -- When in validation only mode raise the Validate_Enabled exception
9084: --
9085: if p_validate then
9086: raise hr_api.validate_enabled;
9087: end if;
9088: --
9089: if g_debug then
9090: hr_utility.set_location(' Leaving:'||l_proc, 70);
9091: end if;
9092: --
9093: Exception
9094: --
9095: when hr_api.validate_enabled
9096: then
9097: --
9098: -- As the Validate_Enabled exception has been raised
9099: -- we must rollback to the savepoint
9225: --
9226: if l_last=-1 or l_last<>orec.pl_bnf_id then
9227: l_last:=orec.pl_bnf_id;
9228: l_effective_date:=p_effective_date;
9229: if (p_effective_date
9231: l_datetrack_mode := hr_api.g_zap;
9232: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9233: l_datetrack_mode := hr_api.g_correction;
9227: l_last:=orec.pl_bnf_id;
9228: l_effective_date:=p_effective_date;
9229: if (p_effective_date
9231: l_datetrack_mode := hr_api.g_zap;
9232: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9233: l_datetrack_mode := hr_api.g_correction;
9234: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9235: l_datetrack_mode := hr_api.g_correction;
9228: l_effective_date:=p_effective_date;
9229: if (p_effective_date
9231: l_datetrack_mode := hr_api.g_zap;
9232: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9233: l_datetrack_mode := hr_api.g_correction;
9234: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9235: l_datetrack_mode := hr_api.g_correction;
9236: Else
9229: if (p_effective_date
9231: l_datetrack_mode := hr_api.g_zap;
9232: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9233: l_datetrack_mode := hr_api.g_correction;
9234: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9235: l_datetrack_mode := hr_api.g_correction;
9236: Else
9237: l_datetrack_mode := hr_api.g_update;
9230: l_effective_date:=orec.effective_start_date;
9231: l_datetrack_mode := hr_api.g_zap;
9232: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9233: l_datetrack_mode := hr_api.g_correction;
9234: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9235: l_datetrack_mode := hr_api.g_correction;
9236: Else
9237: l_datetrack_mode := hr_api.g_update;
9238: End if;
9231: l_datetrack_mode := hr_api.g_zap;
9232: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9233: l_datetrack_mode := hr_api.g_correction;
9234: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9235: l_datetrack_mode := hr_api.g_correction;
9236: Else
9237: l_datetrack_mode := hr_api.g_update;
9238: End if;
9239: --
9233: l_datetrack_mode := hr_api.g_correction;
9234: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9235: l_datetrack_mode := hr_api.g_correction;
9236: Else
9237: l_datetrack_mode := hr_api.g_update;
9238: End if;
9239: --
9240: --
9241: If (p_effective_date between nvl(orec.dsgn_strt_dt, p_effective_date+1)
9238: End if;
9239: --
9240: --
9241: If (p_effective_date between nvl(orec.dsgn_strt_dt, p_effective_date+1)
9242: and nvl(orec.dsgn_thru_dt, hr_api.g_eot)
9243: and not p_rslt_delete_flag
9244: and l_datetrack_mode<>hr_api.g_zap
9245: ) then
9246: --
9240: --
9241: If (p_effective_date between nvl(orec.dsgn_strt_dt, p_effective_date+1)
9242: and nvl(orec.dsgn_thru_dt, hr_api.g_eot)
9243: and not p_rslt_delete_flag
9244: and l_datetrack_mode<>hr_api.g_zap
9245: ) then
9246: --
9247: -- If Coverage started, then end the coverage by set the coverage
9248: -- thru date.
9259: p_update_change_insert => l_update_change_insert);
9260: --
9261: if l_update_override then
9262: --
9263: l_datetrack_mode := hr_api.g_update_override;
9264: --
9265: elsif l_update then
9266: --
9267: l_datetrack_mode := hr_api.g_update;
9263: l_datetrack_mode := hr_api.g_update_override;
9264: --
9265: elsif l_update then
9266: --
9267: l_datetrack_mode := hr_api.g_update;
9268: --
9269: else
9270: --
9271: l_datetrack_mode := hr_api.g_correction;
9267: l_datetrack_mode := hr_api.g_update;
9268: --
9269: else
9270: --
9271: l_datetrack_mode := hr_api.g_correction;
9272: --
9273: end if;
9274: if g_debug then
9275: hr_utility.set_location('dt_mode='||l_datetrack_mode,11);
9315: -- to NULL and coverage flag to 'N'
9316: --
9317: l_step := 40;
9318: --
9319: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9320: l_datetrack_mode := hr_api.g_zap;
9321: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9322: l_datetrack_mode := hr_api.g_zap;
9323: Else
9316: --
9317: l_step := 40;
9318: --
9319: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9320: l_datetrack_mode := hr_api.g_zap;
9321: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9322: l_datetrack_mode := hr_api.g_zap;
9323: Else
9324: l_datetrack_mode := hr_api.g_delete;
9317: l_step := 40;
9318: --
9319: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9320: l_datetrack_mode := hr_api.g_zap;
9321: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9322: l_datetrack_mode := hr_api.g_zap;
9323: Else
9324: l_datetrack_mode := hr_api.g_delete;
9325:
9318: --
9319: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9320: l_datetrack_mode := hr_api.g_zap;
9321: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9322: l_datetrack_mode := hr_api.g_zap;
9323: Else
9324: l_datetrack_mode := hr_api.g_delete;
9325:
9326: End if;
9320: l_datetrack_mode := hr_api.g_zap;
9321: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9322: l_datetrack_mode := hr_api.g_zap;
9323: Else
9324: l_datetrack_mode := hr_api.g_delete;
9325:
9326: End if;
9327: --
9328: -- Start of fix for INTERNAL bug 4924
9326: End if;
9327: --
9328: -- Start of fix for INTERNAL bug 4924
9329: --
9330: if l_datetrack_mode = hr_api.g_delete and
9331: p_effective_date = orec.effective_end_date then
9332: --
9333: -- Already end dated
9334: --
9400: from ben_elig_cvrd_dpnt_f ecd,
9401: ben_per_in_ler pil
9402: where ecd.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
9403: and ecd.cvg_strt_dt is not null
9404: -- and ecd.cvg_thru_dt = hr_api.g_eot
9405: and ecd.business_group_id=p_business_group_id
9406: -- and p_effective_date between
9407: -- ecd.effective_start_date and ecd.effective_end_date
9408: and p_effective_date <= ecd.effective_end_date
9453: from ben_prmry_care_prvdr_f pcp
9454: where pcp.business_group_id = p_business_group_id
9455: and pcp.elig_cvrd_dpnt_id = c_elig_cvrd_dpnt_id
9456: and p_effective_date < pcp.effective_start_date
9457: and NVL(pcp.effective_end_date, hr_api.g_eot) = hr_api.g_eot
9458: ;
9459: -- 3574168
9460:
9461: l_proc varchar2(72); -- := g_package||'unhook_dpnt';
9499: if l_last=-1 or
9500: l_last<>orec.elig_cvrd_dpnt_id then
9501: l_last:=orec.elig_cvrd_dpnt_id;
9502: l_effective_date:=p_effective_date;
9503: if (p_effective_date
9505: l_datetrack_mode := hr_api.g_zap;
9506: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9507: l_datetrack_mode := hr_api.g_correction;
9501: l_last:=orec.elig_cvrd_dpnt_id;
9502: l_effective_date:=p_effective_date;
9503: if (p_effective_date
9505: l_datetrack_mode := hr_api.g_zap;
9506: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9507: l_datetrack_mode := hr_api.g_correction;
9508: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9509: l_datetrack_mode := hr_api.g_correction;
9502: l_effective_date:=p_effective_date;
9503: if (p_effective_date
9505: l_datetrack_mode := hr_api.g_zap;
9506: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9507: l_datetrack_mode := hr_api.g_correction;
9508: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9509: l_datetrack_mode := hr_api.g_correction;
9510: Else
9503: if (p_effective_date
9505: l_datetrack_mode := hr_api.g_zap;
9506: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9507: l_datetrack_mode := hr_api.g_correction;
9508: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9509: l_datetrack_mode := hr_api.g_correction;
9510: Else
9511: l_datetrack_mode := hr_api.g_update;
9504: l_effective_date:=orec.effective_start_date;
9505: l_datetrack_mode := hr_api.g_zap;
9506: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9507: l_datetrack_mode := hr_api.g_correction;
9508: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9509: l_datetrack_mode := hr_api.g_correction;
9510: Else
9511: l_datetrack_mode := hr_api.g_update;
9512: End if;
9505: l_datetrack_mode := hr_api.g_zap;
9506: elsIf (p_effective_date = nvl(orec.effective_start_date,hr_api.g_date)) then
9507: l_datetrack_mode := hr_api.g_correction;
9508: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9509: l_datetrack_mode := hr_api.g_correction;
9510: Else
9511: l_datetrack_mode := hr_api.g_update;
9512: End if;
9513: --
9507: l_datetrack_mode := hr_api.g_correction;
9508: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9509: l_datetrack_mode := hr_api.g_correction;
9510: Else
9511: l_datetrack_mode := hr_api.g_update;
9512: End if;
9513: --
9514: If (p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
9515: and nvl(orec.cvg_thru_dt, hr_api.g_eot)
9511: l_datetrack_mode := hr_api.g_update;
9512: End if;
9513: --
9514: If (p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
9515: and nvl(orec.cvg_thru_dt, hr_api.g_eot)
9516: and orec.CVG_PNDG_FLAG = 'N'
9517: and not p_rslt_delete_flag
9518: and l_datetrack_mode<>hr_api.g_zap
9519: ) then
9514: If (p_effective_date between nvl(orec.cvg_strt_dt, p_effective_date+1)
9515: and nvl(orec.cvg_thru_dt, hr_api.g_eot)
9516: and orec.CVG_PNDG_FLAG = 'N'
9517: and not p_rslt_delete_flag
9518: and l_datetrack_mode<>hr_api.g_zap
9519: ) then
9520: --
9521: -- If Coverage started, then end the coverage by set the coverage
9522: -- thru date.
9532: p_update_change_insert => l_update_change_insert);
9533: --
9534: if l_update_override then
9535: --
9536: l_datetrack_mode := hr_api.g_update_override;
9537: --
9538: elsif l_update then
9539: --
9540: l_datetrack_mode := hr_api.g_update;
9536: l_datetrack_mode := hr_api.g_update_override;
9537: --
9538: elsif l_update then
9539: --
9540: l_datetrack_mode := hr_api.g_update;
9541:
9542: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode )*/
9543: -- l_datetrack_mode := hr_api.g_correction;
9544: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode) */
9539: --
9540: l_datetrack_mode := hr_api.g_update;
9541:
9542: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode )*/
9543: -- l_datetrack_mode := hr_api.g_correction;
9544: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode) */
9545: --
9546: else
9547: --
9544: /* Bug 2597005: Reverse changes (Update the coverages of Dependents in correction mode) */
9545: --
9546: else
9547: --
9548: l_datetrack_mode := hr_api.g_correction;
9549: --
9550:
9551: end if;
9552: if g_debug then
9595: -- to NULL and coverage flag to 'N'
9596: --
9597: l_step := 40;
9598: --
9599: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9600: l_datetrack_mode := hr_api.g_zap;
9601: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9602: l_datetrack_mode := hr_api.g_zap;
9603: Else
9596: --
9597: l_step := 40;
9598: --
9599: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9600: l_datetrack_mode := hr_api.g_zap;
9601: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9602: l_datetrack_mode := hr_api.g_zap;
9603: Else
9604: l_datetrack_mode := hr_api.g_delete;
9597: l_step := 40;
9598: --
9599: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9600: l_datetrack_mode := hr_api.g_zap;
9601: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9602: l_datetrack_mode := hr_api.g_zap;
9603: Else
9604: l_datetrack_mode := hr_api.g_delete;
9605: if g_debug then
9598: --
9599: If (p_effective_date <= nvl(orec.effective_start_date,hr_api.g_date)) then
9600: l_datetrack_mode := hr_api.g_zap;
9601: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9602: l_datetrack_mode := hr_api.g_zap;
9603: Else
9604: l_datetrack_mode := hr_api.g_delete;
9605: if g_debug then
9606: hr_utility.set_location('in dt_mode='||l_datetrack_mode,11);
9600: l_datetrack_mode := hr_api.g_zap;
9601: Elsif (p_datetrack_mode in (hr_api.g_correction, hr_api.g_zap)) then
9602: l_datetrack_mode := hr_api.g_zap;
9603: Else
9604: l_datetrack_mode := hr_api.g_delete;
9605: if g_debug then
9606: hr_utility.set_location('in dt_mode='||l_datetrack_mode,11);
9607: end if;
9608: End if;
9611: --
9612: if g_debug then
9613: hr_utility.set_location('dt_mode='||l_datetrack_mode,11);
9614: end if;
9615: if l_datetrack_mode = hr_api.g_delete and
9616: p_effective_date = orec.effective_end_date then
9617: --
9618: -- Already end dated
9619: --
9656: ,P_EFFECTIVE_START_DATE => l_pcp_future.effective_start_date
9657: ,P_EFFECTIVE_END_DATE => l_pcp_future.effective_end_date
9658: ,P_OBJECT_VERSION_NUMBER => l_pcp_future.object_version_number
9659: ,P_EFFECTIVE_DATE => l_pcp_effective_date
9660: ,P_DATETRACK_MODE => hr_api.g_zap
9661: ,p_called_from => 'delete_enrollment'
9662: );
9663: End loop;
9664: -- 3574168
9770: where prt.pgm_id = p_pgm_id
9771: and prt.person_id = p_person_id
9772: and prt.sspndd_flag = 'N' -- # 3626176
9773: and prt.prtt_enrt_rslt_stat_cd is null
9774: and prt.effective_end_date = hr_api.g_eot
9775: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
9776: and p_effective_date between
9777: prt.effective_start_date and prt.effective_end_date
9778: and prt.business_group_id = p_business_group_id
9771: and prt.person_id = p_person_id
9772: and prt.sspndd_flag = 'N' -- # 3626176
9773: and prt.prtt_enrt_rslt_stat_cd is null
9774: and prt.effective_end_date = hr_api.g_eot
9775: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
9776: and p_effective_date between
9777: prt.effective_start_date and prt.effective_end_date
9778: and prt.business_group_id = p_business_group_id
9779: and p_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
9803: and prt1.per_in_ler_id = prt.per_in_ler_id
9804: and prt1.sspndd_flag = 'Y'
9805: and p_lf_evt_ocrd_dt between
9806: prt1.effective_start_date and prt1.effective_end_date
9807: and prt1.effective_end_date = hr_api.g_eot
9808: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
9809: and prt1.prtt_enrt_rslt_stat_cd is null)))
9810: and prt.prtt_enrt_rslt_stat_cd is null
9811: and prt.effective_end_date = hr_api.g_eot
9804: and prt1.sspndd_flag = 'Y'
9805: and p_lf_evt_ocrd_dt between
9806: prt1.effective_start_date and prt1.effective_end_date
9807: and prt1.effective_end_date = hr_api.g_eot
9808: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
9809: and prt1.prtt_enrt_rslt_stat_cd is null)))
9810: and prt.prtt_enrt_rslt_stat_cd is null
9811: and prt.effective_end_date = hr_api.g_eot
9812: and prt.enrt_cvg_thru_dt = hr_api.g_eot
9807: and prt1.effective_end_date = hr_api.g_eot
9808: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
9809: and prt1.prtt_enrt_rslt_stat_cd is null)))
9810: and prt.prtt_enrt_rslt_stat_cd is null
9811: and prt.effective_end_date = hr_api.g_eot
9812: and prt.enrt_cvg_thru_dt = hr_api.g_eot
9813: and p_effective_date between
9814: prt.effective_start_date and prt.effective_end_date
9815: and prt.business_group_id = p_business_group_id
9808: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
9809: and prt1.prtt_enrt_rslt_stat_cd is null)))
9810: and prt.prtt_enrt_rslt_stat_cd is null
9811: and prt.effective_end_date = hr_api.g_eot
9812: and prt.enrt_cvg_thru_dt = hr_api.g_eot
9813: and p_effective_date between
9814: prt.effective_start_date and prt.effective_end_date
9815: and prt.business_group_id = p_business_group_id
9816: and p_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
10000: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10001: and r.per_in_ler_id <> c.per_in_ler_id
10002: and r.person_id = p_person_id
10003: and nvl(r.pgm_id,-1) = p_pgm_id
10004: and r.effective_end_date = hr_api.g_eot
10005: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10006: and r.prtt_enrt_rslt_stat_cd is null
10007: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10008: and c.elctbl_flag = 'Y'
10001: and r.per_in_ler_id <> c.per_in_ler_id
10002: and r.person_id = p_person_id
10003: and nvl(r.pgm_id,-1) = p_pgm_id
10004: and r.effective_end_date = hr_api.g_eot
10005: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10006: and r.prtt_enrt_rslt_stat_cd is null
10007: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10008: and c.elctbl_flag = 'Y'
10009: /* BUG 3939785
10011: r.ENRT_OVRID_THRU_DT < p_effective_date)
10012: */
10013: and ( r.enrt_ovridn_flag = 'N' /* Bug 3958064 */
10014: or
10015: ( r.enrt_ovridn_flag = 'Y' and nvl(r.ENRT_OVRID_THRU_DT,hr_api.g_eot) <= p_effective_date )
10016: )
10017: and oipl.oipl_id(+)=r.oipl_id
10018: and oipl.business_group_id(+)=r.business_group_id
10019: and p_effective_date between
10039: ben_oipl_f oipl
10040: Where r.per_in_ler_id <> p_per_in_ler_id
10041: and r.person_id = p_person_id
10042: and nvl(r.pgm_id,-1) = p_pgm_id
10043: and r.effective_end_date = hr_api.g_eot
10044: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10045: and r.prtt_enrt_rslt_stat_cd is null
10046: and r.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10047: /* BUG 3939785
10040: Where r.per_in_ler_id <> p_per_in_ler_id
10041: and r.person_id = p_person_id
10042: and nvl(r.pgm_id,-1) = p_pgm_id
10043: and r.effective_end_date = hr_api.g_eot
10044: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10045: and r.prtt_enrt_rslt_stat_cd is null
10046: and r.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10047: /* BUG 3939785
10048: and (r.ENRT_OVRID_THRU_DT is null or
10049: r.ENRT_OVRID_THRU_DT < p_effective_date)
10050: */
10051: and ( r.enrt_ovridn_flag = 'N' /* Bug 3958064 */
10052: or
10053: ( r.enrt_ovridn_flag = 'Y' and nvl(r.ENRT_OVRID_THRU_DT,hr_api.g_eot) <= p_effective_date )
10054: )
10055: and oipl.oipl_id(+)=r.oipl_id
10056: and oipl.business_group_id(+)=r.business_group_id
10057: and p_effective_date between
10108: and pel.pgm_id is NULL
10109: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)
10110: and pel.pl_id = r.pl_id
10111: and c.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
10112: and r.effective_end_date = hr_api.g_eot
10113: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10114: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10115: and c.elctbl_flag = 'Y'
10116: /*
10109: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)
10110: and pel.pl_id = r.pl_id
10111: and c.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
10112: and r.effective_end_date = hr_api.g_eot
10113: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10114: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10115: and c.elctbl_flag = 'Y'
10116: /*
10117: and (r.ENRT_OVRID_THRU_DT is null or
10118: r.ENRT_OVRID_THRU_DT < p_effective_date)
10119: */
10120: and ( r.enrt_ovridn_flag = 'N' /* Bug 3958064 */
10121: or
10122: ( r.enrt_ovridn_flag = 'Y' and nvl(r.ENRT_OVRID_THRU_DT,hr_api.g_eot) <= p_effective_date )
10123: )
10124: and oipl.oipl_id(+)=r.oipl_id
10125: and oipl.business_group_id(+)=r.business_group_id
10126: and p_effective_date between
10168: where pen.per_in_ler_id = p_per_in_ler_id
10169: and pen.pgm_id = p_pgm_id
10170: and pen.prtt_enrt_rslt_stat_cd is null
10171: and pen.no_lngr_elig_flag = 'Y'
10172: and pen.effective_end_date = hr_api.g_eot
10173: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10174: and pen.business_group_id = p_business_group_id;
10175: --
10176: -- For plan not in program (p_pgm_id is null)
10169: and pen.pgm_id = p_pgm_id
10170: and pen.prtt_enrt_rslt_stat_cd is null
10171: and pen.no_lngr_elig_flag = 'Y'
10172: and pen.effective_end_date = hr_api.g_eot
10173: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10174: and pen.business_group_id = p_business_group_id;
10175: --
10176: -- For plan not in program (p_pgm_id is null)
10177: --
10197: and pl_typ_id = l_pl_typ_id
10198: and pen.per_in_ler_id = p_per_in_ler_id
10199: and pen.prtt_enrt_rslt_stat_cd is null
10200: and pen.no_lngr_elig_flag = 'Y'
10201: and pen.effective_end_date = hr_api.g_eot
10202: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10203: and pen.business_group_id = p_business_group_id;
10204: --
10205: cursor c_acrs_ptip is
10198: and pen.per_in_ler_id = p_per_in_ler_id
10199: and pen.prtt_enrt_rslt_stat_cd is null
10200: and pen.no_lngr_elig_flag = 'Y'
10201: and pen.effective_end_date = hr_api.g_eot
10202: and nvl(enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10203: and pen.business_group_id = p_business_group_id;
10204: --
10205: cursor c_acrs_ptip is
10206: select acrs_ptip_cvg_id,
10238: where prt.pgm_id = p_pgm_id
10239: and prt.person_id = p_person_id
10240: and prt.sspndd_flag = 'N' -- # 3626176
10241: and prt.prtt_enrt_rslt_stat_cd is null
10242: and prt.effective_end_date = hr_api.g_eot
10243: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10244: and p_effective_date between
10245: prt.effective_start_date and prt.effective_end_date
10246: and prt.business_group_id = p_business_group_id
10239: and prt.person_id = p_person_id
10240: and prt.sspndd_flag = 'N' -- # 3626176
10241: and prt.prtt_enrt_rslt_stat_cd is null
10242: and prt.effective_end_date = hr_api.g_eot
10243: and nvl(prt.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
10244: and p_effective_date between
10245: prt.effective_start_date and prt.effective_end_date
10246: and prt.business_group_id = p_business_group_id
10247: and l_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
10271: and prt1.per_in_ler_id = prt.per_in_ler_id
10272: and prt1.sspndd_flag = 'Y'
10273: and l_lf_evt_ocrd_dt between
10274: prt1.effective_start_date and prt1.effective_end_date
10275: and prt1.effective_end_date = hr_api.g_eot
10276: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
10277: and prt1.prtt_enrt_rslt_stat_cd is null)))
10278: and prt.prtt_enrt_rslt_stat_cd is null
10279: and prt.effective_end_date = hr_api.g_eot
10272: and prt1.sspndd_flag = 'Y'
10273: and l_lf_evt_ocrd_dt between
10274: prt1.effective_start_date and prt1.effective_end_date
10275: and prt1.effective_end_date = hr_api.g_eot
10276: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
10277: and prt1.prtt_enrt_rslt_stat_cd is null)))
10278: and prt.prtt_enrt_rslt_stat_cd is null
10279: and prt.effective_end_date = hr_api.g_eot
10280: and prt.enrt_cvg_thru_dt = hr_api.g_eot
10275: and prt1.effective_end_date = hr_api.g_eot
10276: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
10277: and prt1.prtt_enrt_rslt_stat_cd is null)))
10278: and prt.prtt_enrt_rslt_stat_cd is null
10279: and prt.effective_end_date = hr_api.g_eot
10280: and prt.enrt_cvg_thru_dt = hr_api.g_eot
10281: and p_effective_date between
10282: prt.effective_start_date and prt.effective_end_date
10283: and prt.business_group_id = p_business_group_id
10276: and prt1.enrt_cvg_thru_dt = hr_api.g_eot
10277: and prt1.prtt_enrt_rslt_stat_cd is null)))
10278: and prt.prtt_enrt_rslt_stat_cd is null
10279: and prt.effective_end_date = hr_api.g_eot
10280: and prt.enrt_cvg_thru_dt = hr_api.g_eot
10281: and p_effective_date between
10282: prt.effective_start_date and prt.effective_end_date
10283: and prt.business_group_id = p_business_group_id
10284: and l_lf_evt_ocrd_dt between -- BUG 3051674 p_effective_date between
10311: Where r.pl_typ_id = p_pl_typ_id
10312: and r.per_in_ler_id = p_per_in_ler_id
10313: and r.pgm_id = p_pgm_id
10314: and r.person_id = p_person_id
10315: and r.effective_end_date = hr_api.g_eot
10316: and r.enrt_cvg_thru_dt = hr_api.g_eot
10317: and r.prtt_enrt_rslt_stat_cd is null
10318: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10319: and r.per_in_ler_id = c.per_in_ler_id
10312: and r.per_in_ler_id = p_per_in_ler_id
10313: and r.pgm_id = p_pgm_id
10314: and r.person_id = p_person_id
10315: and r.effective_end_date = hr_api.g_eot
10316: and r.enrt_cvg_thru_dt = hr_api.g_eot
10317: and r.prtt_enrt_rslt_stat_cd is null
10318: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10319: and r.per_in_ler_id = c.per_in_ler_id
10320: and c.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10490: ,p_dpnt_cvg_strt_dt_rl => l_needs_dpnts.dpnt_cvg_strt_dt_rl
10491: ,p_business_group_id => p_business_group_id
10492: ,p_ENRT_CVG_STRT_DT => l_needs_dpnts.enrt_cvg_strt_dt
10493: ,p_effective_date => p_effective_date
10494: ,p_datetrack_mode => hr_api.g_update -- note below
10495: ,p_process_dpnt => l_process_dpnt
10496: ,p_process_bnf => l_process_bnf);
10497: -- if the datetrack mode of update causes problems, then we'll need
10498: -- to pass the datetrack mode in from the form. Each enrollment
10519: ,p_effective_start_date => l_rec(i).effective_start_date
10520: ,p_effective_end_date => l_rec(i).effective_end_date
10521: ,p_object_version_number => l_rec(i).object_version_number
10522: ,p_effective_date => l_effective_date
10523: ,p_datetrack_mode => hr_api.g_delete
10524: ,p_multi_row_validate => FALSE
10525: ,p_source => 'bepenapi'
10526: );
10527: end if;
10559: ,p_effective_start_date => l_effective_start_date
10560: ,p_effective_end_date => l_effective_end_date
10561: ,p_object_version_number => rslt.object_version_number
10562: ,p_effective_date => l_effective_date
10563: ,p_datetrack_mode => hr_api.g_delete
10564: ,p_multi_row_validate => FALSE
10565: ,p_source => 'bepenapi'
10566: );
10567: --
10596: ,p_effective_start_date => l_effective_start_date
10597: ,p_effective_end_date => l_effective_end_date
10598: ,p_object_version_number => rslt.object_version_number
10599: ,p_effective_date => l_effective_date
10600: ,p_datetrack_mode => hr_api.g_delete
10601: ,p_multi_row_validate => FALSE
10602: ,p_source => 'bepenapi'
10603: );
10604: --