Status Update in Interative Report

 

Step 1 :

Create Region Interative Report

SQL Query :

select
      APEX_ITEM.CHECKBOX(1,EMPNO,'UNCHECKED') selected,   
       EMPNO,
       ENAME,
       JOB,
       MGR,
       HIREDATE,
       SAL,
       COMM,
      decode( APPROVE_STUTAS,1,'APPROVE',2,'pending') APPROVE_STUTAS,
       APPROVE_BY,
       APPROVE_DATE
  from EMP;

Step 2 :

Create Process .......

Begin 
FOR i in 1..apex_application.g_f01.count 
LOOP
if apex_application.g_f01(i) is not null then 
update emp set
APPROVE_BY=:GUSER_ID,
APPROVE_DATE=SYSDATE, 
APPROVE_STUTAS=1
WHERE empno=apex_application.g_f01(i);
end if;
end loop;
end;