APPS.CE_AUTO_BANK_IMPORT dependencies on CE_STATEMENT_HEADERS

Line 71: FROM ce_statement_headers rsh,

67: rsh.statement_number,
68: ba.bank_account_name,
69: ba.currency_code,
70: ba.check_digits
71: FROM ce_statement_headers rsh,
72: ce_statement_headers_int sh,
73: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
74: WHERE rsh.statement_number(+) = sh.statement_number
75: AND rsh.bank_account_id(+) = p_bank_account_id

Line 72: ce_statement_headers_int sh,

68: ba.bank_account_name,
69: ba.currency_code,
70: ba.check_digits
71: FROM ce_statement_headers rsh,
72: ce_statement_headers_int sh,
73: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
74: WHERE rsh.statement_number(+) = sh.statement_number
75: AND rsh.bank_account_id(+) = p_bank_account_id
76: AND NVL(sh.record_status_flag, 'I') <> 'T'

Line 406: DELETE FROM ce_statement_headers_int sh

402: BEGIN
403: IF l_DEBUG in ('Y', 'C') THEN
404: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');
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

Line 635: FROM ce_statement_headers_int

631: attribute15,
632: last_updated_by,
633: last_update_date
634: --org_id
635: FROM ce_statement_headers_int
636: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
637: IF l_DEBUG in ('Y', 'C') THEN
638: cep_standard.debug('< 639: END IF;

Line 720: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;

716: | CALLED BY |
717: | import_prcess |
718: --------------------------------------------------------------------- */
719: FUNCTION lock_statement RETURN BOOLEAN IS
720: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;
721: BEGIN
722: IF l_DEBUG in ('Y', 'C') THEN
723: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
724: END IF;

Line 727: FROM ce_statement_headers_int

723: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
724: END IF;
725: SELECT statement_number
726: INTO X_statement_number
727: FROM ce_statement_headers_int
728: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
729: FOR UPDATE OF statement_number NOWAIT;
730:
731: IF l_DEBUG in ('Y', 'C') THEN

Line 1034: | CE_STATEMENT_HEADERS for the given statement and bank account |

1030: | transfer_header |
1031: | |
1032: | DESCRIPTION |
1033: | Copy the header line in CE_STATEMENT_HEADER_INTERFACE into |
1034: | CE_STATEMENT_HEADERS for the given statement and bank account |
1035: | combination. Record the bank account id and not the bank |
1036: | account number. |
1037: | |
1038: | CALLED BY |

Line 1398: UPDATE ce_statement_headers_int

1394: BEGIN
1395: IF l_DEBUG in ('Y', 'C') THEN
1396: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1397: END IF;
1398: UPDATE ce_statement_headers_int
1399: SET record_status_flag = p_status
1400: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1401: IF l_DEBUG in ('Y', 'C') THEN
1402: cep_standard.debug('<

Line 1614: -- 3. Already existing in the CE_STATEMENT_HEADERS

1610: END IF;
1611: END IF;
1612: END IF;
1613: --
1614: -- 3. Already existing in the CE_STATEMENT_HEADERS
1615: --
1616: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1617: IF (r_statement_number IS NOT NULL) THEN
1618: duplicate_found := CE_AUTO_BANK_IMPORT.header_error('CE_PREV_IMPORT');

Line 1829: r_statement_number CE_STATEMENT_HEADERS.statement_number%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;
1833: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;