Hi,
Under Oracle APEX 24.2.14, I have a form I want to recalculate the value of P10_TOTAL and regenerate it on the form each time anothers elements are modified. P10_TOTAL is a column in the table VE_RESERVATION I have created a DA with calculation of :P10_TOTAL:
DECLARE V_TOTAL NUMBER;
BEGIN
select (
(:p10_tarif * (:p10_nombre_adultes + :p10_nombre_enfants)) +
((to_date(:p10_date_fin_reservation, 'dd/mm/yyyy') - to_date(:p10_date_reservation, 'dd/mm/yyyy')) *
(to_number(:p10_vehicule) * nvl(to_number(:p10_nombre_vehicules), 1))) +
((to_date(:p10_date_fin_reservation, 'dd/mm/yyyy') - to_date(:p10_date_reservation, 'dd/mm/yyyy')) * nvl(TO_NUMBER(:p10_electricite), 0)) +
TO_NUMBER(:p10_don)
) INTO V_TOTAL
from dual;
:P10_TOTAL := V_TOTAL;
END;
These are the elements that triggers the DA when they are modified:
P10_HEBERGEMENT,P10_TARIF,P10_ELECTRICITE,P10_DATE_RESERVATION,P10_DATE_FIN_RESERVATION,P10_NOMBRE_ADULTES,P10_NOMBRE_ENFANTS,P10_VEHICULE,P10_NOMBRE_VEHICULES,P10_DON. See the DA:
The DA is executed, the DA also refresh the element after calculation (an alert message is displayed after its triggering). But the element P10_TOTAL type Number field is not recalculated. Also I would like this element to be displayed but not modified by the end-user.
Best regards.