50:
51: TYPE plan_delivery_rec_type IS RECORD (
52: del_interface_id NUMBER,
53: delivery_id NUMBER,
54: tp_delivery_number WSH_NEW_DELIVERIES.TP_DELIVERY_NUMBER%TYPE,
55: tp_plan_name WSH_NEW_DELIVERIES.TP_PLAN_NAME%TYPE,
56: planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
57: wsh_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
58: initial_pickup_location_id NUMBER,
51: TYPE plan_delivery_rec_type IS RECORD (
52: del_interface_id NUMBER,
53: delivery_id NUMBER,
54: tp_delivery_number WSH_NEW_DELIVERIES.TP_DELIVERY_NUMBER%TYPE,
55: tp_plan_name WSH_NEW_DELIVERIES.TP_PLAN_NAME%TYPE,
56: planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
57: wsh_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
58: initial_pickup_location_id NUMBER,
59: ultimate_dropoff_location_id NUMBER,
52: del_interface_id NUMBER,
53: delivery_id NUMBER,
54: tp_delivery_number WSH_NEW_DELIVERIES.TP_DELIVERY_NUMBER%TYPE,
55: tp_plan_name WSH_NEW_DELIVERIES.TP_PLAN_NAME%TYPE,
56: planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
57: wsh_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
58: initial_pickup_location_id NUMBER,
59: ultimate_dropoff_location_id NUMBER,
60: initial_pickup_date DATE,
53: delivery_id NUMBER,
54: tp_delivery_number WSH_NEW_DELIVERIES.TP_DELIVERY_NUMBER%TYPE,
55: tp_plan_name WSH_NEW_DELIVERIES.TP_PLAN_NAME%TYPE,
56: planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
57: wsh_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,
58: initial_pickup_location_id NUMBER,
59: ultimate_dropoff_location_id NUMBER,
60: initial_pickup_date DATE,
61: ultimate_dropoff_date DATE,
58: initial_pickup_location_id NUMBER,
59: ultimate_dropoff_location_id NUMBER,
60: initial_pickup_date DATE,
61: ultimate_dropoff_date DATE,
62: ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE,
63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
59: ultimate_dropoff_location_id NUMBER,
60: initial_pickup_date DATE,
61: ultimate_dropoff_date DATE,
62: ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE,
63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
60: initial_pickup_date DATE,
61: ultimate_dropoff_date DATE,
62: ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE,
63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
61: ultimate_dropoff_date DATE,
62: ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE,
63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
62: ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE,
63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
66: name WSH_NEW_DELIVERIES.NAME%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
74: vendor_id WSH_NEW_DELIVERIES.VENDOR_ID%TYPE,
67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%TYPE,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
74: vendor_id WSH_NEW_DELIVERIES.VENDOR_ID%TYPE,
75: organization_id NUMBER,
68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%TYPE,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
74: vendor_id WSH_NEW_DELIVERIES.VENDOR_ID%TYPE,
75: organization_id NUMBER,
76: customer_id NUMBER,
69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_ID%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
74: vendor_id WSH_NEW_DELIVERIES.VENDOR_ID%TYPE,
75: organization_id NUMBER,
76: customer_id NUMBER,
77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
70: waybill WSH_NEW_DELIVERIES.WAYBILL%TYPE,
71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%TYPE,
72: party_id WSH_NEW_DELIVERIES.PARTY_ID%TYPE,
73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%TYPE,
74: vendor_id WSH_NEW_DELIVERIES.VENDOR_ID%TYPE,
75: organization_id NUMBER,
76: customer_id NUMBER,
77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
78: intmed_ship_to_location_id NUMBER,
76: customer_id NUMBER,
77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
78: intmed_ship_to_location_id NUMBER,
79: carrier_id NUMBER,
80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,
78: intmed_ship_to_location_id NUMBER,
79: carrier_id NUMBER,
80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
78: intmed_ship_to_location_id NUMBER,
79: carrier_id NUMBER,
80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
79: carrier_id NUMBER,
80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%TYPE,
80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%TYPE,
88: dock_code WSH_NEW_DELIVERIES.DOCK_CODE%TYPE,
81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%TYPE,
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%TYPE,
88: dock_code WSH_NEW_DELIVERIES.DOCK_CODE%TYPE,
89: ilines_count NUMBER, -- count interface lines in plan
82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE,
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%TYPE,
88: dock_code WSH_NEW_DELIVERIES.DOCK_CODE%TYPE,
89: ilines_count NUMBER, -- count interface lines in plan
90: lines_count NUMBER, -- count delivery lines mapped
83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE,
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%TYPE,
88: dock_code WSH_NEW_DELIVERIES.DOCK_CODE%TYPE,
89: ilines_count NUMBER, -- count interface lines in plan
90: lines_count NUMBER, -- count delivery lines mapped
91: s_lines_count NUMBER, -- count delivery lines released to warehouse
84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE,
85: volume WSH_NEW_DELIVERIES.VOLUME%TYPE,
86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE,
87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%TYPE,
88: dock_code WSH_NEW_DELIVERIES.DOCK_CODE%TYPE,
89: ilines_count NUMBER, -- count interface lines in plan
90: lines_count NUMBER, -- count delivery lines mapped
91: s_lines_count NUMBER, -- count delivery lines released to warehouse
92: dangling_conts_count NUMBER, -- count dangling topmost containers
92: dangling_conts_count NUMBER, -- count dangling topmost containers
93: wms_org_flag VARCHAR2(1),
94: assign_details_count NUMBER,
95: leg_base_index NUMBER,
96: wv_frozen_flag WSH_NEW_DELIVERIES.WV_FROZEN_FLAG%TYPE,
97: physical_ultimate_do_loc_id NUMBER -- internal org location to drop off
98: );
99: TYPE plan_delivery_tab_type IS TABLE OF plan_delivery_rec_type INDEX BY BINARY_INTEGER;
100:
238: released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE,
239: lpn_id NUMBER,
240: plan_dd_index NUMBER, -- index to x_plan_details for plan line
241: plan_del_index NUMBER, -- index to x_plan_deliveries for plan delivery
242: wv_frozen_flag WSH_NEW_DELIVERIES.WV_FROZEN_FLAG%TYPE,
243: initial_pickup_location_id WSH_NEW_DELIVERIES.INITIAL_PICKUP_LOCATION_ID%TYPE
244: );
245: TYPE delivery_unassign_tab_type IS TABLE OF delivery_unassign_rec INDEX BY BINARY_INTEGER;
246:
239: lpn_id NUMBER,
240: plan_dd_index NUMBER, -- index to x_plan_details for plan line
241: plan_del_index NUMBER, -- index to x_plan_deliveries for plan delivery
242: wv_frozen_flag WSH_NEW_DELIVERIES.WV_FROZEN_FLAG%TYPE,
243: initial_pickup_location_id WSH_NEW_DELIVERIES.INITIAL_PICKUP_LOCATION_ID%TYPE
244: );
245: TYPE delivery_unassign_tab_type IS TABLE OF delivery_unassign_rec INDEX BY BINARY_INTEGER;
246:
247: