This content has been marked as final. Show 1 reply
reflecting the user's changes doesn't work here because the SELECT statement has no way of remembering what the user has chosen.
'select distinct wl_level, wl_level from idt_org_derog_rule
always yields the same list ("static" if you will).
Using a report and SELECT_LIST_FROM_QUERY is the right way to go, only you need to persist the user's choice.
Are you familiar with APEX Collections? They are exactly what you are looking for.
If not, you'd have to create some imtermediate table to store the user's input row by row, and then re-select them each time. The key is to select the former value into the second parameter p_value.