SALEORDER

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALEORDER

Procedures

Name	Description
DeleteOrderById	Procedure body DeleteOrderById(orderId NUMBER), Package SALEORDER
DeleteOrderItemById	Procedure body DeleteOrderItemById(orderId NUMBER), Package SALEORDER
GetAllItems	Procedure body GetAllItems(orderId NUMBER), Package SALEORDER
GetAllOrders	Procedure body GetAllOrders(), Package SALEORDER
GetOrderById	Procedure body GetOrderById(orderId NUMBER), Package SALEORDER

Functions

Name	Description
DecodeCodeId	Function body DecodeCodeId(codeId INTERGER) return DecodeCodeId, Package SALEORDER

Types

No Data

Cursors

Name	Definition
No Data

Variables and Constants and their Impact Analysis

Name	Types	Value
employeeId	Variable
No Reference found for \"employeeId\"
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.SALEORDER.GetAllItems Procedure
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.SALEORDER.GetAllOrders Procedure
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.SALEORDER.GetOrderById Procedure

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

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEES	Package	Package, Interface
<DEFAULT SCHEMA>.SALEORDER	Package	Package, Interface
<DEFAULT SCHEMA>.SALES_ORDER	Table	Table
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS	Table	Table
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE	View	View
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS	View	View
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderById	Procedure	Procedure interface DeleteOrderById(orderId NUMBER), Package SALEORDER
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderItemById	Procedure	Procedure interface DeleteOrderItemById(orderItemId NUMBER), Package SALEORDER
<DEFAULT SCHEMA>.SALEORDER.GetAllItems	Procedure	Procedure interface GetAllItems(orderId NUMBER), Package SALEORDER
<DEFAULT SCHEMA>.SALEORDER.GetAllOrders	Procedure	Procedure interface GetAllOrders(), Package SALEORDER
<DEFAULT SCHEMA>.SALEORDER.GetOrderById	Procedure	Procedure interface GetOrderById(orderId NUMBER), Package SALEORDER
DECODE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.SALEORDER.DecodeCodeId	Function	Function interface DecodeCodeId(codeId INTERGER) return NVARCHAR, Package SALEORDER
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.CUST_ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEFNAME	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEELNAME	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.FIN_CODE_ID	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.FIN_CODE_ID	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ID	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.ITEM_ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ORDER_DATE	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.ORDER_DATE	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.PROD_SIZE	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.PRODUCT_NAME	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.REGION	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.SALES_REP	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.TOTAL_HT	Column	View column
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.TOTAL_HT	Column	View column
NUMBER	PL/SQL System type	PL/SQL System Object
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym
INTERGER	Undefined Item
last_name	Undefined Item
NVARCHAR	Undefined Item
<DEFAULT SCHEMA>.SALES_ORDER.ID	Primary Key	Column
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS.ID	Primary Key	Column

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

No Data