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_300

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_300
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_300

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_300
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_300();

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_300();
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_300();

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_300();
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 430: , p_tbl JTF_NUMBER_TABLE

426: procedure getmailitemcount(p_api_version_number NUMBER
427: , p_init_msg_list VARCHAR2
428: , p_commit VARCHAR2
429: , p_resource_id NUMBER
430: , p_tbl JTF_NUMBER_TABLE
431: , p5_a0 out nocopy JTF_NUMBER_TABLE
432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 431: , p5_a0 out nocopy JTF_NUMBER_TABLE

427: , p_init_msg_list VARCHAR2
428: , p_commit VARCHAR2
429: , p_resource_id NUMBER
430: , p_tbl JTF_NUMBER_TABLE
431: , p5_a0 out nocopy JTF_NUMBER_TABLE
432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 432: , p5_a1 out nocopy JTF_NUMBER_TABLE

428: , p_commit VARCHAR2
429: , p_resource_id NUMBER
430: , p_tbl JTF_NUMBER_TABLE
431: , p5_a0 out nocopy JTF_NUMBER_TABLE
432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 435: , p5_a4 out nocopy JTF_NUMBER_TABLE

431: , p5_a0 out nocopy JTF_NUMBER_TABLE
432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE
438: , p5_a7 out nocopy JTF_NUMBER_TABLE
439: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 436: , p5_a5 out nocopy JTF_NUMBER_TABLE

432: , p5_a1 out nocopy JTF_NUMBER_TABLE
433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE
438: , p5_a7 out nocopy JTF_NUMBER_TABLE
439: , p5_a8 out nocopy JTF_NUMBER_TABLE
440: , x_return_status out nocopy VARCHAR2

Line 437: , p5_a6 out nocopy JTF_NUMBER_TABLE

433: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE
438: , p5_a7 out nocopy JTF_NUMBER_TABLE
439: , p5_a8 out nocopy JTF_NUMBER_TABLE
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER

Line 438: , p5_a7 out nocopy JTF_NUMBER_TABLE

434: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE
438: , p5_a7 out nocopy JTF_NUMBER_TABLE
439: , p5_a8 out nocopy JTF_NUMBER_TABLE
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2

Line 439: , p5_a8 out nocopy JTF_NUMBER_TABLE

435: , p5_a4 out nocopy JTF_NUMBER_TABLE
436: , p5_a5 out nocopy JTF_NUMBER_TABLE
437: , p5_a6 out nocopy JTF_NUMBER_TABLE
438: , p5_a7 out nocopy JTF_NUMBER_TABLE
439: , p5_a8 out nocopy JTF_NUMBER_TABLE
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2
443: )

Line 498: , p_tbl JTF_NUMBER_TABLE

494: procedure getmailitemcount(p_api_version_number NUMBER
495: , p_init_msg_list VARCHAR2
496: , p_commit VARCHAR2
497: , p_resource_id NUMBER
498: , p_tbl JTF_NUMBER_TABLE
499: , p_email_account_id NUMBER
500: , p6_a0 out nocopy JTF_NUMBER_TABLE
501: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 500: , p6_a0 out nocopy JTF_NUMBER_TABLE

496: , p_commit VARCHAR2
497: , p_resource_id NUMBER
498: , p_tbl JTF_NUMBER_TABLE
499: , p_email_account_id NUMBER
500: , p6_a0 out nocopy JTF_NUMBER_TABLE
501: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a2 out nocopy JTF_NUMBER_TABLE
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER

Line 502: , p6_a2 out nocopy JTF_NUMBER_TABLE

498: , p_tbl JTF_NUMBER_TABLE
499: , p_email_account_id NUMBER
500: , p6_a0 out nocopy JTF_NUMBER_TABLE
501: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a2 out nocopy JTF_NUMBER_TABLE
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: )

Line 558: , p4_a0 out nocopy JTF_NUMBER_TABLE

554: procedure getmailitemcount(p_api_version_number NUMBER
555: , p_init_msg_list VARCHAR2
556: , p_commit VARCHAR2
557: , p_email_account_id NUMBER
558: , p4_a0 out nocopy JTF_NUMBER_TABLE
559: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
560: , p4_a2 out nocopy JTF_NUMBER_TABLE
561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER

Line 560: , p4_a2 out nocopy JTF_NUMBER_TABLE

556: , p_commit VARCHAR2
557: , p_email_account_id NUMBER
558: , p4_a0 out nocopy JTF_NUMBER_TABLE
559: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
560: , p4_a2 out nocopy JTF_NUMBER_TABLE
561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: )

Line 608: , p_tbl JTF_NUMBER_TABLE

604: procedure getmailitemcount(p_api_version_number NUMBER
605: , p_init_msg_list VARCHAR2
606: , p_commit VARCHAR2
607: , p_resource_id NUMBER
608: , p_tbl JTF_NUMBER_TABLE
609: , p_email_account_id NUMBER
610: , p_classification_id NUMBER
611: , x_count out nocopy NUMBER
612: , x_return_status out nocopy VARCHAR2

Line 665: , p_tbl JTF_NUMBER_TABLE

661: procedure getmailitem(p_api_version_number NUMBER
662: , p_init_msg_list VARCHAR2
663: , p_commit VARCHAR2
664: , p_resource_id NUMBER
665: , p_tbl JTF_NUMBER_TABLE
666: , p_rt_classification NUMBER
667: , p_account_id NUMBER
668: , p7_a0 out nocopy NUMBER
669: , p7_a1 out nocopy NUMBER

Line 810: , p_tbl JTF_NUMBER_TABLE

806: procedure getmailitem(p_api_version_number NUMBER
807: , p_init_msg_list VARCHAR2
808: , p_commit VARCHAR2
809: , p_resource_id NUMBER
810: , p_tbl JTF_NUMBER_TABLE
811: , p_rt_classification NUMBER
812: , p_account_id NUMBER
813: , p7_a0 out nocopy NUMBER
814: , p7_a1 out nocopy NUMBER

Line 1105: , x_tbl out nocopy JTF_NUMBER_TABLE

1101: procedure getgroupdetails(p_api_version_number NUMBER
1102: , p_init_msg_list VARCHAR2
1103: , p_commit VARCHAR2
1104: , p_resource_id NUMBER
1105: , x_tbl out nocopy JTF_NUMBER_TABLE
1106: , x_return_status out nocopy VARCHAR2
1107: , x_msg_count out nocopy NUMBER
1108: , x_msg_data out nocopy VARCHAR2
1109: )

Line 1422: , p10_a0 out nocopy JTF_NUMBER_TABLE

1418: , p_page_count NUMBER
1419: , p_sort_by VARCHAR2
1420: , p_sort_order NUMBER
1421: , x_total_message out nocopy NUMBER
1422: , p10_a0 out nocopy JTF_NUMBER_TABLE
1423: , p10_a1 out nocopy JTF_NUMBER_TABLE
1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE

Line 1423: , p10_a1 out nocopy JTF_NUMBER_TABLE

1419: , p_sort_by VARCHAR2
1420: , p_sort_order NUMBER
1421: , x_total_message out nocopy NUMBER
1422: , p10_a0 out nocopy JTF_NUMBER_TABLE
1423: , p10_a1 out nocopy JTF_NUMBER_TABLE
1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE

Line 1425: , p10_a3 out nocopy JTF_NUMBER_TABLE

1421: , x_total_message out nocopy NUMBER
1422: , p10_a0 out nocopy JTF_NUMBER_TABLE
1423: , p10_a1 out nocopy JTF_NUMBER_TABLE
1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 1426: , p10_a4 out nocopy JTF_NUMBER_TABLE

1422: , p10_a0 out nocopy JTF_NUMBER_TABLE
1423: , p10_a1 out nocopy JTF_NUMBER_TABLE
1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 1427: , p10_a5 out nocopy JTF_NUMBER_TABLE

1423: , p10_a1 out nocopy JTF_NUMBER_TABLE
1424: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1425: , p10_a3 out nocopy JTF_NUMBER_TABLE
1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1435: , p10_a13 out nocopy JTF_NUMBER_TABLE

1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE
1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1438: , x_return_status out nocopy VARCHAR2
1439: , x_msg_count out nocopy NUMBER