5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_400
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_300
18: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_VARCHAR2_TABLE_400
21: , a6 out nocopy JTF_VARCHAR2_TABLE_500
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_DATE_TABLE
30: , a2 JTF_VARCHAR2_TABLE_300
31: , a3 JTF_VARCHAR2_TABLE_2000
32: , a4 JTF_VARCHAR2_TABLE_100
33: , a5 JTF_VARCHAR2_TABLE_400
34: , a6 JTF_VARCHAR2_TABLE_500
35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_VARCHAR2_TABLE_100
38: );
41: , a2 out nocopy JTF_VARCHAR2_TABLE_300
42: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_VARCHAR2_TABLE_400
45: , a6 out nocopy JTF_VARCHAR2_TABLE_500
46: , a7 out nocopy JTF_VARCHAR2_TABLE_100
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_VARCHAR2_TABLE_100
49: );
50:
51: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
52: , a1 JTF_VARCHAR2_TABLE_200
53: , a2 JTF_NUMBER_TABLE
54: , a3 JTF_VARCHAR2_TABLE_500
55: );
56: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_200
58: , a2 out nocopy JTF_NUMBER_TABLE
59: , a3 out nocopy JTF_VARCHAR2_TABLE_500
60: );
61:
62: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE
63: , a1 JTF_VARCHAR2_TABLE_200
89: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_300
90: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000
91: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
92: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_400
93: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_500
94: , p14_a7 out nocopy JTF_NUMBER_TABLE
95: , p14_a8 out nocopy JTF_NUMBER_TABLE
96: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
97: , p14_a10 out nocopy JTF_DATE_TABLE
107: , p_sort_state VARCHAR2
108: , p6_a0 out nocopy JTF_NUMBER_TABLE
109: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
110: , p6_a2 out nocopy JTF_NUMBER_TABLE
111: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
112: , x_return_status out nocopy VARCHAR2
113: , x_msg_count out nocopy NUMBER
114: , x_msg_data out nocopy VARCHAR2
115: );