EBS FORM ： 多语言的 增删改锁 包

最新推荐文章于 2021-06-21 21:45:19 发布
最新推荐文章于 2021-06-21 21:45:19 发布
阅读量175 收藏
点赞数
原文链接：http://www.cnblogs.com/CiWEi-/archive/2012/01/03/2311271.html
版权

PACKAGE BODY EMAIL_HEADERS_PRIVATE IS

/*=====================================
** PROCEDURE:   insert_row()
**=====================================*/
PROCEDURE insert_row IS

  CURSOR row_id
  IS  SELECT rowid
       FROM ZZOM_USER_EMAIL_HEADERS_CZW
      WHERE HEADER_ID = :EMAIL_HEADERS.HEADER_ID;

BEGIN

  fnd_standard.set_who;

  IF :EMAIL_HEADERS.HEADER_ID IS NULL THEN
    SELECT  ZZOM_USER_EMAIL_HEADERS_S_CZW.NEXTVAL
      INTO :EMAIL_HEADERS.HEADER_ID
      FROM SYS.DUAL;
  END IF;
-----------------------------------------------
  INSERT INTO ZZOM_USER_EMAIL_HEADERS_CZW (
     HEADER_ID,
     EMAIL_TYPE,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATE_LOGIN,
     ATTRIBUTE_CATEGORY,
     ATTRIBUTE1,
     ATTRIBUTE2,
     ATTRIBUTE3,
     ATTRIBUTE4,
     ATTRIBUTE5,
     ATTRIBUTE6,
     ATTRIBUTE7,
     ATTRIBUTE8,
     ATTRIBUTE9,
     ATTRIBUTE10,
     ATTRIBUTE11,
     ATTRIBUTE12,
     ATTRIBUTE13,
     ATTRIBUTE14,
     ATTRIBUTE15)
  VALUES (
     :EMAIL_HEADERS.HEADER_ID,
     :EMAIL_HEADERS.EMAIL_TYPE,
     :EMAIL_HEADERS.CREATION_DATE,
     :EMAIL_HEADERS.CREATED_BY,
     :EMAIL_HEADERS.LAST_UPDATED_BY,
     :EMAIL_HEADERS.LAST_UPDATE_DATE,
     :EMAIL_HEADERS.LAST_UPDATE_LOGIN,
     :EMAIL_HEADERS.ATTRIBUTE_CATEGORY,
     :EMAIL_HEADERS.ATTRIBUTE1,
     :EMAIL_HEADERS.ATTRIBUTE2,
     :EMAIL_HEADERS.ATTRIBUTE3,
     :EMAIL_HEADERS.ATTRIBUTE4,
     :EMAIL_HEADERS.ATTRIBUTE5,
     :EMAIL_HEADERS.ATTRIBUTE6,
     :EMAIL_HEADERS.ATTRIBUTE7,
     :EMAIL_HEADERS.ATTRIBUTE8,
     :EMAIL_HEADERS.ATTRIBUTE9,
     :EMAIL_HEADERS.ATTRIBUTE10,
     :EMAIL_HEADERS.ATTRIBUTE11,
     :EMAIL_HEADERS.ATTRIBUTE12,
     :EMAIL_HEADERS.ATTRIBUTE13,
     :EMAIL_HEADERS.ATTRIBUTE14,
     :EMAIL_HEADERS.ATTRIBUTE15);
--Process TL table here
INSERT INTO ZZOM_USER_EMAIL_HEADERS_TL_CZW(
     HEADER_ID,
     EMAIL_TYPE,
     MEANING,
     EMAIL_DESCRIPTION,
     LANGUAGE,
     SOURCE_LANG,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATE_LOGIN,
     ATTRIBUTE_CATEGORY,
     ATTRIBUTE1,
     ATTRIBUTE2,
     ATTRIBUTE3,
     ATTRIBUTE4,
     ATTRIBUTE5,
     ATTRIBUTE6,
     ATTRIBUTE7,
     ATTRIBUTE8,
     ATTRIBUTE9,
     ATTRIBUTE10,
     ATTRIBUTE11,
     ATTRIBUTE12,
     ATTRIBUTE13,
     ATTRIBUTE14,
     ATTRIBUTE15)
select
     :EMAIL_HEADERS.HEADER_ID,
     :EMAIL_HEADERS.EMAIL_TYPE,
     :EMAIL_HEADERS.MEANING,
     :EMAIL_HEADERS.EMAIL_DESCRIPTION,
     l.language_code,
      userenv('LANG'),
     :EMAIL_HEADERS.CREATION_DATE,
     :EMAIL_HEADERS.CREATED_BY,
     :EMAIL_HEADERS.LAST_UPDATED_BY,
     :EMAIL_HEADERS.LAST_UPDATE_DATE,
     :EMAIL_HEADERS.LAST_UPDATE_LOGIN,
     :EMAIL_HEADERS.ATTRIBUTE_CATEGORY,
     :EMAIL_HEADERS.ATTRIBUTE1,
     :EMAIL_HEADERS.ATTRIBUTE2,
     :EMAIL_HEADERS.ATTRIBUTE3,
     :EMAIL_HEADERS.ATTRIBUTE4,
     :EMAIL_HEADERS.ATTRIBUTE5,
     :EMAIL_HEADERS.ATTRIBUTE6,
     :EMAIL_HEADERS.ATTRIBUTE7,
     :EMAIL_HEADERS.ATTRIBUTE8,
     :EMAIL_HEADERS.ATTRIBUTE9,
     :EMAIL_HEADERS.ATTRIBUTE10,
     :EMAIL_HEADERS.ATTRIBUTE11,
     :EMAIL_HEADERS.ATTRIBUTE12,
     :EMAIL_HEADERS.ATTRIBUTE13,
     :EMAIL_HEADERS.ATTRIBUTE14,
     :EMAIL_HEADERS.ATTRIBUTE15
FROM fnd_languages l
WHERE l.installed_flag IN ('I', 'B')
AND NOT EXISTS
(SELECT NULL
FROM ZZOM_USER_EMAIL_HEADERS_TL_CZW t
WHERE t.header_id = :EMAIL_HEADERS.HEADER_ID
AND t.LANGUAGE = l.language_code);

 


----------------------------
  OPEN row_id;
  FETCH row_id INTO :EMAIL_HEADERS.row_id;
  IF (row_id%NOTFOUND) THEN
     CLOSE row_id;
     RAISE NO_DATA_FOUND;
  END IF;
  CLOSE row_id;

END insert_row;

/*=====================================
** PROCEDURE:   lock_row()
**=====================================*/
PROCEDURE lock_row IS

  CURSOR c_row
  IS SELECT *
       FROM ZZOM_USER_EMAIL_HEADERS_CZW
      WHERE rowid = :EMAIL_HEADERS.row_id
      FOR UPDATE OF HEADER_ID NOWAIT;
  rec     c_row%rowtype;
  i NUMBER := 0;
--Process TL table here
CURSOR c1 IS
SELECT *
FROM ZZOM_USER_EMAIL_HEADERS_TL_CZW
WHERE HEADER_ID = :EMAIL_HEADERS.HEADER_ID
AND LANGUAGE = userenv('LANG')
FOR UPDATE OF HEADER_ID NOWAIT;
tlrec c1%ROWTYPE;

  ----------------------------------
BEGIN

  LOOP
    BEGIN
      i := i + 1;
      OPEN c_row;
      FETCH c_row INTO rec;
      IF (c_row%NOTFOUND) THEN
        CLOSE c_row;
        fnd_message.set_name('FND','FORM_RECORD_DELETED');
        fnd_message.error;
        RAISE FORM_TRIGGER_FAILURE;
      END IF;
      CLOSE c_row;

      IF (
              (rec.HEADER_ID = :EMAIL_HEADERS.HEADER_ID)
          AND ((rec.EMAIL_TYPE = :EMAIL_HEADERS.EMAIL_TYPE) OR
               ((rec.EMAIL_TYPE is null) AND (:EMAIL_HEADERS.EMAIL_TYPE is null)))
          AND ((rec.CREATION_DATE = :EMAIL_HEADERS.CREATION_DATE) OR
               ((rec.CREATION_DATE is null) AND (:EMAIL_HEADERS.CREATION_DATE is null)))
          AND ((rec.CREATED_BY = :EMAIL_HEADERS.CREATED_BY) OR
               ((rec.CREATED_BY is null) AND (:EMAIL_HEADERS.CREATED_BY is null)))
          AND ((rec.LAST_UPDATED_BY = :EMAIL_HEADERS.LAST_UPDATED_BY) OR
               ((rec.LAST_UPDATED_BY is null) AND (:EMAIL_HEADERS.LAST_UPDATED_BY is null)))
          AND ((rec.LAST_UPDATE_DATE = :EMAIL_HEADERS.LAST_UPDATE_DATE) OR
               ((rec.LAST_UPDATE_DATE is null) AND (:EMAIL_HEADERS.LAST_UPDATE_DATE is null)))
          AND ((rec.LAST_UPDATE_LOGIN = :EMAIL_HEADERS.LAST_UPDATE_LOGIN) OR
               ((rec.LAST_UPDATE_LOGIN is null) AND (:EMAIL_HEADERS.LAST_UPDATE_LOGIN is null)))
          AND ((rec.ATTRIBUTE_CATEGORY = :EMAIL_HEADERS.ATTRIBUTE_CATEGORY) OR
               ((rec.ATTRIBUTE_CATEGORY is null) AND (:EMAIL_HEADERS.ATTRIBUTE_CATEGORY is null)))
          AND ((rec.ATTRIBUTE1 = :EMAIL_HEADERS.ATTRIBUTE1) OR
               ((rec.ATTRIBUTE1 is null) AND (:EMAIL_HEADERS.ATTRIBUTE1 is null)))
          AND ((rec.ATTRIBUTE2 = :EMAIL_HEADERS.ATTRIBUTE2) OR
               ((rec.ATTRIBUTE2 is null) AND (:EMAIL_HEADERS.ATTRIBUTE2 is null)))
          AND ((rec.ATTRIBUTE3 = :EMAIL_HEADERS.ATTRIBUTE3) OR
               ((rec.ATTRIBUTE3 is null) AND (:EMAIL_HEADERS.ATTRIBUTE3 is null)))
          AND ((rec.ATTRIBUTE4 = :EMAIL_HEADERS.ATTRIBUTE4) OR
               ((rec.ATTRIBUTE4 is null) AND (:EMAIL_HEADERS.ATTRIBUTE4 is null)))
          AND ((rec.ATTRIBUTE5 = :EMAIL_HEADERS.ATTRIBUTE5) OR
               ((rec.ATTRIBUTE5 is null) AND (:EMAIL_HEADERS.ATTRIBUTE5 is null)))
          AND ((rec.ATTRIBUTE6 = :EMAIL_HEADERS.ATTRIBUTE6) OR
               ((rec.ATTRIBUTE6 is null) AND (:EMAIL_HEADERS.ATTRIBUTE6 is null)))
          AND ((rec.ATTRIBUTE7 = :EMAIL_HEADERS.ATTRIBUTE7) OR
               ((rec.ATTRIBUTE7 is null) AND (:EMAIL_HEADERS.ATTRIBUTE7 is null)))
          AND ((rec.ATTRIBUTE8 = :EMAIL_HEADERS.ATTRIBUTE8) OR
               ((rec.ATTRIBUTE8 is null) AND (:EMAIL_HEADERS.ATTRIBUTE8 is null)))
          AND ((rec.ATTRIBUTE9 = :EMAIL_HEADERS.ATTRIBUTE9) OR
               ((rec.ATTRIBUTE9 is null) AND (:EMAIL_HEADERS.ATTRIBUTE9 is null)))
          AND ((rec.ATTRIBUTE10 = :EMAIL_HEADERS.ATTRIBUTE10) OR
               ((rec.ATTRIBUTE10 is null) AND (:EMAIL_HEADERS.ATTRIBUTE10 is null)))
          AND ((rec.ATTRIBUTE11 = :EMAIL_HEADERS.ATTRIBUTE11) OR
               ((rec.ATTRIBUTE11 is null) AND (:EMAIL_HEADERS.ATTRIBUTE11 is null)))
          AND ((rec.ATTRIBUTE12 = :EMAIL_HEADERS.ATTRIBUTE12) OR
               ((rec.ATTRIBUTE12 is null) AND (:EMAIL_HEADERS.ATTRIBUTE12 is null)))
          AND ((rec.ATTRIBUTE13 = :EMAIL_HEADERS.ATTRIBUTE13) OR
               ((rec.ATTRIBUTE13 is null) AND (:EMAIL_HEADERS.ATTRIBUTE13 is null)))
          AND ((rec.ATTRIBUTE14 = :EMAIL_HEADERS.ATTRIBUTE14) OR
               ((rec.ATTRIBUTE14 is null) AND (:EMAIL_HEADERS.ATTRIBUTE14 is null)))
          AND ((rec.ATTRIBUTE15 = :EMAIL_HEADERS.ATTRIBUTE15) OR
               ((rec.ATTRIBUTE15 is null) AND (:EMAIL_HEADERS.ATTRIBUTE15 is null)))
      ) or(
                (tlrec.HEADER_ID = :EMAIL_HEADERS.HEADER_ID)
          AND ((tlrec.EMAIL_TYPE = :EMAIL_HEADERS.EMAIL_TYPE) OR
               ((tlrec.EMAIL_TYPE is null) AND (:EMAIL_HEADERS.EMAIL_TYPE is null)))             
          AND ((tlrec.MEANING = :EMAIL_HEADERS.MEANING) OR
               ((tlrec.MEANING is null) AND (:EMAIL_HEADERS.MEANING is null)))
          AND ((tlrec.EMAIL_DESCRIPTION = :EMAIL_HEADERS.EMAIL_DESCRIPTION) OR
               ((tlrec.EMAIL_DESCRIPTION is null) AND (:EMAIL_HEADERS.EMAIL_DESCRIPTION is null)))          
          AND ((tlrec.CREATION_DATE = :EMAIL_HEADERS.CREATION_DATE) OR
               ((tlrec.CREATION_DATE is null) AND (:EMAIL_HEADERS.CREATION_DATE is null)))
          AND ((tlrec.CREATED_BY = :EMAIL_HEADERS.CREATED_BY) OR
               ((tlrec.CREATED_BY is null) AND (:EMAIL_HEADERS.CREATED_BY is null)))
          AND ((tlrec.LAST_UPDATED_BY = :EMAIL_HEADERS.LAST_UPDATED_BY) OR
               ((tlrec.LAST_UPDATED_BY is null) AND (:EMAIL_HEADERS.LAST_UPDATED_BY is null)))
          AND ((tlrec.LAST_UPDATE_DATE = :EMAIL_HEADERS.LAST_UPDATE_DATE) OR
               ((tlrec.LAST_UPDATE_DATE is null) AND (:EMAIL_HEADERS.LAST_UPDATE_DATE is null)))
          AND ((tlrec.LAST_UPDATE_LOGIN = :EMAIL_HEADERS.LAST_UPDATE_LOGIN) OR
               ((tlrec.LAST_UPDATE_LOGIN is null) AND (:EMAIL_HEADERS.LAST_UPDATE_LOGIN is null)))
          AND ((tlrec.ATTRIBUTE_CATEGORY = :EMAIL_HEADERS.ATTRIBUTE_CATEGORY) OR
               ((tlrec.ATTRIBUTE_CATEGORY is null) AND (:EMAIL_HEADERS.ATTRIBUTE_CATEGORY is null)))
          AND ((tlrec.ATTRIBUTE1 = :EMAIL_HEADERS.ATTRIBUTE1) OR
               ((tlrec.ATTRIBUTE1 is null) AND (:EMAIL_HEADERS.ATTRIBUTE1 is null)))
          AND ((tlrec.ATTRIBUTE2 = :EMAIL_HEADERS.ATTRIBUTE2) OR
               ((tlrec.ATTRIBUTE2 is null) AND (:EMAIL_HEADERS.ATTRIBUTE2 is null)))
          AND ((tlrec.ATTRIBUTE3 = :EMAIL_HEADERS.ATTRIBUTE3) OR
               ((tlrec.ATTRIBUTE3 is null) AND (:EMAIL_HEADERS.ATTRIBUTE3 is null)))
          AND ((tlrec.ATTRIBUTE4 = :EMAIL_HEADERS.ATTRIBUTE4) OR
               ((tlrec.ATTRIBUTE4 is null) AND (:EMAIL_HEADERS.ATTRIBUTE4 is null)))
          AND ((tlrec.ATTRIBUTE5 = :EMAIL_HEADERS.ATTRIBUTE5) OR
               ((tlrec.ATTRIBUTE5 is null) AND (:EMAIL_HEADERS.ATTRIBUTE5 is null)))
          AND ((tlrec.ATTRIBUTE6 = :EMAIL_HEADERS.ATTRIBUTE6) OR
               ((tlrec.ATTRIBUTE6 is null) AND (:EMAIL_HEADERS.ATTRIBUTE6 is null)))
          AND ((tlrec.ATTRIBUTE7 = :EMAIL_HEADERS.ATTRIBUTE7) OR
               ((tlrec.ATTRIBUTE7 is null) AND (:EMAIL_HEADERS.ATTRIBUTE7 is null)))
          AND ((tlrec.ATTRIBUTE8 = :EMAIL_HEADERS.ATTRIBUTE8) OR
               ((tlrec.ATTRIBUTE8 is null) AND (:EMAIL_HEADERS.ATTRIBUTE8 is null)))
          AND ((tlrec.ATTRIBUTE9 = :EMAIL_HEADERS.ATTRIBUTE9) OR
               ((tlrec.ATTRIBUTE9 is null) AND (:EMAIL_HEADERS.ATTRIBUTE9 is null)))
          AND ((tlrec.ATTRIBUTE10 = :EMAIL_HEADERS.ATTRIBUTE10) OR
               ((tlrec.ATTRIBUTE10 is null) AND (:EMAIL_HEADERS.ATTRIBUTE10 is null)))
          AND ((tlrec.ATTRIBUTE11 = :EMAIL_HEADERS.ATTRIBUTE11) OR
               ((tlrec.ATTRIBUTE11 is null) AND (:EMAIL_HEADERS.ATTRIBUTE11 is null)))
          AND ((tlrec.ATTRIBUTE12 = :EMAIL_HEADERS.ATTRIBUTE12) OR
               ((tlrec.ATTRIBUTE12 is null) AND (:EMAIL_HEADERS.ATTRIBUTE12 is null)))
          AND ((tlrec.ATTRIBUTE13 = :EMAIL_HEADERS.ATTRIBUTE13) OR
               ((tlrec.ATTRIBUTE13 is null) AND (:EMAIL_HEADERS.ATTRIBUTE13 is null)))
          AND ((tlrec.ATTRIBUTE14 = :EMAIL_HEADERS.ATTRIBUTE14) OR
               ((tlrec.ATTRIBUTE14 is null) AND (:EMAIL_HEADERS.ATTRIBUTE14 is null)))
          AND ((tlrec.ATTRIBUTE15 = :EMAIL_HEADERS.ATTRIBUTE15) OR
               ((tlrec.ATTRIBUTE15 is null) AND (:EMAIL_HEADERS.ATTRIBUTE15 is null)))        
      )
     
     
      THEN
        RETURN;
      ELSE
        fnd_message.set_name('FND', 'FORM_RECORDORD_CHANGED');
        fnd_message.error;
        RAISE FORM_TRIGGER_FAILURE;
      END IF;

    EXCEPTION
      WHEN app_exception.record_lock_exception THEN
        app_exception.record_lock_error(i);
    END;
  END LOOP;

