[Home] [Help]
456: passed when calling update_prtt_rt_val api.
457: 115.196 28-Nov-02 lakrish Bug 2519378, Set tokens for error message
458: BEN_91711_ENRT_RSLT_NOT_FND
459: 115.197 07-Jan-03 ikasire Bug 2739965 delete enrollment for unrestricted.
460: added p_ler_typ_cd parameter to get_ben_pen_upd_dt_mode
461: procedure
462: 115.199 15-Feb-03 pbodla DEBUG : hr_utility.set_location calls wrpped
463: around if statements.
464: 115.200 14-Mar-03 kmahendr Bug#2785410 - code added in void_enrollment proc.
568: handlers changes made to avoid null errors
569: on SS pages
570: 115.256 01-Jun-05 vborkar Bug 4387247 : Modifications to take care of
571: application exceptions.
572: 115.257 04-Jul-05 rgajula Bug 4431511 Added checks in get_ben_pen_upd_dt_modes to ensure update_override is passed as
573: effective datetrack mode if the desired date track mode is
574: delete next change in case of unrestricted enrollments
575: 115.258 20-Jul-05 ikasire Bug 4463836 added new parameter p_called_from_ss
576: 115.259 27-Jul-05 kmahendr Bug#4509665 - modified the cursor c_pl_typ_names
1170: -- ----------------------------------------------------------------------------
1171: -- |-------------------------< Get_ben_upd_dt_mode >---------------------------|
1172: -- ----------------------------------------------------------------------------
1173:
1174: procedure get_ben_pen_upd_dt_mode
1175: (p_effective_date in date
1176: ,p_base_key_value in number
1177: ,P_desired_datetrack_mode in varchar2
1178: ,P_datetrack_allow in out nocopy varchar2
1188: l_dt_zap boolean;
1189: l_dt_future_change boolean;
1190: -- End Bug 4431511
1191: l_step number(9);
1192: l_proc varchar2(80) ; -- := g_package||'.get_ben_pen_upd_dt_mode';
1193: begin
1194: --
1195: g_debug := hr_utility.debug_enabled;
1196: if g_debug then
1193: begin
1194: --
1195: g_debug := hr_utility.debug_enabled;
1196: if g_debug then
1197: l_proc := g_package||'.get_ben_pen_upd_dt_mode';
1198: hr_utility.set_location ('Entering '||l_proc,10);
1199: hr_utility.set_location('IK p_effective_date'||p_effective_date,1234);
1200: hr_utility.set_location('IK P_desired_datetrack_mode '||P_desired_datetrack_mode,1234);
1201: end if;
4676: end;
4677: --
4678: hr_utility.set_location ( ' eff date ' || p_effective_date, 99 );
4679: hr_utility.set_location ( ' OVN ' || l_object_version_number, 99 );
4680: ben_pen_upd.upd
4681: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
4682: ,p_effective_start_date => l_effective_start_date
4683: ,p_effective_end_date => l_effective_end_date
4684: ,p_business_group_id => p_business_group_id
5834: --
5835:
5836: l_step := 120;
5837:
5838: get_ben_pen_upd_dt_mode
5839: (p_effective_date => p_effective_date
5840: ,p_base_key_value => p_prtt_enrt_rslt_id
5841: ,P_desired_datetrack_mode => p_datetrack_mode
5842: ,P_datetrack_allow => l_datetrack_mode
8012: );
8013: --
8014: l_step := 120;
8015: --
8016: hr_utility.set_location(' Before get_ben_pen_upd_dt_mode '||p_datetrack_mode,123);
8017: get_ben_pen_upd_dt_mode
8018: (p_effective_date => p_effective_date
8019: ,p_base_key_value => p_prtt_enrt_rslt_id
8020: ,P_desired_datetrack_mode => p_datetrack_mode
8013: --
8014: l_step := 120;
8015: --
8016: hr_utility.set_location(' Before get_ben_pen_upd_dt_mode '||p_datetrack_mode,123);
8017: get_ben_pen_upd_dt_mode
8018: (p_effective_date => p_effective_date
8019: ,p_base_key_value => p_prtt_enrt_rslt_id
8020: ,P_desired_datetrack_mode => p_datetrack_mode
8021: ,P_datetrack_allow => l_datetrack_mode
8020: ,P_desired_datetrack_mode => p_datetrack_mode
8021: ,P_datetrack_allow => l_datetrack_mode
8022: ,p_ler_typ_cd => l_ler_typ_cd -- Bug 2739965
8023: );
8024: hr_utility.set_location(' After get_ben_pen_upd_dt_mode '||l_datetrack_mode,123);
8025: --
8026: l_step := 125;
8027: --
8028: if g_debug then
8478: );
8479: --
8480: l_step := 120;
8481: --
8482: get_ben_pen_upd_dt_mode
8483: (p_effective_date => p_effective_date
8484: ,p_base_key_value => p_prtt_enrt_rslt_id
8485: ,P_desired_datetrack_mode => p_datetrack_mode
8486: ,P_datetrack_allow => l_datetrack_mode