APPS.CSC_PROF_GROUP_CAT_PUB SQL Statements

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

Line: 30

    x_pvt_PROF_GRP_CAT_rec.LAST_UPDATED_BY := P_PROF_GRP_CAT_Rec.LAST_UPDATED_BY;

Line: 31

    x_pvt_PROF_GRP_CAT_rec.LAST_UPDATE_DATE := P_PROF_GRP_CAT_Rec.LAST_UPDATE_DATE;

Line: 32

    x_pvt_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN := P_PROF_GRP_CAT_Rec.LAST_UPDATE_LOGIN;

Line: 52

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

    x_PROF_GRP_CAT_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;

Line: 68

    x_PROF_GRP_CAT_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;

Line: 69

    x_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;

Line: 85

    p_LAST_UPDATED_BY                 NUMBER,
    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATE_LOGIN               NUMBER,
    p_SEEDED_FLAG                     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: 104

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

PROCEDURE Update_csc_prof_group_cat(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_GROUP_CATEGORY_ID          IN   NUMBER,
    p_GROUP_ID                        NUMBER,
    p_CATEGORY_CODE                   VARCHAR2,
    p_CATEGORY_SEQUENCE               NUMBER,
    p_CREATED_BY                      NUMBER,
    p_CREATION_DATE                   DATE,
    p_LAST_UPDATED_BY                 NUMBER,
    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATE_LOGIN               NUMBER,
    p_SEEDED_FLAG                     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: 273

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

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_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: 291

END Update_csc_prof_group_cat;

Line: 295

PROCEDURE Update_csc_prof_group_cat(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    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) := 'Update_csc_prof_group_cat';

Line: 311

      SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PUB;

Line: 345

    csc_prof_group_cat_PVT.Update_csc_prof_group_cat(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_PROF_GRP_CAT_Rec  =>  l_pvt_PROF_GRP_CAT_Rec ,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 384

      	 ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

Line: 391

      	 ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

Line: 397

      	 ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;

Line: 407

End Update_csc_prof_group_cat;

Line: 412

PROCEDURE Delete_csc_prof_group_cat(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    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: 428

      SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PUB;

Line: 461

    csc_prof_group_cat_PVT.Delete_csc_prof_group_cat(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_PROF_GRP_CAT_Rec  => l_pvt_PROF_GRP_CAT_Rec,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 500

           ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

Line: 506

           ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

Line: 512

           ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;

Line: 522

End Delete_csc_prof_group_cat;