eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELECTION_INFORMATION dependencies on HR_API

Line 336: after checking whether its equalto hr_api.g_varchar2

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

Line 882: if l_current_prv.rt_end_dt <> hr_api.g_eot then

878: if g_debug then
879: hr_utility.set_location('curr prv='||l_current_prv.prtt_rt_val_id,15);
880: end if;
881:
882: if l_current_prv.rt_end_dt <> hr_api.g_eot then
883: --
884: ben_prtt_rt_val_api.update_prtt_rt_val
885: (p_prtt_rt_val_id => l_current_prv.prtt_rt_val_id
886: ,p_person_id => p_person_id

Line 887: ,p_rt_end_dt => hr_api.g_eot

883: --
884: ben_prtt_rt_val_api.update_prtt_rt_val
885: (p_prtt_rt_val_id => l_current_prv.prtt_rt_val_id
886: ,p_person_id => p_person_id
887: ,p_rt_end_dt => hr_api.g_eot
888: ,p_business_group_id => p_business_group_id
889: ,p_object_version_number => l_current_prv.object_version_number
890: ,p_effective_date => p_effective_date);
891: --

Line 1424: where pen.effective_end_date = hr_api.g_eot

1420: ,pen.person_id
1421: from ben_prtt_enrt_rslt_f pen
1422: ,ben_prtt_rt_val prv
1423: ,ben_acty_base_rt_f abr
1424: where pen.effective_end_date = hr_api.g_eot
1425: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1426: and pen.prtt_enrt_rslt_stat_cd is null
1427: and pen.person_id = p_person_id
1428: and pen.business_group_id = p_business_group_id

Line 1425: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

1421: from ben_prtt_enrt_rslt_f pen
1422: ,ben_prtt_rt_val prv
1423: ,ben_acty_base_rt_f abr
1424: where pen.effective_end_date = hr_api.g_eot
1425: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1426: and pen.prtt_enrt_rslt_stat_cd is null
1427: and pen.person_id = p_person_id
1428: and pen.business_group_id = p_business_group_id
1429: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 3061: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>

3057: --
3058: -- Always update per_in_ler_id and create a new rate
3059: -- when per_in_ler_id changes.
3060: --
3061: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>

Line 3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or

3058: -- Always update per_in_ler_id and create a new rate
3059: -- when per_in_ler_id changes.
3060: --
3061: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or

Line 3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>

3059: -- when per_in_ler_id changes.
3060: --
3061: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>

Line 3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or

3060: --
3061: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or

Line 3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>

3061: if ((nvl(l_old_rt_typ_cd,hr_api.g_varchar2)<>
3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>

Line 3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or

3062: nvl(l_enrt_rt.rt_typ_cd,hr_api.g_varchar2)) or
3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or

Line 3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>

3063: (nvl(l_old_tx_typ_cd,hr_api.g_varchar2)<>
3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>

Line 3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or

3064: nvl(l_enrt_rt.tx_typ_cd,hr_api.g_varchar2)) or
3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or

Line 3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>

3065: (nvl(l_old_acty_typ_cd,hr_api.g_varchar2)<>
3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>

Line 3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or

3066: nvl(l_enrt_rt.acty_typ_cd,hr_api.g_varchar2)) or
3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or

Line 3071: (nvl(l_old_rt_val,hr_api.g_number)<>

3067: (nvl(l_old_mlt_cd,hr_api.g_varchar2)<>
3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>

Line 3072: nvl(l_rt_val,hr_api.g_number)) or

3068: nvl(l_enrt_rt.rt_mlt_cd,hr_api.g_varchar2)) or
3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or

Line 3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>

3069: (nvl(l_old_acty_ref_perd_cd,hr_api.g_varchar2)<>
3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>

Line 3074: nvl(l_ann_rt_val,hr_api.g_number)) or

3070: nvl(p_acty_ref_perd_cd,hr_api.g_varchar2)) or
3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or

Line 3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>

3071: (nvl(l_old_rt_val,hr_api.g_number)<>
3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>

Line 3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or

3072: nvl(l_rt_val,hr_api.g_number)) or
3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or

Line 3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>

3073: (nvl(l_old_ann_rt_val,hr_api.g_number) <>
3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>

Line 3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or

3074: nvl(l_ann_rt_val,hr_api.g_number)) or
3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or

Line 3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>

3075: (nvl(l_old_bnft_rt_typ_cd,hr_api.g_varchar2) <>
3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>

Line 3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or

3076: nvl(l_enrt_rt.bnft_rt_typ_cd,hr_api.g_varchar2)) or
3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or

Line 3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>

3077: (nvl(l_old_cmcd_ref_perd_cd,hr_api.g_varchar2) <>
3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>

Line 3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or

3078: nvl(l_enrt_rt.cmcd_acty_ref_perd_cd,hr_api.g_varchar2)) or
3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or

Line 3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>

3079: (nvl(l_old_cmcd_rt_val,hr_api.g_number) <>
3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>

Line 3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or

3080: nvl(l_enrt_rt.cmcd_val,hr_api.g_number)) or
3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or

Line 3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>

3081: (nvl(l_old_dsply_on_enrt_flag,hr_api.g_varchar2) <>
3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>

Line 3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or

3082: nvl(l_enrt_rt.dsply_on_enrt_flag,hr_api.g_varchar2)) or
3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or

Line 3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>

3083: (nvl(l_old_cvg_amt_calc_mthd_id,hr_api.g_number) <>
3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>

Line 3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or

3084: nvl(l_enrt_rt.cvg_amt_calc_mthd_id,hr_api.g_number)) or
3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or

Line 3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>

3085: (nvl(l_old_actl_prem_id,hr_api.g_number) <>
3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>

Line 3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or

3086: nvl(l_enrt_rt.actl_prem_id,hr_api.g_number)) or
3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3094: nvl(p_per_in_ler_id,hr_api.g_number)) or

