APPS.IBC_GRANTS_PKG dependencies on IBC_GRANTS

Line 1: PACKAGE BODY Ibc_Grants_Pkg AS

1: PACKAGE BODY Ibc_Grants_Pkg AS
2: /* $Header: ibctgntb.pls 115.1 2002/11/13 23:46:40 vicho ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

Line 29: CURSOR C IS SELECT ROWID FROM IBC_GRANTS

25: p_LAST_UPDATE_DATE IN DATE,
26: p_LAST_UPDATED_BY IN NUMBER,
27: p_LAST_UPDATE_LOGIN IN NUMBER
28: ) IS
29: CURSOR C IS SELECT ROWID FROM IBC_GRANTS
30: WHERE GRANT_ID = P_GRANT_ID
31: ;
32: BEGIN
33: INSERT INTO IBC_GRANTS (

Line 33: INSERT INTO IBC_GRANTS (

29: CURSOR C IS SELECT ROWID FROM IBC_GRANTS
30: WHERE GRANT_ID = P_GRANT_ID
31: ;
32: BEGIN
33: INSERT INTO IBC_GRANTS (
34: PERMISSION_CODE,
35: GRANTEE_RESOURCE_ID,
36: GRANTEE_USER_ID,
37: GRANTEE_RESOURCE_TYPE,

Line 103: FROM IBC_GRANTS

99: GRANT_LEVEL,
100: CASCADE_FLAG,
101: OBJECT_VERSION_NUMBER,
102: OBJECT_ID
103: FROM IBC_GRANTS
104: WHERE GRANT_ID = P_GRANT_ID
105: FOR UPDATE OF GRANT_ID NOWAIT;
106: recinfo c%ROWTYPE;
107:

Line 153: UPDATE IBC_GRANTS SET

149: p_LAST_UPDATE_DATE IN DATE,
150: p_LAST_UPDATE_LOGIN IN NUMBER
151: ) IS
152: BEGIN
153: UPDATE IBC_GRANTS SET
154: PERMISSION_CODE = P_PERMISSION_CODE,
155: GRANTEE_RESOURCE_ID = P_GRANTEE_RESOURCE_ID,
156: GRANTEE_USER_ID = P_GRANTEE_USER_ID,
157: GRANTEE_RESOURCE_TYPE = P_GRANTEE_RESOURCE_TYPE,

Line 189: DELETE FROM IBC_GRANTS

185: P_GRANT_ID IN NUMBER
186: ) IS
187: BEGIN
188:
189: DELETE FROM IBC_GRANTS
190: WHERE GRANT_ID = P_GRANT_ID;
191:
192: IF (SQL%NOTFOUND) THEN
193: RAISE NO_DATA_FOUND;

Line 197: END Ibc_Grants_Pkg;

193: RAISE NO_DATA_FOUND;
194: END IF;
195: END DELETE_ROW;
196:
197: END Ibc_Grants_Pkg;