DBA Data[Home] [Help]

APPS.AMV_SEARCH_PVT_W dependencies on AMV_SEARCH_PVT

Line 1: package amv_search_pvt_w AUTHID CURRENT_USER as

1: package amv_search_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amvwsers.pls 120.2 2005/06/30 08:43 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);

1: package amv_search_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amvwsers.pls 120.2 2005/06/30 08:43 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);

1: package amv_search_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amvwsers.pls 120.2 2005/06/30 08:43 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:

Line 6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

2: /* $Header: amvwsers.pls 120.2 2005/06/30 08:43 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100

Line 7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

3: procedure rosetta_table_copy_in_p0(t out nocopy amv_search_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p0(t amv_search_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: );

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

5:
6: procedure rosetta_table_copy_in_p1(t out nocopy amv_search_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p1(t amv_search_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

8:
9: procedure rosetta_table_copy_in_p5(t out nocopy amv_search_pvt.amv_area_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE

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

12: procedure rosetta_table_copy_out_p5(t amv_search_pvt.amv_area_varray_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p7(t out nocopy amv_search_pvt.amv_searchrep_varray_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

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

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: );
22: procedure rosetta_table_copy_out_p7(t amv_search_pvt.amv_searchrep_varray_type, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: , a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE

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

25: , a3 out nocopy JTF_VARCHAR2_TABLE_100
26: , a4 out nocopy JTF_NUMBER_TABLE
27: );
28:
29: procedure rosetta_table_copy_in_p9(t out nocopy amv_search_pvt.amv_searchara_varray_type, a0 JTF_NUMBER_TABLE
30: , a1 JTF_VARCHAR2_TABLE_100
31: , a2 JTF_VARCHAR2_TABLE_100
32: , a3 JTF_NUMBER_TABLE
33: , a4 JTF_VARCHAR2_TABLE_100

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

34: , a5 JTF_VARCHAR2_TABLE_100
35: , a6 JTF_VARCHAR2_TABLE_100
36: , a7 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p9(t amv_search_pvt.amv_searchara_varray_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: );
47:
48: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100
49: , a1 JTF_VARCHAR2_TABLE_400
50: );
51: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_400

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

47:
48: procedure rosetta_table_copy_in_p11(t out nocopy amv_search_pvt.amv_searchpar_varray_type, a0 JTF_VARCHAR2_TABLE_100
49: , a1 JTF_VARCHAR2_TABLE_400
50: );
51: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_400
53: );
54:
55: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300

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

51: procedure rosetta_table_copy_out_p11(t amv_search_pvt.amv_searchpar_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_400
53: );
54:
55: procedure rosetta_table_copy_in_p13(t out nocopy amv_search_pvt.amv_searchres_varray_type, a0 JTF_VARCHAR2_TABLE_300
56: , a1 JTF_VARCHAR2_TABLE_2000
57: , a2 JTF_VARCHAR2_TABLE_4000
58: , a3 JTF_NUMBER_TABLE
59: , a4 JTF_NUMBER_TABLE

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

61: , a6 JTF_VARCHAR2_TABLE_300
62: , a7 JTF_VARCHAR2_TABLE_300
63: , a8 JTF_VARCHAR2_TABLE_300
64: );
65: procedure rosetta_table_copy_out_p13(t amv_search_pvt.amv_searchres_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
66: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a3 out nocopy JTF_NUMBER_TABLE
69: , a4 out nocopy JTF_NUMBER_TABLE

Line 158: end amv_search_pvt_w;

154: , p_excluded_array JTF_VARCHAR2_TABLE_4000
155: , x_exc_flag out nocopy VARCHAR2
156: , x_imt_string out nocopy VARCHAR2
157: );
158: end amv_search_pvt_w;