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.AR_TRX_SUMMARY_PKG dependencies on FND_GLOBAL

Line 44: block_events('BLOCK',FND_GLOBAL.conc_request_id);

40:
41: IF nvl(l_po_value,'N') IN ('Y','A') THEN
42:
43: /* 6149811 - clear summary table data */
44: block_events('BLOCK',FND_GLOBAL.conc_request_id);
45:
46: clear_summary_tables('S'); -- only clear ar_trx_summary
47:
48: l_program_start_date := sysdate;

Line 869: LAST_UPDATED_BY = FND_GLOBAL.user_id,

865: set LARGEST_INV_AMOUNT = :amount,
866: LARGEST_INV_CUST_TRX_ID = :cust_trx_id,
867: LARGEST_INV_DATE = :trx_date,
868: LAST_UPDATE_DATE = sysdate,
869: LAST_UPDATED_BY = FND_GLOBAL.user_id,
870: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
871: where cust_account_id = :customer_id
872: and SITE_USE_ID = :site_use_id
873: and CURRENCY = :currency_code

Line 870: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

866: LARGEST_INV_CUST_TRX_ID = :cust_trx_id,
867: LARGEST_INV_DATE = :trx_date,
868: LAST_UPDATE_DATE = sysdate,
869: LAST_UPDATED_BY = FND_GLOBAL.user_id,
870: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
871: where cust_account_id = :customer_id
872: and SITE_USE_ID = :site_use_id
873: and CURRENCY = :currency_code
874: and AS_OF_DATE = :trx_date';

Line 1037: LAST_UPDATED_BY = FND_GLOBAL.user_id,

1033: 'Update ar_trx_summary
1034: set OP_BAL_HIGH_WATERMARK = :cum_balance,
1035: OP_BAL_HIGH_WATERMARK_DATE = :as_of_date,
1036: LAST_UPDATE_DATE = sysdate,
1037: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1039: where cust_account_id = :customer_id
1040: and SITE_USE_ID = :site_use_id
1041: and CURRENCY = :currency_code

Line 1038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

1034: set OP_BAL_HIGH_WATERMARK = :cum_balance,
1035: OP_BAL_HIGH_WATERMARK_DATE = :as_of_date,
1036: LAST_UPDATE_DATE = sysdate,
1037: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1038: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1039: where cust_account_id = :customer_id
1040: and SITE_USE_ID = :site_use_id
1041: and CURRENCY = :currency_code
1042: and AS_OF_DATE = :as_of_date';

Line 1116: block_events('UNBLOCK',FND_GLOBAL.conc_request_id);

1112:
1113: /* 6149811 - remove ar_conc_process_req row
1114: and submit child process to submit the events that
1115: were held during runtime */
1116: block_events('UNBLOCK',FND_GLOBAL.conc_request_id);
1117: submit_held_events;
1118:
1119: IF l_po_value = 'Y'
1120: THEN

Line 2087: LAST_UPDATED_BY = FND_GLOBAL.user_id,

2083: set LARGEST_INV_AMOUNT = :amount,
2084: LARGEST_INV_CUST_TRX_ID = :cust_trx_id,
2085: LARGEST_INV_DATE = :trx_date,
2086: LAST_UPDATE_DATE = sysdate,
2087: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2088: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2089: where cust_account_id = :customer_id
2090: and SITE_USE_ID = :site_use_id
2091: and CURRENCY = :currency_code

Line 2088: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2084: LARGEST_INV_CUST_TRX_ID = :cust_trx_id,
2085: LARGEST_INV_DATE = :trx_date,
2086: LAST_UPDATE_DATE = sysdate,
2087: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2088: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2089: where cust_account_id = :customer_id
2090: and SITE_USE_ID = :site_use_id
2091: and CURRENCY = :currency_code
2092: and AS_OF_DATE = :trx_date';

Line 2265: LAST_UPDATED_BY = FND_GLOBAL.user_id,

2261: 'Update /*+ INDEX(ats AR_TRX_SUMMARY_U1) */ ar_trx_summary ats
2262: set OP_BAL_HIGH_WATERMARK = :cum_balance,
2263: OP_BAL_HIGH_WATERMARK_DATE = :as_of_date,
2264: LAST_UPDATE_DATE = sysdate,
2265: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2266: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2267: where cust_account_id = :customer_id
2268: and SITE_USE_ID = :site_use_id
2269: and CURRENCY = :currency_code

Line 2266: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

2262: set OP_BAL_HIGH_WATERMARK = :cum_balance,
2263: OP_BAL_HIGH_WATERMARK_DATE = :as_of_date,
2264: LAST_UPDATE_DATE = sysdate,
2265: LAST_UPDATED_BY = FND_GLOBAL.user_id,
2266: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
2267: where cust_account_id = :customer_id
2268: and SITE_USE_ID = :site_use_id
2269: and CURRENCY = :currency_code
2270: and AS_OF_DATE = :as_of_date';

Line 2429: block_events('BLOCK',FND_GLOBAL.conc_request_id);

2425: and there is no special treatment for worker zero
2426: */
2427:
2428: /* block all events until this worker completes */
2429: block_events('BLOCK',FND_GLOBAL.conc_request_id);
2430:
2431: /* Collect customers for processing (ALL) */
2432: collect_customers(l_max_workers, l_worker_number,
2433: 'ALL', t_cust_id);

Line 2472: block_events('UNBLOCK',FND_GLOBAL.conc_request_id);

2468: END IF;
2469: END IF;
2470:
2471: /* unblock events for this worker */
2472: block_events('UNBLOCK',FND_GLOBAL.conc_request_id);
2473:
2474: /* Need to process held events here.. not sure how yet */
2475: IF l_worker_number = 0
2476: THEN