381: --bug 8723400 starts
382: IF (x_vendor_site_id is not NULL) THEN
383: UPDATE ap_supplier_sites_all
384: SET last_update_date = SYSDATE -- B# 7646333
385: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333
386: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
387: WHERE location_id = x_location_id
388: AND vendor_site_id = l_check_vendor_site_id;
389: ELSE
382: IF (x_vendor_site_id is not NULL) THEN
383: UPDATE ap_supplier_sites_all
384: SET last_update_date = SYSDATE -- B# 7646333
385: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333
386: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
387: WHERE location_id = x_location_id
388: AND vendor_site_id = l_check_vendor_site_id;
389: ELSE
390: UPDATE ap_supplier_sites_all
388: AND vendor_site_id = l_check_vendor_site_id;
389: ELSE
390: UPDATE ap_supplier_sites_all
391: SET last_update_date = SYSDATE -- B# 7646333
392: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333
393: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
394: WHERE location_id = x_location_id;
395: END IF;
396: --bug 8723400 ends
389: ELSE
390: UPDATE ap_supplier_sites_all
391: SET last_update_date = SYSDATE -- B# 7646333
392: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333
393: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
394: WHERE location_id = x_location_id;
395: END IF;
396: --bug 8723400 ends
397: