摘要:1.List E-Business Suite Profile Option Values For All LevelsSELECT p.profile_option_name SHORT_NAME, n.user_profile_option_name NAME, decode(v.level_id, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, 'User', 10005, 'Server', 10006, 'O 阅读全文
posted @ 2013-03-12 16:31 郭振斌 阅读 (3751) 评论 (0) 编辑
摘要:SyntaxFND_PROFILE.SAVE(<Profile_Option_Name>, <Profile_Option_Value>, <Level SITE/APPL/RESP/USER>, <Level_Value>, <Level_Value_App_id>);ExampleSET SERVEROUTPUT ON SIZE 1000000 DECLARE l_user_id NUMBER; l_resp_id NUMBER; l_resp_app_id NUMBER; l_success BOOLEAN; BEGIN l_u 阅读全文
posted @ 2013-03-12 16:16 郭振斌 阅读 (870) 评论 (0) 编辑