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:

Line 778: from wsh_new_deliveries wnd,

774: IS
775:
776: CURSOR c_delId_cur IS
777: SELECT wnd.delivery_id
778: from wsh_new_deliveries wnd,
779: wsh_transactions_history wth
780: where wnd.name = wth.entity_number
781: and entity_type='DLVY'
782: and wth.event_key = item_key

Line 1587: FROM wsh_new_deliveries

1583: l_event_key VARCHAR2(250);
1584:
1585: CURSOR c_del_status (v_delivery_name varchar2) IS
1586: SELECT status_code
1587: FROM wsh_new_deliveries
1588: WHERE name = v_delivery_name;
1589:
1590: CURSOR c_get_event_key(v_delivery_name NUMBER) IS
1591: SELECT event_key

Line 2023: FROM wsh_new_deliveries

2019: ORDER BY transaction_id DESC;
2020:
2021: CURSOR c_get_del_status (v_delivery_name VARCHAR2) IS
2022: SELECT status_code
2023: FROM wsh_new_deliveries
2024: WHERE name = v_delivery_name;
2025:
2026: l_status wsh_new_deliveries.status_code%TYPE;
2027:

Line 2026: l_status wsh_new_deliveries.status_code%TYPE;

2022: SELECT status_code
2023: FROM wsh_new_deliveries
2024: WHERE name = v_delivery_name;
2025:
2026: l_status wsh_new_deliveries.status_code%TYPE;
2027:
2028: cursor c_get_cancel_rec (v_item_type VARCHAR2, v_item_key VARCHAR2)
2029: IS
2030: SELECT entity_number