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_MAP_PARTY_PUB dependencies on HZ_CONTACT_POINTS

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

1016: * select/de-select data sources for other entities is obsoleted.
1017:
1018: 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');
1019: 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');
1020: 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');
1021: 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');
1022: 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');
1023: 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');
1024: 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 1356: -- for HZ_PARTIES, HZ_PARTY_SITES and HZ_CONTACT_POINTS

1352: SAVEPOINT map_pub;
1353:
1354: --MOSR Changes
1355: --If p_inactivate_flag is 'Y' then in activate Source System mapping
1356: -- for HZ_PARTIES, HZ_PARTY_SITES and HZ_CONTACT_POINTS
1357: --bug 3107162: Passed local variable l_inactivate flag instead of p_inactivate_flag
1358: --bug 4287144: pass enquiry duns
1359: check_mosr_mapping (
1360: lpad(to_char(nvl(l_interface_rec.enquiry_duns,l_interface_rec.duns_number)),9,'0'),

Line 1909: FROM -- hz_contact_points cp,

1905: hosr.start_date_active,
1906: hosr.orig_system,
1907: hosr.orig_system_reference,
1908: hosr.owner_table_name
1909: FROM -- hz_contact_points cp,
1910: hz_orig_sys_references hosr
1911: WHERE --nvl(cp.contact_point_id, '-999') = hosr.owner_table_id
1912: -- AND cp.status = 'A' AND
1913: hosr.orig_system = 'DNB'

Line 1914: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'

1910: hz_orig_sys_references hosr
1911: WHERE --nvl(cp.contact_point_id, '-999') = hosr.owner_table_id
1912: -- AND cp.status = 'A' AND
1913: hosr.orig_system = 'DNB'
1914: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'
1915: AND trunc(nvl(hosr.end_date_active, sysdate)) >= trunc(sysdate)
1916: AND hosr.status='A'
1917: AND hosr.orig_system_reference like p_duns_number_c || '%'
1918: AND hosr.party_id <> nvl(p_party_id,-1);

Line 2007: --Inactivate HZ_CONTACT_POINTS records

2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: RETURN;
2005: END;
2006:
2007: --Inactivate HZ_CONTACT_POINTS records
2008: BEGIN
2009: OPEN c_check_contact_point_mapping;
2010: LOOP
2011: FETCH c_check_contact_point_mapping INTO l_orig_system_ref_id, l_object_version_number, l_start_date_active,

Line 2126: --hz_contact_points cp,

2122: hosr.orig_system_reference,
2123: hosr.owner_table_name,
2124: hosr.owner_table_id
2125: FROM
2126: --hz_contact_points cp,
2127: hz_orig_sys_references hosr
2128: WHERE
2129: --nvl(cp.contact_point_id, '-999') = hosr.owner_table_id AND
2130: hosr.orig_system = 'DNB'

Line 2131: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'

2127: hz_orig_sys_references hosr
2128: WHERE
2129: --nvl(cp.contact_point_id, '-999') = hosr.owner_table_id AND
2130: hosr.orig_system = 'DNB'
2131: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'
2132: -- AND trunc(nvl(hosr.end_date_active, sysdate)) >= trunc(sysdate)
2133: AND hosr.status='A'
2134: AND hosr.party_id = p_organization_rec.party_rec.party_id
2135: AND hosr.orig_system_reference not like p_duns_number_c || '%';

Line 2216: --Inactivate HZ_CONTACT_POINTS records

2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: RETURN;
2214: END;
2215:
2216: --Inactivate HZ_CONTACT_POINTS records
2217: BEGIN
2218: OPEN c_check_contact_point_mapping;
2219: LOOP
2220: FETCH c_check_contact_point_mapping INTO l_orig_system_ref_id, l_object_version_number, l_start_date_active,

Line 4477: where owner_table_name = 'HZ_CONTACT_POINTS'

4473:
4474: select count(1)
4475: into l_count
4476: from hz_orig_sys_references
4477: where owner_table_name = 'HZ_CONTACT_POINTS'
4478: and orig_system = 'DNB'
4479: and status = 'A'
4480: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)
4481: and orig_system_reference like l_duns_number_c || '%';

Line 4490: FROM hz_contact_points hcp

4486: INTO p_contact_points_rec.contact_point_id, l_object_version_number, l_orig_system_reference
4487: FROM
4488: ( SELECT contact_point_id, object_version_number, orig_system_reference,rank() over (
4489: partition by owner_table_id order by last_update_date desc,object_version_number desc,contact_point_id desc) r
4490: FROM hz_contact_points hcp
4491: WHERE owner_table_name = 'HZ_PARTIES'
4492: AND owner_table_id = p_contact_points_rec.owner_table_id
4493: AND contact_point_type = 'PHONE'
4494: AND phone_line_type = p_phone_rec.PHONE_LINE_TYPE

Line 4529: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'

4525: BEGIN
4526: SELECT hosr.orig_system_ref_id INTO l_orig_sys_ref_id
4527: FROM hz_orig_sys_references hosr
4528: WHERE hosr.orig_system = 'DNB'
4529: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'
4530: AND hosr.status='A'
4531: AND hosr.owner_table_id = p_contact_points_rec.contact_point_id;
4532: EXCEPTION
4533: WHEN NO_DATA_FOUND THEN

Line 4541: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';

4537: ELSE
4538: l_orig_sys_reference_rec.orig_system_reference := l_duns_number_c || '-CP-F'||to_char(l_count + 1);
4539: END IF;
4540: l_orig_sys_reference_rec.orig_system := 'DNB';
4541: l_orig_sys_reference_rec.owner_table_name := 'HZ_CONTACT_POINTS';
4542: l_orig_sys_reference_rec.owner_table_id := p_contact_points_rec.contact_point_id;
4543: l_orig_sys_reference_rec.start_date_active := sysdate;
4544: l_orig_sys_reference_rec.party_id := p_contact_points_rec.owner_table_id;
4545: l_orig_sys_reference_rec.status := 'A';

Line 4584: where owner_table_name = 'HZ_CONTACT_POINTS'

4580:
4581: select count(1)
4582: into l_count
4583: from hz_orig_sys_references
4584: where owner_table_name = 'HZ_CONTACT_POINTS'
4585: and orig_system = 'DNB'
4586: and status = 'A'
4587: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)
4588: and orig_system_reference like l_duns_number_c || '%';*/

Line 4597: open check_cont_point_mosr_mapping ( 'DNB', p_contact_points_rec.orig_system_reference, 'HZ_CONTACT_POINTS');

4593: ElSIF p_phone_rec.PHONE_LINE_TYPE = 'FAX' AND p_phone_rec.RAW_PHONE_NUMBER IS NOT NULL THEN
4594: p_contact_points_rec.orig_system_reference := l_duns_number_c || '-CP' || '-F' || to_char(l_count + 1);
4595: END IF;
4596:
4597: open check_cont_point_mosr_mapping ( 'DNB', p_contact_points_rec.orig_system_reference, 'HZ_CONTACT_POINTS');
4598: fetch check_cont_point_mosr_mapping into l_mosr_mapping_exist;
4599: IF l_mosr_mapping_exist = 'Y' THEN
4600: p_contact_points_rec.orig_system := NULL;
4601: ELSE