APPS.AR_TRX_SUMMARY_PKG dependencies on FND_GLOBAL

Line 11: values ('ARSUMREF',FND_GLOBAL.conc_request_id);

7: where CONCURRENT_PROGRAM_NAME = 'ARSUMREF';
8:
9: INSERT INTO AR_CONC_PROCESS_REQUESTS
10: (CONCURRENT_PROGRAM_NAME, REQUEST_ID)
11: values ('ARSUMREF',FND_GLOBAL.conc_request_id);
12:
13: COMMIT;
14: END;
15:

Line 764: LAST_UPDATED_BY = FND_GLOBAL.user_id,

760: text_update := 'Update ar_trx_summary set LARGEST_INV_AMOUNT = :amount,
761: LARGEST_INV_CUST_TRX_ID = :cust_trx_id,
762: LARGEST_INV_DATE = :trx_date,
763: LAST_UPDATE_DATE = sysdate,
764: LAST_UPDATED_BY = FND_GLOBAL.user_id,
765: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
766: where cust_account_id = :customer_id
767: and SITE_USE_ID = :site_use_id
768: and CURRENCY = :currency_code

Line 765: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

761: LARGEST_INV_CUST_TRX_ID = :cust_trx_id,
762: LARGEST_INV_DATE = :trx_date,
763: LAST_UPDATE_DATE = sysdate,
764: LAST_UPDATED_BY = FND_GLOBAL.user_id,
765: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
766: where cust_account_id = :customer_id
767: and SITE_USE_ID = :site_use_id
768: and CURRENCY = :currency_code
769: and AS_OF_DATE = :trx_date';

Line 945: LAST_UPDATED_BY = FND_GLOBAL.user_id,

941: 'Update ar_trx_summary
942: set OP_BAL_HIGH_WATERMARK = :cum_balance,
943: OP_BAL_HIGH_WATERMARK_DATE = :as_of_date,
944: LAST_UPDATE_DATE = sysdate,
945: LAST_UPDATED_BY = FND_GLOBAL.user_id,
946: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
947: where cust_account_id = :customer_id
948: and SITE_USE_ID = :site_use_id
949: and CURRENCY = :currency_code

Line 946: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

942: set OP_BAL_HIGH_WATERMARK = :cum_balance,
943: OP_BAL_HIGH_WATERMARK_DATE = :as_of_date,
944: LAST_UPDATE_DATE = sysdate,
945: LAST_UPDATED_BY = FND_GLOBAL.user_id,
946: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
947: where cust_account_id = :customer_id
948: and SITE_USE_ID = :site_use_id
949: and CURRENCY = :currency_code
950: and AS_OF_DATE = :as_of_date';

Line 1016: where request_id = FND_GLOBAL.conc_request_id;

1012:
1013: END IF; --is credit management installed
1014:
1015: DELETE from AR_CONC_PROCESS_REQUESTS
1016: where request_id = FND_GLOBAL.conc_request_id;
1017:
1018: COMMIT;
1019:
1020: /* Process the business events that have been raised running the run of this

Line 1098: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;

1094: ELSE
1095: fnd_file.put_line(fnd_file.log,'The profile AR_CMGT_ALLOW_SUMMARY_TABLE_REFRESH = N');
1096:
1097: DELETE from AR_CONC_PROCESS_REQUESTS
1098: WHERE REQUEST_ID = FND_GLOBAL.conc_request_id;
1099: COMMIT;
1100: END IF;
1101:
1102: /* over commit to insure that deleted rows are recorded */