1 PACKAGE CSI_GIS_INSTANCE_GEO_LOC_PVT AS
2 /* $Header: csivgils.pls 120.0.12010000.1 2008/11/10 05:56:30 jgootyag noship $ */
3 PROCEDURE INSERT_ROW
4 (
5 p_instance_id IN NUMBER
6 ,p_inst_latitude IN NUMBER
7 ,p_inst_longitude IN NUMBER
8 , x_return_status OUT NOCOPY VARCHAR2
9 );
10
11
12 PROCEDURE UPDATE_ROW
13 (
14 p_instance_id IN NUMBER
15 ,p_inst_latitude IN NUMBER
16 ,p_inst_longitude IN NUMBER
17 ,p_valid_flag IN VARCHAR2
18 , x_return_status OUT NOCOPY VARCHAR2
19 );
20
21 END CSI_GIS_INSTANCE_GEO_LOC_PVT;