APPS.IBC_GRANT_GROUPS_PKG dependencies on IBC_GRANT_GROUPS

Line 1: PACKAGE BODY Ibc_Grant_Groups_Pkg AS

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

Line 20: CURSOR C IS SELECT ROWID FROM IBC_GRANT_GROUPS

16: p_LAST_UPDATE_DATE IN DATE,
17: p_LAST_UPDATED_BY IN NUMBER,
18: p_LAST_UPDATE_LOGIN IN NUMBER
19: ) IS
20: CURSOR C IS SELECT ROWID FROM IBC_GRANT_GROUPS
21: WHERE GRANT_GROUP_ID = P_GRANT_GROUP_ID
22: ;
23: BEGIN
24: INSERT INTO IBC_GRANT_GROUPS (

Line 24: INSERT INTO IBC_GRANT_GROUPS (

20: CURSOR C IS SELECT ROWID FROM IBC_GRANT_GROUPS
21: WHERE GRANT_GROUP_ID = P_GRANT_GROUP_ID
22: ;
23: BEGIN
24: INSERT INTO IBC_GRANT_GROUPS (
25: OBJECT_VERSION_NUMBER,
26: GRANT_GROUP_ID,
27: CREATION_DATE,
28: CREATED_BY,

Line 58: FROM IBC_GRANT_GROUPS

54: P_OBJECT_VERSION_NUMBER IN NUMBER
55: ) IS
56: CURSOR c IS SELECT
57: OBJECT_VERSION_NUMBER
58: FROM IBC_GRANT_GROUPS
59: WHERE GRANT_GROUP_ID = P_GRANT_GROUP_ID
60: FOR UPDATE OF GRANT_GROUP_ID NOWAIT;
61: recinfo c%ROWTYPE;
62:

Line 91: UPDATE IBC_GRANT_GROUPS SET

87: p_LAST_UPDATE_DATE IN DATE,
88: p_LAST_UPDATE_LOGIN IN NUMBER
89: ) IS
90: BEGIN
91: UPDATE IBC_GRANT_GROUPS SET
92: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
93: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
94: NULL, SYSDATE, p_last_update_date),
95: last_updated_by = DECODE(p_last_updated_by, FND_API.G_MISS_NUM,

Line 118: DELETE FROM IBC_GRANT_GROUPS

114: P_GRANT_GROUP_ID IN NUMBER
115: ) IS
116: BEGIN
117:
118: DELETE FROM IBC_GRANT_GROUPS
119: WHERE GRANT_GROUP_ID = P_GRANT_GROUP_ID;
120:
121: IF (SQL%NOTFOUND) THEN
122: RAISE NO_DATA_FOUND;

Line 126: END Ibc_Grant_Groups_Pkg;

122: RAISE NO_DATA_FOUND;
123: END IF;
124: END DELETE_ROW;
125:
126: END Ibc_Grant_Groups_Pkg;