DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_IUHK SQL Statements

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

Line: 25

  PROCEDURE  update_res_group_relate_pre
  (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
   P_START_DATE_ACTIVE    IN   JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE      IN   JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                   OUT NOCOPY  VARCHAR2,
   P_COUNT            OUT NOCOPY  NUMBER,
   P_RETURN_CODE            OUT NOCOPY  VARCHAR2
  )
  IS
  BEGIN
    NULL;
Line: 40

  PROCEDURE  delete_res_group_relate_pre
  (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                 OUT NOCOPY  VARCHAR2,
   P_COUNT                OUT NOCOPY  NUMBER,
   P_RETURN_CODE          OUT NOCOPY  VARCHAR2
  )
  IS
  BEGIN
    NULL;
Line: 69

  PROCEDURE  update_res_group_relate_post
  (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
   P_START_DATE_ACTIVE    IN   JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE      IN   JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                   OUT NOCOPY  VARCHAR2,
   P_COUNT            OUT NOCOPY  NUMBER,
   P_RETURN_CODE            OUT NOCOPY VARCHAR2
  )
 IS
  BEGIN
    NULL;
Line: 84

  PROCEDURE  delete_res_group_relate_post
  (P_GROUP_RELATE_ID      IN   JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                 OUT NOCOPY  VARCHAR2,
   P_COUNT                OUT NOCOPY  NUMBER,
   P_RETURN_CODE          OUT NOCOPY  VARCHAR2
  )
 IS
  BEGIN
    NULL;