132: WHEN NO_DATA_FOUND THEN
133:
134: SELECT EGO_ACTIONS_S.nextval
135: INTO l_action_id 136: FROM DUAL 137: WHERE ROWNUM = 1;
138:
139: INSERT INTO EGO_ACTIONS_B
140: (
Line 721: FROM dual;
717: AND assoc.CLASSIFICATION_CODE = p_src_template_code;
718:
719: CURSOR c_gen_association_id IS
720: SELECT EGO_ASSOCS_S.NEXTVAL 721: FROM dual; 722:
723: l_association_id NUMBER;
724: l_api_name VARCHAR2(50);
725: l_errorcode NUMBER;