DBA Data[Home] [Help]

APPS.AR_CMGT_PARTY_MERGE dependencies on HZ_UTILITY_PUB

Line 280: last_update_date = hz_utility_pub.last_update_date,

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;

Line 281: last_updated_by = hz_utility_pub.user_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:

Line 282: last_update_login = hz_utility_pub.last_update_login

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;

Line 364: last_update_date = hz_utility_pub.last_update_date,

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;

Line 365: last_updated_by = hz_utility_pub.user_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:

Line 366: last_update_login = hz_utility_pub.last_update_login

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;