APPS.JTF_RS_ROLE_RELATE_IUHK SQL Statements

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

Line: 27

  PROCEDURE  update_res_role_relate_pre
  (
   P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
   P_START_DATE_ACTIVE    IN     JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE      IN     JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_OBJECT_VERSION_NUM   IN     JTF_RS_ROLE_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: 43

  PROCEDURE  delete_res_role_relate_pre
  (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
   P_OBJECT_VERSION_NUM   IN  JTF_RS_ROLE_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: 74

  PROCEDURE  update_res_role_relate_post
  (
   P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
   P_START_DATE_ACTIVE    IN     JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE      IN     JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_OBJECT_VERSION_NUM   IN     JTF_RS_ROLE_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: 91

  PROCEDURE  delete_res_role_relate_post
  (P_ROLE_RELATE_ID       IN     JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
   P_OBJECT_VERSION_NUM   IN  JTF_RS_ROLE_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
   P_DATA                   OUT NOCOPY  VARCHAR2,
   P_COUNT            OUT NOCOPY  NUMBER,
   P_RETURN_CODE            OUT NOCOPY  VARCHAR2
  )
 IS
  BEGIN
    NULL;