APPS.PA_PO_INTEGRATION_UTILS dependencies on PO_HEADERS_ALL

Line 153: from po_doc_style_headers st, po_headers_all poh, po_lines_all pol

149: select nvl(clm_flag,'N'), nvl(LINE_NUM_DISPLAY,'XXXX'), to_char(line_num)
150: into v_clm_flag,
151: v_clm_line_num,
152: v_line_num
153: from po_doc_style_headers st, po_headers_all poh, po_lines_all pol
154: where poh.style_id=st.style_id
155: and poh.po_header_id= pol.po_header_id
156: and pol.po_line_id=p_po_line_id;
157:

Line 674: l_po_header_id po_headers_all.po_header_id%TYPE;

670: AND pcsd.CI_ID = pci.CI_ID
671: AND pci.STATUS_CODE NOT IN ('CI_APPROVED', 'CI_CANCELED', 'CI_CLOSED' );
672:
673:
674: l_po_header_id po_headers_all.po_header_id%TYPE;
675: l_vendor_id po_headers_all.vendor_id%TYPE;
676: l_pji_source_flag pa_projects_all.pji_source_flag%TYPE;
677: l_multi_mod_val_result_id NUMBER;
678: l_exception_type VARCHAR2(200) := NULL ;

Line 675: l_vendor_id po_headers_all.vendor_id%TYPE;

671: AND pci.STATUS_CODE NOT IN ('CI_APPROVED', 'CI_CANCELED', 'CI_CLOSED' );
672:
673:
674: l_po_header_id po_headers_all.po_header_id%TYPE;
675: l_vendor_id po_headers_all.vendor_id%TYPE;
676: l_pji_source_flag pa_projects_all.pji_source_flag%TYPE;
677: l_multi_mod_val_result_id NUMBER;
678: l_exception_type VARCHAR2(200) := NULL ;
679: l_message_name VARCHAR2(200) := NULL;

Line 681: l_po_number po_headers_all.segment1%TYPE;

677: l_multi_mod_val_result_id NUMBER;
678: l_exception_type VARCHAR2(200) := NULL ;
679: l_message_name VARCHAR2(200) := NULL;
680: -- l_count NUMBER :=0; commented for the bug 13617899
681: l_po_number po_headers_all.segment1%TYPE;
682: l_related_document_number VARCHAR2(200) := NULL ; -- Added for the bug 13617899
683:
684: BEGIN
685: x_validation_result_type := 'SUCCESS';

Line 699: FROM po_headers_all

695: l_po_header_id := p_header_id_tbl(i);
696:
697: SELECT segment1
698: INTO l_po_number
699: FROM po_headers_all
700: WHERE po_header_id=l_po_header_id;
701:
702: ----------------Transfering the budget, which is defined for the Old supplier on to the New supplier.-----------------
703:

Line 786: FROM po_headers_all poh,

782:
783:
784: SELECT NVL(pp.pji_source_flag,'N')
785: INTO l_pji_source_flag
786: FROM po_headers_all poh,
787: po_distributions_all pod,
788: pa_projects_all pp
789: WHERE poh.po_header_id=l_po_header_id
790: AND poh.po_header_id =pod.po_header_id