DBA Data[Home] [Help]

APPS.HZ_BATCH_IMPORT_PKG dependencies on HZ_IMP_TMP_REL_END_DATE

Line 340: /* HZ_IMP_TMP_REL_END_DATE */

336: /* Clean up staging. Delete for online, truncate for batch */
337: /* Also chean up the following tables: */
338: /* hz_imp_osr_change */
339: /* HZ_IMP_INT_DEDUP_RESULTS */
340: /* HZ_IMP_TMP_REL_END_DATE */
341: PROCEDURE CLEANUP_STAGING(
342: P_BATCH_ID IN NUMBER,
343: P_BATCH_MODE_FLAG IN VARCHAR2
344: ) IS

Line 415: DELETE HZ_IMP_TMP_REL_END_DATE WHERE batch_id = P_BATCH_ID;

411: END IF;
412:
413: DELETE hz_imp_osr_change WHERE batch_id = P_BATCH_ID;
414: --DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = P_BATCH_ID;
415: DELETE HZ_IMP_TMP_REL_END_DATE WHERE batch_id = P_BATCH_ID;
416:
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()-',
419: p_prefix=>'',