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 23: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

19:
20: /*
21: Bug 13388595 : We have defined this function in the Specs so other packages can access it, so this becomes redundant.
22: FUNCTION get_conversion_rate -- <2694908>
23: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
24: ) RETURN PO_HEADERS_ALL.rate%TYPE;
25: */
26:
27: FUNCTION get_line_price -- <2694908>

Line 24: ) RETURN PO_HEADERS_ALL.rate%TYPE;

20: /*
21: Bug 13388595 : We have defined this function in the Specs so other packages can access it, so this becomes redundant.
22: FUNCTION get_conversion_rate -- <2694908>
23: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
24: ) RETURN PO_HEADERS_ALL.rate%TYPE;
25: */
26:
27: FUNCTION get_line_price -- <2694908>
28: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

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

24: ) RETURN PO_HEADERS_ALL.rate%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: /*===========================================================================*/

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

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

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

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

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

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

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

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

Line 252: FROM po_headers_all poh -- FPI GA

248: , decode( poll.line_location_id,
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

Line 408: FROM po_headers_all ph,

404: SELECT ph.type_lookup_code,
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;

Line 1071: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

1067:
1068: =============================================================================*/
1069: FUNCTION get_conversion_rate
1070: (
1071: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
1072: )
1073: RETURN PO_HEADERS_ALL.rate%TYPE
1074: IS
1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

Line 1073: RETURN PO_HEADERS_ALL.rate%TYPE

1069: FUNCTION get_conversion_rate
1070: (
1071: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
1072: )
1073: RETURN PO_HEADERS_ALL.rate%TYPE
1074: IS
1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1076: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1077: l_po_rate PO_HEADERS_ALL.rate%TYPE;

Line 1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;

1071: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
1072: )
1073: RETURN PO_HEADERS_ALL.rate%TYPE
1074: IS
1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1076: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1077: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1078:
1079: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

Line 1076: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

1072: )
1073: RETURN PO_HEADERS_ALL.rate%TYPE
1074: IS
1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1076: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1077: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1078:
1079: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1080: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;

Line 1077: l_po_rate PO_HEADERS_ALL.rate%TYPE;

1073: RETURN PO_HEADERS_ALL.rate%TYPE
1074: IS
1075: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
1076: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1077: l_po_rate PO_HEADERS_ALL.rate%TYPE;
1078:
1079: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1080: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
1081:

Line 1082: x_rate PO_HEADERS_ALL.rate%TYPE;

1078:
1079: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
1080: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
1081:
1082: x_rate PO_HEADERS_ALL.rate%TYPE;
1083:
1084: BEGIN
1085:
1086: SELECT currency_code ,

Line 1092: FROM po_headers_all

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

Line 1140: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE ,

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