DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT SQL Statements

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

Line: 223

              Update_Approval_Rules (
                p_api_version ,
                p_init_msg_list,
                p_commit,
                p_validation_level,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_x_Approval_Rules_Rec);
Line: 254

              Update_Approvers (
                p_api_version ,
                p_init_msg_list,
                p_commit,
                p_validation_level,
                l_x_Approvers_Tbl(i),
                x_return_status,
                x_msg_count,
                x_msg_data);
Line: 266

              Delete_Approvers (
                   p_api_version,
                   p_init_msg_list,
                   p_commit,
                   p_validation_level,
                   l_x_Approvers_Tbl(i).Approval_Approver_Id,
                   p_object_version,
                   x_return_status,
                   x_msg_count,
                   x_msg_data
                   );
Line: 471

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);
Line: 587

      SELECT Ahl_Approval_Rules_B_S.NEXTVAL
      FROM   dual;
Line: 591

      SELECT 1
      FROM   dual
      WHERE EXISTS (SELECT 1
                    FROM   Ahl_Approval_Rules_vl
                    WHERE  Approval_Rule_id = x_id);
Line: 597

      SELECT ORGANIZATION_ID
      FROM HR_OPERATING_UNITS
      WHERE NAME = l_Approval_Rules_rec.OPERATING_NAME;
Line: 604

      SELECT LOOKUP_CODE
      FROM FND_LOOKUPS
      WHERE MEANING = l_Approval_Rules_rec.APPLICATION_USG
      AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
Line: 727

       Ahl_Debug_Pub.debug( l_full_name ||':Insert');
Line: 733

   Ahl_Approval_Rules_Pkg.Insert_Row (
     X_ROWID                 => l_rowid,
     X_APPROVAL_RULE_ID      => l_Approval_Rules_rec.APPROVAL_RULE_ID,
     X_OBJECT_VERSION_NUMBER => 1,
     X_APPROVAL_OBJECT_CODE  => l_Approval_Rules_rec.APPROVAL_OBJECT_CODE,
     X_APPROVAL_PRIORITY_CODE=> l_Approval_Rules_rec.APPROVAL_PRIORITY_CODE,
     X_APPROVAL_TYPE_CODE    => l_Approval_Rules_rec.APPROVAL_TYPE_CODE,
     X_APPLICATION_USG_CODE  => l_Approval_Rules_rec.APPLICATION_USG_CODE,
     X_OPERATING_UNIT_ID     => l_Approval_Rules_rec.OPERATING_UNIT_ID,
     X_ACTIVE_START_DATE     => l_Approval_Rules_rec.ACTIVE_START_DATE,
     X_ACTIVE_END_DATE       => l_Approval_Rules_rec.ACTIVE_END_DATE,
     X_STATUS_CODE           => l_status,
     X_SEEDED_FLAG           => l_seed,
     X_ATTRIBUTE_CATEGORY    => l_Approval_Rules_rec.ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1            => l_Approval_Rules_rec.ATTRIBUTE1,
     X_ATTRIBUTE2            => l_Approval_Rules_rec.ATTRIBUTE2,
     X_ATTRIBUTE3            => l_Approval_Rules_rec.ATTRIBUTE3,
     X_ATTRIBUTE4            => l_Approval_Rules_rec.ATTRIBUTE4,
     X_ATTRIBUTE5            => l_Approval_Rules_rec.ATTRIBUTE5,
     X_ATTRIBUTE6            => l_Approval_Rules_rec.ATTRIBUTE6,
     X_ATTRIBUTE7            => l_Approval_Rules_rec.ATTRIBUTE7,
     X_ATTRIBUTE8            => l_Approval_Rules_rec.ATTRIBUTE8,
     X_ATTRIBUTE9            => l_Approval_Rules_rec.ATTRIBUTE9,
     X_ATTRIBUTE10           => l_Approval_Rules_rec.ATTRIBUTE10,
     X_ATTRIBUTE11           => l_Approval_Rules_rec.ATTRIBUTE11,
     X_ATTRIBUTE12           => l_Approval_Rules_rec.ATTRIBUTE12,
     X_ATTRIBUTE13           => l_Approval_Rules_rec.ATTRIBUTE13,
     X_ATTRIBUTE14           => l_Approval_Rules_rec.ATTRIBUTE14,
     X_ATTRIBUTE15           => l_Approval_Rules_rec.ATTRIBUTE15,
     X_APPROVAL_RULE_NAME    => l_Approval_Rules_rec.APPROVAL_RULE_NAME,
     X_DESCRIPTION           => l_Approval_Rules_rec.DESCRIPTION,
     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 );
Line: 830

PROCEDURE Update_Approval_Rules (
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := Fnd_Api.g_false,
   p_commit            IN  VARCHAR2,
   p_validation_level  IN  NUMBER    := Fnd_Api.g_valid_level_full,
   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,
   p_Approval_Rules_rec   IN  Approval_Rules_Rec_Type
)
IS
   L_API_VERSION          CONSTANT NUMBER := 1.0;
Line: 842

   L_API_NAME             CONSTANT VARCHAR2(30) := 'Update_Approval_Rules';
Line: 851

      SELECT ORGANIZATION_ID
      FROM HR_OPERATING_UNITS
      WHERE NAME = l_Approval_Rules_rec.OPERATING_NAME;
Line: 856

      SELECT Status_code
      FROM Ahl_approval_rules_b
      WHERE Approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 861

      SELECT Seeded_Flag
      FROM Ahl_approval_rules_b
      WHERE Approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 866

      SELECT LOOKUP_CODE
      FROM FND_LOOKUPS
      WHERE MEANING = l_Approval_Rules_rec.APPLICATION_USG
      AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
Line: 873

   SAVEPOINT Update_Approval_Rules;
Line: 960

         p_validation_mode    => Jtf_Plsql_Api.g_update,
         x_return_status      => l_return_status
      );
Line: 1018

       Ahl_Debug_Pub.debug( l_full_name ||':before status order Update');
Line: 1060

       Ahl_Debug_Pub.debug( l_full_name ||':Update');
Line: 1063

    Ahl_Approval_Rules_Pkg.UPDATE_ROW (
     X_APPROVAL_RULE_ID      => l_Approval_Rules_rec.APPROVAL_RULE_ID,
     X_OBJECT_VERSION_NUMBER => l_Approval_Rules_rec.OBJECT_VERSION_NUMBER + 1,
     X_APPROVAL_OBJECT_CODE  => l_Approval_Rules_rec.APPROVAL_OBJECT_CODE,
     X_APPROVAL_PRIORITY_CODE=> l_Approval_Rules_rec.APPROVAL_PRIORITY_CODE,
     X_APPROVAL_TYPE_CODE    => l_Approval_Rules_rec.APPROVAL_TYPE_CODE,
     X_APPLICATION_USG_CODE  => l_Approval_Rules_Rec.APPLICATION_USG_CODE,
     X_OPERATING_UNIT_ID     => l_operating_unit,
     X_ACTIVE_START_DATE     => l_Approval_Rules_rec.ACTIVE_START_DATE,
     X_ACTIVE_END_DATE       => l_Approval_Rules_rec.ACTIVE_END_DATE,
     X_STATUS_CODE           => l_Approval_Rules_rec.STATUS_CODE,
     X_SEEDED_FLAG           => l_seed,
     X_ATTRIBUTE_CATEGORY    => l_Approval_Rules_rec.ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1            => l_Approval_Rules_rec.ATTRIBUTE1,
     X_ATTRIBUTE2            => l_Approval_Rules_rec.ATTRIBUTE2,
     X_ATTRIBUTE3            => l_Approval_Rules_rec.ATTRIBUTE3,
     X_ATTRIBUTE4            => l_Approval_Rules_rec.ATTRIBUTE4,
     X_ATTRIBUTE5            => l_Approval_Rules_rec.ATTRIBUTE5,
     X_ATTRIBUTE6            => l_Approval_Rules_rec.ATTRIBUTE6,
     X_ATTRIBUTE7            => l_Approval_Rules_rec.ATTRIBUTE7,
     X_ATTRIBUTE8            => l_Approval_Rules_rec.ATTRIBUTE8,
     X_ATTRIBUTE9            => l_Approval_Rules_rec.ATTRIBUTE9,
     X_ATTRIBUTE10           => l_Approval_Rules_rec.ATTRIBUTE10,
     X_ATTRIBUTE11           => l_Approval_Rules_rec.ATTRIBUTE11,
     X_ATTRIBUTE12           => l_Approval_Rules_rec.ATTRIBUTE12,
     X_ATTRIBUTE13           => l_Approval_Rules_rec.ATTRIBUTE13,
     X_ATTRIBUTE14           => l_Approval_Rules_rec.ATTRIBUTE14,
     X_ATTRIBUTE15           => l_Approval_Rules_rec.ATTRIBUTE15,
     X_APPROVAL_RULE_NAME    => l_Approval_Rules_rec.APPROVAL_RULE_NAME,
     X_DESCRIPTION           => l_Approval_Rules_rec.DESCRIPTION,
     X_LAST_UPDATE_DATE      => SYSDATE,
     X_LAST_UPDATED_BY       => Fnd_Global.USER_ID,
     X_LAST_UPDATE_LOGIN     => Fnd_Global.LOGIN_ID );
