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.AMV_SEARCH_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 420: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300

416: end if;
417: end if;
418: end rosetta_table_copy_out_p11;
419:
420: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300
421: , a1 JTF_VARCHAR2_TABLE_2000
422: , a2 JTF_VARCHAR2_TABLE_4000
423: , a3 JTF_NUMBER_TABLE
424: , a4 JTF_NUMBER_TABLE

Line 426: , a6 JTF_VARCHAR2_TABLE_300

422: , a2 JTF_VARCHAR2_TABLE_4000
423: , a3 JTF_NUMBER_TABLE
424: , a4 JTF_NUMBER_TABLE
425: , a5 JTF_VARCHAR2_TABLE_100
426: , a6 JTF_VARCHAR2_TABLE_300
427: , a7 JTF_VARCHAR2_TABLE_300
428: , a8 JTF_VARCHAR2_TABLE_300
429: ) as
430: ddindx binary_integer; indx binary_integer;

Line 427: , a7 JTF_VARCHAR2_TABLE_300

423: , a3 JTF_NUMBER_TABLE
424: , a4 JTF_NUMBER_TABLE
425: , a5 JTF_VARCHAR2_TABLE_100
426: , a6 JTF_VARCHAR2_TABLE_300
427: , a7 JTF_VARCHAR2_TABLE_300
428: , a8 JTF_VARCHAR2_TABLE_300
429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin

Line 428: , a8 JTF_VARCHAR2_TABLE_300

424: , a4 JTF_NUMBER_TABLE
425: , a5 JTF_VARCHAR2_TABLE_100
426: , a6 JTF_VARCHAR2_TABLE_300
427: , a7 JTF_VARCHAR2_TABLE_300
428: , a8 JTF_VARCHAR2_TABLE_300
429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin
432: if a0 is not null and a0.count=0 then

Line 459: procedure rosetta_table_copy_out_p13(t amv_search_pvt.amv_searchres_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

455: end loop;
456: end if;
457: end if;
458: end rosetta_table_copy_in_p13;
459: procedure rosetta_table_copy_out_p13(t amv_search_pvt.amv_searchres_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
460: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
461: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
462: , a3 out nocopy JTF_NUMBER_TABLE
463: , a4 out nocopy JTF_NUMBER_TABLE

Line 465: , a6 out nocopy JTF_VARCHAR2_TABLE_300

461: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
462: , a3 out nocopy JTF_NUMBER_TABLE
463: , a4 out nocopy JTF_NUMBER_TABLE
464: , a5 out nocopy JTF_VARCHAR2_TABLE_100
465: , a6 out nocopy JTF_VARCHAR2_TABLE_300
466: , a7 out nocopy JTF_VARCHAR2_TABLE_300
467: , a8 out nocopy JTF_VARCHAR2_TABLE_300
468: ) as
469: ddindx binary_integer; indx binary_integer;

Line 466: , a7 out nocopy JTF_VARCHAR2_TABLE_300

462: , a3 out nocopy JTF_NUMBER_TABLE
463: , a4 out nocopy JTF_NUMBER_TABLE
464: , a5 out nocopy JTF_VARCHAR2_TABLE_100
465: , a6 out nocopy JTF_VARCHAR2_TABLE_300
466: , a7 out nocopy JTF_VARCHAR2_TABLE_300
467: , a8 out nocopy JTF_VARCHAR2_TABLE_300
468: ) as
469: ddindx binary_integer; indx binary_integer;
470: begin

Line 467: , a8 out nocopy JTF_VARCHAR2_TABLE_300

463: , a4 out nocopy JTF_NUMBER_TABLE
464: , a5 out nocopy JTF_VARCHAR2_TABLE_100
465: , a6 out nocopy JTF_VARCHAR2_TABLE_300
466: , a7 out nocopy JTF_VARCHAR2_TABLE_300
467: , a8 out nocopy JTF_VARCHAR2_TABLE_300
468: ) as
469: ddindx binary_integer; indx binary_integer;
470: begin
471: if t is null then

