APPS.IEM_AGENT_INBOX_MGMT_PVT_W dependencies on JTF_NUMBER_TABLE

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

1: package iem_agent_inbox_mgmt_pvt_w as
2: /* $Header: IEMPAIMS.pls 120.1 2006/02/14 15:17 chtang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_agent_inbox_mgmt_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_agent_inbox_mgmt_pvt_w as
2: /* $Header: IEMPAIMS.pls 120.1 2006/02/14 15:17 chtang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_agent_inbox_mgmt_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_400
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE

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_400
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_400
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_400
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE

Line 17: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE
19: , a2 out nocopy JTF_VARCHAR2_TABLE_300
20: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 18: , a1 out nocopy JTF_NUMBER_TABLE

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t iem_agent_inbox_mgmt_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_NUMBER_TABLE
19: , a2 out nocopy JTF_VARCHAR2_TABLE_300
20: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 24: , a7 out nocopy JTF_NUMBER_TABLE

20: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_400
23: , a6 out nocopy JTF_VARCHAR2_TABLE_500
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_VARCHAR2_TABLE_400
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE

Line 25: , a8 out nocopy JTF_NUMBER_TABLE

21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_400
23: , a6 out nocopy JTF_VARCHAR2_TABLE_500
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_VARCHAR2_TABLE_400
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_DATE_TABLE

Line 27: , a10 out nocopy JTF_NUMBER_TABLE

23: , a6 out nocopy JTF_VARCHAR2_TABLE_500
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_VARCHAR2_TABLE_400
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_DATE_TABLE
30: );
31:

Line 28: , a11 out nocopy JTF_NUMBER_TABLE

24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_NUMBER_TABLE
26: , a9 out nocopy JTF_VARCHAR2_TABLE_400
27: , a10 out nocopy JTF_NUMBER_TABLE
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_DATE_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE

Line 32: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE

28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_DATE_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
33: , a1 JTF_NUMBER_TABLE
34: , a2 JTF_VARCHAR2_TABLE_300
35: , a3 JTF_VARCHAR2_TABLE_2000
36: , a4 JTF_VARCHAR2_TABLE_100

Line 33: , a1 JTF_NUMBER_TABLE

29: , a12 out nocopy JTF_DATE_TABLE
30: );
31:
32: procedure rosetta_table_copy_in_p3(t out nocopy iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
33: , a1 JTF_NUMBER_TABLE
34: , a2 JTF_VARCHAR2_TABLE_300
35: , a3 JTF_VARCHAR2_TABLE_2000
36: , a4 JTF_VARCHAR2_TABLE_100
37: , a5 JTF_VARCHAR2_TABLE_400

Line 40: , a8 JTF_NUMBER_TABLE

36: , a4 JTF_VARCHAR2_TABLE_100
37: , a5 JTF_VARCHAR2_TABLE_400
38: , a6 JTF_VARCHAR2_TABLE_500
39: , a7 JTF_VARCHAR2_TABLE_100
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_VARCHAR2_TABLE_400
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: );

Line 42: , a10 JTF_NUMBER_TABLE

38: , a6 JTF_VARCHAR2_TABLE_500
39: , a7 JTF_VARCHAR2_TABLE_100
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_VARCHAR2_TABLE_400
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE

Line 43: , a11 JTF_NUMBER_TABLE

39: , a7 JTF_VARCHAR2_TABLE_100
40: , a8 JTF_NUMBER_TABLE
41: , a9 JTF_VARCHAR2_TABLE_400
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 45: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE

41: , a9 JTF_VARCHAR2_TABLE_400
42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_VARCHAR2_TABLE_300
48: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a1 out nocopy JTF_NUMBER_TABLE

42: , a10 JTF_NUMBER_TABLE
43: , a11 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p3(t iem_agent_inbox_mgmt_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_VARCHAR2_TABLE_300
48: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a4 out nocopy JTF_VARCHAR2_TABLE_100
50: , a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 53: , a8 out nocopy JTF_NUMBER_TABLE

49: , a4 out nocopy JTF_VARCHAR2_TABLE_100
50: , a5 out nocopy JTF_VARCHAR2_TABLE_400
51: , a6 out nocopy JTF_VARCHAR2_TABLE_500
52: , a7 out nocopy JTF_VARCHAR2_TABLE_100
53: , a8 out nocopy JTF_NUMBER_TABLE
54: , a9 out nocopy JTF_VARCHAR2_TABLE_400
55: , a10 out nocopy JTF_NUMBER_TABLE
56: , a11 out nocopy JTF_NUMBER_TABLE
57: );

Line 55: , a10 out nocopy JTF_NUMBER_TABLE

51: , a6 out nocopy JTF_VARCHAR2_TABLE_500
52: , a7 out nocopy JTF_VARCHAR2_TABLE_100
53: , a8 out nocopy JTF_NUMBER_TABLE
54: , a9 out nocopy JTF_VARCHAR2_TABLE_400
55: , a10 out nocopy JTF_NUMBER_TABLE
56: , a11 out nocopy JTF_NUMBER_TABLE
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

Line 56: , a11 out nocopy JTF_NUMBER_TABLE

52: , a7 out nocopy JTF_VARCHAR2_TABLE_100
53: , a8 out nocopy JTF_NUMBER_TABLE
54: , a9 out nocopy JTF_VARCHAR2_TABLE_400
55: , a10 out nocopy JTF_NUMBER_TABLE
56: , a11 out nocopy JTF_NUMBER_TABLE
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_200

Line 59: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

55: , a10 out nocopy JTF_NUMBER_TABLE
56: , a11 out nocopy JTF_NUMBER_TABLE
57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_200
61: , a2 JTF_NUMBER_TABLE
62: , a3 JTF_VARCHAR2_TABLE_500
63: );

Line 61: , a2 JTF_NUMBER_TABLE

57: );
58:
59: procedure rosetta_table_copy_in_p5(t out nocopy iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
60: , a1 JTF_VARCHAR2_TABLE_200
61: , a2 JTF_NUMBER_TABLE
62: , a3 JTF_VARCHAR2_TABLE_500
63: );
64: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 64: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

60: , a1 JTF_VARCHAR2_TABLE_200
61: , a2 JTF_NUMBER_TABLE
62: , a3 JTF_VARCHAR2_TABLE_500
63: );
64: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_200
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_VARCHAR2_TABLE_500
68: );

Line 66: , a2 out nocopy JTF_NUMBER_TABLE

62: , a3 JTF_VARCHAR2_TABLE_500
63: );
64: procedure rosetta_table_copy_out_p5(t iem_agent_inbox_mgmt_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
65: , a1 out nocopy JTF_VARCHAR2_TABLE_200
66: , a2 out nocopy JTF_NUMBER_TABLE
67: , a3 out nocopy JTF_VARCHAR2_TABLE_500
68: );
69:
70: procedure search_messages_in_inbox(p_api_version_number NUMBER

Line 86: , p16_a0 out nocopy JTF_NUMBER_TABLE

82: , p_resource_id NUMBER
83: , p_page_flag NUMBER
84: , p_sort_column NUMBER
85: , p_sort_state VARCHAR2
86: , p16_a0 out nocopy JTF_NUMBER_TABLE
87: , p16_a1 out nocopy JTF_NUMBER_TABLE
88: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_300
89: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
90: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , p16_a1 out nocopy JTF_NUMBER_TABLE

83: , p_page_flag NUMBER
84: , p_sort_column NUMBER
85: , p_sort_state VARCHAR2
86: , p16_a0 out nocopy JTF_NUMBER_TABLE
87: , p16_a1 out nocopy JTF_NUMBER_TABLE
88: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_300
89: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
90: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400

Line 93: , p16_a7 out nocopy JTF_NUMBER_TABLE

89: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_2000
90: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400
92: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
93: , p16_a7 out nocopy JTF_NUMBER_TABLE
94: , p16_a8 out nocopy JTF_NUMBER_TABLE
95: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
96: , p16_a10 out nocopy JTF_NUMBER_TABLE
97: , p16_a11 out nocopy JTF_NUMBER_TABLE

Line 94: , p16_a8 out nocopy JTF_NUMBER_TABLE

90: , p16_a4 out nocopy JTF_VARCHAR2_TABLE_100
91: , p16_a5 out nocopy JTF_VARCHAR2_TABLE_400
92: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
93: , p16_a7 out nocopy JTF_NUMBER_TABLE
94: , p16_a8 out nocopy JTF_NUMBER_TABLE
95: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
96: , p16_a10 out nocopy JTF_NUMBER_TABLE
97: , p16_a11 out nocopy JTF_NUMBER_TABLE
98: , p16_a12 out nocopy JTF_DATE_TABLE

Line 96: , p16_a10 out nocopy JTF_NUMBER_TABLE

92: , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
93: , p16_a7 out nocopy JTF_NUMBER_TABLE
94: , p16_a8 out nocopy JTF_NUMBER_TABLE
95: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
96: , p16_a10 out nocopy JTF_NUMBER_TABLE
97: , p16_a11 out nocopy JTF_NUMBER_TABLE
98: , p16_a12 out nocopy JTF_DATE_TABLE
99: , x_return_status out nocopy VARCHAR2
100: , x_msg_count out nocopy NUMBER

Line 97: , p16_a11 out nocopy JTF_NUMBER_TABLE

93: , p16_a7 out nocopy JTF_NUMBER_TABLE
94: , p16_a8 out nocopy JTF_NUMBER_TABLE
95: , p16_a9 out nocopy JTF_VARCHAR2_TABLE_400
96: , p16_a10 out nocopy JTF_NUMBER_TABLE
97: , p16_a11 out nocopy JTF_NUMBER_TABLE
98: , p16_a12 out nocopy JTF_DATE_TABLE
99: , x_return_status out nocopy VARCHAR2
100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2

Line 112: , p9_a0 out nocopy JTF_NUMBER_TABLE

108: , p_sort_state VARCHAR2
109: , p_resource_role NUMBER
110: , p_resource_name VARCHAR2
111: , p_transferrer_id NUMBER
112: , p9_a0 out nocopy JTF_NUMBER_TABLE
113: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
114: , p9_a2 out nocopy JTF_NUMBER_TABLE
115: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_500
116: , x_return_status out nocopy VARCHAR2

Line 114: , p9_a2 out nocopy JTF_NUMBER_TABLE

110: , p_resource_name VARCHAR2
111: , p_transferrer_id NUMBER
112: , p9_a0 out nocopy JTF_NUMBER_TABLE
113: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
114: , p9_a2 out nocopy JTF_NUMBER_TABLE
115: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_500
116: , x_return_status out nocopy VARCHAR2
117: , x_msg_count out nocopy NUMBER
118: , x_msg_data out nocopy VARCHAR2