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_ADDRESSUSES_INT

Line 349: 'HZ_IMP_ADDRESSUSES_INT',

345: (
346: P_REQUEST_ID,
347: P_BATCH_ID,
348: l_int_row_id(j),
349: 'HZ_IMP_ADDRESSUSES_INT',
350: l_err_id(j),
351: P_SYSDATE,
352: P_USER_ID,
353: P_SYSDATE,

Line 364: update HZ_IMP_ADDRESSUSES_INT

360: 'E'
361: );
362:
363: ForAll j in 1..l_int_row_id.count
364: update HZ_IMP_ADDRESSUSES_INT
365: set interface_status = 'E', error_id = l_err_id(j)
366: where rowid = l_int_row_id(j);
367:
368: CLOSE dup_addr_uses;

Line 466: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_DUP_ADDRUSE_IN_INT',

462: )
463: select error_id, batch_id, request_id, interface_table_name,
464: decode(interface_table_name, 'HZ_IMP_RELSHIPS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',
465: 'HZ_IMP_CONTACTS_INT', 'HZ_IMP_DUP_REL_IN_INT_ERROR',
466: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_DUP_ADDRUSE_IN_INT',
467: 'HZ_IMP_CLASSIFICS_INT', decode(e38_flag, 'M', 'HZ_API_ALLOW_MUL_ASSIGN_FG',
468: 'HZ_IMP_DUP_CLASSIFIC_IN_INT')
469: )
470: from hz_imp_tmp_errors

Line 474: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_CLASSIFICS_INT');

