1 PACKAGE HZ_GEO_STRUCT_MAP_DTL_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHGEMDS.pls 120.2 2005/09/01 20:00:54 baianand noship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_map_id IN NUMBER,
7 x_loc_seq_num IN NUMBER,
8 x_loc_component IN VARCHAR2,
9 x_geography_type IN VARCHAR2,
10 x_geo_element_col IN VARCHAR2
11 );
12
13 PROCEDURE Update_Row (
14 x_rowid IN OUT NOCOPY VARCHAR2,
15 x_map_id IN NUMBER,
16 x_loc_seq_num IN NUMBER,
17 x_loc_component IN VARCHAR2,
18 x_geography_type IN VARCHAR2,
19 x_geo_element_col IN VARCHAR2
20 );
21
22 PROCEDURE Lock_Row (
23 x_rowid IN OUT NOCOPY VARCHAR2,
24 x_map_id IN NUMBER,
25 x_loc_seq_num IN NUMBER,
26 x_loc_component IN VARCHAR2,
27 x_geography_type IN VARCHAR2,
28 x_geo_element_col IN VARCHAR2
29 );
30
31 PROCEDURE Select_Row (
32 x_map_id IN OUT NOCOPY NUMBER,
33 x_loc_seq_num OUT NOCOPY NUMBER,
34 x_loc_component OUT NOCOPY VARCHAR2,
35 x_geography_type OUT NOCOPY VARCHAR2,
36 x_geo_element_col OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE Delete_Row (
40 x_map_id IN NUMBER
41 );
42 -- This API can use to delete only one record in mapping detail table.
43 PROCEDURE Delete_Row (
44 x_map_id IN NUMBER,
45 x_geography_type IN VARCHAR2
46 );
47 END HZ_GEO_STRUCT_MAP_DTL_PVT;