247:
248: UPDATE ap_suppliers
249: SET vendor_name = name_rec.per_vendor_name
250: ,last_update_date = sysdate -- Bug 3191168
251: ,last_updated_by = fnd_global.user_id -- Bug 3191168
252: ,last_update_login = fnd_global.login_id -- Bug 3191168
253: WHERE vendor_id = name_rec.ven_vendor_id;
254:
255: END IF;
248: UPDATE ap_suppliers
249: SET vendor_name = name_rec.per_vendor_name
250: ,last_update_date = sysdate -- Bug 3191168
251: ,last_updated_by = fnd_global.user_id -- Bug 3191168
252: ,last_update_login = fnd_global.login_id -- Bug 3191168
253: WHERE vendor_id = name_rec.ven_vendor_id;
254:
255: END IF;
256:
265:
266: UPDATE ap_supplier_sites_all --bug 3162861
267: SET inactive_date = inactive_rec.per_idate
268: ,last_update_date = sysdate -- Bug 3191168
269: ,last_updated_by = fnd_global.user_id -- Bug 3191168
270: ,last_update_login = fnd_global.login_id -- Bug 3191168
271: WHERE vendor_id = inactive_rec.ven_vendor_id;
272:
273: /* Bug 1561680 */
266: UPDATE ap_supplier_sites_all --bug 3162861
267: SET inactive_date = inactive_rec.per_idate
268: ,last_update_date = sysdate -- Bug 3191168
269: ,last_updated_by = fnd_global.user_id -- Bug 3191168
270: ,last_update_login = fnd_global.login_id -- Bug 3191168
271: WHERE vendor_id = inactive_rec.ven_vendor_id;
272:
273: /* Bug 1561680 */
274: UPDATE ap_suppliers
273: /* Bug 1561680 */
274: UPDATE ap_suppliers
275: SET end_date_active = inactive_rec.per_idate
276: ,last_update_date = sysdate -- Bug 3191168
277: ,last_updated_by = fnd_global.user_id -- Bug 3191168
278: ,last_update_login = fnd_global.login_id -- Bug 3191168
279: WHERE vendor_id = inactive_rec.ven_vendor_id;
280: END IF;
281:
274: UPDATE ap_suppliers
275: SET end_date_active = inactive_rec.per_idate
276: ,last_update_date = sysdate -- Bug 3191168
277: ,last_updated_by = fnd_global.user_id -- Bug 3191168
278: ,last_update_login = fnd_global.login_id -- Bug 3191168
279: WHERE vendor_id = inactive_rec.ven_vendor_id;
280: END IF;
281:
282: END LOOP;
291:
292: UPDATE ap_suppliers
293: SET vendor_name = name_rec1.per_vendor_name
294: ,last_update_date = sysdate -- Bug 3191168
295: ,last_updated_by = fnd_global.user_id -- Bug 3191168
296: ,last_update_login = fnd_global.login_id -- Bug 3191168
297: WHERE vendor_id = name_rec1.ven_vendor_id;
298: END IF;
299:
292: UPDATE ap_suppliers
293: SET vendor_name = name_rec1.per_vendor_name
294: ,last_update_date = sysdate -- Bug 3191168
295: ,last_updated_by = fnd_global.user_id -- Bug 3191168
296: ,last_update_login = fnd_global.login_id -- Bug 3191168
297: WHERE vendor_id = name_rec1.ven_vendor_id;
298: END IF;
299:
300: END LOOP;
307:
308: UPDATE ap_supplier_sites_all --bug 3162861
309: SET inactive_date = inactive_rec1.per_idate
310: ,last_update_date = sysdate -- Bug 3191168
311: ,last_updated_by = fnd_global.user_id -- Bug 3191168
312: ,last_update_login = fnd_global.login_id -- Bug 3191168
313: WHERE vendor_id = inactive_rec1.ven_vendor_id;
314:
315: /* Bug 1561680 */
308: UPDATE ap_supplier_sites_all --bug 3162861
309: SET inactive_date = inactive_rec1.per_idate
310: ,last_update_date = sysdate -- Bug 3191168
311: ,last_updated_by = fnd_global.user_id -- Bug 3191168
312: ,last_update_login = fnd_global.login_id -- Bug 3191168
313: WHERE vendor_id = inactive_rec1.ven_vendor_id;
314:
315: /* Bug 1561680 */
316: UPDATE ap_suppliers
315: /* Bug 1561680 */
316: UPDATE ap_suppliers
317: SET end_date_active = inactive_rec1.per_idate
318: ,last_update_date = sysdate -- Bug 3191168
319: ,last_updated_by = fnd_global.user_id -- Bug 3191168
320: ,last_update_login = fnd_global.login_id -- Bug 3191168
321: WHERE vendor_id = inactive_rec1.ven_vendor_id;
322: END IF;
323:
316: UPDATE ap_suppliers
317: SET end_date_active = inactive_rec1.per_idate
318: ,last_update_date = sysdate -- Bug 3191168
319: ,last_updated_by = fnd_global.user_id -- Bug 3191168
320: ,last_update_login = fnd_global.login_id -- Bug 3191168
321: WHERE vendor_id = inactive_rec1.ven_vendor_id;
322: END IF;
323:
324: END LOOP;