APPS.CSI_GIS_INSTANCE_LOC_PUB dependencies on CSI_GIS_INSTANCE_LOC_UTL_PKG

Line 110: CSI_GIS_INSTANCE_LOC_UTL_PKG.VALIDATE_INSTANCE_NUMBER

106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: /*validate Asset/instance */
110: CSI_GIS_INSTANCE_LOC_UTL_PKG.VALIDATE_INSTANCE_NUMBER
111: (p_instance_id => p_csi_instance_geoloc_tbl(i).instance_id
112: ,p_asset_context => p_asset_context
113: ,x_instance_number => l_instance_number
114: ,x_create_update => l_create_update

Line 240: CSI_GIS_INSTANCE_LOC_UTL_PKG.VALIDATE_LATITUDE_LONGITUDE

236:
237: csi_t_gen_utility_pvt.add( 'calling validate latitude longitude');
238:
239: /*This procedure is called to validate the latitude and longitude values*/
240: CSI_GIS_INSTANCE_LOC_UTL_PKG.VALIDATE_LATITUDE_LONGITUDE
241: (p_latitude => p_csi_instance_geoloc_tbl(i).inst_latitude
242: ,p_longitude => p_csi_instance_geoloc_tbl(i).inst_longitude
243: ,p_geocode_format => p_csi_instance_geoloc_tbl(i).geocode_format
244: ,p_instance_number => l_instance_number

Line 278: CSI_GIS_INSTANCE_LOC_UTL_PKG.CONVERT_DMS_OR_DM_TO_DD

274:
275: csi_t_gen_utility_pvt.add( 'Convert Latitude value to DD');
276:
277: /* calling procedure to convert latitude to DD value */
278: CSI_GIS_INSTANCE_LOC_UTL_PKG.CONVERT_DMS_OR_DM_TO_DD
279: (p_value => p_csi_instance_geoloc_tbl(i).inst_latitude
280: ,p_mode => 'LAT'
281: ,p_geocode_format => p_csi_instance_geoloc_tbl(i).geocode_format
282: ,p_instance_number => l_instance_number

Line 312: CSI_GIS_INSTANCE_LOC_UTL_PKG.CONVERT_DMS_OR_DM_TO_DD

308:
309: csi_t_gen_utility_pvt.add( 'Convert Latitude value to DD');
310:
311: /* calling procedure to convert longitude to DD value */
312: CSI_GIS_INSTANCE_LOC_UTL_PKG.CONVERT_DMS_OR_DM_TO_DD
313: (p_value => p_csi_instance_geoloc_tbl(i).inst_longitude
314: ,p_mode => 'LON'
315: ,p_geocode_format => p_csi_instance_geoloc_tbl(i).geocode_format
316: ,p_instance_number => l_instance_number