[Home] [Help]
PACKAGE: APPS.HZ_GEO_STRUCT_MAP_PUB
Source
1 PACKAGE HZ_GEO_STRUCT_MAP_PUB AS
2 /* $Header: ARHGNRMS.pls 120.4 2005/09/02 17:39:54 baianand noship $ */
3
4 TYPE geo_struct_map_rec_type IS RECORD
5 (country_code VARCHAR2(2),
6 loc_tbl_name VARCHAR2(30),
7 address_style VARCHAR2(30)
8 );
9 TYPE geo_struct_map_dtl_rec_type IS RECORD
10 (loc_seq_num NUMBER,
11 loc_comp VARCHAR2(30),
12 geo_type VARCHAR2(30)
13 );
14 TYPE geo_struct_map_dtl_tbl_type IS TABLE of geo_struct_map_dtl_rec_type INDEX BY BINARY_INTEGER;
15
16 PROCEDURE create_geo_struct_mapping
17 (p_geo_struct_map_rec IN geo_struct_map_rec_type,
18 p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
19 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20 x_map_id OUT NOCOPY NUMBER,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2
24 );
25 PROCEDURE delete_geo_struct_mapping(
26 p_map_id IN NUMBER,
27 p_location_table_name IN VARCHAR2,
28 p_country IN VARCHAR2,
29 p_address_style IN VARCHAR2,
30 p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
31 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2);
35 PROCEDURE create_geo_struct_map_dtls
36 (p_map_id IN NUMBER,
37 p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43 PROCEDURE update_geo_struct_map_dtls
44 (p_map_id IN NUMBER,
45 p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
46 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 END;