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: , a9 JTF_VARCHAR2_TABLE_100
281: ) as

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

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

Line 311: , a3 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 314: , a6 out nocopy JTF_VARCHAR2_TABLE_300

310: , a2 out nocopy JTF_VARCHAR2_TABLE_200
311: , a3 out nocopy JTF_VARCHAR2_TABLE_300
312: , a4 out nocopy JTF_VARCHAR2_TABLE_100
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_VARCHAR2_TABLE_300
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_NUMBER_TABLE
317: , a9 out nocopy JTF_VARCHAR2_TABLE_100
318: ) as

Line 322: a0 := JTF_VARCHAR2_TABLE_300();

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

Line 325: a3 := JTF_VARCHAR2_TABLE_300();

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

Line 328: a6 := JTF_VARCHAR2_TABLE_300();

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

Line 333: a0 := JTF_VARCHAR2_TABLE_300();

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

Line 336: a3 := JTF_VARCHAR2_TABLE_300();

332: else
333: a0 := JTF_VARCHAR2_TABLE_300();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_200();
336: a3 := JTF_VARCHAR2_TABLE_300();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_VARCHAR2_TABLE_300();
340: a7 := JTF_NUMBER_TABLE();

Line 339: a6 := JTF_VARCHAR2_TABLE_300();

335: a2 := JTF_VARCHAR2_TABLE_200();
336: a3 := JTF_VARCHAR2_TABLE_300();
337: a4 := JTF_VARCHAR2_TABLE_100();
338: a5 := JTF_NUMBER_TABLE();
339: a6 := JTF_VARCHAR2_TABLE_300();
340: a7 := JTF_NUMBER_TABLE();
341: a8 := JTF_NUMBER_TABLE();
342: a9 := JTF_VARCHAR2_TABLE_100();
343: if t.count > 0 then

Line 378: , a1 JTF_VARCHAR2_TABLE_300

374: end if;
375: end rosetta_table_copy_out_p8;
376:
377: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_VARCHAR2_TABLE_300
379: , a2 JTF_VARCHAR2_TABLE_300
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_VARCHAR2_TABLE_300
382: ) as

Line 379: , a2 JTF_VARCHAR2_TABLE_300

375: end rosetta_table_copy_out_p8;
376:
377: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_VARCHAR2_TABLE_300
379: , a2 JTF_VARCHAR2_TABLE_300
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_VARCHAR2_TABLE_300
382: ) as
383: ddindx binary_integer; indx binary_integer;

Line 381: , a4 JTF_VARCHAR2_TABLE_300

377: procedure rosetta_table_copy_in_p10(t out nocopy iem_emailaccount_pub.agntacntdetails_tbl_type, a0 JTF_NUMBER_TABLE
378: , a1 JTF_VARCHAR2_TABLE_300
379: , a2 JTF_VARCHAR2_TABLE_300
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_VARCHAR2_TABLE_300
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if a0 is not null and a0.count > 0 then

Line 405: , a1 out nocopy JTF_VARCHAR2_TABLE_300

401: end if;
402: end if;
403: end rosetta_table_copy_in_p10;
404: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_VARCHAR2_TABLE_300
406: , a2 out nocopy JTF_VARCHAR2_TABLE_300
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_VARCHAR2_TABLE_300
409: ) as

Line 406: , a2 out nocopy JTF_VARCHAR2_TABLE_300

402: end if;
403: end rosetta_table_copy_in_p10;
404: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_VARCHAR2_TABLE_300
406: , a2 out nocopy JTF_VARCHAR2_TABLE_300
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_VARCHAR2_TABLE_300
409: ) as
410: ddindx binary_integer; indx binary_integer;

Line 408: , a4 out nocopy JTF_VARCHAR2_TABLE_300

404: procedure rosetta_table_copy_out_p10(t iem_emailaccount_pub.agntacntdetails_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_VARCHAR2_TABLE_300
406: , a2 out nocopy JTF_VARCHAR2_TABLE_300
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_VARCHAR2_TABLE_300
409: ) as
410: ddindx binary_integer; indx binary_integer;
411: begin
412: if t is null or t.count = 0 then

Line 414: a1 := JTF_VARCHAR2_TABLE_300();

