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_ERRORS_S

Line 151: select int_row_id, table_name, hz_imp_errors_s.nextval

147: l_table_name T_TABLE_NAME;
148: --l_debug_prefix VARCHAR2(30):= '';
149:
150: CURSOR dup_rel (p_batch_id NUMBER, p_batch_mode_flag VARCHAR2) IS
151: select int_row_id, table_name, hz_imp_errors_s.nextval
152: from (
153: select /*+ ordered parallel(r) use_hash(r) */
154: table_name, int_row_id, lead(sd,1) over (partition by
155: decode(t.direction_code, 'C', obj_id, sub_id),

Line 201: select int_row_id, hz_imp_errors_s.NextVal from (

197: /* Combination of party_site_id and site_use_type is unique.
198: Order by 's.primary_flag desc' such that primary address uses will not
199: be marked as duplicate and leave a non-primary one there */
200: CURSOR dup_addr_uses (p_batch_id NUMBER, p_batch_mode_flag VARCHAR2) IS
201: select int_row_id, hz_imp_errors_s.NextVal from (
202: select /*+ parallel(s) */ party_site_use_id suid, party_site_id sid,
203: site_use_type sut, int_row_id, lead(party_site_id, 1) over(
204: partition by site_use_type order by primary_flag desc) n_sid
205: from hz_imp_addressuses_sg s

Line 217: select int_row_id, decode(allow_multi_assign_flag, 'N', 'M', 'E'), hz_imp_errors_s.NextVal from (

213: /* There should not be overlapping assignment for the same
214: party and same classification (class category / class code)
215: within the same content source type */
216: CURSOR dup_code_assignments (p_batch_id NUMBER, p_batch_mode_flag VARCHAR2) IS
217: select int_row_id, decode(allow_multi_assign_flag, 'N', 'M', 'E'), hz_imp_errors_s.NextVal from (
218: select /*+ parallel(s) */
219: s.int_row_id, s.party_id, s.party_orig_system_reference,
220: s.primary_flag, s.start_date_active, s.end_date_active,
221: lead(s.start_date_active, 1) over(partition by s.party_id,

Line 565: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20000';

561: execute immediate 'alter sequence ' || l_schema || '.hz_contact_points_s cache 20000';
562: execute immediate 'alter sequence ' || l_schema || '.hz_credit_ratings_s cache 20000';
563: execute immediate 'alter sequence ' || l_schema || '.hz_financial_numbers_s cache 20000';
564: execute immediate 'alter sequence ' || l_schema || '.hz_financial_reports_s cache 20000';
565: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20000';
566: execute immediate 'alter sequence hr.hr_locations_s cache 20000';
567: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s cache 20000';
568: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20000';
569: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20000';

Line 602: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20';

598: execute immediate 'alter sequence ' || l_schema || '.hz_contact_points_s cache 20';
599: execute immediate 'alter sequence ' || l_schema || '.hz_credit_ratings_s cache 20';
600: execute immediate 'alter sequence ' || l_schema || '.hz_financial_numbers_s cache 20';
601: execute immediate 'alter sequence ' || l_schema || '.hz_financial_reports_s cache 20';
602: execute immediate 'alter sequence ' || l_schema || '.hz_imp_errors_s cache 20';
603: execute immediate 'alter sequence hr.hr_locations_s cache 20';
604: execute immediate 'alter sequence ' || l_schema || '.hz_location_profiles_s cache 20';
605: execute immediate 'alter sequence ' || l_schema || '.hz_organization_profiles_s cache 20';
606: execute immediate 'alter sequence ' || l_schema || '.hz_org_contacts_s cache 20';

Line 4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;

4060: fnd_stats.gather_table_stats('AR', 'HZ_ORIG_SYS_REFERENCES', percent=>5, degree=>4);
4061: END IF;
4062:
4063: -- get the start error_id sequence number
4064: SELECT hz_imp_errors_s.NEXTVAL INTO l_start_error_id FROM dual;
4065:
4066: /* Dup check of relationships and address uses within interface,
4067: V+DML of other entities, PP-Wait */
4068: ident_dup_within_int(P_BATCH_ID, P_ORIG_SYSTEM, P_BATCH_MODE_FLAG, P_REQUEST_ID,

Line 4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;

4068: ident_dup_within_int(P_BATCH_ID, P_ORIG_SYSTEM, P_BATCH_MODE_FLAG, P_REQUEST_ID,
4069: D_SYSDATE, l_user_id, l_last_update_login,
4070: P_PROGRAM_APPLICATION_ID, P_PROGRAM_ID);
4071:
4072: SELECT hz_imp_errors_s.CURRVAL INTO l_current_error_id FROM dual;
4073:
4074: -- if error is greater than error limit
4075: IF l_current_error_id - l_start_error_id >=
4076: NVL(P_ERROR_LIMIT, NVL(FND_PROFILE.value('HZ_IMP_ERROR_LIMIT'), 10000)) THEN

Line 4863: P_PROGRAM_ID, l_sysdate, HZ_IMP_ERRORS_S.NextVal, P_BATCH_ID, P_REQUEST_ID, 'HZ_IMP_PARTIES_INT',

4859: program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
4860: token1_name, token1_value)
4861: values (
4862: l_sysdate, P_USER_ID, l_sysdate, P_USER_ID, P_LAST_UPDATE_LOGIN, P_PROGRAM_APPLICATION_ID,
4863: P_PROGRAM_ID, l_sysdate, HZ_IMP_ERRORS_S.NextVal, P_BATCH_ID, P_REQUEST_ID, 'HZ_IMP_PARTIES_INT',
4864: 'HZ_IMP_INVALID_PARTY_ID','PARTY_ID',l_party_id(i))
4865: RETURNING error_id BULK COLLECT INTO l_error_id;
4866:
4867: