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_CLEAR dependencies on CE_AUTO_BANK_MATCH

Line 65: if (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK'

61: X_status VARCHAR2) IS
62: BEGIN
63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');
64: if (X_status = 'RECONCILED') then
65: if (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK'
66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then
67: UPDATE ce_statement_lines l
68: SET status = X_status,
69: reconcile_to_statement_flag =

Line 66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then

62: BEGIN
63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');
64: if (X_status = 'RECONCILED') then
65: if (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK'
66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then
67: UPDATE ce_statement_lines l
68: SET status = X_status,
69: reconcile_to_statement_flag =
70: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag

Line 70: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag

66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then
67: UPDATE ce_statement_lines l
68: SET status = X_status,
69: reconcile_to_statement_flag =
70: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
71: WHERE statement_line_id = X_statement_line_id
72: AND EXISTS
73: (select NULL
74: from ce_statement_recon_gt_v --ce_statement_reconciliations

Line 81: exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

77: and status_flag = 'M');
78: else
79: UPDATE ce_statement_lines l
80: SET status = X_status,
81: exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,
84: currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,
85: reconcile_to_statement_flag =

Line 82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,

78: else
79: UPDATE ce_statement_lines l
80: SET status = X_status,
81: exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,
84: currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,
85: reconcile_to_statement_flag =
86: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag

Line 83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,

79: UPDATE ce_statement_lines l
80: SET status = X_status,
81: exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,
84: currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,
85: reconcile_to_statement_flag =
86: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
87: WHERE statement_line_id = X_statement_line_id

Line 84: currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,

80: SET status = X_status,
81: exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,
84: currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,
85: reconcile_to_statement_flag =
86: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
87: WHERE statement_line_id = X_statement_line_id
88: AND EXISTS

Line 86: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag

82: exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
83: exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,
84: currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,
85: reconcile_to_statement_flag =
86: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
87: WHERE statement_line_id = X_statement_line_id
88: AND EXISTS
89: (select NULL
90: from ce_statement_recon_gt_v --ce_statement_reconciliations

Line 99: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag

95: else /* UNRECONCILED */
96: UPDATE ce_statement_lines
97: SET status = X_status,
98: reconcile_to_statement_flag =
99: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
100: WHERE statement_line_id = X_statement_line_id;
101: end if;
102: cep_standard.debug('< 103: EXCEPTION

Line 420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||

416: ext_precision NUMBER;
417: min_acct_unit NUMBER;
418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

Line 421: CE_AUTO_BANK_MATCH.csl_match_type);

417: min_acct_unit NUMBER;
418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);

Line 422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||

418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

Line 423: CE_AUTO_BANK_MATCH.calc_csl_amount);

419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);

Line 424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:

Line 425: CE_AUTO_BANK_MATCH.trx_amount);

421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||

Line 426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);

Line 427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);

423: CE_AUTO_BANK_MATCH.calc_csl_amount);
424: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
425: CE_AUTO_BANK_MATCH.trx_amount);
426: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
427: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:

Line 432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||

428:
429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||

Line 433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);

429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||
430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);

Line 434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||

430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);
431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);
438: --

Line 435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);

431:
432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);
438: --
439: -- Payment

Line 436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||

432: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = '||
433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);
438: --
439: -- Payment
440: --

Line 437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);

433: CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling);
434: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = '||
435: CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling);
436: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = '||
437: CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling);
438: --
439: -- Payment
440: --
441: -- 7571492: Added PGROUP

Line 442: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR

438: --
439: -- Payment
440: --
441: -- 7571492: Added PGROUP
442: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
443: --CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW' OR
444: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
445: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
446: clearing_sign := -1;

Line 443: --CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW' OR

439: -- Payment
440: --
441: -- 7571492: Added PGROUP
442: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
443: --CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW' OR
444: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
445: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
446: clearing_sign := -1;
447: else

Line 444: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN

440: --
441: -- 7571492: Added PGROUP
442: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
443: --CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW' OR
444: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
445: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
446: clearing_sign := -1;
447: else
448: clearing_sign := 1;

Line 445: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then

441: -- 7571492: Added PGROUP
442: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
443: --CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW' OR
444: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
445: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
446: clearing_sign := -1;
447: else
448: clearing_sign := 1;
449: end if;

Line 453: fnd_currency.get_info(CE_AUTO_BANK_MATCH.aba_bank_currency,

449: end if;
450:
451: -- bug 4528375
452: -- trx_amount was not rounded in view ce_200_transactions_v, so round it
453: fnd_currency.get_info(CE_AUTO_BANK_MATCH.aba_bank_currency,
454: precision, ext_precision, min_acct_unit);
455: CE_AUTO_BANK_MATCH.trx_amount := round(CE_AUTO_BANK_MATCH.trx_amount, precision);
456:
457: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign

Line 455: CE_AUTO_BANK_MATCH.trx_amount := round(CE_AUTO_BANK_MATCH.trx_amount, precision);

451: -- bug 4528375
452: -- trx_amount was not rounded in view ce_200_transactions_v, so round it
453: fnd_currency.get_info(CE_AUTO_BANK_MATCH.aba_bank_currency,
454: precision, ext_precision, min_acct_unit);
455: CE_AUTO_BANK_MATCH.trx_amount := round(CE_AUTO_BANK_MATCH.trx_amount, precision);
456:
457: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign
458: - CE_AUTO_BANK_MATCH.trx_amount;
459: /* 2886201

Line 457: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign

453: fnd_currency.get_info(CE_AUTO_BANK_MATCH.aba_bank_currency,
454: precision, ext_precision, min_acct_unit);
455: CE_AUTO_BANK_MATCH.trx_amount := round(CE_AUTO_BANK_MATCH.trx_amount, precision);
456:
457: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign
458: - CE_AUTO_BANK_MATCH.trx_amount;
459: /* 2886201
460: If transaction currency amount is 0, set real_rate to 1.0 to avoid
461: Division by Zero error. */

Line 458: - CE_AUTO_BANK_MATCH.trx_amount;

454: precision, ext_precision, min_acct_unit);
455: CE_AUTO_BANK_MATCH.trx_amount := round(CE_AUTO_BANK_MATCH.trx_amount, precision);
456:
457: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign
458: - CE_AUTO_BANK_MATCH.trx_amount;
459: /* 2886201
460: If transaction currency amount is 0, set real_rate to 1.0 to avoid
461: Division by Zero error. */
462: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN

