APPS.WSH_TRIP_VALIDATIONS dependencies on WSH_TRIPS

Line 205: status_code WSH_TRIPS.STATUS_CODE%TYPE,

201:
202:
203: --Harmonizing Project
204: TYPE TripActionsRec IS RECORD(
205: status_code WSH_TRIPS.STATUS_CODE%TYPE,
206: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
207: load_tender_status WSH_TRIPS.LOAD_TENDER_STATUS%TYPE,
208: message_name VARCHAR2(2000),
209: caller VARCHAR2(100),

Line 206: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,

202:
203: --Harmonizing Project
204: TYPE TripActionsRec IS RECORD(
205: status_code WSH_TRIPS.STATUS_CODE%TYPE,
206: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
207: load_tender_status WSH_TRIPS.LOAD_TENDER_STATUS%TYPE,
208: message_name VARCHAR2(2000),
209: caller VARCHAR2(100),
210: action_not_allowed VARCHAR2(100),

Line 207: load_tender_status WSH_TRIPS.LOAD_TENDER_STATUS%TYPE,

203: --Harmonizing Project
204: TYPE TripActionsRec IS RECORD(
205: status_code WSH_TRIPS.STATUS_CODE%TYPE,
206: planned_flag WSH_TRIPS.PLANNED_FLAG%TYPE,
207: load_tender_status WSH_TRIPS.LOAD_TENDER_STATUS%TYPE,
208: message_name VARCHAR2(2000),
209: caller VARCHAR2(100),
210: action_not_allowed VARCHAR2(100),
211: shipments_type_flag VARCHAR2(30),

Line 212: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE); -- OTM R12, glog proj

208: message_name VARCHAR2(2000),
209: caller VARCHAR2(100),
210: action_not_allowed VARCHAR2(100),
211: shipments_type_flag VARCHAR2(30),
212: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE); -- OTM R12, glog proj
213:
214: TYPE TripActionsTabType IS TABLE of TripActionsRec INDEX BY BINARY_INTEGER;
215:
216: TYPE trip_rec_type IS RECORD(

Line 224: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE); -- OTM R12, glog proj

220: planned_flag VARCHAR2(32000),
221: load_tender_status VARCHAR2(32000),
222: lane_id NUMBER,
223: shipments_type_flag VARCHAR2(30),
224: ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE); -- OTM R12, glog proj
225:
226: TYPE trip_rec_tab_type IS TABLE OF trip_rec_type INDEX BY BINARY_INTEGER;
227:
228: PROCEDURE Is_Action_Enabled(

Line 246: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

242: x_return_status OUT NOCOPY VARCHAR2
243: );
244:
245: PROCEDURE Validate_Consol_Allowed(
246: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
247: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
248: x_return_status OUT NOCOPY VARCHAR2);
249:
250: --

Line 247: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,

243: );
244:
245: PROCEDURE Validate_Consol_Allowed(
246: p_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
247: p_db_trip_info IN WSH_TRIPS_PVT.trip_rec_type,
248: x_return_status OUT NOCOPY VARCHAR2);
249:
250: --
251: -- Overloaded procedure

Line 254: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type

250: --
251: -- Overloaded procedure
252: --
253: PROCEDURE Get_Disabled_List (
254: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
255: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
256: , x_return_status OUT NOCOPY VARCHAR2
257: , x_msg_count OUT NOCOPY NUMBER
258: , x_msg_data OUT NOCOPY VARCHAR2

Line 255: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType

251: -- Overloaded procedure
252: --
253: PROCEDURE Get_Disabled_List (
254: p_trip_rec IN WSH_TRIPS_PVT.trip_rec_type
255: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
256: , x_return_status OUT NOCOPY VARCHAR2
257: , x_msg_count OUT NOCOPY NUMBER
258: , x_msg_data OUT NOCOPY VARCHAR2
259: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

Line 259: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type

255: , p_in_rec IN WSH_TRIPS_GRP.TripInRecType
256: , x_return_status OUT NOCOPY VARCHAR2
257: , x_msg_count OUT NOCOPY NUMBER
258: , x_msg_data OUT NOCOPY VARCHAR2
259: , x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.trip_rec_type
260: );
261:
262:
263: PROCEDURE Init_Trip_Actions_Tbl (