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

Line 4893: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)

4889: = nvl(CE_AUTO_BANK_MATCH.csl_bank_account_text,'-99999')))
4890: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount
4891: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
4892: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4893: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
4894: AND NOT EXISTS
4895: (select NULL
4896: from ce_statement_reconcils_all r
4897: where r.statement_line_id = catv.statement_line_id

Line 4940: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)

4936: 'MISC_CREDIT', - CE_AUTO_BANK_MATCH.csl_amount,
4937: CE_AUTO_BANK_MATCH.csl_amount)
4938: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
4939: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4940: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
4941: AND NOT EXISTS
4942: (select NULL
4943: from ce_statement_reconcils_all r
4944: where r.statement_line_id = catv.statement_line_id

Line 4992: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)

4988: AND nvl(catv.trx_number, '-99999')
4989: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
4990: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
4991: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4992: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
4993: AND catv.bank_account_amount
4994: between (decode(sl.trx_type,
4995: 'MISC_CREDIT', sl.amount,
4996: - sl.amount) +

Line 5090: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)

5086: AND nvl(catv.trx_number, '-99999')
5087: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-99999')
5088: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5089: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5090: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5091: AND catv.bank_account_amount
5092: between (decode(sl.trx_type,
5093: 'CREDIT', sl.amount,
5094: - sl.amount)

Line 5187: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)

5183: AND nvl(catv.trx_number,'-99999') =
5184: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5185: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5186: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5187: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5188: AND catv.bank_account_amount
5189: between (decode(sl.trx_type,
5190: 'DEBIT', sl.amount,
5191: - sl.amount)

Line 5746: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),

5742: /*
5743: AP_RECONCILIATION_PKG.recon_reverse(
5744: X_CHECKRUN_ID => NULL,
5745: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
5746: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
5747: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
5748: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
5749: X_PROGRAM_APPLICATION_ID => NULL,
5750: X_PROGRAM_ID => NULL,

Line 5747: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),

5743: AP_RECONCILIATION_PKG.recon_reverse(
5744: X_CHECKRUN_ID => NULL,
5745: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
5746: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
5747: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
5748: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
5749: X_PROGRAM_APPLICATION_ID => NULL,
5750: X_PROGRAM_ID => NULL,
5751: X_REQUEST_ID => NULL);

Line 5748: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),

5744: X_CHECKRUN_ID => NULL,
5745: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
5746: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
5747: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
5748: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
5749: X_PROGRAM_APPLICATION_ID => NULL,
5750: X_PROGRAM_ID => NULL,
5751: X_REQUEST_ID => NULL);
5752: */

Line 5769: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

5765: X_EXCHANGE_RATE => CE_AUTO_BANK_MATCH.trx_exchange_rate,
5766: X_MATCHED_FLAG => 'Y',
5767: X_ACTUAL_VALUE_DATE => to_date(NULL),
5768: X_LAST_UPDATE_DATE => sysdate,
5769: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
5770: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
5771: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
5772: X_CREATION_DATE => sysdate,
5773: X_PROGRAM_UPDATE_DATE => to_date(NULL),

Line 5770: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),

5766: X_MATCHED_FLAG => 'Y',
5767: X_ACTUAL_VALUE_DATE => to_date(NULL),
5768: X_LAST_UPDATE_DATE => sysdate,
5769: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
5770: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
5771: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
5772: X_CREATION_DATE => sysdate,
5773: X_PROGRAM_UPDATE_DATE => to_date(NULL),
5774: X_PROGRAM_APPLICATION_ID=> to_number(NULL),

Line 5771: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),

5767: X_ACTUAL_VALUE_DATE => to_date(NULL),
5768: X_LAST_UPDATE_DATE => sysdate,
5769: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
5770: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
5771: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
5772: X_CREATION_DATE => sysdate,
5773: X_PROGRAM_UPDATE_DATE => to_date(NULL),
5774: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
5775: X_PROGRAM_ID => to_number(NULL),

Line 5794: and request_id = nvl(FND_GLOBAL.conc_request_id,-1);

5790:
5791: --delete from ce_statement_reconciliations
5792: delete from ce_statement_reconcils_all
5793: where statement_line_id = CE_AUTO_BANK_MATCH.trx_id2
5794: and request_id = nvl(FND_GLOBAL.conc_request_id,-1);
5795: CE_AUTO_BANK_MATCH.trx_id := CE_AUTO_BANK_MATCH.trx_id2;
5796: CE_AUTO_BANK_MATCH.csl_match_correction_type := 'REVERSAL';
5797: CE_AUTO_BANK_MATCH.corr_csl_amount := 0;
5798: CE_AUTO_BANK_MATCH.calc_csl_amount := 0;

Line 5995: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),

5991: /*
5992: AP_RECONCILIATION_PKG.recon_reverse(
5993: X_CHECKRUN_ID => NULL,
5994: X_CHECK_ID => loc_trx_id,
5995: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
5996: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
5997: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
5998: X_PROGRAM_APPLICATION_ID => NULL,
5999: X_PROGRAM_ID => NULL,

Line 5996: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),

5992: AP_RECONCILIATION_PKG.recon_reverse(
5993: X_CHECKRUN_ID => NULL,
5994: X_CHECK_ID => loc_trx_id,
5995: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
5996: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
5997: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
5998: X_PROGRAM_APPLICATION_ID => NULL,
5999: X_PROGRAM_ID => NULL,
6000: X_REQUEST_ID => NULL);

Line 5997: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),

5993: X_CHECKRUN_ID => NULL,
5994: X_CHECK_ID => loc_trx_id,
5995: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
5996: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
5997: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
5998: X_PROGRAM_APPLICATION_ID => NULL,
5999: X_PROGRAM_ID => NULL,
6000: X_REQUEST_ID => NULL);
6001: */

Line 6018: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

6014: X_EXCHANGE_RATE => CE_AUTO_BANK_MATCH.trx_exchange_rate,
6015: X_MATCHED_FLAG => 'Y',
6016: X_ACTUAL_VALUE_DATE => to_date(NULL),
6017: X_LAST_UPDATE_DATE => sysdate,
6018: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
6019: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
6020: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
6021: X_CREATION_DATE => sysdate,
6022: X_PROGRAM_UPDATE_DATE => to_date(NULL),

Line 6019: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),

6015: X_MATCHED_FLAG => 'Y',
6016: X_ACTUAL_VALUE_DATE => to_date(NULL),
6017: X_LAST_UPDATE_DATE => sysdate,
6018: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
6019: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
6020: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
6021: X_CREATION_DATE => sysdate,
6022: X_PROGRAM_UPDATE_DATE => to_date(NULL),
6023: X_PROGRAM_APPLICATION_ID=> to_number(NULL),

Line 6020: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),

6016: X_ACTUAL_VALUE_DATE => to_date(NULL),
6017: X_LAST_UPDATE_DATE => sysdate,
6018: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
6019: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
6020: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
6021: X_CREATION_DATE => sysdate,
6022: X_PROGRAM_UPDATE_DATE => to_date(NULL),
6023: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
6024: X_PROGRAM_ID => to_number(NULL),