|
GetActionName
|
|
Function body GetActionName(actionId INTEGER) return GetActionName, Package APPLOGPK
Name
|
Datatype
|
Precision
|
Description
|
actionId
|
integer
|
|
INTEGER, parameter of APPLOGPK.GetActionName
|
Name
|
Types
|
Value
|
actionName
|
Variable
|
|
|
function GetActionName(actionId in integer) return nvarchar2
Is
actionName nvarchar2(20);
Begin
actionName :=
CASE actionId
WHEN 1 THEN 'NEW SAL'
WHEN 2 THEN 'DEL SOI'
WHEN 3 THEN 'Good'
WHEN 4 THEN 'Fair'
WHEN 5 THEN 'Poor'
ELSE 'Undefine'
END;
return(actionName);
end GetActionName
Name
|
Types
|
Description
|
<DEFAULT SCHEMA>.APPLOGPK.GetActionName
|
Function
|
Function interface GetActionName(actionId INTERGER) return NVARCHAR2, Package APPLOGPK
|
INTEGER
|
PL/SQL System type
|
PL/SQL System Object
|
NVARCHAR2
|
PL/SQL System type
|
PL/SQL System Object
|