eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROF_GROUP_CAT_PVT SQL Statements

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

Line: 22


    p_LAST_UPDATED_BY                 NUMBER,
    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATE_LOGIN               NUMBER,
    p_SEEDED_FLAG                     VARCHAR2,
    x_PROF_GRP_CAT_rec    OUT NOCOPY   PROF_GRP_CAT_Rec_Type
    )
  IS
BEGIN

    x_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID := P_GROUP_CATEGORY_ID;

Line: 37


    x_PROF_GRP_CAT_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;

Line: 38


    x_PROF_GRP_CAT_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;

Line: 39


    x_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;

Line: 56


    p_LAST_UPDATED_BY            IN   NUMBER,
    p_LAST_UPDATE_DATE           IN   DATE,
    p_LAST_UPDATE_LOGIN          IN   NUMBER,
    p_SEEDED_FLAG                IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )
IS
l_PROF_GRP_CAT_Rec  PROF_GRP_CAT_Rec_Type;

Line: 75


    p_LAST_UPDATED_BY      => p_LAST_UPDATED_BY,
    p_LAST_UPDATE_DATE     => p_LAST_UPDATE_DATE,
    p_LAST_UPDATE_LOGIN    => p_LAST_UPDATE_LOGIN,
    p_SEEDED_FLAG          => p_SEEDED_FLAG,
    x_PROF_GRP_CAT_rec    => l_PROF_GRP_CAT_Rec
    );

Line: 162


      CSC_PROF_GROUP_CATEGORIES_PKG.Insert_Row(
          px_GROUP_CATEGORY_ID  => px_GROUP_CATEGORY_ID,
          p_GROUP_ID  => p_PROF_GRP_CAT_rec.GROUP_ID,
          p_CATEGORY_CODE  => p_PROF_GRP_CAT_rec.CATEGORY_CODE,
          p_CATEGORY_SEQUENCE  => p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,
          p_SEEDED_FLAG   =>  p_PROF_GRP_CAT_rec.SEEDED_FLAG);

Line: 216


PROCEDURE Update_csc_prof_group_cat(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN   NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    p_GROUP_CATEGORY_ID          IN   NUMBER,
    p_GROUP_ID                   IN   NUMBER,
    p_CATEGORY_CODE              IN   VARCHAR2,
    p_CATEGORY_SEQUENCE          IN   NUMBER,
    p_CREATED_BY                 IN   NUMBER DEFAULT NULL,
    p_CREATION_DATE              IN   DATE DEFAULT NULL,
    p_LAST_UPDATED_BY            IN   NUMBER,
    p_LAST_UPDATE_DATE           IN   DATE,
    p_LAST_UPDATE_LOGIN          IN   NUMBER,
    p_SEEDED_FLAG                IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )
IS
l_PROF_GRP_CAT_Rec  PROF_GRP_CAT_Rec_Type;

Line: 247


    p_LAST_UPDATED_BY      => p_LAST_UPDATED_BY,
    p_LAST_UPDATE_DATE     => p_LAST_UPDATE_DATE,
    p_LAST_UPDATE_LOGIN    => p_LAST_UPDATE_LOGIN,
    p_SEEDED_FLAG          => p_SEEDED_FLAG,
    x_PROF_GRP_CAT_rec    => l_PROF_GRP_CAT_Rec
    );

Line: 255


Update_csc_prof_group_cat(
    P_Api_Version_Number   => P_Api_Version_Number,
    P_Init_Msg_List        => P_Init_Msg_List,
    P_Commit               => P_Commit ,
    p_validation_level     => p_validation_level,
    P_PROF_GRP_CAT_Rec     => l_PROF_GRP_CAT_Rec,
    X_Return_Status        => X_Return_Status,
    X_Msg_Count            => X_Msg_Count,
    X_Msg_Data             => X_Msg_Data
    );

Line: 266


END Update_csc_prof_group_cat;

Line: 269


PROCEDURE Update_csc_prof_group_cat(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN  NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_PROF_GRP_CAT_Rec     IN    PROF_GRP_CAT_Rec_Type,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )

 IS
Cursor C_Get_csc_prof_group_cat(c_GROUP_CATEGORY_ID Number) IS
    Select rowid,
           GROUP_CATEGORY_ID,
           GROUP_ID,
           CATEGORY_CODE,
           CATEGORY_SEQUENCE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           SEEDED_FLAG
    From  CSC_PROF_GROUP_CATEGORIES
    Where Group_category_id = c_Group_category_id
    For Update NOWAIT;

Line: 297


l_api_name                CONSTANT VARCHAR2(30) := 'Update_csc_prof_group_cat';

Line: 304


      SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line: 342


               l_old_PROF_GRP_CAT_rec.LAST_UPDATED_BY,
               l_old_PROF_GRP_CAT_rec.LAST_UPDATE_DATE,
               l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,
               l_old_PROF_GRP_CAT_rec.SEEDED_FLAG;

Line: 362


              p_validation_mode  => CSC_CORE_UTILS_PVT.G_UPDATE,
              P_PROF_GRP_CAT_Rec  =>  P_PROF_GRP_CAT_Rec,
              x_return_status    => x_return_status,
              x_msg_count        => x_msg_count,
              x_msg_data         => x_msg_data);

Line: 375


      CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
          p_GROUP_CATEGORY_ID  =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
          p_GROUP_ID  =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
          p_CATEGORY_CODE  =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
          p_CATEGORY_SEQUENCE  =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN),
          p_SEEDED_FLAG  =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.SEEDED_FLAG,l_old_PROF_GRP_CAT_rec.SEEDED_FLAG));

Line: 405


      		ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line: 410


      		ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line: 415


      		ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PVT;

Line: 422


End Update_csc_prof_group_cat;

Line: 425


PROCEDURE Delete_csc_prof_group_cat(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     IN   VARCHAR2     := CSC_CORE_UTILS_PVT.G_FALSE,
    p_validation_level           IN   NUMBER       := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_PROF_GRP_CAT_Rec     IN PROF_GRP_CAT_Rec_Type,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_csc_prof_group_cat';

Line: 441


      SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PVT;

Line: 468


      CSC_PROF_GROUP_CATEGORIES_PKG.Delete_Row(
          p_GROUP_CATEGORY_ID  => p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID);

Line: 491


      		ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;

Line: 500


      		ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;

Line: 507


      		ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PVT;

Line: 514


End Delete_csc_prof_group_cat;

Line: 551


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_GROUP_CATEGORY_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 580


  Select NULL
   from csc_prof_groups_vl
  where group_id = P_GROUP_ID;

Line: 630


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_GROUP_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 672


   Select Null
   from csc_prof_Group_categories
   where group_id = p_GROUP_ID
   and category_code = p_CATEGORY_CODE;

Line: 707


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CATEGORY_CODE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 765


      ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;