EBS开发_导入自定义代码
2022/2/21 6:28:05
本文主要是介绍EBS开发_导入自定义代码,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
BEGIN
fnd_lookup_types_pkg.load_row(x_view_appsname => 'CUX',
x_lookup_type => 'CUX_PUB_YES_OR_NO',
x_application_short_name => 'CUX',
x_customization_level => 'S', --访问级别 U 用户 E 可扩展 S 系统
x_owner => 'ORACLE',
x_last_update_date => NULL,
x_meaning => upper('CUX:公用是否快码'),
x_description => '公用是否快码',
x_security_group => NULL,
x_custom_mode => NULL);
FOR c1 IN (SELECT upper('Y') lookup_code
,'是' meaning
FROM dual
UNION
SELECT upper('N') lookup_code
,'否' meaning
FROM dual
)
LOOP
fnd_lookup_values_pkg.load_row(x_lookup_type => upper('CUX_PUB_YES_OR_NO'),
x_view_appsname => 'CUX',
x_lookup_code => c1.lookup_code,
x_enabled_flag => 'Y',
x_start_date_active => Null,
x_end_date_active => NULL,
x_territory_code => NULL,
x_tag => NULL,
x_attribute_category => NULL,
x_attribute1 => NULL,
x_attribute2 => NULL,
x_attribute3 => NULL,
x_attribute4 => NULL,
x_attribute5 => NULL,
x_attribute6 => NULL,
x_attribute7 => NULL,
x_attribute8 => NULL,
x_attribute9 => NULL,
x_attribute10 => NULL,
x_attribute11 => NULL,
x_attribute12 => NULL,
x_attribute13 => NULL,
x_attribute14 => NULL,
x_attribute15 => NULL,
x_last_update_date => NULL,
x_owner => 'ORACLE',
x_meaning => c1.meaning,
x_description => NULL,
x_security_group => NULL,
x_custom_mode => upper('FORCE')); --FORCE为可更新
END LOOP;
COMMIT;
END;
这篇关于EBS开发_导入自定义代码的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-10-01基于Python+Vue开发的医院门诊预约挂号系统
- 2024-10-01基于Python+Vue开发的旅游景区管理系统
- 2024-10-01RestfulAPI入门指南:打造简单易懂的API接口
- 2024-10-01初学者指南:了解和使用Server Action
- 2024-10-01Server Component入门指南:搭建与配置详解
- 2024-10-01React 中使用 useRequest 实现数据请求
- 2024-10-01使用 golang 将ETH账户的资产平均分散到其他账户
- 2024-10-01JWT用户校验课程:从入门到实践
- 2024-10-01Server Component课程入门指南
- 2024-09-30Dnd-Kit学习:新手快速入门指南