[Home] [Help]
PACKAGE: APPS.IEM_SERVICEREQUEST_PVT_W
Source
1 package iem_servicerequest_pvt_w AUTHID CURRENT_USER as
2 /* $Header: iemcspks.pls 115.3 2002/12/23 19:34:52 mrabatin noship $ */
3 procedure rosetta_table_copy_in_p4(t out nocopy iem_servicerequest_pvt.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_p4(t iem_servicerequest_pvt.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_p6(t out nocopy iem_servicerequest_pvt.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 );
31 procedure rosetta_table_copy_out_p6(t iem_servicerequest_pvt.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
32 , a1 out nocopy JTF_NUMBER_TABLE
33 , a2 out nocopy JTF_NUMBER_TABLE
34 , a3 out nocopy JTF_VARCHAR2_TABLE_100
35 , a4 out nocopy JTF_VARCHAR2_TABLE_100
36 , a5 out nocopy JTF_VARCHAR2_TABLE_100
37 );
38
39 procedure create_servicerequest_wrap(p_api_version NUMBER
40 , p_init_msg_list VARCHAR2
41 , p_commit VARCHAR2
42 , x_return_status out nocopy VARCHAR2
43 , x_msg_count out nocopy NUMBER
44 , x_msg_data out nocopy VARCHAR2
45 , p_resp_appl_id NUMBER
46 , p_resp_id NUMBER
47 , p_user_id NUMBER
48 , p_login_id NUMBER
49 , p_org_id NUMBER
50 , p_request_id NUMBER
51 , p_request_number VARCHAR2
52 , p13_a0 DATE
53 , p13_a1 NUMBER
54 , p13_a2 VARCHAR2
55 , p13_a3 NUMBER
56 , p13_a4 VARCHAR2
57 , p13_a5 NUMBER
58 , p13_a6 VARCHAR2
59 , p13_a7 NUMBER
60 , p13_a8 VARCHAR2
61 , p13_a9 DATE
62 , p13_a10 NUMBER
63 , p13_a11 NUMBER
64 , p13_a12 VARCHAR2
65 , p13_a13 VARCHAR2
66 , p13_a14 VARCHAR2
67 , p13_a15 NUMBER
68 , p13_a16 VARCHAR2
69 , p13_a17 NUMBER
70 , p13_a18 VARCHAR2
71 , p13_a19 VARCHAR2
72 , p13_a20 NUMBER
73 , p13_a21 NUMBER
74 , p13_a22 VARCHAR2
75 , p13_a23 VARCHAR2
76 , p13_a24 NUMBER
77 , p13_a25 NUMBER
78 , p13_a26 NUMBER
79 , p13_a27 NUMBER
80 , p13_a28 NUMBER
81 , p13_a29 NUMBER
82 , p13_a30 VARCHAR2
83 , p13_a31 NUMBER
84 , p13_a32 NUMBER
85 , p13_a33 VARCHAR2
86 , p13_a34 VARCHAR2
87 , p13_a35 VARCHAR2
88 , p13_a36 VARCHAR2
89 , p13_a37 VARCHAR2
90 , p13_a38 VARCHAR2
91 , p13_a39 VARCHAR2
92 , p13_a40 VARCHAR2
93 , p13_a41 VARCHAR2
94 , p13_a42 VARCHAR2
95 , p13_a43 VARCHAR2
96 , p13_a44 VARCHAR2
97 , p13_a45 VARCHAR2
98 , p13_a46 VARCHAR2
99 , p13_a47 VARCHAR2
100 , p13_a48 VARCHAR2
101 , p13_a49 VARCHAR2
102 , p13_a50 VARCHAR2
103 , p13_a51 VARCHAR2
104 , p13_a52 VARCHAR2
105 , p13_a53 VARCHAR2
106 , p13_a54 VARCHAR2
107 , p13_a55 NUMBER
108 , p13_a56 VARCHAR2
109 , p13_a57 NUMBER
110 , p13_a58 VARCHAR2
111 , p13_a59 VARCHAR2
112 , p13_a60 DATE
113 , p13_a61 NUMBER
114 , p13_a62 VARCHAR2
115 , p13_a63 VARCHAR2
116 , p13_a64 VARCHAR2
117 , p13_a65 VARCHAR2
118 , p13_a66 VARCHAR2
119 , p13_a67 VARCHAR2
120 , p13_a68 VARCHAR2
121 , p13_a69 VARCHAR2
122 , p13_a70 VARCHAR2
123 , p13_a71 VARCHAR2
124 , p13_a72 VARCHAR2
125 , p13_a73 VARCHAR2
126 , p13_a74 VARCHAR2
127 , p13_a75 VARCHAR2
128 , p13_a76 VARCHAR2
129 , p13_a77 VARCHAR2
130 , p13_a78 NUMBER
131 , p13_a79 NUMBER
132 , p13_a80 NUMBER
133 , p13_a81 NUMBER
134 , p13_a82 VARCHAR2
135 , p13_a83 DATE
136 , p13_a84 VARCHAR2
137 , p13_a85 NUMBER
138 , p13_a86 NUMBER
139 , p13_a87 VARCHAR2
140 , p13_a88 NUMBER
141 , p13_a89 VARCHAR2
142 , p13_a90 NUMBER
143 , p13_a91 NUMBER
144 , p13_a92 VARCHAR2
145 , p13_a93 NUMBER
146 , p13_a94 VARCHAR2
147 , p13_a95 VARCHAR2
148 , p13_a96 VARCHAR2
149 , p13_a97 DATE
150 , p13_a98 NUMBER
151 , p13_a99 NUMBER
152 , p13_a100 NUMBER
153 , p13_a101 NUMBER
154 , p13_a102 NUMBER
155 , p13_a103 VARCHAR2
156 , p13_a104 NUMBER
157 , p13_a105 VARCHAR2
158 , p13_a106 NUMBER
159 , p13_a107 VARCHAR2
160 , p13_a108 NUMBER
161 , p13_a109 VARCHAR2
162 , p13_a110 VARCHAR2
163 , p13_a111 VARCHAR2
164 , p13_a112 VARCHAR2
165 , p13_a113 VARCHAR2
166 , p13_a114 VARCHAR2
167 , p13_a115 NUMBER
168 , p13_a116 NUMBER
169 , p13_a117 VARCHAR2
170 , p13_a118 NUMBER
171 , p13_a119 NUMBER
172 , p13_a120 VARCHAR2
173 , p13_a121 VARCHAR2
174 , p13_a122 VARCHAR2
175 , p13_a123 VARCHAR2
176 , p13_a124 VARCHAR2
177 , p13_a125 VARCHAR2
178 , p14_a0 JTF_VARCHAR2_TABLE_2000
179 , p14_a1 JTF_VARCHAR2_TABLE_32767
180 , p14_a2 JTF_VARCHAR2_TABLE_300
181 , p14_a3 JTF_VARCHAR2_TABLE_100
182 , p14_a4 JTF_NUMBER_TABLE
183 , p14_a5 JTF_VARCHAR2_TABLE_100
184 , p14_a6 JTF_NUMBER_TABLE
185 , p14_a7 JTF_VARCHAR2_TABLE_100
186 , p14_a8 JTF_NUMBER_TABLE
187 , p15_a0 JTF_NUMBER_TABLE
188 , p15_a1 JTF_NUMBER_TABLE
189 , p15_a2 JTF_NUMBER_TABLE
190 , p15_a3 JTF_VARCHAR2_TABLE_100
191 , p15_a4 JTF_VARCHAR2_TABLE_100
192 , p15_a5 JTF_VARCHAR2_TABLE_100
193 , x_request_id out nocopy NUMBER
194 , x_request_number out nocopy VARCHAR2
195 , x_interaction_id out nocopy NUMBER
196 , x_workflow_process_id out nocopy NUMBER
197 );
198 procedure update_servicerequest_wrap(p_api_version NUMBER
199 , p_init_msg_list VARCHAR2
200 , p_commit VARCHAR2
201 , x_return_status out nocopy VARCHAR2
202 , x_msg_count out nocopy NUMBER
203 , x_msg_data out nocopy VARCHAR2
204 , p_request_id NUMBER
205 , p_request_number VARCHAR2
206 , p_audit_comments VARCHAR2
207 , p_object_version_number NUMBER
208 , p_resp_appl_id NUMBER
209 , p_resp_id NUMBER
210 , p_last_updated_by NUMBER
211 , p_last_update_login NUMBER
212 , p_last_update_date date
213 , p15_a0 DATE
214 , p15_a1 NUMBER
215 , p15_a2 VARCHAR2
216 , p15_a3 NUMBER
217 , p15_a4 VARCHAR2
218 , p15_a5 NUMBER
219 , p15_a6 VARCHAR2
220 , p15_a7 NUMBER
221 , p15_a8 VARCHAR2
222 , p15_a9 DATE
223 , p15_a10 NUMBER
224 , p15_a11 NUMBER
225 , p15_a12 VARCHAR2
226 , p15_a13 VARCHAR2
227 , p15_a14 VARCHAR2
228 , p15_a15 NUMBER
229 , p15_a16 VARCHAR2
230 , p15_a17 NUMBER
231 , p15_a18 VARCHAR2
232 , p15_a19 VARCHAR2
233 , p15_a20 NUMBER
234 , p15_a21 NUMBER
235 , p15_a22 VARCHAR2
236 , p15_a23 VARCHAR2
237 , p15_a24 NUMBER
238 , p15_a25 NUMBER
239 , p15_a26 NUMBER
240 , p15_a27 NUMBER
241 , p15_a28 NUMBER
242 , p15_a29 NUMBER
243 , p15_a30 VARCHAR2
244 , p15_a31 NUMBER
245 , p15_a32 NUMBER
246 , p15_a33 VARCHAR2
247 , p15_a34 VARCHAR2
248 , p15_a35 VARCHAR2
249 , p15_a36 VARCHAR2
250 , p15_a37 VARCHAR2
251 , p15_a38 VARCHAR2
252 , p15_a39 VARCHAR2
253 , p15_a40 VARCHAR2
254 , p15_a41 VARCHAR2
255 , p15_a42 VARCHAR2
256 , p15_a43 VARCHAR2
257 , p15_a44 VARCHAR2
258 , p15_a45 VARCHAR2
259 , p15_a46 VARCHAR2
260 , p15_a47 VARCHAR2
261 , p15_a48 VARCHAR2
262 , p15_a49 VARCHAR2
263 , p15_a50 VARCHAR2
264 , p15_a51 VARCHAR2
265 , p15_a52 VARCHAR2
266 , p15_a53 VARCHAR2
267 , p15_a54 VARCHAR2
268 , p15_a55 NUMBER
269 , p15_a56 VARCHAR2
270 , p15_a57 NUMBER
271 , p15_a58 VARCHAR2
272 , p15_a59 VARCHAR2
273 , p15_a60 DATE
274 , p15_a61 NUMBER
275 , p15_a62 VARCHAR2
276 , p15_a63 VARCHAR2
277 , p15_a64 VARCHAR2
278 , p15_a65 VARCHAR2
279 , p15_a66 VARCHAR2
280 , p15_a67 VARCHAR2
281 , p15_a68 VARCHAR2
282 , p15_a69 VARCHAR2
283 , p15_a70 VARCHAR2
284 , p15_a71 VARCHAR2
285 , p15_a72 VARCHAR2
286 , p15_a73 VARCHAR2
287 , p15_a74 VARCHAR2
288 , p15_a75 VARCHAR2
289 , p15_a76 VARCHAR2
290 , p15_a77 VARCHAR2
291 , p15_a78 NUMBER
292 , p15_a79 NUMBER
293 , p15_a80 NUMBER
294 , p15_a81 NUMBER
295 , p15_a82 VARCHAR2
296 , p15_a83 DATE
297 , p15_a84 VARCHAR2
298 , p15_a85 NUMBER
299 , p15_a86 NUMBER
300 , p15_a87 VARCHAR2
301 , p15_a88 NUMBER
302 , p15_a89 VARCHAR2
303 , p15_a90 NUMBER
304 , p15_a91 NUMBER
305 , p15_a92 VARCHAR2
306 , p15_a93 NUMBER
307 , p15_a94 VARCHAR2
308 , p15_a95 VARCHAR2
309 , p15_a96 VARCHAR2
310 , p15_a97 DATE
311 , p15_a98 NUMBER
312 , p15_a99 NUMBER
313 , p15_a100 NUMBER
314 , p15_a101 NUMBER
315 , p15_a102 NUMBER
316 , p15_a103 VARCHAR2
317 , p15_a104 NUMBER
318 , p15_a105 VARCHAR2
319 , p15_a106 NUMBER
320 , p15_a107 VARCHAR2
321 , p15_a108 NUMBER
322 , p15_a109 VARCHAR2
323 , p15_a110 VARCHAR2
324 , p15_a111 VARCHAR2
325 , p15_a112 VARCHAR2
326 , p15_a113 VARCHAR2
327 , p15_a114 VARCHAR2
328 , p15_a115 NUMBER
329 , p15_a116 NUMBER
330 , p15_a117 VARCHAR2
331 , p15_a118 NUMBER
332 , p15_a119 NUMBER
333 , p15_a120 VARCHAR2
334 , p15_a121 VARCHAR2
335 , p15_a122 VARCHAR2
336 , p15_a123 VARCHAR2
337 , p15_a124 VARCHAR2
338 , p15_a125 VARCHAR2
339 , p16_a0 JTF_VARCHAR2_TABLE_2000
340 , p16_a1 JTF_VARCHAR2_TABLE_32767
341 , p16_a2 JTF_VARCHAR2_TABLE_300
342 , p16_a3 JTF_VARCHAR2_TABLE_100
343 , p16_a4 JTF_NUMBER_TABLE
344 , p16_a5 JTF_VARCHAR2_TABLE_100
345 , p16_a6 JTF_NUMBER_TABLE
346 , p16_a7 JTF_VARCHAR2_TABLE_100
347 , p16_a8 JTF_NUMBER_TABLE
348 , p17_a0 JTF_NUMBER_TABLE
349 , p17_a1 JTF_NUMBER_TABLE
350 , p17_a2 JTF_NUMBER_TABLE
351 , p17_a3 JTF_VARCHAR2_TABLE_100
352 , p17_a4 JTF_VARCHAR2_TABLE_100
353 , p17_a5 JTF_VARCHAR2_TABLE_100
354 , p_called_by_workflow VARCHAR2
355 , p_workflow_process_id NUMBER
356 , x_workflow_process_id out nocopy NUMBER
357 , x_interaction_id out nocopy NUMBER
358 );
359 procedure initialize_rec(p0_a0 in out nocopy DATE
360 , p0_a1 in out nocopy NUMBER
361 , p0_a2 in out nocopy VARCHAR2
362 , p0_a3 in out nocopy NUMBER
363 , p0_a4 in out nocopy VARCHAR2
364 , p0_a5 in out nocopy NUMBER
365 , p0_a6 in out nocopy VARCHAR2
366 , p0_a7 in out nocopy NUMBER
367 , p0_a8 in out nocopy VARCHAR2
368 , p0_a9 in out nocopy DATE
369 , p0_a10 in out nocopy NUMBER
370 , p0_a11 in out nocopy NUMBER
371 , p0_a12 in out nocopy VARCHAR2
372 , p0_a13 in out nocopy VARCHAR2
373 , p0_a14 in out nocopy VARCHAR2
374 , p0_a15 in out nocopy NUMBER
375 , p0_a16 in out nocopy VARCHAR2
376 , p0_a17 in out nocopy NUMBER
377 , p0_a18 in out nocopy VARCHAR2
378 , p0_a19 in out nocopy VARCHAR2
379 , p0_a20 in out nocopy NUMBER
380 , p0_a21 in out nocopy NUMBER
381 , p0_a22 in out nocopy VARCHAR2
382 , p0_a23 in out nocopy VARCHAR2
383 , p0_a24 in out nocopy NUMBER
384 , p0_a25 in out nocopy NUMBER
385 , p0_a26 in out nocopy NUMBER
386 , p0_a27 in out nocopy NUMBER
387 , p0_a28 in out nocopy NUMBER
388 , p0_a29 in out nocopy NUMBER
389 , p0_a30 in out nocopy VARCHAR2
390 , p0_a31 in out nocopy NUMBER
391 , p0_a32 in out nocopy NUMBER
392 , p0_a33 in out nocopy VARCHAR2
393 , p0_a34 in out nocopy VARCHAR2
394 , p0_a35 in out nocopy VARCHAR2
395 , p0_a36 in out nocopy VARCHAR2
396 , p0_a37 in out nocopy VARCHAR2
397 , p0_a38 in out nocopy VARCHAR2
398 , p0_a39 in out nocopy VARCHAR2
399 , p0_a40 in out nocopy VARCHAR2
400 , p0_a41 in out nocopy VARCHAR2
401 , p0_a42 in out nocopy VARCHAR2
402 , p0_a43 in out nocopy VARCHAR2
403 , p0_a44 in out nocopy VARCHAR2
404 , p0_a45 in out nocopy VARCHAR2
405 , p0_a46 in out nocopy VARCHAR2
406 , p0_a47 in out nocopy VARCHAR2
407 , p0_a48 in out nocopy VARCHAR2
408 , p0_a49 in out nocopy VARCHAR2
409 , p0_a50 in out nocopy VARCHAR2
410 , p0_a51 in out nocopy VARCHAR2
411 , p0_a52 in out nocopy VARCHAR2
412 , p0_a53 in out nocopy VARCHAR2
413 , p0_a54 in out nocopy VARCHAR2
414 , p0_a55 in out nocopy NUMBER
415 , p0_a56 in out nocopy VARCHAR2
416 , p0_a57 in out nocopy NUMBER
417 , p0_a58 in out nocopy VARCHAR2
418 , p0_a59 in out nocopy VARCHAR2
419 , p0_a60 in out nocopy DATE
420 , p0_a61 in out nocopy NUMBER
421 , p0_a62 in out nocopy VARCHAR2
422 , p0_a63 in out nocopy VARCHAR2
423 , p0_a64 in out nocopy VARCHAR2
424 , p0_a65 in out nocopy VARCHAR2
425 , p0_a66 in out nocopy VARCHAR2
426 , p0_a67 in out nocopy VARCHAR2
427 , p0_a68 in out nocopy VARCHAR2
428 , p0_a69 in out nocopy VARCHAR2
429 , p0_a70 in out nocopy VARCHAR2
430 , p0_a71 in out nocopy VARCHAR2
431 , p0_a72 in out nocopy VARCHAR2
432 , p0_a73 in out nocopy VARCHAR2
433 , p0_a74 in out nocopy VARCHAR2
434 , p0_a75 in out nocopy VARCHAR2
435 , p0_a76 in out nocopy VARCHAR2
436 , p0_a77 in out nocopy VARCHAR2
437 , p0_a78 in out nocopy NUMBER
438 , p0_a79 in out nocopy NUMBER
439 , p0_a80 in out nocopy NUMBER
440 , p0_a81 in out nocopy NUMBER
441 , p0_a82 in out nocopy VARCHAR2
442 , p0_a83 in out nocopy DATE
443 , p0_a84 in out nocopy VARCHAR2
444 , p0_a85 in out nocopy NUMBER
445 , p0_a86 in out nocopy NUMBER
446 , p0_a87 in out nocopy VARCHAR2
447 , p0_a88 in out nocopy NUMBER
448 , p0_a89 in out nocopy VARCHAR2
449 , p0_a90 in out nocopy NUMBER
450 , p0_a91 in out nocopy NUMBER
451 , p0_a92 in out nocopy VARCHAR2
455 , p0_a96 in out nocopy VARCHAR2
452 , p0_a93 in out nocopy NUMBER
453 , p0_a94 in out nocopy VARCHAR2
454 , p0_a95 in out nocopy VARCHAR2
456 , p0_a97 in out nocopy DATE
457 , p0_a98 in out nocopy NUMBER
458 , p0_a99 in out nocopy NUMBER
459 , p0_a100 in out nocopy NUMBER
460 , p0_a101 in out nocopy NUMBER
461 , p0_a102 in out nocopy NUMBER
462 , p0_a103 in out nocopy VARCHAR2
463 , p0_a104 in out nocopy NUMBER
464 , p0_a105 in out nocopy VARCHAR2
465 , p0_a106 in out nocopy NUMBER
466 , p0_a107 in out nocopy VARCHAR2
467 , p0_a108 in out nocopy NUMBER
468 , p0_a109 in out nocopy VARCHAR2
469 , p0_a110 in out nocopy VARCHAR2
470 , p0_a111 in out nocopy VARCHAR2
471 , p0_a112 in out nocopy VARCHAR2
472 , p0_a113 in out nocopy VARCHAR2
473 , p0_a114 in out nocopy VARCHAR2
474 , p0_a115 in out nocopy NUMBER
475 , p0_a116 in out nocopy NUMBER
476 , p0_a117 in out nocopy VARCHAR2
477 , p0_a118 in out nocopy NUMBER
478 , p0_a119 in out nocopy NUMBER
479 , p0_a120 in out nocopy VARCHAR2
480 , p0_a121 in out nocopy VARCHAR2
481 , p0_a122 in out nocopy VARCHAR2
482 , p0_a123 in out nocopy VARCHAR2
483 , p0_a124 in out nocopy VARCHAR2
484 , p0_a125 in out nocopy VARCHAR2
485 );
486 end iem_servicerequest_pvt_w;