[Home] [Help]
117: AND wda.delivery_id = wdl.delivery_id
118: AND wdl.pick_up_stop_id = wts1.stop_id
119: AND wts1.trip_id = c_trip_id
120: AND wnd.delivery_id = wdl.delivery_id
121: AND wnd.delivery_type = 'STANDARD';
122:
123: CURSOR c_get_trip_details_consol(c_trip_id IN NUMBER) IS
124: SELECT wdd.DELIVERY_DETAIL_ID
125: , wdl1.DELIVERY_ID
1781:
1782: END LOOP;
1783: END IF;
1784:
1785: -- Standard call to get message count and if count is 1,
1786: -- get message info.
1787:
1788: FND_MSG_PUB.Count_And_Get (
1789: p_count => x_msg_count,
11929: END IF;
11930:
11931: IF l_debug_on THEN
11932: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_info(i).delivery_type : '||l_delivery_info(i).delivery_type);
11933: --l_delivery_info(i).delivery_type := 'STANDARD';
11934: --WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_info(i).delivery_type : '||l_delivery_info(i).delivery_type);
11935: END IF;
11936: --
11937: -- G_CREATE_DLVY should have 'N'
11937: -- G_CREATE_DLVY should have 'N'
11938: IF l_delivery_info(i).exists_in_database = 'Y' THEN -- Assigned lines have not been passed
11939: l_start_count := l_end_count + 1;
11940:
11941: IF l_delivery_info(i).delivery_type = 'STANDARD' THEN
11942: OPEN c_get_details(l_delivery_info(i).delivery_id);
11943: FETCH c_get_details BULK COLLECT INTO
11944: l_detail_tab,l_delivery_tab,l_exists_tab,l_customer_tab,l_item_tab,l_shipfrom_loc_tab,
11945: l_org_tab,l_shipto_loc_tab,l_intmed_shipto_loc_tab,
14739: IF ( l_target_delivery.delivery_id IS NOT NULL
14740: AND l_target_delivery.exists_in_database = 'Y') THEN
14741: --
14742: -- has been passed
14743: IF l_target_delivery.delivery_type = 'STANDARD' THEN
14744: OPEN c_get_details(l_target_delivery.delivery_id); -- or container_id
14745: LOOP
14746: FETCH c_get_details INTO l_detail_rec;
14747: EXIT WHEN c_get_details%NOTFOUND;