Oracle之Forms开发指南--触发器段

Oracle ERP最佳技术实践 E-BUSINESS SUITE ORACLE核心应用技术 Forms开发指南

Author: Creation Date: Last Updated: Document Ref: Version:

Approvals:

黄建华

October 16, 2006 June 5, 2013

DRAFT 1A

Copy Number _____

Oracle ERP最佳技术实践 Doc Ref:

July 5, 2008

Document Control

Change Record

5

Date Author Version Change Reference 16-Oct-06 Jianhua.Huang Draft 1a No Previous Document

Reviewers

Name Position

Distribution

Copy No. Name Location 1 2 3 4 Library Master Project Library Project Manager

Note To Holders:

If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

Forms开发指南

File Ref: 171344013.doc (v. DRAFT 1A )

Company Confidential - For internal use only

Document Control ii

Oracle ERP最佳技术实践 Doc Ref:

Forms开发指南

File Ref: 171344013.doc (v. DRAFT 1A )

July 5, 2008

Contents

Document Control .................................................................................................................. ii 1.

开发背景与基础 ......................................................................................................... 2

1.1.

读者基础要求 ...................................................................................................... 2 1.2. 用户和常用工具 .................................................................................................. 2 1.3. AOL开发框架 ..................................................................................................... 2 1.4. 多组织支持 .......................................................................................................... 6 1.5. 主要实例 .............................................................................................................. 6 2.

基于EBS的Forms开发过程 ....................................................................................... 8

2.1. Form文件类型..................................................................................................... 8 2.2. Forms Builder安装 ............................................................................................. 8 2.3. 下载Template相关文件 ................................................................................... 12 2.4. 一个简单的例子.创建数据库对象 ................................................................... 14 2.5. 一个简单的例子.从模版开始设计 ................................................................... 25 2.6. 一个简单的例子.编写数据操作触发器 ........................................................... 32 2.7. 一个简单的例子.上传&编译 ............................................................................ 37 2.8. 一个简单的例子.在EBS中注册运行 ................................................................ 37 3.

参数、List、LOV、字段和记录控制、日历 ......................................................... 40

3.1. 例子：Parameter参数 ...................................................................................... 40

3.2. 例子：List值列表 ............................................................................................. 41 3.3. 例子：LOV窗口式值列表 ................................................................................ 42 3.4. 例子：字段和记录控制 .................................................................................... 44 3.5. 例子：日历 ........................................................................................................ 45 3.6. 上传&编译&运行 .............................................................................................. 46 4.

行指示符、主从块、滚动条、Stacked&Tab画布、多行文本 ............................ 47

4.1. 例子：销售订单行 ............................................................................................ 47 4.2. 例子：Master-Detail主从块 ............................................................................ 49 4.3. 例子：滚动条 .................................................................................................... 51 4.4. 例子：Stacked画布 .......................................................................................... 52 4.5. 画布小结 ............................................................................................................ 57 4.6. 例子：Tab画布 ................................................................................................. 59 4.7. 例子：控制Tab画布 ......................................................................................... 61 4.8. 例子：多行文本框 ............................................................................................ 63 5.

Lov查询、块查询、Button ..................................................................................... 64

5.1. 查询原理 ............................................................................................................ 64

5.2. 例子：Lov查询 ................................................................................................. 64 5.3.

例子：块查询 .................................................................................................... 66

Document Control iii

Company Confidential - For internal use only

Oracle ERP最佳技术实践 Doc Ref:

Forms开发指南

File Ref: 171344013.doc (v. DRAFT 1A )

July 5, 2008

5.4. 例子：Button .................................................................................................... 68 6.

触发器层次关系、常用触发器编写规范 ................................................................ 69

6.1. 理解层次关系 .................................................................................................... 69

6.2. 触发器原理 ........................................................................................................ 69 6.3. 基于EBS模版开发的触发器 ............................................................................. 70 6.4. 一些触发器的理解 ............................................................................................ 71 7.

描述性弹性域、Key弹性域、Key弹性域查询 ...................................................... 73

7.1. 描述性弹性域开发步骤 .................................................................................... 73

7.2. Key弹性域开发步骤 ......................................................................................... 76 8.

Folder、JTF Grid .................................................................................................... 79

8.1. Folder开发步骤（从头开始） ......................................................................... 79 8.2. Folder问题 ........................................................................................................ 84 8.3. Folder开发步骤（基于模版） ......................................................................... 84 8.4. JTF Grid开发步骤 ............................................................................................. 87 9.

多语言开发 ............................................................................................................... 91

9.1. 国际化支持 ........................................................................................................ 91 9.2. Form自身的多语言版本 ................................................................................... 91 9.3. 数据多语言开发步骤 ........................................................................................ 91 9.4. EBS启用新语言时的考虑 ................................................................................. 99 10.

附件开发 ................................................................................................................. 101

10.1. 关于附件 .......................................................................................................... 101 10.2. 标准附件设置 .................................................................................................. 101 11.

Javabean ................................................................................................................. 106

11.1. Form与Java ..................................................................................................... 106 11.2. 例子：Hello World ........................................................................................ 108 11.3. 例子：执行PC本地命令 ................................................................................. 111 11.4. 例子：读取PC文本文件 ................................................................................. 114 11.5. 例子：CSV通用导入 ...................................................................................... 117

12.

Form个性化 ............................................................................................................ 121 12.1. Form个性化原理 ............................................................................................. 121 12.2. 例子：修改字段Prompt ................................................................................. 122 12.3. 例子：有条件显示消息 .................................................................................. 123 12.4. 例子：调用数据库Package ............................................................................ 124 12.5. 例子：添加菜单 .............................................................................................. 124 12.6. 例子：打开功能 .............................................................................................. 125 12.7. 例子：执行查询 .............................................................................................. 126 12.8.

例子：Instance间迁移 ................................................................................... 128

13. 技巧、常用代码 ..................................................................................................... 129 13.1. Form中的变量................................................................................................. 129 13.2. 初始值、格式掩码 .......................................................................................... 129 13.3. 消息处理 .......................................................................................................... 130 13.4. Special菜单 ..................................................................................................... 130 13.5. 库存组织访问 .................................................................................................. 130 13.6. MFG_ORGANIZATION_ID相关问题 ........................................................ 131 13.7. 常用内置过程 .................................................................................................. 132 13.8.

待续 .................................................................................................................. 132

Document Control iv

Company Confidential - For internal use only

Oracle ERP最佳技术实践 Doc Ref:

July 5, 2008

附录：我开始学习Form时的笔记1，仅供参考，未必100%正确 ................................... 133 附录：我开始学习Form时的笔记2，仅供参考，未必100%正确 ................................... 136 14.

Open and Closed Issues for this Deliverable .................................................... 139 Open Issues ................................................................................................................... 139 Closed Issues ................................................................................................................ 139 Forms开发指南

File Ref: 171344013.doc (v. DRAFT 1A )

Company Confidential - For internal use only

Document Control v

本文来源：https://www.bwwdw.com/article/nmb6.html