APPS.AMS_GEO_AREAS_PVT dependencies on AMS_ACT_GEO_AREAS_S

Line 40: SELECT AMS_ACT_GEO_AREAS_S.NEXTVAL

36: l_geo_area_rec geo_area_rec_type := p_geo_area_rec;
37: l_geo_area_count NUMBER;
38:
39: CURSOR c_geo_area_seq IS
40: SELECT AMS_ACT_GEO_AREAS_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_geo_area_count(geo_area_id IN NUMBER) IS
44: SELECT COUNT(*)

Line 358: UPDATE AMS_ACT_GEO_AREAS SET

354:
355: AMS_Utility_PVT.debug_message(l_full_name||': update');
356: END IF;
357:
358: UPDATE AMS_ACT_GEO_AREAS SET
359: last_update_date = SYSDATE,
360: last_updated_by = FND_GLOBAL.user_id,
361: last_update_login = FND_GLOBAL.conc_login_id,
362: object_version_number = l_geo_area_rec.object_version_number + 1,