APPS.WSH_DOCUMENT_SETS dependencies on WSH_NEW_DELIVERIES

Line 177: FROM wsh_new_deliveries del,

173: dlg.delivery_leg_id,
174: wt.ship_method_code,
175: del.initial_pickup_location_id,
176: wt.name
177: FROM wsh_new_deliveries del,
178: wsh_delivery_legs dlg,
179: wsh_trip_stops st,
180: wsh_trips wt
181: WHERE del.delivery_id = dlg.delivery_id

Line 190: wsh_new_deliveries del

186: --LE Uptake
187: CURSOR c_get_ledger_id(p_delivery_id IN NUMBER) IS
188: SELECT ood.set_of_books_id
189: FROM org_organization_definitions ood,
190: wsh_new_deliveries del
191: WHERE ood.organization_id = del.organization_id
192: AND del.delivery_id = p_delivery_id;
193:
194: CURSOR m_get_ledger_id(p_delivery_id IN NUMBER) IS

Line 197: wsh_new_deliveries wnd

193:
194: CURSOR m_get_ledger_id(p_delivery_id IN NUMBER) IS
195: SELECT hoi.org_information1
196: FROM hr_organization_information hoi,
197: wsh_new_deliveries wnd
198: WHERE wnd.delivery_id = p_delivery_id
199: AND hoi.organization_id = wnd.organization_id
200: AND hoi.org_information_context = 'Accounting Information';
201:

Line 204: FROM WSH_NEW_DELIVERIES

200: AND hoi.org_information_context = 'Accounting Information';
201:
202: CURSOR c_get_init_pickup_loc_id(p_delivery_id IN NUMBER) IS
203: SELECT initial_pickup_location_id
204: FROM WSH_NEW_DELIVERIES
205: WHERE delivery_id = p_delivery_id;
206:
207: --- BugFix 3274604 - End
208:

Line 412: FROM WSH_NEW_DELIVERIES

408: entity_name varchar2(100);
409:
410: CURSOR Get_Del_Org (v_del_id NUMBER) IS
411: SELECT organization_id
412: FROM WSH_NEW_DELIVERIES
413: WHERE delivery_id = v_del_id;
414:
415: l_copies NUMBER := 0;
416:

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

577: --
578: -- Debug Statements
579: --
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
582: END IF;
583: --
584: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));
585:

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

580: IF l_debug_on THEN
581: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
582: END IF;
583: --
584: entity_name := WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_ids(i));
585:
586: else
587: entity_name := 'LINE ';
588: end if;

Line 1217: WHERE entity_name = 'WSH_NEW_DELIVERIES'

1213:
1214: SELECT count(*)
1215: into cnt
1216: from wsh_document_instances
1217: WHERE entity_name = 'WSH_NEW_DELIVERIES'
1218: AND entity_id = l_argument(2)
1219: AND document_type = 'PACK_TYPE';
1220:
1221: IF cnt = 0 then

Line 1254: , p_entity_name => 'WSH_NEW_DELIVERIES'

1250: , p_validation_level => NULL
1251: , x_return_status => l_return_status
1252: , x_msg_count => l_msg_count
1253: , x_msg_data => l_msg_data
1254: , p_entity_name => 'WSH_NEW_DELIVERIES'
1255: , p_entity_id => l_argument(2)
1256: , p_application_id => 665
1257: , p_location_id => p_location_id1
1258: , p_document_type => 'PACK_TYPE'