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_EMAILACCOUNT_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

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

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_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300
17: , a1 JTF_VARCHAR2_TABLE_300
18: , a2 JTF_VARCHAR2_TABLE_200
19: , a3 JTF_NUMBER_TABLE
20: ) as

Line 17: , a1 JTF_VARCHAR2_TABLE_300

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy iem_emailaccount_pub.emacnt_tbl_type, a0 JTF_VARCHAR2_TABLE_300
17: , a1 JTF_VARCHAR2_TABLE_300
18: , a2 JTF_VARCHAR2_TABLE_200
19: , a3 JTF_NUMBER_TABLE
20: ) as
21: ddindx binary_integer; indx binary_integer;

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

37: end loop;
38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
42: , a1 out nocopy JTF_VARCHAR2_TABLE_300
43: , a2 out nocopy JTF_VARCHAR2_TABLE_200
44: , a3 out nocopy JTF_NUMBER_TABLE
45: ) as

Line 42: , a1 out nocopy JTF_VARCHAR2_TABLE_300

38: end if;
39: end if;
40: end rosetta_table_copy_in_p1;
41: procedure rosetta_table_copy_out_p1(t iem_emailaccount_pub.emacnt_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
42: , a1 out nocopy JTF_VARCHAR2_TABLE_300
43: , a2 out nocopy JTF_VARCHAR2_TABLE_200
44: , a3 out nocopy JTF_NUMBER_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;

Line 49: a0 := JTF_VARCHAR2_TABLE_300();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_300();
50: a1 := JTF_VARCHAR2_TABLE_300();
51: a2 := JTF_VARCHAR2_TABLE_200();
52: a3 := JTF_NUMBER_TABLE();
53: else

Line 50: a1 := JTF_VARCHAR2_TABLE_300();

46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_300();
50: a1 := JTF_VARCHAR2_TABLE_300();
51: a2 := JTF_VARCHAR2_TABLE_200();
52: a3 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_VARCHAR2_TABLE_300();

Line 54: a0 := JTF_VARCHAR2_TABLE_300();

50: a1 := JTF_VARCHAR2_TABLE_300();
51: a2 := JTF_VARCHAR2_TABLE_200();
52: a3 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_VARCHAR2_TABLE_300();
55: a1 := JTF_VARCHAR2_TABLE_300();
56: a2 := JTF_VARCHAR2_TABLE_200();
57: a3 := JTF_NUMBER_TABLE();
58: if t.count > 0 then

Line 55: a1 := JTF_VARCHAR2_TABLE_300();

51: a2 := JTF_VARCHAR2_TABLE_200();
52: a3 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_VARCHAR2_TABLE_300();
55: a1 := JTF_VARCHAR2_TABLE_300();
56: a2 := JTF_VARCHAR2_TABLE_200();
57: a3 := JTF_NUMBER_TABLE();
58: if t.count > 0 then
59: a0.extend(t.count);

Line 81: , a1 JTF_VARCHAR2_TABLE_300

77: end if;
78: end rosetta_table_copy_out_p1;
79:
80: procedure rosetta_table_copy_in_p4(t out nocopy iem_emailaccount_pub.msg_header_table, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_300
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_DATE_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_300

Line 85: , a5 JTF_VARCHAR2_TABLE_300

81: , a1 JTF_VARCHAR2_TABLE_300
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_DATE_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_300
86: , a6 JTF_VARCHAR2_TABLE_100
87: , a7 JTF_VARCHAR2_TABLE_300
88: , a8 JTF_VARCHAR2_TABLE_300
89: , a9 JTF_VARCHAR2_TABLE_300

Line 87: , a7 JTF_VARCHAR2_TABLE_300

83: , a3 JTF_DATE_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_300
86: , a6 JTF_VARCHAR2_TABLE_100
87: , a7 JTF_VARCHAR2_TABLE_300
88: , a8 JTF_VARCHAR2_TABLE_300
89: , a9 JTF_VARCHAR2_TABLE_300
90: , a10 JTF_NUMBER_TABLE
91: , a11 JTF_VARCHAR2_TABLE_300

Line 88: , a8 JTF_VARCHAR2_TABLE_300

84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_300
86: , a6 JTF_VARCHAR2_TABLE_100
87: , a7 JTF_VARCHAR2_TABLE_300
88: , a8 JTF_VARCHAR2_TABLE_300
89: , a9 JTF_VARCHAR2_TABLE_300
90: , a10 JTF_NUMBER_TABLE
91: , a11 JTF_VARCHAR2_TABLE_300
92: ) as

Line 89: , a9 JTF_VARCHAR2_TABLE_300

85: , a5 JTF_VARCHAR2_TABLE_300
86: , a6 JTF_VARCHAR2_TABLE_100
87: , a7 JTF_VARCHAR2_TABLE_300
88: , a8 JTF_VARCHAR2_TABLE_300
89: , a9 JTF_VARCHAR2_TABLE_300
90: , a10 JTF_NUMBER_TABLE
91: , a11 JTF_VARCHAR2_TABLE_300
92: ) as
93: ddindx binary_integer; indx binary_integer;

Line 91: , a11 JTF_VARCHAR2_TABLE_300

