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.
6 It provides procedures for managing resource salesrep territories, like
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
16 /* Procedure to create the resource salesrep territories
17 based on input values passed by calling routines. */
18
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,
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,
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,
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
53 based on input values passed by calling routines. */
54
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,
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,
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,
82 X_MSG_COUNT OUT NOCOPY NUMBER,
83 X_MSG_DATA OUT NOCOPY VARCHAR2
84 );
85
86 END jtf_rs_srp_territories_pvt;