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_ACTIONS_PVT dependencies on WSH_DELIVERY_DETAILS

Line 61: UPDATE WSH_DELIVERY_DETAILS

57: -- non-pickable (non-reservable) lines should have status updated to 'X'.
58: IF l_debug_on THEN
59: WSH_DEBUG_SV.log(l_module_name,'source_line_id',p_changed_attributes(l_counter).source_line_id);
60: END IF;
61: UPDATE WSH_DELIVERY_DETAILS
62: SET released_status = decode(pickable_flag, 'Y','R', 'X')
63: WHERE source_line_id = p_changed_attributes(l_counter).source_line_id
64: AND source_code = p_source_code
65: RETURNING delivery_detail_id, organization_id BULK COLLECT INTO l_detail_tab, l_organization_tab;

Line 90: -- Update of wsh_delivery_details where requested_quantity/released_status

86: END LOOP;
87: --Done Raise Event: Pick To Pod Workflow
88: --
89: -- DBI Project
90: -- Update of wsh_delivery_details where requested_quantity/released_status
91: -- are changed, call DBI API after the update.
92: -- This API will also check for DBI Installed or not
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count',l_detail_tab.count);

Line 326: from wsh_delivery_details

322: CURSOR c_total_requested_quantity (p_source_line_id NUMBER)
323: IS
324: SELECT inventory_item_id , requested_quantity_uom ,sum ( requested_quantity ),
325: sum ( NVL(requested_quantity2,0) ),organization_id --bugfix 8780998
326: from wsh_delivery_details
327: where source_line_id = p_source_line_id
328: and source_code = 'OE'
329: group by inventory_item_id , requested_quantity_uom,organization_id;
330:

Line 391: FROM wsh_delivery_details wdd,

387: wda.parent_delivery_id,
388: NVL(wda.type, 'S') wda_type,
389: -- END K: MDC
390: wdd.replenishment_status -- bug# 6719369 (replenishment project)
391: FROM wsh_delivery_details wdd,
392: wsh_delivery_assignments wda,
393: wsh_delivery_details wdd1 -- Bug 2773605: Added to fetch parent's lpn_id
394: WHERE wdd.source_code = x_source_code
395: AND wdd.source_line_id = x_original_source_line_id

Line 393: wsh_delivery_details wdd1 -- Bug 2773605: Added to fetch parent's lpn_id

389: -- END K: MDC
390: wdd.replenishment_status -- bug# 6719369 (replenishment project)
391: FROM wsh_delivery_details wdd,
392: wsh_delivery_assignments wda,
393: wsh_delivery_details wdd1 -- Bug 2773605: Added to fetch parent's lpn_id
394: WHERE wdd.source_code = x_source_code
395: AND wdd.source_line_id = x_original_source_line_id
396: AND wdd.container_flag = 'N'
397: AND wdd.released_status <> 'D'

Line 430: FROM wsh_delivery_details wdd,

426: ) IS
427: SELECT sum(nvl(wdd.requested_quantity, 0))
428: -- muom
429: ,sum(nvl(wdd.requested_quantity2, 0))
430: FROM wsh_delivery_details wdd,
431: wsh_delivery_assignments_v wda,
432: wsh_delivery_details wdd1
433: WHERE wdd.source_code = x_source_code
434: AND wdd.source_line_id = x_original_source_line_id

Line 432: wsh_delivery_details wdd1

428: -- muom
429: ,sum(nvl(wdd.requested_quantity2, 0))
430: FROM wsh_delivery_details wdd,
431: wsh_delivery_assignments_v wda,
432: wsh_delivery_details wdd1
433: WHERE wdd.source_code = x_source_code
434: AND wdd.source_line_id = x_original_source_line_id
435: AND wdd.container_flag = 'N'
436: AND wdd.released_status <> 'D'

Line 448: FROM wsh_delivery_details wdd

