[Home] [Help]
5344: l_api_name CONSTANT VARCHAR2(30) := 'Delete_User_Attr';
5345: l_api_version CONSTANT NUMBER := 1.0;
5346: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
5347: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
5348: l_user_id igs_sc_usr_att_vals.user_id%TYPE;
5349: l_grant_name igs_sc_grants.grant_name%TYPE;
5350: l_return_message VARCHAR2(2000);
5351: l_message_count NUMBER(15);
5352: l_return_status VARCHAR2(30);
5364: AND gnt.grant_id = grts.grant_id;
5365:
5366: CURSOR c_get_user_id IS
5367: SELECT uval.user_id
5368: FROM igs_sc_usr_att_vals uval
5369: WHERE uval.user_attrib_id = p_user_attrib_id;
5370:
5371: BEGIN
5372:
5578: -- Delete the user attribute values based on the attribute ID and
5579: -- User ID provided.
5580: -- -----------------------------------------------------------------
5581: DELETE
5582: FROM igs_sc_usr_att_vals atvl
5583: WHERE ( atvl.user_id = p_user_id OR p_user_id IS NULL )
5584: AND atvl.user_attrib_id = p_user_attrib_id;
5585:
5586: -- -----------------------------------------------------------------
7783: Table list :
7784:
7785: IGS_SC_USR_ATTRIBS user_attrib_id
7786:
7787: IGS_SC_USR_ATT_VALS user_id ,user_attrib_id
7788:
7789: IGS_SC_OBJ_GROUPS obj_group_id
7790:
7791: IGS_SC_OBJECTS object_id,obj_group_id
7884:
7885: -- Update all tables
7886:
7887: UPDATE IGS_SC_GRANT_CONDS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;
7888: UPDATE IGS_SC_USR_ATT_VALS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;
7889:
7890: -- Update table itself
7891: UPDATE igs_sc_usr_attribs SET user_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_usr_attribs_c;
7892: