eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_MAILITEM_PUB_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p1(t out nocopy iem_mailitem_pub.email_count_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE

Line 21: , a5 JTF_NUMBER_TABLE

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: ) as

Line 22: , a6 JTF_NUMBER_TABLE

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;

Line 23: , a7 JTF_NUMBER_TABLE

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin

Line 24: , a8 JTF_NUMBER_TABLE

20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then

Line 51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE

Line 52: , a1 out nocopy JTF_NUMBER_TABLE

48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE

Line 55: , a4 out nocopy JTF_NUMBER_TABLE

51: procedure rosetta_table_copy_out_p1(t iem_mailitem_pub.email_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_NUMBER_TABLE
59: , a8 out nocopy JTF_NUMBER_TABLE

Line 56: , a5 out nocopy JTF_NUMBER_TABLE

52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_NUMBER_TABLE
59: , a8 out nocopy JTF_NUMBER_TABLE
60: ) as

Line 57: , a6 out nocopy JTF_NUMBER_TABLE

53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_NUMBER_TABLE
59: , a8 out nocopy JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;

Line 58: , a7 out nocopy JTF_NUMBER_TABLE

54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_NUMBER_TABLE
59: , a8 out nocopy JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin

Line 59: , a8 out nocopy JTF_NUMBER_TABLE

55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_NUMBER_TABLE
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_NUMBER_TABLE
59: , a8 out nocopy JTF_NUMBER_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then

Line 64: a0 := JTF_NUMBER_TABLE();

60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();

Line 65: a1 := JTF_NUMBER_TABLE();

61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();

Line 68: a4 := JTF_NUMBER_TABLE();

64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();

Line 69: a5 := JTF_NUMBER_TABLE();

65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();
73: else

Line 70: a6 := JTF_NUMBER_TABLE();

66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_NUMBER_TABLE();

Line 71: a7 := JTF_NUMBER_TABLE();

67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();

Line 72: a8 := JTF_NUMBER_TABLE();

68: a4 := JTF_NUMBER_TABLE();
69: a5 := JTF_NUMBER_TABLE();
70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();

Line 74: a0 := JTF_NUMBER_TABLE();

70: a6 := JTF_NUMBER_TABLE();
71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();

Line 75: a1 := JTF_NUMBER_TABLE();

71: a7 := JTF_NUMBER_TABLE();
72: a8 := JTF_NUMBER_TABLE();
73: else
74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();

Line 78: a4 := JTF_NUMBER_TABLE();

74: a0 := JTF_NUMBER_TABLE();
75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();
81: a7 := JTF_NUMBER_TABLE();
82: a8 := JTF_NUMBER_TABLE();

Line 79: a5 := JTF_NUMBER_TABLE();

75: a1 := JTF_NUMBER_TABLE();
76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();
81: a7 := JTF_NUMBER_TABLE();
82: a8 := JTF_NUMBER_TABLE();
83: if t.count > 0 then

Line 80: a6 := JTF_NUMBER_TABLE();

76: a2 := JTF_VARCHAR2_TABLE_100();
77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();
81: a7 := JTF_NUMBER_TABLE();
82: a8 := JTF_NUMBER_TABLE();
83: if t.count > 0 then
84: a0.extend(t.count);

Line 81: a7 := JTF_NUMBER_TABLE();

77: a3 := JTF_VARCHAR2_TABLE_100();
78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();
81: a7 := JTF_NUMBER_TABLE();
82: a8 := JTF_NUMBER_TABLE();
83: if t.count > 0 then
84: a0.extend(t.count);
85: a1.extend(t.count);

Line 82: a8 := JTF_NUMBER_TABLE();

78: a4 := JTF_NUMBER_TABLE();
79: a5 := JTF_NUMBER_TABLE();
80: a6 := JTF_NUMBER_TABLE();
81: a7 := JTF_NUMBER_TABLE();
82: a8 := JTF_NUMBER_TABLE();
83: if t.count > 0 then
84: a0.extend(t.count);
85: a1.extend(t.count);
86: a2.extend(t.count);

