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.HZ_GNR_PVT_W

Source


1 package hz_gnr_pvt_w as
2   /* $Header: ARHGNRWS.pls 120.4 2006/02/09 21:25:29 nsinghai noship $ */
3   procedure rosetta_table_copy_in_p4(t out nocopy hz_gnr_pvt.geo_struct_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_300
8     , a5 JTF_VARCHAR2_TABLE_100
9     );
10   procedure rosetta_table_copy_out_p4(t hz_gnr_pvt.geo_struct_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
11     , a1 out nocopy JTF_VARCHAR2_TABLE_100
12     , a2 out nocopy JTF_VARCHAR2_TABLE_100
13     , a3 out nocopy JTF_NUMBER_TABLE
14     , a4 out nocopy JTF_VARCHAR2_TABLE_300
15     , a5 out nocopy JTF_VARCHAR2_TABLE_100
16     );
17 
18   procedure rosetta_table_copy_in_p6(t out nocopy hz_gnr_pvt.geo_suggest_tbl_type, a0 JTF_VARCHAR2_TABLE_100
19     , a1 JTF_VARCHAR2_TABLE_100
20     , a2 JTF_NUMBER_TABLE
21     , a3 JTF_VARCHAR2_TABLE_100
22     , a4 JTF_VARCHAR2_TABLE_100
23     , a5 JTF_VARCHAR2_TABLE_100
24     , a6 JTF_NUMBER_TABLE
25     , a7 JTF_VARCHAR2_TABLE_100
26     , a8 JTF_VARCHAR2_TABLE_100
27     , a9 JTF_VARCHAR2_TABLE_100
28     , a10 JTF_NUMBER_TABLE
29     , a11 JTF_VARCHAR2_TABLE_100
30     , a12 JTF_VARCHAR2_TABLE_100
31     , a13 JTF_NUMBER_TABLE
32     , a14 JTF_VARCHAR2_TABLE_100
33     , a15 JTF_VARCHAR2_TABLE_100
34     , a16 JTF_NUMBER_TABLE
35     , a17 JTF_VARCHAR2_TABLE_100
36     , a18 JTF_VARCHAR2_TABLE_100
37     , a19 JTF_NUMBER_TABLE
38     , a20 JTF_VARCHAR2_TABLE_100
39     , a21 JTF_VARCHAR2_TABLE_100
40     , a22 JTF_NUMBER_TABLE
41     , a23 JTF_VARCHAR2_TABLE_100
42     , a24 JTF_VARCHAR2_TABLE_200
43     , a25 JTF_NUMBER_TABLE
44     , a26 JTF_VARCHAR2_TABLE_100
45     , a27 JTF_VARCHAR2_TABLE_200
46     , a28 JTF_NUMBER_TABLE
47     , a29 JTF_VARCHAR2_TABLE_100
48     , a30 JTF_VARCHAR2_TABLE_200
49     , a31 JTF_NUMBER_TABLE
50     , a32 JTF_VARCHAR2_TABLE_100
51     , a33 JTF_VARCHAR2_TABLE_200
52     , a34 JTF_NUMBER_TABLE
53     , a35 JTF_VARCHAR2_TABLE_100
54     , a36 JTF_VARCHAR2_TABLE_200
55     , a37 JTF_NUMBER_TABLE
56     , a38 JTF_VARCHAR2_TABLE_100
57     , a39 JTF_VARCHAR2_TABLE_200
58     , a40 JTF_NUMBER_TABLE
59     , a41 JTF_VARCHAR2_TABLE_100
60     , a42 JTF_VARCHAR2_TABLE_200
61     , a43 JTF_NUMBER_TABLE
62     , a44 JTF_VARCHAR2_TABLE_100
63     , a45 JTF_VARCHAR2_TABLE_200
64     , a46 JTF_NUMBER_TABLE
65     , a47 JTF_VARCHAR2_TABLE_100
66     , a48 JTF_VARCHAR2_TABLE_200
67     , a49 JTF_NUMBER_TABLE
68     , a50 JTF_VARCHAR2_TABLE_100
69     , a51 JTF_VARCHAR2_TABLE_200
70     , a52 JTF_NUMBER_TABLE
71     , a53 JTF_VARCHAR2_TABLE_100
72     , a54 JTF_VARCHAR2_TABLE_4000
73     );
74   procedure rosetta_table_copy_out_p6(t hz_gnr_pvt.geo_suggest_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
75     , a1 out nocopy JTF_VARCHAR2_TABLE_100
76     , a2 out nocopy JTF_NUMBER_TABLE
77     , a3 out nocopy JTF_VARCHAR2_TABLE_100
78     , a4 out nocopy JTF_VARCHAR2_TABLE_100
79     , a5 out nocopy JTF_VARCHAR2_TABLE_100
80     , a6 out nocopy JTF_NUMBER_TABLE
81     , a7 out nocopy JTF_VARCHAR2_TABLE_100
82     , a8 out nocopy JTF_VARCHAR2_TABLE_100
83     , a9 out nocopy JTF_VARCHAR2_TABLE_100
84     , a10 out nocopy JTF_NUMBER_TABLE
85     , a11 out nocopy JTF_VARCHAR2_TABLE_100
86     , a12 out nocopy JTF_VARCHAR2_TABLE_100
87     , a13 out nocopy JTF_NUMBER_TABLE
88     , a14 out nocopy JTF_VARCHAR2_TABLE_100
89     , a15 out nocopy JTF_VARCHAR2_TABLE_100
90     , a16 out nocopy JTF_NUMBER_TABLE
91     , a17 out nocopy JTF_VARCHAR2_TABLE_100
92     , a18 out nocopy JTF_VARCHAR2_TABLE_100
93     , a19 out nocopy JTF_NUMBER_TABLE
94     , a20 out nocopy JTF_VARCHAR2_TABLE_100
95     , a21 out nocopy JTF_VARCHAR2_TABLE_100
96     , a22 out nocopy JTF_NUMBER_TABLE
97     , a23 out nocopy JTF_VARCHAR2_TABLE_100
98     , a24 out nocopy JTF_VARCHAR2_TABLE_200
99     , a25 out nocopy JTF_NUMBER_TABLE
100     , a26 out nocopy JTF_VARCHAR2_TABLE_100
101     , a27 out nocopy JTF_VARCHAR2_TABLE_200
102     , a28 out nocopy JTF_NUMBER_TABLE
103     , a29 out nocopy JTF_VARCHAR2_TABLE_100
104     , a30 out nocopy JTF_VARCHAR2_TABLE_200
105     , a31 out nocopy JTF_NUMBER_TABLE
106     , a32 out nocopy JTF_VARCHAR2_TABLE_100
107     , a33 out nocopy JTF_VARCHAR2_TABLE_200
108     , a34 out nocopy JTF_NUMBER_TABLE
109     , a35 out nocopy JTF_VARCHAR2_TABLE_100
110     , a36 out nocopy JTF_VARCHAR2_TABLE_200
111     , a37 out nocopy JTF_NUMBER_TABLE
112     , a38 out nocopy JTF_VARCHAR2_TABLE_100
113     , a39 out nocopy JTF_VARCHAR2_TABLE_200
114     , a40 out nocopy JTF_NUMBER_TABLE
115     , a41 out nocopy JTF_VARCHAR2_TABLE_100
116     , a42 out nocopy JTF_VARCHAR2_TABLE_200
117     , a43 out nocopy JTF_NUMBER_TABLE
118     , a44 out nocopy JTF_VARCHAR2_TABLE_100
119     , a45 out nocopy JTF_VARCHAR2_TABLE_200
120     , a46 out nocopy JTF_NUMBER_TABLE
121     , a47 out nocopy JTF_VARCHAR2_TABLE_100
122     , a48 out nocopy JTF_VARCHAR2_TABLE_200
123     , a49 out nocopy JTF_NUMBER_TABLE
124     , a50 out nocopy JTF_VARCHAR2_TABLE_100
125     , a51 out nocopy JTF_VARCHAR2_TABLE_200
126     , a52 out nocopy JTF_NUMBER_TABLE
127     , a53 out nocopy JTF_VARCHAR2_TABLE_100
128     , a54 out nocopy JTF_VARCHAR2_TABLE_4000
129     );
130 
131   procedure search_geographies(p_table_name  VARCHAR2
132     , p_address_style  VARCHAR2
133     , p_address_usage  VARCHAR2
134     , p_country_code  VARCHAR2
135     , p_state  VARCHAR2
136     , p_province  VARCHAR2
137     , p_county  VARCHAR2
138     , p_city  VARCHAR2
139     , p_postal_code  VARCHAR2
140     , p_postal_plus4_code  VARCHAR2
141     , p_attribute1  VARCHAR2
142     , p_attribute2  VARCHAR2
143     , p_attribute3  VARCHAR2
144     , p_attribute4  VARCHAR2
145     , p_attribute5  VARCHAR2
146     , p_attribute6  VARCHAR2
147     , p_attribute7  VARCHAR2
148     , p_attribute8  VARCHAR2
149     , p_attribute9  VARCHAR2
150     , p_attribute10  VARCHAR2
151     , x_mapped_struct_count out nocopy  NUMBER
152     , x_records_count out nocopy  NUMBER
153     , x_return_code out nocopy  NUMBER
154     , x_validation_level out nocopy  VARCHAR2
155     , p24_a0 out nocopy JTF_VARCHAR2_TABLE_100
156     , p24_a1 out nocopy JTF_VARCHAR2_TABLE_100
157     , p24_a2 out nocopy JTF_NUMBER_TABLE
158     , p24_a3 out nocopy JTF_VARCHAR2_TABLE_100
159     , p24_a4 out nocopy JTF_VARCHAR2_TABLE_100
160     , p24_a5 out nocopy JTF_VARCHAR2_TABLE_100
161     , p24_a6 out nocopy JTF_NUMBER_TABLE
162     , p24_a7 out nocopy JTF_VARCHAR2_TABLE_100
163     , p24_a8 out nocopy JTF_VARCHAR2_TABLE_100
164     , p24_a9 out nocopy JTF_VARCHAR2_TABLE_100
165     , p24_a10 out nocopy JTF_NUMBER_TABLE
166     , p24_a11 out nocopy JTF_VARCHAR2_TABLE_100
167     , p24_a12 out nocopy JTF_VARCHAR2_TABLE_100
168     , p24_a13 out nocopy JTF_NUMBER_TABLE
169     , p24_a14 out nocopy JTF_VARCHAR2_TABLE_100
170     , p24_a15 out nocopy JTF_VARCHAR2_TABLE_100
171     , p24_a16 out nocopy JTF_NUMBER_TABLE
172     , p24_a17 out nocopy JTF_VARCHAR2_TABLE_100
173     , p24_a18 out nocopy JTF_VARCHAR2_TABLE_100
174     , p24_a19 out nocopy JTF_NUMBER_TABLE
175     , p24_a20 out nocopy JTF_VARCHAR2_TABLE_100
176     , p24_a21 out nocopy JTF_VARCHAR2_TABLE_100
177     , p24_a22 out nocopy JTF_NUMBER_TABLE
178     , p24_a23 out nocopy JTF_VARCHAR2_TABLE_100
179     , p24_a24 out nocopy JTF_VARCHAR2_TABLE_200
180     , p24_a25 out nocopy JTF_NUMBER_TABLE
181     , p24_a26 out nocopy JTF_VARCHAR2_TABLE_100
182     , p24_a27 out nocopy JTF_VARCHAR2_TABLE_200
183     , p24_a28 out nocopy JTF_NUMBER_TABLE
184     , p24_a29 out nocopy JTF_VARCHAR2_TABLE_100
185     , p24_a30 out nocopy JTF_VARCHAR2_TABLE_200
186     , p24_a31 out nocopy JTF_NUMBER_TABLE
187     , p24_a32 out nocopy JTF_VARCHAR2_TABLE_100
188     , p24_a33 out nocopy JTF_VARCHAR2_TABLE_200
189     , p24_a34 out nocopy JTF_NUMBER_TABLE
190     , p24_a35 out nocopy JTF_VARCHAR2_TABLE_100
191     , p24_a36 out nocopy JTF_VARCHAR2_TABLE_200
192     , p24_a37 out nocopy JTF_NUMBER_TABLE
193     , p24_a38 out nocopy JTF_VARCHAR2_TABLE_100
194     , p24_a39 out nocopy JTF_VARCHAR2_TABLE_200
195     , p24_a40 out nocopy JTF_NUMBER_TABLE
196     , p24_a41 out nocopy JTF_VARCHAR2_TABLE_100
197     , p24_a42 out nocopy JTF_VARCHAR2_TABLE_200
198     , p24_a43 out nocopy JTF_NUMBER_TABLE
199     , p24_a44 out nocopy JTF_VARCHAR2_TABLE_100
200     , p24_a45 out nocopy JTF_VARCHAR2_TABLE_200
201     , p24_a46 out nocopy JTF_NUMBER_TABLE
202     , p24_a47 out nocopy JTF_VARCHAR2_TABLE_100
203     , p24_a48 out nocopy JTF_VARCHAR2_TABLE_200
204     , p24_a49 out nocopy JTF_NUMBER_TABLE
205     , p24_a50 out nocopy JTF_VARCHAR2_TABLE_100
206     , p24_a51 out nocopy JTF_VARCHAR2_TABLE_200
207     , p24_a52 out nocopy JTF_NUMBER_TABLE
208     , p24_a53 out nocopy JTF_VARCHAR2_TABLE_100
209     , p24_a54 out nocopy JTF_VARCHAR2_TABLE_4000
210     , p25_a0 out nocopy JTF_VARCHAR2_TABLE_100
211     , p25_a1 out nocopy JTF_VARCHAR2_TABLE_100
212     , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
213     , p25_a3 out nocopy JTF_NUMBER_TABLE
214     , p25_a4 out nocopy JTF_VARCHAR2_TABLE_300
215     , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
216     , p26_a0 out nocopy  VARCHAR2
217     , x_return_status out nocopy  VARCHAR2
218     , x_msg_count out nocopy  NUMBER
219     , x_msg_data out nocopy  VARCHAR2
220   );
221 end hz_gnr_pvt_w;