DBA Data[Home] [Help]

APPS.PO_INBOUND_XML dependencies on PO_HEADERS_ALL

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 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 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