APPS.WMS_CROSS_DOCK_PVT dependencies on WSH_DELIVERY_DETAILS

Line 666: FROM wsh_delivery_details wdd

662: SELECT 2
663: , inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
664: , wdd.source_line_id
665: INTO l_source_type_id, l_source_header_id, l_source_line_id
666: FROM wsh_delivery_details wdd
667: WHERE wdd.delivery_detail_id = l_backorder_delivery_detail_id;
668: EXCEPTION
669: WHEN OTHERS THEN
670: IF (l_debug = 1) THEN

Line 964: mydebug('***Calling wsh_delivery_details_grp.delivery_detail_action***');

960:
961: -- {{ call wsh_delivery_autocreate.delivery_detail_action }}
962:
963: IF (l_debug = 1) THEN
964: mydebug('***Calling wsh_delivery_details_grp.delivery_detail_action***');
965: mydebug('l_rec_attr_tab(1).delivery_detail_id = '||l_rec_attr_tab(1).delivery_detail_id );
966: mydebug('l_action_prms.action_code = '||l_action_prms.action_code);
967: mydebug('l_action_prms.delivery_id = '||l_action_prms.delivery_id);
968: END IF;

Line 970: wsh_delivery_details_grp.delivery_detail_action

966: mydebug('l_action_prms.action_code = '||l_action_prms.action_code);
967: mydebug('l_action_prms.delivery_id = '||l_action_prms.delivery_id);
968: END IF;
969:
970: wsh_delivery_details_grp.delivery_detail_action
971: (
972: -- Standard Parameters
973: p_api_version_number => 1.0,
974: p_init_msg_list => fnd_api.g_false,

Line 987: mydebug('***After calling wsh_delivery_details_grp.delivery_detail_action***');

983: x_action_out_rec => l_action_out_rec
984: );
985:
986: IF (l_debug = 1) THEN
987: mydebug('***After calling wsh_delivery_details_grp.delivery_detail_action***');
988: mydebug('x_return_status = '||l_return_status);
989: mydebug('x_msg_count = '||l_msg_count);
990: mydebug('x_msg_data = '||l_msg_data);
991: END IF;

Line 1317: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd

1313: SELECT
1314: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1315: ,l.transaction_source_type_id,l.txn_source_id
1316: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1317: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd
1318: WHERE t.transaction_temp_id=l_temp_id
1319: AND l.backorder_delivery_detail_id = wdd.delivery_detail_id
1320: AND t.move_order_line_id=l.line_id
1321: AND exists (

Line 2128: FROM wsh_delivery_details_ob_grp_v

2124: mydebug('Getting del detail id...');
2125: END IF;
2126: begin
2127: SELECT delivery_detail_id INTO l_lpn_del_detail_id
2128: FROM wsh_delivery_details_ob_grp_v
2129: WHERE lpn_id=l_transfer_lpn_id
2130: AND ROWNUM=1;
2131: EXCEPTION
2132: WHEN NO_DATA_FOUND THEN

Line 2176: FROM wsh_delivery_details

2172: -- should only be checked if there is another loop (lpn has a parent)
2173: IF ( parent_lpn_rec.parent_lpn_id IS NOT NULL ) THEN
2174: BEGIN
2175: SELECT 1 INTO l_ret
2176: FROM wsh_delivery_details
2177: WHERE lpn_id = parent_lpn_rec.lpn_id;
2178: EXCEPTION
2179: WHEN NO_DATA_FOUND THEN
2180: IF (l_debug = 1) THEN