APPS.JTF_AM_SKILL_RULES_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_RULE_ID in NUMBER,
  X_DOCUMENT_TYPE in VARCHAR2,
  X_PRODUCT_ID_PASSED in NUMBER,
  X_CATEGORY_ID_PASSED in NUMBER,
  X_PROBLEM_CODE_PASSED in NUMBER,
  X_COMPONENT_ID_PASSED in NUMBER,
  X_ACTIVE_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER 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,
  X_SECURITY_GROUP_ID in NUMBER,
  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_RULES
    where RULE_ID = X_RULE_ID
    ;

Line: 40

  insert into JTF_AM_SKILL_RULES (
    RULE_ID,
    DOCUMENT_TYPE,
    PRODUCT_ID_PASSED,
    CATEGORY_ID_PASSED,
    PROBLEM_CODE_PASSED,
    COMPONENT_ID_PASSED,
    ACTIVE_FLAG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    SECURITY_GROUP_ID
  ) values(
    X_RULE_ID,
    X_DOCUMENT_TYPE,
    X_PRODUCT_ID_PASSED,
    X_CATEGORY_ID_PASSED,
    X_PROBLEM_CODE_PASSED,
    X_COMPONENT_ID_PASSED,
    X_ACTIVE_FLAG,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER,
    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,
    X_SECURITY_GROUP_ID
   );

Line: 112

end INSERT_ROW;

Line: 141

  cursor c1 is select
      DOCUMENT_TYPE,
      PRODUCT_ID_PASSED,
      CATEGORY_ID_PASSED,
      PROBLEM_CODE_PASSED,
      COMPONENT_ID_PASSED,
      ACTIVE_FLAG,
      OBJECT_VERSION_NUMBER,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      SECURITY_GROUP_ID,
      RULE_ID
    from JTF_AM_SKILL_RULES
    where RULE_ID = X_RULE_ID
    for update of RULE_ID nowait;

Line: 224

procedure UPDATE_ROW (
  X_RULE_ID in NUMBER,
  X_DOCUMENT_TYPE in VARCHAR2,
  X_PRODUCT_ID_PASSED in NUMBER,
  X_CATEGORY_ID_PASSED in NUMBER,
  X_PROBLEM_CODE_PASSED in NUMBER,
  X_COMPONENT_ID_PASSED in NUMBER,
  X_ACTIVE_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER 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,
  X_SECURITY_GROUP_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update JTF_AM_SKILL_RULES set
    DOCUMENT_TYPE = X_DOCUMENT_TYPE,
    PRODUCT_ID_PASSED = X_PRODUCT_ID_PASSED,
    CATEGORY_ID_PASSED = X_CATEGORY_ID_PASSED,
    PROBLEM_CODE_PASSED = X_PROBLEM_CODE_PASSED,
    COMPONENT_ID_PASSED = X_COMPONENT_ID_PASSED,
    ACTIVE_FLAG = X_ACTIVE_FLAG,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    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,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where RULE_ID = X_RULE_ID ;

Line: 288

end UPDATE_ROW;

Line: 290

procedure DELETE_ROW (
  X_RULE_ID in NUMBER
) is
begin
  delete from JTF_AM_SKILL_RULES
  where RULE_ID = X_RULE_ID;

Line: 301

end DELETE_ROW;

Line: 332

  l_last_updated_by number := -1;

Line: 336

  CURSOR c_last_updated IS
    SELECT last_updated_by,
           object_version_number
      from JTF_AM_SKILL_RULES
     WHERE rule_id = x_rule_id;

Line: 349

  OPEN c_last_updated;

Line: 350

  FETCH c_last_updated into l_last_updated_by, l_object_version_number ;

Line: 351

      IF c_last_updated%NOTFOUND THEN
         l_object_version_number := 1;

Line: 353

         jtf_am_skill_rules_pkg.insert_row(
                X_ROWID                 => l_row_id ,
                X_RULE_ID               => X_RULE_ID,
                X_DOCUMENT_TYPE         => X_DOCUMENT_TYPE,
                X_PRODUCT_ID_PASSED     => X_PRODUCT_ID_PASSED,
                X_CATEGORY_ID_PASSED    => X_CATEGORY_ID_PASSED,
                X_PROBLEM_CODE_PASSED   => X_PROBLEM_CODE_PASSED,
                X_COMPONENT_ID_PASSED   => X_COMPONENT_ID_PASSED,
                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: 385

      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: 388

            jtf_am_skill_rules_pkg.update_row(
                X_RULE_ID               => X_RULE_ID,
                X_DOCUMENT_TYPE         => X_DOCUMENT_TYPE,
                X_PRODUCT_ID_PASSED     => X_PRODUCT_ID_PASSED,
                X_CATEGORY_ID_PASSED    => X_CATEGORY_ID_PASSED,
                X_PROBLEM_CODE_PASSED   => X_PROBLEM_CODE_PASSED,
                X_COMPONENT_ID_PASSED   => X_COMPONENT_ID_PASSED,
                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: 419

  CLOSE c_last_updated;