DBA Data[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 266: UPDATE ap_supplier_sites_all --bug 3162861

262: FOR inactive_rec IN inactive_cur LOOP
263:
264: IF nvl(inactive_rec.ven_idate, inactive_date) <> nvl(inactive_rec.per_idate, inactive_date) THEN
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

Line 308: UPDATE ap_supplier_sites_all --bug 3162861

304: FOR inactive_rec1 IN inactive_cur1 LOOP
305:
306: IF nvl(inactive_rec1.ven_idate, inactive_date) <> nvl(inactive_rec1.per_idate, inactive_date) THEN
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