436: if (p_from_fk_id <> p_to_fk_id) then
437:
438: update PA_PROJECT_REQUESTS
439: set CUST_PARTY_ID = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login,
443: record_version_number = nvl(record_Version_number,0) +1
444: where CUST_PARTY_ID = p_from_fk_id;
437:
438: update PA_PROJECT_REQUESTS
439: set CUST_PARTY_ID = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login,
443: record_version_number = nvl(record_Version_number,0) +1
444: where CUST_PARTY_ID = p_from_fk_id;
445:
438: update PA_PROJECT_REQUESTS
439: set CUST_PARTY_ID = p_to_fk_id,
440: last_update_date = hz_utility_pub.last_update_date,
441: last_updated_by = hz_utility_pub.user_id,
442: last_update_login = hz_utility_pub.last_update_login,
443: record_version_number = nvl(record_Version_number,0) +1
444: where CUST_PARTY_ID = p_from_fk_id;
445:
446: p_to_id := p_from_id;