APPS.PO_SOURCING2_SV dependencies on PO_LINES

Line 316: l_source_document_header_id PO_LINES.po_header_id%TYPE;

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);
320: l_api_name CONSTANT VARCHAR2(30) := 'GET_BREAK_PRICE';

Line 318: l_new_price PO_LINES.unit_price%TYPE;

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);
320: l_api_name CONSTANT VARCHAR2(30) := 'GET_BREAK_PRICE';
321: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
322: --

Line 390: l_base_unit_price PO_LINES.base_unit_price%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;
391:
392: l_adv_price NUMBER; --
393: l_contract_id PO_LINES.contract_id%TYPE; --
394:

Line 393: l_contract_id PO_LINES.contract_id%TYPE; --

389: -- Bug 3343892
390: l_base_unit_price PO_LINES.base_unit_price%TYPE;
391:
392: l_adv_price NUMBER; --
393: l_contract_id PO_LINES.contract_id%TYPE; --
394:
395:
396: BEGIN
397:

Line 481: po_lines_all pl

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

Line 628: FROM po_lines_all pl -- GA FPI

624:
625: IF (l_price IS NULL) THEN /* */
626: SELECT pl.unit_price
627: INTO l_price /* */
628: FROM po_lines_all pl -- GA FPI
629: WHERE pl.po_line_id = p_po_line_id;
630:
631: x_price_break_id := NULL; -- SERVICES FPJ
632: END IF;

Line 1272: UPDATE po_lines_all

1268: g_user_id NUMBER := fnd_global.user_id;
1269:
1270: BEGIN
1271:
1272: UPDATE po_lines_all
1273: SET unit_price = p_price,
1274: base_unit_price = p_base_unit_price, --
1275: from_line_location_id = p_from_line_location_id, --
1276: last_update_date = SYSDATE,

Line 1353: l_base_unit_price PO_LINES.base_unit_price%TYPE;

1349: x_price OUT NOCOPY NUMBER,
1350: x_from_line_location_id OUT NOCOPY NUMBER --
1351: )
1352: IS
1353: l_base_unit_price PO_LINES.base_unit_price%TYPE;
1354: BEGIN
1355: get_shipment_price
1356: (p_po_line_id => p_po_line_id
1357: , p_from_line_id => p_from_line_id