DBA Data[Home] [Help]

APPS.JTF_TERR_CNR_GROUPS_PVT SQL Statements

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

Line: 68

      l_DML_Operation              CONSTANT VARCHAR2(30) := 'INSERT';
Line: 138

          JTF_TERR_CNR_GROUPS_PKG.Insert_Row(
                               x_rowid                  => l_rowid,
                               x_CNR_GROUP_ID           => l_terr_cnr_group_Id,
                               x_LAST_UPDATED_BY        => p_Terr_cnr_group_rec.LAST_UPDATED_BY,
                               x_LAST_UPDATE_DATE       => p_Terr_cnr_group_rec.LAST_UPDATE_DATE,
                               x_CREATED_BY             => p_Terr_cnr_group_rec.CREATED_BY,
                               x_CREATION_DATE          => p_Terr_cnr_group_rec.CREATION_DATE,
                               x_LAST_UPDATE_LOGIN      => p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN,
                               x_NAME                   => p_Terr_cnr_group_rec.NAME,
                               x_DESCRIPTION            => p_Terr_cnr_group_rec.DESCRIPTION,
                               x_ATTRIBUTE_CATEGORY     => p_Terr_cnr_group_rec.ATTRIBUTE_CATEGORY,
                               x_ATTRIBUTE1             => p_Terr_cnr_group_rec.ATTRIBUTE1,
                               x_ATTRIBUTE2             => p_Terr_cnr_group_rec.ATTRIBUTE2,
                               x_ATTRIBUTE3             => p_Terr_cnr_group_rec.ATTRIBUTE3,
                               x_ATTRIBUTE4             => p_Terr_cnr_group_rec.ATTRIBUTE4,
                               x_ATTRIBUTE5             => p_Terr_cnr_group_rec.ATTRIBUTE5,
                               x_ATTRIBUTE6             => p_Terr_cnr_group_rec.ATTRIBUTE6,
                               x_ATTRIBUTE7             => p_Terr_cnr_group_rec.ATTRIBUTE7,
                               x_ATTRIBUTE8             => p_Terr_cnr_group_rec.ATTRIBUTE8,
                               x_ATTRIBUTE9             => p_Terr_cnr_group_rec.ATTRIBUTE9,
                               x_ATTRIBUTE10            => p_Terr_cnr_group_rec.ATTRIBUTE10,
                               x_ATTRIBUTE11            => p_Terr_cnr_group_rec.ATTRIBUTE11,
                               x_ATTRIBUTE12            => p_Terr_cnr_group_rec.ATTRIBUTE12,
                               x_ATTRIBUTE13            => p_Terr_cnr_group_rec.ATTRIBUTE13,
                               x_ATTRIBUTE14            => p_Terr_cnr_group_rec.ATTRIBUTE14,
                               x_ATTRIBUTE15            => p_Terr_cnr_group_rec.ATTRIBUTE15);
Line: 244

  PROCEDURE Delete_Terr_Cnr_Group
    (
      p_Api_Version_Number      IN  NUMBER,
      p_Init_Msg_List           IN  VARCHAR2 := FND_API.G_FALSE,
      p_Commit                  IN  VARCHAR2 := FND_API.G_FALSE,
      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_Terr_cnr_group_rec      IN  Terr_cnr_group_rec_type     := G_MISS_TERR_CNR_GROUP_REC
    )
  AS

  l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Terr_Cnr_Group';
Line: 259

  l_DML_Operation             CONSTANT VARCHAR2(30) := 'DELETE';
Line: 265

      SAVEPOINT DELETE_CNR_GROUP_PVT;
Line: 321

      JTF_TERR_CNR_GROUPS_PKG.Delete_Row(
                  x_CNR_GROUP_ID => p_Terr_cnr_group_rec.cnr_group_id
      );
Line: 325

      delete
      from JTF_TERR_CNR_GROUP_VALUES jt
      where jt.cnr_group_id = p_Terr_cnr_group_rec.cnr_group_id;
Line: 352

         ROLLBACK TO DELETE_CNR_GROUP_PVT;
Line: 360

         ROLLBACK TO DELETE_CNR_GROUP_PVT;
Line: 368

         ROLLBACK TO DELETE_CNR_GROUP_PVT;
