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) )
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 ;
330:

Line 389: FROM wsh_delivery_details wdd,

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

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

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

Line 425: FROM wsh_delivery_details wdd,

421: CURSOR c_req_qty(x_source_code VARCHAR2,
422: x_original_source_line_id NUMBER
423: ) IS
424: SELECT sum(nvl(wdd.requested_quantity, 0))
425: FROM wsh_delivery_details wdd,
426: wsh_delivery_assignments_v wda,
427: wsh_delivery_details wdd1
428: WHERE wdd.source_code = x_source_code
429: AND wdd.source_line_id = x_original_source_line_id

Line 427: wsh_delivery_details wdd1

423: ) IS
424: SELECT sum(nvl(wdd.requested_quantity, 0))
425: FROM wsh_delivery_details wdd,
426: wsh_delivery_assignments_v wda,
427: wsh_delivery_details wdd1
428: WHERE wdd.source_code = x_source_code
429: AND wdd.source_line_id = x_original_source_line_id
430: AND wdd.container_flag = 'N'
431: AND wdd.released_status <> 'D'

Line 437: l_detail_info WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;

433: AND wda.delivery_detail_id = wdd.delivery_detail_id
434: AND wda.parent_Delivery_Detail_id = wdd1.delivery_Detail_id(+);
435:
436: l_detail_inv_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
437: l_detail_info WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;
438: l_uom_converted BOOLEAN;
439: l_counter NUMBER;
440: l_rs VARCHAR2(1);
441: l_quantity_to_split NUMBER;

Line 609: UPDATE WSH_DELIVERY_DETAILS

605: IF (p_changed_attributes(l_counter).source_line_set_id <> FND_API.G_MISS_NUM)
606: AND ( (c.source_line_set_id IS NULL)
607: OR (p_changed_attributes(l_counter).source_line_set_id <> c.source_line_set_id))
608: AND (l_prev_source_line_id <> p_changed_attributes(l_counter).original_source_line_id) THEN
609: UPDATE WSH_DELIVERY_DETAILS
610: SET source_line_set_id = p_changed_attributes(l_counter).source_line_set_id,
611: last_update_date = SYSDATE,
612: last_updated_by = FND_GLOBAL.USER_ID,
613: last_update_login = FND_GLOBAL.LOGIN_ID

Line 717: UPDATE WSH_DELIVERY_DETAILS

713: WSH_DEBUG_SV.log(l_module_name,'c.requested_quantity2',c.requested_quantity2);
714: WSH_DEBUG_SV.log(l_module_name,'l_quantity_split2',l_quantity_split2);
715: END IF;
716: --
717: UPDATE WSH_DELIVERY_DETAILS
718: SET source_line_id = p_changed_attributes(l_counter).source_line_id,
719: last_update_date = SYSDATE,
720: last_updated_by = FND_GLOBAL.USER_ID,
721: last_update_login = FND_GLOBAL.LOGIN_ID

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