Line 3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>

3087: (nvl(l_old_comp_lvl_fctr_id,hr_api.g_number) <>
3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3094: nvl(p_per_in_ler_id,hr_api.g_number)) or
3095: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */

Line 3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or

3088: nvl(l_enrt_rt.comp_lvl_fctr_id,hr_api.g_number)) or
3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3094: nvl(p_per_in_ler_id,hr_api.g_number)) or
3095: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3096: p_bnft_amt_changed=TRUE or

Line 3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>

3089: (nvl(l_old_prtt_enrt_rslt_id,hr_api.g_number) <>
3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3094: nvl(p_per_in_ler_id,hr_api.g_number)) or
3095: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3096: p_bnft_amt_changed=TRUE or
3097: l_element_changed ) then

Line 3094: nvl(p_per_in_ler_id,hr_api.g_number)) or

3090: nvl(p_prtt_enrt_rslt_id,hr_api.g_number)) or
3091: (nvl(l_old_rt_strt_dt,hr_api.g_date) <>
3092: nvl(l_enrt_rt.rt_strt_dt,hr_api.g_date)) or
3093: (nvl(l_old_per_in_ler_id,hr_api.g_number) <>
3094: nvl(p_per_in_ler_id,hr_api.g_number)) or
3095: l_global_pen_rec.sspndd_flag = 'Y' or /*4775760 */
3096: p_bnft_amt_changed=TRUE or
3097: l_element_changed ) then
3098: --

Line 3220: ,p_rt_end_dt => hr_api.g_eot

