| Clearing the Lines Block [message #410463] |
Sat, 27 June 2009 03:07  |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India |
Member |
|
|
Hi There,
I need small help please.
I have designed a form and registered in apps 11i.
it has headers and lines parts.
In headers user will select some customer and its site. and enters lines(ex: Sales orders)
which depends on the customer and site selected above in headers.
he enters everything and saves it.
and later he comes back and query the same . and enters diff customer and site... then i need
to clear the whole lines block. As soon as user changes the customer i need to clear the
lines block.
I have used APP_FIELD.CLEAR_FIELDS API in when-validate-item of customer in the headers block.
but it was clearging the first record of the lines block only. I need to clear all the records
of the lines block.
Thanks,
Kittu.
|
|
|
| Re: Clearing the Lines Block [message #410505 is a reply to message #410463] |
Sat, 27 June 2009 13:45  |
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
I don't know Oracle Applications, but - as you've posted the question in Forms forum, perhaps it'll help: can you not use the CLEAR_BLOCK Forms built-in?
Moreover, your "header and lines" design smells like master-detail. If that's so, then there's a possibility that you don't have to do anything but properly set master-detail relationship - Forms will do the rest.
|
|
|
| Re: Clearing the Lines Block [message #410597 is a reply to message #410505] |
Mon, 29 June 2009 03:50 |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India |
Member |
|
|
Hi Littlefoot,
Thanks for the reply.
I think for CLEAR_BLOCK... this will clears the present block....
But when i chnage in the header block lines block has to be cleared.
Yes this is the master-detail form only... but the joining is like some unique value ex: header_id....
That will not clear the things...
Thanks,
Kittu.
|
|
|
|
| Re: Clearing the Lines Block [message #410621 is a reply to message #410601] |
Mon, 29 June 2009 05:10 |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India |
Member |
|
|
Hi Vamsi,
Thanks for the reply.
When i write code in the headers block's item's validation trigger : go_block(lines_block) and clear block.Was giving error.
Thing is when i have the data entered in the headers ans lines... if i change i item in the headers... then whole lines have to be cleared.
Am new to Forms...
Kittu.
|
|
|
| Re: Clearing the Lines Block [message #410625 is a reply to message #410621] |
Mon, 29 June 2009 05:37 |
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
Restricted procedures (read about them in Forms Online Help system) can not be called from the WHEN-VALIDATE-ITEM trigger.
Once again: if master-detail relationship is correctly set, Forms engine will do the job by itself - no additional coding is required.
|
|
|
|
|
| Re: Clearing the Lines Block [message #411477 is a reply to message #411080] |
Sat, 04 July 2009 03:30 |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India |
Member |
|
|
Thanks fro reply David...
Thing is when i have the data entered in the headers and lines and save the form one number will generate... if i close the form and later i query the form with the same number generated previusly...ok... and if i change the value of one item in the headers... then whole lines have to be cleared.
Please help.
Kittu.
|
|
|
|
| Re: Clearing the Lines Block [message #413338 is a reply to message #412351] |
Wed, 15 July 2009 05:14 |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India |
Member |
|
|
David Please find my fmb file attached.
And also please let me know am i doing any mistake this this.
Am new to forms.... thats my problem.
Thanks,
Krishna.
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
