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_CONTACT_POINTS

Line 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');

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');
96: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_NUMBERS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
97: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CODE_ASSIGNMENTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

Line 561: execute immediate 'alter sequence ' || l_schema || '.hz_contact_points_s cache 20000';

557: alter cache size before run instead
558: IF P_BATCH_MODE_FLAG = 'Y' THEN
559: execute immediate 'alter sequence ' || l_schema || '.hz_code_assignments_s cache 20000';
560: execute immediate 'alter sequence ' || l_schema || '.hz_contact_numbers_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';

Line 598: execute immediate 'alter sequence ' || l_schema || '.hz_contact_points_s cache 20';

594: /*
595: IF P_BATCH_MODE_FLAG = 'Y' THEN
596: execute immediate 'alter sequence ' || l_schema || '.hz_code_assignments_s cache 20';
597: execute immediate 'alter sequence ' || l_schema || '.hz_contact_numbers_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';

Line 771: AND cposr.owner_table_name = ''HZ_CONTACT_POINTS''

767: AND posr.owner_table_name = ''HZ_PARTIES''
768: AND cposr.orig_system = cpi.cp_orig_system
769: AND cposr.orig_system_reference = cpi.cp_orig_system_reference
770: AND cposr.status = ''A''
771: AND cposr.owner_table_name = ''HZ_CONTACT_POINTS''
772: AND cposr.party_id <> posr.owner_table_id
773: AND cpi.rowid = cpt_sg.int_row_id
774: AND NOT EXISTS
775: (SELECT 1 FROM HZ_IMP_TMP_ERRORS err

Line 807: from hz_imp_contactpts_sg hcs, hz_orig_sys_references hos, hz_contact_points hcp_new,hz_contact_points hcp_old

803: ';
804:
805: l_cleanup_ssm_cpt_dnb VARCHAR2(4000) :=
806: ' select hos.rowid, hcp_old.primary_flag, hcp_old.rowid,hcp_new.rowid
807: from hz_imp_contactpts_sg hcs, hz_orig_sys_references hos, hz_contact_points hcp_new,hz_contact_points hcp_old
808: where hcs.party_orig_system=''DNB''
809: and hcs.old_cp_orig_system_ref=hos.orig_system_reference
810: and hos.orig_system=hcs.party_orig_system
811: and hos.owner_table_name=''HZ_CONTACT_POINTS''

Line 811: and hos.owner_table_name=''HZ_CONTACT_POINTS''

807: from hz_imp_contactpts_sg hcs, hz_orig_sys_references hos, hz_contact_points hcp_new,hz_contact_points hcp_old
808: where hcs.party_orig_system=''DNB''
809: and hcs.old_cp_orig_system_ref=hos.orig_system_reference
810: and hos.orig_system=hcs.party_orig_system
811: and hos.owner_table_name=''HZ_CONTACT_POINTS''
812: and hos.status=''A''
813: and hcs.old_cp_orig_system_ref is not null
814: and hcp_old.contact_point_id = hos.owner_table_id
815: and hcs.contact_point_id=hcp_new.contact_point_id

Line 957: UPDATE HZ_CONTACT_POINTS

953: SET status='I',end_date_active = sysdate
954: WHERE rowid = l_row_id(j);
955:
956: FORALL j IN l_row_id_old.FIRST.. l_row_id_old.LAST
957: UPDATE HZ_CONTACT_POINTS
958: SET status='I', primary_flag = 'N'
959: WHERE rowid = l_row_id_old(j);
960:
961: FORALL j IN l_row_id_new.FIRST.. l_row_id_new.LAST

Line 962: UPDATE HZ_CONTACT_POINTS

958: SET status='I', primary_flag = 'N'
959: WHERE rowid = l_row_id_old(j);
960:
961: FORALL j IN l_row_id_new.FIRST.. l_row_id_new.LAST
962: UPDATE HZ_CONTACT_POINTS
963: SET primary_flag = l_primary_flag(j)
964: WHERE rowid = l_row_id_new(j);
965:
966: IF l_last_fetch = TRUE THEN

Line 3128: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_CONTACT_POINTS')

3124: 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,
3125: token1_name, token1_value)
3126: values (
3127: 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_CONTACTPTS_INT',
3128: 'AR_RAPI_DESC_FLEX_INVALID', 'DFF_NAME', 'HZ_CONTACT_POINTS')
3129: when (E15_FLAG is null) then
3130: into hz_imp_errors (
3131: 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,
3132: token1_name, token1_value)

Line 3177: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CONTACT_POINTS_U1', 'ENTITY',

3173: 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,
3174: token1_name, token1_value, token2_name, token2_value)
3175: values (
3176: 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_CONTACTPTS_INT',
3177: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CONTACT_POINTS_U1', 'ENTITY',
3178: 'HZ_CONTACT_POINTS')
3179: when (ACTION_MISMATCH_FLAG is null) then
3180: into hz_imp_errors (
3181: 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 3178: 'HZ_CONTACT_POINTS')

3174: token1_name, token1_value, token2_name, token2_value)
3175: values (
3176: 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_CONTACTPTS_INT',
3177: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CONTACT_POINTS_U1', 'ENTITY',
3178: 'HZ_CONTACT_POINTS')
3179: when (ACTION_MISMATCH_FLAG is null) then
3180: into hz_imp_errors (
3181: 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)
3182: values (