APPS.HZ_MERGE_PKG dependencies on HZ_PARTY_SITE_USES

Line 2320: 'HZ_PARTY_SITE_USES','HZ_PARTY_SITES',

2316:
2317: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2318: p_to_fk_id, p_par_entity_name,
2319: 'HZ_MERGE_PKG.party_site_use_merge',
2320: 'HZ_PARTY_SITE_USES','HZ_PARTY_SITES',
2321: 'PARTY_SITE_USE_ID', 'PARTY_SITE_ID',x_return_status);
2322:
2323: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2324: l_dup_exists := HZ_MERGE_DUP_CHECK.check_party_site_use_dup(

Line 4484: IS SELECT 1 FROM HZ_PARTY_SITE_USES SU

4480: WHERE PARTY_SITE_ID = p_party_site_id
4481: AND ROWNUM =1;
4482:
4483: CURSOR c_prim_site_uses(p_party_id NUMBER,p_party_site_id NUMBER,p_site_use_type VARCHAR2,p_request_id NUMBER)
4484: IS SELECT 1 FROM HZ_PARTY_SITE_USES SU
4485: WHERE SU.PARTY_SITE_ID IN (
4486: SELECT PS.PARTY_SITE_ID
4487: FROM HZ_PARTY_SITES PS
4488: WHERE PARTY_ID = p_party_id )

Line 4503: UPDATE HZ_PARTY_SITE_USES

4499: BEGIN
4500:
4501: IF (x_to_id <> FND_API.G_MISS_NUM AND
4502: x_to_id <> p_from_id) THEN
4503: UPDATE HZ_PARTY_SITE_USES
4504: SET
4505: ----Bug: 2619948 added setting status to 'M' here too
4506: STATUS = 'M',
4507: last_update_date = hz_utility_pub.last_update_date,

Line 4570: UPDATE HZ_PARTY_SITE_USES

4566: RETURN;
4567: END IF;
4568:
4569: -- Update and set party_id = p_to_fk_id where pk = from_id
4570: UPDATE HZ_PARTY_SITE_USES
4571: SET
4572: STATUS = 'M',
4573: last_update_date = hz_utility_pub.last_update_date,
4574: last_updated_by = hz_utility_pub.user_id,