[Home] [Help]
167: and c.application_id=n_epbproductid
168: and (a.end_date is null or a.end_date > SYSDATE)
169: and (b.end_date is NULL or b.end_date > SYSDATE);
170:
171: -- replace from bism_groups with from zpb_account_states
172: -- where user_id = u.subject_id
173: -- and group_id = g.subject_id
174: -- and user_id <> group_id
175: cursor revokedroles is
230:
231: if b_userexists = false then
232: t_newguid := bism_utils.get_guid;
233: insert into bism_subjects (subject_id, subject_name, subject_type) values (t_newguid,each.name,'u');
234: insert into bism_groups (user_id, group_id) values(t_newguid,t_newguid);
235:
236: if (b_writetolog) then
237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
238: 'User with name '|| each.name||' has been added successfully');
410: eachgrant.granted_role||' is not a group. Users can not be added to it');
411: end if;
412: else
413: if t_subid1 is not null and t_subid2 is not null then
414: --insert into bism_groups (user_id, group_id) values(t_subid1,t_subid2);
415:
416: -- update user state to indicate a new role has been added
417: t_subname:=eachgrant.resp_sub_name;
418:
576: select subject_id into t_subid2
577: from bism_subjects
578: where subject_name = eachrevoked.gname;
579:
580: -- delete bism_groups
581: -- where user_id = t_subid1
582: -- and group_id = t_subid2;
583:
584: -- update the user state table to indicate removed role
668: and resp_id = p_resp_id
669: and business_area_id = p_business_area_id;
670:
671: --delete any existing entries for this user
672: delete from bism_groups
673: where user_id = l_subject_id
674: and user_id <> group_id;
675:
676: --exception
676: --exception
677: -- when no_data_found then
678: --do nothing
679:
680: insert into bism_groups
681: (user_id, group_id)
682: values(l_subject_id, l_group_id);
683:
684: --exception