APPS.CSI_GIS_INSTANCE_GEO_LOC_PVT dependencies on CSI_II_GEOLOCATIONS

Line 35: INSERT INTO CSI_II_GEOLOCATIONS

31: BEGIN
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: INSERT INTO CSI_II_GEOLOCATIONS
36: (
37: INSTANCE_ID,
38: INST_LATITUDE,
39: INST_LONGITUDE,

Line 84: UPDATE CSI_II_GEOLOCATIONS

80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: IF p_valid_flag = 'N' THEN
83:
84: UPDATE CSI_II_GEOLOCATIONS
85: SET
86: VALID_FLAG = p_valid_flag,
87: LAST_UPDATED_BY = FND_GLOBAL.user_id,
88: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,

Line 94: UPDATE CSI_II_GEOLOCATIONS

90:
91: WHERE
92: INSTANCE_ID = p_instance_id;
93: ELSE
94: UPDATE CSI_II_GEOLOCATIONS
95: SET
96: INST_LATITUDE = p_inst_latitude,
97: INST_LONGITUDE = p_inst_longitude,
98: VALID_FLAG = NVL(p_valid_flag,'Y'),