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 AMV_SEARCH_PVT

Line 1: package body amv_search_pvt_w as

1: package body amv_search_pvt_w as
2: /* $Header: amvwserb.pls 120.2 2005/06/30 08:43 appldev ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

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 28: t := amv_search_pvt.amv_char_varray_type();

24: begin
25: if a0 is null then
26: t := null;
27: elsif a0.count = 0 then
28: t := amv_search_pvt.amv_char_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_search_pvt.amv_char_varray_type();
32: t.extend(a0.count);

Line 31: t := amv_search_pvt.amv_char_varray_type();

27: elsif a0.count = 0 then
28: t := amv_search_pvt.amv_char_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_search_pvt.amv_char_varray_type();
32: t.extend(a0.count);
33: indx := a0.first;
34: ddindx := 1;
35: while true loop

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 71: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

67: end if;
68: end if;
69: end rosetta_table_copy_out_p0;
70:
71: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if a0 is null then
75: t := null;

Line 77: t := amv_search_pvt.amv_number_varray_type();

73: begin
74: if a0 is null then
75: t := null;
76: elsif a0.count = 0 then
77: t := amv_search_pvt.amv_number_varray_type();
78: else
79: if a0.count > 0 then
80: t := amv_search_pvt.amv_number_varray_type();
81: t.extend(a0.count);

Line 80: t := amv_search_pvt.amv_number_varray_type();

76: elsif a0.count = 0 then
77: t := amv_search_pvt.amv_number_varray_type();
78: else
79: if a0.count > 0 then
80: t := amv_search_pvt.amv_number_varray_type();
81: t.extend(a0.count);
82: indx := a0.first;
83: ddindx := 1;
84: while true loop

Line 95: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p1;
95: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null then
99: a0 := null;

Line 120: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_out_p1;
119:
120: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
121: , a1 JTF_VARCHAR2_TABLE_100
122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin

Line 126: t := amv_search_pvt.amv_area_varray_type();

122: ) as
123: ddindx binary_integer; indx binary_integer;
124: begin
125: if a0 is not null and a0.count=0 then
126: t := amv_search_pvt.amv_area_varray_type();
127: elsif a0 is not null and a0.count > 0 then
128: if a0.count > 0 then
129: t := amv_search_pvt.amv_area_varray_type();
130: t.extend(a0.count);

Line 129: t := amv_search_pvt.amv_area_varray_type();

125: if a0 is not null and a0.count=0 then
126: t := amv_search_pvt.amv_area_varray_type();
127: elsif a0 is not null and a0.count > 0 then
128: if a0.count > 0 then
129: t := amv_search_pvt.amv_area_varray_type();
130: t.extend(a0.count);
131: indx := a0.first;
132: ddindx := 1;
133: while true loop

Line 145: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE

141: end loop;
142: end if;
143: end if;
144: end rosetta_table_copy_in_p5;
145: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin

Line 177: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE

173: end if;
174: end if;
175: end rosetta_table_copy_out_p5;
176:
177: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_VARCHAR2_TABLE_100
179: , a2 JTF_VARCHAR2_TABLE_100
180: , a3 JTF_VARCHAR2_TABLE_100
181: , a4 JTF_NUMBER_TABLE

Line 186: t := amv_search_pvt.amv_searchrep_varray_type();

182: ) as
183: ddindx binary_integer; indx binary_integer;
184: begin
185: if a0 is not null and a0.count=0 then
186: t := amv_search_pvt.amv_searchrep_varray_type();
187: elsif a0 is not null and a0.count > 0 then
188: if a0.count > 0 then
189: t := amv_search_pvt.amv_searchrep_varray_type();
190: t.extend(a0.count);

Line 189: t := amv_search_pvt.amv_searchrep_varray_type();

185: if a0 is not null and a0.count=0 then
186: t := amv_search_pvt.amv_searchrep_varray_type();
187: elsif a0 is not null and a0.count > 0 then
188: if a0.count > 0 then
189: t := amv_search_pvt.amv_searchrep_varray_type();
190: t.extend(a0.count);
191: indx := a0.first;
192: ddindx := 1;
193: while true loop

Line 208: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE

204: end loop;
205: end if;
206: end if;
207: end rosetta_table_copy_in_p7;
208: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_100
211: , a3 out nocopy JTF_VARCHAR2_TABLE_100
212: , a4 out nocopy JTF_NUMBER_TABLE

Line 258: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE

254: end if;
255: end if;
256: end rosetta_table_copy_out_p7;
257:
258: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
259: , a1 JTF_VARCHAR2_TABLE_100
260: , a2 JTF_VARCHAR2_TABLE_100
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100

Line 270: t := amv_search_pvt.amv_searchara_varray_type();

266: ) as
267: ddindx binary_integer; indx binary_integer;
268: begin
269: if a0 is not null and a0.count=0 then
270: t := amv_search_pvt.amv_searchara_varray_type();
271: elsif a0 is not null and a0.count > 0 then
272: if a0.count > 0 then
273: t := amv_search_pvt.amv_searchara_varray_type();
274: t.extend(a0.count);

Line 273: t := amv_search_pvt.amv_searchara_varray_type();

269: if a0 is not null and a0.count=0 then
270: t := amv_search_pvt.amv_searchara_varray_type();
271: elsif a0 is not null and a0.count > 0 then
272: if a0.count > 0 then
273: t := amv_search_pvt.amv_searchara_varray_type();
274: t.extend(a0.count);
275: indx := a0.first;
276: ddindx := 1;
277: while true loop

Line 295: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE

291: end loop;
292: end if;
293: end if;
294: end rosetta_table_copy_in_p9;
295: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_VARCHAR2_TABLE_100
297: , a2 out nocopy JTF_VARCHAR2_TABLE_100
298: , a3 out nocopy JTF_NUMBER_TABLE
299: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 363: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100

359: end if;
360: end if;
361: end rosetta_table_copy_out_p9;
362:
363: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100
364: , a1 JTF_VARCHAR2_TABLE_400
365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin

Line 369: t := amv_search_pvt.amv_searchpar_varray_type();

365: ) as
366: ddindx binary_integer; indx binary_integer;
367: begin
368: if a0 is not null and a0.count=0 then
369: t := amv_search_pvt.amv_searchpar_varray_type();
370: elsif a0 is not null and a0.count > 0 then
371: if a0.count > 0 then
372: t := amv_search_pvt.amv_searchpar_varray_type();
373: t.extend(a0.count);

Line 372: t := amv_search_pvt.amv_searchpar_varray_type();

368: if a0 is not null and a0.count=0 then
369: t := amv_search_pvt.amv_searchpar_varray_type();
370: elsif a0 is not null and a0.count > 0 then
371: if a0.count > 0 then
372: t := amv_search_pvt.amv_searchpar_varray_type();
373: t.extend(a0.count);
374: indx := a0.first;
375: ddindx := 1;
376: while true loop

Line 388: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

384: end loop;
385: end if;
386: end if;
387: end rosetta_table_copy_in_p11;
388: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
389: , a1 out nocopy JTF_VARCHAR2_TABLE_400
390: ) as
391: ddindx binary_integer; indx binary_integer;
392: begin

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 433: t := amv_search_pvt.amv_searchres_varray_type();

429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin
432: if a0 is not null and a0.count=0 then
433: t := amv_search_pvt.amv_searchres_varray_type();
434: elsif a0 is not null and a0.count > 0 then
435: if a0.count > 0 then
436: t := amv_search_pvt.amv_searchres_varray_type();
437: t.extend(a0.count);

Line 436: t := amv_search_pvt.amv_searchres_varray_type();

432: if a0 is not null and a0.count=0 then
433: t := amv_search_pvt.amv_searchres_varray_type();
434: elsif a0 is not null and a0.count > 0 then
435: if a0.count > 0 then
436: t := amv_search_pvt.amv_searchres_varray_type();
437: t.extend(a0.count);
438: indx := a0.first;
439: ddindx := 1;
440: while true loop

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 553: ddx_searchrep_array amv_search_pvt.amv_searchrep_varray_type;

549: , p12_a4 out nocopy JTF_NUMBER_TABLE
550: )
551:
552: as
553: ddx_searchrep_array amv_search_pvt.amv_searchrep_varray_type;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any

Line 572: amv_search_pvt.find_repositories(p_api_version,

568:
569:
570:
571: -- here's the delegated call to the old PL/SQL routine
572: amv_search_pvt.find_repositories(p_api_version,
573: p_init_msg_list,
574: p_validation_level,
575: x_return_status,
576: x_msg_count,

Line 599: amv_search_pvt_w.rosetta_table_copy_out_p7(ddx_searchrep_array, p12_a0

595:
596:
597:
598:
599: amv_search_pvt_w.rosetta_table_copy_out_p7(ddx_searchrep_array, p12_a0
600: , p12_a1
601: , p12_a2
602: , p12_a3
603: , p12_a4

Line 633: ddp_searcharea_obj amv_search_pvt.amv_searchara_obj_type;

629: , p7_a7 NUMBER := 0-1962.0724
630: )
631:
632: as
633: ddp_searcharea_obj amv_search_pvt.amv_searchara_obj_type;
634: ddx_searcharea_array amv_search_pvt.amv_searchara_varray_type;
635: ddindx binary_integer; indx binary_integer;
636: begin
637:

Line 634: ddx_searcharea_array amv_search_pvt.amv_searchara_varray_type;

630: )
631:
632: as
633: ddp_searcharea_obj amv_search_pvt.amv_searchara_obj_type;
634: ddx_searcharea_array amv_search_pvt.amv_searchara_varray_type;
635: ddindx binary_integer; indx binary_integer;
636: begin
637:
638: -- copy data to the local IN or IN-OUT args, if any

Line 657: amv_search_pvt.find_repository_areas(p_api_version,

653: ddp_searcharea_obj.object_version_number := rosetta_g_miss_num_map(p7_a7);
654:
655:
656: -- here's the delegated call to the old PL/SQL routine
657: amv_search_pvt.find_repository_areas(p_api_version,
658: p_init_msg_list,
659: p_validation_level,
660: x_return_status,
661: x_msg_count,

Line 676: amv_search_pvt_w.rosetta_table_copy_out_p9(ddx_searcharea_array, p8_a0

672:
673:
674:
675:
676: amv_search_pvt_w.rosetta_table_copy_out_p9(ddx_searcharea_array, p8_a0
677: , p8_a1
678: , p8_a2
679: , p8_a3
680: , p8_a4

Line 723: ddp_area_array amv_search_pvt.amv_char_varray_type;

719: , p17_a2 VARCHAR2 := fnd_api.g_miss_char
720: )
721:
722: as
723: ddp_area_array amv_search_pvt.amv_char_varray_type;
724: ddp_content_array amv_search_pvt.amv_char_varray_type;
725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;

Line 724: ddp_content_array amv_search_pvt.amv_char_varray_type;

720: )
721:
722: as
723: ddp_area_array amv_search_pvt.amv_char_varray_type;
724: ddp_content_array amv_search_pvt.amv_char_varray_type;
725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;
728: ddx_return_obj amv_search_pvt.amv_return_obj_type;

Line 725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;

721:
722: as
723: ddp_area_array amv_search_pvt.amv_char_varray_type;
724: ddp_content_array amv_search_pvt.amv_char_varray_type;
725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;
728: ddx_return_obj amv_search_pvt.amv_return_obj_type;
729: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;

Line 726: ddp_category_id amv_search_pvt.amv_number_varray_type;

722: as
723: ddp_area_array amv_search_pvt.amv_char_varray_type;
724: ddp_content_array amv_search_pvt.amv_char_varray_type;
725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;
728: ddx_return_obj amv_search_pvt.amv_return_obj_type;
729: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
730: ddindx binary_integer; indx binary_integer;

Line 727: ddp_request_obj amv_search_pvt.amv_request_obj_type;

723: ddp_area_array amv_search_pvt.amv_char_varray_type;
724: ddp_content_array amv_search_pvt.amv_char_varray_type;
725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;
728: ddx_return_obj amv_search_pvt.amv_return_obj_type;
729: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
730: ddindx binary_integer; indx binary_integer;
731: begin

Line 728: ddx_return_obj amv_search_pvt.amv_return_obj_type;

724: ddp_content_array amv_search_pvt.amv_char_varray_type;
725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;
728: ddx_return_obj amv_search_pvt.amv_return_obj_type;
729: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
730: ddindx binary_integer; indx binary_integer;
731: begin
732:

Line 729: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;

725: ddp_param_array amv_search_pvt.amv_searchpar_varray_type;
726: ddp_category_id amv_search_pvt.amv_number_varray_type;
727: ddp_request_obj amv_search_pvt.amv_request_obj_type;
728: ddx_return_obj amv_search_pvt.amv_return_obj_type;
729: ddx_searchres_array amv_search_pvt.amv_searchres_varray_type;
730: ddindx binary_integer; indx binary_integer;
731: begin
732:
733: -- copy data to the local IN or IN-OUT args, if any

Line 742: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);

738:
739:
740:
741:
742: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);
743:
744: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);
745:
746: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0

Line 744: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);

740:
741:
742: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);
743:
744: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);
745:
746: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0
747: , p10_a1
748: );

Line 746: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0

742: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_area_array, p_area_array);
743:
744: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_content_array, p_content_array);
745:
746: amv_search_pvt_w.rosetta_table_copy_in_p11(ddp_param_array, p10_a0
747: , p10_a1
748: );
749:
750:

Line 753: amv_search_pvt_w.rosetta_table_copy_in_p1(ddp_category_id, p_category_id);

749:
750:
751:
752:
753: amv_search_pvt_w.rosetta_table_copy_in_p1(ddp_category_id, p_category_id);
754:
755:
756:
757: ddp_request_obj.records_requested := rosetta_g_miss_num_map(p17_a0);

Line 764: amv_search_pvt.content_search(p_api_version,

760:
761:
762:
763: -- here's the delegated call to the old PL/SQL routine
764: amv_search_pvt.content_search(p_api_version,
765: p_init_msg_list,
766: p_validation_level,
767: x_return_status,
768: x_msg_count,

Line 808: amv_search_pvt_w.rosetta_table_copy_out_p13(ddx_searchres_array, p19_a0

804: p18_a0 := rosetta_g_miss_num_map(ddx_return_obj.returned_record_count);
805: p18_a1 := rosetta_g_miss_num_map(ddx_return_obj.next_record_position);
806: p18_a2 := rosetta_g_miss_num_map(ddx_return_obj.total_record_count);
807:
808: amv_search_pvt_w.rosetta_table_copy_out_p13(ddx_searchres_array, p19_a0
809: , p19_a1
810: , p19_a2
811: , p19_a3
812: , p19_a4

Line 828: ddp_optional_array amv_search_pvt.amv_char_varray_type;

824: , x_imt_string out nocopy VARCHAR2
825: )
826:
827: as
828: ddp_optional_array amv_search_pvt.amv_char_varray_type;
829: ddp_required_array amv_search_pvt.amv_char_varray_type;
830: ddp_excluded_array amv_search_pvt.amv_char_varray_type;
831: ddindx binary_integer; indx binary_integer;
832: begin

Line 829: ddp_required_array amv_search_pvt.amv_char_varray_type;

825: )
826:
827: as
828: ddp_optional_array amv_search_pvt.amv_char_varray_type;
829: ddp_required_array amv_search_pvt.amv_char_varray_type;
830: ddp_excluded_array amv_search_pvt.amv_char_varray_type;
831: ddindx binary_integer; indx binary_integer;
832: begin
833:

Line 830: ddp_excluded_array amv_search_pvt.amv_char_varray_type;

826:
827: as
828: ddp_optional_array amv_search_pvt.amv_char_varray_type;
829: ddp_required_array amv_search_pvt.amv_char_varray_type;
830: ddp_excluded_array amv_search_pvt.amv_char_varray_type;
831: ddindx binary_integer; indx binary_integer;
832: begin
833:
834: -- copy data to the local IN or IN-OUT args, if any

Line 835: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_optional_array, p_optional_array);

831: ddindx binary_integer; indx binary_integer;
832: begin
833:
834: -- copy data to the local IN or IN-OUT args, if any
835: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_optional_array, p_optional_array);
836:
837: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_required_array, p_required_array);
838:
839: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_excluded_array, p_excluded_array);

Line 837: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_required_array, p_required_array);

833:
834: -- copy data to the local IN or IN-OUT args, if any
835: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_optional_array, p_optional_array);
836:
837: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_required_array, p_required_array);
838:
839: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_excluded_array, p_excluded_array);
840:
841:

Line 839: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_excluded_array, p_excluded_array);

835: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_optional_array, p_optional_array);
836:
837: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_required_array, p_required_array);
838:
839: amv_search_pvt_w.rosetta_table_copy_in_p0(ddp_excluded_array, p_excluded_array);
840:
841:
842:
843: -- here's the delegated call to the old PL/SQL routine

Line 844: amv_search_pvt.build_imt_string(ddp_optional_array,

840:
841:
842:
843: -- here's the delegated call to the old PL/SQL routine
844: amv_search_pvt.build_imt_string(ddp_optional_array,
845: ddp_required_array,
846: ddp_excluded_array,
847: x_exc_flag,
848: x_imt_string);

Line 857: end amv_search_pvt_w;

853:
854:
855: end;
856:
857: end amv_search_pvt_w;