3216: if not l_non_recurring_rt then
3217: --
3218: ben_prtt_rt_val_api.update_prtt_rt_val
3219: (p_prtt_rt_val_id => p_prtt_rt_val_id
3220: ,p_rt_end_dt => hr_api.g_eot
3221: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3222: ,p_input_value_id => l_enrt_rt.input_value_id
3223: ,p_element_type_id => l_enrt_rt.element_type_id
3224: ,p_person_id => p_person_id

Line 3403: ,p_rt_end_dt => hr_api.g_eot

3399: ,p_mlt_cd => l_enrt_rt.rt_mlt_cd
3400: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
3401: ,p_rt_val => l_rt_val
3402: ,p_rt_strt_dt => l_enrt_rt.rt_strt_dt
3403: ,p_rt_end_dt => hr_api.g_eot
3404: ,p_ann_rt_val => l_ann_rt_val
3405: ,p_bnft_rt_typ_cd => l_enrt_rt.bnft_rt_typ_cd
3406: ,p_cmcd_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd
3407: ,p_cmcd_rt_val => l_enrt_rt.cmcd_val

Line 3439: l_old_rt_end_dt <> hr_api.g_eot and

3435: -- Check for old rate being reused, set end dt to eot.
3436: -- Re-use the rate only if the rate is continuous (maagrawa 2/24/00)
3437: --
3438: if l_old_rt_end_dt is not null and
3439: l_old_rt_end_dt <> hr_api.g_eot and
3440: l_enrt_rt.rt_strt_dt <= l_old_rt_end_dt then
3441: --
3442: if not p_calculate_only_mode then
3443: --

Line 3451: ,p_rt_end_dt => hr_api.g_eot

3447: if not l_non_recurring_rt then
3448: --
3449: ben_prtt_rt_val_api.update_prtt_rt_val
3450: (p_prtt_rt_val_id => p_prtt_rt_val_id
3451: ,p_rt_end_dt => hr_api.g_eot
3452: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3453: ,p_input_value_id => l_enrt_rt.input_value_id
3454: ,p_element_type_id => l_enrt_rt.element_type_id
3455: ,p_person_id => p_person_id

Line 3573: ,p_rt_end_dt => hr_api.g_eot

3569: ,p_mlt_cd => l_enrt_rt.rt_mlt_cd
3570: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd
3571: ,p_rt_val => l_rt_val
3572: ,p_rt_strt_dt => l_enrt_rt.rt_strt_dt
3573: ,p_rt_end_dt => hr_api.g_eot
3574: ,p_ann_rt_val => l_ann_rt_val
3575: ,p_bnft_rt_typ_cd => l_enrt_rt.bnft_rt_typ_cd
3576: ,p_cmcd_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd
3577: ,p_cmcd_rt_val => l_enrt_rt.cmcd_val

Line 3611: l_rt_end_dt <> hr_api.g_eot then

3607: -- parameter end date.
3608: --
3609: if not p_calculate_only_mode and
3610: l_rt_end_dt is not null and
3611: l_rt_end_dt <> hr_api.g_eot then
3612: --
3613: if l_xrt_end_dt_cd is null then
3614: ben_determine_date.rate_and_coverage_dates
3615: (p_which_dates_cd => 'R'

Line 3775: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2

3771: ,p_effective_end_date out nocopy date
3772: ,p_object_version_number in out nocopy number
3773: ,p_prtt_enrt_interim_id out nocopy number
3774: ,p_business_group_id in number
3775: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2

Line 3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2

3772: ,p_object_version_number in out nocopy number
3773: ,p_prtt_enrt_interim_id out nocopy number
3774: ,p_business_group_id in number
3775: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2

Line 3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2

3773: ,p_prtt_enrt_interim_id out nocopy number
3774: ,p_business_group_id in number
3775: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2

Line 3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2

3774: ,p_business_group_id in number
3775: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2

Line 3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2

3775: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2

Line 3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2

3776: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2

Line 3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2

3777: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2

Line 3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2

3778: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2

Line 3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2

3779: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2

Line 3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2

3780: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2

Line 3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2

3781: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2

Line 3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2

3782: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2

Line 3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2

3783: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2

Line 3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2

3784: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2

Line 3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2

3785: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2

Line 3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2

3786: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2

Line 3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2

3787: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2

Line 3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2

3788: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2

Line 3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2

3789: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2

Line 3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2

3790: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2

Line 3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2

3791: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2

Line 3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2

3792: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2

Line 3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2

3793: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2

Line 3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2

3794: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2

Line 3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2

3795: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2

Line 3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2

3796: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2

Line 3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2

3797: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
3805: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2

Line 3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2

3798: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
3805: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
3806: ,p_dpnt_actn_warning out nocopy boolean

Line 3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2

3799: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
3805: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
3806: ,p_dpnt_actn_warning out nocopy boolean
3807: ,p_bnf_actn_warning out nocopy boolean

Line 3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2

3800: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
3805: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
3806: ,p_dpnt_actn_warning out nocopy boolean
3807: ,p_bnf_actn_warning out nocopy boolean
3808: ,p_ctfn_actn_warning out nocopy boolean)

Line 3805: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2

3801: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
3802: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
3803: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
3804: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
3805: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
3806: ,p_dpnt_actn_warning out nocopy boolean
3807: ,p_bnf_actn_warning out nocopy boolean
3808: ,p_ctfn_actn_warning out nocopy boolean)
3809: is

Line 3944: if l_attribute = hr_api.g_varchar2 then

3940: -- if it contains the value $Sys_Def$
3941: -- created for bug# 2714383
3942: function decd_attribute(l_attribute in varchar2) return varchar2 is
3943: begin
3944: if l_attribute = hr_api.g_varchar2 then
3945: return null;
3946: else
3947: return l_attribute;
3948: end if;

Line 4212: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2

4208: ,p_effective_end_date out nocopy date
4209: ,p_object_version_number in out nocopy number
4210: ,p_prtt_enrt_interim_id out nocopy number
4211: ,p_business_group_id in number
4212: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2

Line 4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2

4209: ,p_object_version_number in out nocopy number
4210: ,p_prtt_enrt_interim_id out nocopy number
4211: ,p_business_group_id in number
4212: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2

Line 4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2

4210: ,p_prtt_enrt_interim_id out nocopy number
4211: ,p_business_group_id in number
4212: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2

Line 4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2

4211: ,p_business_group_id in number
4212: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2

Line 4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2

4212: ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2

Line 4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2

4213: ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2

Line 4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2

4214: ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2

Line 4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2

4215: ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2

Line 4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2

4216: ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2

Line 4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2

4217: ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2

Line 4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2

4218: ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2

Line 4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2

4219: ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2

Line 4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2

4220: ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2

Line 4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2

4221: ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2

Line 4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2

4222: ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2

Line 4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2

4223: ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2

Line 4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2

4224: ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2

Line 4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2

4225: ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2

Line 4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2

4226: ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2

Line 4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2

4227: ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2

Line 4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2

4228: ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2

Line 4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2

4229: ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2

Line 4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2

4230: ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2

Line 4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2

4231: ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2

Line 4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2

4232: ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2

Line 4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2

4233: ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2

Line 4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2

4234: ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2

Line 4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2

4235: ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4243: ,p_dpnt_actn_warning out nocopy boolean

Line 4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2

4236: ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4243: ,p_dpnt_actn_warning out nocopy boolean
4244: ,p_bnf_actn_warning out nocopy boolean

Line 4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2

4237: ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4243: ,p_dpnt_actn_warning out nocopy boolean
4244: ,p_bnf_actn_warning out nocopy boolean
4245: ,p_ctfn_actn_warning out nocopy boolean)

