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_XLA_EXTRACT_MAIN_PKG dependencies on FND_GLOBAL

Line 381: IF NVL(fnd_global.CONC_REQUEST_ID,0) <> 0 THEN

377: PROCEDURE log(
378: message IN VARCHAR2,
379: newline IN BOOLEAN DEFAULT TRUE) IS
380: BEGIN
381: IF NVL(fnd_global.CONC_REQUEST_ID,0) <> 0 THEN
382: IF message = 'NEWLINE' THEN
383: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
384: ELSIF (newline) THEN
385: FND_FILE.put_line(fnd_file.log,message);

Line 8078: last_updated_by = fnd_global.user_id,

8074: --
8075: UPDATE ar_cash_receipt_history_all
8076: SET posting_control_id = l_pst_id,
8077: gl_posted_date = l_date,
8078: last_updated_by = fnd_global.user_id,
8079: last_update_date = sysdate,
8080: last_update_login = fnd_global.user_id
8081: WHERE posting_control_id = -3
8082: AND (cash_receipt_id, event_id) IN

Line 8080: last_update_login = fnd_global.user_id

8076: SET posting_control_id = l_pst_id,
8077: gl_posted_date = l_date,
8078: last_updated_by = fnd_global.user_id,
8079: last_update_date = sysdate,
8080: last_update_login = fnd_global.user_id
8081: WHERE posting_control_id = -3
8082: AND (cash_receipt_id, event_id) IN
8083: (SELECT /*+ cardinality(EV,1) unnest */ ev.source_id_int_1, ev.event_id
8084: /* added hint as suggest by the perf team thru bug 13702457 */

Line 8101: last_updated_by = fnd_global.user_id,

8097:
8098: UPDATE AR_MISC_CASH_DISTRIBUTIONS_ALL
8099: SET posting_control_id = l_pst_id,
8100: gl_posted_date = l_date,
8101: last_updated_by = fnd_global.user_id,
8102: last_update_date = sysdate,
8103: last_update_login = fnd_global.user_id
8104: WHERE posting_control_id = -3
8105: AND (cash_receipt_id, event_id) IN

Line 8103: last_update_login = fnd_global.user_id

8099: SET posting_control_id = l_pst_id,
8100: gl_posted_date = l_date,
8101: last_updated_by = fnd_global.user_id,
8102: last_update_date = sysdate,
8103: last_update_login = fnd_global.user_id
8104: WHERE posting_control_id = -3
8105: AND (cash_receipt_id, event_id) IN
8106: (SELECT ev.source_id_int_1, ev.event_id
8107: FROM xla_post_acctg_events_v ev

Line 8125: last_updated_by = fnd_global.user_id,

8121: UPDATE /*+ INDEX(ra_cust_trx_line_gl_dist_all ra_cust_trx_line_gl_dist_n6) */
8122: ra_cust_trx_line_gl_dist_all
8123: SET posting_control_id = l_pst_id,
8124: gl_posted_date = l_date,
8125: last_updated_by = fnd_global.user_id,
8126: last_update_date = sysdate,
8127: last_update_login = fnd_global.user_id
8128: WHERE posting_control_id = -3
8129: AND (customer_trx_id, event_id) IN

Line 8127: last_update_login = fnd_global.user_id

8123: SET posting_control_id = l_pst_id,
8124: gl_posted_date = l_date,
8125: last_updated_by = fnd_global.user_id,
8126: last_update_date = sysdate,
8127: last_update_login = fnd_global.user_id
8128: WHERE posting_control_id = -3
8129: AND (customer_trx_id, event_id) IN
8130: (SELECT ev.source_id_int_1, ev.event_id
8131: FROM xla_post_acctg_events_v ev

Line 8150: last_updated_by = fnd_global.user_id,

8146: --
8147: UPDATE ar_adjustments_all
8148: SET posting_control_id = l_pst_id,
8149: gl_posted_date = l_date,
8150: last_updated_by = fnd_global.user_id,
8151: last_update_date = sysdate,
8152: last_update_login = fnd_global.user_id
8153: WHERE posting_control_id = -3
8154: AND adjustment_id IN

Line 8152: last_update_login = fnd_global.user_id

8148: SET posting_control_id = l_pst_id,
8149: gl_posted_date = l_date,
8150: last_updated_by = fnd_global.user_id,
8151: last_update_date = sysdate,
8152: last_update_login = fnd_global.user_id
8153: WHERE posting_control_id = -3
8154: AND adjustment_id IN
8155: (SELECT ev.source_id_int_1
8156: FROM xla_post_acctg_events_v ev

Line 8169: last_updated_by = fnd_global.user_id,

8165: --
8166: UPDATE ar_receivable_applications_all
8167: SET posting_control_id = l_pst_id,
8168: gl_posted_date = l_date,
8169: last_updated_by = fnd_global.user_id,
8170: last_update_date = sysdate,
8171: last_update_login = fnd_global.user_id
8172: WHERE posting_control_id = -3
8173: AND event_id IN

Line 8171: last_update_login = fnd_global.user_id

8167: SET posting_control_id = l_pst_id,
8168: gl_posted_date = l_date,
8169: last_updated_by = fnd_global.user_id,
8170: last_update_date = sysdate,
8171: last_update_login = fnd_global.user_id
8172: WHERE posting_control_id = -3
8173: AND event_id IN
8174: (SELECT /*+ LEADING(ev) CARDINALITY(ev,1) */ ev.event_id -- Added hint for bug 14335425
8175: FROM xla_post_acctg_events_v ev

Line 8192: last_updated_by = fnd_global.user_id,

8188: --
8189: UPDATE AR_TRANSACTION_HISTORY_ALL
8190: SET posting_control_id = l_pst_id,
8191: gl_posted_date = l_date,
8192: last_updated_by = fnd_global.user_id,
8193: last_update_date = sysdate,
8194: last_update_login = fnd_global.user_id
8195: WHERE posting_control_id = -3
8196: AND postable_flag='Y'

Line 8194: last_update_login = fnd_global.user_id

8190: SET posting_control_id = l_pst_id,
8191: gl_posted_date = l_date,
8192: last_updated_by = fnd_global.user_id,
8193: last_update_date = sysdate,
8194: last_update_login = fnd_global.user_id
8195: WHERE posting_control_id = -3
8196: AND postable_flag='Y'
8197: AND event_id IN
8198: (SELECT ev.event_id