1 PACKAGE Ibc_Object_Permissions_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctopes.pls 115.1 2002/11/13 23:47:14 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 PROCEDURE INSERT_ROW (
10 X_ROWID OUT NOCOPY VARCHAR2,
11 P_OBJECT_ID IN NUMBER,
12 P_PERMISSIONS_LOOKUP_TYPE IN VARCHAR2,
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 PROCEDURE LOCK_ROW (
20 P_OBJECT_ID IN NUMBER,
21 P_PERMISSIONS_LOOKUP_TYPE IN VARCHAR2,
22 P_OBJECT_VERSION_NUMBER IN NUMBER
23 );
24 PROCEDURE UPDATE_ROW (
25 P_OBJECT_ID IN NUMBER,
26 P_PERMISSIONS_LOOKUP_TYPE IN VARCHAR2,
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 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
31 );
32 PROCEDURE DELETE_ROW (
33 P_OBJECT_ID IN NUMBER
34 );
35
36 PROCEDURE LOAD_ROW (
37 p_object_id NUMBER,
38 p_PERMISSIONS_LOOKUP_TYPE VARCHAR2,
39 p_OWNER IN VARCHAR2);
40
41 END Ibc_Object_Permissions_Pkg;