486: d_api_name CONSTANT VARCHAR2(30) := 'remove_notified_draft_lines';
487: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
488: d_position NUMBER;
489:
490: l_po_line_id_tbl PO_TBL_NUMBER;
491: BEGIN
492:
493: d_position := 0;
494: IF (PO_LOG.d_proc) THEN
595: d_api_name CONSTANT VARCHAR2(30) := 'process_rejected_records';
596: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
597: d_position NUMBER;
598:
599: l_intf_header_id_tbl PO_TBL_NUMBER;
600: l_action_tbl PO_TBL_VARCHAR30;
601: l_dft_id_tbl PO_TBL_NUMBER;
602: l_po_header_id_tbl PO_TBL_NUMBER;
603:
597: d_position NUMBER;
598:
599: l_intf_header_id_tbl PO_TBL_NUMBER;
600: l_action_tbl PO_TBL_VARCHAR30;
601: l_dft_id_tbl PO_TBL_NUMBER;
602: l_po_header_id_tbl PO_TBL_NUMBER;
603:
604: l_dft_to_delete_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
605:
598:
599: l_intf_header_id_tbl PO_TBL_NUMBER;
600: l_action_tbl PO_TBL_VARCHAR30;
601: l_dft_id_tbl PO_TBL_NUMBER;
602: l_po_header_id_tbl PO_TBL_NUMBER;
603:
604: l_dft_to_delete_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
605:
606: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
600: l_action_tbl PO_TBL_VARCHAR30;
601: l_dft_id_tbl PO_TBL_NUMBER;
602: l_po_header_id_tbl PO_TBL_NUMBER;
603:
604: l_dft_to_delete_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
605:
606: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
607: l_chg_exist_tbl PO_TBL_VARCHAR1;
608:
602: l_po_header_id_tbl PO_TBL_NUMBER;
603:
604: l_dft_to_delete_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
605:
606: l_dft_exist_chg_check_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
607: l_chg_exist_tbl PO_TBL_VARCHAR1;
608:
609: BEGIN
610: d_position := 0;