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_RELATIONSHIPS

Line 91: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

87:
88: /* Commented code for bug 4079902 */
89:
90: /*
91: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
92: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
93: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
94: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
95: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

Line 430: hz_relationships r

426: P_BATCH_ID, rs.sub_orig_system_reference, r.relationship_id,
427: r.directional_flag, rs.int_row_id int_row_id,
428: P_SYSDATE, P_USER_ID, P_SYSDATE, P_USER_ID
429: FROM hz_imp_relships_sg rs,
430: hz_relationships r
431: WHERE rs.batch_id=P_BATCH_ID
432: AND rs.sub_orig_system = P_OS
433: AND rs.batch_mode_flag = P_BATCH_MODE_FLAG
434: AND rs.action_flag = 'I'

Line 578: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20000';

574: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_s cache 20000';
575: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_number_s cache 20000';
576: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_uses_s cache 20000';
577: execute immediate 'alter sequence ' || l_schema || '.hz_person_profiles_s cache 20000';
578: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20000';
579: END IF;
580: */
581: ELSE
582:

Line 615: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20';

611: execute immediate 'alter sequence ' || l_schema || '.hz_party_sites_s cache 20';
612: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_number_s cache 20';
613: execute immediate 'alter sequence ' || l_schema || '.hz_party_site_uses_s cache 20';
614: execute immediate 'alter sequence ' || l_schema || '.hz_person_profiles_s cache 20';
615: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20';
616: END IF;
617: */
618: END IF;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1281: l_dss_rel_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS',null);

1277: -- Bug 3871136
1278: l_dss_person_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PERSON');
1279: l_dss_org_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'ORGANIZATION');
1280: l_dss_others_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_PARTIES',null);
1281: l_dss_rel_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS',null);
1282: l_dss_ca_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name('HZ_CODE_ASSIGNMENTS',null);
1283: l_dss_cp_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PARTY_CONTACT_POINTS');
1284: l_dss_ps_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PARTY_SITE_CONTACT_POINTS');
1285:

Line 2304: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_RELATIONSHIPS')

2300: 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,
2301: token1_name, token1_value)
2302: values (
2303: 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_RELSHIPS_INT',
2304: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_RELATIONSHIPS')
2305: when (E10_FLAG is null) then
2306: into hz_imp_errors (
2307: 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,
2308: token1_name, token1_value)

Line 2326: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_RELATIONSHIPS_U1', 'ENTITY',

2322: 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,
2323: token1_name, token1_value, token2_name, token2_value)
2324: values (
2325: 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_RELSHIPS_INT',
2326: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_RELATIONSHIPS_U1', 'ENTITY',
2327: 'HZ_RELATIONSHIPS')
2328: when (ACTION_MISMATCH_FLAG is null) then
2329: into hz_imp_errors (
2330: 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 2327: 'HZ_RELATIONSHIPS')

2323: token1_name, token1_value, token2_name, token2_value)
2324: values (
2325: 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_RELSHIPS_INT',
2326: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_RELATIONSHIPS_U1', 'ENTITY',
2327: 'HZ_RELATIONSHIPS')
2328: when (ACTION_MISMATCH_FLAG is null) then
2329: into hz_imp_errors (
2330: 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)
2331: values (