PACKAGE: APPS.CSI_GIS_INSTANCE_LOC_PUB

Source

1 PACKAGE CSI_GIS_INSTANCE_LOC_PUB 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;