<DEFAULT SCHEMA>

Tables

Name	Description
APPLOG	Table
COUNTER	Table
CUSTOMER	Table
DEPARTMENT	Table
DERIVEDTABLE	Table
EMPLOYEE	Table
FIN_CODE
MANAGER	Table
MESSAGES
NEWPRODUCT	Table
PRODUCT	Table
SALES_ORDER	Table
SALES_ORDER_ITEMS	Table
SECURITY_APPS
SECURITY_GROUPINGS
SECURITY_INFO
SECURITY_TEMPLATE
SECURITY_USERS
SITE	Table

Views

Name	Description
ALL_CUSTOMERS	View
ALL_DEPARTMENTS	View
ALL_EMPLOYEES	View
ALL_EMPLOYEES_BY_DEPARTMENT	View
ALL_EMPLOYEES_DETAILS	View
ALL_MANAGERS	View
ALL_MANAGERS_BY_DEPARTEMENT	View
ALL_MANAGERS_BY_SITE	View
ALL_NEWPRODUCT	View
ALL_ORDERS_BY_EMPLOYEE	View
ALL_ORDERS_BY_MANAGER	View
ALL_PRODUCTS	View
ALL_SALES_ORDER_ITEMS_DETAILS	View
ALL_SITES	View
GET_LOG_2017	View
GET_LOG_2017_BY_MANAGERS	View
GET_LOG_2017_Q1	View
GET_LOG_2017_Q2	View
GET_LOG_2017_Q3	View
GET_LOG_2017_Q4	View

Triggers

Name	Description
CHECKAPPLOG	Simple Trigger of AFTER "insert ON AppLog"
CHECKPRODUCT	Simple Trigger of AFTER "update ON Product"
COUNTER_UPDATE	Simple Trigger of AFTER "UPDATE ON COUNTER"
EMPLOYEE_DELETING	Simple Trigger of AFTER "DELETE ON EMPLOYEE"
INSERTPRODUCT	Simple Trigger of AFTER "insert ON Product"
LOG_SALARY_INCREASE	Simple Trigger of AFTER "UPDATE ON EMPLOYEE"
TRG_ORDER	Simple Trigger of BEFORE "INSERT on sales_order_items"
TRG_SALE_ORDER_ITEMS	Simple Trigger of BEFORE "DELETE on sales_order_items"

Packages

Name	Description
APPLOGPK	Package, Body
CUSTOMERS	Package, Body
DATA	Package, Body
EMPLOYEES	Package, Body
PRODUCTS	Package, Body
SALEORDER	Package, Body

Procedures

Name	Description
ChangedSalary	Procedure body ChangedSalary(employeeId NUMBER,newSalary NUMBER), Package APPLOGPK
CreateProduct	Procedure body CreateProduct(name NVARCHAR2,description NVARCHAR2,prod_size INTEGER,quantity NUMBER,unit_price NUMBER), Package PRODUCTS
DeleteCustomerById	Procedure body DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS
DeleteEmployeeById	Procedure body DeleteEmployeeById(id NUMBER), Package EMPLOYEES
DeleteOrderById	Procedure body DeleteOrderById(orderId NUMBER), Package SALEORDER
DeleteOrderItemById	Procedure body DeleteOrderItemById(orderId NUMBER), Package SALEORDER
DeleteProductById	Procedure body DeleteProductById(productId NUMBER), Package PRODUCTS
GetAllCustomers	Procedure body GetAllCustomers(), Package CUSTOMERS
GetAllEmployees	Procedure body GetAllEmployees(), Package EMPLOYEES
GetAllItems	Procedure body GetAllItems(orderId NUMBER), Package SALEORDER
GetAllOrders	Procedure body GetAllOrders(), Package SALEORDER
GetAllProducts	Procedure body GetAllProducts(), Package PRODUCTS
GetManagerOfEmployeeById	Procedure body GetManagerOfEmployeeById(id NUMBER), Package EMPLOYEES
GetOrderById	Procedure body GetOrderById(orderId NUMBER), Package SALEORDER
GetProductById	Procedure body GetProductById(productId NUMBER), Package PRODUCTS
InitProduct	Procedure body InitProduct(name NVARCHAR2), Package PRODUCTS
InsertCustomer	Procedure body InsertCustomer(fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS
InsertEmployee	Procedure body InsertEmployee(fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES
LogCleaner	Procedure body LogCleaner(), Package APPLOGPK
LogDeletingEmployee	Procedure body LogDeletingEmployee(id NUMBER), Package EMPLOYEES
LogDeletingSalesOrderItem	Procedure body LogDeletingSalesOrderItem(saleOrderItemId NUMBER), Package APPLOGPK
Ordersbyemployee	Procedure body Ordersbyemployee(employee_Id NUMBER), Package DATA
OrdersByEmployee2	Procedure body OrdersByEmployee2(employee_Id NUMBER,p_recordset SYS_REFCURSOR), Package EMPLOYEES
ProductsByCustomer	Procedure body ProductsByCustomer(Customer_Id NUMBER), Package PRODUCTS
PRODUCTSBYCUSTOMER	Procedure body PRODUCTSBYCUSTOMER(CUSTOMER NUMBER,P_REF SYS_REFCURSOR)
sp_customer_List	Procedure body sp_customer_List(), Package DATA
sp_deleteemployee	Procedure body sp_deleteemployee(employeeId NUMBER), Package DATA
SP_DELETEEMPLOYEE	Procedure body SP_DELETEEMPLOYEE(EMPLOYEEID NUMBER)
sp_GetFullname	Procedure body sp_GetFullname(fname NVARCHAR2,lname NVARCHAR2), Package DATA
sp_retrieve_employees	Procedure body sp_retrieve_employees(), Package DATA
Startup	Procedure body Startup(name NVARCHAR2), Package DATA
UpdateCustomerName	Procedure body UpdateCustomerName(customerId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS
UpdateEmployeeName	Procedure body UpdateEmployeeName(employeeId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package EMPLOYEES
UpdateProductPrice	Procedure body UpdateProductPrice(productId INTERGER,price NUMBER), Package PRODUCTS

Functions

Name	Description
CheckCustomer	Function body CheckCustomer(customer_Id NUMBER) return CheckCustomer, Package CUSTOMERS
CheckEmployee	Function body CheckEmployee(employee_Id NUMBER) return CheckEmployee, Package EMPLOYEES
CheckPrice	Function body CheckPrice(price NUMBER) return CheckPrice, Package PRODUCTS
DecodeCodeId	Function body DecodeCodeId(codeId INTERGER) return DecodeCodeId, Package SALEORDER
F	Function body F(I_1 NUMBER,I_2 NUMBER,I_3 NUMBER) return T_OUT_PARAMS_TAB
GetActionId	Function body GetActionId(actionName NVARCHAR2) return GetActionId, Package APPLOGPK
GetActionName	Function body GetActionName(actionId INTEGER) return GetActionName, Package APPLOGPK
GetFullName	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package EMPLOYEES
GetFullName	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package CUSTOMERS
GetFullName	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package DATA
GetManagerByEmployee	Function body GetManagerByEmployee(id NUMBER) return GetManagerByEmployee, Package EMPLOYEES
uf_SetBracket	Function body uf_SetBracket(astring VARCHAR2) return uf_SetBracket, Package DATA