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 5140: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)

5136: = nvl(CE_AUTO_BANK_MATCH.csl_bank_account_text,'-99999')))
5137: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount
5138: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5139: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5140: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5141: AND NOT EXISTS
5142: (select NULL
5143: from ce_statement_reconcils_all r
5144: where r.statement_line_id = catv.statement_line_id

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

5183: 'MISC_CREDIT', - CE_AUTO_BANK_MATCH.csl_amount,
5184: CE_AUTO_BANK_MATCH.csl_amount)
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 NOT EXISTS
5189: (select NULL
5190: from ce_statement_reconcils_all r
5191: where r.statement_line_id = catv.statement_line_id

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

5235: AND nvl(catv.trx_number, '-99999')
5236: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5237: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5238: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5239: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5240: AND catv.bank_account_amount
5241: between (decode(sl.trx_type,
5242: 'MISC_CREDIT', sl.amount,
5243: - sl.amount) +

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

5333: AND nvl(catv.trx_number, '-99999')
5334: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-99999')
5335: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5336: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5337: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5338: AND catv.bank_account_amount
5339: between (decode(sl.trx_type,
5340: 'CREDIT', sl.amount,
5341: - sl.amount)

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

5430: AND nvl(catv.trx_number,'-99999') =
5431: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5432: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5433: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5434: AND catv.request_id = nvl(FND_GLOBAL.conc_request_id,-1)
5435: AND catv.bank_account_amount
5436: between (decode(sl.trx_type,
5437: 'DEBIT', sl.amount,
5438: - sl.amount)

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

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

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

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

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

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

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

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

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

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

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

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

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

6037:
6038: --delete from ce_statement_reconciliations
6039: delete from ce_statement_reconcils_all
6040: where statement_line_id = CE_AUTO_BANK_MATCH.trx_id2
6041: and request_id = nvl(FND_GLOBAL.conc_request_id,-1);
6042: CE_AUTO_BANK_MATCH.trx_id := CE_AUTO_BANK_MATCH.trx_id2;
6043: CE_AUTO_BANK_MATCH.csl_match_correction_type := 'REVERSAL';
6044: CE_AUTO_BANK_MATCH.corr_csl_amount := 0;
6045: CE_AUTO_BANK_MATCH.calc_csl_amount := 0;

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

6238: /*
6239: AP_RECONCILIATION_PKG.recon_reverse(
6240: X_CHECKRUN_ID => NULL,
6241: X_CHECK_ID => loc_trx_id,
6242: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
6243: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
6244: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
6245: X_PROGRAM_APPLICATION_ID => NULL,
6246: X_PROGRAM_ID => NULL,

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

6239: AP_RECONCILIATION_PKG.recon_reverse(
6240: X_CHECKRUN_ID => NULL,
6241: X_CHECK_ID => loc_trx_id,
6242: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
6243: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
6244: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
6245: X_PROGRAM_APPLICATION_ID => NULL,
6246: X_PROGRAM_ID => NULL,
6247: X_REQUEST_ID => NULL);

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

6240: X_CHECKRUN_ID => NULL,
6241: X_CHECK_ID => loc_trx_id,
6242: X_LAST_UPDATED_BY => nvl(FND_GLOBAL.user_id, -1),
6243: X_LAST_UPDATE_LOGIN => nvl(FND_GLOBAL.user_id, -1),
6244: X_CREATED_BY => nvl(FND_GLOBAL.user_id, -1),
6245: X_PROGRAM_APPLICATION_ID => NULL,
6246: X_PROGRAM_ID => NULL,
6247: X_REQUEST_ID => NULL);
6248: */

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

6261: X_EXCHANGE_RATE => CE_AUTO_BANK_MATCH.trx_exchange_rate,
6262: X_MATCHED_FLAG => 'Y',
6263: X_ACTUAL_VALUE_DATE => to_date(NULL),
6264: X_LAST_UPDATE_DATE => sysdate,
6265: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
6266: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
6267: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
6268: X_CREATION_DATE => sysdate,
6269: X_PROGRAM_UPDATE_DATE => to_date(NULL),

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

6262: X_MATCHED_FLAG => 'Y',
6263: X_ACTUAL_VALUE_DATE => to_date(NULL),
6264: X_LAST_UPDATE_DATE => sysdate,
6265: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
6266: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
6267: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
6268: X_CREATION_DATE => sysdate,
6269: X_PROGRAM_UPDATE_DATE => to_date(NULL),
6270: X_PROGRAM_APPLICATION_ID=> to_number(NULL),

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

6263: X_ACTUAL_VALUE_DATE => to_date(NULL),
6264: X_LAST_UPDATE_DATE => sysdate,
6265: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
6266: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
6267: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
6268: X_CREATION_DATE => sysdate,
6269: X_PROGRAM_UPDATE_DATE => to_date(NULL),
6270: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
6271: X_PROGRAM_ID => to_number(NULL),