END lock_row;

/*=====================================
** PROCEDURE:   update_row()
**=====================================*/
PROCEDURE update_row IS
BEGIN

  fnd_standard.set_who;
--------------------------------------
  UPDATE ZZOM_USER_EMAIL_HEADERS_CZW SET
      HEADER_ID                      = :EMAIL_HEADERS.HEADER_ID,
      EMAIL_TYPE                     = :EMAIL_HEADERS.EMAIL_TYPE,
      CREATION_DATE                  = :EMAIL_HEADERS.CREATION_DATE,
      CREATED_BY                     = :EMAIL_HEADERS.CREATED_BY,
      LAST_UPDATED_BY                = :EMAIL_HEADERS.LAST_UPDATED_BY,
      LAST_UPDATE_DATE               = :EMAIL_HEADERS.LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN              = :EMAIL_HEADERS.LAST_UPDATE_LOGIN,
      ATTRIBUTE_CATEGORY             = :EMAIL_HEADERS.ATTRIBUTE_CATEGORY,
      ATTRIBUTE1                     = :EMAIL_HEADERS.ATTRIBUTE1,
      ATTRIBUTE2                     = :EMAIL_HEADERS.ATTRIBUTE2,
      ATTRIBUTE3                     = :EMAIL_HEADERS.ATTRIBUTE3,
      ATTRIBUTE4                     = :EMAIL_HEADERS.ATTRIBUTE4,
      ATTRIBUTE5                     = :EMAIL_HEADERS.ATTRIBUTE5,
      ATTRIBUTE6                     = :EMAIL_HEADERS.ATTRIBUTE6,
      ATTRIBUTE7                     = :EMAIL_HEADERS.ATTRIBUTE7,
      ATTRIBUTE8                     = :EMAIL_HEADERS.ATTRIBUTE8,
      ATTRIBUTE9                     = :EMAIL_HEADERS.ATTRIBUTE9,
      ATTRIBUTE10                    = :EMAIL_HEADERS.ATTRIBUTE10,
      ATTRIBUTE11                    = :EMAIL_HEADERS.ATTRIBUTE11,
      ATTRIBUTE12                    = :EMAIL_HEADERS.ATTRIBUTE12,
      ATTRIBUTE13                    = :EMAIL_HEADERS.ATTRIBUTE13,
      ATTRIBUTE14                    = :EMAIL_HEADERS.ATTRIBUTE14,
      ATTRIBUTE15                    = :EMAIL_HEADERS.ATTRIBUTE15
  WHERE ROWID = :EMAIL_HEADERS.row_id;
 
