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_KDO_USKARB_DATA_OD_CZAS_BU | ENABLED | Valid | AFTER STATEMENT | INSERT | Table | KDO_USKARB |
TRG_KDO_WEW_BIU | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDO_WEW |
TRG_KDO_WEW_KDO_POW_ID_POW_BU | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDO_WEW |
TRG_KDO_WIRT_ADR_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_WIRT_ADRESY |
TRG_KDO_WIRT_ADR_UPDATE | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDO_WIRT_ADRESY |
TRG_KDO_WIRT_NR_KONTR | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDO_WIRT_WEW |
TRG_KDO_WIRT_UPDATE | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDO_WIRT_WEW |
TRG_KDR_ADRESY_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_ADRESY_TYP |
TRG_KDR_ADRESY_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_ADRESY_TYP |
TRG_KDR_CONST_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_CONST_PARAM |
TRG_KDR_DEKLARACJE_PARAM_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_DEKLARACJE_PARAM |
TRG_KDR_DEKRET_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_DEKRET_TYP |
TRG_KDR_DNI_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_DNI_TYP |
TRG_KDR_DOK_RODZAJ | DISABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_DOK_RODZAJ |
TRG_KDR_DOK_TYP | DISABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_DOK_TYP |
TRG_KDR_DYWIDENDY_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_DYWIDENDY |
TRG_KDR_DYWIDENDY_PROCENT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_DYWIDENDY |
TRG_KDR_FIRMA_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_FIRMA_PARAM |
TRG_KDR_FORMAT_MASK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_FORMAT_MASK |
TRG_KDR_HARM_STAND | ENABLED | Valid | BEFORE EACH ROW | UPDATE OR DELETE | Table | KDR_HARM |
TRG_KDR_HARM_UMOWY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_HARM_UMOWY |
TRG_KDR_JEDN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_JEDN |
TRG_KDR_JEDN_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_JEDN |
TRG_KDR_JEDN_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_JEDN_TYP |
TRG_KDR_JEDN_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_JEDN_TYP |
TRG_KDR_KALK_NALICZENIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KALK_NALICZENIA |
TRG_KDR_KALK_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KALK_PARAM |
TRG_KDR_KALK_SKLADN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KALK_SKLADN |
TRG_KDR_KALK_SKLADN_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KALK_SKLADN_TYP |
TRG_KDR_KARTY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KARTY |
TRG_KDR_KARTY_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDR_KARTY |
TRG_KDR_KDR_LISTY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LISTY |
TRG_KDR_KODY_ID_KODU | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KODY |
TRG_KDR_KODY_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KODY_TYP |
TRG_KDR_KONTAKTY_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_KONTAKTY_TYP |
TRG_KDR_KONTAKTY_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_KONTAKTY_TYP |
TRG_KDR_LISTY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LISTY |
TRG_KDR_LISTY_RODZAJ_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LISTY_RODZAJ |
TRG_KDR_LISTY_SKLADN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LISTY_SKLADN |
TRG_KDR_LISTY_SKLADN_INSERT | ENABLED | Valid | INSTEAD OF | INSERT | View | V_KDR_LISTY_SKLADN |
TRG_KDR_LISTY_SKLADN_UPDATE | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_KDR_LISTY_SKLADN |
TRG_KDR_LISTY_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LISTY_TYP |
TRG_KDR_LISTY_TYP_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_LISTY_TYP |
TRG_KDR_LISTY_UP_BLOK_DEKRET | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_LISTY |
TRG_KDR_LISTY_UPD | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_LISTY |
TRG_KDR_LOG_CZASY_NALICZEN_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LOG_CZASY_NALICZEN |
TRG_KDR_LOGS_SEQ | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_LOGS |
TRG_KDR_NIEOB_DEL_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE OR DELETE | Table | KDR_NIEOB |
TRG_KDR_NIEOB_DOK_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_NIEOB_DOK |
TRG_KDR_NIEOB_GRUPY_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_NIEOB_GRUPY |
TRG_KDR_NIEOB_GRUPY_TYPY_IN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_NIEOB_GRUPY_TYPY |
TRG_KDR_NIEOB_GRUPY_TYPY_UP | ENABLED | Valid | BEFORE EACH ROW | UPDATE | Table | KDR_NIEOB_GRUPY_TYPY |
TRG_KDR_NIEOB_INS | DISABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_NIEOB |
TRG_KDR_NIEOB_TYP_ID_NIEOB_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_NIEOB_TYP |
TRG_KDR_ODSETKI_POZYCZKI_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_ODSETKI_POZYCZKI |
TRG_KDR_ODS_POZ_PROCENT | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_ODSETKI_POZYCZKI |
TRG_KDR_PARAM | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PARAM |
TRG_KDR_PARAMETRY_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_PARAMETRY |
TRG_KDR_PARAM_RODZAJ_PRM_TP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PARAM_RODZAJ_PARAM_TYP |
TRG_KDR_PARAM_TYP_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PARAM_TYP |
TRG_KDR_PARAM_WARTOSCI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PARAM_WARTOSCI |
TRG_KDR_PASKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PASKI |
TRG_KDR_PASKI_DEKRETY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PASKI_DEKRETY |
TRG_KDR_PASKI_NIEOB_BLOKADA | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDR_PASKI_NIEOB |
TRG_KDR_PASKI_NIEOB_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PASKI_NIEOB |
TRG_KDR_PASKI_PODST_CHOR_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PASKI_PODSTAWA_CHOR |
TRG_KDR_PASKI_SKLADN_IND_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PASKI_SKLADN_IND |
TRG_KDR_PASKI_SKLADN_SZCZEG_U | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_KDR_PASKI_SKLADN_IND_SZCZEG |
TRG_KDR_POPRZ_WYPLATY_TYP_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_POPRZEDNIE_WYPLATY_TYP |
TRG_KDR_POP_WYPLATY_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_POPRZEDNIE_WYPLATY |
TRG_KDR_POP_WYPLATY_INS_UP_DEL | ENABLED | Valid | AFTER EACH ROW | INSERT OR UPDATE OR DELETE | Table | KDR_POPRZEDNIE_WYPLATY |
TRG_KDR_POZYCZKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_POZYCZKI |
TRG_KDR_POZYCZKI_DELETE | ENABLED | Valid | INSTEAD OF | DELETE | View | V_KDR_POZYCZKI |
TRG_KDR_POZYCZKI_PORECZ_PESEL | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_POZYCZKI_PORECZYCIELE |
TRG_KDR_POZYCZKI_PORECZYCIELE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_POZYCZKI_PORECZYCIELE |
TRG_KDR_POZYCZKI_RATY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_POZYCZKI_RATY |
TRG_KDR_POZYCZKI_TYP | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_POZYCZKI_TYP |
TRG_KDR_PPK_FUNDUSZE_DANE_ID | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_UMOWY_PPK_FUNDUSZE_DANE |
TRG_KDR_PRAC | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC |
TRG_KDR_PRAC_ADRESY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_ADRESY |
TRG_KDR_PRAC_AKTA_OSOBOWE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_AKTA_OSOBOWE |
TRG_KDR_PRAC_AKTA_OSOBOWE_PL | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_AKTA_OSOBOWE_PLIKI |
TRG_KDR_PRAC_BADANIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_BADANIA |
TRG_KDR_PRAC_CECHY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_PARAM |
TRG_KDR_PRAC_DELEGACJE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_DELEGACJE |
TRG_KDR_PRAC_DOK | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_DOK |
TRG_KDR_PRAC_DO_NR_CHECK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_PRAC_DOK |
TRG_KDR_PRAC_EWIDENCJE | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_EWIDENCJE |
TRG_KDR_PRAC_HISTORIA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_HISTORIA |
TRG_KDR_PRAC_JEZYK_WYPOW | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_JEZYKI |
TRG_KDR_PRAC_KARIERA | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_KARIERA |
TRG_KDR_PRAC_KARIERA_WYLACZEN | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_KARIERA_WYLACZENIA |
TRG_KDR_PRAC_KDO_INS | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_KDO |
TRG_KDR_PRAC_KONTAKTY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_KONTAKTY |
TRG_KDR_PRAC_KONTAKTY_INSERT | ENABLED | Valid | INSTEAD OF | INSERT | View | V_KDR_PRAC_KONTAKTY |
TRG_KDR_PRAC_KONTAKTY_UPDATE | ENABLED | Valid | INSTEAD OF | UPDATE | View | V_KDR_PRAC_KONTAKTY |
TRG_KDR_PRAC_NAGRODY_KARY | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_NAGRODY_KARY |
TRG_KDR_PRAC_PESEL_NIP_CHECK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_PRAC |
TRG_KDR_PRAC_RACHUNKI | ENABLED | Valid | BEFORE EACH ROW | INSERT | Table | KDR_PRAC_RACHUNKI |
TRG_KDR_PRAC_RACHUNKI_CHECK | ENABLED | Valid | BEFORE EACH ROW | INSERT OR UPDATE | Table | KDR_PRAC_RACHUNKI |