1 PACKAGE Ibc_Grant_Groups_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctggrs.pls 115.1 2002/11/13 23:46:35 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_GROUP_ID IN NUMBER,
13 P_OBJECT_VERSION_NUMBER IN NUMBER,
14 p_CREATION_DATE IN DATE DEFAULT NULL,
15 p_CREATED_BY IN NUMBER DEFAULT NULL,
16 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
17 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
18 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
19 );
20 PROCEDURE LOCK_ROW (
21 P_GRANT_GROUP_ID IN NUMBER,
22 P_OBJECT_VERSION_NUMBER IN NUMBER
23 );
24 PROCEDURE UPDATE_ROW (
25 P_GRANT_GROUP_ID IN NUMBER,
26 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL,
27 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
28 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
29 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
30 );
31 PROCEDURE DELETE_ROW (
32 P_GRANT_GROUP_ID IN NUMBER
33 );
34
35 END Ibc_Grant_Groups_Pkg;