APPS.BIS_FUNCTIONAL_AREA_PUB SQL Statements

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

Line: 144

PROCEDURE Update_Functional_Area(
  p_Api_Version         IN          NUMBER
 ,p_Commit              IN          VARCHAR2 := FND_API.G_FALSE
 ,p_Func_Area_Rec       IN          BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
) IS
  l_Count                  NUMBER;

Line: 155

    SAVEPOINT UpdateFuncAreaSP;

Line: 161

     ,p_Action_Type     => C_UPDATE
     ,x_Return_Status   => x_Return_Status
     ,x_Msg_Count       => x_Msg_Count
     ,x_Msg_Data        => x_Msg_Data
    );

Line: 171

    BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area(
      p_Api_Version    => 1.0
     ,p_Commit         => p_Commit
     ,p_Func_Area_Rec  => p_Func_Area_Rec
     ,x_Return_Status  => x_Return_Status
     ,x_Msg_Count      => x_Msg_Count
     ,x_Msg_Data       => x_Msg_Data
    );

Line: 191

        ROLLBACK TO UpdateFuncAreaSP;

Line: 201

        ROLLBACK TO UpdateFuncAreaSP;

Line: 211

        ROLLBACK TO UpdateFuncAreaSP;

Line: 214

            x_msg_data      :=  x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

Line: 216

            x_msg_data      :=  SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

Line: 219

        ROLLBACK TO UpdateFuncAreaSP;

Line: 222

            x_msg_data      :=  x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

Line: 224

            x_msg_data      :=  SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area ';

Line: 227

END Update_Functional_Area;

Line: 313

     ,p_Action_Type     => C_UPDATE
     ,x_Return_Status   => x_Return_Status
     ,x_Msg_Count       => x_Msg_Count
     ,x_Msg_Data        => x_Msg_Data
    );

Line: 417

        IF (FND_LOAD_UTIL.UPLOAD_TEST(p_Func_Area_Rec.Last_Updated_By
                                    , p_Func_Area_Rec.Last_Update_Date
                                    , l_Func_Area_Rec.Last_Updated_By
                                    , l_Func_Area_Rec.Last_Update_Date
                                    , NULL)) THEN

              BIS_FUNCTIONAL_AREA_PUB.Update_Functional_Area(
                p_Api_Version     => 1.0
               ,p_Commit          => p_Commit
               ,p_Func_Area_Rec   => p_Func_Area_Rec
               ,x_Return_Status   => x_Return_Status
               ,x_Msg_Count       => x_Msg_Count
               ,x_Msg_Data        => x_Msg_Data
              );

Line: 571

PROCEDURE Update_Func_Area_Apps_Dep (
  p_Api_Version         IN           NUMBER
 ,p_Commit              IN           VARCHAR2 := FND_API.G_FALSE
 ,p_Functional_Area_Id  IN           NUMBER
 ,p_Application_Id      IN           NUMBER
 ,x_Return_Status       OUT  NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT  NOCOPY  NUMBER
 ,x_Msg_Data            OUT  NOCOPY  VARCHAR2
) IS
    l_Count             NUMBER;

Line: 585

    SAVEPOINT UpdateFuncAreaAppDepSP;

Line: 593

     ,p_Action_Type         => C_UPDATE
     ,x_Return_Status       => x_Return_Status
     ,x_Msg_Count           => x_Msg_Count
     ,x_Msg_Data            => x_Msg_Data
    );

Line: 602

    BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep (
       p_Api_Version         => 1.0
      ,p_Commit              => p_Commit
      ,p_Functional_Area_Id  => p_Functional_Area_Id
      ,p_Application_Id      => p_Application_Id
      ,x_Return_Status       => x_Return_Status
      ,x_Msg_Count           => x_Msg_Count
      ,x_Msg_Data            => x_Msg_Data
    );

Line: 622

        ROLLBACK TO UpdateFuncAreaAppDepSP;

Line: 632

        ROLLBACK TO UpdateFuncAreaAppDepSP;

Line: 642

        ROLLBACK TO UpdateFuncAreaAppDepSP;

Line: 645

            x_msg_data      :=  x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

Line: 647

            x_msg_data      :=  SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

Line: 650

        ROLLBACK TO UpdateFuncAreaAppDepSP;

Line: 653

            x_msg_data      :=  x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

Line: 655

            x_msg_data      :=  SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep ';

Line: 658

END Update_Func_Area_Apps_Dep;

Line: 685

    SELECT COUNT(1) INTO l_Count
    FROM   BIS_FUNC_AREA_APP_DEPENDENCY
    WHERE  FUNCTIONAL_AREA_ID = l_Func_Area_App_Dep_Rec.Functional_Area_Id
    AND    APPLICATION_ID     = l_Func_Area_App_Dep_Rec.Application_Id;

Line: 704

        BIS_FUNCTIONAL_AREA_PUB.Update_Func_Area_Apps_Dep (
             p_Api_Version        => 1.0
            ,p_Commit             => p_Commit
            ,p_Functional_Area_Id => l_Func_Area_App_Dep_Rec.Functional_Area_Id
            ,p_Application_Id     => l_Func_Area_App_Dep_Rec.Application_Id
            ,x_Return_Status      => x_Return_Status
            ,x_Msg_Count          => x_Msg_Count
            ,x_Msg_Data           => x_Msg_Data
        );

Line: 784

        SELECT COUNT(1) INTO l_Count
        FROM   BIS_FUNCTIONAL_AREAS
        WHERE  UPPER(SHORT_NAME) = UPPER(p_Func_Area_Rec.Short_Name);

Line: 808

    ELSIF(p_Action_Type = C_UPDATE OR p_Action_Type = C_RETRIEVE OR p_Action_Type = C_DELETE) THEN

        /*
        IF (p_Func_Area_Rec.Functional_Area_Id IS NULL) THEN
            FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

Line: 818

        SELECT COUNT(1) INTO l_Count
        FROM   BIS_FUNCTIONAL_AREAS_VL
        WHERE  SHORT_NAME = p_Func_Area_Rec.Short_Name;

Line: 894

    SELECT COUNT(1) INTO l_Count
    FROM   BIS_FUNCTIONAL_AREAS
    WHERE  FUNCTIONAL_AREA_ID = p_Functional_Area_Id;

Line: 910

            SELECT COUNT(1) INTO l_Count
            FROM   FND_APPLICATION
            WHERE  APPLICATION_ID = p_Application_Id;

Line: 922

        SELECT COUNT(1) INTO l_Count
        FROM   BIS_FUNC_AREA_APP_DEPENDENCY
        WHERE  FUNCTIONAL_AREA_ID = p_Functional_Area_Id
        AND    APPLICATION_ID     = p_Application_Id;

Line: 936

        SELECT COUNT(1) INTO l_Count
        FROM   BIS_FUNC_AREA_APP_DEPENDENCY
        WHERE  APPLICATION_ID     = p_Application_Id;

Line: 950

    ELSIF(p_Action_Type = C_UPDATE OR p_Action_Type = C_DELETE) THEN

        SELECT COUNT(1) INTO l_Count
        FROM   BIS_FUNC_AREA_APP_DEPENDENCY
        WHERE  FUNCTIONAL_AREA_ID = p_Functional_Area_Id
        AND    APPLICATION_ID     = p_Application_Id;

Line: 1013

  /*SELECT (NVL(MAX(FUNCTIONAL_AREA_ID), 0)+1)
  INTO   l_Max_Id
  FROM   BIS_FUNCTIONAL_AREAS;

Line: 1020

  SELECT BIS_FUNC_AREA_ID_S.NEXTVAL
  INTO l_next
  FROM DUAL;

Line: 1037

  SELECT FUNCTIONAL_AREA_ID
  INTO   l_FA_Id
  FROM   BIS_FUNCTIONAL_AREAS
  WHERE  UPPER(SHORT_NAME) = UPPER(p_Functional_Area_Short_Name);

Line: 1050

PROCEDURE Delete_Functional_Area(
  p_Api_Version         IN          NUMBER
 ,p_Commit              IN          VARCHAR2 := FND_API.G_FALSE
 ,p_Func_Area_Rec       IN          BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
 ,x_Return_Status       OUT NOCOPY  VARCHAR2
 ,x_Msg_Count           OUT NOCOPY  NUMBER
 ,x_Msg_Data            OUT NOCOPY  VARCHAR2
) IS
    l_Func_Area_Rec   BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;

Line: 1062

      SELECT  B.FUNCTIONAL_AREA_ID,
              B.APPLICATION_ID
      FROM    BIS_FUNC_AREA_APP_DEPENDENCY B
      WHERE   B.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;

Line: 1067

    SAVEPOINT DeleteFuncAreaSP;

Line: 1074

     ,p_Action_Type     => C_DELETE
     ,x_Return_Status   => x_Return_Status
     ,x_Msg_Count       => x_Msg_Count
     ,x_Msg_Data        => x_Msg_Data
    );

Line: 1096

    BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area(
      p_Api_Version    => 1.0
     ,p_Commit         => p_Commit
     ,p_Func_Area_Rec  => l_Func_Area_Rec
     ,x_Return_Status  => x_Return_Status
     ,x_Msg_Count      => x_Msg_Count
     ,x_Msg_Data       => x_Msg_Data
    );

Line: 1115

        ROLLBACK TO DeleteFuncAreaSP;

Line: 1125

        ROLLBACK TO DeleteFuncAreaSP;

Line: 1135

        ROLLBACK TO DeleteFuncAreaSP;

Line: 1138

            x_msg_data      :=  x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

Line: 1140

            x_msg_data      :=  SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

Line: 1143

        ROLLBACK TO DeleteFuncAreaSP;

Line: 1146

            x_msg_data      :=  x_msg_data||' -> BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

Line: 1148

            x_msg_data      :=  SQLERRM||' at BIS_FUNCTIONAL_AREA_PUB.Delete_Functional_Area ';

Line: 1150

END Delete_Functional_Area;

Line: 1172

     ,p_Action_Type         => C_DELETE
     ,x_Return_Status       => x_Return_Status
     ,x_Msg_Count           => x_Msg_Count
     ,x_Msg_Data            => x_Msg_Data
    );