--更改职责
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博客 ” ,链接:http://blog.itpub.net/10359218/viewspace-677435/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10359218/viewspace-677435/