Line 4242: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2

4238: ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
4239: ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
4240: ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
4241: ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
4242: ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
4243: ,p_dpnt_actn_warning out nocopy boolean
4244: ,p_bnf_actn_warning out nocopy boolean
4245: ,p_ctfn_actn_warning out nocopy boolean)
4246: is

Line 4422: and pen.effective_end_date = hr_api.g_eot

4418: from ben_enrt_bnft enb,
4419: ben_prtt_enrt_rslt_f pen
4420: where enb.enrt_bnft_id = p_enrt_bnft_id
4421: and enb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4422: and pen.effective_end_date = hr_api.g_eot
4423: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4424: and pen.prtt_enrt_rslt_stat_cd is NULL
4425: ;
4426: --

Line 4423: and pen.enrt_cvg_thru_dt = hr_api.g_eot

4419: ben_prtt_enrt_rslt_f pen
4420: where enb.enrt_bnft_id = p_enrt_bnft_id
4421: and enb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4422: and pen.effective_end_date = hr_api.g_eot
4423: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4424: and pen.prtt_enrt_rslt_stat_cd is NULL
4425: ;
4426: --
4427: -- Bug 2600087 fixes to open future dated coverage

Line 4435: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot

4431: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4432: and pen.prtt_enrt_rslt_stat_cd is null
4433: and pen.effective_end_date = (select pen2.effective_start_date - 1
4434: from ben_prtt_enrt_rslt_f pen2
4435: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4436: and pen2.effective_end_date = hr_api.g_eot
4437: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4438: and pen2.prtt_enrt_rslt_stat_cd is null);
4439: --

Line 4436: and pen2.effective_end_date = hr_api.g_eot

