APPS.PO_REQIMP_PKG dependencies on PO_LINES

Line 276: (x_po_line_id IN po_lines.po_line_id%TYPE,

272: -- | OUT : x_unit_price
273: -- +=======================================================================+
274:
275: PROCEDURE JA_AU_PRICE_BREAK
276: (x_po_line_id IN po_lines.po_line_id%TYPE,
277: x_unit_of_purchase IN po_line_locations.unit_meas_lookup_code%TYPE,
278: x_quantity IN po_line_locations.quantity%TYPE,
279: x_unit_price OUT NOCOPY po_line_locations.price_override%TYPE)
280: IS

Line 319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,

315: PROCEDURE JA_AU_SUGGESTED_DOCUMENT
316: (x_item_id IN po_requisitions_interface.item_id%TYPE,
317: x_document_header_id OUT NOCOPY po_requisitions_interface.autosource_doc_header_id%TYPE,
318: x_document_line_num OUT NOCOPY po_requisitions_interface.autosource_doc_line_num%TYPE,
319: x_po_line_id OUT NOCOPY po_lines.po_line_id%TYPE,
320: x_vendor_product_number OUT NOCOPY po_requisitions_interface.suggested_vendor_item_num%TYPE ,
321: x_vendor_id OUT NOCOPY po_requisitions_interface.suggested_vendor_id%TYPE ,
322: x_vendor_site_id OUT NOCOPY po_requisitions_interface.suggested_vendor_site_id%TYPE ,
323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,

Line 327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,

323: x_vendor_contact_id OUT NOCOPY po_requisitions_interface.suggested_vendor_contact_id%TYPE ,
324: x_vendor_name OUT NOCOPY po_requisitions_interface.suggested_vendor_name%TYPE ,
325: x_vendor_site_code OUT NOCOPY po_requisitions_interface.suggested_vendor_site%TYPE ,
326: x_unit_price OUT NOCOPY po_requisitions_interface.unit_price%TYPE ,
327: x_unit_of_purchase OUT NOCOPY po_lines.unit_meas_lookup_code%TYPE ,
328: x_suggested_vendor_id IN po_requisitions_interface.suggested_vendor_id%TYPE ,
329: x_suggested_vendor_site_id IN po_requisitions_interface.suggested_vendor_site_id%TYPE
330: )
331: IS

Line 347: po_lines pol,

343: nvl(pol.unit_price,0),
344: pol.unit_meas_lookup_code
345: FROM po_autosource_documents pad,
346: po_headers poh,
347: po_lines pol,
348: po_vendors pov,
349: po_vendor_sites povs,
350: po_autosource_vendors ven,
351: po_autosource_rules rul

Line 392: po_lines_all pl,

388: po_vendor_sites_all pvs,
389: po_asl_attributes paa,
390: po_asl_documents pad,
391: po_headers_all ph,
392: po_lines_all pl,
393: mrp_sr_source_org msso
394: WHERE pvs.vendor_site_id = pasl.vendor_site_id
395: AND pv.vendor_id = pasl.vendor_id
396: AND pasl.item_id = x_item_id

Line 433: po_lines_all pl,

429: po_vendor_sites_all pvs,
430: po_asl_attributes paa,
431: po_asl_documents pad,
432: po_headers_all ph,
433: po_lines_all pl,
434: mrp_sr_source_org msso
435: WHERE pvs.vendor_site_id = pasl.vendor_site_id
436: AND pv.vendor_id = pasl.vendor_id
437: AND pasl.item_id = x_item_id

Line 546: l_po_line_id po_lines.po_line_id%TYPE;

542: l_unit_price po_requisitions_interface.unit_price%TYPE ;
543: l_quote_line_price po_requisitions_interface.unit_price%TYPE ;
544: l_vendor_name po_requisitions_interface.suggested_vendor_name%TYPE ;
545: l_vendor_site_code po_requisitions_interface.suggested_vendor_site%TYPE ;
546: l_po_line_id po_lines.po_line_id%TYPE;
547: l_dummy char(1);
548: l_dummy2 po_requisitions_interface.unit_price%TYPE ;
549: l_uom_direct varchar2(30);
550:

Line 585: from po_lines_all

581: if x_autosource_doc_header_id is not null and
582: x_autosource_doc_line_num is not null then
583: select unit_meas_lookup_code
584: into l_uom_direct
585: from po_lines_all
586: where po_header_id = x_autosource_doc_header_id
587: and line_num = x_autosource_doc_line_num;
588: end if;
589: