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.

APPS.WSH_USA_QUANTITY_PVT dependencies on FND_GLOBAL

Line 669: last_updated_by = FND_GLOBAL.USER_ID,

665: --
666: UPDATE WSH_DELIVERY_DETAILS
667: set src_requested_quantity = (src_requested_quantity - l_src_cancel_qty_allowed),
668: last_update_date = SYSDATE,
669: last_updated_by = FND_GLOBAL.USER_ID,
670: last_update_login = FND_GLOBAL.LOGIN_ID
671: where source_code = p_source_code
672: and source_line_id = p_changed_attribute.source_line_id;
673: --

Line 670: last_update_login = FND_GLOBAL.LOGIN_ID

666: UPDATE WSH_DELIVERY_DETAILS
667: set src_requested_quantity = (src_requested_quantity - l_src_cancel_qty_allowed),
668: last_update_date = SYSDATE,
669: last_updated_by = FND_GLOBAL.USER_ID,
670: last_update_login = FND_GLOBAL.LOGIN_ID
671: where source_code = p_source_code
672: and source_line_id = p_changed_attribute.source_line_id;
673: --
674: IF l_debug_on THEN

Line 932: last_updated_by = FND_GLOBAL.USER_ID,

928: UPDATE wsh_delivery_details SET
929: requested_quantity = l_update_qty,
930: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2,
931: last_update_date = SYSDATE,
932: last_updated_by = FND_GLOBAL.USER_ID,
933: last_update_login = FND_GLOBAL.LOGIN_ID
934: WHERE source_line_id = old_delivery_detail_rec.source_line_id
935: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
936: ELSE

Line 933: last_update_login = FND_GLOBAL.LOGIN_ID

929: requested_quantity = l_update_qty,
930: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2,
931: last_update_date = SYSDATE,
932: last_updated_by = FND_GLOBAL.USER_ID,
933: last_update_login = FND_GLOBAL.LOGIN_ID
934: WHERE source_line_id = old_delivery_detail_rec.source_line_id
935: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
936: ELSE
937: UPDATE wsh_delivery_details SET

Line 941: last_updated_by = FND_GLOBAL.USER_ID,

937: UPDATE wsh_delivery_details SET
938: requested_quantity = old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity,
939: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2, -- OPM B2187389
940: last_update_date = SYSDATE,
941: last_updated_by = FND_GLOBAL.USER_ID,
942: last_update_login = FND_GLOBAL.LOGIN_ID
943: WHERE source_line_id = old_delivery_detail_rec.source_line_id
944: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
945: END IF;

Line 942: last_update_login = FND_GLOBAL.LOGIN_ID

938: requested_quantity = old_delivery_detail_rec.requested_quantity + l_changed_detail_quantity,
939: requested_quantity2 = old_delivery_detail_rec.requested_quantity2 + l_changed_line_quantity2, -- OPM B2187389
940: last_update_date = SYSDATE,
941: last_updated_by = FND_GLOBAL.USER_ID,
942: last_update_login = FND_GLOBAL.LOGIN_ID
943: WHERE source_line_id = old_delivery_detail_rec.source_line_id
944: AND delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
945: END IF;
946:

Line 1817: , last_updated_by = FND_GLOBAL.USER_ID

1813: SET requested_quantity2 = old_delivery_detail_rec.requested_quantity2 - ABS(l_changed_detail_quantity2)
1814: --Added bug 13812257, if requested_quantity2 is decremented then cancelled_quantity2 should be incremented.
1815: , cancelled_quantity2 = (NVL(cancelled_quantity2,0) + ABS(l_changed_detail_quantity2))
1816: , last_update_date = SYSDATE
1817: , last_updated_by = FND_GLOBAL.USER_ID
1818: , last_update_login = FND_GLOBAL.LOGIN_ID
1819: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
1820:
1821:

Line 1818: , last_update_login = FND_GLOBAL.LOGIN_ID

1814: --Added bug 13812257, if requested_quantity2 is decremented then cancelled_quantity2 should be incremented.
1815: , cancelled_quantity2 = (NVL(cancelled_quantity2,0) + ABS(l_changed_detail_quantity2))
1816: , last_update_date = SYSDATE
1817: , last_updated_by = FND_GLOBAL.USER_ID
1818: , last_update_login = FND_GLOBAL.LOGIN_ID
1819: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
1820:
1821:
1822:

Line 2441: last_updated_by = FND_GLOBAL.USER_ID,

2437: locator_id = NULL,
2438: cancelled_quantity = 0,
2439: cancelled_quantity2 = 0,
2440: last_update_date = SYSDATE,
2441: last_updated_by = FND_GLOBAL.USER_ID,
2442: last_update_login = FND_GLOBAL.LOGIN_ID
2443: WHERE source_line_id = p_source_line_id
2444: AND source_code = p_source_code
2445: AND released_status in ('S','Y')

Line 2442: last_update_login = FND_GLOBAL.LOGIN_ID

2438: cancelled_quantity = 0,
2439: cancelled_quantity2 = 0,
2440: last_update_date = SYSDATE,
2441: last_updated_by = FND_GLOBAL.USER_ID,
2442: last_update_login = FND_GLOBAL.LOGIN_ID
2443: WHERE source_line_id = p_source_line_id
2444: AND source_code = p_source_code
2445: AND released_status in ('S','Y')
2446: AND requested_quantity = 0

Line 2605: p_logging_entity_id => FND_GLOBAL.USER_ID,

2601: x_exception_id => l_dummy_exception_id ,
2602: p_logged_at_location_id => l_exception_location_id,
2603: p_exception_location_id => l_exception_location_id,
2604: p_logging_entity => 'SHIPPER',
2605: p_logging_entity_id => FND_GLOBAL.USER_ID,
2606: p_exception_name => 'WSH_CHANGED_QUANTITY',
2607: p_message => l_msg,
2608: p_delivery_detail_id => nvl(p_parent_delivery_detail_id,p_delivery_detail_id),
2609: p_delivery_assignment_id => l_delivery_assignment_id,

Line 2934: , last_updated_by = FND_GLOBAL.USER_ID

2930: , cycle_count_quantity2 = decode(cycle_count_quantity2,null,null,0,0,(p_requested_quantity2 - nvl(p_shipped_quantity2,0)) - ABS(p_changed_detail_quantity2))
2931: , cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity)
2932: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2933: , last_update_date = SYSDATE
2934: , last_updated_by = FND_GLOBAL.USER_ID
2935: , last_update_login = FND_GLOBAL.LOGIN_ID
2936: WHERE delivery_detail_id = p_delivery_detail_id;
2937: ELSE
2938:

Line 2935: , last_update_login = FND_GLOBAL.LOGIN_ID

2931: , cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity)
2932: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2933: , last_update_date = SYSDATE
2934: , last_updated_by = FND_GLOBAL.USER_ID
2935: , last_update_login = FND_GLOBAL.LOGIN_ID
2936: WHERE delivery_detail_id = p_delivery_detail_id;
2937: ELSE
2938:
2939: UPDATE wsh_delivery_details

Line 2953: , last_updated_by = FND_GLOBAL.USER_ID

2949: , cycle_count_quantity2 = decode(cycle_count_quantity2,null,null,0)
2950: , cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity)
2951: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2952: , last_update_date = SYSDATE
2953: , last_updated_by = FND_GLOBAL.USER_ID
2954: , last_update_login = FND_GLOBAL.LOGIN_ID
2955: WHERE delivery_detail_id = p_delivery_detail_id;
2956: --
2957: END IF; -- end of comparison between requested - detail with shipped quantity

Line 2954: , last_update_login = FND_GLOBAL.LOGIN_ID

2950: , cancelled_quantity = nvl(cancelled_quantity,0) + ABS(p_changed_detail_quantity)
2951: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2952: , last_update_date = SYSDATE
2953: , last_updated_by = FND_GLOBAL.USER_ID
2954: , last_update_login = FND_GLOBAL.LOGIN_ID
2955: WHERE delivery_detail_id = p_delivery_detail_id;
2956: --
2957: END IF; -- end of comparison between requested - detail with shipped quantity
2958: ELSE

Line 2978: , last_updated_by = FND_GLOBAL.USER_ID

2974: , cycle_count_quantity2 = decode(cycle_count_quantity2,null,null,0,0,(p_requested_quantity2 - nvl(p_shipped_quantity2,0)) - ABS(p_changed_detail_quantity2))
2975: , cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity - l_update_qty
2976: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2977: , last_update_date = SYSDATE
2978: , last_updated_by = FND_GLOBAL.USER_ID
2979: , last_update_login = FND_GLOBAL.LOGIN_ID
2980: WHERE delivery_detail_id = p_delivery_detail_id;
2981: ELSE
2982:

Line 2979: , last_update_login = FND_GLOBAL.LOGIN_ID

2975: , cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity - l_update_qty
2976: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2977: , last_update_date = SYSDATE
2978: , last_updated_by = FND_GLOBAL.USER_ID
2979: , last_update_login = FND_GLOBAL.LOGIN_ID
2980: WHERE delivery_detail_id = p_delivery_detail_id;
2981: ELSE
2982:
2983: UPDATE wsh_delivery_details

Line 2995: , last_updated_by = FND_GLOBAL.USER_ID

2991: , cycle_count_quantity2 = decode(cycle_count_quantity2,null,null,0)
2992: , cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity - l_update_qty
2993: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2994: , last_update_date = SYSDATE
2995: , last_updated_by = FND_GLOBAL.USER_ID
2996: , last_update_login = FND_GLOBAL.LOGIN_ID
2997: WHERE delivery_detail_id = p_delivery_detail_id;
2998: --
2999: END IF; -- end of comparison between requested - detail with shipped quantity

Line 2996: , last_update_login = FND_GLOBAL.LOGIN_ID

2992: , cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity - l_update_qty
2993: , cancelled_quantity2 = nvl(cancelled_quantity2,0) + ABS(p_changed_detail_quantity2)
2994: , last_update_date = SYSDATE
2995: , last_updated_by = FND_GLOBAL.USER_ID
2996: , last_update_login = FND_GLOBAL.LOGIN_ID
2997: WHERE delivery_detail_id = p_delivery_detail_id;
2998: --
2999: END IF; -- end of comparison between requested - detail with shipped quantity
3000: END IF;

Line 3283: last_updated_by = FND_GLOBAL.USER_ID,

3279: locator_id = NULL,
3280: cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity,
3281: cancelled_quantity2 = nvl(cancelled_quantity2,0) + p_requested_quantity2,
3282: last_update_date = SYSDATE,
3283: last_updated_by = FND_GLOBAL.USER_ID,
3284: last_update_login = FND_GLOBAL.LOGIN_ID
3285: where delivery_detail_id = p_delivery_detail_id;
3286:
3287: --bug# 6689448 (replenishment project) (Begin) : added the code to call WMS api for replenshment requested delivery

Line 3284: last_update_login = FND_GLOBAL.LOGIN_ID

3280: cancelled_quantity = nvl(cancelled_quantity,0) + p_requested_quantity,
3281: cancelled_quantity2 = nvl(cancelled_quantity2,0) + p_requested_quantity2,
3282: last_update_date = SYSDATE,
3283: last_updated_by = FND_GLOBAL.USER_ID,
3284: last_update_login = FND_GLOBAL.LOGIN_ID
3285: where delivery_detail_id = p_delivery_detail_id;
3286:
3287: --bug# 6689448 (replenishment project) (Begin) : added the code to call WMS api for replenshment requested delivery
3288: -- detail lines with zeqo qty so that WMS deletes the replenishment record.