4432: and pen.prtt_enrt_rslt_stat_cd is null
4433: and pen.effective_end_date = (select pen2.effective_start_date - 1
4434: from ben_prtt_enrt_rslt_f pen2
4435: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
4436: and pen2.effective_end_date = hr_api.g_eot
4437: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4438: and pen2.prtt_enrt_rslt_stat_cd is null);
4439: --
4440: --bug#5032364

Line 4446: and pen.effective_end_date = hr_api.g_eot;

4442: select pen.*
4443: from ben_prtt_enrt_rslt_f pen
4444: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4445: and pen.prtt_enrt_rslt_stat_cd is null
4446: and pen.effective_end_date = hr_api.g_eot;
4447: --
4448: l_enrt_rslt2 c_enrt_rslt2%rowtype;
4449: --
4450: -- 5612091 - Added OR condition with p_elig_per_elctbl_chc_id

Line 4538: and pen.effective_end_date <> hr_api.g_eot

4534: from ben_prtt_enrt_rslt_f pen
4535: where pen.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
4536: and p_effective_date between
4537: pen.effective_start_date and pen.effective_end_date
4538: and pen.effective_end_date <> hr_api.g_eot
4539: and pen.prtt_enrt_rslt_stat_cd is null
4540: and pen.business_group_id = p_business_group_id
4541: order by pen.effective_start_date desc ;
4542: --

Line 4616: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'

4612: from ben_prtt_enrt_rslt_f pen
4613: ,ben_ptip_f ptip
4614: ,ben_per_in_ler pil
4615: ,ben_elig_per_elctbl_chc epe
4616: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
4617: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
4618: and pen.prtt_enrt_rslt_stat_cd is null
4619: and pen.person_id = pil.person_id -- 318321
4620: and pen.business_group_id = p_business_group_id -- 81545

Line 4617: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'

4613: ,ben_ptip_f ptip
4614: ,ben_per_in_ler pil
4615: ,ben_elig_per_elctbl_chc epe
4616: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
4617: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
4618: and pen.prtt_enrt_rslt_stat_cd is null
4619: and pen.person_id = pil.person_id -- 318321
4620: and pen.business_group_id = p_business_group_id -- 81545
4621: and pen.ptip_id = p_ptip_id -- 54444

Line 4989: p_datetrack_mode => hr_api.g_future_change,

4985: p_effective_start_date => l_effective_start_date,
4986: p_effective_end_date => l_effective_end_date,
4987: p_object_version_number => l_pen_curr.object_version_number,
4988: p_effective_date => l_pen_curr.effective_end_date,
4989: p_datetrack_mode => hr_api.g_future_change,
4990: p_multi_row_validate => FALSE);
4991: --
4992: for l_rec in c_prv(l_pen_curr.prtt_enrt_rslt_id,l_pen_curr.per_in_ler_id) loop
4993: --

Line 5025: p_rt_end_dt => hr_api.g_eot,

5021: p_person_id => l_global_pil_rec.person_id,
5022: p_business_group_id => p_business_group_id,
5023: p_prtt_rt_val_id => l_rec.prtt_rt_val_id,
5024: p_rt_strt_dt => nvl(l_ecr.rt_strt_dt,l_rec.rt_strt_dt),
5025: p_rt_end_dt => hr_api.g_eot,
5026: p_object_version_number => l_rec.object_version_number,
5027: p_effective_date => p_effective_date );
5028: --
5029: end loop;

Line 5053: p_datetrack_mode => hr_api.g_future_change,

5049: p_effective_start_date => l_effective_start_date,
5050: p_effective_end_date => l_effective_end_date,
5051: p_object_version_number => l_pen_curr_interim.object_version_number,
5052: p_effective_date => l_pen_curr_interim.effective_end_date,
5053: p_datetrack_mode => hr_api.g_future_change,
5054: p_multi_row_validate => FALSE);
5055: END IF;
5056: --
5057: -- 6057157 : Reset the Rate End to EOT, as PEN records are done similarly above.

Line 5070: p_rt_end_dt => hr_api.g_eot,

5066: (p_validate => false,
5067: p_person_id => l_global_pil_rec.person_id,
5068: p_business_group_id => p_business_group_id,
5069: p_prtt_rt_val_id => l_rec.prtt_rt_val_id,
5070: p_rt_end_dt => hr_api.g_eot,
5071: p_object_version_number => l_rec.object_version_number,
5072: p_effective_date => p_effective_date );
5073: --
5074: end loop;

