GetActionId

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

Function body GetActionId(actionName NVARCHAR2) return GetActionId, Package APPLOGPK

Name	Datatype	Precision	Description
actionName	nvarchar2		NVARCHAR2, parameter of APPLOGPK.GetActionId

Name	Types	Value
actionId	Variable
Impact Analysis:	Object calling \"actionId\" Object Type <DEFAULT SCHEMA>.APPLOGPK.GetActionId Function

function GetActionId(actionName in nvarchar2) return integer

	Is
		actionId integer;
	Begin
		actionId :=
		  CASE actionName
			 WHEN 'NEW SAL' THEN 1
			 WHEN 'DEL SOI' THEN 2
			 WHEN 'C' THEN 3
			 WHEN 'D' THEN 4
			 WHEN 'F' THEN 5
			 ELSE -1
		  END;
		  return(actionId);
	end GetActionId

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK.GetActionId	Function	Function interface GetActionId(actionName NVARCHAR2) return INTEGER, Package APPLOGPK
INTEGER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object

Name	Types	Description
<DEFAULT SCHEMA>.APPLOGPK.ChangedSalary.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('NEW SA
<DEFAULT SCHEMA>.APPLOGPK.LogDeletingSalesOrderItem.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,GetActionId('DEL SO
<DEFAULT SCHEMA>.EMPLOYEES.LogDeletingEmployee.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message,Employee_Id) VALUES (SYSDATE,APPLOGPK.GetActionI
<DEFAULT SCHEMA>.INSERTPRODUCT.Insert	Insert Statement	INSERT INTO AppLog (Log_date, Action, Title,Message) VALUES (SYSDATE,AppLogPk.GetActionId('INS PRODU