87: , a7 JTF_VARCHAR2_TABLE_300
88: , a8 JTF_VARCHAR2_TABLE_300
89: , a9 JTF_VARCHAR2_TABLE_300
90: , a10 JTF_NUMBER_TABLE
91: , a11 JTF_VARCHAR2_TABLE_300
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if a0 is not null and a0.count > 0 then

Line 122: , a1 out nocopy JTF_VARCHAR2_TABLE_300

118: end if;
119: end if;
120: end rosetta_table_copy_in_p4;
121: procedure rosetta_table_copy_out_p4(t iem_emailaccount_pub.msg_header_table, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_300
123: , a2 out nocopy JTF_VARCHAR2_TABLE_200
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_VARCHAR2_TABLE_100
126: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 126: , a5 out nocopy JTF_VARCHAR2_TABLE_300

122: , a1 out nocopy JTF_VARCHAR2_TABLE_300
123: , a2 out nocopy JTF_VARCHAR2_TABLE_200
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_VARCHAR2_TABLE_100
126: , a5 out nocopy JTF_VARCHAR2_TABLE_300
127: , a6 out nocopy JTF_VARCHAR2_TABLE_100
128: , a7 out nocopy JTF_VARCHAR2_TABLE_300
129: , a8 out nocopy JTF_VARCHAR2_TABLE_300
130: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 128: , a7 out nocopy JTF_VARCHAR2_TABLE_300

124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_VARCHAR2_TABLE_100
126: , a5 out nocopy JTF_VARCHAR2_TABLE_300
127: , a6 out nocopy JTF_VARCHAR2_TABLE_100
128: , a7 out nocopy JTF_VARCHAR2_TABLE_300
129: , a8 out nocopy JTF_VARCHAR2_TABLE_300
130: , a9 out nocopy JTF_VARCHAR2_TABLE_300
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 129: , a8 out nocopy JTF_VARCHAR2_TABLE_300

125: , a4 out nocopy JTF_VARCHAR2_TABLE_100
126: , a5 out nocopy JTF_VARCHAR2_TABLE_300
127: , a6 out nocopy JTF_VARCHAR2_TABLE_100
128: , a7 out nocopy JTF_VARCHAR2_TABLE_300
129: , a8 out nocopy JTF_VARCHAR2_TABLE_300
130: , a9 out nocopy JTF_VARCHAR2_TABLE_300
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_VARCHAR2_TABLE_300
133: ) as

Line 130: , a9 out nocopy JTF_VARCHAR2_TABLE_300

126: , a5 out nocopy JTF_VARCHAR2_TABLE_300
127: , a6 out nocopy JTF_VARCHAR2_TABLE_100
128: , a7 out nocopy JTF_VARCHAR2_TABLE_300
129: , a8 out nocopy JTF_VARCHAR2_TABLE_300
130: , a9 out nocopy JTF_VARCHAR2_TABLE_300
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_VARCHAR2_TABLE_300
133: ) as
134: ddindx binary_integer; indx binary_integer;

Line 132: , a11 out nocopy JTF_VARCHAR2_TABLE_300

128: , a7 out nocopy JTF_VARCHAR2_TABLE_300
129: , a8 out nocopy JTF_VARCHAR2_TABLE_300
130: , a9 out nocopy JTF_VARCHAR2_TABLE_300
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_VARCHAR2_TABLE_300
133: ) as
134: ddindx binary_integer; indx binary_integer;
135: begin
136: if t is null or t.count = 0 then

Line 138: a1 := JTF_VARCHAR2_TABLE_300();

134: ddindx binary_integer; indx binary_integer;
135: begin
136: if t is null or t.count = 0 then
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_VARCHAR2_TABLE_300();
139: a2 := JTF_VARCHAR2_TABLE_200();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_300();

Line 142: a5 := JTF_VARCHAR2_TABLE_300();

138: a1 := JTF_VARCHAR2_TABLE_300();
139: a2 := JTF_VARCHAR2_TABLE_200();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_300();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: a7 := JTF_VARCHAR2_TABLE_300();
145: a8 := JTF_VARCHAR2_TABLE_300();
146: a9 := JTF_VARCHAR2_TABLE_300();

Line 144: a7 := JTF_VARCHAR2_TABLE_300();

140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_300();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: a7 := JTF_VARCHAR2_TABLE_300();
145: a8 := JTF_VARCHAR2_TABLE_300();
146: a9 := JTF_VARCHAR2_TABLE_300();
147: a10 := JTF_NUMBER_TABLE();
148: a11 := JTF_VARCHAR2_TABLE_300();

Line 145: a8 := JTF_VARCHAR2_TABLE_300();

141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_300();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: a7 := JTF_VARCHAR2_TABLE_300();
145: a8 := JTF_VARCHAR2_TABLE_300();
146: a9 := JTF_VARCHAR2_TABLE_300();
147: a10 := JTF_NUMBER_TABLE();
148: a11 := JTF_VARCHAR2_TABLE_300();
149: else

Line 146: a9 := JTF_VARCHAR2_TABLE_300();

142: a5 := JTF_VARCHAR2_TABLE_300();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: a7 := JTF_VARCHAR2_TABLE_300();
145: a8 := JTF_VARCHAR2_TABLE_300();
146: a9 := JTF_VARCHAR2_TABLE_300();
147: a10 := JTF_NUMBER_TABLE();
148: a11 := JTF_VARCHAR2_TABLE_300();
149: else
150: a0 := JTF_NUMBER_TABLE();

Line 148: a11 := JTF_VARCHAR2_TABLE_300();

144: a7 := JTF_VARCHAR2_TABLE_300();
145: a8 := JTF_VARCHAR2_TABLE_300();
146: a9 := JTF_VARCHAR2_TABLE_300();
147: a10 := JTF_NUMBER_TABLE();
148: a11 := JTF_VARCHAR2_TABLE_300();
149: else
150: a0 := JTF_NUMBER_TABLE();
151: a1 := JTF_VARCHAR2_TABLE_300();
152: a2 := JTF_VARCHAR2_TABLE_200();

Line 151: a1 := JTF_VARCHAR2_TABLE_300();

147: a10 := JTF_NUMBER_TABLE();
148: a11 := JTF_VARCHAR2_TABLE_300();
149: else
150: a0 := JTF_NUMBER_TABLE();
151: a1 := JTF_VARCHAR2_TABLE_300();
152: a2 := JTF_VARCHAR2_TABLE_200();
153: a3 := JTF_DATE_TABLE();
154: a4 := JTF_VARCHAR2_TABLE_100();
155: a5 := JTF_VARCHAR2_TABLE_300();

Line 155: a5 := JTF_VARCHAR2_TABLE_300();

151: a1 := JTF_VARCHAR2_TABLE_300();
152: a2 := JTF_VARCHAR2_TABLE_200();
153: a3 := JTF_DATE_TABLE();
154: a4 := JTF_VARCHAR2_TABLE_100();
155: a5 := JTF_VARCHAR2_TABLE_300();
156: a6 := JTF_VARCHAR2_TABLE_100();
157: a7 := JTF_VARCHAR2_TABLE_300();
158: a8 := JTF_VARCHAR2_TABLE_300();
159: a9 := JTF_VARCHAR2_TABLE_300();

Line 157: a7 := JTF_VARCHAR2_TABLE_300();

153: a3 := JTF_DATE_TABLE();
154: a4 := JTF_VARCHAR2_TABLE_100();
155: a5 := JTF_VARCHAR2_TABLE_300();
156: a6 := JTF_VARCHAR2_TABLE_100();
157: a7 := JTF_VARCHAR2_TABLE_300();
158: a8 := JTF_VARCHAR2_TABLE_300();
159: a9 := JTF_VARCHAR2_TABLE_300();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_300();

Line 158: a8 := JTF_VARCHAR2_TABLE_300();

154: a4 := JTF_VARCHAR2_TABLE_100();
155: a5 := JTF_VARCHAR2_TABLE_300();
156: a6 := JTF_VARCHAR2_TABLE_100();
157: a7 := JTF_VARCHAR2_TABLE_300();
158: a8 := JTF_VARCHAR2_TABLE_300();
159: a9 := JTF_VARCHAR2_TABLE_300();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_300();
162: if t.count > 0 then

Line 159: a9 := JTF_VARCHAR2_TABLE_300();

155: a5 := JTF_VARCHAR2_TABLE_300();
156: a6 := JTF_VARCHAR2_TABLE_100();
157: a7 := JTF_VARCHAR2_TABLE_300();
158: a8 := JTF_VARCHAR2_TABLE_300();
159: a9 := JTF_VARCHAR2_TABLE_300();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_300();
162: if t.count > 0 then
163: a0.extend(t.count);

Line 161: a11 := JTF_VARCHAR2_TABLE_300();

157: a7 := JTF_VARCHAR2_TABLE_300();
158: a8 := JTF_VARCHAR2_TABLE_300();
159: a9 := JTF_VARCHAR2_TABLE_300();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_300();
162: if t.count > 0 then
163: a0.extend(t.count);
164: a1.extend(t.count);
165: a2.extend(t.count);

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

267: end if;
268: end if;
269: end rosetta_table_copy_out_p6;
270:
271: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300
272: , a1 JTF_VARCHAR2_TABLE_100
273: , a2 JTF_VARCHAR2_TABLE_200
274: , a3 JTF_VARCHAR2_TABLE_300
275: , a4 JTF_VARCHAR2_TABLE_100

Line 274: , a3 JTF_VARCHAR2_TABLE_300

270:
271: procedure rosetta_table_copy_in_p8(t out nocopy iem_emailaccount_pub.acntdetails_tbl_type, a0 JTF_VARCHAR2_TABLE_300
272: , a1 JTF_VARCHAR2_TABLE_100
273: , a2 JTF_VARCHAR2_TABLE_200
274: , a3 JTF_VARCHAR2_TABLE_300
275: , a4 JTF_VARCHAR2_TABLE_100
276: , a5 JTF_NUMBER_TABLE
277: , a6 JTF_VARCHAR2_TABLE_300
278: , a7 JTF_NUMBER_TABLE

Line 277: , a6 JTF_VARCHAR2_TABLE_300

273: , a2 JTF_VARCHAR2_TABLE_200
274: , a3 JTF_VARCHAR2_TABLE_300
275: , a4 JTF_VARCHAR2_TABLE_100
276: , a5 JTF_NUMBER_TABLE
277: , a6 JTF_VARCHAR2_TABLE_300
278: , a7 JTF_NUMBER_TABLE
279: , a8 JTF_NUMBER_TABLE
280: ) as
281: ddindx binary_integer; indx binary_integer;

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

302: end loop;
303: end if;
304: end if;
305: end rosetta_table_copy_in_p8;
306: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
307: , a1 out nocopy JTF_VARCHAR2_TABLE_100
308: , a2 out nocopy JTF_VARCHAR2_TABLE_200
309: , a3 out nocopy JTF_VARCHAR2_TABLE_300
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 309: , a3 out nocopy JTF_VARCHAR2_TABLE_300

305: end rosetta_table_copy_in_p8;
306: procedure rosetta_table_copy_out_p8(t iem_emailaccount_pub.acntdetails_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
307: , a1 out nocopy JTF_VARCHAR2_TABLE_100
308: , a2 out nocopy JTF_VARCHAR2_TABLE_200
309: , a3 out nocopy JTF_VARCHAR2_TABLE_300
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
311: , a5 out nocopy JTF_NUMBER_TABLE
312: , a6 out nocopy JTF_VARCHAR2_TABLE_300
313: , a7 out nocopy JTF_NUMBER_TABLE

Line 312: , a6 out nocopy JTF_VARCHAR2_TABLE_300

308: , a2 out nocopy JTF_VARCHAR2_TABLE_200
309: , a3 out nocopy JTF_VARCHAR2_TABLE_300
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100
311: , a5 out nocopy JTF_NUMBER_TABLE
312: , a6 out nocopy JTF_VARCHAR2_TABLE_300
313: , a7 out nocopy JTF_NUMBER_TABLE
314: , a8 out nocopy JTF_NUMBER_TABLE
315: ) as
316: ddindx binary_integer; indx binary_integer;

Line 319: a0 := JTF_VARCHAR2_TABLE_300();

315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if t is null or t.count = 0 then
319: a0 := JTF_VARCHAR2_TABLE_300();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_200();
322: a3 := JTF_VARCHAR2_TABLE_300();
323: a4 := JTF_VARCHAR2_TABLE_100();

Line 322: a3 := JTF_VARCHAR2_TABLE_300();

318: if t is null or t.count = 0 then
319: a0 := JTF_VARCHAR2_TABLE_300();
320: a1 := JTF_VARCHAR2_TABLE_100();
321: a2 := JTF_VARCHAR2_TABLE_200();
322: a3 := JTF_VARCHAR2_TABLE_300();
323: a4 := JTF_VARCHAR2_TABLE_100();
324: a5 := JTF_NUMBER_TABLE();
325: a6 := JTF_VARCHAR2_TABLE_300();
326: a7 := JTF_NUMBER_TABLE();

Line 325: a6 := JTF_VARCHAR2_TABLE_300();

321: a2 := JTF_VARCHAR2_TABLE_200();
322: a3 := JTF_VARCHAR2_TABLE_300();
323: a4 := JTF_VARCHAR2_TABLE_100();
324: a5 := JTF_NUMBER_TABLE();
325: a6 := JTF_VARCHAR2_TABLE_300();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_NUMBER_TABLE();
328: else
329: a0 := JTF_VARCHAR2_TABLE_300();

Line 329: a0 := JTF_VARCHAR2_TABLE_300();

325: a6 := JTF_VARCHAR2_TABLE_300();
326: a7 := JTF_NUMBER_TABLE();
327: a8 := JTF_NUMBER_TABLE();
328: else
329: a0 := JTF_VARCHAR2_TABLE_300();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_200();
332: a3 := JTF_VARCHAR2_TABLE_300();
333: a4 := JTF_VARCHAR2_TABLE_100();

Line 332: a3 := JTF_VARCHAR2_TABLE_300();

328: else
329: a0 := JTF_VARCHAR2_TABLE_300();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_200();
332: a3 := JTF_VARCHAR2_TABLE_300();
333: a4 := JTF_VARCHAR2_TABLE_100();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();

Line 335: a6 := JTF_VARCHAR2_TABLE_300();

331: a2 := JTF_VARCHAR2_TABLE_200();
332: a3 := JTF_VARCHAR2_TABLE_300();
333: a4 := JTF_VARCHAR2_TABLE_100();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();
337: a8 := JTF_NUMBER_TABLE();
338: if t.count > 0 then
339: a0.extend(t.count);

Line 371: , a1 JTF_VARCHAR2_TABLE_300

367: end if;
368: end rosetta_table_copy_out_p8;
369:
370: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
371: , a1 JTF_VARCHAR2_TABLE_300
372: , a2 JTF_VARCHAR2_TABLE_300
373: , a3 JTF_VARCHAR2_TABLE_100
374: , a4 JTF_VARCHAR2_TABLE_300
375: ) as

Line 372: , a2 JTF_VARCHAR2_TABLE_300

368: end rosetta_table_copy_out_p8;
369:
370: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
371: , a1 JTF_VARCHAR2_TABLE_300
372: , a2 JTF_VARCHAR2_TABLE_300
373: , a3 JTF_VARCHAR2_TABLE_100
374: , a4 JTF_VARCHAR2_TABLE_300
375: ) as
376: ddindx binary_integer; indx binary_integer;

Line 374: , a4 JTF_VARCHAR2_TABLE_300

370: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
371: , a1 JTF_VARCHAR2_TABLE_300
372: , a2 JTF_VARCHAR2_TABLE_300
373: , a3 JTF_VARCHAR2_TABLE_100
374: , a4 JTF_VARCHAR2_TABLE_300
375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin
378: if a0 is not null and a0.count > 0 then

Line 398: , a1 out nocopy JTF_VARCHAR2_TABLE_300

394: end if;
395: end if;
396: end rosetta_table_copy_in_p10;
397: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
398: , a1 out nocopy JTF_VARCHAR2_TABLE_300
399: , a2 out nocopy JTF_VARCHAR2_TABLE_300
400: , a3 out nocopy JTF_VARCHAR2_TABLE_100
401: , a4 out nocopy JTF_VARCHAR2_TABLE_300
402: ) as

Line 399: , a2 out nocopy JTF_VARCHAR2_TABLE_300

395: end if;
396: end rosetta_table_copy_in_p10;
397: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
398: , a1 out nocopy JTF_VARCHAR2_TABLE_300
399: , a2 out nocopy JTF_VARCHAR2_TABLE_300
400: , a3 out nocopy JTF_VARCHAR2_TABLE_100
401: , a4 out nocopy JTF_VARCHAR2_TABLE_300
402: ) as
403: ddindx binary_integer; indx binary_integer;

Line 401: , a4 out nocopy JTF_VARCHAR2_TABLE_300

397: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
398: , a1 out nocopy JTF_VARCHAR2_TABLE_300
399: , a2 out nocopy JTF_VARCHAR2_TABLE_300
400: , a3 out nocopy JTF_VARCHAR2_TABLE_100
401: , a4 out nocopy JTF_VARCHAR2_TABLE_300
402: ) as
403: ddindx binary_integer; indx binary_integer;
404: begin
405: if t is null or t.count = 0 then

Line 407: a1 := JTF_VARCHAR2_TABLE_300();

403: ddindx binary_integer; indx binary_integer;
404: begin
405: if t is null or t.count = 0 then
406: a0 := JTF_NUMBER_TABLE();
407: a1 := JTF_VARCHAR2_TABLE_300();
408: a2 := JTF_VARCHAR2_TABLE_300();
409: a3 := JTF_VARCHAR2_TABLE_100();
410: a4 := JTF_VARCHAR2_TABLE_300();
411: else

Line 408: a2 := JTF_VARCHAR2_TABLE_300();

404: begin
405: if t is null or t.count = 0 then
406: a0 := JTF_NUMBER_TABLE();
407: a1 := JTF_VARCHAR2_TABLE_300();
408: a2 := JTF_VARCHAR2_TABLE_300();
409: a3 := JTF_VARCHAR2_TABLE_100();
410: a4 := JTF_VARCHAR2_TABLE_300();
411: else
412: a0 := JTF_NUMBER_TABLE();

Line 410: a4 := JTF_VARCHAR2_TABLE_300();

406: a0 := JTF_NUMBER_TABLE();
407: a1 := JTF_VARCHAR2_TABLE_300();
408: a2 := JTF_VARCHAR2_TABLE_300();
409: a3 := JTF_VARCHAR2_TABLE_100();
410: a4 := JTF_VARCHAR2_TABLE_300();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_VARCHAR2_TABLE_300();
414: a2 := JTF_VARCHAR2_TABLE_300();

Line 413: a1 := JTF_VARCHAR2_TABLE_300();

409: a3 := JTF_VARCHAR2_TABLE_100();
410: a4 := JTF_VARCHAR2_TABLE_300();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_VARCHAR2_TABLE_300();
414: a2 := JTF_VARCHAR2_TABLE_300();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_VARCHAR2_TABLE_300();
417: if t.count > 0 then

Line 414: a2 := JTF_VARCHAR2_TABLE_300();

410: a4 := JTF_VARCHAR2_TABLE_300();
411: else
412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_VARCHAR2_TABLE_300();
414: a2 := JTF_VARCHAR2_TABLE_300();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_VARCHAR2_TABLE_300();
417: if t.count > 0 then
418: a0.extend(t.count);

Line 416: a4 := JTF_VARCHAR2_TABLE_300();

412: a0 := JTF_NUMBER_TABLE();
413: a1 := JTF_VARCHAR2_TABLE_300();
414: a2 := JTF_VARCHAR2_TABLE_300();
415: a3 := JTF_VARCHAR2_TABLE_100();
416: a4 := JTF_VARCHAR2_TABLE_300();
417: if t.count > 0 then
418: a0.extend(t.count);
419: a1.extend(t.count);
420: a2.extend(t.count);

Line 443: , a2 JTF_VARCHAR2_TABLE_300

439: end rosetta_table_copy_out_p10;
440:
441: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
442: , a1 JTF_NUMBER_TABLE
443: , a2 JTF_VARCHAR2_TABLE_300
444: , a3 JTF_VARCHAR2_TABLE_300
445: , a4 JTF_VARCHAR2_TABLE_300
446: , a5 JTF_VARCHAR2_TABLE_300
447: , a6 JTF_VARCHAR2_TABLE_300

Line 444: , a3 JTF_VARCHAR2_TABLE_300

