The following lines contain the word 'select', 'insert', 'update' or 'delete':
CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;
| update_line_status |
| |
| DESCRIPTION |
| Update the record status to indicate its current state. |
--------------------------------------------------------------------- */
PROCEDURE update_line_status (
X_statement_line_id NUMBER,
X_status VARCHAR2) IS
BEGIN
cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');
UPDATE ce_statement_lines l
SET status = X_status,
reconcile_to_statement_flag =
CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
WHERE statement_line_id = X_statement_line_id
AND EXISTS
(select NULL
from ce_statement_recon_gt_v --ce_statement_reconciliations
where statement_line_id = l.statement_line_id
and current_record_flag = 'Y'
and status_flag = 'M');
UPDATE ce_statement_lines l
SET status = X_status,
exchange_rate_type = CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
exchange_rate_date = CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
exchange_rate = CE_AUTO_BANK_MATCH.csl_exchange_rate,
currency_code = CE_AUTO_BANK_MATCH.csl_currency_code,
reconcile_to_statement_flag =
CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
WHERE statement_line_id = X_statement_line_id
AND EXISTS
(select NULL
from ce_statement_recon_gt_v --ce_statement_reconciliations
where statement_line_id = l.statement_line_id
and current_record_flag = 'Y'
and status_flag = 'M');
UPDATE ce_statement_lines
SET status = X_status,
reconcile_to_statement_flag =
CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
WHERE statement_line_id = X_statement_line_id;
cep_standard.debug('<
cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');
END update_line_status;
CE_RECONCILIATION_ERRORS_PKG.insert_row(
CE_AUTO_BANK_MATCH.csh_statement_header_id,
CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
CE_RECONCILIATION_ERRORS_PKG.insert_row(
CE_AUTO_BANK_MATCH.csh_statement_header_id,
CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_FOREIGN_DIFFERENCE');
tmp_query := 'select count(*)
from ce_801_eft_reconciled_v
where clearing_trx_type = ''PAY_EFT''
and to_char(statement_line_id) in (' || stmt_ln_list ||')
and to_char(trx_id) not in (' || trx_id_list || ')';
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(
CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
CE_RECONCILIATION_ERRORS_PKG.insert_row(
CE_AUTO_BANK_MATCH.csh_statement_header_id,
CE_AUTO_BANK_MATCH.csl_statement_line_id, message_name, app_short_name);
DELETE FROM ce_statement_reconcils_all
WHERE statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id;