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_REC

Line 429: -- cep_standard.debug('DEBUG: CE_AUTO_BANK_REC.G_foreign_difference_handling = '||

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:
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);

Line 430: -- CE_AUTO_BANK_REC.G_foreign_difference_handling);

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:
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 = '||

Line 510: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

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;
514: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 518: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN

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
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;

Line 604: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

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;
608: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 671: (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN

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
675: NULL;

Line 690: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

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;
694: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 698: IF (CE_AUTO_BANK_REC.G_differences_account = 'CHARGES') THEN

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
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;

Line 717: IF (CE_AUTO_BANK_REC.G_ce_differences_account = 'CHARGES') THEN

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;
721: CE_AUTO_BANK_MATCH.trx_errors_amount := difference_amount - CE_AUTO_BANK_MATCH.csl_charges_amount;

Line 1097: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_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,
1101: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

Line 1109: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

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';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then

Line 1142: gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_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,
1146: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,

Line 1155: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

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;
1159: --

Line 1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);

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: --
1185: -- Payment Batch

Line 1193: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),

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,
1197: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

Line 1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

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');
1211: END IF;

Line 1221: gl_date => TO_DATE(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD' ),'YYYY/MM/DD'),

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,
1225: errors_amount => CE_AUTO_BANK_MATCH.trx_errors_amount,

Line 1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,

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');
1240: END IF;

Line 1253: gl_date => CE_AUTO_BANK_REC.G_gl_date,

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,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,

Line 1266: X_SET_OF_BOOKS_ID => CE_AUTO_BANK_REC.G_set_of_books_id,

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,
1270: X_ACTIVITY_TYPE_ID => CE_AUTO_BANK_REC.G_receivables_trx_id,

Line 1268: X_RECEIPT_METHOD_ID => CE_AUTO_BANK_REC.G_payment_method_id,

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',
1272: X_REFERENCE_TYPE => 'REMITTANCE BATCH',

Line 1270: X_ACTIVITY_TYPE_ID => CE_AUTO_BANK_REC.G_receivables_trx_id,

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,
1274: X_TAX_ID => NULL,

Line 1276: X_CR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_cr_vat_tax_code,

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,
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);

Line 1277: X_DR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_dr_vat_tax_code,

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,
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');

Line 1280: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);

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;
1284: cep_standard.debug('<