How to create search/Entry screen in Oracle apps forms.
741751Jul 5 2010 — edited Jul 8 2010HI All,
I want to develop a form in such a way that if user enter the values in the master block and Tab out or if i use a button GO then all the detailed records need to be display in the detailed block field, if thers no matching data in the detailed blk then the form should allow to insert the records, basically its kind if thrs data exist in the master and details block when user enters the data the correcsponding details field needs to display, if the data not exist in master/detail block after clicking the Go buton the cursor should go to detailded block and the user can enter the data.
and currently am useing a below code in trigger when-Button-Pressed but when click Go button each and everyime its asking for the confirmation for the changes i have made (i.e want to save or not kind of)... as if the data exist then when i click on Go button it should display the detailed field or else cusor should go to detailed tab and we can insert the data.
=================================================
DECLARE
l_dte_gang_date DATE;
l_num_shift_no NUMBER;
l_num_where VARCHAR2(200);
BEGIN
l_dte_gang_date := :BLK_DATE.GANG_DATE;
l_num_shift_no := :BLK_DATE.SHIFT_No;
l_num_where := 'gang_date= '||'to_date('||''''||l_dte_gang_date||''''||')'||' and shift_no= '||l_num_shift_no;
SET_BLOCK_PROPERTY('BLK_DATE',DEFAULT_WHERE,l_num_where);
go_item('BLK_DATE.gang_date');
execute_query;
END;
SET_BLOCK_PROPERTY('BLK_DATE',DEFAULT_WHERE,l_num_where);
go_item('BLK_DATE.gang_date');
execute_query;
=======================================================
Regards,
Mustaq.