DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 129: , a9 JTF_VARCHAR2_TABLE_300

125: , a5 JTF_NUMBER_TABLE
126: , a6 JTF_NUMBER_TABLE
127: , a7 JTF_NUMBER_TABLE
128: , a8 JTF_VARCHAR2_TABLE_100
129: , a9 JTF_VARCHAR2_TABLE_300
130: , a10 JTF_VARCHAR2_TABLE_2000
131: , a11 JTF_VARCHAR2_TABLE_2000
132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100

Line 136: , a16 JTF_VARCHAR2_TABLE_300

132: , a12 JTF_VARCHAR2_TABLE_100
133: , a13 JTF_VARCHAR2_TABLE_100
134: , a14 JTF_DATE_TABLE
135: , a15 JTF_DATE_TABLE
136: , a16 JTF_VARCHAR2_TABLE_300
137: , a17 JTF_VARCHAR2_TABLE_2000
138: , a18 JTF_DATE_TABLE
139: , a19 JTF_VARCHAR2_TABLE_100
140: , a20 JTF_NUMBER_TABLE

Line 143: , a23 JTF_VARCHAR2_TABLE_300

139: , a19 JTF_VARCHAR2_TABLE_100
140: , a20 JTF_NUMBER_TABLE
141: , a21 JTF_NUMBER_TABLE
142: , a22 JTF_NUMBER_TABLE
143: , a23 JTF_VARCHAR2_TABLE_300
144: , a24 JTF_VARCHAR2_TABLE_2000
145: , a25 JTF_VARCHAR2_TABLE_2000
146: , a26 JTF_VARCHAR2_TABLE_2000
147: , a27 JTF_VARCHAR2_TABLE_2000

Line 208: , a9 out nocopy JTF_VARCHAR2_TABLE_300

204: , a5 out nocopy JTF_NUMBER_TABLE
205: , a6 out nocopy JTF_NUMBER_TABLE
206: , a7 out nocopy JTF_NUMBER_TABLE
207: , a8 out nocopy JTF_VARCHAR2_TABLE_100
208: , a9 out nocopy JTF_VARCHAR2_TABLE_300
209: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
210: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 215: , a16 out nocopy JTF_VARCHAR2_TABLE_300

211: , a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , a13 out nocopy JTF_VARCHAR2_TABLE_100
213: , a14 out nocopy JTF_DATE_TABLE
214: , a15 out nocopy JTF_DATE_TABLE
215: , a16 out nocopy JTF_VARCHAR2_TABLE_300
216: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
217: , a18 out nocopy JTF_DATE_TABLE
218: , a19 out nocopy JTF_VARCHAR2_TABLE_100
219: , a20 out nocopy JTF_NUMBER_TABLE

Line 222: , a23 out nocopy JTF_VARCHAR2_TABLE_300

218: , a19 out nocopy JTF_VARCHAR2_TABLE_100
219: , a20 out nocopy JTF_NUMBER_TABLE
220: , a21 out nocopy JTF_NUMBER_TABLE
221: , a22 out nocopy JTF_NUMBER_TABLE
222: , a23 out nocopy JTF_VARCHAR2_TABLE_300
223: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
224: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
225: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
226: , a27 out nocopy JTF_VARCHAR2_TABLE_2000

Line 271: a9 := JTF_VARCHAR2_TABLE_300();

267: a5 := JTF_NUMBER_TABLE();
268: a6 := JTF_NUMBER_TABLE();
269: a7 := JTF_NUMBER_TABLE();
270: a8 := JTF_VARCHAR2_TABLE_100();
271: a9 := JTF_VARCHAR2_TABLE_300();
272: a10 := JTF_VARCHAR2_TABLE_2000();
273: a11 := JTF_VARCHAR2_TABLE_2000();
274: a12 := JTF_VARCHAR2_TABLE_100();
275: a13 := JTF_VARCHAR2_TABLE_100();

Line 278: a16 := JTF_VARCHAR2_TABLE_300();

274: a12 := JTF_VARCHAR2_TABLE_100();
275: a13 := JTF_VARCHAR2_TABLE_100();
276: a14 := JTF_DATE_TABLE();
277: a15 := JTF_DATE_TABLE();
278: a16 := JTF_VARCHAR2_TABLE_300();
279: a17 := JTF_VARCHAR2_TABLE_2000();
280: a18 := JTF_DATE_TABLE();
281: a19 := JTF_VARCHAR2_TABLE_100();
282: a20 := JTF_NUMBER_TABLE();

