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_KDR_PRAC_RACHUNKI_INSERT | ENABLED | Valid | INSTEAD OF | INSERT | View | V_KDR_PRAC_RACHUNKI |
TRG_KDR_PRAC_RACHUNKI_UPDATE | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_KDR_PRAC_RACHUNKI |
TRG_KDR_PRAC_RACHUNKI_UP_DEL | ENABLED | Valid | BEFORE EACH ROW | UPDATE OR DELETE | Table | KDR_PRAC_RACHUNKI |
TRG_KDR_PRAC_REJESTR_WYPADKOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_REJESTR_WYPADKOW |
TRG_KDR_PRAC_RODZ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_RODZ |
TRG_KDR_PRAC_RODZ_PESEL_NIP_CH | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_PRAC_RODZ |
TRG_KDR_PRAC_SZKOLENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_SZKOLENIA |
TRG_KDR_PRAC_UPRAWN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_UPRAWN |
TRG_KDR_PRAC_URLOPY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_URLOPY |
TRG_KDR_PRAC_URLOPY_POZOSTALO | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_PRAC_URLOPY |
TRG_KDR_PRAC_WOJSKO | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_WOJSKO |
TRG_KDR_PRAC_WYKSZT | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_WYKSZT |
TRG_KDR_RACHUNKI_SKLADN_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_RACHUNKI_SKLADN |
TRG_KDR_RACHUNKI_WAZNOSC_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_RACHUNKI_WAZNOSC |
TRG_KDR_REP_ZUS3_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_REP_ZUS3 |
TRG_KDR_ROZLICZENIE_NADGODZIN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_ROZLICZENIE_NADGODZIN |
TRG_KDR_RP7_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_RP7 |
TRG_KDR_SKLADN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN |
TRG_KDR_SKLADN_GRUPY_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_GRUPY |
TRG_KDR_SKLADN_GRUPY_TYPY_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_GRUPY_TYPY |
TRG_KDR_SKLADN_GRUPY_TYPY_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_SKLADN_GRUPY_TYPY |
TRG_KDR_SKLADN_IND | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_IND |
TRG_KDR_SKLADN_IND_GRUPOWE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_IND_GRUPOWE |
TRG_KDR_SKLADN_IND_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_IND_TYP |
TRG_KDR_SKLADN_IND_TYP_EDYCJA | ENABLED | Valid | BEFORE EACH ROW | UPDATE OR DELETE | Table | KDR_SKLADN_IND_TYP |
TRG_KDR_SKLADN_IND_TYP_WZORY | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE OR DELETE | Table | KDR_SKLADN_IND_TYP |
TRG_KDR_SKLADN_IND_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_SKLADN_IND |
TRG_KDR_SKLADN_NIEOB_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_NIEOB |
TRG_KDR_SKLADN_NIEOB_TYP_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_NIEOB_TYP |
TRG_KDR_SKLADN_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_PARAM |
TRG_KDR_SKLADN_PARAM_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_PARAM_TYP |
TRG_KDR_SKLADN_PARAM_WZORY | ENABLED | Valid | AFTER STATEMENT | INSERT OR UPDATE OR DELETE | Table | KDR_SKLADN_PARAM |
TRG_KDR_SKLADN_RECZNIE | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_SKLADN |
TRG_KDR_SKLADN_RECZNIE_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_RECZNIE |
TRG_KDR_SKLADN_RODZAJ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_RODZAJ |
TRG_KDR_SKLADN_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_TYP |
TRG_KDR_SKLADN_TYP_KOLEJNOSC_N | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_SKLADN_TYP |
TRG_KDR_SKLADN_UMOWY_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_UMOWY_TYP |
TRG_KDR_SKL_DEK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_TYP_DEK |
TRG_KDR_SKL_IND_DEK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SKLADN_IND_TYP_DEK |
TRG_KDR_SL_AKTA_OSOBOWE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_AKTA_OSOBOWE |
TRG_KDR_SL_BADANIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_BADANIA |
TRG_KDR_SL_EWIDENCJE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_EWIDENCJE |
TRG_KDR_SL_JEZYKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_JEZYKI |
TRG_KDR_SL_NAGRODY_KARY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_NAGRODY_KARY |
TRG_KDR_SL_NAGRODY_KARY_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_SL_NAGRODY_KARY |
TRG_KDR_SL_OBYWATELSTWO | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_OBYWATELSTWO |
TRG_KDR_SL_OBYWATELSTWO_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_SL_OBYWATELSTWO |
TRG_KDR_SL_ODDZ_ZUS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_ODDZ_ZUS |
TRG_KDR_SL_ODDZ_ZUS_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_SL_ODDZ_ZUS |
TRG_KDR_SL_PROZUM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_PROZUM |
TRG_KDR_SL_RODZAJE_URAZOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_RODZAJE_URAZOW |
TRG_KDR_SL_SKUTKI_WYPADKOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_SKUTKI_WYPADKOW |
TRG_KDR_SL_STAN_CYW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_STAN_CYW |
TRG_KDR_SL_STAN_CYW_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_SL_STAN_CYW |
TRG_KDR_SL_STOP_NAUK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_STOP_NAUK |
TRG_KDR_SL_STOP_NAUK_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_SL_STOP_NAUK |
TRG_KDR_SL_SZKOLENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_SZKOLENIA |
TRG_KDR_SL_SZKOLENIA_UPDATE | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_SL_SZKOLENIA |
TRG_KDR_SL_UMIEJSCOWIEN_URAZOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_SL_UMIEJSCOWIENIA_URAZOW |
TRG_KDR_SL_UMOWY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_SL_UMOWY |
TRG_KDR_STAN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_STAN |
TRG_KDR_STAN_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_STAN |
TRG_KDR_STAN_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_STAN_TYP |
TRG_KDR_STAN_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_STAN_TYP |
TRG_KDR_UMOWY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY |
TRG_KDR_UMOWY_DELETE | ENABLED | Valid | BEFORE EACH ROW | DELETE | Table | KDR_UMOWY |
TRG_KDR_UMOWY_EKW_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_EKWIWALENT |
TRG_KDR_UMOWY_GRUPY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_GRUPY |
TRG_KDR_UMOWY_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PARAM |
TRG_KDR_UMOWY_PPK_FUND_LISTYID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PPK_FUNDUSZE_LISTY |
TRG_KDR_UMOWY_PPK_FUND_PRACID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PPK_FUNDUSZE_PRAC |
TRG_KDR_UMOWY_RODZAJ_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_UMOWY_RODZAJ |
TRG_KDR_UMOWY_RODZAJ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_RODZAJ |
TRG_KDR_UMOWY_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_TYP |
TRG_KDR_UMOWY_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_UMOWY_TYP |
TRG_KDR_UMOWY_TYP_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_TYP_PARAM |
TRG_KDR_UMOWY_TYP_RODZAJ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_TYP_RODZAJ |
TRG_KDR_UMOWY_TYP_SKLADN_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_TYP_SKLADN_IND_TYP |
TRG_KDR_UMOWY_UNIQUE_NR_UMOWA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_UMOWY |
TRG_KDR_UMOWY_UPDATE | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_UMOWY |
TRG_KDR_UMOWY_ZADANIA_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_ZADANIA |
TRG_KDR_UMOWY_ZUS_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_UMOWY_ZUS |
TRG_KDR_UMOWY_ZUS_INSERT | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_ZUS |
TRG_KDR_UMOWY_ZUS_UPDATE | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_KDR_UMOWY_ZUS |
TRG_KDR_UPRAWN_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UPRAWN_TYP |
TRG_KDR_UPRAWN_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_UPRAWN_TYP |
TRG_KDR_V_SKLADN_UP | ENABLED | Valid | INSTEAD OF | INSERT OR UPDATE OR DELETE | View | V_KDR_SKLADN |
TRG_KDR_WYKSZT_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_WYKSZT_TYP |
TRG_KDR_WYKSZT_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_WYKSZT_TYP |
TRG_KDR_ZAWODY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_ZAWODY |
TRG_KDR_ZAWODY_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_ZAWODY |
TRG_KDR_ZLEC_IND | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_ZLEC_IND |
TRG_KDR_ZMIANY_AU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDR_ZMIANY |
TRG_KDR_ZMIANY_GODZ_AU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDR_ZMIANY_GODZ |
TRG_KDR_ZMIANY_OKRESY_AU | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDR_ZMIANY_OKRESY |
TRG_KDR_ZMIANY_OKRESY_BEF | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_ZMIANY_OKRESY |
TRG_KDR_ZUS_EKSP_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | UPDATE OR DELETE | Table | KDR_ZUS_EKSP |
TRG_KDR_ZUS_SKLADN_MSC_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_ZUS_SKLADN_MIESIECZNE |
TRG_KG_BANKI_P_MALE_PK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | BANKI_P |