410: ddindx binary_integer; indx binary_integer;
411: begin
412: if t is null or t.count = 0 then
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_300();
415: a2 := JTF_VARCHAR2_TABLE_300();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_VARCHAR2_TABLE_300();
418: else

Line 415: a2 := JTF_VARCHAR2_TABLE_300();

411: begin
412: if t is null or t.count = 0 then
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_300();
415: a2 := JTF_VARCHAR2_TABLE_300();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_VARCHAR2_TABLE_300();
418: else
419: a0 := JTF_NUMBER_TABLE();

Line 417: a4 := JTF_VARCHAR2_TABLE_300();

413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_300();
415: a2 := JTF_VARCHAR2_TABLE_300();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_VARCHAR2_TABLE_300();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_300();
421: a2 := JTF_VARCHAR2_TABLE_300();

Line 420: a1 := JTF_VARCHAR2_TABLE_300();

416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_VARCHAR2_TABLE_300();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_300();
421: a2 := JTF_VARCHAR2_TABLE_300();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_VARCHAR2_TABLE_300();
424: if t.count > 0 then

Line 421: a2 := JTF_VARCHAR2_TABLE_300();

417: a4 := JTF_VARCHAR2_TABLE_300();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_300();
421: a2 := JTF_VARCHAR2_TABLE_300();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_VARCHAR2_TABLE_300();
424: if t.count > 0 then
425: a0.extend(t.count);

Line 423: a4 := JTF_VARCHAR2_TABLE_300();

419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_VARCHAR2_TABLE_300();
421: a2 := JTF_VARCHAR2_TABLE_300();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_VARCHAR2_TABLE_300();
424: if t.count > 0 then
425: a0.extend(t.count);
426: a1.extend(t.count);
427: a2.extend(t.count);

Line 450: , a2 JTF_VARCHAR2_TABLE_300

446: end rosetta_table_copy_out_p10;
447:
448: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
449: , a1 JTF_NUMBER_TABLE
450: , a2 JTF_VARCHAR2_TABLE_300
451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300
453: , a5 JTF_VARCHAR2_TABLE_300
454: , a6 JTF_VARCHAR2_TABLE_300

Line 451: , a3 JTF_VARCHAR2_TABLE_300

447:
448: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
449: , a1 JTF_NUMBER_TABLE
450: , a2 JTF_VARCHAR2_TABLE_300
451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300
453: , a5 JTF_VARCHAR2_TABLE_300
454: , a6 JTF_VARCHAR2_TABLE_300
455: , a7 JTF_VARCHAR2_TABLE_300

Line 452: , a4 JTF_VARCHAR2_TABLE_300

448: procedure rosetta_table_copy_in_p12(t out nocopy iem_emailaccount_pub.agentacnt_tbl_type, a0 JTF_NUMBER_TABLE
449: , a1 JTF_NUMBER_TABLE
450: , a2 JTF_VARCHAR2_TABLE_300
451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300
453: , a5 JTF_VARCHAR2_TABLE_300
454: , a6 JTF_VARCHAR2_TABLE_300
455: , a7 JTF_VARCHAR2_TABLE_300
456: ) as

Line 453: , a5 JTF_VARCHAR2_TABLE_300

449: , a1 JTF_NUMBER_TABLE
450: , a2 JTF_VARCHAR2_TABLE_300
451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300
453: , a5 JTF_VARCHAR2_TABLE_300
454: , a6 JTF_VARCHAR2_TABLE_300
455: , a7 JTF_VARCHAR2_TABLE_300
456: ) as
457: ddindx binary_integer; indx binary_integer;

Line 454: , a6 JTF_VARCHAR2_TABLE_300

450: , a2 JTF_VARCHAR2_TABLE_300
451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300
453: , a5 JTF_VARCHAR2_TABLE_300
454: , a6 JTF_VARCHAR2_TABLE_300
455: , a7 JTF_VARCHAR2_TABLE_300
456: ) as
457: ddindx binary_integer; indx binary_integer;
458: begin

Line 455: , a7 JTF_VARCHAR2_TABLE_300

451: , a3 JTF_VARCHAR2_TABLE_300
452: , a4 JTF_VARCHAR2_TABLE_300
453: , a5 JTF_VARCHAR2_TABLE_300
454: , a6 JTF_VARCHAR2_TABLE_300
455: , a7 JTF_VARCHAR2_TABLE_300
456: ) as
457: ddindx binary_integer; indx binary_integer;
458: begin
459: if a0 is not null and a0.count > 0 then

