DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on BEN_EXT_UTIL

Line 1: package body BEN_EXT_UTIL as

1: package body BEN_EXT_UTIL as
2: /* $Header: benxutil.pkb 120.13.12010000.2 2008/08/05 15:01:54 ubhat ship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+

Line 882: p_chg_actl_strt_dt := ben_ext_util.calc_ext_date

878: if nvl(l_chg_actl_dt.excld_flag,'N') = 'Y' or l_chg_actl_dt.val_1 is null or
879: l_chg_actl_dt.val_1 in ('CHAD','CHED') then
880: p_chg_actl_strt_dt := hr_api.g_sot;
881: else
882: p_chg_actl_strt_dt := ben_ext_util.calc_ext_date
883: (p_ext_date_cd => l_chg_actl_dt.val_1,
884: p_abs_date => p_effective_date,
885: p_ext_dfn_id => p_ext_dfn_id
886: );

Line 894: p_chg_actl_end_dt := ben_ext_util.calc_ext_date

890: if nvl(l_chg_actl_dt.excld_flag,'N') = 'Y' or l_chg_actl_dt.val_2 is null or
891: l_chg_actl_dt.val_2 in ('CHAD','CHED'/*,'CTBSD','CESD','CLEOD','CDBLEOD'*/ ) then
892: p_chg_actl_end_dt := hr_api.g_eot;
893: else
894: p_chg_actl_end_dt := ben_ext_util.calc_ext_date
895: (p_ext_date_cd => l_chg_actl_dt.val_2,
896: p_abs_date => p_effective_date,
897: p_ext_dfn_id => p_ext_dfn_id
898: );

Line 909: p_chg_eff_strt_dt := ben_ext_util.calc_ext_date

905: if nvl(l_chg_eff_dt.excld_flag,'N') = 'Y' or l_chg_eff_dt.val_1 is null or
906: l_chg_actl_dt.val_2 in ('CHAD','CHED'/*,'CTBSD','CESD','CLEOD','CDBLEOD'*/ ) then
907: p_chg_eff_strt_dt := hr_api.g_sot;
908: else
909: p_chg_eff_strt_dt := ben_ext_util.calc_ext_date
910: (p_ext_date_cd => l_chg_eff_dt.val_1,
911: p_abs_date => p_effective_date,
912: p_ext_dfn_id => p_ext_dfn_id
913: );

Line 920: p_chg_eff_end_dt := ben_ext_util.calc_ext_date

916: if nvl(l_chg_eff_dt.excld_flag,'N') = 'Y' or l_chg_eff_dt.val_2 is null or
917: l_chg_actl_dt.val_2 in ('CHAD','CHED'/*,'CTBSD','CESD','CLEOD','CDBLEOD'*/ ) then
918: p_chg_eff_end_dt := hr_api.g_eot;
919: else
920: p_chg_eff_end_dt := ben_ext_util.calc_ext_date
921: (p_ext_date_cd => l_chg_eff_dt.val_2,
922: p_abs_date => p_effective_date,
923: p_ext_dfn_id => p_ext_dfn_id
924: );

Line 973: p_to_be_sent_strt_dt := ben_ext_util.calc_ext_date

969: p_to_be_sent_strt_dt := hr_api.g_sot;
970: else
971:
972: hr_utility.set_location(' 514 error cm ' , 514);
973: p_to_be_sent_strt_dt := ben_ext_util.calc_ext_date
974: (p_ext_date_cd => l_to_be_sent_dt.val_1,
975: p_abs_date => p_effective_date,
976: p_ext_dfn_id => p_ext_dfn_id
977: );

Line 984: p_to_be_sent_end_dt := ben_ext_util.calc_ext_date

980: if nvl(l_to_be_sent_dt.excld_flag,'N') = 'Y' or l_to_be_sent_dt.val_2 is null then
981: p_to_be_sent_end_dt := hr_api.g_eot;
982: else
983: hr_utility.set_location(' 514 error cmm ' , 514);
984: p_to_be_sent_end_dt := ben_ext_util.calc_ext_date
985: (p_ext_date_cd => l_to_be_sent_dt.val_2,
986: p_abs_date => p_effective_date,
987: p_ext_dfn_id => p_ext_dfn_id
988: );

Line 2359: END BEN_EXT_UTIL;

2355: hr_utility.trace('Leaving: '||l_proc);
2356: END entries_affected;
2357:
2358: --
2359: END BEN_EXT_UTIL;