Line 462: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN

458: - CE_AUTO_BANK_MATCH.trx_amount;
459: /* 2886201
460: If transaction currency amount is 0, set real_rate to 1.0 to avoid
461: Division by Zero error. */
462: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN
463: real_rate := 1.0;
464: ELSE
465: real_rate := (CE_AUTO_BANK_MATCH.csl_amount -
466: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/

Line 465: real_rate := (CE_AUTO_BANK_MATCH.csl_amount -

461: Division by Zero error. */
462: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN
463: real_rate := 1.0;
464: ELSE
465: real_rate := (CE_AUTO_BANK_MATCH.csl_amount -
466: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
467: CE_AUTO_BANK_MATCH.trx_curr_amount;
468: END IF;
469:

Line 466: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/

462: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN
463: real_rate := 1.0;
464: ELSE
465: real_rate := (CE_AUTO_BANK_MATCH.csl_amount -
466: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
467: CE_AUTO_BANK_MATCH.trx_curr_amount;
468: END IF;
469:
470: /* 2886201 End of Code Changes */

Line 467: CE_AUTO_BANK_MATCH.trx_curr_amount;

463: real_rate := 1.0;
464: ELSE
465: real_rate := (CE_AUTO_BANK_MATCH.csl_amount -
466: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
467: CE_AUTO_BANK_MATCH.trx_curr_amount;
468: END IF;
469:
470: /* 2886201 End of Code Changes */
471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN

Line 471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN

467: CE_AUTO_BANK_MATCH.trx_curr_amount;
468: END IF;
469:
470: /* 2886201 End of Code Changes */
471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN
472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;

Line 472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

468: END IF;
469:
470: /* 2886201 End of Code Changes */
471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN
472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

Line 473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN

469:
470: /* 2886201 End of Code Changes */
471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN
472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;

Line 474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN

470: /* 2886201 End of Code Changes */
471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN
472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
478:

Line 475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;

471: IF (ABS(difference_amount) <> ABS(CE_AUTO_BANK_MATCH.csl_charges_amount)) THEN
472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
478:
479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

472: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
478:
479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
480:

Line 477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;

473: --IF (CE_AUTO_BANK_MATCH.G_le_fx_difference_handling = 'C') THEN
474: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
478:
479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
480:
481: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN

Line 479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

475: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
476: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
478:
479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
480:
481: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
482: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 481: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN

477: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
478:
479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
480:
481: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
482: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
484: END IF;
485: ELSE

Line 482: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

478:
479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
480:
481: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
482: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
484: END IF;
485: ELSE
486: --IF (CE_AUTO_BANK_MATCH.G_foreign_difference_handling = 'G') THEN

Line 483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

479: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
480:
481: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
482: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
484: END IF;
485: ELSE
486: --IF (CE_AUTO_BANK_MATCH.G_foreign_difference_handling = 'G') THEN
487: IF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'G') THEN

Line 486: --IF (CE_AUTO_BANK_MATCH.G_foreign_difference_handling = 'G') THEN

482: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
484: END IF;
485: ELSE
486: --IF (CE_AUTO_BANK_MATCH.G_foreign_difference_handling = 'G') THEN
487: IF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'G') THEN
488: --
489: -- bug# 1209738
490: -- When foreign option is set to Gain/Loss, for EMU Rate Type

Line 487: IF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'G') THEN

483: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
484: END IF;
485: ELSE
486: --IF (CE_AUTO_BANK_MATCH.G_foreign_difference_handling = 'G') THEN
487: IF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'G') THEN
488: --
489: -- bug# 1209738
490: -- When foreign option is set to Gain/Loss, for EMU Rate Type
491: -- do not override the exchange rate

Line 493: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN

489: -- bug# 1209738
490: -- When foreign option is set to Gain/Loss, for EMU Rate Type
491: -- do not override the exchange rate
492: --
493: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
494: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
495: ELSE
496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN

Line 494: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;

490: -- When foreign option is set to Gain/Loss, for EMU Rate Type
491: -- do not override the exchange rate
492: --
493: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
494: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
495: ELSE
496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';

Line 496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

492: --
493: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
494: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
495: ELSE
496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;

Line 497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN

493: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
494: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
495: ELSE
496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
501: END IF;

Line 498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';

494: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
495: ELSE
496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
501: END IF;
502: END IF;

Line 499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;

495: ELSE
496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
501: END IF;
502: END IF;
503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN

Line 500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;

496: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
497: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
498: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
501: END IF;
502: END IF;
503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN
504: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;

Line 503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN

499: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
501: END IF;
502: END IF;
503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN
504: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
505: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
506: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
507:

Line 504: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;

500: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
501: END IF;
502: END IF;
503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN
504: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
505: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
506: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
507:
508: /*

Line 505: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

501: END IF;
502: END IF;
503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN
504: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
505: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
506: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
507:
508: /*
509: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

Line 506: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;

502: END IF;
503: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'C') THEN
504: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
505: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
506: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
507:
508: /*
509: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
510: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

Line 509: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

505: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
506: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
507:
508: /*
509: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
510: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
511: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
512: ELSE
513: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 511: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

507:
508: /*
509: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
510: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
511: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
512: ELSE
513: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
514: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
515: END IF;

Line 513: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

509: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
510: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
511: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
512: ELSE
513: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
514: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
515: END IF;
516: ELSE
517: */

Line 514: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

510: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
511: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
512: ELSE
513: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
514: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
515: END IF;
516: ELSE
517: */
518: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN

Line 519: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

515: END IF;
516: ELSE
517: */
518: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN
519: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
520: ELSE
521: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
522: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
523: END IF;

Line 521: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

517: */
518: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN
519: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
520: ELSE
521: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
522: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
523: END IF;
524: --END IF;
525:

Line 522: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

518: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN
519: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
520: ELSE
521: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
522: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
523: END IF;
524: --END IF;
525:
526: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'N') THEN

Line 526: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'N') THEN

