APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on INV_SHIPPING_TRANSACTION_PUB

Line 430: INV_SHIPPING_TRANSACTION_PUB.GET_DELIVERY_TRANSACTION_TYPE(

426: debug( 'l_delivery_detail_id is ' || l_delivery_detail_id, 'ValidateLPN');
427: END IF;
428: if (l_transaction_type_id = -1) then
429: l_transaction_type_id :=
430: INV_SHIPPING_TRANSACTION_PUB.GET_DELIVERY_TRANSACTION_TYPE(
431: l_delivery_detail_id,
432: l_transaction_source_type_id,
433: l_transaction_action_id,
434: l_return_status);

Line 570: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

566: , nvl(wnd.gross_weight, 0)
567: , wnd.weight_uom_code
568: , wnd.waybill
569: , ' ' trip_name,
570: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
571: FROM wsh_new_deliveries_ob_grp_v wnd
572: WHERE wnd.delivery_id = p_delivery_id;
573: END get_delivery_info;
574:

Line 2698: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

2694: if p_trip_id <> 0 then
2695: OPEN x_deliveryLOV for
2696: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2697: wnd.waybill,
2698: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2699: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2700: WHERE wnd.delivery_id = wstt.delivery_id
2701: and wstt.trip_id = p_trip_id
2702: and wstt.dock_door_id = p_dock_door_id

Line 2711: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

2707: else
2708: OPEN x_deliveryLOV for
2709: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2710: wnd.waybill,
2711: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2712: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2713: WHERE wnd.delivery_id = wstt.delivery_id
2714: and wstt.dock_appoint_flag = 'N'
2715: and nvl(wstt.direct_ship_flag,'N') = 'N'