eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_NEW_DELIVERIES

Line 44: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

40:
41:
42:
43: --dummy tables for calling validate_constraint_main
44: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
45: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
46: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
47: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
48: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;

Line 113: wsh_new_deliveries d

109:
110: CURSOR c_get_deliveries IS
111: SELECT t.id, d.ignore_for_planning
112: FROM wsh_tmp t,
113: wsh_new_deliveries d
114: WHERE d.delivery_id = t.id
115: AND NOT EXISTS (
116: SELECT WDA.delivery_detail_id
117: FROM wsh_delivery_assignments_v WDA,

Line 135: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

131: ORDER BY d.creation_date;
132:
133:
134: -- OTM R12 : update delivery
135: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
136: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
137: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
138: l_tms_update VARCHAR2(1);
139: l_trip_not_found VARCHAR2(1);

Line 136: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

132:
133:
134: -- OTM R12 : update delivery
135: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
136: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
137: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
138: l_tms_update VARCHAR2(1);
139: l_trip_not_found VARCHAR2(1);
140: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 141: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

137: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
138: l_tms_update VARCHAR2(1);
139: l_trip_not_found VARCHAR2(1);
140: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
141: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
142: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
143: l_otm_return_status VARCHAR2(1); -- not to overwrite l_return_status
144: l_gc3_is_installed VARCHAR2(1);
145: -- End of OTM R12 : update delivery

Line 142: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

138: l_tms_update VARCHAR2(1);
139: l_trip_not_found VARCHAR2(1);
140: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
141: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
142: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
143: l_otm_return_status VARCHAR2(1); -- not to overwrite l_return_status
144: l_gc3_is_installed VARCHAR2(1);
145: -- End of OTM R12 : update delivery
146:

Line 504: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

500: nvl(l_delivery_info.mode_of_transport, '@@') <>
501: NVL(l_delivery_info.mode_of_transport,
502: nvl(l_attr_tab(1).mode_of_transport, '@@'))) THEN
503: IF (l_delivery_info.tms_interface_flag NOT IN
504: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
505: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
506: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 505: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

501: NVL(l_delivery_info.mode_of_transport,
502: nvl(l_attr_tab(1).mode_of_transport, '@@'))) THEN
503: IF (l_delivery_info.tms_interface_flag NOT IN
504: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
505: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
506: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
509: l_tms_update := 'Y';

Line 506: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

502: nvl(l_attr_tab(1).mode_of_transport, '@@'))) THEN
503: IF (l_delivery_info.tms_interface_flag NOT IN
504: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
505: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
506: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
509: l_tms_update := 'Y';
510: l_delivery_info_tab(1) := l_delivery_info;

Line 507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

503: IF (l_delivery_info.tms_interface_flag NOT IN
504: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
505: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
506: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
509: l_tms_update := 'Y';
510: l_delivery_info_tab(1) := l_delivery_info;
511: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

504: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
505: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
506: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
509: l_tms_update := 'Y';
510: l_delivery_info_tab(1) := l_delivery_info;
511: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
512: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 511: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

507: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
508: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
509: l_tms_update := 'Y';
510: l_delivery_info_tab(1) := l_delivery_info;
511: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
512: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;
513: END IF;
514: END IF; -- checking the value differences
515: END IF; -- IF ((l_trip_not_found = 'N' AND

Line 598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );

594: END LOOP;
595:
596: -- update appended delivery
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
599: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
600: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
601: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
602: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

Line 619: UPDATE wsh_new_deliveries

615: END IF;
616: -- End of OTM R12 : update delivery
617: END IF;
618:
619: UPDATE wsh_new_deliveries
620: SET intmed_ship_to_location_id = NVL(intmed_ship_to_location_id,l_attr_tab(1).intmed_ship_to_location_id),
621: fob_code = NVL(fob_code,l_attr_tab(1).fob_code),
622: freight_terms_code = NVL(freight_terms_code,l_attr_tab(1).freight_terms_code),
623: ship_method_code = NVL(ship_method_code,l_attr_tab(1).ship_method_code),

Line 636: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

632: last_update_date = SYSDATE,
633: last_updated_by = FND_GLOBAL.user_id,
634: last_update_login = FND_GLOBAL.login_id,
635: -- OTM R12
636: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
637: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1))
638: -- End of OTM R12
639: WHERE delivery_id = l_delivery_id;
640:

Line 749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );

745: i := l_action_out_rec.result_id_tab.next(i);
746: END LOOP;
747:
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
750: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
751: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
752: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
753: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

Line 769: UPDATE wsh_new_deliveries

765: END IF;
766: -- End of OTM R12 : update delivery
767: END IF;
768:
769: UPDATE wsh_new_deliveries
770: SET intmed_ship_to_location_id = NVL(intmed_ship_to_location_id,l_attr_tab(1).intmed_ship_to_location_id),
771: fob_code = NVL(fob_code,l_attr_tab(1).fob_code),
772: freight_terms_code = NVL(freight_terms_code,l_attr_tab(1).freight_terms_code),
773: ship_method_code = NVL(ship_method_code,l_attr_tab(1).ship_method_code),

Line 786: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

782: last_update_date = SYSDATE,
783: last_updated_by = FND_GLOBAL.user_id,
784: last_update_login = FND_GLOBAL.login_id,
785: -- OTM R12
786: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
787: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1))
788: -- End of OTM R12
789: WHERE delivery_id = l_delivery_id;
790: