DBA Data[Home] [Help]

APPS.CSC_PROFILE_GROUPS_PUB SQL Statements

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

Line: 31

    x_pvt_Groups_rec.LAST_UPDATED_BY := P_Groups_Rec.LAST_UPDATED_BY;
Line: 32

    x_pvt_Groups_rec.LAST_UPDATE_DATE := P_Groups_Rec.LAST_UPDATE_DATE;
Line: 33

    x_pvt_Groups_rec.LAST_UPDATE_LOGIN := P_Groups_Rec.LAST_UPDATE_LOGIN;
Line: 42

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

    X_Prof_group_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY;
Line: 64

    X_Prof_group_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE;
Line: 65

    X_Prof_group_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN;
Line: 87

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

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

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

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

      Update_profile_groups(
      P_Api_Version_Number         => P_Api_Version_Number,
      P_Init_Msg_List              => P_Init_Msg_List,
      P_Commit                     => P_Commit,
      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: 314

PROCEDURE Update_profile_groups(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    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
l_api_name                CONSTANT VARCHAR2(30) := 'Update_profile_groups';
Line: 332

      SAVEPOINT UPDATE_PROFILE_GROUPS_PUB;
Line: 363

      CSC_profile_groups_PVT.Update_profile_groups(
      P_Api_Version_Number         => 1.0,
      P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
      P_Commit                     => p_commit,
      P_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
      P_PROF_GROUP_Rec  =>  l_pvt_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: 403

    		 ROLLBACK TO Update_profile_groups_PUB;
Line: 410

    		 ROLLBACK TO Update_profile_groups_PUB;
Line: 417

    		 ROLLBACK TO Update_profile_groups_PUB;
Line: 426

End Update_profile_groups;
Line: 429

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

      SAVEPOINT DELETE_PROFILE_GROUPS_PUB;
Line: 474

    CSC_profile_groups_PVT.Delete_profile_groups(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => CSC_CORE_UTILS_PVT.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
    P_GROUP_Id  => P_GROUP_Id,
    P_OBJECT_VERSION_NUMBER => p_OBJECT_VERSION_NUMBER,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);
Line: 513

    		 ROLLBACK TO Delete_profile_groups_PUB;
Line: 520

    		 ROLLBACK TO Delete_profile_groups_PUB;
Line: 527

    		 ROLLBACK TO Delete_profile_groups_PUB;
Line: 536

End Delete_profile_groups;