Good Evening Community,
@"John Snyders-Oracle"
I am using APEX 5.1.0.00.45 with Oracle 12c Database
I have replicated this in My Oracle Workspace on Apex.Oracle.com
https://apex.oracle.com/pls/apex/f?p=4550:1:1666570127918:::::
Workspace: STEELE41_APEX_ORACLE
USERNAME: ORACLE_USER
PW: Pa$$word123
Application: Receipt_Log_Multiple_Payments ---> Page 2
***If you have issues logging into the Workspace And/ Or Application; Please Let Me Know ***
----------------------------------------------------------------------------------------------------------------------
The Problem I'm Looking to Solve:
Note: This is on both IGs: Payments & Receipt Lines
a User Can Select/ Enter Multiple Item IDs & Multiple Payment Types ;
If they Choose to Delete an Item I would like to Update the P2_Subtotal Field with the New Subtotal after the Row is Deleted with APEX$ROW_ACTION
....The same for when a User Deletes a Payment Type with APEX$ROW_ACTION I would like to Update the New Amount in the P2_PAYMENTS_AMOUNT Page Item
Both IGs are being Added with JS Code similar to the one in the IG CookBook; Only I'm Using Dynamic Actions
What I'm needing is for the Amounts to be Subtracted by the Amount of the Line that is being Deleted with APEX$ROW_ACTION
Screenshots Below to give a Visual:
HERE Subtotal Should be 55.00 because deleted the line with Extended Price 375
HERE Payments Total should be 55.00 Because Deleted Payment Check for 230.00
Please Let me know if you have any Questions
Regards,
DSteele41