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

Line 1: PACKAGE BODY jtf_rs_srp_territories_pvt AS

1: PACKAGE BODY jtf_rs_srp_territories_pvt AS
2: /* $Header: jtfrsvib.pls 120.0 2005/05/11 08:23:02 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.

Line 11: Calls to these procedures will invoke calls to table handlers (jtf_rs_srp_territories_pkg)

7: create and update resource salesrep territories, from other modules.
8: Its main procedures are as following:
9: Create Resource Salesrep Territories
10: Update Resource Salesrep Territories
11: Calls to these procedures will invoke calls to table handlers (jtf_rs_srp_territories_pkg)
12: which do the actual inserts, updates and deletes into tables.
13: ******************************************************************************************/
14:
15: /* Package variables. */

Line 17: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_SRP_TERRITORIES_PVT';

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

Line 26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,

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

Line 27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,

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

Line 28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

24: P_INIT_MSG_LIST IN VARCHAR2,
25: P_COMMIT IN VARCHAR2,
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,

Line 29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

25: P_COMMIT IN VARCHAR2,
26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,

Line 30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

26: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,

Line 31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

27: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,

Line 32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,

28: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,

Line 33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,

29: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,

Line 34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,

30: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,

Line 35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,

31: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,

Line 36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,

32: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,

Line 37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,

33: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,

Line 38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,

34: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,

Line 39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,

35: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,

Line 40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,

36: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,

Line 41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,

37: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,

Line 42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,

38: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,

Line 43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,

39: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,

Line 44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,

40: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,

41: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,

42: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,

43: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
44: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
45: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
46: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,
51: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE

Line 51: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE

47: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
48: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
49: X_MSG_COUNT OUT NOCOPY NUMBER,
50: X_MSG_DATA OUT NOCOPY VARCHAR2,
51: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
52: )IS
53:
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';

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

53:
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
56: l_rowid ROWID;
57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;

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

54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
56: l_rowid ROWID;
57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;

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

55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
56: l_rowid ROWID;
57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

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

56: l_rowid ROWID;
57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;

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

57: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type := p_salesrep_id;
58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;

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

58: l_territory_id jtf_rs_srp_territories.territory_id%type := p_territory_id;
59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;

Line 63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;

59: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;

Line 64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;

60: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;

Line 65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;

61: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;

Line 66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;

62: l_status jtf_rs_srp_territories.status%type := p_status;
63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;

Line 67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;

63: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type;
64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;

Line 68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;

64: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;

Line 69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;

65: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;

Line 70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;

66: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;

Line 71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;

67: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;

Line 72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;

68: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;

Line 73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;

69: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;

Line 74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;

70: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;

Line 75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;

71: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
79: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;

Line 76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;

72: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
79: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
80: l_msg_data VARCHAR2(2000);

Line 77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;

73: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
79: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
80: l_msg_data VARCHAR2(2000);
81: l_msg_count NUMBER;

Line 78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;

74: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
79: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
80: l_msg_data VARCHAR2(2000);
81: l_msg_count NUMBER;
82: l_salesrep_start_date DATE;

Line 79: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;

75: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
76: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
77: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
78: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
79: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
80: l_msg_data VARCHAR2(2000);
81: l_msg_count NUMBER;
82: l_salesrep_start_date DATE;
83: l_salesrep_end_date DATE;

Line 90: CURSOR c_jtf_rs_srp_territories( l_rowid IN ROWID ) IS

86: l_check_count NUMBER;
87: l_check_char VARCHAR2(1);
88: l_bind_data_id NUMBER;
89:
90: CURSOR c_jtf_rs_srp_territories( l_rowid IN ROWID ) IS
91: SELECT 'Y'
92: FROM jtf_rs_srp_territories
93: WHERE ROWID = l_rowid;
94:

Line 92: FROM jtf_rs_srp_territories

88: l_bind_data_id NUMBER;
89:
90: CURSOR c_jtf_rs_srp_territories( l_rowid IN ROWID ) IS
91: SELECT 'Y'
92: FROM jtf_rs_srp_territories
93: WHERE ROWID = l_rowid;
94:
95: CURSOR c_salesrep_details( l_salesrep_id IN NUMBER ) IS
96: SELECT start_date_active,

Line 126: 'JTF_RS_SRP_TERRITORIES_PVT',

122:
123: --Pre Call to the Customer Type User Hook
124:
125: IF jtf_usr_hks.ok_to_execute(
126: 'JTF_RS_SRP_TERRITORIES_PVT',
127: 'CREATE_RS_SRP_TERRITORIES',
128: 'B',
129: 'C')
130: THEN

Line 131: jtf_rs_srp_territories_cuhk.create_rs_srp_territories_pre(

127: 'CREATE_RS_SRP_TERRITORIES',
128: 'B',
129: 'C')
130: THEN
131: jtf_rs_srp_territories_cuhk.create_rs_srp_territories_pre(
132: P_SALESREP_ID => l_salesrep_id,
133: P_TERRITORY_ID => l_territory_id,
134: P_STATUS => l_status,
135: P_WH_UPDATE_DATE => l_wh_update_date,

Line 154: 'JTF_RS_SRP_TERRITORIES_PVT',

150:
151: --Pre Call to the Vertical Type User Hook
152:
153: IF jtf_usr_hks.ok_to_execute(
154: 'JTF_RS_SRP_TERRITORIES_PVT',
155: 'CREATE_RS_SRP_TERRITORIES',
156: 'B',
157: 'V')
158: THEN

Line 159: jtf_rs_srp_territories_vuhk.create_rs_srp_territories_pre(

155: 'CREATE_RS_SRP_TERRITORIES',
156: 'B',
157: 'V')
158: THEN
159: jtf_rs_srp_territories_vuhk.create_rs_srp_territories_pre(
160: P_SALESREP_ID => l_salesrep_id,
161: P_TERRITORY_ID => l_territory_id,
162: P_STATUS => l_status,
163: P_WH_UPDATE_DATE => l_wh_update_date,

Line 182: 'JTF_RS_SRP_TERRITORIES_PVT',

178:
179: --Pre Call to the Internal Type User Hook
180:
181: IF jtf_usr_hks.ok_to_execute(
182: 'JTF_RS_SRP_TERRITORIES_PVT',
183: 'CREATE_RS_SRP_TERRITORIES',
184: 'B',
185: 'I')
186: THEN

Line 187: jtf_rs_srp_territories_iuhk.create_rs_srp_territories_pre(

183: 'CREATE_RS_SRP_TERRITORIES',
184: 'B',
185: 'I')
186: THEN
187: jtf_rs_srp_territories_iuhk.create_rs_srp_territories_pre(
188: P_SALESREP_ID => l_salesrep_id,
189: P_TERRITORY_ID => l_territory_id,
190: P_STATUS => l_status,
191: P_WH_UPDATE_DATE => l_wh_update_date,

Line 212: FROM jtf_rs_srp_territories

208: l_check_count := 0;
209:
210: SELECT count(*)
211: INTO l_check_count
212: FROM jtf_rs_srp_territories
213: WHERE SALESREP_ID = l_salesrep_id
214: AND TERRITORY_ID = l_territory_id;
215:
216: IF l_check_count > 0 THEN

Line 321: SELECT jtf_rs_srp_territories_s.nextval

317: END IF;
318: END IF;
319:
320: --Get the next value of the Salesrep_Territory_Id from the sequence
321: SELECT jtf_rs_srp_territories_s.nextval
322: INTO l_salesrep_territory_id
323: FROM dual;
324:
325: --Insert the row into the table by calling the table handler

Line 326: jtf_rs_srp_territories_pkg.insert_row(

322: INTO l_salesrep_territory_id
323: FROM dual;
324:
325: --Insert the row into the table by calling the table handler
326: jtf_rs_srp_territories_pkg.insert_row(
327: X_ROWID => l_rowid,
328: X_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
329: X_SALESREP_ID => l_salesrep_id,
330: X_TERRITORY_ID => l_territory_id,

Line 359: OPEN c_jtf_rs_srp_territories(l_rowid);

355: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
356: );
357:
358: --dbms_output.put_line('Inserted Row');
359: OPEN c_jtf_rs_srp_territories(l_rowid);
360: FETCH c_jtf_rs_srp_territories INTO l_check_char;
361: IF c_jtf_rs_srp_territories%NOTFOUND THEN
362: --dbms_output.put_line('Error in Table Handler');
363: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 360: FETCH c_jtf_rs_srp_territories INTO l_check_char;

356: );
357:
358: --dbms_output.put_line('Inserted Row');
359: OPEN c_jtf_rs_srp_territories(l_rowid);
360: FETCH c_jtf_rs_srp_territories INTO l_check_char;
361: IF c_jtf_rs_srp_territories%NOTFOUND THEN
362: --dbms_output.put_line('Error in Table Handler');
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

Line 361: IF c_jtf_rs_srp_territories%NOTFOUND THEN

357:
358: --dbms_output.put_line('Inserted Row');
359: OPEN c_jtf_rs_srp_territories(l_rowid);
360: FETCH c_jtf_rs_srp_territories INTO l_check_char;
361: IF c_jtf_rs_srp_territories%NOTFOUND THEN
362: --dbms_output.put_line('Error in Table Handler');
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
365: fnd_msg_pub.add;

Line 366: CLOSE c_jtf_rs_srp_territories;

362: --dbms_output.put_line('Error in Table Handler');
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
365: fnd_msg_pub.add;
366: CLOSE c_jtf_rs_srp_territories;
367: RAISE fnd_api.g_exc_unexpected_error;
368: ELSE
369: --dbms_output.put_line('Salesrep Territory Successfully Created');
370: x_salesrep_territory_id := l_salesrep_territory_id;

Line 376: CLOSE c_jtf_rs_srp_territories;

372:
373: --Close the cursors
374: CLOSE c_salesrep_details;
375: CLOSE c_territory_details;
376: CLOSE c_jtf_rs_srp_territories;
377:
378: --Make the post processing call to the user hooks
379:
380: --Post Call to the Customer Type User Hook

Line 383: 'JTF_RS_SRP_TERRITORIES_PVT',

379:
380: --Post Call to the Customer Type User Hook
381:
382: IF jtf_usr_hks.ok_to_execute(
383: 'JTF_RS_SRP_TERRITORIES_PVT',
384: 'CREATE_RS_SRP_TERRITORIES',
385: 'A',
386: 'C')
387: THEN

Line 388: jtf_rs_srp_territories_cuhk.create_rs_srp_territories_post(

384: 'CREATE_RS_SRP_TERRITORIES',
385: 'A',
386: 'C')
387: THEN
388: jtf_rs_srp_territories_cuhk.create_rs_srp_territories_post(
389: P_SALESREP_ID => l_salesrep_id,
390: P_TERRITORY_ID => l_territory_id,
391: P_STATUS => l_status,
392: P_WH_UPDATE_DATE => l_wh_update_date,

Line 412: 'JTF_RS_SRP_TERRITORIES_PVT',

408:
409: --Post Call to the Vertical Type User Hook
410:
411: IF jtf_usr_hks.ok_to_execute(
412: 'JTF_RS_SRP_TERRITORIES_PVT',
413: 'CREATE_RS_SRP_TERRITORIES',
414: 'A',
415: 'V')
416: THEN

Line 417: jtf_rs_srp_territories_vuhk.create_rs_srp_territories_post(

413: 'CREATE_RS_SRP_TERRITORIES',
414: 'A',
415: 'V')
416: THEN
417: jtf_rs_srp_territories_vuhk.create_rs_srp_territories_post(
418: P_SALESREP_ID => l_salesrep_id,
419: P_TERRITORY_ID => l_territory_id,
420: P_STATUS => l_status,
421: P_WH_UPDATE_DATE => l_wh_update_date,

Line 441: 'JTF_RS_SRP_TERRITORIES_PVT',

437:
438: --Post Call to the Internal Type User Hook
439:
440: IF jtf_usr_hks.ok_to_execute(
441: 'JTF_RS_SRP_TERRITORIES_PVT',
442: 'CREATE_RS_SRP_TERRITORIES',
443: 'A',
444: 'I')
445: THEN

Line 446: jtf_rs_srp_territories_iuhk.create_rs_srp_territories_post(

442: 'CREATE_RS_SRP_TERRITORIES',
443: 'A',
444: 'I')
445: THEN
446: jtf_rs_srp_territories_iuhk.create_rs_srp_territories_post(
447: P_SALESREP_ID => l_salesrep_id,
448: P_TERRITORY_ID => l_territory_id,
449: P_STATUS => l_status,
450: P_WH_UPDATE_DATE => l_wh_update_date,

Line 469: 'JTF_RS_SRP_TERRITORIES_PVT',

465:
466: /* Standard call for Message Generation */
467:
468: IF jtf_usr_hks.ok_to_execute(
469: 'JTF_RS_SRP_TERRITORIES_PVT',
470: 'CREATE_RS_SRP_TERRITORIES',
471: 'M',
472: 'M')
473: THEN

Line 474: IF (jtf_rs_srp_territories_cuhk.ok_to_generate_msg(

470: 'CREATE_RS_SRP_TERRITORIES',
471: 'M',
472: 'M')
473: THEN
474: IF (jtf_rs_srp_territories_cuhk.ok_to_generate_msg(
475: p_salesrep_territory_id => l_salesrep_territory_id,
476: x_return_status => x_return_status) )
477: THEN
478:

Line 531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,

527: PROCEDURE update_rs_srp_territories(
528: P_API_VERSION IN NUMBER,
529: P_INIT_MSG_LIST IN VARCHAR2,
530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

Line 532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,

528: P_API_VERSION IN NUMBER,
529: P_INIT_MSG_LIST IN VARCHAR2,
530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,

Line 533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,

529: P_INIT_MSG_LIST IN VARCHAR2,
530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,

Line 534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,

530: P_COMMIT IN VARCHAR2,
531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,

Line 535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,

531: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,

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

532: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE,
533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,

Line 537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,

533: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE,
534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,

Line 538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,

534: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,

Line 539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,

535: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE,
536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,

Line 540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,

536: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,

Line 541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,

537: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE,
538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,

Line 542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,

538: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE,
539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,

Line 543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,

539: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE,
540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,

Line 544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,

540: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE,
541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,

Line 545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,

541: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE,
542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,

Line 546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,

542: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE,
543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,

Line 547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,

543: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE,
544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,

Line 548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,

544: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE,
545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
552: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,

Line 549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,

545: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE,
546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
552: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
553: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,

546: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE,
547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
552: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
553: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
554: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,

547: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE,
548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
552: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
553: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
554: X_MSG_COUNT OUT NOCOPY NUMBER,
555: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 552: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,

548: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE,
549: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE,
550: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE,
551: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE,
552: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE,
553: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
554: X_MSG_COUNT OUT NOCOPY NUMBER,
555: X_MSG_DATA OUT NOCOPY VARCHAR2
556: )IS

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

556: )IS
557:
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;

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

557:
558: l_api_version CONSTANT NUMBER := 1.0;
559: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;

Line 562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;

558: l_api_version CONSTANT NUMBER := 1.0;
559: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;

Line 563: l_territory_id jtf_rs_srp_territories.territory_id%type;

559: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RS_SRP_TERRITORIES';
560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;

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

560: l_status jtf_rs_srp_territories.status%type := p_status;
561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;

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

561: l_wh_update_date jtf_rs_srp_territories.wh_update_date%type := p_wh_update_date;
562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;

Line 566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;

562: l_salesrep_id jtf_rs_srp_territories.salesrep_id%type;
563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;

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

563: l_territory_id jtf_rs_srp_territories.territory_id%type;
564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;

Line 568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;

564: l_start_date_active jtf_rs_srp_territories.start_date_active%type := p_start_date_active;
565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;

Line 569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;

565: l_end_date_active jtf_rs_srp_territories.end_date_active%type := p_end_date_active;
566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;

Line 570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;

566: l_salesrep_territory_id jtf_rs_srp_territories.salesrep_territory_id%type := p_salesrep_territory_id;
567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;

Line 571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;

567: l_object_version_number jtf_rs_srp_territories.object_version_number%type := p_object_version_number;
568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;

Line 572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;

568: l_attribute1 jtf_rs_srp_territories.attribute1%type := p_attribute1;
569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;

Line 573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;

569: l_attribute2 jtf_rs_srp_territories.attribute2%type := p_attribute2;
570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;

Line 574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;

570: l_attribute3 jtf_rs_srp_territories.attribute3%type := p_attribute3;
571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;

Line 575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;

571: l_attribute4 jtf_rs_srp_territories.attribute4%type := p_attribute4;
572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;

Line 576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;

572: l_attribute5 jtf_rs_srp_territories.attribute5%type := p_attribute5;
573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;

Line 577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;

573: l_attribute6 jtf_rs_srp_territories.attribute6%type := p_attribute6;
574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;

Line 578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;

574: l_attribute7 jtf_rs_srp_territories.attribute7%type := p_attribute7;
575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;

Line 579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;

575: l_attribute8 jtf_rs_srp_territories.attribute8%type := p_attribute8;
576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
583: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;

Line 580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;

576: l_attribute9 jtf_rs_srp_territories.attribute9%type := p_attribute9;
577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
583: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
584: l_msg_data VARCHAR2(2000);

Line 581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;

577: l_attribute10 jtf_rs_srp_territories.attribute10%type := p_attribute10;
578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
583: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
584: l_msg_data VARCHAR2(2000);
585: l_msg_count NUMBER;

Line 582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;

578: l_attribute11 jtf_rs_srp_territories.attribute11%type := p_attribute11;
579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
583: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
584: l_msg_data VARCHAR2(2000);
585: l_msg_count NUMBER;
586: l_salesrep_start_date DATE;

Line 583: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;

579: l_attribute12 jtf_rs_srp_territories.attribute12%type := p_attribute12;
580: l_attribute13 jtf_rs_srp_territories.attribute13%type := p_attribute13;
581: l_attribute14 jtf_rs_srp_territories.attribute14%type := p_attribute14;
582: l_attribute15 jtf_rs_srp_territories.attribute15%type := p_attribute15;
583: l_attribute_category jtf_rs_srp_territories.attribute_category%type := p_attribute_category;
584: l_msg_data VARCHAR2(2000);
585: l_msg_count NUMBER;
586: l_salesrep_start_date DATE;
587: l_salesrep_end_date DATE;

Line 596: FROM jtf_rs_srp_territories

592: l_bind_data_id NUMBER;
593:
594: CURSOR c_salesrep_territory_id( l_salesrep_territory_id IN NUMBER) IS
595: SELECT salesrep_id, territory_id
596: FROM jtf_rs_srp_territories
597: WHERE salesrep_territory_id = l_salesrep_territory_id;
598:
599: CURSOR c_salesrep_territory_update( l_salesrep_territory_id IN NUMBER ) IS
600: SELECT

Line 621: FROM jtf_rs_srp_territories

617: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
618: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
619: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
620: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
621: FROM jtf_rs_srp_territories
622: WHERE salesrep_territory_id = l_salesrep_territory_id;
623:
624: salesrep_territory_rec c_salesrep_territory_update%ROWTYPE;
625:

Line 629: FROM jtf_rs_salesreps jrs, jtf_rs_srp_territories jst

625:
626: CURSOR c_salesrep_details( l_salesrep_territory_id IN NUMBER ) IS
627: SELECT jrs.start_date_active,
628: jrs.end_date_active
629: FROM jtf_rs_salesreps jrs, jtf_rs_srp_territories jst
630: WHERE jrs.salesrep_id = jst.salesrep_id
631: AND jst.salesrep_territory_id = l_salesrep_territory_id;
632:
633: CURSOR c_territory_details( l_salesrep_territory_id IN NUMBER ) IS

Line 636: FROM ra_territories rt, jtf_rs_srp_territories jst

632:
633: CURSOR c_territory_details( l_salesrep_territory_id IN NUMBER ) IS
634: SELECT rt.start_date_active,
635: rt.end_date_active
636: FROM ra_territories rt, jtf_rs_srp_territories jst
637: WHERE rt.territory_id = jst.territory_id
638: AND jst.salesrep_territory_id = l_salesrep_territory_id;
639:
640: BEGIN

Line 658: 'JTF_RS_SRP_TERRITORIES_PVT',

654:
655: --Pre Call to the Customer Type User Hook
656:
657: IF jtf_usr_hks.ok_to_execute(
658: 'JTF_RS_SRP_TERRITORIES_PVT',
659: 'UPDATE_RS_SRP_TERRITORIES',
660: 'B',
661: 'C')
662: THEN

Line 663: jtf_rs_srp_territories_cuhk.update_rs_srp_territories_pre(

659: 'UPDATE_RS_SRP_TERRITORIES',
660: 'B',
661: 'C')
662: THEN
663: jtf_rs_srp_territories_cuhk.update_rs_srp_territories_pre(
664: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
665: P_STATUS => l_status,
666: P_WH_UPDATE_DATE => l_wh_update_date,
667: P_START_DATE_ACTIVE => l_start_date_active,

Line 685: 'JTF_RS_SRP_TERRITORIES_PVT',

681:
682: --Pre Call to the Vertical Type User Hook
683:
684: IF jtf_usr_hks.ok_to_execute(
685: 'JTF_RS_SRP_TERRITORIES_PVT',
686: 'UPDATE_RS_SRP_TERRITORIES',
687: 'B',
688: 'V')
689: THEN

Line 690: jtf_rs_srp_territories_vuhk.update_rs_srp_territories_pre(

686: 'UPDATE_RS_SRP_TERRITORIES',
687: 'B',
688: 'V')
689: THEN
690: jtf_rs_srp_territories_vuhk.update_rs_srp_territories_pre(
691: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
692: P_STATUS => l_status,
693: P_WH_UPDATE_DATE => l_wh_update_date,
694: P_START_DATE_ACTIVE => l_start_date_active,

Line 712: 'JTF_RS_SRP_TERRITORIES_PVT',

708:
709: --Pre Call to the Internal Type User Hook
710:
711: IF jtf_usr_hks.ok_to_execute(
712: 'JTF_RS_SRP_TERRITORIES_PVT',
713: 'UPDATE_RS_SRP_TERRITORIES',
714: 'B',
715: 'I')
716: THEN

Line 717: jtf_rs_srp_territories_iuhk.update_rs_srp_territories_pre(

713: 'UPDATE_RS_SRP_TERRITORIES',
714: 'B',
715: 'I')
716: THEN
717: jtf_rs_srp_territories_iuhk.update_rs_srp_territories_pre(
718: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
719: P_STATUS => l_status,
720: P_WH_UPDATE_DATE => l_wh_update_date,
721: P_START_DATE_ACTIVE => l_start_date_active,

Line 869: jtf_rs_srp_territories_pkg.lock_row(

865: END IF;
866: END IF;
867:
868: --Lock the row in the table by calling the table handler
869: jtf_rs_srp_territories_pkg.lock_row(
870: X_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
871: X_OBJECT_VERSION_NUMBER => l_object_version_number
872: );
873:

Line 880: jtf_rs_srp_territories_pkg.update_row(

876:
877:
878: BEGIN
879: --Update the row in the table by calling the table handler
880: jtf_rs_srp_territories_pkg.update_row(
881: X_SALESREP_TERRITORY_ID => p_salesrep_territory_id,
882: X_SALESREP_ID => l_salesrep_id,
883: X_TERRITORY_ID => l_territory_id,
884: X_STATUS => salesrep_territory_rec.l_status,

Line 934: 'JTF_RS_SRP_TERRITORIES_PVT',

930:
931: --Post Call to the Customer Type User Hook
932:
933: IF jtf_usr_hks.ok_to_execute(
934: 'JTF_RS_SRP_TERRITORIES_PVT',
935: 'UPDATE_RS_SRP_TERRITORIES',
936: 'A',
937: 'C')
938: THEN

Line 939: jtf_rs_srp_territories_cuhk.update_rs_srp_territories_post(

935: 'UPDATE_RS_SRP_TERRITORIES',
936: 'A',
937: 'C')
938: THEN
939: jtf_rs_srp_territories_cuhk.update_rs_srp_territories_post(
940: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
941: P_STATUS => l_status,
942: P_WH_UPDATE_DATE => l_wh_update_date,
943: P_START_DATE_ACTIVE => l_start_date_active,

Line 961: 'JTF_RS_SRP_TERRITORIES_PVT',

957:
958: --Post Call to the Vertical Type User Hook
959:
960: IF jtf_usr_hks.ok_to_execute(
961: 'JTF_RS_SRP_TERRITORIES_PVT',
962: 'UPDATE_RS_SRP_TERRITORIES',
963: 'A',
964: 'V')
965: THEN

Line 966: jtf_rs_srp_territories_vuhk.update_rs_srp_territories_post(

962: 'UPDATE_RS_SRP_TERRITORIES',
963: 'A',
964: 'V')
965: THEN
966: jtf_rs_srp_territories_vuhk.update_rs_srp_territories_post(
967: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
968: P_STATUS => l_status,
969: P_WH_UPDATE_DATE => l_wh_update_date,
970: P_START_DATE_ACTIVE => l_start_date_active,

Line 988: 'JTF_RS_SRP_TERRITORIES_PVT',

984:
985: --Post Call to the Internal Type User Hook
986:
987: IF jtf_usr_hks.ok_to_execute(
988: 'JTF_RS_SRP_TERRITORIES_PVT',
989: 'UPDATE_RS_SRP_TERRITORIES',
990: 'A',
991: 'I')
992: THEN

Line 993: jtf_rs_srp_territories_iuhk.update_rs_srp_territories_post(

989: 'UPDATE_RS_SRP_TERRITORIES',
990: 'A',
991: 'I')
992: THEN
993: jtf_rs_srp_territories_iuhk.update_rs_srp_territories_post(
994: P_SALESREP_TERRITORY_ID => l_salesrep_territory_id,
995: P_STATUS => l_status,
996: P_WH_UPDATE_DATE => l_wh_update_date,
997: P_START_DATE_ACTIVE => l_start_date_active,

Line 1015: 'JTF_RS_SRP_TERRITORIES_PVT',

1011:
1012: /* Standard call for Message Generation */
1013:
1014: IF jtf_usr_hks.ok_to_execute(
1015: 'JTF_RS_SRP_TERRITORIES_PVT',
1016: 'UPDATE_RS_SRP_TERRITORIES',
1017: 'M',
1018: 'M')
1019: THEN

Line 1020: IF (jtf_rs_srp_territories_cuhk.ok_to_generate_msg(

1016: 'UPDATE_RS_SRP_TERRITORIES',
1017: 'M',
1018: 'M')
1019: THEN
1020: IF (jtf_rs_srp_territories_cuhk.ok_to_generate_msg(
1021: p_salesrep_territory_id => l_salesrep_territory_id,
1022: x_return_status => x_return_status) )
1023: THEN
1024:

Line 1071: END jtf_rs_srp_territories_pvt;

1067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1068:
1069: END update_rs_srp_territories;
1070:
1071: END jtf_rs_srp_territories_pvt;