APPS.CS_KB_SET_LINKS_PKG SQL Statements

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

Line: 17

    select * from cs_kb_set_links
    where set_id = p_set_source_id;

Line: 21

  select count(*) into l_count
    from cs_kb_sets_b
    where set_id = p_set_source_id;

Line: 33

    select cs_kb_set_links_s.nextval into l_id from dual;

Line: 35

    CS_KB_SET_LINKS_PKG.Insert_Row(
      X_Rowid => l_rowid,
      X_Link_Id => l_id,
      X_Link_type => REC_LINK.LINK_TYPE,
      X_Object_Code => REC_LINK.OBJECT_CODE,
      X_Set_Id => P_SET_TARGET_ID,
      X_Other_Id => REC_LINK.OTHER_ID,
      X_Creation_Date => sysdate,
      X_Created_By => fnd_global.user_id,
      X_Last_Update_Date => sysdate,
      X_Last_Updated_By => fnd_global.user_id,
      X_Last_Update_Login => fnd_global.login_id,
      X_ATTRIBUTE_CATEGORY => REC_LINK.ATTRIBUTE_CATEGORY,
      X_ATTRIBUTE1 => REC_LINK.ATTRIBUTE1,
      X_ATTRIBUTE2 => REC_LINK.ATTRIBUTE2,
      X_ATTRIBUTE3 => REC_LINK.ATTRIBUTE3,
      X_ATTRIBUTE4 => REC_LINK.ATTRIBUTE4,
      X_ATTRIBUTE5 => REC_LINK.ATTRIBUTE5,
      X_ATTRIBUTE6 => REC_LINK.ATTRIBUTE6,
      X_ATTRIBUTE7 => REC_LINK.ATTRIBUTE7,
      X_ATTRIBUTE8 => REC_LINK.ATTRIBUTE8,
      X_ATTRIBUTE9 => REC_LINK.ATTRIBUTE9,
      X_ATTRIBUTE10 => REC_LINK.ATTRIBUTE10,
      X_ATTRIBUTE11 => REC_LINK.ATTRIBUTE11,
      X_ATTRIBUTE12 => REC_LINK.ATTRIBUTE12,
      X_ATTRIBUTE13 => REC_LINK.ATTRIBUTE13,
      X_ATTRIBUTE14 => REC_LINK.ATTRIBUTE14,
      X_ATTRIBUTE15 => REC_LINK.ATTRIBUTE15
      );

Line: 97

  P_UPDATE_EXTRA_VERSION in VARCHAR2,
  x_link_id     in OUT NOCOPY           NUMBER,
  x_return_status  OUT NOCOPY           VARCHAR2,
  x_msg_data       OUT NOCOPY           VARCHAR2,
  x_msg_count      OUT NOCOPY           NUMBER
  ) IS
  l_date  date;

Line: 112

   SELECT set_number, status
   FROM CS_KB_SETS_B
   WHERE set_id = P_SET_ID
     AND ( status = 'PUB' or latest_version_flag = 'Y' );

Line: 121

   SELECT 'SELECT count(*) FROM '||
           v.From_Table||
           ' WHERE '||v.select_id||' = :1 '||
           decode( v.where_clause, null, ' ', ' AND ' || v.where_clause )
   FROM jtf_objects_vl v, jtf_object_usages u
   WHERE v.object_code = P_OBJECT_CODE
   AND v.object_code = u.object_code
   AND u.object_user_code='CS_KB_SET'
   and ( v.end_date_active is NULL or v.end_date_active > sysdate );

Line: 137

   SELECT count(*)
   FROM CS_KB_SET_LINKS
   WHERE set_id      = P_SET_ID
   AND   other_id    = P_OTHER_ID
   AND   object_code = P_OBJECT_CODE;

Line: 147

   SELECT sb.set_id
   FROM CS_KB_SETS_B sb
   WHERE sb.set_number = c_soln_number
     AND sb.latest_version_flag = 'Y';

Line: 156

   SELECT sb.set_id
   FROM CS_KB_SETS_B sb
   WHERE sb.set_number = c_soln_number
     AND sb.status = 'PUB';

Line: 169

    SELECT count(*)
    FROM CS_KB_SET_LINKS
    WHERE set_id = c_soln_id
      AND object_code = c_object_code
      AND other_id = c_other_id;

Line: 274

    select cs_kb_set_links_s.nextval into l_id from dual;

Line: 283

  CS_KB_SET_LINKS_PKG.Insert_Row(
    X_Rowid => l_rowid,
    X_Link_Id => l_id,
    X_Link_type => p_link_type,
    X_Object_Code => p_object_code,
    X_Set_Id => p_set_id,
    X_Other_Id => p_other_id,
    X_Creation_Date => l_date,
    X_Created_By => l_created_by,
    X_Last_Update_Date => l_date,
    X_Last_Updated_By => l_created_by,
    X_Last_Update_Login => l_login,
    X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => P_ATTRIBUTE1,
    X_ATTRIBUTE2 => P_ATTRIBUTE2,
    X_ATTRIBUTE3 => P_ATTRIBUTE3,
    X_ATTRIBUTE4 => P_ATTRIBUTE4,
    X_ATTRIBUTE5 => P_ATTRIBUTE5,
    X_ATTRIBUTE6 => P_ATTRIBUTE6,
    X_ATTRIBUTE7 => P_ATTRIBUTE7,
    X_ATTRIBUTE8 => P_ATTRIBUTE8,
    X_ATTRIBUTE9 => P_ATTRIBUTE9,
    X_ATTRIBUTE10 => P_ATTRIBUTE10,
    X_ATTRIBUTE11 => P_ATTRIBUTE11,
    X_ATTRIBUTE12 => P_ATTRIBUTE12,
    X_ATTRIBUTE13 => P_ATTRIBUTE13,
    X_ATTRIBUTE14 => P_ATTRIBUTE14,
    X_ATTRIBUTE15 => P_ATTRIBUTE15
  );

Line: 322

  IF (P_UPDATE_EXTRA_VERSION = 'Y') THEN
      -- If the link being created is to a published solution version, see if
      -- there is also an in-progress version of the same solution. If there is,
      -- we need to also create a link between the object and the latest
      -- in-progess solution version.
      -- Due to 3407999, if the link being created is to an in progress version,
      -- see if there is also an published version of the same solution. If
      -- there is, we need to also create a link between the object and the
      -- published one.
      l_found_other_version := 'N';

Line: 359

            select cs_kb_set_links_s.nextval into l_other_link_id from dual;

Line: 360

            CS_KB_SET_LINKS_PKG.Insert_Row(
              X_Rowid => l_other_rowid,
              X_Link_Id => l_other_link_id,
              X_Link_type => p_link_type,
              X_Object_Code => p_object_code,
              X_Set_Id => l_other_soln_ver_id,
              X_Other_Id => p_other_id,
              X_Creation_Date => l_date,
              X_Created_By => l_created_by,
              X_Last_Update_Date => l_date,
              X_Last_Updated_By => l_created_by,
              X_Last_Update_Login => l_login,
              X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
              X_ATTRIBUTE1 => P_ATTRIBUTE1,
              X_ATTRIBUTE2 => P_ATTRIBUTE2,
              X_ATTRIBUTE3 => P_ATTRIBUTE3,
              X_ATTRIBUTE4 => P_ATTRIBUTE4,
              X_ATTRIBUTE5 => P_ATTRIBUTE5,
              X_ATTRIBUTE6 => P_ATTRIBUTE6,
              X_ATTRIBUTE7 => P_ATTRIBUTE7,
              X_ATTRIBUTE8 => P_ATTRIBUTE8,
              X_ATTRIBUTE9 => P_ATTRIBUTE9,
              X_ATTRIBUTE10 => P_ATTRIBUTE10,
              X_ATTRIBUTE11 => P_ATTRIBUTE11,
              X_ATTRIBUTE12 => P_ATTRIBUTE12,
              X_ATTRIBUTE13 => P_ATTRIBUTE13,
              X_ATTRIBUTE14 => P_ATTRIBUTE14,
              X_ATTRIBUTE15 => P_ATTRIBUTE15
            );

Line: 468

     P_UPDATE_EXTRA_VERSION  => 'Y'                 ,
     x_link_id            => x_link_id           ,
     x_return_status      => x_return_status     ,
     x_msg_data           => x_msg_data          ,
     x_msg_count          => x_msg_count);

