APPS.IEM_SERVICEREQUEST_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

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

Line 8: , a5 JTF_VARCHAR2_TABLE_100

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: );

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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

Line 16: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 18: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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: );

Line 20: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 27: , a3 JTF_VARCHAR2_TABLE_100

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

Line 28: , a4 JTF_VARCHAR2_TABLE_100

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

Line 29: , a5 JTF_VARCHAR2_TABLE_100

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

Line 34: , a3 out nocopy 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:

Line 35: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 36: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 181: , p14_a3 JTF_VARCHAR2_TABLE_100

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

Line 183: , p14_a5 JTF_VARCHAR2_TABLE_100

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

Line 185: , p14_a7 JTF_VARCHAR2_TABLE_100

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

Line 190: , p15_a3 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

Line 191: , p15_a4 JTF_VARCHAR2_TABLE_100

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

Line 192: , p15_a5 JTF_VARCHAR2_TABLE_100

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

Line 342: , p16_a3 JTF_VARCHAR2_TABLE_100

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

Line 344: , p16_a5 JTF_VARCHAR2_TABLE_100

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

Line 346: , p16_a7 JTF_VARCHAR2_TABLE_100

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

Line 351: , p17_a3 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

Line 352: , p17_a4 JTF_VARCHAR2_TABLE_100

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

Line 353: , p17_a5 JTF_VARCHAR2_TABLE_100

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