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_PARTY_SITES

Line 1026: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', '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');
1025: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_INDICATORS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1026: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1027: */
1028: arp_util.debug('do_add_policy_function (-) ');
1029:
1030: END do_add_policy_function;

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 1889: FROM --hz_party_sites ps,

1885: hosr.start_date_active,
1886: hosr.orig_system,
1887: hosr.orig_system_reference,
1888: hosr.owner_table_name
1889: FROM --hz_party_sites ps,
1890: hz_orig_sys_references hosr
1891: WHERE --nvl(ps.party_site_id, '-999') = hosr.owner_table_id
1892: --AND ps.status = 'A' AND
1893: hosr.orig_system = 'DNB'

Line 1894: AND hosr.owner_table_name = 'HZ_PARTY_SITES'

1890: hz_orig_sys_references hosr
1891: WHERE --nvl(ps.party_site_id, '-999') = hosr.owner_table_id
1892: --AND ps.status = 'A' AND
1893: hosr.orig_system = 'DNB'
1894: AND hosr.owner_table_name = 'HZ_PARTY_SITES'
1895: AND trunc(nvl(hosr.end_date_active, sysdate)) >= trunc(sysdate)
1896: AND hosr.status='A'
1897: AND hosr.orig_system_reference like p_duns_number_c || '%'
1898: AND hosr.party_id <> nvl(p_party_id,-1);

Line 1963: --Inactivate HZ_PARTY_SITES records

1959: RETURN;
1960: END;
1961:
1962:
1963: --Inactivate HZ_PARTY_SITES records
1964: BEGIN
1965:
1966: OPEN c_check_party_site_mapping;
1967: LOOP

Line 2105: --hz_party_sites ps,

2101: hosr.orig_system_reference,
2102: hosr.owner_table_name,
2103: hosr.owner_table_id
2104: FROM
2105: --hz_party_sites ps,
2106: hz_orig_sys_references hosr
2107: WHERE
2108: --nvl(ps.party_site_id, '-999') = hosr.owner_table_id AND
2109: hosr.orig_system = 'DNB'

Line 2110: AND hosr.owner_table_name = 'HZ_PARTY_SITES'

2106: hz_orig_sys_references hosr
2107: WHERE
2108: --nvl(ps.party_site_id, '-999') = hosr.owner_table_id AND
2109: hosr.orig_system = 'DNB'
2110: AND hosr.owner_table_name = 'HZ_PARTY_SITES'
2111: -- AND trunc(nvl(hosr.end_date_active, sysdate)) >= trunc(sysdate)
2112: AND hosr.status='A'
2113: AND hosr.party_id = p_organization_rec.party_rec.party_id
2114: AND hosr.orig_system_reference not like p_duns_number_c || '%';

Line 2174: --Inactivate HZ_PARTY_SITES records

2170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2171: RETURN;
2172: END IF;
2173:
2174: --Inactivate HZ_PARTY_SITES records
2175: BEGIN
2176: OPEN c_check_party_site_mapping;
2177: LOOP
2178: FETCH c_check_party_site_mapping INTO l_orig_system_ref_id, l_object_version_number, l_start_date_active,

Line 4043: FROM hz_party_sites ps, hz_locations loc

4039:
4040: -- Bug 2882305 : Add address1 to select statement
4041: SELECT ps.location_id, ps.party_site_id, loc.object_version_number,loc.address1
4042: INTO p_location_rec.location_id, l_party_site_id, l_object_version_number, l_address1
4043: FROM hz_party_sites ps, hz_locations loc
4044: WHERE ps.party_id = p_party_id
4045: AND ps.location_id = loc.location_id
4046: AND loc.actual_content_source = p_location_rec.actual_content_source
4047: AND ps.end_date_active is NULL

Line 4065: FROM hz_party_sites ps, hz_locations loc

4061: -- if the existing location record has same taxable components, update this record
4062:
4063: /* SELECT ps.location_id, loc.object_version_number
4064: INTO p_location_rec.location_id, l_object_version_number
4065: FROM hz_party_sites ps, hz_locations loc
4066: WHERE ps.party_id = p_party_id
4067: AND ps.location_id = loc.location_id
4068: AND loc.actual_content_source = p_location_rec.actual_content_source
4069: AND UPPER(loc.ADDRESS1 || loc.ADDRESS2 || loc.ADDRESS3 || loc.ADDRESS4 ||

Line 4109: AND hosr.owner_table_name = 'HZ_PARTY_SITES'

4105: BEGIN
4106: SELECT hosr.orig_system_ref_id INTO l_orig_sys_ref_id
4107: FROM hz_orig_sys_references hosr
4108: WHERE hosr.orig_system = 'DNB'
4109: AND hosr.owner_table_name = 'HZ_PARTY_SITES'
4110: AND hosr.status='A'
4111: AND hosr.owner_table_id = l_party_site_id;
4112: EXCEPTION
4113: WHEN NO_DATA_FOUND THEN

Line 4117: where owner_table_name = 'HZ_PARTY_SITES'

4113: WHEN NO_DATA_FOUND THEN
4114: select count(1)
4115: into l_count
4116: from hz_orig_sys_references
4117: where owner_table_name = 'HZ_PARTY_SITES'
4118: and orig_system = 'DNB'
4119: and status = 'A'
4120: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)
4121: and orig_system_reference like l_duns_number_c || '%';

Line 4125: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';

4121: and orig_system_reference like l_duns_number_c || '%';
4122: /* Bug Fix: 4305055 */
4123: l_orig_sys_reference_rec.orig_system_reference := l_duns_number_c || '-PS' || to_char(l_count + 1);
4124: l_orig_sys_reference_rec.orig_system := 'DNB';
4125: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTY_SITES';
4126: l_orig_sys_reference_rec.owner_table_id := l_party_site_id;
4127: l_orig_sys_reference_rec.start_date_active := sysdate;
4128: l_orig_sys_reference_rec.party_id := p_party_id;
4129: l_orig_sys_reference_rec.status := 'A';

Line 4271: FROM HZ_PARTY_SITES

4267: /*
4268: BEGIN
4269:
4270: SELECT 'Y' INTO l_party_site_exist
4271: FROM HZ_PARTY_SITES
4272: WHERE location_id = p_location_rec.location_id
4273: AND party_id = p_party_id
4274: AND actual_content_source = p_location_rec.actual_content_source
4275: AND status = 'A'

Line 4288: UPDATE hz_party_sites SET END_DATE_ACTIVE = sysdate , status = 'I' WHERE party_site_id = p_old_party_site_id;

4284: x_return_status);
4285:
4286: -- if there is old party site record, end it.
4287: IF p_old_party_site_id IS NOT NULL THEN
4288: UPDATE hz_party_sites SET END_DATE_ACTIVE = sysdate , status = 'I' WHERE party_site_id = p_old_party_site_id;
4289: END IF;
4290: -- END;
4291: END do_store_location;
4292:

Line 4304: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

4300: l_msg_data VARCHAR2(2000);
4301:
4302: l_profile VARCHAR2(1);
4303: l_mosr_mapping_exist VARCHAR2(1);
4304: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
4305: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
4306: l_count NUMBER;
4307: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;
4308:

Line 4305: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;

4301:
4302: l_profile VARCHAR2(1);
4303: l_mosr_mapping_exist VARCHAR2(1);
4304: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
4305: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
4306: l_count NUMBER;
4307: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;
4308:
4309: CURSOR check_party_site_mosr_mapping (p_orig_system IN VARCHAR2,

Line 4345: where owner_table_name = 'HZ_PARTY_SITES'

4341:
4342: select count(1)
4343: into l_count
4344: from hz_orig_sys_references
4345: where owner_table_name = 'HZ_PARTY_SITES'
4346: and orig_system = 'DNB'
4347: and status = 'A'
4348: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)
4349: and orig_system_reference like l_duns_number_c || '%';

Line 4353: open check_party_site_mosr_mapping ( 'DNB', p_party_site_rec.orig_system_reference, 'HZ_PARTY_SITES');

4349: and orig_system_reference like l_duns_number_c || '%';
4350: /* Bug Fix: 4305055 */
4351: p_party_site_rec.orig_system_reference := l_duns_number_c || '-PS' || to_char(l_count + 1);
4352:
4353: open check_party_site_mosr_mapping ( 'DNB', p_party_site_rec.orig_system_reference, 'HZ_PARTY_SITES');
4354: FETCH check_party_site_mosr_mapping into l_mosr_mapping_exist;
4355: IF l_mosr_mapping_exist = 'Y' THEN
4356: p_party_site_rec.orig_system := NULL;
4357: ELSE