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_PVT

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 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 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 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 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: