ITPub博客

首页 > 数据库 > Oracle > How to invoke Standard Choose Organizations Form From your form

How to invoke Standard Choose Organizations Form From your form

原创 Oracle 作者:pan_tian 时间:2014-07-03 12:20:39 0 删除 编辑

Step1: Create 4 parameters in your custom form,ORG_ID,ORG_CODE,ORG_NAME,CHART_OF_ACCOUNTS_ID

Attributes like below

Step2: Pre-Form Trigger, call FND_ORG.CHOOSE_ORG;

(FND_ORG.CHOOSE_ORG定义在FNDSQF.pll文件中)

And you are all set, the list of Orgs appearing will be from the Organization Access defined for the current responsibility.



------------------------------------------------------------------------------------------------------

FND_ORG.CHOOSE_ORG

VariableDescription
Summary
procedure  FND_ORG.CHOOSE_ORG(
		allow_cancel   IN    boolean    default FALSE);
DescriptionCall this procedure in PRE-FORM to ensure the organization parameters are set. If the local form has no organization parameters passed, the global defaults are used. If the global organization defaults are not set, the procedure opens the organization LOV to force an organization selection.
VariableDescription
allow_cancelAllow cancelation of the LOV without forcing a choice. The default is FALSE.


<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1207633/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: [置顶] 记录、分享、积累
下一篇: OM:Over-ship Tolerance
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章