106: program_id = hz_utility_pub.program_id,
107: program_update_date = sysdate
108: where incumbent_partner_party_id = p_from_fk_id;
109:
110: l_col_name := 'AS_LEAD_COMPETITORS.competitor_id';
111:
112: UPDATE AS_LEAD_COMPETITORS
113: set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
114: last_update_date = hz_utility_pub.last_update_date,
108: where incumbent_partner_party_id = p_from_fk_id;
109:
110: l_col_name := 'AS_LEAD_COMPETITORS.competitor_id';
111:
112: UPDATE AS_LEAD_COMPETITORS
113: set object_version_number = nvl(object_version_number,0) + 1, competitor_id = p_to_fk_id,
114: last_update_date = hz_utility_pub.last_update_date,
115: last_updated_by = hz_utility_pub.user_id,
116: last_update_login = hz_utility_pub.last_update_login,