184: AND vendor_id = l_to_vendor_id);
185:
186: UPDATE pos_supplier_mappings
187: SET vendor_id = l_to_vendor_id,
188: last_updated_by = fnd_global.user_id,
189: last_update_date = SYSDATE,
190: last_update_login = fnd_global.login_id
191: WHERE mapping_id IN (SELECT mapping_id
192: FROM pos_supplier_mappings
186: UPDATE pos_supplier_mappings
187: SET vendor_id = l_to_vendor_id,
188: last_updated_by = fnd_global.user_id,
189: last_update_date = SYSDATE,
190: last_update_login = fnd_global.login_id
191: WHERE mapping_id IN (SELECT mapping_id
192: FROM pos_supplier_mappings
193: WHERE party_id = p_to_fk_id);
194:
595: AND vendor_id = l_to_vendor_id);
596:
597: UPDATE pos_supplier_mappings
598: SET vendor_id = l_to_vendor_id,
599: last_updated_by = fnd_global.user_id,
600: last_update_date = SYSDATE,
601: last_update_login = fnd_global.login_id
602: WHERE mapping_id IN (SELECT mapping_id
603: FROM pos_supplier_mappings
597: UPDATE pos_supplier_mappings
598: SET vendor_id = l_to_vendor_id,
599: last_updated_by = fnd_global.user_id,
600: last_update_date = SYSDATE,
601: last_update_login = fnd_global.login_id
602: WHERE mapping_id IN (SELECT mapping_id
603: FROM pos_supplier_mappings
604: WHERE party_id = p_to_fk_id);
605: