DBA Data[Home] [Help]

APPS.AMV_SEARCH_PVT_W dependencies on JTF_VARCHAR2_TABLE_4000

Line 22: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 46: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p0;
46: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 52: a0 := JTF_VARCHAR2_TABLE_4000();

48: begin
49: if t is null then
50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_4000();
53: else
54: a0 := JTF_VARCHAR2_TABLE_4000();
55: if t.count > 0 then
56: a0.extend(t.count);

Line 54: a0 := JTF_VARCHAR2_TABLE_4000();

50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_4000();
53: else
54: a0 := JTF_VARCHAR2_TABLE_4000();
55: if t.count > 0 then
56: a0.extend(t.count);
57: ddindx := t.first;
58: indx := 1;

Line 422: , a2 JTF_VARCHAR2_TABLE_4000

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
425: , a5 JTF_VARCHAR2_TABLE_100
426: , a6 JTF_VARCHAR2_TABLE_300

Line 461: , a2 out nocopy JTF_VARCHAR2_TABLE_4000

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
464: , a5 out nocopy JTF_VARCHAR2_TABLE_100
465: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 484: a2 := JTF_VARCHAR2_TABLE_4000();

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();
487: a5 := JTF_VARCHAR2_TABLE_100();
488: a6 := JTF_VARCHAR2_TABLE_300();

Line 494: a2 := JTF_VARCHAR2_TABLE_4000();

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();
497: a5 := JTF_VARCHAR2_TABLE_100();
498: a6 := JTF_VARCHAR2_TABLE_300();

Line 695: , p_area_array JTF_VARCHAR2_TABLE_4000

691: , x_msg_count out nocopy NUMBER
692: , x_msg_data out nocopy VARCHAR2
693: , p_check_login_user VARCHAR2
694: , p_application_id NUMBER
695: , p_area_array JTF_VARCHAR2_TABLE_4000
696: , p_content_array JTF_VARCHAR2_TABLE_4000
697: , p10_a0 JTF_VARCHAR2_TABLE_100
698: , p10_a1 JTF_VARCHAR2_TABLE_400
699: , p_imt_string VARCHAR2

Line 696: , p_content_array JTF_VARCHAR2_TABLE_4000

692: , x_msg_data out nocopy VARCHAR2
693: , p_check_login_user VARCHAR2
694: , p_application_id NUMBER
695: , p_area_array JTF_VARCHAR2_TABLE_4000
696: , p_content_array JTF_VARCHAR2_TABLE_4000
697: , p10_a0 JTF_VARCHAR2_TABLE_100
698: , p10_a1 JTF_VARCHAR2_TABLE_400
699: , p_imt_string VARCHAR2
700: , p_days NUMBER

Line 710: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000

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
713: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
714: , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 820: procedure build_imt_string(p_optional_array JTF_VARCHAR2_TABLE_4000

816: , p19_a8
817: );
818: end;
819:
820: procedure build_imt_string(p_optional_array JTF_VARCHAR2_TABLE_4000
821: , p_required_array JTF_VARCHAR2_TABLE_4000
822: , p_excluded_array JTF_VARCHAR2_TABLE_4000
823: , x_exc_flag out nocopy VARCHAR2
824: , x_imt_string out nocopy VARCHAR2

Line 821: , p_required_array JTF_VARCHAR2_TABLE_4000

817: );
818: end;
819:
820: procedure build_imt_string(p_optional_array JTF_VARCHAR2_TABLE_4000
821: , p_required_array JTF_VARCHAR2_TABLE_4000
822: , p_excluded_array JTF_VARCHAR2_TABLE_4000
823: , x_exc_flag out nocopy VARCHAR2
824: , x_imt_string out nocopy VARCHAR2
825: )

Line 822: , p_excluded_array JTF_VARCHAR2_TABLE_4000

818: end;
819:
820: procedure build_imt_string(p_optional_array JTF_VARCHAR2_TABLE_4000
821: , p_required_array JTF_VARCHAR2_TABLE_4000
822: , p_excluded_array JTF_VARCHAR2_TABLE_4000
823: , x_exc_flag out nocopy VARCHAR2
824: , x_imt_string out nocopy VARCHAR2
825: )
826: