DBA Data[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on FND_GLOBAL

Line 251: ,last_updated_by = fnd_global.user_id -- Bug 3191168

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;

Line 252: ,last_update_login = fnd_global.login_id -- Bug 3191168

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:

Line 269: ,last_updated_by = fnd_global.user_id -- Bug 3191168

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 */

Line 270: ,last_update_login = fnd_global.login_id -- Bug 3191168

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

Line 277: ,last_updated_by = fnd_global.user_id -- Bug 3191168

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:

Line 278: ,last_update_login = fnd_global.login_id -- Bug 3191168

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;

Line 295: ,last_updated_by = fnd_global.user_id -- Bug 3191168

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:

Line 296: ,last_update_login = fnd_global.login_id -- Bug 3191168

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;

Line 311: ,last_updated_by = fnd_global.user_id -- Bug 3191168

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 */

Line 312: ,last_update_login = fnd_global.login_id -- Bug 3191168

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

Line 319: ,last_updated_by = fnd_global.user_id -- Bug 3191168

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:

Line 320: ,last_update_login = fnd_global.login_id -- Bug 3191168

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;