APPS.CS_KB_SET_RECS_PKG SQL Statements

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

Line: 43

      select set_order into l_order from cs_kb_set_recs
      where set_rec_id = p_set_rec_id;

Line: 61

    select sr1.set_rec_id, sr1.set_order into l_set_rec_id_prev, l_prev_order
    from cs_kb_set_recs sr1 where sr1.set_order =
     (select max(sr.set_order)
      from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
      where sr.set_number = sv.set_number
        and sv.viewable_version_flag = 'Y'
        and sv.status = 'PUB'
        and sr.set_order < l_order );

Line: 115

      select set_order into l_order from cs_kb_set_recs
      where set_rec_id = p_set_rec_id;

Line: 133

    select sr1.set_rec_id, sr1.set_order into l_set_rec_id_next, l_next_order
    from cs_kb_set_recs sr1 where sr1.set_order =
     (select min(sr.set_order)
      from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
      where sr.set_number = sv.set_number
        and sv.viewable_version_flag = 'Y'
        and sv.status = 'PUB'
        and sr.set_order > l_order );

Line: 204

      select count(*) into l_count
        from cs_kb_set_recs
        where set_rec_id = p_set_rec_id;

Line: 219

      select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;

Line: 221

        select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;

Line: 226

      select cs_kb_set_recs_s.nextval into l_set_rec_id from dual;

Line: 241

      select distinct set_id into l_set_id
      from cs_kb_secure_solutions_view
      where set_number = p_set_number
        and viewable_version_flag = 'Y'
        and status = 'PUB';

Line: 258

    select count(*) into l_count
      from cs_kb_set_recs
      where set_number = p_set_number;

Line: 275

      select cs_kb_set_rec_order_s.nextval into l_set_order from dual;

Line: 278

      select count(*) into l_count from cs_kb_set_recs
      where set_order = l_set_order;

Line: 292

      select cs_kb_set_rec_order_s.currval into l_order_seq_val from dual;

Line: 294

        select cs_kb_set_rec_order_s.nextval into l_order_seq_val from dual;

Line: 303

    insert into CS_KB_SET_RECS
    ( SET_REC_ID,
      SET_ID,
      SET_ORDER,
      SET_NUMBER,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
      ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10,
      ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 )
    values
    ( l_set_rec_id,
      l_set_id,
      l_set_order,
      P_SET_NUMBER,
      l_date,
      l_created_by,
      l_date,
      l_created_by,
      l_login,
      P_ATTRIBUTE_CATEGORY,
      P_ATTRIBUTE1, P_ATTRIBUTE2, P_ATTRIBUTE3, P_ATTRIBUTE4, P_ATTRIBUTE5,
      P_ATTRIBUTE6, P_ATTRIBUTE7, P_ATTRIBUTE8, P_ATTRIBUTE9, P_ATTRIBUTE10,
      P_ATTRIBUTE11, P_ATTRIBUTE12, P_ATTRIBUTE13, P_ATTRIBUTE14, P_ATTRIBUTE15);

Line: 351

   * Update_Set_Rec
   *  This procedure updates a solution recommendation record.
   *  NOTE: !! Currently this procedure is not being used. !!
   *   !! Needs additial review and some cleanup. !!
   */
  procedure Update_Set_Rec
  ( P_SET_REC_ID         in NUMBER,
    P_SET_NUMBER         in VARCHAR2,
    P_SET_ORDER          in NUMBER,
    P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE1         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE2         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE3         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE4         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE5         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE6         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE7         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE8         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE9         in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE10        in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE11        in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE12        in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE13        in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE14        in VARCHAR2 DEFAULT NULL,
    P_ATTRIBUTE15        in VARCHAR2 DEFAULT NULL,
    X_RET_STATUS         out nocopy VARCHAR2,
    X_MSG_COUNT          out nocopy NUMBER,
    X_MSG_DATA           out nocopy VARCHAR2 )
  is
  l_date  date;

Line: 381

  l_updated_by number;

Line: 404

  l_updated_by := fnd_global.user_id;

Line: 407

  update CS_KB_SET_RECS set
    SET_ORDER = P_SET_ORDER,
    LAST_UPDATE_DATE = l_date,
    LAST_UPDATED_BY = l_updated_by,
    LAST_UPDATE_LOGIN = l_login,
    ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = P_ATTRIBUTE1,
    ATTRIBUTE2 = P_ATTRIBUTE2,
    ATTRIBUTE3 = P_ATTRIBUTE3,
    ATTRIBUTE4 = P_ATTRIBUTE4,
    ATTRIBUTE5 = P_ATTRIBUTE5,
    ATTRIBUTE6 = P_ATTRIBUTE6,
    ATTRIBUTE7 = P_ATTRIBUTE7,
    ATTRIBUTE8 = P_ATTRIBUTE8,
    ATTRIBUTE9 = P_ATTRIBUTE9,
    ATTRIBUTE10 = P_ATTRIBUTE10,
    ATTRIBUTE11 = P_ATTRIBUTE11,
    ATTRIBUTE12 = P_ATTRIBUTE12,
    ATTRIBUTE13 = P_ATTRIBUTE13,
    ATTRIBUTE14 = P_ATTRIBUTE14,
    ATTRIBUTE15 = P_ATTRIBUTE15
  WHERE SET_REC_ID = P_SET_REC_ID;

Line: 444

end Update_Set_Rec;

Line: 447

   * Delete_Set_Rec
   *  Delete a solution recommendation record.
   */
  PROCEDURE Delete_Set_Rec
  ( p_set_rec_id in  number,
    x_ret_status out nocopy varchar2,
    x_msg_count  out nocopy number,
    x_msg_data   out nocopy varchar2 )
  is
    l_count number;

Line: 472

    select count(*) into l_count from cs_kb_set_recs
    where set_rec_id = p_set_rec_id;

Line: 484

    delete from CS_KB_SET_RECS
    where SET_REC_ID = p_set_rec_id;

Line: 493

  end Delete_Set_Rec;

Line: 514

    select set_order into l_order_1
    from cs_kb_set_recs
    where set_rec_id = p_set_rec_id_1;

Line: 518

    select set_order into l_order_2
    from cs_kb_set_recs
    where set_rec_id = p_set_rec_id_2;

Line: 528

    update cs_kb_set_recs
    set set_order = -100,
        last_update_date = l_date,
        last_updated_by = l_user,
        last_update_login = l_login
    where set_rec_id = p_set_rec_id_2;

Line: 535

    update cs_kb_set_recs
    set set_order = l_order_2,
        last_update_date = l_date,
        last_updated_by = l_user,
        last_update_login = l_login
    where set_rec_id = p_set_rec_id_1;

Line: 542

    update cs_kb_set_recs
    set set_order = l_order_1,
        last_update_date = l_date,
        last_updated_by = l_user,
        last_update_login = l_login
    where set_rec_id = p_set_rec_id_2;