APPS.JTF_RS_DYNAMIC_GROUPS_IUHK SQL Statements

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

Line: 26

  PROCEDURE  update_dynamic_groups_pre
  (P_GROUP_ID    	   IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
   P_GROUP_NUMBER    	   IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
   P_GROUP_NAME 	   IN   JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_GROUP_DESC 	   IN   JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_USAGE    	  	   IN   JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_START_DATE_ACTIVE     IN   JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE       IN   JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_SQL_TEXT              IN   JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                  OUT NOCOPY  VARCHAR2,
   P_COUNT                 OUT NOCOPY  NUMBER,
   P_RETURN_CODE           OUT NOCOPY  VARCHAR2
  )
 IS
  BEGIN
    NULL;

Line: 46

  PROCEDURE  delete_dynamic_groups_pre
  (P_GROUP_ID    	  IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
   P_OBJECT_VERSION_NUMBER	IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                 OUT NOCOPY  VARCHAR2,
   P_COUNT                OUT NOCOPY  NUMBER,
   P_RETURN_CODE          OUT NOCOPY  VARCHAR2
  )
 IS
  BEGIN
    NULL;

Line: 78

  PROCEDURE  update_dynamic_groups_post
  (P_GROUP_ID    	   IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
   P_GROUP_NUMBER    	   IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_NUMBER%TYPE,
   P_GROUP_NAME 	   IN   JTF_RS_DYNAMIC_GROUPS_TL.GROUP_NAME%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_GROUP_DESC 	   IN   JTF_RS_DYNAMIC_GROUPS_TL.GROUP_DESC%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_USAGE    	  	   IN   JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_START_DATE_ACTIVE     IN   JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE       IN   JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_SQL_TEXT              IN   JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                  OUT NOCOPY  VARCHAR2,
   P_COUNT                 OUT NOCOPY  NUMBER,
   P_RETURN_CODE           OUT NOCOPY  VARCHAR2
  )
 IS
  BEGIN
    NULL;

Line: 99

  PROCEDURE  delete_dynamic_groups_post
  (P_GROUP_ID    	  IN   JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,
   P_OBJECT_VERSION_NUMBER	IN JTF_RS_DYNAMIC_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                 OUT NOCOPY  VARCHAR2,
   P_COUNT                OUT NOCOPY  NUMBER,
   P_RETURN_CODE          OUT NOCOPY  VARCHAR2
  )
 IS
  BEGIN
    NULL;