Line 5146: nvl(l_old_bnft_val,hr_api.g_number)=

5142: if ( p_prtt_enrt_rslt_id is not null and
5143: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5144: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
5145: (( ben_sspndd_enrollment.g_use_new_result=false and
5146: nvl(l_old_bnft_val,hr_api.g_number)=
5147: nvl(l_global_enb_rec.val,hr_api.g_number)) or
5148: l_old_sspndd_flag = 'Y')) then
5149: if g_debug then
5150: hr_utility.set_location('enrt cvg strt dt'||l_global_epe_rec.enrt_cvg_strt_dt,111);

Line 5147: nvl(l_global_enb_rec.val,hr_api.g_number)) or

5143: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5144: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
5145: (( ben_sspndd_enrollment.g_use_new_result=false and
5146: nvl(l_old_bnft_val,hr_api.g_number)=
5147: nvl(l_global_enb_rec.val,hr_api.g_number)) or
5148: l_old_sspndd_flag = 'Y')) then
5149: if g_debug then
5150: hr_utility.set_location('enrt cvg strt dt'||l_global_epe_rec.enrt_cvg_strt_dt,111);
5151: end if;

Line 5207: nvl(l_old_bnft_val,hr_api.g_number)= nvl(l_global_enb_rec.val,hr_api.g_number) and

5203: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5204: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
5205: -- l_use_new_result=false and
5206: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
5207: nvl(l_old_bnft_val,hr_api.g_number)= nvl(l_global_enb_rec.val,hr_api.g_number) and
5208: p_enrt_cvg_thru_dt is null and
5209: l_start_new_result = false ) then
5210: if g_debug then
5211: hr_utility.set_location(l_proc, 80);

Line 5459: p_datetrack_mode => hr_api.g_future_change,

5455: p_effective_start_date => l_effective_start_date,
5456: p_effective_end_date => l_effective_end_date,
5457: p_object_version_number => l_enrt_rslt.object_version_number,
5458: p_effective_date => l_enrt_rslt.effective_end_date,
5459: p_datetrack_mode => hr_api.g_future_change,
5460: p_multi_row_validate => FALSE);
5461: p_object_version_number := l_enrt_rslt.object_version_number;
5462: --
5463: -- Bug 5766477 Also re-open dependent coverage.

Line 5474: p_datetrack_mode => hr_api.g_future_change,

5470: p_effective_end_date => l_effective_end_date,
5471: p_object_version_number => l_dpnt_rec.object_version_number,
5472: p_business_group_id => p_business_group_id,
5473: p_effective_date => l_enrt_rslt.effective_end_date,
5474: p_datetrack_mode => hr_api.g_future_change,
5475: p_multi_row_actn => FALSE);
5476: end loop;
5477:
5478: if (g_debug) then

Line 5571: ,p_enrt_cvg_thru_dt => hr_api.g_eot

5567: ,p_effective_start_date => p_effective_start_date
5568: ,p_effective_end_date => p_effective_end_date
5569: ,p_enrt_mthd_cd => p_enrt_mthd_cd
5570: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
5571: ,p_enrt_cvg_thru_dt => hr_api.g_eot
5572: ,p_enrt_ovrid_thru_dt => l_old_enrt_ovrid_thru_dt
5573: ,p_enrt_ovrid_rsn_cd => l_old_enrt_ovrid_rsn_cd
5574: ,p_enrt_ovridn_flag => l_old_enrt_ovridn_flag
5575: ,p_object_version_number => p_object_version_number

Line 5717: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=

5713: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5714: l_crntly_enrd_rslt_exists and
5715: -- l_use_new_result=false and
5716: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
5717: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5718: nvl(l_global_enb_rec.val,hr_api.g_number) and
5719: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
5720: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5721: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,

Line 5718: nvl(l_global_enb_rec.val,hr_api.g_number) and

5714: l_crntly_enrd_rslt_exists and
5715: -- l_use_new_result=false and
5716: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
5717: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5718: nvl(l_global_enb_rec.val,hr_api.g_number) and
5719: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
5720: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5721: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
5722: hr_api.g_number)) and

