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