Hi Will, You can set a public variable when your first trigger is called and reset it at the end of the trigger. You can read the status of the variable in your other triggers, etc. Public variables can be set in the specifications of a package and called like this:

--First trigger
BEGIN
 pkg_TriggerFunctions.v_MyVar := True;
 --process updates.
 pkg_TriggerFunctions.v_MyVar := False;
END;
---------

--Second trigger (or whatever)
 BEGIN
 IF pkg_TriggerFunctions.v_MyVar THEN
   --Special trigger processing
 ELSE
   --Normal trigger processing
 END IF;
END;

>George,
>
>Yes, this is the problem. Some of the triggers fired by the updates in the trigger check to make sure the parent ID exists in the employee table.
>
>

>CREATE OR REPLACE TRIGGER "PAYROLL TEST"."TRIG_BIUD_EMP_TIME"
>    BEFORE INSERT OR
>    DELETE OR
>    UPDATE OF "DATEFROM", "DATETO", "EMPLOYEEID"
>    ON "PAYROLL TEST"."EMP_TIME"
>    FOR EACH ROW
>    DECLARE RecordCount NUMBER;
>BEGIN
>  /* PREVENT INSERTS AND UPDATES IF NO MATCHING KEY IN 'employee' */
>  IF (UPDATING AND :old.employeeid != :new.employeeid) OR INSERTING
>  THEN
>    SELECT COUNT(*)
>    INTO RecordCount
>    FROM employee
>    WHERE (employee.id = :new.employeeid);
>    IF RecordCount = 0
>    THEN
>      raise_application_error(-20003, 'Employee ID does not exist in the employee table.');
>    END IF;
>  END IF;
>END;
>

>
>Is there a way to determine how a trigger is being called? If I know the trigger is being fired by "TRIG_BIUD_EMPLOYEE" trigger I could bypass testing for the employeeid in the employee table.
>
>
>>You are modifying multiple tables here so several triggers may be firing. You will need to look at all the triggers to see if they are also doing updates to any of these tables or related constraining tables.
>>
>>>I am getting an error:
>>>
>>>PAYROLL TEST.EMPLOYEE is mutating, trigger/function may not see it ORA-0651: at "PAYROLL TEST.TRIG_BIUD_EMP_TIME",line 6
>>>
>>>Anyone have suggests how to correct this error?
>>>
>>>The trigger is:
>>>
>>>

>>>CREATE OR REPLACE TRIGGER "PAYROLL TEST"."TRIG_BIUD_EMPLOYEE"
>>>AFTER INSERT OR
>>>DELETE OR
>>>UPDATE OF "ID"
>>>ON "PAYROLL TEST"."EMPLOYEE"
>>>FOR EACH ROW
>>>DECLARE RecordCount NUMBER;
>>>BEGIN
>>>IF UPDATING AND :old.id != :new.id
>>>THEN
>>>/* CASCADE UPDATES TO Pay Rate History */
>>>UPDATE pay_rate
>>>SET pay_rate.employeeID = :new.id
>>>WHERE pay_rate.employeeID = :old.id;
>>>
>>>/* CASCADE UPDATES TO Employee Future Activities */
>>>UPDATE emp_future
>>>SET emp_future.employeeID = :new.id
>>>WHERE emp_future.employeeID = :old.id;
>>>
>>>/* CASCADE UPDATES TO Employee History Info */
>>>UPDATE emp_history
>>>SET emp_history.employeeID = :new.id
>>>WHERE emp_history.employeeID = :old.id;
>>>
>>>/* CASCADE UPDATES TO Employee License Table */
>>>UPDATE emp_license
>>>SET emp_license.employeeID = :new.id
>>>WHERE emp_license.employeeID = :old.id;
>>>
>>>UPDATE emp_time
>>>SET emp_time.employeeID = :new.id
>>>WHERE emp_time.employeeID = :old.id;
>>>END IF;
>>>/* PREVENT DELETES IF DEPENDENT RECORDS IN Pay Rate History */
>>>IF DELETING
>>>THEN
>>>SELECT COUNT(*)
>>>INTO RecordCount
>>>FROM pay_rate
>>>WHERE (pay_rate.EmployeeID = :old.id);
>>>IF RecordCount > 0
>>>THEN
>>>raise_application_error(-20002, 'Cannot delete record. Pay rates have been found for this employee.');
>>>END IF;
>>>
>>>DELETE FROM emp_future
>>>WHERE emp_future.employeeID = :old.id;
>>>
>>>DELETE FROM emp_history
>>>WHERE emp_history.employeeID = :old.id;
>>>
>>>DELETE FROM emp_license
>>>WHERE emp_license.employeeID = :old.id;
>>>
>>>DELETE FROM emp_time
>>>WHERE emp_time.employeeID = :old.id;
>>>END IF;
>>>END;
>>>