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_SRP_TERRITORIES_PUB dependencies on JTF_RS_SRP_TERRITORIES

Line 1: PACKAGE BODY jtf_rs_srp_territories_pub AS

1: PACKAGE BODY jtf_rs_srp_territories_pub AS
2: /* $Header: jtfrspib.pls 120.0 2005/05/11 08:21:11 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a public API that caller will invoke.

Line 12: Calls to these procedures will invoke procedures from jtf_rs_srp_territories_pvt

8: Its main procedures are as following:
9: Create Resource Salesrep Territories
10: Update Resource Salesrep Territories
11: Delete Resource Salesrep Territories
12: Calls to these procedures will invoke procedures from jtf_rs_srp_territories_pvt
13: to do business validations and to do actual inserts, updates and deletes into tables.
14: ******************************************************************************************/
15:
16: /* Package variables. */

Line 18: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_SRP_TERRITORIES_PUB';

14: ******************************************************************************************/
15:
16: /* Package variables. */
17:
18: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_SRP_TERRITORIES_PUB';
19:
20: /* Procedure to create the resource salesrep territories
21: based on input values passed by calling routines. */
22:

Line 27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

23: PROCEDURE create_rs_srp_territories
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

Line 28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,

25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,

26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

27: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,

28: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
29: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
30: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE

Line 36: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE

32: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
37: ) IS
38:
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';

Line 41: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;

37: ) IS
38:
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
41: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

Line 42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;

38:
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
41: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;

Line 43: l_status jtf_rs_srp_territories.status%type := p_status;

39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
41: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
47: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

Line 44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;

40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
41: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
47: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
48: l_org_id number;

Line 45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

41: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
47: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
48: l_org_id number;
49:

Line 46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;

42: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
47: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
48: l_org_id number;
49:
50:

Line 47: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

43: l_status jtf_rs_srp_territories.status%type := p_status;
44: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
45: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
46: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
47: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
48: l_org_id number;
49:
50:
51: CURSOR c_salesrep_id IS

Line 55: l_salesrep jtf_rs_srp_territories.salesrep_id%type ;

51: CURSOR c_salesrep_id IS
52: SELECT salesrep_id
53: FROM jtf_rs_salesreps
54: WHERE salesrep_id = l_salesrep_id;
55: l_salesrep jtf_rs_srp_territories.salesrep_id%type ;
56:
57:
58: BEGIN
59: SAVEPOINT create_rs_srp_territories_pub;

Line 119: jtf_rs_srp_territories_pvt.create_rs_srp_territories

115: --End of Territory Id Validation
116:
117: --Call the Private API for create_rs_srp_territories
118:
119: jtf_rs_srp_territories_pvt.create_rs_srp_territories
120: (P_API_VERSION => 1,
121: P_INIT_MSG_LIST => fnd_api.g_false,
122: P_COMMIT => fnd_api.g_false,
123: P_SALESREP_ID => l_salesrep_id,

Line 168: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

164: PROCEDURE update_rs_srp_territories
165: (P_API_VERSION IN NUMBER,
166: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

165: (P_API_VERSION IN NUMBER,
166: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,

166: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
174: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,

Line 171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
174: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
175: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

168: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
174: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
175: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
176: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

169: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
174: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
175: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
176: X_MSG_COUNT OUT NOCOPY NUMBER,
177: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 174: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,

170: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
172: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
173: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
174: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
175: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
176: X_MSG_COUNT OUT NOCOPY NUMBER,
177: X_MSG_DATA OUT NOCOPY VARCHAR2
178: ) IS

Line 182: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;

178: ) IS
179:
180: l_api_version CONSTANT NUMBER := 1.0;
181: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
182: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

Line 183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;

179:
180: l_api_version CONSTANT NUMBER := 1.0;
181: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
182: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;

Line 184: l_status jtf_rs_srp_territories.status%type := p_status;

180: l_api_version CONSTANT NUMBER := 1.0;
181: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
182: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;

Line 185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;

181: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
182: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;

Line 186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

182: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;

Line 187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;

183: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;

Line 188: l_attribute1 jtf_rs_srp_territories.attribute1%type;

184: l_status jtf_rs_srp_territories.status%type := p_status;
185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;

Line 189: l_attribute2 jtf_rs_srp_territories.attribute2%type;

185: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;

Line 190: l_attribute3 jtf_rs_srp_territories.attribute3%type;

186: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;

Line 191: l_attribute4 jtf_rs_srp_territories.attribute4%type;

187: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;

Line 192: l_attribute5 jtf_rs_srp_territories.attribute5%type;

188: l_attribute1 jtf_rs_srp_territories.attribute1%type;
189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;

Line 193: l_attribute6 jtf_rs_srp_territories.attribute6%type;

189: l_attribute2 jtf_rs_srp_territories.attribute2%type;
190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;

Line 194: l_attribute7 jtf_rs_srp_territories.attribute7%type;

190: l_attribute3 jtf_rs_srp_territories.attribute3%type;
191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;

Line 195: l_attribute8 jtf_rs_srp_territories.attribute8%type;

191: l_attribute4 jtf_rs_srp_territories.attribute4%type;
192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;

Line 196: l_attribute9 jtf_rs_srp_territories.attribute9%type;

192: l_attribute5 jtf_rs_srp_territories.attribute5%type;
193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;

Line 197: l_attribute10 jtf_rs_srp_territories.attribute10%type;

193: l_attribute6 jtf_rs_srp_territories.attribute6%type;
194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;

Line 198: l_attribute11 jtf_rs_srp_territories.attribute11%type;

194: l_attribute7 jtf_rs_srp_territories.attribute7%type;
195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;

Line 199: l_attribute12 jtf_rs_srp_territories.attribute12%type;

195: l_attribute8 jtf_rs_srp_territories.attribute8%type;
196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;

Line 200: l_attribute13 jtf_rs_srp_territories.attribute13%type;

196: l_attribute9 jtf_rs_srp_territories.attribute9%type;
197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;
204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

Line 201: l_attribute14 jtf_rs_srp_territories.attribute14%type;

197: l_attribute10 jtf_rs_srp_territories.attribute10%type;
198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;
204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
205: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;

Line 202: l_attribute15 jtf_rs_srp_territories.attribute15%type;

198: l_attribute11 jtf_rs_srp_territories.attribute11%type;
199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;
204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
205: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
206: l_org_id number;

Line 203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;

199: l_attribute12 jtf_rs_srp_territories.attribute12%type;
200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;
204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
205: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
206: l_org_id number;
207:

Line 204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

200: l_attribute13 jtf_rs_srp_territories.attribute13%type;
201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;
204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
205: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
206: l_org_id number;
207:
208: CURSOR c_salesrep_id IS

Line 205: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;

201: l_attribute14 jtf_rs_srp_territories.attribute14%type;
202: l_attribute15 jtf_rs_srp_territories.attribute15%type;
203: l_attribute_category jtf_rs_srp_territories.attribute_category%type;
204: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
205: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
206: l_org_id number;
207:
208: CURSOR c_salesrep_id IS
209: SELECT salesrep_id

Line 212: l_salesrep jtf_rs_srp_territories.salesrep_id%type ;

208: CURSOR c_salesrep_id IS
209: SELECT salesrep_id
210: FROM jtf_rs_salesreps
211: WHERE salesrep_id = l_salesrep_id;
212: l_salesrep jtf_rs_srp_territories.salesrep_id%type ;
213:
214: BEGIN
215: SAVEPOINT update_rs_srp_territories_pub;
216: x_return_status := fnd_api.g_ret_sts_success;

Line 273: FROM jtf_rs_srp_territories

269: END IF;
270: --End of Territory Id Validation
271:
272: SELECT salesrep_territory_id INTO l_salesrep_territory_id
273: FROM jtf_rs_srp_territories
274: WHERE salesrep_id = l_salesrep_id
275: AND territory_id = l_territory_id;
276:
277: --Call the private procedure for update

Line 279: jtf_rs_srp_territories_pvt.update_rs_srp_territories

275: AND territory_id = l_territory_id;
276:
277: --Call the private procedure for update
278:
279: jtf_rs_srp_territories_pvt.update_rs_srp_territories
280: (P_API_VERSION => 1,
281: P_INIT_MSG_LIST => fnd_api.g_false,
282: P_COMMIT => fnd_api.g_false,
283: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,

Line 322: END jtf_rs_srp_territories_pub;

318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
319:
320: END update_rs_srp_territories;
321:
322: END jtf_rs_srp_territories_pub;