Line 285: a23 := JTF_VARCHAR2_TABLE_300();

281: a19 := JTF_VARCHAR2_TABLE_100();
282: a20 := JTF_NUMBER_TABLE();
283: a21 := JTF_NUMBER_TABLE();
284: a22 := JTF_NUMBER_TABLE();
285: a23 := JTF_VARCHAR2_TABLE_300();
286: a24 := JTF_VARCHAR2_TABLE_2000();
287: a25 := JTF_VARCHAR2_TABLE_2000();
288: a26 := JTF_VARCHAR2_TABLE_2000();
289: a27 := JTF_VARCHAR2_TABLE_2000();

Line 301: a9 := JTF_VARCHAR2_TABLE_300();

297: a5 := JTF_NUMBER_TABLE();
298: a6 := JTF_NUMBER_TABLE();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: a9 := JTF_VARCHAR2_TABLE_300();
302: a10 := JTF_VARCHAR2_TABLE_2000();
303: a11 := JTF_VARCHAR2_TABLE_2000();
304: a12 := JTF_VARCHAR2_TABLE_100();
305: a13 := JTF_VARCHAR2_TABLE_100();

Line 308: a16 := JTF_VARCHAR2_TABLE_300();

304: a12 := JTF_VARCHAR2_TABLE_100();
305: a13 := JTF_VARCHAR2_TABLE_100();
306: a14 := JTF_DATE_TABLE();
307: a15 := JTF_DATE_TABLE();
308: a16 := JTF_VARCHAR2_TABLE_300();
309: a17 := JTF_VARCHAR2_TABLE_2000();
310: a18 := JTF_DATE_TABLE();
311: a19 := JTF_VARCHAR2_TABLE_100();
312: a20 := JTF_NUMBER_TABLE();

Line 315: a23 := JTF_VARCHAR2_TABLE_300();

311: a19 := JTF_VARCHAR2_TABLE_100();
312: a20 := JTF_NUMBER_TABLE();
313: a21 := JTF_NUMBER_TABLE();
314: a22 := JTF_NUMBER_TABLE();
315: a23 := JTF_VARCHAR2_TABLE_300();
316: a24 := JTF_VARCHAR2_TABLE_2000();
317: a25 := JTF_VARCHAR2_TABLE_2000();
318: a26 := JTF_VARCHAR2_TABLE_2000();
319: a27 := JTF_VARCHAR2_TABLE_2000();

Line 394: , a1 JTF_VARCHAR2_TABLE_300

390: end if;
391: end rosetta_table_copy_out_p6;
392:
393: procedure rosetta_table_copy_in_p8(t out nocopy amv_item_pub.amv_nameid_varray_type, a0 JTF_NUMBER_TABLE
394: , a1 JTF_VARCHAR2_TABLE_300
395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin
398: if a0 is not null and a0.count=0 then

Line 419: , a1 out nocopy JTF_VARCHAR2_TABLE_300

415: end if;
416: end if;
417: end rosetta_table_copy_in_p8;
418: procedure rosetta_table_copy_out_p8(t amv_item_pub.amv_nameid_varray_type, a0 out nocopy JTF_NUMBER_TABLE
419: , a1 out nocopy JTF_VARCHAR2_TABLE_300
420: ) as
421: ddindx binary_integer; indx binary_integer;
422: begin
423: if t is null then

Line 428: a1 := JTF_VARCHAR2_TABLE_300();

424: a0 := null;
425: a1 := null;
426: elsif t.count = 0 then
427: a0 := JTF_NUMBER_TABLE();
428: a1 := JTF_VARCHAR2_TABLE_300();
429: else
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_300();
432: if t.count > 0 then

Line 431: a1 := JTF_VARCHAR2_TABLE_300();

427: a0 := JTF_NUMBER_TABLE();
428: a1 := JTF_VARCHAR2_TABLE_300();
429: else
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_300();
432: if t.count > 0 then
433: a0.extend(t.count);
434: a1.extend(t.count);
435: ddindx := t.first;

Line 460: , p10_a1 JTF_VARCHAR2_TABLE_300

456: , p_check_login_user VARCHAR2
457: , p_channel_id_array JTF_NUMBER_TABLE
458: , p_file_array JTF_NUMBER_TABLE
459: , p10_a0 JTF_NUMBER_TABLE
460: , p10_a1 JTF_VARCHAR2_TABLE_300
461: , p_author_array JTF_VARCHAR2_TABLE_4000
462: , p_keyword_array JTF_VARCHAR2_TABLE_4000
463: , x_item_id out nocopy NUMBER
464: , p8_a0 NUMBER := 0-1962.0724

Line 588: , p10_a1 JTF_VARCHAR2_TABLE_300

584: , p_check_login_user VARCHAR2
585: , p_channel_id_array JTF_NUMBER_TABLE
586: , p_file_array JTF_NUMBER_TABLE
587: , p10_a0 JTF_NUMBER_TABLE
588: , p10_a1 JTF_VARCHAR2_TABLE_300
589: , p_author_array JTF_VARCHAR2_TABLE_4000
590: , p_keyword_array JTF_VARCHAR2_TABLE_4000
591: , p8_a0 NUMBER := 0-1962.0724
592: , p8_a1 NUMBER := 0-1962.0724

Line 735: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300

731: , p7_a22 out nocopy NUMBER
732: , p7_a23 out nocopy VARCHAR2
733: , x_file_array out nocopy JTF_NUMBER_TABLE
734: , p9_a0 out nocopy JTF_NUMBER_TABLE
735: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_300
736: , x_author_array out nocopy JTF_VARCHAR2_TABLE_4000
737: , x_keyword_array out nocopy JTF_VARCHAR2_TABLE_4000
738: )
739:

