eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SALESREPS_PUB SQL Statements

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

Line: 6


   create and update Salesreps.
   Its main procedures are as following:
   Create Salesreps
   Update Salesreps
   This package valoidates the input parameters to these procedures and then
   to do business validations and to do actual inserts and updates into tables.
   ******************************************************************************************/

  /* Package Varianles  */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_SALESREPS_PUB';

Line: 38


   P_WH_UPDATE_DATE       IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE      DEFAULT NULL,
   P_SALES_TAX_GEOCODE    IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE   DEFAULT NULL,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE   DEFAULT NULL,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY  NUMBER,
   X_MSG_DATA             OUT NOCOPY  VARCHAR2,
   X_SALESREP_ID    	  OUT NOCOPY  JTF_RS_SALESREPS.SALESREP_ID%TYPE
  ) IS

    l_api_version              CONSTANT NUMBER := 1.0;

Line: 62


    l_wh_update_date                    jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;

Line: 152


         /* Calling Private API to insert salesrep */

         jtf_rs_salesreps_pvt.create_salesrep(
	    P_API_VERSION          =>   1,
	    P_INIT_MSG_LIST        =>   fnd_api.g_false,
	    P_COMMIT               =>   fnd_api.g_false,
	    P_RESOURCE_ID          =>   l_resource_id,
	    P_SALES_CREDIT_TYPE_ID =>   l_sales_credit_type_id,
	    P_NAME                 =>   l_name,
	    P_STATUS               =>   l_status,
	    P_START_DATE_ACTIVE    =>   l_start_date_active,
	    P_END_DATE_ACTIVE      =>   l_end_date_active,
            P_ORG_ID               =>   l_org_id,
	    P_GL_ID_REV            =>   l_gl_id_rev,
	    P_GL_ID_FREIGHT        =>   l_gl_id_freight,
	    P_GL_ID_REC            =>   l_gl_id_rec,
	    P_SET_OF_BOOKS_ID      =>   l_set_of_books_id,
	    P_SALESREP_NUMBER      =>   l_salesrep_number,
	    P_EMAIL_ADDRESS        =>   l_email_address,
	    P_WH_UPDATE_DATE       =>   l_wh_update_date,
	    P_SALES_TAX_GEOCODE    =>   l_sales_tax_geocode,
	    P_SALES_TAX_INSIDE_CITY_LIMITS   =>   l_sales_tax_inside_city_limits,
	    X_RETURN_STATUS        =>  x_return_status,
	    X_MSG_COUNT            =>  x_msg_count,
	    X_MSG_DATA             =>  x_msg_data,
	    X_SALESREP_ID          =>  x_salesrep_id
         );

Line: 206


            P_WH_UPDATE_DATE       =>   l_wh_update_date,
            P_SALES_TAX_GEOCODE    =>   l_sales_tax_geocode,
            P_SALES_TAX_INSIDE_CITY_LIMITS   =>   l_sales_tax_inside_city_limits,
            P_SALESREP_ID	   =>  G_SALESREP_ID,
            P_ORG_ID		   =>  G_ORG_ID,
            P_ATTRIBUTE1           =>  G_ATTRIBUTE1,
            P_ATTRIBUTE2           =>  G_ATTRIBUTE2,
            P_ATTRIBUTE3           =>  G_ATTRIBUTE3,
            P_ATTRIBUTE4           =>  G_ATTRIBUTE4,
            P_ATTRIBUTE5           =>  G_ATTRIBUTE5,
            P_ATTRIBUTE6           =>  G_ATTRIBUTE6,
            P_ATTRIBUTE7           =>  G_ATTRIBUTE7,
            P_ATTRIBUTE8           =>  G_ATTRIBUTE8,
            P_ATTRIBUTE9           =>  G_ATTRIBUTE9,
            P_ATTRIBUTE10          =>  G_ATTRIBUTE10,
            P_ATTRIBUTE11          =>  G_ATTRIBUTE11,
            P_ATTRIBUTE12          =>  G_ATTRIBUTE12,
            P_ATTRIBUTE13          =>  G_ATTRIBUTE13,
            P_ATTRIBUTE14          =>  G_ATTRIBUTE14,
            P_ATTRIBUTE15          =>  G_ATTRIBUTE15,
            P_ATTRIBUTE_CATEGORY   =>  G_ATTRIBUTE_CATEGORY,
            X_RETURN_STATUS        =>  x_return_status,
            X_MSG_COUNT            =>  x_msg_count,
            X_MSG_DATA             =>  x_msg_data,
            X_SALESREP_ID          =>  x_salesrep_id
         );

Line: 295


   P_WH_UPDATE_DATE       IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE      DEFAULT NULL,
   P_SALES_TAX_GEOCODE    IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE   DEFAULT NULL,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE   DEFAULT NULL,
   P_SALESREP_ID	  IN   JTF_RS_SALESREPS.SALESREP_ID%TYPE,
   P_ORG_ID		  IN   JTF_RS_SALESREPS.ORG_ID%TYPE,
   P_ATTRIBUTE_CATEGORY   IN   JTF_RS_SALESREPS.ATTRIBUTE_CATEGORY%TYPE  DEFAULT NULL,
   P_ATTRIBUTE1           IN   JTF_RS_SALESREPS.ATTRIBUTE1%TYPE          DEFAULT NULL,
   P_ATTRIBUTE2           IN   JTF_RS_SALESREPS.ATTRIBUTE2%TYPE          DEFAULT NULL,
   P_ATTRIBUTE3           IN   JTF_RS_SALESREPS.ATTRIBUTE3%TYPE          DEFAULT NULL,
   P_ATTRIBUTE4           IN   JTF_RS_SALESREPS.ATTRIBUTE4%TYPE          DEFAULT NULL,
   P_ATTRIBUTE5           IN   JTF_RS_SALESREPS.ATTRIBUTE5%TYPE          DEFAULT NULL,
   P_ATTRIBUTE6           IN   JTF_RS_SALESREPS.ATTRIBUTE6%TYPE          DEFAULT NULL,
   P_ATTRIBUTE7           IN   JTF_RS_SALESREPS.ATTRIBUTE7%TYPE          DEFAULT NULL,
   P_ATTRIBUTE8           IN   JTF_RS_SALESREPS.ATTRIBUTE8%TYPE          DEFAULT NULL,
   P_ATTRIBUTE9           IN   JTF_RS_SALESREPS.ATTRIBUTE9%TYPE          DEFAULT NULL,
   P_ATTRIBUTE10          IN   JTF_RS_SALESREPS.ATTRIBUTE10%TYPE         DEFAULT NULL,
   P_ATTRIBUTE11          IN   JTF_RS_SALESREPS.ATTRIBUTE11%TYPE         DEFAULT NULL,
   P_ATTRIBUTE12          IN   JTF_RS_SALESREPS.ATTRIBUTE12%TYPE         DEFAULT NULL,
   P_ATTRIBUTE13          IN   JTF_RS_SALESREPS.ATTRIBUTE13%TYPE         DEFAULT NULL,
   P_ATTRIBUTE14          IN   JTF_RS_SALESREPS.ATTRIBUTE14%TYPE         DEFAULT NULL,
   P_ATTRIBUTE15          IN   JTF_RS_SALESREPS.ATTRIBUTE15%TYPE         DEFAULT NULL,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY  NUMBER,
   X_MSG_DATA             OUT NOCOPY  VARCHAR2,
   X_SALESREP_ID          OUT NOCOPY  JTF_RS_SALESREPS.SALESREP_ID%TYPE
  ) IS

    BEGIN

--dbms_output.put_line ('Inside the create_salesrep_migrate pub body');

Line: 364


   	P_WH_UPDATE_DATE       => P_WH_UPDATE_DATE,
   	P_SALES_TAX_GEOCODE    => P_SALES_TAX_GEOCODE,
   	P_SALES_TAX_INSIDE_CITY_LIMITS => P_SALES_TAX_INSIDE_CITY_LIMITS,
   	X_RETURN_STATUS        => X_RETURN_STATUS,
   	X_MSG_COUNT            => X_MSG_COUNT,
   	X_MSG_DATA             => X_MSG_DATA,
   	X_SALESREP_ID          => X_SALESREP_ID
     );

Line: 375


  /* Procedure to update the Salesreps
	based on input values passed by calling routines. */

  PROCEDURE  update_salesrep
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   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                     DEFAULT  FND_API.G_MISS_CHAR,
   P_STATUS               IN   JTF_RS_SALESREPS.STATUS%TYPE                   DEFAULT  FND_API.G_MISS_CHAR,
   P_START_DATE_ACTIVE    IN   JTF_RS_SALESREPS.START_DATE_ACTIVE%TYPE        DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE      IN   JTF_RS_SALESREPS.END_DATE_ACTIVE%TYPE          DEFAULT  FND_API.G_MISS_DATE,
   P_GL_ID_REV            IN   JTF_RS_SALESREPS.GL_ID_REV%TYPE                DEFAULT  FND_API.G_MISS_NUM,
   P_GL_ID_FREIGHT        IN   JTF_RS_SALESREPS.GL_ID_FREIGHT%TYPE            DEFAULT  FND_API.G_MISS_NUM,
   P_GL_ID_REC            IN   JTF_RS_SALESREPS.GL_ID_REC%TYPE                DEFAULT  FND_API.G_MISS_NUM,
   P_SET_OF_BOOKS_ID      IN   JTF_RS_SALESREPS.SET_OF_BOOKS_ID%TYPE          DEFAULT  FND_API.G_MISS_NUM,
   P_SALESREP_NUMBER      IN   JTF_RS_SALESREPS.SALESREP_NUMBER%TYPE          DEFAULT  FND_API.G_MISS_CHAR,
   P_EMAIL_ADDRESS        IN   JTF_RS_SALESREPS.EMAIL_ADDRESS%TYPE            DEFAULT  FND_API.G_MISS_CHAR,
   P_WH_UPDATE_DATE       IN   JTF_RS_SALESREPS.WH_UPDATE_DATE%TYPE           DEFAULT  FND_API.G_MISS_DATE,
   P_SALES_TAX_GEOCODE    IN   JTF_RS_SALESREPS.SALES_TAX_GEOCODE%TYPE        DEFAULT  FND_API.G_MISS_CHAR,
   P_SALES_TAX_INSIDE_CITY_LIMITS   IN   JTF_RS_SALESREPS.SALES_TAX_INSIDE_CITY_LIMITS%TYPE   DEFAULT  FND_API.G_MISS_CHAR,
   P_ORG_ID	          IN   JTF_RS_SALESREPS.ORG_ID%TYPE,
   P_OBJECT_VERSION_NUMBER	IN  OUT NOCOPY  JTF_RS_SALESREPS.OBJECT_VERSION_NUMBER%TYPE,
   X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
   X_MSG_COUNT            OUT NOCOPY  NUMBER,
   X_MSG_DATA             OUT NOCOPY  VARCHAR2
  ) IS

    l_api_version         CONSTANT NUMBER := 1.0;

Line: 405


    l_api_name            CONSTANT VARCHAR2(30) := 'UPDATE_SALESREP';

Line: 418


    l_wh_update_date                    jtf_rs_salesreps.wh_update_date%type := p_wh_update_date;

Line: 427


    SAVEPOINT update_salesreps_pub;

Line: 496


    /* Calling Private API to insert salesrep */
    jtf_rs_salesreps_pvt.update_salesrep(
	P_API_VERSION          =>   1,
	P_INIT_MSG_LIST        =>   fnd_api.g_false,
	P_COMMIT               =>   fnd_api.g_false,
	P_SALESREP_ID          =>   l_salesrep_id,
	P_SALES_CREDIT_TYPE_ID =>   l_sales_credit_type_id,
	P_NAME                 =>   l_name,
	P_STATUS               =>   l_status,
	P_START_DATE_ACTIVE    =>   l_start_date_active,
	P_END_DATE_ACTIVE      =>   l_end_date_active,
	P_GL_ID_REV            =>   l_gl_id_rev,
	P_GL_ID_FREIGHT        =>   l_gl_id_freight,
	P_GL_ID_REC            =>   l_gl_id_rec,
	P_SET_OF_BOOKS_ID      =>   l_set_of_books_id,
	P_SALESREP_NUMBER      =>   l_salesrep_number,
	P_EMAIL_ADDRESS        =>   l_email_address,
	P_WH_UPDATE_DATE       =>   l_wh_update_date,
	P_SALES_TAX_GEOCODE    =>   l_sales_tax_geocode,
	P_SALES_TAX_INSIDE_CITY_LIMITS   =>   l_sales_tax_inside_city_limits,
	P_ORG_ID               =>  l_org_id,
	P_OBJECT_VERSION_NUMBER =>  l_object_version_number,
	X_RETURN_STATUS        =>  x_return_status,
	X_MSG_COUNT            =>  x_msg_count,
	X_MSG_DATA             =>  x_msg_data
       );

Line: 544


      ROLLBACK TO update_salesreps_pub;

Line: 549


      ROLLBACK TO update_salesreps_pub;

Line: 554


      ROLLBACK TO update_salesreps_pub;

Line: 564


  END update_salesrep;