[Home] [Help]
4586: l_api_version CONSTANT NUMBER := 1.0;
4587: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
4588: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
4589: l_object_id_mthd igs_sc_obj_att_mths.object_id%TYPE;
4590: l_object_id_val igs_sc_obj_att_vals.object_id%TYPE;
4591: l_return_message VARCHAR2(2000);
4592: l_message_count NUMBER(15);
4593: l_return_status VARCHAR2(30);
4594:
4601: WHERE objs.obj_attrib_id = p_obj_attrib_id;
4602:
4603: CURSOR c_get_object_id_val IS
4604: SELECT attrs.object_id
4605: FROM igs_sc_obj_att_vals attrs
4606: WHERE attrs.obj_attrib_id = p_obj_attrib_id;
4607:
4608: BEGIN
4609:
5134: -- Delete the attribute values that are associated to the attribute
5135: -- id and object id provided.
5136: -- -----------------------------------------------------------------
5137: DELETE
5138: FROM igs_sc_obj_att_vals oval
5139: WHERE oval.obj_attrib_id = p_obj_attrib_id
5140: AND oval.object_id = p_object_id;
5141:
5142: -- -----------------------------------------------------------------
7795: IGS_SC_OBJ_ATT_MTHS object_id,obj_attrib_id
7796:
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
7958: -- Update all tables
7959:
7960: UPDATE IGS_SC_OBJ_ATT_MTHS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7961:
7962: UPDATE IGS_SC_OBJ_ATT_VALS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7963:
7964: UPDATE IGS_SC_GRANT_CONDS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7965:
7966: -- Update table itself