APPS.JTF_RS_SRP_TERRITORIES_IUHK SQL Statements

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

Line: 15

      P_WH_UPDATE_DATE  	IN   	JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
      P_START_DATE_ACTIVE	IN   	JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
      P_END_DATE_ACTIVE  	IN   	JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
      X_RETURN_STATUS		OUT NOCOPY 	VARCHAR2,
      X_MSG_COUNT          	OUT NOCOPY      NUMBER,
      X_MSG_DATA           	OUT NOCOPY      VARCHAR2
   ) IS

   BEGIN
      NULL;

Line: 33

      P_WH_UPDATE_DATE        IN      JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
      P_START_DATE_ACTIVE     IN      JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
      P_END_DATE_ACTIVE       IN      JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
      P_SALESREP_TERRITORY_ID IN      JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
      X_RETURN_STATUS         OUT NOCOPY     VARCHAR2,
      X_MSG_COUNT      	      OUT NOCOPY     NUMBER,
      X_MSG_DATA              OUT NOCOPY     VARCHAR2
   ) IS

   BEGIN
      NULL;

Line: 46

   /* Internal Procedure for pre processing in case of update srp territories */

   PROCEDURE  update_rs_srp_territories_pre (
      P_SALESREP_TERRITORY_ID	IN      JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
      P_STATUS             	IN      JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
      P_WH_UPDATE_DATE     	IN      JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
      P_START_DATE_ACTIVE  	IN      JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
      P_END_DATE_ACTIVE    	IN      JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
      X_RETURN_STATUS      	OUT NOCOPY    VARCHAR2,
      X_MSG_COUNT          	OUT NOCOPY    NUMBER,
      X_MSG_DATA           	OUT NOCOPY    VARCHAR2
   ) IS

   BEGIN
      NULL;

Line: 61

   END update_rs_srp_territories_pre;

Line: 63

   /* Internal Procedure for post processing in case of update srp territories */

   PROCEDURE  update_rs_srp_territories_post (
      P_SALESREP_TERRITORY_ID      IN      JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
      P_STATUS                     IN      JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
      P_WH_UPDATE_DATE             IN      JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
      P_START_DATE_ACTIVE          IN      JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
      P_END_DATE_ACTIVE            IN      JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
      X_RETURN_STATUS              OUT NOCOPY     VARCHAR2,
      X_MSG_COUNT                  OUT NOCOPY     NUMBER,
      X_MSG_DATA                   OUT NOCOPY     VARCHAR2
   ) IS

   BEGIN
      NULL;

Line: 78

   END update_rs_srp_territories_post;