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

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

Line: 19


    P_LAST_UPDATED_BY            IN   NUMBER ,
    P_LAST_UPDATE_DATE           IN   DATE 	,
    P_LAST_UPDATE_LOGIN          IN   NUMBER ,
    P_GROUP_NAME                 IN   VARCHAR2,
    P_GROUP_NAME_CODE            IN   VARCHAR2,
    P_DESCRIPTION                IN   VARCHAR2,
    P_PARTY_TYPE		            IN   VARCHAR2 ,
    P_START_DATE_ACTIVE          IN   DATE,
    P_END_DATE_ACTIVE            IN   DATE,
    P_USE_IN_CUSTOMER_DASHBOARD  IN   VARCHAR2,
    P_SEEDED_FLAG                IN   VARCHAR2,
    P_OBJECT_VERSION_NUMBER 	   IN   NUMBER DEFAULT NULL,
    P_APPLICATION_ID             IN   NUMBER,
    X_PROF_GROUP_Rec             OUT  NOCOPY  PROF_GROUP_Rec_Type
    )
   IS
 BEGIN

    X_Prof_group_rec.GROUP_ID := P_GROUP_ID;

Line: 40


    X_Prof_group_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;

Line: 41


    X_Prof_group_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;

Line: 42


    X_Prof_group_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;

Line: 67


    P_LAST_UPDATED_BY            IN   NUMBER,
    P_LAST_UPDATE_DATE           IN   DATE,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_GROUP_NAME                 IN   VARCHAR2,
    P_GROUP_NAME_CODE            IN   VARCHAR2,
    P_DESCRIPTION                IN   VARCHAR2,
    P_PARTY_TYPE		            IN   VARCHAR2,
    P_START_DATE_ACTIVE          IN   DATE,
    P_END_DATE_ACTIVE            IN   DATE,
    P_USE_IN_CUSTOMER_DASHBOARD  IN   VARCHAR2,
    P_SEEDED_FLAG                IN   VARCHAR2,
    X_Object_Version_Number      OUT NOCOPY 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_prof_group_rec PROF_GROUP_REC_TYPE := G_MISS_PROF_GROUP_REC;

Line: 92


      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_GROUP_NAME       	=>    P_GROUP_NAME,
      P_GROUP_NAME_CODE   	=>    P_GROUP_NAME_CODE,
      P_DESCRIPTION    	        =>    P_DESCRIPTION,
      P_PARTY_TYPE 	        =>    P_PARTY_TYPE,
      P_START_DATE_ACTIVE 	=>    P_START_DATE_ACTIVE,
      P_END_DATE_ACTIVE 	=>    P_END_DATE_ACTIVE,
      P_USE_IN_CUSTOMER_DASHBOARD 	=>  P_USE_IN_CUSTOMER_DASHBOARD,
      P_SEEDED_FLAG 	        =>    P_SEEDED_FLAG,
      P_APPLICATION_ID          =>    P_APPLICATION_ID,
      X_PROF_GROUP_Rec     => l_prof_group_rec
	);

Line: 187


      CSC_PROF_GROUPS_PKG.Insert_Row(
          px_GROUP_ID  => px_GROUP_ID,
          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  => FND_GLOBAL.CONC_LOGIN_ID,
          p_GROUP_NAME  => p_PROF_GROUP_rec.GROUP_NAME,
          p_GROUP_NAME_CODE  => p_PROF_GROUP_rec.GROUP_NAME_CODE,
          p_DESCRIPTION  => p_PROF_GROUP_rec.DESCRIPTION,
          p_START_DATE_ACTIVE  => p_PROF_GROUP_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE  => p_PROF_GROUP_rec.END_DATE_ACTIVE,
          p_USE_IN_CUSTOMER_DASHBOARD  => p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,
          p_PARTY_TYPE  => p_PROF_GROUP_rec.PARTY_TYPE,
          p_SEEDED_FLAG  => p_PROF_GROUP_rec.SEEDED_FLAG,
	     x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
          p_APPLICATION_ID    => p_PROF_GROUP_rec.APPLICATION_ID );

Line: 256


PROCEDURE Update_profile_groups(
    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_ID                   IN   NUMBER,
    P_CREATED_BY                 IN   NUMBER,
    P_CREATION_DATE              IN   DATE ,
    P_LAST_UPDATED_BY            IN   NUMBER,
    P_LAST_UPDATE_DATE           IN   DATE ,
    P_LAST_UPDATE_LOGIN          IN   NUMBER,
    P_GROUP_NAME                 IN   VARCHAR2,
    P_GROUP_NAME_CODE            IN   VARCHAR2,
    P_DESCRIPTION                IN   VARCHAR2,
    P_PARTY_TYPE		         IN   VARCHAR2,
    P_START_DATE_ACTIVE          IN   DATE ,
    P_END_DATE_ACTIVE            IN   DATE ,
    P_USE_IN_CUSTOMER_DASHBOARD  IN   VARCHAR2,
    P_SEEDED_FLAG         IN   VARCHAR2,
    PX_OBJECT_VERSION_NUMBER 	   IN OUT NOCOPY  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_prof_group_Rec  PROF_GROUP_REC_TYPE;

Line: 288


      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_GROUP_NAME       	=>    P_GROUP_NAME,
      P_GROUP_NAME_CODE   	=>    P_GROUP_NAME_CODE,
      P_DESCRIPTION    	=>          P_DESCRIPTION,
      P_PARTY_TYPE 	=>		P_PARTY_TYPE,
      P_START_DATE_ACTIVE 	=>    P_START_DATE_ACTIVE,
      P_END_DATE_ACTIVE 	=>    P_END_DATE_ACTIVE,
      P_USE_IN_CUSTOMER_DASHBOARD 	=>  P_USE_IN_CUSTOMER_DASHBOARD,
      P_SEEDED_FLAG 	=>        P_SEEDED_FLAG,
      P_OBJECT_VERSION_NUMBER 	=> PX_OBJECT_VERSION_NUMBER,
      P_APPLICATION_ID         => P_APPLICATION_ID,
      X_PROF_GROUP_Rec     => l_prof_group_rec
	);

Line: 304


      Update_profile_groups(
      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_GROUP_Rec  	=>  l_prof_group_rec,
	 PX_Object_Version_Number => px_Object_Version_Number,
      X_Return_Status              => x_return_status,
      X_Msg_Count                  => x_msg_count,
      X_Msg_Data                   => x_msg_data);

Line: 316


PROCEDURE Update_profile_groups(
    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_GROUP_Rec     IN    PROF_GROUP_Rec_Type,
    PX_Object_Version_Number  IN OUT NOCOPY NUMBER,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2
    )

 IS

Cursor C_Get_profile_groups(c_GROUP_ID Number) IS
    Select GROUP_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN,
           GROUP_NAME,
           GROUP_NAME_CODE,
           DESCRIPTION,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE,
           USE_IN_CUSTOMER_DASHBOARD,
           SEEDED_FLAG,
	   OBJECT_VERSION_NUMBER

    From  CSC_PROF_GROUPS_VL
    Where group_id = c_Group_id
    And object_version_number = px_Object_Version_Number
    For Update NOWAIT;

Line: 351


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

Line: 359


      SAVEPOINT UPDATE_PROFILE_GROUPS_PVT;

Line: 391


               l_old_PROF_GROUP_rec.LAST_UPDATED_BY,
               l_old_PROF_GROUP_rec.LAST_UPDATE_DATE,
               l_old_PROF_GROUP_rec.LAST_UPDATE_LOGIN,
               l_old_PROF_GROUP_rec.GROUP_NAME,
               l_old_PROF_GROUP_rec.GROUP_NAME_CODE,
               l_old_PROF_GROUP_rec.DESCRIPTION,
               l_old_PROF_GROUP_rec.START_DATE_ACTIVE,
               l_old_PROF_GROUP_rec.END_DATE_ACTIVE,
               l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,
               l_old_PROF_GROUP_rec.SEEDED_FLAG,
	       l_old_prof_GROUP_rec.OBJECT_VERSION_NUMBER;

Line: 427


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

Line: 440


      CSC_PROF_GROUPS_PKG.Update_Row(
          p_GROUP_ID  => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.GROUP_ID,l_old_PROF_GROUP_rec.GROUP_ID),
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_GROUP_NAME  =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),
          p_GROUP_NAME_CODE  =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
          p_DESCRIPTION  =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
          p_START_DATE_ACTIVE  => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
          p_END_DATE_ACTIVE  => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
          p_USE_IN_CUSTOMER_DASHBOARD  => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
          p_PARTY_TYPE  => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
          p_SEEDED_FLAG  => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),
	       PX_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
          p_APPLICATION_ID  => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.APPLICATION_ID,l_old_PROF_GROUP_rec.APPLICATION_ID) );

Line: 475


    		 ROLLBACK TO Update_profile_groups_PVT;

Line: 483


    		 ROLLBACK TO Update_profile_groups_PVT;

Line: 491


    		 ROLLBACK TO Update_profile_groups_PVT;

Line: 495


End Update_profile_groups;

Line: 498


PROCEDURE Delete_profile_groups(
    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_ID                   IN   NUMBER,
    P_Object_Version_Number      IN   NUMBER,
    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_profile_groups';

Line: 515


      SAVEPOINT DELETE_PROFILE_GROUPS_PVT;

Line: 543


      CSC_PROF_GROUPS_PKG.Delete_Row(
          p_GROUP_ID  => p_GROUP_ID,
		p_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER);

Line: 564


    		 ROLLBACK TO Delete_profile_groups_PVT;

Line: 572


    		 ROLLBACK TO Delete_profile_groups_PVT;

Line: 580


    		 ROLLBACK TO Delete_profile_groups_PVT;

Line: 588


End Delete_profile_groups;

Line: 603


  Select group_id
  From csc_prof_groups_vl
  Where group_name = p_GROUP_NAME;

Line: 648


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

Line: 688


  Select group_id
  From csc_prof_groups_b
  Where group_name_code = p_GROUP_NAME_CODE;

Line: 724


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