440:
441: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
442: , a1 JTF_NUMBER_TABLE
443: , a2 JTF_VARCHAR2_TABLE_300
444: , a3 JTF_VARCHAR2_TABLE_300
445: , a4 JTF_VARCHAR2_TABLE_300
446: , a5 JTF_VARCHAR2_TABLE_300
447: , a6 JTF_VARCHAR2_TABLE_300
448: , a7 JTF_VARCHAR2_TABLE_300

Line 445: , a4 JTF_VARCHAR2_TABLE_300

441: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
442: , a1 JTF_NUMBER_TABLE
443: , a2 JTF_VARCHAR2_TABLE_300
444: , a3 JTF_VARCHAR2_TABLE_300
445: , a4 JTF_VARCHAR2_TABLE_300
446: , a5 JTF_VARCHAR2_TABLE_300
447: , a6 JTF_VARCHAR2_TABLE_300
448: , a7 JTF_VARCHAR2_TABLE_300
449: ) as

Line 446: , a5 JTF_VARCHAR2_TABLE_300

442: , a1 JTF_NUMBER_TABLE
443: , a2 JTF_VARCHAR2_TABLE_300
444: , a3 JTF_VARCHAR2_TABLE_300
445: , a4 JTF_VARCHAR2_TABLE_300
446: , a5 JTF_VARCHAR2_TABLE_300
447: , a6 JTF_VARCHAR2_TABLE_300
448: , a7 JTF_VARCHAR2_TABLE_300
449: ) as
450: ddindx binary_integer; indx binary_integer;

Line 447: , a6 JTF_VARCHAR2_TABLE_300

443: , a2 JTF_VARCHAR2_TABLE_300
444: , a3 JTF_VARCHAR2_TABLE_300
445: , a4 JTF_VARCHAR2_TABLE_300
446: , a5 JTF_VARCHAR2_TABLE_300
447: , a6 JTF_VARCHAR2_TABLE_300
448: , a7 JTF_VARCHAR2_TABLE_300
449: ) as
450: ddindx binary_integer; indx binary_integer;
451: begin

Line 448: , a7 JTF_VARCHAR2_TABLE_300

444: , a3 JTF_VARCHAR2_TABLE_300
445: , a4 JTF_VARCHAR2_TABLE_300
446: , a5 JTF_VARCHAR2_TABLE_300
447: , a6 JTF_VARCHAR2_TABLE_300
448: , a7 JTF_VARCHAR2_TABLE_300
449: ) as
450: ddindx binary_integer; indx binary_integer;
451: begin
452: if a0 is not null and a0.count > 0 then

Line 476: , a2 out nocopy JTF_VARCHAR2_TABLE_300

472: end if;
473: end rosetta_table_copy_in_p12;
474: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
475: , a1 out nocopy JTF_NUMBER_TABLE
476: , a2 out nocopy JTF_VARCHAR2_TABLE_300
477: , a3 out nocopy JTF_VARCHAR2_TABLE_300
478: , a4 out nocopy JTF_VARCHAR2_TABLE_300
479: , a5 out nocopy JTF_VARCHAR2_TABLE_300
480: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 477: , a3 out nocopy JTF_VARCHAR2_TABLE_300

473: end rosetta_table_copy_in_p12;
474: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
475: , a1 out nocopy JTF_NUMBER_TABLE
476: , a2 out nocopy JTF_VARCHAR2_TABLE_300
477: , a3 out nocopy JTF_VARCHAR2_TABLE_300
478: , a4 out nocopy JTF_VARCHAR2_TABLE_300
479: , a5 out nocopy JTF_VARCHAR2_TABLE_300
480: , a6 out nocopy JTF_VARCHAR2_TABLE_300
481: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 478: , a4 out nocopy JTF_VARCHAR2_TABLE_300

474: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
475: , a1 out nocopy JTF_NUMBER_TABLE
476: , a2 out nocopy JTF_VARCHAR2_TABLE_300
477: , a3 out nocopy JTF_VARCHAR2_TABLE_300
478: , a4 out nocopy JTF_VARCHAR2_TABLE_300
479: , a5 out nocopy JTF_VARCHAR2_TABLE_300
480: , a6 out nocopy JTF_VARCHAR2_TABLE_300
481: , a7 out nocopy JTF_VARCHAR2_TABLE_300
482: ) as

Line 479: , a5 out nocopy JTF_VARCHAR2_TABLE_300

475: , a1 out nocopy JTF_NUMBER_TABLE
476: , a2 out nocopy JTF_VARCHAR2_TABLE_300
477: , a3 out nocopy JTF_VARCHAR2_TABLE_300
478: , a4 out nocopy JTF_VARCHAR2_TABLE_300
479: , a5 out nocopy JTF_VARCHAR2_TABLE_300
480: , a6 out nocopy JTF_VARCHAR2_TABLE_300
481: , a7 out nocopy JTF_VARCHAR2_TABLE_300
482: ) as
483: ddindx binary_integer; indx binary_integer;

Line 480: , a6 out nocopy JTF_VARCHAR2_TABLE_300

476: , a2 out nocopy JTF_VARCHAR2_TABLE_300
477: , a3 out nocopy JTF_VARCHAR2_TABLE_300
478: , a4 out nocopy JTF_VARCHAR2_TABLE_300
479: , a5 out nocopy JTF_VARCHAR2_TABLE_300
480: , a6 out nocopy JTF_VARCHAR2_TABLE_300
481: , a7 out nocopy JTF_VARCHAR2_TABLE_300
482: ) as
483: ddindx binary_integer; indx binary_integer;
484: begin

