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_CONTACTROLES_INT

Line 1134: UPDATE HZ_IMP_CONTACTROLES_INT

1130: AND obj_orig_system_reference = l_posr(i))
1131: );
1132: --Update contact roles
1133: FORALL i in l_posr.FIRST..l_posr.LAST
1134: UPDATE HZ_IMP_CONTACTROLES_INT
1135: SET interface_status = 'D'
1136: WHERE batch_id = p_batch_id
1137: AND sub_orig_system = l_pos(i)
1138: AND sub_orig_system_reference = l_posr(i);

Line 1362: update HZ_IMP_CONTACTROLES_INT

1358: where BATCH_ID = P_BATCH_ID
1359: and SUB_ORIG_SYSTEM = P_ORIG_SYSTEM
1360: and INTERFACE_STATUS = 'C';
1361:
1362: update HZ_IMP_CONTACTROLES_INT
1363: set error_id = null,
1364: interface_status = null
1365: where BATCH_ID = P_BATCH_ID
1366: and SUB_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1508: update HZ_IMP_CONTACTROLES_INT

1504: and batch_id = P_BATCH_ID
1505: and stage = 3
1506: and status = 'C');
1507:
1508: update HZ_IMP_CONTACTROLES_INT
1509: set error_id = null, interface_status = null
1510: where batch_id = P_BATCH_ID
1511: and sub_orig_system = P_ORIG_SYSTEM
1512: and interface_status = 'C'

Line 2976: 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_CONTACTROLES_INT',

2972: into hz_imp_errors (
2973: 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,
2974: token1_name, token1_value, token2_name, token2_value)
2975: values (
2976: 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_CONTACTROLES_INT',
2977: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'ROLE_TYPE', 'LOOKUP_TYPE',
2978: 'CONTACT_ROLE_TYPE')
2979: when (E2_FLAG is null) then
2980: into hz_imp_errors (

Line 2983: 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_CONTACTROLES_INT',

2979: when (E2_FLAG is null) then
2980: into hz_imp_errors (
2981: 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)
2982: values (
2983: 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_CONTACTROLES_INT',
2984: 'HZ_IMP_CONTROLE_OSR_MISMATCH')
2985: when (E3_FLAG is null) then
2986: into hz_imp_errors (
2987: 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 2990: 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_CONTACTROLES_INT',

2986: into hz_imp_errors (
2987: 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,
2988: token1_name, token1_value, token2_name, token2_value)
2989: values (
2990: 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_CONTACTROLES_INT',
2991: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2992: 'HZ_CREATED_BY_MODULES')
2993: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2994: into hz_imp_errors (

Line 2998: 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_CONTACTROLES_INT',

2994: into hz_imp_errors (
2995: 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,
2996: token1_name, token1_value, token2_name, token2_value)
2997: values (
2998: 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_CONTACTROLES_INT',
2999: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_ORG_CONTACT_ROLES_U1', 'ENTITY',
3000: 'HZ_ORG_CONTACT_ROLES')
3001: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
3002: into hz_imp_errors (

Line 3006: 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_CONTACTROLES_INT',

3002: into hz_imp_errors (
3003: 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,
3004: token1_name, token1_value, token2_name, token2_value)
3005: values (
3006: 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_CONTACTROLES_INT',
3007: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_ORG_CONTACT_ROLES_U2', 'ENTITY',
3008: 'HZ_ORG_CONTACT_ROLES')
3009: when (ACTION_MISMATCH_FLAG is null) then
3010: into hz_imp_errors (

Line 3013: 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_CONTACTROLES_INT',

3009: when (ACTION_MISMATCH_FLAG is null) then
3010: into hz_imp_errors (
3011: 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)
3012: values (
3013: 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_CONTACTROLES_INT',
3014: 'HZ_IMP_ACTION_MISMATCH')
3015: when (MISSING_PARENT_FLAG is null) then
3016: into hz_imp_errors (
3017: 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 3019: 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_CONTACTROLES_INT',

3015: when (MISSING_PARENT_FLAG is null) then
3016: into hz_imp_errors (
3017: 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)
3018: values (
3019: 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_CONTACTROLES_INT',
3020: 'HZ_IMP_CONTACT_NOT_FOUND')
3021: 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,
3022: E3_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
3023: from hz_imp_tmp_errors

Line 3026: and interface_table_name = 'HZ_IMP_CONTACTROLES_INT';

3022: E3_FLAG, DUP_VAL_IDX_EXCEP_FLAG, ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
3023: from hz_imp_tmp_errors
3024: where batch_id = P_BATCH_ID
3025: and request_id = P_REQUEST_ID
3026: and interface_table_name = 'HZ_IMP_CONTACTROLES_INT';
3027:
3028:
3029:
3030: insert all

Line 3256: update hz_imp_contactroles_int

3252: where rowid = l_row_id(i)
3253: and l_table_name(i) = 'HZ_IMP_CONTACTS_INT';
3254:
3255: ForAll i in 1..l_row_id.count
3256: update hz_imp_contactroles_int
3257: set interface_status = 'E',
3258: error_id = l_error_id(i)
3259: where rowid = l_row_id(i)
3260: and l_table_name(i) = 'HZ_IMP_CONTACTROLES_INT';

Line 3260: and l_table_name(i) = 'HZ_IMP_CONTACTROLES_INT';

3256: update hz_imp_contactroles_int
3257: set interface_status = 'E',
3258: error_id = l_error_id(i)
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',

Line 3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_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');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');

Line 4487: select /*+ index_ffs(a,hz_imp_contactroles_int_n1)

4483: from hz_imp_contacts_int a
4484: where sub_orig_system = :2
4485: and batch_id=:1
4486: union all -- Contact Roles
4487: select /*+ index_ffs(a,hz_imp_contactroles_int_n1)
4488: parallel_index(a)*/
4489: sub_orig_system_reference party_orig_system_reference
4490: from hz_imp_contactroles_int a
4491: where sub_orig_system = :2

Line 4490: from hz_imp_contactroles_int a

4486: union all -- Contact Roles
4487: select /*+ index_ffs(a,hz_imp_contactroles_int_n1)
4488: parallel_index(a)*/
4489: sub_orig_system_reference party_orig_system_reference
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)*/

Line 4584: select /+ index(a,hz_imp_contactroles_int_n1) /

4580: from hz_imp_contacts_int a
4581: where sub_orig_system = :2
4582: and batch_id=:1
4583: union all -- Contact Roles
4584: select /*+ index(a,hz_imp_contactroles_int_n1) */
4585: sub_orig_system_reference party_orig_system_reference
4586: from hz_imp_contactroles_int a
4587: where sub_orig_system = :2
4588: and batch_id=:1

Line 4586: from hz_imp_contactroles_int a

4582: and batch_id=:1
4583: union all -- Contact Roles
4584: select /*+ index(a,hz_imp_contactroles_int_n1) */
4585: sub_orig_system_reference party_orig_system_reference
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) */