APPS.JTF_RS_SALESREPS_IUHK SQL Statements

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

Line: 25

   P_WH_UPDATE_DATE                 IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
   P_SALES_TAX_GEOCODE              IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
   X_RETURN_STATUS                  OUT NOCOPY VARCHAR2
  ) IS
  begin
	null;

Line: 52

   P_WH_UPDATE_DATE                 IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
   P_SALES_TAX_GEOCODE              IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
   X_RETURN_STATUS                  OUT NOCOPY VARCHAR2
  ) IS
  begin
	null;

Line: 63

	update salesrep */

  PROCEDURE  update_salesrep_pre
  (P_SALESREP_ID    	            IN   JTF_RS_SALESREPS.SALESREP_ID%TYPE,
   P_SALES_CREDIT_TYPE_ID           IN   JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
   P_NAME                           IN   JTF_RS_SALESREPS.NAME%TYPE,
   P_STATUS                         IN   JTF_RS_SALESREPS.STATUS%TYPE,
   P_START_DATE_ACTIVE              IN   JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
   P_END_DATE_ACTIVE                IN   JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
   P_GL_ID_REV                      IN   JTF_RS_SALESREPS.GL_ID_REV%TYPE,
   P_GL_ID_FREIGHT                  IN   JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
   P_GL_ID_REC                      IN   JTF_RS_SALESREPS.GL_ID_REC%TYPE,
   P_SET_OF_BOOKS_ID                IN   JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
   P_SALESREP_NUMBER                IN   JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
   P_EMAIL_ADDRESS                  IN   JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
   P_WH_UPDATE_DATE                 IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
   P_SALES_TAX_GEOCODE              IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
   X_RETURN_STATUS                  OUT NOCOPY VARCHAR2
  ) IS
  begin
	null;

Line: 85

  end update_salesrep_pre;

Line: 89

	update salesrep */

  PROCEDURE  update_salesrep_post
  (P_SALESREP_ID    	            IN   JTF_RS_SALESREPS.SALESREP_ID%TYPE,
   P_SALES_CREDIT_TYPE_ID           IN   JTF_RS_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE,
   P_NAME                           IN   JTF_RS_SALESREPS.NAME%TYPE,
   P_STATUS                         IN   JTF_RS_SALESREPS.STATUS%TYPE,
   P_START_DATE_ACTIVE              IN   JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE,
   P_END_DATE_ACTIVE                IN   JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE,
   P_GL_ID_REV                      IN   JTF_RS_SALESREPS.GL_ID_REV%TYPE,
   P_GL_ID_FREIGHT                  IN   JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE,
   P_GL_ID_REC                      IN   JTF_RS_SALESREPS.GL_ID_REC%TYPE,
   P_SET_OF_BOOKS_ID                IN   JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE,
   P_SALESREP_NUMBER                IN   JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE,
   P_EMAIL_ADDRESS                  IN   JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE,
   P_WH_UPDATE_DATE                 IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE,
   P_SALES_TAX_GEOCODE              IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE,
   X_RETURN_STATUS                  OUT NOCOPY VARCHAR2
  ) IS
  begin
	null;

Line: 111

  end update_salesrep_post;