--更改职责
fnd_user_resp_groups_api.update_assignment(user_id => v_user_id
,responsibility_id => v_resp_id
,responsibility_application_id => v_appl_id
,start_date => v_user_info.start_date
,end_date => sysdate
,description => ''
);
,responsibility_id => v_resp_id
,responsibility_application_id => v_appl_id
,start_date => v_user_info.start_date
,end_date => sysdate
,description => ''
);
--增加职责
fnd_user_resp_groups_api.upload_assignment(user_id => v_user_id
,responsibility_id => v_resp_id
,responsibility_application_id => v_appl_id
,start_date => v_user_info.start_date
,end_date => sysdate
,description => ''
);
,responsibility_id => v_resp_id
,responsibility_application_id => v_appl_id
,start_date => v_user_info.start_date
,end_date => sysdate
,description => ''
);
--增加职责
fnd_user_pkg.addresp(username => v_user_info.user_name
,resp_app => v_appL_short_name
,resp_key => v_user_info.resp_key
,description => ''
,start_date => v_user_info.start_date
);
,resp_app => v_appL_short_name
,resp_key => v_user_info.resp_key
,description => ''
,start_date => v_user_info.start_date
);
--失效职责（失效日期为当天）
fnd_user_pkg.DelResp(username => v_user_name
,resp_app => v_appl_short_name
,resp_key => v_resp_key
,security_group => v_sec_group
);
,resp_app => v_appl_short_name
,resp_key => v_resp_key
,security_group => v_sec_group
);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10359218/viewspace-677435/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