Line 483: , a2 out nocopy JTF_VARCHAR2_TABLE_300

479: end if;
480: end rosetta_table_copy_in_p12;
481: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_VARCHAR2_TABLE_300
484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300
486: , a5 out nocopy JTF_VARCHAR2_TABLE_300
487: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 484: , a3 out nocopy JTF_VARCHAR2_TABLE_300

480: end rosetta_table_copy_in_p12;
481: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_VARCHAR2_TABLE_300
484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300
486: , a5 out nocopy JTF_VARCHAR2_TABLE_300
487: , a6 out nocopy JTF_VARCHAR2_TABLE_300
488: , a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 485: , a4 out nocopy JTF_VARCHAR2_TABLE_300

481: procedure rosetta_table_copy_out_p12(t iem_emailaccount_pub.agentacnt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_VARCHAR2_TABLE_300
484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300
486: , a5 out nocopy JTF_VARCHAR2_TABLE_300
487: , a6 out nocopy JTF_VARCHAR2_TABLE_300
488: , a7 out nocopy JTF_VARCHAR2_TABLE_300
489: ) as

Line 486: , a5 out nocopy JTF_VARCHAR2_TABLE_300

482: , a1 out nocopy JTF_NUMBER_TABLE
483: , a2 out nocopy JTF_VARCHAR2_TABLE_300
484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300
486: , a5 out nocopy JTF_VARCHAR2_TABLE_300
487: , a6 out nocopy JTF_VARCHAR2_TABLE_300
488: , a7 out nocopy JTF_VARCHAR2_TABLE_300
489: ) as
490: ddindx binary_integer; indx binary_integer;

Line 487: , a6 out nocopy JTF_VARCHAR2_TABLE_300

483: , a2 out nocopy JTF_VARCHAR2_TABLE_300
484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300
486: , a5 out nocopy JTF_VARCHAR2_TABLE_300
487: , a6 out nocopy JTF_VARCHAR2_TABLE_300
488: , a7 out nocopy JTF_VARCHAR2_TABLE_300
489: ) as
490: ddindx binary_integer; indx binary_integer;
491: begin

Line 488: , a7 out nocopy JTF_VARCHAR2_TABLE_300

484: , a3 out nocopy JTF_VARCHAR2_TABLE_300
485: , a4 out nocopy JTF_VARCHAR2_TABLE_300
486: , a5 out nocopy JTF_VARCHAR2_TABLE_300
487: , a6 out nocopy JTF_VARCHAR2_TABLE_300
488: , a7 out nocopy JTF_VARCHAR2_TABLE_300
489: ) as
490: ddindx binary_integer; indx binary_integer;
491: begin
492: if t is null or t.count = 0 then

Line 495: a2 := JTF_VARCHAR2_TABLE_300();

491: begin
492: if t is null or t.count = 0 then
493: a0 := JTF_NUMBER_TABLE();
494: a1 := JTF_NUMBER_TABLE();
495: a2 := JTF_VARCHAR2_TABLE_300();
496: a3 := JTF_VARCHAR2_TABLE_300();
497: a4 := JTF_VARCHAR2_TABLE_300();
498: a5 := JTF_VARCHAR2_TABLE_300();
499: a6 := JTF_VARCHAR2_TABLE_300();

Line 496: a3 := JTF_VARCHAR2_TABLE_300();

492: if t is null or t.count = 0 then
493: a0 := JTF_NUMBER_TABLE();
494: a1 := JTF_NUMBER_TABLE();
495: a2 := JTF_VARCHAR2_TABLE_300();
496: a3 := JTF_VARCHAR2_TABLE_300();
497: a4 := JTF_VARCHAR2_TABLE_300();
498: a5 := JTF_VARCHAR2_TABLE_300();
499: a6 := JTF_VARCHAR2_TABLE_300();
500: a7 := JTF_VARCHAR2_TABLE_300();

Line 497: a4 := JTF_VARCHAR2_TABLE_300();

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

Line 498: a5 := JTF_VARCHAR2_TABLE_300();

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

Line 499: a6 := JTF_VARCHAR2_TABLE_300();

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

Line 500: a7 := JTF_VARCHAR2_TABLE_300();

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

Line 504: a2 := JTF_VARCHAR2_TABLE_300();

500: a7 := JTF_VARCHAR2_TABLE_300();
501: else
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_300();
505: a3 := JTF_VARCHAR2_TABLE_300();
506: a4 := JTF_VARCHAR2_TABLE_300();
507: a5 := JTF_VARCHAR2_TABLE_300();
508: a6 := JTF_VARCHAR2_TABLE_300();

Line 505: a3 := JTF_VARCHAR2_TABLE_300();

501: else
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_300();
505: a3 := JTF_VARCHAR2_TABLE_300();
506: a4 := JTF_VARCHAR2_TABLE_300();
507: a5 := JTF_VARCHAR2_TABLE_300();
508: a6 := JTF_VARCHAR2_TABLE_300();
509: a7 := JTF_VARCHAR2_TABLE_300();

Line 506: a4 := JTF_VARCHAR2_TABLE_300();

502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_300();
505: a3 := JTF_VARCHAR2_TABLE_300();
506: a4 := JTF_VARCHAR2_TABLE_300();
507: a5 := JTF_VARCHAR2_TABLE_300();
508: a6 := JTF_VARCHAR2_TABLE_300();
509: a7 := JTF_VARCHAR2_TABLE_300();
510: if t.count > 0 then

Line 507: a5 := JTF_VARCHAR2_TABLE_300();

503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_VARCHAR2_TABLE_300();
505: a3 := JTF_VARCHAR2_TABLE_300();
506: a4 := JTF_VARCHAR2_TABLE_300();
507: a5 := JTF_VARCHAR2_TABLE_300();
508: a6 := JTF_VARCHAR2_TABLE_300();
509: a7 := JTF_VARCHAR2_TABLE_300();
510: if t.count > 0 then
511: a0.extend(t.count);

Line 508: a6 := JTF_VARCHAR2_TABLE_300();

504: a2 := JTF_VARCHAR2_TABLE_300();
505: a3 := JTF_VARCHAR2_TABLE_300();
506: a4 := JTF_VARCHAR2_TABLE_300();
507: a5 := JTF_VARCHAR2_TABLE_300();
508: a6 := JTF_VARCHAR2_TABLE_300();
509: a7 := JTF_VARCHAR2_TABLE_300();
510: if t.count > 0 then
511: a0.extend(t.count);
512: a1.extend(t.count);

Line 509: a7 := JTF_VARCHAR2_TABLE_300();

505: a3 := JTF_VARCHAR2_TABLE_300();
506: a4 := JTF_VARCHAR2_TABLE_300();
507: a5 := JTF_VARCHAR2_TABLE_300();
508: a6 := JTF_VARCHAR2_TABLE_300();
509: a7 := JTF_VARCHAR2_TABLE_300();
510: if t.count > 0 then
511: a0.extend(t.count);
512: a1.extend(t.count);
513: a2.extend(t.count);

Line 547: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

543: , p_resource_id NUMBER
544: , x_return_status out nocopy VARCHAR2
545: , x_msg_count out nocopy NUMBER
546: , x_msg_data out nocopy VARCHAR2
547: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
548: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
549: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
550: , p7_a3 out nocopy JTF_NUMBER_TABLE
551: )

Line 548: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300

544: , x_return_status out nocopy VARCHAR2
545: , x_msg_count out nocopy NUMBER
546: , x_msg_data out nocopy VARCHAR2
547: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
548: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_300
549: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
550: , p7_a3 out nocopy JTF_NUMBER_TABLE
551: )
552:

Line 597: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300

593: , p_top_n INTEGER
594: , p_top_option INTEGER
595: , p_folder_path VARCHAR2
596: , p4_a0 out nocopy JTF_NUMBER_TABLE
597: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
599: , p4_a3 out nocopy JTF_DATE_TABLE
600: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
601: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 601: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300

597: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_300
598: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
599: , p4_a3 out nocopy JTF_DATE_TABLE
600: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
601: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
602: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
603: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
604: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
605: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 603: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300

599: , p4_a3 out nocopy JTF_DATE_TABLE
600: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
601: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
602: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
603: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
604: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
605: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
606: , p4_a10 out nocopy JTF_NUMBER_TABLE
607: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 604: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300

600: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
601: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
602: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
603: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
604: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
605: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
606: , p4_a10 out nocopy JTF_NUMBER_TABLE
607: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
608: )

Line 605: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300

601: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
602: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
603: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
604: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
605: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
606: , p4_a10 out nocopy JTF_NUMBER_TABLE
607: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
608: )
609:

Line 607: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300

603: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
604: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_300
605: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_300
606: , p4_a10 out nocopy JTF_NUMBER_TABLE
607: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
608: )
609:
610: as
611: ddmessage_headers iem_emailaccount_pub.msg_header_table;

Line 657: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

653: , x_msg_count out nocopy NUMBER
654: , x_msg_data out nocopy VARCHAR2
655: , p7_a0 out nocopy JTF_NUMBER_TABLE
656: , p7_a1 out nocopy JTF_NUMBER_TABLE
657: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

654: , x_msg_data out nocopy VARCHAR2
655: , p7_a0 out nocopy JTF_NUMBER_TABLE
656: , p7_a1 out nocopy JTF_NUMBER_TABLE
657: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

655: , p7_a0 out nocopy JTF_NUMBER_TABLE
656: , p7_a1 out nocopy JTF_NUMBER_TABLE
657: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
663: )

Line 660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

656: , p7_a1 out nocopy JTF_NUMBER_TABLE
657: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
663: )
664:

Line 661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

657: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
663: )
664:
665: as

Line 662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

658: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
659: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
660: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
661: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
662: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
663: )
664:
665: as
666: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;

Line 717: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300

713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p7_a0 out nocopy JTF_NUMBER_TABLE
716: , p7_a1 out nocopy JTF_NUMBER_TABLE
717: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

714: , x_msg_data out nocopy VARCHAR2
715: , p7_a0 out nocopy JTF_NUMBER_TABLE
716: , p7_a1 out nocopy JTF_NUMBER_TABLE
717: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

Line 719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300

715: , p7_a0 out nocopy JTF_NUMBER_TABLE
716: , p7_a1 out nocopy JTF_NUMBER_TABLE
717: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
723: )

Line 720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300

716: , p7_a1 out nocopy JTF_NUMBER_TABLE
717: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
723: )
724:

Line 721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

717: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
723: )
724:
725: as

Line 722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300

718: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
719: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
720: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
721: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_300
723: )
724:
725: as
726: ddx_agent_acnt_tbl iem_emailaccount_pub.agentacnt_tbl_type;

Line 784: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300

780: , x_msg_count out nocopy NUMBER
781: , x_search_count out nocopy NUMBER
782: , x_msg_data out nocopy VARCHAR2
783: , p15_a0 out nocopy JTF_NUMBER_TABLE
784: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
785: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
786: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
787: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
788: )

Line 785: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300

781: , x_search_count out nocopy NUMBER
782: , x_msg_data out nocopy VARCHAR2
783: , p15_a0 out nocopy JTF_NUMBER_TABLE
784: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
785: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
786: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
787: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
788: )
789:

Line 787: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300

783: , p15_a0 out nocopy JTF_NUMBER_TABLE
784: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
785: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_300
786: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
787: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_300
788: )
789:
790: as
791: ddx_agent_acnt_dtl_data iem_emailaccount_pub.agntacntdetails_tbl_type;

Line 861: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300

857: , p_email_account_id NUMBER
858: , x_return_status out nocopy VARCHAR2
859: , x_msg_count out nocopy NUMBER
860: , x_msg_data out nocopy VARCHAR2
861: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
862: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
863: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
864: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
865: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 864: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300

860: , x_msg_data out nocopy VARCHAR2
861: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_300
862: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
863: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
864: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
865: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
866: , p7_a5 out nocopy JTF_NUMBER_TABLE
867: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
868: , p7_a7 out nocopy JTF_NUMBER_TABLE

Line 867: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300

863: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
864: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
865: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
866: , p7_a5 out nocopy JTF_NUMBER_TABLE
867: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
868: , p7_a7 out nocopy JTF_NUMBER_TABLE
869: , p7_a8 out nocopy JTF_NUMBER_TABLE
870: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
871: )