APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_NEW_DELIVERIES

Line 45: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12, glog proj

41: status_code,
42: planned_flag,
43: NVL(shipment_direction, 'O'), -- J IB jckwok
44: NVL(ignore_for_planning, 'N'), -- OTM R12, glog proj
45: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12, glog proj
46: FROM wsh_new_deliveries
47: WHERE delivery_id = p_delivery_id;
48:
49: CURSOR get_parent_leg(p_delivery_leg_id in number) is

Line 46: FROM wsh_new_deliveries

42: planned_flag,
43: NVL(shipment_direction, 'O'), -- J IB jckwok
44: NVL(ignore_for_planning, 'N'), -- OTM R12, glog proj
45: NVL(tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12, glog proj
46: FROM wsh_new_deliveries
47: WHERE delivery_id = p_delivery_id;
48:
49: CURSOR get_parent_leg(p_delivery_leg_id in number) is
50: select parent.delivery_leg_id, parent.delivery_id

Line 95: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE; -- OTM R12,glog proj

91: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
92: l_delivery_leg_id NUMBER;
93: l_delivery_id NUMBER;
94:
95: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE; -- OTM R12,glog proj
96: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE; -- OTM R12,glog proj
97:
98: -- Added for bug 4493263
99: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;

Line 96: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE; -- OTM R12,glog proj

92: l_delivery_leg_id NUMBER;
93: l_delivery_id NUMBER;
94:
95: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE; -- OTM R12,glog proj
96: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE; -- OTM R12,glog proj
97:
98: -- Added for bug 4493263
99: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
100: l_dummy_id_tab wsh_util_core.id_tab_type;

Line 812: wsh_new_deliveries d, wsh_delivery_legs l, wsh_trip_stops s

808: l_num_errors NUMBER;
809:
810: cursor c_is_final_leg (p_dleg_id in number) is
811: select d.delivery_id from
812: wsh_new_deliveries d, wsh_delivery_legs l, wsh_trip_stops s
813: where l.delivery_id = d.delivery_id
814: and d.ultimate_dropoff_location_id = s.stop_location_id
815: and l.drop_off_stop_id = s.stop_id
816: and l.delivery_leg_id = p_dleg_id;

Line 861: wsh_new_deliveries_pvt.lock_dlvy_no_compare(

857: IF l_delivery_id IS NOT NULL THEN
858:
859: -- Lock the delivery before update
860:
861: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
862: p_delivery_id => l_delivery_id);
863:
864:
865: UPDATE wsh_new_deliveries

Line 865: UPDATE wsh_new_deliveries

861: wsh_new_deliveries_pvt.lock_dlvy_no_compare(
862: p_delivery_id => l_delivery_id);
863:
864:
865: UPDATE wsh_new_deliveries
866: SET DELIVERED_DATE = p_delivery_leg_tab(l_index).POD_DATE
867: WHERE delivery_id = l_delivery_id;
868:
869: END IF;