Пример использования API для добавление записи в код поиска (lookup):
declare
lx_rowid rowid;
begin
for i in (select 'TEST' as lookup_code,
'TEST' as meaning,
null as tag,
'TEST' as descr,
sysdate as start_date_active,
null as end_date_active
from dual t
)
loop
-- Call the procedure
fnd_lookup_values_pkg.insert_row(x_rowid => lx_rowid,
x_lookup_type => 'LOOKUP_TYPE_NAME',
x_security_group_id => 0,
x_view_application_id => 3,
x_lookup_code => i.lookup_code,
x_tag => i.tag,
x_attribute_category => null,
x_attribute1 => null,
x_attribute2 => null,
x_attribute3 => null,
x_attribute4 => null,
x_enabled_flag => 'Y',
x_start_date_active => i.start_date_active,
x_end_date_active => i.end_date_active,
x_territory_code => 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_meaning => i.meaning,
x_description => i.descr,
x_creation_date => sysdate,
x_created_by => -1,
x_last_update_date => sysdate,
x_last_updated_by => -1,
x_last_update_login => -1);
end loop;
commit;
end;
/
Последние комментарии