APPS.JTF_RS_RESOURCE_TEAM_VUHK SQL Statements

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

Line: 49

	update resource team */

  PROCEDURE  update_resource_team_pre
  (P_TEAM_ID              IN   JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
   P_TEAM_NAME            IN   JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
   P_TEAM_DESC            IN   JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
   P_EXCLUSIVE_FLAG       IN   JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
   P_EMAIL_ADDRESS        IN   JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
   P_START_DATE_ACTIVE    IN   JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
   P_END_DATE_ACTIVE      IN   JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2
  )IS
     l_old_start_date_active DATE ;

Line: 72

	SELECT org_id FROM cn_repositories_all WHERE status = 'A';

Line: 89

	select start_date_active, end_date_active
	  into l_old_start_date_active, l_old_end_date_active
	  from jtf_rs_teams_vl
	  where team_id = P_TEAM_ID;

Line: 123

  END update_resource_team_pre;

Line: 127

	update resource team */

  PROCEDURE  update_resource_team_post
  (P_TEAM_ID              IN   JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
   P_TEAM_NAME            IN   JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
   P_TEAM_DESC            IN   JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
   P_EXCLUSIVE_FLAG       IN   JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
   P_EMAIL_ADDRESS        IN   JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
   P_START_DATE_ACTIVE    IN   JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
   P_END_DATE_ACTIVE      IN   JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
   X_RETURN_STATUS        OUT NOCOPY VARCHAR2
  )IS
  BEGIN
      x_return_status := fnd_api.g_ret_sts_success;

Line: 141

  END update_resource_team_post;