CUSTOMERS

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CUSTOMERS

Procedures

Name	Description
DeleteCustomerById	Procedure body DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS
GetAllCustomers	Procedure body GetAllCustomers(), Package CUSTOMERS
InsertCustomer	Procedure body InsertCustomer(fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS
UpdateCustomerName	Procedure body UpdateCustomerName(customerId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS

Functions

Name	Description
CheckCustomer	Function body CheckCustomer(customer_Id NUMBER) return CheckCustomer, Package CUSTOMERS
GetFullName	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package CUSTOMERS

Types

No Data

Cursors

Name	Definition
No Data

Variables and Constants and their Impact Analysis

Name	Types	Value
isChecked	Variable
Impact Analysis:	Object calling \"isChecked\" Object Type <DEFAULT SCHEMA>.CUSTOMERS.CheckCustomer Function
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.CUSTOMERS.GetAllCustomers Procedure

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

Name	Types	Description
<DEFAULT SCHEMA>.CUSTOMERS	Package	Package, Interface
CUSTOMER	Table	Table
<DEFAULT SCHEMA>.ALL_CUSTOMERS	View	View
<DEFAULT SCHEMA>.CUSTOMERS.DeleteCustomerById	Procedure	Procedure interface DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS
<DEFAULT SCHEMA>.CUSTOMERS.GetAllCustomers	Procedure	Procedure interface GetAllCustomers(), Package CUSTOMERS
<DEFAULT SCHEMA>.CUSTOMERS.InsertCustomer	Procedure	Procedure interface InsertCustomer(fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS
<DEFAULT SCHEMA>.CUSTOMERS.UpdateCustomerName	Procedure	Procedure interface UpdateCustomerName(customerId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS
<DEFAULT SCHEMA>.CUSTOMERS.CheckCustomer	Function	Function interface CheckCustomer(customer_Id NUMBER) return BOOLEAN, Package CUSTOMERS
CONCAT	Function	PL/SQL System Function
<DEFAULT SCHEMA>.CUSTOMERS.GetFullName	Function	Function interface GetFullName(fname NVARCHAR2,lname NVARCHAR2) return NVARCHAR, Package CUSTOMERS
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
FNAME	Column	Virtual column
<DEFAULT SCHEMA>.ALL_CUSTOMERS.ID	Column	View column
LNAME	Column	Virtual column
BOOLEAN	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym
ID	Undefined Item
INTERGER	Undefined Item
NVARCHAR	Undefined Item

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

Name	Types	Description
<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
<DEFAULT SCHEMA>.DATA.sp_customer_List	Procedure	Procedure body sp_customer_List(), Package DATA