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_MODULE_GROUPS_PUB SQL Statements

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

Line: 31


    x_pvt_PROF_MODULE_GRP_rec.LAST_UPDATE_DATE := P_PROF_MODULE_GRP_Rec.LAST_UPDATE_DATE;

Line: 32


    x_pvt_PROF_MODULE_GRP_rec.LAST_UPDATED_BY := P_PROF_MODULE_GRP_Rec.LAST_UPDATED_BY;

Line: 35


    x_pvt_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN := P_PROF_MODULE_GRP_Rec.LAST_UPDATE_LOGIN;

Line: 58


     p_LAST_UPDATE_DATE                DATE,
     p_LAST_UPDATED_BY                 NUMBER,
     p_CREATION_DATE                   DATE,
     p_CREATED_BY                      NUMBER,
     p_LAST_UPDATE_LOGIN               NUMBER,
     p_SEEDED_FLAG                     VARCHAR2,
     p_APPLICATION_ID                  NUMBER,
     p_DASHBOARD_GROUP_ID              NUMBER,
     x_PROF_MODULE_GRP_Rec     OUT NOCOPY     PROF_MODULE_GRP_Rec_Type    )
  IS
BEGIN

    x_PROF_MODULE_GRP_rec.MODULE_GROUP_ID := P_MODULE_GROUP_ID;

Line: 79


    x_PROF_MODULE_GRP_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;

Line: 80


    x_PROF_MODULE_GRP_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;

Line: 83


    x_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;

Line: 104


    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATED_BY                 NUMBER,
    p_CREATION_DATE                   DATE,
    p_CREATED_BY                      NUMBER,
    p_LAST_UPDATE_LOGIN               NUMBER,
    p_SEEDED_FLAG                     VARCHAR2,
    p_APPLICATION_ID                  NUMBER,
    p_DASHBOARD_GROUP_ID              NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS
 l_PROF_MODULE_GRP_REC PROF_MODULE_GRP_REC_TYPE;

Line: 129


     p_LAST_UPDATE_DATE     => p_LAST_UPDATE_DATE,
     p_LAST_UPDATED_BY      => p_LAST_UPDATED_BY,
     p_CREATION_DATE        => p_CREATION_DATE,
     p_CREATED_BY           => p_CREATED_BY,
     p_LAST_UPDATE_LOGIN    => p_LAST_UPDATE_LOGIN,
     p_SEEDED_FLAG          => p_SEEDED_FLAG,
     p_APPLICATION_ID       => p_APPLICATION_ID,
     p_DASHBOARD_GROUP_ID   => p_DASHBOARD_GROUP_ID,
     x_PROF_MODULE_GRP_Rec  => l_PROF_MODULE_GRP_Rec    );

Line: 272


PROCEDURE Update_prof_module_groups(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_MODULE_GROUP_ID          	      NUMBER,
    p_FORM_FUNCTION_ID                NUMBER,
    p_FORM_FUNCTION_NAME              VARCHAR2,
    p_RESPONSIBILITY_ID                NUMBER,
    p_RESP_APPL_ID                NUMBER,
    p_PARTY_TYPE                      VARCHAR2,
    p_GROUP_ID                        NUMBER,
    p_DASHBOARD_GROUP_FLAG            VARCHAR2,
    p_CURRENCY_CODE                   VARCHAR2,
    p_LAST_UPDATE_DATE                DATE,
    p_LAST_UPDATED_BY                 NUMBER,
    p_CREATION_DATE                   DATE,
    p_CREATED_BY                      NUMBER,
    p_LAST_UPDATE_LOGIN               NUMBER,
    p_SEEDED_FLAG                     VARCHAR2,
    p_APPLICATION_ID                  NUMBER,
    p_DASHBOARD_GROUP_ID              NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS
 l_PROF_MODULE_GRP_REC PROF_MODULE_GRP_REC_TYPE;

Line: 310


     p_LAST_UPDATE_DATE     => p_LAST_UPDATE_DATE,
     p_LAST_UPDATED_BY      => p_LAST_UPDATED_BY,
     p_CREATION_DATE        => p_CREATION_DATE,
     p_CREATED_BY           => p_CREATED_BY,
     p_LAST_UPDATE_LOGIN    => p_LAST_UPDATE_LOGIN,
     p_SEEDED_FLAG          => p_SEEDED_FLAG,
     p_APPLICATION_ID       => p_APPLICATION_ID ,
     p_DASHBOARD_GROUP_ID   => p_DASHBOARD_GROUP_ID,
     x_PROF_MODULE_GRP_Rec  => l_PROF_MODULE_GRP_Rec    );

Line: 321


 Update_prof_module_groups(
    P_Api_Version_Number     => P_Api_Version_Number,
    P_Init_Msg_List          => P_Init_Msg_List,
    P_Commit                 => P_Commit,
    P_PROF_MODULE_GRP_Rec    => l_PROF_MODULE_GRP_Rec,
    X_Return_Status          => X_Return_Status,
    X_Msg_Count              => X_Msg_Count,
    X_Msg_Data               => X_Msg_Data
    );

Line: 331


END Update_prof_module_groups;

Line: 333


PROCEDURE Update_prof_module_groups(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_PROF_MODULE_GRP_Rec        IN    PROF_MODULE_GRP_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_prof_module_groups';

Line: 349


      SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PUB;

Line: 383


    CSC_prof_module_groups_PVT.Update_prof_module_groups(
    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_MODULE_GRP_Rec  =>  l_pvt_PROF_MODULE_GRP_Rec ,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 422


		 ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;

Line: 429


		 ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;

Line: 435


		 ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;

Line: 445


End Update_prof_module_groups;

Line: 448


PROCEDURE Delete_prof_module_groups(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    P_PROF_MODULE_GRP_Rec     IN PROF_MODULE_GRP_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_prof_module_groups';

Line: 464


      SAVEPOINT DELETE_PROF_MODULE_GROUPS_PUB;

Line: 499


    CSC_prof_module_groups_PVT.Delete_prof_module_groups(
    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_MODULE_GRP_Id  => l_pvt_PROF_MODULE_GRP_Rec.module_group_id,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 538


		 ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;

Line: 546


		 ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;

Line: 554


		 ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;

Line: 564


End Delete_prof_module_groups;