DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on FND_GLOBAL

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

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

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

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

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

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

Line 3363: ,FND_GLOBAL.USER_ID

3359: ,GLOBAL_ATTRIBUTE20
3360: ,CREATION_DATE
3361: ,CREATED_BY
3362: ,sysdate
3363: ,FND_GLOBAL.USER_ID
3364: ,FND_GLOBAL.LOGIN_ID
3365: ,PROGRAM_APPLICATION_ID
3366: ,PROGRAM_ID
3367: ,PROGRAM_UPDATE_DATE

Line 3364: ,FND_GLOBAL.LOGIN_ID

3360: ,CREATION_DATE
3361: ,CREATED_BY
3362: ,sysdate
3363: ,FND_GLOBAL.USER_ID
3364: ,FND_GLOBAL.LOGIN_ID
3365: ,PROGRAM_APPLICATION_ID
3366: ,PROGRAM_ID
3367: ,PROGRAM_UPDATE_DATE
3368: ,REQUEST_ID

Line 3718: ,last_updated_by = FND_GLOBAL.USER_ID

3714: SET
3715: TMS_VERSION_NUMBER = l_new_tms_version_number_tab(j)
3716: ,TMS_INTERFACE_FLAG = l_new_tms_interface_flag_tab(j)
3717: ,last_update_date = SYSDATE
3718: ,last_updated_by = FND_GLOBAL.USER_ID
3719: ,last_update_login = FND_GLOBAL.LOGIN_ID
3720: WHERE DELIVERY_ID = l_delivery_id_tab(j);
3721:
3722: IF l_debug_on THEN

Line 3719: ,last_update_login = FND_GLOBAL.LOGIN_ID

3715: TMS_VERSION_NUMBER = l_new_tms_version_number_tab(j)
3716: ,TMS_INTERFACE_FLAG = l_new_tms_interface_flag_tab(j)
3717: ,last_update_date = SYSDATE
3718: ,last_updated_by = FND_GLOBAL.USER_ID
3719: ,last_update_login = FND_GLOBAL.LOGIN_ID
3720: WHERE DELIVERY_ID = l_delivery_id_tab(j);
3721:
3722: IF l_debug_on THEN
3723: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);