APPS.PO_PRICE_BREAK_GRP dependencies on PO_LINES

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 204: l_source_document_line_id PO_LINES.po_line_id%TYPE;

200: l_base_curr_ext_precision number;
201:
202: --
203: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
204: l_source_document_line_id PO_LINES.po_line_id%TYPE;
205: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
206: l_new_currency_price PO_LINES.unit_price%TYPE;
207: l_return_status varchar2(1);
208: l_api_name CONSTANT varchar2(30) := 'GET_PRICE_BREAK';

Line 206: l_new_currency_price PO_LINES.unit_price%TYPE;

202: --
203: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
204: l_source_document_line_id PO_LINES.po_line_id%TYPE;
205: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
206: l_new_currency_price PO_LINES.unit_price%TYPE;
207: l_return_status varchar2(1);
208: l_api_name CONSTANT varchar2(30) := 'GET_PRICE_BREAK';
209: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
210: --

Line 213: l_base_unit_price PO_LINES.base_unit_price%TYPE;

209: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
210: --
211:
212: -- Bug 3343892
213: l_base_unit_price PO_LINES.base_unit_price%TYPE;
214:
215: -- Bug 3373445
216: l_currency_unit_price NUMBER := null;
217: l_precision NUMBER := null;

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);