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 414: DELETE FROM ce_statement_headers_int sh

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

Line 643: FROM ce_statement_headers_int

639: attribute15,
640: last_updated_by,
641: last_update_date
642: --org_id
643: FROM ce_statement_headers_int
644: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
645: IF l_DEBUG in ('Y', 'C') THEN
646: cep_standard.debug('< 647: END IF;

Line 728: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;

724: | CALLED BY |
725: | import_prcess |
726: --------------------------------------------------------------------- */
727: FUNCTION lock_statement RETURN BOOLEAN IS
728: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;
729: BEGIN
730: IF l_DEBUG in ('Y', 'C') THEN
731: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
732: END IF;

Line 735: FROM ce_statement_headers_int

731: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
732: END IF;
733: SELECT statement_number
734: INTO X_statement_number
735: FROM ce_statement_headers_int
736: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
737: FOR UPDATE OF statement_number NOWAIT;
738:
739: IF l_DEBUG in ('Y', 'C') THEN

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

1041: | transfer_header |
1042: | |
1043: | DESCRIPTION |
1044: | Copy the header line in CE_STATEMENT_HEADER_INTERFACE into |
1045: | CE_STATEMENT_HEADERS for the given statement and bank account |
1046: | combination. Record the bank account id and not the bank |
1047: | account number. |
1048: | |
1049: | CALLED BY |

Line 1411: UPDATE ce_statement_headers_int

1407: BEGIN
1408: IF l_DEBUG in ('Y', 'C') THEN
1409: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1410: END IF;
1411: UPDATE ce_statement_headers_int
1412: SET record_status_flag = p_status
1413: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1414: IF l_DEBUG in ('Y', 'C') THEN
1415: cep_standard.debug('<

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

1623: END IF;
1624: END IF;
1625: END IF;
1626: --
1627: -- 3. Already existing in the CE_STATEMENT_HEADERS
1628: --
1629: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1630: IF (r_statement_number IS NOT NULL) THEN
1631: duplicate_found := CE_AUTO_BANK_IMPORT.header_error('CE_PREV_IMPORT');

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