111: last_update_date = sysdate
112: WHERE vendor_id = p_dup_vendor_id
113: AND vendor_site_id = p_dup_vendor_site_id ;
114:
115: UPDATE po_rfq_vendors
116: SET vendor_id = p_vendor_id,
117: vendor_site_id = p_vendor_site_id,
118: last_updated_by = l_last_updated_by,
119: last_update_date = sysdate
119: last_update_date = sysdate
120: WHERE vendor_id = p_dup_vendor_id
121: AND vendor_site_id = p_dup_vendor_site_id ;
122:
123: DELETE from po_rfq_vendors prv
124: WHERE vendor_id = p_dup_vendor_id
125: AND vendor_site_id = p_dup_vendor_site_id;
126:
127: