685: ;
686:
687: CURSOR c_model_id IS
688: SELECT ams_dm_models_all_b_s.NEXTVAL
689: FROM dual;
690:
691: CURSOR c_id_exists (p_model_id IN NUMBER) IS
692: SELECT 1
693: FROM dual
689: FROM dual;
690:
691: CURSOR c_id_exists (p_model_id IN NUMBER) IS
692: SELECT 1
693: FROM dual
694: WHERE EXISTS (SELECT 1
695: FROM ams_dm_models_all_b
696: WHERE model_id = p_model_id)
697: ;