---daca pe firma rupta nu se doreste decat pastrarea nomenclatoarelor, fara solduri/stocuri initiale si tranzactii trebuie dat urmatorul SQL ---SetLunaLucru(2010, 11) este luna de pornire a firmei DELETE MIFIX1; DELETE MIFIX; DELETE MASTERMIFIX; BEGIN PKG_GLOBALS.SetLunaLucru(2010, 11); FOR V_REC IN (SELECT * FROM TREZOR) LOOP PKG_TREZOR.SP_DELETERECORD(V_REC.CODTREZOR); END LOOP; FOR V_REC IN (SELECT * FROM TRANSF) LOOP PKG_MISCARI_INTERNE.SP_DELETERECORD(V_REC.CODTRANSF); END LOOP; FOR V_REC IN (SELECT * FROM IESIRI) LOOP PKG_IESIRI.SP_DELETERECORD(V_REC.CODIES); END LOOP; FOR V_REC IN (SELECT * FROM INTRARI) LOOP PKG_INTRARI.SP_DELETERECORD(V_REC.CODINTR); END LOOP; DELETE NPARTSOLDLUNA; DELETE OBLIGPIFLUNA; DELETE NPERSSOLDLUNA; DELETE NIRLUNA; DELETE NIRSERLUNA; DELETE STOCINI; DELETE SOLDINI; DELETE NBANKSOLDLUNA; END;