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 6167: FROM HZ_PERSON_PROFILES

6163: ) IS
6164:
6165: CURSOR c_merge_to_per_prof(cp_cont_source VARCHAR2) IS
6166: SELECT person_profile_id
6167: FROM HZ_PERSON_PROFILES
6168: WHERE party_id = p_to_fk_id
6169: AND effective_end_date is null
6170: AND content_source_type = cp_cont_source;
6171:

Line 6174: FROM HZ_PERSON_PROFILES

6170: AND content_source_type = cp_cont_source;
6171:
6172: CURSOR c_cont_source IS
6173: SELECT CONTENT_SOURCE_TYPE
6174: FROM HZ_PERSON_PROFILES
6175: WHERE person_profile_id = p_from_id;
6176:
6177: l_cont_source VARCHAR2(50);
6178: l_to_perpro_id NUMBER;

Line 6196: UPDATE HZ_PERSON_PROFILES

6192: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
6193: FND_MSG_PUB.ADD;
6194: x_return_status := FND_API.G_RET_STS_ERROR;
6195: ELSE
6196: UPDATE HZ_PERSON_PROFILES
6197: SET
6198: party_id = p_to_fk_id,
6199: last_update_date = hz_utility_pub.last_update_date,
6200: last_updated_by = hz_utility_pub.user_id,

Line 6211: UPDATE HZ_PERSON_PROFILES

6207: END IF;
6208: ELSE
6209: CLOSE c_merge_to_per_prof;
6210:
6211: UPDATE HZ_PERSON_PROFILES
6212: SET
6213: STATUS = 'M',
6214: effective_end_date = trunc(SYSDATE-1),
6215: last_update_date = hz_utility_pub.last_update_date,