APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_PARTY_SITES

Line 1828: FROM HZ_PARTY_SITES

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

Line 1899: HZ_PARTY_SITES_PKG.Insert_Row (

1895: END IF;
1896:
1897:
1898: -- call table-handler.
1899: HZ_PARTY_SITES_PKG.Insert_Row (
1900: X_PARTY_SITE_ID => p_party_site_rec.party_site_id,
1901: X_PARTY_ID => p_party_site_rec.party_id,
1902: X_LOCATION_ID => p_party_site_rec.location_id,
1903: X_PARTY_SITE_NUMBER => p_party_site_rec.party_site_number,

Line 1943: 'HZ_PARTY_SITES',

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

Line 2041: FROM hz_party_sites

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

Line 2064: UPDATE hz_party_sites

2060: l_record_locked := 'Y';
2061: END;
2062:
2063: IF l_rowid IS NOT NULL AND l_record_locked <> 'Y' THEN
2064: UPDATE hz_party_sites
2065: SET identifying_address_flag = 'N'
2066: WHERE rowid = l_rowid;
2067: END IF;
2068:

Line 2206: HZ_PARTY_SITES_PKG.Select_Row (

2202: END IF;
2203:
2204: x_party_site_rec.party_site_id := p_party_site_id;
2205:
2206: HZ_PARTY_SITES_PKG.Select_Row (
2207: X_PARTY_SITE_ID => x_party_site_rec.party_site_id,
2208: X_PARTY_ID => x_party_site_rec.party_id,
2209: X_LOCATION_ID => x_party_site_rec.location_id,
2210: X_PARTY_SITE_NUMBER => x_party_site_rec.party_site_number,

Line 4122: FROM HZ_PARTY_SITES PS

4118: SELECT ROWID
4119: FROM HZ_PARTY_SITE_USES SU
4120: WHERE SU.PARTY_SITE_ID IN (
4121: SELECT PS.PARTY_SITE_ID
4122: FROM HZ_PARTY_SITES PS
4123: WHERE PARTY_ID = p_party_id )
4124: AND SU.PARTY_SITE_ID <> p_party_site_id
4125: AND SU.SITE_USE_TYPE = p_site_use_type
4126: AND SU.PRIMARY_PER_TYPE = 'Y'

Line 4215: FROM HZ_PARTY_SITES

4211: -- if this is the first party site use per type,,
4212: -- we need to mark it with primary_per_type = 'Y'.
4213: SELECT PARTY_ID
4214: INTO l_party_id
4215: FROM HZ_PARTY_SITES
4216: WHERE PARTY_SITE_ID = p_party_site_use_rec.party_site_id;
4217:
4218: IF p_party_site_use_rec.primary_per_type = 'Y' THEN --Bug No:3560167
4219: 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 4228: FROM HZ_PARTY_SITES PS

4224: INTO l_exist
4225: FROM HZ_PARTY_SITE_USES SU
4226: WHERE PARTY_SITE_ID IN (
4227: SELECT PARTY_SITE_ID
4228: FROM HZ_PARTY_SITES PS
4229: WHERE PS.PARTY_ID = l_party_id )
4230: AND SU.SITE_USE_TYPE = p_party_site_use_rec.site_use_type
4231: AND ROWNUM = 1;
4232: