119: SET deleted_flag = '1'
120: WHERE devl_project_id = deletedPubl;
121: COMMIT;
122: EXCEPTION WHEN OTHERS THEN
123: errbuf := cz_utils.get_text('CZ_PUB_MGR_ERR','ERR',SQLERRM);
124: END;
125: END IF;
126: END LOOP;
127: close cDeletedPublication;
126: END LOOP;
127: close cDeletedPublication;
128: EXCEPTION
129: WHEN OTHERS THEN
130: errbuf := cz_utils.get_text('CZ_PUB_MGR_ERR','ERR',SQLERRM);
131: END;
132:
133: exception
134: when no_data_found then
131: END;
132:
133: exception
134: when no_data_found then
135: errbuf := cz_utils.get_text('CZ_PUB_MGR_ERR','ERR',SQLERRM);
136: end;
137:
138: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
139: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/