APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_TRIP_TAB

Line 77: -- in the form of objects (WSH_OTM_TRIP_TAB)

73: -- +==========================================================================================+
74: -- Procedure : GET_TRIP_OBJECTS
75: -- Description:
76: -- Procedure to get the Trip, Trip Stop, delivery,delivery details and Lpn info
77: -- in the form of objects (WSH_OTM_TRIP_TAB)
78:
79: -- Inputs/Outputs:
80: -- p_trip_id_tab - id table (list of Trip Ids)
81: -- p_user_id - User Id to set the context

Line 102: x_trip_tab OUT NOCOPY WSH_OTM_TRIP_TAB,

98: x_domain_name OUT NOCOPY VARCHAR2,
99: x_otm_user_name OUT NOCOPY VARCHAR2,
100: x_otm_pwd OUT NOCOPY VARCHAR2,
101: x_server_tz_code OUT NOCOPY VARCHAR2,
102: x_trip_tab OUT NOCOPY WSH_OTM_TRIP_TAB,
103: x_dlv_tab OUT NOCOPY WSH_OTM_DLV_TAB,
104: x_error_trip_id_tab OUT NOCOPY WSH_OTM_ID_TAB,
105: x_return_status OUT NOCOPY VARCHAR2)IS
106:

Line 111: l_trip_tab WSH_OTM_TRIP_TAB;

107: -- Declare local variables
108:
109: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_TRIP_OBJECTS';
110:
111: l_trip_tab WSH_OTM_TRIP_TAB;
112: l_stops_tab WSH_OTM_STOP_TAB;
113: --lpn_tab WSH_OTM_LPN_TAB;
114: l_dlv_tab WSH_OTM_DLV_TAB;
115: l_dlv_ids WSH_OTM_ID_TAB;

Line 306: x_trip_tab := WSH_OTM_TRIP_TAB();

302:
303: i:=1;
304:
305: WSH_UTIL_CORE.OpenDynamicCursor(c_trips, l_trips_sql, bind_col_tab);
306: x_trip_tab := WSH_OTM_TRIP_TAB();
307: l_trip_tab := WSH_OTM_TRIP_TAB();
308: l_stops_tab := WSH_OTM_STOP_TAB();
309: l_stop_details := WSH_OTM_STOP_DET_TAB();
310: l_all_dlv_tab := WSH_OTM_DLV_TAB();

Line 307: l_trip_tab := WSH_OTM_TRIP_TAB();

303: i:=1;
304:
305: WSH_UTIL_CORE.OpenDynamicCursor(c_trips, l_trips_sql, bind_col_tab);
306: x_trip_tab := WSH_OTM_TRIP_TAB();
307: l_trip_tab := WSH_OTM_TRIP_TAB();
308: l_stops_tab := WSH_OTM_STOP_TAB();
309: l_stop_details := WSH_OTM_STOP_DET_TAB();
310: l_all_dlv_tab := WSH_OTM_DLV_TAB();
311: -- Bug 6497991: Populating error trips