DATA

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   DATA

Procedures

Name	Description
Ordersbyemployee	Procedure body Ordersbyemployee(employee_Id NUMBER), Package DATA
sp_customer_List	Procedure body sp_customer_List(), Package DATA
sp_deleteemployee	Procedure body sp_deleteemployee(employeeId NUMBER), Package DATA
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

Functions

Name	Description
GetFullName	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package DATA
uf_SetBracket	Function body uf_SetBracket(astring VARCHAR2) return uf_SetBracket, Package DATA

Types

No Data

Cursors

Name	Definition
No Data

Variables and Constants and their Impact Analysis

Name	Types	Value
rc	Variable
Impact Analysis:	Object calling \"rc\" Object Type <DEFAULT SCHEMA>.DATA.Ordersbyemployee Procedure

References
     The items listed in the matrix below are called / used by the Package “DATA”

Name	Types	Description
<DEFAULT SCHEMA>.CUSTOMERS	Package	Package, Interface
<DEFAULT SCHEMA>.DATA	Package	Package, Interface
<DEFAULT SCHEMA>.EMPLOYEES	Package	Package, Interface
<DEFAULT SCHEMA>.PRODUCTS	Package	Package, Interface
<DEFAULT SCHEMA>.EMPLOYEES.DeleteEmployeeById	Procedure	Procedure interface DeleteEmployeeById(id NUMBER), Package EMPLOYEES
<DEFAULT SCHEMA>.CUSTOMERS.GetAllCustomers	Procedure	Procedure interface GetAllCustomers(), Package CUSTOMERS
<DEFAULT SCHEMA>.EMPLOYEES.GetAllEmployees	Procedure	Procedure interface GetAllEmployees(), Package EMPLOYEES
<DEFAULT SCHEMA>.PRODUCTS.InitProduct	Procedure	Procedure interface InitProduct(name NVARCHAR2), Package PRODUCTS
<DEFAULT SCHEMA>.DATA.Ordersbyemployee	Procedure	Procedure interface Ordersbyemployee(employee_Id NUMBER), Package DATA
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2	Procedure	Procedure interface OrdersByEmployee2(employee_Id NUMBER,p_recordset SYS_REFCURSOR), Package EMPLOYEES
<DEFAULT SCHEMA>.DATA.sp_customer_List	Procedure	Procedure interface sp_customer_List(), Package DATA
<DEFAULT SCHEMA>.DATA.sp_deleteemployee	Procedure	Procedure interface sp_deleteemployee(employeeId NUMBER), Package DATA
<DEFAULT SCHEMA>.DATA.sp_GetFullname	Procedure	Procedure interface sp_GetFullname(fname NVARCHAR2,lname NVARCHAR2), Package DATA
<DEFAULT SCHEMA>.DATA.sp_retrieve_employees	Procedure	Procedure interface sp_retrieve_employees(), Package DATA
<DEFAULT SCHEMA>.DATA.Startup	Procedure	Procedure interface Startup(name NVARCHAR2), Package DATA
CONCAT	Function	PL/SQL System Function
<DEFAULT SCHEMA>.DATA.GetFullName	Function	Function interface GetFullName(fname NVARCHAR2,lname NVARCHAR2) return NVARCHAR, Package DATA
<DEFAULT SCHEMA>.DATA.uf_SetBracket	Function	Function interface uf_SetBracket(astring VARCHAR2) return VARCHAR2, Package DATA
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
SYS_REFCURSOR	PL/SQL System type	PL/SQL System Object
VARCHAR2	PL/SQL System type	PL/SQL System Object
NVARCHAR	Undefined Item

Impact Analysis
     The items listed in the matrix below are using / calling the Package “DATA”

Name	Types	Description
w_resp_employee.cb_orders.clicked	Event	event clicked()
n_tr_demopfc.uf_GetFullname	Function	function string uf_GetFullname(string,string)
<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
d_sp_employee_list.table.procedure	Datawindow Attribute
d_sp_customer_list.table.procedure	Datawindow Attribute