DBA Data[Home] [Help]

APPS.JTF_AM_SKILL_RULE_DTLS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_DETAIL_ID in NUMBER,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_RULE_ID in NUMBER,
  X_RANK in NUMBER,
  X_CHECK_PRODUCT_ID in NUMBER,
  X_CHECK_CATEGORY_ID in NUMBER,
  X_CHECK_PROBLEM_CODE in NUMBER,
  X_CHECK_COMPONENT_ID in NUMBER,
  X_ACTIVE_FLAG in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE14 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
) is
  cursor C is select ROWID from JTF_AM_SKILL_RULE_DTLS
    where DETAIL_ID = X_DETAIL_ID
    ;
Line: 41

  insert into JTF_AM_SKILL_RULE_DTLS (
    ATTRIBUTE6,
    ATTRIBUTE12,
    DETAIL_ID,
    RULE_ID,
    RANK,
    CHECK_PRODUCT_ID,
    CHECK_CATEGORY_ID,
    CHECK_PROBLEM_CODE,
    CHECK_COMPONENT_ID,
    ACTIVE_FLAG,
    CREATED_BY,
    CREATION_DATE,
    ATTRIBUTE15,
    SECURITY_GROUP_ID,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    OBJECT_VERSION_NUMBER,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE13,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    LAST_UPDATE_LOGIN,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    ATTRIBUTE14
  ) values (
    X_ATTRIBUTE6,
    X_ATTRIBUTE12,
    X_DETAIL_ID,
    X_RULE_ID,
    X_RANK,
    X_CHECK_PRODUCT_ID,
    X_CHECK_CATEGORY_ID,
    X_CHECK_PROBLEM_CODE,
    X_CHECK_COMPONENT_ID,
    X_ACTIVE_FLAG,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_ATTRIBUTE15,
    X_SECURITY_GROUP_ID,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_OBJECT_VERSION_NUMBER,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE13,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_ATTRIBUTE14
    );
Line: 115

end INSERT_ROW;
Line: 145

  cursor c1 is select
      ATTRIBUTE6,
      ATTRIBUTE12,
      RULE_ID,
      RANK,
      CHECK_PRODUCT_ID,
      CHECK_CATEGORY_ID,
      CHECK_PROBLEM_CODE,
      CHECK_COMPONENT_ID,
      ACTIVE_FLAG,
      ATTRIBUTE15,
      SECURITY_GROUP_ID,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      OBJECT_VERSION_NUMBER,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE13,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE14,
      DETAIL_ID
    from JTF_AM_SKILL_RULE_DTLS
    where DETAIL_ID = X_DETAIL_ID
    for update of DETAIL_ID nowait;
Line: 230

