DBA Data[Home] [Help]

APPS.FTE_PARTY_MERGE dependencies on HZ_UTILITY_V2PUB

Line 69: last_update_date = hz_utility_v2pub.last_update_date,

65: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
66:
67: UPDATE fte_location_parameters
68: SET facility_contact_id = p_to_fk_id,
69: last_update_date = hz_utility_v2pub.last_update_date,
70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,
72: request_id = hz_utility_v2pub.request_id,
73: program_application_id = hz_utility_v2pub.program_application_id,

Line 70: last_updated_by = hz_utility_v2pub.user_id,

66:
67: UPDATE fte_location_parameters
68: SET facility_contact_id = p_to_fk_id,
69: last_update_date = hz_utility_v2pub.last_update_date,
70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,
72: request_id = hz_utility_v2pub.request_id,
73: program_application_id = hz_utility_v2pub.program_application_id,
74: program_id = hz_utility_v2pub.program_id,

Line 71: last_update_login = hz_utility_v2pub.last_update_login,

67: UPDATE fte_location_parameters
68: SET facility_contact_id = p_to_fk_id,
69: last_update_date = hz_utility_v2pub.last_update_date,
70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,
72: request_id = hz_utility_v2pub.request_id,
73: program_application_id = hz_utility_v2pub.program_application_id,
74: program_id = hz_utility_v2pub.program_id,
75: program_update_date = sysdate

Line 72: request_id = hz_utility_v2pub.request_id,

68: SET facility_contact_id = p_to_fk_id,
69: last_update_date = hz_utility_v2pub.last_update_date,
70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,
72: request_id = hz_utility_v2pub.request_id,
73: program_application_id = hz_utility_v2pub.program_application_id,
74: program_id = hz_utility_v2pub.program_id,
75: program_update_date = sysdate
76: WHERE facility_contact_id = p_from_fk_id;

Line 73: program_application_id = hz_utility_v2pub.program_application_id,

69: last_update_date = hz_utility_v2pub.last_update_date,
70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,
72: request_id = hz_utility_v2pub.request_id,
73: program_application_id = hz_utility_v2pub.program_application_id,
74: program_id = hz_utility_v2pub.program_id,
75: program_update_date = sysdate
76: WHERE facility_contact_id = p_from_fk_id;
77:

Line 74: program_id = hz_utility_v2pub.program_id,

70: last_updated_by = hz_utility_v2pub.user_id,
71: last_update_login = hz_utility_v2pub.last_update_login,
72: request_id = hz_utility_v2pub.request_id,
73: program_application_id = hz_utility_v2pub.program_application_id,
74: program_id = hz_utility_v2pub.program_id,
75: program_update_date = sysdate
76: WHERE facility_contact_id = p_from_fk_id;
77:
78: END IF;