APPS.PO_PRICE_BREAK_GRP dependencies on PO_LINES_ALL

Line 29: p_po_line_num IN PO_LINES_ALL.line_num%TYPE

25: */
26:
27: FUNCTION get_line_price -- <2694908>
28: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
29: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
30: ) RETURN PO_LINES_ALL.unit_price%TYPE;
31:
32: /*===========================================================================*/
33: /*============================ BODY (Overloaded) ============================*/

Line 30: ) RETURN PO_LINES_ALL.unit_price%TYPE;

26:
27: FUNCTION get_line_price -- <2694908>
28: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
29: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
30: ) RETURN PO_LINES_ALL.unit_price%TYPE;
31:
32: /*===========================================================================*/
33: /*============================ BODY (Overloaded) ============================*/
34: /*===========================================================================*/

Line 253: , po_lines_all pol -- FPI GA

249: null, pol.unit_meas_lookup_code,
250: poll.unit_meas_lookup_code)
251: , poll.line_location_id -- SERVICES FPJ
252: FROM po_headers_all poh -- FPI GA
253: , po_lines_all pol -- FPI GA
254: , po_line_locations_all poll -- FPI GA
255: WHERE poh.po_header_id = p_source_document_header_id
256: and poh.po_header_id = pol.po_header_id
257: and pol.line_num = p_source_document_line_num

Line 409: po_lines_all pl

405: pl.po_line_id
406: INTO l_source_document_type,
407: l_source_document_line_id
408: FROM po_headers_all ph,
409: po_lines_all pl
410: WHERE ph.po_header_id = p_source_document_header_id
411: AND pl.po_header_id(+) = ph.po_header_id
412: AND pl.line_num(+) = p_source_document_line_num;
413:

Line 1141: p_po_line_num IN PO_LINES_ALL.line_num%TYPE

1137: =============================================================================*/
1138: FUNCTION get_line_price
1139: (
1140: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
1141: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1142: )
1143: RETURN PO_LINES_ALL.unit_price%TYPE
1144: IS
1145: x_unit_price PO_LINES_ALL.unit_price%TYPE;

Line 1143: RETURN PO_LINES_ALL.unit_price%TYPE

1139: (
1140: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
1141: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1142: )
1143: RETURN PO_LINES_ALL.unit_price%TYPE
1144: IS
1145: x_unit_price PO_LINES_ALL.unit_price%TYPE;
1146:
1147: BEGIN

Line 1145: x_unit_price PO_LINES_ALL.unit_price%TYPE;

1141: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1142: )
1143: RETURN PO_LINES_ALL.unit_price%TYPE
1144: IS
1145: x_unit_price PO_LINES_ALL.unit_price%TYPE;
1146:
1147: BEGIN
1148:
1149: SELECT unit_price

Line 1151: FROM po_lines_all

1147: BEGIN
1148:
1149: SELECT unit_price
1150: INTO x_unit_price
1151: FROM po_lines_all
1152: WHERE po_header_id = p_po_header_id
1153: AND line_num = p_po_line_num;
1154:
1155: return (x_unit_price);