276:
277:
278: UPDATE AR_CUSTOMER_CALLS_ALL
279: SET phone_id = p_to_fk_id,
280: last_update_date = hz_utility_pub.last_update_date,
281: last_updated_by = hz_utility_pub.user_id,
282: last_update_login = hz_utility_pub.last_update_login
283: WHERE
284: phone_id = p_from_fk_id;
277:
278: UPDATE AR_CUSTOMER_CALLS_ALL
279: SET phone_id = p_to_fk_id,
280: last_update_date = hz_utility_pub.last_update_date,
281: last_updated_by = hz_utility_pub.user_id,
282: last_update_login = hz_utility_pub.last_update_login
283: WHERE
284: phone_id = p_from_fk_id;
285:
278: UPDATE AR_CUSTOMER_CALLS_ALL
279: SET phone_id = p_to_fk_id,
280: last_update_date = hz_utility_pub.last_update_date,
281: last_updated_by = hz_utility_pub.user_id,
282: last_update_login = hz_utility_pub.last_update_login
283: WHERE
284: phone_id = p_from_fk_id;
285:
286: end if;
360:
361:
362: UPDATE AR_CUSTOMER_CALL_TOPICS_ALL
363: SET phone_id = p_to_fk_id,
364: last_update_date = hz_utility_pub.last_update_date,
365: last_updated_by = hz_utility_pub.user_id,
366: last_update_login = hz_utility_pub.last_update_login
367: WHERE
368: phone_id = p_from_fk_id;
361:
362: UPDATE AR_CUSTOMER_CALL_TOPICS_ALL
363: SET phone_id = p_to_fk_id,
364: last_update_date = hz_utility_pub.last_update_date,
365: last_updated_by = hz_utility_pub.user_id,
366: last_update_login = hz_utility_pub.last_update_login
367: WHERE
368: phone_id = p_from_fk_id;
369:
362: UPDATE AR_CUSTOMER_CALL_TOPICS_ALL
363: SET phone_id = p_to_fk_id,
364: last_update_date = hz_utility_pub.last_update_date,
365: last_updated_by = hz_utility_pub.user_id,
366: last_update_login = hz_utility_pub.last_update_login
367: WHERE
368: phone_id = p_from_fk_id;
369:
370: end if;