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: (
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;