Create LOV dynamically
615670Feb 5 2008 — edited Feb 8 2008I am trying to create a lov dynamically with a new dynamically created record group and want to set list of values property for a text field in the form through custom.pll.
How to achieve this?
v_lov lov;
v_record_group_id recordgroup;
v_record_group_id := create_group_from_query('REC_GROUP',
'SELECT *...');
i := populate_group(v_record_group_id );
v_lov = find_lov ('LOV_NAME');
-- above line is the problem??? if lov is already existing, i mean in design time
-- its easy, but want to create it at runtime, how to do this?
set_lov_property(v_lov, group_name, 'XX_CUSTOMER_GROUP');
Any help on this is highly appreciated.
Thanks
CM