Line: 526

     P_UPDATE_EXTRA_VERSION  => 'Y'                 ,
     x_link_id            => l_link_id           ,
     x_return_status      => l_return_status     ,
     x_msg_data           => l_msg_data          ,
     x_msg_count          => l_msg_count);

Line: 587

     P_UPDATE_EXTRA_VERSION  => 'Y'                 ,
     x_link_id            => l_link_id           ,
     x_return_status      => l_return_status     ,
     x_msg_data           => l_msg_data          ,
     x_msg_count          => l_msg_count);

Line: 647

     P_UPDATE_EXTRA_VERSION  => 'N'                 ,
     x_link_id            => x_link_id           ,
     x_return_status      => x_return_status     ,
     x_msg_data           => x_msg_data          ,
     x_msg_count          => x_msg_count);

Line: 657

procedure Update_Set_Link(
  P_LINK_ID in NUMBER,
  P_LINK_TYPE in VARCHAR,
  P_OBJECT_CODE in VARCHAR,
  P_SET_ID in NUMBER,
  P_OTHER_ID 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_return_status  OUT NOCOPY VARCHAR2,
  x_msg_data       OUT NOCOPY VARCHAR2,
  x_msg_count      OUT NOCOPY NUMBER
  ) IS

  -- Validation Cursors
  CURSOR Validate_Link IS
   SELECT sl.set_id, sl.object_code, sl.other_id, sb.set_number, sb.status
   FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
   WHERE sl.link_id = P_LINK_ID
     AND sl.set_id = sb.set_id
     AND ( sb.status = 'PUB' OR sb.latest_version_flag = 'Y' );

Line: 695

   SELECT sl.link_id, sl.set_id
   FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
   WHERE sb.set_number = c_soln_number
     AND sb.latest_version_flag = 'Y'
     AND sb.set_id = sl.set_id
     AND sl.object_code = c_object_code
     AND sl.other_id = c_other_id;

Line: 706

   SELECT sl.link_id, sl.set_id
   FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
   WHERE sb.set_number = c_soln_number
     AND sb.status = 'PUB'
     AND sb.set_id = sl.set_id
     AND sl.object_code = c_object_code
     AND sl.other_id = c_other_id;

Line: 723

  l_updated_by number;

Line: 726

 SAVEPOINT Update_Link_SP;

Line: 780

   FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');

Line: 792

  l_updated_by := fnd_global.user_id;

Line: 795

  CS_KB_SET_LINKS_PKG.Update_Row(
    X_Link_Id => p_link_id,
    X_Link_type => p_link_type,
    X_Object_Code => p_object_code,
    X_Set_Id => p_set_id,
    X_Other_Id => p_other_id,
    X_Last_Update_Date => l_date,
    X_Last_Updated_By => l_updated_by,
    X_Last_Update_Login => l_login,
    X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1 => P_ATTRIBUTE1,
    X_ATTRIBUTE2 => P_ATTRIBUTE2,
    X_ATTRIBUTE3 => P_ATTRIBUTE3,
    X_ATTRIBUTE4 => P_ATTRIBUTE4,
    X_ATTRIBUTE5 => P_ATTRIBUTE5,
    X_ATTRIBUTE6 => P_ATTRIBUTE6,
    X_ATTRIBUTE7 => P_ATTRIBUTE7,
    X_ATTRIBUTE8 => P_ATTRIBUTE8,
    X_ATTRIBUTE9 => P_ATTRIBUTE9,
    X_ATTRIBUTE10 => P_ATTRIBUTE10,
    X_ATTRIBUTE11 => P_ATTRIBUTE11,
    X_ATTRIBUTE12 => P_ATTRIBUTE12,
    X_ATTRIBUTE13 => P_ATTRIBUTE13,
    X_ATTRIBUTE14 => P_ATTRIBUTE14,
    X_ATTRIBUTE15 => P_ATTRIBUTE15);

Line: 822

   CS_KB_SET_LINKS_PKG.Raise_Soln_Link_Updated_Event(
     p_set_id      => p_set_id,
     p_object_code => p_object_code,
     p_object_id   => p_other_id,
     p_link_id     => p_link_id,
     p_link_type   => p_link_type,
     p_event_date  => l_date );

