[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.
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
989: (p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id
990: ,p_person_id => p_person_id
991: ,p_business_group_id => p_business_group_id
992: ,p_object_version_number => l_future_prv.object_version_number
991: ,p_business_group_id => p_business_group_id
992: ,p_object_version_number => l_future_prv.object_version_number
993: ,p_effective_date => l_future_prv.rt_strt_dt);
994: else
995: ben_prtt_rt_val_api.update_prtt_rt_val
996: (p_validate => false,
997: p_person_id => p_person_id,
998: p_business_group_id => p_business_group_id,
999: p_prtt_rt_val_id => l_future_prv.prtt_rt_val_id,
1024: l_prv_count := l_prv_count + 1;
1025: l_found := true;
1026: --9614678
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
3530: -- delete future dated rate
3531: --
3532: if not p_calculate_only_mode then
3533: --
3534: ben_prtt_rt_val_api.delete_prtt_rt_val
3535: (p_prtt_rt_val_id => p_prtt_rt_val_id
3536: ,p_enrt_rt_id => p_enrt_rt_id
3537: ,p_person_id => p_person_id
3538: ,p_business_group_id => l_enrt_rt.business_group_id
3649: --from benraten. This needs to happed only for recurring rates.
3650: --
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
3679: end if;
3680: if not p_calculate_only_mode then
3681: --
3682: --
3683: ben_prtt_rt_val_api.update_prtt_rt_val
3684: (p_prtt_rt_val_id => p_prtt_rt_val_id
3685: ,p_rt_end_dt => l_xrt_end_dt
3686: ,p_ended_per_in_ler_id => p_per_in_ler_id
3687: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3745: );
3746: end if;
3747: close c_future_ended_rates;
3748:
3749: ben_prtt_rt_val_api.update_prtt_rt_val
3750: (p_prtt_rt_val_id => p_prtt_rt_val_id
3751: ,p_rt_end_dt => l_xrt_end_dt
3752: ,p_ended_per_in_ler_id => p_per_in_ler_id
3753: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
3851: );
3852: end if;
3853: close c_prtt_rt_val_adj;
3854: --
3855: ben_prtt_rt_val_api.update_prtt_rt_val
3856: (P_VALIDATE => FALSE
3857: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
3858: ,P_RT_END_DT => l_enrt_rt.rt_strt_dt - 1 --Bug 8507247
3859: ,p_person_id => l_pen.person_id
3871: end if;
3872: close c_get_prior_per_in_ler;
3873: -- end 7206471
3874:
3875: ben_prtt_rt_val_api.create_prtt_rt_val
3876: (p_prtt_rt_val_id => p_prtt_rt_val_id
3877: ,p_enrt_rt_id => p_enrt_rt_id
3878: ,p_per_in_ler_id => p_per_in_ler_id
3879: ,p_rt_typ_cd => l_enrt_rt.rt_typ_cd
3928: --from benraten. This needs to happed only for recurring rates.
3929: --
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
4035: );
4036: end if;
4037: close c_prtt_rt_val_adj;
4038: --
4039: ben_prtt_rt_val_api.update_prtt_rt_val
4040: (P_VALIDATE => FALSE
4041: ,P_PRTT_RT_VAL_ID => l_pen.prtt_rt_val_id
4042: ,P_RT_END_DT => l_enrt_rt.rt_strt_dt - 1 --Bug 8507247
4043: ,p_person_id => l_pen.person_id
4055: end if;
4056: close c_get_prior_per_in_ler;
4057: -- end 7206471
4058: -- if no prtt_rt_val_id passed do insert
4059: ben_prtt_rt_val_api.create_prtt_rt_val
4060: (p_prtt_rt_val_id => p_prtt_rt_val_id
4061: ,p_enrt_rt_id => p_enrt_rt_id
4062: ,p_per_in_ler_id => p_per_in_ler_id
4063: ,p_rt_typ_cd => l_enrt_rt.rt_typ_cd
4129: ,p_effective_date => p_effective_date);
4130: end if;
4131: --
4132: if l_xrt_end_dt_cd = 'WAENT' then
4133: ben_prtt_rt_val_api.update_prtt_rt_val
4134: (p_prtt_rt_val_id => p_prtt_rt_val_id
4135: ,p_rt_end_dt => l_rt_end_dt
4136: ,p_ended_per_in_ler_id => p_per_in_ler_id
4137: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id
5875: );
5876: --
5877: END IF;
5878: --
5879: ben_prtt_rt_val_api.update_prtt_rt_val
5880: (p_validate => false,
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,
5923: --
5924: hr_utility.set_location('Interim l_rec.prtt_rt_val_id ' || l_rec.prtt_rt_val_id,99);
5925: hr_utility.set_location('l_rec.rt_end_dt ' || l_rec.rt_end_dt,99);
5926: --
5927: ben_prtt_rt_val_api.update_prtt_rt_val
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,