Oracle EBS Form菜单栏增加菜单选项
方法:
1.在form级触发器when-new-form-instance添加选项初始化
form级app_special.instantiate(‘SPECIAL1′,’转明细行’);
2.在block级触发器pre_block中添加启用选项
app_special.enable(‘SPECIAL1′,property_on);
3.在Forms级上添加选项对应触发器SPECIAL1
在Form级上写选项的实际操作代码。
–添加菜单
app_special.instantiate(option_name => ‘SPECIAL2′, –添加自定义触发器事件
hint => ‘按类型数量汇总’, –新增选项名称
icon => null,
initially_enabled => false,
separator => null);
end if;
4.在package body增加监听自定义触发器事件SPECIAL2,并编写该事件所做的处理
if event_name = ‘SPECIAL2′ then
–书写该触发器所做的处理操作
–调用FORM
app_navigate.execute(function_name => ‘CUXTEST001’,
open_flag => ‘C’,
session_flag => ‘Y’,
other_params => ‘OE_ORDER_NUM = “‘ || v_oe_order_num || ‘”‘ ||
‘header_id = “‘ ||
v_header_id || ‘”‘ ||
‘user_id = “‘ || v_user_id || ‘”‘ ||
‘org_id = “‘ || v_org_id || ‘”‘);
--刘轶鹤