APPS.HZ_MERGE_PKG dependencies on HZ_EDUCATION

Line 1830: 'HZ_EDUCATION','HZ_PARTIES',

1826:
1827: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1828: p_to_fk_id, p_par_entity_name,
1829: 'HZ_MERGE_PKG.education_merge',
1830: 'HZ_EDUCATION','HZ_PARTIES',
1831: 'EDUCATION_ID', 'PARTY_ID',x_return_status);
1832:
1833: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1834: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(

Line 1879: 'HZ_EDUCATION','HZ_PARTIES',

1875:
1876: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1877: p_to_fk_id, p_par_entity_name,
1878: 'HZ_MERGE_PKG.education_school_merge',
1879: 'HZ_EDUCATION','HZ_PARTIES',
1880: 'EDUCATION_ID', 'SCHOOL_PARTY_ID',x_return_status);
1881:
1882: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1883: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(

Line 3750: UPDATE HZ_EDUCATION

3746: BEGIN
3747:
3748: IF (x_to_id <> FND_API.G_MISS_NUM AND
3749: x_to_id <> p_from_id) THEN
3750: UPDATE HZ_EDUCATION
3751: SET
3752: STATUS = 'M',
3753: last_update_date = hz_utility_pub.last_update_date,
3754: last_updated_by = hz_utility_pub.user_id,

Line 3763: UPDATE HZ_EDUCATION

3759: program_update_date = sysdate
3760: WHERE education_id = p_from_id;
3761: ELSE
3762: -- Update and set party_id = p_to_fk_id where pk = from_id
3763: UPDATE HZ_EDUCATION
3764: SET
3765: party_id = p_to_fk_id,
3766: last_update_date = hz_utility_pub.last_update_date,
3767: last_updated_by = hz_utility_pub.user_id,

Line 3797: UPDATE HZ_EDUCATION

3793: BEGIN
3794:
3795: IF (x_to_id <> FND_API.G_MISS_NUM AND
3796: x_to_id <> p_from_id) THEN
3797: UPDATE HZ_EDUCATION
3798: SET
3799: STATUS = 'M',
3800: last_update_date = hz_utility_pub.last_update_date,
3801: last_updated_by = hz_utility_pub.user_id,

Line 3810: UPDATE HZ_EDUCATION

3806: program_update_date = sysdate
3807: WHERE education_id = p_from_id;
3808: ELSE
3809: -- Update and set party_id = p_to_fk_id where pk = from_id
3810: UPDATE HZ_EDUCATION
3811: SET
3812: school_party_id = p_to_fk_id,
3813: last_update_date = hz_utility_pub.last_update_date,
3814: last_updated_by = hz_utility_pub.user_id,