[Home] [Help]
53: Keep old orgnl_enrt_dt if plan stays
54: same
55: 26 Oct 98 jcarpent 115.14 Updated prv to non-datetracked
56: 27 Oct 98 jcarpent 115.15 Changed election_rate_information
57: 29 Oct 98 jcarpent 115.16 Fixed calls to ben_prtt_rt_val_api.
58: Don't compare old elctns made date
59: 29 Oct 98 stee 115.17 Get rt_typ_cd and rt_mlt_cd from
60: enrt_rt.
61: 31 Oct 98 bbulusu 115.18 Added per_in_ler_d to delet_enrolment
67: 10 Dec 98 stee 115.22 Fixed bnf warning.
68: 15 Dec 98 jcarpent 115.23 Added call to Create_debit_ledger..
69: 31 Dec 98 lmcdonal 115.24 Better debug messages.
70: 12 Jan 98 maagrawa 115.25 Modified calls to
71: ben_prtt_rt_val_api. (Column
72: acty_base_rt_id added to
73: table ben_prtt_rt_val).
74: 01 Feb 99 jcarpent 115.26 Changed calls to update prv to use
75: ended_per_in_ler_id.
845: --
846: -- Call delete prv if Unrestricted, else update prv
847: --
848: if p_unrestricted = 'Y' then
849: ben_prtt_rt_val_api.delete_prtt_rt_val
850: (p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id
851: ,p_person_id => p_person_id
852: ,p_business_group_id => p_business_group_id
853: ,p_object_version_number => l_future_prv.object_version_number
852: ,p_business_group_id => p_business_group_id
853: ,p_object_version_number => l_future_prv.object_version_number
854: ,p_effective_date => l_future_prv.rt_strt_dt);
855: else
856: ben_prtt_rt_val_api.update_prtt_rt_val
857: (p_validate => false,
858: p_person_id => p_person_id,
859: p_business_group_id => p_business_group_id,
860: p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id,
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
887: ,p_rt_end_dt => hr_api.g_eot
888: ,p_business_group_id => p_business_group_id
3107: -- delete future dated rate
3108: --
3109: if not p_calculate_only_mode then
3110: --
3111: ben_prtt_rt_val_api.delete_prtt_rt_val
3112: (p_prtt_rt_val_id => p_prtt_rt_val_id
3113: ,p_enrt_rt_id => p_enrt_rt_id
3114: ,p_person_id => p_person_id
3115: ,p_business_group_id => l_enrt_rt.business_group_id
3214: --from benraten. This needs to happed only for recurring rates.
3215: --
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
3244: end if;
3245: if not p_calculate_only_mode then
3246: --
3247: --
3248: ben_prtt_rt_val_api.update_prtt_rt_val
3249: (p_prtt_rt_val_id => p_prtt_rt_val_id
3250: ,p_rt_end_dt => l_xrt_end_dt
3251: ,p_ended_per_in_ler_id => p_per_in_ler_id
3252: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3276: hr_utility.set_location('processing type recurring ',1999);
3277: end if;
3278: --
3279:
3280: ben_prtt_rt_val_api.update_prtt_rt_val
3281: (p_prtt_rt_val_id => p_prtt_rt_val_id
3282: ,p_rt_end_dt => l_xrt_end_dt
3283: ,p_ended_per_in_ler_id => p_per_in_ler_id
3284: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3368: );
3369: end if;
3370: close c_prtt_rt_val_adj;
3371: --
3372: ben_prtt_rt_val_api.update_prtt_rt_val
3373: (P_VALIDATE => FALSE
3374: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
3375: ,P_RT_END_DT => l_epe.rt_strt_dt - 1
3376: ,p_person_id => l_pen.person_id
3388: end if;
3389: close c_get_prior_per_in_ler;
3390: -- end 7206471
3391:
3392: ben_prtt_rt_val_api.create_prtt_rt_val
3393: (p_prtt_rt_val_id => p_prtt_rt_val_id
3394: ,p_enrt_rt_id => p_enrt_rt_id
3395: ,p_per_in_ler_id => p_per_in_ler_id
3396: ,p_rt_typ_cd => l_enrt_rt.rt_typ_cd
3445: --from benraten. This needs to happed only for recurring rates.
3446: --
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
3538: );
3539: end if;
3540: close c_prtt_rt_val_adj;
3541: --
3542: ben_prtt_rt_val_api.update_prtt_rt_val
3543: (P_VALIDATE => FALSE
3544: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
3545: ,P_RT_END_DT => l_epe.rt_strt_dt - 1
3546: ,p_person_id => l_pen.person_id
3558: end if;
3559: close c_get_prior_per_in_ler;
3560: -- end 7206471
3561: -- if no prtt_rt_val_id passed do insert
3562: ben_prtt_rt_val_api.create_prtt_rt_val
3563: (p_prtt_rt_val_id => p_prtt_rt_val_id
3564: ,p_enrt_rt_id => p_enrt_rt_id
3565: ,p_per_in_ler_id => p_per_in_ler_id
3566: ,p_rt_typ_cd => l_enrt_rt.rt_typ_cd
3632: ,p_effective_date => p_effective_date);
3633: end if;
3634: --
3635: if l_xrt_end_dt_cd = 'WAENT' then
3636: ben_prtt_rt_val_api.update_prtt_rt_val
3637: (p_prtt_rt_val_id => p_prtt_rt_val_id
3638: ,p_rt_end_dt => l_rt_end_dt
3639: ,p_ended_per_in_ler_id => p_per_in_ler_id
3640: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
5015: );
5016: --
5017: END IF;
5018: --
5019: ben_prtt_rt_val_api.update_prtt_rt_val
5020: (p_validate => false,
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,
5061: --
5062: hr_utility.set_location('Interim l_rec.prtt_rt_val_id ' || l_rec.prtt_rt_val_id,99);
5063: hr_utility.set_location('l_rec.rt_end_dt ' || l_rec.rt_end_dt,99);
5064: --
5065: ben_prtt_rt_val_api.update_prtt_rt_val
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,