APPS.WSH_DOCUMENT_SETS dependencies on WSH_NEW_DELIVERIES

Line 190: FROM wsh_new_deliveries del,

186: dlg.delivery_leg_id,
187: wt.ship_method_code,
188: del.initial_pickup_location_id,
189: wt.name
190: FROM wsh_new_deliveries del,
191: wsh_delivery_legs dlg,
192: wsh_trip_stops st,
193: wsh_trips wt
194: WHERE del.delivery_id = dlg.delivery_id

Line 203: wsh_new_deliveries del

199: --LE Uptake
200: CURSOR c_get_ledger_id(p_delivery_id IN NUMBER) IS
201: SELECT ood.set_of_books_id
202: FROM org_organization_definitions ood,
203: wsh_new_deliveries del
204: WHERE ood.organization_id = del.organization_id
205: AND del.delivery_id = p_delivery_id;
206:
207: CURSOR m_get_ledger_id(p_delivery_id IN NUMBER) IS

Line 210: wsh_new_deliveries wnd

206:
207: CURSOR m_get_ledger_id(p_delivery_id IN NUMBER) IS
208: SELECT hoi.org_information1
209: FROM hr_organization_information hoi,
210: wsh_new_deliveries wnd
211: WHERE wnd.delivery_id = p_delivery_id
212: AND hoi.organization_id = wnd.organization_id
213: AND hoi.org_information_context = 'Accounting Information';
214:

Line 217: FROM WSH_NEW_DELIVERIES

213: AND hoi.org_information_context = 'Accounting Information';
214:
215: CURSOR c_get_init_pickup_loc_id(p_delivery_id IN NUMBER) IS
216: SELECT initial_pickup_location_id
217: FROM WSH_NEW_DELIVERIES
218: WHERE delivery_id = p_delivery_id;
219:
220: --- BugFix 3274604 - End
221:

Line 425: FROM WSH_NEW_DELIVERIES

421: entity_name varchar2(100);
422:
423: CURSOR Get_Del_Org (v_del_id NUMBER) IS
424: SELECT organization_id
425: FROM WSH_NEW_DELIVERIES
426: WHERE delivery_id = v_del_id;
427:
428: l_copies NUMBER := 0;
429:

Line 597: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

593: --
594: -- Debug Statements
595: --
596: IF l_debug_on THEN
597: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
598: END IF;
599: --
600: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));
601:

Line 600: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));

596: IF l_debug_on THEN
597: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
598: END IF;
599: --
600: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));
601:
602: else
603: entity_name := 'LINE ';
604: end if;

Line 1257: WHERE entity_name = 'WSH_NEW_DELIVERIES'

1253:
1254: SELECT count(*)
1255: into cnt
1256: from wsh_document_instances
1257: WHERE entity_name = 'WSH_NEW_DELIVERIES'
1258: AND entity_id = l_argument(2)
1259: AND document_type = 'PACK_TYPE';
1260:
1261: IF cnt = 0 then

Line 1294: , p_entity_name => 'WSH_NEW_DELIVERIES'

1290: , p_validation_level => NULL
1291: , x_return_status => l_return_status
1292: , x_msg_count => l_msg_count
1293: , x_msg_data => l_msg_data
1294: , p_entity_name => 'WSH_NEW_DELIVERIES'
1295: , p_entity_id => l_argument(2)
1296: , p_application_id => 665
1297: , p_location_id => p_location_id1
1298: , p_document_type => 'PACK_TYPE'