1: package body pay_jp_ltax_imp_pkg as
2: /* $Header: pyjpltxi.pkb 120.4 2011/07/29 10:15:55 keyazawa noship $ */
3: --
4: c_package constant varchar2(30) := 'pay_jp_ltax_imp_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6: --
7: c_com_ltx_info_elm constant varchar2(80) := 'COM_LTX_INFO';
8: c_com_itx_info_elm constant varchar2(80) := 'COM_ITX_INFO';
9: c_itx_org_iv constant varchar2(80) := 'WITHHOLD_AGENT';
479: --
480: begin
481: --
482: if g_debug then
483: hr_utility.set_location(l_proc,0);
484: end if;
485: --
486: --if g_business_group_id is null
487: --or g_business_group_id <> p_business_group_id then
645: set_detail_debug(l_detail_debug);
646: --
647: if g_debug then
648: --
649: hr_utility.trace('g_request_id : '||to_char(g_request_id));
650: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
646: --
647: if g_debug then
648: --
649: hr_utility.trace('g_request_id : '||to_char(g_request_id));
650: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
647: if g_debug then
648: --
649: hr_utility.trace('g_request_id : '||to_char(g_request_id));
650: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
648: --
649: hr_utility.trace('g_request_id : '||to_char(g_request_id));
650: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
649: hr_utility.trace('g_request_id : '||to_char(g_request_id));
650: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
650: hr_utility.trace('g_business_group_id : '||to_char(g_business_group_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
651: hr_utility.trace('g_effective_yyyymm : '||g_effective_yyyymm);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
652: hr_utility.trace('g_effective_som : '||to_char(g_effective_som,'YYYY/MM/DD'));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
653: hr_utility.trace('g_effective_eom : '||to_char(g_effective_eom,'YYYY/MM/DD'));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
654: hr_utility.trace('g_effective_soy : '||to_char(g_effective_soy,'YYYY/MM/DD'));
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
655: hr_utility.trace('g_effective_eoy : '||to_char(g_effective_eoy,'YYYY/MM/DD'));
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
656: hr_utility.trace('g_upload_date : '||to_char(g_upload_date,'YYYY/MM/DD'));
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
657: hr_utility.trace('g_session_date : '||to_char(g_session_date,'YYYY/MM/DD'));
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
658: hr_utility.trace('g_organization_id : '||to_char(g_organization_id));
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
659: hr_utility.trace('g_district_code : '||g_district_code);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
660: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
661: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
662: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
663: hr_utility.trace('g_file_dir : '||g_file_dir);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
664: hr_utility.trace('g_file_suffix : '||g_file_suffix);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
665: hr_utility.trace('g_file_split : '||g_file_split);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
666: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
667: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
668: hr_utility.trace('g_show_no_file : '||g_show_no_file);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
669: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
670: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
671: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
672: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
673: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
674: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
675: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
676: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
684: --
677: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
684: --
685: end if;
678: hr_utility.trace('g_action_if_exists : '||g_action_if_exists);
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
684: --
685: end if;
686: --
679: hr_utility.trace('g_reject_if_future_changes : '||g_reject_if_future_changes);
680: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
681: hr_utility.trace('g_create_asg_set_for_errored : '||g_create_asg_set_for_errored);
682: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
683: hr_utility.trace('pay_jp_report_pkg.g_db_char_set : '||pay_jp_report_pkg.g_db_char_set);
684: --
685: end if;
686: --
687: if g_debug then
684: --
685: end if;
686: --
687: if g_debug then
688: hr_utility.set_location(l_proc,1000);
689: end if;
690: --
691: end init;
692: --
861: --
862: begin
863: --
864: if g_debug then
865: hr_utility.set_location(l_proc,0);
866: hr_utility.trace('g_file_split : '||g_file_split);
867: end if;
868: --
869: l_file_tbl_cnt := 0;
862: begin
863: --
864: if g_debug then
865: hr_utility.set_location(l_proc,0);
866: hr_utility.trace('g_file_split : '||g_file_split);
867: end if;
868: --
869: l_file_tbl_cnt := 0;
870: l_ass_id_tbl_cnt := 0;
874: if g_file_split is null
875: or g_file_split = 'Y' then
876: --
877: if g_debug then
878: hr_utility.set_location(l_proc,10);
879: end if;
880: --
881: if g_assignment_set_id is null then
882: --
884: fetch csr_imp_file bulk collect into l_imp_file_tbl;
885: close csr_imp_file;
886: --
887: if g_debug then
888: hr_utility.set_location(l_proc,20);
889: hr_utility.trace('l_imp_file_tbl.count : '||to_char(l_imp_file_tbl.count));
890: end if;
891: --
892: else
885: close csr_imp_file;
886: --
887: if g_debug then
888: hr_utility.set_location(l_proc,20);
889: hr_utility.trace('l_imp_file_tbl.count : '||to_char(l_imp_file_tbl.count));
890: end if;
891: --
892: else
893: --
912: --
913: end if;
914: --
915: if g_debug then
916: hr_utility.set_location(l_proc,30);
917: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
918: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
919: hr_utility.trace('l_ass_amd_ind_tbl.count : '||to_char(l_ass_amd_ind_tbl.count));
920: end if;
913: end if;
914: --
915: if g_debug then
916: hr_utility.set_location(l_proc,30);
917: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
918: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
919: hr_utility.trace('l_ass_amd_ind_tbl.count : '||to_char(l_ass_amd_ind_tbl.count));
920: end if;
921: --
914: --
915: if g_debug then
916: hr_utility.set_location(l_proc,30);
917: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
918: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
919: hr_utility.trace('l_ass_amd_ind_tbl.count : '||to_char(l_ass_amd_ind_tbl.count));
920: end if;
921: --
922: open csr_imp_file_ass;
915: if g_debug then
916: hr_utility.set_location(l_proc,30);
917: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
918: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
919: hr_utility.trace('l_ass_amd_ind_tbl.count : '||to_char(l_ass_amd_ind_tbl.count));
920: end if;
921: --
922: open csr_imp_file_ass;
923: loop
1000: end loop;
1001: close csr_imp_file_ass;
1002: --
1003: if g_debug then
1004: hr_utility.set_location(l_proc,40);
1005: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1006: hr_utility.trace('l_ass_file_tbl.count : '||to_char(l_ass_file_tbl.count));
1007: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1008: end if;
1001: close csr_imp_file_ass;
1002: --
1003: if g_debug then
1004: hr_utility.set_location(l_proc,40);
1005: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1006: hr_utility.trace('l_ass_file_tbl.count : '||to_char(l_ass_file_tbl.count));
1007: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1008: end if;
1009: --
1002: --
1003: if g_debug then
1004: hr_utility.set_location(l_proc,40);
1005: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1006: hr_utility.trace('l_ass_file_tbl.count : '||to_char(l_ass_file_tbl.count));
1007: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1008: end if;
1009: --
1010: if l_ass_id_tbl.count > 0 then
1003: if g_debug then
1004: hr_utility.set_location(l_proc,40);
1005: hr_utility.trace('l_ass_id_tbl.count : '||to_char(l_ass_id_tbl.count));
1006: hr_utility.trace('l_ass_file_tbl.count : '||to_char(l_ass_file_tbl.count));
1007: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1008: end if;
1009: --
1010: if l_ass_id_tbl.count > 0 then
1011: --
1084: --
1085: end if;
1086: --
1087: if g_debug then
1088: hr_utility.set_location(l_proc,60);
1089: hr_utility.trace('l_imp_file_tbl.count : '||to_char(l_imp_file_tbl.count));
1090: end if;
1091: --
1092: end if;
1085: end if;
1086: --
1087: if g_debug then
1088: hr_utility.set_location(l_proc,60);
1089: hr_utility.trace('l_imp_file_tbl.count : '||to_char(l_imp_file_tbl.count));
1090: end if;
1091: --
1092: end if;
1093: --
1091: --
1092: end if;
1093: --
1094: if g_debug then
1095: hr_utility.set_location(l_proc,70);
1096: end if;
1097: --
1098: if l_imp_file_tbl.count > 0 then
1099: --
1181: --
1182: end if;
1183: --
1184: if g_debug then
1185: hr_utility.set_location(l_proc,80);
1186: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1187: hr_utility.trace('l_imp_file_ind_tbl.count : '||to_char(l_imp_file_ind_tbl.count));
1188: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
1189: hr_utility.trace('g_dup_file_wng_tbl.count : '||to_char(g_dup_file_wng_tbl.count));
1182: end if;
1183: --
1184: if g_debug then
1185: hr_utility.set_location(l_proc,80);
1186: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1187: hr_utility.trace('l_imp_file_ind_tbl.count : '||to_char(l_imp_file_ind_tbl.count));
1188: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
1189: hr_utility.trace('g_dup_file_wng_tbl.count : '||to_char(g_dup_file_wng_tbl.count));
1190: end if;
1183: --
1184: if g_debug then
1185: hr_utility.set_location(l_proc,80);
1186: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1187: hr_utility.trace('l_imp_file_ind_tbl.count : '||to_char(l_imp_file_ind_tbl.count));
1188: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
1189: hr_utility.trace('g_dup_file_wng_tbl.count : '||to_char(g_dup_file_wng_tbl.count));
1190: end if;
1191: --
1184: if g_debug then
1185: hr_utility.set_location(l_proc,80);
1186: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1187: hr_utility.trace('l_imp_file_ind_tbl.count : '||to_char(l_imp_file_ind_tbl.count));
1188: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
1189: hr_utility.trace('g_dup_file_wng_tbl.count : '||to_char(g_dup_file_wng_tbl.count));
1190: end if;
1191: --
1192: else
1185: hr_utility.set_location(l_proc,80);
1186: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1187: hr_utility.trace('l_imp_file_ind_tbl.count : '||to_char(l_imp_file_ind_tbl.count));
1188: hr_utility.trace('g_show_dup_file : '||g_show_dup_file);
1189: hr_utility.trace('g_dup_file_wng_tbl.count : '||to_char(g_dup_file_wng_tbl.count));
1190: end if;
1191: --
1192: else
1193: --
1191: --
1192: else
1193: --
1194: if g_debug then
1195: hr_utility.set_location(l_proc,90);
1196: end if;
1197: --
1198: l_file_tbl_cnt := l_file_tbl_cnt + 1;
1199: l_file_tbl(l_file_tbl_cnt).file_name := default_file_name(null,null,null);
1198: l_file_tbl_cnt := l_file_tbl_cnt + 1;
1199: l_file_tbl(l_file_tbl_cnt).file_name := default_file_name(null,null,null);
1200: --
1201: if g_debug then
1202: hr_utility.set_location(l_proc,100);
1203: end if;
1204: --
1205: if g_ass_set_amendment_type is not null
1206: and g_ass_set_amendment_type <> 'N' then
1222: --
1223: end if;
1224: --
1225: if g_debug then
1226: hr_utility.set_location(l_proc,110);
1227: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
1228: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1229: end if;
1230: --
1223: end if;
1224: --
1225: if g_debug then
1226: hr_utility.set_location(l_proc,110);
1227: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
1228: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1229: end if;
1230: --
1231: end if;
1224: --
1225: if g_debug then
1226: hr_utility.set_location(l_proc,110);
1227: hr_utility.trace('l_ass_amd_tbl.count : '||to_char(l_ass_amd_tbl.count));
1228: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1229: end if;
1230: --
1231: end if;
1232: --
1230: --
1231: end if;
1232: --
1233: if g_debug then
1234: hr_utility.set_location(l_proc,120);
1235: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1236: end if;
1237: --
1238: if g_debug
1231: end if;
1232: --
1233: if g_debug then
1234: hr_utility.set_location(l_proc,120);
1235: hr_utility.trace('l_file_tbl.count : '||to_char(l_file_tbl.count));
1236: end if;
1237: --
1238: if g_debug
1239: and g_detail_debug = 'Y' then
1241: if l_file_tbl.count > 0 then
1242: --
1243: for i in 1..l_file_tbl.count loop
1244: --
1245: hr_utility.trace(to_char(i)||' : '||l_file_tbl(i).file_name);
1246: --
1247: end loop;
1248: --
1249: end if;
1286: --
1287: end if;
1288: --
1289: if g_debug then
1290: hr_utility.set_location(l_proc,130);
1291: hr_utility.trace('g_file_tbl.count : '||to_char(g_file_tbl.count));
1292: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1293: hr_utility.trace('g_show_no_file : '||g_show_no_file);
1294: hr_utility.trace('g_no_file_wng_tbl.count : '||to_char(g_no_file_wng_tbl.count));
1287: end if;
1288: --
1289: if g_debug then
1290: hr_utility.set_location(l_proc,130);
1291: hr_utility.trace('g_file_tbl.count : '||to_char(g_file_tbl.count));
1292: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1293: hr_utility.trace('g_show_no_file : '||g_show_no_file);
1294: hr_utility.trace('g_no_file_wng_tbl.count : '||to_char(g_no_file_wng_tbl.count));
1295: end if;
1288: --
1289: if g_debug then
1290: hr_utility.set_location(l_proc,130);
1291: hr_utility.trace('g_file_tbl.count : '||to_char(g_file_tbl.count));
1292: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1293: hr_utility.trace('g_show_no_file : '||g_show_no_file);
1294: hr_utility.trace('g_no_file_wng_tbl.count : '||to_char(g_no_file_wng_tbl.count));
1295: end if;
1296: --
1289: if g_debug then
1290: hr_utility.set_location(l_proc,130);
1291: hr_utility.trace('g_file_tbl.count : '||to_char(g_file_tbl.count));
1292: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1293: hr_utility.trace('g_show_no_file : '||g_show_no_file);
1294: hr_utility.trace('g_no_file_wng_tbl.count : '||to_char(g_no_file_wng_tbl.count));
1295: end if;
1296: --
1297: if g_debug
1290: hr_utility.set_location(l_proc,130);
1291: hr_utility.trace('g_file_tbl.count : '||to_char(g_file_tbl.count));
1292: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1293: hr_utility.trace('g_show_no_file : '||g_show_no_file);
1294: hr_utility.trace('g_no_file_wng_tbl.count : '||to_char(g_no_file_wng_tbl.count));
1295: end if;
1296: --
1297: if g_debug
1298: and g_detail_debug = 'Y' then
1300: if g_file_tbl.count > 0 then
1301: --
1302: for i in 1..g_file_tbl.count loop
1303: --
1304: hr_utility.trace(to_char(i)||' : '||g_file_tbl(i).file_name);
1305: --
1306: end loop;
1307: --
1308: end if;
1329: --
1330: if g_debug
1331: and g_detail_debug = 'Y' then
1332: --
1333: hr_utility.trace(g_file_tbl(i).file_name||' : '||l_file_data_tbl.count);
1334: --
1335: end if;
1336: --
1337: if l_file_data_tbl.count > 0 then
1347: --
1348: <
1349: for k in 1..21 loop
1350: --
1351: hr_utility.trace(to_char(k)||' : '||pay_jp_report_pkg.split_str(l_cnv_data,k));
1352: --
1353: end loop loop_split_data;
1354: --
1355: end if;
1404: --
1405: end if;
1406: --
1407: if g_debug then
1408: hr_utility.set_location(l_proc,140);
1409: hr_utility.trace('g_imp_data_tbl.count : '||to_char(g_imp_data_tbl.count));
1410: end if;
1411: --
1412: if g_debug
1405: end if;
1406: --
1407: if g_debug then
1408: hr_utility.set_location(l_proc,140);
1409: hr_utility.trace('g_imp_data_tbl.count : '||to_char(g_imp_data_tbl.count));
1410: end if;
1411: --
1412: if g_debug
1413: and g_detail_debug = 'Y' then
1415: if g_imp_data_tbl.count > 0 then
1416: --
1417: for i in 1..g_imp_data_tbl.count loop
1418: --
1419: hr_utility.trace(to_char(i)||' :'||to_char(g_imp_data_tbl(i).file_id)||','||to_char(g_imp_data_tbl(i).line));
1420: --
1421: end loop;
1422: --
1423: end if;
1424: --
1425: end if;
1426: --
1427: if g_debug then
1428: hr_utility.set_location(l_proc,1000);
1429: end if;
1430: --
1431: end imp_file_data;
1432: --
1514: begin
1515: --
1516: if g_debug
1517: and g_detail_debug = 'Y' then
1518: hr_utility.set_location(l_proc,0);
1519: end if;
1520: --
1521: open csr_ass;
1522: fetch csr_ass into
1534: p_final_process_date := l_final_process_date;
1535: --
1536: if g_debug
1537: and g_detail_debug = 'Y' then
1538: hr_utility.trace('p_swot_number : '||p_swot_number);
1539: hr_utility.trace('p_employee_number : '||p_employee_number);
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1535: --
1536: if g_debug
1537: and g_detail_debug = 'Y' then
1538: hr_utility.trace('p_swot_number : '||p_swot_number);
1539: hr_utility.trace('p_employee_number : '||p_employee_number);
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1536: if g_debug
1537: and g_detail_debug = 'Y' then
1538: hr_utility.trace('p_swot_number : '||p_swot_number);
1539: hr_utility.trace('p_employee_number : '||p_employee_number);
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1537: and g_detail_debug = 'Y' then
1538: hr_utility.trace('p_swot_number : '||p_swot_number);
1539: hr_utility.trace('p_employee_number : '||p_employee_number);
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1545: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
1538: hr_utility.trace('p_swot_number : '||p_swot_number);
1539: hr_utility.trace('p_employee_number : '||p_employee_number);
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1545: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
1546: hr_utility.set_location(l_proc,1000);
1539: hr_utility.trace('p_employee_number : '||p_employee_number);
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1545: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
1546: hr_utility.set_location(l_proc,1000);
1547: end if;
1540: hr_utility.trace('p_district_code : '||p_district_code);
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1545: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
1546: hr_utility.set_location(l_proc,1000);
1547: end if;
1548: --
1541: hr_utility.trace('l_assignment_id : '||to_char(l_assignment_id));
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1545: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
1546: hr_utility.set_location(l_proc,1000);
1547: end if;
1548: --
1549: end get_ltxi_assignment;
1542: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
1543: hr_utility.trace('l_assignment_number : '||l_assignment_number);
1544: hr_utility.trace('l_regular_payment_date : '||to_char(l_regular_payment_date,'YYYY/MM/DD'));
1545: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
1546: hr_utility.set_location(l_proc,1000);
1547: end if;
1548: --
1549: end get_ltxi_assignment;
1550: --
1574: begin
1575: --
1576: if g_debug
1577: and g_detail_debug = 'Y' then
1578: hr_utility.set_location(l_proc,0);
1579: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
1580: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
1581: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1582: end if;
1575: --
1576: if g_debug
1577: and g_detail_debug = 'Y' then
1578: hr_utility.set_location(l_proc,0);
1579: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
1580: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
1581: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1582: end if;
1583: --
1576: if g_debug
1577: and g_detail_debug = 'Y' then
1578: hr_utility.set_location(l_proc,0);
1579: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
1580: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
1581: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1582: end if;
1583: --
1584: l_valid := true;
1577: and g_detail_debug = 'Y' then
1578: hr_utility.set_location(l_proc,0);
1579: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
1580: hr_utility.trace('g_assignment_set_id : '||to_char(g_assignment_set_id));
1581: hr_utility.trace('g_ass_amd_ind_tbl.count : '||to_char(g_ass_amd_ind_tbl.count));
1582: end if;
1583: --
1584: l_valid := true;
1585: --
1638: --
1639: if g_debug
1640: and g_detail_debug = 'Y' then
1641: --
1642: hr_utility.set_location(l_proc,10);
1643: --
1644: if l_valid then
1645: hr_utility.trace('ass set valid true');
1646: end if;
1641: --
1642: hr_utility.set_location(l_proc,10);
1643: --
1644: if l_valid then
1645: hr_utility.trace('ass set valid true');
1646: end if;
1647: --
1648: end if;
1649: --
1668: --
1669: if g_debug
1670: and g_detail_debug = 'Y' then
1671: --
1672: hr_utility.set_location(l_proc,20);
1673: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
1674: --
1675: if l_valid then
1676: hr_utility.trace('g_no_ass_wng_tbl valid true');
1669: if g_debug
1670: and g_detail_debug = 'Y' then
1671: --
1672: hr_utility.set_location(l_proc,20);
1673: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
1674: --
1675: if l_valid then
1676: hr_utility.trace('g_no_ass_wng_tbl valid true');
1677: end if;
1672: hr_utility.set_location(l_proc,20);
1673: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
1674: --
1675: if l_valid then
1676: hr_utility.trace('g_no_ass_wng_tbl valid true');
1677: end if;
1678: --
1679: end if;
1680: --
1684: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(c_res_date_iv_id,p_assignment_id,p_regular_payment_date),hr_api.g_eot);
1685: --
1686: if g_debug
1687: and g_detail_debug = 'Y' then
1688: hr_utility.set_location(l_proc,30);
1689: hr_utility.trace('l_non_res_date : '||to_char(l_non_res_date,'YYYY/MM/DD'));
1690: hr_utility.trace('l_res_date : '||to_char(l_res_date,'YYYY/MM/DD'));
1691: end if;
1692: --
1685: --
1686: if g_debug
1687: and g_detail_debug = 'Y' then
1688: hr_utility.set_location(l_proc,30);
1689: hr_utility.trace('l_non_res_date : '||to_char(l_non_res_date,'YYYY/MM/DD'));
1690: hr_utility.trace('l_res_date : '||to_char(l_res_date,'YYYY/MM/DD'));
1691: end if;
1692: --
1693: if l_non_res_date is not null then
1686: if g_debug
1687: and g_detail_debug = 'Y' then
1688: hr_utility.set_location(l_proc,30);
1689: hr_utility.trace('l_non_res_date : '||to_char(l_non_res_date,'YYYY/MM/DD'));
1690: hr_utility.trace('l_res_date : '||to_char(l_res_date,'YYYY/MM/DD'));
1691: end if;
1692: --
1693: if l_non_res_date is not null then
1694: --
1707: end if;
1708: --
1709: if g_debug
1710: and g_detail_debug = 'Y' then
1711: hr_utility.set_location(l_proc,40);
1712: hr_utility.trace('l_non_res_flag : '||l_non_res_flag);
1713: end if;
1714: --
1715: if l_non_res_flag is not null
1708: --
1709: if g_debug
1710: and g_detail_debug = 'Y' then
1711: hr_utility.set_location(l_proc,40);
1712: hr_utility.trace('l_non_res_flag : '||l_non_res_flag);
1713: end if;
1714: --
1715: if l_non_res_flag is not null
1716: and l_non_res_flag = 'Y' then
1730: --
1731: if g_debug
1732: and g_detail_debug = 'Y' then
1733: --
1734: hr_utility.set_location(l_proc,50);
1735: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
1736: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
1737: --
1738: if l_valid then
1731: if g_debug
1732: and g_detail_debug = 'Y' then
1733: --
1734: hr_utility.set_location(l_proc,50);
1735: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
1736: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
1737: --
1738: if l_valid then
1739: hr_utility.trace('g_non_res_wng_tbl valid true');
1732: and g_detail_debug = 'Y' then
1733: --
1734: hr_utility.set_location(l_proc,50);
1735: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
1736: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
1737: --
1738: if l_valid then
1739: hr_utility.trace('g_non_res_wng_tbl valid true');
1740: end if;
1735: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
1736: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
1737: --
1738: if l_valid then
1739: hr_utility.trace('g_non_res_wng_tbl valid true');
1740: end if;
1741: --
1742: end if;
1743: --
1774: --
1775: if g_debug
1776: and g_detail_debug = 'Y' then
1777: --
1778: hr_utility.set_location(l_proc,60);
1779: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
1780: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
1781: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
1782: --
1775: if g_debug
1776: and g_detail_debug = 'Y' then
1777: --
1778: hr_utility.set_location(l_proc,60);
1779: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
1780: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
1781: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
1782: --
1783: end if;
1776: and g_detail_debug = 'Y' then
1777: --
1778: hr_utility.set_location(l_proc,60);
1779: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
1780: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
1781: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
1782: --
1783: end if;
1784: --
1777: --
1778: hr_utility.set_location(l_proc,60);
1779: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
1780: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
1781: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
1782: --
1783: end if;
1784: --
1785: p_valid := l_valid;
1785: p_valid := l_valid;
1786: --
1787: if g_debug
1788: and g_detail_debug = 'Y' then
1789: hr_utility.set_location(l_proc,1000);
1790: end if;
1791: --
1792: end valid_ltxi_assignment;
1793: --
1810: begin
1811: --
1812: if g_debug
1813: and g_detail_debug = 'Y' then
1814: hr_utility.set_location(l_proc,0);
1815: hr_utility.trace('g_imp_data_tbl.count : '||to_char(g_imp_data_tbl.count));
1816: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1817: end if;
1818: --
1811: --
1812: if g_debug
1813: and g_detail_debug = 'Y' then
1814: hr_utility.set_location(l_proc,0);
1815: hr_utility.trace('g_imp_data_tbl.count : '||to_char(g_imp_data_tbl.count));
1816: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1817: end if;
1818: --
1819: if g_imp_data_tbl.count > 0 then
1812: if g_debug
1813: and g_detail_debug = 'Y' then
1814: hr_utility.set_location(l_proc,0);
1815: hr_utility.trace('g_imp_data_tbl.count : '||to_char(g_imp_data_tbl.count));
1816: hr_utility.trace('g_imp_file_ind_tbl.count : '||to_char(g_imp_file_ind_tbl.count));
1817: end if;
1818: --
1819: if g_imp_data_tbl.count > 0 then
1820: --
1999: end if;
2000: --
2001: if g_debug
2002: and g_detail_debug = 'Y' then
2003: hr_utility.trace('g_ass_id_tbl.count : '||to_char(g_ass_id_tbl.count));
2004: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2000: --
2001: if g_debug
2002: and g_detail_debug = 'Y' then
2003: hr_utility.trace('g_ass_id_tbl.count : '||to_char(g_ass_id_tbl.count));
2004: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2001: if g_debug
2002: and g_detail_debug = 'Y' then
2003: hr_utility.trace('g_ass_id_tbl.count : '||to_char(g_ass_id_tbl.count));
2004: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2002: and g_detail_debug = 'Y' then
2003: hr_utility.trace('g_ass_id_tbl.count : '||to_char(g_ass_id_tbl.count));
2004: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2003: hr_utility.trace('g_ass_id_tbl.count : '||to_char(g_ass_id_tbl.count));
2004: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2004: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2005: hr_utility.trace('g_ass_data_tbl.count : '||to_char(g_ass_data_tbl.count));
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2006: hr_utility.trace('g_valid_diff_ltax : '||g_valid_diff_ltax);
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2007: hr_utility.trace('g_diff_ltax_wng_tbl.count : '||to_char(g_diff_ltax_wng_tbl.count));
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2008: hr_utility.trace('g_inv_data_wng_tbl.count : '||to_char(g_inv_data_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2016: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
2009: hr_utility.trace('g_valid_incon_data : '||g_valid_incon_data);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2016: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
2017: hr_utility.set_location(l_proc,1000);
2010: hr_utility.trace('g_show_incon_data : '||g_show_incon_data);
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2016: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
2017: hr_utility.set_location(l_proc,1000);
2018: end if;
2011: hr_utility.trace('g_incon_data_wng_tbl.count : '||to_char(g_incon_data_wng_tbl.count));
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2016: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
2017: hr_utility.set_location(l_proc,1000);
2018: end if;
2019: --
2012: hr_utility.trace('g_no_ass_wng_tbl.count : '||to_char(g_no_ass_wng_tbl.count));
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2016: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
2017: hr_utility.set_location(l_proc,1000);
2018: end if;
2019: --
2020: end valid_file_data;
2013: hr_utility.trace('g_valid_non_res : '||g_valid_non_res);
2014: hr_utility.trace('g_non_res_wng_tbl.count : '||to_char(g_non_res_wng_tbl.count));
2015: hr_utility.trace('g_valid_dup_ass : '||g_valid_dup_ass);
2016: hr_utility.trace('g_dup_ass_wng_tbl.count : '||to_char(g_dup_ass_wng_tbl.count));
2017: hr_utility.set_location(l_proc,1000);
2018: end if;
2019: --
2020: end valid_file_data;
2021: --
2066: begin
2067: --
2068: if g_debug
2069: and g_detail_debug = 'Y' then
2070: hr_utility.set_location(l_proc,0);
2071: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2067: --
2068: if g_debug
2069: and g_detail_debug = 'Y' then
2070: hr_utility.set_location(l_proc,0);
2071: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2068: if g_debug
2069: and g_detail_debug = 'Y' then
2070: hr_utility.set_location(l_proc,0);
2071: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2076: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
2069: and g_detail_debug = 'Y' then
2070: hr_utility.set_location(l_proc,0);
2071: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2076: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
2077: hr_utility.trace('g_valid_term_flag : '||g_valid_term_flag);
2070: hr_utility.set_location(l_proc,0);
2071: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2076: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
2077: hr_utility.trace('g_valid_term_flag : '||g_valid_term_flag);
2078: end if;
2071: hr_utility.trace('p_assignment_id : '||to_char(p_assignment_id));
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2076: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
2077: hr_utility.trace('g_valid_term_flag : '||g_valid_term_flag);
2078: end if;
2079: --
2072: hr_utility.trace('p_batch_id : '||to_char(p_batch_id));
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2076: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
2077: hr_utility.trace('g_valid_term_flag : '||g_valid_term_flag);
2078: end if;
2079: --
2080: begin
2073: hr_utility.trace('g_create_entry_if_not_exist : '||g_create_entry_if_not_exist);
2074: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2075: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2076: hr_utility.trace('g_datetrack_eev : '||g_datetrack_eev);
2077: hr_utility.trace('g_valid_term_flag : '||g_valid_term_flag);
2078: end if;
2079: --
2080: begin
2081: --
2150: end;
2151: --
2152: if g_debug
2153: and g_detail_debug = 'Y' then
2154: hr_utility.set_location(l_proc,10);
2155: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
2156: hr_utility.trace('g_payroll_id : '||to_char(g_payroll_id));
2157: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2158: end if;
2151: --
2152: if g_debug
2153: and g_detail_debug = 'Y' then
2154: hr_utility.set_location(l_proc,10);
2155: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
2156: hr_utility.trace('g_payroll_id : '||to_char(g_payroll_id));
2157: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2158: end if;
2159: --
2152: if g_debug
2153: and g_detail_debug = 'Y' then
2154: hr_utility.set_location(l_proc,10);
2155: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
2156: hr_utility.trace('g_payroll_id : '||to_char(g_payroll_id));
2157: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2158: end if;
2159: --
2160: if g_mth_tbl.count > 0 then
2153: and g_detail_debug = 'Y' then
2154: hr_utility.set_location(l_proc,10);
2155: hr_utility.trace('l_payroll_id : '||to_char(l_payroll_id));
2156: hr_utility.trace('g_payroll_id : '||to_char(g_payroll_id));
2157: hr_utility.trace('g_mth_tbl.count : '||to_char(g_mth_tbl.count));
2158: end if;
2159: --
2160: if g_mth_tbl.count > 0 then
2161: --
2190: end if;
2191: --
2192: else
2193: --
2194: hr_utility.trace('l_mth_tbl.count is 0');
2195: --
2196: end if;
2197: --
2198: if g_debug
2196: end if;
2197: --
2198: if g_debug
2199: and g_detail_debug = 'Y' then
2200: hr_utility.set_location(l_proc,20);
2201: hr_utility.trace('g_ee_tbl.count : '||to_char(g_ee_tbl.count));
2202: end if;
2203: --
2204: if g_ee_tbl.count > 0 then
2197: --
2198: if g_debug
2199: and g_detail_debug = 'Y' then
2200: hr_utility.set_location(l_proc,20);
2201: hr_utility.trace('g_ee_tbl.count : '||to_char(g_ee_tbl.count));
2202: end if;
2203: --
2204: if g_ee_tbl.count > 0 then
2205: --
2220: l_final_process_date := g_ass_ind_tbl(p_assignment_id).final_process_date;
2221: --
2222: if g_debug
2223: and g_detail_debug = 'Y' then
2224: hr_utility.set_location(l_proc,30);
2225: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
2226: hr_utility.trace('g_ee_tbl('||to_char(i)||').upload_date : '||to_char(g_ee_tbl(i).upload_date,'YYYY/MM/DD'));
2227: end if;
2228: --
2221: --
2222: if g_debug
2223: and g_detail_debug = 'Y' then
2224: hr_utility.set_location(l_proc,30);
2225: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
2226: hr_utility.trace('g_ee_tbl('||to_char(i)||').upload_date : '||to_char(g_ee_tbl(i).upload_date,'YYYY/MM/DD'));
2227: end if;
2228: --
2229: if g_valid_term_flag is null
2222: if g_debug
2223: and g_detail_debug = 'Y' then
2224: hr_utility.set_location(l_proc,30);
2225: hr_utility.trace('l_final_process_date : '||to_char(l_final_process_date,'YYYY/MM/DD'));
2226: hr_utility.trace('g_ee_tbl('||to_char(i)||').upload_date : '||to_char(g_ee_tbl(i).upload_date,'YYYY/MM/DD'));
2227: end if;
2228: --
2229: if g_valid_term_flag is null
2230: or g_valid_term_flag= 'N'
2243: l_com_ltx_info_eev_rec);
2244: --
2245: if g_debug
2246: and g_detail_debug = 'Y' then
2247: hr_utility.set_location(l_proc,40);
2248: hr_utility.trace('l_ltax_start_mth : '||l_ltax_start_mth);
2249: hr_utility.trace('l_com_ltx_info_ee_rec.element_entry_id : '||to_char(l_com_ltx_info_ee_rec.element_entry_id));
2250: end if;
2251: --
2244: --
2245: if g_debug
2246: and g_detail_debug = 'Y' then
2247: hr_utility.set_location(l_proc,40);
2248: hr_utility.trace('l_ltax_start_mth : '||l_ltax_start_mth);
2249: hr_utility.trace('l_com_ltx_info_ee_rec.element_entry_id : '||to_char(l_com_ltx_info_ee_rec.element_entry_id));
2250: end if;
2251: --
2252: if l_com_ltx_info_ee_rec.element_entry_id is not null
2245: if g_debug
2246: and g_detail_debug = 'Y' then
2247: hr_utility.set_location(l_proc,40);
2248: hr_utility.trace('l_ltax_start_mth : '||l_ltax_start_mth);
2249: hr_utility.trace('l_com_ltx_info_ee_rec.element_entry_id : '||to_char(l_com_ltx_info_ee_rec.element_entry_id));
2250: end if;
2251: --
2252: if l_com_ltx_info_ee_rec.element_entry_id is not null
2253: and l_com_ltx_info_eev_rec.entry_value_tbl.count > 0 then
2409: --
2410: if g_debug
2411: and g_detail_debug = 'Y' then
2412: --
2413: hr_utility.set_location(l_proc,50);
2414: --
2415: for j in 1..7 loop
2416: --
2417: hr_utility.trace('l_new_value_tbl('||to_char(j)||') : '||l_new_value_tbl(j));
2413: hr_utility.set_location(l_proc,50);
2414: --
2415: for j in 1..7 loop
2416: --
2417: hr_utility.trace('l_new_value_tbl('||to_char(j)||') : '||l_new_value_tbl(j));
2418: --
2419: end loop;
2420: --
2421: end if;
2445: end if;
2446: --
2447: if g_debug
2448: and g_detail_debug = 'Y' then
2449: hr_utility.set_location(l_proc,60);
2450: hr_utility.trace('l_change_type : '||l_change_type);
2451: end if;
2452: --
2453: pay_jp_bee_utility_pkg.out(
2446: --
2447: if g_debug
2448: and g_detail_debug = 'Y' then
2449: hr_utility.set_location(l_proc,60);
2450: hr_utility.trace('l_change_type : '||l_change_type);
2451: end if;
2452: --
2453: pay_jp_bee_utility_pkg.out(
2454: p_full_name => g_ass_data_tbl(p_assignment_id).i_full_name,
2476: commit;
2477: --
2478: if g_debug
2479: and g_detail_debug = 'Y' then
2480: hr_utility.set_location(l_proc,70);
2481: hr_utility.trace('l_batch_line_id : '||to_char(l_batch_line_id));
2482: hr_utility.trace('l_batch_line_ovn : '||to_char(l_batch_line_ovn));
2483: end if;
2484: --
2477: --
2478: if g_debug
2479: and g_detail_debug = 'Y' then
2480: hr_utility.set_location(l_proc,70);
2481: hr_utility.trace('l_batch_line_id : '||to_char(l_batch_line_id));
2482: hr_utility.trace('l_batch_line_ovn : '||to_char(l_batch_line_ovn));
2483: end if;
2484: --
2485: end if;
2478: if g_debug
2479: and g_detail_debug = 'Y' then
2480: hr_utility.set_location(l_proc,70);
2481: hr_utility.trace('l_batch_line_id : '||to_char(l_batch_line_id));
2482: hr_utility.trace('l_batch_line_ovn : '||to_char(l_batch_line_ovn));
2483: end if;
2484: --
2485: end if;
2486: --
2491: end loop;
2492: --
2493: else
2494: --
2495: hr_utility.trace('g_ee_tbl.count is 0');
2496: --
2497: end if;
2498: --
2499: if g_debug
2497: end if;
2498: --
2499: if g_debug
2500: and g_detail_debug = 'Y' then
2501: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
2502: hr_utility.trace('g_upd_eev_wng_tbl.count : '||to_char(g_upd_eev_wng_tbl.count));
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2498: --
2499: if g_debug
2500: and g_detail_debug = 'Y' then
2501: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
2502: hr_utility.trace('g_upd_eev_wng_tbl.count : '||to_char(g_upd_eev_wng_tbl.count));
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2499: if g_debug
2500: and g_detail_debug = 'Y' then
2501: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
2502: hr_utility.trace('g_upd_eev_wng_tbl.count : '||to_char(g_upd_eev_wng_tbl.count));
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2507: hr_utility.trace('g_sp_with_wng_tbl.count : '||to_char(g_sp_with_wng_tbl.count));
2500: and g_detail_debug = 'Y' then
2501: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
2502: hr_utility.trace('g_upd_eev_wng_tbl.count : '||to_char(g_upd_eev_wng_tbl.count));
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2507: hr_utility.trace('g_sp_with_wng_tbl.count : '||to_char(g_sp_with_wng_tbl.count));
2508: hr_utility.set_location(l_proc,1000);
2501: hr_utility.trace('g_show_upd_eev : '||g_show_upd_eev);
2502: hr_utility.trace('g_upd_eev_wng_tbl.count : '||to_char(g_upd_eev_wng_tbl.count));
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2507: hr_utility.trace('g_sp_with_wng_tbl.count : '||to_char(g_sp_with_wng_tbl.count));
2508: hr_utility.set_location(l_proc,1000);
2509: end if;
2502: hr_utility.trace('g_upd_eev_wng_tbl.count : '||to_char(g_upd_eev_wng_tbl.count));
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2507: hr_utility.trace('g_sp_with_wng_tbl.count : '||to_char(g_sp_with_wng_tbl.count));
2508: hr_utility.set_location(l_proc,1000);
2509: end if;
2510: --
2503: hr_utility.trace('g_valid_no_upd : '||g_valid_no_upd);
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2507: hr_utility.trace('g_sp_with_wng_tbl.count : '||to_char(g_sp_with_wng_tbl.count));
2508: hr_utility.set_location(l_proc,1000);
2509: end if;
2510: --
2511: exception
2504: hr_utility.trace('g_show_no_upd : '||g_show_no_upd);
2505: hr_utility.trace('g_no_upd_wng_tbl.count : '||to_char(g_no_upd_wng_tbl.count));
2506: hr_utility.trace('g_valid_sp_with : '||g_valid_sp_with);
2507: hr_utility.trace('g_sp_with_wng_tbl.count : '||to_char(g_sp_with_wng_tbl.count));
2508: hr_utility.set_location(l_proc,1000);
2509: end if;
2510: --
2511: exception
2512: when others then
2512: when others then
2513: --
2514: if g_debug
2515: and g_detail_debug = 'Y' then
2516: hr_utility.set_location(l_proc,-1000);
2517: end if;
2518: --
2519: g_inv_ass_wng_tbl_cnt := g_inv_ass_wng_tbl_cnt + 1;
2520: g_inv_ass_wng_tbl(g_inv_ass_wng_tbl_cnt)
2528: to_char(sqlcode)||':'||substrb(sqlerrm,1,100);
2529: --
2530: if g_debug
2531: and g_detail_debug = 'Y' then
2532: hr_utility.set_location(l_proc,-1100);
2533: hr_utility.trace('g_inv_ass_wng_tbl.count : '||to_char(g_inv_ass_wng_tbl.count));
2534: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2535: end if;
2536: --
2529: --
2530: if g_debug
2531: and g_detail_debug = 'Y' then
2532: hr_utility.set_location(l_proc,-1100);
2533: hr_utility.trace('g_inv_ass_wng_tbl.count : '||to_char(g_inv_ass_wng_tbl.count));
2534: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2535: end if;
2536: --
2537: if g_ass_ind_tbl.count > 0 then
2530: if g_debug
2531: and g_detail_debug = 'Y' then
2532: hr_utility.set_location(l_proc,-1100);
2533: hr_utility.trace('g_inv_ass_wng_tbl.count : '||to_char(g_inv_ass_wng_tbl.count));
2534: hr_utility.trace('g_ass_ind_tbl.count : '||to_char(g_ass_ind_tbl.count));
2535: end if;
2536: --
2537: if g_ass_ind_tbl.count > 0 then
2538: --
2594: --
2595: begin
2596: --
2597: if g_debug then
2598: hr_utility.set_location(l_proc,0);
2599: end if;
2600: --
2601: pay_jp_bee_utility_pkg.g_num_of_outs := 0;
2602: --
2603: l_upload_date := fnd_date.canonical_to_date(p_upload_date);
2604: l_date_effective_changes := p_date_effective_changes;
2605: --
2606: if g_debug then
2607: hr_utility.set_location(l_proc,10);
2608: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2609: hr_utility.trace('l_upload_date : '||to_char(l_upload_date,'YYYY/MM/DD'));
2610: end if;
2611: --
2604: l_date_effective_changes := p_date_effective_changes;
2605: --
2606: if g_debug then
2607: hr_utility.set_location(l_proc,10);
2608: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2609: hr_utility.trace('l_upload_date : '||to_char(l_upload_date,'YYYY/MM/DD'));
2610: end if;
2611: --
2612: init(
2605: --
2606: if g_debug then
2607: hr_utility.set_location(l_proc,10);
2608: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2609: hr_utility.trace('l_upload_date : '||to_char(l_upload_date,'YYYY/MM/DD'));
2610: end if;
2611: --
2612: init(
2613: p_business_group_id,
2635: p_create_entry_if_not_exist,
2636: p_create_asg_set_for_errored);
2637: --
2638: if g_debug then
2639: hr_utility.set_location(l_proc,20);
2640: end if;
2641: --
2642: pay_jp_bee_utility_pkg.chk_date_effective_changes(
2643: g_action_if_exists,
2644: g_reject_if_future_changes,
2645: l_date_effective_changes);
2646: --
2647: if g_debug then
2648: hr_utility.set_location(l_proc,30);
2649: end if;
2650: --
2651: insert_session(g_session_date);
2652: --
2650: --
2651: insert_session(g_session_date);
2652: --
2653: if g_debug then
2654: hr_utility.set_location(l_proc,40);
2655: end if;
2656: --
2657: pay_batch_element_entry_api.create_batch_header(
2658: p_validate => false,
2668: p_batch_id => l_batch_id,
2669: p_object_version_number => l_batch_ovn);
2670: --
2671: if g_debug then
2672: hr_utility.set_location(l_proc,50);
2673: end if;
2674: --
2675: imp_file_data;
2676: --
2674: --
2675: imp_file_data;
2676: --
2677: if g_debug then
2678: hr_utility.set_location(l_proc,60);
2679: end if;
2680: --
2681: valid_file_data;
2682: --
2680: --
2681: valid_file_data;
2682: --
2683: if g_debug then
2684: hr_utility.set_location(l_proc,70);
2685: end if;
2686: --
2687: if g_ass_id_tbl.count > 0 then
2688: --
2696: --
2697: end if;
2698: --
2699: if g_debug then
2700: hr_utility.set_location(l_proc,80);
2701: end if;
2702: --
2703: delete_session;
2704: --
2702: --
2703: delete_session;
2704: --
2705: if g_debug then
2706: hr_utility.set_location(l_proc,90);
2707: end if;
2708: --
2709: if g_dup_file_wng_tbl_cnt > 0 then
2710: --
2721: --
2722: end if;
2723: --
2724: if g_debug then
2725: hr_utility.set_location(l_proc,100);
2726: end if;
2727: --
2728: if g_no_file_wng_tbl_cnt > 0 then
2729: --
2740: --
2741: end if;
2742: --
2743: if g_debug then
2744: hr_utility.set_location(l_proc,110);
2745: end if;
2746: --
2747: if g_diff_ltax_wng_tbl_cnt > 0 then
2748: --
2759: --
2760: end if;
2761: --
2762: if g_debug then
2763: hr_utility.set_location(l_proc,120);
2764: end if;
2765: --
2766: if g_inv_data_wng_tbl_cnt > 0 then
2767: --
2778: --
2779: end if;
2780: --
2781: if g_debug then
2782: hr_utility.set_location(l_proc,130);
2783: end if;
2784: --
2785: if g_incon_data_wng_tbl_cnt > 0 then
2786: --
2797: --
2798: end if;
2799: --
2800: if g_debug then
2801: hr_utility.set_location(l_proc,140);
2802: end if;
2803: --
2804: if g_no_ass_wng_tbl_cnt > 0 then
2805: --
2816: --
2817: end if;
2818: --
2819: if g_debug then
2820: hr_utility.set_location(l_proc,150);
2821: end if;
2822: --
2823: if g_non_res_wng_tbl_cnt > 0 then
2824: --
2835: --
2836: end if;
2837: --
2838: if g_debug then
2839: hr_utility.set_location(l_proc,160);
2840: end if;
2841: --
2842: if g_dup_ass_wng_tbl_cnt > 0 then
2843: --
2854: --
2855: end if;
2856: --
2857: if g_debug then
2858: hr_utility.set_location(l_proc,170);
2859: end if;
2860: --
2861: if g_upd_eev_wng_tbl_cnt > 0 then
2862: --
2873: --
2874: end if;
2875: --
2876: if g_debug then
2877: hr_utility.set_location(l_proc,180);
2878: end if;
2879: --
2880: if g_no_upd_wng_tbl_cnt > 0 then
2881: --
2892: --
2893: end if;
2894: --
2895: if g_debug then
2896: hr_utility.set_location(l_proc,190);
2897: end if;
2898: --
2899: if g_sp_with_wng_tbl_cnt > 0 then
2900: --
2911: --
2912: end if;
2913: --
2914: if g_debug then
2915: hr_utility.set_location(l_proc,200);
2916: end if;
2917: --
2918: if g_inv_ass_wng_tbl_cnt > 0 then
2919: --
2930: --
2931: end if;
2932: --
2933: if g_debug then
2934: hr_utility.set_location(l_proc,210);
2935: end if;
2936: --
2937: if g_err_ass_set_id is not null then
2938: --
2942: --
2943: end if;
2944: --
2945: if g_debug then
2946: hr_utility.set_location(l_proc,220);
2947: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2948: end if;
2949: --
2950: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
2943: end if;
2944: --
2945: if g_debug then
2946: hr_utility.set_location(l_proc,220);
2947: hr_utility.trace('pay_jp_bee_utility_pkg.g_num_of_outs : '||to_char(pay_jp_bee_utility_pkg.g_num_of_outs));
2948: end if;
2949: --
2950: if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
2951: --
2961: --
2962: end if;
2963: --
2964: if g_debug then
2965: hr_utility.set_location(l_proc,230);
2966: end if;
2967: --
2968: if g_inv_ass_wng_tbl_cnt > 0 then
2969: --
2975: --
2976: end if;
2977: --
2978: if g_debug then
2979: hr_utility.trace('p_retcode : '||to_char(p_retcode));
2980: hr_utility.trace('p_errbuf : '||p_errbuf);
2981: hr_utility.set_location(l_proc,1000);
2982: end if;
2983: --
2976: end if;
2977: --
2978: if g_debug then
2979: hr_utility.trace('p_retcode : '||to_char(p_retcode));
2980: hr_utility.trace('p_errbuf : '||p_errbuf);
2981: hr_utility.set_location(l_proc,1000);
2982: end if;
2983: --
2984: end transfer_imp_ltax_info_to_bee;
2977: --
2978: if g_debug then
2979: hr_utility.trace('p_retcode : '||to_char(p_retcode));
2980: hr_utility.trace('p_errbuf : '||p_errbuf);
2981: hr_utility.set_location(l_proc,1000);
2982: end if;
2983: --
2984: end transfer_imp_ltax_info_to_bee;
2985: --