Line 115: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE

111: end if;
112: end if;
113: end rosetta_table_copy_out_p1;
114:
115: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_NUMBER_TABLE
118: ) as
119: ddindx binary_integer; indx binary_integer;

Line 117: , a2 JTF_NUMBER_TABLE

113: end rosetta_table_copy_out_p1;
114:
115: procedure rosetta_table_copy_in_p3(t out nocopy iem_mailitem_pub.class_count_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_100
117: , a2 JTF_NUMBER_TABLE
118: ) as
119: ddindx binary_integer; indx binary_integer;
120: begin
121: if a0 is not null and a0.count > 0 then

Line 138: procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

134: end loop;
135: end if;
136: end if;
137: end rosetta_table_copy_in_p3;
138: procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , a2 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;

Line 140: , a2 out nocopy JTF_NUMBER_TABLE

136: end if;
137: end rosetta_table_copy_in_p3;
138: procedure rosetta_table_copy_out_p3(t iem_mailitem_pub.class_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
139: , a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , a2 out nocopy JTF_NUMBER_TABLE
141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then

Line 145: a0 := JTF_NUMBER_TABLE();

141: ) as
142: ddindx binary_integer; indx binary_integer;
143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();

Line 147: a2 := JTF_NUMBER_TABLE();

143: begin
144: if t is null or t.count = 0 then
145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_VARCHAR2_TABLE_100();
151: a2 := JTF_NUMBER_TABLE();

Line 149: a0 := JTF_NUMBER_TABLE();

145: a0 := JTF_NUMBER_TABLE();
146: a1 := JTF_VARCHAR2_TABLE_100();
147: a2 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_VARCHAR2_TABLE_100();
151: a2 := JTF_NUMBER_TABLE();
152: if t.count > 0 then
153: a0.extend(t.count);

Line 151: a2 := JTF_NUMBER_TABLE();

147: a2 := JTF_NUMBER_TABLE();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_VARCHAR2_TABLE_100();
151: a2 := JTF_NUMBER_TABLE();
152: if t.count > 0 then
153: a0.extend(t.count);
154: a1.extend(t.count);
155: a2.extend(t.count);

Line 172: procedure rosetta_table_copy_in_p4(t out nocopy iem_mailitem_pub.t_number_table, a0 JTF_NUMBER_TABLE) as

168: end if;
169: end if;
170: end rosetta_table_copy_out_p3;
171:
172: procedure rosetta_table_copy_in_p4(t out nocopy iem_mailitem_pub.t_number_table, a0 JTF_NUMBER_TABLE) as
173: ddindx binary_integer; indx binary_integer;
174: begin
175: if a0 is null then
176: t := null;

Line 196: procedure rosetta_table_copy_out_p4(t iem_mailitem_pub.t_number_table, a0 out nocopy JTF_NUMBER_TABLE) as

192: end loop;
193: end if;
194: end if;
195: end rosetta_table_copy_in_p4;
196: procedure rosetta_table_copy_out_p4(t iem_mailitem_pub.t_number_table, a0 out nocopy JTF_NUMBER_TABLE) as
197: ddindx binary_integer; indx binary_integer;
198: begin
199: if t is null then
200: a0 := null;

Line 202: a0 := JTF_NUMBER_TABLE();

198: begin
199: if t is null then
200: a0 := null;
201: elsif t.count = 0 then
202: a0 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: if t.count > 0 then
206: a0.extend(t.count);

Line 204: a0 := JTF_NUMBER_TABLE();

200: a0 := null;
201: elsif t.count = 0 then
202: a0 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: if t.count > 0 then
206: a0.extend(t.count);
207: ddindx := t.first;
208: indx := 1;

Line 221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE

217: end if;
218: end if;
219: end rosetta_table_copy_out_p4;
220:
221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE

Line 222: , a1 JTF_NUMBER_TABLE

218: end if;
219: end rosetta_table_copy_out_p4;
220:
221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE

Line 224: , a3 JTF_NUMBER_TABLE

220:
221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200

Line 225: , a4 JTF_NUMBER_TABLE

221: procedure rosetta_table_copy_in_p6(t out nocopy iem_mailitem_pub.acq_email_info_tbl, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_2000

Line 226: , a5 JTF_NUMBER_TABLE

222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_VARCHAR2_TABLE_100
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_2000
230: , a9 JTF_VARCHAR2_TABLE_100

Line 234: , a13 JTF_NUMBER_TABLE

230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE
235: , a14 JTF_VARCHAR2_TABLE_100
236: , a15 JTF_VARCHAR2_TABLE_300
237: ) as
238: ddindx binary_integer; indx binary_integer;

Line 270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

266: end loop;
267: end if;
268: end if;
269: end rosetta_table_copy_in_p6;
270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE

Line 271: , a1 out nocopy JTF_NUMBER_TABLE

267: end if;
268: end if;
269: end rosetta_table_copy_in_p6;
270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE

Line 273: , a3 out nocopy JTF_NUMBER_TABLE

269: end rosetta_table_copy_in_p6;
270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 274: , a4 out nocopy JTF_NUMBER_TABLE

270: procedure rosetta_table_copy_out_p6(t iem_mailitem_pub.acq_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 275: , a5 out nocopy JTF_NUMBER_TABLE

271: , a1 out nocopy JTF_NUMBER_TABLE
272: , a2 out nocopy JTF_VARCHAR2_TABLE_100
273: , a3 out nocopy JTF_NUMBER_TABLE
274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 283: , a13 out nocopy JTF_NUMBER_TABLE

279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE
284: , a14 out nocopy JTF_VARCHAR2_TABLE_100
285: , a15 out nocopy JTF_VARCHAR2_TABLE_300
286: ) as
287: ddindx binary_integer; indx binary_integer;

Line 290: a0 := JTF_NUMBER_TABLE();

286: ) as
287: ddindx binary_integer; indx binary_integer;
288: begin
289: if t is null or t.count = 0 then
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();

Line 291: a1 := JTF_NUMBER_TABLE();

287: ddindx binary_integer; indx binary_integer;
288: begin
289: if t is null or t.count = 0 then
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();

Line 293: a3 := JTF_NUMBER_TABLE();

289: if t is null or t.count = 0 then
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();

Line 294: a4 := JTF_NUMBER_TABLE();

290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_2000();

Line 295: a5 := JTF_NUMBER_TABLE();

291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_VARCHAR2_TABLE_100();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_2000();
299: a9 := JTF_VARCHAR2_TABLE_100();

Line 303: a13 := JTF_NUMBER_TABLE();

299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();
306: else
307: a0 := JTF_NUMBER_TABLE();

Line 307: a0 := JTF_NUMBER_TABLE();

303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();
306: else
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();

Line 308: a1 := JTF_NUMBER_TABLE();

304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();
306: else
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();

Line 310: a3 := JTF_NUMBER_TABLE();

306: else
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();

Line 311: a4 := JTF_NUMBER_TABLE();

307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_2000();

Line 312: a5 := JTF_NUMBER_TABLE();

308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_2000();
316: a9 := JTF_VARCHAR2_TABLE_100();

Line 320: a13 := JTF_NUMBER_TABLE();

316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();
321: a14 := JTF_VARCHAR2_TABLE_100();
322: a15 := JTF_VARCHAR2_TABLE_300();
323: if t.count > 0 then
324: a0.extend(t.count);

Line 369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 JTF_NUMBER_TABLE

365: end if;
366: end if;
367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 JTF_NUMBER_TABLE
370: , a1 JTF_NUMBER_TABLE
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200

Line 370: , a1 JTF_NUMBER_TABLE

366: end if;
367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 JTF_NUMBER_TABLE
370: , a1 JTF_NUMBER_TABLE
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200
374: , a5 JTF_VARCHAR2_TABLE_2000

Line 372: , a3 JTF_NUMBER_TABLE

