2025: procedure purge_processed_recs(p_session_id in NUMBER,
2026: p_err_buf out NOCOPY VARCHAR2) is
2027: BEGIN
2028: p_err_buf := null;
2029: delete from ghr_mass_actions_preview
2030: WHERE mass_action_type = 'REALIGNMENT'
2031: and session_id = p_session_id;
2032: COMMIT;
2033:
2362: BEGIN
2363: g_proc := 'purge_old_data';
2364:
2365: hr_utility.set_location('Entering ' || l_proc,5);
2366: delete from ghr_mass_actions_preview
2367: WHERE mass_action_type = 'REALIGNMENT'
2368: and session_id = userenv('sessionid');
2369: COMMIT;
2370: hr_utility.set_location('Exiting ' || l_proc,10);
3148: END;
3149: END IF;
3150:
3151:
3152: insert into GHR_MASS_ACTIONS_PREVIEW
3153: (
3154: mass_action_type,
3155: --report_type,
3156: ui_type,