IF (SQL%NOTFOUND) THEN
     RAISE NO_DATA_FOUND;
  END IF;

--------------------------------------
--Process TL table here

 

UPDATE zzom_user_email_headers_tl_czw
   SET header_id          = :email_headers.header_id,
       email_type         = :email_headers.email_type,
       meaning            = :email_headers.meaning,
       email_description  = :email_headers.email_description,
       source_lang        = userenv('LANG'),
       creation_date      = :email_headers.creation_date,
       created_by         = :email_headers.created_by,
       last_updated_by    = :email_headers.last_updated_by,
       last_update_date   = :email_headers.last_update_date,
       last_update_login  = :email_headers.last_update_login,
       attribute_category = :email_headers.attribute_category,
       attribute1         = :email_headers.attribute1,
       attribute2         = :email_headers.attribute2,
       attribute3         = :email_headers.attribute3,
       attribute4         = :email_headers.attribute4,
       attribute5         = :email_headers.attribute5,
       attribute6         = :email_headers.attribute6,
       attribute7         = :email_headers.attribute7,
       attribute8         = :email_headers.attribute8,
       attribute9         = :email_headers.attribute9,
       attribute10        = :email_headers.attribute10,
       attribute11        = :email_headers.attribute11,
       attribute12        = :email_headers.attribute12,
       attribute13        = :email_headers.attribute13,
       attribute14        = :email_headers.attribute14,
       attribute15        = :email_headers.attribute15
 WHERE header_id= :email_headers.header_id
  AND userenv('LANG') IN (LANGUAGE, source_lang);

  IF (SQL%NOTFOUND) THEN
     RAISE NO_DATA_FOUND;
  END IF;

END update_row;

/*=====================================
** PROCEDURE:   delete_row()
**=====================================*/
PROCEDURE delete_row IS
BEGIN

  DELETE FROM ZZOM_USER_EMAIL_HEADERS_CZW
  WHERE HEADER_ID = :EMAIL_HEADERS.HEADER_ID;

  IF (SQL%NOTFOUND) THEN
     RAISE NO_DATA_FOUND;
  END IF;
 
  DELETE FROM ZZOM_USER_EMAIL_HEADERS_TL_CZW
  WHERE HEADER_ID = :EMAIL_HEADERS.HEADER_ID;

  IF (SQL%NOTFOUND) THEN
     RAISE NO_DATA_FOUND;
  END IF;

END delete_row;

END EMAIL_HEADERS_PRIVATE;

转载于:https://www.cnblogs.com/CiWEi-/archive/2012/01/03/2311271.html

asd132qwe1321
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Form 表单多语言维护平台 2.1.docx
01-27
Form 表单多语言维护平台 2.1.docx
ORACLE EBS FORM开发
09-05
ORACLE EBS FORM开发 ORACLE EBS FORM开发是一种基于Oracle E-Business Suite（EBS）的FORM开发技术，用于构建企业级应用程序。本文档将详细介绍Oracle EBS FORM的基本开发技能，包括画布、公式、小技巧等。 一、...
EBS多语言小地球
weixin_33730836的博客
06-03 325
EBS多语言
weixin_33849215的博客
07-02 1099
界面多语言 :登陆EBS系统时选择不同语言，系统访问不同语言文件夹下的 fmx,rdf 等文件， US/ English ZHS/ 中文 数据多语言：表中包含LANGUAGE列 用以区分该数据所属语言，建立视图（通常以_VL后缀）where条件中加上 and table_name.language = USERENV('LANG'); 消息多语言:定义消息字典时分别建立不同语言的消息,编译...
当年测试的 11 种语言版本的 EBS
Robbie Mosaic's T-Log
05-26 1720
EBS，Microsoft Essential Business Server，虽然已成了过去，但是却给我们中软资源的这些员工留下了一段苦中有甜的回忆。 记得当年，我们组中有 PM Ling，有 test lead Kevin，有四位 tester：Chuck、Afro、小斌、Job，还有我，组中唯一的 developer。 如果说自动化测试 Visual Studio 安装程序时，装
EBS Form内置函数说明
06-27
详细记录了Forms Builder的所有内置函数, 共计1313页, 方便初学者查看
EBS FORM开发模板APPSTAND、TEMPLATE
06-14
Oracle EBS（Enterprise Business Suite）是Oracle公司推出的一套全面的企业级应用套件，它包含了财务管理、供应链管理、项目管理等多个模块，旨在帮助企业实现高效运营。在EBS中，FORM开发是构建用户界面的重要部分...
EBSForm个性化详解及开发实例word原版.doc
01-27
EBS Form 个性化详解及开发实例 EBS Form 个性化是 Oracle E-Business Suite R12 中的一个功能强大且灵活的功能，它允许用户根据需要自定义 Form 的外观和行为。在本文档中，我们将详细介绍 EBS Form 个性化的基础...
【转】Form_Form Builder国际化多语言开发（案例）
qingshimoon4的博客
06-21 403
一、摘要 Oracle EBS系统是一个多语言的系统，能够实现不同语言环境登录显示不同的语言信息，系统中多语言涉及到两个主要的方面： 界面的多语言 任何给用户看到的地方，都需要实现多语言来满足不同国家和地区的使用。界面的多语言使得不同的语言环境看到不同语言的界面 基础数据的多语言 很多用户看到的数据都是通过基础设置而来的，因此不但需要实现界面的多语言，还需要实现基础数据也多语言化。数据的多语言使得不同的语言环境看到不同语言的数据 二、功能预览 当以英文环境登录系统时 (1).界面多语言：可以查
ebs form 查询
weixin_30652271的博客
10-12 221
1.使用标准查询时，item的背景不是浅蓝色 解决办法：打开when-new-record-instance触发器的属性选项板，将执行层次改为before。 2.手电筒查询，点击一次后手电筒按钮变灰 解决办法：打开块的属性选项板，设置允许查询属性为yes。 转载于:https://www.cnblogs.com/yyfebs/p/5953321.html...
利用资源文件实现窗体多语言
m0_38110784的博客
04-05 1216
如图，将Form的Localizable设为True,然后选择需要的Language比如英语 这时更改窗体控件的文本，Form下会出现.en-GB.resx资源文件,再更改Form的Language属性为中文简体，更改窗体控件的文本，Form下会出现.zn-CN.resx资源文件 修改的控件的文本存在.en-GB.resx和.zn-CN.resx中，如下图：
Form_Form Builder国际化多语言开发（案例）
weixin_33852020的博客
01-17 465
2014-05-06 Created By BaoXinjian 一、摘要 Oracle EBS系统是一个多语言的系统，能够实现不同语言环境登录显示不同的语言信息，系统中多语言涉及到两个主要的方面： 1. 界面的多语言 任何给用户看到的地方，都需要实现多语言来满足不同国家和地区的使用。界面的多语言使得不同的语言环境看到不同语言的界面 2. 基础数据的多语言 很多用户看到的数据都是通...
OAF中多语言转换开发实现步骤
专注Oracle EBS---低调的奢华
04-14 1538
Oracle EBS 12.0.0   Oracle EBS 12.0.0 开始，OA Framework的 多语言转换的实现基本上已经和一般的实现没有什么区别，大大简化了开发的复杂性。 下面是基本的开发步骤：   1，按照下面的规则为 _TL表创建一个实体对象   命名实体为TLEO，如LOOKUP_CODES_TL表被命名为LookupCodeTLEO实体名称 包括
EBS Form开发基础教程(一)
PorryLee
10-30 8652
1. 引言            由于，网上关于EBS form开发的相关资料少之又少，加上，很多东西时间长了容易忘，所谓好记性不如烂笔头，因此决定写一个连载的基础教程，一方面可以积累，有助于自身知识的储备，另一方面可以帮助想从事或者刚刚接触EBS开发工作的初学者入门，下面先来讲讲EBS开发过程中的三类用户和常用工具。     2. 三类用户         2.1 三类用户
EBS_FORM_开发:关于LOCK-ON
weixin_34120274的博客
08-17 269
假死锁问题: 留着解决以后分享问题的解决思路. 转:http://tech.it168.com/a2009/0428/274/000000274236_4.shtml 1、错误提示： 　　 　　2、原理知识： 　　2.1当我们在Forms中，试图更改block中数据的时候，Forms先发出一个对该行数据的select ... for update n...
一 创建form表单并实现后台数据的增删改查
vvvjack7的博客
02-21 4137
思路：form表单创建，提交后上传用户信息到数据库，创建后台，可实现增删改查。 1     enroll.php     <实现form表单的创建,并且可以提交到数据库中> <!DOCTYPE html> <html> <head> <meta charset = 'utf-8'/> <title>用户注...
更改EBS form bulider中英文
夏日青草
09-14 2743
使用英文版的FormBuilder ,只要更改注册表的NLS_LANG 为：              AMERICAN_AMERICA.ZHS16GBK    中文为:SIMPLIFIED CHINESE_CHINA.ZHS16GBK （位置：hkey_local_manchine\software\wow6432node\oracle\key_devsuithome1）
Oracle EBS FORM开发指南：基础与进阶技巧
"Oracle EBS FORM开发文档涵盖了基础的FORM开发流程、视图查询操作、触发器使用、堆叠画布构建、行号显示以及LOV（List of Values）和动态列表的创建方法。" Oracle EBS (Enterprise Business Suite) 的FORM开发是...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值