1 PACKAGE Ibc_Grants_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctgnts.pls 115.1 2002/11/13 23:46:45 vicho ship $ */
3
4 -- MODIFICATION HISTORY
5 -- Person Date Comments
6 -- --------- ------ ------------------------------------------
7 -- vicho 11/05/2002 Remove G_MISS defaulting on UPDATE_ROW
8
9
10 PROCEDURE INSERT_ROW (
11 PX_ROWID IN OUT NOCOPY VARCHAR2,
12 P_GRANT_ID IN NUMBER,
13 P_PERMISSION_CODE IN VARCHAR2,
14 P_GRANTEE_RESOURCE_ID IN NUMBER,
15 P_GRANTEE_USER_ID IN NUMBER,
16 P_GRANTEE_RESOURCE_TYPE IN VARCHAR2,
17 P_GRANT_GROUP_ID IN NUMBER,
18 P_ACTION IN VARCHAR2,
19 P_GRANT_LEVEL IN NUMBER,
20 P_CASCADE_FLAG IN VARCHAR2,
21 P_OBJECT_VERSION_NUMBER IN NUMBER,
22 P_OBJECT_ID IN NUMBER,
23 p_CREATION_DATE IN DATE DEFAULT NULL,
24 p_CREATED_BY IN NUMBER DEFAULT NULL,
25 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
26 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
27 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL);
28 PROCEDURE LOCK_ROW (
29 P_GRANT_ID IN NUMBER,
30 P_PERMISSION_CODE IN VARCHAR2,
31 P_GRANTEE_RESOURCE_ID IN NUMBER,
32 P_GRANTEE_USER_ID IN NUMBER,
33 P_GRANTEE_RESOURCE_TYPE IN VARCHAR2,
34 P_GRANT_GROUP_ID IN NUMBER,
35 P_ACTION IN VARCHAR2,
36 P_GRANT_LEVEL IN NUMBER,
37 P_CASCADE_FLAG IN VARCHAR2,
38 P_OBJECT_VERSION_NUMBER IN NUMBER,
39 P_OBJECT_ID IN NUMBER
40 );
41 PROCEDURE UPDATE_ROW (
42 P_GRANT_ID IN NUMBER,
43 P_PERMISSION_CODE IN VARCHAR2,
44 P_GRANTEE_RESOURCE_ID IN NUMBER,
45 P_GRANTEE_USER_ID IN NUMBER,
46 P_GRANTEE_RESOURCE_TYPE IN VARCHAR2,
47 P_GRANT_GROUP_ID IN NUMBER,
48 P_ACTION IN VARCHAR2,
49 P_GRANT_LEVEL IN NUMBER,
50 P_CASCADE_FLAG IN VARCHAR2,
51 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL,
52 P_OBJECT_ID IN NUMBER,
53 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
54 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
55 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
56 );
57 PROCEDURE DELETE_ROW (
58 P_GRANT_ID IN NUMBER
59 );
60 END Ibc_Grants_Pkg;