DBA Data[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 224: UPDATE ap_supplier_sites_all --bug 3162861

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

Line 265: UPDATE ap_supplier_sites_all --bug 3162861

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