Re: Refreshing Data In POST-DATABASE-COMMIT

I used a timer! it's not a bad idea after all:

DECLARE

	refresh_timer TIMER;
	time_needed NUMBER(7) := 500;

BEGIN
.
.
.

                                        XXP_UTILITIES.PO_Delete_Zero_quantities(:XXP_PURCHASE_HEADER.HEADER_ID);
.
.
.

	IF :PARAMETER.CANCREATETIMER = 1 THEN
		refresh_timer := CREATE_TIMER('refresh_timer', time_needed,
NO_REPEAT);
		:PARAMETER.CANCREATETIMER := 0;
	END IF;

END;