[Home] [Help]
135: /* check if Geo location info already exists for the instance, else mark it as create */
136: BEGIN
137: SELECT 'U'
138: INTO l_create_update
139: FROM CSI_II_GEOLOCATIONS
140: WHERE INSTANCE_ID = p_instance_id;
141:
142: EXCEPTION WHEN NO_DATA_FOUND THEN
143: l_create_update := 'C';