1 PACKAGE HZ_GEO_UI_UTIL_PUB AS
2 /* $Header: ARHGEOUS.pls 120.2 2005/09/28 20:11:53 sroychou noship $ */
3
4 TYPE tax_geo_rec_type IS RECORD (
5 level_number NUMBER,
6 geography_type VARCHAR2(360),
7 loc_comp VARCHAR2(360),
8 tax_geo_valid VARCHAR2(10) DEFAULT 'N'
9 );
10
11 TYPE tax_geo_tbl_type IS TABLE OF tax_geo_rec_type
12 INDEX BY BINARY_INTEGER;
13
14 FUNCTION check_dup_geo ( p_parent_id in NUMBER,
15 p_geo_name in VARCHAR2,
16 p_geo_code in VARCHAR2,
17 p_geo_type in VARCHAR2)
18 RETURN VARCHAR2;
19
20 FUNCTION check_geo_tax_valid( p_map_id in NUMBER,
21 p_geo_type in VARCHAR2,
22 p_geo_tax in VARCHAR2)
23 RETURN VARCHAR2;
24
25 PROCEDURE update_map_usages(p_map_id IN NUMBER,
26 p_tax_tbl IN HZ_GEO_UI_UTIL_PUB.tax_geo_tbl_type,
27 p_geo_tbl IN HZ_GEO_UI_UTIL_PUB.tax_geo_tbl_type,
28 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_show_gnr OUT NOCOPY VARCHAR2
33 );
34
35 FUNCTION get_geo_ref(p_geography_id IN NUMBER,
36 p_loc_table_name IN VARCHAR2)
37 RETURN VARCHAR2;
38
39 FUNCTION get_country_name(p_geography_id IN NUMBER)
40 RETURN VARCHAR2;
41
42 END HZ_GEO_UI_UTIL_PUB;