ChangedSalary


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   APPLOGPK   >   ChangedSalary   

Procedure body ChangedSalary(employeeId NUMBER,newSalary NUMBER), Package APPLOGPK

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

procedure ChangedSalary(employeeId in NUMBER,newSalary in NUMBER)
    is
		title nvarchar2(50);
		msg nvarchar2(50);
    begin
			
			title := concat('Update salary to ',newSalary);
			msg := concat('Update a salary for employee id',employeeId);
            INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('NEW SAL'), title,msg , employeeId);

    end ChangedSalary

     
Name Types Description
<DEFAULT SCHEMA>.APPLOG Table Table
<DEFAULT SCHEMA>.APPLOGPK.ChangedSalary Procedure Procedure interface ChangedSalary(employeeId NUMBER,newSalary NUMBER), Package APPLOGPK
<DEFAULT SCHEMA>.APPLOGPK.GetActionId Function Function body GetActionId(actionName NVARCHAR2) return GetActionId, Package APPLOGPK
CONCAT Function PL/SQL System Function
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>.LOG_SALARY_INCREASE Trigger Simple Trigger of AFTER "UPDATE ON EMPLOYEE"