This seems like it should be easy but I cannot figure it out. I want to create a custom event for the purchase_order_line_tab using the execute online sql action. The goal is when a PO line is entered, use the value from one field, use that in a function to return a value and insert that value into another field for the same PO line. For a test I can just hard code the value for now. If I was just creating a trigger I would do something like below. Any suggestion on what I need to do to get this to work.
declare
a_ varchar2(20);
begin
a_ := 'Test Result';
:NEW.part_revision := a_;
end;
Thanks
Phil
Best answer by asanka
View original