	CHECKAPPLOG

Item Location

CHECKAPPLOG

Description

Simple Trigger of AFTER "insert ON AppLog"

Variables and Constants and their Impact Analysis

Name	Types	Value
No Data

Cursors

Name	Definition
No Data

Source Code

CREATE OR REPLACE TRIGGER CheckAppLog
AFTER insert ON AppLog
FOR EACH ROW
DECLARE

BEGIN
    :new.LOG_DATE := SYSDATE; 
END

References
The items listed in the matrix below are called / used by the Trigger “CHECKAPPLOG”

Name	Types	Description
<DEFAULT SCHEMA>.APPLOG	Table	Table
SYSDATE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.APPLOG.LOG_DATE	Column	Column

Impact Analysis
The items listed in the matrix below are using / calling the Trigger “CHECKAPPLOG”

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('DEL SO
<DEFAULT SCHEMA>.INSERTPRODUCT.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message) VALUES (SYSDATE,AppLogPk.GetActionId('INS PRODU
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,APPLOGPK.GetActionI
<DEFAULT SCHEMA>.APPLOGPK.ChangedSalary.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('NEW SA