	sp_deleteemployee

Item Location

DATA >

sp_deleteemployee

Description

Procedure body sp_deleteemployee(employeeId NUMBER), Package DATA

Parameters

Name	Datatype	Precision	Description
employeeId	NUMBER		NUMBER, parameter of DATA.sp_deleteemployee

Variables and Constants and their Impact Analysis

Name	Types	Value
No Data

Cursors

Name	Definition
No Data

Source Code

procedure sp_deleteemployee( employeeId in NUMBER )
    Is 

    Begin
        Employees.DeleteEmployeeById(employeeId);
    end sp_deleteemployee

References
The items listed in the matrix below are called / used by the Procedure “sp_deleteemployee”

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEES	Package	Package, Interface
<DEFAULT SCHEMA>.EMPLOYEES.DeleteEmployeeById	Procedure	Procedure interface DeleteEmployeeById(id NUMBER), Package EMPLOYEES
<DEFAULT SCHEMA>.DATA.sp_deleteemployee	Procedure	Procedure interface sp_deleteemployee(employeeId NUMBER), Package DATA
NUMBER	PL/SQL System type	PL/SQL System Object

Impact Analysis
The items listed in the matrix below are using / calling the Procedure “sp_deleteemployee”

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer	Procedure	Procedure body ProductsByCustomer(Customer_Id NUMBER), Package PRODUCTS
<DEFAULT SCHEMA>.SP_DELETEEMPLOYEE	Procedure	Procedure body SP_DELETEEMPLOYEE(EMPLOYEEID NUMBER)
d_sp_customer_list.table.delete.method	Datawindow Attribute