Line: 375

  END Delete_Terr_Cnr_Group;
Line: 394

  PROCEDURE Update_Terr_Cnr_Group
    (
      p_Api_Version_Number          IN  NUMBER,
      p_Init_Msg_List               IN  VARCHAR2                    := FND_API.G_FALSE,
      p_Commit                      IN  VARCHAR2                    := FND_API.G_FALSE,
      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_Terr_cnr_group_rec          IN  Terr_cnr_group_rec_type     := G_MISS_TERR_CNR_GROUP_REC,
      x_Terr_cnr_group_out_rec      OUT NOCOPY Terr_cnr_group_out_rec_type
    )
  AS
      l_api_name                  CONSTANT VARCHAR2(30) := 'Update_Terr_Cnr_Group';
Line: 409

      l_DML_Operation             CONSTANT VARCHAR2(30) := 'UPDATE';
Line: 416

      SAVEPOINT UPDATE_CNR_GROUP_PVT;
Line: 474

         JTF_TERR_CNR_GROUPS_PKG.Update_Row(
                  x_Rowid               => l_rowid,
                  x_CNR_GROUP_ID        => l_terr_cnr_group_Id,
                  x_LAST_UPDATED_BY     => p_Terr_cnr_group_rec.LAST_UPDATED_BY,
                  x_LAST_UPDATE_DATE    => p_Terr_cnr_group_rec.LAST_UPDATE_DATE,
                  x_CREATED_BY          => p_Terr_cnr_group_rec.CREATED_BY,
                  x_CREATION_DATE       => p_Terr_cnr_group_rec.CREATION_DATE,
                  x_LAST_UPDATE_LOGIN   => p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN,
                  x_NAME                => p_Terr_cnr_group_rec.NAME,
                  x_DESCRIPTION         => p_Terr_cnr_group_rec.DESCRIPTION,
                  x_ATTRIBUTE_CATEGORY  => p_Terr_cnr_group_rec.ATTRIBUTE_CATEGORY,
                  x_ATTRIBUTE1          => p_Terr_cnr_group_rec.ATTRIBUTE1,
                  x_ATTRIBUTE2          => p_Terr_cnr_group_rec.ATTRIBUTE2,
                  x_ATTRIBUTE3          => p_Terr_cnr_group_rec.ATTRIBUTE3,
                  x_ATTRIBUTE4          => p_Terr_cnr_group_rec.ATTRIBUTE4,
                  x_ATTRIBUTE5          => p_Terr_cnr_group_rec.ATTRIBUTE5,
                  x_ATTRIBUTE6          => p_Terr_cnr_group_rec.ATTRIBUTE6,
                  x_ATTRIBUTE7          => p_Terr_cnr_group_rec.ATTRIBUTE7,
                  x_ATTRIBUTE8          => p_Terr_cnr_group_rec.ATTRIBUTE8,
                  x_ATTRIBUTE9          => p_Terr_cnr_group_rec.ATTRIBUTE9,
                  x_ATTRIBUTE10         => p_Terr_cnr_group_rec.ATTRIBUTE10,
                  x_ATTRIBUTE11         => p_Terr_cnr_group_rec.ATTRIBUTE11,
                  x_ATTRIBUTE12         => p_Terr_cnr_group_rec.ATTRIBUTE12,
                  x_ATTRIBUTE13         => p_Terr_cnr_group_rec.ATTRIBUTE13,
                  x_ATTRIBUTE14         => p_Terr_cnr_group_rec.ATTRIBUTE14,
                  x_ATTRIBUTE15         => p_Terr_cnr_group_rec.ATTRIBUTE15
        );
Line: 529

         ROLLBACK TO UPDATE_CNR_GROUP_PVT;
Line: 537

         ROLLBACK TO UPDATE_CNR_GROUP_PVT;
Line: 545

         ROLLBACK TO UPDATE_CNR_GROUP_PVT;
Line: 552

  END Update_Terr_Cnr_Group;
Line: 583

           select 1
            from JTF_TERR_CNR_GROUPS jtcg
            where jtcg.NAME = p_Terr_cnr_group_rec.NAME
              and rownum < 2;
