DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on FND_GLOBAL

Line 406: ,nvl(p_delivery_info.created_by,FND_GLOBAL.USER_ID)

402: ,p_delivery_info.global_attribute18
403: ,p_delivery_info.global_attribute19
404: ,p_delivery_info.global_attribute20
405: ,nvl(p_delivery_info.creation_date, SYSDATE)
406: ,nvl(p_delivery_info.created_by,FND_GLOBAL.USER_ID)
407: ,nvl(p_delivery_info.last_update_date, SYSDATE)
408: ,nvl(p_delivery_info.last_updated_by,FND_GLOBAL.USER_ID)
409: ,nvl(p_delivery_info.last_update_login,FND_GLOBAL.LOGIN_ID)
410: ,p_delivery_info.program_application_id

Line 408: ,nvl(p_delivery_info.last_updated_by,FND_GLOBAL.USER_ID)

404: ,p_delivery_info.global_attribute20
405: ,nvl(p_delivery_info.creation_date, SYSDATE)
406: ,nvl(p_delivery_info.created_by,FND_GLOBAL.USER_ID)
407: ,nvl(p_delivery_info.last_update_date, SYSDATE)
408: ,nvl(p_delivery_info.last_updated_by,FND_GLOBAL.USER_ID)
409: ,nvl(p_delivery_info.last_update_login,FND_GLOBAL.LOGIN_ID)
410: ,p_delivery_info.program_application_id
411: ,p_delivery_info.program_id
412: ,p_delivery_info.program_update_date

Line 409: ,nvl(p_delivery_info.last_update_login,FND_GLOBAL.LOGIN_ID)

405: ,nvl(p_delivery_info.creation_date, SYSDATE)
406: ,nvl(p_delivery_info.created_by,FND_GLOBAL.USER_ID)
407: ,nvl(p_delivery_info.last_update_date, SYSDATE)
408: ,nvl(p_delivery_info.last_updated_by,FND_GLOBAL.USER_ID)
409: ,nvl(p_delivery_info.last_update_login,FND_GLOBAL.LOGIN_ID)
410: ,p_delivery_info.program_application_id
411: ,p_delivery_info.program_id
412: ,p_delivery_info.program_update_date
413: ,p_delivery_info.request_id

Line 3383: ,FND_GLOBAL.USER_ID

3379: ,GLOBAL_ATTRIBUTE20
3380: ,CREATION_DATE
3381: ,CREATED_BY
3382: ,sysdate
3383: ,FND_GLOBAL.USER_ID
3384: ,FND_GLOBAL.LOGIN_ID
3385: ,PROGRAM_APPLICATION_ID
3386: ,PROGRAM_ID
3387: ,PROGRAM_UPDATE_DATE

Line 3384: ,FND_GLOBAL.LOGIN_ID

3380: ,CREATION_DATE
3381: ,CREATED_BY
3382: ,sysdate
3383: ,FND_GLOBAL.USER_ID
3384: ,FND_GLOBAL.LOGIN_ID
3385: ,PROGRAM_APPLICATION_ID
3386: ,PROGRAM_ID
3387: ,PROGRAM_UPDATE_DATE
3388: ,REQUEST_ID

Line 3742: ,last_updated_by = FND_GLOBAL.USER_ID

3738: SET
3739: TMS_VERSION_NUMBER = l_new_tms_version_number_tab(j)
3740: ,TMS_INTERFACE_FLAG = l_new_tms_interface_flag_tab(j)
3741: ,last_update_date = SYSDATE
3742: ,last_updated_by = FND_GLOBAL.USER_ID
3743: ,last_update_login = FND_GLOBAL.LOGIN_ID
3744: WHERE DELIVERY_ID = l_delivery_id_tab(j);
3745:
3746: IF l_debug_on THEN

Line 3743: ,last_update_login = FND_GLOBAL.LOGIN_ID

3739: TMS_VERSION_NUMBER = l_new_tms_version_number_tab(j)
3740: ,TMS_INTERFACE_FLAG = l_new_tms_interface_flag_tab(j)
3741: ,last_update_date = SYSDATE
3742: ,last_updated_by = FND_GLOBAL.USER_ID
3743: ,last_update_login = FND_GLOBAL.LOGIN_ID
3744: WHERE DELIVERY_ID = l_delivery_id_tab(j);
3745:
3746: IF l_debug_on THEN
3747: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);