APPS.CSI_GIS_INSTANCE_LOC_PUB dependencies on CSI_GIS_INSTANCE_GEO_LOC_PVT

Line 129: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW

125: csi_t_gen_utility_pvt.add( 'Invalidating Instance geo location info');
126: END IF;
127:
128:
129: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW
130: ( p_instance_id => p_csi_instance_geoloc_tbl(i).instance_id
131: ,p_inst_latitude => l_inst_latitude_dd_value
132: ,p_inst_longitude => l_inst_longitude_dd_value
133: ,p_valid_flag => 'N'

Line 208: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW

204: IF (l_debug_level > 0) THEN
205: csi_t_gen_utility_pvt.add( 'Invalidating Instance geo location info');
206: END IF;
207:
208: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW
209: ( p_instance_id => p_csi_instance_geoloc_tbl(i).instance_id
210: ,p_inst_latitude => l_inst_latitude_dd_value
211: ,p_inst_longitude => l_inst_longitude_dd_value
212: ,p_valid_flag => p_csi_instance_geoloc_tbl(i).valid_flag

Line 354: CSI_GIS_INSTANCE_GEO_LOC_PVT.INSERT_ROW

350: IF l_create_update = 'C' THEN
351:
352: csi_t_gen_utility_pvt.add( 'Calling Insert row');
353:
354: CSI_GIS_INSTANCE_GEO_LOC_PVT.INSERT_ROW
355: ( p_instance_id => p_CSI_instance_geoloc_tbl(i).instance_id
356: ,p_inst_latitude => l_inst_latitude_dd_value
357: ,p_inst_longitude => l_inst_longitude_dd_value
358: , x_return_status => l_return_status

Line 398: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW

394: ELSIF l_create_update = 'U' THEN
395:
396: csi_t_gen_utility_pvt.add( 'Calling Update row');
397: /* Updating information for an existing instance */
398: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW
399: ( p_instance_id => p_CSI_instance_geoloc_tbl(i).instance_id
400: ,p_inst_latitude => l_inst_latitude_dd_value
401: ,p_inst_longitude => l_inst_longitude_dd_value
402: ,p_valid_flag => p_CSI_instance_geoloc_tbl(i).valid_flag