APPS.JTF_RS_SRP_TERRITORIES_PUB SQL Statements

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

Line: 7

   create, update and delete resource salesrep territories from other modules.
   Its main procedures are as following:
   Create Resource Salesrep Territories
   Update Resource Salesrep Territories
   Delete Resource Salesrep Territories
   Calls to these procedures will invoke procedures from jtf_rs_srp_territories_pvt
   to do business validations and to do actual inserts, updates and deletes into tables.
   ******************************************************************************************/

  /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_SRP_TERRITORIES_PUB';

Line: 30

   P_WH_UPDATE_DATE      	IN   JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE 	DEFAULT NULL,
   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   	DEFAULT NULL,
   X_RETURN_STATUS        	OUT NOCOPY VARCHAR2,
   X_MSG_COUNT            	OUT NOCOPY NUMBER,
   X_MSG_DATA             	OUT NOCOPY VARCHAR2,
   X_SALESREP_TERRITORY_ID      OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
  ) IS

   l_api_version         	CONSTANT NUMBER := 1.0;

Line: 44

   l_wh_update_date		jtf_rs_srp_territories.wh_update_date%type 	:= p_wh_update_date;

Line: 52

    SELECT salesrep_id
    FROM   jtf_rs_salesreps
    WHERE  salesrep_id = l_salesrep_id;

Line: 126

     P_WH_UPDATE_DATE           => l_wh_update_date,
     P_START_DATE_ACTIVE	=> l_start_date_active,
     P_END_DATE_ACTIVE 		=> l_end_date_active,
     X_RETURN_STATUS 		=> x_return_status,
     X_MSG_COUNT 		=> x_msg_count,
     X_MSG_DATA 		=> x_msg_data,
     X_SALESREP_TERRITORY_ID	=> x_salesrep_territory_id
    );

Line: 164

  PROCEDURE  update_rs_srp_territories
  (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_SRP_TERRITORIES.SALESREP_ID%TYPE,
   P_TERRITORY_ID               IN   	JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
   P_STATUS                     IN   	JTF_RS_SRP_TERRITORIES.STATUS%TYPE		DEFAULT FND_API.G_MISS_CHAR,
   P_WH_UPDATE_DATE             IN   	JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE 	DEFAULT FND_API.G_MISS_DATE,
   P_START_DATE_ACTIVE          IN   	JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE 	DEFAULT FND_API.G_MISS_DATE,
   P_END_DATE_ACTIVE            IN   	JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE 	DEFAULT FND_API.G_MISS_DATE,
   P_OBJECT_VERSION_NUMBER	IN OUT NOCOPY  JTF_RS_SRP_TERRITORIES.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: 185

   l_wh_update_date             jtf_rs_srp_territories.wh_update_date%type	:= p_wh_update_date;

Line: 209

    SELECT salesrep_id
    FROM   jtf_rs_salesreps
    WHERE  salesrep_id = l_salesrep_id;

Line: 215

    SAVEPOINT update_rs_srp_territories_pub;

Line: 272

      SELECT salesrep_territory_id INTO l_salesrep_territory_id
      FROM jtf_rs_srp_territories
      WHERE salesrep_id = l_salesrep_id
         AND territory_id = l_territory_id;

Line: 279

    jtf_rs_srp_territories_pvt.update_rs_srp_territories
    (P_API_VERSION 		=> 1,
     P_INIT_MSG_LIST 		=> fnd_api.g_false,
     P_COMMIT 			=> fnd_api.g_false,
     P_SALESREP_TERRITORY_ID	=> l_salesrep_territory_id,
     P_STATUS                   => l_status,
     P_WH_UPDATE_DATE           => l_wh_update_date,
     P_START_DATE_ACTIVE 	=> l_start_date_active,
     P_END_DATE_ACTIVE 		=> l_end_date_active,
     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: 309

      ROLLBACK TO update_rs_srp_territories_pub;

Line: 316

      ROLLBACK TO update_rs_srp_territories_pub;

Line: 320

  END update_rs_srp_territories;