APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on INV_SHIPPING_TRANSACTION_PUB

Line 378: INV_SHIPPING_TRANSACTION_PUB.GET_DELIVERY_TRANSACTION_TYPE(

374: debug( 'l_delivery_detail_id is ' || l_delivery_detail_id, 'ValidateLPN');
375: END IF;
376: if (l_transaction_type_id = -1) then
377: l_transaction_type_id :=
378: INV_SHIPPING_TRANSACTION_PUB.GET_DELIVERY_TRANSACTION_TYPE(
379: l_delivery_detail_id,
380: l_transaction_source_type_id,
381: l_transaction_action_id,
382: l_return_status);

Line 517: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

513: , nvl(wnd.gross_weight, 0)
514: , wnd.weight_uom_code
515: , wnd.waybill
516: , ' ' trip_name,
517: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
518: FROM wsh_new_deliveries_ob_grp_v wnd
519: WHERE wnd.delivery_id = p_delivery_id;
520: END get_delivery_info;
521:

Line 2637: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

2633: if p_trip_id <> 0 then
2634: OPEN x_deliveryLOV for
2635: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2636: wnd.waybill,
2637: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2638: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2639: WHERE wnd.delivery_id = wstt.delivery_id
2640: and wstt.trip_id = p_trip_id
2641: and wstt.dock_door_id = p_dock_door_id

Line 2650: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

2646: else
2647: OPEN x_deliveryLOV for
2648: SELECT distinct wstt.delivery_name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
2649: wnd.waybill,
2650: INV_SHIPPING_TRANSACTION_PUB.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
2651: FROM wsh_new_deliveries wnd,wms_shipping_transaction_temp wstt
2652: WHERE wnd.delivery_id = wstt.delivery_id
2653: and wstt.dock_appoint_flag = 'N'
2654: and nvl(wstt.direct_ship_flag,'N') = 'N'