[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
1243: -- ----------------------------------------------------------------------------
1244: -- |-------------------------< Get_ben_upd_dt_mode >---------------------------|
1245: -- ----------------------------------------------------------------------------
1246:
1247: procedure get_ben_pen_upd_dt_mode
1248: (p_effective_date in date
1249: ,p_base_key_value in number
1250: ,P_desired_datetrack_mode in varchar2
1251: ,P_datetrack_allow in out nocopy varchar2
1261: l_dt_zap boolean;
1262: l_dt_future_change boolean;
1263: -- End Bug 4431511
1264: l_step number(9);
1265: l_proc varchar2(80) ; -- := g_package||'.get_ben_pen_upd_dt_mode';
1266: begin
1267: --
1268: g_debug := hr_utility.debug_enabled;
1269: if g_debug then
1266: begin
1267: --
1268: g_debug := hr_utility.debug_enabled;
1269: if g_debug then
1270: l_proc := g_package||'.get_ben_pen_upd_dt_mode';
1271: hr_utility.set_location ('Entering '||l_proc,10);
1272: hr_utility.set_location('IK p_effective_date'||p_effective_date,1234);
1273: hr_utility.set_location('IK P_desired_datetrack_mode '||P_desired_datetrack_mode,1234);
1274: end if;
4965: end;
4966: --
4967: hr_utility.set_location ( ' eff date ' || p_effective_date, 99 );
4968: hr_utility.set_location ( ' OVN ' || l_object_version_number, 99 );
4969: ben_pen_upd.upd
4970: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
4971: ,p_effective_start_date => l_effective_start_date
4972: ,p_effective_end_date => l_effective_end_date
4973: ,p_business_group_id => p_business_group_id
6123: --
6124:
6125: l_step := 120;
6126:
6127: get_ben_pen_upd_dt_mode
6128: (p_effective_date => p_effective_date
6129: ,p_base_key_value => p_prtt_enrt_rslt_id
6130: ,P_desired_datetrack_mode => p_datetrack_mode
6131: ,P_datetrack_allow => l_datetrack_mode
9178:
9179: --
9180: l_step := 120;
9181: --
9182: hr_utility.set_location(' Before get_ben_pen_upd_dt_mode '||p_datetrack_mode,123);
9183: get_ben_pen_upd_dt_mode
9184: (p_effective_date => p_effective_date
9185: ,p_base_key_value => p_prtt_enrt_rslt_id
9186: ,P_desired_datetrack_mode => p_datetrack_mode
9179: --
9180: l_step := 120;
9181: --
9182: hr_utility.set_location(' Before get_ben_pen_upd_dt_mode '||p_datetrack_mode,123);
9183: get_ben_pen_upd_dt_mode
9184: (p_effective_date => p_effective_date
9185: ,p_base_key_value => p_prtt_enrt_rslt_id
9186: ,P_desired_datetrack_mode => p_datetrack_mode
9187: ,P_datetrack_allow => l_datetrack_mode
9186: ,P_desired_datetrack_mode => p_datetrack_mode
9187: ,P_datetrack_allow => l_datetrack_mode
9188: ,p_ler_typ_cd => l_ler_typ_cd -- Bug 2739965
9189: );
9190: hr_utility.set_location(' After get_ben_pen_upd_dt_mode '||l_datetrack_mode,123);
9191: --
9192: l_step := 125;
9193: --
9194: if g_debug then
9666: );
9667: --
9668: l_step := 120;
9669: --
9670: get_ben_pen_upd_dt_mode
9671: (p_effective_date => p_effective_date
9672: ,p_base_key_value => p_prtt_enrt_rslt_id
9673: ,P_desired_datetrack_mode => p_datetrack_mode
9674: ,P_datetrack_allow => l_datetrack_mode