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

Line 287: X_created_by => NVL(FND_GLOBAL.user_id,-1),

283: X_bank_account_text => NULL,
284: X_amount => CE_AUTO_BANK_MATCH.csl_amount,
285: X_charges_amount => CE_AUTO_BANK_MATCH.csl_charges_amount,
286: X_status => 'RECONCILED',
287: X_created_by => NVL(FND_GLOBAL.user_id,-1),
288: X_creation_date => sysdate,
289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
290: X_last_update_date => sysdate,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,

Line 289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

285: X_charges_amount => CE_AUTO_BANK_MATCH.csl_charges_amount,
286: X_status => 'RECONCILED',
287: X_created_by => NVL(FND_GLOBAL.user_id,-1),
288: X_creation_date => sysdate,
289: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
290: X_last_update_date => sysdate,
291: X_currency_code => CE_AUTO_BANK_MATCH.csl_currency_code,
292: X_original_amount => CE_AUTO_BANK_MATCH.csl_original_amount,
293: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 393: X_created_by => nvl(FND_GLOBAL.user_id,-1),

389: X_status_flag => Y_status_flag,
390: X_action_flag => 'C',
391: X_current_record_flag => 'Y',
392: X_auto_reconciled_flag => Y_auto_reconciled_flag,
393: X_created_by => nvl(FND_GLOBAL.user_id,-1),
394: X_creation_date => sysdate,
395: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
396: X_last_update_date => sysdate,
397: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),

Line 395: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),

391: X_current_record_flag => 'Y',
392: X_auto_reconciled_flag => Y_auto_reconciled_flag,
393: X_created_by => nvl(FND_GLOBAL.user_id,-1),
394: X_creation_date => sysdate,
395: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
396: X_last_update_date => sysdate,
397: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
398: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
399: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),

Line 397: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),

393: X_created_by => nvl(FND_GLOBAL.user_id,-1),
394: X_creation_date => sysdate,
395: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
396: X_last_update_date => sysdate,
397: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
398: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
399: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
400: X_program_update_date => sysdate);
401: ELSE

Line 398: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),

394: X_creation_date => sysdate,
395: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
396: X_last_update_date => sysdate,
397: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
398: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
399: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
400: X_program_update_date => sysdate);
401: ELSE
402: IF (Y_cleared_trx_type IN ('ROI_LINE','STATEMENT')) THEN

Line 399: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),

395: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
396: X_last_update_date => sysdate,
397: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
398: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
399: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
400: X_program_update_date => sysdate);
401: ELSE
402: IF (Y_cleared_trx_type IN ('ROI_LINE','STATEMENT')) THEN
403: CE_STATEMENT_RECONS_PKG.insert_row(

Line 416: X_created_by => nvl(FND_GLOBAL.user_id,-1),

412: X_status_flag => Y_status_flag,
413: X_action_flag => 'C',
414: X_current_record_flag => 'Y',
415: X_auto_reconciled_flag => Y_auto_reconciled_flag,
416: X_created_by => nvl(FND_GLOBAL.user_id,-1),
417: X_creation_date => sysdate,
418: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
419: X_last_update_date => sysdate,
420: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),

Line 418: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),

414: X_current_record_flag => 'Y',
415: X_auto_reconciled_flag => Y_auto_reconciled_flag,
416: X_created_by => nvl(FND_GLOBAL.user_id,-1),
417: X_creation_date => sysdate,
418: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
419: X_last_update_date => sysdate,
420: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
421: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
422: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),

Line 420: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),

416: X_created_by => nvl(FND_GLOBAL.user_id,-1),
417: X_creation_date => sysdate,
418: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
419: X_last_update_date => sysdate,
420: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
421: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
422: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
423: X_program_update_date => sysdate);
424: ELSE

Line 421: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),

417: X_creation_date => sysdate,
418: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
419: X_last_update_date => sysdate,
420: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
421: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
422: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
423: X_program_update_date => sysdate);
424: ELSE
425: CE_STATEMENT_RECONS_PKG.insert_row(

Line 422: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),

418: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
419: X_last_update_date => sysdate,
420: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
421: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
422: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
423: X_program_update_date => sysdate);
424: ELSE
425: CE_STATEMENT_RECONS_PKG.insert_row(
426: X_row_id => Y_rowid,

Line 438: X_created_by => nvl(FND_GLOBAL.user_id,-1),

434: X_status_flag => Y_status_flag,
435: X_action_flag => 'C',
436: X_current_record_flag => 'Y',
437: X_auto_reconciled_flag => Y_auto_reconciled_flag,
438: X_created_by => nvl(FND_GLOBAL.user_id,-1),
439: X_creation_date => sysdate,
440: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
441: X_last_update_date => sysdate,
442: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),

Line 440: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),

