1) Custom.pll常用代码示例
Item属性修改
i. 获取当前Form和Block的名称
PROCEDUREevent(event_nameVARCHAR2)IS
form_nameVARCHAR2(30) := name_in('system.current_form');
block_nameVARCHAR2(30) := name_in('system.cursor_block');
BEGIN
NULL;
END;
ii. 强制字段大写
app_item_property2.set_property('vendor.name', case_restriction,uppercase);
iii. 更改字段提示
app_item_property2.set_property('vendor.name', PROMPT_TEXT,'Supplier Name');
iv. 更改按钮标签
app_item_property2.set_property('vendors.details', LABEL,'More Details');
v. 更改字段背景颜色
app_item_property2.set_property('vendor.note',BACKGROUND_COLOR, 'r255g255b0');-- bright yellow
vi.