APPLOGPK

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   APPLOGPK

Procedures

Name	Description
ChangedSalary	Procedure body ChangedSalary(employeeId NUMBER,newSalary NUMBER), Package APPLOGPK
LogCleaner	Procedure body LogCleaner(), Package APPLOGPK
LogDeletingSalesOrderItem	Procedure body LogDeletingSalesOrderItem(saleOrderItemId NUMBER), Package APPLOGPK

Functions

Name	Description
GetActionId	Function body GetActionId(actionName NVARCHAR2) return GetActionId, Package APPLOGPK
GetActionName	Function body GetActionName(actionId INTEGER) return GetActionName, Package APPLOGPK

Types

No Data

Cursors

Name	Definition
No Data

Variables and Constants and their Impact Analysis

Name	Types	Value
actionId	Variable
Impact Analysis:	Object calling \"actionId\" Object Type <DEFAULT SCHEMA>.APPLOGPK.GetActionId Function
actionName	Variable
Impact Analysis:	Object calling \"actionName\" Object Type <DEFAULT SCHEMA>.APPLOGPK.GetActionName Function
msg	Variable
Impact Analysis:	Object calling \"msg\" Object Type <DEFAULT SCHEMA>.APPLOGPK.ChangedSalary Procedure <DEFAULT SCHEMA>.APPLOGPK.ChangedSalary.Insert Insert Statement
msg	Variable
Impact Analysis:	Object calling \"msg\" Object Type <DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem Procedure <DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem.Insert Insert Statement
title	Variable
Impact Analysis:	Object calling \"title\" Object Type <DEFAULT SCHEMA>.APPLOGPK.ChangedSalary Procedure <DEFAULT SCHEMA>.APPLOGPK.ChangedSalary.Insert Insert Statement
title	Variable
Impact Analysis:	Object calling \"title\" Object Type <DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem Procedure <DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem.Insert Insert Statement

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

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK	Package	Package, Interface
<DEFAULT SCHEMA>.APPLOG	Table	Table
<DEFAULT SCHEMA>.APPLOGPK.ChangedSalary	Procedure	Procedure interface ChangedSalary(employeeId NUMBER,newSalary NUMBER), Package APPLOGPK
<DEFAULT SCHEMA>.APPLOGPK.LogCleaner	Procedure	Procedure interface LogCleaner(), Package APPLOGPK
<DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem	Procedure	Procedure interface LogDeletingSalesOrderItem(saleOrderItemId NUMBER), Package APPLOGPK
CONCAT	Function	PL/SQL System Function
<DEFAULT SCHEMA>.APPLOGPK.GetActionId	Function	Function interface GetActionId(actionName NVARCHAR2) return INTEGER, Package APPLOGPK
<DEFAULT SCHEMA>.APPLOGPK.GetActionName	Function	Function interface GetActionName(actionId INTERGER) return NVARCHAR2, Package APPLOGPK
SYSDATE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.APPLOG.ACTION	Column	Column
<DEFAULT SCHEMA>.APPLOG.EMPLOYEE_ID	Column	Column
<DEFAULT SCHEMA>.APPLOG.LOG_DATE	Column	Column
<DEFAULT SCHEMA>.APPLOG.MESSAGE	Column	Column
<DEFAULT SCHEMA>.APPLOG.TITLE	Column	Column
INTEGER	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

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

Name	Types	Description
<DEFAULT SCHEMA>.LOG_SALARY_INCREASE	Trigger	Simple Trigger of AFTER "UPDATE ON EMPLOYEE"
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS	Trigger	Simple Trigger of BEFORE "DELETE on sales_order_items"
<DEFAULT SCHEMA>.INSERTPRODUCT.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message) VALUES (SYSDATE,AppLogPk.GetActionId('INS PRODU
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,APPLOGPK.GetActionI