[Home] [Help]
PACKAGE: APPS.CSI_GIS_INSTANCE_LOC_PUB
Source
1 PACKAGE CSI_GIS_INSTANCE_LOC_PUB AUTHID CURRENT_USER as
2 /* $Header: csipgils.pls 120.0.12010000.1 2008/11/07 13:41:45 jgootyag noship $ */
3
4 TYPE csi_instance_geoloc_rec_type IS RECORD
5 ( INSTANCE_ID NUMBER
6 ,INST_LATITUDE VARCHAR2(100)
7 ,INST_LONGITUDE VARCHAR2(100)
8 ,VALID_FLAG VARCHAR2(1) :='Y'
9 ,GEOCODE_FORMAT VARCHAR2(3) := 'DMS'
10 );
11
12 TYPE csi_instance_geoloc_tbl_type IS TABLE OF csi_instance_geoloc_rec_type
13 INDEX BY BINARY_INTEGER;
14
15
16
17
18
19 PROCEDURE CREATEUPDATE_INST_GEOLOC_INFO
20 (
21 p_api_version IN NUMBER
22 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
23 ,p_CSI_INSTANCE_geoloc_tbl IN CSI_GIS_INSTANCE_LOC_PUB.csi_instance_geoloc_tbl_type
24 ,p_asset_context IN VARCHAR2 :='EAM'
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30 PROCEDURE IMPORT_INSTANCE_GEO_LOCATION
31 (
32 p_api_version IN NUMBER,
33 p_commit IN VARCHAR2 := FND_API.G_TRUE ,
34 x_return_status OUT NOCOPY VARCHAR2 ,
35 x_msg_count OUT NOCOPY NUMBER ,
36 x_msg_data OUT NOCOPY VARCHAR2
37 ) ;
38
39 END CSI_GIS_INSTANCE_LOC_PUB;