eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WSH_USA_QUANTITY_PVT dependencies on FND_GLOBAL

Line 609: last_updated_by = FND_GLOBAL.USER_ID,

605: --
606: UPDATE WSH_DELIVERY_DETAILS
607: set src_requested_quantity = (src_requested_quantity - l_src_cancel_qty_allowed),
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.USER_ID,
610: last_update_login = FND_GLOBAL.LOGIN_ID
611: where source_code = p_source_code
612: and source_line_id = p_changed_attribute.source_line_id;
613: --

Line 610: last_update_login = FND_GLOBAL.LOGIN_ID

606: UPDATE WSH_DELIVERY_DETAILS
607: set src_requested_quantity = (src_requested_quantity - l_src_cancel_qty_allowed),
608: last_update_date = SYSDATE,
609: last_updated_by = FND_GLOBAL.USER_ID,
610: last_update_login = FND_GLOBAL.LOGIN_ID
611: where source_code = p_source_code
612: and source_line_id = p_changed_attribute.source_line_id;
613: --
614: IF l_debug_on THEN

Line 804: last_updated_by = FND_GLOBAL.USER_ID,

800: UPDATE wsh_delivery_details SET
801: requested_quantity = old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity,
802: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2, -- OPM B2187389
803: last_update_date = SYSDATE,
804: last_updated_by = FND_GLOBAL.USER_ID,
805: last_update_login = FND_GLOBAL.LOGIN_ID
806: WHERE source_line_id = old_delivery_detail_rec.source_line_id
807: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
808:

Line 805: last_update_login = FND_GLOBAL.LOGIN_ID

801: requested_quantity = old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity,
802: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2, -- OPM B2187389
803: last_update_date = SYSDATE,
804: last_updated_by = FND_GLOBAL.USER_ID,
805: last_update_login = FND_GLOBAL.LOGIN_ID
806: WHERE source_line_id = old_delivery_detail_rec.source_line_id
807: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
808:
809: -- DBI Project

Line 1560: last_updated_by = FND_GLOBAL.USER_ID,

1556:
1557: update wsh_delivery_details set
1558: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 - ABS(l_changed_detail_quantity2),
1559: last_update_date = SYSDATE,
1560: last_updated_by = FND_GLOBAL.USER_ID,
1561: last_update_login = FND_GLOBAL.LOGIN_ID
1562: where delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
1563:
1564:

Line 1561: last_update_login = FND_GLOBAL.LOGIN_ID

1557: update wsh_delivery_details set
1558: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 - ABS(l_changed_detail_quantity2),
1559: last_update_date = SYSDATE,
1560: last_updated_by = FND_GLOBAL.USER_ID,
1561: last_update_login = FND_GLOBAL.LOGIN_ID
1562: where delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
1563:
1564:
1565: END IF; -- Changed Quantity -- OPM B2187389

Line 2176: last_updated_by = FND_GLOBAL.USER_ID,

2172: locator_id = NULL,
2173: cancelled_quantity = 0,
2174: cancelled_quantity2 = 0,
2175: last_update_date = SYSDATE,
2176: last_updated_by = FND_GLOBAL.USER_ID,
2177: last_update_login = FND_GLOBAL.LOGIN_ID
2178: WHERE source_line_id = p_source_line_id
2179: AND source_code = p_source_code
2180: AND released_status in ('S','Y')

Line 2177: last_update_login = FND_GLOBAL.LOGIN_ID

2173: cancelled_quantity = 0,
2174: cancelled_quantity2 = 0,
2175: last_update_date = SYSDATE,
2176: last_updated_by = FND_GLOBAL.USER_ID,
2177: last_update_login = FND_GLOBAL.LOGIN_ID
2178: WHERE source_line_id = p_source_line_id
2179: AND source_code = p_source_code
2180: AND released_status in ('S','Y')
2181: AND requested_quantity = 0

Line 2340: p_logging_entity_id => FND_GLOBAL.USER_ID,

2336: x_exception_id => l_dummy_exception_id ,
2337: p_logged_at_location_id => l_exception_location_id,
2338: p_exception_location_id => l_exception_location_id,
2339: p_logging_entity => 'SHIPPER',
2340: p_logging_entity_id => FND_GLOBAL.USER_ID,
2341: p_exception_name => 'WSH_CHANGED_QUANTITY',
2342: p_message => l_msg,
2343: p_delivery_detail_id => nvl(p_parent_delivery_detail_id,p_delivery_detail_id),
2344: p_delivery_assignment_id => l_delivery_assignment_id,

Line 2611: last_updated_by = FND_GLOBAL.USER_ID,

2607: cycle_count_quantity2 = decode(cycle_count_quantity2,null,null,0,0,(p_requested_quantity2 - nvl(p_shipped_quantity2,0)) - ABS(p_changed_detail_quantity2)),
2608: cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity),
2609: cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2),
2610: last_update_date = SYSDATE,
2611: last_updated_by = FND_GLOBAL.USER_ID,
2612: last_update_login = FND_GLOBAL.LOGIN_ID
2613: where delivery_detail_id = p_delivery_detail_id;
2614: ELSE
2615: UPDATE wsh_delivery_details SET

Line 2612: last_update_login = FND_GLOBAL.LOGIN_ID

2608: cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity),
2609: cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2),
2610: last_update_date = SYSDATE,
2611: last_updated_by = FND_GLOBAL.USER_ID,
2612: last_update_login = FND_GLOBAL.LOGIN_ID
2613: where delivery_detail_id = p_delivery_detail_id;
2614: ELSE
2615: UPDATE wsh_delivery_details SET
2616: requested_quantity = p_requested_quantity - ABS(p_changed_detail_quantity),

Line 2629: last_updated_by = FND_GLOBAL.USER_ID,

2625: cycle_count_quantity2 = decode(cycle_count_quantity2,null,null,0),
2626: cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity),
2627: cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2),
2628: last_update_date = SYSDATE,
2629: last_updated_by = FND_GLOBAL.USER_ID,
2630: last_update_login = FND_GLOBAL.LOGIN_ID
2631: WHERE delivery_detail_id = p_delivery_detail_id;
2632: --
2633: END IF; -- end of comparison between requested - detail with shipped quantity

Line 2630: last_update_login = FND_GLOBAL.LOGIN_ID

2626: cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity),
2627: cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2),
2628: last_update_date = SYSDATE,
2629: last_updated_by = FND_GLOBAL.USER_ID,
2630: last_update_login = FND_GLOBAL.LOGIN_ID
2631: WHERE delivery_detail_id = p_delivery_detail_id;
2632: --
2633: END IF; -- end of comparison between requested - detail with shipped quantity
2634:

Line 2883: last_updated_by = FND_GLOBAL.USER_ID,

2879: locator_id = NULL,
2880: cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity,
2881: cancelled_quantity2 = nvl(cancelled_quantity2,0) + p_requested_quantity2,
2882: last_update_date = SYSDATE,
2883: last_updated_by = FND_GLOBAL.USER_ID,
2884: last_update_login = FND_GLOBAL.LOGIN_ID
2885: where delivery_detail_id = p_delivery_detail_id;
2886:
2887: --bug# 6689448 (replenishment project) (Begin) : added the code to call WMS api for replenshment requested delivery

Line 2884: last_update_login = FND_GLOBAL.LOGIN_ID

2880: cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity,
2881: cancelled_quantity2 = nvl(cancelled_quantity2,0) + p_requested_quantity2,
2882: last_update_date = SYSDATE,
2883: last_updated_by = FND_GLOBAL.USER_ID,
2884: last_update_login = FND_GLOBAL.LOGIN_ID
2885: where delivery_detail_id = p_delivery_detail_id;
2886:
2887: --bug# 6689448 (replenishment project) (Begin) : added the code to call WMS api for replenshment requested delivery
2888: -- detail lines with zeqo qty so that WMS deletes the replenishment record.