Line 841: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300

837: , p11_a5 out nocopy JTF_NUMBER_TABLE
838: , p11_a6 out nocopy JTF_NUMBER_TABLE
839: , p11_a7 out nocopy JTF_NUMBER_TABLE
840: , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
841: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_300
842: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_2000
843: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_2000
844: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
845: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 848: , p11_a16 out nocopy JTF_VARCHAR2_TABLE_300

844: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
845: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
846: , p11_a14 out nocopy JTF_DATE_TABLE
847: , p11_a15 out nocopy JTF_DATE_TABLE
848: , p11_a16 out nocopy JTF_VARCHAR2_TABLE_300
849: , p11_a17 out nocopy JTF_VARCHAR2_TABLE_2000
850: , p11_a18 out nocopy JTF_DATE_TABLE
851: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
852: , p11_a20 out nocopy JTF_NUMBER_TABLE

Line 855: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300

851: , p11_a19 out nocopy JTF_VARCHAR2_TABLE_100
852: , p11_a20 out nocopy JTF_NUMBER_TABLE
853: , p11_a21 out nocopy JTF_NUMBER_TABLE
854: , p11_a22 out nocopy JTF_NUMBER_TABLE
855: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_300
856: , p11_a24 out nocopy JTF_VARCHAR2_TABLE_2000
857: , p11_a25 out nocopy JTF_VARCHAR2_TABLE_2000
858: , p11_a26 out nocopy JTF_VARCHAR2_TABLE_2000
859: , p11_a27 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1597: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300

1593: , p7_a5 out nocopy JTF_NUMBER_TABLE
1594: , p7_a6 out nocopy JTF_NUMBER_TABLE
1595: , p7_a7 out nocopy JTF_NUMBER_TABLE
1596: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1597: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
1598: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_2000
1599: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_2000
1600: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1604: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300

1600: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
1601: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
1602: , p7_a14 out nocopy JTF_DATE_TABLE
1603: , p7_a15 out nocopy JTF_DATE_TABLE
1604: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
1605: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
1606: , p7_a18 out nocopy JTF_DATE_TABLE
1607: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p7_a20 out nocopy JTF_NUMBER_TABLE

Line 1611: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300

1607: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
1608: , p7_a20 out nocopy JTF_NUMBER_TABLE
1609: , p7_a21 out nocopy JTF_NUMBER_TABLE
1610: , p7_a22 out nocopy JTF_NUMBER_TABLE
1611: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
1612: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_2000
1613: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1614: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
1615: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1692: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300

1688: , p_check_login_user VARCHAR2
1689: , p_item_id NUMBER
1690: , p_match_type VARCHAR2
1691: , p8_a0 out nocopy JTF_NUMBER_TABLE
1692: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_300
1693: )
1694:
1695: as
1696: ddx_channel_array amv_item_pub.amv_nameid_varray_type;