Re: Help please: LOV populates on parent window

Hi,

I have some suggestions, but I don't know if they would help, because your information is a little bit limited.

• Is the scope on the fields in block 'DEFINE_PACKAGE'? Not sure if you can achieve that by using 'go_block' only. Are the items enterable?
• How is the column mapping defined for the LOV (Properties)? I.e. if you use the same LOV for populating the items in 'ITEM_MAIN' they might map to the items in that window.

HTH

--
H. Hultink
Software Engineer
Stoas, Division IOAL
Wageningen, The Netherlands
"Activating Knowledge"
http://www.stoas.nl

e-mail: hhu_at_stopspam.stoas.nl

"MJIANG" <mjiang_at_uponorhsdna.com> wrote in message
news:10d5bf0.0212301204.7f521832_at_posting.google.com...


> I am modifying a custom form. There is a button on parent

> window"Item_Main" to call anther child window"Define_Package". The

> code for WHEN-BUTTON-PRESSED is

> app_custom.open_window('DEFINE_PACKAGE');

>

> Code for procedure Open_window in package app_custom is

>

> procedure open_window(wnd in varchar2) is

> begin

> if (wnd = 'ITEM_MAIN') then

> app_window.set_window_position('ITEM_MAIN', 'FIRST_WINDOW');

> go_block('ITEM_MAIN');

> elsif (wnd = 'DEFINE_PACKAGE') then

> app_window.set_window_position('DEFINE_PACKAGE','CASCADE','ITEM_MAIN');

> go_block('DEFINE_PACKAGE');

> set_window_property('DEFINE_PACKAGE', VISIBLE, PROPERTY_TRUE);

> clear_block;

> end if;

> end open_window;

>

> The problem is when I use LOV to populate fields on window

> "Define_pacage", the value comes up in fields on parent window

> Item_Main. The two windows have the same fields(Package Type,

> description). LOV is based on record group. Record group query code is

> select package_type,description,package_type_id from xx_package_types

> order by package_type

>

> Any ideas to fix the problem? Thanks in advance.