Line: 854

      CS_KB_SET_LINKS_PKG.Update_Row(
        X_Link_Id => l_other_link_id,
        X_Link_type => p_link_type,
        X_Object_Code => p_object_code,
        X_Set_Id => l_other_soln_id,
        X_Other_Id => p_other_id,
        X_Last_Update_Date => l_date,
        X_Last_Updated_By => l_updated_by,
        X_Last_Update_Login => l_login,
        X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
        X_ATTRIBUTE1 => P_ATTRIBUTE1,
        X_ATTRIBUTE2 => P_ATTRIBUTE2,
        X_ATTRIBUTE3 => P_ATTRIBUTE3,
        X_ATTRIBUTE4 => P_ATTRIBUTE4,
        X_ATTRIBUTE5 => P_ATTRIBUTE5,
        X_ATTRIBUTE6 => P_ATTRIBUTE6,
        X_ATTRIBUTE7 => P_ATTRIBUTE7,
        X_ATTRIBUTE8 => P_ATTRIBUTE8,
        X_ATTRIBUTE9 => P_ATTRIBUTE9,
        X_ATTRIBUTE10 => P_ATTRIBUTE10,
        X_ATTRIBUTE11 => P_ATTRIBUTE11,
        X_ATTRIBUTE12 => P_ATTRIBUTE12,
        X_ATTRIBUTE13 => P_ATTRIBUTE13,
        X_ATTRIBUTE14 => P_ATTRIBUTE14,
        X_ATTRIBUTE15 => P_ATTRIBUTE15);

Line: 884

    ROLLBACK TO Update_Link_SP;

Line: 886

      fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );

Line: 895

END Update_Set_Link;

Line: 898

function Update_Set_Link(
  P_LINK_ID in NUMBER,
  P_LINK_TYPE in VARCHAR,
  P_OBJECT_CODE in VARCHAR,
  P_SET_ID in NUMBER,
  P_OTHER_ID in NUMBER,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2
) return number is
  l_return_status VARCHAR2(1);

Line: 925

   Update_Set_Link(
     P_LINK_ID            => P_LINK_ID           ,
     P_LINK_TYPE          => P_LINK_TYPE         ,
     P_OBJECT_CODE        => P_OBJECT_CODE       ,
     P_SET_ID             => P_SET_ID            ,
     P_OTHER_ID           => P_OTHER_ID          ,
     P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
     P_ATTRIBUTE1         => P_ATTRIBUTE1        ,
     P_ATTRIBUTE2         => P_ATTRIBUTE2        ,
     P_ATTRIBUTE3         => P_ATTRIBUTE3        ,
     P_ATTRIBUTE4         => P_ATTRIBUTE4        ,
     P_ATTRIBUTE5         => P_ATTRIBUTE5        ,
     P_ATTRIBUTE6         => P_ATTRIBUTE6        ,
     P_ATTRIBUTE7         => P_ATTRIBUTE7        ,
     P_ATTRIBUTE8         => P_ATTRIBUTE8        ,
     P_ATTRIBUTE9         => P_ATTRIBUTE9        ,
     P_ATTRIBUTE10        => P_ATTRIBUTE10       ,
     P_ATTRIBUTE11        => P_ATTRIBUTE11       ,
     P_ATTRIBUTE12        => P_ATTRIBUTE12       ,
     P_ATTRIBUTE13        => P_ATTRIBUTE13       ,
     P_ATTRIBUTE14        => P_ATTRIBUTE14       ,
     P_ATTRIBUTE15        => P_ATTRIBUTE15       ,
     x_return_status      => l_return_status     ,
     x_msg_data           => l_msg_data          ,
     x_msg_count          => l_msg_count);

Line: 954

end Update_Set_Link;

Line: 956

function Delete_Set_Link_W_Obj_Code(
  p_set_id        in Number,
  p_object_code   in Varchar2,
  p_other_id      in Number
) return number is
  cursor get_link_id( c_set_id NUMBER, c_object_code VARCHAR2,
                      c_other_id NUMBER )IS
    select link_id
    from cs_kb_set_links
    where set_id = c_set_id
      and object_code = c_object_code
      and other_id = c_other_id;

Line: 988

    l_ret_val := Delete_Set_Link( l_link_id );

Line: 995

end Delete_Set_Link_W_Obj_Code;

Line: 998

function Delete_Set_Link(
  P_LINK_ID in NUMBER
) return number is
  -- Cursor to validate link exists and is to either a published solution
  -- version or an in-progress version.
  cursor Valid_Link IS
    select sb.set_number, sb.status, sl.object_code, sl.other_id
    from cs_kb_set_links sl, cs_kb_sets_b sb
    where sl.link_id = P_LINK_ID
      and sl.set_id = sb.set_id
      and ( sb.status = 'PUB' or sb.latest_version_flag = 'Y' );

Line: 1013

   SELECT sl.link_id
   FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
   WHERE sb.set_number = c_soln_number
     AND (sb.latest_version_flag = 'Y' or sb.status = 'PUB')
     AND sb.set_id = sl.set_id
     AND sl.object_code = c_object_code
     AND sl.other_id = c_other_id;

Line: 1027

  SAVEPOINT Delete_Link_SP;

Line: 1057

  delete from CS_KB_SET_LINKS
  where LINK_ID = P_LINK_ID;

Line: 1076

    delete from CS_KB_SET_LINKS
    where LINK_ID = l_other_link_id;

Line: 1083

    ROLLBACK TO Delete_Link_SP;

Line: 1085

      fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );

Line: 1092

end Delete_Set_Link;

Line: 1094

procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_LINK_ID in NUMBER,
  X_LINK_TYPE in VARCHAR2,
  X_OBJECT_CODE in VARCHAR2,
  X_SET_ID in NUMBER,
  X_OTHER_ID in NUMBER,
  --X_OTHER_CODE in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2) IS

  cursor C is select ROWID from CS_KB_SET_LINKS where LINK_ID = X_LINK_ID;

Line: 1130

  insert into CS_KB_SET_LINKS (
    LINK_ID,
    LINK_TYPE,
    OBJECT_CODE,
    SET_ID,
    OTHER_ID,
    --OTHER_CODE,
    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 (
    X_LINK_ID,
    X_LINK_TYPE,
    X_OBJECT_CODE,
    X_SET_ID,
    X_OTHER_ID,
    --X_OTHER_CODE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15
    );

Line: 1198

END INSERT_ROW;

Line: 1200

procedure UPDATE_ROW (
  X_LINK_ID in NUMBER,
  X_LINK_TYPE in VARCHAR2,
  X_OBJECT_CODE in VARCHAR2,
  X_SET_ID in NUMBER,
  X_OTHER_ID in NUMBER,
  --X_OTHER_CODE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2
) IS

BEGIN

  update CS_KB_SET_LINKS set

    LINK_TYPE = X_LINK_TYPE,
    OBJECT_CODE = X_OBJECT_CODE,
    SET_ID = X_SET_ID,
    OTHER_ID  = X_OTHER_ID,
    --OTHER_CODE = X_OTHER_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY =  X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15
  where LINK_ID = X_LINK_ID;

Line: 1262

END UPDATE_ROW;

Line: 1278

    select set_number, access_level, status
    into l_set_number, l_access_level, l_status
    from CS_KB_SETS_B
    where set_id  = p_set_id;

Line: 1357

   l_param_list.DELETE;

Line: 1361

procedure Raise_Soln_Link_Updated_Event(
   p_set_id            NUMBER,
   p_object_code       VARCHAR2,
   p_object_id         VARCHAR2,
   p_link_id           NUMBER,
   p_link_type         VARCHAR2,
   p_event_date        DATE
) is
   l_param_list   wf_parameter_list_t;

Line: 1373

    select set_number, status
    into l_set_number, l_status
    from CS_KB_SETS_B
    where set_id  = p_set_id;

Line: 1439

   /*** Raise SolutionLinkUpdated event ***/
   wf_event.raise(
      p_event_name => 'oracle.apps.cs.knowledge.SolutionLink.Updated',
      p_event_key => to_char( sysdate, 'YYYYMMDD HH24MISS') ,
      p_parameters => l_param_list
   );

Line: 1446

   l_param_list.DELETE;

Line: 1448

end Raise_Soln_Link_Updated_Event;