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 2297: fnd_currencies fc,

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

Line 2298: fnd_currencies fc1

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

Line 2334: fnd_currencies fc,

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

Line 2335: fnd_currencies fc1

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

Line 2371: fnd_currencies fc,

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

Line 2372: fnd_currencies fc1

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

Line 2408: fnd_currencies fc,

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

Line 2409: fnd_currencies fc1

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

Line 2445: fnd_currencies fc,

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

Line 2446: fnd_currencies fc1

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

Line 2482: fnd_currencies fc,

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

Line 2483: fnd_currencies fc1

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

Line 2519: fnd_currencies fc,

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

Line 2520: fnd_currencies fc1

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

Line 2556: fnd_currencies fc,

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

Line 2557: fnd_currencies fc1

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

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

3332: WHEN OTHERS THEN
3333: return 'E';
3334: END get_format_amount;
3335: --
3336: FUNCTION get_currency_precision(p_currency_code IN fnd_currencies.currency_code%TYPE )
3337: RETURN NUMBER IS
3338: table_size NUMBER;
3339: i NUMBER;
3340: l_precision NUMBER;

Line 3353: FROM fnd_currencies

3349: END LOOP ;
3350:
3351: SELECT precision
3352: INTO l_precision
3353: FROM fnd_currencies
3354: WHERE currency_code = p_currency_code ;
3355:
3356: l_table_curr(table_size+1).currency_code := p_currency_code ;
3357: l_table_curr(table_size+1).precision := l_precision ;