EBS开发_导入自定义代码

78 阅读 0 评论 52 点赞

我是靠谱客的博主开朗太阳，最近开发中收集的这篇文章主要介绍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;