436: X_current_record_flag => 'Y',
437: X_auto_reconciled_flag => Y_auto_reconciled_flag,
438: X_created_by => nvl(FND_GLOBAL.user_id,-1),
439: X_creation_date => sysdate,
440: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
441: X_last_update_date => sysdate,
442: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
443: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
444: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),

Line 442: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),

438: X_created_by => nvl(FND_GLOBAL.user_id,-1),
439: X_creation_date => sysdate,
440: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
441: X_last_update_date => sysdate,
442: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
443: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
444: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
445: X_program_update_date => sysdate);
446:

Line 443: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),

439: X_creation_date => sysdate,
440: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
441: X_last_update_date => sysdate,
442: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
443: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
444: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
445: X_program_update_date => sysdate);
446:
447: END IF;

Line 444: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),

440: X_last_updated_by => nvl(FND_GLOBAL.user_id,-1),
441: X_last_update_date => sysdate,
442: X_request_id => nvl(FND_GLOBAL.conc_request_id,-1),
443: X_program_application_id =>nvl(FND_GLOBAL.prog_appl_id,-1),
444: X_program_id => nvl(FND_GLOBAL.conc_program_id,-1),
445: X_program_update_date => sysdate);
446:
447: END IF;
448: END IF;

Line 1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

1133: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1134: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1135: p_trx_amount => NVL(amount_to_clear,0),
1136: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1140:
1141: IF l_DEBUG in ('Y', 'C') THEN

Line 1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),

1134: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1135: p_trx_amount => NVL(amount_to_clear,0),
1136: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1140:
1141: IF l_DEBUG in ('Y', 'C') THEN
1142: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');

Line 1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );

1135: p_trx_amount => NVL(amount_to_clear,0),
1136: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1137: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1140:
1141: IF l_DEBUG in ('Y', 'C') THEN
1142: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1143: END IF;

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

1694: X_MATCHED_FLAG => 'Y',
1695: X_ACTUAL_VALUE_DATE =>
1696: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: X_LAST_UPDATE_DATE => sysdate,
1698: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1699: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1700: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1701: X_CREATION_DATE => sysdate,
1702: X_PROGRAM_UPDATE_DATE => sysdate,

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

1695: X_ACTUAL_VALUE_DATE =>
1696: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: X_LAST_UPDATE_DATE => sysdate,
1698: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1699: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1700: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1701: X_CREATION_DATE => sysdate,
1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

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

1696: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: X_LAST_UPDATE_DATE => sysdate,
1698: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1699: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1700: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1701: X_CREATION_DATE => sysdate,
1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

Line 1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

1699: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1700: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1701: X_CREATION_DATE => sysdate,
1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1707: );

Line 1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

1700: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1701: X_CREATION_DATE => sysdate,
1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1707: );
1708: IF l_DEBUG in ('Y', 'C') THEN

Line 1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),

1701: X_CREATION_DATE => sysdate,
1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1707: );
1708: IF l_DEBUG in ('Y', 'C') THEN
1709: cep_standard.debug('reconcile_pbatch: ' || '<<

Line 1732: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

1728: P_PASSIN_MODE => passin_mode ,
1729: P_STATEMENT_LINE_ID => statement_line_id ,
1730: P_STATEMENT_LINE_TYPE => null,
1731: P_LAST_UPDATE_DATE => sysdate,
1732: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1733: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1734: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1735: P_CREATION_DATE => sysdate,
1736: P_PROGRAM_UPDATE_DATE => sysdate,

Line 1733: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),

1729: P_STATEMENT_LINE_ID => statement_line_id ,
1730: P_STATEMENT_LINE_TYPE => null,
1731: P_LAST_UPDATE_DATE => sysdate,
1732: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1733: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1734: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1735: P_CREATION_DATE => sysdate,
1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),

Line 1734: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),

1730: P_STATEMENT_LINE_TYPE => null,
1731: P_LAST_UPDATE_DATE => sysdate,
1732: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1733: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1734: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1735: P_CREATION_DATE => sysdate,
1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

Line 1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),

1733: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1734: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1735: P_CREATION_DATE => sysdate,
1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1739: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1740: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1741: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007

Line 1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

1734: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1735: P_CREATION_DATE => sysdate,
1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1739: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1740: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1741: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1742:

Line 1739: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),

1735: P_CREATION_DATE => sysdate,
1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1739: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1740: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1741: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1742:
1743: cep_standard.debug('end call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');

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

1993: X_MATCHED_FLAG => clearing_flag,
1994: X_ACTUAL_VALUE_DATE =>
1995: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1996: X_LAST_UPDATE_DATE => sysdate,
1997: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1998: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1999: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2000: X_CREATION_DATE => sysdate,
2001: X_PROGRAM_UPDATE_DATE => sysdate,

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

1994: X_ACTUAL_VALUE_DATE =>
1995: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1996: X_LAST_UPDATE_DATE => sysdate,
1997: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1998: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1999: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2000: X_CREATION_DATE => sysdate,
2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

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

