85: open c2;
86: fetch c2 into l_party_name;
87: close c2;
88:
89: IF (upper(p_entity_name) = 'JTF_FM_PREVIEWS_V')
90: THEN
91: update JTF_FM_PREVIEWS
92: set fm_party_id = p_to_fk_id,
93: last_update_date = hz_utility_pub.last_update_date,
87: close c2;
88:
89: IF (upper(p_entity_name) = 'JTF_FM_PREVIEWS_V')
90: THEN
91: update JTF_FM_PREVIEWS
92: set fm_party_id = p_to_fk_id,
93: last_update_date = hz_utility_pub.last_update_date,
94: last_updated_by = hz_utility_pub.user_id,
95: last_update_login = hz_utility_pub.last_update_login