[Home] [Help]
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'
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
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('<
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;
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
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('<