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 4377: FROM HZ_PERSON_LANGUAGE

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

Line 4383: UPDATE HZ_PERSON_LANGUAGE

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

Line 4403: FROM HZ_PERSON_LANGUAGE

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

Line 4417: FROM HZ_PERSON_LANGUAGE

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

Line 4443: UPDATE HZ_PERSON_LANGUAGE

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