73: /* All deleted publications*/
74:
75: CURSOR cDeletedPublication IS
76: SELECT devl_project_id
77: FROM cz_devl_projects
78: WHERE deleted_flag = '0'
79: AND devl_project_id NOT IN (SELECT object_id FROM cz_rp_entries
80: WHERE object_type = 'PRJ'
81: AND deleted_flag = '0');
114:
115: IF (NOT (hashRequiredModels.EXISTS(deletedPubl))) THEN
116: BEGIN
117: /* Logically delete model */
118: UPDATE cz_devl_projects
119: SET deleted_flag = '1'
120: WHERE devl_project_id = deletedPubl;
121: COMMIT;
122: EXCEPTION WHEN OTHERS THEN