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