Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create search/Entry screen in Oracle apps forms.

741751Jul 5 2010 — edited Jul 8 2010
HI 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2010
Added on Jul 5 2010
7 comments
2,096 views