444: requested_quantity_uom,
445: requested_quantity_uom2,
446: inventory_item_id,
447: delivery_detail_id
448: FROM wsh_delivery_details wdd
449: WHERE wdd.source_code = 'OE'
450: AND wdd.source_line_id = x_line_id
451: AND wdd.requested_quantity = 0
452: AND wdd.released_status <> 'D';

Line 455: l_detail_info WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;

451: AND wdd.requested_quantity = 0
452: AND wdd.released_status <> 'D';
453:
454: l_detail_inv_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
455: l_detail_info WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;
456:
457: l_cancel_Reservation_Tab_Type WSH_USA_ACTIONS_PVT.Cancel_Reservation_Tab_Type; --bugfix 8915868
458: l_cancel_counter NUMBER :=0 ; --bugfix 8915868
459:

Line 656: UPDATE WSH_DELIVERY_DETAILS

652: IF (p_changed_attributes(l_counter).source_line_set_id <> FND_API.G_MISS_NUM)
653: AND ( (c.source_line_set_id IS NULL)
654: OR (p_changed_attributes(l_counter).source_line_set_id <> c.source_line_set_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

Line 773: UPDATE WSH_DELIVERY_DETAILS

769: WSH_DEBUG_SV.log(l_module_name,'c.requested_quantity2',c.requested_quantity2);
770: WSH_DEBUG_SV.log(l_module_name,'l_quantity_split2',l_quantity_split2);
771: END IF;
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

Line 921: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DETAIL_INT IN SPLIT_RECORDS_Int' );

917: l_detail_info.parent_delivery_id := c.parent_delivery_id;
918: l_detail_info.wda_type := c.wda_type;
919: -- END K: MDC
920: IF l_debug_on THEN
921: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DETAIL_INT IN SPLIT_RECORDS_Int' );
922: END IF;
923: --
924: -- HW OPMCONV. Removed l_process_flag
925: -- Bug 16722851

Line 929: WSH_DELIVERY_DETAILS_ACTIONS.Split_Detail_INT(

925: -- Bug 16722851
926: l_rsv_to_split := NULL;
927: l_rsv_to_split2 := NULL;
928:
929: WSH_DELIVERY_DETAILS_ACTIONS.Split_Detail_INT(
930: p_old_delivery_detail_rec => l_detail_info,
931: p_new_source_line_id => p_changed_attributes(l_counter).source_line_id,
932: p_quantity_to_split => l_quantity_split,
933: p_quantity_to_split2 => l_quantity_split2,

Line 1004: UPDATE wsh_delivery_details

1000: -- MOL will be not null or
1001: -- X-dock where MOL will be null, in which case we want to
1002: -- retain the released_status of 'S' with null MOL
1003: IF c.move_order_line_id IS NOT NULL THEN
1004: UPDATE wsh_delivery_details
1005: SET released_status = 'R',
1006: move_order_line_id = NULL
1007: WHERE delivery_detail_id = c.delivery_detail_id;
1008: -- else released_status should be 'S' and MOL should be null

Line 1010: UPDATE wsh_delivery_details

1006: move_order_line_id = NULL
1007: WHERE delivery_detail_id = c.delivery_detail_id;
1008: -- else released_status should be 'S' and MOL should be null
1009: ELSE
1010: UPDATE wsh_delivery_details
1011: SET released_status = 'S',
1012: move_order_line_id = NULL
1013: WHERE delivery_detail_id = c.delivery_detail_id;
1014: END IF;

Line 1019: -- Update of wsh_delivery_details where requested_quantity/released_status

1015: --End of X-dock,split
1016:
1017: --
1018: -- DBI Project
1019: -- Update of wsh_delivery_details where requested_quantity/released_status
1020: -- are changed, call DBI API after the update.
1021: -- This API will also check for DBI Installed or not
1022: IF l_debug_on THEN
1023: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API delievery detail id:',c.delivery_detail_id);

Line 1142: l_reservable := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1138: OR
1139: (l_trnfer_reservations = 'Y' ))) OR
1140: --bug 6313281: added status 'B' for ato_lines as they can have reservations.
1141: ( c.released_status = 'B' AND l_ato_split ) THEN
1142: l_reservable := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1143: x_item_id => c.inventory_item_id,
1144: x_organization_id => c.organization_id,
1145: x_pickable_flag => c.pickable_flag);
1146:

Line 1261: update wsh_delivery_details

1257: to_uom => crec.requested_quantity_uom,
1258: quantity => crec.requested_quantity2,
1259: item_id => crec.inventory_item_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

Line 1331: UPDATE WSH_DELIVERY_DETAILS

1327: CLOSE ordered_quantity2;
1328:
1329: -- bug fix 2187012 fix #2 start
1330: -- No Update of released status
1331: UPDATE WSH_DELIVERY_DETAILS
1332: SET SRC_REQUESTED_QUANTITY = SRC_REQUESTED_QUANTITY - p_changed_attributes(l_counter).ordered_quantity,
1333: SRC_REQUESTED_QUANTITY2 = l_line_ordered_quantinty2 --SRC_REQUESTED_QUANTITY2 - p_changed_attributes(l_counter).ordered_quantity2
1334: WHERE SOURCE_LINE_ID = p_changed_attributes(l_counter).original_source_line_id
1335: AND SOURCE_CODE = p_source_code;

Line 2041: from wsh_delivery_details

2037: --bug#6407943:Needs to change items org dependent attributes when org changes.
2038: cursor c_is_reservable IS
2039: select inventory_item_id, organization_id, pickable_flag,requested_quantity_uom,
2040: unit_weight,weight_uom_code,unit_volume,volume_uom_code,hazard_class_id,item_description
2041: from wsh_delivery_details
2042: where source_line_id = p_attributes_rec.source_line_id
2043: and source_code = p_source_code
2044: and rownum = 1;
2045:

Line 2050: from wsh_delivery_details

2046: /* H projects: pricing integration csun */ /* J TP Release */
2047: --4410272
2048: cursor c_get_delivery_detail_id IS
2049: select delivery_detail_id, released_status, date_requested, date_scheduled
2050: from wsh_delivery_details
2051: WHERE source_code = p_source_code
2052: AND source_line_id = p_attributes_rec.source_line_id
2053: AND container_flag = 'N'
2054: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,

Line 2059: from wsh_delivery_details

2055: delivery_detail_id, p_attributes_rec.delivery_detail_id );
2056:
2057: cursor c_get_tpdetails IS
2058: select organization_id, carrier_id, ship_method_code, ignore_for_planning
2059: from wsh_delivery_details
2060: WHERE source_code = p_source_code
2061: AND source_line_id = p_attributes_rec.source_line_id
2062: AND container_flag = 'N'
2063: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,

Line 2126: l_smc wsh_delivery_details.ship_method_code%TYPE;

2122: l_groupbysmc VARCHAR2(1);
2123: l_groupbycarrier VARCHAR2(1);
2124: l_in_ids wsh_util_core.id_tab_type;
2125: l_datetype VARCHAR2(30);
2126: l_smc wsh_delivery_details.ship_method_code%TYPE;
2127: l_carrierid wsh_delivery_details.carrier_id%TYPE;
2128: l_orgid wsh_delivery_details.organization_id%TYPE;
2129: l_earliest_pickup_date DATE;
2130: l_latest_pickup_date DATE;

Line 2127: l_carrierid wsh_delivery_details.carrier_id%TYPE;

2123: l_groupbycarrier VARCHAR2(1);
2124: l_in_ids wsh_util_core.id_tab_type;
2125: l_datetype VARCHAR2(30);
2126: l_smc wsh_delivery_details.ship_method_code%TYPE;
2127: l_carrierid wsh_delivery_details.carrier_id%TYPE;
2128: l_orgid wsh_delivery_details.organization_id%TYPE;
2129: l_earliest_pickup_date DATE;
2130: l_latest_pickup_date DATE;
2131: l_earliest_dropoff_date DATE;

Line 2128: l_orgid wsh_delivery_details.organization_id%TYPE;

2124: l_in_ids wsh_util_core.id_tab_type;
2125: l_datetype VARCHAR2(30);
2126: l_smc wsh_delivery_details.ship_method_code%TYPE;
2127: l_carrierid wsh_delivery_details.carrier_id%TYPE;
2128: l_orgid wsh_delivery_details.organization_id%TYPE;
2129: l_earliest_pickup_date DATE;
2130: l_latest_pickup_date DATE;
2131: l_earliest_dropoff_date DATE;
2132: l_latest_dropoff_date DATE;

Line 2221: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

2217:
2218: -- Bug 3125768: Commenting the following call that gets the reservable flag.
2219: -- Now, Get the reservable flag after fetching the pickable flag for the new Organization
2220: /*
2221: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2222: x_item_id => l_inventory_item_id,
2223: x_organization_id => l_organization_id,
2224: x_pickable_flag => l_pickable_flag);
2225: */

Line 2301: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

2297:
2298: END IF;
2299:
2300: -- Bug 3125768
2301: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2302: x_item_id => l_inventory_item_id,
2303: x_organization_id => l_organization_id,
2304: x_pickable_flag => l_pickable_flag);
2305:

Line 2557: UPDATE wsh_delivery_details

2553:
2554: /*2740139 : For non-transactable,non-reservable,but stockable and shippable
2555: items, the release status is 'X'.In this case the subinventory value is
2556: set to the value that is present in wdd and not from the order lines.*/
2557: UPDATE wsh_delivery_details
2558: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2559: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2560: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2561: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,

Line 3064: -- Update of wsh_delivery_details where requested_quantity/released_status

3060: END IF;
3061: END IF;
3062: --
3063: -- DBI Project
3064: -- Update of wsh_delivery_details where requested_quantity/released_status
3065: -- are changed, call DBI API after the update.
3066: -- This API will also check for DBI Installed or not
3067: IF l_debug_on THEN
3068: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API delivery details l_details_marked count :',l_details_marked.COUNT);

Line 3453: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;

3449:
3450: ln_rec_info C_PULL_DELIVERY_DETAILS%ROWTYPE;
3451:
3452: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3453: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;
3454: dummy_rowid VARCHAR2(30);
3455: dummy_delivery_detail_id number;
3456: dummy_slid number;
3457: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 3949: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details( l_delivery_details_info, dummy_rowid,

3945: IF l_debug_on THEN
3946: WSH_DEBUG_SV.log(l_module_name,'Source Line Set id -'||l_delivery_details_info.source_line_set_id);
3947: END IF;
3948:
3949: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details( l_delivery_details_info, dummy_rowid,
3950: DUMMY_DELIVERY_DETAIL_ID,
3951: l_cr_dt_status );
3952: IF (l_cr_dt_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3953: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',

Line 3985: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments( l_delivery_assignments_info,

3981: l_delivery_assignments_info.parent_delivery_id := NULL;
3982: l_delivery_assignments_info.delivery_detail_id := dummy_delivery_detail_id;
3983: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
3984:
3985: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments( l_delivery_assignments_info,
3986: dummy_assgn_rowid,
3987: DUMMY_DELIVERY_ASSIGNMENT_ID,
3988: l_cr_as_status);
3989: IF (l_cr_as_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

Line 4027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);

4023: NULL);
4024: l_item_quantity_uom_tab(1) := l_delivery_details_info.requested_quantity_uom;
4025:
4026: IF l_debug_on THEN
4027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
4028: END IF;
4029:
4030: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
4031: p_detail_tab => l_delivery_detail_tab,

Line 4030: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

4026: IF l_debug_on THEN
4027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
4028: END IF;
4029:
4030: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
4031: p_detail_tab => l_delivery_detail_tab,
4032: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
4033: x_return_status => l_return_status);
4034:

Line 4036: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);

4032: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
4033: x_return_status => l_return_status);
4034:
4035: IF l_debug_on THEN
4036: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
4037: END IF;
4038:
4039: -- we will not fail based on l_return_status here because
4040: -- we do not want to stop the flow