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.ARP_PROCESS_LOCKBOX dependencies on FND_CURRENCIES

Line 8: TYPE curr_record IS RECORD ( currency_code fnd_currencies.currency_code%TYPE,

4: option_name ar_lookups.lookup_code%type,
5: cursor_name INTEGER);
6: TYPE opened_cursors IS table of option_record
7: INDEX BY BINARY_INTEGER;
8: TYPE curr_record IS RECORD ( currency_code fnd_currencies.currency_code%TYPE,
9: precision fnd_currencies.precision%TYPE );
10: TYPE table_curr IS TABLE OF curr_record INDEX BY BINARY_INTEGER;
11: --
12: opened_cursor_table opened_cursors;

Line 9: precision fnd_currencies.precision%TYPE );

5: cursor_name INTEGER);
6: TYPE opened_cursors IS table of option_record
7: INDEX BY BINARY_INTEGER;
8: TYPE curr_record IS RECORD ( currency_code fnd_currencies.currency_code%TYPE,
9: precision fnd_currencies.precision%TYPE );
10: TYPE table_curr IS TABLE OF curr_record INDEX BY BINARY_INTEGER;
11: --
12: opened_cursor_table opened_cursors;
13: g_matching_option ar_lookups.lookup_code%type;

Line 2295: fnd_currencies fc,

2291: nvl(trans_to_receipt_rate1,1),
2292: invoice_currency_code1,
2293: status
2294: FROM ar_payments_interface interface,
2295: fnd_currencies fc,
2296: fnd_currencies fc1
2297: WHERE invoice1 is NOT NULL
2298: AND transmission_request_id = p_trans_req_id
2299: AND status = 'AR_PLB_APP_OK'

Line 2296: fnd_currencies fc1

2292: invoice_currency_code1,
2293: status
2294: FROM ar_payments_interface interface,
2295: fnd_currencies fc,
2296: fnd_currencies fc1
2297: WHERE invoice1 is NOT NULL
2298: AND transmission_request_id = p_trans_req_id
2299: AND status = 'AR_PLB_APP_OK'
2300: AND fc.currency_code = interface.currency_code

Line 2332: fnd_currencies fc,

2328: nvl(trans_to_receipt_rate2,1),
2329: invoice_currency_code2,
2330: status
2331: FROM ar_payments_interface interface,
2332: fnd_currencies fc,
2333: fnd_currencies fc1
2334: WHERE invoice2 is NOT NULL
2335: AND transmission_request_id = p_trans_req_id
2336: AND status = 'AR_PLB_APP_OK'

Line 2333: fnd_currencies fc1

2329: invoice_currency_code2,
2330: status
2331: FROM ar_payments_interface interface,
2332: fnd_currencies fc,
2333: fnd_currencies fc1
2334: WHERE invoice2 is NOT NULL
2335: AND transmission_request_id = p_trans_req_id
2336: AND status = 'AR_PLB_APP_OK'
2337: AND fc.currency_code = interface.currency_code

Line 2369: fnd_currencies fc,

2365: nvl(trans_to_receipt_rate3,1),
2366: invoice_currency_code3,
2367: status
2368: FROM ar_payments_interface interface,
2369: fnd_currencies fc,
2370: fnd_currencies fc1
2371: WHERE invoice3 is NOT NULL
2372: AND transmission_request_id = p_trans_req_id
2373: AND status = 'AR_PLB_APP_OK'

Line 2370: fnd_currencies fc1

2366: invoice_currency_code3,
2367: status
2368: FROM ar_payments_interface interface,
2369: fnd_currencies fc,
2370: fnd_currencies fc1
2371: WHERE invoice3 is NOT NULL
2372: AND transmission_request_id = p_trans_req_id
2373: AND status = 'AR_PLB_APP_OK'
2374: AND fc.currency_code = interface.currency_code

Line 2406: fnd_currencies fc,

2402: nvl(trans_to_receipt_rate4,1),
2403: invoice_currency_code4,
2404: status
2405: FROM ar_payments_interface interface,
2406: fnd_currencies fc,
2407: fnd_currencies fc1
2408: WHERE invoice4 is NOT NULL
2409: AND transmission_request_id = p_trans_req_id
2410: AND status = 'AR_PLB_APP_OK'

Line 2407: fnd_currencies fc1

