APPS.HZ_MERGE_PKG dependencies on HZ_PERSON_LANGUAGE

Line 2271: 'HZ_PERSON_LANGUAGE','HZ_PARTIES',

2267:
2268: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2269: p_to_fk_id, p_par_entity_name,
2270: 'HZ_MERGE_PKG.per_languages_merge',
2271: 'HZ_PERSON_LANGUAGE','HZ_PARTIES',
2272: 'LANGUAGE_USE_REFERENCE_ID', 'PARTY_ID',x_return_status);
2273:
2274: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2275: l_dup_exists := HZ_MERGE_DUP_CHECK.check_languages_dup(

Line 4375: FROM HZ_PERSON_LANGUAGE

4371: l_fp_nav_flag VARCHAR2(1);
4372:
4373: Cursor C_From_Lang IS
4374: SELECT primary_language_indicator,native_language
4375: FROM HZ_PERSON_LANGUAGE
4376: WHERE LANGUAGE_USE_REFERENCE_ID = p_from_id;
4377:
4378: BEGIN
4379: IF (x_to_id <> FND_API.G_MISS_NUM AND

Line 4381: UPDATE HZ_PERSON_LANGUAGE

4377:
4378: BEGIN
4379: IF (x_to_id <> FND_API.G_MISS_NUM AND
4380: x_to_id <> p_from_id) THEN
4381: UPDATE HZ_PERSON_LANGUAGE
4382: SET
4383: STATUS = 'M',
4384: last_update_date = hz_utility_pub.last_update_date,
4385: last_updated_by = hz_utility_pub.user_id,

Line 4401: FROM HZ_PERSON_LANGUAGE

4397: IF l_fp_pri_ind_flag = 'Y' THEN
4398: BEGIN
4399: SELECT 'Exists'
4400: INTO l_exists
4401: FROM HZ_PERSON_LANGUAGE
4402: WHERE PRIMARY_LANGUAGE_INDICATOR = 'Y'
4403: AND PARTY_ID = p_to_fk_id
4404: AND ROWNUM = 1;
4405: EXCEPTION

Line 4415: FROM HZ_PERSON_LANGUAGE

4411: IF l_fp_nav_flag = 'Y' THEN
4412: BEGIN
4413: SELECT 'Exists'
4414: INTO l_exists
4415: FROM HZ_PERSON_LANGUAGE
4416: WHERE NATIVE_LANGUAGE = 'Y'
4417: AND PARTY_ID = p_to_fk_id
4418: AND ROWNUM = 1;
4419: EXCEPTION

Line 4441: UPDATE HZ_PERSON_LANGUAGE

4437: CLOSE C_Lang1;
4438:
4439: */
4440: -- Update and set party_id = p_to_fk_id where pk = from_id
4441: UPDATE HZ_PERSON_LANGUAGE
4442: SET
4443: party_id = p_to_fk_id,
4444: primary_language_indicator = l_primary_lang_flag,
4445: native_language = l_primary_nav_flag,