Line 481: , a7 out nocopy JTF_VARCHAR2_TABLE_300

477: , a3 out nocopy JTF_VARCHAR2_TABLE_300
478: , a4 out nocopy JTF_VARCHAR2_TABLE_300
479: , a5 out nocopy JTF_VARCHAR2_TABLE_300
480: , a6 out nocopy JTF_VARCHAR2_TABLE_300
481: , a7 out nocopy JTF_VARCHAR2_TABLE_300
482: ) as
483: ddindx binary_integer; indx binary_integer;
484: begin
485: if t is null or t.count = 0 then

Line 488: a2 := JTF_VARCHAR2_TABLE_300();

484: begin
485: if t is null or t.count = 0 then
486: a0 := JTF_NUMBER_TABLE();
487: a1 := JTF_NUMBER_TABLE();
488: a2 := JTF_VARCHAR2_TABLE_300();
489: a3 := JTF_VARCHAR2_TABLE_300();
490: a4 := JTF_VARCHAR2_TABLE_300();
491: a5 := JTF_VARCHAR2_TABLE_300();
492: a6 := JTF_VARCHAR2_TABLE_300();

Line 489: a3 := JTF_VARCHAR2_TABLE_300();

485: if t is null or t.count = 0 then
486: a0 := JTF_NUMBER_TABLE();
487: a1 := JTF_NUMBER_TABLE();
488: a2 := JTF_VARCHAR2_TABLE_300();
489: a3 := JTF_VARCHAR2_TABLE_300();
490: a4 := JTF_VARCHAR2_TABLE_300();
491: a5 := JTF_VARCHAR2_TABLE_300();
492: a6 := JTF_VARCHAR2_TABLE_300();
493: a7 := JTF_VARCHAR2_TABLE_300();

Line 490: a4 := JTF_VARCHAR2_TABLE_300();

486: a0 := JTF_NUMBER_TABLE();
487: a1 := JTF_NUMBER_TABLE();
488: a2 := JTF_VARCHAR2_TABLE_300();
489: a3 := JTF_VARCHAR2_TABLE_300();
490: a4 := JTF_VARCHAR2_TABLE_300();
491: a5 := JTF_VARCHAR2_TABLE_300();
492: a6 := JTF_VARCHAR2_TABLE_300();
493: a7 := JTF_VARCHAR2_TABLE_300();
494: else

Line 491: a5 := JTF_VARCHAR2_TABLE_300();

487: a1 := JTF_NUMBER_TABLE();
488: a2 := JTF_VARCHAR2_TABLE_300();
489: a3 := JTF_VARCHAR2_TABLE_300();
490: a4 := JTF_VARCHAR2_TABLE_300();
491: a5 := JTF_VARCHAR2_TABLE_300();
492: a6 := JTF_VARCHAR2_TABLE_300();
493: a7 := JTF_VARCHAR2_TABLE_300();
494: else
495: a0 := JTF_NUMBER_TABLE();

Line 492: a6 := JTF_VARCHAR2_TABLE_300();

488: a2 := JTF_VARCHAR2_TABLE_300();
489: a3 := JTF_VARCHAR2_TABLE_300();
490: a4 := JTF_VARCHAR2_TABLE_300();
491: a5 := JTF_VARCHAR2_TABLE_300();
492: a6 := JTF_VARCHAR2_TABLE_300();
493: a7 := JTF_VARCHAR2_TABLE_300();
494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();

Line 493: a7 := JTF_VARCHAR2_TABLE_300();

489: a3 := JTF_VARCHAR2_TABLE_300();
490: a4 := JTF_VARCHAR2_TABLE_300();
491: a5 := JTF_VARCHAR2_TABLE_300();
492: a6 := JTF_VARCHAR2_TABLE_300();
493: a7 := JTF_VARCHAR2_TABLE_300();
494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();

Line 497: a2 := JTF_VARCHAR2_TABLE_300();

493: a7 := JTF_VARCHAR2_TABLE_300();
494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_VARCHAR2_TABLE_300();
500: a5 := JTF_VARCHAR2_TABLE_300();
501: a6 := JTF_VARCHAR2_TABLE_300();

Line 498: a3 := JTF_VARCHAR2_TABLE_300();

494: else
495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_VARCHAR2_TABLE_300();
500: a5 := JTF_VARCHAR2_TABLE_300();
501: a6 := JTF_VARCHAR2_TABLE_300();
502: a7 := JTF_VARCHAR2_TABLE_300();

Line 499: a4 := JTF_VARCHAR2_TABLE_300();

495: a0 := JTF_NUMBER_TABLE();
496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_VARCHAR2_TABLE_300();
500: a5 := JTF_VARCHAR2_TABLE_300();
501: a6 := JTF_VARCHAR2_TABLE_300();
502: a7 := JTF_VARCHAR2_TABLE_300();
503: if t.count > 0 then

Line 500: a5 := JTF_VARCHAR2_TABLE_300();

496: a1 := JTF_NUMBER_TABLE();
497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_VARCHAR2_TABLE_300();
500: a5 := JTF_VARCHAR2_TABLE_300();
501: a6 := JTF_VARCHAR2_TABLE_300();
502: a7 := JTF_VARCHAR2_TABLE_300();
503: if t.count > 0 then
504: a0.extend(t.count);