Line: 589

           select 1
            from JTF_TERR_VALUES_ALL jtva
            where jtva.CNR_GROUP_ID = p_Terr_cnr_group_rec.CNR_GROUP_ID
              and rownum < 2;
Line: 594

   CURSOR c_cnrgroupname_update IS
           select 1
            from JTF_TERR_CNR_GROUPS jtcg
            where jtcg.NAME = p_Terr_cnr_group_rec.NAME
              and jtcg.CNR_GROUP_ID <> p_Terr_cnr_group_rec.CNR_GROUP_ID
              and rownum < 2;
Line: 602

           select 1
            from jtf_terr_values_all jtv, jtf_terr_qual_all jtq
            where jtq.qual_usg_id = -1102
              and jtv.terr_qual_id = jtq.terr_qual_id
              and jtv.low_value_char_id = p_Terr_cnr_group_rec.CNR_GROUP_ID
              and rownum < 2;
Line: 614

  IF ( p_DML_Operation = 'DELETE' ) THEN
            --dbms_output.put_line('DELETE');
Line: 634

  ELSIF (p_DML_Operation IN ('INSERT','UPDATE')) THEN
            --dbms_output.put_line('INSERT,UPDATE');
Line: 659

    IF  ( p_Terr_cnr_group_rec.LAST_UPDATED_BY is NULL OR
          p_Terr_cnr_group_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) THEN
        IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
          FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
Line: 663

          FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
Line: 670

    If ( p_Terr_cnr_group_rec.LAST_UPDATE_DATE IS NULL OR
         p_Terr_cnr_group_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
       IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
          FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
Line: 674

          FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
Line: 681

    If ( p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN  is NULL OR
         p_Terr_cnr_group_rec.LAST_UPDATE_LOGIN  = FND_API.G_MISS_NUM )  THEN
       IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
          FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
Line: 685

          FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
Line: 702

    IF ( p_DML_Operation = 'INSERT' ) THEN
            --dbms_output.put_line('INSERT CHECK AT END');
Line: 722

    ELSIF ( p_DML_Operation = 'UPDATE' ) THEN
            --dbms_output.put_line('first update check');
Line: 736

            OPEN c_cnrgroupname_update;
Line: 737

                FETCH c_cnrgroupname_update INTO l_cnr_group_num;
Line: 739

                IF c_cnrgroupname_update%FOUND THEN
                  --dbms_output.put_line('c_cnrgroupname_update%FOUND');
Line: 748

            CLOSE c_cnrgroupname_update;
Line: 807

      l_DML_Operation              CONSTANT VARCHAR2(30) := 'INSERT';
Line: 856

          JTF_TERR_CNR_GROUP_VALUES_PKG.Insert_Row(
                               x_rowid                  => l_rowid,
                               x_CNR_GROUP_VALUE_ID     => l_terr_cnr_group_value_Id,
                               x_LAST_UPDATED_BY        => p_Terr_cnr_values_rec.LAST_UPDATED_BY,
                               x_LAST_UPDATE_DATE       => p_Terr_cnr_values_rec.LAST_UPDATE_DATE,
                               x_CREATED_BY             => p_Terr_cnr_values_rec.CREATED_BY,
                               x_CREATION_DATE          => p_Terr_cnr_values_rec.CREATION_DATE,
                               x_LAST_UPDATE_LOGIN      => p_Terr_cnr_values_rec.LAST_UPDATE_LOGIN,
                               x_CNR_GROUP_ID           => p_Terr_cnr_values_rec.CNR_GROUP_ID,
                               x_COMPARISON_OPERATOR    => p_Terr_cnr_values_rec.COMPARISON_OPERATOR,
                               x_LOW_VALUE_CHAR         => p_Terr_cnr_values_rec.LOW_VALUE_CHAR,
                               x_HIGH_VALUE_CHAR        => p_Terr_cnr_values_rec.HIGH_VALUE_CHAR,
                               x_START_DATE_ACTIVE      => p_Terr_cnr_values_rec.START_DATE_ACTIVE,
                               x_END_DATE_ACTIVE        => p_Terr_cnr_values_rec.END_DATE_ACTIVE,
                               x_ORG_ID                 => p_Terr_cnr_values_rec.ORG_ID
                               );
Line: 932

  PROCEDURE Delete_Terr_Cnr_Value
    (
      p_Api_Version_Number      IN  NUMBER,
      p_Init_Msg_List           IN  VARCHAR2                    := FND_API.G_FALSE,
      p_Commit                  IN  VARCHAR2                    := FND_API.G_FALSE,
      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_Terr_cnr_values_rec     IN  Terr_cnr_values_rec_type    := G_MISS_TERR_CNR_VALUES_REC
    ) AS

  l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Terr_Cnr_Value';
Line: 946

  l_DML_Operation             CONSTANT VARCHAR2(30) := 'DELETE';
Line: 952

      SAVEPOINT DELETE_CNR_VALUE_PVT;
Line: 981

            JTF_TERR_CNR_GROUP_VALUES_PKG.Delete_Row(
                  x_CNR_GROUP_VALUE_ID => p_Terr_cnr_values_rec.cnr_group_value_id
      );
Line: 1008

         ROLLBACK TO DELETE_CNR_VALUE_PVT;
Line: 1016

         ROLLBACK TO DELETE_CNR_VALUE_PVT;
Line: 1024

         ROLLBACK TO DELETE_CNR_VALUE_PVT;
Line: 1032

  End Delete_Terr_Cnr_Value;
Line: 1034

  PROCEDURE Update_Terr_Cnr_Value
    (
      p_Api_Version_Number          IN  NUMBER,
      p_Init_Msg_List               IN  VARCHAR2                    := FND_API.G_FALSE,
      p_Commit                      IN  VARCHAR2                    := FND_API.G_FALSE,
      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_Terr_cnr_values_rec         IN  Terr_cnr_values_rec_type    := G_MISS_TERR_CNR_VALUES_REC,
      x_Terr_cnr_values_out_rec     OUT NOCOPY Terr_cnr_values_out_rec_type
    ) AS
      l_api_name                   CONSTANT VARCHAR2(30) := 'Update_Terr_Cnr_Values';
Line: 1048

      l_DML_Operation              CONSTANT VARCHAR2(30) := 'UPDATE';
Line: 1060

      SAVEPOINT UPDATE_CNR_VALUES_PVT;
Line: 1097

          JTF_TERR_CNR_GROUP_VALUES_PKG.Update_Row(
                               x_rowid                  => l_rowid,
                               x_CNR_GROUP_VALUE_ID     => l_terr_cnr_group_value_Id,
                               x_LAST_UPDATED_BY        => p_Terr_cnr_values_rec.LAST_UPDATED_BY,
                               x_LAST_UPDATE_DATE       => p_Terr_cnr_values_rec.LAST_UPDATE_DATE,
                               x_CREATED_BY             => p_Terr_cnr_values_rec.CREATED_BY,
                               x_CREATION_DATE          => p_Terr_cnr_values_rec.CREATION_DATE,
                               x_LAST_UPDATE_LOGIN      => p_Terr_cnr_values_rec.LAST_UPDATE_LOGIN,
                               x_CNR_GROUP_ID           => p_Terr_cnr_values_rec.CNR_GROUP_ID,
                               x_COMPARISON_OPERATOR    => p_Terr_cnr_values_rec.COMPARISON_OPERATOR,
                               x_LOW_VALUE_CHAR         => p_Terr_cnr_values_rec.LOW_VALUE_CHAR,
                               x_HIGH_VALUE_CHAR        => p_Terr_cnr_values_rec.HIGH_VALUE_CHAR,
                               x_START_DATE_ACTIVE      => p_Terr_cnr_values_rec.START_DATE_ACTIVE,
                               x_END_DATE_ACTIVE        => p_Terr_cnr_values_rec.END_DATE_ACTIVE,
                               x_ORG_ID                 => p_Terr_cnr_values_rec.ORG_ID
                               );
Line: 1143

         ROLLBACK TO UPDATE_CNR_VALUES_PVT;
Line: 1152

         ROLLBACK TO UPDATE_CNR_VALUES_PVT;
Line: 1161

         ROLLBACK TO UPDATE_CNR_VALUES_PVT;
Line: 1167

              'Error inside Update_Terr_Cnr_Group ' || sqlerrm);
Line: 1170

  End Update_Terr_Cnr_Value;