eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PRICE_BREAK_GRP dependencies on PO_HEADERS_ALL

Line 21: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

17: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
18: --
19:
20: FUNCTION get_conversion_rate -- <2694908>
21: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
22: ) RETURN PO_HEADERS_ALL.rate%TYPE;
23:
24: FUNCTION get_line_price -- <2694908>
25: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

Line 22: ) RETURN PO_HEADERS_ALL.rate%TYPE;

18: --
19:
20: FUNCTION get_conversion_rate -- <2694908>
21: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
22: ) RETURN PO_HEADERS_ALL.rate%TYPE;
23:
24: FUNCTION get_line_price -- <2694908>
25: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
26: p_po_line_num IN PO_LINES_ALL.line_num%TYPE

Line 25: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

21: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
22: ) RETURN PO_HEADERS_ALL.rate%TYPE;
23:
24: FUNCTION get_line_price -- <2694908>
25: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
26: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
27: ) RETURN PO_LINES_ALL.unit_price%TYPE;
28:
29: /*===========================================================================*/

Line 184: v_req_rate_type po_headers_all.rate_type%TYPE; -- FPI GA

180: v_temp number;
181: v_return_unit_of_measure varchar2(26);
182:
183: v_req_sob_id number; -- FPI GA
184: v_req_rate_type po_headers_all.rate_type%TYPE; -- FPI GA
185: v_ga_flag varchar2(1); -- FPI GA
186: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA
187: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA
188: v_po_rate po_headers_all.rate%TYPE; -- FPI GA

Line 186: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA

182:
183: v_req_sob_id number; -- FPI GA
184: v_req_rate_type po_headers_all.rate_type%TYPE; -- FPI GA
185: v_ga_flag varchar2(1); -- FPI GA
186: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA
187: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA
188: v_po_rate po_headers_all.rate%TYPE; -- FPI GA
189:
190: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */

Line 187: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA

183: v_req_sob_id number; -- FPI GA
184: v_req_rate_type po_headers_all.rate_type%TYPE; -- FPI GA
185: v_ga_flag varchar2(1); -- FPI GA
186: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA
187: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA
188: v_po_rate po_headers_all.rate%TYPE; -- FPI GA
189:
190: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */
191:

Line 188: v_po_rate po_headers_all.rate%TYPE; -- FPI GA

184: v_req_rate_type po_headers_all.rate_type%TYPE; -- FPI GA
185: v_ga_flag varchar2(1); -- FPI GA
186: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA
187: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA
188: v_po_rate po_headers_all.rate%TYPE; -- FPI GA
189:
190: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */
191:
192: l_dummy_var BOOLEAN; -- <2694908>

Line 249: FROM po_headers_all poh -- FPI GA

245: , decode( poll.line_location_id,
246: null, pol.unit_meas_lookup_code,
247: poll.unit_meas_lookup_code)
248: , poll.line_location_id -- SERVICES FPJ
249: FROM po_headers_all poh -- FPI GA
250: , po_lines_all pol -- FPI GA
251: , po_line_locations_all poll -- FPI GA
252: WHERE poh.po_header_id = p_source_document_header_id
253: and poh.po_header_id = pol.po_header_id

Line 405: FROM po_headers_all ph,

401: SELECT ph.type_lookup_code,
402: pl.po_line_id
403: INTO l_source_document_type,
404: l_source_document_line_id
405: FROM po_headers_all ph,
406: po_lines_all pl
407: WHERE ph.po_header_id = p_source_document_header_id
408: AND pl.po_header_id(+) = ph.po_header_id
409: AND pl.line_num(+) = p_source_document_line_num;

Line 1067: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

1063:
1064: =============================================================================*/
1065: FUNCTION get_conversion_rate
1066: (
1067: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
1068: )
1069: RETURN PO_HEADERS_ALL.rate%TYPE
1070: IS
1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

Line 1069: RETURN PO_HEADERS_ALL.rate%TYPE

1065: FUNCTION get_conversion_rate
1066: (
1067: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
1068: )
1069: RETURN PO_HEADERS_ALL.rate%TYPE
1070: IS
1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1072: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1073: l_po_rate PO_HEADERS_ALL.rate%TYPE;

Line 1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

1067: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
1068: )
1069: RETURN PO_HEADERS_ALL.rate%TYPE
1070: IS
1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1072: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1073: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1074:
1075: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

Line 1072: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

1068: )
1069: RETURN PO_HEADERS_ALL.rate%TYPE
1070: IS
1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1072: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1073: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1074:
1075: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1076: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;

Line 1073: l_po_rate PO_HEADERS_ALL.rate%TYPE;

1069: RETURN PO_HEADERS_ALL.rate%TYPE
1070: IS
1071: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1072: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1073: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1074:
1075: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1076: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
1077:

Line 1078: x_rate PO_HEADERS_ALL.rate%TYPE;

1074:
1075: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1076: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
1077:
1078: x_rate PO_HEADERS_ALL.rate%TYPE;
1079:
1080: BEGIN
1081:
1082: SELECT currency_code ,

Line 1088: FROM po_headers_all

1084: nvl(rate, 1) --
1085: INTO l_currency_code ,
1086: l_ga_flag ,
1087: l_po_rate
1088: FROM po_headers_all
1089: WHERE po_header_id = p_po_header_id;
1090:
1091: -- If document is local Blanket, get rate from document header
1092: --

Line 1136: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

1132:
1133: =============================================================================*/
1134: FUNCTION get_line_price
1135: (
1136: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,
1137: p_po_line_num IN PO_LINES_ALL.line_num%TYPE
1138: )
1139: RETURN PO_LINES_ALL.unit_price%TYPE
1140: IS