SP_DELETEEMPLOYEE

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SP_DELETEEMPLOYEE

Procedure body SP_DELETEEMPLOYEE(EMPLOYEEID NUMBER)

Name	Datatype	Precision	Description
EMPLOYEEID	NUMBER		NUMBER

CREATE OR REPLACE Procedure SP_DELETEEMPLOYEE( employeeId IN NUMBER )

IS
BEGIN

   Data.sp_deleteemployee(employeeId);

EXCEPTION
WHEN OTHERS THEN
   raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
END

Name	Types	Description
<DEFAULT SCHEMA>.DATA	Package	Package, Interface
<DEFAULT SCHEMA>.DATA.sp_deleteemployee	Procedure	Procedure interface sp_deleteemployee(employeeId NUMBER), Package DATA
DBMS_STANDARD.RAISE_APPLICATION_ERROR	Function	PL/SQL System Function
NUMBER	PL/SQL System type	PL/SQL System Object
OTHERS	Undefined Item
SQLCODE	Undefined Item
SQLERRM	Undefined Item

Name	Types	Description
w_resp_employee.cb_delete.clicked	Event	event clicked()
<DEFAULT SCHEMA>.TRG_ORDER	Trigger	Simple Trigger of BEFORE "INSERT on sales_order_items"
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer	Procedure	Procedure body ProductsByCustomer(Customer_Id NUMBER), Package PRODUCTS