APPS.IEM_EMAILACCOUNT_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy iem_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300

1: package iem_emailaccount_pub_w as
2: /* $Header: IEMVEMAS.pls 120.3 2006/05/16 08:41 txliu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );

Line 4: , a1 JTF_VARCHAR2_TABLE_300

1: package iem_emailaccount_pub_w as
2: /* $Header: IEMVEMAS.pls 120.3 2006/05/16 08:41 txliu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy iem_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 8: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
9: , a1 out nocopy JTF_VARCHAR2_TABLE_300
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );

Line 9: , a1 out nocopy JTF_VARCHAR2_TABLE_300

5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: );
8: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
9: , a1 out nocopy JTF_VARCHAR2_TABLE_300
10: , a2 out nocopy JTF_VARCHAR2_TABLE_200
11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:

Line 15: , a1 JTF_VARCHAR2_TABLE_300

11: , a3 out nocopy JTF_NUMBER_TABLE
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE
15: , a1 JTF_VARCHAR2_TABLE_300
16: , a2 JTF_VARCHAR2_TABLE_200
17: , a3 JTF_DATE_TABLE
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_VARCHAR2_TABLE_300

Line 19: , a5 JTF_VARCHAR2_TABLE_300

15: , a1 JTF_VARCHAR2_TABLE_300
16: , a2 JTF_VARCHAR2_TABLE_200
17: , a3 JTF_DATE_TABLE
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_VARCHAR2_TABLE_300
20: , a6 JTF_VARCHAR2_TABLE_100
21: , a7 JTF_VARCHAR2_TABLE_300
22: , a8 JTF_VARCHAR2_TABLE_300
23: , a9 JTF_VARCHAR2_TABLE_300

Line 21: , a7 JTF_VARCHAR2_TABLE_300

17: , a3 JTF_DATE_TABLE
18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_VARCHAR2_TABLE_300
20: , a6 JTF_VARCHAR2_TABLE_100
21: , a7 JTF_VARCHAR2_TABLE_300
22: , a8 JTF_VARCHAR2_TABLE_300
23: , a9 JTF_VARCHAR2_TABLE_300
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300

Line 22: , a8 JTF_VARCHAR2_TABLE_300

18: , a4 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_VARCHAR2_TABLE_300
20: , a6 JTF_VARCHAR2_TABLE_100
21: , a7 JTF_VARCHAR2_TABLE_300
22: , a8 JTF_VARCHAR2_TABLE_300
23: , a9 JTF_VARCHAR2_TABLE_300
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300
26: );

Line 23: , a9 JTF_VARCHAR2_TABLE_300

19: , a5 JTF_VARCHAR2_TABLE_300
20: , a6 JTF_VARCHAR2_TABLE_100
21: , a7 JTF_VARCHAR2_TABLE_300
22: , a8 JTF_VARCHAR2_TABLE_300
23: , a9 JTF_VARCHAR2_TABLE_300
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300
26: );
27: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE

Line 25: , a11 JTF_VARCHAR2_TABLE_300

21: , a7 JTF_VARCHAR2_TABLE_300
22: , a8 JTF_VARCHAR2_TABLE_300
23: , a9 JTF_VARCHAR2_TABLE_300
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300
26: );
27: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_VARCHAR2_TABLE_300
29: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 28: , a1 out nocopy JTF_VARCHAR2_TABLE_300

24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_VARCHAR2_TABLE_300
26: );
27: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_VARCHAR2_TABLE_300
29: , a2 out nocopy JTF_VARCHAR2_TABLE_200
30: , a3 out nocopy JTF_DATE_TABLE
31: , a4 out nocopy JTF_VARCHAR2_TABLE_100
32: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 32: , a5 out nocopy JTF_VARCHAR2_TABLE_300

28: , a1 out nocopy JTF_VARCHAR2_TABLE_300
29: , a2 out nocopy JTF_VARCHAR2_TABLE_200
30: , a3 out nocopy JTF_DATE_TABLE
31: , a4 out nocopy JTF_VARCHAR2_TABLE_100
32: , a5 out nocopy JTF_VARCHAR2_TABLE_300
33: , a6 out nocopy JTF_VARCHAR2_TABLE_100
34: , a7 out nocopy JTF_VARCHAR2_TABLE_300
35: , a8 out nocopy JTF_VARCHAR2_TABLE_300
36: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 34: , a7 out nocopy JTF_VARCHAR2_TABLE_300

30: , a3 out nocopy JTF_DATE_TABLE
31: , a4 out nocopy JTF_VARCHAR2_TABLE_100
32: , a5 out nocopy JTF_VARCHAR2_TABLE_300
33: , a6 out nocopy JTF_VARCHAR2_TABLE_100
34: , a7 out nocopy JTF_VARCHAR2_TABLE_300
35: , a8 out nocopy JTF_VARCHAR2_TABLE_300
36: , a9 out nocopy JTF_VARCHAR2_TABLE_300
37: , a10 out nocopy JTF_NUMBER_TABLE
38: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 35: , a8 out nocopy JTF_VARCHAR2_TABLE_300

31: , a4 out nocopy JTF_VARCHAR2_TABLE_100
32: , a5 out nocopy JTF_VARCHAR2_TABLE_300
33: , a6 out nocopy JTF_VARCHAR2_TABLE_100
34: , a7 out nocopy JTF_VARCHAR2_TABLE_300
35: , a8 out nocopy JTF_VARCHAR2_TABLE_300
36: , a9 out nocopy JTF_VARCHAR2_TABLE_300
37: , a10 out nocopy JTF_NUMBER_TABLE
38: , a11 out nocopy JTF_VARCHAR2_TABLE_300
39: );

Line 36: , a9 out nocopy JTF_VARCHAR2_TABLE_300

32: , a5 out nocopy JTF_VARCHAR2_TABLE_300
33: , a6 out nocopy JTF_VARCHAR2_TABLE_100
34: , a7 out nocopy JTF_VARCHAR2_TABLE_300
35: , a8 out nocopy JTF_VARCHAR2_TABLE_300
36: , a9 out nocopy JTF_VARCHAR2_TABLE_300
37: , a10 out nocopy JTF_NUMBER_TABLE
38: , a11 out nocopy JTF_VARCHAR2_TABLE_300
39: );
40:

Line 38: , a11 out nocopy JTF_VARCHAR2_TABLE_300

34: , a7 out nocopy JTF_VARCHAR2_TABLE_300
35: , a8 out nocopy JTF_VARCHAR2_TABLE_300
36: , a9 out nocopy JTF_VARCHAR2_TABLE_300
37: , a10 out nocopy JTF_NUMBER_TABLE
38: , a11 out nocopy JTF_VARCHAR2_TABLE_300
39: );
40:
41: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100
42: , a1 JTF_VARCHAR2_TABLE_100

Line 54: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300

50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_VARCHAR2_TABLE_200
57: , a3 JTF_VARCHAR2_TABLE_300
58: , a4 JTF_VARCHAR2_TABLE_100

Line 57: , a3 JTF_VARCHAR2_TABLE_300

53:
54: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_VARCHAR2_TABLE_200
57: , a3 JTF_VARCHAR2_TABLE_300
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_300
61: , a7 JTF_NUMBER_TABLE

Line 60: , a6 JTF_VARCHAR2_TABLE_300

56: , a2 JTF_VARCHAR2_TABLE_200
57: , a3 JTF_VARCHAR2_TABLE_300
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_300
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_NUMBER_TABLE
63: );
64: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 64: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

60: , a6 JTF_VARCHAR2_TABLE_300
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_NUMBER_TABLE
63: );
64: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
65: , a1 out nocopy JTF_VARCHAR2_TABLE_100
66: , a2 out nocopy JTF_VARCHAR2_TABLE_200
67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 67: , a3 out nocopy JTF_VARCHAR2_TABLE_300

63: );
64: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
65: , a1 out nocopy JTF_VARCHAR2_TABLE_100
66: , a2 out nocopy JTF_VARCHAR2_TABLE_200
67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_300
71: , a7 out nocopy JTF_NUMBER_TABLE

Line 70: , a6 out nocopy JTF_VARCHAR2_TABLE_300

66: , a2 out nocopy JTF_VARCHAR2_TABLE_200
67: , a3 out nocopy JTF_VARCHAR2_TABLE_300
68: , a4 out nocopy JTF_VARCHAR2_TABLE_100
69: , a5 out nocopy JTF_NUMBER_TABLE
70: , a6 out nocopy JTF_VARCHAR2_TABLE_300
71: , a7 out nocopy JTF_NUMBER_TABLE
72: , a8 out nocopy JTF_NUMBER_TABLE
73: );
74:

Line 76: , a1 JTF_VARCHAR2_TABLE_300

72: , a8 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_300
77: , a2 JTF_VARCHAR2_TABLE_300
78: , a3 JTF_VARCHAR2_TABLE_100
79: , a4 JTF_VARCHAR2_TABLE_300
80: );

Line 77: , a2 JTF_VARCHAR2_TABLE_300

73: );
74:
75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_300
77: , a2 JTF_VARCHAR2_TABLE_300
78: , a3 JTF_VARCHAR2_TABLE_100
79: , a4 JTF_VARCHAR2_TABLE_300
80: );
81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 79: , a4 JTF_VARCHAR2_TABLE_300

75: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_300
77: , a2 JTF_VARCHAR2_TABLE_300
78: , a3 JTF_VARCHAR2_TABLE_100
79: , a4 JTF_VARCHAR2_TABLE_300
80: );
81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_300
83: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 82: , a1 out nocopy JTF_VARCHAR2_TABLE_300

78: , a3 JTF_VARCHAR2_TABLE_100
79: , a4 JTF_VARCHAR2_TABLE_300
80: );
81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_300
83: , a2 out nocopy JTF_VARCHAR2_TABLE_300
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_300
86: );

Line 83: , a2 out nocopy JTF_VARCHAR2_TABLE_300

79: , a4 JTF_VARCHAR2_TABLE_300
80: );
81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_300
83: , a2 out nocopy JTF_VARCHAR2_TABLE_300
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_300
86: );
87:

Line 85: , a4 out nocopy JTF_VARCHAR2_TABLE_300

81: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_300
83: , a2 out nocopy JTF_VARCHAR2_TABLE_300
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_300
86: );
87:
88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE

Line 90: , a2 JTF_VARCHAR2_TABLE_300

86: );
87:
88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300

Line 91: , a3 JTF_VARCHAR2_TABLE_300

87:
88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300

Line 92: , a4 JTF_VARCHAR2_TABLE_300

88: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300
96: );

Line 93: , a5 JTF_VARCHAR2_TABLE_300

89: , a1 JTF_NUMBER_TABLE
90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300
96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 94: , a6 JTF_VARCHAR2_TABLE_300

90: , a2 JTF_VARCHAR2_TABLE_300
91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300
96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE

Line 95: , a7 JTF_VARCHAR2_TABLE_300

91: , a3 JTF_VARCHAR2_TABLE_300
92: , a4 JTF_VARCHAR2_TABLE_300
93: , a5 JTF_VARCHAR2_TABLE_300
94: , a6 JTF_VARCHAR2_TABLE_300
95: , a7 JTF_VARCHAR2_TABLE_300
96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 99: , a2 out nocopy JTF_VARCHAR2_TABLE_300

95: , a7 JTF_VARCHAR2_TABLE_300
96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300
103: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 100: , a3 out nocopy JTF_VARCHAR2_TABLE_300

96: );
97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300
103: , a6 out nocopy JTF_VARCHAR2_TABLE_300
104: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 101: , a4 out nocopy JTF_VARCHAR2_TABLE_300

97: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300
103: , a6 out nocopy JTF_VARCHAR2_TABLE_300
104: , a7 out nocopy JTF_VARCHAR2_TABLE_300
105: );

Line 102: , a5 out nocopy JTF_VARCHAR2_TABLE_300

98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300
103: , a6 out nocopy JTF_VARCHAR2_TABLE_300
104: , a7 out nocopy JTF_VARCHAR2_TABLE_300
105: );
106:

Line 103: , a6 out nocopy JTF_VARCHAR2_TABLE_300

99: , a2 out nocopy JTF_VARCHAR2_TABLE_300
100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300
103: , a6 out nocopy JTF_VARCHAR2_TABLE_300
104: , a7 out nocopy JTF_VARCHAR2_TABLE_300
105: );
106:
107: procedure get_emailaccount_list(p_api_version_number NUMBER

Line 104: , a7 out nocopy JTF_VARCHAR2_TABLE_300

100: , a3 out nocopy JTF_VARCHAR2_TABLE_300
101: , a4 out nocopy JTF_VARCHAR2_TABLE_300
102: , a5 out nocopy JTF_VARCHAR2_TABLE_300
103: , a6 out nocopy JTF_VARCHAR2_TABLE_300
104: , a7 out nocopy JTF_VARCHAR2_TABLE_300
105: );
106:
107: procedure get_emailaccount_list(p_api_version_number NUMBER
108: , p_init_msg_list VARCHAR2

Line 114: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

110: , p_resource_id NUMBER
111: , x_return_status out nocopy VARCHAR2
112: , x_msg_count out nocopy NUMBER
113: , x_msg_data out nocopy VARCHAR2
114: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
115: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
116: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
117: , p7_a3 out nocopy JTF_NUMBER_TABLE
118: );

Line 115: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300

111: , x_return_status out nocopy VARCHAR2
112: , x_msg_count out nocopy NUMBER
113: , x_msg_data out nocopy VARCHAR2
114: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
115: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
116: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
117: , p7_a3 out nocopy JTF_NUMBER_TABLE
118: );
119: procedure getemailheaders(p_agentname VARCHAR2

Line 124: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300

120: , p_top_n INTEGER
121: , p_top_option INTEGER
122: , p_folder_path VARCHAR2
123: , p4_a0 out nocopy JTF_NUMBER_TABLE
124: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
125: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
126: , p4_a3 out nocopy JTF_DATE_TABLE
127: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 128: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

124: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
125: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
126: , p4_a3 out nocopy JTF_DATE_TABLE
127: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
129: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

126: , p4_a3 out nocopy JTF_DATE_TABLE
127: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
129: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a10 out nocopy JTF_NUMBER_TABLE
134: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300

127: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
129: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a10 out nocopy JTF_NUMBER_TABLE
134: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
135: );

Line 132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

128: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
129: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a10 out nocopy JTF_NUMBER_TABLE
134: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
135: );
136: procedure listagentaccounts(p_api_version_number NUMBER

Line 134: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

130: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
131: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
132: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
133: , p4_a10 out nocopy JTF_NUMBER_TABLE
134: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
135: );
136: procedure listagentaccounts(p_api_version_number NUMBER
137: , p_init_msg_list VARCHAR2
138: , p_commit VARCHAR2

Line 145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
143: , p7_a0 out nocopy JTF_NUMBER_TABLE
144: , p7_a1 out nocopy JTF_NUMBER_TABLE
145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

142: , x_msg_data out nocopy VARCHAR2
143: , p7_a0 out nocopy JTF_NUMBER_TABLE
144: , p7_a1 out nocopy JTF_NUMBER_TABLE
145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
150: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

143: , p7_a0 out nocopy JTF_NUMBER_TABLE
144: , p7_a1 out nocopy JTF_NUMBER_TABLE
145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
150: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
151: );

Line 148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

144: , p7_a1 out nocopy JTF_NUMBER_TABLE
145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
150: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
151: );
152: procedure listagentaccountdetails(p_api_version_number NUMBER

Line 149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

145: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
150: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
151: );
152: procedure listagentaccountdetails(p_api_version_number NUMBER
153: , p_init_msg_list VARCHAR2

Line 150: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

146: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
147: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
148: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
149: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
150: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
151: );
152: procedure listagentaccountdetails(p_api_version_number NUMBER
153: , p_init_msg_list VARCHAR2
154: , p_commit VARCHAR2

Line 168: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300

164: , x_msg_count out nocopy NUMBER
165: , x_search_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: , p15_a0 out nocopy JTF_NUMBER_TABLE
168: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
169: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
172: );

Line 169: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300

165: , x_search_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: , p15_a0 out nocopy JTF_NUMBER_TABLE
168: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
169: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
172: );
173: procedure listaccountdetails(p_api_version_number NUMBER

Line 171: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300

167: , p15_a0 out nocopy JTF_NUMBER_TABLE
168: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
169: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
170: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
171: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
172: );
173: procedure listaccountdetails(p_api_version_number NUMBER
174: , p_init_msg_list VARCHAR2
175: , p_commit VARCHAR2

Line 180: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

176: , p_email_account_id NUMBER
177: , x_return_status out nocopy VARCHAR2
178: , x_msg_count out nocopy NUMBER
179: , x_msg_data out nocopy VARCHAR2
180: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
181: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
183: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
184: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 183: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

179: , x_msg_data out nocopy VARCHAR2
180: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
181: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
182: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
183: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
184: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
185: , p7_a5 out nocopy JTF_NUMBER_TABLE
186: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
187: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 186: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

182: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
183: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
184: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
185: , p7_a5 out nocopy JTF_NUMBER_TABLE
186: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
187: , p7_a7 out nocopy JTF_NUMBER_TABLE
188: , p7_a8 out nocopy JTF_NUMBER_TABLE
189: );
190: end iem_emailaccount_pub_w;