1 Package JTF_TTY_WebADI_Salsteam_update AS
2 /* $Header: jtfvstus.pls 120.2 2005/09/22 21:13:58 shli ship $ */
3 -- Start of Comments
4 -- ---------------------------------------------------
5 -- PURPOSE
6 -- upload named account territory resource information into excel
7 --
8 --
9 -- PROCEDURES:
10 -- (see below for specification)
11 --
12 -- NOTES
13 -- This package is for PRIVATE USE ONLY use
14 --
15 -- HISTORY
16 -- 05/17/2003 sbehera Package Created
17 -- End of Comments
18 --
19
20 G_USER CONSTANT VARCHAR2(60):=FND_GLOBAL.USER_ID;
21
22
23
24 PROCEDURE POPULATE_SALES_TEAM (
25 --P_USER_SEQUENCE in varchar2,
26 P_NAMED_ACCOUNT in varchar2,
27 P_SITE_TYPE in varchar2,
28 P_TRADE_NAME in varchar2,
29 P_DUNS in varchar2,
30 P_GU_DUNS in varchar2,
31 P_GU_NAME in varchar2,
32 P_CITY in varchar2,
33 P_STATE in varchar2,
34 P_PROVINCE in varchar2,
35 P_POSTAL_CODE in varchar2,
36 P_TERRITORY_GROUP in varchar2,
37 P_RESOURCE1_NAME in varchar2,
38 P_GROUP1_NAME in varchar2,
39 P_ROLE1_NAME in varchar2,
40 P_RESOURCE2_NAME in varchar2,
41 P_GROUP2_NAME in varchar2,
42 P_ROLE2_NAME in varchar2,
43 P_RESOURCE3_NAME in varchar2,
44 P_GROUP3_NAME in varchar2,
45 P_ROLE3_NAME in varchar2,
46 P_RESOURCE4_NAME in varchar2,
47 P_GROUP4_NAME in varchar2,
48 P_ROLE4_NAME in varchar2,
49 P_RESOURCE5_NAME in varchar2,
50 P_GROUP5_NAME in varchar2,
51 P_ROLE5_NAME in varchar2,
52 P_RESOURCE6_NAME in varchar2,
53 P_GROUP6_NAME in varchar2,
54 P_ROLE6_NAME in varchar2,
55 P_RESOURCE7_NAME in varchar2,
56 P_GROUP7_NAME in varchar2,
57 P_ROLE7_NAME in varchar2,
58 P_RESOURCE8_NAME in varchar2,
59 P_GROUP8_NAME in varchar2,
60 P_ROLE8_NAME in varchar2,
61 P_RESOURCE9_NAME in varchar2,
62 P_GROUP9_NAME in varchar2,
63 P_ROLE9_NAME in varchar2,
64 P_RESOURCE10_NAME in varchar2,
65 P_GROUP10_NAME in varchar2,
66 P_ROLE10_NAME in varchar2,
67 P_RESOURCE11_NAME in varchar2,
68 P_GROUP11_NAME in varchar2,
69 P_ROLE11_NAME in varchar2,
70 P_RESOURCE12_NAME in varchar2,
71 P_GROUP12_NAME in varchar2,
72 P_ROLE12_NAME in varchar2,
73 P_RESOURCE13_NAME in varchar2,
74 P_GROUP13_NAME in varchar2,
75 P_ROLE13_NAME in varchar2,
76 P_RESOURCE14_NAME in varchar2,
77 P_GROUP14_NAME in varchar2,
78 P_ROLE14_NAME in varchar2,
79 P_RESOURCE15_NAME in varchar2,
80 P_GROUP15_NAME in varchar2,
81 P_ROLE15_NAME in varchar2,
82 P_RESOURCE16_NAME in varchar2,
83 P_GROUP16_NAME in varchar2,
84 P_ROLE16_NAME in varchar2,
85 P_RESOURCE17_NAME in varchar2,
86 P_GROUP17_NAME in varchar2,
87 P_ROLE17_NAME in varchar2,
88 P_RESOURCE18_NAME in varchar2,
89 P_GROUP18_NAME in varchar2,
90 P_ROLE18_NAME in varchar2,
91 P_RESOURCE19_NAME in varchar2,
92 P_GROUP19_NAME in varchar2,
93 P_ROLE19_NAME in varchar2,
94 P_RESOURCE20_NAME in varchar2,
95 P_GROUP20_NAME in varchar2,
96 P_ROLE20_NAME in varchar2,
97 P_RESOURCE21_NAME in varchar2,
98 P_GROUP21_NAME in varchar2,
99 P_ROLE21_NAME in varchar2,
100 P_RESOURCE22_NAME in varchar2,
101 P_GROUP22_NAME in varchar2,
102 P_ROLE22_NAME in varchar2,
103 P_RESOURCE23_NAME in varchar2,
104 P_GROUP23_NAME in varchar2,
105 P_ROLE23_NAME in varchar2,
106 P_RESOURCE24_NAME in varchar2,
107 P_GROUP24_NAME in varchar2,
108 P_ROLE24_NAME in varchar2,
109 P_RESOURCE25_NAME in varchar2,
110 P_GROUP25_NAME in varchar2,
111 P_ROLE25_NAME in varchar2,
112 P_RESOURCE26_NAME in varchar2,
113 P_GROUP26_NAME in varchar2,
114 P_ROLE26_NAME in varchar2,
115 P_RESOURCE27_NAME in varchar2,
116 P_GROUP27_NAME in varchar2,
117 P_ROLE27_NAME in varchar2,
118 P_RESOURCE28_NAME in varchar2,
119 P_GROUP28_NAME in varchar2,
120 P_ROLE28_NAME in varchar2,
121 P_RESOURCE29_NAME in varchar2,
122 P_GROUP29_NAME in varchar2,
123 P_ROLE29_NAME in varchar2,
124 P_RESOURCE30_NAME in varchar2,
125 P_GROUP30_NAME in varchar2,
126 P_ROLE30_NAME in varchar2,
127 P_TERR_GRP_ACCT_ID in varchar2
128 );
129
130 PROCEDURE POPULATE_ALIGNMENT (
131 --P_USER_SEQUENCE in varchar2,
132 P_NAMED_ACCOUNT in varchar2,
133 P_SITE_TYPE in varchar2,
134 P_TRADE_NAME in varchar2,
135 P_DUNS in varchar2,
136 P_GU_DUNS in varchar2,
137 P_GU_NAME in varchar2,
138 P_CITY in varchar2,
139 P_STATE in varchar2,
140 P_PROVINCE in varchar2,
141 P_POSTAL_CODE in varchar2,
142 P_DNB_ANNUAL_REV in varchar2,
143 P_DNB_NUM_OF_EMP in varchar2,
144 P_PRIOR_WON in varchar2,
145 P_TERRITORY_GROUP in varchar2,
146 P_RESOURCE1_NAME in varchar2,
147 P_GROUP1_NAME in varchar2,
148 P_ROLE1_NAME in varchar2,
149 P_RESOURCE2_NAME in varchar2,
150 P_GROUP2_NAME in varchar2,
151 P_ROLE2_NAME in varchar2,
152 P_RESOURCE3_NAME in varchar2,
153 P_GROUP3_NAME in varchar2,
154 P_ROLE3_NAME in varchar2,
155 P_RESOURCE4_NAME in varchar2,
156 P_GROUP4_NAME in varchar2,
157 P_ROLE4_NAME in varchar2,
158 P_RESOURCE5_NAME in varchar2,
159 P_GROUP5_NAME in varchar2,
160 P_ROLE5_NAME in varchar2,
161 P_RESOURCE6_NAME in varchar2,
162 P_GROUP6_NAME in varchar2,
163 P_ROLE6_NAME in varchar2,
164 P_RESOURCE7_NAME in varchar2,
165 P_GROUP7_NAME in varchar2,
166 P_ROLE7_NAME in varchar2,
167 P_RESOURCE8_NAME in varchar2,
168 P_GROUP8_NAME in varchar2,
169 P_ROLE8_NAME in varchar2,
170 P_RESOURCE9_NAME in varchar2,
171 P_GROUP9_NAME in varchar2,
172 P_ROLE9_NAME in varchar2,
173 P_RESOURCE10_NAME in varchar2,
174 P_GROUP10_NAME in varchar2,
175 P_ROLE10_NAME in varchar2,
176 P_RESOURCE11_NAME in varchar2,
177 P_GROUP11_NAME in varchar2,
178 P_ROLE11_NAME in varchar2,
179 P_RESOURCE12_NAME in varchar2,
180 P_GROUP12_NAME in varchar2,
181 P_ROLE12_NAME in varchar2,
182 P_RESOURCE13_NAME in varchar2,
183 P_GROUP13_NAME in varchar2,
184 P_ROLE13_NAME in varchar2,
185 P_RESOURCE14_NAME in varchar2,
186 P_GROUP14_NAME in varchar2,
187 P_ROLE14_NAME in varchar2,
188 P_RESOURCE15_NAME in varchar2,
189 P_GROUP15_NAME in varchar2,
190 P_ROLE15_NAME in varchar2,
191 P_RESOURCE16_NAME in varchar2,
192 P_GROUP16_NAME in varchar2,
193 P_ROLE16_NAME in varchar2,
194 P_RESOURCE17_NAME in varchar2,
195 P_GROUP17_NAME in varchar2,
196 P_ROLE17_NAME in varchar2,
197 P_RESOURCE18_NAME in varchar2,
198 P_GROUP18_NAME in varchar2,
199 P_ROLE18_NAME in varchar2,
200 P_RESOURCE19_NAME in varchar2,
201 P_GROUP19_NAME in varchar2,
202 P_ROLE19_NAME in varchar2,
203 P_RESOURCE20_NAME in varchar2,
204 P_GROUP20_NAME in varchar2,
205 P_ROLE20_NAME in varchar2,
206 P_RESOURCE21_NAME in varchar2,
207 P_GROUP21_NAME in varchar2,
208 P_ROLE21_NAME in varchar2,
209 P_RESOURCE22_NAME in varchar2,
210 P_GROUP22_NAME in varchar2,
211 P_ROLE22_NAME in varchar2,
212 P_RESOURCE23_NAME in varchar2,
213 P_GROUP23_NAME in varchar2,
214 P_ROLE23_NAME in varchar2,
215 P_RESOURCE24_NAME in varchar2,
216 P_GROUP24_NAME in varchar2,
217 P_ROLE24_NAME in varchar2,
218 P_RESOURCE25_NAME in varchar2,
219 P_GROUP25_NAME in varchar2,
220 P_ROLE25_NAME in varchar2,
221 P_RESOURCE26_NAME in varchar2,
222 P_GROUP26_NAME in varchar2,
223 P_ROLE26_NAME in varchar2,
224 P_RESOURCE27_NAME in varchar2,
225 P_GROUP27_NAME in varchar2,
226 P_ROLE27_NAME in varchar2,
227 P_RESOURCE28_NAME in varchar2,
228 P_GROUP28_NAME in varchar2,
229 P_ROLE28_NAME in varchar2,
230 P_RESOURCE29_NAME in varchar2,
231 P_GROUP29_NAME in varchar2,
232 P_ROLE29_NAME in varchar2,
233 P_RESOURCE30_NAME in varchar2,
234 P_GROUP30_NAME in varchar2,
235 P_ROLE30_NAME in varchar2,
236 P_TERR_GRP_ACCT_ID in varchar2,
237 P_ALIGNMENT_ID in varchar2);
238
239
240
241 /*
242 PROCEDURE POPULATE_SALES_ALIGN (
243 P_USER_SEQUENCE in varchar2,
244 P_NAMED_ACCOUNT in varchar2,
245 P_TERRITORY_GROUP in varchar2,
246 P_RESOURCE1_NAME in varchar2,
247 P_GROUP1_NAME in varchar2,
248 P_ROLE1_NAME in varchar2,
249 P_RESOURCE2_NAME in varchar2,
250 P_GROUP2_NAME in varchar2,
251 P_ROLE2_NAME in varchar2,
252 P_RESOURCE3_NAME in varchar2,
253 P_GROUP3_NAME in varchar2,
254 P_ROLE3_NAME in varchar2,
255 P_RESOURCE4_NAME in varchar2,
256 P_GROUP4_NAME in varchar2,
257 P_ROLE4_NAME in varchar2,
258 P_RESOURCE5_NAME in varchar2,
259 P_GROUP5_NAME in varchar2,
260 P_ROLE5_NAME in varchar2,
261 P_RESOURCE6_NAME in varchar2,
262 P_GROUP6_NAME in varchar2,
263 P_ROLE6_NAME in varchar2,
264 P_RESOURCE7_NAME in varchar2,
265 P_GROUP7_NAME in varchar2,
266 P_ROLE7_NAME in varchar2,
267 P_RESOURCE8_NAME in varchar2,
268 P_GROUP8_NAME in varchar2,
269 P_ROLE8_NAME in varchar2,
270 P_RESOURCE9_NAME in varchar2,
271 P_GROUP9_NAME in varchar2,
272 P_ROLE9_NAME in varchar2,
273 P_RESOURCE10_NAME in varchar2,
274 P_GROUP10_NAME in varchar2,
275 P_ROLE10_NAME in varchar2,
276 P_RESOURCE11_NAME in varchar2,
277 P_GROUP11_NAME in varchar2,
278 P_ROLE11_NAME in varchar2,
279 P_RESOURCE12_NAME in varchar2,
280 P_GROUP12_NAME in varchar2,
281 P_ROLE12_NAME in varchar2,
282 P_RESOURCE13_NAME in varchar2,
283 P_GROUP13_NAME in varchar2,
284 P_ROLE13_NAME in varchar2,
285 P_RESOURCE14_NAME in varchar2,
286 P_GROUP14_NAME in varchar2,
287 P_ROLE14_NAME in varchar2,
288 P_RESOURCE15_NAME in varchar2,
289 P_GROUP15_NAME in varchar2,
290 P_ROLE15_NAME in varchar2,
291 P_RESOURCE16_NAME in varchar2,
292 P_GROUP16_NAME in varchar2,
293 P_ROLE16_NAME in varchar2,
294 P_RESOURCE17_NAME in varchar2,
295 P_GROUP17_NAME in varchar2,
296 P_ROLE17_NAME in varchar2,
297 P_RESOURCE18_NAME in varchar2,
298 P_GROUP18_NAME in varchar2,
299 P_ROLE18_NAME in varchar2,
300 P_RESOURCE19_NAME in varchar2,
301 P_GROUP19_NAME in varchar2,
302 P_ROLE19_NAME in varchar2,
303 P_RESOURCE20_NAME in varchar2,
304 P_GROUP20_NAME in varchar2,
305 P_ROLE20_NAME in varchar2,
306 P_RESOURCE21_NAME in varchar2,
307 P_GROUP21_NAME in varchar2,
308 P_ROLE21_NAME in varchar2,
309 P_RESOURCE22_NAME in varchar2,
310 P_GROUP22_NAME in varchar2,
311 P_ROLE22_NAME in varchar2,
312 P_RESOURCE23_NAME in varchar2,
313 P_GROUP23_NAME in varchar2,
314 P_ROLE23_NAME in varchar2,
315 P_RESOURCE24_NAME in varchar2,
316 P_GROUP24_NAME in varchar2,
317 P_ROLE24_NAME in varchar2,
318 P_RESOURCE25_NAME in varchar2,
319 P_GROUP25_NAME in varchar2,
320 P_ROLE25_NAME in varchar2,
321 P_RESOURCE26_NAME in varchar2,
322 P_GROUP26_NAME in varchar2,
323 P_ROLE26_NAME in varchar2,
324 P_RESOURCE27_NAME in varchar2,
325 P_GROUP27_NAME in varchar2,
326 P_ROLE27_NAME in varchar2,
327 P_RESOURCE28_NAME in varchar2,
328 P_GROUP28_NAME in varchar2,
329 P_ROLE28_NAME in varchar2,
330 P_RESOURCE29_NAME in varchar2,
331 P_GROUP29_NAME in varchar2,
332 P_ROLE29_NAME in varchar2,
333 P_RESOURCE30_NAME in varchar2,
334 P_GROUP30_NAME in varchar2,
335 P_ROLE30_NAME in varchar2,
336 P_TERR_GRP_ACCT_ID in varchar2,
337 P_ALIGNMENT_FLAG in varchar2,
338 P_ALIGNMENT_ID in varchar2);
339 */
340
341 PROCEDURE validate_resource (
342 P_RESOURCE_NAME in varchar2,
343 P_GROUP_NAME in varchar2,
344 P_ROLE_NAME in varchar2,
345 P_terr_group_id in number,
346 P_named_account_id in number,
347 P_TERR_GRP_ACCT_ID in number,
348 p_alignment_id in varchar2,
349 X_RESOURCE_id out NOCOPY number,
350 x_group_id out NOCOPY number,
351 x_role_code out NOCOPY varchar2,
352 x_error_code out NOCOPY number,
353 x_status out NOCOPY varchar2);
354
355
356
357 END JTF_TTY_WEBADI_Salsteam_update;
358