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,
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,
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
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;
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:
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;