DBA Data[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on FND_GLOBAL

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

205: IF nvl(name_rec.ven_vendor_name,'EMPTY') <> nvl(name_rec.per_vendor_name,'EMPTY') THEN
206: UPDATE ap_suppliers
207: SET vendor_name = name_rec.per_vendor_name
208: ,last_update_date = sysdate -- Bug 3191168
209: ,last_updated_by = fnd_global.user_id -- Bug 3191168
210: ,last_update_login = fnd_global.login_id -- Bug 3191168
211: WHERE vendor_id = name_rec.ven_vendor_id;
212:
213: END IF;

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

206: UPDATE ap_suppliers
207: SET vendor_name = name_rec.per_vendor_name
208: ,last_update_date = sysdate -- Bug 3191168
209: ,last_updated_by = fnd_global.user_id -- Bug 3191168
210: ,last_update_login = fnd_global.login_id -- Bug 3191168
211: WHERE vendor_id = name_rec.ven_vendor_id;
212:
213: END IF;
214:

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

223:
224: UPDATE ap_supplier_sites_all --bug 3162861
225: SET inactive_date = inactive_rec.per_idate
226: ,last_update_date = sysdate -- Bug 3191168
227: ,last_updated_by = fnd_global.user_id -- Bug 3191168
228: ,last_update_login = fnd_global.login_id -- Bug 3191168
229: WHERE vendor_id = inactive_rec.ven_vendor_id;
230:
231: /* Bug 1561680 */

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

224: UPDATE ap_supplier_sites_all --bug 3162861
225: SET inactive_date = inactive_rec.per_idate
226: ,last_update_date = sysdate -- Bug 3191168
227: ,last_updated_by = fnd_global.user_id -- Bug 3191168
228: ,last_update_login = fnd_global.login_id -- Bug 3191168
229: WHERE vendor_id = inactive_rec.ven_vendor_id;
230:
231: /* Bug 1561680 */
232: UPDATE ap_suppliers

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

231: /* Bug 1561680 */
232: UPDATE ap_suppliers
233: SET end_date_active = inactive_rec.per_idate
234: ,last_update_date = sysdate -- Bug 3191168
235: ,last_updated_by = fnd_global.user_id -- Bug 3191168
236: ,last_update_login = fnd_global.login_id -- Bug 3191168
237: WHERE vendor_id = inactive_rec.ven_vendor_id;
238: END IF;
239:

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

232: UPDATE ap_suppliers
233: SET end_date_active = inactive_rec.per_idate
234: ,last_update_date = sysdate -- Bug 3191168
235: ,last_updated_by = fnd_global.user_id -- Bug 3191168
236: ,last_update_login = fnd_global.login_id -- Bug 3191168
237: WHERE vendor_id = inactive_rec.ven_vendor_id;
238: END IF;
239:
240: END LOOP;

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

248: IF nvl(name_rec1.ven_vendor_name,'EMPTY') <> nvl(name_rec1.per_vendor_name,'EMPTY') THEN
249: UPDATE ap_suppliers
250: SET vendor_name = name_rec1.per_vendor_name
251: ,last_update_date = sysdate -- Bug 3191168
252: ,last_updated_by = fnd_global.user_id -- Bug 3191168
253: ,last_update_login = fnd_global.login_id -- Bug 3191168
254: WHERE vendor_id = name_rec1.ven_vendor_id;
255: END IF;
256:

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

249: UPDATE ap_suppliers
250: SET vendor_name = name_rec1.per_vendor_name
251: ,last_update_date = sysdate -- Bug 3191168
252: ,last_updated_by = fnd_global.user_id -- Bug 3191168
253: ,last_update_login = fnd_global.login_id -- Bug 3191168
254: WHERE vendor_id = name_rec1.ven_vendor_id;
255: END IF;
256:
257: END LOOP;

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

264:
265: UPDATE ap_supplier_sites_all --bug 3162861
266: SET inactive_date = inactive_rec1.per_idate
267: ,last_update_date = sysdate -- Bug 3191168
268: ,last_updated_by = fnd_global.user_id -- Bug 3191168
269: ,last_update_login = fnd_global.login_id -- Bug 3191168
270: WHERE vendor_id = inactive_rec1.ven_vendor_id;
271:
272: /* Bug 1561680 */

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

265: UPDATE ap_supplier_sites_all --bug 3162861
266: SET inactive_date = inactive_rec1.per_idate
267: ,last_update_date = sysdate -- Bug 3191168
268: ,last_updated_by = fnd_global.user_id -- Bug 3191168
269: ,last_update_login = fnd_global.login_id -- Bug 3191168
270: WHERE vendor_id = inactive_rec1.ven_vendor_id;
271:
272: /* Bug 1561680 */
273: UPDATE ap_suppliers

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

272: /* Bug 1561680 */
273: UPDATE ap_suppliers
274: SET end_date_active = inactive_rec1.per_idate
275: ,last_update_date = sysdate -- Bug 3191168
276: ,last_updated_by = fnd_global.user_id -- Bug 3191168
277: ,last_update_login = fnd_global.login_id -- Bug 3191168
278: WHERE vendor_id = inactive_rec1.ven_vendor_id;
279: END IF;
280:

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

273: UPDATE ap_suppliers
274: SET end_date_active = inactive_rec1.per_idate
275: ,last_update_date = sysdate -- Bug 3191168
276: ,last_updated_by = fnd_global.user_id -- Bug 3191168
277: ,last_update_login = fnd_global.login_id -- Bug 3191168
278: WHERE vendor_id = inactive_rec1.ven_vendor_id;
279: END IF;
280:
281: END LOOP;