DBA Data[Home] [Help]

APPS.PO_SOURCING2_SV dependencies on PO_LINES

Line 241: l_source_document_header_id PO_LINES.po_header_id%TYPE;

237: old_quantity number := 0;
238:
239: --
240: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
241: l_source_document_header_id PO_LINES.po_header_id%TYPE;
242: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
243: l_new_price PO_LINES.unit_price%TYPE;
244: l_return_status VARCHAR2(1);
245: l_api_name CONSTANT varchar2(30) := 'GET_BREAK_PRICE';

Line 243: l_new_price PO_LINES.unit_price%TYPE;

239: --
240: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
241: l_source_document_header_id PO_LINES.po_header_id%TYPE;
242: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
243: l_new_price PO_LINES.unit_price%TYPE;
244: l_return_status VARCHAR2(1);
245: l_api_name CONSTANT varchar2(30) := 'GET_BREAK_PRICE';
246: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
247: --

Line 311: l_base_unit_price PO_LINES.base_unit_price%TYPE;

307: l_currency_code PO_HEADERS.currency_code%TYPE;
308: --
309:
310: -- Bug 3343892
311: l_base_unit_price PO_LINES.base_unit_price%TYPE;
312:
313: l_adv_price NUMBER; --
314: l_contract_id PO_LINES.contract_id%TYPE; --
315:

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

310: -- Bug 3343892
311: l_base_unit_price PO_LINES.base_unit_price%TYPE;
312:
313: l_adv_price NUMBER; --
314: l_contract_id PO_LINES.contract_id%TYPE; --
315:
316:
317: BEGIN
318:

Line 378: po_lines_all pl

374: pl.po_header_id
375: INTO l_source_document_type,
376: l_source_document_header_id
377: FROM po_headers_all ph,
378: po_lines_all pl
379: WHERE ph.po_header_id = pl.po_header_id
380: AND pl.po_line_id = p_po_line_id;
381: ELSE
382: SELECT ph.type_lookup_code,

Line 519: FROM po_lines_all pl -- GA FPI

515:
516: if (l_price is null) then /* */
517: SELECT pl.unit_price
518: INTO l_price /* */
519: FROM po_lines_all pl -- GA FPI
520: WHERE pl.po_line_id = p_po_line_id;
521:
522: x_price_break_id := null; -- SERVICES FPJ
523: end if;

Line 1054: UPDATE po_lines_all

1050: g_user_id number := fnd_global.user_id;
1051:
1052: BEGIN
1053:
1054: UPDATE po_lines_all
1055: SET unit_price = p_price,
1056: base_unit_price = p_base_unit_price, --
1057: from_line_location_id = p_from_line_location_id, --
1058: last_update_date = sysdate,

Line 1135: l_base_unit_price PO_LINES.base_unit_price%TYPE;

1131: x_price OUT NOCOPY NUMBER,
1132: x_from_line_location_id OUT NOCOPY NUMBER --
1133: )
1134: IS
1135: l_base_unit_price PO_LINES.base_unit_price%TYPE;
1136: BEGIN
1137: get_shipment_price
1138: ( p_po_line_id => p_po_line_id
1139: , p_from_line_id => p_from_line_id