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: |
| |||||||
title | Variable | |||||||
Impact Analysis: |
|
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" |