随笔分类 - EBS - WorkFlow
摘要:表单名称:MYFORM数据块名称:MYBLOCK第一步:在表单中加入参数:WF_ITEMKEYMYBLOCK的数据来源中必须有WF_ITEMKEY这个字段。修改或添加数据块级触发器:WHEN-NEW-BLOCK-INSTANCEif :Parameter.wf_itemkey is not nullthen declare ls_where varchar2(1000); ls_this_where varchar2(1000); begin ls_where := GET_BLOCK_PROPERTY(MYBLOCK,DEFAULT_WHERE); if ls_where is null t
阅读全文
摘要:代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1DECLARE2l_item_keyVARCHAR2(30):='CW_WF_DEMO_002';--项目关键字,唯一的3l_user_item_keyVARCHAR2(30):='CW_WF_D...
阅读全文