DBA Data[Home] [Help]

APPS.WSH_CUST_MERGE dependencies on WSH_DELIVERY_VALIDATIONS

Line 1309: l_tms_trip_tab WSH_DELIVERY_VALIDATIONS.trip_info_tab_type;

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

Line 1324: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

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

Line 1494: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

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

Line 1507: WSH_DELIVERY_VALIDATIONS.get_trip_information

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

Line 1802: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

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

Line 1815: WSH_DELIVERY_VALIDATIONS.get_trip_information

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