DBA Data[Home] [Help]

APPS.AP_TCA_SUPPLIER_SYNC_PKG dependencies on FND_GLOBAL

Line 385: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333

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

Line 386: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333

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

Line 392: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333

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

Line 393: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333

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: