DBA Data[Home] [Help]

APPS.IEM_MAILITEM_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 229: , a8 JTF_VARCHAR2_TABLE_300

225: , a4 JTF_NUMBER_TABLE
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_300
230: , a9 JTF_VARCHAR2_TABLE_100
231: , a10 JTF_VARCHAR2_TABLE_100
232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100

Line 236: , a15 JTF_VARCHAR2_TABLE_300

232: , a11 JTF_VARCHAR2_TABLE_100
233: , a12 JTF_VARCHAR2_TABLE_100
234: , a13 JTF_NUMBER_TABLE
235: , a14 JTF_VARCHAR2_TABLE_100
236: , a15 JTF_VARCHAR2_TABLE_300
237: ) as
238: ddindx binary_integer; indx binary_integer;
239: begin
240: if a0 is not null and a0.count > 0 then

Line 278: , a8 out nocopy JTF_VARCHAR2_TABLE_300

274: , a4 out nocopy JTF_NUMBER_TABLE
275: , a5 out nocopy JTF_NUMBER_TABLE
276: , a6 out nocopy JTF_VARCHAR2_TABLE_100
277: , a7 out nocopy JTF_VARCHAR2_TABLE_200
278: , a8 out nocopy JTF_VARCHAR2_TABLE_300
279: , a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , a10 out nocopy JTF_VARCHAR2_TABLE_100
281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 285: , a15 out nocopy JTF_VARCHAR2_TABLE_300

281: , a11 out nocopy JTF_VARCHAR2_TABLE_100
282: , a12 out nocopy JTF_VARCHAR2_TABLE_100
283: , a13 out nocopy JTF_NUMBER_TABLE
284: , a14 out nocopy JTF_VARCHAR2_TABLE_100
285: , a15 out nocopy JTF_VARCHAR2_TABLE_300
286: ) as
287: ddindx binary_integer; indx binary_integer;
288: begin
289: if t is null or t.count = 0 then

Line 298: a8 := JTF_VARCHAR2_TABLE_300();

294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_NUMBER_TABLE();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_200();
298: a8 := JTF_VARCHAR2_TABLE_300();
299: a9 := JTF_VARCHAR2_TABLE_100();
300: a10 := JTF_VARCHAR2_TABLE_100();
301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();

Line 305: a15 := JTF_VARCHAR2_TABLE_300();

301: a11 := JTF_VARCHAR2_TABLE_100();
302: a12 := JTF_VARCHAR2_TABLE_100();
303: a13 := JTF_NUMBER_TABLE();
304: a14 := JTF_VARCHAR2_TABLE_100();
305: a15 := JTF_VARCHAR2_TABLE_300();
306: else
307: a0 := JTF_NUMBER_TABLE();
308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_VARCHAR2_TABLE_100();

Line 315: a8 := JTF_VARCHAR2_TABLE_300();

311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_NUMBER_TABLE();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_200();
315: a8 := JTF_VARCHAR2_TABLE_300();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: a10 := JTF_VARCHAR2_TABLE_100();
318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();

Line 322: a15 := JTF_VARCHAR2_TABLE_300();

318: a11 := JTF_VARCHAR2_TABLE_100();
319: a12 := JTF_VARCHAR2_TABLE_100();
320: a13 := JTF_NUMBER_TABLE();
321: a14 := JTF_VARCHAR2_TABLE_100();
322: a15 := JTF_VARCHAR2_TABLE_300();
323: if t.count > 0 then
324: a0.extend(t.count);
325: a1.extend(t.count);
326: a2.extend(t.count);

Line 370: , a1 JTF_VARCHAR2_TABLE_300

366: end if;
367: end rosetta_table_copy_out_p6;
368:
369: procedure rosetta_table_copy_in_p8(t out nocopy iem_mailitem_pub.keyvals_tbl_type, a0 JTF_VARCHAR2_TABLE_100
370: , a1 JTF_VARCHAR2_TABLE_300
371: , a2 JTF_VARCHAR2_TABLE_100
372: ) as
373: ddindx binary_integer; indx binary_integer;
374: begin

Line 393: , a1 out nocopy JTF_VARCHAR2_TABLE_300

389: end if;
390: end if;
391: end rosetta_table_copy_in_p8;
392: procedure rosetta_table_copy_out_p8(t iem_mailitem_pub.keyvals_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
393: , a1 out nocopy JTF_VARCHAR2_TABLE_300
394: , a2 out nocopy JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin

Line 400: a1 := JTF_VARCHAR2_TABLE_300();

396: ddindx binary_integer; indx binary_integer;
397: begin
398: if t is null or t.count = 0 then
399: a0 := JTF_VARCHAR2_TABLE_100();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_VARCHAR2_TABLE_100();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_300();

Line 404: a1 := JTF_VARCHAR2_TABLE_300();

400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_VARCHAR2_TABLE_100();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_300();
405: a2 := JTF_VARCHAR2_TABLE_100();
406: if t.count > 0 then
407: a0.extend(t.count);
408: a1.extend(t.count);

Line 858: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300

854: , p7_a41 out nocopy VARCHAR2
855: , p7_a42 out nocopy VARCHAR2
856: , p7_a43 out nocopy NUMBER
857: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
858: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
859: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
860: , x_encrypted_id out nocopy VARCHAR2
861: , x_return_status out nocopy VARCHAR2
862: , x_msg_count out nocopy NUMBER

Line 1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300

1426: , p10_a4 out nocopy JTF_NUMBER_TABLE
1427: , p10_a5 out nocopy JTF_NUMBER_TABLE
1428: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1429: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
1430: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
1431: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
1432: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 1437: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300

1433: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1434: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1435: , p10_a13 out nocopy JTF_NUMBER_TABLE
1436: , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1437: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_300
1438: , x_return_status out nocopy VARCHAR2
1439: , x_msg_count out nocopy NUMBER
1440: , x_msg_data out nocopy VARCHAR2
1441: )

Line 1564: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300

1560: , p7_a41 out nocopy VARCHAR2
1561: , p7_a42 out nocopy VARCHAR2
1562: , p7_a43 out nocopy NUMBER
1563: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1565: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1566: , x_encrypted_id out nocopy VARCHAR2
1567: , x_return_status out nocopy VARCHAR2
1568: , x_msg_count out nocopy NUMBER