APPS.IEM_QUEUE_MANAGEMENT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 6: , a3 JTF_VARCHAR2_TABLE_2000

2: /* $Header: IEMPQUMS.pls 120.1 2006/02/13 14:32 chtang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
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

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

14: );
15: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_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

Line 31: , a3 JTF_VARCHAR2_TABLE_2000

27:
28: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_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

Line 42: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

38: );
39: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
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

Line 52: , a1 JTF_VARCHAR2_TABLE_200

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

Line 57: , a1 out nocopy 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
59: , a3 out nocopy JTF_VARCHAR2_TABLE_500
60: );
61:

Line 63: , a1 JTF_VARCHAR2_TABLE_200

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
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 68: , a1 out nocopy JTF_VARCHAR2_TABLE_200

64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_VARCHAR2_TABLE_200
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: );
72:

Line 90: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_2000

86: , p_sort_state VARCHAR2
87: , p14_a0 out nocopy JTF_NUMBER_TABLE
88: , p14_a1 out nocopy JTF_NUMBER_TABLE
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

Line 109: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

105: , p_email_account_id NUMBER
106: , p_sort_column NUMBER
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

Line 123: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

119: , p_email_account_id NUMBER
120: , p_sort_column NUMBER
121: , p_sort_state VARCHAR2
122: , p6_a0 out nocopy JTF_NUMBER_TABLE
123: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
124: , p6_a2 out nocopy JTF_NUMBER_TABLE
125: , p6_a3 out nocopy JTF_NUMBER_TABLE
126: , x_return_status out nocopy VARCHAR2
127: , x_msg_count out nocopy NUMBER