LogDeletingEmployee


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   EMPLOYEES   >   LogDeletingEmployee   

Procedure body LogDeletingEmployee(id NUMBER), Package EMPLOYEES

Name Datatype Precision Description
id NUMBER NUMBER, parameter of EMPLOYEES.LogDeletingEmployee
Name Types Value
msg Variable
Impact Analysis:
Object calling \"msg\" Object Type
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee Procedure
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert Insert Statement
title Variable
Impact Analysis:
Object calling \"title\" Object Type
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee Procedure
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert Insert Statement
Name Definition
No Data

procedure LogDeletingEmployee( id in NUMBER)
    is
		title nvarchar2(50);
		msg nvarchar2(50);
    begin
			
			title := concat('Delete employee id: ',id);
			msg := concat('Delete employee id: ',id);
            INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,APPLOGPK.GetActionId('DEL EMPLOYEE'), title,msg , id);

    end LogDeletingEmployee

     
Name Types Description
<DEFAULT SCHEMA>.APPLOGPK Package Package, Interface
<DEFAULT SCHEMA>.APPLOG Table Table
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee Procedure Procedure interface LogDeletingEmployee(id NUMBER), Package EMPLOYEES
CONCAT Function PL/SQL System Function
<DEFAULT SCHEMA>.APPLOGPK.GetActionId Function Function interface GetActionId(actionName NVARCHAR2) return INTEGER, Package APPLOGPK
SYSDATE Function PL/SQL System Function
<DEFAULT SCHEMA>.APPLOG.ACTION Column Column
<DEFAULT SCHEMA>.APPLOG.EMPLOYEE_ID Column Column
<DEFAULT SCHEMA>.APPLOG.LOG_DATE Column Column
<DEFAULT SCHEMA>.APPLOG.MESSAGE Column Column
<DEFAULT SCHEMA>.APPLOG.TITLE Column Column
NUMBER PL/SQL System type PL/SQL System Object
NVARCHAR2 PL/SQL System type PL/SQL System Object

     
Name Types Description
<DEFAULT SCHEMA>.EMPLOYEE_DELETING Trigger Simple Trigger of AFTER "DELETE ON EMPLOYEE"