APPS.WSH_TRIP_STOPS_PVT dependencies on WSH_TRIPS

Line 35: from wsh_trips

31: get_physical_loc_err EXCEPTION;
32:
33: cursor l_trip_shipments_type_csr(p_trip_id IN NUMBER) is
34: select decode(shipments_type_flag, 'M', 'O', shipments_type_flag)
35: from wsh_trips
36: where trip_id = p_trip_id;
37:
38: l_shipments_type_flag VARCHAR2(100);
39:

Line 415: FROM WSH_TRIPS

411: --OTM R12, glog proj
412: CURSOR c_get_trip_status (p_trip_id IN NUMBER) IS
413: SELECT NVL(ignore_for_planning, 'N'),
414: tp_plan_name
415: FROM WSH_TRIPS
416: WHERE trip_id = p_trip_id;
417: --
418:
419:

Line 432: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

428: l_stop_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
429: l_dbi_rs VARCHAR2(1); -- DBI Project
430:
431: --OTM R12, glog proj
432: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
433: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
434: e_gc3_trip EXCEPTION;
435: l_gc3_is_installed VARCHAR2(1);
436: --

Line 433: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

429: l_dbi_rs VARCHAR2(1); -- DBI Project
430:
431: --OTM R12, glog proj
432: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
433: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
434: e_gc3_trip EXCEPTION;
435: l_gc3_is_installed VARCHAR2(1);
436: --
437:

Line 628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);

624: IF l_trip_id IS NOT NULL THEN
625:
626: -- Need to compute all stops weight/volumes
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);
629: END IF;
630:
631: l_trip_id_tab(1) := l_trip_id;
632: WSH_TRIPS_ACTIONS.trip_weight_volume(

Line 632: WSH_TRIPS_ACTIONS.trip_weight_volume(

628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);
629: END IF;
630:
631: l_trip_id_tab(1) := l_trip_id;
632: WSH_TRIPS_ACTIONS.trip_weight_volume(
633: p_trip_rows => l_trip_id_tab,
634: p_override_flag => 'Y',
635: p_calc_wv_if_frozen => 'N',
636: p_start_departure_date => to_date(NULL),

Line 1663: FROM wsh_trips

1659:
1660: --OTM R12, glog proj
1661: CURSOR get_trip_status(p_entity_id IN NUMBER) IS
1662: SELECT status_code, planned_flag,tp_plan_name
1663: FROM wsh_trips
1664: WHERE trip_id = p_entity_id;
1665:
1666: CURSOR has_pick_up_deliveries(x_stop_id NUMBER) IS
1667: SELECT delivery_id

Line 1706: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

1702: l_ssn_disabled BOOLEAN; -- used only to track this column when stop is OPEN
1703: l_pad_disabled BOOLEAN; -- used only to track this column when stop is OPEN
1704:
1705: -- OTM R12, glog proj
1706: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
1707: l_gc3_is_installed VARCHAR2(1);
1708:
1709: l_debug_on BOOLEAN;
1710: --

Line 1915: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE =

1911: END IF;
1912: ELSE
1913: -- SSN Change
1914: -- Only for Profile set to PAD and none of the above conditions are met
1915: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE =
1916: WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD THEN
1917: l_ssn_disabled := TRUE;
1918: i:=i+1; x_disabled_list(i) := 'STOP_SEQUENCE_NUMBER';
1919: END IF;