APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_PARTY_SITES

Line 1824: FROM HZ_PARTY_SITES

1820: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1821: -- There is no need to check if the data-source is selected.
1822:
1823: SELECT 'Y' INTO l_dummy
1824: FROM HZ_PARTY_SITES
1825: WHERE PARTY_ID = p_party_site_rec.party_id
1826: AND STATUS = 'A'
1827: /* AND HZ_MIXNM_UTILITY.isDataSourceSelected (
1828: g_pst_selected_datasources, actual_content_source ) = 'Y'*/

Line 1895: HZ_PARTY_SITES_PKG.Insert_Row (

1891: END IF;
1892:
1893:
1894: -- call table-handler.
1895: HZ_PARTY_SITES_PKG.Insert_Row (
1896: X_PARTY_SITE_ID => p_party_site_rec.party_site_id,
1897: X_PARTY_ID => p_party_site_rec.party_id,
1898: X_LOCATION_ID => p_party_site_rec.location_id,
1899: X_PARTY_SITE_NUMBER => p_party_site_rec.party_site_number,

Line 1939: 'HZ_PARTY_SITES',

1935: /*
1936: per HLD,mosr record should not be created for copy case, since old osr is still active
1937: hz_orig_system_ref_pvt.create_mosr_for_merge(
1938: FND_API.G_FALSE,
1939: 'HZ_PARTY_SITES',
1940: p_party_site_rec.party_site_id,
1941: x_return_status,
1942: l_msg_count,
1943: l_msg_data);

Line 2037: FROM hz_party_sites

2033: ) IS
2034:
2035: CURSOR c_party_sites IS
2036: SELECT rowid
2037: FROM hz_party_sites
2038: WHERE party_id = p_party_id
2039: AND party_site_id <> nvl(p_party_site_id,-999)
2040: AND identifying_address_flag = 'Y'
2041: AND rownum = 1

Line 2060: UPDATE hz_party_sites

2056: l_record_locked := 'Y';
2057: END;
2058:
2059: IF l_rowid IS NOT NULL AND l_record_locked <> 'Y' THEN
2060: UPDATE hz_party_sites
2061: SET identifying_address_flag = 'N'
2062: WHERE rowid = l_rowid;
2063: END IF;
2064:

Line 2200: HZ_PARTY_SITES_PKG.Select_Row (

2196: END IF;
2197:
2198: x_party_site_rec.party_site_id := p_party_site_id;
2199:
2200: HZ_PARTY_SITES_PKG.Select_Row (
2201: X_PARTY_SITE_ID => x_party_site_rec.party_site_id,
2202: X_PARTY_ID => x_party_site_rec.party_id,
2203: X_LOCATION_ID => x_party_site_rec.location_id,
2204: X_PARTY_SITE_NUMBER => x_party_site_rec.party_site_number,

Line 4084: FROM HZ_PARTY_SITES PS

4080: SELECT ROWID
4081: FROM HZ_PARTY_SITE_USES SU
4082: WHERE SU.PARTY_SITE_ID IN (
4083: SELECT PS.PARTY_SITE_ID
4084: FROM HZ_PARTY_SITES PS
4085: WHERE PARTY_ID = p_party_id )
4086: AND SU.PARTY_SITE_ID <> p_party_site_id
4087: AND SU.SITE_USE_TYPE = p_site_use_type
4088: AND SU.PRIMARY_PER_TYPE = 'Y'

Line 4177: FROM HZ_PARTY_SITES

4173: -- if this is the first party site use per type,,
4174: -- we need to mark it with primary_per_type = 'Y'.
4175: SELECT PARTY_ID
4176: INTO l_party_id
4177: FROM HZ_PARTY_SITES
4178: WHERE PARTY_SITE_ID = p_party_site_use_rec.party_site_id;
4179:
4180: IF p_party_site_use_rec.primary_per_type = 'Y' THEN --Bug No:3560167
4181: do_unmark_primary_per_type(l_party_id,p_party_site_use_rec.party_site_id,p_party_site_use_rec.site_use_type); --Bug No:3560167

Line 4190: FROM HZ_PARTY_SITES PS

4186: INTO l_exist
4187: FROM HZ_PARTY_SITE_USES SU
4188: WHERE PARTY_SITE_ID IN (
4189: SELECT PARTY_SITE_ID
4190: FROM HZ_PARTY_SITES PS
4191: WHERE PS.PARTY_ID = l_party_id )
4192: AND SU.SITE_USE_TYPE = p_party_site_use_rec.site_use_type
4193: AND ROWNUM = 1;
4194: