DECLARE
    PROCEDURE make_delete_query (
    param_parent_id IN NUMBER,
    param_process_id IN NUMBER
    ) IS
        BEGIN
            FOR rec IN (SELECT id, ident FROM  sys_obj_type WHERE parent_id = _parent_id ) LOOP
                DBMS_OUTPUT.put_line('update ' || rec.ident || ' set status = 0, wi_removed_from_bpmn = 0 where wi_process_id = ' || param_parent_id);
                make_delete_query(rec.id, param_process_id);
            END LOOP;
        END;
BEGIN
    DBMS_OUTPUT.put_line('update WF_PROCESS_ITEM set status = 0, wi_removed_from_bpmn = 0 where wi_process_id = 21561700');
    FOR rec IN (SELECT id, ident FROM sys_obj_type WHERE ident = 'WF_PROCESS_ITEM') LOOP
        make_delete_query(rec.id, 21561700);
    END LOOP;
END;