856: l_detail_info.parent_delivery_id := c.parent_delivery_id;
857: l_detail_info.wda_type := c.wda_type;
858: -- END K: MDC
859: IF l_debug_on THEN
860: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DETAIL_INT IN SPLIT_RECORDS_Int' );
861: END IF;
862: --
863: -- HW OPMCONV. Removed l_process_flag
864: WSH_DELIVERY_DETAILS_ACTIONS.Split_Detail_INT(

Line 864: WSH_DELIVERY_DETAILS_ACTIONS.Split_Detail_INT(

860: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DETAIL_INT IN SPLIT_RECORDS_Int' );
861: END IF;
862: --
863: -- HW OPMCONV. Removed l_process_flag
864: WSH_DELIVERY_DETAILS_ACTIONS.Split_Detail_INT(
865: p_old_delivery_detail_rec => l_detail_info,
866: p_new_source_line_id => p_changed_attributes(l_counter).source_line_id,
867: p_quantity_to_split => l_quantity_split,
868: p_quantity_to_split2 => l_quantity_split2,

Line 931: UPDATE wsh_delivery_details

927: -- MOL will be not null or
928: -- X-dock where MOL will be null, in which case we want to
929: -- retain the released_status of 'S' with null MOL
930: IF c.move_order_line_id IS NOT NULL THEN
931: UPDATE wsh_delivery_details
932: SET released_status = 'R',
933: move_order_line_id = NULL
934: WHERE delivery_detail_id = c.delivery_detail_id;
935: -- else released_status should be 'S' and MOL should be null

Line 937: UPDATE wsh_delivery_details

933: move_order_line_id = NULL
934: WHERE delivery_detail_id = c.delivery_detail_id;
935: -- else released_status should be 'S' and MOL should be null
936: ELSE
937: UPDATE wsh_delivery_details
938: SET released_status = 'S',
939: move_order_line_id = NULL
940: WHERE delivery_detail_id = c.delivery_detail_id;
941: END IF;

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

942: --End of X-dock,split
943:
944: --
945: -- DBI Project
946: -- Update of wsh_delivery_details where requested_quantity/released_status
947: -- are changed, call DBI API after the update.
948: -- This API will also check for DBI Installed or not
949: IF l_debug_on THEN
950: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API delievery detail id:',c.delivery_detail_id);

Line 1042: l_reservable := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1038: IF ( c.released_status in ('Y', 'C')) OR
1039: ( c.released_status = 'S' AND l_detailed_qty > 0) OR
1040: --bug 6313281: added status 'B' for ato_lines as they can have reservations.
1041: ( c.released_status = 'B' AND l_ato_split ) THEN
1042: l_reservable := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1043: x_item_id => c.inventory_item_id,
1044: x_organization_id => c.organization_id,
1045: x_pickable_flag => c.pickable_flag);
1046:

Line 1152: UPDATE WSH_DELIVERY_DETAILS

1148:
1149:
1150: -- bug fix 2187012 fix #2 start
1151: -- No Update of released status
1152: UPDATE WSH_DELIVERY_DETAILS
1153: SET SRC_REQUESTED_QUANTITY = SRC_REQUESTED_QUANTITY - p_changed_attributes(l_counter).ordered_quantity,
1154: SRC_REQUESTED_QUANTITY2 = SRC_REQUESTED_QUANTITY2 - p_changed_attributes(l_counter).ordered_quantity2
1155: WHERE SOURCE_LINE_ID = p_changed_attributes(l_counter).original_source_line_id
1156: AND SOURCE_CODE = p_source_code;

Line 1747: from wsh_delivery_details

1743: --bug#6407943:Needs to change items org dependent attributes when org changes.
1744: cursor c_is_reservable IS
1745: select inventory_item_id, organization_id, pickable_flag,requested_quantity_uom,
1746: unit_weight,weight_uom_code,unit_volume,volume_uom_code,hazard_class_id,item_description
1747: from wsh_delivery_details
1748: where source_line_id = p_attributes_rec.source_line_id
1749: and source_code = p_source_code
1750: and rownum = 1;
1751:

Line 1756: from wsh_delivery_details

1752: /* H projects: pricing integration csun */ /* J TP Release */
1753: --4410272
1754: cursor c_get_delivery_detail_id IS
1755: select delivery_detail_id, released_status, date_requested, date_scheduled
1756: from wsh_delivery_details
1757: WHERE source_code = p_source_code
1758: AND source_line_id = p_attributes_rec.source_line_id
1759: AND container_flag = 'N'
1760: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,

Line 1765: from wsh_delivery_details

1761: delivery_detail_id, p_attributes_rec.delivery_detail_id );
1762:
1763: cursor c_get_tpdetails IS
1764: select organization_id, carrier_id, ship_method_code, ignore_for_planning
1765: from wsh_delivery_details
1766: WHERE source_code = p_source_code
1767: AND source_line_id = p_attributes_rec.source_line_id
1768: AND container_flag = 'N'
1769: AND delivery_detail_id = decode( p_attributes_rec.delivery_detail_id, FND_API.G_MISS_NUM ,

Line 1832: l_smc wsh_delivery_details.ship_method_code%TYPE;

1828: l_groupbysmc VARCHAR2(1);
1829: l_groupbycarrier VARCHAR2(1);
1830: l_in_ids wsh_util_core.id_tab_type;
1831: l_datetype VARCHAR2(30);
1832: l_smc wsh_delivery_details.ship_method_code%TYPE;
1833: l_carrierid wsh_delivery_details.carrier_id%TYPE;
1834: l_orgid wsh_delivery_details.organization_id%TYPE;
1835: l_earliest_pickup_date DATE;
1836: l_latest_pickup_date DATE;

Line 1833: l_carrierid wsh_delivery_details.carrier_id%TYPE;

1829: l_groupbycarrier VARCHAR2(1);
1830: l_in_ids wsh_util_core.id_tab_type;
1831: l_datetype VARCHAR2(30);
1832: l_smc wsh_delivery_details.ship_method_code%TYPE;
1833: l_carrierid wsh_delivery_details.carrier_id%TYPE;
1834: l_orgid wsh_delivery_details.organization_id%TYPE;
1835: l_earliest_pickup_date DATE;
1836: l_latest_pickup_date DATE;
1837: l_earliest_dropoff_date DATE;

Line 1834: l_orgid wsh_delivery_details.organization_id%TYPE;

1830: l_in_ids wsh_util_core.id_tab_type;
1831: l_datetype VARCHAR2(30);
1832: l_smc wsh_delivery_details.ship_method_code%TYPE;
1833: l_carrierid wsh_delivery_details.carrier_id%TYPE;
1834: l_orgid wsh_delivery_details.organization_id%TYPE;
1835: l_earliest_pickup_date DATE;
1836: l_latest_pickup_date DATE;
1837: l_earliest_dropoff_date DATE;
1838: l_latest_dropoff_date DATE;

Line 1925: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1921:
1922: -- Bug 3125768: Commenting the following call that gets the reservable flag.
1923: -- Now, Get the reservable flag after fetching the pickable flag for the new Organization
1924: /*
1925: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1926: x_item_id => l_inventory_item_id,
1927: x_organization_id => l_organization_id,
1928: x_pickable_flag => l_pickable_flag);
1929: */

Line 2003: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1999:
2000: END IF;
2001:
2002: -- Bug 3125768
2003: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2004: x_item_id => l_inventory_item_id,
2005: x_organization_id => l_organization_id,
2006: x_pickable_flag => l_pickable_flag);
2007:

Line 2251: UPDATE wsh_delivery_details

2247:
2248: /*2740139 : For non-transactable,non-reservable,but stockable and shippable
2249: items, the release status is 'X'.In this case the subinventory value is
2250: set to the value that is present in wdd and not from the order lines.*/
2251: UPDATE wsh_delivery_details
2252: SET sold_to_contact_id = decode ( p_attributes_rec.sold_to_contact_id, FND_API.G_MISS_NUM ,
2253: sold_to_contact_id , NVL(p_attributes_rec.sold_to_contact_id, sold_to_contact_id) ) ,
2254: ship_to_contact_id = decode ( p_attributes_rec.ship_to_contact_id, FND_API.G_MISS_NUM ,
2255: ship_to_contact_id , p_attributes_rec.ship_to_contact_id ) ,

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

2748: END IF;
2749: END IF;
2750: --
2751: -- DBI Project
2752: -- Update of wsh_delivery_details where requested_quantity/released_status
2753: -- are changed, call DBI API after the update.
2754: -- This API will also check for DBI Installed or not
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API delivery details l_details_marked count :',l_details_marked.COUNT);

Line 3141: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;

3137:
3138: ln_rec_info C_PULL_DELIVERY_DETAILS%ROWTYPE;
3139:
3140: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3141: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_assignments_rec_TYPE;
3142: dummy_rowid VARCHAR2(30);
3143: dummy_delivery_detail_id number;
3144: dummy_slid number;
3145: l_header_price_att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 3633: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details( l_delivery_details_info, dummy_rowid,

3629: IF l_debug_on THEN
3630: WSH_DEBUG_SV.log(l_module_name,'Source Line Set id -'||l_delivery_details_info.source_line_set_id);
3631: END IF;
3632:
3633: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Details( l_delivery_details_info, dummy_rowid,
3634: DUMMY_DELIVERY_DETAIL_ID,
3635: l_cr_dt_status );
3636: IF (l_cr_dt_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3637: WSH_INTERFACE.PrintMsg(name=>'WSH_DET_CREATE_DET_FAILED',

Line 3669: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments( l_delivery_assignments_info,

3665: l_delivery_assignments_info.parent_delivery_id := NULL;
3666: l_delivery_assignments_info.delivery_detail_id := dummy_delivery_detail_id;
3667: l_delivery_assignments_info.parent_delivery_detail_id := NULL;
3668:
3669: WSH_DELIVERY_DETAILS_PKG.Create_Delivery_Assignments( l_delivery_assignments_info,
3670: dummy_assgn_rowid,
3671: DUMMY_DELIVERY_ASSIGNMENT_ID,
3672: l_cr_as_status);
3673: IF (l_cr_as_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

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

3707: NULL);
3708: l_item_quantity_uom_tab(1) := l_delivery_details_info.requested_quantity_uom;
3709:
3710: IF l_debug_on THEN
3711: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
3712: END IF;
3713:
3714: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
3715: p_detail_tab => l_delivery_detail_tab,

Line 3714: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(

3710: IF l_debug_on THEN
3711: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split',WSH_DEBUG_SV.C_PROC_LEVEL);
3712: END IF;
3713:
3714: WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split(
3715: p_detail_tab => l_delivery_detail_tab,
3716: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
3717: x_return_status => l_return_status);
3718:

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

3716: p_item_quantity_uom_tab => l_item_quantity_uom_tab,
3717: x_return_status => l_return_status);
3718:
3719: IF l_debug_on THEN
3720: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_SPLITTER.tms_delivery_detail_split: ' || l_return_status);
3721: END IF;
3722:
3723: -- we will not fail based on l_return_status here because
3724: -- we do not want to stop the flow