APPS.IGS_SC_GRANTS_PVT dependencies on IGS_SC_OBJ_GRANTS

Line 640: FROM igs_sc_obj_grants

636: -- Select of all conditions for a grant
637:
638: CURSOR c_grant_where (s_grant_id NUMBER, s_obj_id NUMBER) IS
639: SELECT grant_where
640: FROM igs_sc_obj_grants
641: WHERE object_id = s_obj_id
642: AND grant_id = s_grant_id;
643: --FOR UPDATE OF grant_where;
644:

Line 1161: DELETE FROM igs_sc_obj_grants

1157: -- Insert or update grant for an object
1158:
1159: IF l_statment IS NULL THEN
1160:
1161: DELETE FROM igs_sc_obj_grants
1162: WHERE object_id = p_group_rec.object_id AND grant_id = p_grants_rec.grant_id;
1163:
1164: END IF;
1165:

Line 1172: INSERT INTO igs_sc_obj_grants (

1168:
1169: IF c_grant_where%NOTFOUND THEN
1170:
1171: -- Insert new row
1172: INSERT INTO igs_sc_obj_grants (
1173: grant_id,
1174: object_id,
1175: grant_where,
1176: creation_date,

Line 1193: -- UPDATE igs_sc_obj_grants SET grant_where = l_statment WHERE CURRENT OF c_grant_where;

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;
1194:
1195: END IF;
1196:
1197: CLOSE c_grant_where;

Line 1246: igs_sc_obj_grants objgr,

1242: CURSOR c_grants (s_group_id NUMBER,s_object_id NUMBER, s_user_id NUMBER) IS
1243: SELECT gr.grant_id,
1244: objgr.grant_where
1245: FROM igs_sc_grants gr,
1246: igs_sc_obj_grants objgr,
1247: wf_local_user_roles rls
1248: WHERE rls.user_orig_system =g_user_orig_system
1249: AND rls.user_orig_system_id = s_user_id
1250: AND rls.role_orig_system = 'IGS'

Line 1262: igs_sc_obj_grants objgr

1258:
1259: CURSOR c_def_grant (s_group_id NUMBER,s_object_id NUMBER) IS
1260: SELECT objgr.grant_where
1261: FROM igs_sc_grants gr,
1262: igs_sc_obj_grants objgr
1263: WHERE objgr.object_id = s_object_id
1264: AND objgr.grant_id = gr.grant_id
1265: AND gr.obj_group_id = s_group_id
1266: AND gr.locked_flag ='Y'