512:
513:
514: --Harmonizing Project
515: TYPE DeliveryActionsRec IS RECORD(
516: status_code wsh_new_deliveries.status_code%TYPE,
517: planned_flag wsh_new_deliveries.planned_flag%TYPE,
518: caller VARCHAR2(100),
519: action_not_allowed VARCHAR2(100),
520: org_type VARCHAR2(30),
513:
514: --Harmonizing Project
515: TYPE DeliveryActionsRec IS RECORD(
516: status_code wsh_new_deliveries.status_code%TYPE,
517: planned_flag wsh_new_deliveries.planned_flag%TYPE,
518: caller VARCHAR2(100),
519: action_not_allowed VARCHAR2(100),
520: org_type VARCHAR2(30),
521: message_name VARCHAR2(2000),
520: org_type VARCHAR2(30),
521: message_name VARCHAR2(2000),
522: shipment_direction VARCHAR2(30),
523: --OTM R12
524: ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE,
525: tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
526: otm_enabled WSH_SHIPPING_PARAMETERS.OTM_ENABLED%TYPE -- OTM R12 - Bug#5399341
527: --
528: );
521: message_name VARCHAR2(2000),
522: shipment_direction VARCHAR2(30),
523: --OTM R12
524: ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE,
525: tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
526: otm_enabled WSH_SHIPPING_PARAMETERS.OTM_ENABLED%TYPE -- OTM R12 - Bug#5399341
527: --
528: );
529: -- A Column called message_name has been added to the record
544: planned_flag VARCHAR2(32000),
545: shipment_direction VARCHAR2(30),
546: delivery_type VARCHAR2(30),
547: --OTM R12
548: ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE,
549: tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
550: otm_enabled WSH_SHIPPING_PARAMETERS.OTM_ENABLED%TYPE, -- OTM R12 - Bug#539934a
551: client_id NUMBER --- LSP PROJECT
552: --
545: shipment_direction VARCHAR2(30),
546: delivery_type VARCHAR2(30),
547: --OTM R12
548: ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE,
549: tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE,
550: otm_enabled WSH_SHIPPING_PARAMETERS.OTM_ENABLED%TYPE, -- OTM R12 - Bug#539934a
551: client_id NUMBER --- LSP PROJECT
552: --
553: );
578: --
579: -- Overloaded procedure
580: --
581: PROCEDURE Get_Disabled_List (
582: p_delivery_rec IN WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
583: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
584: , x_return_status OUT NOCOPY VARCHAR2
585: , x_msg_count OUT NOCOPY NUMBER
586: , x_msg_data OUT NOCOPY VARCHAR2
583: , p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type
584: , x_return_status OUT NOCOPY VARCHAR2
585: , x_msg_count OUT NOCOPY NUMBER
586: , x_msg_data OUT NOCOPY VARCHAR2
587: , x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type
588: );
589:
590: PROCEDURE Init_Delivery_Actions_Tbl (
591: p_action IN VARCHAR2
758: );
759:
760: PROCEDURE GET_DELIVERY_INFORMATION
761: (p_delivery_id IN NUMBER,
762: x_delivery_rec OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type,
763: x_return_status OUT NOCOPY VARCHAR2);
764: --END OTM R12
765:
766: END WSH_DELIVERY_VALIDATIONS;