Name | Value |
---|---|
OWNER | AREL |
TRIGGER_NAME | T_ABSENCES_JUSTIFIEES_2 |
TRIGGER_TYPE | BEFORE EACH ROW |
TRIGGERING_EVENT | INSERT |
TABLE_OWNER | AREL |
BASE_OBJECT_TYPE | TABLE |
TABLE_NAME | ABSENCES_JUSTIFIEES |
COLUMN_NAME | null |
REFERENCING_NAMES | REFERENCING NEW AS NEW OLD AS OLD |
WHEN_CLAUSE | null |
STATUS | ENABLED |
DESCRIPTION | t_absences_justifiees_2 BEFORE INSERT ON absences_justifiees FOR EACH ROW |
ACTION_TYPE | PL/SQL |
TRIGGER_BODY | DECLARE BEGIN UPDATE etudiants_absences SET justification = 'aj' WHERE pf_groupe = :new.f_groupe AND (SELECT e.jour FROM edt e WHERE e.p_id = pf_edt)+1 BETWEEN to_char(:new.date_debut, 'D') AND to_char(:new.date_fin, 'D') AND (SELECT e.semaine FROM edt e WHERE e.p_id = pf_edt) BETWEEN to_char(:new.date_debut, 'WW') AND to_char(:new.date_fin, 'WW'); END; |
CREATED | 2011-09-02 09:27:09.0 |
LAST_DDL_TIME | 2011-09-02 09:27:09.0 |