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
|