[Home] [Help]
PACKAGE: APPS.JTF_ASSIGN_PUB_W
Source
1 package jtf_assign_pub_w as
2 /* $Header: jtfampws.pls 120.2 2006/06/27 12:02:18 abraina ship $ */
3 procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 );
9 procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10 , a1 out nocopy JTF_VARCHAR2_TABLE_100
11 , a2 out nocopy JTF_DATE_TABLE
12 , a3 out nocopy JTF_DATE_TABLE
13 , a4 out nocopy JTF_NUMBER_TABLE
14 );
15
16 procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
17 , a1 JTF_NUMBER_TABLE
18 , a2 JTF_VARCHAR2_TABLE_100
19 , a3 JTF_VARCHAR2_TABLE_100
20 , a4 JTF_DATE_TABLE
21 , a5 JTF_DATE_TABLE
22 , a6 JTF_NUMBER_TABLE
23 , a7 JTF_NUMBER_TABLE
24 , a8 JTF_VARCHAR2_TABLE_300
25 , a9 JTF_NUMBER_TABLE
26 , a10 JTF_NUMBER_TABLE
27 , a11 JTF_VARCHAR2_TABLE_100
28 , a12 JTF_VARCHAR2_TABLE_100
29 , a13 JTF_VARCHAR2_TABLE_100
30 , a14 JTF_VARCHAR2_TABLE_100
31 , a15 JTF_NUMBER_TABLE
32 , a16 JTF_VARCHAR2_TABLE_100
33 , a17 JTF_NUMBER_TABLE
34 , a18 JTF_VARCHAR2_TABLE_100
35 , a19 JTF_DATE_TABLE
36 , a20 JTF_DATE_TABLE
37 , a21 JTF_NUMBER_TABLE
38 , a22 JTF_VARCHAR2_TABLE_200
39 , a23 JTF_VARCHAR2_TABLE_100
40 , a24 JTF_NUMBER_TABLE
41 , a25 JTF_VARCHAR2_TABLE_100
42 , a26 JTF_VARCHAR2_TABLE_100
43 );
44 procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_NUMBER_TABLE
46 , a2 out nocopy JTF_VARCHAR2_TABLE_100
47 , a3 out nocopy JTF_VARCHAR2_TABLE_100
48 , a4 out nocopy JTF_DATE_TABLE
49 , a5 out nocopy JTF_DATE_TABLE
50 , a6 out nocopy JTF_NUMBER_TABLE
51 , a7 out nocopy JTF_NUMBER_TABLE
52 , a8 out nocopy JTF_VARCHAR2_TABLE_300
53 , a9 out nocopy JTF_NUMBER_TABLE
54 , a10 out nocopy JTF_NUMBER_TABLE
55 , a11 out nocopy JTF_VARCHAR2_TABLE_100
56 , a12 out nocopy JTF_VARCHAR2_TABLE_100
57 , a13 out nocopy JTF_VARCHAR2_TABLE_100
58 , a14 out nocopy JTF_VARCHAR2_TABLE_100
59 , a15 out nocopy JTF_NUMBER_TABLE
60 , a16 out nocopy JTF_VARCHAR2_TABLE_100
61 , a17 out nocopy JTF_NUMBER_TABLE
62 , a18 out nocopy JTF_VARCHAR2_TABLE_100
63 , a19 out nocopy JTF_DATE_TABLE
64 , a20 out nocopy JTF_DATE_TABLE
65 , a21 out nocopy JTF_NUMBER_TABLE
66 , a22 out nocopy JTF_VARCHAR2_TABLE_200
67 , a23 out nocopy JTF_VARCHAR2_TABLE_100
68 , a24 out nocopy JTF_NUMBER_TABLE
69 , a25 out nocopy JTF_VARCHAR2_TABLE_100
70 , a26 out nocopy JTF_VARCHAR2_TABLE_100
71 );
72
73 procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74 , a1 JTF_VARCHAR2_TABLE_100
75 , a2 JTF_VARCHAR2_TABLE_100
76 , a3 JTF_VARCHAR2_TABLE_100
77 , a4 JTF_VARCHAR2_TABLE_100
78 );
79 procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80 , a1 out nocopy JTF_VARCHAR2_TABLE_100
81 , a2 out nocopy JTF_VARCHAR2_TABLE_100
82 , a3 out nocopy JTF_VARCHAR2_TABLE_100
83 , a4 out nocopy JTF_VARCHAR2_TABLE_100
84 );
85
86 procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
87 , a1 JTF_VARCHAR2_TABLE_100
88 , a2 JTF_VARCHAR2_TABLE_100
89 , a3 JTF_VARCHAR2_TABLE_100
90 );
91 procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92 , a1 out nocopy JTF_VARCHAR2_TABLE_100
93 , a2 out nocopy JTF_VARCHAR2_TABLE_100
94 , a3 out nocopy JTF_VARCHAR2_TABLE_100
95 );
96
97 procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
98 , a1 JTF_VARCHAR2_TABLE_100
99 );
100 procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101 , a1 out nocopy JTF_VARCHAR2_TABLE_100
102 );
103
104 procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
105 , a1 JTF_VARCHAR2_TABLE_100
106 );
107 procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108 , a1 out nocopy JTF_VARCHAR2_TABLE_100
109 );
110
111 procedure get_assign_resources(p_api_version NUMBER
112 , p_init_msg_list VARCHAR2
113 , p_commit VARCHAR2
114 , p_resource_id NUMBER
115 , p_resource_type VARCHAR2
116 , p_role VARCHAR2
117 , p_no_of_resources NUMBER
118 , p_auto_select_flag VARCHAR2
119 , p_contracts_preferred_engineer VARCHAR2
120 , p_ib_preferred_engineer VARCHAR2
121 , p_contract_id NUMBER
122 , p_customer_product_id NUMBER
123 , p_effort_duration NUMBER
124 , p_effort_uom VARCHAR2
125 , p_start_date date
126 , p_end_date date
127 , p_territory_flag VARCHAR2
128 , p_calendar_flag VARCHAR2
129 , p_web_availability_flag VARCHAR2
130 , p_category_id NUMBER
131 , p_inventory_item_id NUMBER
132 , p_inventory_org_id NUMBER
133 , p_problem_code VARCHAR2
134 , p_calling_doc_id NUMBER
135 , p_calling_doc_type VARCHAR2
136 , p_column_list VARCHAR2
137 , p_business_process_id NUMBER
138 , p_business_process_date date
139 , p_filter_excluded_resource VARCHAR2
140 , p32_a0 out nocopy JTF_NUMBER_TABLE
141 , p32_a1 out nocopy JTF_NUMBER_TABLE
142 , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
143 , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144 , p32_a4 out nocopy JTF_DATE_TABLE
145 , p32_a5 out nocopy JTF_DATE_TABLE
146 , p32_a6 out nocopy JTF_NUMBER_TABLE
147 , p32_a7 out nocopy JTF_NUMBER_TABLE
148 , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149 , p32_a9 out nocopy JTF_NUMBER_TABLE
150 , p32_a10 out nocopy JTF_NUMBER_TABLE
151 , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152 , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153 , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154 , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155 , p32_a15 out nocopy JTF_NUMBER_TABLE
156 , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157 , p32_a17 out nocopy JTF_NUMBER_TABLE
158 , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
159 , p32_a19 out nocopy JTF_DATE_TABLE
160 , p32_a20 out nocopy JTF_DATE_TABLE
161 , p32_a21 out nocopy JTF_NUMBER_TABLE
162 , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
163 , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
164 , p32_a24 out nocopy JTF_NUMBER_TABLE
165 , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
166 , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
167 , x_return_status out nocopy VARCHAR2
168 , x_msg_count out nocopy NUMBER
169 , x_msg_data out nocopy VARCHAR2
170 , p26_a0 NUMBER := 0-1962.0724
171 , p26_a1 NUMBER := 0-1962.0724
172 , p26_a2 VARCHAR2 := fnd_api.g_miss_char
173 , p26_a3 NUMBER := 0-1962.0724
174 , p26_a4 VARCHAR2 := fnd_api.g_miss_char
175 , p26_a5 VARCHAR2 := fnd_api.g_miss_char
176 , p26_a6 VARCHAR2 := fnd_api.g_miss_char
177 , p26_a7 VARCHAR2 := fnd_api.g_miss_char
178 , p26_a8 VARCHAR2 := fnd_api.g_miss_char
179 , p26_a9 VARCHAR2 := fnd_api.g_miss_char
180 , p26_a10 VARCHAR2 := fnd_api.g_miss_char
181 , p26_a11 NUMBER := 0-1962.0724
182 , p26_a12 NUMBER := 0-1962.0724
183 , p26_a13 NUMBER := 0-1962.0724
184 , p26_a14 NUMBER := 0-1962.0724
185 , p26_a15 VARCHAR2 := fnd_api.g_miss_char
186 , p26_a16 NUMBER := 0-1962.0724
187 , p26_a17 NUMBER := 0-1962.0724
188 , p26_a18 NUMBER := 0-1962.0724
189 , p26_a19 NUMBER := 0-1962.0724
190 , p26_a20 VARCHAR2 := fnd_api.g_miss_char
191 , p26_a21 NUMBER := 0-1962.0724
192 , p26_a22 VARCHAR2 := fnd_api.g_miss_char
193 , p26_a23 VARCHAR2 := fnd_api.g_miss_char
194 , p26_a24 VARCHAR2 := fnd_api.g_miss_char
195 , p26_a25 VARCHAR2 := fnd_api.g_miss_char
196 , p26_a26 VARCHAR2 := fnd_api.g_miss_char
197 , p26_a27 VARCHAR2 := fnd_api.g_miss_char
198 , p26_a28 VARCHAR2 := fnd_api.g_miss_char
199 , p26_a29 VARCHAR2 := fnd_api.g_miss_char
200 , p26_a30 VARCHAR2 := fnd_api.g_miss_char
201 , p26_a31 VARCHAR2 := fnd_api.g_miss_char
202 , p26_a32 VARCHAR2 := fnd_api.g_miss_char
203 , p26_a33 VARCHAR2 := fnd_api.g_miss_char
204 , p26_a34 VARCHAR2 := fnd_api.g_miss_char
205 , p26_a35 VARCHAR2 := fnd_api.g_miss_char
206 , p26_a36 VARCHAR2 := fnd_api.g_miss_char
207 , p26_a37 NUMBER := 0-1962.0724
208 , p26_a38 NUMBER := 0-1962.0724
209 , p26_a39 NUMBER := 0-1962.0724
210 , p26_a40 NUMBER := 0-1962.0724
211 , p26_a41 NUMBER := 0-1962.0724
212 , p26_a42 NUMBER := 0-1962.0724
213 , p26_a43 NUMBER := 0-1962.0724
214 , p26_a44 NUMBER := 0-1962.0724
215 , p26_a45 NUMBER := 0-1962.0724
216 , p26_a46 NUMBER := 0-1962.0724
217 , p26_a47 VARCHAR2 := fnd_api.g_miss_char
218 , p26_a48 VARCHAR2 := fnd_api.g_miss_char
219 , p26_a49 VARCHAR2 := fnd_api.g_miss_char
220 , p26_a50 VARCHAR2 := fnd_api.g_miss_char
221 , p26_a51 VARCHAR2 := fnd_api.g_miss_char
222 , p26_a52 NUMBER := 0-1962.0724
223 , p26_a53 NUMBER := 0-1962.0724
224 , p27_a0 NUMBER := 0-1962.0724
225 , p27_a1 NUMBER := 0-1962.0724
226 , p27_a2 NUMBER := 0-1962.0724
227 , p27_a3 VARCHAR2 := fnd_api.g_miss_char
228 , p27_a4 NUMBER := 0-1962.0724
229 , p27_a5 VARCHAR2 := fnd_api.g_miss_char
230 , p27_a6 VARCHAR2 := fnd_api.g_miss_char
231 , p27_a7 VARCHAR2 := fnd_api.g_miss_char
232 , p27_a8 VARCHAR2 := fnd_api.g_miss_char
233 , p27_a9 VARCHAR2 := fnd_api.g_miss_char
234 , p27_a10 VARCHAR2 := fnd_api.g_miss_char
235 , p27_a11 VARCHAR2 := fnd_api.g_miss_char
236 , p27_a12 NUMBER := 0-1962.0724
237 , p27_a13 NUMBER := 0-1962.0724
238 , p27_a14 NUMBER := 0-1962.0724
239 , p27_a15 NUMBER := 0-1962.0724
240 , p27_a16 NUMBER := 0-1962.0724
241 , p27_a17 NUMBER := 0-1962.0724
242 , p27_a18 NUMBER := 0-1962.0724
243 , p27_a19 VARCHAR2 := fnd_api.g_miss_char
244 , p27_a20 NUMBER := 0-1962.0724
245 , p27_a21 NUMBER := 0-1962.0724
246 , p27_a22 NUMBER := 0-1962.0724
247 , p27_a23 NUMBER := 0-1962.0724
248 , p27_a24 VARCHAR2 := fnd_api.g_miss_char
249 , p27_a25 NUMBER := 0-1962.0724
250 , p27_a26 VARCHAR2 := fnd_api.g_miss_char
251 , p27_a27 VARCHAR2 := fnd_api.g_miss_char
252 , p27_a28 VARCHAR2 := fnd_api.g_miss_char
253 , p27_a29 VARCHAR2 := fnd_api.g_miss_char
254 , p27_a30 VARCHAR2 := fnd_api.g_miss_char
255 , p27_a31 VARCHAR2 := fnd_api.g_miss_char
256 , p27_a32 VARCHAR2 := fnd_api.g_miss_char
257 , p27_a33 VARCHAR2 := fnd_api.g_miss_char
258 , p27_a34 VARCHAR2 := fnd_api.g_miss_char
259 , p27_a35 VARCHAR2 := fnd_api.g_miss_char
260 , p27_a36 VARCHAR2 := fnd_api.g_miss_char
261 , p27_a37 VARCHAR2 := fnd_api.g_miss_char
262 , p27_a38 VARCHAR2 := fnd_api.g_miss_char
263 , p27_a39 VARCHAR2 := fnd_api.g_miss_char
264 , p27_a40 VARCHAR2 := fnd_api.g_miss_char
265 , p27_a41 NUMBER := 0-1962.0724
266 , p27_a42 NUMBER := 0-1962.0724
267 , p27_a43 NUMBER := 0-1962.0724
268 , p27_a44 NUMBER := 0-1962.0724
269 , p27_a45 NUMBER := 0-1962.0724
270 , p27_a46 NUMBER := 0-1962.0724
271 , p27_a47 NUMBER := 0-1962.0724
272 , p27_a48 NUMBER := 0-1962.0724
273 , p27_a49 NUMBER := 0-1962.0724
274 , p27_a50 NUMBER := 0-1962.0724
275 , p27_a51 VARCHAR2 := fnd_api.g_miss_char
276 , p27_a52 VARCHAR2 := fnd_api.g_miss_char
277 , p27_a53 VARCHAR2 := fnd_api.g_miss_char
278 , p27_a54 VARCHAR2 := fnd_api.g_miss_char
279 , p27_a55 VARCHAR2 := fnd_api.g_miss_char
280 , p27_a56 NUMBER := 0-1962.0724
281 , p27_a57 NUMBER := 0-1962.0724
282 , p28_a0 VARCHAR2 := fnd_api.g_miss_char
283 , p28_a1 VARCHAR2 := fnd_api.g_miss_char
284 , p28_a2 VARCHAR2 := fnd_api.g_miss_char
285 , p28_a3 VARCHAR2 := fnd_api.g_miss_char
286 , p28_a4 VARCHAR2 := fnd_api.g_miss_char
287 , p28_a5 VARCHAR2 := fnd_api.g_miss_char
288 , p28_a6 VARCHAR2 := fnd_api.g_miss_char
289 , p28_a7 VARCHAR2 := fnd_api.g_miss_char
290 , p28_a8 VARCHAR2 := fnd_api.g_miss_char
291 , p28_a9 VARCHAR2 := fnd_api.g_miss_char
292 , p28_a10 VARCHAR2 := fnd_api.g_miss_char
293 , p28_a11 VARCHAR2 := fnd_api.g_miss_char
294 , p28_a12 VARCHAR2 := fnd_api.g_miss_char
295 , p28_a13 VARCHAR2 := fnd_api.g_miss_char
296 , p28_a14 VARCHAR2 := fnd_api.g_miss_char
297 , p28_a15 VARCHAR2 := fnd_api.g_miss_char
298 , p28_a16 VARCHAR2 := fnd_api.g_miss_char
299 , p28_a17 VARCHAR2 := fnd_api.g_miss_char
300 , p28_a18 VARCHAR2 := fnd_api.g_miss_char
301 , p28_a19 VARCHAR2 := fnd_api.g_miss_char
302 , p28_a20 VARCHAR2 := fnd_api.g_miss_char
303 , p28_a21 VARCHAR2 := fnd_api.g_miss_char
304 , p28_a22 VARCHAR2 := fnd_api.g_miss_char
305 , p28_a23 VARCHAR2 := fnd_api.g_miss_char
306 , p28_a24 VARCHAR2 := fnd_api.g_miss_char
307 , p28_a25 NUMBER := 0-1962.0724
308 , p28_a26 NUMBER := 0-1962.0724
309 , p28_a27 NUMBER := 0-1962.0724
310 , p28_a28 NUMBER := 0-1962.0724
311 , p28_a29 NUMBER := 0-1962.0724
312 , p28_a30 NUMBER := 0-1962.0724
313 , p28_a31 NUMBER := 0-1962.0724
314 , p28_a32 NUMBER := 0-1962.0724
315 , p28_a33 NUMBER := 0-1962.0724
316 , p28_a34 NUMBER := 0-1962.0724
317 , p28_a35 NUMBER := 0-1962.0724
318 , p28_a36 NUMBER := 0-1962.0724
319 , p28_a37 NUMBER := 0-1962.0724
320 , p28_a38 NUMBER := 0-1962.0724
321 , p28_a39 NUMBER := 0-1962.0724
322 , p28_a40 NUMBER := 0-1962.0724
323 , p28_a41 NUMBER := 0-1962.0724
324 , p28_a42 NUMBER := 0-1962.0724
325 , p28_a43 NUMBER := 0-1962.0724
326 , p28_a44 NUMBER := 0-1962.0724
327 , p28_a45 NUMBER := 0-1962.0724
328 , p28_a46 NUMBER := 0-1962.0724
329 , p28_a47 NUMBER := 0-1962.0724
330 , p28_a48 NUMBER := 0-1962.0724
331 , p28_a49 NUMBER := 0-1962.0724
332 , p28_a50 VARCHAR2 := fnd_api.g_miss_char
333 , p28_a51 VARCHAR2 := fnd_api.g_miss_char
334 , p28_a52 VARCHAR2 := fnd_api.g_miss_char
335 , p28_a53 VARCHAR2 := fnd_api.g_miss_char
336 , p28_a54 VARCHAR2 := fnd_api.g_miss_char
337 , p28_a55 VARCHAR2 := fnd_api.g_miss_char
338 , p28_a56 VARCHAR2 := fnd_api.g_miss_char
339 , p28_a57 VARCHAR2 := fnd_api.g_miss_char
340 , p28_a58 VARCHAR2 := fnd_api.g_miss_char
341 , p28_a59 VARCHAR2 := fnd_api.g_miss_char
342 , p28_a60 VARCHAR2 := fnd_api.g_miss_char
343 , p28_a61 VARCHAR2 := fnd_api.g_miss_char
344 , p28_a62 VARCHAR2 := fnd_api.g_miss_char
345 , p28_a63 VARCHAR2 := fnd_api.g_miss_char
346 , p28_a64 VARCHAR2 := fnd_api.g_miss_char
347 );
348 procedure get_assign_task_resources(p_api_version NUMBER
349 , p_init_msg_list VARCHAR2
350 , p_resource_type VARCHAR2
351 , p_role VARCHAR2
352 , p_no_of_resources NUMBER
353 , p_auto_select_flag VARCHAR2
354 , p_contracts_preferred_engineer VARCHAR2
355 , p_ib_preferred_engineer VARCHAR2
356 , p_effort_duration NUMBER
357 , p_effort_uom VARCHAR2
358 , p_start_date date
359 , p_end_date date
360 , p_territory_flag VARCHAR2
361 , p_calendar_flag VARCHAR2
362 , p_web_availability_flag VARCHAR2
363 , p_task_id NUMBER
364 , p_column_list VARCHAR2
365 , p_business_process_id NUMBER
369 , p20_a1 out nocopy JTF_NUMBER_TABLE
366 , p_business_process_date date
367 , p_filter_excluded_resource VARCHAR2
368 , p20_a0 out nocopy JTF_NUMBER_TABLE
370 , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
371 , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372 , p20_a4 out nocopy JTF_DATE_TABLE
373 , p20_a5 out nocopy JTF_DATE_TABLE
374 , p20_a6 out nocopy JTF_NUMBER_TABLE
375 , p20_a7 out nocopy JTF_NUMBER_TABLE
376 , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377 , p20_a9 out nocopy JTF_NUMBER_TABLE
378 , p20_a10 out nocopy JTF_NUMBER_TABLE
379 , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380 , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381 , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382 , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383 , p20_a15 out nocopy JTF_NUMBER_TABLE
384 , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385 , p20_a17 out nocopy JTF_NUMBER_TABLE
386 , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
387 , p20_a19 out nocopy JTF_DATE_TABLE
388 , p20_a20 out nocopy JTF_DATE_TABLE
389 , p20_a21 out nocopy JTF_NUMBER_TABLE
390 , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
391 , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
392 , p20_a24 out nocopy JTF_NUMBER_TABLE
393 , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
394 , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
395 , x_return_status out nocopy VARCHAR2
396 , x_msg_count out nocopy NUMBER
397 , x_msg_data out nocopy VARCHAR2
398 );
399 procedure get_assign_dr_resources(p_api_version NUMBER
400 , p_init_msg_list VARCHAR2
401 , p_resource_type VARCHAR2
402 , p_role VARCHAR2
403 , p_no_of_resources NUMBER
404 , p_auto_select_flag VARCHAR2
405 , p_contracts_preferred_engineer VARCHAR2
406 , p_ib_preferred_engineer VARCHAR2
407 , p_contract_id NUMBER
408 , p_customer_product_id NUMBER
409 , p_effort_duration NUMBER
410 , p_effort_uom VARCHAR2
411 , p_start_date date
412 , p_end_date date
413 , p_territory_flag VARCHAR2
414 , p_calendar_flag VARCHAR2
415 , p_web_availability_flag VARCHAR2
416 , p_category_id NUMBER
417 , p_inventory_item_id NUMBER
418 , p_inventory_org_id NUMBER
419 , p_problem_code VARCHAR2
420 , p_dr_id NUMBER
421 , p_column_list VARCHAR2
422 , p_business_process_id NUMBER
423 , p_business_process_date date
424 , p_filter_excluded_resource VARCHAR2
425 , p27_a0 out nocopy JTF_NUMBER_TABLE
426 , p27_a1 out nocopy JTF_NUMBER_TABLE
427 , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
428 , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429 , p27_a4 out nocopy JTF_DATE_TABLE
430 , p27_a5 out nocopy JTF_DATE_TABLE
431 , p27_a6 out nocopy JTF_NUMBER_TABLE
432 , p27_a7 out nocopy JTF_NUMBER_TABLE
433 , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434 , p27_a9 out nocopy JTF_NUMBER_TABLE
435 , p27_a10 out nocopy JTF_NUMBER_TABLE
436 , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437 , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438 , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439 , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440 , p27_a15 out nocopy JTF_NUMBER_TABLE
441 , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442 , p27_a17 out nocopy JTF_NUMBER_TABLE
443 , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
444 , p27_a19 out nocopy JTF_DATE_TABLE
445 , p27_a20 out nocopy JTF_DATE_TABLE
446 , p27_a21 out nocopy JTF_NUMBER_TABLE
447 , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
448 , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
449 , p27_a24 out nocopy JTF_NUMBER_TABLE
450 , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
451 , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
452 , x_return_status out nocopy VARCHAR2
453 , x_msg_count out nocopy NUMBER
454 , x_msg_data out nocopy VARCHAR2
455 , p23_a0 NUMBER := 0-1962.0724
456 , p23_a1 NUMBER := 0-1962.0724
457 , p23_a2 NUMBER := 0-1962.0724
458 , p23_a3 VARCHAR2 := fnd_api.g_miss_char
459 , p23_a4 NUMBER := 0-1962.0724
460 , p23_a5 VARCHAR2 := fnd_api.g_miss_char
461 , p23_a6 VARCHAR2 := fnd_api.g_miss_char
465 , p23_a10 VARCHAR2 := fnd_api.g_miss_char
462 , p23_a7 VARCHAR2 := fnd_api.g_miss_char
463 , p23_a8 VARCHAR2 := fnd_api.g_miss_char
464 , p23_a9 VARCHAR2 := fnd_api.g_miss_char
466 , p23_a11 VARCHAR2 := fnd_api.g_miss_char
467 , p23_a12 NUMBER := 0-1962.0724
468 , p23_a13 NUMBER := 0-1962.0724
469 , p23_a14 NUMBER := 0-1962.0724
470 , p23_a15 NUMBER := 0-1962.0724
471 , p23_a16 NUMBER := 0-1962.0724
472 , p23_a17 NUMBER := 0-1962.0724
473 , p23_a18 NUMBER := 0-1962.0724
474 , p23_a19 VARCHAR2 := fnd_api.g_miss_char
475 , p23_a20 NUMBER := 0-1962.0724
476 , p23_a21 NUMBER := 0-1962.0724
477 , p23_a22 NUMBER := 0-1962.0724
478 , p23_a23 NUMBER := 0-1962.0724
479 , p23_a24 VARCHAR2 := fnd_api.g_miss_char
480 , p23_a25 NUMBER := 0-1962.0724
481 , p23_a26 VARCHAR2 := fnd_api.g_miss_char
482 , p23_a27 VARCHAR2 := fnd_api.g_miss_char
483 , p23_a28 VARCHAR2 := fnd_api.g_miss_char
484 , p23_a29 VARCHAR2 := fnd_api.g_miss_char
485 , p23_a30 VARCHAR2 := fnd_api.g_miss_char
486 , p23_a31 VARCHAR2 := fnd_api.g_miss_char
487 , p23_a32 VARCHAR2 := fnd_api.g_miss_char
488 , p23_a33 VARCHAR2 := fnd_api.g_miss_char
489 , p23_a34 VARCHAR2 := fnd_api.g_miss_char
490 , p23_a35 VARCHAR2 := fnd_api.g_miss_char
491 , p23_a36 VARCHAR2 := fnd_api.g_miss_char
492 , p23_a37 VARCHAR2 := fnd_api.g_miss_char
493 , p23_a38 VARCHAR2 := fnd_api.g_miss_char
494 , p23_a39 VARCHAR2 := fnd_api.g_miss_char
495 , p23_a40 VARCHAR2 := fnd_api.g_miss_char
496 , p23_a41 NUMBER := 0-1962.0724
497 , p23_a42 NUMBER := 0-1962.0724
498 , p23_a43 NUMBER := 0-1962.0724
499 , p23_a44 NUMBER := 0-1962.0724
500 , p23_a45 NUMBER := 0-1962.0724
501 , p23_a46 NUMBER := 0-1962.0724
502 , p23_a47 NUMBER := 0-1962.0724
503 , p23_a48 NUMBER := 0-1962.0724
504 , p23_a49 NUMBER := 0-1962.0724
505 , p23_a50 NUMBER := 0-1962.0724
506 , p23_a51 VARCHAR2 := fnd_api.g_miss_char
507 , p23_a52 VARCHAR2 := fnd_api.g_miss_char
508 , p23_a53 VARCHAR2 := fnd_api.g_miss_char
509 , p23_a54 VARCHAR2 := fnd_api.g_miss_char
510 , p23_a55 VARCHAR2 := fnd_api.g_miss_char
511 );
512 procedure get_assign_oppr_resources(p_api_version NUMBER
513 , p_init_msg_list VARCHAR2
514 , p_resource_type VARCHAR2
515 , p_role VARCHAR2
516 , p_no_of_resources NUMBER
517 , p_auto_select_flag VARCHAR2
518 , p_effort_duration NUMBER
519 , p_effort_uom VARCHAR2
520 , p_start_date date
521 , p_end_date date
522 , p_territory_flag VARCHAR2
523 , p_calendar_flag VARCHAR2
524 , p_business_process_id NUMBER
525 , p_business_process_date date
526 , p15_a0 out nocopy JTF_NUMBER_TABLE
527 , p15_a1 out nocopy JTF_NUMBER_TABLE
528 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
529 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530 , p15_a4 out nocopy JTF_DATE_TABLE
531 , p15_a5 out nocopy JTF_DATE_TABLE
532 , p15_a6 out nocopy JTF_NUMBER_TABLE
533 , p15_a7 out nocopy JTF_NUMBER_TABLE
534 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535 , p15_a9 out nocopy JTF_NUMBER_TABLE
536 , p15_a10 out nocopy JTF_NUMBER_TABLE
537 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539 , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541 , p15_a15 out nocopy JTF_NUMBER_TABLE
542 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543 , p15_a17 out nocopy JTF_NUMBER_TABLE
544 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
545 , p15_a19 out nocopy JTF_DATE_TABLE
546 , p15_a20 out nocopy JTF_DATE_TABLE
547 , p15_a21 out nocopy JTF_NUMBER_TABLE
548 , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
549 , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
550 , p15_a24 out nocopy JTF_NUMBER_TABLE
551 , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
552 , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
553 , x_return_status out nocopy VARCHAR2
554 , x_msg_count out nocopy NUMBER
555 , x_msg_data out nocopy VARCHAR2
556 , p12_a0 NUMBER := 0-1962.0724
557 , p12_a1 NUMBER := 0-1962.0724
558 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
559 , p12_a3 VARCHAR2 := fnd_api.g_miss_char
560 , p12_a4 VARCHAR2 := fnd_api.g_miss_char
561 , p12_a5 VARCHAR2 := fnd_api.g_miss_char
562 , p12_a6 VARCHAR2 := fnd_api.g_miss_char
563 , p12_a7 VARCHAR2 := fnd_api.g_miss_char
564 , p12_a8 NUMBER := 0-1962.0724
565 , p12_a9 NUMBER := 0-1962.0724
566 , p12_a10 NUMBER := 0-1962.0724
567 , p12_a11 NUMBER := 0-1962.0724
568 , p12_a12 NUMBER := 0-1962.0724
569 , p12_a13 NUMBER := 0-1962.0724
570 , p12_a14 NUMBER := 0-1962.0724
574 , p12_a18 NUMBER := 0-1962.0724
571 , p12_a15 VARCHAR2 := fnd_api.g_miss_char
572 , p12_a16 NUMBER := 0-1962.0724
573 , p12_a17 VARCHAR2 := fnd_api.g_miss_char
575 , p12_a19 NUMBER := 0-1962.0724
576 , p12_a20 VARCHAR2 := fnd_api.g_miss_char
577 , p12_a21 NUMBER := 0-1962.0724
578 , p12_a22 VARCHAR2 := fnd_api.g_miss_char
579 , p12_a23 VARCHAR2 := fnd_api.g_miss_char
580 , p12_a24 NUMBER := 0-1962.0724
581 , p12_a25 VARCHAR2 := fnd_api.g_miss_char
582 , p12_a26 DATE := fnd_api.g_miss_date
583 , p12_a27 VARCHAR2 := fnd_api.g_miss_char
584 , p12_a28 NUMBER := 0-1962.0724
585 , p12_a29 NUMBER := 0-1962.0724
586 , p12_a30 NUMBER := 0-1962.0724
587 , p12_a31 NUMBER := 0-1962.0724
588 , p12_a32 NUMBER := 0-1962.0724
589 , p12_a33 NUMBER := 0-1962.0724
590 , p12_a34 NUMBER := 0-1962.0724
591 , p12_a35 VARCHAR2 := fnd_api.g_miss_char
592 , p12_a36 VARCHAR2 := fnd_api.g_miss_char
593 , p12_a37 VARCHAR2 := fnd_api.g_miss_char
594 , p12_a38 VARCHAR2 := fnd_api.g_miss_char
595 , p12_a39 VARCHAR2 := fnd_api.g_miss_char
596 , p12_a40 VARCHAR2 := fnd_api.g_miss_char
597 , p12_a41 VARCHAR2 := fnd_api.g_miss_char
598 , p12_a42 VARCHAR2 := fnd_api.g_miss_char
599 , p12_a43 VARCHAR2 := fnd_api.g_miss_char
600 , p12_a44 VARCHAR2 := fnd_api.g_miss_char
601 , p12_a45 VARCHAR2 := fnd_api.g_miss_char
602 , p12_a46 VARCHAR2 := fnd_api.g_miss_char
603 , p12_a47 VARCHAR2 := fnd_api.g_miss_char
604 , p12_a48 VARCHAR2 := fnd_api.g_miss_char
605 , p12_a49 VARCHAR2 := fnd_api.g_miss_char
606 , p12_a50 NUMBER := 0-1962.0724
607 );
608 procedure get_assign_lead_resources(p_api_version NUMBER
609 , p_init_msg_list VARCHAR2
610 , p_resource_type VARCHAR2
611 , p_role VARCHAR2
612 , p_no_of_resources NUMBER
613 , p_auto_select_flag VARCHAR2
614 , p_effort_duration NUMBER
615 , p_effort_uom VARCHAR2
616 , p_start_date date
617 , p_end_date date
618 , p_territory_flag VARCHAR2
619 , p_calendar_flag VARCHAR2
620 , p_business_process_id NUMBER
621 , p_business_process_date date
622 , p15_a0 out nocopy JTF_NUMBER_TABLE
623 , p15_a1 out nocopy JTF_NUMBER_TABLE
624 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
625 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626 , p15_a4 out nocopy JTF_DATE_TABLE
627 , p15_a5 out nocopy JTF_DATE_TABLE
628 , p15_a6 out nocopy JTF_NUMBER_TABLE
629 , p15_a7 out nocopy JTF_NUMBER_TABLE
630 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631 , p15_a9 out nocopy JTF_NUMBER_TABLE
632 , p15_a10 out nocopy JTF_NUMBER_TABLE
633 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635 , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637 , p15_a15 out nocopy JTF_NUMBER_TABLE
638 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639 , p15_a17 out nocopy JTF_NUMBER_TABLE
640 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
641 , p15_a19 out nocopy JTF_DATE_TABLE
642 , p15_a20 out nocopy JTF_DATE_TABLE
643 , p15_a21 out nocopy JTF_NUMBER_TABLE
644 , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
645 , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
646 , p15_a24 out nocopy JTF_NUMBER_TABLE
647 , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
648 , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
649 , x_return_status out nocopy VARCHAR2
650 , x_msg_count out nocopy NUMBER
651 , x_msg_data out nocopy VARCHAR2
652 , p12_a0 NUMBER := 0-1962.0724
653 , p12_a1 NUMBER := 0-1962.0724
654 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
655 , p12_a3 VARCHAR2 := fnd_api.g_miss_char
656 , p12_a4 VARCHAR2 := fnd_api.g_miss_char
657 , p12_a5 VARCHAR2 := fnd_api.g_miss_char
658 , p12_a6 VARCHAR2 := fnd_api.g_miss_char
659 , p12_a7 VARCHAR2 := fnd_api.g_miss_char
660 , p12_a8 NUMBER := 0-1962.0724
661 , p12_a9 NUMBER := 0-1962.0724
662 , p12_a10 NUMBER := 0-1962.0724
663 , p12_a11 NUMBER := 0-1962.0724
664 , p12_a12 NUMBER := 0-1962.0724
665 , p12_a13 NUMBER := 0-1962.0724
666 , p12_a14 NUMBER := 0-1962.0724
667 , p12_a15 VARCHAR2 := fnd_api.g_miss_char
668 , p12_a16 NUMBER := 0-1962.0724
669 , p12_a17 VARCHAR2 := fnd_api.g_miss_char
670 , p12_a18 NUMBER := 0-1962.0724
671 , p12_a19 NUMBER := 0-1962.0724
672 , p12_a20 VARCHAR2 := fnd_api.g_miss_char
673 , p12_a21 NUMBER := 0-1962.0724
674 , p12_a22 VARCHAR2 := fnd_api.g_miss_char
675 , p12_a23 NUMBER := 0-1962.0724
676 , p12_a24 VARCHAR2 := fnd_api.g_miss_char
677 , p12_a25 DATE := fnd_api.g_miss_date
678 , p12_a26 NUMBER := 0-1962.0724
679 , p12_a27 NUMBER := 0-1962.0724
680 , p12_a28 NUMBER := 0-1962.0724
681 , p12_a29 NUMBER := 0-1962.0724
682 , p12_a30 NUMBER := 0-1962.0724
683 , p12_a31 NUMBER := 0-1962.0724
684 , p12_a32 VARCHAR2 := fnd_api.g_miss_char
685 , p12_a33 VARCHAR2 := fnd_api.g_miss_char
686 , p12_a34 VARCHAR2 := fnd_api.g_miss_char
687 , p12_a35 VARCHAR2 := fnd_api.g_miss_char
688 , p12_a36 VARCHAR2 := fnd_api.g_miss_char
689 , p12_a37 VARCHAR2 := fnd_api.g_miss_char
690 , p12_a38 VARCHAR2 := fnd_api.g_miss_char
691 , p12_a39 VARCHAR2 := fnd_api.g_miss_char
692 , p12_a40 VARCHAR2 := fnd_api.g_miss_char
693 , p12_a41 VARCHAR2 := fnd_api.g_miss_char
694 , p12_a42 VARCHAR2 := fnd_api.g_miss_char
695 , p12_a43 VARCHAR2 := fnd_api.g_miss_char
696 , p12_a44 VARCHAR2 := fnd_api.g_miss_char
697 , p12_a45 VARCHAR2 := fnd_api.g_miss_char
698 , p12_a46 VARCHAR2 := fnd_api.g_miss_char
702 , p_init_msg_list VARCHAR2
699 , p12_a47 NUMBER := 0-1962.0724
700 );
701 procedure get_assign_account_resources(p_api_version NUMBER
703 , p_resource_type VARCHAR2
704 , p_role VARCHAR2
705 , p_no_of_resources NUMBER
706 , p_auto_select_flag VARCHAR2
707 , p_effort_duration NUMBER
708 , p_effort_uom VARCHAR2
709 , p_start_date date
710 , p_end_date date
711 , p_territory_flag VARCHAR2
712 , p_calendar_flag VARCHAR2
713 , p_business_process_id NUMBER
714 , p_business_process_date date
715 , p15_a0 out nocopy JTF_NUMBER_TABLE
716 , p15_a1 out nocopy JTF_NUMBER_TABLE
717 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
718 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719 , p15_a4 out nocopy JTF_DATE_TABLE
720 , p15_a5 out nocopy JTF_DATE_TABLE
721 , p15_a6 out nocopy JTF_NUMBER_TABLE
722 , p15_a7 out nocopy JTF_NUMBER_TABLE
723 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724 , p15_a9 out nocopy JTF_NUMBER_TABLE
725 , p15_a10 out nocopy JTF_NUMBER_TABLE
726 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728 , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730 , p15_a15 out nocopy JTF_NUMBER_TABLE
731 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732 , p15_a17 out nocopy JTF_NUMBER_TABLE
733 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
734 , p15_a19 out nocopy JTF_DATE_TABLE
735 , p15_a20 out nocopy JTF_DATE_TABLE
736 , p15_a21 out nocopy JTF_NUMBER_TABLE
737 , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
738 , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
739 , p15_a24 out nocopy JTF_NUMBER_TABLE
740 , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
741 , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
742 , x_return_status out nocopy VARCHAR2
743 , x_msg_count out nocopy NUMBER
744 , x_msg_data out nocopy VARCHAR2
745 , p12_a0 VARCHAR2 := fnd_api.g_miss_char
746 , p12_a1 VARCHAR2 := fnd_api.g_miss_char
747 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
748 , p12_a3 VARCHAR2 := fnd_api.g_miss_char
749 , p12_a4 VARCHAR2 := fnd_api.g_miss_char
750 , p12_a5 VARCHAR2 := fnd_api.g_miss_char
751 , p12_a6 NUMBER := 0-1962.0724
752 , p12_a7 NUMBER := 0-1962.0724
753 , p12_a8 NUMBER := 0-1962.0724
754 , p12_a9 NUMBER := 0-1962.0724
755 , p12_a10 NUMBER := 0-1962.0724
756 , p12_a11 NUMBER := 0-1962.0724
757 , p12_a12 NUMBER := 0-1962.0724
758 , p12_a13 VARCHAR2 := fnd_api.g_miss_char
759 , p12_a14 NUMBER := 0-1962.0724
760 , p12_a15 VARCHAR2 := fnd_api.g_miss_char
761 , p12_a16 NUMBER := 0-1962.0724
762 , p12_a17 NUMBER := 0-1962.0724
763 , p12_a18 VARCHAR2 := fnd_api.g_miss_char
764 , p12_a19 NUMBER := 0-1962.0724
765 , p12_a20 VARCHAR2 := fnd_api.g_miss_char
766 , p12_a21 VARCHAR2 := fnd_api.g_miss_char
767 , p12_a22 VARCHAR2 := fnd_api.g_miss_char
768 , p12_a23 VARCHAR2 := fnd_api.g_miss_char
769 , p12_a24 VARCHAR2 := fnd_api.g_miss_char
770 , p12_a25 VARCHAR2 := fnd_api.g_miss_char
771 , p12_a26 VARCHAR2 := fnd_api.g_miss_char
772 , p12_a27 VARCHAR2 := fnd_api.g_miss_char
773 , p12_a28 VARCHAR2 := fnd_api.g_miss_char
774 , p12_a29 VARCHAR2 := fnd_api.g_miss_char
775 , p12_a30 VARCHAR2 := fnd_api.g_miss_char
776 , p12_a31 VARCHAR2 := fnd_api.g_miss_char
777 , p12_a32 VARCHAR2 := fnd_api.g_miss_char
778 , p12_a33 VARCHAR2 := fnd_api.g_miss_char
779 , p12_a34 VARCHAR2 := fnd_api.g_miss_char
780 , p12_a35 VARCHAR2 := fnd_api.g_miss_char
781 , p12_a36 NUMBER := 0-1962.0724
782 );
783 procedure get_assign_esc_resources(p_api_version NUMBER
784 , p_init_msg_list VARCHAR2
785 , p_resource_type VARCHAR2
786 , p_role VARCHAR2
787 , p_no_of_resources NUMBER
788 , p_auto_select_flag VARCHAR2
789 , p_effort_duration NUMBER
790 , p_effort_uom VARCHAR2
791 , p_start_date date
792 , p_end_date date
793 , p_territory_flag VARCHAR2
794 , p_calendar_flag VARCHAR2
795 , p_web_availability_flag VARCHAR2
796 , p13_a0 JTF_NUMBER_TABLE
797 , p13_a1 JTF_VARCHAR2_TABLE_100
798 , p_business_process_id NUMBER
799 , p_business_process_date date
800 , p16_a0 out nocopy JTF_NUMBER_TABLE
801 , p16_a1 out nocopy JTF_NUMBER_TABLE
802 , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
803 , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804 , p16_a4 out nocopy JTF_DATE_TABLE
805 , p16_a5 out nocopy JTF_DATE_TABLE
806 , p16_a6 out nocopy JTF_NUMBER_TABLE
807 , p16_a7 out nocopy JTF_NUMBER_TABLE
808 , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809 , p16_a9 out nocopy JTF_NUMBER_TABLE
810 , p16_a10 out nocopy JTF_NUMBER_TABLE
811 , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812 , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813 , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814 , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815 , p16_a15 out nocopy JTF_NUMBER_TABLE
816 , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817 , p16_a17 out nocopy JTF_NUMBER_TABLE
818 , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
819 , p16_a19 out nocopy JTF_DATE_TABLE
820 , p16_a20 out nocopy JTF_DATE_TABLE
821 , p16_a21 out nocopy JTF_NUMBER_TABLE
822 , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
823 , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
824 , p16_a24 out nocopy JTF_NUMBER_TABLE
825 , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
826 , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
827 , x_return_status out nocopy VARCHAR2
828 , x_msg_count out nocopy NUMBER
829 , x_msg_data out nocopy VARCHAR2
830 );
834 , p_contract_id NUMBER
831 procedure get_excluded_resources(p_api_version NUMBER
832 , p_init_msg_list VARCHAR2
833 , p_commit VARCHAR2
835 , p_customer_product_id NUMBER
836 , p_calling_doc_id NUMBER
837 , p_calling_doc_type VARCHAR2
838 , p_business_process_id NUMBER
839 , p_business_process_date date
840 , p12_a0 out nocopy JTF_NUMBER_TABLE
841 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
842 , x_return_status out nocopy VARCHAR2
843 , x_msg_count out nocopy NUMBER
844 , x_msg_data out nocopy VARCHAR2
845 , p7_a0 NUMBER := 0-1962.0724
846 , p7_a1 NUMBER := 0-1962.0724
847 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
848 , p7_a3 NUMBER := 0-1962.0724
849 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
850 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
851 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
852 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
853 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
854 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
855 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
856 , p7_a11 NUMBER := 0-1962.0724
857 , p7_a12 NUMBER := 0-1962.0724
858 , p7_a13 NUMBER := 0-1962.0724
859 , p7_a14 NUMBER := 0-1962.0724
860 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
861 , p7_a16 NUMBER := 0-1962.0724
862 , p7_a17 NUMBER := 0-1962.0724
863 , p7_a18 NUMBER := 0-1962.0724
864 , p7_a19 NUMBER := 0-1962.0724
865 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
866 , p7_a21 NUMBER := 0-1962.0724
867 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
868 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
869 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
870 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
871 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
872 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
873 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
874 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
875 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
876 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
877 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
878 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
879 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
880 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
881 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
882 , p7_a37 NUMBER := 0-1962.0724
883 , p7_a38 NUMBER := 0-1962.0724
884 , p7_a39 NUMBER := 0-1962.0724
885 , p7_a40 NUMBER := 0-1962.0724
886 , p7_a41 NUMBER := 0-1962.0724
887 , p7_a42 NUMBER := 0-1962.0724
888 , p7_a43 NUMBER := 0-1962.0724
889 , p7_a44 NUMBER := 0-1962.0724
890 , p7_a45 NUMBER := 0-1962.0724
891 , p7_a46 NUMBER := 0-1962.0724
892 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
893 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
894 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
895 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
896 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
897 , p7_a52 NUMBER := 0-1962.0724
898 , p7_a53 NUMBER := 0-1962.0724
899 , p8_a0 NUMBER := 0-1962.0724
900 , p8_a1 NUMBER := 0-1962.0724
901 , p8_a2 NUMBER := 0-1962.0724
902 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
903 , p8_a4 NUMBER := 0-1962.0724
904 , p8_a5 VARCHAR2 := fnd_api.g_miss_char
905 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
906 , p8_a7 VARCHAR2 := fnd_api.g_miss_char
907 , p8_a8 VARCHAR2 := fnd_api.g_miss_char
908 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
909 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
910 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
911 , p8_a12 NUMBER := 0-1962.0724
912 , p8_a13 NUMBER := 0-1962.0724
913 , p8_a14 NUMBER := 0-1962.0724
914 , p8_a15 NUMBER := 0-1962.0724
915 , p8_a16 NUMBER := 0-1962.0724
916 , p8_a17 NUMBER := 0-1962.0724
917 , p8_a18 NUMBER := 0-1962.0724
918 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
919 , p8_a20 NUMBER := 0-1962.0724
920 , p8_a21 NUMBER := 0-1962.0724
921 , p8_a22 NUMBER := 0-1962.0724
922 , p8_a23 NUMBER := 0-1962.0724
923 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
924 , p8_a25 NUMBER := 0-1962.0724
925 , p8_a26 VARCHAR2 := fnd_api.g_miss_char
926 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
927 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
928 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
929 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
930 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
931 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
932 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
933 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
934 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
935 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
936 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
937 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
938 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
939 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
940 , p8_a41 NUMBER := 0-1962.0724
941 , p8_a42 NUMBER := 0-1962.0724
942 , p8_a43 NUMBER := 0-1962.0724
943 , p8_a44 NUMBER := 0-1962.0724
944 , p8_a45 NUMBER := 0-1962.0724
945 , p8_a46 NUMBER := 0-1962.0724
946 , p8_a47 NUMBER := 0-1962.0724
947 , p8_a48 NUMBER := 0-1962.0724
948 , p8_a49 NUMBER := 0-1962.0724
949 , p8_a50 NUMBER := 0-1962.0724
950 , p8_a51 VARCHAR2 := fnd_api.g_miss_char
951 , p8_a52 VARCHAR2 := fnd_api.g_miss_char
952 , p8_a53 VARCHAR2 := fnd_api.g_miss_char
953 , p8_a54 VARCHAR2 := fnd_api.g_miss_char
954 , p8_a55 VARCHAR2 := fnd_api.g_miss_char
955 , p8_a56 NUMBER := 0-1962.0724
956 , p8_a57 NUMBER := 0-1962.0724
957 , p9_a0 NUMBER := 0-1962.0724
958 , p9_a1 NUMBER := 0-1962.0724
959 , p9_a2 NUMBER := 0-1962.0724
960 , p9_a3 VARCHAR2 := fnd_api.g_miss_char
961 , p9_a4 NUMBER := 0-1962.0724
962 , p9_a5 VARCHAR2 := fnd_api.g_miss_char
963 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
964 , p9_a7 VARCHAR2 := fnd_api.g_miss_char
965 , p9_a8 VARCHAR2 := fnd_api.g_miss_char
966 , p9_a9 VARCHAR2 := fnd_api.g_miss_char
967 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
968 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
969 , p9_a12 NUMBER := 0-1962.0724
970 , p9_a13 NUMBER := 0-1962.0724
971 , p9_a14 NUMBER := 0-1962.0724
972 , p9_a15 NUMBER := 0-1962.0724
973 , p9_a16 NUMBER := 0-1962.0724
974 , p9_a17 NUMBER := 0-1962.0724
975 , p9_a18 NUMBER := 0-1962.0724
976 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
977 , p9_a20 NUMBER := 0-1962.0724
978 , p9_a21 NUMBER := 0-1962.0724
979 , p9_a22 NUMBER := 0-1962.0724
980 , p9_a23 NUMBER := 0-1962.0724
981 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
982 , p9_a25 NUMBER := 0-1962.0724
983 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
984 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
985 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
986 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
987 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
988 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
989 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
990 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
991 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
992 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
993 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
994 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
995 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
996 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
997 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
998 , p9_a41 NUMBER := 0-1962.0724
999 , p9_a42 NUMBER := 0-1962.0724
1000 , p9_a43 NUMBER := 0-1962.0724
1001 , p9_a44 NUMBER := 0-1962.0724
1002 , p9_a45 NUMBER := 0-1962.0724
1003 , p9_a46 NUMBER := 0-1962.0724
1004 , p9_a47 NUMBER := 0-1962.0724
1005 , p9_a48 NUMBER := 0-1962.0724
1006 , p9_a49 NUMBER := 0-1962.0724
1007 , p9_a50 NUMBER := 0-1962.0724
1008 , p9_a51 VARCHAR2 := fnd_api.g_miss_char
1009 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
1010 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
1011 , p9_a54 VARCHAR2 := fnd_api.g_miss_char
1012 , p9_a55 VARCHAR2 := fnd_api.g_miss_char
1013 );
1014 procedure get_resource_availability(p_api_version NUMBER
1015 , p_init_msg_list VARCHAR2
1016 , p_commit VARCHAR2
1017 , p_calendar_flag VARCHAR2
1018 , p_effort_duration NUMBER
1019 , p_effort_uom VARCHAR2
1020 , p_breakdown NUMBER
1021 , p_breakdown_uom VARCHAR2
1022 , p_planned_start_date date
1023 , p_planned_end_date date
1024 , p_continuous_task VARCHAR2
1025 , x_return_status in out nocopy VARCHAR2
1026 , x_msg_count in out nocopy NUMBER
1027 , x_msg_data in out nocopy VARCHAR2
1028 , p14_a0 in out nocopy JTF_NUMBER_TABLE
1029 , p14_a1 in out nocopy JTF_NUMBER_TABLE
1030 , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1031 , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032 , p14_a4 in out nocopy JTF_DATE_TABLE
1033 , p14_a5 in out nocopy JTF_DATE_TABLE
1034 , p14_a6 in out nocopy JTF_NUMBER_TABLE
1035 , p14_a7 in out nocopy JTF_NUMBER_TABLE
1036 , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037 , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038 , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039 , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040 , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041 , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042 , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043 , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044 , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045 , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046 , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1047 , p14_a19 in out nocopy JTF_DATE_TABLE
1048 , p14_a20 in out nocopy JTF_DATE_TABLE
1049 , p14_a21 in out nocopy JTF_NUMBER_TABLE
1050 , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1051 , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1052 , p14_a24 in out nocopy JTF_NUMBER_TABLE
1053 , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
1054 , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1055 );
1056 end jtf_assign_pub_w;