DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on HR_API

Line 884: p_chg_actl_strt_dt := hr_api.g_sot;

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

Line 896: p_chg_actl_end_dt := hr_api.g_eot;

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

Line 911: p_chg_eff_strt_dt := hr_api.g_sot;

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

Line 922: p_chg_eff_end_dt := hr_api.g_eot;

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

Line 973: p_to_be_sent_strt_dt := hr_api.g_sot;

969: fetch c_to_be_sent_dt into l_to_be_sent_dt;
970: close c_to_be_sent_dt;
971: --
972: if nvl(l_to_be_sent_dt.excld_flag,'N') = 'Y' or l_to_be_sent_dt.val_1 is null then
973: p_to_be_sent_strt_dt := hr_api.g_sot;
974: else
975:
976: hr_utility.set_location(' 514 error cm ' , 514);
977: p_to_be_sent_strt_dt := ben_ext_util.calc_ext_date

Line 985: p_to_be_sent_end_dt := hr_api.g_eot;

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

Line 2235: ,p_start_date IN DATE DEFAULT hr_api.g_sot

2231: PROCEDURE entries_affected
2232: (p_assignment_id IN NUMBER DEFAULT NULL
2233: ,p_event_group_id IN NUMBER DEFAULT NULL
2234: ,p_mode IN VARCHAR2 DEFAULT NULL
2235: ,p_start_date IN DATE DEFAULT hr_api.g_sot
2236: ,p_end_date IN DATE DEFAULT hr_api.g_eot
2237: ,p_business_group_id IN NUMBER
2238: ,p_detailed_output OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
2239: ,p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_CREATION_DATE'

Line 2236: ,p_end_date IN DATE DEFAULT hr_api.g_eot

2232: (p_assignment_id IN NUMBER DEFAULT NULL
2233: ,p_event_group_id IN NUMBER DEFAULT NULL
2234: ,p_mode IN VARCHAR2 DEFAULT NULL
2235: ,p_start_date IN DATE DEFAULT hr_api.g_sot
2236: ,p_end_date IN DATE DEFAULT hr_api.g_eot
2237: ,p_business_group_id IN NUMBER
2238: ,p_detailed_output OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
2239: ,p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_CREATION_DATE'
2240: ,p_penserv_mode IN VARCHAR2 DEFAULT 'N' --vkodedal changes for penserver - 30-apr-2008