APPS.HZ_MERGE_PKG dependencies on HZ_PERSON_PROFILES

Line 542: 'HZ_PERSON_PROFILES','HZ_PARTIES',

538:
539: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
540: p_to_fk_id, p_par_entity_name,
541: 'HZ_MERGE_PKG.per_profile_merge',
542: 'HZ_PERSON_PROFILES','HZ_PARTIES',
543: 'PERSON_PROFILE_ID', 'PARTY_ID',x_return_status);
544:
545: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
546: do_per_profile_merge(p_from_id, l_to_id,p_from_fk_id,p_to_fk_id,

Line 6037: FROM HZ_PERSON_PROFILES

6033: ) IS
6034:
6035: CURSOR c_merge_to_per_prof(cp_cont_source VARCHAR2) IS
6036: SELECT person_profile_id
6037: FROM HZ_PERSON_PROFILES
6038: WHERE party_id = p_to_fk_id
6039: AND effective_end_date is null
6040: AND content_source_type = cp_cont_source;
6041:

Line 6044: FROM HZ_PERSON_PROFILES

6040: AND content_source_type = cp_cont_source;
6041:
6042: CURSOR c_cont_source IS
6043: SELECT CONTENT_SOURCE_TYPE
6044: FROM HZ_PERSON_PROFILES
6045: WHERE person_profile_id = p_from_id;
6046:
6047: l_cont_source VARCHAR2(50);
6048: l_to_perpro_id NUMBER;

Line 6066: UPDATE HZ_PERSON_PROFILES

6062: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
6063: FND_MSG_PUB.ADD;
6064: x_return_status := FND_API.G_RET_STS_ERROR;
6065: ELSE
6066: UPDATE HZ_PERSON_PROFILES
6067: SET
6068: party_id = p_to_fk_id,
6069: last_update_date = hz_utility_pub.last_update_date,
6070: last_updated_by = hz_utility_pub.user_id,

Line 6081: UPDATE HZ_PERSON_PROFILES

6077: END IF;
6078: ELSE
6079: CLOSE c_merge_to_per_prof;
6080:
6081: UPDATE HZ_PERSON_PROFILES
6082: SET
6083: STATUS = 'M',
6084: effective_end_date = trunc(SYSDATE-1),
6085: last_update_date = hz_utility_pub.last_update_date,