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.
PACKAGE: APPS.AMV_SEARCH_PVT_W

Source


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 
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
17     , a1 JTF_VARCHAR2_TABLE_100
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
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
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
43     , a5 out nocopy 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
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
60     , a5 JTF_VARCHAR2_TABLE_100
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
70     , a5 out nocopy JTF_VARCHAR2_TABLE_100
71     , a6 out nocopy JTF_VARCHAR2_TABLE_300
72     , a7 out nocopy JTF_VARCHAR2_TABLE_300
73     , a8 out nocopy JTF_VARCHAR2_TABLE_300
74     );
75 
76   procedure find_repositories(p_api_version  NUMBER
77     , p_init_msg_list  VARCHAR2
78     , p_validation_level  NUMBER
79     , x_return_status out nocopy  VARCHAR2
80     , x_msg_count out nocopy  NUMBER
81     , x_msg_data out nocopy  VARCHAR2
82     , p_check_login_user  VARCHAR2
83     , p_object_version_number  NUMBER
84     , p_repository_id  NUMBER
85     , p_repository_code  VARCHAR2
86     , p_repository_name  VARCHAR2
87     , p_status  VARCHAR2
88     , p12_a0 out nocopy JTF_NUMBER_TABLE
89     , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
90     , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
91     , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
92     , p12_a4 out nocopy JTF_NUMBER_TABLE
93   );
94   procedure find_repository_areas(p_api_version  NUMBER
95     , p_init_msg_list  VARCHAR2
96     , p_validation_level  NUMBER
97     , x_return_status out nocopy  VARCHAR2
98     , x_msg_count out nocopy  NUMBER
99     , x_msg_data out nocopy  VARCHAR2
100     , p_check_login_user  VARCHAR2
101     , p8_a0 out nocopy JTF_NUMBER_TABLE
102     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
103     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
104     , p8_a3 out nocopy JTF_NUMBER_TABLE
105     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
106     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
107     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
108     , p8_a7 out nocopy JTF_NUMBER_TABLE
109     , p7_a0  NUMBER := 0-1962.0724
110     , p7_a1  VARCHAR2 := fnd_api.g_miss_char
111     , p7_a2  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a3  NUMBER := 0-1962.0724
113     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
114     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
115     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
116     , p7_a7  NUMBER := 0-1962.0724
117   );
118   procedure content_search(p_api_version  NUMBER
119     , p_init_msg_list  VARCHAR2
120     , p_validation_level  NUMBER
121     , x_return_status out nocopy  VARCHAR2
122     , x_msg_count out nocopy  NUMBER
123     , x_msg_data out nocopy  VARCHAR2
124     , p_check_login_user  VARCHAR2
125     , p_application_id  NUMBER
126     , p_area_array JTF_VARCHAR2_TABLE_4000
127     , p_content_array JTF_VARCHAR2_TABLE_4000
128     , p10_a0 JTF_VARCHAR2_TABLE_100
129     , p10_a1 JTF_VARCHAR2_TABLE_400
130     , p_imt_string  VARCHAR2
131     , p_days  NUMBER
132     , p_user_id  NUMBER
133     , p_category_id JTF_NUMBER_TABLE
134     , p_include_subcats  VARCHAR2
135     , p_external_contents  VARCHAR2
136     , p18_a0 out nocopy  NUMBER
137     , p18_a1 out nocopy  NUMBER
138     , p18_a2 out nocopy  NUMBER
139     , p19_a0 out nocopy JTF_VARCHAR2_TABLE_300
140     , p19_a1 out nocopy JTF_VARCHAR2_TABLE_2000
141     , p19_a2 out nocopy JTF_VARCHAR2_TABLE_4000
142     , p19_a3 out nocopy JTF_NUMBER_TABLE
143     , p19_a4 out nocopy JTF_NUMBER_TABLE
144     , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
145     , p19_a6 out nocopy JTF_VARCHAR2_TABLE_300
146     , p19_a7 out nocopy JTF_VARCHAR2_TABLE_300
147     , p19_a8 out nocopy JTF_VARCHAR2_TABLE_300
148     , p17_a0  NUMBER := 0-1962.0724
149     , p17_a1  NUMBER := 0-1962.0724
150     , p17_a2  VARCHAR2 := fnd_api.g_miss_char
151   );
152   procedure build_imt_string(p_optional_array JTF_VARCHAR2_TABLE_4000
153     , p_required_array JTF_VARCHAR2_TABLE_4000
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;