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