APPS.WSH_SHIPMENT_BATCH_PKG dependencies on WSH_DELIVERY_DETAILS

Line 503: l_dyn_query := l_dyn_query || ' FROM Wsh_Delivery_Details wdd, ';

499: l_dyn_query := l_dyn_query || l_grp_query;
500: l_dyn_query := l_dyn_query || ' ) Group_Id ';
501:
502: -- From Clause
503: l_dyn_query := l_dyn_query || ' FROM Wsh_Delivery_Details wdd, ';
504: l_dyn_query := l_dyn_query || ' Wsh_Delivery_Assignments wda, ';
505: l_dyn_query := l_dyn_query || ' Oe_Order_Lines_All oel ';
506:
507: -- Where Clause

Line 728: from wsh_delivery_details

724: --{ Locking Delivery Detail Starts
725: BEGIN
726: select source_header_id
727: into l_src_header_id
728: from wsh_delivery_details
729: where rowid = l_rowid_tbl(i)
730: for update nowait;
731:
732: --Bug 14620571 - Start

Line 921: update wsh_delivery_details

917: END IF;
918: --
919: IF l_update_flag THEN
920: FORALL i in l_rowid_tbl.first..l_rowid_tbl.last
921: update wsh_delivery_details
922: set shipment_batch_id = l_dd_batch_id_tbl(i),
923: shipment_line_number = l_dd_line_num_tbl(i),
924: reference_line_id = l_src_line_id_tbl(i),
925: last_update_date = SYSDATE,

Line 1116: from wsh_delivery_details wdd,

1112: CURSOR c_del_details IS
1113: select src_requested_quantity,
1114: requested_quantity,
1115: delivery_detail_id
1116: from wsh_delivery_details wdd,
1117: wsh_transactions_history wth,
1118: wsh_shipment_batches wsb
1119: where source_code = 'OE'
1120: and released_status in ( 'R', 'B', 'X' )

Line 1180: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details', WSH_DEBUG_SV.C_PROC_LEVEL);

1176: l_cancel_quantity := l_pending_cancel_qty;
1177: l_pending_cancel_qty := 0;
1178: --
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details', WSH_DEBUG_SV.C_PROC_LEVEL);
1181: END IF;
1182: --
1183:
1184: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (

Line 1184: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (

1180: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details', WSH_DEBUG_SV.C_PROC_LEVEL);
1181: END IF;
1182: --
1183:
1184: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (
1185: p_from_detail_id => i.delivery_detail_id,
1186: p_req_quantity => l_cancel_quantity ,
1187: x_new_detail_id => l_new_detail_id ,
1188: x_return_status => l_return_status );

Line 1192: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details', l_return_status);

1188: x_return_status => l_return_status );
1189:
1190: --
1191: IF l_debug_on THEN
1192: WSH_DEBUG_SV.log(l_module_name, 'Return Status of WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details', l_return_status);
1193: END IF;
1194: --
1195:
1196: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 1227: update wsh_delivery_details

1223: END IF;
1224: --
1225: IF l_unassign_detail_tab.count > 0 THEN
1226: FORALL i in l_unassign_detail_tab.first..l_unassign_detail_tab.last
1227: update wsh_delivery_details
1228: set shipment_batch_id = null,
1229: shipment_line_number = null,
1230: reference_line_id = null,
1231: last_update_date = SYSDATE,