613: END IF;
614: --
615: END IF;
616:
617: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 100);
618:
619:
620: -- Call the Extract Process
621: --
618:
619:
620: -- Call the Extract Process
621: --
622: ben_ext_thread.process ( errbuf => l_errbuf
623: , retcode => l_retcode
624: , p_benefit_action_id => NULL
625: , p_ext_dfn_id => l_extract_def_id
626: , p_effective_date => TO_CHAR(l_end_date,'yyyy/mm/dd')
768: , p_filling_date => null
769: , p_report_type => 'CA'
770: );
771:
772: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);
773:
774: -- Call the Extract Process
775: --
776: ben_ext_thread.process ( errbuf => l_errbuf
772: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);
773:
774: -- Call the Extract Process
775: --
776: ben_ext_thread.process ( errbuf => l_errbuf
777: , retcode => l_retcode
778: , p_benefit_action_id => NULL
779: , p_ext_dfn_id => l_extract_def_id
780: , p_effective_date => to_char(l_end_date,'yyyy/mm/dd')
921: -- bug 3448316 caused change from p_filling_date to l_filling_date
922: , p_report_type => 'EM'
923:
924: );
925: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);
926:
927: ben_ext_thread.process ( errbuf => l_errbuf
928: , retcode => l_retcode
929: , p_benefit_action_id => NULL
923:
924: );
925: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);
926:
927: ben_ext_thread.process ( errbuf => l_errbuf
928: , retcode => l_retcode
929: , p_benefit_action_id => NULL
930: , p_ext_dfn_id => l_extract_def_id
931: , p_effective_date => TO_CHAR(l_end_date,'yyyy/mm/dd')