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 ,
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
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: /*===========================================================================*/
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
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; /*
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:
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>
196: /* Bug2842675 */
197: l_base_curr_ext_precision number;
198:
199: --
200: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
201: l_source_document_line_id PO_LINES.po_line_id%TYPE;
202: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
203: l_new_currency_price PO_LINES.unit_price%TYPE;
204: l_return_status varchar2(1);
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
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;
508:
509: x_discount := 0; -- line price does not have a discount
510: x_price_break_id := NULL; -- SERVICES FPJ
511:
512: PO_HEADERS_SV3.get_currency_info ( p_source_document_header_id ,
513: x_currency_code ,
514: x_rate_type ,
515: x_rate_date ,
516: x_rate );
568: IF g_debug_stmt THEN
569: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Get Currency Info');
570: END IF; /* IF g_debug_stmt */
571:
572: PO_HEADERS_SV3.get_currency_info ( p_source_document_header_id ,
573: x_currency_code ,
574: x_rate_type ,
575: x_rate_date ,
576: x_rate );
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;
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;
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;
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;
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:
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 ,
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: --
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