APPS.HZ_MERGE_PKG dependencies on HZ_EMPLOYMENT_HISTORY

Line 1928: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',

1924:
1925: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1926: p_to_fk_id, p_par_entity_name,
1927: 'HZ_MERGE_PKG.emp_history_merge',
1928: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',
1929: 'EMPLOYMENT_HISTORY_ID', 'PARTY_ID',x_return_status);
1930:
1931: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1932: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(

Line 1977: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',

1973:
1974: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1975: p_to_fk_id, p_par_entity_name,
1976: 'HZ_MERGE_PKG.emp_history_employed_merge',
1977: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',
1978: 'EMPLOYMENT_HISTORY_ID','EMPLOYED_BY_PARTY_ID',x_return_status);
1979:
1980: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1981: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(

Line 2026: 'HZ_WORK_CLASS', 'HZ_EMPLOYMENT_HISTORY',

2022:
2023: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2024: p_to_fk_id, p_par_entity_name,
2025: 'HZ_MERGE_PKG.work_class_merge',
2026: 'HZ_WORK_CLASS', 'HZ_EMPLOYMENT_HISTORY',
2027: 'WORK_CLASS_ID', 'EMPLOYMENT_HISTORY_ID', x_return_status);
2028:
2029: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2030: l_dup_exists := HZ_MERGE_DUP_CHECK.check_work_class_dup(

Line 3843: UPDATE HZ_EMPLOYMENT_HISTORY

3839: BEGIN
3840:
3841: IF (x_to_id <> FND_API.G_MISS_NUM AND
3842: x_to_id <> p_from_id) THEN
3843: UPDATE HZ_EMPLOYMENT_HISTORY
3844: SET
3845: STATUS = 'M',
3846: last_update_date = hz_utility_pub.last_update_date,
3847: last_updated_by = hz_utility_pub.user_id,

Line 3856: UPDATE HZ_EMPLOYMENT_HISTORY

3852: program_update_date = sysdate
3853: WHERE employment_history_id = p_from_id;
3854: ELSE
3855: -- Update and set party_id = p_to_fk_id where pk = from_id
3856: UPDATE HZ_EMPLOYMENT_HISTORY
3857: SET
3858: party_id = p_to_fk_id,
3859: last_update_date = hz_utility_pub.last_update_date,
3860: last_updated_by = hz_utility_pub.user_id,

Line 3890: UPDATE HZ_EMPLOYMENT_HISTORY

3886: BEGIN
3887:
3888: IF (x_to_id <> FND_API.G_MISS_NUM AND
3889: x_to_id <> p_from_id) THEN
3890: UPDATE HZ_EMPLOYMENT_HISTORY
3891: SET
3892: STATUS = 'M',
3893: last_update_date = hz_utility_pub.last_update_date,
3894: last_updated_by = hz_utility_pub.user_id,

Line 3903: UPDATE HZ_EMPLOYMENT_HISTORY

3899: program_update_date = sysdate
3900: WHERE employment_history_id = p_from_id;
3901: ELSE
3902: -- Update and set party_id = p_to_fk_id where pk = from_id
3903: UPDATE HZ_EMPLOYMENT_HISTORY
3904: SET
3905: employed_by_party_id = p_to_fk_id,
3906: last_update_date = hz_utility_pub.last_update_date,
3907: last_updated_by = hz_utility_pub.user_id,