Line 5720: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=

5716: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
5717: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5718: nvl(l_global_enb_rec.val,hr_api.g_number) and
5719: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
5720: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5721: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
5722: hr_api.g_number)) and
5723: */
5724: l_start_new_result = false and

Line 5722: hr_api.g_number)) and

5718: nvl(l_global_enb_rec.val,hr_api.g_number) and
5719: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
5720: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5721: nvl(l_global_enb_rec.val,nvl(l_crntly_enrd_rslt_rec.bnft_amt,
5722: hr_api.g_number)) and
5723: */
5724: l_start_new_result = false and
5725: l_global_epe_rec.enrt_cvg_strt_dt = l_crntly_enrd_rslt_rec.enrt_cvg_strt_dt then --BUG 4568911
5726: -- RCHASE Bug#5353 alteration

Line 5727: -- nvl(l_global_enb_rec.val,hr_api.g_number) then

5723: */
5724: l_start_new_result = false and
5725: l_global_epe_rec.enrt_cvg_strt_dt = l_crntly_enrd_rslt_rec.enrt_cvg_strt_dt then --BUG 4568911
5726: -- RCHASE Bug#5353 alteration
5727: -- nvl(l_global_enb_rec.val,hr_api.g_number) then
5728: --
5729: -- If they are not staying in the same plan and option
5730: -- and ELIG PER ELCTBL CHC: CRNTLY ENRD FLAG = Y then
5731: -- re-use the enrollment result.

Line 5777: ,p_enrt_cvg_thru_dt => hr_api.g_eot

5773: ,p_effective_start_date => p_effective_start_date
5774: ,p_effective_end_date => p_effective_end_date
5775: ,p_enrt_mthd_cd => p_enrt_mthd_cd
5776: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
5777: ,p_enrt_cvg_thru_dt => hr_api.g_eot
5778: ,p_enrt_ovrid_thru_dt => l_crntly_enrd_rslt_rec.enrt_ovrid_thru_dt
5779: ,p_enrt_ovrid_rsn_cd => l_crntly_enrd_rslt_rec.enrt_ovrid_rsn_cd
5780: ,p_enrt_ovridn_flag => l_crntly_enrd_rslt_rec.enrt_ovridn_flag
5781: ,p_object_version_number => l_object_version_number

Line 5872: p_datetrack_mode => hr_api.g_correction,

5868: p_business_group_id => p_business_group_id,
5869: p_RPLCS_SSPNDD_RSLT_ID => null,
5870: p_object_version_number => l_delink_interim.object_version_number,
5871: p_effective_date => p_effective_date,
5872: p_datetrack_mode => hr_api.g_correction,
5873: p_multi_row_validate => FALSE,
5874: p_program_application_id => fnd_global.prog_appl_id,
5875: p_program_id => fnd_global.conc_program_id,
5876: p_request_id => fnd_global.conc_request_id,

Line 5952: nvl(l_elect_cvg_strt_dt,hr_api.g_eot)

5948: --- l_old_erlst_deenrt_dt is decide the previous enrolment
5949: -- bal_epe_rec.epe.erlst_deenrt_dt decide the whether erlst_deenrt_dt is to be calc
5950: if l_old_erlst_deenrt_dt is null and
5951: l_global_epe_rec.erlst_deenrt_dt is not null and
5952: nvl(l_elect_cvg_strt_dt,hr_api.g_eot)
5953: <> l_global_epe_rec.enrt_cvg_strt_dt then
5954: if g_debug then
5955: hr_utility.set_location('CALLINGH ERLST DATE ' , 8086.1);
5956: end if;

