DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE_INT dependencies on WSH_NEW_DELIVERIES

Line 54: tp_delivery_number WSH_NEW_DELIVERIES.TP_DELIVERY_NUMBER%TYPE,

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,

Line 55: tp_plan_name WSH_NEW_DELIVERIES.TP_PLAN_NAME%TYPE,

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,

Line 56: planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,

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,

Line 57: wsh_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE,

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,

Line 62: ship_method_code WSH_NEW_DELIVERIES.SHIP_METHOD_CODE%TYPE,

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,

Line 63: mode_of_transport WSH_NEW_DELIVERIES.MODE_OF_TRANSPORT%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,

Line 64: service_level WSH_NEW_DELIVERIES.SERVICE_LEVEL%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,

Line 65: freight_terms_code WSH_NEW_DELIVERIES.FREIGHT_TERMS_CODE%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,

Line 66: name WSH_NEW_DELIVERIES.NAME%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,

Line 67: loading_sequence WSH_NEW_DELIVERIES.LOADING_SEQUENCE%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,

Line 68: loading_order_flag WSH_NEW_DELIVERIES.LOADING_ORDER_FLAG%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,

Line 69: fob_location_id WSH_NEW_DELIVERIES.FOB_LOCATION_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,

Line 70: waybill WSH_NEW_DELIVERIES.WAYBILL%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,

Line 71: currency_code WSH_NEW_DELIVERIES.CURRENCY_CODE%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,

Line 72: party_id WSH_NEW_DELIVERIES.PARTY_ID%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,
76: customer_id NUMBER,

Line 73: shipping_control WSH_NEW_DELIVERIES.SHIPPING_CONTROL%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,
77: fob_code WSH_DELIVERY_DETAILS.FOB_CODE%TYPE,

Line 74: vendor_id WSH_NEW_DELIVERIES.VENDOR_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,
78: intmed_ship_to_location_id NUMBER,

Line 80: shipment_direction WSH_NEW_DELIVERIES.SHIPMENT_DIRECTION%TYPE,

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,

Line 81: additional_shipment_info WSH_NEW_DELIVERIES.ADDITIONAL_SHIPMENT_INFO%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,

Line 82: gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%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,

Line 83: net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%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,

Line 84: weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%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,

Line 85: volume WSH_NEW_DELIVERIES.VOLUME%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

Line 86: volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%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
90: lines_count NUMBER, -- count delivery lines mapped

Line 87: pooled_ship_to_location_id WSH_NEW_DELIVERIES.POOLED_SHIP_TO_LOCATION_ID%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
91: s_lines_count NUMBER, -- count delivery lines released to warehouse

Line 88: dock_code WSH_NEW_DELIVERIES.DOCK_CODE%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
92: dangling_conts_count NUMBER, -- count dangling topmost containers

Line 96: wv_frozen_flag WSH_NEW_DELIVERIES.WV_FROZEN_FLAG%TYPE,

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:

Line 242: wv_frozen_flag WSH_NEW_DELIVERIES.WV_FROZEN_FLAG%TYPE,

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:

Line 243: initial_pickup_location_id WSH_NEW_DELIVERIES.INITIAL_PICKUP_LOCATION_ID%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:
247: