Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |
Trigger Name | Status | Validity | Type | Event | Base Object Type | Base Object |
---|---|---|---|---|---|---|
TRG_PA_POST_PRZYPISY_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_POSTEPOWANIA_PRZYPISY |
TRG_PA_POST_PRZYPISY_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_POSTEPOWANIA_PRZYPISY |
TRG_PA_POST_ULGI_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_POSTEPOWANIA_ULGI |
TRG_PA_POST_ULGI_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_POSTEPOWANIA_ULGI |
TRG_PA_POST_UNI_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_POSTEPOWANIA_UNI |
TRG_PA_POST_UNI_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_POSTEPOWANIA_UNI |
TRG_PARAGONY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAGONY |
TRG_PARAMETRY_CK_METRYKI_SPRRA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY |
TRG_PARAMETRY_USLUGI_INSERT | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAMETRY_USLUGI |
TRG_PARAM_INST_SCHEMAT_WS_OPER | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY_INST |
TRG_PARAM_KOSZTY_UPOMNIENIA_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAM_KOSZTY_UPOMNIENIA |
TRG_PARAM_ODSETKI_PODATKOWE_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAM_ODSETKI_PODATKOWE |
TRG_PARAM_REJ_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY |
TRG_PARAM_RO_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY_RO |
TRG_PARAM_RO_ID_REJ_PROL_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY_RO |
TRG_PARAM_RO_ID_REJ_RAT_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY_RO |
TRG_PARAM_RO_ID_REJ_UMO_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY_RO |
TRG_PARAM_RSPUSL_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAMETRY |
TRG_PARAM_WART_LISTY_ID_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAM_WARTOSCI_LISTY |
TRG_PARAM_WARTOSCI_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAM_WARTOSCI |
TRG_PARAM_WARTOSCI_LISTY_ZGODN | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAM_WARTOSCI_LISTY |
TRG_PARAM_WARTOSCI_ZGODNOSC | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | PARAM_WARTOSCI |
TRG_PARREKL_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PARAMETRY_REKLAMACJE |
TRG_PA_SL_CZYNN_GRUPY_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_SL_CZYNNOSCI_GRUPY |
TRG_PA_SL_CZYNN_GRUPY_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_CZYNNOSCI_GRUPY |
TRG_PA_SL_CZYNNOSCI_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_CZYNNOSCI |
TRG_PA_SL_CZYNN_OS_TYPY_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_CZYNNOSCI_OSOBY_TYPY |
TRG_PA_SL_RODZ_DEC_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_RODZAJE_DECYZJI |
TRG_PA_SL_RODZ_PISM_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_RODZAJE_PISM |
TRG_PA_SL_RODZ_POST_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_RODZAJE_POSTEPOWANIA |
TRG_PA_SL_STAT_DEC_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_STATUSY_DECYZJI |
TRG_PA_SL_STAT_POST_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_SL_STATUSY_POSTEPOWANIA |
TRG_PA_STAT_POST_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_STATUSY_POSTEPOWANIA |
TRG_PA_STAT_POST_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | PA_STATUSY_POSTEPOWANIA |
TRG_PA_TMP_PLIKI_I | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PA_TMP_PLIKI |
TRG_PK_LICZNIKI_STAN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | LICZNIKI_STAN |
TRG_PK_LICZNIKI_USLUGI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | LICZNIKI_USLUGI |
TRG_PK_POSESJA_USLUGI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_USLUGI |
TRG_PK_POSESJA_USLUGI_LICZN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_USLUGI_LICZNIKI |
TRG_PK_SL_LICZNIKOW_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_LICZNIKOW |
TRG_PK_SL_RODZ_LICZNIKA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | SL_RODZ_LICZNIKA |
TRG_PLIKI_XML_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PLIKI_XML |
TRG_POS_DOKUMENTY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_DOKUMENTY |
TRG_POSEJA_WSP_DATY | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA_WSPOLNOTA_WEW |
TRG_POSEJA_WSP_ID_POZ | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA_WSPOLNOTA_WEW |
TRG_POSESJA_BIUD | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | POSESJA |
TRG_POSESJA_EWID_PESEL_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_EWIDENCJA_PESEL |
TRG_POSESJA_EWP_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_EWIDENCJA_PESEL |
TRG_POSESJA_ID_REJ_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA |
TRG_POSESJA_KOD_OBREBU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA |
TRG_POSESJA_KOPIUJ_PRZENIES | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KOPIUJ_PRZENIES_LOG |
TRG_POSESJA_KOPIUJ_PRZENIES_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KOPIUJ_PRZENIES_LOG |
TRG_POSESJA_OBREBY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_OBREBY |
TRG_POSESJA_POJ_ILOSC_OSOB | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_POJEMNIKI_ILOSC_OSOB |
TRG_POSESJA_POWODY_WYLACZENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_POWODY_WYLACZENIA |
TRG_POSESJA_POWODY_WYLACZ_LOG | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA_POWODY_WYLACZENIA |
TRG_POSESJA_UMOWY_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_UMOWY |
TRG_POSESJA_USLUGI_IL_ID_FAKE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_USLUGI_ILOSC |
TRG_POSESJA_ZDARZENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | POSESJA_ZDARZENIA |
TRG_POSKONAD_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE_ADRESY |
TRG_POSKONAD_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE_ADRESY |
TRG_POSKON_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE |
TRG_POSKON_LOGUJ_STATUS | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE | Table | POSESJA_KONTROLE |
TRG_POSKONOS_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE_OSOBY |
TRG_POSKONOS_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE_OSOBY |
TRG_POSKONPRA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE_PRACOWNICY |
TRG_POSKONPRA_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE_PRACOWNICY |
TRG_POSKONSLWYN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE_SL_WYNIKI |
TRG_POSKONSLWYN_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE_SL_WYNIKI |
TRG_POSKONSTA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE_STATUSY |
TRG_POSKONSTA_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE_STATUSY |
TRG_POSKON_TWORZ_KLIENTA | ENABLED | Valid | AFTER EACH ROW | INSERT | Table | POSESJA_KONTROLE |
TRG_POSKON_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE |
TRG_POSKONZA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_KONTROLE_ZALACZNIKI |
TRG_POSKONZA_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POSESJA_KONTROLE_ZALACZNIKI |
TRG_POS_SPOS_ODPROW_CIEK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_SPOSOBY_ODPROW_CIEK |
TRG_POS_SPOS_OGRZEWANIA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_SPOSOBY_OGRZEWANIA |
TRG_POS_SPOS_ZAGOSP_BIO_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POSESJA_SPOSOBY_ZAGOSP_BIO |
TRG_POST_CZYNNOSCI_0 | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POST_CZYNNOSCI |
TRG_POST_CZYNNOSCI_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POST_CZYNNOSCI |
TRG_POST_CZYNNOSCI_ZALACZ_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POST_CZYNNOSCI_ZALACZ |
TRG_POST_POSTEPOWANIA_0 | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POST_POSTEPOWANIA |
TRG_POST_POSTEPOWANIA_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POST_POSTEPOWANIA |
TRG_POST_PRZYPISY_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POST_PRZYPISY |
TRG_POST_SL_CZYNNOSCI_U | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | POST_SL_CZYNNOSCI |
TRG_POWIATY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POWIATY |
TRG_POWOD_REKL_POL_WYM_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POWOD_REKLAMACJI_POLA_WYMAG |
TRG_PPK_FUNDUSZE_ID_UMOWY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PPK_FUNDUSZE_UMOWY |
TRG_PPK_FUNDUSZE_POLA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PPK_FUNDUSZE_POLA |
TRG_PRAC_FIRMA_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_FIRMA |
TRG_PRAC_FIRMA_OGRANICZ_BI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_FIRMA |
TRG_PRACOWNICY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRACOWNICY |
TRG_PRAC_PASKI_UMOWY_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_PASKI_UMOWY |
TRG_PRAC_POCZTA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | POCZTA |
TRG_PRAC_PREMIE_WYDZ_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_PREMIE_WYDZ |
TRG_PRAC_PZATR_WYL_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_PZATR_WYLACZENIE |
TRG_PRAC_WYDZIAL_KOSZTY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PRAC_WYDZIAL_KOSZTY |
TRG_PROD_PROD_SUR_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_PRODUKCJA_SUROWCE |
TRG_PROD_PRODUKCJA_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_PRODUKCJA |
TRG_PROD_PROD_ZAMOW_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | PROD_PRODUKCJA_ZAMOWIENIE |