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 50: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

46:
47:
48:
49: --dummy tables for calling validate_constraint_main
50: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
51: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
52: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
53: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
54: l_cc_in_ids WSH_UTIL_CORE.id_tab_type;

Line 119: wsh_new_deliveries d

115: --bugfix 13998576 added hint in subquery
116: CURSOR c_get_deliveries IS
117: SELECT t.id, d.ignore_for_planning
118: FROM wsh_tmp t,
119: wsh_new_deliveries d
120: WHERE d.delivery_id = t.id
121: AND NOT EXISTS (
122: SELECT /*+ no_unnest */ WDA.delivery_detail_id
123: FROM wsh_delivery_assignments_v WDA,

Line 141: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

137: ORDER BY d.creation_date;
138:
139:
140: -- OTM R12 : update delivery
141: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
142: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
143: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
144: l_tms_update VARCHAR2(1);
145: l_trip_not_found VARCHAR2(1);

Line 142: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

138:
139:
140: -- OTM R12 : update delivery
141: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
142: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
143: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
144: l_tms_update VARCHAR2(1);
145: l_trip_not_found VARCHAR2(1);
146: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 147: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;

143: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
144: l_tms_update VARCHAR2(1);
145: l_trip_not_found VARCHAR2(1);
146: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
147: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
148: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
149: l_otm_return_status VARCHAR2(1); -- not to overwrite l_return_status
150: l_gc3_is_installed VARCHAR2(1);
151: -- End of OTM R12 : update delivery

Line 148: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

144: l_tms_update VARCHAR2(1);
145: l_trip_not_found VARCHAR2(1);
146: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
147: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
148: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
149: l_otm_return_status VARCHAR2(1); -- not to overwrite l_return_status
150: l_gc3_is_installed VARCHAR2(1);
151: -- End of OTM R12 : update delivery
152:

Line 510: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

506: nvl(l_delivery_info.mode_of_transport, '@@') <>
507: NVL(l_delivery_info.mode_of_transport,
508: nvl(l_attr_tab(1).mode_of_transport, '@@'))) THEN
509: IF (l_delivery_info.tms_interface_flag NOT IN
510: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
511: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
512: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 511: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

507: NVL(l_delivery_info.mode_of_transport,
508: nvl(l_attr_tab(1).mode_of_transport, '@@'))) THEN
509: IF (l_delivery_info.tms_interface_flag NOT IN
510: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
511: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
512: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
515: l_tms_update := 'Y';

Line 512: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

508: nvl(l_attr_tab(1).mode_of_transport, '@@'))) THEN
509: IF (l_delivery_info.tms_interface_flag NOT IN
510: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
511: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
512: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
515: l_tms_update := 'Y';
516: l_delivery_info_tab(1) := l_delivery_info;

Line 513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

509: IF (l_delivery_info.tms_interface_flag NOT IN
510: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
511: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
512: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
515: l_tms_update := 'Y';
516: l_delivery_info_tab(1) := l_delivery_info;
517: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

510: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
511: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
512: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
515: l_tms_update := 'Y';
516: l_delivery_info_tab(1) := l_delivery_info;
517: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
518: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;

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

513: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
514: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
515: l_tms_update := 'Y';
516: l_delivery_info_tab(1) := l_delivery_info;
517: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
518: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;
519: END IF;
520: END IF; -- checking the value differences
521: END IF; -- IF ((l_trip_not_found = 'N' AND

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

600: END LOOP;
601:
602: -- update appended delivery
603: IF l_debug_on THEN
604: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
605: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
606: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
607: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
608: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

Line 625: UPDATE wsh_new_deliveries

621: END IF;
622: -- End of OTM R12 : update delivery
623: END IF;
624:
625: UPDATE wsh_new_deliveries
626: SET intmed_ship_to_location_id = NVL(intmed_ship_to_location_id,l_attr_tab(1).intmed_ship_to_location_id),
627: fob_code = NVL(fob_code,l_attr_tab(1).fob_code),
628: freight_terms_code = NVL(freight_terms_code,l_attr_tab(1).freight_terms_code),
629: ship_method_code = NVL(ship_method_code,l_attr_tab(1).ship_method_code),

Line 642: 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)),

638: last_update_date = SYSDATE,
639: last_updated_by = FND_GLOBAL.user_id,
640: last_update_login = FND_GLOBAL.login_id,
641: -- OTM R12
642: 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)),
643: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1))
644: -- End of OTM R12
645: WHERE delivery_id = l_delivery_id;
646:

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

751: i := l_action_out_rec.result_id_tab.next(i);
752: END LOOP;
753:
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATING WSH_NEW_DELIVERIES ATTRIBUTES' );
756: WSH_DEBUG_SV.log(l_module_name, 'intmed_ship_to_location_id', l_attr_tab(1).intmed_ship_to_location_id );
757: WSH_DEBUG_SV.log(l_module_name, 'fob_code', l_attr_tab(1).fob_code );
758: WSH_DEBUG_SV.log(l_module_name, 'freight_terms_code', l_attr_tab(1).freight_terms_code );
759: WSH_DEBUG_SV.log(l_module_name, 'carrier_id', l_attr_tab(1).carrier_id );

Line 775: UPDATE wsh_new_deliveries

771: END IF;
772: -- End of OTM R12 : update delivery
773: END IF;
774:
775: UPDATE wsh_new_deliveries
776: SET intmed_ship_to_location_id = NVL(intmed_ship_to_location_id,l_attr_tab(1).intmed_ship_to_location_id),
777: fob_code = NVL(fob_code,l_attr_tab(1).fob_code),
778: freight_terms_code = NVL(freight_terms_code,l_attr_tab(1).freight_terms_code),
779: ship_method_code = NVL(ship_method_code,l_attr_tab(1).ship_method_code),

Line 792: 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)),

788: last_update_date = SYSDATE,
789: last_updated_by = FND_GLOBAL.user_id,
790: last_update_login = FND_GLOBAL.login_id,
791: -- OTM R12
792: 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)),
793: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1))
794: -- End of OTM R12
795: WHERE delivery_id = l_delivery_id;
796: