[Home] [Help]
615: | set_single_org |
616: | |
617: | DESCRIPTION |
618: | set to single org for AR/AP processing when
619: | CE_AUTO_BANK_REC.G_org_id is null
620: | - always use base table (_ALL) for AP/AR table when try to find
621: | a match. Our ce_security_profile_gt will handle the security |
622: | - set single org is needed when call AR/AP API, since we cannot
623: | pass the org_id
637: cep_standard.debug('current_org_id =' ||current_org_id );
638:
639: -- bug 3782741 set single org, since AR will not allow org_id to be passed
640: --IF CE_AUTO_BANK_MATCH.bau_org_id is not null THEN
641: --IF CE_AUTO_BANK_REC.G_org_id is not null THEN (this is set at ceabrdrb ce_auto_bank_rec)
642: IF (x_org_id is not null) THEN
643: IF ((current_org_id is null) or (x_org_id <> current_org_id )) THEN
644: mo_global.set_policy_context('S',x_org_id);
645: cep_standard.debug('set current_org_id to ' ||x_org_id );
693: cep_standard.debug( 'CE_AUTO_BANK_MATCH.csl_receivables_trx_id= '|| CE_AUTO_BANK_MATCH.csl_receivables_trx_id||
694: ',CE_AUTO_BANK_MATCH.trx_org_id='||CE_AUTO_BANK_MATCH.trx_org_id );
695:
696: x_receivables_trx_id := nvl(CE_AUTO_BANK_MATCH.csl_receivables_trx_id,
697: CE_AUTO_BANK_REC.G_receivables_trx_id);
698:
699: cep_standard.debug( 'x_receivables_trx_id= '|| x_receivables_trx_id);
700:
701: -- bug 5722367 removed the reference to ar_receivables_trx_all table to ar_receivables_trx
761: cep_standard.debug( '>>CE_AUTO_BANK_MATCH.match_oi_trx' );
762:
763: -- match xtr transaction first then non-xtr OI trx
764: -- bug 4914608 some bank acct used by xtr might not have xtr_use_enable_flag = Y
765: IF ((CE_AUTO_BANK_REC.G_legal_entity_id is not null) or
766: --IF ((CE_AUTO_BANK_MATCH.bau_legal_entity_id is not null) AND
767: (CE_AUTO_BANK_MATCH.bau_xtr_use_enable_flag = 'Y')) THEN
768: cep_standard.debug( ' use ce_185_transactions_v CE_AUTO_BANK_MATCH.csl_trx_date='|| CE_AUTO_BANK_MATCH.csl_trx_date);
769: BEGIN -- BUG 11719138
809: CE_AUTO_BANK_MATCH.gt_seq_id
810: --FROM ce_185_transactions_v catv
811: FROM ce_available_transactions_tmp catv
812: WHERE catv.trx_type = tx_type
813: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)
814: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
815: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
816: AND to_char(catv.trx_date,'YYYY/MM/DD') =
817: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
877: CE_AUTO_BANK_MATCH.gt_seq_id
878: --FROM ce_999_transactions_v catv
879: FROM ce_available_transactions_tmp catv
880: WHERE catv.trx_type = tx_type
881: --AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
882: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
883: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
884: AND to_char(catv.trx_date,'YYYY/MM/DD') =
885: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
940:
941: --
942: -- When Fixed relationship is found, exchange info is not mandatory.
943: --
944: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency='||CE_AUTO_BANK_REC.G_functional_currency ||
945: ', CE_AUTO_BANK_MATCH.csl_currency_code=' ||CE_AUTO_BANK_MATCH.csl_currency_code);
946:
947: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_exchange_rate_date='||CE_AUTO_BANK_MATCH.csl_exchange_rate_date ||
948: ', CE_AUTO_BANK_MATCH.csl_trx_date='||CE_AUTO_BANK_MATCH.csl_trx_date);
948: ', CE_AUTO_BANK_MATCH.csl_trx_date='||CE_AUTO_BANK_MATCH.csl_trx_date);
949:
950: BEGIN
951: gl_currency_api.get_relation(
952: CE_AUTO_BANK_REC.G_functional_currency,
953: CE_AUTO_BANK_MATCH.csl_currency_code,
954: nvl(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
955: CE_AUTO_BANK_MATCH.csl_trx_date),
956: fixed_relation,
992: CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL AND
993: CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL AND
994: CE_AUTO_BANK_MATCH.csl_original_amount IS NULL)
995: THEN
996: cep_standard.debug('++CE_AUTO_BANK_REC.G_exchange_rate_type = ' || CE_AUTO_BANK_REC.G_exchange_rate_type);
997: cep_standard.debug('++CE_AUTO_BANK_REC.G_exchange_rate_date = ' || CE_AUTO_BANK_REC.G_exchange_rate_date);
998: cep_standard.debug('++CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '|| CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
999:
1000: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
993: CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL AND
994: CE_AUTO_BANK_MATCH.csl_original_amount IS NULL)
995: THEN
996: cep_standard.debug('++CE_AUTO_BANK_REC.G_exchange_rate_type = ' || CE_AUTO_BANK_REC.G_exchange_rate_type);
997: cep_standard.debug('++CE_AUTO_BANK_REC.G_exchange_rate_date = ' || CE_AUTO_BANK_REC.G_exchange_rate_date);
998: cep_standard.debug('++CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '|| CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
999:
1000: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
1001: THEN
998: cep_standard.debug('++CE_AUTO_BANK_MATCH.csl_clearing_trx_type = '|| CE_AUTO_BANK_MATCH.csl_clearing_trx_type);
999:
1000: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
1001: THEN
1002: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_REC.G_cashflow_exchange_rate_type;
1003: ELSE
1004: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_REC.G_exchange_rate_type;
1005: END IF;
1006:
1000: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
1001: THEN
1002: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_REC.G_cashflow_exchange_rate_type;
1003: ELSE
1004: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := CE_AUTO_BANK_REC.G_exchange_rate_type;
1005: END IF;
1006:
1007: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
1008: THEN
1009: cep_standard.debug('++CE_AUTO_BANK_MATCH.trx_reference_type = ' || CE_AUTO_BANK_MATCH.trx_reference_type);
1010:
1011: IF (CE_AUTO_BANK_MATCH.trx_reference_type = 'STMT') -- JEC
1012: THEN
1013: cep_standard.debug('[JEC]++CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = ' || CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE);
1014: IF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'CFD')
1015: THEN
1016: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1017: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'CLD')
1010:
1011: IF (CE_AUTO_BANK_MATCH.trx_reference_type = 'STMT') -- JEC
1012: THEN
1013: cep_standard.debug('[JEC]++CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = ' || CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE);
1014: IF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'CFD')
1015: THEN
1016: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1017: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'CLD')
1018: THEN
1013: cep_standard.debug('[JEC]++CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = ' || CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE);
1014: IF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'CFD')
1015: THEN
1016: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1017: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'CLD')
1018: THEN
1019: /* The statement line trx date is used for the cleared date in autoReconciliation
1020: So, we will use the matching transaction cleared date when the cashflow exchange
1021: date type is set to use the cleared date. If there is no cleared date, then the
1022: statement line transaction date will be used. */
1023: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := NVL(CE_AUTO_BANK_MATCH.trx_cleared_date,
1024: CE_AUTO_BANK_MATCH.csl_trx_date);
1025:
1026: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'BSD')
1027: THEN
1028: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1029: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'BSG')
1030: THEN
1025:
1026: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'BSD')
1027: THEN
1028: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1029: ELSIF (CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE = 'BSG')
1030: THEN
1031: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1032: END IF;
1033:
1031: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1032: END IF;
1033:
1034: ELSE -- BAT
1035: cep_standard.debug('[BAT]++CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = ' || CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE);
1036: IF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'CFD')
1037: THEN
1038: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1039: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'AVD')
1032: END IF;
1033:
1034: ELSE -- BAT
1035: cep_standard.debug('[BAT]++CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = ' || CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE);
1036: IF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'CFD')
1037: THEN
1038: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1039: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'AVD')
1040: THEN
1035: cep_standard.debug('[BAT]++CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = ' || CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE);
1036: IF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'CFD')
1037: THEN
1038: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1039: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'AVD')
1040: THEN
1041: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_value_date;
1042: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'CLD')
1043: THEN
1038: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1039: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'AVD')
1040: THEN
1041: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_value_date;
1042: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'CLD')
1043: THEN
1044: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := NVL(CE_AUTO_BANK_MATCH.trx_cleared_date,
1045: CE_AUTO_BANK_MATCH.csl_trx_date);
1046: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'BSD')
1042: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'CLD')
1043: THEN
1044: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := NVL(CE_AUTO_BANK_MATCH.trx_cleared_date,
1045: CE_AUTO_BANK_MATCH.csl_trx_date);
1046: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'BSD')
1047: THEN
1048: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1049: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'BSG')
1050: THEN
1045: CE_AUTO_BANK_MATCH.csl_trx_date);
1046: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'BSD')
1047: THEN
1048: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1049: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'BSG')
1050: THEN
1051: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1052: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'SLD')
1053: THEN
1048: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1049: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'BSG')
1050: THEN
1051: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1052: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'SLD')
1053: THEN
1054: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csl_trx_date;
1055: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'TRX')
1056: THEN
1051: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1052: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'SLD')
1053: THEN
1054: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csl_trx_date;
1055: ELSIF (CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE = 'TRX')
1056: THEN
1057: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_deposit_date;
1058: END IF;
1059: cep_standard.debug('[BAT]++CE_AUTO_BANK_MATCH.csl_exchange_rate_date = ' || CE_AUTO_BANK_MATCH.csl_exchange_rate_date);
1058: END IF;
1059: cep_standard.debug('[BAT]++CE_AUTO_BANK_MATCH.csl_exchange_rate_date = ' || CE_AUTO_BANK_MATCH.csl_exchange_rate_date);
1060: END IF;
1061: ELSE -- not cashflow
1062: IF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'SLD')
1063: THEN
1064: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csl_trx_date;
1065: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'BSD')
1066: THEN
1061: ELSE -- not cashflow
1062: IF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'SLD')
1063: THEN
1064: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csl_trx_date;
1065: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'BSD')
1066: THEN
1067: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1068: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'BGD')
1069: THEN
1064: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csl_trx_date;
1065: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'BSD')
1066: THEN
1067: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1068: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'BGD')
1069: THEN
1070: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1071: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TCD')
1072: THEN
1067: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_date;
1068: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'BGD')
1069: THEN
1070: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1071: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TCD')
1072: THEN
1073: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1074: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TXD')
1075: THEN
1070: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.csh_statement_gl_date;
1071: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TCD')
1072: THEN
1073: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1074: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TXD')
1075: THEN
1076: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
1077: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TGD')
1078: THEN
1073: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_date;
1074: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TXD')
1075: THEN
1076: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_exchange_rate_date;
1077: ELSIF (CE_AUTO_BANK_REC.G_exchange_rate_date = 'TGD')
1078: THEN
1079: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1080: END IF;
1081: END IF;
1150: END IF;
1151:
1152: ELSE -- not 'User'
1153: BEGIN
1154: cep_standard.debug('CE_AUTO_BANK_REC.G_set_of_books_id = '||CE_AUTO_BANK_REC.G_set_of_books_id);
1155: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_currency_code = '|| CE_AUTO_BANK_MATCH.trx_currency_code );
1156: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_exchange_rate_date = '|| CE_AUTO_BANK_MATCH.csl_exchange_rate_date);
1157: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_exchange_rate_type = '|| CE_AUTO_BANK_MATCH.csl_exchange_rate_type);
1158:
1156: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_exchange_rate_date = '|| CE_AUTO_BANK_MATCH.csl_exchange_rate_date);
1157: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_exchange_rate_type = '|| CE_AUTO_BANK_MATCH.csl_exchange_rate_type);
1158:
1159: x_exchange_rate := gl_currency_api.get_rate(
1160: x_set_of_books_id => CE_AUTO_BANK_REC.G_set_of_books_id,
1161: x_from_currency => nvl(CE_AUTO_BANK_MATCH.trx_currency_code,CE_AUTO_BANK_MATCH.csl_currency_code),
1162: x_conversion_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1163: x_conversion_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type);
1164:
1659: --FROM ce_260_cf_transactions_v catv
1660: FROM ce_available_transactions_tmp catv
1661: WHERE catv.trx_type = tx_type
1662: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1663: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id , catv.legal_entity_id)
1664: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
1665: AND catv.check_number = CE_AUTO_BANK_MATCH.csl_statement_line_id
1666: AND catv.application_id = 261
1667: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
1693: --FROM ce_260_cf_transactions_v catv
1694: FROM ce_available_transactions_tmp catv
1695: WHERE catv.trx_type = tx_type
1696: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1697: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, catv.legal_entity_id)
1698: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
1699: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
1700: and catv.check_number is null
1701: AND to_char(catv.trx_date,'YYYY/MM/DD') =
1730: --FROM ce_260_cf_transactions_v catv
1731: FROM ce_available_transactions_tmp catv
1732: WHERE catv.trx_type = tx_type
1733: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
1734: --AND catv.legal_entity_id = CE_AUTO_BANK_REC.G_legal_entity_id
1735: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
1736: --AND catv.customer_id = CE_AUTO_BANK_MATCH.csl_bank_trx_number
1737: AND catv.bank_account_text = CE_AUTO_BANK_MATCH.csl_bank_account_text
1738: and catv.check_number is null
1897: INTO
1898: CE_AUTO_BANK_MATCH.G_le_amount_tolerance,
1899: CE_AUTO_BANK_MATCH.G_le_percent_tolerance,
1900: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling,
1901: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
1902: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1903: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1904: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1905: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1898: CE_AUTO_BANK_MATCH.G_le_amount_tolerance,
1899: CE_AUTO_BANK_MATCH.G_le_percent_tolerance,
1900: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling,
1901: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
1902: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1903: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1904: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1905: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1906: le_found;
1899: CE_AUTO_BANK_MATCH.G_le_percent_tolerance,
1900: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling,
1901: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
1902: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1903: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1904: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1905: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1906: le_found;
1907:
1900: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling,
1901: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
1902: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1903: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1904: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1905: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1906: le_found;
1907:
1908: CLOSE le_sys_par;
1901: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
1902: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1903: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1904: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1905: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1906: le_found;
1907:
1908: CLOSE le_sys_par;
1909:
1913: --no system parameter set at LE level default value
1914: CE_AUTO_BANK_MATCH.G_le_amount_tolerance := 0;
1915: CE_AUTO_BANK_MATCH.G_le_percent_tolerance := 0;
1916: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling := 'F';
1917: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT := 'CHARGES';
1918: --CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE
1919: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT :='NR';
1920: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE :='BSD';
1921: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE :='TRX';
1914: CE_AUTO_BANK_MATCH.G_le_amount_tolerance := 0;
1915: CE_AUTO_BANK_MATCH.G_le_percent_tolerance := 0;
1916: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling := 'F';
1917: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT := 'CHARGES';
1918: --CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE
1919: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT :='NR';
1920: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE :='BSD';
1921: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE :='TRX';
1922:
1915: CE_AUTO_BANK_MATCH.G_le_percent_tolerance := 0;
1916: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling := 'F';
1917: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT := 'CHARGES';
1918: --CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE
1919: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT :='NR';
1920: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE :='BSD';
1921: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE :='TRX';
1922:
1923: END IF;
1916: CE_AUTO_BANK_MATCH.G_le_Fx_Difference_Handling := 'F';
1917: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT := 'CHARGES';
1918: --CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE
1919: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT :='NR';
1920: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE :='BSD';
1921: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE :='TRX';
1922:
1923: END IF;
1924: */
1917: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT := 'CHARGES';
1918: --CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE
1919: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT :='NR';
1920: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE :='BSD';
1921: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE :='TRX';
1922:
1923: END IF;
1924: */
1925: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <>
1922:
1923: END IF;
1924: */
1925: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <>
1926: CE_AUTO_BANK_REC.G_functional_currency) and
1927: (CE_AUTO_BANK_MATCH.aba_bank_currency <>
1928: CE_AUTO_BANK_MATCH.trx_currency_code) THEN
1929: cep_standard.debug('Forex account not using the same curr as bk');
1930: curr := 6;
2030: FROM ce_available_transactions_tmp catv
2031: WHERE ltrim(upper(catv.batch_name)) =
2032: ltrim(upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number))
2033: AND catv.trx_date = CE_AUTO_BANK_MATCH.csl_trx_date
2034: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
2035: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
2036: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
2037: AND nvl(catv.status, 'C') <> 'V'
2038: AND catv.application_id = 802
2056: RAISE NO_DATA_FOUND;
2057: END IF;
2058:
2059: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <>
2060: CE_AUTO_BANK_REC.G_functional_currency) and
2061: (CE_AUTO_BANK_MATCH.aba_bank_currency <>
2062: CE_AUTO_BANK_MATCH.trx_currency_code) THEN
2063: cep_standard.debug('Forex account not using the same curr as bk');
2064: curr := 6;
2217: AND aba.bank_account_id = ba.bank_account_id
2218: AND aba.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id --bug5182963
2219: AND BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID
2220: AND aba.org_id = c.org_id
2221: AND aba.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, c.org_id)
2222: --AND aba.bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
2223: AND aba.AP_USE_ENABLE_FLAG = 'Y'
2224: AND c.status_lookup_code IN ('NEGOTIABLE', 'STOP INITIATED',
2225: DECODE(CE_AUTO_BANK_MATCH.csl_trx_type,
2253: and aph2.payment_history_id > aph.payment_history_id);
2254: ELSE
2255: cep_standard.debug('Searching for matching receipt, agent account...');
2256: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_bank_account_text='||CE_AUTO_BANK_MATCH.csl_bank_account_text);
2257: cep_standard.debug('CE_AUTO_BANK_REC.G_org_id='||CE_AUTO_BANK_REC.G_org_id);
2258: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_invoice_text='||CE_AUTO_BANK_MATCH.csl_invoice_text);
2259: cep_standard.debug('CE_AUTO_BANK_MATCH.csh_bank_account_id='||CE_AUTO_BANK_MATCH.csh_bank_account_id);
2260:
2261: SELECT distinct(crh.cash_receipt_history_id),
2260:
2261: SELECT distinct(crh.cash_receipt_history_id),
2262: crh.cash_receipt_id,
2263: crh.rowid,
2264: DECODE(cr.currency_code, CE_AUTO_BANK_REC.G_functional_currency, crh.amount,
2265: CE_AUTO_BANK_MATCH.aba_bank_currency, crh.amount,
2266: NVL(crh.acctd_amount,crh.amount)),
2267: crh.acctd_amount,
2268: crh.status,
2324: and crh.org_id = cr.org_id
2325: and crh.org_id = rec.org_id(+) /* 13610807 - Added outer join */
2326: AND aba.bank_acct_use_id = cr.remit_bank_acct_use_id
2327: AND aba.org_id = cr.org_id
2328: AND aba.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, aba.org_id)
2329: and BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID
2330: AND aba.bank_account_id = ba.bank_account_id
2331: AND aba.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
2332: AND aba.AR_USE_ENABLE_FLAG = 'Y'
2342: AND ext.ext_bank_account_id = cr.customer_bank_account_id
2343: AND ext.bank_account_num = CE_AUTO_BANK_MATCH.csl_bank_account_text;
2344: END IF;
2345:
2346: IF ((CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency) and
2347: (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_MATCH.trx_currency_code))
2348: THEN
2349: cep_standard.debug('Forex account not using the same curr as bk');
2350: curr := 1;
2499: AND aba.bank_account_id = ba.bank_account_id
2500: AND aba.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id --bug5182963
2501: and BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID
2502: AND aba.org_id = c.org_id
2503: AND aba.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, aba.org_id)
2504: --AND aba.bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
2505: AND c.status_lookup_code IN
2506: ('NEGOTIABLE', 'STOP INITIATED',
2507: DECODE(CE_AUTO_BANK_MATCH.csl_trx_type,
2535: SELECT distinct(crh.cash_receipt_history_id),
2536: crh.cash_receipt_id,
2537: crh.rowid,
2538: DECODE(cr.currency_code,
2539: CE_AUTO_BANK_REC.G_functional_currency, crh.amount,
2540: CE_AUTO_BANK_MATCH.aba_bank_currency, crh.amount,
2541: NVL(crh.acctd_amount,crh.amount)),
2542: crh.acctd_amount,
2543: crh.status,
2607: and crh.org_id = rec.org_id (+) -- Bug # 8587301 Added (+) Outer Join
2608: --AND aba.bank_account_id = cr.remittance_bank_account_id
2609: --AND cr.remittance_bank_account_id =CE_AUTO_BANK_MATCH.csh_bank_account_id
2610: AND aba.bank_acct_use_id = cr.remit_bank_acct_use_id
2611: AND aba.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, aba.org_id)
2612: --AND aba.bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
2613: AND aba.org_id = cr.org_id
2614: --AND aba.org_id = sp.org_id
2615: AND aba.bank_account_id = ba.bank_account_id
2614: --AND aba.org_id = sp.org_id
2615: AND aba.bank_account_id = ba.bank_account_id
2616: and BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID
2617: AND crh.status = decode(CE_AUTO_BANK_MATCH.csl_trx_type,
2618: 'NSF', decode(CE_AUTO_BANK_REC.G_nsf_handling,
2619: 'REVERSE',crh.status,
2620: 'REVERSED'),
2621: 'REJECTED', decode('REVERSE',
2622: 'REVERSE', crh.status,
2638: AND ps.trx_number = CE_AUTO_BANK_MATCH.csl_invoice_text;
2639: END IF;
2640:
2641: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <>
2642: CE_AUTO_BANK_REC.G_functional_currency) and
2643: (CE_AUTO_BANK_MATCH.aba_bank_currency <>
2644: CE_AUTO_BANK_MATCH.trx_currency_code) THEN
2645: cep_standard.debug('Forex account not using the same curr as bk');
2646: curr := 1;
2766: FROM
2767: CE_200_BATCHES_V ab
2768: WHERE
2769: UPPER(ab.trx_number) = UPPER(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
2770: AND (ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
2771: OR ab.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, ab.legal_entity_id))
2772: AND ab.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id;
2773:
2774: --bug 7514063 added NVL to the columns in select clause
2767: CE_200_BATCHES_V ab
2768: WHERE
2769: UPPER(ab.trx_number) = UPPER(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
2770: AND (ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
2771: OR ab.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, ab.legal_entity_id))
2772: AND ab.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id;
2773:
2774: --bug 7514063 added NVL to the columns in select clause
2775: curr := 2;
2837: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_amount='|| CE_AUTO_BANK_MATCH.trx_amount);
2838:
2839: /* Bug 8218042 - The amount is not rounded in the view. */
2840: IF ((CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') AND
2841: (CE_AUTO_BANK_MATCH.trx_currency_code <> CE_AUTO_BANK_REC.G_functional_currency))
2842: THEN
2843: cep_standard.debug('rounding trx amount');
2844: fnd_currency.get_info(
2845: CE_AUTO_BANK_REC.G_functional_currency,
2841: (CE_AUTO_BANK_MATCH.trx_currency_code <> CE_AUTO_BANK_REC.G_functional_currency))
2842: THEN
2843: cep_standard.debug('rounding trx amount');
2844: fnd_currency.get_info(
2845: CE_AUTO_BANK_REC.G_functional_currency,
2846: funct_curr_precision,
2847: funct_curr_ext_precision,
2848: funct_curr_min_acct_unit);
2849:
2893: FROM
2894: CE_222_BATCHES_V ab
2895: WHERE
2896: ab.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
2897: AND ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
2898: AND ab.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id;
2899:
2900: -- 16169940: Added debug statements
2901: cep_standard.debug('16169940: CE_AUTO_BANK_MATCH.trx_date='||CE_AUTO_BANK_MATCH.trx_date);
2938: cep_standard.debug('trx_cleared_amount = '||CE_AUTO_BANK_MATCH.trx_cleared_amount);
2939: cep_standard.debug('trx_curr_amount = '||CE_AUTO_BANK_MATCH.trx_curr_amount);
2940: cep_standard.debug('csl_match_type = '||CE_AUTO_BANK_MATCH.csl_match_type);
2941:
2942: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency) AND
2943: (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_MATCH.trx_currency_code)
2944: THEN
2945: cep_standard.debug('Forex account not using the same curr as bk');
2946: curr := 6;
3077: CE_AUTO_BANK_MATCH.logical_group_reference,
3078: CE_AUTO_BANK_MATCH.csl_clearing_trx_type -- bug 7571492
3079: FROM CE_200_GROUPS_V ab
3080: WHERE upper(ab.logical_group_reference) = upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
3081: AND (ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
3082: or
3083: ab.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, ab.legal_entity_id))
3084: AND ab.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id;
3085:
3079: FROM CE_200_GROUPS_V ab
3080: WHERE upper(ab.logical_group_reference) = upper(CE_AUTO_BANK_MATCH.csl_bank_trx_number)
3081: AND (ab.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, ab.org_id)
3082: or
3083: ab.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id, ab.legal_entity_id))
3084: AND ab.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id;
3085:
3086: -- 7571492 : Changed local variables in INTO clause to global variables.
3087: curr := 2;
3124: cep_standard.debug('trx_cleared_amount = '||CE_AUTO_BANK_MATCH.trx_cleared_amount);
3125: cep_standard.debug('trx_curr_amount = '||CE_AUTO_BANK_MATCH.trx_curr_amount);
3126: cep_standard.debug('csl_match_type = '||CE_AUTO_BANK_MATCH.csl_match_type);
3127:
3128: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency) AND
3129: (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_MATCH.trx_currency_code)
3130: THEN
3131: cep_standard.debug('Forex trx not using the same curr as account');
3132: curr := 6;
3134: END IF;
3135:
3136: /* Bug 8218042 - The amount is not rounded in the view. */
3137: IF ((CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') AND
3138: (CE_AUTO_BANK_MATCH.trx_currency_code <> CE_AUTO_BANK_REC.G_functional_currency))
3139: THEN
3140: cep_standard.debug('rounding trx amount');
3141: fnd_currency.get_info(CE_AUTO_BANK_REC.G_functional_currency,
3142: funct_curr_precision,
3137: IF ((CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') AND
3138: (CE_AUTO_BANK_MATCH.trx_currency_code <> CE_AUTO_BANK_REC.G_functional_currency))
3139: THEN
3140: cep_standard.debug('rounding trx amount');
3141: fnd_currency.get_info(CE_AUTO_BANK_REC.G_functional_currency,
3142: funct_curr_precision,
3143: funct_curr_ext_precision,
3144: funct_curr_min_acct_unit);
3145:
3200:
3201: BEGIN
3202: acctd_amount := gl_currency_api.convert_amount(
3203: CE_AUTO_BANK_MATCH.csl_currency_code,
3204: CE_AUTO_BANK_REC.G_functional_currency,
3205: nvl(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
3206: CE_AUTO_BANK_MATCH.csl_trx_date),
3207: CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
3208: amount_to_convert);
3273: CE_AUTO_BANK_MATCH.csl_matching_against <> 'STMT')
3274: THEN
3275: cep_standard.debug('DEBUG: trx_curr: '|| CE_AUTO_BANK_MATCH.trx_currency_type);
3276: IF (trx_currency_type = 'FOREIGN' AND
3277: CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
3278: OR(trx_currency_type = 'FUNCTIONAL' AND
3279: CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
3280: THEN
3281: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3275: cep_standard.debug('DEBUG: trx_curr: '|| CE_AUTO_BANK_MATCH.trx_currency_type);
3276: IF (trx_currency_type = 'FOREIGN' AND
3277: CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
3278: OR(trx_currency_type = 'FUNCTIONAL' AND
3279: CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
3280: THEN
3281: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3282: CE_AUTO_BANK_MATCH.csh_statement_header_id,
3283: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_NO_FOREIGN_MISC');
3315: -- bug# 939160
3316: -- Verified that exchange information is not null
3317: -- when creating foreign currency misc receipts
3318: --
3319: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency AND
3320: CE_AUTO_BANK_MATCH.csl_create_misc_trx_flag = 'Y' AND
3321: ( CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL
3322: OR CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL
3323: OR CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL))
3339: ELSIF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type <> 'User')
3340: THEN
3341: BEGIN
3342: receipt_amount := gl_currency_api.convert_amount(
3343: CE_AUTO_BANK_REC.G_functional_currency,
3344: CE_AUTO_BANK_MATCH.csl_currency_code,
3345: NVL(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
3346: CE_AUTO_BANK_MATCH.csl_trx_date),
3347: CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
3425: X_passin_mode => 'AUTO_TRX',
3426: X_trx_number => l_trx_number,
3427: X_doc_sequence_value => to_number(NULL),
3428: X_doc_sequence_id => to_number(NULL),
3429: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
3430: X_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
3431: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
3432: X_deposit_date => CE_AUTO_BANK_MATCH.csl_trx_date,
3433: X_amount => receipt_amount,
3431: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
3432: X_deposit_date => CE_AUTO_BANK_MATCH.csl_trx_date,
3433: X_amount => receipt_amount,
3434: X_bank_account_amount => base_receipt_amount,
3435: X_set_of_books_id => CE_AUTO_BANK_REC.G_set_of_books_id,
3436: X_misc_currency_code => NVL(CE_AUTO_BANK_MATCH.csl_currency_code,
3437: CE_AUTO_BANK_MATCH.aba_bank_currency),
3438: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
3439: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
3449: X_reference_id => NULL,
3450: X_clear_currency_code => NULL,
3451: X_statement_line_id =>
3452: X_statement_line_id,
3453: X_module_name => 'CE_AUTO_BANK_REC',
3454: X_cr_vat_tax_id => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
3455: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
3456: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
3457: X_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
3450: X_clear_currency_code => NULL,
3451: X_statement_line_id =>
3452: X_statement_line_id,
3453: X_module_name => 'CE_AUTO_BANK_REC',
3454: X_cr_vat_tax_id => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
3455: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
3456: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
3457: X_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
3458: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
3451: X_statement_line_id =>
3452: X_statement_line_id,
3453: X_module_name => 'CE_AUTO_BANK_REC',
3454: X_cr_vat_tax_id => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
3455: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
3456: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
3457: X_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
3458: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
3459: X_org_id => NVL(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id)
3455: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
3456: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
3457: X_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
3458: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
3459: X_org_id => NVL(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id)
3460: );
3461: cep_standard.debug('end create_misc_trx: >> CE_AUTO_BANK_CLEAR.misc_receipt');
3462: CE_AUTO_BANK_MATCH.csl_match_found := 'FULL';
3463: END IF; --9021558: check creation_status
3594: CE_AUTO_BANK_MATCH.csl_statement_line_id,
3595: 'CE_PMT_AMOUNT');
3596: END IF;
3597: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI'
3598: AND CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')
3599: THEN
3600: -- do not perform the following check for open-interface
3601: -- transactions when matched by Date and Amount
3602: cep_standard.debug('no check for OI trx matched by Date and Amount.');
3720: THEN
3721: -- Bug #8287134 Start
3722: IF (CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'CASHFLOW')
3723: THEN
3724: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 101)))
3725: THEN
3726: cep_standard.debug('ERROR#09: CE_INVALID_GL_PERIOD');
3727: valid_trx:=FALSE;
3728: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3733: -- Bug #8287134 End
3734: -- 7571492 : Added PGROUP for csl_match_type
3735: ELSIF (CE_AUTO_BANK_MATCH.csl_match_type IN ('PBATCH','PAYMENT','PGROUP'))
3736: THEN
3737: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)))
3738: THEN
3739: cep_standard.debug('ERROR#10: CE_INVALID_AP_PERIOD');
3740: valid_trx:=FALSE;
3741: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3751: CE_AUTO_BANK_MATCH.trx_clr_flag := 'Y';
3752: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_clr_flag='||CE_AUTO_BANK_MATCH.trx_clr_flag);
3753: END IF;
3754:
3755: ELSIF (NOT(CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)))
3756: THEN
3757: cep_standard.debug('ERROR#11: CE_INVALID_AR_PERIOD');
3758: valid_trx:= FALSE;
3759: CE_RECONCILIATION_ERRORS_PKG.insert_row(
3819:
3820: end if ;
3821: cep_standard.debug('l_unclearing_gl_date='||nvl(to_char(l_unclearing_gl_date),'
3822: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_date='||CE_AUTO_BANK_MATCH.trx_date);
3823: cep_standard.debug('CE_AUTO_BANK_REC.G_gl_date='||CE_AUTO_BANK_REC.G_gl_date);
3824:
3825: if CE_AUTO_BANK_REC.G_gl_date < trunc(nvl(l_unclearing_gl_date,CE_AUTO_BANK_MATCH.trx_date))
3826: then
3827: cep_standard.debug('ERROR#12: GL Date earlier than unrec/trx date');
3821: cep_standard.debug('l_unclearing_gl_date='||nvl(to_char(l_unclearing_gl_date),'
3822: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_date='||CE_AUTO_BANK_MATCH.trx_date);
3823: cep_standard.debug('CE_AUTO_BANK_REC.G_gl_date='||CE_AUTO_BANK_REC.G_gl_date);
3824:
3825: if CE_AUTO_BANK_REC.G_gl_date < trunc(nvl(l_unclearing_gl_date,CE_AUTO_BANK_MATCH.trx_date))
3826: then
3827: cep_standard.debug('ERROR#12: GL Date earlier than unrec/trx date');
3828: valid_trx:= FALSE;
3829: if l_unclearing_gl_date is null
3985: ce_available_transactions_tmp catv
3986: WHERE
3987: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
3988: AND catv.bank_account_amount = CE_AUTO_BANK_MATCH.csl_amount
3989: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
3990: AND catv.trx_number = LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0') --9963618
3991: AND catv.application_id = 801
3992: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
3993:
4053:
4054: cep_standard.debug('CE_AUTO_BANK_MATCH.bau_xtr_use_enable_flag ' ||CE_AUTO_BANK_MATCH.bau_xtr_use_enable_flag);
4055: curr := 3;
4056:
4057: IF (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'T')
4058: THEN
4059: IF ((CE_AUTO_BANK_REC.G_legal_entity_id is not null) OR
4060: (CE_AUTO_BANK_MATCH.bau_xtr_use_enable_flag = 'Y'))
4061: THEN
4055: curr := 3;
4056:
4057: IF (CE_AUTO_BANK_REC.G_open_interface_matching_code = 'T')
4058: THEN
4059: IF ((CE_AUTO_BANK_REC.G_legal_entity_id is not null) OR
4060: (CE_AUTO_BANK_MATCH.bau_xtr_use_enable_flag = 'Y'))
4061: THEN
4062: cep_standard.debug('use ce_185_transactions_v');
4063:
4111: WHERE
4112: catv.trx_type = tx_type
4113: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4114: --8978548: changed the NVL clause to use catv.legal_enity_id if null
4115: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,catv.legal_entity_id)
4116: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
4117: AND catv.application_id = 185
4118: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
4119:
4331: ce_222_reversal_v catv
4332: WHERE
4333: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4334: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4335: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4336: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
4337: AND catv.status = decode(CE_AUTO_BANK_REC.G_nsf_handling,'REVERSE',catv.status,'DM REVERSE',catv.status,'REVERSED')
4338: UNION
4339: SELECT
4333: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4334: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4335: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4336: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
4337: AND catv.status = decode(CE_AUTO_BANK_REC.G_nsf_handling,'REVERSE',catv.status,'DM REVERSE',catv.status,'REVERSED')
4338: UNION
4339: SELECT
4340: catv.trx_id,
4341: catv.cash_receipt_id,
4364: ce_available_transactions_tmp catv
4365: WHERE
4366: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4367: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4368: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4369: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
4370: AND catv.status = 'REVERSED'
4371: AND catv.application_id = 222
4372: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
4425: ce_available_transactions_tmp catv
4426: WHERE
4427: DECODE(tx_type,'CASH',DECODE(catv.trx_type,'MISC','CASH',catv.trx_type),catv.trx_type) = tx_type
4428: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4429: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4430: AND catv.trx_number = CE_AUTO_BANK_MATCH.csl_bank_trx_number
4431: AND catv.status <> 'REVERSED'
4432: AND catv.application_id = 222
4433: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
4435: ELSIF ((tx_type = 'PAYMENT') AND (CE_AUTO_BANK_MATCH.bau_ap_use_enable_flag = 'Y'))
4436: THEN
4437: curr := 6;
4438:
4439: cep_standard.DEBUG('G_show_void_payment_flag = ' || CE_AUTO_BANK_REC.G_show_void_payment_flag); -- Bug 16301520 Added debug
4440: numeric_result_trx_num :=
4441: ce_check_numeric(
4442: CE_AUTO_BANK_MATCH.csl_bank_trx_number,
4443: 1,
4445:
4446: IF (numeric_result_trx_num = '0')
4447: THEN /* CE_AUTO_BANK_MATCH.csl_bank_trx_number is numeric */
4448: --bug 8427347 - Added the If condition
4449: IF (CE_AUTO_BANK_REC.G_org_id IS NULL) --Start 9677807
4450: THEN
4451: SELECT
4452: catv.trx_id,
4453: catv.cash_receipt_id,
4500: WHERE
4501: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4502: AND catv.check_number = to_number(LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0'))
4503: AND catv.application_id = 200
4504: AND catv.status NOT in Decode(Nvl(CE_AUTO_BANK_REC.G_show_void_payment_flag,'N'),'N','VOIDED','X') -- Bug 16301520
4505: AND catv.reconciled_status_flag = 'N'; -- bug 8606133
4506: ELSE
4507: SELECT
4508: catv.trx_id,
4554: --ce_200_transactions_v catv
4555: ce_available_transactions_tmp catv
4556: WHERE
4557: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4558: AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
4559: AND catv.check_number = to_number(LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0'))
4560: AND catv.application_id = 200
4561: AND catv.status NOT in Decode(Nvl(CE_AUTO_BANK_REC.G_show_void_payment_flag,'N'),'N','VOIDED','X') -- Bug 16301520
4562: AND catv.reconciled_status_flag = 'N';
4557: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4558: AND catv.org_id = CE_AUTO_BANK_REC.G_org_id
4559: AND catv.check_number = to_number(LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0'))
4560: AND catv.application_id = 200
4561: AND catv.status NOT in Decode(Nvl(CE_AUTO_BANK_REC.G_show_void_payment_flag,'N'),'N','VOIDED','X') -- Bug 16301520
4562: AND catv.reconciled_status_flag = 'N';
4563: END IF; -- End 9677807
4564: --
4565: -- CE_AUTO_BANK_MATCH.csl_bank_trx_number is alphanumeric
4615: -- ce_200_transactions_v catv
4616: ce_available_transactions_tmp catv
4617: WHERE
4618: catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4619: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
4620: AND catv.trx_number = LTRIM(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '0')
4621: AND catv.application_id = 200
4622: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
4623: END IF;
4623: END IF;
4624:
4625: /* Bug 2925260 The amount is not rounded in the view. */
4626: IF ((CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') AND
4627: (CE_AUTO_BANK_MATCH.trx_currency_code <> CE_AUTO_BANK_REC.G_functional_currency))
4628: THEN
4629: fnd_currency.get_info(CE_AUTO_BANK_REC.G_functional_currency,
4630: funct_curr_precision,
4631: funct_curr_ext_precision,
4625: /* Bug 2925260 The amount is not rounded in the view. */
4626: IF ((CE_AUTO_BANK_MATCH.trx_currency_type = 'FOREIGN') AND
4627: (CE_AUTO_BANK_MATCH.trx_currency_code <> CE_AUTO_BANK_REC.G_functional_currency))
4628: THEN
4629: fnd_currency.get_info(CE_AUTO_BANK_REC.G_functional_currency,
4630: funct_curr_precision,
4631: funct_curr_ext_precision,
4632: funct_curr_min_acct_unit);
4633:
4638: /* Bug 2925260 End Code Changes */
4639:
4640: END IF;
4641:
4642: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency) AND
4643: (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_MATCH.trx_currency_code)
4644: THEN
4645: cep_standard.debug('Forex account not using the same curr as bk');
4646: curr := 9;
4882: AND catv.trx_type in ('MISC_DEBIT', 'MISC_CREDIT')
4883: AND v.trx_type = 'MISC'
4884: AND v.bank_account_id = catv.bank_account_id
4885: --AND v.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4886: AND v.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,v.org_id)
4887: AND v.trx_number = nvl(catv.trx_number,v.trx_number)
4888: AND to_char(v.trx_date,'YYYY/MM/DD') <=
4889: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4890: AND v.status in ('REMITTED', 'CLEARED', 'RISK_ELIMINATED')
4982: AND catv.trx_type in ('DEBIT', 'CREDIT')
4983: AND v.trx_type = 'CASH'
4984: AND v.bank_account_id = catv.bank_account_id
4985: --AND v.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4986: AND v.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, v.org_id)
4987: AND v.trx_number = nvl(catv.trx_number,v.trx_number)
4988: AND to_char(v.trx_date,'YYYY/MM/DD') <=
4989: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
4990: AND v.status in ('REMITTED', 'CLEARED', 'RISK_ELIMINATED')
5068: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5069: AND catv.trx_id <> CE_AUTO_BANK_MATCH.csl_statement_line_id
5070: AND catv.trx_type in ('DEBIT', 'CREDIT')
5071: AND v2.bank_account_id = catv.bank_account_id
5072: AND v2.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, v2.org_id)
5073: --AND v2.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5074: AND v2.trx_number = nvl(catv.trx_number,v2.trx_number)
5075: AND to_char(v2.trx_date,'YYYY/MM/DD') <=
5076: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5123: catv.CE_BANK_ACCT_USE_ID
5124: FROM ce_200_reconciled_v catv
5125: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5126: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5127: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
5128: AND nvl(catv.trx_number,'-99999')
5129: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5130: AND (nvl(catv.invoice_text, '-99999')
5131: = nvl(CE_AUTO_BANK_MATCH.csl_invoice_text,'-99999')
5168: catv.CE_BANK_ACCT_USE_ID
5169: FROM ce_222_reconciled_v catv
5170: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5171: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5172: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
5173: AND nvl(catv.trx_number,'-99999')
5174: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5175: AND (nvl(catv.invoice_text, '-99999')
5176: = nvl(CE_AUTO_BANK_MATCH.csl_invoice_text,'-99999')
5230: AND sl.trx_type in ('MISC_DEBIT', 'MISC_CREDIT')
5231: AND catv.trx_type = 'MISC'
5232: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5233: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5234: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
5235: AND nvl(catv.trx_number, '-99999')
5236: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5237: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5238: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5328: AND sl.trx_type in ('DEBIT', 'CREDIT')
5329: AND catv.trx_type = 'CASH'
5330: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5331: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5332: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
5333: AND nvl(catv.trx_number, '-99999')
5334: = nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-99999')
5335: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5336: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5425: AND sl.statement_line_id = catv.statement_line_id
5426: AND sl.trx_type in ('DEBIT', 'CREDIT')
5427: AND catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5428: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5429: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
5430: AND nvl(catv.trx_number,'-99999') =
5431: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number,'-99999')
5432: AND to_char(catv.trx_date,'YYYY/MM/DD') <=
5433: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5490: SELECT l.statement_line_id,
5491: l.rowid,
5492: l.trx_date,
5493: l.currency_code,
5494: decode(l.currency_code, CE_AUTO_BANK_REC.G_functional_currency,
5495: l.amount, CE_AUTO_BANK_MATCH.aba_bank_currency, l.amount,
5496: nvl(l.original_amount, l.amount)),
5497: l.original_amount,
5498: l.status,
5498: l.status,
5499: 0,
5500: l.trx_type,
5501: 1,
5502: decode(l.currency_code, CE_AUTO_BANK_REC.G_functional_currency,
5503: 'FUNCTIONAL', CE_AUTO_BANK_MATCH.aba_bank_currency, 'BANK',
5504: 'FOREIGN'),
5505: l.amount,
5506: l.trx_type,
5558: AND ar.org_id = r.org_id
5559: AND v.trx_type = 'CASH'
5560: AND v.bank_account_id = h.bank_account_id
5561: --AND v.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5562: AND v.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,v.org_id)
5563: AND v.trx_number = nvl(l.bank_trx_number,v.trx_number)
5564: AND to_char(v.trx_date,'YYYY/MM/DD') <=
5565: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5566: AND v.status in ('REMITTED', 'CLEARED', 'RISK_ELIMINATED')
5571: + decode(l.trx_type,
5572: 'CREDIT', l.amount,
5573: - l.amount)
5574: - decode(l.currency_code,
5575: CE_AUTO_BANK_REC.G_functional_currency,
5576: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance,
5577: CE_AUTO_BANK_MATCH.aba_bank_currency,
5578: tolerance_amount,
5579: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance))
5581: + decode(l.trx_type,
5582: 'CREDIT', l.amount,
5583: - l.amount)
5584: + decode(l.currency_code,
5585: CE_AUTO_BANK_REC.G_functional_currency,
5586: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance,
5587: CE_AUTO_BANK_MATCH.aba_bank_currency,
5588: tolerance_amount,
5589: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance))
5605: SELECT l.statement_line_id,
5606: l.rowid,
5607: l.trx_date,
5608: l.currency_code,
5609: decode(l.currency_code, CE_AUTO_BANK_REC.G_functional_currency,
5610: l.amount, CE_AUTO_BANK_MATCH.aba_bank_currency, l.amount,
5611: nvl(l.original_amount, l.amount)),
5612: l.original_amount,
5613: l.status,
5613: l.status,
5614: 0,
5615: l.trx_type,
5616: 1,
5617: decode(l.currency_code, CE_AUTO_BANK_REC.G_functional_currency,
5618: 'FUNCTIONAL', CE_AUTO_BANK_MATCH.aba_bank_currency, 'BANK',
5619: 'FOREIGN'),
5620: l.amount,
5621: l.trx_type,
5670: AND nvl(r.status_flag, 'U') <> 'U'
5671: AND glcc.conversion_type = l.exchange_rate_type
5672: AND v2.bank_account_id = h.bank_account_id
5673: --AND v2.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5674: AND v2.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,v2.org_id)
5675: AND v2.trx_number = nvl(l.bank_trx_number,v2.trx_number)
5676: AND to_char(v2.trx_date,'YYYY/MM/DD') <=
5677: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
5678: AND CE_AUTO_BANK_MATCH.calc_csl_amount +
5680: AND v2.bank_account_amount
5681: between (- CE_AUTO_BANK_MATCH.calc_csl_amount
5682: + decode(l.trx_type, 'DEBIT', l.amount, - l.amount)
5683: - decode(l.currency_code,
5684: CE_AUTO_BANK_REC.G_functional_currency,
5685: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance,
5686: CE_AUTO_BANK_MATCH.aba_bank_currency,
5687: tolerance_amount,
5688: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance))
5688: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance))
5689: and (- CE_AUTO_BANK_MATCH.calc_csl_amount
5690: + decode(l.trx_type, 'DEBIT', l.amount, - l.amount)
5691: + decode(l.currency_code,
5692: CE_AUTO_BANK_REC.G_functional_currency,
5693: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance,
5694: CE_AUTO_BANK_MATCH.aba_bank_currency,
5695: tolerance_amount,
5696: CE_AUTO_BANK_MATCH.ba_ap_amount_tolerance))
5723: /* Calculate calc_tolerance_amount. */
5724:
5725: IF (NVL(CE_AUTO_BANK_MATCH.csl_currency_code,
5726: CE_AUTO_BANK_MATCH.aba_bank_currency)
5727: = CE_AUTO_BANK_REC.G_functional_currency) THEN
5728: CE_AUTO_BANK_MATCH.trx_currency_type := 'FUNCTIONAL';
5729: ELSIF (NVL(CE_AUTO_BANK_MATCH.csl_currency_code,
5730: CE_AUTO_BANK_MATCH.aba_bank_currency)
5731: = CE_AUTO_BANK_MATCH.aba_bank_currency) THEN
5792: END IF;
5793: */
5794: /*
5795: IF (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK') THEN
5796: IF (NVL(CE_AUTO_BANK_REC.G_amount_tolerance,0) <> 0) THEN
5797: calc_tolerance_amount :=
5798: convert_amount_tolerance(CE_AUTO_BANK_REC.G_amount_tolerance);
5799: ELSE
5800: calc_tolerance_amount := 0;
5794: /*
5795: IF (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK') THEN
5796: IF (NVL(CE_AUTO_BANK_REC.G_amount_tolerance,0) <> 0) THEN
5797: calc_tolerance_amount :=
5798: convert_amount_tolerance(CE_AUTO_BANK_REC.G_amount_tolerance);
5799: ELSE
5800: calc_tolerance_amount := 0;
5801: END IF;
5802: ELSIF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL','FOREIGN')) THEN
5799: ELSE
5800: calc_tolerance_amount := 0;
5801: END IF;
5802: ELSIF (CE_AUTO_BANK_MATCH.trx_currency_type IN ('FUNCTIONAL','FOREIGN')) THEN
5803: calc_tolerance_amount := CE_AUTO_BANK_REC.G_amount_tolerance;
5804: END IF;
5805: */
5806:
5807: --------------------------------------------------------------------------------
6027:
6028: ARP_CASHBOOK.unclear(
6029: p_cr_id => CE_AUTO_BANK_MATCH.trx_cash_receipt_id,
6030: p_trx_date => CE_AUTO_BANK_MATCH.trx_date,
6031: p_gl_date => CE_AUTO_BANK_REC.G_gl_date,
6032: p_actual_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6033: p_module_name => 'CEABRMA',
6034: p_module_version => '1.0',
6035: p_crh_id => CE_AUTO_BANK_MATCH.trx_id);
6275: elsif (loc_match_type = 'RECEIPT') then
6276: ARP_CASHBOOK.unclear(
6277: p_cr_id => loc_cash_receipt_id,
6278: p_trx_date => loc_trx_date,
6279: p_gl_date => CE_AUTO_BANK_REC.G_gl_date,
6280: p_actual_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6281: p_module_name => 'CEABRMA',
6282: p_module_version => '1.0',
6283: p_crh_id => loc_trx_id);
6448: --
6449: -- bug 1941362
6450: -- Reset G_gl_date because trx_match might have changed the G_gl_date
6451: --
6452: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_REC.G_gl_date_original;
6453:
6454: --
6455: -- Set the trx_currency_type
6456: --
6454: --
6455: -- Set the trx_currency_type
6456: --
6457: IF (NVL(CE_AUTO_BANK_MATCH.csl_currency_code, CE_AUTO_BANK_MATCH.aba_bank_currency)
6458: = CE_AUTO_BANK_REC.G_functional_currency)
6459: THEN
6460: CE_AUTO_BANK_MATCH.trx_currency_type := 'FUNCTIONAL';
6461: ELSIF (NVL(CE_AUTO_BANK_MATCH.csl_currency_code,CE_AUTO_BANK_MATCH.aba_bank_currency)
6462: = CE_AUTO_BANK_MATCH.aba_bank_currency)
6473: -- in the bank account reconciliation controls.
6474:
6475: IF ((csl_bank_trx_number IS NULL)
6476: AND NOT (csl_reconcile_flag = 'OI'
6477: AND NVL(CE_AUTO_BANK_REC.G_open_interface_matching_code,'T') = 'D')
6478: AND (csl_invoice_text IS NULL AND csl_bank_account_text IS NULL)
6479: AND (csl_invoice_text IS NULL AND csl_customer_text IS NULL)
6480: AND (CE_AUTO_BANK_MATCH.csl_trx_type NOT IN ('MISC_CREDIT', 'MISC_DEBIT')
6481: OR (CE_AUTO_BANK_MATCH.csl_trx_type IN ('MISC_CREDIT', 'MISC_DEBIT')
6484: cep_standard.debug('Required field(s) for matching not available at statement line');
6485: RAISE NO_DATA_FOUND;
6486:
6487: ELSIF ( trx_currency_type = 'FOREIGN'
6488: AND CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
6489: OR( trx_currency_type = 'FUNCTIONAL'
6490: AND CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
6491: THEN
6492: cep_standard.debug('Currency mismatch: CE_NO_FOREIGN_RECON');
6486:
6487: ELSIF ( trx_currency_type = 'FOREIGN'
6488: AND CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
6489: OR( trx_currency_type = 'FUNCTIONAL'
6490: AND CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency)
6491: THEN
6492: cep_standard.debug('Currency mismatch: CE_NO_FOREIGN_RECON');
6493: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6494: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6499: -- Open Interface system option needs to be enabled
6500: -- before we try to find the match
6501: --
6502: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI'
6503: AND NVL(CE_AUTO_BANK_REC.G_open_interface_flag,'N') = 'N' )
6504: THEN
6505: CE_RECONCILIATION_ERRORS_PKG.insert_row(
6506: CE_AUTO_BANK_MATCH.csh_statement_header_id,
6507: CE_AUTO_BANK_MATCH.csl_statement_line_id,
6555: ELSE
6556: IF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('DEBIT', 'STOP'))
6557: THEN
6558: --FOR SEPA ER 6700007 START
6559: primary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order,'T');
6560: --bug 7565001 : selective setting secondary_match
6561: IF (primary_match = 'T')
6562: THEN
6563: secondary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order2,'B');
6559: primary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order,'T');
6560: --bug 7565001 : selective setting secondary_match
6561: IF (primary_match = 'T')
6562: THEN
6563: secondary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order2,'B');
6564: ELSE
6565: secondary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order2,'T');
6566: END IF;
6567:
6561: IF (primary_match = 'T')
6562: THEN
6563: secondary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order2,'B');
6564: ELSE
6565: secondary_match := NVL(CE_AUTO_BANK_REC.G_ap_matching_order2,'T');
6566: END IF;
6567:
6568: IF (primary_match = 'T') AND (secondary_match = 'B') THEN
6569: Tertiary_match := 'G' ;
6579: Tertiary_match := 'T';
6580: END IF;
6581: cep_standard.debug('AP primary_match -'||primary_match||' secondary_match -'||secondary_match||' Tertiary_match -'||Tertiary_match);
6582: ELSE
6583: primary_match := NVL(CE_AUTO_BANK_REC.G_ar_matching_order,'T');
6584: IF (primary_match = 'T') THEN
6585: secondary_match := 'B';
6586: ELSE
6587: secondary_match := 'T';
6638: -- bug 1796965
6639: SELECT count(*)
6640: INTO accounting_method_found
6641: FROM ar_system_parameters s
6642: WHERE s.org_id = NVL(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id);
6643:
6644: IF (accounting_method_found = 1)
6645: THEN
6646: SELECT accounting_method
6645: THEN
6646: SELECT accounting_method
6647: INTO CE_AUTO_BANK_MATCH.ar_accounting_method
6648: FROM ar_system_parameters s
6649: WHERE s.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id);
6650: ELSE
6651: CE_AUTO_BANK_MATCH.ar_accounting_method := NULL;
6652: END IF;
6653: cep_standard.debug('CE_AUTO_BANK_MATCH.ar_accounting_method =' ||CE_AUTO_BANK_MATCH.ar_accounting_method);
6681:
6682: IF (misc_exists = 'N')
6683: THEN
6684: IF (NVL(CE_AUTO_BANK_MATCH.csl_receipt_method_id,
6685: CE_AUTO_BANK_REC.G_payment_method_id) IS NULL
6686: OR
6687: NVL(CE_AUTO_BANK_MATCH.csl_receivables_trx_id,
6688: CE_AUTO_BANK_REC.G_receivables_trx_id) IS NULL)
6689: THEN
6684: IF (NVL(CE_AUTO_BANK_MATCH.csl_receipt_method_id,
6685: CE_AUTO_BANK_REC.G_payment_method_id) IS NULL
6686: OR
6687: NVL(CE_AUTO_BANK_MATCH.csl_receivables_trx_id,
6688: CE_AUTO_BANK_REC.G_receivables_trx_id) IS NULL)
6689: THEN
6690: cep_standard.debug('No receipt method or receivable activity info.');
6691: CE_AUTO_BANK_MATCH.nsf_info_flag := 'Y';
6692: ELSE
6716: -- bug# 939160
6717: -- Verified that exchange information is not null
6718: -- when creating foreign currency misc receipts
6719: --
6720: IF (CE_AUTO_BANK_MATCH.aba_bank_currency <> CE_AUTO_BANK_REC.G_functional_currency AND
6721: CE_AUTO_BANK_MATCH.csl_create_misc_trx_flag = 'Y' AND
6722: (CE_AUTO_BANK_MATCH.csl_exchange_rate_date IS NULL
6723: OR CE_AUTO_BANK_MATCH.csl_exchange_rate_type IS NULL
6724: OR CE_AUTO_BANK_MATCH.csl_exchange_rate IS NULL))
6741: ELSIF (CE_AUTO_BANK_MATCH.csl_exchange_rate_type <> 'User')
6742: THEN
6743: BEGIN
6744: receipt_amount := gl_currency_api.convert_amount(
6745: CE_AUTO_BANK_REC.G_functional_currency,
6746: CE_AUTO_BANK_MATCH.csl_currency_code,
6747: nvl(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,CE_AUTO_BANK_MATCH.csl_trx_date),
6748: CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
6749: (CE_AUTO_BANK_MATCH.trx_amount-CE_AUTO_BANK_MATCH.calc_csl_amount));
6805: X_passin_mode => 'AUTO_TRX',
6806: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number || '/NSF',
6807: X_doc_sequence_value => NULL,
6808: X_doc_sequence_id => to_number(NULL),
6809: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
6810: X_value_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6811: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
6812: X_deposit_date => CE_AUTO_BANK_MATCH.csl_trx_date,
6813: X_amount => receipt_amount,
6811: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
6812: X_deposit_date => CE_AUTO_BANK_MATCH.csl_trx_date,
6813: X_amount => receipt_amount,
6814: X_bank_account_amount => base_receipt_amount,
6815: X_set_of_books_id => CE_AUTO_BANK_REC.G_set_of_books_id,
6816: X_misc_currency_code => NVL(CE_AUTO_BANK_MATCH.csl_currency_code, CE_AUTO_BANK_MATCH.aba_bank_currency),
6817: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
6818: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
6819: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
6816: X_misc_currency_code => NVL(CE_AUTO_BANK_MATCH.csl_currency_code, CE_AUTO_BANK_MATCH.aba_bank_currency),
6817: X_exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
6818: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
6819: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
6820: X_receipt_method_id => nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id),
6821: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
6822: X_activity_type_id => nvl(CE_AUTO_BANK_MATCH.csl_receivables_trx_id, CE_AUTO_BANK_REC.G_receivables_trx_id),
6823: X_comments => 'Created by Auto Bank Rec',
6824: X_reference_type => NULL,
6818: X_exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
6819: X_exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
6820: X_receipt_method_id => nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id),
6821: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
6822: X_activity_type_id => nvl(CE_AUTO_BANK_MATCH.csl_receivables_trx_id, CE_AUTO_BANK_REC.G_receivables_trx_id),
6823: X_comments => 'Created by Auto Bank Rec',
6824: X_reference_type => NULL,
6825: X_reference_id => to_number(NULL),
6826: X_clear_currency_code => NULL,
6827: X_statement_line_id => X_statement_line_id,
6828: X_tax_id => l_vat_tax_id,
6829: X_tax_rate => l_tax_rate,
6830: X_paid_from => NULL,
6831: X_module_name => 'CE_AUTO_BANK_REC',
6832: X_cr_vat_tax_id => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
6833: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
6834: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
6835: X_cr_id => p_cr_id,
6828: X_tax_id => l_vat_tax_id,
6829: X_tax_rate => l_tax_rate,
6830: X_paid_from => NULL,
6831: X_module_name => 'CE_AUTO_BANK_REC',
6832: X_cr_vat_tax_id => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
6833: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
6834: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
6835: X_cr_id => p_cr_id,
6836: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6829: X_tax_rate => l_tax_rate,
6830: X_paid_from => NULL,
6831: X_module_name => 'CE_AUTO_BANK_REC',
6832: X_cr_vat_tax_id => CE_AUTO_BANK_REC.G_cr_vat_tax_code,
6833: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
6834: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
6835: X_cr_id => p_cr_id,
6836: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6837: X_org_id => nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id));
6833: X_dr_vat_tax_id => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
6834: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
6835: X_cr_id => p_cr_id,
6836: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
6837: X_org_id => nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id));
6838:
6839: cep_standard.debug('end match_engine: >> CE_AUTO_BANK_CLEAR.misc_receipt');
6840: cep_standard.debug('p_cr_id = '|| p_cr_id);
6841: cep_standard.debug('Create a misc receipt with cash_receipt_id='|| to_char(p_cr_id));
7086: --------------------------------------------------------------------- */
7087: PROCEDURE update_gl_date IS
7088: BEGIN
7089: cep_standard.debug('>>CE_AUTO_BANK_MATCH.update_gl_date');
7090: IF ((CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)) OR
7091: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222))) THEN
7092: UPDATE ce_statement_headers
7093: SET gl_date = CE_AUTO_BANK_REC.G_gl_date
7094: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid;
7087: PROCEDURE update_gl_date IS
7088: BEGIN
7089: cep_standard.debug('>>CE_AUTO_BANK_MATCH.update_gl_date');
7090: IF ((CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)) OR
7091: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222))) THEN
7092: UPDATE ce_statement_headers
7093: SET gl_date = CE_AUTO_BANK_REC.G_gl_date
7094: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid;
7095: END IF;
7089: cep_standard.debug('>>CE_AUTO_BANK_MATCH.update_gl_date');
7090: IF ((CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200)) OR
7091: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222))) THEN
7092: UPDATE ce_statement_headers
7093: SET gl_date = CE_AUTO_BANK_REC.G_gl_date
7094: WHERE rowid = CE_AUTO_BANK_MATCH.csh_rowid;
7095: END IF;
7096: cep_standard.debug('<
7193:
7194: CE_AUTO_BANK_MATCH.tolerance_amount := 0;
7195: IF (CE_AUTO_BANK_MATCH.csl_trx_type IN ('REJECTED', 'STOP')
7196: OR (CE_AUTO_BANK_MATCH.csl_clearing_trx_type in ('ROI_LINE', 'XTR_LINE')
7197: AND CE_AUTO_BANK_REC.G_open_interface_matching_code = 'D')) THEN
7198: CE_AUTO_BANK_MATCH.tolerance_amount := 0;
7199: ELSE
7200: --
7201: -- Amount tolerance
7355:
7356: BEGIN
7357: --bug 4452153 exchanged the currency code parameters
7358: acctd_amount := gl_currency_api.convert_amount(
7359: CE_AUTO_BANK_REC.G_functional_currency,
7360: CE_AUTO_BANK_MATCH.csl_currency_code,
7361: nvl(CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
7362: CE_AUTO_BANK_MATCH.csl_trx_date),
7363: CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
7415: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_receipt_method_id '|| CE_AUTO_BANK_MATCH.csl_receipt_method_id);
7416: cep_standard.debug('CE_AUTO_BANK_MATCH.trx_org_id '|| CE_AUTO_BANK_MATCH.trx_org_id);
7417:
7418: SELECT arm.name
7419: INTO CE_AUTO_BANK_REC.G_payment_method_name
7420: FROM ar_receipt_method_accounts arma,
7421: ar_receipt_methods arm
7422: WHERE arm.receipt_method_id = arma.receipt_method_id
7423: --AND arma.REMIT_BANK_ACCT_USE_ID = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
7423: --AND arma.REMIT_BANK_ACCT_USE_ID = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
7424: AND arma.REMIT_BANK_ACCT_USE_ID = nvl(CE_AUTO_BANK_MATCH.trx_bank_acct_use_id, arma.REMIT_BANK_ACCT_USE_ID)
7425: --AND arma.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7426: --AND arma.org_id = CE_AUTO_BANK_MATCH.bau_org_id
7427: AND arma.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id, nvl(CE_AUTO_BANK_REC.G_org_id, arma.org_id))
7428: --AND arm.receipt_method_id = nvl(CE_AUTO_BANK_REC.G_payment_method_id,CE_AUTO_BANK_MATCH.csl_receipt_method_id)
7429: AND arm.receipt_method_id = nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id)
7430: AND CE_AUTO_BANK_MATCH.csl_trx_date between nvl(arm.start_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7431: AND nvl(arm.end_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7424: AND arma.REMIT_BANK_ACCT_USE_ID = nvl(CE_AUTO_BANK_MATCH.trx_bank_acct_use_id, arma.REMIT_BANK_ACCT_USE_ID)
7425: --AND arma.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7426: --AND arma.org_id = CE_AUTO_BANK_MATCH.bau_org_id
7427: AND arma.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id, nvl(CE_AUTO_BANK_REC.G_org_id, arma.org_id))
7428: --AND arm.receipt_method_id = nvl(CE_AUTO_BANK_REC.G_payment_method_id,CE_AUTO_BANK_MATCH.csl_receipt_method_id)
7429: AND arm.receipt_method_id = nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id)
7430: AND CE_AUTO_BANK_MATCH.csl_trx_date between nvl(arm.start_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7431: AND nvl(arm.end_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7432: and exists (select 1 from ce_bank_acct_uses_gt_v bau
7425: --AND arma.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7426: --AND arma.org_id = CE_AUTO_BANK_MATCH.bau_org_id
7427: AND arma.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id, nvl(CE_AUTO_BANK_REC.G_org_id, arma.org_id))
7428: --AND arm.receipt_method_id = nvl(CE_AUTO_BANK_REC.G_payment_method_id,CE_AUTO_BANK_MATCH.csl_receipt_method_id)
7429: AND arm.receipt_method_id = nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_id, CE_AUTO_BANK_REC.G_payment_method_id)
7430: AND CE_AUTO_BANK_MATCH.csl_trx_date between nvl(arm.start_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7431: AND nvl(arm.end_date,CE_AUTO_BANK_MATCH.csl_trx_date)
7432: and exists (select 1 from ce_bank_acct_uses_gt_v bau
7433: where bau.bank_acct_use_id = arma.REMIT_BANK_ACCT_USE_ID
7483:
7484: select LEGAL_ENTITY_ID
7485: into l_le_id
7486: from XLE_FP_OU_LEDGER_V
7487: where OPERATING_UNIT_ID =nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7488: exception
7489: WHEN OTHERS THEN
7490: -- Bug 12989812 Start
7491: cep_standard.debug('Fetching LE ID from Bank Acc ID.');
7488: exception
7489: WHEN OTHERS THEN
7490: -- Bug 12989812 Start
7491: cep_standard.debug('Fetching LE ID from Bank Acc ID.');
7492: -- l_le_id := nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7493: SELECT ACCOUNT_OWNER_ORG_ID
7494: INTO L_LE_ID
7495: FROM CE_BANK_ACCOUNTS
7496: WHERE BANK_ACCOUNT_ID = CE_AUTO_BANK_MATCH.CSH_BANK_ACCOUNT_ID ;
7503: SELECT ar.liability_tax_code, ar.asset_tax_code
7504: INTO y_dr_vat_tax_code, y_cr_vat_tax_code
7505: FROM ar_receivables_trx ar
7506: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7507: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ; --CE_AUTO_BANK_MATCH.bau_org_id;
7508: */
7509: SELECT nvl(
7510: (
7511: select rtld.asset_tax_code
7522: ),ar.liability_tax_code) liability_tax_code
7523: INTO y_cr_vat_tax_code, y_dr_vat_tax_code
7524: FROM ar_receivables_trx ar
7525: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7526: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7527: else
7528: y_dr_vat_tax_code := CE_AUTO_BANK_REC.G_dr_vat_tax_code;
7529: y_cr_vat_tax_code := CE_AUTO_BANK_REC.G_cr_vat_tax_code;
7530: end if;
7524: FROM ar_receivables_trx ar
7525: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7526: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7527: else
7528: y_dr_vat_tax_code := CE_AUTO_BANK_REC.G_dr_vat_tax_code;
7529: y_cr_vat_tax_code := CE_AUTO_BANK_REC.G_cr_vat_tax_code;
7530: end if;
7531:
7532: cep_standard.debug( 'y_dr_vat_tax_code ='||y_dr_vat_tax_code);
7525: WHERE ar.receivables_trx_id = CE_AUTO_BANK_MATCH.csl_receivables_trx_id
7526: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id) ;
7527: else
7528: y_dr_vat_tax_code := CE_AUTO_BANK_REC.G_dr_vat_tax_code;
7529: y_cr_vat_tax_code := CE_AUTO_BANK_REC.G_cr_vat_tax_code;
7530: end if;
7531:
7532: cep_standard.debug( 'y_dr_vat_tax_code ='||y_dr_vat_tax_code);
7533: cep_standard.debug( 'y_cr_vat_tax_code ='||y_cr_vat_tax_code);
7543: p_validation_level => NULL,
7544: x_return_status => l_return_status,
7545: x_msg_count => l_msg_count,
7546: x_msg_data => l_msg_data,
7547: p_internal_org_id => nvl(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id), --:org_id,
7548: p_legal_entity_id => l_le_id, --:org_id,
7549: p_transaction_date => sysdate,
7550: p_related_doc_date => NULL,
7551: p_adjusted_doc_date=> NULL,
7557: SELECT ar.vat_tax_id, ar.tax_rate
7558: INTO l_vat_tax_id, X_tax_rate
7559: FROM ce_misc_tax_code_v ar --ar_vat_tax ar
7560: WHERE ar.tax_code = y_dr_vat_tax_code
7561: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id, CE_AUTO_BANK_REC.G_org_id)
7562: AND to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
7563: between to_char(ar.start_date,'YYYY/MM/DD')
7564: and NVL(to_char(ar.end_date,'YYYY/MM/DD'),
7565: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'));
7567: SELECT ar.vat_tax_id, ar.tax_rate
7568: INTO l_vat_tax_id, X_tax_rate
7569: FROM ce_misc_tax_code_v ar --ar_vat_tax ar
7570: WHERE tax_code = y_cr_vat_tax_code
7571: AND ar.org_id = nvl(CE_AUTO_BANK_MATCH.trx_org_id,CE_AUTO_BANK_REC.G_org_id)
7572: AND to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD')
7573: between to_char(ar.start_date,'YYYY/MM/DD')
7574: and NVL(to_char(ar.end_date,'YYYY/MM/DD'),
7575: to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'));
7796: /* 14834217: End */
7797: FROM ce_available_transactions_tmp catv
7798: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
7799: AND catv.TRX_ID = CE_AUTO_BANK_MATCH.csl_cashflow_id
7800: AND catv.legal_entity_id = nvl(CE_AUTO_BANK_REC.G_legal_entity_id,catv.legal_entity_id)
7801: AND catv.application_id = 261
7802: AND NVL(catv.reconciled_status_flag, 'N') = 'N';
7803:
7804: cep_standard.debug( 'no_of_matches '||no_of_matches );
7853: -- 16002860: START
7854: -- GL Period should be open
7855: -- Bug 14840476: GL Date = Clearing Date = Statement Line Date
7856: -- Autorecon parameter GL date will not be used for cashflows generated for bank statements
7857: -- l_clearing_gl_date := CE_AUTO_BANK_REC.G_gl_date_original;
7858: l_clearing_gl_date := CE_AUTO_BANK_MATCH.csl_trx_date;
7859:
7860: cep_standard.debug('l_clearing_gl_date='||to_Char(l_clearing_gl_date));
7861: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(l_clearing_gl_date, 101)))
7857: -- l_clearing_gl_date := CE_AUTO_BANK_REC.G_gl_date_original;
7858: l_clearing_gl_date := CE_AUTO_BANK_MATCH.csl_trx_date;
7859:
7860: cep_standard.debug('l_clearing_gl_date='||to_Char(l_clearing_gl_date));
7861: IF(NOT(CE_AUTO_BANK_REC.find_gl_period(l_clearing_gl_date, 101)))
7862: THEN
7863: cep_standard.debug('GL period is closed');
7864: CE_RECONCILIATION_ERRORS_PKG.delete_row(
7865: CE_AUTO_BANK_MATCH.csh_statement_header_id,
7936: X_currency_code => NVL(CE_AUTO_BANK_MATCH.csl_currency_code,CE_AUTO_BANK_MATCH.aba_bank_currency),
7937: auto_reconciled_flag => 'Y',
7938: X_statement_header_id => d_statement_header_id,
7939: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
7940: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
7941: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
7942:
7943: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
7944:
10044: -- Bug 16298972 End
10045:
10046: cep_standard.debug('-> Opening r_branch_cursor');
10047: OPEN r_branch_cursor(
10048: CE_AUTO_BANK_REC.G_bank_branch_id,
10049: CE_AUTO_BANK_REC.G_bank_account_id,
10050: CE_AUTO_BANK_REC.G_org_id,
10051: CE_AUTO_BANK_REC.G_legal_entity_id);
10052: j := 0;
10045:
10046: cep_standard.debug('-> Opening r_branch_cursor');
10047: OPEN r_branch_cursor(
10048: CE_AUTO_BANK_REC.G_bank_branch_id,
10049: CE_AUTO_BANK_REC.G_bank_account_id,
10050: CE_AUTO_BANK_REC.G_org_id,
10051: CE_AUTO_BANK_REC.G_legal_entity_id);
10052: j := 0;
10053: LOOP
10046: cep_standard.debug('-> Opening r_branch_cursor');
10047: OPEN r_branch_cursor(
10048: CE_AUTO_BANK_REC.G_bank_branch_id,
10049: CE_AUTO_BANK_REC.G_bank_account_id,
10050: CE_AUTO_BANK_REC.G_org_id,
10051: CE_AUTO_BANK_REC.G_legal_entity_id);
10052: j := 0;
10053: LOOP
10054: cep_standard.debug('-> Fetching r_branch_cursor');
10047: OPEN r_branch_cursor(
10048: CE_AUTO_BANK_REC.G_bank_branch_id,
10049: CE_AUTO_BANK_REC.G_bank_account_id,
10050: CE_AUTO_BANK_REC.G_org_id,
10051: CE_AUTO_BANK_REC.G_legal_entity_id);
10052: j := 0;
10053: LOOP
10054: cep_standard.debug('-> Fetching r_branch_cursor');
10055: FETCH r_branch_cursor INTO
10061: -- For each bank account set the use flag
10062: set_acct_type(CE_AUTO_BANK_MATCH.csh_bank_account_id);
10063:
10064: -- configuration set at system parameter's level level
10065: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) THEN
10066: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10064: -- configuration set at system parameter's level level
10065: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) THEN
10066: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10065: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) THEN
10066: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10066: IF (CE_AUTO_BANK_MATCH.ba_owner_le_id is not null) THEN
10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10067: CE_SYSTEM_PARAMETERS1_PKG.select_columns(
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10068: CE_AUTO_BANK_REC.G_rowid,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10069: CE_AUTO_BANK_REC.G_set_of_books_id,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10070: CE_AUTO_BANK_REC.G_cashbook_begin_date,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10071: CE_AUTO_BANK_REC.G_show_cleared_flag,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10072: CE_AUTO_BANK_REC.G_show_void_payment_flag,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10073: CE_AUTO_BANK_REC.G_line_autocreation_flag,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10074: CE_AUTO_BANK_REC.G_interface_purge_flag,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10075: CE_AUTO_BANK_REC.G_interface_archive_flag,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10076: CE_AUTO_BANK_REC.G_lines_per_commit,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10084: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
10077: CE_AUTO_BANK_REC.G_functional_currency,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10084: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
10085: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
10078: CE_AUTO_BANK_REC.G_sob_short_name,
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10084: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
10085: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
10086: CE_AUTO_BANK_MATCH.ba_owner_le_id);
10079: CE_AUTO_BANK_REC.G_account_period_type,
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10084: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
10085: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
10086: CE_AUTO_BANK_MATCH.ba_owner_le_id);
10087: END IF;
10080: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10084: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
10085: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
10086: CE_AUTO_BANK_MATCH.ba_owner_le_id);
10087: END IF;
10088: END IF;
10081: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
10082: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
10083: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
10084: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
10085: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
10086: CE_AUTO_BANK_MATCH.ba_owner_le_id);
10087: END IF;
10088: END IF;
10089:
10097: CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance,
10098: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance,
10099: CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance,
10100: CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance,
10101: CE_AUTO_BANK_REC.G_float_handling_flag,
10102: CE_AUTO_BANK_REC.G_ap_matching_order,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10098: CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance,
10099: CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance,
10100: CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance,
10101: CE_AUTO_BANK_REC.G_float_handling_flag,
10102: CE_AUTO_BANK_REC.G_ap_matching_order,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10099: CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance,
10100: CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance,
10101: CE_AUTO_BANK_REC.G_float_handling_flag,
10102: CE_AUTO_BANK_REC.G_ap_matching_order,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10100: CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance,
10101: CE_AUTO_BANK_REC.G_float_handling_flag,
10102: CE_AUTO_BANK_REC.G_ap_matching_order,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10108: CE_AUTO_BANK_REC.G_open_interface_clear_status,
10101: CE_AUTO_BANK_REC.G_float_handling_flag,
10102: CE_AUTO_BANK_REC.G_ap_matching_order,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10108: CE_AUTO_BANK_REC.G_open_interface_clear_status,
10109: CE_AUTO_BANK_REC.G_open_interface_matching_code,
10102: CE_AUTO_BANK_REC.G_ap_matching_order,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10108: CE_AUTO_BANK_REC.G_open_interface_clear_status,
10109: CE_AUTO_BANK_REC.G_open_interface_matching_code,
10110: CE_AUTO_BANK_MATCH.BA_RECON_OI_AMOUNT_TOLERANCE,
10103: CE_AUTO_BANK_REC.G_ar_matching_order,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10108: CE_AUTO_BANK_REC.G_open_interface_clear_status,
10109: CE_AUTO_BANK_REC.G_open_interface_matching_code,
10110: CE_AUTO_BANK_MATCH.BA_RECON_OI_AMOUNT_TOLERANCE,
10111: CE_AUTO_BANK_MATCH.BA_RECON_OI_PERCENT_TOLERANCE,
10104: CE_AUTO_BANK_REC.G_exchange_rate_type,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10108: CE_AUTO_BANK_REC.G_open_interface_clear_status,
10109: CE_AUTO_BANK_REC.G_open_interface_matching_code,
10110: CE_AUTO_BANK_MATCH.BA_RECON_OI_AMOUNT_TOLERANCE,
10111: CE_AUTO_BANK_MATCH.BA_RECON_OI_PERCENT_TOLERANCE,
10112: ignore_trx_id,
10105: CE_AUTO_BANK_REC.G_exchange_rate_date,
10106: CE_AUTO_BANK_REC.G_open_interface_flag,
10107: CE_AUTO_BANK_REC.G_open_interface_float_status,
10108: CE_AUTO_BANK_REC.G_open_interface_clear_status,
10109: CE_AUTO_BANK_REC.G_open_interface_matching_code,
10110: CE_AUTO_BANK_MATCH.BA_RECON_OI_AMOUNT_TOLERANCE,
10111: CE_AUTO_BANK_MATCH.BA_RECON_OI_PERCENT_TOLERANCE,
10112: ignore_trx_id,
10113: ignore_trx_id2,
10113: ignore_trx_id2,
10114: CE_AUTO_BANK_MATCH.BA_RECON_AP_FX_DIFF_HANDLING,
10115: CE_AUTO_BANK_MATCH.BA_RECON_AR_FX_DIFF_HANDLING,
10116: CE_AUTO_BANK_MATCH.BA_RECON_CE_FX_DIFF_HANDLING,
10117: CE_AUTO_BANK_REC.G_differences_account,
10118: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
10119: CE_AUTO_BANK_MATCH.ba_owner_le_id,
10120: CE_AUTO_BANK_MATCH.csh_bank_account_id,
10121: CE_AUTO_BANK_REC.G_ap_matching_order2 -- FOR SEPA ER 6700007
10114: CE_AUTO_BANK_MATCH.BA_RECON_AP_FX_DIFF_HANDLING,
10115: CE_AUTO_BANK_MATCH.BA_RECON_AR_FX_DIFF_HANDLING,
10116: CE_AUTO_BANK_MATCH.BA_RECON_CE_FX_DIFF_HANDLING,
10117: CE_AUTO_BANK_REC.G_differences_account,
10118: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
10119: CE_AUTO_BANK_MATCH.ba_owner_le_id,
10120: CE_AUTO_BANK_MATCH.csh_bank_account_id,
10121: CE_AUTO_BANK_REC.G_ap_matching_order2 -- FOR SEPA ER 6700007
10122: );
10117: CE_AUTO_BANK_REC.G_differences_account,
10118: CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT,
10119: CE_AUTO_BANK_MATCH.ba_owner_le_id,
10120: CE_AUTO_BANK_MATCH.csh_bank_account_id,
10121: CE_AUTO_BANK_REC.G_ap_matching_order2 -- FOR SEPA ER 6700007
10122: );
10123: END IF;
10124:
10125: cep_standard.debug('-> CE_AUTO_BANK_MATCH.BA_ROWID '|| CE_AUTO_BANK_MATCH.BA_ROWID);
10128: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance= ' || CE_AUTO_BANK_MATCH.ba_ar_amount_tolerance);
10129: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance= '||CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance);
10130: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance= ' || CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance);
10131: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance= '||CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance);
10132: cep_standard.debug('-> CE_AUTO_BANK_REC.G_float_handling_flag='||CE_AUTO_BANK_REC.G_float_handling_flag);
10133: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ap_matching_order ='|| CE_AUTO_BANK_REC.G_ap_matching_order);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10129: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance= '||CE_AUTO_BANK_MATCH.ba_ar_percent_tolerance);
10130: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance= ' || CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance);
10131: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance= '||CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance);
10132: cep_standard.debug('-> CE_AUTO_BANK_REC.G_float_handling_flag='||CE_AUTO_BANK_REC.G_float_handling_flag);
10133: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ap_matching_order ='|| CE_AUTO_BANK_REC.G_ap_matching_order);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10130: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance= ' || CE_AUTO_BANK_MATCH.ba_ce_amount_tolerance);
10131: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance= '||CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance);
10132: cep_standard.debug('-> CE_AUTO_BANK_REC.G_float_handling_flag='||CE_AUTO_BANK_REC.G_float_handling_flag);
10133: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ap_matching_order ='|| CE_AUTO_BANK_REC.G_ap_matching_order);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10131: cep_standard.debug('-> CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance= '||CE_AUTO_BANK_MATCH.ba_ce_percent_tolerance);
10132: cep_standard.debug('-> CE_AUTO_BANK_REC.G_float_handling_flag='||CE_AUTO_BANK_REC.G_float_handling_flag);
10133: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ap_matching_order ='|| CE_AUTO_BANK_REC.G_ap_matching_order);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10139: cep_standard.debug('-> REC.G_open_interface_clear_status='|| CE_AUTO_BANK_REC.G_open_interface_clear_status);
10132: cep_standard.debug('-> CE_AUTO_BANK_REC.G_float_handling_flag='||CE_AUTO_BANK_REC.G_float_handling_flag);
10133: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ap_matching_order ='|| CE_AUTO_BANK_REC.G_ap_matching_order);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10139: cep_standard.debug('-> REC.G_open_interface_clear_status='|| CE_AUTO_BANK_REC.G_open_interface_clear_status);
10140: cep_standard.debug('-> REC.G_open_interface_matching_code='||CE_AUTO_BANK_REC.G_open_interface_matching_code);
10133: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ap_matching_order ='|| CE_AUTO_BANK_REC.G_ap_matching_order);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10139: cep_standard.debug('-> REC.G_open_interface_clear_status='|| CE_AUTO_BANK_REC.G_open_interface_clear_status);
10140: cep_standard.debug('-> REC.G_open_interface_matching_code='||CE_AUTO_BANK_REC.G_open_interface_matching_code);
10141: cep_standard.debug('-> BA_RECON_OI_AMOUNT_TOLERANCE='|| BA_RECON_OI_AMOUNT_TOLERANCE);
10134: cep_standard.debug('-> CE_AUTO_BANK_REC.G_ar_matching_order ='|| CE_AUTO_BANK_REC.G_ar_matching_order);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10139: cep_standard.debug('-> REC.G_open_interface_clear_status='|| CE_AUTO_BANK_REC.G_open_interface_clear_status);
10140: cep_standard.debug('-> REC.G_open_interface_matching_code='||CE_AUTO_BANK_REC.G_open_interface_matching_code);
10141: cep_standard.debug('-> BA_RECON_OI_AMOUNT_TOLERANCE='|| BA_RECON_OI_AMOUNT_TOLERANCE);
10142: cep_standard.debug('-> BA_RECON_OI_PERCENT_TOLERANCE='|| BA_RECON_OI_PERCENT_TOLERANCE);
10135: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_type='||CE_AUTO_BANK_REC.G_exchange_rate_type);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10139: cep_standard.debug('-> REC.G_open_interface_clear_status='|| CE_AUTO_BANK_REC.G_open_interface_clear_status);
10140: cep_standard.debug('-> REC.G_open_interface_matching_code='||CE_AUTO_BANK_REC.G_open_interface_matching_code);
10141: cep_standard.debug('-> BA_RECON_OI_AMOUNT_TOLERANCE='|| BA_RECON_OI_AMOUNT_TOLERANCE);
10142: cep_standard.debug('-> BA_RECON_OI_PERCENT_TOLERANCE='|| BA_RECON_OI_PERCENT_TOLERANCE);
10143: cep_standard.debug('-> BA_RECON_AP_FX_DIFF_HANDLING='|| BA_RECON_AP_FX_DIFF_HANDLING);
10136: cep_standard.debug('-> CE_AUTO_BANK_REC.G_exchange_rate_date='|| CE_AUTO_BANK_REC.G_exchange_rate_date);
10137: cep_standard.debug('-> CE_AUTO_BANK_REC.G_open_interface_flag='|| CE_AUTO_BANK_REC.G_open_interface_flag);
10138: cep_standard.debug('-> REC.G_open_interface_float_status='|| CE_AUTO_BANK_REC.G_open_interface_float_status);
10139: cep_standard.debug('-> REC.G_open_interface_clear_status='|| CE_AUTO_BANK_REC.G_open_interface_clear_status);
10140: cep_standard.debug('-> REC.G_open_interface_matching_code='||CE_AUTO_BANK_REC.G_open_interface_matching_code);
10141: cep_standard.debug('-> BA_RECON_OI_AMOUNT_TOLERANCE='|| BA_RECON_OI_AMOUNT_TOLERANCE);
10142: cep_standard.debug('-> BA_RECON_OI_PERCENT_TOLERANCE='|| BA_RECON_OI_PERCENT_TOLERANCE);
10143: cep_standard.debug('-> BA_RECON_AP_FX_DIFF_HANDLING='|| BA_RECON_AP_FX_DIFF_HANDLING);
10144: cep_standard.debug('-> BA_RECON_AR_FX_DIFF_HANDLING='|| BA_RECON_AR_FX_DIFF_HANDLING);
10142: cep_standard.debug('-> BA_RECON_OI_PERCENT_TOLERANCE='|| BA_RECON_OI_PERCENT_TOLERANCE);
10143: cep_standard.debug('-> BA_RECON_AP_FX_DIFF_HANDLING='|| BA_RECON_AP_FX_DIFF_HANDLING);
10144: cep_standard.debug('-> BA_RECON_AR_FX_DIFF_HANDLING='|| BA_RECON_AR_FX_DIFF_HANDLING);
10145: cep_standard.debug('-> BA_RECON_CE_FX_DIFF_HANDLING='|| BA_RECON_CE_FX_DIFF_HANDLING);
10146: cep_standard.debug('-> REC.G_differences_account=' || CE_AUTO_BANK_REC.G_differences_account);
10147: cep_standard.debug('-> REC.G_CE_DIFFERENCES_ACCOUNT=' || CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT);
10148:
10149: IF (r_branch_cursor%ROWCOUNT = j) THEN
10150: cep_standard.debug('-> no more bank accounts in branch. exit r_branch_cursor loop');
10143: cep_standard.debug('-> BA_RECON_AP_FX_DIFF_HANDLING='|| BA_RECON_AP_FX_DIFF_HANDLING);
10144: cep_standard.debug('-> BA_RECON_AR_FX_DIFF_HANDLING='|| BA_RECON_AR_FX_DIFF_HANDLING);
10145: cep_standard.debug('-> BA_RECON_CE_FX_DIFF_HANDLING='|| BA_RECON_CE_FX_DIFF_HANDLING);
10146: cep_standard.debug('-> REC.G_differences_account=' || CE_AUTO_BANK_REC.G_differences_account);
10147: cep_standard.debug('-> REC.G_CE_DIFFERENCES_ACCOUNT=' || CE_AUTO_BANK_REC.G_CE_DIFFERENCES_ACCOUNT);
10148:
10149: IF (r_branch_cursor%ROWCOUNT = j) THEN
10150: cep_standard.debug('-> no more bank accounts in branch. exit r_branch_cursor loop');
10151: EXIT;
10169: END IF;
10170:
10171: cep_standard.debug('--> Opening r_bank_cursor');
10172: OPEN r_bank_cursor (
10173: CE_AUTO_BANK_REC.G_statement_number_from,
10174: CE_AUTO_BANK_REC.G_statement_number_to,
10175: CE_AUTO_BANK_REC.G_statement_date_from,
10176: CE_AUTO_BANK_REC.G_statement_date_to,
10177: CE_AUTO_BANK_MATCH.csh_bank_account_id);
10170:
10171: cep_standard.debug('--> Opening r_bank_cursor');
10172: OPEN r_bank_cursor (
10173: CE_AUTO_BANK_REC.G_statement_number_from,
10174: CE_AUTO_BANK_REC.G_statement_number_to,
10175: CE_AUTO_BANK_REC.G_statement_date_from,
10176: CE_AUTO_BANK_REC.G_statement_date_to,
10177: CE_AUTO_BANK_MATCH.csh_bank_account_id);
10178: i := 0;
10171: cep_standard.debug('--> Opening r_bank_cursor');
10172: OPEN r_bank_cursor (
10173: CE_AUTO_BANK_REC.G_statement_number_from,
10174: CE_AUTO_BANK_REC.G_statement_number_to,
10175: CE_AUTO_BANK_REC.G_statement_date_from,
10176: CE_AUTO_BANK_REC.G_statement_date_to,
10177: CE_AUTO_BANK_MATCH.csh_bank_account_id);
10178: i := 0;
10179: LOOP
10172: OPEN r_bank_cursor (
10173: CE_AUTO_BANK_REC.G_statement_number_from,
10174: CE_AUTO_BANK_REC.G_statement_number_to,
10175: CE_AUTO_BANK_REC.G_statement_date_from,
10176: CE_AUTO_BANK_REC.G_statement_date_to,
10177: CE_AUTO_BANK_MATCH.csh_bank_account_id);
10178: i := 0;
10179: LOOP
10180: cep_standard.debug('--> CE_AUTO_BANK_MATCH.Fetching r_bank_cursor');
10385: CE_AUTO_BANK_MATCH.csh_statement_header_id,
10386: CE_AUTO_BANK_MATCH.csl_statement_line_id,
10387: 'CE_LINE_LOCKED');
10388: END IF;
10389: IF (statement_line_count = CE_AUTO_BANK_REC.G_lines_per_commit)
10390: THEN
10391: COMMIT;
10392: statement_line_count := 0;
10393: END IF;