368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.queue_email_info_tbl, a0 JTF_NUMBER_TABLE
370: , a1 JTF_NUMBER_TABLE
371: , a2 JTF_VARCHAR2_TABLE_100
372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200
374: , a5 JTF_VARCHAR2_TABLE_2000
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_NUMBER_TABLE

Line 376: , a7 JTF_NUMBER_TABLE

372: , a3 JTF_NUMBER_TABLE
373: , a4 JTF_VARCHAR2_TABLE_200
374: , a5 JTF_VARCHAR2_TABLE_2000
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_NUMBER_TABLE
377: , a8 JTF_VARCHAR2_TABLE_400
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_VARCHAR2_TABLE_100

Line 378: , a9 JTF_NUMBER_TABLE

374: , a5 JTF_VARCHAR2_TABLE_2000
375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_NUMBER_TABLE
377: , a8 JTF_VARCHAR2_TABLE_400
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_VARCHAR2_TABLE_100
381: , a12 JTF_VARCHAR2_TABLE_100
382: , a13 JTF_VARCHAR2_TABLE_100

Line 379: , a10 JTF_NUMBER_TABLE

375: , a6 JTF_VARCHAR2_TABLE_100
376: , a7 JTF_NUMBER_TABLE
377: , a8 JTF_VARCHAR2_TABLE_400
378: , a9 JTF_NUMBER_TABLE
379: , a10 JTF_NUMBER_TABLE
380: , a11 JTF_VARCHAR2_TABLE_100
381: , a12 JTF_VARCHAR2_TABLE_100
382: , a13 JTF_VARCHAR2_TABLE_100
383: ) as

Line 414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

410: end loop;
411: end if;
412: end if;
413: end rosetta_table_copy_in_p8;
414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
415: , a1 out nocopy JTF_NUMBER_TABLE
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 415: , a1 out nocopy JTF_NUMBER_TABLE

411: end if;
412: end if;
413: end rosetta_table_copy_in_p8;
414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
415: , a1 out nocopy JTF_NUMBER_TABLE
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200
419: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 417: , a3 out nocopy JTF_NUMBER_TABLE

413: end rosetta_table_copy_in_p8;
414: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.queue_email_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
415: , a1 out nocopy JTF_NUMBER_TABLE
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200
419: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
420: , a6 out nocopy JTF_VARCHAR2_TABLE_100
421: , a7 out nocopy JTF_NUMBER_TABLE

Line 421: , a7 out nocopy JTF_NUMBER_TABLE

417: , a3 out nocopy JTF_NUMBER_TABLE
418: , a4 out nocopy JTF_VARCHAR2_TABLE_200
419: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
420: , a6 out nocopy JTF_VARCHAR2_TABLE_100
421: , a7 out nocopy JTF_NUMBER_TABLE
422: , a8 out nocopy JTF_VARCHAR2_TABLE_400
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
425: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , a9 out nocopy JTF_NUMBER_TABLE

419: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
420: , a6 out nocopy JTF_VARCHAR2_TABLE_100
421: , a7 out nocopy JTF_NUMBER_TABLE
422: , a8 out nocopy JTF_VARCHAR2_TABLE_400
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
425: , a11 out nocopy JTF_VARCHAR2_TABLE_100
426: , a12 out nocopy JTF_VARCHAR2_TABLE_100
427: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 424: , a10 out nocopy JTF_NUMBER_TABLE

420: , a6 out nocopy JTF_VARCHAR2_TABLE_100
421: , a7 out nocopy JTF_NUMBER_TABLE
422: , a8 out nocopy JTF_VARCHAR2_TABLE_400
423: , a9 out nocopy JTF_NUMBER_TABLE
424: , a10 out nocopy JTF_NUMBER_TABLE
425: , a11 out nocopy JTF_VARCHAR2_TABLE_100
426: , a12 out nocopy JTF_VARCHAR2_TABLE_100
427: , a13 out nocopy JTF_VARCHAR2_TABLE_100
428: ) as

Line 432: a0 := JTF_NUMBER_TABLE();

428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: a3 := JTF_NUMBER_TABLE();
436: a4 := JTF_VARCHAR2_TABLE_200();

Line 433: a1 := JTF_NUMBER_TABLE();

429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: a3 := JTF_NUMBER_TABLE();
436: a4 := JTF_VARCHAR2_TABLE_200();
437: a5 := JTF_VARCHAR2_TABLE_2000();

Line 435: a3 := JTF_NUMBER_TABLE();

431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_VARCHAR2_TABLE_100();
435: a3 := JTF_NUMBER_TABLE();
436: a4 := JTF_VARCHAR2_TABLE_200();
437: a5 := JTF_VARCHAR2_TABLE_2000();
438: a6 := JTF_VARCHAR2_TABLE_100();
439: a7 := JTF_NUMBER_TABLE();

Line 439: a7 := JTF_NUMBER_TABLE();

435: a3 := JTF_NUMBER_TABLE();
436: a4 := JTF_VARCHAR2_TABLE_200();
437: a5 := JTF_VARCHAR2_TABLE_2000();
438: a6 := JTF_VARCHAR2_TABLE_100();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_VARCHAR2_TABLE_400();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
443: a11 := JTF_VARCHAR2_TABLE_100();

Line 441: a9 := JTF_NUMBER_TABLE();

437: a5 := JTF_VARCHAR2_TABLE_2000();
438: a6 := JTF_VARCHAR2_TABLE_100();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_VARCHAR2_TABLE_400();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
443: a11 := JTF_VARCHAR2_TABLE_100();
444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();

Line 442: a10 := JTF_NUMBER_TABLE();

438: a6 := JTF_VARCHAR2_TABLE_100();
439: a7 := JTF_NUMBER_TABLE();
440: a8 := JTF_VARCHAR2_TABLE_400();
441: a9 := JTF_NUMBER_TABLE();
442: a10 := JTF_NUMBER_TABLE();
443: a11 := JTF_VARCHAR2_TABLE_100();
444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else

Line 447: a0 := JTF_NUMBER_TABLE();

443: a11 := JTF_VARCHAR2_TABLE_100();
444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_NUMBER_TABLE();
451: a4 := JTF_VARCHAR2_TABLE_200();

Line 448: a1 := JTF_NUMBER_TABLE();

444: a12 := JTF_VARCHAR2_TABLE_100();
445: a13 := JTF_VARCHAR2_TABLE_100();
446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_NUMBER_TABLE();
451: a4 := JTF_VARCHAR2_TABLE_200();
452: a5 := JTF_VARCHAR2_TABLE_2000();

Line 450: a3 := JTF_NUMBER_TABLE();

446: else
447: a0 := JTF_NUMBER_TABLE();
448: a1 := JTF_NUMBER_TABLE();
449: a2 := JTF_VARCHAR2_TABLE_100();
450: a3 := JTF_NUMBER_TABLE();
451: a4 := JTF_VARCHAR2_TABLE_200();
452: a5 := JTF_VARCHAR2_TABLE_2000();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();

Line 454: a7 := JTF_NUMBER_TABLE();

450: a3 := JTF_NUMBER_TABLE();
451: a4 := JTF_VARCHAR2_TABLE_200();
452: a5 := JTF_VARCHAR2_TABLE_2000();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_400();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
458: a11 := JTF_VARCHAR2_TABLE_100();

Line 456: a9 := JTF_NUMBER_TABLE();

452: a5 := JTF_VARCHAR2_TABLE_2000();
453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_400();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
458: a11 := JTF_VARCHAR2_TABLE_100();
459: a12 := JTF_VARCHAR2_TABLE_100();
460: a13 := JTF_VARCHAR2_TABLE_100();

Line 457: a10 := JTF_NUMBER_TABLE();

453: a6 := JTF_VARCHAR2_TABLE_100();
454: a7 := JTF_NUMBER_TABLE();
455: a8 := JTF_VARCHAR2_TABLE_400();
456: a9 := JTF_NUMBER_TABLE();
457: a10 := JTF_NUMBER_TABLE();
458: a11 := JTF_VARCHAR2_TABLE_100();
459: a12 := JTF_VARCHAR2_TABLE_100();
460: a13 := JTF_VARCHAR2_TABLE_100();
461: if t.count > 0 then

Line 564: , p_tbl JTF_NUMBER_TABLE

560: procedure getmailitemcount(p_api_version_number NUMBER
561: , p_init_msg_list VARCHAR2
562: , p_commit VARCHAR2
563: , p_resource_id NUMBER
564: , p_tbl JTF_NUMBER_TABLE
565: , p5_a0 out nocopy JTF_NUMBER_TABLE
566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 565: , p5_a0 out nocopy JTF_NUMBER_TABLE

561: , p_init_msg_list VARCHAR2
562: , p_commit VARCHAR2
563: , p_resource_id NUMBER
564: , p_tbl JTF_NUMBER_TABLE
565: , p5_a0 out nocopy JTF_NUMBER_TABLE
566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 566: , p5_a1 out nocopy JTF_NUMBER_TABLE

562: , p_commit VARCHAR2
563: , p_resource_id NUMBER
564: , p_tbl JTF_NUMBER_TABLE
565: , p5_a0 out nocopy JTF_NUMBER_TABLE
566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 569: , p5_a4 out nocopy JTF_NUMBER_TABLE

565: , p5_a0 out nocopy JTF_NUMBER_TABLE
566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
572: , p5_a7 out nocopy JTF_NUMBER_TABLE
573: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 570: , p5_a5 out nocopy JTF_NUMBER_TABLE

566: , p5_a1 out nocopy JTF_NUMBER_TABLE
567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
572: , p5_a7 out nocopy JTF_NUMBER_TABLE
573: , p5_a8 out nocopy JTF_NUMBER_TABLE
574: , x_return_status out nocopy VARCHAR2

Line 571: , p5_a6 out nocopy JTF_NUMBER_TABLE

567: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
572: , p5_a7 out nocopy JTF_NUMBER_TABLE
573: , p5_a8 out nocopy JTF_NUMBER_TABLE
574: , x_return_status out nocopy VARCHAR2
575: , x_msg_count out nocopy NUMBER

Line 572: , p5_a7 out nocopy JTF_NUMBER_TABLE

568: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
572: , p5_a7 out nocopy JTF_NUMBER_TABLE
573: , p5_a8 out nocopy JTF_NUMBER_TABLE
574: , x_return_status out nocopy VARCHAR2
575: , x_msg_count out nocopy NUMBER
576: , x_msg_data out nocopy VARCHAR2

Line 573: , p5_a8 out nocopy JTF_NUMBER_TABLE

569: , p5_a4 out nocopy JTF_NUMBER_TABLE
570: , p5_a5 out nocopy JTF_NUMBER_TABLE
571: , p5_a6 out nocopy JTF_NUMBER_TABLE
572: , p5_a7 out nocopy JTF_NUMBER_TABLE
573: , p5_a8 out nocopy JTF_NUMBER_TABLE
574: , x_return_status out nocopy VARCHAR2
575: , x_msg_count out nocopy NUMBER
576: , x_msg_data out nocopy VARCHAR2
577: )

Line 632: , p_tbl JTF_NUMBER_TABLE

628: procedure getmailitemcount(p_api_version_number NUMBER
629: , p_init_msg_list VARCHAR2
630: , p_commit VARCHAR2
631: , p_resource_id NUMBER
632: , p_tbl JTF_NUMBER_TABLE
633: , p_email_account_id NUMBER
634: , p6_a0 out nocopy JTF_NUMBER_TABLE
635: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 634: , p6_a0 out nocopy JTF_NUMBER_TABLE

630: , p_commit VARCHAR2
631: , p_resource_id NUMBER
632: , p_tbl JTF_NUMBER_TABLE
633: , p_email_account_id NUMBER
634: , p6_a0 out nocopy JTF_NUMBER_TABLE
635: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a2 out nocopy JTF_NUMBER_TABLE
637: , x_return_status out nocopy VARCHAR2
638: , x_msg_count out nocopy NUMBER

Line 636: , p6_a2 out nocopy JTF_NUMBER_TABLE

632: , p_tbl JTF_NUMBER_TABLE
633: , p_email_account_id NUMBER
634: , p6_a0 out nocopy JTF_NUMBER_TABLE
635: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
636: , p6_a2 out nocopy JTF_NUMBER_TABLE
637: , x_return_status out nocopy VARCHAR2
638: , x_msg_count out nocopy NUMBER
639: , x_msg_data out nocopy VARCHAR2
640: )

Line 692: , p4_a0 out nocopy JTF_NUMBER_TABLE

688: procedure getmailitemcount(p_api_version_number NUMBER
689: , p_init_msg_list VARCHAR2
690: , p_commit VARCHAR2
691: , p_email_account_id NUMBER
692: , p4_a0 out nocopy JTF_NUMBER_TABLE
693: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
694: , p4_a2 out nocopy JTF_NUMBER_TABLE
695: , x_return_status out nocopy VARCHAR2
696: , x_msg_count out nocopy NUMBER

Line 694: , p4_a2 out nocopy JTF_NUMBER_TABLE

690: , p_commit VARCHAR2
691: , p_email_account_id NUMBER
692: , p4_a0 out nocopy JTF_NUMBER_TABLE
693: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
694: , p4_a2 out nocopy JTF_NUMBER_TABLE
695: , x_return_status out nocopy VARCHAR2
696: , x_msg_count out nocopy NUMBER
697: , x_msg_data out nocopy VARCHAR2
698: )

Line 742: , p_tbl JTF_NUMBER_TABLE

738: procedure getmailitemcount(p_api_version_number NUMBER
739: , p_init_msg_list VARCHAR2
740: , p_commit VARCHAR2
741: , p_resource_id NUMBER
742: , p_tbl JTF_NUMBER_TABLE
743: , p_email_account_id NUMBER
744: , p_classification_id NUMBER
745: , x_count out nocopy NUMBER
746: , x_return_status out nocopy VARCHAR2

Line 799: , p_tbl JTF_NUMBER_TABLE

795: procedure getmailitem(p_api_version_number NUMBER
796: , p_init_msg_list VARCHAR2
797: , p_commit VARCHAR2
798: , p_resource_id NUMBER
799: , p_tbl JTF_NUMBER_TABLE
800: , p_rt_classification NUMBER
801: , p_account_id NUMBER
802: , p7_a0 out nocopy NUMBER
803: , p7_a1 out nocopy NUMBER

Line 944: , p_tbl JTF_NUMBER_TABLE

940: procedure getmailitem(p_api_version_number NUMBER
941: , p_init_msg_list VARCHAR2
942: , p_commit VARCHAR2
943: , p_resource_id NUMBER
944: , p_tbl JTF_NUMBER_TABLE
945: , p_rt_classification NUMBER
946: , p_account_id NUMBER
947: , p7_a0 out nocopy NUMBER
948: , p7_a1 out nocopy NUMBER

Line 1239: , x_tbl out nocopy JTF_NUMBER_TABLE

1235: procedure getgroupdetails(p_api_version_number NUMBER
1236: , p_init_msg_list VARCHAR2
1237: , p_commit VARCHAR2
1238: , p_resource_id NUMBER
1239: , x_tbl out nocopy JTF_NUMBER_TABLE
1240: , x_return_status out nocopy VARCHAR2
1241: , x_msg_count out nocopy NUMBER
1242: , x_msg_data out nocopy VARCHAR2
1243: )

Line 1556: , p10_a0 out nocopy JTF_NUMBER_TABLE

1552: , p_page_count NUMBER
1553: , p_sort_by VARCHAR2
1554: , p_sort_order NUMBER
1555: , x_total_message out nocopy NUMBER
1556: , p10_a0 out nocopy JTF_NUMBER_TABLE
1557: , p10_a1 out nocopy JTF_NUMBER_TABLE
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE

Line 1557: , p10_a1 out nocopy JTF_NUMBER_TABLE

1553: , p_sort_by VARCHAR2
1554: , p_sort_order NUMBER
1555: , x_total_message out nocopy NUMBER
1556: , p10_a0 out nocopy JTF_NUMBER_TABLE
1557: , p10_a1 out nocopy JTF_NUMBER_TABLE
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE

Line 1559: , p10_a3 out nocopy JTF_NUMBER_TABLE

1555: , x_total_message out nocopy NUMBER
1556: , p10_a0 out nocopy JTF_NUMBER_TABLE
1557: , p10_a1 out nocopy JTF_NUMBER_TABLE
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 1560: , p10_a4 out nocopy JTF_NUMBER_TABLE

1556: , p10_a0 out nocopy JTF_NUMBER_TABLE
1557: , p10_a1 out nocopy JTF_NUMBER_TABLE
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1561: , p10_a5 out nocopy JTF_NUMBER_TABLE

1557: , p10_a1 out nocopy JTF_NUMBER_TABLE
1558: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p10_a3 out nocopy JTF_NUMBER_TABLE
1560: , p10_a4 out nocopy JTF_NUMBER_TABLE
1561: , p10_a5 out nocopy JTF_NUMBER_TABLE
1562: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1564: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_2000
1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1569: , p10_a13 out nocopy JTF_NUMBER_TABLE

1565: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1566: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1567: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1569: , p10_a13 out nocopy JTF_NUMBER_TABLE
1570: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1571: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1572: , x_return_status out nocopy VARCHAR2
1573: , x_msg_count out nocopy NUMBER

Line 1656: , p10_a0 out nocopy JTF_NUMBER_TABLE

1652: , p_page_count NUMBER
1653: , p_sort_by VARCHAR2
1654: , p_sort_order NUMBER
1655: , x_total_message out nocopy NUMBER
1656: , p10_a0 out nocopy JTF_NUMBER_TABLE
1657: , p10_a1 out nocopy JTF_NUMBER_TABLE
1658: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p10_a3 out nocopy JTF_NUMBER_TABLE
1660: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 1657: , p10_a1 out nocopy JTF_NUMBER_TABLE

1653: , p_sort_by VARCHAR2
1654: , p_sort_order NUMBER
1655: , x_total_message out nocopy NUMBER
1656: , p10_a0 out nocopy JTF_NUMBER_TABLE
1657: , p10_a1 out nocopy JTF_NUMBER_TABLE
1658: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p10_a3 out nocopy JTF_NUMBER_TABLE
1660: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
1661: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1659: , p10_a3 out nocopy JTF_NUMBER_TABLE

1655: , x_total_message out nocopy NUMBER
1656: , p10_a0 out nocopy JTF_NUMBER_TABLE
1657: , p10_a1 out nocopy JTF_NUMBER_TABLE
1658: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1659: , p10_a3 out nocopy JTF_NUMBER_TABLE
1660: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
1661: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1662: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p10_a7 out nocopy JTF_NUMBER_TABLE

Line 1663: , p10_a7 out nocopy JTF_NUMBER_TABLE

1659: , p10_a3 out nocopy JTF_NUMBER_TABLE
1660: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
1661: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1662: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p10_a7 out nocopy JTF_NUMBER_TABLE
1664: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1667: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1665: , p10_a9 out nocopy JTF_NUMBER_TABLE

1661: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1662: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p10_a7 out nocopy JTF_NUMBER_TABLE
1664: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1667: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1668: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1669: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1666: , p10_a10 out nocopy JTF_NUMBER_TABLE

1662: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1663: , p10_a7 out nocopy JTF_NUMBER_TABLE
1664: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_400
1665: , p10_a9 out nocopy JTF_NUMBER_TABLE
1666: , p10_a10 out nocopy JTF_NUMBER_TABLE
1667: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1668: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1669: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
1670: , x_return_status out nocopy VARCHAR2