Oracle Forms

Hi all,

My requirement is when I give order number in header level in Oracle Apps Form, i want the lines to be displayed in lines block.

I have written the query and a cursor.

The Query returns 6 lines when passing the Order Number.

But when i use the following code in forms, the form returns only one line in the lines block.

BEGIN
first_record;
for i in xx_cur
loop
:REQUEST.CUSTOMER_NUMBER := i.party_number;
:REQUEST.CUSTOMER_NAME := i.party_name;

If :system.last_record = 'TRUE'
Then
Exit;
ELSE
next_record;
End if;
end loop;

END;

If i use the above code only the first line gets displayed in the form.

If i didnt use the system_last_record condition the 6 lines are displaying.
--If :system.last_record = 'TRUE'
--Then
--Exit;
--ELSE
next_record;
--End if;
end loop;

END;

Y the :system.last_record is not working.

Please help me to solve this issue.

Thanks in Advance,
Jegan