316: --
317: begin
318: -- Set the Continuous Calc override flag, so that the trigger points
319: -- are not fired.
320: pay_continuous_calc.g_override_cc := TRUE;
321: --
322:
323: hr_utility.set_location(c_indent,30);
324:
706: where eev.element_entry_id = update_ee_id
707: and (p_effective_date - 1) between
708: eev.effective_start_date and eev.effective_end_date;
709: */
710: pay_continuous_calc.g_override_cc := FALSE;
711: --
712: exception
713: when others then
714: pay_continuous_calc.g_override_cc := FALSE;
710: pay_continuous_calc.g_override_cc := FALSE;
711: --
712: exception
713: when others then
714: pay_continuous_calc.g_override_cc := FALSE;
715: raise;
716: end;
717: --
718: -- Return element_entry_id that we updated.
825: -- then set the effective_end_dates as appropriate.
826: begin
827: -- Set the Continuous Calc override flag, so that the trigger points
828: -- are not fired.
829: pay_continuous_calc.g_override_cc := TRUE;
830: --
831: delete from pay_element_entries_f pee
832: where pee.element_entry_id = stop_ee_id
833: and pee.effective_start_date > p_date_earned;
850: where eev.element_entry_id = stop_ee_id
851: and p_date_earned between
852: eev.effective_start_date and eev.effective_end_date;
853: --
854: pay_continuous_calc.g_override_cc := FALSE;
855: --
856: exception
857: when others then
858: pay_continuous_calc.g_override_cc := FALSE;
854: pay_continuous_calc.g_override_cc := FALSE;
855: --
856: exception
857: when others then
858: pay_continuous_calc.g_override_cc := FALSE;
859: raise;
860: end;
861: end stop_recurring_ee;
862: --