APPS.IGF_SL_EDIT SQL Statements

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

Line: 4

PROCEDURE insert_edit(p_loan_number   igf_sl_edit_report.loan_number%TYPE,
                      p_orig_chg_code igf_sl_edit_report.orig_chg_code%TYPE,
                      p_err_type      igf_sl_edit_report.sl_error_type%TYPE,
                      p_err_code      igf_sl_edit_report.sl_error_code%TYPE,
                      p_field_name    igf_sl_edit_report.field_name%TYPE,
                      p_field_value   igf_sl_edit_report.field_value%TYPE)
IS
  /*************************************************************
  Created By : venagara
  Date Created On : 2000/11/07
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

  lv_rowid     VARCHAR2(25);

Line: 27

    igf_sl_edit_report_pkg.insert_row (
      x_mode                              => 'R',
      x_rowid                             => lv_rowid,
      x_edtr_id                           => lv_edtr_id,
      x_loan_number                       => p_loan_number,
      x_orig_chg_code                     => p_orig_chg_code,
      x_sl_error_type                     => p_err_type,
      x_sl_error_code                     => p_err_code,
      x_field_name                        => p_field_name,
      x_field_value                       => p_field_value
    );

Line: 42

   fnd_message.set_token('NAME','igf_sl_edit.insert_edit');

Line: 45

END insert_edit;

Line: 48

PROCEDURE delete_edit(p_loan_number   igf_sl_edit_report.loan_number%TYPE,
                      p_orig_chg_code igf_sl_edit_report.orig_chg_code%TYPE)
IS
  /*************************************************************
  Created By : venagara
  Date Created On : 2000/11/07
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

   lv_row_id  VARCHAR2(25);

Line: 64

   SELECT rowid row_id FROM igf_sl_edit_report
   WHERE loan_number   = p_loan_number
   AND   orig_chg_code = p_orig_chg_code;

Line: 70

       igf_sl_edit_report_pkg.delete_row (tbh_rec.row_id);

Line: 73

END delete_edit;