PACKAGE: APPS.IBC_OBJECT_GRANT_GROUPS_PKG

Source

1 PACKAGE Ibc_Object_Grant_Groups_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctoggs.pls 115.2 2003/06/19 22:26:35 enunez ship $ */
3 
4 -- MODIFICATION HISTORY
5 -- Person            Date        Comments
6 -- ---------         ------      ------------------------------------------
7 -- vicho	     11/05/2002     Remove G_MISS defaulting on UPDATE_ROW
8 -- enunez     02/12/2003     Added INHERITANCE_TYPE parameters.
9 
10 PROCEDURE INSERT_ROW (
11   PX_ROWID IN OUT NOCOPY VARCHAR2,
12   P_OBJECT_GRANT_GROUP_ID IN NUMBER,
13   P_OBJECT_VERSION_NUMBER IN NUMBER,
14   P_GRANT_GROUP_ID IN NUMBER,
15   P_OBJECT_ID IN NUMBER,
16   P_INHERITED_FLAG IN VARCHAR2,
17   P_INHERITED_FROM IN NUMBER,
18   P_INSTANCE_PK1_VALUE IN VARCHAR2,
19   P_INSTANCE_PK2_VALUE IN VARCHAR2,
20   P_INSTANCE_PK3_VALUE IN VARCHAR2,
21   P_INSTANCE_PK4_VALUE IN VARCHAR2,
22   P_INSTANCE_PK5_VALUE IN VARCHAR2,
23   P_INHERITANCE_TYPE   IN VARCHAR2,
24   p_CREATION_DATE IN DATE 	  	DEFAULT NULL,
25   p_CREATED_BY IN NUMBER	  	DEFAULT NULL,
26   p_LAST_UPDATE_DATE IN DATE  		DEFAULT NULL,
27   p_LAST_UPDATED_BY IN NUMBER 		DEFAULT NULL,
28   p_LAST_UPDATE_LOGIN IN NUMBER		DEFAULT NULL);
29 
30 PROCEDURE LOCK_ROW (
31   P_OBJECT_GRANT_GROUP_ID IN NUMBER,
32   P_OBJECT_VERSION_NUMBER IN NUMBER,
33   P_GRANT_GROUP_ID IN NUMBER,
34   P_OBJECT_ID IN NUMBER,
35   P_INHERITED_FLAG IN VARCHAR2,
36   P_INHERITED_FROM IN NUMBER,
37   P_INSTANCE_PK1_VALUE IN VARCHAR2,
38   P_INSTANCE_PK2_VALUE IN VARCHAR2,
39   P_INSTANCE_PK3_VALUE IN VARCHAR2,
40   P_INSTANCE_PK4_VALUE IN VARCHAR2,
41   P_INSTANCE_PK5_VALUE IN VARCHAR2,
42   P_INHERITANCE_TYPE   IN VARCHAR2
43 );
44 
45 PROCEDURE UPDATE_ROW (
46   P_OBJECT_GRANT_GROUP_ID IN NUMBER,
47   p_OBJECT_VERSION_NUMBER    IN  NUMBER DEFAULT  NULL,
48   P_GRANT_GROUP_ID IN NUMBER,
49   P_OBJECT_ID IN NUMBER,
50   P_INHERITED_FLAG IN VARCHAR2,
51   P_INHERITED_FROM IN NUMBER,
52   P_INSTANCE_PK1_VALUE IN VARCHAR2,
53   P_INSTANCE_PK2_VALUE IN VARCHAR2,
54   P_INSTANCE_PK3_VALUE IN VARCHAR2,
55   P_INSTANCE_PK4_VALUE IN VARCHAR2,
56   P_INSTANCE_PK5_VALUE IN VARCHAR2,
57   P_INHERITANCE_TYPE   IN VARCHAR2,
58   p_LAST_UPDATED_BY    IN  NUMBER DEFAULT  NULL,
59   p_LAST_UPDATE_DATE    IN  DATE DEFAULT  NULL,
60   p_LAST_UPDATE_LOGIN    IN  NUMBER DEFAULT  NULL
61 );
62 
63 PROCEDURE DELETE_ROW (
64   P_OBJECT_GRANT_GROUP_ID IN NUMBER
65 );
66 
67 END Ibc_Object_Grant_Groups_Pkg;