I have an IG with an edit link that populates a form on another page. There is an aggregation/count on the IG to help me see duplicate applications. I do not want to prevent dupes, the loan processors want to see the duplicates to make a determination as to which one to process. (Ergo, I'm not using the automatic DML process for the IG or the Form)
When they click on edit, they go to another page that is a form, laid out with a flow to help them see relevant data. They want to edit three fields on the form. So I have this code to write their changes back to their table. (Rowid is my PK.)
begin
case :APEX$ROW_STATUS
when 'C' then
insert into PLP_PLUSLOANPROC_X ( PLP_USER_ID, PLP_COMMENTS, PLP_COMPLETED_STATUS )
values ( :PLP_USER_ID, :PLP_COMMENTS, :PLP_COMPLETED_STATUS )
returning rowid into :ROWID;
when 'U' then
update PLP_PLUSLOANPROC_X
set PLP_USER_ID = :PLP_USER_ID,
PLP_COMMENTS = :PLP_COMMENTS,
PLP_COMPLETED_STATUS = :PLP_COMPLETED_STATUS
where rowid = :ROWID;
when 'D' then
delete PLP_PLUSLOANPROC_X
where rowid = :ROWID;
end case;
end;
But nothing is updating. When I use the above code on the IG page, they can edit a row in the IG, hit save and this code works properly to update the table. But from the form on another page, it's a bust. What am I doing wrong?
Thanks for any help.
Ceci