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,
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,
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,
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,
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
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,
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'
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