DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on FND_GLOBAL

Line 659: last_updated_by = FND_GLOBAL.USER_ID,

655: AND (l_prev_source_line_id <> p_changed_attributes(l_counter).original_source_line_id) THEN
656: UPDATE WSH_DELIVERY_DETAILS
657: SET source_line_set_id = p_changed_attributes(l_counter).source_line_set_id,
658: last_update_date = SYSDATE,
659: last_updated_by = FND_GLOBAL.USER_ID,
660: last_update_login = FND_GLOBAL.LOGIN_ID
661: WHERE source_line_id = p_changed_attributes(l_counter).original_source_line_id
662: AND source_code = p_source_code
663: AND container_flag = 'N'

Line 660: last_update_login = FND_GLOBAL.LOGIN_ID

656: UPDATE WSH_DELIVERY_DETAILS
657: SET source_line_set_id = p_changed_attributes(l_counter).source_line_set_id,
658: last_update_date = SYSDATE,
659: last_updated_by = FND_GLOBAL.USER_ID,
660: last_update_login = FND_GLOBAL.LOGIN_ID
661: WHERE source_line_id = p_changed_attributes(l_counter).original_source_line_id
662: AND source_code = p_source_code
663: AND container_flag = 'N'
664: AND released_status <> 'D';

Line 776: last_updated_by = FND_GLOBAL.USER_ID,

772: --
773: UPDATE WSH_DELIVERY_DETAILS
774: SET source_line_id = p_changed_attributes(l_counter).source_line_id,
775: last_update_date = SYSDATE,
776: last_updated_by = FND_GLOBAL.USER_ID,
777: last_update_login = FND_GLOBAL.LOGIN_ID
778: WHERE delivery_detail_id = c.delivery_detail_id;
779:
780: --wrudge

Line 777: last_update_login = FND_GLOBAL.LOGIN_ID

773: UPDATE WSH_DELIVERY_DETAILS
774: SET source_line_id = p_changed_attributes(l_counter).source_line_id,
775: last_update_date = SYSDATE,
776: last_updated_by = FND_GLOBAL.USER_ID,
777: last_update_login = FND_GLOBAL.LOGIN_ID
778: WHERE delivery_detail_id = c.delivery_detail_id;
779:
780: --wrudge
781: -- bug 2121426: keep track of reservation quantity to transfer

Line 1264: last_updated_by = FND_GLOBAL.USER_ID,

1260:
1261: update wsh_delivery_details
1262: set requested_quantity = l_update_qty,
1263: last_update_date = SYSDATE,
1264: last_updated_by = FND_GLOBAL.USER_ID,
1265: last_update_login = FND_GLOBAL.LOGIN_ID
1266: where delivery_detail_id = crec.delivery_detail_id;
1267:
1268: IF l_debug_on THEN

Line 1265: last_update_login = FND_GLOBAL.LOGIN_ID

1261: update wsh_delivery_details
1262: set requested_quantity = l_update_qty,
1263: last_update_date = SYSDATE,
1264: last_updated_by = FND_GLOBAL.USER_ID,
1265: last_update_login = FND_GLOBAL.LOGIN_ID
1266: where delivery_detail_id = crec.delivery_detail_id;
1267:
1268: IF l_debug_on THEN
1269: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.Detail_Weight_Volume',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2976: last_updated_by = FND_GLOBAL.USER_ID,

2972: nvl(l_ignore_for_planning,nvl(ignore_for_planning,'N'))),
2973: -- Bug 3244272 : Added laste_update_date and last_updated_by in the
2974: -- update statement.
2975: last_update_date = SYSDATE,
2976: last_updated_by = FND_GLOBAL.USER_ID,
2977: last_update_login = FND_GLOBAL.LOGIN_ID
2978: WHERE source_code = p_source_code
2979: AND source_line_id = p_attributes_rec.source_line_id
2980: AND container_flag = 'N'

Line 2977: last_update_login = FND_GLOBAL.LOGIN_ID

2973: -- Bug 3244272 : Added laste_update_date and last_updated_by in the
2974: -- update statement.
2975: last_update_date = SYSDATE,
2976: last_updated_by = FND_GLOBAL.USER_ID,
2977: last_update_login = FND_GLOBAL.LOGIN_ID
2978: WHERE source_code = p_source_code
2979: AND source_line_id = p_attributes_rec.source_line_id
2980: AND container_flag = 'N'
2981: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,