626:
627:
628: /* Clean up staging. Delete for online, truncate for batch */
629: /* Also chean up the following tables: */
630: /* hz_imp_osr_change */
631: /* HZ_IMP_INT_DEDUP_RESULTS */
632: /* HZ_IMP_TMP_REL_END_DATE */
633: PROCEDURE CLEANUP_STAGING(
634: P_BATCH_ID IN NUMBER,
698: AND batch_mode_flag = P_BATCH_MODE_FLAG;
699:
700: END IF;
701:
702: DELETE hz_imp_osr_change WHERE batch_id = P_BATCH_ID;
703: --DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = P_BATCH_ID;
704: DELETE HZ_IMP_TMP_REL_END_DATE WHERE batch_id = P_BATCH_ID;
705:
706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN