6560:
6561: ELSE
6562:
6563: DELETE
6564: FROM igs_sc_obj_grants objs
6565: WHERE objs.grant_id = p_grant_id;
6566:
6567: UPDATE igs_sc_grants grts
6568: SET grts.locked_flag = l_locked_flag_value
7797: IGS_SC_OBJ_ATTRIBS obj_group_id ,obj_attrib_id
7798:
7799: IGS_SC_OBJ_ATT_VALS object_id,obj_attrib_id
7800:
7801: IGS_SC_OBJ_GRANTS grant_id,object_id
7802:
7803: IGS_SC_GRANTS grant_id,user_group_id,obj_group_id ,function_id
7804:
7805: IGS_SC_GRANT_CONDS grant_id,obj_attrib_id,user_attrib_id
7860:
7861: IF igs_sc_grants_rec.grant_id <> l_current_seq THEN
7862:
7863: -- Update all tables
7864: UPDATE IGS_SC_OBJ_GRANTS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7865:
7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7867:
7868: -- Update table itself