1182: p_grants_rec.grant_id,
1183: p_group_rec.object_id,
1184: l_statment,
1185: SYSDATE,
1186: NVL(FND_GLOBAL.user_id,-1),
1187: NVL(FND_GLOBAL.user_id,-1),
1188: SYSDATE,
1189: NVL(FND_GLOBAL.login_id, -1) ) ;
1190: ELSE
1183: p_group_rec.object_id,
1184: l_statment,
1185: SYSDATE,
1186: NVL(FND_GLOBAL.user_id,-1),
1187: NVL(FND_GLOBAL.user_id,-1),
1188: SYSDATE,
1189: NVL(FND_GLOBAL.login_id, -1) ) ;
1190: ELSE
1191: null; --simran
1185: SYSDATE,
1186: NVL(FND_GLOBAL.user_id,-1),
1187: NVL(FND_GLOBAL.user_id,-1),
1188: SYSDATE,
1189: NVL(FND_GLOBAL.login_id, -1) ) ;
1190: ELSE
1191: null; --simran
1192: --update existing
1193: -- UPDATE igs_sc_obj_grants SET grant_where = l_statment WHERE CURRENT OF c_grant_where;