DBA Data[Home] [Help]

APPS.IEM_EMAILACCOUNT_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 84: , a4 JTF_VARCHAR2_TABLE_100

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
86: , a6 JTF_VARCHAR2_TABLE_100
87: , a7 JTF_VARCHAR2_TABLE_300
88: , a8 JTF_VARCHAR2_TABLE_300

Line 86: , a6 JTF_VARCHAR2_TABLE_100

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
90: , a10 JTF_NUMBER_TABLE

Line 125: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
127: , a6 out nocopy JTF_VARCHAR2_TABLE_100
128: , a7 out nocopy JTF_VARCHAR2_TABLE_300
129: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 127: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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
131: , a10 out nocopy JTF_NUMBER_TABLE

Line 141: a4 := JTF_VARCHAR2_TABLE_100();

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();
143: a6 := JTF_VARCHAR2_TABLE_100();
144: a7 := JTF_VARCHAR2_TABLE_300();
145: a8 := JTF_VARCHAR2_TABLE_300();

Line 143: a6 := JTF_VARCHAR2_TABLE_100();

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();
147: a10 := JTF_NUMBER_TABLE();

Line 154: a4 := JTF_VARCHAR2_TABLE_100();

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();
156: a6 := JTF_VARCHAR2_TABLE_100();
157: a7 := JTF_VARCHAR2_TABLE_300();
158: a8 := JTF_VARCHAR2_TABLE_300();

Line 156: a6 := JTF_VARCHAR2_TABLE_100();

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();
160: a10 := JTF_NUMBER_TABLE();

Line 200: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100

196: end if;
197: end if;
198: end rosetta_table_copy_out_p4;
199:
200: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100
201: , a1 JTF_VARCHAR2_TABLE_100
202: , a2 JTF_VARCHAR2_TABLE_200
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_NUMBER_TABLE

Line 201: , a1 JTF_VARCHAR2_TABLE_100

197: end if;
198: end rosetta_table_copy_out_p4;
199:
200: procedure rosetta_table_copy_in_p6(t out nocopy iem_emailaccount_pub.account_info_table, a0 JTF_VARCHAR2_TABLE_100
201: , a1 JTF_VARCHAR2_TABLE_100
202: , a2 JTF_VARCHAR2_TABLE_200
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_NUMBER_TABLE
205: ) as

Line 227: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100

223: end loop;
224: end if;
225: end if;
226: end rosetta_table_copy_in_p6;
227: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_VARCHAR2_TABLE_200
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_NUMBER_TABLE

Line 228: , a1 out nocopy JTF_VARCHAR2_TABLE_100

224: end if;
225: end if;
226: end rosetta_table_copy_in_p6;
227: procedure rosetta_table_copy_out_p6(t iem_emailaccount_pub.account_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_VARCHAR2_TABLE_200
230: , a3 out nocopy JTF_NUMBER_TABLE
231: , a4 out nocopy JTF_NUMBER_TABLE
232: ) as

Line 236: a0 := JTF_VARCHAR2_TABLE_100();

232: ) as
233: ddindx binary_integer; indx binary_integer;
234: begin
235: if t is null or t.count = 0 then
236: a0 := JTF_VARCHAR2_TABLE_100();
237: a1 := JTF_VARCHAR2_TABLE_100();
238: a2 := JTF_VARCHAR2_TABLE_200();
239: a3 := JTF_NUMBER_TABLE();
240: a4 := JTF_NUMBER_TABLE();

Line 237: a1 := JTF_VARCHAR2_TABLE_100();

233: ddindx binary_integer; indx binary_integer;
234: begin
235: if t is null or t.count = 0 then
236: a0 := JTF_VARCHAR2_TABLE_100();
237: a1 := JTF_VARCHAR2_TABLE_100();
238: a2 := JTF_VARCHAR2_TABLE_200();
239: a3 := JTF_NUMBER_TABLE();
240: a4 := JTF_NUMBER_TABLE();
241: else

Line 242: a0 := JTF_VARCHAR2_TABLE_100();

238: a2 := JTF_VARCHAR2_TABLE_200();
239: a3 := JTF_NUMBER_TABLE();
240: a4 := JTF_NUMBER_TABLE();
241: else
242: a0 := JTF_VARCHAR2_TABLE_100();
243: a1 := JTF_VARCHAR2_TABLE_100();
244: a2 := JTF_VARCHAR2_TABLE_200();
245: a3 := JTF_NUMBER_TABLE();
246: a4 := JTF_NUMBER_TABLE();

Line 243: a1 := JTF_VARCHAR2_TABLE_100();

239: a3 := JTF_NUMBER_TABLE();
240: a4 := JTF_NUMBER_TABLE();
241: else
242: a0 := JTF_VARCHAR2_TABLE_100();
243: a1 := JTF_VARCHAR2_TABLE_100();
244: a2 := JTF_VARCHAR2_TABLE_200();
245: a3 := JTF_NUMBER_TABLE();
246: a4 := JTF_NUMBER_TABLE();
247: if t.count > 0 then

Line 272: , a1 JTF_VARCHAR2_TABLE_100

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
276: , a5 JTF_NUMBER_TABLE

Line 275: , a4 JTF_VARCHAR2_TABLE_100

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
279: , a8 JTF_NUMBER_TABLE

Line 280: , a9 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
282: ddindx binary_integer; indx binary_integer;
283: begin
284: if a0 is not null and a0.count > 0 then

Line 309: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
313: , a5 out nocopy JTF_NUMBER_TABLE

Line 312: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
316: , a8 out nocopy JTF_NUMBER_TABLE

Line 317: , a9 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
319: ddindx binary_integer; indx binary_integer;
320: begin
321: if t is null or t.count = 0 then

Line 323: a1 := JTF_VARCHAR2_TABLE_100();

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();
327: a5 := JTF_NUMBER_TABLE();

Line 326: a4 := JTF_VARCHAR2_TABLE_100();

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();
330: a8 := JTF_NUMBER_TABLE();

Line 331: a9 := 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
333: a0 := JTF_VARCHAR2_TABLE_300();
334: a1 := JTF_VARCHAR2_TABLE_100();
335: a2 := JTF_VARCHAR2_TABLE_200();

Line 334: a1 := JTF_VARCHAR2_TABLE_100();

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();
338: a5 := JTF_NUMBER_TABLE();

Line 337: a4 := JTF_VARCHAR2_TABLE_100();

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();
341: a8 := JTF_NUMBER_TABLE();

Line 342: a9 := 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
344: a0.extend(t.count);
345: a1.extend(t.count);
346: a2.extend(t.count);

Line 380: , a3 JTF_VARCHAR2_TABLE_100

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;
384: begin

Line 407: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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;
411: begin

Line 416: a3 := JTF_VARCHAR2_TABLE_100();

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();
420: a1 := JTF_VARCHAR2_TABLE_300();

Line 422: a3 := JTF_VARCHAR2_TABLE_100();

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);
426: a1.extend(t.count);

Line 600: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 602: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
606: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 786: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100

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:
790: as

Line 862: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
866: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 865: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
869: , p7_a8 out nocopy JTF_NUMBER_TABLE

Line 870: , p7_a9 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: )
872:
873: as
874: ddx_acnt_details_tbl iem_emailaccount_pub.acntdetails_tbl_type;