procedure UPDATE_ROW (
  X_DETAIL_ID in NUMBER,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_RULE_ID in NUMBER,
  X_RANK in NUMBER,
  X_CHECK_PRODUCT_ID in NUMBER,
  X_CHECK_CATEGORY_ID in NUMBER,
  X_CHECK_PROBLEM_CODE in NUMBER,
  X_CHECK_COMPONENT_ID in NUMBER,
  X_ACTIVE_FLAG in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SECURITY_GROUP_ID in NUMBER,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update JTF_AM_SKILL_RULE_DTLS set
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    RULE_ID = X_RULE_ID,
    RANK = X_RANK,
    CHECK_PRODUCT_ID = X_CHECK_PRODUCT_ID,
    CHECK_CATEGORY_ID = X_CHECK_CATEGORY_ID,
    CHECK_PROBLEM_CODE = X_CHECK_PROBLEM_CODE,
    CHECK_COMPONENT_ID = X_CHECK_COMPONENT_ID,
    ACTIVE_FLAG = X_ACTIVE_FLAG,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where DETAIL_ID = X_DETAIL_ID
  ;
Line: 297

end UPDATE_ROW;
Line: 299

procedure DELETE_ROW (
  X_DETAIL_ID in NUMBER
) is
begin
  delete from JTF_AM_SKILL_RULE_DTLS
  where DETAIL_ID = X_DETAIL_ID;
Line: 310

end DELETE_ROW;
Line: 342

  l_last_updated_by number := -1;
Line: 346

  CURSOR c_last_updated IS
    SELECT last_updated_by,
           object_version_number
      from JTF_AM_SKILL_RULE_DTLS
     WHERE detail_id = x_detail_id;
Line: 359

  OPEN c_last_updated;
Line: 360

  FETCH c_last_updated into l_last_updated_by, l_object_version_number ;
Line: 361

      IF c_last_updated%NOTFOUND THEN
         l_object_version_number := 1;
Line: 363

         jtf_am_skill_rule_dtls_pkg.insert_row(
                X_ROWID                 => l_row_id ,
                X_DETAIL_ID             => X_DETAIL_ID,
                X_RULE_ID               => X_RULE_ID,
                X_RANK                  => X_RANK,
                X_CHECK_PRODUCT_ID      => X_CHECK_PRODUCT_ID,
                X_CHECK_CATEGORY_ID     => X_CHECK_CATEGORY_ID,
                X_CHECK_PROBLEM_CODE    => X_CHECK_PROBLEM_CODE,
                X_CHECK_COMPONENT_ID    => X_CHECK_COMPONENT_ID,
                X_ACTIVE_FLAG           => X_ACTIVE_FLAG,
                X_ATTRIBUTE1            => X_ATTRIBUTE1 ,
                X_ATTRIBUTE2            => X_ATTRIBUTE2 ,
                X_ATTRIBUTE3            => X_ATTRIBUTE3 ,
                X_ATTRIBUTE4            => X_ATTRIBUTE4 ,
                X_ATTRIBUTE5            => X_ATTRIBUTE5 ,
                X_ATTRIBUTE6            => X_ATTRIBUTE6 ,
                X_ATTRIBUTE7            => X_ATTRIBUTE7 ,
                X_ATTRIBUTE8            => X_ATTRIBUTE8 ,
                X_ATTRIBUTE9            => X_ATTRIBUTE9 ,
                X_ATTRIBUTE10           => X_ATTRIBUTE10 ,
                X_ATTRIBUTE11           => X_ATTRIBUTE11 ,
                X_ATTRIBUTE12           => X_ATTRIBUTE12 ,
                X_ATTRIBUTE13           => X_ATTRIBUTE13 ,
                X_ATTRIBUTE14           => X_ATTRIBUTE14 ,
                X_ATTRIBUTE15           => X_ATTRIBUTE15 ,
                X_ATTRIBUTE_CATEGORY    => X_ATTRIBUTE_CATEGORY ,
                X_SECURITY_GROUP_ID     => X_SECURITY_GROUP_ID,
                X_OBJECT_VERSION_NUMBER => l_object_version_number ,
                X_CREATION_DATE         => sysdate      ,
                X_CREATED_BY            => l_user_id ,
                X_LAST_UPDATE_DATE      => sysdate      ,
                X_LAST_UPDATED_BY       => l_user_id ,
                X_LAST_UPDATE_LOGIN     => 0 );
Line: 396

      ELSIF c_last_updated%FOUND THEN
         IF l_last_updated_by IN (1,0) THEN
            l_object_version_number :=   l_object_version_number + 1;
Line: 399

            jtf_am_skill_rule_dtls_pkg.update_row(
                X_DETAIL_ID             => X_DETAIL_ID,
                X_RULE_ID               => X_RULE_ID,
                X_RANK                  => X_RANK,
                X_CHECK_PRODUCT_ID      => X_CHECK_PRODUCT_ID,
                X_CHECK_CATEGORY_ID     => X_CHECK_CATEGORY_ID,
                X_CHECK_PROBLEM_CODE    => X_CHECK_PROBLEM_CODE,
                X_CHECK_COMPONENT_ID    => X_CHECK_COMPONENT_ID,
                X_ACTIVE_FLAG           => X_ACTIVE_FLAG,
                X_ATTRIBUTE1            => X_ATTRIBUTE1 ,
                X_ATTRIBUTE2            => X_ATTRIBUTE2 ,
                X_ATTRIBUTE3            => X_ATTRIBUTE3 ,
                X_ATTRIBUTE4            => X_ATTRIBUTE4 ,
                X_ATTRIBUTE5            => X_ATTRIBUTE5 ,
                X_ATTRIBUTE6            => X_ATTRIBUTE6 ,
                X_ATTRIBUTE7            => X_ATTRIBUTE7 ,
                X_ATTRIBUTE8            => X_ATTRIBUTE8 ,
                X_ATTRIBUTE9            => X_ATTRIBUTE9 ,
                X_ATTRIBUTE10           => X_ATTRIBUTE10 ,
                X_ATTRIBUTE11           => X_ATTRIBUTE11 ,
                X_ATTRIBUTE12           => X_ATTRIBUTE12 ,
                X_ATTRIBUTE13           => X_ATTRIBUTE13 ,
                X_ATTRIBUTE14           => X_ATTRIBUTE14 ,
                X_ATTRIBUTE15           => X_ATTRIBUTE15 ,
                X_ATTRIBUTE_CATEGORY    => X_ATTRIBUTE_CATEGORY ,
                X_SECURITY_GROUP_ID     => X_SECURITY_GROUP_ID,
                X_OBJECT_VERSION_NUMBER => l_object_version_number,
                X_LAST_UPDATE_DATE      => sysdate      ,
                X_LAST_UPDATED_BY       => l_user_id ,
                X_LAST_UPDATE_LOGIN     => 0 );
Line: 431

  CLOSE c_last_updated;