Line: 1117

      ROLLBACK TO Update_Approval_Rules;
Line: 1125

      ROLLBACK TO Update_Approval_Rules;
Line: 1133

      ROLLBACK TO update_Approval_Rules;
Line: 1144

END Update_Approval_Rules;
Line: 1162

    SELECT 1 FROM ahl_approvers
    WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 1166

    SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 1258

    SELECT 1 FROM ahl_approval_rules_b
    WHERE UPPER(status_code) = 'ACTIVE'
    AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
    AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
    AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
Line: 1268

    SELECT 1 FROM ahl_approval_rules_b
    WHERE UPPER(status_code) = 'ACTIVE'
    AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
    AND approval_priority_code IS NULL
 AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_type_code IS NULL
    AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
Line: 1278

    SELECT 1 FROM ahl_approval_rules_b
    WHERE UPPER(status_code) = 'ACTIVE'
    AND operating_unit_id IS NULL
    AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
 AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
Line: 1288

    SELECT 1 FROM ahl_approval_rules_b
    WHERE UPPER(status_code) = 'ACTIVE'
    AND operating_unit_id IS NULL
    AND approval_priority_code IS NULL
 AND application_usg_code =(SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
Line: 1297

    SELECT 1 FROM ahl_approval_rules_b
    WHERE UPPER(status_code) = 'ACTIVE'
    AND operating_unit_id IS NULL
    AND application_usg_code =  (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
    AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
Line: 1396

    SELECT 1 FROM HR_OPERATING_UNITS
    WHERE name = p_Approval_Rules_rec.operating_name;
Line: 1429

    SELECT 1 FROM FND_LOOKUPS
    WHERE meaning = p_Approval_Rules_rec.Application_Usg
    AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';
Line: 1464

    SELECT 1 FROM ahl_approval_rules_b t1, ahl_status_order_rules t2
    WHERE t1.approval_rule_id = p_Approval_Rules_rec.approval_rule_id
    AND t2.next_status_code = p_Approval_Rules_rec.status_code
    AND t2.current_status_code = (SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id);
Line: 1470

    SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 1500

PROCEDURE Delete_Approval_Rules (
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := Fnd_Api.g_false,
   p_commit            IN  VARCHAR2,
   p_validation_level  IN  NUMBER    := Fnd_Api.g_valid_level_full,
   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,
   p_Approval_Rule_id  IN  NUMBER,
   p_object_version    IN  NUMBER
)


IS
   CURSOR c_Approval_Rules IS
      SELECT   *
      FROM     Ahl_Approval_Rules_VL
      WHERE    Approval_Rule_id = p_Approval_Rule_id;
Line: 1525

   l_api_name    CONSTANT VARCHAR2(30) := 'Delete_Approval_Rules';
Line: 1529

   SAVEPOINT Delete_Approval_Rules;
Line: 1553

       Ahl_Debug_Pub.debug( l_full_name ||':Delete');
Line: 1569

    /*DELETE FROM Ahl_Approval_Rules_tl
    WHERE  Approval_Rule_id = p_Approval_Rule_id;
Line: 1580

    DELETE FROM Ahl_Approval_Rules_b
    WHERE  Approval_Rule_id = p_Approval_Rule_id;*/
Line: 1583

    UPDATE Ahl_Approval_Rules_B
    SET Status_Code = 'OBSOLETE'
    WHERE  Approval_Rule_id = p_Approval_Rule_id;
Line: 1613

      ROLLBACK TO Delete_Approval_Rules;
Line: 1621

      ROLLBACK TO Delete_Approval_Rules;
Line: 1629

      ROLLBACK TO Delete_Approval_Rules;
Line: 1640

END Delete_Approval_Rules;
Line: 1880

   x_Approval_Rules_rec.last_update_date           := Fnd_Api.g_miss_date;
Line: 1881

   x_Approval_Rules_rec.last_updated_by            := Fnd_Api.g_miss_num;
Line: 1884

   x_Approval_Rules_rec.last_update_login          := Fnd_Api.g_miss_num;
Line: 1915

      SELECT   *
      FROM     Ahl_Approval_Rules_v
      WHERE    Approval_Rule_id = p_Approval_Rules_rec.Approval_Rule_id;
Line: 1994

                SELECT 1 INTO l_count
                FROM Ahl_Approval_Rules_vl
                WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
                AND   approval_rule_name = l_Approval_Rules_rec.approval_rule_name
                AND   active_start_date = l_Approval_Rules_rec.active_start_date
                AND   active_end_date = l_Approval_Rules_rec.active_end_Date
                AND   status_code = l_Approval_Rules_rec.status_code;
Line: 2007

                SELECT 1 INTO l_count
                FROM Ahl_Approval_Rules_vl
                WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
                AND   approval_rule_name = l_Approval_Rules_rec.approval_rule_name
                AND   active_start_date = l_Approval_Rules_rec.active_start_date
                AND   status_code = l_Approval_Rules_rec.status_code;
Line: 2020

                SELECT 1 INTO l_count
                FROM Ahl_Approval_Rules_vl
                WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
                AND   approval_rule_name = l_Approval_Rules_rec.approval_rule_name
                AND   status_code = l_Approval_Rules_rec.status_code;
Line: 2139

    SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
    WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME;
Line: 2143

    SELECT approval_object_code FROM ahl_approval_rules_b
    WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 2147

    SELECT approval_type_code FROM ahl_approval_rules_b
    WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 2151

    SELECT application_usg_code
    FROM ahl_approval_rules_b
    WHERE  approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
Line: 2364

      SELECT Ahl_Approvers_S.NEXTVAL
      FROM   dual;
Line: 2368

      SELECT 1
      FROM   dual
      WHERE EXISTS (SELECT 1
                    FROM   AHL_Approvers
                    WHERE  Approval_Approver_Id = x_id);
Line: 2483

       Ahl_Debug_Pub.debug( l_full_name ||':Insert');
Line: 2487

   Ahl_Approvers_Pkg.Insert_Row (
     X_ROWID                 => l_rowid,
     X_APPROVAL_APPROVER_ID  => l_Approvers_rec.APPROVAL_APPROVER_ID,
     X_OBJECT_VERSION_NUMBER => 1,
     X_APPROVAL_RULE_ID      => l_Approvers_rec.APPROVAL_RULE_ID,
     X_APPROVER_TYPE_CODE    => l_Approvers_rec.APPROVER_TYPE_CODE,
     X_APPROVER_SEQUENCE     => l_Approvers_rec.APPROVER_SEQUENCE,
     X_APPROVER_ID           => l_Approvers_rec.APPROVER_ID,
     X_LAST_UPDATE_DATE      => SYSDATE,
     X_LAST_UPDATED_BY       => Fnd_Global.USER_ID,
     X_CREATION_DATE         => SYSDATE,
     X_CREATED_BY            => Fnd_Global.USER_ID,
     X_LAST_UPDATE_LOGIN     => Fnd_Global.LOGIN_ID,
     X_ATTRIBUTE_CATEGORY    => l_Approvers_rec.ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1            => l_Approvers_rec.ATTRIBUTE1,
     X_ATTRIBUTE2            => l_Approvers_rec.ATTRIBUTE2,
     X_ATTRIBUTE3            => l_Approvers_rec.ATTRIBUTE3,
     X_ATTRIBUTE4            => l_Approvers_rec.ATTRIBUTE4,
     X_ATTRIBUTE5            => l_Approvers_rec.ATTRIBUTE5,
     X_ATTRIBUTE6            => l_Approvers_rec.ATTRIBUTE6,
     X_ATTRIBUTE7            => l_Approvers_rec.ATTRIBUTE7,
     X_ATTRIBUTE8            => l_Approvers_rec.ATTRIBUTE8,
     X_ATTRIBUTE9            => l_Approvers_rec.ATTRIBUTE9,
     X_ATTRIBUTE10           => l_Approvers_rec.ATTRIBUTE10,
     X_ATTRIBUTE11           => l_Approvers_rec.ATTRIBUTE11,
     X_ATTRIBUTE12           => l_Approvers_rec.ATTRIBUTE12,
     X_ATTRIBUTE13           => l_Approvers_rec.ATTRIBUTE13,
     X_ATTRIBUTE14           => l_Approvers_rec.ATTRIBUTE14,
     X_ATTRIBUTE15           => l_Approvers_rec.ATTRIBUTE15 );
Line: 2576

PROCEDURE Update_Approvers (
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := Fnd_Api.g_false,
   p_commit            IN  VARCHAR2,
   p_validation_level  IN  NUMBER    := Fnd_Api.g_valid_level_full,
   p_Approvers_rec     IN  Approvers_Rec_Type,

   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2

)
IS
   L_API_VERSION        CONSTANT NUMBER := 1.0;
Line: 2590

   L_API_NAME           CONSTANT VARCHAR2(30) := 'Update_Approvers';
Line: 2598

   SAVEPOINT Update_Approvers;
Line: 2628

         p_validation_mode    => Jtf_Plsql_Api.g_update,
         p_Approvers_rec      => p_Approvers_rec,
         x_return_status      => l_return_status
      );
Line: 2666

       Ahl_Debug_Pub.debug( l_full_name ||':Update');
Line: 2669

 Ahl_Approvers_Pkg. UPDATE_ROW (
     X_APPROVAL_APPROVER_ID  => l_Approvers_rec.APPROVAL_APPROVER_ID,
     X_OBJECT_VERSION_NUMBER => l_Approvers_rec.OBJECT_VERSION_NUMBER + 1,
     X_APPROVAL_RULE_ID      => l_Approvers_rec.APPROVAL_RULE_ID,
     X_APPROVER_TYPE_CODE    => l_Approvers_rec.APPROVER_TYPE_CODE,
     X_APPROVER_SEQUENCE     => l_Approvers_rec.APPROVER_SEQUENCE,
     X_APPROVER_ID           => l_Approvers_rec.APPROVER_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    => l_Approvers_rec.ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1            => l_Approvers_rec.ATTRIBUTE1,
     X_ATTRIBUTE2            => l_Approvers_rec.ATTRIBUTE2,
     X_ATTRIBUTE3            => l_Approvers_rec.ATTRIBUTE3,
     X_ATTRIBUTE4            => l_Approvers_rec.ATTRIBUTE4,
     X_ATTRIBUTE5            => l_Approvers_rec.ATTRIBUTE5,
     X_ATTRIBUTE6            => l_Approvers_rec.ATTRIBUTE6,
     X_ATTRIBUTE7            => l_Approvers_rec.ATTRIBUTE7,
     X_ATTRIBUTE8            => l_Approvers_rec.ATTRIBUTE8,
     X_ATTRIBUTE9            => l_Approvers_rec.ATTRIBUTE9,
     X_ATTRIBUTE10           => l_Approvers_rec.ATTRIBUTE10,
     X_ATTRIBUTE11           => l_Approvers_rec.ATTRIBUTE11,
     X_ATTRIBUTE12           => l_Approvers_rec.ATTRIBUTE12,
     X_ATTRIBUTE13           => l_Approvers_rec.ATTRIBUTE13,
     X_ATTRIBUTE14           => l_Approvers_rec.ATTRIBUTE14,
     X_ATTRIBUTE15           => l_Approvers_rec.ATTRIBUTE15 );
Line: 2715

      ROLLBACK TO Update_Approvers;
Line: 2723

      ROLLBACK TO Update_Approvers;
Line: 2731

      ROLLBACK TO Update_Approvers;
Line: 2742

END Update_Approvers;
Line: 2802

PROCEDURE Delete_Approvers (
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := Fnd_Api.g_false,
   p_commit            IN  VARCHAR2,
   p_validation_level  IN  NUMBER    := Fnd_Api.g_valid_level_full,
   p_Approval_Approver_Id   IN  NUMBER,
   p_object_version    IN  NUMBER,
   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2
)
IS
   CURSOR c_Approvers IS
      SELECT   *
      FROM     AHL_Approvers
      WHERE    APPROVAL_APPROVER_ID = p_Approval_Approver_Id;
Line: 2821

    SELECT COUNT(*) FROM Ahl_Approvers
    WHERE Approval_Rule_Id IN
    (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
Line: 2826

    SELECT status_code FROM Ahl_Approval_rules_b
    WHERE Approval_Rule_Id IN
    (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
Line: 2839

   l_api_name    CONSTANT VARCHAR2(30) := 'Delete_Approvers';
Line: 2845

   SAVEPOINT Delete_Approvers;
Line: 2893

              Fnd_Message.set_name('AHL', 'AHL_APPR_NOT_DELETE');
Line: 2907

       Ahl_Debug_Pub.debug( l_full_name ||':Delete');
Line: 2911

  DELETE FROM Ahl_Approvers
    WHERE  APPROVAL_APPROVER_ID = p_Approval_Approver_Id;
Line: 2940

      ROLLBACK TO Delete_Approvers;
Line: 2948

      ROLLBACK TO Delete_Approvers;
Line: 2956

      ROLLBACK TO Delete_Approvers;
Line: 2968

END Delete_Approvers;
Line: 3138

      SELECT   *
      FROM     AHL_Approvers
      WHERE    APPROVAL_APPROVER_ID = p_Approvers_rec.Approval_Approver_Id;
Line: 3231

        SELECT ROLE_ID
          FROM AHL_APPROVERS_TYPE_V
         WHERE UPPER(ROLE_NAME) LIKE UPPER(approver_name)
           AND UPPER(LOOKUP_CODE) LIKE UPPER(p_approvers_rec.approver_type_code);
Line: 3239

        SELECT AJREV.RESOURCE_ID
          FROM  JTF_RS_RESOURCE_EXTNS AJREV,
                FND_USER USR
         WHERE  AJREV.CATEGORY IN ('EMPLOYEE','PARTNER', 'PARTY')
           AND  AJREV.RESOURCE_ID > 0
           AND  USR.USER_NAME LIKE UPPER(approver_name)
           AND  AJREV.USER_ID = USR.USER_ID;
Line: 3250

        SELECT DISTINCT JRRV.role_id
          FROM jtf_rs_role_relations_vl JRRV
         WHERE JRRV.role_type_code in ('AHLAPPR', 'AHLGAPPR')
           AND UPPER(JRRV.role_name) LIKE UPPER(approver_name);
Line: 3262

        SELECT ROLE_ID
          FROM AHL_APPROVERS_TYPE_V
         WHERE UPPER(ROLE_NAME) LIKE UPPER(approver_name)
           AND ROLE_ID = approver_id
           AND UPPER(LOOKUP_CODE) LIKE UPPER(p_approvers_rec.approver_type_code);
Line: 3272

        SELECT AJREV.RESOURCE_ID
         FROM  JTF_RS_RESOURCE_EXTNS AJREV
        WHERE  AJREV.CATEGORY IN ('EMPLOYEE','PARTNER', 'PARTY')
          AND  AJREV.RESOURCE_ID > 0
          AND  UPPER(AJREV.USER_NAME) LIKE UPPER(approver_name)
          AND  AJREV.RESOURCE_ID = approver_id;
Line: 3282

        SELECT DISTINCT JRRV.role_id
          FROM jtf_rs_role_relations_vl JRRV
         WHERE JRRV.role_type_code in ('AHLAPPR', 'AHLGAPPR')
           AND UPPER(JRRV.role_name) LIKE UPPER(approver_name)
           AND JRRV.role_id = approver_id;