[Home] [Help]
332: within the plan year in the subsequent
333: life events
334: 27-Dec-02 ikasire 115.149 Bug 2677804 override thru date changes
335: 02-jan-03 hmani 115.149 Bug 2714383 - Passed pen_attributes
336: after checking whether its equalto hr_api.g_varchar2
337: Created a new function called 'decd_attribute'
338: 09-jan-03 kmahendr 115.151 Bug#2734491 - Rates with child code is treated as
339: parent for annual target.
340: 23-Jan-03 ikasire 115.152 Bug#2149438 Used the overloaded annual_to_period
980: ,p_element_link_id => null
981: ,p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id
982: ,p_rt_end_date => p_rt_strt_dt - 1
983: ,p_effective_date => p_rt_strt_dt
984: ,p_dt_delete_mode => hr_api.g_zap
985: ,p_acty_base_rt_id => l_future_prv.acty_base_rt_id
986: ,p_amt => l_future_prv.rt_val);
987: --
988: ben_prtt_rt_val_api.delete_prtt_rt_val
1017: if g_debug then
1018: hr_utility.set_location('curr prv='||l_current_prv.prtt_rt_val_id,15);
1019: end if;
1020:
1021: if l_current_prv.rt_end_dt <> hr_api.g_eot then
1022: --9614678
1023: l_prv_table(l_prv_count).prtt_rt_val_id := l_current_prv.prtt_rt_val_id;
1024: l_prv_count := l_prv_count + 1;
1025: l_found := true;
1027:
1028: ben_prtt_rt_val_api.update_prtt_rt_val
1029: (p_prtt_rt_val_id => l_current_prv.prtt_rt_val_id
1030: ,p_person_id => p_person_id
1031: ,p_rt_end_dt => hr_api.g_eot
1032: ,p_business_group_id => p_business_group_id
1033: ,p_object_version_number => l_current_prv.object_version_number
1034: ,p_effective_date => p_effective_date);
1035: --
1716: ,pen.person_id
1717: from ben_prtt_enrt_rslt_f pen
1718: ,ben_prtt_rt_val prv
1719: ,ben_acty_base_rt_f abr
1720: where pen.effective_end_date = hr_api.g_eot
1721: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1722: and pen.prtt_enrt_rslt_stat_cd is null
1723: and pen.person_id = p_person_id
1724: and pen.business_group_id = p_business_group_id
1717: from ben_prtt_enrt_rslt_f pen
1718: ,ben_prtt_rt_val prv
1719: ,ben_acty_base_rt_f abr
1720: where pen.effective_end_date = hr_api.g_eot
1721: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1722: and pen.prtt_enrt_rslt_stat_cd is null
1723: and pen.person_id = p_person_id
1724: and pen.business_group_id = p_business_group_id
1725: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
1749: and prv.rt_end_dt > c_rt_end_dt
1750: --and prv.ENDED_PER_IN_LER_ID <> c_per_in_ler_id
1751: and prv.prtt_rt_val_stat_cd is null
1752: and prv.acty_base_rt_id = c_acty_base_rt_id
1753: and prv.rt_end_dt <> hr_api.g_eot
1754: and not exists
1755: (select '1' from ben_le_clsn_n_rstr bkp
1756: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
1757: and BKUP_TBL_ID = c_prtt_rt_val_id
3480: --
3481: -- Always update per_in_ler_id and create a new rate
3482: -- when per_in_ler_id changes.
3483: --
3484: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3485: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3481: -- Always update per_in_ler_id and create a new rate
3482: -- when per_in_ler_id changes.
3483: --
3484: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3485: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3482: -- when per_in_ler_id changes.
3483: --
3484: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3485: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3483: --
3484: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3485: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3484: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3485: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3485: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3486: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3487: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3488: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3489: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3490: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3491: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3492: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3493: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3494: (nvl(l_old_rt_val,hr_api.g_number)<>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3495: nvl(l_rt_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3496: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3497: nvl(l_ann_rt_val,hr_api.g_number)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3498: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3499: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3500: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3501: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3502: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3503: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3504: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3505: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3506: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3507: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3508: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3516: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3509: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3516: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3517: nvl(p_per_in_ler_id,hr_api.g_number)) or
3510: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3516: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3517: nvl(p_per_in_ler_id,hr_api.g_number)) or
3518: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3511: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3516: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3517: nvl(p_per_in_ler_id,hr_api.g_number)) or
3518: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3519: p_bnft_amt_changed=TRUE or
3512: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3516: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3517: nvl(p_per_in_ler_id,hr_api.g_number)) or
3518: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3519: p_bnft_amt_changed=TRUE or
3520: l_element_changed ) then
3513: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3514: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3515: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3516: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3517: nvl(p_per_in_ler_id,hr_api.g_number)) or
3518: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3519: p_bnft_amt_changed=TRUE or
3520: l_element_changed ) then
3521: --
3651: if not l_non_recurring_rt then
3652: --
3653: ben_prtt_rt_val_api.update_prtt_rt_val
3654: (p_prtt_rt_val_id => p_prtt_rt_val_id
3655: ,p_rt_end_dt => hr_api.g_eot
3656: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3657: ,p_input_value_id => l_enrt_rt.input_value_id
3658: ,p_element_type_id => l_enrt_rt.element_type_id
3659: ,p_person_id => p_person_id
3882: ,p_mlt_cd => l_enrt_rt.rt_mlt_cd
3883: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
3884: ,p_rt_val => l_rt_val
3885: ,p_rt_strt_dt => l_enrt_rt.rt_strt_dt
3886: ,p_rt_end_dt => hr_api.g_eot
3887: ,p_ann_rt_val => l_ann_rt_val
3888: ,p_bnft_rt_typ_cd => l_enrt_rt.bnft_rt_typ_cd
3889: ,p_cmcd_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd
3890: ,p_cmcd_rt_val => l_enrt_rt.cmcd_val
3918: -- Check for old rate being reused, set end dt to eot.
3919: -- Re-use the rate only if the rate is continuous (maagrawa 2/24/00)
3920: --
3921: if l_old_rt_end_dt is not null and
3922: l_old_rt_end_dt <> hr_api.g_eot and
3923: l_enrt_rt.rt_strt_dt <= l_old_rt_end_dt then
3924: --
3925: if not p_calculate_only_mode then
3926: --
3930: if not l_non_recurring_rt then
3931: --
3932: ben_prtt_rt_val_api.update_prtt_rt_val
3933: (p_prtt_rt_val_id => p_prtt_rt_val_id
3934: ,p_rt_end_dt => hr_api.g_eot
3935: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3936: ,p_input_value_id => l_enrt_rt.input_value_id
3937: ,p_element_type_id => l_enrt_rt.element_type_id
3938: ,p_person_id => p_person_id
4066: ,p_mlt_cd => l_enrt_rt.rt_mlt_cd
4067: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
4068: ,p_rt_val => l_rt_val
4069: ,p_rt_strt_dt => l_enrt_rt.rt_strt_dt
4070: ,p_rt_end_dt => hr_api.g_eot
4071: ,p_ann_rt_val => l_ann_rt_val
4072: ,p_bnft_rt_typ_cd => l_enrt_rt.bnft_rt_typ_cd
4073: ,p_cmcd_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd
4074: ,p_cmcd_rt_val => l_enrt_rt.cmcd_val
4104: -- parameter end date.
4105: --
4106: if not p_calculate_only_mode and
4107: l_rt_end_dt is not null and
4108: l_rt_end_dt <> hr_api.g_eot then
4109: --
4110: if l_xrt_end_dt_cd is null then
4111: ben_determine_date.rate_and_coverage_dates
4112: (p_which_dates_cd => 'R'
4268: ,p_effective_end_date out nocopy date
4269: ,p_object_version_number in out nocopy number
4270: ,p_prtt_enrt_interim_id out nocopy number
4271: ,p_business_group_id in number
4272: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4273: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4269: ,p_object_version_number in out nocopy number
4270: ,p_prtt_enrt_interim_id out nocopy number
4271: ,p_business_group_id in number
4272: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4273: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4270: ,p_prtt_enrt_interim_id out nocopy number
4271: ,p_business_group_id in number
4272: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4273: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4271: ,p_business_group_id in number
4272: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4273: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4272: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4273: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4273: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4274: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4275: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4276: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4277: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4278: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4279: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4280: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4281: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4282: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4283: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4284: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4285: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4286: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4287: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4288: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4289: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4290: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4291: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4292: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4293: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4301: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4294: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4301: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4302: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4295: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4301: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4302: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4303: ,p_dpnt_actn_warning out nocopy boolean
4296: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4301: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4302: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4303: ,p_dpnt_actn_warning out nocopy boolean
4304: ,p_bnf_actn_warning out nocopy boolean
4297: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4301: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4302: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4303: ,p_dpnt_actn_warning out nocopy boolean
4304: ,p_bnf_actn_warning out nocopy boolean
4305: ,p_ctfn_actn_warning out nocopy boolean)
4298: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4299: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4300: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4301: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4302: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4303: ,p_dpnt_actn_warning out nocopy boolean
4304: ,p_bnf_actn_warning out nocopy boolean
4305: ,p_ctfn_actn_warning out nocopy boolean)
4306: is
4437: -- if it contains the value $Sys_Def$
4438: -- created for bug# 2714383
4439: function decd_attribute(l_attribute in varchar2) return varchar2 is
4440: begin
4441: if l_attribute = hr_api.g_varchar2 then
4442: return null;
4443: else
4444: return l_attribute;
4445: end if;
4705: ,p_effective_end_date out nocopy date
4706: ,p_object_version_number in out nocopy number
4707: ,p_prtt_enrt_interim_id out nocopy number
4708: ,p_business_group_id in number
4709: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4710: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4706: ,p_object_version_number in out nocopy number
4707: ,p_prtt_enrt_interim_id out nocopy number
4708: ,p_business_group_id in number
4709: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4710: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4707: ,p_prtt_enrt_interim_id out nocopy number
4708: ,p_business_group_id in number
4709: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4710: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4708: ,p_business_group_id in number
4709: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4710: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4709: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4710: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4710: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4711: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4712: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4713: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4714: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4715: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4716: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4717: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4718: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4719: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4720: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4721: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4722: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4723: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4724: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4725: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4726: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4727: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4728: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4729: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4730: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4738: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4731: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4738: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4739: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4732: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4738: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4739: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4740: ,p_dpnt_actn_warning out nocopy boolean
4733: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4738: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4739: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4740: ,p_dpnt_actn_warning out nocopy boolean
4741: ,p_bnf_actn_warning out nocopy boolean
4734: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4738: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4739: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4740: ,p_dpnt_actn_warning out nocopy boolean
4741: ,p_bnf_actn_warning out nocopy boolean
4742: ,p_ctfn_actn_warning out nocopy boolean
4735: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4736: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4737: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4738: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4739: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4740: ,p_dpnt_actn_warning out nocopy boolean
4741: ,p_bnf_actn_warning out nocopy boolean
4742: ,p_ctfn_actn_warning out nocopy boolean
4743: ,p_imp_cvg_strt_dt in date default NULL) -- 8716870
4916: from ben_enrt_bnft enb,
4917: ben_prtt_enrt_rslt_f pen
4918: where enb.enrt_bnft_id = p_enrt_bnft_id
4919: and enb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4920: and pen.effective_end_date = hr_api.g_eot
4921: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4922: and pen.prtt_enrt_rslt_stat_cd is NULL
4923: ;
4924: --
4917: ben_prtt_enrt_rslt_f pen
4918: where enb.enrt_bnft_id = p_enrt_bnft_id
4919: and enb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4920: and pen.effective_end_date = hr_api.g_eot
4921: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4922: and pen.prtt_enrt_rslt_stat_cd is NULL
4923: ;
4924: --
4925: -- Bug 2600087 fixes to open future dated coverage
4929: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4930: and pen.prtt_enrt_rslt_stat_cd is null
4931: and pen.effective_end_date = (select pen2.effective_start_date - 1
4932: from ben_prtt_enrt_rslt_f pen2
4933: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4934: and pen2.effective_end_date = hr_api.g_eot
4935: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4936: and pen2.prtt_enrt_rslt_stat_cd is null);
4937:
4930: and pen.prtt_enrt_rslt_stat_cd is null
4931: and pen.effective_end_date = (select pen2.effective_start_date - 1
4932: from ben_prtt_enrt_rslt_f pen2
4933: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4934: and pen2.effective_end_date = hr_api.g_eot
4935: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4936: and pen2.prtt_enrt_rslt_stat_cd is null);
4937:
4938:
4955: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4956: and pen.prtt_enrt_rslt_stat_cd is null
4957: and pen.effective_end_date = (select pen2.effective_start_date - 1
4958: from ben_prtt_enrt_rslt_f pen2
4959: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4960: and pen2.effective_end_date = hr_api.g_eot
4961: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4962: and pen2.prtt_enrt_rslt_stat_cd is null)
4963: and not exists
4956: and pen.prtt_enrt_rslt_stat_cd is null
4957: and pen.effective_end_date = (select pen2.effective_start_date - 1
4958: from ben_prtt_enrt_rslt_f pen2
4959: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4960: and pen2.effective_end_date = hr_api.g_eot
4961: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4962: and pen2.prtt_enrt_rslt_stat_cd is null)
4963: and not exists
4964: (select '1' from ben_le_clsn_n_rstr bkp where
4975: select pen.*
4976: from ben_prtt_enrt_rslt_f pen
4977: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4978: and pen.prtt_enrt_rslt_stat_cd is null
4979: and pen.effective_end_date = hr_api.g_eot;
4980: --
4981: l_enrt_rslt2 c_enrt_rslt2%rowtype;
4982: --
4983: -- 5612091 - Added OR condition with p_elig_per_elctbl_chc_id
5002: select pdp.*
5003: from ben_elig_cvrd_dpnt_f pdp
5004: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5005: and pdp.cvg_thru_dt is not null
5006: and pdp.effective_end_date <> hr_api.g_eot
5007: and p_effective_date
5008: between pdp.effective_start_date
5009: and pdp.effective_end_date;
5010: --
5071: from ben_prtt_enrt_rslt_f pen
5072: where pen.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
5073: and p_effective_date between
5074: pen.effective_start_date and pen.effective_end_date
5075: and pen.effective_end_date <> hr_api.g_eot
5076: and pen.per_in_ler_id <> p_per_in_ler_id -- 12583091
5077: and pen.prtt_enrt_rslt_stat_cd is null
5078: and pen.business_group_id = p_business_group_id
5079: order by pen.effective_start_date desc ;
5110: and nvl(epe.oipl_id, -1) = nvl(pen.oipl_id, -1)
5111: and pen.per_in_ler_id = p_per_in_ler_id
5112: and pen.prtt_enrt_rslt_stat_cd is null
5113: and pen.business_group_id = p_business_group_id
5114: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
5115: and pen.effective_end_date = hr_api.g_eot;
5116: --
5117: l_ended_pen c_get_ended_result%rowtype;
5118: --
5111: and pen.per_in_ler_id = p_per_in_ler_id
5112: and pen.prtt_enrt_rslt_stat_cd is null
5113: and pen.business_group_id = p_business_group_id
5114: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
5115: and pen.effective_end_date = hr_api.g_eot;
5116: --
5117: l_ended_pen c_get_ended_result%rowtype;
5118: --
5119: -- end 12421421
5289: from ben_prtt_enrt_rslt_f pen
5290: ,ben_ptip_f ptip
5291: ,ben_per_in_ler pil
5292: ,ben_elig_per_elctbl_chc epe
5293: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
5294: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
5295: and pen.prtt_enrt_rslt_stat_cd is null
5296: and pen.person_id = pil.person_id -- 318321
5297: and pen.business_group_id = p_business_group_id -- 81545
5290: ,ben_ptip_f ptip
5291: ,ben_per_in_ler pil
5292: ,ben_elig_per_elctbl_chc epe
5293: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
5294: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
5295: and pen.prtt_enrt_rslt_stat_cd is null
5296: and pen.person_id = pil.person_id -- 318321
5297: and pen.business_group_id = p_business_group_id -- 81545
5298: and pen.ptip_id = p_ptip_id -- 54444
5344: AND bkup.person_id = p_person_id
5345: AND bkup.business_group_id = p_business_group_id
5346: AND bkup.effective_start_date = p_esd
5347: AND bkup.enrt_cvg_strt_dt = p_csd
5348: AND bkup.effective_end_date = hr_api.g_eot
5349: AND bkup.enrt_cvg_thru_dt = hr_api.g_eot;
5350:
5351: l_bkup_pen_rec c_bkup_pen_rec%rowtype;
5352: l_pil_id number;
5345: AND bkup.business_group_id = p_business_group_id
5346: AND bkup.effective_start_date = p_esd
5347: AND bkup.enrt_cvg_strt_dt = p_csd
5348: AND bkup.effective_end_date = hr_api.g_eot
5349: AND bkup.enrt_cvg_thru_dt = hr_api.g_eot;
5350:
5351: l_bkup_pen_rec c_bkup_pen_rec%rowtype;
5352: l_pil_id number;
5353:
5394: AND nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
5395: AND pen.pl_id = p_pl_id
5396: AND Nvl(pen.oipl_id ,-1) = nvl(p_oipl_id,-1)
5397: AND pen.business_group_id = p_business_group_id
5398: and pen.enrt_cvg_thru_dt = hr_api.g_eot
5399: AND pen.prtt_enrt_rslt_stat_cd IS NULL
5400: AND EXISTS(SELECT NULL
5401: FROM ben_prtt_enrt_rslt_f pen2
5402: WHERE pen2.per_in_ler_id = pen.per_in_ler_id
5402: WHERE pen2.per_in_ler_id = pen.per_in_ler_id
5403: AND pen2.rplcs_sspndd_rslt_id = pen.prtt_enrt_rslt_id
5404: AND pen2.sspndd_flag = 'Y'
5405: AND pen2.prtt_enrt_rslt_stat_cd IS NULL
5406: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
5407: AND pen2.business_group_id = pen.business_group_id);
5408: l_check_int_enr c_check_int_enr%rowtype;
5409:
5410: l_yenrt_cvg_strt_dt_cd varchar2(30);
5845: p_effective_start_date => l_effective_start_date,
5846: p_effective_end_date => l_effective_end_date,
5847: p_object_version_number => l_pen_curr.object_version_number,
5848: p_effective_date => l_pen_curr.effective_end_date,
5849: p_datetrack_mode => hr_api.g_future_change,
5850: p_multi_row_validate => FALSE);
5851: --
5852: for l_rec in c_prv(l_pen_curr.prtt_enrt_rslt_id,l_pen_curr.per_in_ler_id) loop
5853: --
5881: p_person_id => l_global_pil_rec.person_id,
5882: p_business_group_id => p_business_group_id,
5883: p_prtt_rt_val_id => l_rec.prtt_rt_val_id,
5884: p_rt_strt_dt => nvl(l_ecr.rt_strt_dt,l_rec.rt_strt_dt),
5885: p_rt_end_dt => hr_api.g_eot,
5886: p_object_version_number => l_rec.object_version_number,
5887: p_effective_date => p_effective_date );
5888: --
5889: end loop;
5911: p_effective_start_date => l_effective_start_date,
5912: p_effective_end_date => l_effective_end_date,
5913: p_object_version_number => l_pen_curr_interim.object_version_number,
5914: p_effective_date => l_pen_curr_interim.effective_end_date,
5915: p_datetrack_mode => hr_api.g_future_change,
5916: p_multi_row_validate => FALSE);
5917: END IF;
5918: --
5919: -- 6057157 : Reset the Rate End to EOT, as PEN records are done similarly above.
5928: (p_validate => false,
5929: p_person_id => l_global_pil_rec.person_id,
5930: p_business_group_id => p_business_group_id,
5931: p_prtt_rt_val_id => l_rec.prtt_rt_val_id,
5932: p_rt_end_dt => hr_api.g_eot,
5933: p_object_version_number => l_rec.object_version_number,
5934: p_effective_date => p_effective_date );
5935: --
5936: end loop;
6008: if ( p_prtt_enrt_rslt_id is not null and
6009: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6010: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
6011: (( ben_sspndd_enrollment.g_use_new_result=false and
6012: nvl(l_old_bnft_val,hr_api.g_number)=
6013: nvl(l_global_enb_rec.val,hr_api.g_number)) or
6014: l_old_sspndd_flag = 'Y')) then
6015: if g_debug then
6016: hr_utility.set_location('enrt cvg strt dt'||l_global_epe_rec.enrt_cvg_strt_dt,111);
6009: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6010: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
6011: (( ben_sspndd_enrollment.g_use_new_result=false and
6012: nvl(l_old_bnft_val,hr_api.g_number)=
6013: nvl(l_global_enb_rec.val,hr_api.g_number)) or
6014: l_old_sspndd_flag = 'Y')) then
6015: if g_debug then
6016: hr_utility.set_location('enrt cvg strt dt'||l_global_epe_rec.enrt_cvg_strt_dt,111);
6017: end if;
6035: -- result instead of updating the suspended flag on the current enrollment.
6036: -- The benefit amount did not change.
6037: --
6038: elsif ((l_global_enb_rec.val is not null and
6039: l_global_enb_rec.val = nvl(l_old_bnft_val, hr_api.g_number)) and
6040: l_global_epe_rec.ctfn_rqd_flag = 'Y' and
6041: l_old_sspndd_flag = 'N') then
6042: l_start_new_result := true;
6043: hr_utility.set_location('start new result.',8086.1);
6095: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6096: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
6097: -- l_use_new_result=false and
6098: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
6099: nvl(l_old_bnft_val,hr_api.g_number)= nvl(l_global_enb_rec.val,hr_api.g_number) and
6100: p_enrt_cvg_thru_dt is null and
6101: l_start_new_result = false ) then
6102: if g_debug then
6103: hr_utility.set_location(l_proc, 80);
6372: p_effective_start_date => l_effective_start_date,
6373: p_effective_end_date => l_effective_end_date,
6374: p_object_version_number => l_enrt_rslt.object_version_number,
6375: p_effective_date => l_enrt_rslt.effective_end_date,
6376: p_datetrack_mode => hr_api.g_future_change,
6377: p_multi_row_validate => FALSE);
6378: p_object_version_number := l_enrt_rslt.object_version_number;
6379: --
6380: -- Bug 5766477 Also re-open dependent coverage.
6387: p_effective_end_date => l_effective_end_date,
6388: p_object_version_number => l_dpnt_rec.object_version_number,
6389: p_business_group_id => p_business_group_id,
6390: p_effective_date => l_enrt_rslt.effective_end_date,
6391: p_datetrack_mode => hr_api.g_future_change,
6392: p_multi_row_actn => FALSE);
6393: end loop;
6394:
6395: if (g_debug) then
6494: ,p_old_oipl_id => l_old_oipl_id
6495: ,p_old_bnft_amt => l_old_bnft_val
6496: ,p_bnft_amt => l_global_enb_rec.val
6497: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
6498: ,p_enrt_cvg_end_dt => hr_api.g_eot
6499: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
6500: ,p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
6501: ,p_person_id => l_global_pil_rec.person_id
6502: ,p_business_group_id => l_global_epe_rec.business_group_id
6509: ,p_effective_start_date => p_effective_start_date
6510: ,p_effective_end_date => p_effective_end_date
6511: ,p_enrt_mthd_cd => p_enrt_mthd_cd
6512: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
6513: ,p_enrt_cvg_thru_dt => hr_api.g_eot
6514: ,p_enrt_ovrid_thru_dt => l_old_enrt_ovrid_thru_dt
6515: ,p_enrt_ovrid_rsn_cd => l_old_enrt_ovrid_rsn_cd
6516: ,p_enrt_ovridn_flag => l_old_enrt_ovridn_flag
6517: ,p_object_version_number => p_object_version_number
6655: l_global_epe_rec.prtt_enrt_rslt_id is not null and
6656: l_crntly_enrd_rslt_exists and
6657: -- l_use_new_result=false and
6658: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
6659: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6660: nvl(l_global_enb_rec.val,hr_api.g_number) and
6661: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
6662: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6663: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
6656: l_crntly_enrd_rslt_exists and
6657: -- l_use_new_result=false and
6658: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
6659: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6660: nvl(l_global_enb_rec.val,hr_api.g_number) and
6661: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
6662: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6663: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
6664: hr_api.g_number)) and
6658: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
6659: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6660: nvl(l_global_enb_rec.val,hr_api.g_number) and
6661: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
6662: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6663: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
6664: hr_api.g_number)) and
6665: */
6666: l_start_new_result = false and
6660: nvl(l_global_enb_rec.val,hr_api.g_number) and
6661: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
6662: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
6663: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
6664: hr_api.g_number)) and
6665: */
6666: l_start_new_result = false and
6667: l_global_epe_rec.enrt_cvg_strt_dt = l_crntly_enrd_rslt_rec.enrt_cvg_strt_dt then --BUG 4568911
6668: -- RCHASE Bug#5353 alteration
6665: */
6666: l_start_new_result = false and
6667: l_global_epe_rec.enrt_cvg_strt_dt = l_crntly_enrd_rslt_rec.enrt_cvg_strt_dt then --BUG 4568911
6668: -- RCHASE Bug#5353 alteration
6669: -- nvl(l_global_enb_rec.val,hr_api.g_number) then
6670: --
6671: -- If they are not staying in the same plan and option
6672: -- and ELIG PER ELCTBL CHC: CRNTLY ENRD FLAG = Y then
6673: -- re-use the enrollment result.
6736: p_effective_start_date => l_effective_start_date,
6737: p_effective_end_date => l_effective_end_date,
6738: p_object_version_number => l_get_prev_pil_enrt.object_version_number,
6739: p_effective_date => l_get_prev_pil_enrt.effective_start_date,
6740: p_datetrack_mode => hr_api.g_future_change,
6741: p_multi_row_validate => FALSE);
6742:
6743: ---Refetch the enrollment result for the Object version number.
6744: open c_get_ovn(l_check_enrt_same_pil.prtt_enrt_rslt_id,l_prev_pil.per_in_ler_id,l_get_prev_pil_enrt.effective_start_date);
6790: ,p_effective_start_date => p_effective_start_date
6791: ,p_effective_end_date => p_effective_end_date
6792: ,p_enrt_mthd_cd => p_enrt_mthd_cd
6793: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
6794: ,p_enrt_cvg_thru_dt => hr_api.g_eot
6795: ,p_enrt_ovrid_thru_dt => l_crntly_enrd_rslt_rec.enrt_ovrid_thru_dt
6796: ,p_enrt_ovrid_rsn_cd => l_crntly_enrd_rslt_rec.enrt_ovrid_rsn_cd
6797: ,p_enrt_ovridn_flag => l_crntly_enrd_rslt_rec.enrt_ovridn_flag
6798: ,p_object_version_number => l_object_version_number
6885: p_business_group_id => p_business_group_id,
6886: p_RPLCS_SSPNDD_RSLT_ID => null,
6887: p_object_version_number => l_delink_interim.object_version_number,
6888: p_effective_date => p_effective_date,
6889: p_datetrack_mode => hr_api.g_correction,
6890: p_multi_row_validate => FALSE,
6891: p_program_application_id => fnd_global.prog_appl_id,
6892: p_program_id => fnd_global.conc_program_id,
6893: p_request_id => fnd_global.conc_request_id,
6966: --- l_old_erlst_deenrt_dt is decide the previous enrolment
6967: -- bal_epe_rec.epe.erlst_deenrt_dt decide the whether erlst_deenrt_dt is to be calc
6968: if l_old_erlst_deenrt_dt is null and
6969: l_global_epe_rec.erlst_deenrt_dt is not null and
6970: nvl(l_elect_cvg_strt_dt,hr_api.g_eot)
6971: <> l_global_epe_rec.enrt_cvg_strt_dt then
6972: if g_debug then
6973: hr_utility.set_location('CALLINGH ERLST DATE ' , 8086.1);
6974: end if;
7024: end if; -- date is null
7025: if g_debug then
7026: hr_utility.set_location(l_proc, 170);
7027: end if;
7028: if (nvl(l_old_bnft_val,hr_api.g_number)<>
7029: nvl(l_global_enb_rec.val,hr_api.g_number)
7030: -- Bug#1807450 added and condition
7031: and p_prtt_enrt_rslt_id is not null) or
7032: -- Added for Interim Coverage /*ENH*/
7025: if g_debug then
7026: hr_utility.set_location(l_proc, 170);
7027: end if;
7028: if (nvl(l_old_bnft_val,hr_api.g_number)<>
7029: nvl(l_global_enb_rec.val,hr_api.g_number)
7030: -- Bug#1807450 added and condition
7031: and p_prtt_enrt_rslt_id is not null) or
7032: -- Added for Interim Coverage /*ENH*/
7033: ben_sspndd_enrollment.g_use_new_result or
7134: --
7135: -- unrestricted changes
7136:
7137: if p_prtt_enrt_rslt_id is not null then
7138: l_datetrack_mode := hr_api.g_update;
7139: else
7140: l_datetrack_mode := p_datetrack_mode;
7141: end if;
7142: -- Bug 2172036 pass assignment_id also to create pen
7217: p_object_version_number => l_get_enrt_rslts_for_pen.object_version_number,
7218: p_effective_date => l_get_enrt_rslts_for_pen.effective_start_date,--p_effective_date,
7219: /*Bug 9057101: Instead of passing p_effective_date, pass
7220: effective start date of the pen_id*/
7221: p_datetrack_mode => hr_api.g_correction,
7222: p_multi_row_validate => FALSE,
7223: p_enrt_cvg_thru_dt => l_global_epe_rec.enrt_cvg_strt_dt - 1 -- Bug 8507247
7224: );
7225: end loop; -- c_get_enrt_rslts_for_pen
7267: p_effective_end_date => l_effective_end_date,
7268: p_business_group_id => p_business_group_id,
7269: p_object_version_number => l_get_enrt_rslts_for_pen.object_version_number,
7270: p_effective_date => l_get_enrt_rslts_for_pen.effective_start_date,--p_effective_date,
7271: p_datetrack_mode => hr_api.g_correction,
7272: p_multi_row_validate => FALSE,
7273: p_enrt_cvg_thru_dt => l_global_epe_rec.enrt_cvg_strt_dt - 1
7274: );
7275: end loop; -- c_get_enrt_rslts_for_pen
7451: ,p_old_oipl_id => l_old_oipl_id
7452: ,p_old_bnft_amt => l_old_bnft_val
7453: ,p_bnft_amt => l_global_enb_rec.val
7454: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
7455: ,p_enrt_cvg_end_dt => hr_api.g_eot --?
7456: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
7457: ,p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
7458: ,p_person_id => l_global_pil_rec.person_id
7459: ,p_business_group_id => l_global_epe_rec.business_group_id
7974: --
7975: -- If the result was created in the same run, then the mode will be insert.
7976: -- In this case, we can only do update in correction mode.
7977: --
7978: if p_datetrack_mode = hr_api.g_insert then
7979: l_datetrack_mode := hr_api.g_correction;
7980: else
7981: l_datetrack_mode := p_datetrack_mode;
7982: end if;
7975: -- If the result was created in the same run, then the mode will be insert.
7976: -- In this case, we can only do update in correction mode.
7977: --
7978: if p_datetrack_mode = hr_api.g_insert then
7979: l_datetrack_mode := hr_api.g_correction;
7980: else
7981: l_datetrack_mode := p_datetrack_mode;
7982: end if;
7983: --
8018: --
8019: -- When in validation only mode raise the Validate_Enabled exception
8020: --
8021: if p_validate then
8022: raise hr_api.validate_enabled;
8023: end if;
8024:
8025: if g_debug then
8026: hr_utility.set_location('Leaving:'||l_proc, 999);
8027: end if;
8028:
8029: exception
8030: --
8031: when hr_api.validate_enabled then
8032: --
8033: -- As the Validate_Enabled exception has been raised
8034: -- we must rollback to the savepoint
8035: --
8453: if p_validate = 'Y' then
8454: l_validate := true;
8455: end if;
8456: --
8457: if l_datetrack_mode = hr_api.g_correction then
8458: if p_effective_date = p_effective_start_date then
8459: null;
8460: else
8461: l_datetrack_mode := hr_api.g_update;
8457: if l_datetrack_mode = hr_api.g_correction then
8458: if p_effective_date = p_effective_start_date then
8459: null;
8460: else
8461: l_datetrack_mode := hr_api.g_update;
8462: end if;
8463: end if;
8464: --
8465: ben_env_object.init(p_business_group_id => p_business_group_id,