LogDeletingSalesOrderItem

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

Procedure body LogDeletingSalesOrderItem(saleOrderItemId NUMBER), Package APPLOGPK

Name	Datatype	Precision	Description
saleOrderItemId	NUMBER		NUMBER, parameter of APPLOGPK.LogDeletingSalesOrderItem

Name	Types	Value
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.LogDeletingSalesOrderItem Procedure <DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem.Insert Insert Statement

procedure LogDeletingSalesOrderItem(saleOrderItemId in NUMBER)
    is
		title nvarchar2(50);
		msg nvarchar2(50);
    begin
			
			title := concat('Delete Sale order item id: ',saleOrderItemId);
			msg := concat('Delete Sale order item id: ',saleOrderItemId);
            INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('DEL SOI'), title,msg , saleOrderItemId);

    end LogDeletingSalesOrderItem

Name	Types	Description
<DEFAULT SCHEMA>.APPLOG	Table	Table
<DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem	Procedure	Procedure interface LogDeletingSalesOrderItem(saleOrderItemId NUMBER), Package APPLOGPK
<DEFAULT SCHEMA>.APPLOGPK.GetActionId	Function	Function body GetActionId(actionName NVARCHAR2) return GetActionId, Package APPLOGPK
CONCAT	Function	PL/SQL System Function
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
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object

Name	Types	Description
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS	Trigger	Simple Trigger of BEFORE "DELETE on sales_order_items"