876: close c_chg_actl_dt;
877: --
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,
888:
889: --
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,
903: close c_chg_eff_dt;
904: --
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,
914: end if;
915: --
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,
965: fetch c_to_be_sent_dt into l_to_be_sent_dt;
966: close c_to_be_sent_dt;
967: --
968: if nvl(l_to_be_sent_dt.excld_flag,'N') = 'Y' or l_to_be_sent_dt.val_1 is null then
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
977: );
978: end if;
979: --
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,
2227: PROCEDURE entries_affected
2228: (p_assignment_id IN NUMBER DEFAULT NULL
2229: ,p_event_group_id IN NUMBER DEFAULT NULL
2230: ,p_mode IN VARCHAR2 DEFAULT NULL
2231: ,p_start_date IN DATE DEFAULT hr_api.g_sot
2232: ,p_end_date IN DATE DEFAULT hr_api.g_eot
2233: ,p_business_group_id IN NUMBER
2234: ,p_detailed_output OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
2235: ,p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_CREATION_DATE'
2228: (p_assignment_id IN NUMBER DEFAULT NULL
2229: ,p_event_group_id IN NUMBER DEFAULT NULL
2230: ,p_mode IN VARCHAR2 DEFAULT NULL
2231: ,p_start_date IN DATE DEFAULT hr_api.g_sot
2232: ,p_end_date IN DATE DEFAULT hr_api.g_eot
2233: ,p_business_group_id IN NUMBER
2234: ,p_detailed_output OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
2235: ,p_process_mode IN VARCHAR2 DEFAULT 'ENTRY_CREATION_DATE'
2236: ,p_penserv_mode IN VARCHAR2 DEFAULT 'N' --vkodedal changes for penserver - 30-apr-2008