Line 501: a6 := JTF_VARCHAR2_TABLE_300();

497: a2 := JTF_VARCHAR2_TABLE_300();
498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_VARCHAR2_TABLE_300();
500: a5 := JTF_VARCHAR2_TABLE_300();
501: a6 := JTF_VARCHAR2_TABLE_300();
502: a7 := JTF_VARCHAR2_TABLE_300();
503: if t.count > 0 then
504: a0.extend(t.count);
505: a1.extend(t.count);

Line 502: a7 := JTF_VARCHAR2_TABLE_300();

498: a3 := JTF_VARCHAR2_TABLE_300();
499: a4 := JTF_VARCHAR2_TABLE_300();
500: a5 := JTF_VARCHAR2_TABLE_300();
501: a6 := JTF_VARCHAR2_TABLE_300();
502: a7 := JTF_VARCHAR2_TABLE_300();
503: if t.count > 0 then
504: a0.extend(t.count);
505: a1.extend(t.count);
506: a2.extend(t.count);

Line 540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

536: , p_resource_id NUMBER
537: , x_return_status out nocopy VARCHAR2
538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
542: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
543: , p7_a3 out nocopy JTF_NUMBER_TABLE
544: )

Line 541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300

537: , x_return_status out nocopy VARCHAR2
538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
542: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
543: , p7_a3 out nocopy JTF_NUMBER_TABLE
544: )
545:

Line 590: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300

586: , p_top_n INTEGER
587: , p_top_option INTEGER
588: , p_folder_path VARCHAR2
589: , p4_a0 out nocopy JTF_NUMBER_TABLE
590: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
591: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
592: , p4_a3 out nocopy JTF_DATE_TABLE
593: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
594: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 594: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

590: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
591: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
592: , p4_a3 out nocopy JTF_DATE_TABLE
593: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
594: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
595: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
597: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 596: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

592: , p4_a3 out nocopy JTF_DATE_TABLE
593: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
594: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
595: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
597: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
599: , p4_a10 out nocopy JTF_NUMBER_TABLE
600: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 597: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300

593: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
594: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
595: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
597: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
599: , p4_a10 out nocopy JTF_NUMBER_TABLE
600: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
601: )

Line 598: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

594: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
595: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
596: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
597: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
599: , p4_a10 out nocopy JTF_NUMBER_TABLE
600: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
601: )
602:

Line 600: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

596: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
597: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
599: , p4_a10 out nocopy JTF_NUMBER_TABLE
600: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
601: )
602:
603: as
604: ddmessage_headers iem_emailaccount_pub.msg_header_table;

Line 650: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

646: , x_msg_count out nocopy NUMBER
647: , x_msg_data out nocopy VARCHAR2
648: , p7_a0 out nocopy JTF_NUMBER_TABLE
649: , p7_a1 out nocopy JTF_NUMBER_TABLE
650: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

647: , x_msg_data out nocopy VARCHAR2
648: , p7_a0 out nocopy JTF_NUMBER_TABLE
649: , p7_a1 out nocopy JTF_NUMBER_TABLE
650: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
655: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

648: , p7_a0 out nocopy JTF_NUMBER_TABLE
649: , p7_a1 out nocopy JTF_NUMBER_TABLE
650: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
655: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
656: )

Line 653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

649: , p7_a1 out nocopy JTF_NUMBER_TABLE
650: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
655: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
656: )
657:

Line 654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

650: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
655: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
656: )
657:
658: as

Line 655: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

651: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
652: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
653: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
654: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
655: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
656: )
657:
658: as
659: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;

Line 717: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300

713: , x_msg_count out nocopy NUMBER
714: , x_search_count out nocopy NUMBER
715: , x_msg_data out nocopy VARCHAR2
716: , p15_a0 out nocopy JTF_NUMBER_TABLE
717: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
718: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
719: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
720: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
721: )

Line 718: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300

714: , x_search_count out nocopy NUMBER
715: , x_msg_data out nocopy VARCHAR2
716: , p15_a0 out nocopy JTF_NUMBER_TABLE
717: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
718: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
719: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
720: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
721: )
722:

Line 720: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300

716: , p15_a0 out nocopy JTF_NUMBER_TABLE
717: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
718: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
719: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
720: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
721: )
722:
723: as
724: ddx_agent_acnt_dtl_data iem_emailaccount_pub.agntacntdetails_tbl_type;

Line 794: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

790: , p_email_account_id NUMBER
791: , x_return_status out nocopy VARCHAR2
792: , x_msg_count out nocopy NUMBER
793: , x_msg_data out nocopy VARCHAR2
794: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
795: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
796: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
797: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
798: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 797: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

793: , x_msg_data out nocopy VARCHAR2
794: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
795: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
796: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
797: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
798: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
799: , p7_a5 out nocopy JTF_NUMBER_TABLE
800: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
801: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 800: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

796: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
797: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
798: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
799: , p7_a5 out nocopy JTF_NUMBER_TABLE
800: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
801: , p7_a7 out nocopy JTF_NUMBER_TABLE
802: , p7_a8 out nocopy JTF_NUMBER_TABLE
803: )
804: