APPS.IEM_QUEUE_MANAGEMENT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE

1: package iem_queue_management_pvt_w as
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

Line 4: , a1 JTF_NUMBER_TABLE

1: package iem_queue_management_pvt_w as
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

Line 10: , a7 JTF_NUMBER_TABLE

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

Line 11: , a8 JTF_NUMBER_TABLE

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

Line 15: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
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

Line 16: , a1 out nocopy JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
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

Line 22: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 23: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 28: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE

24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_DATE_TABLE
26: );
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

Line 29: , a1 JTF_NUMBER_TABLE

25: , a10 out nocopy JTF_DATE_TABLE
26: );
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

Line 36: , a8 JTF_NUMBER_TABLE

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

Line 39: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE

35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_VARCHAR2_TABLE_100
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

Line 40: , a1 out nocopy JTF_NUMBER_TABLE

36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_VARCHAR2_TABLE_100
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

Line 47: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 51: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

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

Line 53: , a2 JTF_NUMBER_TABLE

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

Line 56: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy 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
59: , a3 out nocopy JTF_VARCHAR2_TABLE_500
60: );

Line 58: , a2 out nocopy 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:
62: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE

Line 62: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE

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
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_NUMBER_TABLE
66: );

Line 64: , a2 JTF_NUMBER_TABLE

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
68: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 65: , a3 JTF_NUMBER_TABLE

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
68: , a1 out nocopy JTF_VARCHAR2_TABLE_200
69: , a2 out nocopy JTF_NUMBER_TABLE

Line 67: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy 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
68: , a1 out nocopy JTF_VARCHAR2_TABLE_200
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: );

Line 69: , a2 out nocopy 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:
73: procedure search_messages_in_queue(p_api_version_number NUMBER

Line 70: , a3 out nocopy 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:
73: procedure search_messages_in_queue(p_api_version_number NUMBER
74: , p_init_msg_list VARCHAR2

Line 87: , p14_a0 out nocopy JTF_NUMBER_TABLE

83: , p_sent_date_format VARCHAR2
84: , p_group_id NUMBER
85: , p_sort_column NUMBER
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

Line 88: , p14_a1 out nocopy JTF_NUMBER_TABLE

84: , p_group_id NUMBER
85: , p_sort_column NUMBER
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

Line 94: , p14_a7 out nocopy JTF_NUMBER_TABLE

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
98: , x_return_status out nocopy VARCHAR2

Line 95: , p14_a8 out nocopy JTF_NUMBER_TABLE

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
98: , x_return_status out nocopy VARCHAR2
99: , x_msg_count out nocopy NUMBER

Line 108: , p6_a0 out nocopy JTF_NUMBER_TABLE

104: , p_commit VARCHAR2
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

Line 110: , p6_a2 out nocopy JTF_NUMBER_TABLE

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
114: , x_msg_data out nocopy VARCHAR2

Line 122: , p6_a0 out nocopy JTF_NUMBER_TABLE

118: , p_commit VARCHAR2
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

Line 124: , p6_a2 out nocopy JTF_NUMBER_TABLE

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
128: , x_msg_data out nocopy VARCHAR2

Line 125: , p6_a3 out nocopy JTF_NUMBER_TABLE

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
128: , x_msg_data out nocopy VARCHAR2
129: );