第三章 Oracle_EBS_个性化设置.docxVIP

十月总结二个性化总结Author:jun.zhanCreation Date:October 29, 2012Last Updated:October 29, 2012Document Ref:MD120Version:1.0Title, Subject, Last Updated Date, Reference Number, andVersion are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools-Options…View and checking the Bookmarks option in the Show region.文档控制更改记录1DateAuthorVersionChange ReferenceOctober 29, 2012Jun.zhan审阅NamePosition分发记录Copy No.NameLocationThe copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cover page.目录文档控制ii个性化调用请求,报表,存储过程1利用FORM个性化调用请求1利用FORM个性化跳转块4利用FORM个性化增加web link7Form个性化修改标准Form的LOV8利用FORM个性化插入或更新数据库11解决和未解决的问题13已解决的问题13未解决的问题13To update the table of contents, put the cursor anywhere in the table and press [F9]. To change the number of levels displayed, select the menu option InsertIndex and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.个性化调用请求,报表,存储过程本文将详细介绍个性化的应用仅作参考利用FORM个性化调用请求主要内容1)利用全局变量直接调用请求2)利用全局变量调用存储过程在调用请求Setp by Step 截图利用全局变量直接调用请求:利用全局变量调用存储过程在调用请求:????利用FORM个性化跳转块主要内容1) 利用内置直接调用块(不含From操作)2) 利用内置传参数给from,在from中做逻辑处理后跳转Setp by Step 截图利用内置直接调用块(不含From操作):???利用内置传参数给from,在from中做逻辑处理后跳转:eg:在销售订单的订单头模块的活动中启用功能销售回款计划，只有当订单为登记状态时，才允许进入。1、先在when-new-form-instance触发器中添加菜单项例子添加的是special41；如果只需要在某个特定的块启用某功能的话，在表单个性化的活动中的‘已在块中启用’选择启用的块;2、在菜单项special41触发器中校验逻辑是否成立3、在菜单项special41中启用功能。在参数中直接输入=SELL_HEADER_ID=||:ORDER.HEADER_ID ?被调用的form中处理和在from中调用function一样。a、定义parameter: sell_header_idb、在form级触发器when_new_form_instance中定义if :parameter.sell_header_id is not null thengo_block(FUNS_HEADER);DO_KEY(EXECUTE_QUERY);end if;c.在block级的pre_query中定义 PROCEDURE pre_query IS BEGINIF :