DBA Data[Home] [Help]

APPS.WSH_CUST_MERGE dependencies on WSH_DELIVERY_VALIDATIONS

Line 1306: l_tms_trip_tab WSH_DELIVERY_VALIDATIONS.trip_info_tab_type;

1302: l_gc3_is_installed VARCHAR2(1);
1303:
1304: frcost_not_found EXCEPTION;
1305: l_tms_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1306: l_tms_trip_tab WSH_DELIVERY_VALIDATIONS.trip_info_tab_type;
1307: l_new_delivery_leg_tab g_rowid_tbl_type;
1308: l_delivery_leg_count NUMBER;
1309: l_ignoreTab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1310: l_tms_count NUMBER;

Line 1321: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

1317: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1318: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1319: l_tms_update WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1320: l_trip_not_found VARCHAR2(1);
1321: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
1322: l_tms_version_number g_number_tbl_type;
1323: l_tms_interface_flag WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1324: l_index NUMBER;
1325: l_delivery_count NUMBER;

Line 1491: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

1487: l_index := l_hash_value_tab.FIRST;
1488: WHILE (l_index IS NOT NULL) LOOP
1489: l_trip_not_found := 'N';
1490:
1491: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
1492: p_delivery_id => l_delivery_id_tab(l_index),
1493: x_delivery_rec => l_delivery_info,
1494: x_return_status => l_return_status);
1495:

Line 1504: WSH_DELIVERY_VALIDATIONS.get_trip_information

1500:
1501: IF (nvl(l_delivery_info.ignore_for_planning, 'N') = 'N') THEN
1502:
1503: --get trip information for delivery, no update when trip not OPEN
1504: WSH_DELIVERY_VALIDATIONS.get_trip_information
1505: (p_delivery_id => l_delivery_id_tab(l_index),
1506: x_trip_info_rec => l_trip_info_rec,
1507: x_return_status => l_return_status);
1508:

Line 1799: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

1795: -- for loop to populate
1796: l_index := l_tms_delivery_id_tab.FIRST;
1797: WHILE (l_index IS NOT NULL) LOOP
1798:
1799: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
1800: p_delivery_id => l_tms_delivery_id_tab(l_index),
1801: x_delivery_rec => l_delivery_info,
1802: x_return_status => l_return_status);
1803:

Line 1812: WSH_DELIVERY_VALIDATIONS.get_trip_information

1808:
1809: IF (nvl(l_delivery_info.ignore_for_planning, 'N') = 'N') THEN
1810:
1811: --get trip information for delivery, no update when trip not OPEN
1812: WSH_DELIVERY_VALIDATIONS.get_trip_information
1813: (p_delivery_id => l_tms_delivery_id_tab(l_index),
1814: x_trip_info_rec => l_trip_info_rec,
1815: x_return_status => l_return_status);
1816: