EMPLOYEES

Item Location

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

Procedures

Name	Description
DeleteEmployeeById	Procedure body DeleteEmployeeById(id NUMBER), Package EMPLOYEES
GetAllEmployees	Procedure body GetAllEmployees(), Package EMPLOYEES
GetManagerOfEmployeeById	Procedure body GetManagerOfEmployeeById(id NUMBER), Package EMPLOYEES
InsertEmployee	Procedure body InsertEmployee(fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES
LogDeletingEmployee	Procedure body LogDeletingEmployee(id NUMBER), Package EMPLOYEES
OrdersByEmployee2	Procedure body OrdersByEmployee2(employee_Id NUMBER,p_recordset SYS_REFCURSOR), Package EMPLOYEES
UpdateEmployeeName	Procedure body UpdateEmployeeName(employeeId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES

Functions

Name	Description
CheckEmployee	Function body CheckEmployee(employee_Id NUMBER) return CheckEmployee, Package EMPLOYEES
GetFullName	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package EMPLOYEES
GetManagerByEmployee	Function body GetManagerByEmployee(id NUMBER) return GetManagerByEmployee, Package EMPLOYEES

Types

No Data

Cursors

Name	Definition
No Data

Variables and Constants and their Impact Analysis

Name	Types	Value
isChecked	Variable
Impact Analysis:	Object calling \"isChecked\" Object Type <DEFAULT SCHEMA>.EMPLOYEES.CheckEmployee Function
msg	Variable
Impact Analysis:	Object calling \"msg\" Object Type <DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee Procedure <DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert Insert Statement
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.EMPLOYEES.GetAllEmployees Procedure
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.EMPLOYEES.GetManagerOfEmployeeById Procedure
title	Variable
Impact Analysis:	Object calling \"title\" Object Type <DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee Procedure <DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert Insert Statement

References
     The items listed in the matrix below are called / used by the Package “EMPLOYEES”

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK	Package	Package, Interface
<DEFAULT SCHEMA>.EMPLOYEES	Package	Package, Interface
<DEFAULT SCHEMA>.APPLOG	Table	Table
CUSTOMER	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.SALES_ORDER	Table	Table
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS	Table	Table
<DEFAULT SCHEMA>.ALL_EMPLOYEES	View	View
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS	View	View
<DEFAULT SCHEMA>.ALL_PRODUCTS	View	View
<DEFAULT SCHEMA>.EMPLOYEES.DeleteEmployeeById	Procedure	Procedure interface DeleteEmployeeById(id NUMBER), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.GetAllEmployees	Procedure	Procedure interface GetAllEmployees(), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.GetManagerOfEmployeeById	Procedure	Procedure interface GetManagerOfEmployeeById(id NUMBER), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.InsertEmployee	Procedure	Procedure interface InsertEmployee(fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee	Procedure	Procedure interface LogDeletingEmployee(id NUMBER), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2	Procedure	Procedure interface OrdersByEmployee2(employee_Id NUMBER,p_recordset SYS_REFCURSOR), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.UpdateEmployeeName	Procedure	Procedure interface UpdateEmployeeName(employeeId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.CheckEmployee	Function	Function interface CheckEmployee(employee_Id NUMBER) return BOOLEAN, Package EMPLOYEES
CONCAT	Function	PL/SQL System Function
DECODE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.APPLOGPK.GetActionId	Function	Function interface GetActionId(actionName NVARCHAR2) return INTEGER, Package APPLOGPK
<DEFAULT SCHEMA>.EMPLOYEES.GetFullName	Function	Function interface GetFullName(fname NVARCHAR2,lname NVARCHAR2) return NVARCHAR, Package EMPLOYEES
<DEFAULT SCHEMA>.EMPLOYEES.GetManagerByEmployee	Function	Function interface GetManagerByEmployee(id NUMBER) return INT, Package EMPLOYEES
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
SUM	Function	PL/SQL System Function
SYSDATE	Function	PL/SQL System Function
CFNAME	Alias	Column alias
CLNAME	Alias	Column alias
OAMOUNT	Alias	Column alias
ODATE	Alias	Column alias
OID	Alias	Column alias
OREGION	Alias	Column alias
<DEFAULT SCHEMA>.APPLOG.ACTION	Column	Column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.CITY	Column	View column
CUST_ID	Column	Virtual column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_FNAME	Column	Column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_FNAME	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.EMP_ID	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_LNAME	Column	View column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_LNAME	Column	Column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_STREET	Column	View column
<DEFAULT SCHEMA>.APPLOG.EMPLOYEE_ID	Column	Column
FIN_CODE_ID	Column	Virtual column
FNAME	Column	Virtual column
ID	Column	Virtual column
LNAME	Column	Virtual column
<DEFAULT SCHEMA>.APPLOG.LOG_DATE	Column	Column
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.MANAGER_FNAME	Column	View column
<DEFAULT SCHEMA>.APPLOG.MESSAGE	Column	Column
ORDER_DATE	Column	Virtual column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.PHONE	Column	View column
QUANTITY	Column	Virtual column
REGION	Column	Virtual column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.STATE	Column	View column
<DEFAULT SCHEMA>.APPLOG.TITLE	Column	Column
<DEFAULT SCHEMA>.ALL_PRODUCTS.UNIT_PRICE	Column	View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.ZIP_CODE	Column	View column
BOOLEAN	PL/SQL System type	PL/SQL System Object
INT	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
SYS_REFCURSOR	PL/SQL System type	PL/SQL System Object
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym
INTERGER	Undefined Item
NVARCHAR	Undefined Item
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS.ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER.ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER.SALES_REP	Foreign Key	Column

Impact Analysis
     The items listed in the matrix below are using / calling the Package “EMPLOYEES”

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE_DELETING	Trigger	Simple Trigger of AFTER "DELETE ON EMPLOYEE"
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderById	Procedure	Procedure body DeleteOrderById(orderId NUMBER), Package SALEORDER
<DEFAULT SCHEMA>.DATA.Ordersbyemployee	Procedure	Procedure body Ordersbyemployee(employee_Id NUMBER), Package DATA
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer	Procedure	Procedure body ProductsByCustomer(Customer_Id NUMBER), Package PRODUCTS
<DEFAULT SCHEMA>.DATA.sp_deleteemployee	Procedure	Procedure body sp_deleteemployee(employeeId NUMBER), Package DATA
<DEFAULT SCHEMA>.DATA.sp_retrieve_employees	Procedure	Procedure body sp_retrieve_employees(), Package DATA