## T_ABSENCES_JUSTIFIEES_1

Code
Dependencies
Details

Name | Value
--- | ---
OWNER | AREL
TRIGGER_NAME | T_ABSENCES_JUSTIFIEES_1
TRIGGER_TYPE | BEFORE EACH ROW
TRIGGERING_EVENT | INSERT OR UPDATE
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_1 BEFORE INSERT OR UPDATE ON absences_justifiees FOR EACH ROW
ACTION_TYPE | PL/SQL
TRIGGER_BODY | DECLARE compte number; groupe_impossible EXCEPTION; BEGIN SELECT COUNT(g.p_id) INTO compte FROM groupes g, groupes_parentes gp, groupes apprenant, types_groupes tg WHERE g.p_id = :new.f_groupe AND gp.pf_fils = g.p_id AND apprenant.p_id = gp.pf_pere AND tg.p_id = apprenant.f_type AND tg.libelle = 'apprenant'; IF (compte != 1) THEN RAISE groupe_impossible; END IF; END;
CREATED | 2011-09-02 09:27:09.0
LAST_DDL_TIME | 2011-09-02 09:27:09.0