12: PROCEDURE get_org_precision_values (PRECISION OUT NOCOPY NUMBER,
13: ext_precision OUT NOCOPY NUMBER,
14: min_acct_unit OUT NOCOPY NUMBER)
15: IS
16: functional_cur_code gl_sets_of_books.currency_code%TYPE := '';
17: BEGIN
18: -- get functional currency code
19: SELECT gls.currency_code
20: INTO functional_cur_code
19: SELECT gls.currency_code
20: INTO functional_cur_code
21: FROM
22: financials_system_parameters fsp,
23: gl_sets_of_books gls
24: WHERE
25: fsp.set_of_books_id = gls.set_of_books_id;
26:
27: fnd_currency.get_info(functional_cur_code, PRECISION,
38: p_po_currency_code IN VARCHAR2,
39: p_rate_type IN VARCHAR2,
40: p_rate_date IN DATE) RETURN NUMBER
41: IS
42: l_req_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
43: l_rate NUMBER := 1;
44: l_rate_type po_headers_all.rate_type%TYPE;
45: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
46: l_display_rate NUMBER;
120: IS
121: l_conversion_rate NUMBER := 1;
122: l_req_cur_code po_requisition_lines.currency_code%TYPE;
123: l_po_cur_code po_headers.currency_code%TYPE;
124: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
125: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
126: l_api_name VARCHAR2(30) := 'calculate_price_diff';
127: l_progress VARCHAR2(3) := '000';
128: BEGIN
121: l_conversion_rate NUMBER := 1;
122: l_req_cur_code po_requisition_lines.currency_code%TYPE;
123: l_po_cur_code po_headers.currency_code%TYPE;
124: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
125: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
126: l_api_name VARCHAR2(30) := 'calculate_price_diff';
127: l_progress VARCHAR2(3) := '000';
128: BEGIN
129:
226: IS
227: l_conversion_rate NUMBER := 1;
228: l_req_cur_code po_requisition_lines.currency_code%TYPE;
229: l_po_cur_code po_headers.currency_code%TYPE;
230: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
231: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
232: l_api_name VARCHAR2(30) := 'calculate_amount_diff';
233: l_progress VARCHAR2(3) := '000';
234: BEGIN
227: l_conversion_rate NUMBER := 1;
228: l_req_cur_code po_requisition_lines.currency_code%TYPE;
229: l_po_cur_code po_headers.currency_code%TYPE;
230: l_req_ou_cur_code gl_sets_of_books.currency_code%TYPE;
231: l_po_ou_cur_code gl_sets_of_books.currency_code%TYPE;
232: l_api_name VARCHAR2(30) := 'calculate_amount_diff';
233: l_progress VARCHAR2(3) := '000';
234: BEGIN
235: