APPS.PO_SOURCING2_SV dependencies on PO_HEADERS

Line 315: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;

311: -- Bug 670873, lpo, 05/28/98
312: old_quantity NUMBER := 0;
313:
314: --
315: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
316: l_source_document_header_id PO_LINES.po_header_id%TYPE;
317: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
318: l_new_price PO_LINES.unit_price%TYPE;
319: l_return_status VARCHAR2(1);

Line 339: po_headers_all poh -- 5684820

335: CURSOR unit_price IS
336: SELECT pll.price_override,
337: pll.line_location_id -- SERVICES FPJ
338: FROM po_line_locations_all pll, -- GA FPI
339: po_headers_all poh -- 5684820
340: /*
341: Bug fix for 2687718.
342: Added QUOTATION in the WHERE clause to ensure that pricing works when
343: a Standard PO is sourced to a Quotation through the Supplier Catalog.

Line 384: l_rate PO_HEADERS.rate%TYPE;

380:
381: l_api_version NUMBER := 1.0;
382:
383: --
384: l_rate PO_HEADERS.rate%TYPE;
385: l_rate_type PO_HEADERS.rate_type%TYPE;
386: l_currency_code PO_HEADERS.currency_code%TYPE;
387: --
388:

Line 385: l_rate_type PO_HEADERS.rate_type%TYPE;

381: l_api_version NUMBER := 1.0;
382:
383: --
384: l_rate PO_HEADERS.rate%TYPE;
385: l_rate_type PO_HEADERS.rate_type%TYPE;
386: l_currency_code PO_HEADERS.currency_code%TYPE;
387: --
388:
389: -- Bug 3343892

Line 386: l_currency_code PO_HEADERS.currency_code%TYPE;

382:
383: --
384: l_rate PO_HEADERS.rate%TYPE;
385: l_rate_type PO_HEADERS.rate_type%TYPE;
386: l_currency_code PO_HEADERS.currency_code%TYPE;
387: --
388:
389: -- Bug 3343892
390: l_base_unit_price PO_LINES.base_unit_price%TYPE;

Line 480: FROM po_headers_all ph,

476: SELECT ph.type_lookup_code,
477: pl.po_header_id
478: INTO l_source_document_type,
479: l_source_document_header_id
480: FROM po_headers_all ph,
481: po_lines_all pl
482: WHERE ph.po_header_id = pl.po_header_id
483: AND pl.po_line_id = p_po_line_id;
484: ELSE

Line 491: FROM po_headers_all ph

487: SELECT ph.type_lookup_code,
488: ph.po_header_id
489: INTO l_source_document_type,
490: l_source_document_header_id
491: FROM po_headers_all ph
492: WHERE ph.po_header_id = p_contract_id;
493: ELSE
494: l_source_document_type := NULL;
495: l_source_document_header_id := NULL;

Line 655: PO_HEADERS_SV3.get_currency_code(l_source_document_header_id);

651: -- rate information anymore
652:
653: IF (p_currency_code IS NULL) THEN
654: l_currency_code :=
655: PO_HEADERS_SV3.get_currency_code(l_source_document_header_id);
656: ELSE
657: l_currency_code := p_currency_code;
658: END IF;
659:

Line 767: l_currency_code := PO_HEADERS_SV3.get_currency_code(p_contract_id);

763: -- Use the currency code from the PO always. No need to pass in
764: -- rate information anymore
765:
766: IF (p_currency_code IS NULL) THEN
767: l_currency_code := PO_HEADERS_SV3.get_currency_code(p_contract_id);
768: ELSE
769: l_currency_code := p_currency_code;
770: END IF;
771: