1: PACKAGE jtf_rs_srp_territories_pvt AS
2: /* $Header: jtfrsvis.pls 120.0 2005/05/11 08:23:03 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.
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:
19: PROCEDURE create_rs_srp_territories
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
24: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
24: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
24: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
24: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
23: P_SALESREP_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_ID%TYPE,
24: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
24: P_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.TERRITORY_ID%TYPE,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
25: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
26: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
27: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
28: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
37: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT NULL,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
38: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT NULL,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
39: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT NULL,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
40: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT NULL,
41: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT NULL,
42: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT NULL,
43: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT NULL,
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
44: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
46: X_MSG_COUNT OUT NOCOPY NUMBER,
47: X_MSG_DATA OUT NOCOPY VARCHAR2,
48: X_SALESREP_TERRITORY_ID OUT NOCOPY JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE
49: );
50:
51:
52: /* Procedure to update the resource salesrep territories
55: PROCEDURE update_rs_srp_territories
56: (P_API_VERSION IN NUMBER,
57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
60: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
56: (P_API_VERSION IN NUMBER,
57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
60: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
57: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
60: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
58: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
60: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
59: P_SALESREP_TERRITORY_ID IN JTF_RS_SRP_TERRITORIES.SALESREP_TERRITORY_ID%TYPE,
60: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
60: P_STATUS IN JTF_RS_SRP_TERRITORIES.STATUS%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
61: P_WH_UPDATE_DATE IN JTF_RS_SRP_TERRITORIES.WH_UPDATE_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
62: P_START_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_END_DATE_ACTIVE IN JTF_RS_SRP_TERRITORIES.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_SRP_TERRITORIES.OBJECT_VERSION_NUMBER%TYPE,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
65: P_ATTRIBUTE2 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
66: P_ATTRIBUTE3 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_ATTRIBUTE4 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
68: P_ATTRIBUTE5 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE6 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE7 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE8 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE9 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE1 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
74: P_ATTRIBUTE10 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
82: X_MSG_COUNT OUT NOCOPY NUMBER,
75: P_ATTRIBUTE11 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
82: X_MSG_COUNT OUT NOCOPY NUMBER,
83: X_MSG_DATA OUT NOCOPY VARCHAR2
76: P_ATTRIBUTE12 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE13 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE14 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE15 IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE_CATEGORY IN JTF_RS_SRP_TERRITORIES.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
82: X_MSG_COUNT OUT NOCOPY NUMBER,
83: X_MSG_DATA OUT NOCOPY VARCHAR2
84: );
82: X_MSG_COUNT OUT NOCOPY NUMBER,
83: X_MSG_DATA OUT NOCOPY VARCHAR2
84: );
85:
86: END jtf_rs_srp_territories_pvt;