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 AUTHID CURRENT_USER as
2: /* $Header: IEMVEMAS.pls 120.5 2011/12/25 17:36:06 lkullamb 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 AUTHID CURRENT_USER as
2: /* $Header: IEMVEMAS.pls 120.5 2011/12/25 17:36:06 lkullamb 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: , a9 JTF_VARCHAR2_TABLE_100
64: );

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

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

Line 68: , a3 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 71: , a6 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 78: , a1 JTF_VARCHAR2_TABLE_300

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

Line 79: , a2 JTF_VARCHAR2_TABLE_300

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

Line 81: , a4 JTF_VARCHAR2_TABLE_300

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

Line 84: , a1 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 85: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 87: , a4 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 92: , a2 JTF_VARCHAR2_TABLE_300

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

Line 93: , a3 JTF_VARCHAR2_TABLE_300

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

Line 94: , a4 JTF_VARCHAR2_TABLE_300

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

Line 95: , a5 JTF_VARCHAR2_TABLE_300

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

Line 96: , a6 JTF_VARCHAR2_TABLE_300

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

Line 97: , a7 JTF_VARCHAR2_TABLE_300

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

Line 101: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 102: , a3 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 103: , a4 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 104: , a5 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 105: , a6 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 106: , a7 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 116: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 117: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 126: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 130: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 132: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 133: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 134: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 136: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 147: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 148: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 149: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 150: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 151: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 152: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

159: , x_msg_count out nocopy NUMBER
160: , x_msg_data out nocopy VARCHAR2
161: , p7_a0 out nocopy JTF_NUMBER_TABLE
162: , p7_a1 out nocopy JTF_NUMBER_TABLE
163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

160: , x_msg_data out nocopy VARCHAR2
161: , p7_a0 out nocopy JTF_NUMBER_TABLE
162: , p7_a1 out nocopy JTF_NUMBER_TABLE
163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
168: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

161: , p7_a0 out nocopy JTF_NUMBER_TABLE
162: , p7_a1 out nocopy JTF_NUMBER_TABLE
163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
168: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
169: );

Line 166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

162: , p7_a1 out nocopy JTF_NUMBER_TABLE
163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
168: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
169: );
170: procedure listagentaccountdetails(p_api_version_number NUMBER

Line 167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

163: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
168: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
169: );
170: procedure listagentaccountdetails(p_api_version_number NUMBER
171: , p_init_msg_list VARCHAR2

Line 168: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

164: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
165: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
166: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
167: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
168: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
169: );
170: procedure listagentaccountdetails(p_api_version_number NUMBER
171: , p_init_msg_list VARCHAR2
172: , p_commit VARCHAR2

Line 186: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300

182: , x_msg_count out nocopy NUMBER
183: , x_search_count out nocopy NUMBER
184: , x_msg_data out nocopy VARCHAR2
185: , p15_a0 out nocopy JTF_NUMBER_TABLE
186: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
187: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
188: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
190: );

Line 187: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300

183: , x_search_count out nocopy NUMBER
184: , x_msg_data out nocopy VARCHAR2
185: , p15_a0 out nocopy JTF_NUMBER_TABLE
186: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
187: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
188: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
190: );
191: procedure listaccountdetails(p_api_version_number NUMBER

Line 189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300

185: , p15_a0 out nocopy JTF_NUMBER_TABLE
186: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
187: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
188: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
190: );
191: procedure listaccountdetails(p_api_version_number NUMBER
192: , p_init_msg_list VARCHAR2
193: , p_commit VARCHAR2

Line 198: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

194: , p_email_account_id NUMBER
195: , x_return_status out nocopy VARCHAR2
196: , x_msg_count out nocopy NUMBER
197: , x_msg_data out nocopy VARCHAR2
198: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
199: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
201: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

197: , x_msg_data out nocopy VARCHAR2
198: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
199: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
201: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a5 out nocopy JTF_NUMBER_TABLE
204: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
205: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 204: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

200: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
201: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
202: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a5 out nocopy JTF_NUMBER_TABLE
204: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
205: , p7_a7 out nocopy JTF_NUMBER_TABLE
206: , p7_a8 out nocopy JTF_NUMBER_TABLE
207: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
208: );