211: x_err_stack := x_err_stack || '-> clear_interface_tables';
212:
213: pa_debug.debug(x_err_stage);
214:
215: DELETE FROM PA_TOP_TASKS_IT;
216: DELETE FROM PA_PROJECTS_IT;
217: DELETE FROM PA_PRJ_TYPES_IT;
218: DELETE FROM PA_EXP_TYPES_IT;
219: DELETE FROM PA_PRJ_CLASSES_IT;
333: IF (earliest_collect_time IS NOT NULL) THEN
334: /* Purge Interface table */
335: /* Project Dimension */
336: IF (collect_top_tasks_flag = 'Y') THEN
337: purge_it_OADW('PA_TOP_TASKS_IT',earliest_collect_time);
338: END IF;
339: IF (collect_lowest_tasks_flag = 'Y') THEN
340: purge_it_OADW('PA_LOWEST_TASKS_IT',earliest_collect_time);
341: END IF;
421: x_err_stack := x_err_stack || '-> purge_interface_tables';
422:
423: pa_debug.debug(x_err_stage);
424:
425: DELETE FROM PA_TOP_TASKS_IT
426: WHERE STATUS_CODE = 'T';
427:
428: DELETE FROM PA_PROJECTS_IT
429: WHERE STATUS_CODE = 'T';