One of my client has an interesting requirement, In Sales order form when user changes the ORDER pricing date then it needs cascade with ALL existing LINES pricing date.
I tried a traditional way by using 'When New Block Instance' or 'When New Record Instance' for block LINE and added an action.
Its working good only when user enter/update the sales order line.
Cascading is not happening when there are multiple lines exist and user changing the pricing date at header
and closing the form (with out going to Line block).
In order achieve that, used BuiltIn Type to 'Execute a Procedure'.
In Procedure, used API oe_order_pub to update lines.
Thanks, Vijay
I tried a traditional way by using 'When New Block Instance' or 'When New Record Instance' for block LINE and added an action.
Cascading is not happening when there are multiple lines exist and user changing the pricing date at header
and closing the form (with out going to Line block).
In order achieve that, used BuiltIn Type to 'Execute a Procedure'.
Thanks, Vijay
Hi Mr. Vijay,
ReplyDeleteYou have done a great job. It is really very helpful and informative. By adding screenshots and giving examples you have made it an excellent guide.
Surely, it has been visited and benefitted by a lot of people. But I astonish that why no one has added any comments or apprteciations.
There is no other option except to appreciate your work.
Thanks and regards,
Mohammad Yar
Hello Vijay,
ReplyDeleteI have a similar requirement. Thank you for the screen shots and wonderful explanation.
Would you mind sharing the plsql package logic?
Thanks,
Via Form Personalization how to Loop through all the records,Example while creating item,whether user enter the all the categories or not.It is to stop user to creating item in case he/she did not enter all the categories.
ReplyDelete