APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_NEW_DELIVERIES

Line 116: select name, customer_id from wsh_new_deliveries

112:
113: l_txns_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
114:
115: cursor del_name_cur is
116: select name, customer_id from wsh_new_deliveries
117: where delivery_id = p_entity_id;
118:
119: -- This cursor checks if the delivery contains all the delivery details associated their corresponding source_line_ids.
120: cursor valid_del_cur(p_delivery_id IN NUMBER) is

Line 412: from wsh_new_deliveries

408: p_document_type,
409: x_return_status);
410: --commit;
411: select 1 into l_tmp
412: from wsh_new_deliveries
413: where delivery_id = p_entity_id
414: for update nowait;
415:
416: IF l_debug_on THEN

Line 465: from wsh_new_deliveries

461: Bug 2399483
462: */
463:
464: select 1 into l_tmp
465: from wsh_new_deliveries
466: where delivery_id = p_entity_id
467: for update nowait;
468:
469: WSH_DELIVERY_UTIL.Update_Dlvy_Status (p_entity_id,

Line 612: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_cancel_disallowed');
609: END IF;
610: WHEN wsh_del_assign_to_trip THEN
611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_OUTBOUND_FAILED_TRIP');
612: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
614: wsh_util_core.add_message(x_return_status,l_module_name);
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_assign_to_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));

636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_details_credit_hold ');
637: END IF;
638: WHEN wsh_invalid_customer THEN
639: FND_MESSAGE.SET_NAME('WSH','WSH_NO_CUST_DEF_ERROR');
640: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_entity_id));
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: wsh_util_core.add_message(x_return_status,l_module_name);
643: IF l_debug_on THEN
644: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_customer exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 675: from wsh_new_deliveries

671: and trading_partner_id = p_organization_id;
672:
673: cursor del_cur is
674: select delivery_id
675: from wsh_new_deliveries
676: where name = p_delivery_name
677: and organization_id = p_organization_id;
678:
679: l_event_code VARCHAR2(30);

Line 814: from wsh_new_deliveries wnd,

810: IS
811:
812: CURSOR c_delId_cur IS
813: SELECT wnd.delivery_id
814: from wsh_new_deliveries wnd,
815: wsh_transactions_history wth
816: where wnd.name = wth.entity_number
817: and entity_type='DLVY'
818: and wth.event_key = item_key

Line 1869: FROM wsh_new_deliveries

1865: l_event_key VARCHAR2(250);
1866:
1867: CURSOR c_del_status (v_delivery_name varchar2) IS
1868: SELECT status_code
1869: FROM wsh_new_deliveries
1870: WHERE name = v_delivery_name;
1871:
1872: CURSOR c_get_event_key(v_delivery_name NUMBER) IS
1873: SELECT event_key

Line 2308: FROM wsh_new_deliveries

2304: ORDER BY transaction_id DESC;
2305:
2306: CURSOR c_get_del_status (v_delivery_name VARCHAR2) IS
2307: SELECT status_code
2308: FROM wsh_new_deliveries
2309: WHERE name = v_delivery_name;
2310:
2311: l_status wsh_new_deliveries.status_code%TYPE;
2312:

Line 2311: l_status wsh_new_deliveries.status_code%TYPE;

2307: SELECT status_code
2308: FROM wsh_new_deliveries
2309: WHERE name = v_delivery_name;
2310:
2311: l_status wsh_new_deliveries.status_code%TYPE;
2312:
2313: cursor c_get_cancel_rec (v_item_type VARCHAR2, v_item_key VARCHAR2)
2314: IS
2315: SELECT entity_number