APPS.PO_INBOUND_XML dependencies on PO_HEADERS_INTERFACE

Line 320: l_po_number po_headers_interface.document_num%type;

316: l_rec_upd_count NUMBER;
317: l_rec_can_count NUMBER;
318: l_lns_count NUMBER;
319: l_rejected_flag NUMBER:=0;
320: l_po_number po_headers_interface.document_num%type;
321: l_release_num po_headers_interface.release_num%type:=NULL;
322: l_revision_num po_headers_interface.revision_num%type;
323: l_line_num po_lines_interface.line_num%type:=NULL;
324: CURSOR l_csr_lines

Line 321: l_release_num po_headers_interface.release_num%type:=NULL;

317: l_rec_can_count NUMBER;
318: l_lns_count NUMBER;
319: l_rejected_flag NUMBER:=0;
320: l_po_number po_headers_interface.document_num%type;
321: l_release_num po_headers_interface.release_num%type:=NULL;
322: l_revision_num po_headers_interface.revision_num%type;
323: l_line_num po_lines_interface.line_num%type:=NULL;
324: CURSOR l_csr_lines
325: (

Line 322: l_revision_num po_headers_interface.revision_num%type;

318: l_lns_count NUMBER;
319: l_rejected_flag NUMBER:=0;
320: l_po_number po_headers_interface.document_num%type;
321: l_release_num po_headers_interface.release_num%type:=NULL;
322: l_revision_num po_headers_interface.revision_num%type;
323: l_line_num po_lines_interface.line_num%type:=NULL;
324: CURSOR l_csr_lines
325: (
326: p_interface_header_id NUMBER,p_process_code VARCHAR2

Line 392: FROM po_headers_interface

388: org_id
389: INTO l_po_number,
390: l_argument8,
391: l_argument9
392: FROM po_headers_interface
393: WHERE interface_header_id= l_interface_header_id;
394: EXCEPTION
395: WHEN OTHERS THEN
396: l_po_number:=NULL;

Line 631: FROM po_headers_interface

627: IF is_po_number_exists(l_po_number,l_argument9) THEN
628: BEGIN
629: SELECT revision_num
630: INTO l_revision_num
631: FROM po_headers_interface
632: WHERE interface_header_id= l_interface_header_id;
633: EXCEPTION
634: WHEN OTHERS THEN
635: l_revision_num:=NULL;

Line 679: FROM po_headers_interface

675: FROM po_lines_interface
676: WHERE interface_header_id =l_interface_header_id;
677: IF l_lns_count =0 THEN
678: DELETE
679: FROM po_headers_interface
680: WHERE interface_header_id =l_interface_header_id;
681: END IF;
682: END IF;
683: COMMIT;