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 4486: IS SELECT 1, request_id FROM HZ_PARTY_SITE_USES SU

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

Line 4507: UPDATE HZ_PARTY_SITE_USES

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

Line 4576: UPDATE HZ_PARTY_SITE_USES

4572: RETURN;
4573: END IF;
4574:
4575: -- Update and set party_id = p_to_fk_id where pk = from_id
4576: UPDATE HZ_PARTY_SITE_USES
4577: SET
4578: STATUS = 'M',
4579: last_update_date = hz_utility_pub.last_update_date,
4580: last_updated_by = hz_utility_pub.user_id,