APPS.IGR_I_STATUS_PKG SQL Statements

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

Line: 4

PROCEDURE update_row (
  X_S_ENQUIRY_STATUS in VARCHAR2,
  X_ENQUIRY_STATUS in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  x_ret_status OUT NOCOPY VARCHAR2,
  x_msg_data OUT NOCOPY VARCHAR2,
  x_msg_count OUT NOCOPY NUMBER
  ) AS

l_last_update_date                 DATE;

Line: 43

l_last_updated_by                  NUMBER(15);

Line: 44

l_last_update_login                NUMBER(15);

Line: 48

  SELECT last_update_date,
         enabled_flag,
         lead_flag,
         opp_flag,
         opp_open_status_flag ,
         opp_decision_date_flag,
         forecast_rollup_flag,
         win_loss_indicator,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15,
         meaning,
         description,
         status_rank
  FROM as_statuses_vl
  WHERE status_code = x_s_enquiry_status;

Line: 83

  SAVEPOINT update_row_status;

Line: 95

  INTO    l_last_update_date,
          l_enabled_flag,
          l_lead_flag,
          l_opp_flag,
          l_opp_open_status_flag ,
          l_opp_decision_date_flag,
          l_forecast_rollup_flag,
          l_win_loss_indicator,
          l_attribute_category,
          l_attribute1,
          l_attribute2,
          l_attribute3,
          l_attribute4,
          l_attribute5,
          l_attribute6,
          l_attribute7,
          l_attribute8,
          l_attribute9,
          l_attribute10,
          l_attribute11,
          l_attribute12,
          l_attribute13,
          l_attribute14,
          l_attribute15,
          l_meaning,
          l_description,
          l_status_rank;

Line: 181

  l_last_updated_by := fnd_global.user_id;

Line: 182

  l_last_update_login := fnd_global.login_id;

Line: 185

  AS_STATUSES_PKG.UPDATE_ROW(
              l_status_code,
              l_enabled_flag,
              l_lead_flag,
              l_opp_flag,
              l_opp_open_status_flag,
              l_opp_decision_date_flag,
              l_status_rank,
              l_forecast_rollup_flag,
              l_win_loss_indicator,
              NULL,
              l_attribute_category,
              l_attribute1,
              l_attribute2,
              l_attribute3,
              l_attribute4,
              l_attribute5,
              l_attribute6,
              l_attribute7,
              l_attribute8,
              l_attribute9,
              l_attribute10,
              l_attribute11,
              l_attribute12,
              l_attribute13,
              l_attribute14,
              l_attribute15,
              v_enquiry_status,
              v_description,
              l_last_update_date,
              l_last_updated_by,
              l_last_update_login);

Line: 221

    ROLLBACK TO update_row_status;

Line: 228

END update_row;