Home/Questions/Q 2858
Answered
Swarup
Swarup

Swarup

  • India
View Profile
  • 0
Professional
Asked: 2020-11-02T15:59:15+05:30

Approve all dynamically in oracle apex

  • 0

Hi Sir,

I have created a lov with Approve All,Reject All.

If i select approve all then all the status field should be approved vice versa dynamically

dynamic

    16 Answers

    1. Vinish

      Vinish

      View Profile
      Enlightened

      Create a dynamic action on the status LOV for the change event to execute PL/SQL code.

      Then add the following PL/SQL code in it:

      if :px_status_lov = 'APPROVE ALL' then
  Update table1
    set status = 'APPROVED'
  Where yourconditionColumn = :px_column;
  
  Delete from table1
    where yourconditionColumn = :px_column;
elsif :px_status_lov = 'REJECT ALL' then
  Update table1
    set status = 'REJECTED'
    Where yourconditionColumn = :px_column;
End if;

      Then create one more True action to refresh the report region below.

      • 0
    2. Vinish

      Vinish

      View Profile
      Enlightened

      If the return value of P3_STATUSALL is Approve All then you should change the if condition accordingly. Below is the code:

      if :px_status_lov = 'Approve All' then
Update table1
set status = 'APPROVED'
Where yourconditionColumn = :px_column;

Delete from table1
where yourconditionColumn = :px_column;

apex_util.set_session_state('P3_STATUSM', 'Approved');

elsif :px_status_lov = 'Reject All' then

Update table1
set status = 'REJECTED'
Where yourconditionColumn = :px_column;

apex_util.set_session_state('P3_STATUSM', 'Rejected');
end if;

      Items to submit: P3_STATUSALL,P3_PID

      Items to return: P3_STATUSM

      • 0
    3. Vinish

      Vinish

      View Profile
      Enlightened

      What event did you choose for the DA for P3_STATUSALL?

      Is the report region is being refreshed after selecting the value from P3_STATUSALL?

      • 0
    5. Vinish

      Vinish

      View Profile
      Enlightened

      It means the dynamic action on the list change event is firing. Because it refreshes the page.

      So you have to check the values returned by the STATUSM and STATUSALL lists. Also, check and update and delete statement if you specified the correct condition.

      • 0

    You must login to add an answer.