1 Package JTF_TERR_SALES_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptsas.pls 120.0 2005/06/02 18:20:56 appldev ship $ */
3 ---------------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_SALES_TERRITORY_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core Sales territory manager public api's.
10 -- This package is a public API for getting winning territories
11 -- or territory resources.
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package is publicly available for use
18 --
19 -- HISTORY
20 -- 09/14/99 VNEDUNGA Created
21 -- 12/22/99 vnedunga Making chnages to filter
22 -- resource by resource type
23 --
24 --
25 -- End of Comments
26 --
27 -- ***************************************************
28 -- GLOBAL VARIABLES
29 -- ***************************************************
30
31
32 -- ***************************************************
33 -- start of comments
34 -- ***************************************************
35 -- api name : Get_WinningTerrMembers
36 -- type : public.
37 -- function : Get winning territories members for an ACCOUNT
38 -- pre-reqs : Territories needs to be setup first
39 -- requirements :
40 -- business rules :
41
42 -- version : current version 1.0
43 -- initial version: initial version 1.0
44 --
45 -- notes: Public API for retreving a set of winning
46 -- territories resources. This is an overloaded
47 -- procedure for accounts,lead, oppor, service
48 -- requests, and collections.
49 --
50 -- end of comments
51 procedure Get_WinningTerrMembers
52 ( p_api_version_number IN number,
53 p_init_msg_list IN varchar2 := fnd_api.g_false,
54 p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type,
55 p_Resource_Type IN varchar2,
56 p_Role IN varchar2,
57 x_return_status OUT NOCOPY varchar2,
58 x_msg_count OUT NOCOPY number,
59 X_msg_data OUT NOCOPY varchar2,
60 x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
61 );
62
63
64 -- ***************************************************
65 -- start of comments
66 -- ***************************************************
67 -- api name : Get_WinningTerrMembers ### BULK ###
68 -- type : public.
69 -- function : Get winning territories members for an ACCOUNT
70 -- pre-reqs : Territories needs to be setup first
71 -- requirements :
72 -- business rules :
73
74 -- version : current version 1.0
75 -- initial version: initial version 1.0
76 --
77 -- notes: Public API for retreving a set of winning
78 -- territories resources. This is an overloaded
79 -- procedure for accounts,lead, oppor, service
80 -- requests, and collections.
81 --
82 -- end of comments
83 procedure Get_WinningTerrMembers
84 ( p_api_version_number IN number,
85 p_init_msg_list IN varchar2 := fnd_api.g_false,
86 p_TerrAccount_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
87 p_Resource_Type IN varchar2,
88 p_Role IN varchar2,
89 x_return_status OUT NOCOPY varchar2,
90 x_msg_count OUT NOCOPY number,
91 X_msg_data OUT NOCOPY varchar2,
92 x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
93 p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
94 p_num_winners IN NUMBER := FND_API.G_MISS_NUM
95 );
96
97
98 -- Start of Comments
99 -- ***************************************************
100 -- start of comments
101 -- ***************************************************
102 -- api name : Get_WinningTerritories
103 -- type : public.
104 -- function : Get the WINNING territories for an ACCOUNT
105 -- pre-reqs : Territories needs to be setup first
106 -- requirements :
107 -- business rules :
108 -- version : current version 1.0
109 -- initial version: initial version 1.0
110 --
111 -- notes: Public API for retrieving the winning territories
112 -- This is an overloaded procedure for accounts,lead,
113 -- opportunity, service requests, and collections.
114 --
115 --
116 -- end of comments
117 procedure Get_WinningTerritories
118 ( p_api_version_number IN number,
119 p_init_msg_list IN varchar2 := fnd_api.g_false,
120 x_return_status OUT NOCOPY varchar2,
121 x_msg_count OUT NOCOPY number,
122 X_msg_data OUT NOCOPY varchar2,
123 p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_rec_type
124 );
125
126 --
127 -- Start of Comments
128 -- ***************************************************
129 -- start of comments
130 -- ***************************************************
131 -- api name : Get_WinningTerritories ### BULK ###
132 -- type : public.
133 -- function : Get the WINNING territories for an ACCOUNT
134 -- pre-reqs : Territories needs to be setup first
135 -- requirements :
136 -- business rules :
137 -- version : current version 1.0
138 -- initial version: initial version 1.0
139 --
140 -- notes: Public API for retrieving the winning territories
141 -- This is an overloaded procedure for accounts,lead,
142 -- opportunity, service requests, and collections.
143 --
144 --
145 -- end of comments
146
147 procedure Get_WinningTerritories
148 ( p_api_version_number IN number,
149 p_init_msg_list IN varchar2 := fnd_api.g_false,
150 x_return_status OUT NOCOPY varchar2,
151 x_msg_count OUT NOCOPY number,
152 X_msg_data OUT NOCOPY varchar2,
153 p_TerrAcct_Rec IN JTF_TERRITORY_PUB.JTF_Account_BULK_rec_type,
154 x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.Winning_BULK_rec_type,
155 p_top_level_terr_id IN NUMBER := FND_API.G_MISS_NUM,
156 p_num_winners IN NUMBER := FND_API.G_MISS_NUM,
157 p_role IN VARCHAR2 := FND_API.G_MISS_CHAR
158 );
159
160
161 /*========================================================================================*/
162 /*========================= OPPORTUNITY ==================================================*/
163 /*========================================================================================*/
164
165 -- ***************************************************
166 -- start of comments
167 -- ***************************************************
168 -- api name : Get_WinningTerrMembers - ### SINGLE ###
169 -- type : public.
170 -- function : Get winning territories members for an OPPORTUNITY
171 -- pre-reqs : Territories needs to be setup first
172 -- requirements :
173 -- business rules :
174
175 -- version : current version 1.0
176 -- initial version: initial version 1.0
177 --
178 -- notes: Public API for retreving a set of winning
179 -- territories resources. This is an overloaded
180 -- procedure for accounts,lead, oppor, service
181 -- requests, and collections.
182 --
183 -- end of comments
184 procedure Get_WinningTerrMembers
185 ( p_api_version_number IN number,
186 p_init_msg_list IN varchar2 := fnd_api.g_false,
187 p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_rec_type,
188 p_Resource_Type IN varchar2,
189 p_Role IN varchar2,
190 x_return_status OUT NOCOPY varchar2,
191 x_msg_count OUT NOCOPY number,
192 X_msg_data OUT NOCOPY varchar2,
193 x_TerrResource_tbl OUT NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
194 ) ;
195
196 -- ***************************************************
197 -- start of comments
198 -- ***************************************************
199 -- api name : Get_WinningTerrMembers - ### BULK ###
200 -- type : public.
201 -- function : Get winning territories members for an OPPORTUNITY
202 -- pre-reqs : Territories needs to be setup first
203 -- requirements :
204 -- business rules :
205
206 -- version : current version 1.0
207 -- initial version: initial version 1.0
208 --
209 -- notes: Public API for retreving a set of winning
210 -- territories resources. This is an overloaded
211 -- procedure for accounts,lead, oppor, service
212 -- requests, and collections.
213 --
214 -- end of comments
215 procedure Get_WinningTerrMembers
216 ( p_api_version_number IN number,
217 p_init_msg_list IN varchar2 := fnd_api.g_false,
218 p_TerrOppor_Rec IN JTF_TERRITORY_PUB.JTF_Oppor_BULK_rec_type,
219 p_Resource_Type IN varchar2,
220 p_Role IN varchar2,
221 x_return_status OUT NOCOPY varchar2,
222 x_msg_count OUT NOCOPY number,
223 X_msg_data OUT NOCOPY varchar2,
224 x_winners_rec OUT NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE
225 );
226
227
228 /*========================================================================================*/
229 /*========================= LEAD =========================================================*/
230 /*========================================================================================*/
231
232
233 -- ***************************************************
234 -- start of comments
235 -- ***************************************************
236 -- api name : Get_WinningTerrMembers ### SINGLE ###
237 -- type : public.
238 -- function : Get winning territories members for a LEAD
239 -- pre-reqs : Territories needs to be setup first
240 -- requirements :
241 -- business rules :
242
243 -- version : current version 1.0
244 -- initial version: initial version 1.0
245 --
246 -- notes: Public API for retreving a set of winning
247 -- territories resources. This is an overloaded
248 -- procedure for accounts,lead, oppor, service
249 -- requests, and collections.
250 --
251 -- end of comments
252 procedure Get_WinningTerrMembers
253 ( p_api_version_number IN number,
254 p_init_msg_list IN varchar2 := fnd_api.g_false,
255 p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_rec_type,
256 p_Resource_Type IN varchar2,
257 p_Role IN varchar2,
258 x_return_status OUT NOCOPY varchar2,
259 x_msg_count OUT NOCOPY number,
260 X_msg_data OUT NOCOPY varchar2,
261 x_TerrResource_tbl out NOCOPY JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
262 );
263
264 -- ***************************************************
265 -- start of comments
266 -- ***************************************************
267 -- api name : Get_WinningTerrMembers - ### BULK ###
268 -- type : public.
269 -- function : Get winning territories members for a LEAD
270 -- pre-reqs : Territories needs to be setup first
271 -- requirements :
272 -- business rules :
273
274 -- version : current version 1.0
275 -- initial version: initial version 1.0
276 --
277 -- notes: Public API for retreving a set of winning
278 -- territories resources. This is an overloaded
279 -- procedure for accounts,lead, oppor, service
280 -- requests, and collections.
281 --
282 -- end of comments
283 procedure Get_WinningTerrMembers
284 ( p_api_version_number IN number,
285 p_init_msg_list IN varchar2 := fnd_api.g_false,
286 p_TerrLead_Rec IN JTF_TERRITORY_PUB.JTF_Lead_BULK_rec_type,
287 p_Resource_Type IN varchar2,
288 p_Role IN varchar2,
289 x_return_status OUT NOCOPY varchar2,
290 x_msg_count OUT NOCOPY number,
291 X_msg_data OUT NOCOPY varchar2,
292 x_winners_rec out NOCOPY JTF_TERRITORY_PUB.WINNING_BULK_REC_TYPE
293 );
294
295
296
297 END JTF_TERR_SALES_PUB;