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 1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

1112: p_payment_id => cleared_trx_id, --CE_AUTO_BANK_MATCH.trx_id,
1113: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1118: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1119:
1120: IF l_DEBUG in ('Y', 'C') THEN

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

1113: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1118: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1119:
1120: IF l_DEBUG in ('Y', 'C') THEN
1121: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');

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

1114: p_trx_amount => NVL(amount_to_clear,0),
1115: p_trx_type => cleared_trx_type, --CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1116: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1117: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1118: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1119:
1120: IF l_DEBUG in ('Y', 'C') THEN
1121: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1122: END IF;

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

1663: X_MATCHED_FLAG => 'Y',
1664: X_ACTUAL_VALUE_DATE =>
1665: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1666: X_LAST_UPDATE_DATE => sysdate,
1667: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1668: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1669: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1670: X_CREATION_DATE => sysdate,
1671: X_PROGRAM_UPDATE_DATE => sysdate,

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

1664: X_ACTUAL_VALUE_DATE =>
1665: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1666: X_LAST_UPDATE_DATE => sysdate,
1667: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1668: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1669: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1670: X_CREATION_DATE => sysdate,
1671: X_PROGRAM_UPDATE_DATE => sysdate,
1672: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

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

1665: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1666: X_LAST_UPDATE_DATE => sysdate,
1667: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1668: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1669: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1670: X_CREATION_DATE => sysdate,
1671: X_PROGRAM_UPDATE_DATE => sysdate,
1672: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1673: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

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

1668: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1669: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1670: X_CREATION_DATE => sysdate,
1671: X_PROGRAM_UPDATE_DATE => sysdate,
1672: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1673: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1674: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1676: );

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

1669: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1670: X_CREATION_DATE => sysdate,
1671: X_PROGRAM_UPDATE_DATE => sysdate,
1672: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1673: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1674: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1676: );
1677: IF l_DEBUG in ('Y', 'C') THEN

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

1670: X_CREATION_DATE => sysdate,
1671: X_PROGRAM_UPDATE_DATE => sysdate,
1672: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1673: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1674: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1676: );
1677: IF l_DEBUG in ('Y', 'C') THEN
1678: cep_standard.debug('reconcile_pbatch: ' || '<<

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

1697: P_PASSIN_MODE => passin_mode ,
1698: P_STATEMENT_LINE_ID => statement_line_id ,
1699: P_STATEMENT_LINE_TYPE => null,
1700: P_LAST_UPDATE_DATE => sysdate,
1701: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1702: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1703: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1704: P_CREATION_DATE => sysdate,
1705: P_PROGRAM_UPDATE_DATE => sysdate,

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

1698: P_STATEMENT_LINE_ID => statement_line_id ,
1699: P_STATEMENT_LINE_TYPE => null,
1700: P_LAST_UPDATE_DATE => sysdate,
1701: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1702: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1703: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1704: P_CREATION_DATE => sysdate,
1705: P_PROGRAM_UPDATE_DATE => sysdate,
1706: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),

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

1699: P_STATEMENT_LINE_TYPE => null,
1700: P_LAST_UPDATE_DATE => sysdate,
1701: P_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1702: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1703: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1704: P_CREATION_DATE => sysdate,
1705: P_PROGRAM_UPDATE_DATE => sysdate,
1706: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1707: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

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

1702: P_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1703: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1704: P_CREATION_DATE => sysdate,
1705: P_PROGRAM_UPDATE_DATE => sysdate,
1706: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1707: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1708: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1709: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1710: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007

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

1703: P_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1704: P_CREATION_DATE => sysdate,
1705: P_PROGRAM_UPDATE_DATE => sysdate,
1706: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1707: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1708: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1709: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1710: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1711:

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

1704: P_CREATION_DATE => sysdate,
1705: P_PROGRAM_UPDATE_DATE => sysdate,
1706: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1707: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1708: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1709: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1710: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1711:
1712: cep_standard.debug('end call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');

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

1956: X_MATCHED_FLAG => clearing_flag,
1957: X_ACTUAL_VALUE_DATE =>
1958: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1959: X_LAST_UPDATE_DATE => sysdate,
1960: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1961: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1962: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1963: X_CREATION_DATE => sysdate,
1964: X_PROGRAM_UPDATE_DATE => sysdate,

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

1957: X_ACTUAL_VALUE_DATE =>
1958: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1959: X_LAST_UPDATE_DATE => sysdate,
1960: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1961: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1962: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1963: X_CREATION_DATE => sysdate,
1964: X_PROGRAM_UPDATE_DATE => sysdate,
1965: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

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

1958: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1959: X_LAST_UPDATE_DATE => sysdate,
1960: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
1961: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1962: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1963: X_CREATION_DATE => sysdate,
1964: X_PROGRAM_UPDATE_DATE => sysdate,
1965: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1966: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

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

1961: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
1962: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1963: X_CREATION_DATE => sysdate,
1964: X_PROGRAM_UPDATE_DATE => sysdate,
1965: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1966: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1967: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
1969: );

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

1962: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
1963: X_CREATION_DATE => sysdate,
1964: X_PROGRAM_UPDATE_DATE => sysdate,
1965: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1966: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1967: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
1969: );
1970: IF l_DEBUG in ('Y', 'C') THEN

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