1995: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1996: X_LAST_UPDATE_DATE => sysdate,
1997: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1998: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1999: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2000: X_CREATION_DATE => sysdate,
2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

Line 2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

1998: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1999: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2000: X_CREATION_DATE => sysdate,
2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
2006: );

Line 2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

1999: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2000: X_CREATION_DATE => sysdate,
2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
2006: );
2007: IF l_DEBUG in ('Y', 'C') THEN

Line 2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),

2000: X_CREATION_DATE => sysdate,
2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
2006: );
2007: IF l_DEBUG in ('Y', 'C') THEN
2008: cep_standard.debug('reconcile_stmt: ' || '<<

Line 2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

2025: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2026: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2027: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
2028: p_trx_type => 'PAY',
2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2030: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2031: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2032: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2033: cleared_trx_type := 'PAY';

Line 2030: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),

2026: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2027: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
2028: p_trx_type => 'PAY',
2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2030: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2031: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2032: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2033: cleared_trx_type := 'PAY';
2034: end if;

Line 2031: p_created_by => NVL(FND_GLOBAL.user_id,-1) );

2027: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
2028: p_trx_type => 'PAY',
2029: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2030: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2031: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2032: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2033: cleared_trx_type := 'PAY';
2034: end if;
2035: end if;

Line 2074: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);

2070: where statement_line_id in
2071: (x_trx_id, CE_AUTO_BANK_MATCH.csl_statement_line_id)
2072: and reference_type = tx_type
2073: and nvl(current_record_flag, 'N') = 'Y'
2074: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);
2075:
2076: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2077: Y_statement_line_id => x_trx_id,
2078: Y_cleared_trx_type => 'STATEMENT',

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

2141: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2142: where statement_line_id = x_trx_id
2143: and reference_type <> 'STATEMENT'
2144: and reference_id = CE_AUTO_BANK_MATCH.trx_id
2145: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2146: end if;
2147: end if;
2148: elsif (passin_mode <> 'MANUAL_C') then
2149: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';

Line 2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

2418: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2419: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2420: p_trx_amount => NVL(amount_cleared,0),
2421: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2424: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2425:
2426: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');

Line 2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),

2419: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2420: p_trx_amount => NVL(amount_cleared,0),
2421: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2424: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2425:
2426: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2427: END IF;

Line 2424: p_created_by => NVL(FND_GLOBAL.user_id,-1) );

2420: p_trx_amount => NVL(amount_cleared,0),
2421: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2424: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2425:
2426: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2427: END IF;
2428: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;

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

2491: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2492: X_MATCHED_FLAG => clearing_flag,
2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,
2494: X_LAST_UPDATE_DATE => sysdate,
2495: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2496: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2497: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2498: X_CREATION_DATE => sysdate,
2499: X_PROGRAM_UPDATE_DATE => sysdate,

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

2492: X_MATCHED_FLAG => clearing_flag,
2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,
2494: X_LAST_UPDATE_DATE => sysdate,
2495: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2496: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2497: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2498: X_CREATION_DATE => sysdate,
2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

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

2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,
2494: X_LAST_UPDATE_DATE => sysdate,
2495: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2496: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2497: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2498: X_CREATION_DATE => sysdate,
2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

Line 2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

2496: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2497: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2498: X_CREATION_DATE => sysdate,
2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:

Line 2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

2497: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2498: X_CREATION_DATE => sysdate,
2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<<

Line 2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),

2498: X_CREATION_DATE => sysdate,
2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<< 2506: END IF;

Line 2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);

2700: END IF;
2701:
2702: /* Bug 16491164 Commented the following code
2703: -- Bug 16298972 Start
2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;

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

2841: X_EXCHANGE_RATE => xrate,
2842: X_MATCHED_FLAG => clearing_flag, -- Bug 13803033 Changed hardcoded 'Y' to clearing_flag
2843: X_ACTUAL_VALUE_DATE => value_date,
2844: X_LAST_UPDATE_DATE => sysdate,
2845: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2846: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2847: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2848: X_CREATION_DATE => sysdate,
2849: X_PROGRAM_UPDATE_DATE => to_date(NULL),

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

2842: X_MATCHED_FLAG => clearing_flag, -- Bug 13803033 Changed hardcoded 'Y' to clearing_flag
2843: X_ACTUAL_VALUE_DATE => value_date,
2844: X_LAST_UPDATE_DATE => sysdate,
2845: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2846: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2847: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2848: X_CREATION_DATE => sysdate,
2849: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2850: X_PROGRAM_APPLICATION_ID=> to_number(NULL),

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

2843: X_ACTUAL_VALUE_DATE => value_date,
2844: X_LAST_UPDATE_DATE => sysdate,
2845: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2846: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2847: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2848: X_CREATION_DATE => sysdate,
2849: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2850: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
2851: X_PROGRAM_ID => to_number(NULL),