eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_IMPORT dependencies on CE_STATEMENT_LINES

Line 150: ce_statement_lines_interface l

146: curr.currency_code
147: FROM fnd_currencies curr,
148: gl_daily_conversion_types gt,
149: ce_transaction_codes ctc,
150: ce_statement_lines_interface l
151: WHERE curr.currency_code(+) = l.currency_code
152: AND gt.user_conversion_type(+) = l.user_exchange_rate_type
153: AND ctc.trx_code(+) = l.trx_code
154: AND ctc.bank_account_id(+) = CE_AUTO_BANK_IMPORT.G_bank_account_id

Line 409: DELETE FROM ce_statement_lines_interface sl

405: END IF;
406: DELETE FROM ce_statement_headers_int sh
407: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
408:
409: DELETE FROM ce_statement_lines_interface sl
410: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
411: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
412: IF l_DEBUG in ('Y', 'C') THEN
413: cep_standard.debug('<

Line 515: FROM ce_statement_lines_interface

511: attribute12,
512: attribute13,
513: attribute14,
514: attribute15
515: FROM ce_statement_lines_interface
516: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
517: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
518: IF l_DEBUG in ('Y', 'C') THEN
519: cep_standard.debug('<

Line 760: csli_amount CE_STATEMENT_LINES.amount%TYPE;

756: | CALLED BY |
757: | import_prcess |
758: --------------------------------------------------------------------- */
759: FUNCTION lock_statement_line(csli_rowid IN VARCHAR2) RETURN BOOLEAN IS
760: csli_amount CE_STATEMENT_LINES.amount%TYPE;
761: BEGIN
762: IF l_DEBUG in ('Y', 'C') THEN
763: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
764: END IF;

Line 767: FROM ce_statement_lines_interface

763: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
764: END IF;
765: SELECT amount
766: INTO csli_amount
767: FROM ce_statement_lines_interface
768: WHERE rowid = csli_rowid
769: FOR UPDATE OF bank_account_num NOWAIT;
770: IF l_DEBUG in ('Y', 'C') THEN
771: cep_standard.debug('<

Line 793: | Copy the statement lines in CE_STATEMENT_LINES_INTERFACE into |

789: | PRIVATE PROCEDURE |
790: | transfer_lines |
791: | |
792: | DESCRIPTION |
793: | Copy the statement lines in CE_STATEMENT_LINES_INTERFACE into |
794: | CE_STATEMENT_LINES for the given statement and bank account |
795: | combination. Record the bank account id and not the bank |
796: | account number. If the currency field is null, populate it |
797: | with the base currency of the bank. |

Line 794: | CE_STATEMENT_LINES for the given statement and bank account |

790: | transfer_lines |
791: | |
792: | DESCRIPTION |
793: | Copy the statement lines in CE_STATEMENT_LINES_INTERFACE into |
794: | CE_STATEMENT_LINES for the given statement and bank account |
795: | combination. Record the bank account id and not the bank |
796: | account number. If the currency field is null, populate it |
797: | with the base currency of the bank. |
798: | |

Line 898: ce_statement_lines_interface csli,

894: csli.attribute13,
895: csli.attribute14,
896: csli.attribute15
897: FROM ce_transaction_codes ctc,
898: ce_statement_lines_interface csli,
899: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
900: WHERE ctc.trx_code(+) = csli.trx_code
901: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
902: aba.bank_account_id

Line 909: INSERT INTO ce_statement_lines

905: AND aba.bank_account_id = G_bank_account_id;
906: ELSIF (nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
907: --Bug 6710502: Added an nvl to subsisdiary flag to handle records upgraded from 11i to R12
908: IF ( nvl(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
909: INSERT INTO ce_statement_lines
910: (statement_line_id,
911: statement_header_id,
912: line_number,
913: trx_date,

Line 950: SELECT ce_statement_lines_s.nextval,

946: attribute12,
947: attribute13,
948: attribute14,
949: attribute15)
950: SELECT ce_statement_lines_s.nextval,
951: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
952: csli.line_number,
953: csli.trx_date,
954: (select distinct ctc.trx_type

Line 1005: ce_statement_lines_interface csli,

1001: csli.attribute14,
1002: csli.attribute15
1003: FROM --ce_transaction_codes ctc,
1004: gl_daily_conversion_types gdct,
1005: ce_statement_lines_interface csli,
1006: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1007: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type
1008: --AND ctc.trx_code(+) = csli.trx_code
1009: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =

Line 1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;

1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;

Line 1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;

Line 1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;

1816: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;

Line 1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;

1817: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;

1818: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;

1819: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;

1820: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1828: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1821: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1828: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1829: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;

Line 1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1822: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1828: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1829: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1830: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;

Line 1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1823: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1828: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1829: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1830: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1831: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;

Line 1828: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1824: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1825: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1826: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1827: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1828: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1829: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1830: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1831: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1832: r_currency_code FND_CURRENCIES.currency_code%TYPE;