1963: X_CREATION_DATE => sysdate,
1964: X_PROGRAM_UPDATE_DATE => sysdate,
1965: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1966: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1967: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
1969: );
1970: IF l_DEBUG in ('Y', 'C') THEN
1971: cep_standard.debug('reconcile_stmt: ' || '<<

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

1988: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
1989: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1990: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
1991: p_trx_type => 'PAY',
1992: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1993: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1994: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1995: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1996: cleared_trx_type := 'PAY';

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

1989: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1990: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
1991: p_trx_type => 'PAY',
1992: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1993: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1994: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1995: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1996: cleared_trx_type := 'PAY';
1997: end if;

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

1990: p_trx_amount => NVL(amount_cleared,0) * clearing_sign,
1991: p_trx_type => 'PAY',
1992: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1993: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1994: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1995: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
1996: cleared_trx_type := 'PAY';
1997: end if;
1998: end if;

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

2033: where statement_line_id in
2034: (x_trx_id, CE_AUTO_BANK_MATCH.csl_statement_line_id)
2035: and reference_type = tx_type
2036: and nvl(current_record_flag, 'N') = 'Y'
2037: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);
2038:
2039: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2040: Y_statement_line_id => x_trx_id,
2041: Y_cleared_trx_type => 'STATEMENT',

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

2104: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2105: where statement_line_id = x_trx_id
2106: and reference_type <> 'STATEMENT'
2107: and reference_id = CE_AUTO_BANK_MATCH.trx_id
2108: and nvl(request_id,-999) = nvl(FND_GLOBAL.conc_request_id,-1);
2109: end if;
2110: end if;
2111: elsif (passin_mode <> 'MANUAL_C') then
2112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';

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

2353: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2354: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2357: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2359: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2360:
2361: IF l_DEBUG in ('Y', 'C') THEN

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

2354: p_cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2357: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2359: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2360:
2361: IF l_DEBUG in ('Y', 'C') THEN
2362: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');

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

2355: p_trx_amount => NVL(amount_cleared,0),
2356: p_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
2357: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2358: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2359: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2360:
2361: IF l_DEBUG in ('Y', 'C') THEN
2362: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2363: END IF;

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

2427: X_MATCHED_FLAG => clearing_flag,
2428: X_ACTUAL_VALUE_DATE =>
2429: CE_AUTO_BANK_MATCH.csl_effective_date,
2430: X_LAST_UPDATE_DATE => sysdate,
2431: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2432: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2433: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2434: X_CREATION_DATE => sysdate,
2435: X_PROGRAM_UPDATE_DATE => sysdate,

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

2428: X_ACTUAL_VALUE_DATE =>
2429: CE_AUTO_BANK_MATCH.csl_effective_date,
2430: X_LAST_UPDATE_DATE => sysdate,
2431: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2432: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2433: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2434: X_CREATION_DATE => sysdate,
2435: X_PROGRAM_UPDATE_DATE => sysdate,
2436: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),

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

2429: CE_AUTO_BANK_MATCH.csl_effective_date,
2430: X_LAST_UPDATE_DATE => sysdate,
2431: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2432: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2433: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2434: X_CREATION_DATE => sysdate,
2435: X_PROGRAM_UPDATE_DATE => sysdate,
2436: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2437: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),

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

2432: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2433: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2434: X_CREATION_DATE => sysdate,
2435: X_PROGRAM_UPDATE_DATE => sysdate,
2436: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2437: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2438: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '
2440: );

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

2433: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2434: X_CREATION_DATE => sysdate,
2435: X_PROGRAM_UPDATE_DATE => sysdate,
2436: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2437: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2438: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '
2440: );
2441:

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

2434: X_CREATION_DATE => sysdate,
2435: X_PROGRAM_UPDATE_DATE => sysdate,
2436: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2437: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2438: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '
2440: );
2441:
2442: IF l_DEBUG in ('Y', 'C') THEN

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

2754: X_EXCHANGE_RATE => xrate,
2755: X_MATCHED_FLAG => 'Y',
2756: X_ACTUAL_VALUE_DATE => value_date,
2757: X_LAST_UPDATE_DATE => sysdate,
2758: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2759: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2760: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2761: X_CREATION_DATE => sysdate,
2762: X_PROGRAM_UPDATE_DATE => to_date(NULL),

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

2755: X_MATCHED_FLAG => 'Y',
2756: X_ACTUAL_VALUE_DATE => value_date,
2757: X_LAST_UPDATE_DATE => sysdate,
2758: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2759: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2760: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2761: X_CREATION_DATE => sysdate,
2762: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2763: X_PROGRAM_APPLICATION_ID=> to_number(NULL),

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

2756: X_ACTUAL_VALUE_DATE => value_date,
2757: X_LAST_UPDATE_DATE => sysdate,
2758: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),
2759: X_LAST_UPDATE_LOGIN => NVL(FND_GLOBAL.user_id,-1),
2760: X_CREATED_BY => NVL(FND_GLOBAL.user_id,-1),
2761: X_CREATION_DATE => sysdate,
2762: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2763: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
2764: X_PROGRAM_ID => to_number(NULL),