Line 6010: if (nvl(l_old_bnft_val,hr_api.g_number)<>

6006: end if; -- date is null
6007: if g_debug then
6008: hr_utility.set_location(l_proc, 170);
6009: end if;
6010: if (nvl(l_old_bnft_val,hr_api.g_number)<>
6011: nvl(l_global_enb_rec.val,hr_api.g_number)
6012: -- Bug#1807450 added and condition
6013: and p_prtt_enrt_rslt_id is not null) or
6014: -- Added for Interim Coverage /*ENH*/

Line 6011: nvl(l_global_enb_rec.val,hr_api.g_number)

6007: if g_debug then
6008: hr_utility.set_location(l_proc, 170);
6009: end if;
6010: if (nvl(l_old_bnft_val,hr_api.g_number)<>
6011: nvl(l_global_enb_rec.val,hr_api.g_number)
6012: -- Bug#1807450 added and condition
6013: and p_prtt_enrt_rslt_id is not null) or
6014: -- Added for Interim Coverage /*ENH*/
6015: ben_sspndd_enrollment.g_use_new_result or

Line 6120: l_datetrack_mode := hr_api.g_update;

6116: --
6117: -- unrestricted changes
6118:
6119: if p_prtt_enrt_rslt_id is not null then
6120: l_datetrack_mode := hr_api.g_update;
6121: else
6122: l_datetrack_mode := p_datetrack_mode;
6123: end if;
6124: -- Bug 2172036 pass assignment_id also to create pen

Line 6191: p_datetrack_mode => hr_api.g_correction,

6187: p_effective_end_date => l_effective_end_date,
6188: p_business_group_id => p_business_group_id,
6189: p_object_version_number => l_get_enrt_rslts_for_pen.object_version_number,
6190: p_effective_date => p_effective_date,
6191: p_datetrack_mode => hr_api.g_correction,
6192: p_multi_row_validate => FALSE,
6193: p_enrt_cvg_thru_dt => l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt - 1
6194: );
6195: end loop; -- c_get_enrt_rslts_for_pen

Line 6340: ,p_enrt_cvg_end_dt => hr_api.g_eot --?

6336: ,p_old_oipl_id => l_old_oipl_id
6337: ,p_old_bnft_amt => l_old_bnft_val
6338: ,p_bnft_amt => l_global_enb_rec.val
6339: ,p_enrt_cvg_strt_dt => l_global_epe_rec.enrt_cvg_strt_dt
6340: ,p_enrt_cvg_end_dt => hr_api.g_eot --?
6341: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
6342: ,p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
6343: ,p_person_id => l_global_pil_rec.person_id
6344: ,p_business_group_id => l_global_epe_rec.business_group_id

Line 6853: if p_datetrack_mode = hr_api.g_insert then

6849: --
6850: -- If the result was created in the same run, then the mode will be insert.
6851: -- In this case, we can only do update in correction mode.
6852: --
6853: if p_datetrack_mode = hr_api.g_insert then
6854: l_datetrack_mode := hr_api.g_correction;
6855: else
6856: l_datetrack_mode := p_datetrack_mode;
6857: end if;

Line 6854: l_datetrack_mode := hr_api.g_correction;

6850: -- If the result was created in the same run, then the mode will be insert.
6851: -- In this case, we can only do update in correction mode.
6852: --
6853: if p_datetrack_mode = hr_api.g_insert then
6854: l_datetrack_mode := hr_api.g_correction;
6855: else
6856: l_datetrack_mode := p_datetrack_mode;
6857: end if;
6858: --

Line 6897: raise hr_api.validate_enabled;

6893: --
6894: -- When in validation only mode raise the Validate_Enabled exception
6895: --
6896: if p_validate then
6897: raise hr_api.validate_enabled;
6898: end if;
6899:
6900: if g_debug then
6901: hr_utility.set_location('Leaving:'||l_proc, 999);

Line 6906: when hr_api.validate_enabled then

6902: end if;
6903:
6904: exception
6905: --
6906: when hr_api.validate_enabled then
6907: --
6908: -- As the Validate_Enabled exception has been raised
6909: -- we must rollback to the savepoint
6910: --

Line 7332: if l_datetrack_mode = hr_api.g_correction then

7328: if p_validate = 'Y' then
7329: l_validate := true;
7330: end if;
7331: --
7332: if l_datetrack_mode = hr_api.g_correction then
7333: if p_effective_date = p_effective_start_date then
7334: null;
7335: else
7336: l_datetrack_mode := hr_api.g_update;

Line 7336: l_datetrack_mode := hr_api.g_update;

7332: if l_datetrack_mode = hr_api.g_correction then
7333: if p_effective_date = p_effective_start_date then
7334: null;
7335: else
7336: l_datetrack_mode := hr_api.g_update;
7337: end if;
7338: end if;
7339: --
7340: ben_env_object.init(p_business_group_id => p_business_group_id,