This discussion is archived
5 Replies Latest reply: Sep 27, 2013 6:30 AM by 1001953 RSS

Working with tabular forms

1001953 Newbie
Currently Being Moderated

Hi,

 

I want a tabular form on a table in which I can update some of the fields,along with some dynamic actions of disabling some fields and some validations.

 

I tried creating tabular form using the wizard, but here update process MRU is created by default and even if the checkbox is checked or not, updates can be done by modifying the data.

What I need is checking the checkbox and modifying the information, and only the checked records should be modified.

 

I tried creating a manual tabular form and creating a process for updation ,but even if I check the third row and update values, the values are updated with first row values.

The manualtabular form looks like

 

select apex_item.checkbox(1,pa_num,'UNCHECKED') "Select Projects",

org,

PA_NUM,

PROJECT,

SECTOR,

apex_item.select_list(6,STATUS,'YES;YES,NO;NO') "PROCESS_STATUS",

apex_item.text(7,first_name,10) first_name,

apex_item.text(8,last_name,10) last_name

from "LIST"

 

and the process looks like

begin

for i in 1..apex_application.g_f01.count

loop           

    update list

    set STATUS= apex_application.g_f06(i), first_name=apex_application.g_f07

        last_name=apex_application.g_f08(i)

        where pa_number= apex_application.g_f01(i);  

end loop; 

commit;

end;

 

i also tried with assigning apex_application.g_f01(i) into vrow and using vrow instead of i, but then I get an error as no data found.

Can anyone help.

 

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points