eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_TMP_REL_END_DATE

Line 423: insert into hz_imp_tmp_rel_end_date(batch_id, sub_orig_system_reference, relationship_id, directional_flag, int_row_id,

419: CLOSE dup_code_assignments;
420:
421: -- Bug 4398179 end dating DNB old relationships
422: IF P_OS = 'DNB' THEN
423: insert into hz_imp_tmp_rel_end_date(batch_id, sub_orig_system_reference, relationship_id, directional_flag, int_row_id,
424: creation_date, created_by, last_update_date, last_updated_by)
425: SELECT /*+ parallel(rs) parallel(r) full(rs) leading(rs) use_nl(r) */
426: P_BATCH_ID, rs.sub_orig_system_reference, r.relationship_id,
427: r.directional_flag, rs.int_row_id int_row_id,

Line 450: insert into hz_imp_tmp_rel_end_date(batch_id, sub_orig_system_reference, relationship_id, directional_flag, int_row_id,

446: AND P_SYSDATE > r.start_date
447: AND P_SYSDATE <= nvl(r.end_date, TO_DATE('31-12-4712 00:00:01', 'DD-MM-YYYY HH24:MI:SS'))
448: AND r.actual_content_source='DNB';
449:
450: insert into hz_imp_tmp_rel_end_date(batch_id, sub_orig_system_reference, relationship_id, directional_flag, int_row_id,
451: creation_date, created_by, last_update_date, last_updated_by)
452: SELECT batch_id, sub_orig_system_reference, relationship_id, decode(directional_flag,'B','F','F','B'), int_row_id,
453: creation_date, created_by, last_update_date, last_updated_by
454: FROM hz_imp_tmp_rel_end_date WHERE batch_id=P_BATCH_ID;

Line 454: FROM hz_imp_tmp_rel_end_date WHERE batch_id=P_BATCH_ID;

450: insert into hz_imp_tmp_rel_end_date(batch_id, sub_orig_system_reference, relationship_id, directional_flag, int_row_id,
451: creation_date, created_by, last_update_date, last_updated_by)
452: SELECT batch_id, sub_orig_system_reference, relationship_id, decode(directional_flag,'B','F','F','B'), int_row_id,
453: creation_date, created_by, last_update_date, last_updated_by
454: FROM hz_imp_tmp_rel_end_date WHERE batch_id=P_BATCH_ID;
455: END IF;
456:
457: /* Records in hz_tmp_errors for global validations will be ignored when
458: copy from tmp error to permanent error table. Insert into tmp errors table

Line 632: /* HZ_IMP_TMP_REL_END_DATE */

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,
635: P_BATCH_MODE_FLAG IN VARCHAR2
636: ) IS

Line 704: DELETE HZ_IMP_TMP_REL_END_DATE WHERE batch_id = P_BATCH_ID;

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
707: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()-',
708: p_prefix=>'',