EBS运维_将时效用户的职责全部填写失效日期

--This script below will get the list of all inactive users and end date all the responsibilities assigned to them.


Declare
  --cursor to get all inactive users
  CURSOR cur_inactive_user IS
    select fu.user_id,
           fd.responsibility_id,
           fd.responsibility_application_id,
           fd.security_group_id,
           fd.start_date,
           fd.end_date
      from fnd_user fu, fnd_user_resp_groups_direct fd
     where fu.user_id = fd.user_id and (fu.end_date <
  = sysdate or fu.end_date is NOT NULL) and fd.end_date is null;


BEGIN


  FOR rec_inactive_user IN cur_inactive_user LOOP
  
    --checking if the responsibility is assigned to the user
  
    IF (fnd_user_resp_groups_api.assignment_exists(rec_inactive_user.user_id,