[Home] [Help]
2245: -- A mutating table error will occur on pay_defined_balances if a defined
2246: -- balance is inserted here, while the old version of trigger
2247: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version
2248: -- of the trigger prevents this error by setting a global in the trigger
2249: -- before the call to hrdyndbi.new_defined_balance.
2250: -- However, when running a patch triggers are pretty much the last things to
2251: -- be run, so it is possible that defined balances could be inserted using the
2252: -- new package code, but with the trigger missing. Hence the global will be
2253: -- set here also.
2252: -- new package code, but with the trigger missing. Hence the global will be
2253: -- set here also.
2254: -- The global is basically guaranteeing that the save_run_balance flag will
2255: -- be set when the row is inserted below, if it can be defaulted.
2256: -- hrdyndbi.new_defined_balance will attempt to update the flag if it is not
2257: -- set providing the global is false. The update is required for existing
2258: -- defined balances when default have subsequently been set.
2259: --
2260: hrdyndbi.g_trigger_dfb_ari := true;
2256: -- hrdyndbi.new_defined_balance will attempt to update the flag if it is not
2257: -- set providing the global is false. The update is required for existing
2258: -- defined balances when default have subsequently been set.
2259: --
2260: hrdyndbi.g_trigger_dfb_ari := true;
2261: --
2262: -- Create defined balance
2263: --
2264: insert into pay_defined_balances