| 221 |
vnguyen |
1 |
CREATE PROCEDURE "RELEASE_MANAGER"."LOG_DAEMON_ACTION" ( nRconId IN NUMBER,
|
|
|
2 |
enumActionTypeName IN VARCHAR2,
|
|
|
3 |
nUserId IN NUMBER,
|
|
|
4 |
sAdditionalComments IN VARCHAR2 DEFAULT NULL ) IS
|
|
|
5 |
/* ---------------------------------------------------------------------------
|
|
|
6 |
Version: 3.0
|
|
|
7 |
--------------------------------------------------------------------------- */
|
|
|
8 |
|
|
|
9 |
ActionTypeId NUMBER;
|
|
|
10 |
|
|
|
11 |
BEGIN
|
|
|
12 |
|
|
|
13 |
-- Get Action Type FK
|
|
|
14 |
SELECT act.ACTTYPE_ID INTO ActionTypeId
|
|
|
15 |
FROM ACTION_TYPE act
|
|
|
16 |
WHERE act.NAME = enumActionTypeName;
|
|
|
17 |
|
|
|
18 |
|
|
|
19 |
INSERT INTO DAEMON_ACTION_LOG
|
|
|
20 |
VALUES ( nUserId, ORA_SYSDATETIME, nRconId, sAdditionalComments, ActionTypeId );
|
|
|
21 |
|
|
|
22 |
|
|
|
23 |
END Log_Daemon_Action;
|
|
|
24 |
/
|