[Home] [Help]
2261: -- A mutating table error will occur on pay_defined_balances if a defined
2262: -- balance is inserted here, while the old version of trigger
2263: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version
2264: -- of the trigger prevents this error by setting a global in the trigger
2265: -- before the call to hrdyndbi.new_defined_balance.
2266: -- However, when running a patch triggers are pretty much the last things to
2267: -- be run, so it is possible that defined balances could be inserted using the
2268: -- new package code, but with the trigger missing. Hence the global will be
2269: -- set here also.
2268: -- new package code, but with the trigger missing. Hence the global will be
2269: -- set here also.
2270: -- The global is basically guaranteeing that the save_run_balance flag will
2271: -- be set when the row is inserted below, if it can be defaulted.
2272: -- hrdyndbi.new_defined_balance will attempt to update the flag if it is not
2273: -- set providing the global is false. The update is required for existing
2274: -- defined balances when default have subsequently been set.
2275: --
2276: hrdyndbi.g_trigger_dfb_ari := true;
2272: -- hrdyndbi.new_defined_balance will attempt to update the flag if it is not
2273: -- set providing the global is false. The update is required for existing
2274: -- defined balances when default have subsequently been set.
2275: --
2276: hrdyndbi.g_trigger_dfb_ari := true;
2277: --
2278: -- Create defined balance
2279: --
2280: insert into pay_defined_balances