2403: invoice_currency_code4,
2404: status
2405: FROM ar_payments_interface interface,
2406: fnd_currencies fc,
2407: fnd_currencies fc1
2408: WHERE invoice4 is NOT NULL
2409: AND transmission_request_id = p_trans_req_id
2410: AND status = 'AR_PLB_APP_OK'
2411: AND fc.currency_code = interface.currency_code

Line 2443: fnd_currencies fc,

2439: nvl(trans_to_receipt_rate5,1),
2440: invoice_currency_code5,
2441: status
2442: FROM ar_payments_interface interface,
2443: fnd_currencies fc,
2444: fnd_currencies fc1
2445: WHERE invoice5 is NOT NULL
2446: AND transmission_request_id = p_trans_req_id
2447: AND status = 'AR_PLB_APP_OK'

Line 2444: fnd_currencies fc1

2440: invoice_currency_code5,
2441: status
2442: FROM ar_payments_interface interface,
2443: fnd_currencies fc,
2444: fnd_currencies fc1
2445: WHERE invoice5 is NOT NULL
2446: AND transmission_request_id = p_trans_req_id
2447: AND status = 'AR_PLB_APP_OK'
2448: AND fc.currency_code = interface.currency_code

Line 2480: fnd_currencies fc,

2476: nvl(trans_to_receipt_rate6,1),
2477: invoice_currency_code6,
2478: status
2479: FROM ar_payments_interface interface,
2480: fnd_currencies fc,
2481: fnd_currencies fc1
2482: WHERE invoice6 is NOT NULL
2483: AND transmission_request_id = p_trans_req_id
2484: AND status = 'AR_PLB_APP_OK'

Line 2481: fnd_currencies fc1

2477: invoice_currency_code6,
2478: status
2479: FROM ar_payments_interface interface,
2480: fnd_currencies fc,
2481: fnd_currencies fc1
2482: WHERE invoice6 is NOT NULL
2483: AND transmission_request_id = p_trans_req_id
2484: AND status = 'AR_PLB_APP_OK'
2485: AND fc.currency_code = interface.currency_code

Line 2517: fnd_currencies fc,

2513: nvl(trans_to_receipt_rate7,1),
2514: invoice_currency_code7,
2515: status
2516: FROM ar_payments_interface interface,
2517: fnd_currencies fc,
2518: fnd_currencies fc1
2519: WHERE invoice7 is NOT NULL
2520: AND transmission_request_id = p_trans_req_id
2521: AND status = 'AR_PLB_APP_OK'

Line 2518: fnd_currencies fc1

2514: invoice_currency_code7,
2515: status
2516: FROM ar_payments_interface interface,
2517: fnd_currencies fc,
2518: fnd_currencies fc1
2519: WHERE invoice7 is NOT NULL
2520: AND transmission_request_id = p_trans_req_id
2521: AND status = 'AR_PLB_APP_OK'
2522: AND fc.currency_code = interface.currency_code

Line 2554: fnd_currencies fc,

2550: nvl(trans_to_receipt_rate8,1),
2551: invoice_currency_code8,
2552: status
2553: FROM ar_payments_interface interface,
2554: fnd_currencies fc,
2555: fnd_currencies fc1
2556: WHERE invoice8 is NOT NULL
2557: AND transmission_request_id = p_trans_req_id
2558: AND status = 'AR_PLB_APP_OK'

Line 2555: fnd_currencies fc1

2551: invoice_currency_code8,
2552: status
2553: FROM ar_payments_interface interface,
2554: fnd_currencies fc,
2555: fnd_currencies fc1
2556: WHERE invoice8 is NOT NULL
2557: AND transmission_request_id = p_trans_req_id
2558: AND status = 'AR_PLB_APP_OK'
2559: AND fc.currency_code = interface.currency_code

Line 3327: FUNCTION get_currency_precision(p_currency_code IN fnd_currencies.currency_code%TYPE )

3323: WHEN OTHERS THEN
3324: return 'E';
3325: END get_format_amount;
3326: --
3327: FUNCTION get_currency_precision(p_currency_code IN fnd_currencies.currency_code%TYPE )
3328: RETURN NUMBER IS
3329: table_size NUMBER;
3330: i NUMBER;
3331: l_precision NUMBER;

Line 3344: FROM fnd_currencies

3340: END LOOP ;
3341:
3342: SELECT precision
3343: INTO l_precision
3344: FROM fnd_currencies
3345: WHERE currency_code = p_currency_code ;
3346:
3347: l_table_curr(table_size+1).currency_code := p_currency_code ;
3348: l_table_curr(table_size+1).precision := l_precision ;