Line 482: a0 := JTF_VARCHAR2_TABLE_300();

478: a6 := null;
479: a7 := null;
480: a8 := null;
481: elsif t.count = 0 then
482: a0 := JTF_VARCHAR2_TABLE_300();
483: a1 := JTF_VARCHAR2_TABLE_2000();
484: a2 := JTF_VARCHAR2_TABLE_4000();
485: a3 := JTF_NUMBER_TABLE();
486: a4 := JTF_NUMBER_TABLE();

Line 488: a6 := JTF_VARCHAR2_TABLE_300();

484: a2 := JTF_VARCHAR2_TABLE_4000();
485: a3 := JTF_NUMBER_TABLE();
486: a4 := JTF_NUMBER_TABLE();
487: a5 := JTF_VARCHAR2_TABLE_100();
488: a6 := JTF_VARCHAR2_TABLE_300();
489: a7 := JTF_VARCHAR2_TABLE_300();
490: a8 := JTF_VARCHAR2_TABLE_300();
491: else
492: a0 := JTF_VARCHAR2_TABLE_300();

Line 489: a7 := JTF_VARCHAR2_TABLE_300();

485: a3 := JTF_NUMBER_TABLE();
486: a4 := JTF_NUMBER_TABLE();
487: a5 := JTF_VARCHAR2_TABLE_100();
488: a6 := JTF_VARCHAR2_TABLE_300();
489: a7 := JTF_VARCHAR2_TABLE_300();
490: a8 := JTF_VARCHAR2_TABLE_300();
491: else
492: a0 := JTF_VARCHAR2_TABLE_300();
493: a1 := JTF_VARCHAR2_TABLE_2000();

Line 490: a8 := JTF_VARCHAR2_TABLE_300();

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

Line 492: a0 := JTF_VARCHAR2_TABLE_300();

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

Line 498: a6 := JTF_VARCHAR2_TABLE_300();

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

Line 499: a7 := JTF_VARCHAR2_TABLE_300();

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

Line 500: a8 := JTF_VARCHAR2_TABLE_300();

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

Line 708: , p19_a0 out nocopy JTF_VARCHAR2_TABLE_300

704: , p_external_contents VARCHAR2
705: , p18_a0 out nocopy NUMBER
706: , p18_a1 out nocopy NUMBER
707: , p18_a2 out nocopy NUMBER
708: , p19_a0 out nocopy JTF_VARCHAR2_TABLE_300
709: , p19_a1 out nocopy JTF_VARCHAR2_TABLE_2000
710: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
711: , p19_a3 out nocopy JTF_NUMBER_TABLE
712: , p19_a4 out nocopy JTF_NUMBER_TABLE

Line 714: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300

710: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
711: , p19_a3 out nocopy JTF_NUMBER_TABLE
712: , p19_a4 out nocopy JTF_NUMBER_TABLE
713: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
714: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
715: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
716: , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300
717: , p17_a0 NUMBER := 0-1962.0724
718: , p17_a1 NUMBER := 0-1962.0724

Line 715: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300

711: , p19_a3 out nocopy JTF_NUMBER_TABLE
712: , p19_a4 out nocopy JTF_NUMBER_TABLE
713: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
714: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
715: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
716: , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300
717: , p17_a0 NUMBER := 0-1962.0724
718: , p17_a1 NUMBER := 0-1962.0724
719: , p17_a2 VARCHAR2 := fnd_api.g_miss_char

Line 716: , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300

712: , p19_a4 out nocopy JTF_NUMBER_TABLE
713: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
714: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
715: , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
716: , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300
717: , p17_a0 NUMBER := 0-1962.0724
718: , p17_a1 NUMBER := 0-1962.0724
719: , p17_a2 VARCHAR2 := fnd_api.g_miss_char
720: )