522: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
523: END IF;
524: --END IF;
525:
526: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'N') THEN
527: CE_RECONCILIATION_ERRORS_PKG.insert_row(
528: CE_AUTO_BANK_MATCH.csh_statement_header_id,
529: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
530: success := FALSE;

Line 528: CE_AUTO_BANK_MATCH.csh_statement_header_id,

524: --END IF;
525:
526: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'N') THEN
527: CE_RECONCILIATION_ERRORS_PKG.insert_row(
528: CE_AUTO_BANK_MATCH.csh_statement_header_id,
529: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
530: success := FALSE;
531: END IF;
532: END IF;

Line 529: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');

525:
526: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ap_fx_diff_handling = 'N') THEN
527: CE_RECONCILIATION_ERRORS_PKG.insert_row(
528: CE_AUTO_BANK_MATCH.csh_statement_header_id,
529: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
530: success := FALSE;
531: END IF;
532: END IF;
533: ELSE --diff amt <> csl_charges_amount

Line 534: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

530: success := FALSE;
531: END IF;
532: END IF;
533: ELSE --diff amt <> csl_charges_amount
534: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
535:
536: END IF;
537: --
538: -- Receipt

Line 541: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then

537: --
538: -- Receipt
539: --
540: ELSE
541: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
542: difference_amount := 0;
543: else
544: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND
545: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then

Line 544: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND

540: ELSE
541: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
542: difference_amount := 0;
543: else
544: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND
545: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
546: clearing_sign := -1;
547: else
548: clearing_sign := 1;

Line 545: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then

541: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
542: difference_amount := 0;
543: else
544: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND
545: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
546: clearing_sign := -1;
547: else
548: clearing_sign := 1;
549: end if;

Line 550: difference_amount := CE_AUTO_BANK_MATCH.trx_amount -

546: clearing_sign := -1;
547: else
548: clearing_sign := 1;
549: end if;
550: difference_amount := CE_AUTO_BANK_MATCH.trx_amount -
551: CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;
552: end if;
553:
554: /* 2886201

Line 551: CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;

547: else
548: clearing_sign := 1;
549: end if;
550: difference_amount := CE_AUTO_BANK_MATCH.trx_amount -
551: CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;
552: end if;
553:
554: /* 2886201
555: If transaction currency amount is 0, set real_rate to 1.0 to avoid

Line 557: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN

553:
554: /* 2886201
555: If transaction currency amount is 0, set real_rate to 1.0 to avoid
556: Division by Zero error. */
557: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN
558: real_rate := 1.0;
559: ELSE
560: real_rate := (CE_AUTO_BANK_MATCH.csl_amount+
561: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/

Line 560: real_rate := (CE_AUTO_BANK_MATCH.csl_amount+

556: Division by Zero error. */
557: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN
558: real_rate := 1.0;
559: ELSE
560: real_rate := (CE_AUTO_BANK_MATCH.csl_amount+
561: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
562: CE_AUTO_BANK_MATCH.trx_curr_amount;
563: END IF; /* 2886201 End Code Added */
564:

Line 561: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/

557: IF (CE_AUTO_BANK_MATCH.trx_curr_amount = 0) THEN
558: real_rate := 1.0;
559: ELSE
560: real_rate := (CE_AUTO_BANK_MATCH.csl_amount+
561: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
562: CE_AUTO_BANK_MATCH.trx_curr_amount;
563: END IF; /* 2886201 End Code Added */
564:
565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN

Line 562: CE_AUTO_BANK_MATCH.trx_curr_amount;

558: real_rate := 1.0;
559: ELSE
560: real_rate := (CE_AUTO_BANK_MATCH.csl_amount+
561: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
562: CE_AUTO_BANK_MATCH.trx_curr_amount;
563: END IF; /* 2886201 End Code Added */
564:
565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN
566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

Line 565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN

561: NVL(CE_AUTO_BANK_MATCH.csl_charges_amount,0))/
562: CE_AUTO_BANK_MATCH.trx_curr_amount;
563: END IF; /* 2886201 End Code Added */
564:
565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN
566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

Line 566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

562: CE_AUTO_BANK_MATCH.trx_curr_amount;
563: END IF; /* 2886201 End Code Added */
564:
565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN
566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;

Line 567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN

563: END IF; /* 2886201 End Code Added */
564:
565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN
566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
571:

Line 568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;

564:
565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN
566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
571:
572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

565: IF (difference_amount <> CE_AUTO_BANK_MATCH.csl_charges_amount) THEN
566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
571:
572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
573:

Line 570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;

566: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
567: IF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling = 'CH') THEN
568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
571:
572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
573:
574: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN

Line 572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

568: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
569: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
571:
572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
573:
574: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
575: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
576: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 574: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN

570: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
571:
572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
573:
574: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
575: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
576: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
577: END IF;
578: ELSE

Line 575: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

571:
572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
573:
574: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
575: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
576: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
577: END IF;
578: ELSE
579:

Line 576: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

572: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
573:
574: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ce_fx_diff_handling in ('E', 'FX')) THEN
575: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
576: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
577: END IF;
578: ELSE
579:
580: IF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'G') THEN

Line 580: IF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'G') THEN

576: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
577: END IF;
578: ELSE
579:
580: IF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'G') THEN
581: --
582: -- bug# 1209738
583: -- When foreign option is set to Gain/Loss, for EMU Rate Type
584: -- do not override the exchange rate

Line 586: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN

582: -- bug# 1209738
583: -- When foreign option is set to Gain/Loss, for EMU Rate Type
584: -- do not override the exchange rate
585: --
586: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;

583: -- When foreign option is set to Gain/Loss, for EMU Rate Type
584: -- do not override the exchange rate
585: --
586: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN

Line 588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));

584: -- do not override the exchange rate
585: --
586: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';

Line 590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

586: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type = 'EMU FIXED') THEN
587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;

Line 591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN

587: CE_AUTO_BANK_MATCH.calc_csl_amount := CE_AUTO_BANK_MATCH.calc_csl_amount + difference_amount;
588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
595: END IF;

Line 592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';

588: cep_standard.debug('****** CE_AUTO_BANK_MATCH.calc_csl_amount = '||to_char(CE_AUTO_BANK_MATCH.calc_csl_amount));
589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
595: END IF;
596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;

589: ELSE
590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
595: END IF;
596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
597: END IF;

Line 594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;

590: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
591: IF (real_rate <> NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate,real_rate+1)) THEN
592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
595: END IF;
596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
597: END IF;
598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN

Line 596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

592: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
593: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
595: END IF;
596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
597: END IF;
598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN
599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

Line 598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN

594: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
595: END IF;
596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
597: END IF;
598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN
599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
602:

Line 599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;

595: END IF;
596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
597: END IF;
598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN
599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
602:
603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

Line 600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;

596: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
597: END IF;
598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN
599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
602:
603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

Line 601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;

597: END IF;
598: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'C') THEN
599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
602:
603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
605: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

599: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_MATCH.trx_exchange_rate_type;
600: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
602:
603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
605: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
606: ELSE
607: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 605: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

601: CE_AUTO_BANK_MATCH.csl_exchange_rate := CE_AUTO_BANK_MATCH.trx_exchange_rate;
602:
603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
605: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
606: ELSE
607: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
608: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
609: END IF;

Line 607: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

603: /*IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
605: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
606: ELSE
607: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
608: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
609: END IF;
610: ELSE */
611:

Line 608: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
605: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
606: ELSE
607: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
608: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
609: END IF;
610: ELSE */
611:
612: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 612: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

608: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
609: END IF;
610: ELSE */
611:
612: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
613: --END IF;
614: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'N') THEN
615: CE_RECONCILIATION_ERRORS_PKG.insert_row(
616: CE_AUTO_BANK_MATCH.csh_statement_header_id,

Line 614: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'N') THEN

610: ELSE */
611:
612: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
613: --END IF;
614: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'N') THEN
615: CE_RECONCILIATION_ERRORS_PKG.insert_row(
616: CE_AUTO_BANK_MATCH.csh_statement_header_id,
617: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
618: success := FALSE;

Line 616: CE_AUTO_BANK_MATCH.csh_statement_header_id,

612: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
613: --END IF;
614: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'N') THEN
615: CE_RECONCILIATION_ERRORS_PKG.insert_row(
616: CE_AUTO_BANK_MATCH.csh_statement_header_id,
617: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
618: success := FALSE;
619: END IF;
620: END IF;

Line 617: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');

613: --END IF;
614: ELSIF (CE_AUTO_BANK_MATCH.ba_recon_ar_fx_diff_handling = 'N') THEN
615: CE_RECONCILIATION_ERRORS_PKG.insert_row(
616: CE_AUTO_BANK_MATCH.csh_statement_header_id,
617: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
618: success := FALSE;
619: END IF;
620: END IF;
621: ELSE

Line 622: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

618: success := FALSE;
619: END IF;
620: END IF;
621: ELSE
622: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
623: END IF;
624: END IF;
625: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;

Line 625: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN

621: ELSE
622: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
623: END IF;
624: END IF;
625: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
629: END IF;

Line 626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;

622: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
623: END IF;
624: END IF;
625: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
629: END IF;
630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');

Line 627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';

623: END IF;
624: END IF;
625: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
629: END IF;
630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
631: END calc_foreign_clearing_amounts;

Line 628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;

624: END IF;
625: IF (CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL) THEN
626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
629: END IF;
630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
631: END calc_foreign_clearing_amounts;
632:

Line 649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||

645: clearing_sign NUMBER;
646: success BOOLEAN;
647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

Line 650: CE_AUTO_BANK_MATCH.csl_match_type);

646: success BOOLEAN;
647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);

Line 651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||

647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||

Line 652: CE_AUTO_BANK_MATCH.trx_match_type);

648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);

Line 653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||

649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||

Line 654: CE_AUTO_BANK_MATCH.trx_amount);

650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);

Line 655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||

651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||

Line 656: CE_AUTO_BANK_MATCH.csl_match_correction_type);

652: CE_AUTO_BANK_MATCH.trx_match_type);
653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);

Line 657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||

653: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_amount = '||
654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||

Line 658: CE_AUTO_BANK_MATCH.csl_trx_type);

654: CE_AUTO_BANK_MATCH.trx_amount);
655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);

Line 659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||

655: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_correction_type = '||
656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:

Line 660: CE_AUTO_BANK_MATCH.trx_currency_type);

656: CE_AUTO_BANK_MATCH.csl_match_correction_type);
657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

Line 661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||

657: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_trx_type = '||
658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);

Line 662: CE_AUTO_BANK_MATCH.calc_csl_amount);

658: CE_AUTO_BANK_MATCH.csl_trx_type);
659: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_currency_type = '||
660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
666:

Line 664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||

660: CE_AUTO_BANK_MATCH.trx_currency_type);
661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
666:
667: success := TRUE;
668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN

Line 665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);

661: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
662: CE_AUTO_BANK_MATCH.calc_csl_amount);
663:
664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
666:
667: success := TRUE;
668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN
669: NULL;

Line 668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN

664: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '||
665: CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
666:
667: success := TRUE;
668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN
669: NULL;
670: ELSIF ((CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') AND
671: (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN
672: CE_AUTO_BANK_MATCH.trx_charges_amount :=

Line 670: ELSIF ((CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') AND

666:
667: success := TRUE;
668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN
669: NULL;
670: ELSIF ((CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') AND
671: (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN
672: CE_AUTO_BANK_MATCH.trx_charges_amount :=
673: CE_AUTO_BANK_MATCH.csl_charges_amount;
674: ELSIF (CE_AUTO_BANK_MATCH.tolerance_amount = 0) THEN

Line 672: CE_AUTO_BANK_MATCH.trx_charges_amount :=

668: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'JE_LINE') THEN
669: NULL;
670: ELSIF ((CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') AND
671: (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN
672: CE_AUTO_BANK_MATCH.trx_charges_amount :=
673: CE_AUTO_BANK_MATCH.csl_charges_amount;
674: ELSIF (CE_AUTO_BANK_MATCH.tolerance_amount = 0) THEN
675: NULL;
676: ELSE

Line 673: CE_AUTO_BANK_MATCH.csl_charges_amount;

669: NULL;
670: ELSIF ((CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') AND
671: (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN
672: CE_AUTO_BANK_MATCH.trx_charges_amount :=
673: CE_AUTO_BANK_MATCH.csl_charges_amount;
674: ELSIF (CE_AUTO_BANK_MATCH.tolerance_amount = 0) THEN
675: NULL;
676: ELSE
677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN

Line 674: ELSIF (CE_AUTO_BANK_MATCH.tolerance_amount = 0) THEN

670: ELSIF ((CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') AND
671: (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN
672: CE_AUTO_BANK_MATCH.trx_charges_amount :=
673: CE_AUTO_BANK_MATCH.csl_charges_amount;
674: ELSIF (CE_AUTO_BANK_MATCH.tolerance_amount = 0) THEN
675: NULL;
676: ELSE
677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN
678: -- added 'PGROUP'

Line 677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN

673: CE_AUTO_BANK_MATCH.csl_charges_amount;
674: ELSIF (CE_AUTO_BANK_MATCH.tolerance_amount = 0) THEN
675: NULL;
676: ELSE
677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN
678: -- added 'PGROUP'
679: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
680: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
681: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then

Line 679: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR

675: NULL;
676: ELSE
677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN
678: -- added 'PGROUP'
679: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
680: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
681: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
682: clearing_sign := -1;
683: else

Line 680: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN

676: ELSE
677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN
678: -- added 'PGROUP'
679: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
680: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
681: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
682: clearing_sign := -1;
683: else
684: clearing_sign := 1;

Line 681: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then

677: IF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL', 'BANK')) THEN
678: -- added 'PGROUP'
679: IF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PAYMENT','PBATCH','PGROUP') OR
680: CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') THEN
681: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
682: clearing_sign := -1;
683: else
684: clearing_sign := 1;
685: end if;

Line 686: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign

682: clearing_sign := -1;
683: else
684: clearing_sign := 1;
685: end if;
686: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign
687: - CE_AUTO_BANK_MATCH.trx_amount;
688:
689: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

Line 687: - CE_AUTO_BANK_MATCH.trx_amount;

683: else
684: clearing_sign := 1;
685: end if;
686: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign
687: - CE_AUTO_BANK_MATCH.trx_amount;
688:
689: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
691: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 689: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

685: end if;
686: difference_amount := CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign
687: - CE_AUTO_BANK_MATCH.trx_amount;
688:
689: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
691: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
692: ELSE
693: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 691: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

687: - CE_AUTO_BANK_MATCH.trx_amount;
688:
689: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
691: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
692: ELSE
693: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
694: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
695: END IF;

Line 693: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

689: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
691: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
692: ELSE
693: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
694: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
695: END IF;
696:
697: ELSE

Line 694: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
691: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
692: ELSE
693: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
694: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
695: END IF;
696:
697: ELSE
698: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN

Line 699: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

695: END IF;
696:
697: ELSE
698: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN
699: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
700: ELSE
701: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
702: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
703: END IF;

Line 701: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

697: ELSE
698: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN
699: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
700: ELSE
701: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
702: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
703: END IF;
704: END IF;
705:

Line 702: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

698: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN
699: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
700: ELSE
701: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
702: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
703: END IF;
704: END IF;
705:
706: ELSE -- cash/receipt

Line 707: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND

703: END IF;
704: END IF;
705:
706: ELSE -- cash/receipt
707: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND
708: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
709: clearing_sign := -1;
710: else
711: clearing_sign := 1;

Line 708: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then

704: END IF;
705:
706: ELSE -- cash/receipt
707: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT' AND
708: CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
709: clearing_sign := -1;
710: else
711: clearing_sign := 1;
712: end if;

Line 713: difference_amount := CE_AUTO_BANK_MATCH.trx_amount

709: clearing_sign := -1;
710: else
711: clearing_sign := 1;
712: end if;
713: difference_amount := CE_AUTO_BANK_MATCH.trx_amount
714: - CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;
715:
716: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

Line 714: - CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;

710: else
711: clearing_sign := 1;
712: end if;
713: difference_amount := CE_AUTO_BANK_MATCH.trx_amount
714: - CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;
715:
716: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
718: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 716: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN

712: end if;
713: difference_amount := CE_AUTO_BANK_MATCH.trx_amount
714: - CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;
715:
716: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
718: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
719: ELSE
720: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 718: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

714: - CE_AUTO_BANK_MATCH.calc_csl_amount * clearing_sign;
715:
716: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
718: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
719: ELSE
720: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
721: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
722: END IF;

Line 720: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;

716: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW') THEN
717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
718: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
719: ELSE
720: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
721: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
722: END IF;
723: ELSE
724: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

Line 721: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN
718: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
719: ELSE
720: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
721: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
722: END IF;
723: ELSE
724: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
725: END IF;

Line 724: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;

720: CE_AUTO_BANK_MATCH.trx_charges_amount := CE_AUTO_BANK_MATCH.csl_charges_amount;
721: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;
722: END IF;
723: ELSE
724: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
725: END IF;
726: END IF;
727: ELSIF (CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') THEN
728: calc_foreign_clearing_amounts(success);

Line 727: ELSIF (CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') THEN

723: ELSE
724: CE_AUTO_BANK_MATCH.trx_charges_amount := difference_amount;
725: END IF;
726: END IF;
727: ELSIF (CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') THEN
728: calc_foreign_clearing_amounts(success);
729: END IF;
730: END IF;
731: --

Line 734: IF (CE_AUTO_BANK_MATCH.trx_errors_amount = 0) THEN

730: END IF;
731: --
732: -- Zero equals to NULL
733: --
734: IF (CE_AUTO_BANK_MATCH.trx_errors_amount = 0) THEN
735: CE_AUTO_BANK_MATCH.trx_errors_amount := NULL;
736: END IF;
737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;

Line 735: CE_AUTO_BANK_MATCH.trx_errors_amount := NULL;

731: --
732: -- Zero equals to NULL
733: --
734: IF (CE_AUTO_BANK_MATCH.trx_errors_amount = 0) THEN
735: CE_AUTO_BANK_MATCH.trx_errors_amount := NULL;
736: END IF;
737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;
739: END IF;

Line 737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN

733: --
734: IF (CE_AUTO_BANK_MATCH.trx_errors_amount = 0) THEN
735: CE_AUTO_BANK_MATCH.trx_errors_amount := NULL;
736: END IF;
737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;
739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);

Line 738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;

734: IF (CE_AUTO_BANK_MATCH.trx_errors_amount = 0) THEN
735: CE_AUTO_BANK_MATCH.trx_errors_amount := NULL;
736: END IF;
737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;
739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:

Line 740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||

736: END IF;
737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;
739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);

Line 741: CE_AUTO_BANK_MATCH.trx_charges_amount);

737: IF (CE_AUTO_BANK_MATCH.trx_charges_amount = 0) THEN
738: CE_AUTO_BANK_MATCH.trx_charges_amount := NULL;
739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);
745:

Line 743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||

739: END IF;
740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);
745:
746: cep_standard.debug('< 747: RETURN (success);

Line 744: CE_AUTO_BANK_MATCH.trx_errors_amount);

740: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_charges_amount = '||
741: CE_AUTO_BANK_MATCH.trx_charges_amount);
742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);
745:
746: cep_standard.debug('< 747: RETURN (success);
748: EXCEPTION

Line 1068: | CE_AUTO_BANK_MATCH.match_process |

Line 1081: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'MISC' AND

1077: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_process');
1078: --
1079: -- Statement lines
1080: --
1081: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'MISC' AND
1082: CE_AUTO_BANK_MATCH.csl_match_correction_type IN
1083: ('REVERSAL', 'ADJUSTMENT')) THEN
1084: IF (calculate_clearing_amounts) THEN
1085: reconcile_stmt(

Line 1082: CE_AUTO_BANK_MATCH.csl_match_correction_type IN

1078: --
1079: -- Statement lines
1080: --
1081: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'MISC' AND
1082: CE_AUTO_BANK_MATCH.csl_match_correction_type IN
1083: ('REVERSAL', 'ADJUSTMENT')) THEN
1084: IF (calculate_clearing_amounts) THEN
1085: reconcile_stmt(
1086: passin_mode => 'AUTO',

Line 1087: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,

1083: ('REVERSAL', 'ADJUSTMENT')) THEN
1084: IF (calculate_clearing_amounts) THEN
1085: reconcile_stmt(
1086: passin_mode => 'AUTO',
1087: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

Line 1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,

1084: IF (calculate_clearing_amounts) THEN
1085: reconcile_stmt(
1086: passin_mode => 'AUTO',
1087: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,

1085: reconcile_stmt(
1086: passin_mode => 'AUTO',
1087: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,

1086: passin_mode => 'AUTO',
1087: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,

Line 1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

1087: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

Line 1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1088: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

Line 1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

1089: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,

1090: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

1091: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

1092: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1093: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,

Line 1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1094: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1095: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,

Line 1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,

1096: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1104: reference_status => NULL,

Line 1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1104: reference_status => NULL,
1105: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

Line 1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

1098: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1104: reference_status => NULL,
1105: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1106: auto_reconciled_flag => 'Y',

Line 1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,

1099: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1100: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1104: reference_status => NULL,
1105: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1106: auto_reconciled_flag => 'Y',
1107: X_statement_header_id => d_statement_header_id,

Line 1105: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1102: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1103: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1104: reference_status => NULL,
1105: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1106: auto_reconciled_flag => 'Y',
1107: X_statement_header_id => d_statement_header_id,
1108: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

Line 1108: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1104: reference_status => NULL,
1105: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1106: auto_reconciled_flag => 'Y',
1107: X_statement_header_id => d_statement_header_id,
1108: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';

Line 1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,

1106: auto_reconciled_flag => 'Y',
1107: X_statement_header_id => d_statement_header_id,
1108: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,

Line 1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);

1107: X_statement_header_id => d_statement_header_id,
1108: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');

Line 1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';

1108: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');
1116: else /* ADJUSTMENT */

Line 1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then

1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');
1116: else /* ADJUSTMENT */
1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,

Line 1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,

1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');
1116: else /* ADJUSTMENT */
1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
1118: 'RECONCILED');

Line 1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,

1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');
1116: else /* ADJUSTMENT */
1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
1118: 'RECONCILED');
1119: end if;
1120: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
1121: CE_AUTO_BANK_CLEAR.update_line_status(

Line 1120: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;

1116: else /* ADJUSTMENT */
1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
1118: 'RECONCILED');
1119: end if;
1120: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
1121: CE_AUTO_BANK_CLEAR.update_line_status(
1122: CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1123: END IF;
1124: --

Line 1122: CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1118: 'RECONCILED');
1119: end if;
1120: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
1121: CE_AUTO_BANK_CLEAR.update_line_status(
1122: CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1123: END IF;
1124: --
1125: -- Transaction
1126: --

Line 1127: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type IN

1123: END IF;
1124: --
1125: -- Transaction
1126: --
1127: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type IN
1128: ('PAY_LINE', 'JE_LINE','PAYMENT','CASH','MISC','RECEIPT')) THEN
1129: IF (calculate_clearing_amounts) THEN
1130: reconcile_trx(
1131: passin_mode => 'AUTO',

Line 1132: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,

1128: ('PAY_LINE', 'JE_LINE','PAYMENT','CASH','MISC','RECEIPT')) THEN
1129: IF (calculate_clearing_amounts) THEN
1130: reconcile_trx(
1131: passin_mode => 'AUTO',
1132: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

Line 1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,

1129: IF (calculate_clearing_amounts) THEN
1130: reconcile_trx(
1131: passin_mode => 'AUTO',
1132: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,

1130: reconcile_trx(
1131: passin_mode => 'AUTO',
1132: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,

1131: passin_mode => 'AUTO',
1132: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,

Line 1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

1132: tx_type => CE_AUTO_BANK_MATCH.csl_match_type,
1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

Line 1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1133: trx_id => CE_AUTO_BANK_MATCH.trx_id,
1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

Line 1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

1134: trx_status => CE_AUTO_BANK_MATCH.trx_status,
1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,

1135: receipt_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

1136: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

1137: exchange_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1138: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,

Line 1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1139: amount_cleared => CE_AUTO_BANK_MATCH.calc_csl_amount,
1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1140: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,

Line 1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,

1141: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1149: reference_status => NULL,

Line 1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1149: reference_status => NULL,
1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

Line 1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

1143: value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1149: reference_status => NULL,
1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1151: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,

Line 1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,

1144: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1145: ar_cash_receipt_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1149: reference_status => NULL,
1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1151: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1152: auto_reconciled_flag => 'Y',

Line 1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1149: reference_status => NULL,
1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1151: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1152: auto_reconciled_flag => 'Y',
1153: X_statement_header_id => d_statement_header_id,
1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 1151: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,

1147: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1148: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1149: reference_status => NULL,
1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1151: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1152: auto_reconciled_flag => 'Y',
1153: X_statement_header_id => d_statement_header_id,
1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1155: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

Line 1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1150: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1151: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1152: auto_reconciled_flag => 'Y',
1153: X_statement_header_id => d_statement_header_id,
1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1155: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1156: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1157: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1158: END IF;

Line 1156: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);

1152: auto_reconciled_flag => 'Y',
1153: X_statement_header_id => d_statement_header_id,
1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1155: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1156: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1157: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1158: END IF;
1159: --
1160: -- Payroll EFT Transaction

Line 1157: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1153: X_statement_header_id => d_statement_header_id,
1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1155: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1156: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1157: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1158: END IF;
1159: --
1160: -- Payroll EFT Transaction
1161: --

Line 1162: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAY_EFT') THEN

1158: END IF;
1159: --
1160: -- Payroll EFT Transaction
1161: --
1162: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAY_EFT') THEN
1163: IF (calculate_clearing_amounts) THEN
1164: reconcile_pay_eft(
1165: passin_mode => 'AUTO',
1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT

Line 1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT

1162: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PAY_EFT') THEN
1163: IF (calculate_clearing_amounts) THEN
1164: reconcile_pay_eft(
1165: passin_mode => 'AUTO',
1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT
1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,
1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,

1163: IF (calculate_clearing_amounts) THEN
1164: reconcile_pay_eft(
1165: passin_mode => 'AUTO',
1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT
1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,
1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

Line 1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,

1164: reconcile_pay_eft(
1165: passin_mode => 'AUTO',
1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT
1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,
1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,

1165: passin_mode => 'AUTO',
1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT
1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,
1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,

Line 1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1166: tx_type => CE_AUTO_BANK_MATCH.csl_match_type, --PAY_EFT
1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,
1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

Line 1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

1167: trx_count => CE_AUTO_BANK_MATCH.trx_count,
1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1175: auto_reconciled_flag => 'Y',

Line 1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

1168: trx_group => CE_AUTO_BANK_MATCH.trx_group,
1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1175: auto_reconciled_flag => 'Y',
1176: X_statement_header_id => d_statement_header_id,

Line 1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,

1169: cleared_trx_type => CE_AUTO_BANK_MATCH.csl_reconcile_flag,
1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1175: auto_reconciled_flag => 'Y',
1176: X_statement_header_id => d_statement_header_id,
1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,

Line 1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

1170: cleared_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1171: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1172: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1175: auto_reconciled_flag => 'Y',
1176: X_statement_header_id => d_statement_header_id,
1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,

Line 1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,

1173: X_statement_line_type => CE_AUTO_BANK_MATCH.csl_line_trx_type,
1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1175: auto_reconciled_flag => 'Y',
1176: X_statement_header_id => d_statement_header_id,
1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,
1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);

Line 1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,

1174: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1175: auto_reconciled_flag => 'Y',
1176: X_statement_header_id => d_statement_header_id,
1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,
1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

Line 1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,

1175: auto_reconciled_flag => 'Y',
1176: X_statement_header_id => d_statement_header_id,
1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,
1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1183: END IF;

Line 1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1176: X_statement_header_id => d_statement_header_id,
1177: X_bank_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,
1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1183: END IF;
1184: --

Line 1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,
1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1183: END IF;
1184: --
1185: -- Payment Batch
1186: --

Line 1187: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PBATCH') THEN

1183: END IF;
1184: --
1185: -- Payment Batch
1186: --
1187: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PBATCH') THEN
1188: IF (calculate_clearing_amounts) THEN
1189: reconcile_pbatch(
1190: passin_mode => 'AUTO',
1191: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,

Line 1191: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,

1187: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PBATCH') THEN
1188: IF (calculate_clearing_amounts) THEN
1189: reconcile_pbatch(
1190: passin_mode => 'AUTO',
1191: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1192: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1192: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

1188: IF (calculate_clearing_amounts) THEN
1189: reconcile_pbatch(
1190: passin_mode => 'AUTO',
1191: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1192: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,

Line 1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1190: passin_mode => 'AUTO',
1191: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1192: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

Line 1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1191: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1192: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,

Line 1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,

1192: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

Line 1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

1194: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,

1195: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

Line 1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

1196: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1204: X_statement_header_id => d_statement_header_id,

Line 1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1204: X_statement_header_id => d_statement_header_id,
1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,

Line 1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

1198: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1204: X_statement_header_id => d_statement_header_id,
1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

1199: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1200: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1204: X_statement_header_id => d_statement_header_id,
1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

Line 1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,

1201: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1204: X_statement_header_id => d_statement_header_id,
1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1208: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency);
1209:

Line 1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1202: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1203: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1204: X_statement_header_id => d_statement_header_id,
1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1208: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency);
1209:
1210: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

Line 1208: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency);

1204: X_statement_header_id => d_statement_header_id,
1205: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1208: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency);
1209:
1210: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1211: END IF;
1212: --

Line 1210: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1208: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency);
1209:
1210: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1211: END IF;
1212: --
1213: -- Payment Group
1214: --

Line 1215: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PGROUP') THEN

1211: END IF;
1212: --
1213: -- Payment Group
1214: --
1215: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PGROUP') THEN
1216: IF (calculate_clearing_amounts) THEN
1217: reconcile_pbatch(
1218: passin_mode => 'AUTO',
1219: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,

Line 1219: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,

1215: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'PGROUP') THEN
1216: IF (calculate_clearing_amounts) THEN
1217: reconcile_pbatch(
1218: passin_mode => 'AUTO',
1219: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1220: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1220: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

1216: IF (calculate_clearing_amounts) THEN
1217: reconcile_pbatch(
1218: passin_mode => 'AUTO',
1219: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1220: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,

Line 1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1218: passin_mode => 'AUTO',
1219: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1220: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

Line 1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1219: pbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1220: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,

Line 1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,

1220: statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

Line 1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),
1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,

Line 1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,

1222: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,

1223: cleared_date => TO_DATE(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),
1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

1224: amount_to_clear => CE_AUTO_BANK_MATCH.calc_csl_amount,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),
1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

Line 1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,

1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,
1226: charges_amount => CE_AUTO_BANK_MATCH.trx_charges_amount,
1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),
1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1233: X_statement_header_id => d_statement_header_id,

Line 1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

1227: prorate_amount => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),
1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1233: X_statement_header_id => d_statement_header_id,
1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

1228: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1229: exchange_rate_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),
1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1233: X_statement_header_id => d_statement_header_id,
1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

Line 1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,

1230: 'YYYY/MM/DD'),'YYYY/MM/DD'),
1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1233: X_statement_header_id => d_statement_header_id,
1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,
1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);

Line 1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1231: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1232: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1233: X_statement_header_id => d_statement_header_id,
1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,
1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);
1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

Line 1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,

1233: X_statement_header_id => d_statement_header_id,
1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,
1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);
1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1240: END IF;
1241: --

Line 1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);

1234: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,
1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);
1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1240: END IF;
1241: --
1242: -- Remittance Batch

Line 1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,
1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);
1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1240: END IF;
1241: --
1242: -- Remittance Batch
1243: --

Line 1244: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'RBATCH') THEN

1240: END IF;
1241: --
1242: -- Remittance Batch
1243: --
1244: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'RBATCH') THEN
1245: IF (calculate_clearing_amounts) THEN
1246: misc_number := nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1247: CE_AUTO_BANK_MATCH.csh_statement_number||'/'
1248: || CE_AUTO_BANK_MATCH.csl_line_number);

Line 1246: misc_number := nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,

1242: -- Remittance Batch
1243: --
1244: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'RBATCH') THEN
1245: IF (calculate_clearing_amounts) THEN
1246: misc_number := nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1247: CE_AUTO_BANK_MATCH.csh_statement_number||'/'
1248: || CE_AUTO_BANK_MATCH.csl_line_number);
1249: reconcile_rbatch(
1250: passin_mode => 'AUTO',

Line 1247: CE_AUTO_BANK_MATCH.csh_statement_number||'/'

1243: --
1244: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'RBATCH') THEN
1245: IF (calculate_clearing_amounts) THEN
1246: misc_number := nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1247: CE_AUTO_BANK_MATCH.csh_statement_number||'/'
1248: || CE_AUTO_BANK_MATCH.csl_line_number);
1249: reconcile_rbatch(
1250: passin_mode => 'AUTO',
1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,

Line 1248: || CE_AUTO_BANK_MATCH.csl_line_number);

1244: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type = 'RBATCH') THEN
1245: IF (calculate_clearing_amounts) THEN
1246: misc_number := nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,
1247: CE_AUTO_BANK_MATCH.csh_statement_number||'/'
1248: || CE_AUTO_BANK_MATCH.csl_line_number);
1249: reconcile_rbatch(
1250: passin_mode => 'AUTO',
1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,

1247: CE_AUTO_BANK_MATCH.csh_statement_number||'/'
1248: || CE_AUTO_BANK_MATCH.csl_line_number);
1249: reconcile_rbatch(
1250: passin_mode => 'AUTO',
1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,
1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

Line 1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

1248: || CE_AUTO_BANK_MATCH.csl_line_number);
1249: reconcile_rbatch(
1250: passin_mode => 'AUTO',
1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,
1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

Line 1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1250: passin_mode => 'AUTO',
1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,
1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,

Line 1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

1251: rbatch_id => CE_AUTO_BANK_MATCH.trx_id,
1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,
1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

Line 1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,

1252: X_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,
1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',

Line 1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,
1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,

Line 1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,

1254: value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,

1255: bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,
1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,

Line 1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,
1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,
1267: X_MISC_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,

Line 1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,

1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,
1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,
1267: X_MISC_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,
1268: X_RECEIPT_METHOD_ID => CE_AUTO_BANK_REC.G_payment_method_id,

Line 1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,

1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,
1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,
1267: X_MISC_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,
1268: X_RECEIPT_METHOD_ID => CE_AUTO_BANK_REC.G_payment_method_id,
1269: X_BANK_ACCOUNT_ID => CE_AUTO_BANK_MATCH.csh_bank_account_id,

Line 1267: X_MISC_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,

1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,
1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,
1267: X_MISC_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,
1268: X_RECEIPT_METHOD_ID => CE_AUTO_BANK_REC.G_payment_method_id,
1269: X_BANK_ACCOUNT_ID => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1270: X_ACTIVITY_TYPE_ID => CE_AUTO_BANK_REC.G_receivables_trx_id,
1271: X_COMMENTS => 'Created by Auto Bank Rec',

Line 1269: X_BANK_ACCOUNT_ID => CE_AUTO_BANK_MATCH.csh_bank_account_id,

1265: X_FOREIGN_DIFF_AMT => CE_AUTO_BANK_MATCH.trx_prorate_amount,
1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,
1267: X_MISC_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,
1268: X_RECEIPT_METHOD_ID => CE_AUTO_BANK_REC.G_payment_method_id,
1269: X_BANK_ACCOUNT_ID => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1270: X_ACTIVITY_TYPE_ID => CE_AUTO_BANK_REC.G_receivables_trx_id,
1271: X_COMMENTS => 'Created by Auto Bank Rec',
1272: X_REFERENCE_TYPE => 'REMITTANCE BATCH',
1273: X_CLEAR_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,

Line 1273: X_CLEAR_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,

1269: X_BANK_ACCOUNT_ID => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1270: X_ACTIVITY_TYPE_ID => CE_AUTO_BANK_REC.G_receivables_trx_id,
1271: X_COMMENTS => 'Created by Auto Bank Rec',
1272: X_REFERENCE_TYPE => 'REMITTANCE BATCH',
1273: X_CLEAR_CURRENCY_CODE => CE_AUTO_BANK_MATCH.aba_bank_currency,
1274: X_TAX_ID => NULL,
1275: X_TAX_RATE => NULL,
1276: X_CR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
1277: X_DR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_dr_vat_tax_code,

Line 1279: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,

1275: X_TAX_RATE => NULL,
1276: X_CR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
1277: X_DR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
1278: X_statement_header_id => d_statement_header_id,
1279: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1280: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1282: END IF;
1283: END IF;

Line 1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1277: X_DR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
1278: X_statement_header_id => d_statement_header_id,
1279: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1280: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1282: END IF;
1283: END IF;
1284: cep_standard.debug('< 1285: EXCEPTION

Line 1296: CE_AUTO_BANK_MATCH.csh_statement_header_id,

1292: app_short_name := 'CE';
1293: message_name := 'OTHER_APP_ERROR';
1294: END IF;
1295: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1296: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1297: CE_AUTO_BANK_MATCH.csl_statement_line_id, message_name, app_short_name);
1298: --
1299: -- get rid of any lines that might have been inserted into
1300: -- the reconciliation tables. This happens when lines per commit

Line 1297: CE_AUTO_BANK_MATCH.csl_statement_line_id, message_name, app_short_name);

1293: message_name := 'OTHER_APP_ERROR';
1294: END IF;
1295: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1296: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1297: CE_AUTO_BANK_MATCH.csl_statement_line_id, message_name, app_short_name);
1298: --
1299: -- get rid of any lines that might have been inserted into
1300: -- the reconciliation tables. This happens when lines per commit
1301: -- is not zero

Line 1305: WHERE statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id;

1301: -- is not zero
1302: --
1303: --DELETE FROM ce_statement_reconciliations
1304: DELETE FROM ce_statement_reconcils_all
1305: WHERE statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id;
1306: WHEN OTHERS THEN
1307: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.reconcile_process OTHERS');
1308: /*
1309: IF (rbatch_cursor%ISOPEN) THEN