[Home] [Help]
PACKAGE: APPS.CS_SERVICEREQUEST_PUB_W
Source
1 package cs_servicerequest_pub_w AUTHID CURRENT_USER as
2 /* $Header: cssrrsws.pls 120.9.12020000.3 2013/02/04 15:50:53 lkullamb ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
4 , a1 JTF_VARCHAR2_TABLE_32767
5 , a2 JTF_VARCHAR2_TABLE_300
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 );
13 procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
14 , a1 out nocopy JTF_VARCHAR2_TABLE_32767
15 , a2 out nocopy JTF_VARCHAR2_TABLE_300
16 , a3 out nocopy JTF_VARCHAR2_TABLE_100
17 , a4 out nocopy JTF_NUMBER_TABLE
18 , a5 out nocopy JTF_VARCHAR2_TABLE_100
19 , a6 out nocopy JTF_NUMBER_TABLE
20 , a7 out nocopy JTF_VARCHAR2_TABLE_100
21 , a8 out nocopy JTF_NUMBER_TABLE
22 );
23
24 procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE
25 , a1 JTF_NUMBER_TABLE
26 , a2 JTF_NUMBER_TABLE
27 , a3 JTF_VARCHAR2_TABLE_100
28 , a4 JTF_VARCHAR2_TABLE_100
29 , a5 JTF_VARCHAR2_TABLE_100
30 , a6 JTF_VARCHAR2_TABLE_100
31 , a7 JTF_DATE_TABLE
32 , a8 JTF_DATE_TABLE
33 );
34 procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
35 , a1 out nocopy JTF_NUMBER_TABLE
36 , a2 out nocopy JTF_NUMBER_TABLE
37 , a3 out nocopy JTF_VARCHAR2_TABLE_100
38 , a4 out nocopy JTF_VARCHAR2_TABLE_100
39 , a5 out nocopy JTF_VARCHAR2_TABLE_100
40 , a6 out nocopy JTF_VARCHAR2_TABLE_100
41 , a7 out nocopy JTF_DATE_TABLE
42 , a8 out nocopy JTF_DATE_TABLE
43 );
44
45 procedure rosetta_table_copy_in_p8(t out nocopy cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 JTF_NUMBER_TABLE
46 , a1 JTF_VARCHAR2_TABLE_200
47 , a2 JTF_VARCHAR2_TABLE_200
48 , a3 JTF_VARCHAR2_TABLE_200
49 , a4 JTF_VARCHAR2_TABLE_200
50 , a5 JTF_VARCHAR2_TABLE_200
51 , a6 JTF_VARCHAR2_TABLE_200
52 , a7 JTF_VARCHAR2_TABLE_100
53 , a8 JTF_NUMBER_TABLE
54 , a9 JTF_NUMBER_TABLE
55 , a10 JTF_VARCHAR2_TABLE_100
56 , a11 JTF_VARCHAR2_TABLE_100
57 , a12 JTF_VARCHAR2_TABLE_200
58 , a13 JTF_VARCHAR2_TABLE_100
59 , a14 JTF_VARCHAR2_TABLE_100
60 );
61 procedure rosetta_table_copy_out_p8(t cs_servicerequest_pub.ext_attr_grp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62 , a1 out nocopy JTF_VARCHAR2_TABLE_200
63 , a2 out nocopy JTF_VARCHAR2_TABLE_200
64 , a3 out nocopy JTF_VARCHAR2_TABLE_200
65 , a4 out nocopy JTF_VARCHAR2_TABLE_200
66 , a5 out nocopy JTF_VARCHAR2_TABLE_200
67 , a6 out nocopy JTF_VARCHAR2_TABLE_200
68 , a7 out nocopy JTF_VARCHAR2_TABLE_100
69 , a8 out nocopy JTF_NUMBER_TABLE
70 , a9 out nocopy JTF_NUMBER_TABLE
71 , a10 out nocopy JTF_VARCHAR2_TABLE_100
75 , a14 out nocopy JTF_VARCHAR2_TABLE_100
72 , a11 out nocopy JTF_VARCHAR2_TABLE_100
73 , a12 out nocopy JTF_VARCHAR2_TABLE_200
74 , a13 out nocopy JTF_VARCHAR2_TABLE_100
76 );
77
78 procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE
79 , a1 JTF_VARCHAR2_TABLE_100
80 , a2 JTF_VARCHAR2_TABLE_200
81 , a3 JTF_VARCHAR2_TABLE_200
82 , a4 JTF_VARCHAR2_TABLE_4000
83 , a5 JTF_NUMBER_TABLE
84 , a6 JTF_DATE_TABLE
85 , a7 JTF_VARCHAR2_TABLE_4000
86 , a8 JTF_VARCHAR2_TABLE_100
87 );
88 procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89 , a1 out nocopy JTF_VARCHAR2_TABLE_100
90 , a2 out nocopy JTF_VARCHAR2_TABLE_200
91 , a3 out nocopy JTF_VARCHAR2_TABLE_200
92 , a4 out nocopy JTF_VARCHAR2_TABLE_4000
93 , a5 out nocopy JTF_NUMBER_TABLE
94 , a6 out nocopy JTF_DATE_TABLE
95 , a7 out nocopy JTF_VARCHAR2_TABLE_4000
96 , a8 out nocopy JTF_VARCHAR2_TABLE_100
97 );
98
99 procedure rosetta_table_copy_in_p11(t out nocopy cs_servicerequest_pub.resource_validate_tbl_type, a0 JTF_NUMBER_TABLE);
100 procedure rosetta_table_copy_out_p11(t cs_servicerequest_pub.resource_validate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
101
102 procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100);
103 procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100);
104
105 procedure rosetta_table_copy_in_p17(t out nocopy cs_servicerequest_pub.sr_notes_table, a0 JTF_VARCHAR2_TABLE_2000
106 , a1 JTF_VARCHAR2_TABLE_100
107 , a2 JTF_CLOB_TABLE
108 , a3 JTF_NUMBER_TABLE
109 );
110 procedure rosetta_table_copy_out_p17(t cs_servicerequest_pub.sr_notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
111 , a1 out nocopy JTF_VARCHAR2_TABLE_100
112 , a2 out nocopy JTF_CLOB_TABLE
113 , a3 out nocopy JTF_NUMBER_TABLE
114 );
115
116 procedure rosetta_table_copy_in_p19(t out nocopy cs_servicerequest_pub.tasks_table, a0 JTF_VARCHAR2_TABLE_100
117 , a1 JTF_VARCHAR2_TABLE_100
118 , a2 JTF_VARCHAR2_TABLE_100
119 , a3 JTF_VARCHAR2_TABLE_100
120 , a4 JTF_VARCHAR2_TABLE_100
121 , a5 JTF_VARCHAR2_TABLE_4000
122 , a6 JTF_VARCHAR2_TABLE_100
123 , a7 JTF_VARCHAR2_TABLE_4000
124 , a8 JTF_VARCHAR2_TABLE_100
125 , a9 JTF_VARCHAR2_TABLE_100
126 , a10 JTF_VARCHAR2_TABLE_100
127 , a11 JTF_VARCHAR2_TABLE_100
128 , a12 JTF_DATE_TABLE
129 , a13 JTF_DATE_TABLE
130 , a14 JTF_DATE_TABLE
131 , a15 JTF_DATE_TABLE
132 , a16 JTF_DATE_TABLE
133 , a17 JTF_DATE_TABLE
134 , a18 JTF_NUMBER_TABLE
135 , a19 JTF_VARCHAR2_TABLE_100
136 , a20 JTF_NUMBER_TABLE
137 , a21 JTF_VARCHAR2_TABLE_100
138 , a22 JTF_NUMBER_TABLE
139 , a23 JTF_VARCHAR2_TABLE_100
140 , a24 JTF_VARCHAR2_TABLE_100
141 , a25 JTF_VARCHAR2_TABLE_100
142 , a26 JTF_VARCHAR2_TABLE_100
143 , a27 JTF_NUMBER_TABLE
144 , a28 JTF_DATE_TABLE
145 , a29 JTF_NUMBER_TABLE
146 , a30 JTF_DATE_TABLE
147 , a31 JTF_NUMBER_TABLE
148 , a32 JTF_NUMBER_TABLE
149 , a33 JTF_VARCHAR2_TABLE_100
150 , a34 JTF_VARCHAR2_TABLE_100
151 , a35 JTF_NUMBER_TABLE
152 , a36 JTF_NUMBER_TABLE
153 , a37 JTF_NUMBER_TABLE
154 , a38 JTF_NUMBER_TABLE
155 , a39 JTF_NUMBER_TABLE
156 , a40 JTF_NUMBER_TABLE
157 , a41 JTF_NUMBER_TABLE
158 , a42 JTF_NUMBER_TABLE
159 , a43 JTF_NUMBER_TABLE
160 , a44 JTF_NUMBER_TABLE
161 , a45 JTF_NUMBER_TABLE
162 , a46 JTF_VARCHAR2_TABLE_100
163 , a47 JTF_NUMBER_TABLE
164 , a48 JTF_VARCHAR2_TABLE_100
165 , a49 JTF_VARCHAR2_TABLE_100
166 , a50 JTF_VARCHAR2_TABLE_100
167 , a51 JTF_VARCHAR2_TABLE_100
168 , a52 JTF_VARCHAR2_TABLE_100
169 , a53 JTF_NUMBER_TABLE
170 , a54 JTF_VARCHAR2_TABLE_200
171 , a55 JTF_VARCHAR2_TABLE_200
172 , a56 JTF_VARCHAR2_TABLE_200
173 , a57 JTF_VARCHAR2_TABLE_200
174 , a58 JTF_VARCHAR2_TABLE_200
175 , a59 JTF_VARCHAR2_TABLE_200
176 , a60 JTF_VARCHAR2_TABLE_200
177 , a61 JTF_VARCHAR2_TABLE_200
178 , a62 JTF_VARCHAR2_TABLE_200
179 , a63 JTF_VARCHAR2_TABLE_200
180 , a64 JTF_VARCHAR2_TABLE_200
181 , a65 JTF_VARCHAR2_TABLE_200
182 , a66 JTF_VARCHAR2_TABLE_200
183 , a67 JTF_VARCHAR2_TABLE_200
184 , a68 JTF_VARCHAR2_TABLE_200
185 , a69 JTF_VARCHAR2_TABLE_200
186 );
187 procedure rosetta_table_copy_out_p19(t cs_servicerequest_pub.tasks_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
188 , a1 out nocopy JTF_VARCHAR2_TABLE_100
189 , a2 out nocopy JTF_VARCHAR2_TABLE_100
190 , a3 out nocopy JTF_VARCHAR2_TABLE_100
191 , a4 out nocopy JTF_VARCHAR2_TABLE_100
192 , a5 out nocopy JTF_VARCHAR2_TABLE_4000
193 , a6 out nocopy JTF_VARCHAR2_TABLE_100
194 , a7 out nocopy JTF_VARCHAR2_TABLE_4000
195 , a8 out nocopy JTF_VARCHAR2_TABLE_100
196 , a9 out nocopy JTF_VARCHAR2_TABLE_100
197 , a10 out nocopy JTF_VARCHAR2_TABLE_100
198 , a11 out nocopy JTF_VARCHAR2_TABLE_100
199 , a12 out nocopy JTF_DATE_TABLE
200 , a13 out nocopy JTF_DATE_TABLE
201 , a14 out nocopy JTF_DATE_TABLE
202 , a15 out nocopy JTF_DATE_TABLE
203 , a16 out nocopy JTF_DATE_TABLE
204 , a17 out nocopy JTF_DATE_TABLE
205 , a18 out nocopy JTF_NUMBER_TABLE
206 , a19 out nocopy JTF_VARCHAR2_TABLE_100
207 , a20 out nocopy JTF_NUMBER_TABLE
208 , a21 out nocopy JTF_VARCHAR2_TABLE_100
209 , a22 out nocopy JTF_NUMBER_TABLE
210 , a23 out nocopy JTF_VARCHAR2_TABLE_100
211 , a24 out nocopy JTF_VARCHAR2_TABLE_100
215 , a28 out nocopy JTF_DATE_TABLE
212 , a25 out nocopy JTF_VARCHAR2_TABLE_100
213 , a26 out nocopy JTF_VARCHAR2_TABLE_100
214 , a27 out nocopy JTF_NUMBER_TABLE
216 , a29 out nocopy JTF_NUMBER_TABLE
217 , a30 out nocopy JTF_DATE_TABLE
218 , a31 out nocopy JTF_NUMBER_TABLE
219 , a32 out nocopy JTF_NUMBER_TABLE
220 , a33 out nocopy JTF_VARCHAR2_TABLE_100
221 , a34 out nocopy JTF_VARCHAR2_TABLE_100
222 , a35 out nocopy JTF_NUMBER_TABLE
223 , a36 out nocopy JTF_NUMBER_TABLE
224 , a37 out nocopy JTF_NUMBER_TABLE
225 , a38 out nocopy JTF_NUMBER_TABLE
226 , a39 out nocopy JTF_NUMBER_TABLE
227 , a40 out nocopy JTF_NUMBER_TABLE
228 , a41 out nocopy JTF_NUMBER_TABLE
229 , a42 out nocopy JTF_NUMBER_TABLE
230 , a43 out nocopy JTF_NUMBER_TABLE
231 , a44 out nocopy JTF_NUMBER_TABLE
232 , a45 out nocopy JTF_NUMBER_TABLE
233 , a46 out nocopy JTF_VARCHAR2_TABLE_100
234 , a47 out nocopy JTF_NUMBER_TABLE
235 , a48 out nocopy JTF_VARCHAR2_TABLE_100
236 , a49 out nocopy JTF_VARCHAR2_TABLE_100
237 , a50 out nocopy JTF_VARCHAR2_TABLE_100
238 , a51 out nocopy JTF_VARCHAR2_TABLE_100
239 , a52 out nocopy JTF_VARCHAR2_TABLE_100
240 , a53 out nocopy JTF_NUMBER_TABLE
241 , a54 out nocopy JTF_VARCHAR2_TABLE_200
242 , a55 out nocopy JTF_VARCHAR2_TABLE_200
243 , a56 out nocopy JTF_VARCHAR2_TABLE_200
244 , a57 out nocopy JTF_VARCHAR2_TABLE_200
245 , a58 out nocopy JTF_VARCHAR2_TABLE_200
246 , a59 out nocopy JTF_VARCHAR2_TABLE_200
247 , a60 out nocopy JTF_VARCHAR2_TABLE_200
248 , a61 out nocopy JTF_VARCHAR2_TABLE_200
249 , a62 out nocopy JTF_VARCHAR2_TABLE_200
250 , a63 out nocopy JTF_VARCHAR2_TABLE_200
251 , a64 out nocopy JTF_VARCHAR2_TABLE_200
252 , a65 out nocopy JTF_VARCHAR2_TABLE_200
253 , a66 out nocopy JTF_VARCHAR2_TABLE_200
254 , a67 out nocopy JTF_VARCHAR2_TABLE_200
255 , a68 out nocopy JTF_VARCHAR2_TABLE_200
256 , a69 out nocopy JTF_VARCHAR2_TABLE_200
257 );
258
259 procedure initialize_rec(p0_a0 in out nocopy DATE
260 , p0_a1 in out nocopy NUMBER
261 , p0_a2 in out nocopy VARCHAR2
262 , p0_a3 in out nocopy NUMBER
263 , p0_a4 in out nocopy VARCHAR2
264 , p0_a5 in out nocopy NUMBER
265 , p0_a6 in out nocopy VARCHAR2
266 , p0_a7 in out nocopy NUMBER
267 , p0_a8 in out nocopy VARCHAR2
268 , p0_a9 in out nocopy DATE
269 , p0_a10 in out nocopy NUMBER
270 , p0_a11 in out nocopy NUMBER
271 , p0_a12 in out nocopy VARCHAR2
272 , p0_a13 in out nocopy VARCHAR2
273 , p0_a14 in out nocopy VARCHAR2
274 , p0_a15 in out nocopy NUMBER
275 , p0_a16 in out nocopy VARCHAR2
276 , p0_a17 in out nocopy NUMBER
277 , p0_a18 in out nocopy VARCHAR2
278 , p0_a19 in out nocopy VARCHAR2
279 , p0_a20 in out nocopy NUMBER
280 , p0_a21 in out nocopy NUMBER
281 , p0_a22 in out nocopy VARCHAR2
282 , p0_a23 in out nocopy VARCHAR2
283 , p0_a24 in out nocopy NUMBER
284 , p0_a25 in out nocopy NUMBER
285 , p0_a26 in out nocopy NUMBER
286 , p0_a27 in out nocopy NUMBER
287 , p0_a28 in out nocopy NUMBER
288 , p0_a29 in out nocopy NUMBER
289 , p0_a30 in out nocopy VARCHAR2
290 , p0_a31 in out nocopy NUMBER
291 , p0_a32 in out nocopy NUMBER
292 , p0_a33 in out nocopy VARCHAR2
293 , p0_a34 in out nocopy VARCHAR2
294 , p0_a35 in out nocopy VARCHAR2
295 , p0_a36 in out nocopy VARCHAR2
296 , p0_a37 in out nocopy VARCHAR2
297 , p0_a38 in out nocopy VARCHAR2
298 , p0_a39 in out nocopy VARCHAR2
299 , p0_a40 in out nocopy VARCHAR2
300 , p0_a41 in out nocopy VARCHAR2
301 , p0_a42 in out nocopy VARCHAR2
302 , p0_a43 in out nocopy VARCHAR2
303 , p0_a44 in out nocopy VARCHAR2
304 , p0_a45 in out nocopy VARCHAR2
305 , p0_a46 in out nocopy VARCHAR2
306 , p0_a47 in out nocopy VARCHAR2
307 , p0_a48 in out nocopy VARCHAR2
308 , p0_a49 in out nocopy VARCHAR2
309 , p0_a50 in out nocopy VARCHAR2
310 , p0_a51 in out nocopy VARCHAR2
311 , p0_a52 in out nocopy VARCHAR2
312 , p0_a53 in out nocopy VARCHAR2
313 , p0_a54 in out nocopy VARCHAR2
314 , p0_a55 in out nocopy NUMBER
315 , p0_a56 in out nocopy VARCHAR2
316 , p0_a57 in out nocopy NUMBER
317 , p0_a58 in out nocopy VARCHAR2
318 , p0_a59 in out nocopy VARCHAR2
319 , p0_a60 in out nocopy DATE
320 , p0_a61 in out nocopy NUMBER
321 , p0_a62 in out nocopy VARCHAR2
322 , p0_a63 in out nocopy VARCHAR2
323 , p0_a64 in out nocopy VARCHAR2
324 , p0_a65 in out nocopy VARCHAR2
325 , p0_a66 in out nocopy VARCHAR2
326 , p0_a67 in out nocopy VARCHAR2
327 , p0_a68 in out nocopy VARCHAR2
328 , p0_a69 in out nocopy VARCHAR2
329 , p0_a70 in out nocopy VARCHAR2
330 , p0_a71 in out nocopy VARCHAR2
331 , p0_a72 in out nocopy VARCHAR2
332 , p0_a73 in out nocopy VARCHAR2
333 , p0_a74 in out nocopy VARCHAR2
334 , p0_a75 in out nocopy VARCHAR2
335 , p0_a76 in out nocopy VARCHAR2
336 , p0_a77 in out nocopy VARCHAR2
337 , p0_a78 in out nocopy VARCHAR2
338 , p0_a79 in out nocopy VARCHAR2
339 , p0_a80 in out nocopy VARCHAR2
340 , p0_a81 in out nocopy VARCHAR2
341 , p0_a82 in out nocopy VARCHAR2
342 , p0_a83 in out nocopy VARCHAR2
343 , p0_a84 in out nocopy VARCHAR2
344 , p0_a85 in out nocopy VARCHAR2
345 , p0_a86 in out nocopy VARCHAR2
346 , p0_a87 in out nocopy VARCHAR2
347 , p0_a88 in out nocopy VARCHAR2
348 , p0_a89 in out nocopy VARCHAR2
349 , p0_a90 in out nocopy VARCHAR2
353 , p0_a94 in out nocopy NUMBER
350 , p0_a91 in out nocopy VARCHAR2
351 , p0_a92 in out nocopy VARCHAR2
352 , p0_a93 in out nocopy VARCHAR2
354 , p0_a95 in out nocopy NUMBER
355 , p0_a96 in out nocopy NUMBER
356 , p0_a97 in out nocopy NUMBER
357 , p0_a98 in out nocopy VARCHAR2
358 , p0_a99 in out nocopy DATE
359 , p0_a100 in out nocopy VARCHAR2
360 , p0_a101 in out nocopy NUMBER
361 , p0_a102 in out nocopy NUMBER
362 , p0_a103 in out nocopy VARCHAR2
363 , p0_a104 in out nocopy NUMBER
364 , p0_a105 in out nocopy VARCHAR2
365 , p0_a106 in out nocopy NUMBER
366 , p0_a107 in out nocopy NUMBER
367 , p0_a108 in out nocopy VARCHAR2
368 , p0_a109 in out nocopy NUMBER
369 , p0_a110 in out nocopy VARCHAR2
370 , p0_a111 in out nocopy VARCHAR2
371 , p0_a112 in out nocopy VARCHAR2
372 , p0_a113 in out nocopy DATE
373 , p0_a114 in out nocopy NUMBER
374 , p0_a115 in out nocopy NUMBER
375 , p0_a116 in out nocopy NUMBER
376 , p0_a117 in out nocopy NUMBER
377 , p0_a118 in out nocopy NUMBER
378 , p0_a119 in out nocopy VARCHAR2
379 , p0_a120 in out nocopy NUMBER
380 , p0_a121 in out nocopy VARCHAR2
381 , p0_a122 in out nocopy NUMBER
382 , p0_a123 in out nocopy VARCHAR2
383 , p0_a124 in out nocopy NUMBER
384 , p0_a125 in out nocopy VARCHAR2
385 , p0_a126 in out nocopy VARCHAR2
386 , p0_a127 in out nocopy VARCHAR2
387 , p0_a128 in out nocopy VARCHAR2
388 , p0_a129 in out nocopy VARCHAR2
389 , p0_a130 in out nocopy VARCHAR2
390 , p0_a131 in out nocopy NUMBER
391 , p0_a132 in out nocopy NUMBER
392 , p0_a133 in out nocopy VARCHAR2
393 , p0_a134 in out nocopy NUMBER
394 , p0_a135 in out nocopy NUMBER
395 , p0_a136 in out nocopy VARCHAR2
396 , p0_a137 in out nocopy VARCHAR2
397 , p0_a138 in out nocopy VARCHAR2
398 , p0_a139 in out nocopy VARCHAR2
399 , p0_a140 in out nocopy VARCHAR2
400 , p0_a141 in out nocopy VARCHAR2
401 , p0_a142 in out nocopy NUMBER
402 , p0_a143 in out nocopy VARCHAR2
403 , p0_a144 in out nocopy NUMBER
404 , p0_a145 in out nocopy VARCHAR2
405 , p0_a146 in out nocopy DATE
406 , p0_a147 in out nocopy DATE
407 , p0_a148 in out nocopy DATE
408 , p0_a149 in out nocopy VARCHAR2
409 , p0_a150 in out nocopy NUMBER
410 , p0_a151 in out nocopy VARCHAR2
411 , p0_a152 in out nocopy VARCHAR2
412 , p0_a153 in out nocopy VARCHAR2
413 , p0_a154 in out nocopy VARCHAR2
414 , p0_a155 in out nocopy VARCHAR2
415 , p0_a156 in out nocopy VARCHAR2
416 , p0_a157 in out nocopy VARCHAR2
417 , p0_a158 in out nocopy VARCHAR2
418 , p0_a159 in out nocopy VARCHAR2
419 , p0_a160 in out nocopy VARCHAR2
420 , p0_a161 in out nocopy VARCHAR2
421 , p0_a162 in out nocopy VARCHAR2
422 , p0_a163 in out nocopy VARCHAR2
423 , p0_a164 in out nocopy DATE
424 , p0_a165 in out nocopy VARCHAR
425 , p0_a166 in out nocopy VARCHAR
426 , p0_a167 in out nocopy VARCHAR
427 , p0_a168 in out nocopy VARCHAR
428 , p0_a169 in out nocopy NUMBER
429 , p0_a170 in out nocopy NUMBER
430 , p0_a171 in out nocopy NUMBER
431 , p0_a172 in out nocopy NUMBER
432 , p0_a173 in out nocopy NUMBER
433 , p0_a174 in out nocopy VARCHAR2
434 , p0_a175 in out nocopy VARCHAR2
435 , p0_a176 in out nocopy NUMBER
436 , p0_a177 in out nocopy NUMBER
437 , p0_a178 in out nocopy NUMBER
438 , p0_a179 in out nocopy NUMBER
439 , p0_a180 in out nocopy NUMBER
440 , p0_a181 in out nocopy NUMBER
441 , p0_a182 in out nocopy NUMBER
442 , p0_a183 in out nocopy NUMBER
443 , p0_a184 in out nocopy VARCHAR2
444 , p0_a185 in out nocopy VARCHAR2
445 , p0_a186 in out nocopy VARCHAR2
446 , p0_a187 in out nocopy VARCHAR2
447 , p0_a188 in out nocopy VARCHAR2
448 , p0_a189 in out nocopy VARCHAR2
449 , p0_a190 in out nocopy VARCHAR2
450 , p0_a191 in out nocopy VARCHAR2
451 , p0_a192 in out nocopy VARCHAR2
452 , p0_a193 in out nocopy VARCHAR2
453 , p0_a194 in out nocopy VARCHAR2
454 , p0_a195 in out nocopy VARCHAR2
455 , p0_a196 in out nocopy VARCHAR2
456 , p0_a197 in out nocopy VARCHAR2
457 , p0_a198 in out nocopy VARCHAR2
458 , p0_a199 in out nocopy VARCHAR2
459 , p0_a200 in out nocopy VARCHAR2
460 , p0_a201 in out nocopy VARCHAR2
461 , p0_a202 in out nocopy VARCHAR2
462 , p0_a203 in out nocopy VARCHAR2
463 , p0_a204 in out nocopy VARCHAR2
464 , p0_a205 in out nocopy NUMBER
465 , p0_a206 in out nocopy VARCHAR2
466 , p0_a207 in out nocopy NUMBER
467 , p0_a208 in out nocopy VARCHAR2
468 , p0_a209 in out nocopy VARCHAR2
469 , p0_a210 in out nocopy NUMBER
470 , p0_a211 in out nocopy DATE
471 , p0_a212 in out nocopy NUMBER
472 , p0_a213 in out nocopy NUMBER
473 , p0_a214 in out nocopy NUMBER
474 , p0_a215 in out nocopy NUMBER
475 , p0_a216 in out nocopy NUMBER
476 , p0_a217 in out nocopy DATE
477 , p0_a218 in out nocopy DATE
478 , p0_a219 in out nocopy DATE
479 , p0_a220 in out nocopy DATE
480 , p0_a221 in out nocopy DATE
481 , p0_a222 in out nocopy DATE
482 , p0_a223 in out nocopy NUMBER
483 , p0_a224 in out nocopy NUMBER
484 , p0_a225 in out nocopy NUMBER
485 );
486 procedure create_servicerequest(p_api_version NUMBER
487 , p_init_msg_list VARCHAR2
488 , p_commit VARCHAR2
489 , x_return_status out nocopy VARCHAR2
490 , x_msg_count out nocopy NUMBER
494 , p_user_id NUMBER
491 , x_msg_data out nocopy VARCHAR2
492 , p_resp_appl_id NUMBER
493 , p_resp_id NUMBER
495 , p_login_id NUMBER
496 , p_org_id NUMBER
497 , p_request_id NUMBER
498 , p_request_number VARCHAR2
499 , p13_a0 DATE
500 , p13_a1 NUMBER
501 , p13_a2 VARCHAR2
502 , p13_a3 NUMBER
503 , p13_a4 VARCHAR2
504 , p13_a5 NUMBER
505 , p13_a6 VARCHAR2
506 , p13_a7 NUMBER
507 , p13_a8 VARCHAR2
508 , p13_a9 DATE
509 , p13_a10 NUMBER
510 , p13_a11 NUMBER
511 , p13_a12 VARCHAR2
512 , p13_a13 VARCHAR2
513 , p13_a14 VARCHAR2
514 , p13_a15 NUMBER
515 , p13_a16 VARCHAR2
516 , p13_a17 NUMBER
517 , p13_a18 VARCHAR2
518 , p13_a19 VARCHAR2
519 , p13_a20 NUMBER
520 , p13_a21 NUMBER
521 , p13_a22 VARCHAR2
522 , p13_a23 VARCHAR2
523 , p13_a24 NUMBER
524 , p13_a25 NUMBER
525 , p13_a26 NUMBER
526 , p13_a27 NUMBER
527 , p13_a28 NUMBER
528 , p13_a29 NUMBER
529 , p13_a30 VARCHAR2
530 , p13_a31 NUMBER
531 , p13_a32 NUMBER
532 , p13_a33 VARCHAR2
533 , p13_a34 VARCHAR2
534 , p13_a35 VARCHAR2
535 , p13_a36 VARCHAR2
536 , p13_a37 VARCHAR2
537 , p13_a38 VARCHAR2
538 , p13_a39 VARCHAR2
539 , p13_a40 VARCHAR2
540 , p13_a41 VARCHAR2
541 , p13_a42 VARCHAR2
542 , p13_a43 VARCHAR2
543 , p13_a44 VARCHAR2
544 , p13_a45 VARCHAR2
545 , p13_a46 VARCHAR2
546 , p13_a47 VARCHAR2
547 , p13_a48 VARCHAR2
548 , p13_a49 VARCHAR2
549 , p13_a50 VARCHAR2
550 , p13_a51 VARCHAR2
551 , p13_a52 VARCHAR2
552 , p13_a53 VARCHAR2
553 , p13_a54 VARCHAR2
554 , p13_a55 NUMBER
555 , p13_a56 VARCHAR2
556 , p13_a57 NUMBER
557 , p13_a58 VARCHAR2
558 , p13_a59 VARCHAR2
559 , p13_a60 DATE
560 , p13_a61 NUMBER
561 , p13_a62 VARCHAR2
562 , p13_a63 VARCHAR2
563 , p13_a64 VARCHAR2
564 , p13_a65 VARCHAR2
565 , p13_a66 VARCHAR2
566 , p13_a67 VARCHAR2
567 , p13_a68 VARCHAR2
568 , p13_a69 VARCHAR2
569 , p13_a70 VARCHAR2
570 , p13_a71 VARCHAR2
571 , p13_a72 VARCHAR2
572 , p13_a73 VARCHAR2
573 , p13_a74 VARCHAR2
574 , p13_a75 VARCHAR2
575 , p13_a76 VARCHAR2
576 , p13_a77 VARCHAR2
577 , p13_a78 VARCHAR2
578 , p13_a79 VARCHAR2
579 , p13_a80 VARCHAR2
580 , p13_a81 VARCHAR2
581 , p13_a82 VARCHAR2
582 , p13_a83 VARCHAR2
583 , p13_a84 VARCHAR2
584 , p13_a85 VARCHAR2
585 , p13_a86 VARCHAR2
586 , p13_a87 VARCHAR2
587 , p13_a88 VARCHAR2
588 , p13_a89 VARCHAR2
589 , p13_a90 VARCHAR2
590 , p13_a91 VARCHAR2
591 , p13_a92 VARCHAR2
592 , p13_a93 VARCHAR2
593 , p13_a94 NUMBER
594 , p13_a95 NUMBER
595 , p13_a96 NUMBER
596 , p13_a97 NUMBER
597 , p13_a98 VARCHAR2
598 , p13_a99 DATE
599 , p13_a100 VARCHAR2
600 , p13_a101 NUMBER
601 , p13_a102 NUMBER
602 , p13_a103 VARCHAR2
603 , p13_a104 NUMBER
604 , p13_a105 VARCHAR2
605 , p13_a106 NUMBER
606 , p13_a107 NUMBER
607 , p13_a108 VARCHAR2
608 , p13_a109 NUMBER
609 , p13_a110 VARCHAR2
610 , p13_a111 VARCHAR2
611 , p13_a112 VARCHAR2
612 , p13_a113 DATE
613 , p13_a114 NUMBER
614 , p13_a115 NUMBER
615 , p13_a116 NUMBER
616 , p13_a117 NUMBER
617 , p13_a118 NUMBER
618 , p13_a119 VARCHAR2
619 , p13_a120 NUMBER
620 , p13_a121 VARCHAR2
621 , p13_a122 NUMBER
622 , p13_a123 VARCHAR2
623 , p13_a124 NUMBER
624 , p13_a125 VARCHAR2
625 , p13_a126 VARCHAR2
626 , p13_a127 VARCHAR2
627 , p13_a128 VARCHAR2
628 , p13_a129 VARCHAR2
629 , p13_a130 VARCHAR2
630 , p13_a131 NUMBER
631 , p13_a132 NUMBER
632 , p13_a133 VARCHAR2
633 , p13_a134 NUMBER
634 , p13_a135 NUMBER
635 , p13_a136 VARCHAR2
636 , p13_a137 VARCHAR2
637 , p13_a138 VARCHAR2
638 , p13_a139 VARCHAR2
639 , p13_a140 VARCHAR2
640 , p13_a141 VARCHAR2
641 , p13_a142 NUMBER
642 , p13_a143 VARCHAR2
643 , p13_a144 NUMBER
644 , p13_a145 VARCHAR2
645 , p13_a146 DATE
646 , p13_a147 DATE
647 , p13_a148 DATE
648 , p13_a149 VARCHAR2
649 , p13_a150 NUMBER
650 , p13_a151 VARCHAR2
651 , p13_a152 VARCHAR2
652 , p13_a153 VARCHAR2
653 , p13_a154 VARCHAR2
654 , p13_a155 VARCHAR2
655 , p13_a156 VARCHAR2
656 , p13_a157 VARCHAR2
657 , p13_a158 VARCHAR2
658 , p13_a159 VARCHAR2
659 , p13_a160 VARCHAR2
660 , p13_a161 VARCHAR2
661 , p13_a162 VARCHAR2
662 , p13_a163 VARCHAR2
663 , p13_a164 DATE
664 , p13_a165 VARCHAR
665 , p13_a166 VARCHAR
666 , p13_a167 VARCHAR
667 , p13_a168 VARCHAR
668 , p13_a169 NUMBER
669 , p13_a170 NUMBER
670 , p13_a171 NUMBER
671 , p13_a172 NUMBER
672 , p13_a173 NUMBER
676 , p13_a177 NUMBER
673 , p13_a174 VARCHAR2
674 , p13_a175 VARCHAR2
675 , p13_a176 NUMBER
677 , p13_a178 NUMBER
678 , p13_a179 NUMBER
679 , p13_a180 NUMBER
680 , p13_a181 NUMBER
681 , p13_a182 NUMBER
682 , p13_a183 NUMBER
683 , p13_a184 VARCHAR2
684 , p13_a185 VARCHAR2
685 , p13_a186 VARCHAR2
686 , p13_a187 VARCHAR2
687 , p13_a188 VARCHAR2
688 , p13_a189 VARCHAR2
689 , p13_a190 VARCHAR2
690 , p13_a191 VARCHAR2
691 , p13_a192 VARCHAR2
692 , p13_a193 VARCHAR2
693 , p13_a194 VARCHAR2
694 , p13_a195 VARCHAR2
695 , p13_a196 VARCHAR2
696 , p13_a197 VARCHAR2
697 , p13_a198 VARCHAR2
698 , p13_a199 VARCHAR2
699 , p13_a200 VARCHAR2
700 , p13_a201 VARCHAR2
701 , p13_a202 VARCHAR2
702 , p13_a203 VARCHAR2
703 , p13_a204 VARCHAR2
704 , p13_a205 NUMBER
705 , p13_a206 VARCHAR2
706 , p13_a207 NUMBER
707 , p13_a208 VARCHAR2
708 , p13_a209 VARCHAR2
709 , p13_a210 NUMBER
710 , p13_a211 DATE
711 , p13_a212 NUMBER
712 , p13_a213 NUMBER
713 , p13_a214 NUMBER
714 , p13_a215 NUMBER
715 , p13_a216 NUMBER
716 , p13_a217 DATE
717 , p13_a218 DATE
718 , p13_a219 DATE
719 , p13_a220 DATE
720 , p13_a221 DATE
721 , p13_a222 DATE
722 , p13_a223 NUMBER
723 , p13_a224 NUMBER
724 , p13_a225 NUMBER
725 , p14_a0 JTF_VARCHAR2_TABLE_2000
726 , p14_a1 JTF_VARCHAR2_TABLE_32767
727 , p14_a2 JTF_VARCHAR2_TABLE_300
728 , p14_a3 JTF_VARCHAR2_TABLE_100
729 , p14_a4 JTF_NUMBER_TABLE
730 , p14_a5 JTF_VARCHAR2_TABLE_100
731 , p14_a6 JTF_NUMBER_TABLE
732 , p14_a7 JTF_VARCHAR2_TABLE_100
733 , p14_a8 JTF_NUMBER_TABLE
734 , p15_a0 JTF_NUMBER_TABLE
735 , p15_a1 JTF_NUMBER_TABLE
736 , p15_a2 JTF_NUMBER_TABLE
737 , p15_a3 JTF_VARCHAR2_TABLE_100
738 , p15_a4 JTF_VARCHAR2_TABLE_100
739 , p15_a5 JTF_VARCHAR2_TABLE_100
740 , p15_a6 JTF_VARCHAR2_TABLE_100
741 , p15_a7 JTF_DATE_TABLE
742 , p15_a8 JTF_DATE_TABLE
743 , p_auto_assign VARCHAR2
744 , p_auto_generate_tasks VARCHAR2
745 , p18_a0 out nocopy NUMBER
746 , p18_a1 out nocopy VARCHAR2
747 , p18_a2 out nocopy NUMBER
748 , p18_a3 out nocopy NUMBER
749 , p18_a4 out nocopy NUMBER
750 , p18_a5 out nocopy NUMBER
751 , p18_a6 out nocopy VARCHAR2
752 , p18_a7 out nocopy VARCHAR2
753 , p18_a8 out nocopy NUMBER
754 , p18_a9 out nocopy NUMBER
755 , p18_a10 out nocopy NUMBER
756 , p18_a11 out nocopy DATE
757 , p18_a12 out nocopy DATE
758 , p18_a13 out nocopy DATE
759 , p18_a14 out nocopy DATE
760 , p18_a15 out nocopy NUMBER
761 , p_default_contract_sla_ind VARCHAR2
762 , p_default_coverage_template_id NUMBER
763 );
764 procedure create_servicerequest(p_api_version NUMBER
765 , p_init_msg_list VARCHAR2
766 , p_commit VARCHAR2
767 , x_return_status out nocopy VARCHAR2
768 , x_msg_count out nocopy NUMBER
769 , x_msg_data out nocopy VARCHAR2
770 , p_resp_appl_id NUMBER
771 , p_resp_id NUMBER
772 , p_user_id NUMBER
773 , p_login_id NUMBER
774 , p_org_id NUMBER
775 , p_request_id NUMBER
776 , p_request_number VARCHAR2
777 , p13_a0 DATE
778 , p13_a1 NUMBER
779 , p13_a2 VARCHAR2
780 , p13_a3 NUMBER
781 , p13_a4 VARCHAR2
782 , p13_a5 NUMBER
783 , p13_a6 VARCHAR2
784 , p13_a7 NUMBER
785 , p13_a8 VARCHAR2
786 , p13_a9 DATE
787 , p13_a10 NUMBER
788 , p13_a11 NUMBER
789 , p13_a12 VARCHAR2
790 , p13_a13 VARCHAR2
791 , p13_a14 VARCHAR2
792 , p13_a15 NUMBER
793 , p13_a16 VARCHAR2
794 , p13_a17 NUMBER
795 , p13_a18 VARCHAR2
796 , p13_a19 VARCHAR2
797 , p13_a20 NUMBER
798 , p13_a21 NUMBER
799 , p13_a22 VARCHAR2
800 , p13_a23 VARCHAR2
801 , p13_a24 NUMBER
802 , p13_a25 NUMBER
803 , p13_a26 NUMBER
804 , p13_a27 NUMBER
805 , p13_a28 NUMBER
806 , p13_a29 NUMBER
807 , p13_a30 VARCHAR2
808 , p13_a31 NUMBER
809 , p13_a32 NUMBER
810 , p13_a33 VARCHAR2
811 , p13_a34 VARCHAR2
812 , p13_a35 VARCHAR2
813 , p13_a36 VARCHAR2
814 , p13_a37 VARCHAR2
815 , p13_a38 VARCHAR2
816 , p13_a39 VARCHAR2
817 , p13_a40 VARCHAR2
818 , p13_a41 VARCHAR2
819 , p13_a42 VARCHAR2
820 , p13_a43 VARCHAR2
821 , p13_a44 VARCHAR2
822 , p13_a45 VARCHAR2
823 , p13_a46 VARCHAR2
824 , p13_a47 VARCHAR2
825 , p13_a48 VARCHAR2
826 , p13_a49 VARCHAR2
827 , p13_a50 VARCHAR2
828 , p13_a51 VARCHAR2
829 , p13_a52 VARCHAR2
830 , p13_a53 VARCHAR2
831 , p13_a54 VARCHAR2
832 , p13_a55 NUMBER
833 , p13_a56 VARCHAR2
834 , p13_a57 NUMBER
835 , p13_a58 VARCHAR2
836 , p13_a59 VARCHAR2
837 , p13_a60 DATE
838 , p13_a61 NUMBER
839 , p13_a62 VARCHAR2
840 , p13_a63 VARCHAR2
841 , p13_a64 VARCHAR2
842 , p13_a65 VARCHAR2
843 , p13_a66 VARCHAR2
844 , p13_a67 VARCHAR2
845 , p13_a68 VARCHAR2
846 , p13_a69 VARCHAR2
847 , p13_a70 VARCHAR2
848 , p13_a71 VARCHAR2
849 , p13_a72 VARCHAR2
853 , p13_a76 VARCHAR2
850 , p13_a73 VARCHAR2
851 , p13_a74 VARCHAR2
852 , p13_a75 VARCHAR2
854 , p13_a77 VARCHAR2
855 , p13_a78 VARCHAR2
856 , p13_a79 VARCHAR2
857 , p13_a80 VARCHAR2
858 , p13_a81 VARCHAR2
859 , p13_a82 VARCHAR2
860 , p13_a83 VARCHAR2
861 , p13_a84 VARCHAR2
862 , p13_a85 VARCHAR2
863 , p13_a86 VARCHAR2
864 , p13_a87 VARCHAR2
865 , p13_a88 VARCHAR2
866 , p13_a89 VARCHAR2
867 , p13_a90 VARCHAR2
868 , p13_a91 VARCHAR2
869 , p13_a92 VARCHAR2
870 , p13_a93 VARCHAR2
871 , p13_a94 NUMBER
872 , p13_a95 NUMBER
873 , p13_a96 NUMBER
874 , p13_a97 NUMBER
875 , p13_a98 VARCHAR2
876 , p13_a99 DATE
877 , p13_a100 VARCHAR2
878 , p13_a101 NUMBER
879 , p13_a102 NUMBER
880 , p13_a103 VARCHAR2
881 , p13_a104 NUMBER
882 , p13_a105 VARCHAR2
883 , p13_a106 NUMBER
884 , p13_a107 NUMBER
885 , p13_a108 VARCHAR2
886 , p13_a109 NUMBER
887 , p13_a110 VARCHAR2
888 , p13_a111 VARCHAR2
889 , p13_a112 VARCHAR2
890 , p13_a113 DATE
891 , p13_a114 NUMBER
892 , p13_a115 NUMBER
893 , p13_a116 NUMBER
894 , p13_a117 NUMBER
895 , p13_a118 NUMBER
896 , p13_a119 VARCHAR2
897 , p13_a120 NUMBER
898 , p13_a121 VARCHAR2
899 , p13_a122 NUMBER
900 , p13_a123 VARCHAR2
901 , p13_a124 NUMBER
902 , p13_a125 VARCHAR2
903 , p13_a126 VARCHAR2
904 , p13_a127 VARCHAR2
905 , p13_a128 VARCHAR2
906 , p13_a129 VARCHAR2
907 , p13_a130 VARCHAR2
908 , p13_a131 NUMBER
909 , p13_a132 NUMBER
910 , p13_a133 VARCHAR2
911 , p13_a134 NUMBER
912 , p13_a135 NUMBER
913 , p13_a136 VARCHAR2
914 , p13_a137 VARCHAR2
915 , p13_a138 VARCHAR2
916 , p13_a139 VARCHAR2
917 , p13_a140 VARCHAR2
918 , p13_a141 VARCHAR2
919 , p13_a142 NUMBER
920 , p13_a143 VARCHAR2
921 , p13_a144 NUMBER
922 , p13_a145 VARCHAR2
923 , p13_a146 DATE
924 , p13_a147 DATE
925 , p13_a148 DATE
926 , p13_a149 VARCHAR2
927 , p13_a150 NUMBER
928 , p13_a151 VARCHAR2
929 , p13_a152 VARCHAR2
930 , p13_a153 VARCHAR2
931 , p13_a154 VARCHAR2
932 , p13_a155 VARCHAR2
933 , p13_a156 VARCHAR2
934 , p13_a157 VARCHAR2
935 , p13_a158 VARCHAR2
936 , p13_a159 VARCHAR2
937 , p13_a160 VARCHAR2
938 , p13_a161 VARCHAR2
939 , p13_a162 VARCHAR2
940 , p13_a163 VARCHAR2
941 , p13_a164 DATE
942 , p13_a165 VARCHAR
943 , p13_a166 VARCHAR
944 , p13_a167 VARCHAR
945 , p13_a168 VARCHAR
946 , p13_a169 NUMBER
947 , p13_a170 NUMBER
948 , p13_a171 NUMBER
949 , p13_a172 NUMBER
950 , p13_a173 NUMBER
951 , p13_a174 VARCHAR2
952 , p13_a175 VARCHAR2
953 , p13_a176 NUMBER
954 , p13_a177 NUMBER
955 , p13_a178 NUMBER
956 , p13_a179 NUMBER
957 , p13_a180 NUMBER
958 , p13_a181 NUMBER
959 , p13_a182 NUMBER
960 , p13_a183 NUMBER
961 , p13_a184 VARCHAR2
962 , p13_a185 VARCHAR2
963 , p13_a186 VARCHAR2
964 , p13_a187 VARCHAR2
965 , p13_a188 VARCHAR2
966 , p13_a189 VARCHAR2
967 , p13_a190 VARCHAR2
968 , p13_a191 VARCHAR2
969 , p13_a192 VARCHAR2
970 , p13_a193 VARCHAR2
971 , p13_a194 VARCHAR2
972 , p13_a195 VARCHAR2
973 , p13_a196 VARCHAR2
974 , p13_a197 VARCHAR2
975 , p13_a198 VARCHAR2
976 , p13_a199 VARCHAR2
977 , p13_a200 VARCHAR2
978 , p13_a201 VARCHAR2
979 , p13_a202 VARCHAR2
980 , p13_a203 VARCHAR2
981 , p13_a204 VARCHAR2
982 , p13_a205 NUMBER
983 , p13_a206 VARCHAR2
984 , p13_a207 NUMBER
985 , p13_a208 VARCHAR2
986 , p13_a209 VARCHAR2
987 , p13_a210 NUMBER
988 , p13_a211 DATE
989 , p13_a212 NUMBER
990 , p13_a213 NUMBER
991 , p13_a214 NUMBER
992 , p13_a215 NUMBER
993 , p13_a216 NUMBER
994 , p13_a217 DATE
995 , p13_a218 DATE
996 , p13_a219 DATE
997 , p13_a220 DATE
998 , p13_a221 DATE
999 , p13_a222 DATE
1000 , p13_a223 NUMBER
1001 , p13_a224 NUMBER
1002 , p13_a225 NUMBER
1003 , p14_a0 JTF_VARCHAR2_TABLE_2000
1004 , p14_a1 JTF_VARCHAR2_TABLE_32767
1005 , p14_a2 JTF_VARCHAR2_TABLE_300
1006 , p14_a3 JTF_VARCHAR2_TABLE_100
1007 , p14_a4 JTF_NUMBER_TABLE
1008 , p14_a5 JTF_VARCHAR2_TABLE_100
1009 , p14_a6 JTF_NUMBER_TABLE
1010 , p14_a7 JTF_VARCHAR2_TABLE_100
1011 , p14_a8 JTF_NUMBER_TABLE
1012 , p15_a0 JTF_NUMBER_TABLE
1013 , p15_a1 JTF_NUMBER_TABLE
1014 , p15_a2 JTF_NUMBER_TABLE
1015 , p15_a3 JTF_VARCHAR2_TABLE_100
1016 , p15_a4 JTF_VARCHAR2_TABLE_100
1017 , p15_a5 JTF_VARCHAR2_TABLE_100
1018 , p15_a6 JTF_VARCHAR2_TABLE_100
1019 , p15_a7 JTF_DATE_TABLE
1020 , p15_a8 JTF_DATE_TABLE
1021 , p_auto_assign VARCHAR2
1022 , p_default_contract_sla_ind VARCHAR2
1023 , x_request_id out nocopy NUMBER
1024 , x_request_number out nocopy VARCHAR2
1025 , x_interaction_id out nocopy NUMBER
1026 , x_workflow_process_id out nocopy NUMBER
1027 , x_individual_owner out nocopy NUMBER
1028 , x_group_owner out nocopy NUMBER
1032 , p_init_msg_list VARCHAR2
1029 , x_individual_type out nocopy VARCHAR2
1030 );
1031 procedure update_servicerequest(p_api_version NUMBER
1033 , p_commit VARCHAR2
1034 , x_return_status out nocopy VARCHAR2
1035 , x_msg_count out nocopy NUMBER
1036 , x_msg_data out nocopy VARCHAR2
1037 , p_request_id NUMBER
1038 , p_request_number VARCHAR2
1039 , p_audit_comments VARCHAR2
1040 , p_object_version_number NUMBER
1041 , p_resp_appl_id NUMBER
1042 , p_resp_id NUMBER
1043 , p_last_updated_by NUMBER
1044 , p_last_update_login NUMBER
1045 , p_last_update_date date
1046 , p15_a0 DATE
1047 , p15_a1 NUMBER
1048 , p15_a2 VARCHAR2
1049 , p15_a3 NUMBER
1050 , p15_a4 VARCHAR2
1051 , p15_a5 NUMBER
1052 , p15_a6 VARCHAR2
1053 , p15_a7 NUMBER
1054 , p15_a8 VARCHAR2
1055 , p15_a9 DATE
1056 , p15_a10 NUMBER
1057 , p15_a11 NUMBER
1058 , p15_a12 VARCHAR2
1059 , p15_a13 VARCHAR2
1060 , p15_a14 VARCHAR2
1061 , p15_a15 NUMBER
1062 , p15_a16 VARCHAR2
1063 , p15_a17 NUMBER
1064 , p15_a18 VARCHAR2
1065 , p15_a19 VARCHAR2
1066 , p15_a20 NUMBER
1067 , p15_a21 NUMBER
1068 , p15_a22 VARCHAR2
1069 , p15_a23 VARCHAR2
1070 , p15_a24 NUMBER
1071 , p15_a25 NUMBER
1072 , p15_a26 NUMBER
1073 , p15_a27 NUMBER
1074 , p15_a28 NUMBER
1075 , p15_a29 NUMBER
1076 , p15_a30 VARCHAR2
1077 , p15_a31 NUMBER
1078 , p15_a32 NUMBER
1079 , p15_a33 VARCHAR2
1080 , p15_a34 VARCHAR2
1081 , p15_a35 VARCHAR2
1082 , p15_a36 VARCHAR2
1083 , p15_a37 VARCHAR2
1084 , p15_a38 VARCHAR2
1085 , p15_a39 VARCHAR2
1086 , p15_a40 VARCHAR2
1087 , p15_a41 VARCHAR2
1088 , p15_a42 VARCHAR2
1089 , p15_a43 VARCHAR2
1090 , p15_a44 VARCHAR2
1091 , p15_a45 VARCHAR2
1092 , p15_a46 VARCHAR2
1093 , p15_a47 VARCHAR2
1094 , p15_a48 VARCHAR2
1095 , p15_a49 VARCHAR2
1096 , p15_a50 VARCHAR2
1097 , p15_a51 VARCHAR2
1098 , p15_a52 VARCHAR2
1099 , p15_a53 VARCHAR2
1100 , p15_a54 VARCHAR2
1101 , p15_a55 NUMBER
1102 , p15_a56 VARCHAR2
1103 , p15_a57 NUMBER
1104 , p15_a58 VARCHAR2
1105 , p15_a59 VARCHAR2
1106 , p15_a60 DATE
1107 , p15_a61 NUMBER
1108 , p15_a62 VARCHAR2
1109 , p15_a63 VARCHAR2
1110 , p15_a64 VARCHAR2
1111 , p15_a65 VARCHAR2
1112 , p15_a66 VARCHAR2
1113 , p15_a67 VARCHAR2
1114 , p15_a68 VARCHAR2
1115 , p15_a69 VARCHAR2
1116 , p15_a70 VARCHAR2
1117 , p15_a71 VARCHAR2
1118 , p15_a72 VARCHAR2
1119 , p15_a73 VARCHAR2
1120 , p15_a74 VARCHAR2
1121 , p15_a75 VARCHAR2
1122 , p15_a76 VARCHAR2
1123 , p15_a77 VARCHAR2
1124 , p15_a78 VARCHAR2
1125 , p15_a79 VARCHAR2
1126 , p15_a80 VARCHAR2
1127 , p15_a81 VARCHAR2
1128 , p15_a82 VARCHAR2
1129 , p15_a83 VARCHAR2
1130 , p15_a84 VARCHAR2
1131 , p15_a85 VARCHAR2
1132 , p15_a86 VARCHAR2
1133 , p15_a87 VARCHAR2
1134 , p15_a88 VARCHAR2
1135 , p15_a89 VARCHAR2
1136 , p15_a90 VARCHAR2
1137 , p15_a91 VARCHAR2
1138 , p15_a92 VARCHAR2
1139 , p15_a93 VARCHAR2
1140 , p15_a94 NUMBER
1141 , p15_a95 NUMBER
1142 , p15_a96 NUMBER
1143 , p15_a97 NUMBER
1144 , p15_a98 VARCHAR2
1145 , p15_a99 DATE
1146 , p15_a100 VARCHAR2
1147 , p15_a101 NUMBER
1148 , p15_a102 NUMBER
1149 , p15_a103 VARCHAR2
1150 , p15_a104 NUMBER
1151 , p15_a105 VARCHAR2
1152 , p15_a106 NUMBER
1153 , p15_a107 NUMBER
1154 , p15_a108 VARCHAR2
1155 , p15_a109 NUMBER
1156 , p15_a110 VARCHAR2
1157 , p15_a111 VARCHAR2
1158 , p15_a112 VARCHAR2
1159 , p15_a113 DATE
1160 , p15_a114 NUMBER
1161 , p15_a115 NUMBER
1162 , p15_a116 NUMBER
1163 , p15_a117 NUMBER
1164 , p15_a118 NUMBER
1165 , p15_a119 VARCHAR2
1166 , p15_a120 NUMBER
1167 , p15_a121 VARCHAR2
1168 , p15_a122 NUMBER
1169 , p15_a123 VARCHAR2
1170 , p15_a124 NUMBER
1171 , p15_a125 VARCHAR2
1172 , p15_a126 VARCHAR2
1173 , p15_a127 VARCHAR2
1174 , p15_a128 VARCHAR2
1175 , p15_a129 VARCHAR2
1176 , p15_a130 VARCHAR2
1177 , p15_a131 NUMBER
1178 , p15_a132 NUMBER
1179 , p15_a133 VARCHAR2
1180 , p15_a134 NUMBER
1181 , p15_a135 NUMBER
1182 , p15_a136 VARCHAR2
1183 , p15_a137 VARCHAR2
1184 , p15_a138 VARCHAR2
1185 , p15_a139 VARCHAR2
1186 , p15_a140 VARCHAR2
1187 , p15_a141 VARCHAR2
1188 , p15_a142 NUMBER
1189 , p15_a143 VARCHAR2
1190 , p15_a144 NUMBER
1191 , p15_a145 VARCHAR2
1192 , p15_a146 DATE
1193 , p15_a147 DATE
1194 , p15_a148 DATE
1195 , p15_a149 VARCHAR2
1196 , p15_a150 NUMBER
1197 , p15_a151 VARCHAR2
1198 , p15_a152 VARCHAR2
1199 , p15_a153 VARCHAR2
1200 , p15_a154 VARCHAR2
1201 , p15_a155 VARCHAR2
1202 , p15_a156 VARCHAR2
1203 , p15_a157 VARCHAR2
1204 , p15_a158 VARCHAR2
1205 , p15_a159 VARCHAR2
1206 , p15_a160 VARCHAR2
1207 , p15_a161 VARCHAR2
1208 , p15_a162 VARCHAR2
1209 , p15_a163 VARCHAR2
1210 , p15_a164 DATE
1211 , p15_a165 VARCHAR
1212 , p15_a166 VARCHAR
1216 , p15_a170 NUMBER
1213 , p15_a167 VARCHAR
1214 , p15_a168 VARCHAR
1215 , p15_a169 NUMBER
1217 , p15_a171 NUMBER
1218 , p15_a172 NUMBER
1219 , p15_a173 NUMBER
1220 , p15_a174 VARCHAR2
1221 , p15_a175 VARCHAR2
1222 , p15_a176 NUMBER
1223 , p15_a177 NUMBER
1224 , p15_a178 NUMBER
1225 , p15_a179 NUMBER
1226 , p15_a180 NUMBER
1227 , p15_a181 NUMBER
1228 , p15_a182 NUMBER
1229 , p15_a183 NUMBER
1230 , p15_a184 VARCHAR2
1231 , p15_a185 VARCHAR2
1232 , p15_a186 VARCHAR2
1233 , p15_a187 VARCHAR2
1234 , p15_a188 VARCHAR2
1235 , p15_a189 VARCHAR2
1236 , p15_a190 VARCHAR2
1237 , p15_a191 VARCHAR2
1238 , p15_a192 VARCHAR2
1239 , p15_a193 VARCHAR2
1240 , p15_a194 VARCHAR2
1241 , p15_a195 VARCHAR2
1242 , p15_a196 VARCHAR2
1243 , p15_a197 VARCHAR2
1244 , p15_a198 VARCHAR2
1245 , p15_a199 VARCHAR2
1246 , p15_a200 VARCHAR2
1247 , p15_a201 VARCHAR2
1248 , p15_a202 VARCHAR2
1249 , p15_a203 VARCHAR2
1250 , p15_a204 VARCHAR2
1251 , p15_a205 NUMBER
1252 , p15_a206 VARCHAR2
1253 , p15_a207 NUMBER
1254 , p15_a208 VARCHAR2
1255 , p15_a209 VARCHAR2
1256 , p15_a210 NUMBER
1257 , p15_a211 DATE
1258 , p15_a212 NUMBER
1259 , p15_a213 NUMBER
1260 , p15_a214 NUMBER
1261 , p15_a215 NUMBER
1262 , p15_a216 NUMBER
1263 , p15_a217 DATE
1264 , p15_a218 DATE
1265 , p15_a219 DATE
1266 , p15_a220 DATE
1267 , p15_a221 DATE
1268 , p15_a222 DATE
1269 , p15_a223 NUMBER
1270 , p15_a224 NUMBER
1271 , p15_a225 NUMBER
1272 , p16_a0 JTF_VARCHAR2_TABLE_2000
1273 , p16_a1 JTF_VARCHAR2_TABLE_32767
1274 , p16_a2 JTF_VARCHAR2_TABLE_300
1275 , p16_a3 JTF_VARCHAR2_TABLE_100
1276 , p16_a4 JTF_NUMBER_TABLE
1277 , p16_a5 JTF_VARCHAR2_TABLE_100
1278 , p16_a6 JTF_NUMBER_TABLE
1279 , p16_a7 JTF_VARCHAR2_TABLE_100
1280 , p16_a8 JTF_NUMBER_TABLE
1281 , p17_a0 JTF_NUMBER_TABLE
1282 , p17_a1 JTF_NUMBER_TABLE
1283 , p17_a2 JTF_NUMBER_TABLE
1284 , p17_a3 JTF_VARCHAR2_TABLE_100
1285 , p17_a4 JTF_VARCHAR2_TABLE_100
1286 , p17_a5 JTF_VARCHAR2_TABLE_100
1287 , p17_a6 JTF_VARCHAR2_TABLE_100
1288 , p17_a7 JTF_DATE_TABLE
1289 , p17_a8 JTF_DATE_TABLE
1290 , p_called_by_workflow VARCHAR2
1291 , p_workflow_process_id NUMBER
1292 , p_auto_assign VARCHAR2
1293 , p_validate_sr_closure VARCHAR2
1294 , p_auto_close_child_entities VARCHAR2
1295 , p_default_contract_sla_ind VARCHAR2
1296 , p_auto_generate_tasks VARCHAR2
1297 , p25_a0 out nocopy NUMBER
1298 , p25_a1 out nocopy NUMBER
1299 , p25_a2 out nocopy NUMBER
1300 , p25_a3 out nocopy NUMBER
1301 , p25_a4 out nocopy VARCHAR2
1302 , p25_a5 out nocopy DATE
1303 , p25_a6 out nocopy DATE
1304 , p25_a7 out nocopy NUMBER
1305 , p25_a8 out nocopy DATE
1306 , p25_a9 out nocopy NUMBER
1307 );
1308 procedure update_servicerequest(p_api_version NUMBER
1309 , p_init_msg_list VARCHAR2
1310 , p_commit VARCHAR2
1311 , x_return_status out nocopy VARCHAR2
1312 , x_msg_count out nocopy NUMBER
1313 , x_msg_data out nocopy VARCHAR2
1314 , p_request_id NUMBER
1315 , p_request_number VARCHAR2
1316 , p_audit_comments VARCHAR2
1317 , p_object_version_number NUMBER
1318 , p_resp_appl_id NUMBER
1319 , p_resp_id NUMBER
1320 , p_last_updated_by NUMBER
1321 , p_last_update_login NUMBER
1322 , p_last_update_date date
1323 , p15_a0 DATE
1324 , p15_a1 NUMBER
1325 , p15_a2 VARCHAR2
1326 , p15_a3 NUMBER
1327 , p15_a4 VARCHAR2
1328 , p15_a5 NUMBER
1329 , p15_a6 VARCHAR2
1330 , p15_a7 NUMBER
1331 , p15_a8 VARCHAR2
1332 , p15_a9 DATE
1333 , p15_a10 NUMBER
1334 , p15_a11 NUMBER
1335 , p15_a12 VARCHAR2
1336 , p15_a13 VARCHAR2
1337 , p15_a14 VARCHAR2
1338 , p15_a15 NUMBER
1339 , p15_a16 VARCHAR2
1340 , p15_a17 NUMBER
1341 , p15_a18 VARCHAR2
1342 , p15_a19 VARCHAR2
1343 , p15_a20 NUMBER
1344 , p15_a21 NUMBER
1345 , p15_a22 VARCHAR2
1346 , p15_a23 VARCHAR2
1347 , p15_a24 NUMBER
1348 , p15_a25 NUMBER
1349 , p15_a26 NUMBER
1350 , p15_a27 NUMBER
1351 , p15_a28 NUMBER
1352 , p15_a29 NUMBER
1353 , p15_a30 VARCHAR2
1354 , p15_a31 NUMBER
1355 , p15_a32 NUMBER
1356 , p15_a33 VARCHAR2
1357 , p15_a34 VARCHAR2
1358 , p15_a35 VARCHAR2
1359 , p15_a36 VARCHAR2
1360 , p15_a37 VARCHAR2
1361 , p15_a38 VARCHAR2
1362 , p15_a39 VARCHAR2
1363 , p15_a40 VARCHAR2
1364 , p15_a41 VARCHAR2
1365 , p15_a42 VARCHAR2
1366 , p15_a43 VARCHAR2
1367 , p15_a44 VARCHAR2
1368 , p15_a45 VARCHAR2
1369 , p15_a46 VARCHAR2
1370 , p15_a47 VARCHAR2
1371 , p15_a48 VARCHAR2
1372 , p15_a49 VARCHAR2
1373 , p15_a50 VARCHAR2
1374 , p15_a51 VARCHAR2
1375 , p15_a52 VARCHAR2
1376 , p15_a53 VARCHAR2
1377 , p15_a54 VARCHAR2
1378 , p15_a55 NUMBER
1379 , p15_a56 VARCHAR2
1380 , p15_a57 NUMBER
1381 , p15_a58 VARCHAR2
1382 , p15_a59 VARCHAR2
1383 , p15_a60 DATE
1384 , p15_a61 NUMBER
1385 , p15_a62 VARCHAR2
1386 , p15_a63 VARCHAR2
1387 , p15_a64 VARCHAR2
1388 , p15_a65 VARCHAR2
1392 , p15_a69 VARCHAR2
1389 , p15_a66 VARCHAR2
1390 , p15_a67 VARCHAR2
1391 , p15_a68 VARCHAR2
1393 , p15_a70 VARCHAR2
1394 , p15_a71 VARCHAR2
1395 , p15_a72 VARCHAR2
1396 , p15_a73 VARCHAR2
1397 , p15_a74 VARCHAR2
1398 , p15_a75 VARCHAR2
1399 , p15_a76 VARCHAR2
1400 , p15_a77 VARCHAR2
1401 , p15_a78 VARCHAR2
1402 , p15_a79 VARCHAR2
1403 , p15_a80 VARCHAR2
1404 , p15_a81 VARCHAR2
1405 , p15_a82 VARCHAR2
1406 , p15_a83 VARCHAR2
1407 , p15_a84 VARCHAR2
1408 , p15_a85 VARCHAR2
1409 , p15_a86 VARCHAR2
1410 , p15_a87 VARCHAR2
1411 , p15_a88 VARCHAR2
1412 , p15_a89 VARCHAR2
1413 , p15_a90 VARCHAR2
1414 , p15_a91 VARCHAR2
1415 , p15_a92 VARCHAR2
1416 , p15_a93 VARCHAR2
1417 , p15_a94 NUMBER
1418 , p15_a95 NUMBER
1419 , p15_a96 NUMBER
1420 , p15_a97 NUMBER
1421 , p15_a98 VARCHAR2
1422 , p15_a99 DATE
1423 , p15_a100 VARCHAR2
1424 , p15_a101 NUMBER
1425 , p15_a102 NUMBER
1426 , p15_a103 VARCHAR2
1427 , p15_a104 NUMBER
1428 , p15_a105 VARCHAR2
1429 , p15_a106 NUMBER
1430 , p15_a107 NUMBER
1431 , p15_a108 VARCHAR2
1432 , p15_a109 NUMBER
1433 , p15_a110 VARCHAR2
1434 , p15_a111 VARCHAR2
1435 , p15_a112 VARCHAR2
1436 , p15_a113 DATE
1437 , p15_a114 NUMBER
1438 , p15_a115 NUMBER
1439 , p15_a116 NUMBER
1440 , p15_a117 NUMBER
1441 , p15_a118 NUMBER
1442 , p15_a119 VARCHAR2
1443 , p15_a120 NUMBER
1444 , p15_a121 VARCHAR2
1445 , p15_a122 NUMBER
1446 , p15_a123 VARCHAR2
1447 , p15_a124 NUMBER
1448 , p15_a125 VARCHAR2
1449 , p15_a126 VARCHAR2
1450 , p15_a127 VARCHAR2
1451 , p15_a128 VARCHAR2
1452 , p15_a129 VARCHAR2
1453 , p15_a130 VARCHAR2
1454 , p15_a131 NUMBER
1455 , p15_a132 NUMBER
1456 , p15_a133 VARCHAR2
1457 , p15_a134 NUMBER
1458 , p15_a135 NUMBER
1459 , p15_a136 VARCHAR2
1460 , p15_a137 VARCHAR2
1461 , p15_a138 VARCHAR2
1462 , p15_a139 VARCHAR2
1463 , p15_a140 VARCHAR2
1464 , p15_a141 VARCHAR2
1465 , p15_a142 NUMBER
1466 , p15_a143 VARCHAR2
1467 , p15_a144 NUMBER
1468 , p15_a145 VARCHAR2
1469 , p15_a146 DATE
1470 , p15_a147 DATE
1471 , p15_a148 DATE
1472 , p15_a149 VARCHAR2
1473 , p15_a150 NUMBER
1474 , p15_a151 VARCHAR2
1475 , p15_a152 VARCHAR2
1476 , p15_a153 VARCHAR2
1477 , p15_a154 VARCHAR2
1478 , p15_a155 VARCHAR2
1479 , p15_a156 VARCHAR2
1480 , p15_a157 VARCHAR2
1481 , p15_a158 VARCHAR2
1482 , p15_a159 VARCHAR2
1483 , p15_a160 VARCHAR2
1484 , p15_a161 VARCHAR2
1485 , p15_a162 VARCHAR2
1486 , p15_a163 VARCHAR2
1487 , p15_a164 DATE
1488 , p15_a165 VARCHAR
1489 , p15_a166 VARCHAR
1490 , p15_a167 VARCHAR
1491 , p15_a168 VARCHAR
1492 , p15_a169 NUMBER
1493 , p15_a170 NUMBER
1494 , p15_a171 NUMBER
1495 , p15_a172 NUMBER
1496 , p15_a173 NUMBER
1497 , p15_a174 VARCHAR2
1498 , p15_a175 VARCHAR2
1499 , p15_a176 NUMBER
1500 , p15_a177 NUMBER
1501 , p15_a178 NUMBER
1502 , p15_a179 NUMBER
1503 , p15_a180 NUMBER
1504 , p15_a181 NUMBER
1505 , p15_a182 NUMBER
1506 , p15_a183 NUMBER
1507 , p15_a184 VARCHAR2
1508 , p15_a185 VARCHAR2
1509 , p15_a186 VARCHAR2
1510 , p15_a187 VARCHAR2
1511 , p15_a188 VARCHAR2
1512 , p15_a189 VARCHAR2
1513 , p15_a190 VARCHAR2
1514 , p15_a191 VARCHAR2
1515 , p15_a192 VARCHAR2
1516 , p15_a193 VARCHAR2
1517 , p15_a194 VARCHAR2
1518 , p15_a195 VARCHAR2
1519 , p15_a196 VARCHAR2
1520 , p15_a197 VARCHAR2
1521 , p15_a198 VARCHAR2
1522 , p15_a199 VARCHAR2
1523 , p15_a200 VARCHAR2
1524 , p15_a201 VARCHAR2
1525 , p15_a202 VARCHAR2
1526 , p15_a203 VARCHAR2
1527 , p15_a204 VARCHAR2
1528 , p15_a205 NUMBER
1529 , p15_a206 VARCHAR2
1530 , p15_a207 NUMBER
1531 , p15_a208 VARCHAR2
1532 , p15_a209 VARCHAR2
1533 , p15_a210 NUMBER
1534 , p15_a211 DATE
1535 , p15_a212 NUMBER
1536 , p15_a213 NUMBER
1537 , p15_a214 NUMBER
1538 , p15_a215 NUMBER
1539 , p15_a216 NUMBER
1540 , p15_a217 DATE
1541 , p15_a218 DATE
1542 , p15_a219 DATE
1543 , p15_a220 DATE
1544 , p15_a221 DATE
1545 , p15_a222 DATE
1546 , p15_a223 NUMBER
1547 , p15_a224 NUMBER
1548 , p15_a225 NUMBER
1549 , p16_a0 JTF_VARCHAR2_TABLE_2000
1550 , p16_a1 JTF_VARCHAR2_TABLE_32767
1551 , p16_a2 JTF_VARCHAR2_TABLE_300
1552 , p16_a3 JTF_VARCHAR2_TABLE_100
1553 , p16_a4 JTF_NUMBER_TABLE
1554 , p16_a5 JTF_VARCHAR2_TABLE_100
1555 , p16_a6 JTF_NUMBER_TABLE
1556 , p16_a7 JTF_VARCHAR2_TABLE_100
1557 , p16_a8 JTF_NUMBER_TABLE
1558 , p17_a0 JTF_NUMBER_TABLE
1559 , p17_a1 JTF_NUMBER_TABLE
1560 , p17_a2 JTF_NUMBER_TABLE
1561 , p17_a3 JTF_VARCHAR2_TABLE_100
1562 , p17_a4 JTF_VARCHAR2_TABLE_100
1563 , p17_a5 JTF_VARCHAR2_TABLE_100
1564 , p17_a6 JTF_VARCHAR2_TABLE_100
1565 , p17_a7 JTF_DATE_TABLE
1566 , p17_a8 JTF_DATE_TABLE
1570 , x_workflow_process_id out nocopy NUMBER
1567 , p_called_by_workflow VARCHAR2
1568 , p_workflow_process_id NUMBER
1569 , p_default_contract_sla_ind VARCHAR2
1571 , x_interaction_id out nocopy NUMBER
1572 );
1573 procedure update_status(p_api_version NUMBER
1574 , p_init_msg_list VARCHAR2
1575 , p_commit VARCHAR2
1576 , x_return_status out nocopy VARCHAR2
1577 , x_msg_count out nocopy NUMBER
1578 , x_msg_data out nocopy VARCHAR2
1579 , p_resp_appl_id NUMBER
1580 , p_resp_id NUMBER
1581 , p_user_id NUMBER
1582 , p_login_id NUMBER
1583 , p_request_id NUMBER
1584 , p_request_number VARCHAR2
1585 , p_object_version_number NUMBER
1586 , p_status_id NUMBER
1587 , p_status VARCHAR2
1588 , p_closed_date date
1589 , p_audit_comments VARCHAR2
1590 , p_called_by_workflow VARCHAR2
1591 , p_workflow_process_id NUMBER
1592 , p_comments VARCHAR2
1593 , p_public_comment_flag VARCHAR2
1594 , p_validate_sr_closure VARCHAR2
1595 , p_auto_close_child_entities VARCHAR2
1596 , p_auto_generate_tasks VARCHAR2
1597 , x_interaction_id out nocopy NUMBER
1598 );
1599 procedure create_servicerequest(p_api_version NUMBER
1600 , p_init_msg_list VARCHAR2
1601 , p_commit VARCHAR2
1602 , x_return_status out nocopy VARCHAR2
1603 , x_msg_count out nocopy NUMBER
1604 , x_msg_data out nocopy VARCHAR2
1605 , p_resp_appl_id NUMBER
1606 , p_resp_id NUMBER
1607 , p_user_id NUMBER
1608 , p_login_id NUMBER
1609 , p_org_id NUMBER
1610 , p_request_id NUMBER
1611 , p_request_number VARCHAR2
1612 , p13_a0 DATE
1613 , p13_a1 NUMBER
1614 , p13_a2 VARCHAR2
1615 , p13_a3 NUMBER
1616 , p13_a4 VARCHAR2
1617 , p13_a5 NUMBER
1618 , p13_a6 VARCHAR2
1619 , p13_a7 NUMBER
1620 , p13_a8 VARCHAR2
1621 , p13_a9 DATE
1622 , p13_a10 NUMBER
1623 , p13_a11 NUMBER
1624 , p13_a12 VARCHAR2
1625 , p13_a13 VARCHAR2
1626 , p13_a14 VARCHAR2
1627 , p13_a15 NUMBER
1628 , p13_a16 VARCHAR2
1629 , p13_a17 NUMBER
1630 , p13_a18 VARCHAR2
1631 , p13_a19 VARCHAR2
1632 , p13_a20 NUMBER
1633 , p13_a21 NUMBER
1634 , p13_a22 VARCHAR2
1635 , p13_a23 VARCHAR2
1636 , p13_a24 NUMBER
1637 , p13_a25 NUMBER
1638 , p13_a26 NUMBER
1639 , p13_a27 NUMBER
1640 , p13_a28 NUMBER
1641 , p13_a29 NUMBER
1642 , p13_a30 VARCHAR2
1643 , p13_a31 NUMBER
1644 , p13_a32 NUMBER
1645 , p13_a33 VARCHAR2
1646 , p13_a34 VARCHAR2
1647 , p13_a35 VARCHAR2
1648 , p13_a36 VARCHAR2
1649 , p13_a37 VARCHAR2
1650 , p13_a38 VARCHAR2
1651 , p13_a39 VARCHAR2
1652 , p13_a40 VARCHAR2
1653 , p13_a41 VARCHAR2
1654 , p13_a42 VARCHAR2
1655 , p13_a43 VARCHAR2
1656 , p13_a44 VARCHAR2
1657 , p13_a45 VARCHAR2
1658 , p13_a46 VARCHAR2
1659 , p13_a47 VARCHAR2
1660 , p13_a48 VARCHAR2
1661 , p13_a49 VARCHAR2
1662 , p13_a50 VARCHAR2
1663 , p13_a51 VARCHAR2
1664 , p13_a52 VARCHAR2
1665 , p13_a53 VARCHAR2
1666 , p13_a54 VARCHAR2
1667 , p13_a55 NUMBER
1668 , p13_a56 VARCHAR2
1669 , p13_a57 NUMBER
1670 , p13_a58 VARCHAR2
1671 , p13_a59 VARCHAR2
1672 , p13_a60 DATE
1673 , p13_a61 NUMBER
1674 , p13_a62 VARCHAR2
1675 , p13_a63 VARCHAR2
1676 , p13_a64 VARCHAR2
1677 , p13_a65 VARCHAR2
1678 , p13_a66 VARCHAR2
1679 , p13_a67 VARCHAR2
1680 , p13_a68 VARCHAR2
1681 , p13_a69 VARCHAR2
1682 , p13_a70 VARCHAR2
1683 , p13_a71 VARCHAR2
1684 , p13_a72 VARCHAR2
1685 , p13_a73 VARCHAR2
1686 , p13_a74 VARCHAR2
1687 , p13_a75 VARCHAR2
1688 , p13_a76 VARCHAR2
1689 , p13_a77 VARCHAR2
1690 , p13_a78 VARCHAR2
1691 , p13_a79 VARCHAR2
1692 , p13_a80 VARCHAR2
1693 , p13_a81 VARCHAR2
1694 , p13_a82 VARCHAR2
1695 , p13_a83 VARCHAR2
1696 , p13_a84 VARCHAR2
1697 , p13_a85 VARCHAR2
1698 , p13_a86 VARCHAR2
1699 , p13_a87 VARCHAR2
1700 , p13_a88 VARCHAR2
1701 , p13_a89 VARCHAR2
1702 , p13_a90 VARCHAR2
1703 , p13_a91 VARCHAR2
1704 , p13_a92 VARCHAR2
1705 , p13_a93 VARCHAR2
1706 , p13_a94 NUMBER
1707 , p13_a95 NUMBER
1708 , p13_a96 NUMBER
1709 , p13_a97 NUMBER
1710 , p13_a98 VARCHAR2
1711 , p13_a99 DATE
1712 , p13_a100 VARCHAR2
1713 , p13_a101 NUMBER
1714 , p13_a102 NUMBER
1715 , p13_a103 VARCHAR2
1716 , p13_a104 NUMBER
1717 , p13_a105 VARCHAR2
1718 , p13_a106 NUMBER
1719 , p13_a107 NUMBER
1720 , p13_a108 VARCHAR2
1721 , p13_a109 NUMBER
1722 , p13_a110 VARCHAR2
1723 , p13_a111 VARCHAR2
1724 , p13_a112 VARCHAR2
1725 , p13_a113 DATE
1726 , p13_a114 NUMBER
1727 , p13_a115 NUMBER
1728 , p13_a116 NUMBER
1729 , p13_a117 NUMBER
1730 , p13_a118 NUMBER
1731 , p13_a119 VARCHAR2
1732 , p13_a120 NUMBER
1733 , p13_a121 VARCHAR2
1734 , p13_a122 NUMBER
1735 , p13_a123 VARCHAR2
1736 , p13_a124 NUMBER
1737 , p13_a125 VARCHAR2
1738 , p13_a126 VARCHAR2
1739 , p13_a127 VARCHAR2
1743 , p13_a131 NUMBER
1740 , p13_a128 VARCHAR2
1741 , p13_a129 VARCHAR2
1742 , p13_a130 VARCHAR2
1744 , p13_a132 NUMBER
1745 , p13_a133 VARCHAR2
1746 , p13_a134 NUMBER
1747 , p13_a135 NUMBER
1748 , p13_a136 VARCHAR2
1749 , p13_a137 VARCHAR2
1750 , p13_a138 VARCHAR2
1751 , p13_a139 VARCHAR2
1752 , p13_a140 VARCHAR2
1753 , p13_a141 VARCHAR2
1754 , p13_a142 NUMBER
1755 , p13_a143 VARCHAR2
1756 , p13_a144 NUMBER
1757 , p13_a145 VARCHAR2
1758 , p13_a146 DATE
1759 , p13_a147 DATE
1760 , p13_a148 DATE
1761 , p13_a149 VARCHAR2
1762 , p13_a150 NUMBER
1763 , p13_a151 VARCHAR2
1764 , p13_a152 VARCHAR2
1765 , p13_a153 VARCHAR2
1766 , p13_a154 VARCHAR2
1767 , p13_a155 VARCHAR2
1768 , p13_a156 VARCHAR2
1769 , p13_a157 VARCHAR2
1770 , p13_a158 VARCHAR2
1771 , p13_a159 VARCHAR2
1772 , p13_a160 VARCHAR2
1773 , p13_a161 VARCHAR2
1774 , p13_a162 VARCHAR2
1775 , p13_a163 VARCHAR2
1776 , p13_a164 DATE
1777 , p13_a165 VARCHAR
1778 , p13_a166 VARCHAR
1779 , p13_a167 VARCHAR
1780 , p13_a168 VARCHAR
1781 , p13_a169 NUMBER
1782 , p13_a170 NUMBER
1783 , p13_a171 NUMBER
1784 , p13_a172 NUMBER
1785 , p13_a173 NUMBER
1786 , p13_a174 VARCHAR2
1787 , p13_a175 VARCHAR2
1788 , p13_a176 NUMBER
1789 , p13_a177 NUMBER
1790 , p13_a178 NUMBER
1791 , p13_a179 NUMBER
1792 , p13_a180 NUMBER
1793 , p13_a181 NUMBER
1794 , p13_a182 NUMBER
1795 , p13_a183 NUMBER
1796 , p13_a184 VARCHAR2
1797 , p13_a185 VARCHAR2
1798 , p13_a186 VARCHAR2
1799 , p13_a187 VARCHAR2
1800 , p13_a188 VARCHAR2
1801 , p13_a189 VARCHAR2
1802 , p13_a190 VARCHAR2
1803 , p13_a191 VARCHAR2
1804 , p13_a192 VARCHAR2
1805 , p13_a193 VARCHAR2
1806 , p13_a194 VARCHAR2
1807 , p13_a195 VARCHAR2
1808 , p13_a196 VARCHAR2
1809 , p13_a197 VARCHAR2
1810 , p13_a198 VARCHAR2
1811 , p13_a199 VARCHAR2
1812 , p13_a200 VARCHAR2
1813 , p13_a201 VARCHAR2
1814 , p13_a202 VARCHAR2
1815 , p13_a203 VARCHAR2
1816 , p13_a204 VARCHAR2
1817 , p13_a205 NUMBER
1818 , p13_a206 VARCHAR2
1819 , p13_a207 NUMBER
1820 , p13_a208 VARCHAR2
1821 , p13_a209 VARCHAR2
1822 , p13_a210 NUMBER
1823 , p13_a211 DATE
1824 , p13_a212 NUMBER
1825 , p13_a213 NUMBER
1826 , p13_a214 NUMBER
1827 , p13_a215 NUMBER
1828 , p13_a216 NUMBER
1829 , p13_a217 DATE
1830 , p13_a218 DATE
1831 , p13_a219 DATE
1832 , p13_a220 DATE
1833 , p13_a221 DATE
1834 , p13_a222 DATE
1835 , p13_a223 NUMBER
1836 , p13_a224 NUMBER
1837 , p13_a225 NUMBER
1838 , p14_a0 JTF_VARCHAR2_TABLE_2000
1839 , p14_a1 JTF_VARCHAR2_TABLE_32767
1840 , p14_a2 JTF_VARCHAR2_TABLE_300
1841 , p14_a3 JTF_VARCHAR2_TABLE_100
1842 , p14_a4 JTF_NUMBER_TABLE
1843 , p14_a5 JTF_VARCHAR2_TABLE_100
1844 , p14_a6 JTF_NUMBER_TABLE
1845 , p14_a7 JTF_VARCHAR2_TABLE_100
1846 , p14_a8 JTF_NUMBER_TABLE
1847 , p15_a0 JTF_NUMBER_TABLE
1848 , p15_a1 JTF_NUMBER_TABLE
1849 , p15_a2 JTF_NUMBER_TABLE
1850 , p15_a3 JTF_VARCHAR2_TABLE_100
1851 , p15_a4 JTF_VARCHAR2_TABLE_100
1852 , p15_a5 JTF_VARCHAR2_TABLE_100
1853 , p15_a6 JTF_VARCHAR2_TABLE_100
1854 , p15_a7 JTF_DATE_TABLE
1855 , p15_a8 JTF_DATE_TABLE
1856 , p_default_contract_sla_ind VARCHAR2
1857 , x_request_id out nocopy NUMBER
1858 , x_request_number out nocopy VARCHAR2
1859 , x_interaction_id out nocopy NUMBER
1860 , x_workflow_process_id out nocopy NUMBER
1861 );
1862 procedure process_sr_ext_attrs(p_api_version NUMBER
1863 , p_init_msg_list VARCHAR2
1864 , p_commit VARCHAR2
1865 , p_incident_id NUMBER
1866 , p4_a0 JTF_NUMBER_TABLE
1867 , p4_a1 JTF_VARCHAR2_TABLE_200
1868 , p4_a2 JTF_VARCHAR2_TABLE_200
1869 , p4_a3 JTF_VARCHAR2_TABLE_200
1870 , p4_a4 JTF_VARCHAR2_TABLE_200
1871 , p4_a5 JTF_VARCHAR2_TABLE_200
1872 , p4_a6 JTF_VARCHAR2_TABLE_200
1873 , p4_a7 JTF_VARCHAR2_TABLE_100
1874 , p4_a8 JTF_NUMBER_TABLE
1875 , p4_a9 JTF_NUMBER_TABLE
1876 , p4_a10 JTF_VARCHAR2_TABLE_100
1877 , p4_a11 JTF_VARCHAR2_TABLE_100
1878 , p4_a12 JTF_VARCHAR2_TABLE_200
1879 , p4_a13 JTF_VARCHAR2_TABLE_100
1880 , p4_a14 JTF_VARCHAR2_TABLE_100
1881 , p5_a0 JTF_NUMBER_TABLE
1882 , p5_a1 JTF_VARCHAR2_TABLE_100
1883 , p5_a2 JTF_VARCHAR2_TABLE_200
1884 , p5_a3 JTF_VARCHAR2_TABLE_200
1885 , p5_a4 JTF_VARCHAR2_TABLE_4000
1886 , p5_a5 JTF_NUMBER_TABLE
1887 , p5_a6 JTF_DATE_TABLE
1888 , p5_a7 JTF_VARCHAR2_TABLE_4000
1889 , p5_a8 JTF_VARCHAR2_TABLE_100
1890 , p_modified_by NUMBER
1891 , p_modified_on date
1892 , x_failed_row_id_list out nocopy VARCHAR2
1893 , x_return_status out nocopy VARCHAR2
1894 , x_errorcode out nocopy NUMBER
1895 , x_msg_count out nocopy NUMBER
1896 , x_msg_data out nocopy VARCHAR2
1897 );
1898 procedure get_sr_info(p_api_version NUMBER
1899 , p_incident_id NUMBER
1900 , p_incident_number VARCHAR2
1901 , p3_a0 in out nocopy NUMBER
1902 , p3_a1 in out nocopy VARCHAR2
1903 , p3_a2 in out nocopy NUMBER
1904 , p3_a3 in out nocopy VARCHAR2
1905 , p3_a4 in out nocopy NUMBER
1906 , p3_a5 in out nocopy VARCHAR2
1907 , p3_a6 in out nocopy NUMBER
1908 , p3_a7 in out nocopy VARCHAR2
1912 , p3_a11 in out nocopy NUMBER
1909 , p3_a8 in out nocopy NUMBER
1910 , p3_a9 in out nocopy NUMBER
1911 , p3_a10 in out nocopy VARCHAR2
1913 , p3_a12 in out nocopy VARCHAR2
1914 , p3_a13 in out nocopy NUMBER
1915 , p3_a14 in out nocopy VARCHAR2
1916 , p3_a15 in out nocopy VARCHAR2
1917 , p3_a16 in out nocopy VARCHAR2
1918 , p3_a17 in out nocopy VARCHAR2
1919 , p3_a18 in out nocopy VARCHAR2
1920 , p3_a19 in out nocopy VARCHAR2
1921 , p3_a20 in out nocopy VARCHAR2
1922 , p3_a21 in out nocopy VARCHAR2
1923 , p3_a22 in out nocopy VARCHAR2
1924 , p3_a23 in out nocopy VARCHAR2
1925 , p3_a24 in out nocopy NUMBER
1926 , p3_a25 in out nocopy VARCHAR2
1927 , p3_a26 in out nocopy VARCHAR2
1928 , p3_a27 in out nocopy NUMBER
1929 , p3_a28 in out nocopy VARCHAR2
1930 , p3_a29 in out nocopy NUMBER
1931 , p3_a30 in out nocopy VARCHAR2
1932 , p3_a31 in out nocopy VARCHAR2
1933 , p3_a32 in out nocopy NUMBER
1934 , p3_a33 in out nocopy VARCHAR2
1935 , p3_a34 in out nocopy NUMBER
1936 , p3_a35 in out nocopy VARCHAR2
1937 , p3_a36 in out nocopy VARCHAR2
1938 , p3_a37 in out nocopy DATE
1939 , p3_a38 in out nocopy DATE
1940 , p3_a39 in out nocopy DATE
1941 , p3_a40 in out nocopy DATE
1942 , p3_a41 in out nocopy DATE
1943 , p3_a42 in out nocopy DATE
1944 , p3_a43 in out nocopy DATE
1945 , p3_a44 in out nocopy DATE
1946 , p3_a45 in out nocopy DATE
1947 , p3_a46 in out nocopy NUMBER
1948 , p3_a47 in out nocopy VARCHAR2
1949 , p3_a48 in out nocopy DATE
1950 , p3_a49 in out nocopy NUMBER
1951 , p3_a50 in out nocopy NUMBER
1952 , p3_a51 in out nocopy NUMBER
1953 , p3_a52 in out nocopy NUMBER
1954 , p3_a53 in out nocopy VARCHAR2
1955 , p3_a54 in out nocopy VARCHAR2
1956 , p3_a55 in out nocopy VARCHAR2
1957 , p3_a56 in out nocopy VARCHAR2
1958 , p3_a57 in out nocopy VARCHAR2
1959 , p3_a58 in out nocopy VARCHAR2
1960 , p3_a59 in out nocopy VARCHAR2
1961 , p3_a60 in out nocopy VARCHAR2
1962 , p3_a61 in out nocopy VARCHAR2
1963 , p3_a62 in out nocopy VARCHAR2
1964 , p3_a63 in out nocopy VARCHAR2
1965 , p3_a64 in out nocopy VARCHAR2
1966 , p3_a65 in out nocopy VARCHAR2
1967 , p3_a66 in out nocopy VARCHAR2
1968 , p3_a67 in out nocopy VARCHAR2
1969 , p3_a68 in out nocopy VARCHAR2
1970 , p3_a69 in out nocopy VARCHAR2
1971 , p3_a70 in out nocopy VARCHAR2
1972 , p3_a71 in out nocopy VARCHAR2
1973 , p3_a72 in out nocopy VARCHAR2
1974 , p3_a73 in out nocopy VARCHAR2
1975 , p3_a74 in out nocopy VARCHAR2
1976 , p3_a75 in out nocopy VARCHAR2
1977 , p3_a76 in out nocopy VARCHAR2
1978 , p3_a77 in out nocopy VARCHAR2
1979 , p3_a78 in out nocopy VARCHAR2
1980 , p3_a79 in out nocopy VARCHAR2
1981 , p3_a80 in out nocopy VARCHAR2
1982 , p3_a81 in out nocopy VARCHAR2
1983 , p3_a82 in out nocopy VARCHAR2
1984 , p3_a83 in out nocopy VARCHAR2
1985 , p3_a84 in out nocopy VARCHAR2
1986 , p3_a85 in out nocopy VARCHAR2
1987 , p3_a86 in out nocopy VARCHAR2
1988 , p3_a87 in out nocopy VARCHAR2
1989 , p3_a88 in out nocopy VARCHAR2
1990 , p3_a89 in out nocopy VARCHAR2
1991 , p3_a90 in out nocopy VARCHAR2
1992 , p3_a91 in out nocopy VARCHAR2
1993 , p3_a92 in out nocopy VARCHAR2
1994 , p3_a93 in out nocopy VARCHAR2
1995 , p3_a94 in out nocopy VARCHAR2
1996 , p3_a95 in out nocopy VARCHAR2
1997 , p3_a96 in out nocopy VARCHAR2
1998 , p3_a97 in out nocopy VARCHAR2
1999 , p3_a98 in out nocopy VARCHAR2
2000 , p3_a99 in out nocopy VARCHAR2
2001 , p3_a100 in out nocopy VARCHAR2
2002 , p3_a101 in out nocopy VARCHAR2
2003 , p3_a102 in out nocopy VARCHAR2
2004 , p3_a103 in out nocopy VARCHAR2
2005 , p3_a104 in out nocopy VARCHAR2
2006 , p4_a0 in out nocopy JTF_VARCHAR2_TABLE_100
2007 , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2008 , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2009 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2010 , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
2011 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_4000
2012 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2013 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_4000
2014 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
2015 , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
2016 , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
2017 , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2018 , p4_a12 in out nocopy JTF_DATE_TABLE
2019 , p4_a13 in out nocopy JTF_DATE_TABLE
2020 , p4_a14 in out nocopy JTF_DATE_TABLE
2021 , p4_a15 in out nocopy JTF_DATE_TABLE
2022 , p4_a16 in out nocopy JTF_DATE_TABLE
2023 , p4_a17 in out nocopy JTF_DATE_TABLE
2024 , p4_a18 in out nocopy JTF_NUMBER_TABLE
2025 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_100
2026 , p4_a20 in out nocopy JTF_NUMBER_TABLE
2027 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_100
2028 , p4_a22 in out nocopy JTF_NUMBER_TABLE
2029 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_100
2030 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_100
2031 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_100
2032 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_100
2033 , p4_a27 in out nocopy JTF_NUMBER_TABLE
2034 , p4_a28 in out nocopy JTF_DATE_TABLE
2035 , p4_a29 in out nocopy JTF_NUMBER_TABLE
2036 , p4_a30 in out nocopy JTF_DATE_TABLE
2037 , p4_a31 in out nocopy JTF_NUMBER_TABLE
2038 , p4_a32 in out nocopy JTF_NUMBER_TABLE
2039 , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_100
2040 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_100
2041 , p4_a35 in out nocopy JTF_NUMBER_TABLE
2042 , p4_a36 in out nocopy JTF_NUMBER_TABLE
2043 , p4_a37 in out nocopy JTF_NUMBER_TABLE
2044 , p4_a38 in out nocopy JTF_NUMBER_TABLE
2045 , p4_a39 in out nocopy JTF_NUMBER_TABLE
2046 , p4_a40 in out nocopy JTF_NUMBER_TABLE
2047 , p4_a41 in out nocopy JTF_NUMBER_TABLE
2048 , p4_a42 in out nocopy JTF_NUMBER_TABLE
2049 , p4_a43 in out nocopy JTF_NUMBER_TABLE
2050 , p4_a44 in out nocopy JTF_NUMBER_TABLE
2051 , p4_a45 in out nocopy JTF_NUMBER_TABLE
2052 , p4_a46 in out nocopy JTF_VARCHAR2_TABLE_100
2053 , p4_a47 in out nocopy JTF_NUMBER_TABLE
2054 , p4_a48 in out nocopy JTF_VARCHAR2_TABLE_100
2055 , p4_a49 in out nocopy JTF_VARCHAR2_TABLE_100
2056 , p4_a50 in out nocopy JTF_VARCHAR2_TABLE_100
2057 , p4_a51 in out nocopy JTF_VARCHAR2_TABLE_100
2058 , p4_a52 in out nocopy JTF_VARCHAR2_TABLE_100
2059 , p4_a53 in out nocopy JTF_NUMBER_TABLE
2060 , p4_a54 in out nocopy JTF_VARCHAR2_TABLE_200
2061 , p4_a55 in out nocopy JTF_VARCHAR2_TABLE_200
2062 , p4_a56 in out nocopy JTF_VARCHAR2_TABLE_200
2063 , p4_a57 in out nocopy JTF_VARCHAR2_TABLE_200
2064 , p4_a58 in out nocopy JTF_VARCHAR2_TABLE_200
2065 , p4_a59 in out nocopy JTF_VARCHAR2_TABLE_200
2066 , p4_a60 in out nocopy JTF_VARCHAR2_TABLE_200
2067 , p4_a61 in out nocopy JTF_VARCHAR2_TABLE_200
2068 , p4_a62 in out nocopy JTF_VARCHAR2_TABLE_200
2069 , p4_a63 in out nocopy JTF_VARCHAR2_TABLE_200
2070 , p4_a64 in out nocopy JTF_VARCHAR2_TABLE_200
2071 , p4_a65 in out nocopy JTF_VARCHAR2_TABLE_200
2072 , p4_a66 in out nocopy JTF_VARCHAR2_TABLE_200
2073 , p4_a67 in out nocopy JTF_VARCHAR2_TABLE_200
2074 , p4_a68 in out nocopy JTF_VARCHAR2_TABLE_200
2075 , p4_a69 in out nocopy JTF_VARCHAR2_TABLE_200
2076 , p5_a0 in out nocopy JTF_VARCHAR2_TABLE_2000
2077 , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2078 , p5_a2 in out nocopy JTF_CLOB_TABLE
2079 , p5_a3 in out nocopy JTF_NUMBER_TABLE
2080 , x_return_status out nocopy VARCHAR2
2081 , x_msg_count out nocopy VARCHAR2
2082 , x_msg_data out nocopy VARCHAR2
2083 );
2084 end cs_servicerequest_pub_w;