DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_CLEAR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

  CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;
Line: 54

|	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');
Line: 67

      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');
Line: 79

      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');
Line: 96

    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;
Line: 102

  cep_standard.debug('<
Line: 105

    cep_standard.debug('EXCEPTION:  CE_AUTO_BANK_CLEAR.update_line_status');
Line: 107

END update_line_status;
Line: 527

          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');
Line: 615

          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');
Line: 772

  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 || ')';
Line: 1114

      	   CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
		'RECONCILED');
Line: 1117

      	   CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
		'RECONCILED');
Line: 1121

        CE_AUTO_BANK_CLEAR.update_line_status(
	   CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
Line: 1157

      CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
Line: 1182

      CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
Line: 1210

        CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
Line: 1239

        CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
Line: 1281

      CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
Line: 1295

    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);
Line: 1304

    DELETE FROM ce_statement_reconcils_all
    WHERE statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id;