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 151: ce_statement_lines_interface l

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

Line 417: DELETE FROM ce_statement_lines_interface sl

413: END IF;
414: DELETE FROM ce_statement_headers_int sh
415: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
416:
417: DELETE FROM ce_statement_lines_interface sl
418: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
419: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
420: IF l_DEBUG in ('Y', 'C') THEN
421: cep_standard.debug('<

Line 523: FROM ce_statement_lines_interface

519: attribute12,
520: attribute13,
521: attribute14,
522: attribute15
523: FROM ce_statement_lines_interface
524: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
525: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
526: IF l_DEBUG in ('Y', 'C') THEN
527: cep_standard.debug('<

Line 768: csli_amount CE_STATEMENT_LINES.amount%TYPE;

764: | CALLED BY |
765: | import_prcess |
766: --------------------------------------------------------------------- */
767: FUNCTION lock_statement_line(csli_rowid IN VARCHAR2) RETURN BOOLEAN IS
768: csli_amount CE_STATEMENT_LINES.amount%TYPE;
769: BEGIN
770: IF l_DEBUG in ('Y', 'C') THEN
771: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
772: END IF;

Line 775: FROM ce_statement_lines_interface

771: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
772: END IF;
773: SELECT amount
774: INTO csli_amount
775: FROM ce_statement_lines_interface
776: WHERE rowid = csli_rowid
777: FOR UPDATE OF bank_account_num NOWAIT;
778: IF l_DEBUG in ('Y', 'C') THEN
779: cep_standard.debug('<

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

797: | PRIVATE PROCEDURE |
798: | transfer_lines |
799: | |
800: | DESCRIPTION |
801: | Copy the statement lines in CE_STATEMENT_LINES_INTERFACE into |
802: | CE_STATEMENT_LINES for the given statement and bank account |
803: | combination. Record the bank account id and not the bank |
804: | account number. If the currency field is null, populate it |
805: | with the base currency of the bank. |

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

798: | transfer_lines |
799: | |
800: | DESCRIPTION |
801: | Copy the statement lines in CE_STATEMENT_LINES_INTERFACE into |
802: | CE_STATEMENT_LINES for the given statement and bank account |
803: | combination. Record the bank account id and not the bank |
804: | account number. If the currency field is null, populate it |
805: | with the base currency of the bank. |
806: | |

Line 906: ce_statement_lines_interface csli,

902: csli.attribute13,
903: csli.attribute14,
904: csli.attribute15
905: FROM ce_transaction_codes ctc,
906: ce_statement_lines_interface csli,
907: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
908: WHERE ctc.trx_code(+) = csli.trx_code
909: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
910: aba.bank_account_id

Line 918: INSERT INTO ce_statement_lines

914: AND ctc.reconciliation_sequence = CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id; -- Bug 8965556 Added condition
915: ELSIF (nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
916: --Bug 6710502: Added an nvl to subsisdiary flag to handle records upgraded from 11i to R12
917: IF ( nvl(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
918: INSERT INTO ce_statement_lines
919: (statement_line_id,
920: statement_header_id,
921: line_number,
922: trx_date,

Line 959: SELECT ce_statement_lines_s.nextval,

955: attribute12,
956: attribute13,
957: attribute14,
958: attribute15)
959: SELECT ce_statement_lines_s.nextval,
960: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
961: csli.line_number,
962: csli.trx_date,
963: (select distinct ctc.trx_type

Line 1016: ce_statement_lines_interface csli,

1012: csli.attribute14,
1013: csli.attribute15
1014: FROM --ce_transaction_codes ctc,
1015: gl_daily_conversion_types gdct,
1016: ce_statement_lines_interface csli,
1017: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1018: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type
1019: --AND ctc.trx_code(+) = csli.trx_code
1020: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =

Line 1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;

1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;

Line 1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;
1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;

Line 1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;

1831: aba_bank_account_name CE_BANK_ACCOUNTS.bank_account_name%TYPE;
1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;

Line 1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;

1832: aba_bank_check_digits CE_BANK_ACCOUNTS.check_digits%TYPE;
1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;

1833: csli_line_number CE_STATEMENT_LINES_INTERFACE.line_number%TYPE;
1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;

1834: csli_amount CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;

1835: csli_trx_code CE_STATEMENT_LINES_INTERFACE.trx_code%TYPE;
1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

Line 1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1836: csli_user_exchange_rate_type CE_STATEMENT_LINES_INTERFACE.user_exchange_rate_type%TYPE;
1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;

Line 1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1837: csli_currency_code CE_STATEMENT_LINES_INTERFACE.currency_code%TYPE;
1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;

Line 1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1838: csli_exchange_rate_date CE_STATEMENT_LINES_INTERFACE.exchange_rate_date%TYPE;
1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;

Line 1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;

1839: csli_trx_date CE_STATEMENT_LINES_INTERFACE.trx_date%TYPE;
1840: csli_dr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1841: csli_cr_sum CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1842: csli_dr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1843: csli_cr_count CE_STATEMENT_LINES_INTERFACE.amount%TYPE;
1844: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1845: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1846: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1847: r_currency_code FND_CURRENCIES.currency_code%TYPE;