470: from hz_imp_tmp_errors
471: where batch_id = P_BATCH_ID
472: and request_id = P_REQUEST_ID
473: and interface_table_name in ('HZ_IMP_RELSHIPS_INT', 'HZ_IMP_CONTACTS_INT',
474: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_CLASSIFICS_INT');
475:
476: COMMIT;
477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
478: hz_utility_v2pub.debug(p_message=>'WRP:ident_dup_within_int()-',

Line 1093: UPDATE HZ_IMP_ADDRESSUSES_INT

1089:
1090: --Update child entities
1091: --Update site uses
1092: FORALL i in l_psosr.FIRST..l_psosr.LAST
1093: UPDATE HZ_IMP_ADDRESSUSES_INT
1094: SET interface_status = 'D'
1095: WHERE batch_id = p_batch_id
1096: AND site_orig_system = l_psos(i)
1097: AND site_orig_system_reference = l_psosr(i);

Line 1369: update HZ_IMP_ADDRESSUSES_INT

1365: where BATCH_ID = P_BATCH_ID
1366: and SUB_ORIG_SYSTEM = P_ORIG_SYSTEM
1367: and INTERFACE_STATUS = 'C';
1368:
1369: update HZ_IMP_ADDRESSUSES_INT
1370: set error_id = null,
1371: interface_status = null
1372: where BATCH_ID = P_BATCH_ID
1373: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1522: update HZ_IMP_ADDRESSUSES_INT

1518: and batch_id = P_BATCH_ID
1519: and stage = 3
1520: and status = 'C');
1521:
1522: update HZ_IMP_ADDRESSUSES_INT
1523: set error_id = null, interface_status = null
1524: where batch_id = P_BATCH_ID
1525: and party_orig_system = P_ORIG_SYSTEM
1526: and interface_status = 'C'

Line 2919: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2915: into hz_imp_errors (
2916: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2917: token1_name, token1_value, token2_name, token2_value)
2918: values (
2919: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2920: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SITE_USE_TYPE', 'LOOKUP_TYPE',
2921: 'PARTY_SITE_USE_CODE')
2922: when (E2_FLAG is null) then
2923: into hz_imp_errors (

Line 2926: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2922: when (E2_FLAG is null) then
2923: into hz_imp_errors (
2924: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2925: values (
2926: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2927: 'HZ_API_UNIQUE_SITE_USE_TYPE')
2928: when (E3_FLAG is null) then
2929: into hz_imp_errors (
2930: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 2932: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2928: when (E3_FLAG is null) then
2929: into hz_imp_errors (
2930: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2931: values (
2932: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2933: 'HZ_IMP_ADDRUSE_OSR_MISMATCH')
2934: when (E4_FLAG is null) then
2935: into hz_imp_errors (
2936: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 2939: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2935: into hz_imp_errors (
2936: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2937: token1_name, token1_value, token2_name, token2_value)
2938: values (
2939: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2940: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2941: 'HZ_CREATED_BY_MODULES')
2942: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2943: into hz_imp_errors (

Line 2947: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2943: into hz_imp_errors (
2944: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2945: token1_name, token1_value, token2_name, token2_value)
2946: values (
2947: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2948: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_PARTY_SITE_USES_U1', 'ENTITY',
2949: 'HZ_PARTY_SITE_USES')
2950: when (ACTION_MISMATCH_FLAG is null) then
2951: into hz_imp_errors (

Line 2954: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2950: when (ACTION_MISMATCH_FLAG is null) then
2951: into hz_imp_errors (
2952: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2953: values (
2954: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2955: 'HZ_IMP_ACTION_MISMATCH')
2956: when (MISSING_PARENT_FLAG is null) then
2957: into hz_imp_errors (
2958: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 2960: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',

2956: when (MISSING_PARENT_FLAG is null) then
2957: into hz_imp_errors (
2958: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2959: values (
2960: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_ADDRESSUSES_INT',
2961: 'HZ_IMP_ADDR_NOT_FOUND')
2962: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG, E3_FLAG, E4_FLAG,
2963: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
2964: from hz_imp_tmp_errors e

Line 2967: and e.interface_table_name = 'HZ_IMP_ADDRESSUSES_INT';

2963: DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
2964: from hz_imp_tmp_errors e
2965: where e.batch_id = P_BATCH_ID
2966: and e.request_id = P_REQUEST_ID
2967: and e.interface_table_name = 'HZ_IMP_ADDRESSUSES_INT';
2968:
2969:
2970: insert all
2971: when (E1_FLAG is null) then

Line 3263: update hz_imp_addressuses_int

3259: where rowid = l_row_id(i)
3260: and l_table_name(i) = 'HZ_IMP_CONTACTROLES_INT';
3261:
3262: ForAll i in 1..l_row_id.count
3263: update hz_imp_addressuses_int
3264: set interface_status = 'E',
3265: error_id = l_error_id(i)
3266: where rowid = l_row_id(i)
3267: and l_table_name(i) = 'HZ_IMP_ADDRESSUSES_INT';

Line 3267: and l_table_name(i) = 'HZ_IMP_ADDRESSUSES_INT';

3263: update hz_imp_addressuses_int
3264: set interface_status = 'E',
3265: error_id = l_error_id(i)
3266: where rowid = l_row_id(i)
3267: and l_table_name(i) = 'HZ_IMP_ADDRESSUSES_INT';
3268:
3269: ForAll i in 1..l_row_id.count
3270: update hz_imp_finreports_int
3271: set interface_status = 'E',

Line 3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');

3942: to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3943:
3944: fnd_stats.gather_table_stats('AR', 'HZ_IMP_PARTIES_INT');
3945: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSES_INT');
3946: fnd_stats.gather_table_stats('AR', 'HZ_IMP_ADDRESSUSES_INT');
3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');

Line 4494: select /+ index_ffs(a,hz_imp_addressuses_int_n1) parallel_index(a)/

4490: from hz_imp_contactroles_int a
4491: where sub_orig_system = :2
4492: and batch_id=:1
4493: union all -- Address Uses
4494: select /*+ index_ffs(a,hz_imp_addressuses_int_n1) parallel_index(a)*/
4495: party_orig_system_reference
4496: from hz_imp_addressuses_int a
4497: where party_orig_system = :2
4498: and batch_id=:1

Line 4496: from hz_imp_addressuses_int a

4492: and batch_id=:1
4493: union all -- Address Uses
4494: select /*+ index_ffs(a,hz_imp_addressuses_int_n1) parallel_index(a)*/
4495: party_orig_system_reference
4496: from hz_imp_addressuses_int a
4497: where party_orig_system = :2
4498: and batch_id=:1
4499: )
4500: group by party_orig_system_reference

Line 4590: select /+ index(a,hz_imp_addressuses_int_n1) /

4586: from hz_imp_contactroles_int a
4587: where sub_orig_system = :2
4588: and batch_id=:1
4589: union all -- Address Uses
4590: select /*+ index(a,hz_imp_addressuses_int_n1) */
4591: party_orig_system_reference
4592: from hz_imp_addressuses_int a
4593: where party_orig_system = :2
4594: and batch_id=:1

Line 4592: from hz_imp_addressuses_int a

4588: and batch_id=:1
4589: union all -- Address Uses
4590: select /*+ index(a,hz_imp_addressuses_int_n1) */
4591: party_orig_system_reference
4592: from hz_imp_addressuses_int a
4593: where party_orig_system = :2
4594: and batch_id=:1
4595: )
4596: group by party_orig_system_reference