APPS.PO_INBOUND_XML dependencies on PO_HEADERS

Line 81: l_doc_num IN PO_HEADERS.segment1%TYPE,

77: l_return_status OUT NOCOPY VARCHAR2,
78: l_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
79: l_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
80: l_doc_id IN NUMBER,
81: l_doc_num IN PO_HEADERS.segment1%TYPE,
82: l_release_id IN NUMBER,
83: l_release_num IN NUMBER,
84: l_doc_line_id IN NUMBER,
85: l_doc_line_num IN NUMBER,

Line 93: l_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,

89: l_action_date IN DATE,
90: l_cancel_reason IN PO_LINES.cancel_reason%TYPE,
91: l_cancel_reqs_flag IN VARCHAR2,
92: l_print_flag IN VARCHAR2,
93: l_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
94: l_use_gldate IN VARCHAR2 DEFAULT NULL,
95: l_org_id IN NUMBER DEFAULT NULL )
96: IS
97: pragma autonomous_transaction;

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 472: FROM po_headers_all

468: END IF;
469: BEGIN
470: SELECT revision_num
471: INTO l_revision_num
472: FROM po_headers_all
473: WHERE segment1= l_po_number
474: AND org_id = l_argument9;
475: EXCEPTION
476: WHEN OTHERS THEN

Line 511: FROM po_headers_all

507: IF l_result_lines=1 THEN
508: BEGIN
509: SELECT revision_num
510: INTO l_revision_num
511: FROM po_headers_all
512: WHERE segment1= l_po_number
513: AND org_id = l_argument9;
514: EXCEPTION
515: WHEN OTHERS THEN

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 643: UPDATE po_headers_all

639: RAISE po_process_inbound;
640: END;
641: BEGIN
642: IF l_revision_num IS NOT NULL THEN
643: UPDATE po_headers_all
644: SET revision_num=l_revision_num
645: WHERE segment1 = l_po_number
646: AND org_id = l_argument9;
647: END IF;

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;

Line 752: FROM po_headers_all

748: IS
749: BEGIN
750: SELECT po_header_id
751: INTO p_po_header_id
752: FROM po_headers_all
753: WHERE segment1=p_po_number
754: AND org_id = p_operating_unit;
755: EXCEPTION
756: WHEN No_Data_Found THEN

Line 772: FROM po_headers_all

768: l_po_number NUMBER;
769: BEGIN
770: SELECT segment1
771: INTO l_po_number
772: FROM po_headers_all
773: WHERE segment1=p_po_number
774: AND org_id = p_operating_unit;
775: RETURN TRUE;
776: EXCEPTION