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 3748: UPDATE HZ_EDUCATION

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

Line 3761: UPDATE HZ_EDUCATION

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

Line 3795: UPDATE HZ_EDUCATION

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

Line 3808: UPDATE HZ_EDUCATION

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