APEX

Hi All,

I am using apex_item.checkbox, apex_item.select in an interactive report. Please see below screenshot:

If i checked the 2 or 3 or 4 record and change their status to yes it still update with No because it is updating the value of first row in all the rows. I am using below process to update:

BEGIN

FOR I IN 1 .. APEX_APPLICATION.G_F01.COUNT

LOOP

  BEGIN

        UPDATE LOCK\_FILES

           SET CREATE\_PROVISION = APEX\_APPLICATION.G\_F02(I)         --,

         WHERE     SBU\_CODE = :P0\_SBU\_CODE

               AND LINE\_ID = APEX\_APPLICATION.G\_F01 (I);

        APEX\_APPLICATION.G\_PRINT\_SUCCESS\_MESSAGE :=

              APEX\_APPLICATION.G\_F02 (I)

           || '-'

           || APEX\_APPLICATION.G\_F01 (I)

           ;                                                      --,

  END;

END LOOP;

END;

My sql query is:

SELECT APEX_ITEM.CHECKBOX (p_idx => 1, p_value => LF.LINE_ID) AS TICK,

   APEX\_ITEM.SELECT\_LIST(2,LF.CREATE\_PROVISION,'Yes;Y,No;N')

      AS CREATE\_PROV,

   TCM.TOUR\_ARR\_DATE,

   TCM.TOUR\_DEP\_DATE,

   LF.LINE\_ID,

   LF.SBU\_CODE,

   LF.VERSION\_NO from LOCK\_FILES LF.

Please suggest on this.

Best Regards.