eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_UTIL_CORE

Line 96: p_trip_rows IN wsh_util_core.id_tab_type,

92: -- - 'PLAN'
93: -- - 'UNPLAN'
94:
95: PROCEDURE Plan(
96: p_trip_rows IN wsh_util_core.id_tab_type,
97: p_action IN VARCHAR2,
98: x_return_status OUT NOCOPY VARCHAR2);
99:
100:

Line 128: p_del_rows IN wsh_util_core.id_tab_type,

124: -- x_trip_ids - the autocreated trip ids
125: -- x_trip_names - the autocreated trip names
126:
127: PROCEDURE autocreate_trip_multi(
128: p_del_rows IN wsh_util_core.id_tab_type,
129: p_entity IN VARCHAR2 DEFAULT 'D',
130: x_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
131: x_trip_names OUT NOCOPY wsh_util_core.Column_Tab_Type,
132: x_return_status OUT NOCOPY VARCHAR2);

Line 130: x_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,

126:
127: PROCEDURE autocreate_trip_multi(
128: p_del_rows IN wsh_util_core.id_tab_type,
129: p_entity IN VARCHAR2 DEFAULT 'D',
130: x_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
131: x_trip_names OUT NOCOPY wsh_util_core.Column_Tab_Type,
132: x_return_status OUT NOCOPY VARCHAR2);
133:
134: --

Line 131: x_trip_names OUT NOCOPY wsh_util_core.Column_Tab_Type,

127: PROCEDURE autocreate_trip_multi(
128: p_del_rows IN wsh_util_core.id_tab_type,
129: p_entity IN VARCHAR2 DEFAULT 'D',
130: x_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
131: x_trip_names OUT NOCOPY wsh_util_core.Column_Tab_Type,
132: x_return_status OUT NOCOPY VARCHAR2);
133:
134: --
135: -- Procedure: Autocreate_Trip

Line 148: p_del_rows IN wsh_util_core.id_tab_type,

144: -- x_trip_name - the autocreated trip name
145: -- NOTE: Trip Stop/Delivery Leg sequences are not generated automatically
146:
147: PROCEDURE autocreate_trip(
148: p_del_rows IN wsh_util_core.id_tab_type,
149: p_entity IN VARCHAR2 DEFAULT 'D',
150: x_trip_id OUT NOCOPY NUMBER,
151: x_trip_name OUT NOCOPY VARCHAR2,
152: x_return_status OUT NOCOPY VARCHAR2,

Line 175: p_line_rows IN wsh_util_core.id_tab_type,

171: -- NOTE: Trip Stop/Delivery Leg sequences are not generated automatically
172:
173: --Compatibility Changes - removed trip_id, trip_name and added x_trip_rows
174: PROCEDURE autocreate_del_trip(
175: p_line_rows IN wsh_util_core.id_tab_type,
176: p_org_rows IN wsh_util_core.id_tab_type,
177: p_max_detail_commit IN NUMBER := 1000,
178: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
179: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,

Line 176: p_org_rows IN wsh_util_core.id_tab_type,

172:
173: --Compatibility Changes - removed trip_id, trip_name and added x_trip_rows
174: PROCEDURE autocreate_del_trip(
175: p_line_rows IN wsh_util_core.id_tab_type,
176: p_org_rows IN wsh_util_core.id_tab_type,
177: p_max_detail_commit IN NUMBER := 1000,
178: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
179: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,
180: x_return_status OUT NOCOPY VARCHAR2);

Line 178: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,

174: PROCEDURE autocreate_del_trip(
175: p_line_rows IN wsh_util_core.id_tab_type,
176: p_org_rows IN wsh_util_core.id_tab_type,
177: p_max_detail_commit IN NUMBER := 1000,
178: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
179: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,
180: x_return_status OUT NOCOPY VARCHAR2);
181:
182: --

Line 179: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,

175: p_line_rows IN wsh_util_core.id_tab_type,
176: p_org_rows IN wsh_util_core.id_tab_type,
177: p_max_detail_commit IN NUMBER := 1000,
178: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
179: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,
180: x_return_status OUT NOCOPY VARCHAR2);
181:
182: --
183: -- Procedure: Assign_Trip (for delivery details)

Line 193: p_line_rows IN wsh_util_core.id_tab_type,

189: -- x_del_rows - table of autocreated deliveries
190: -- NOTE: Trip Stop/Delivery Leg sequences are not generated automatically
191:
192: PROCEDURE assign_trip(
193: p_line_rows IN wsh_util_core.id_tab_type,
194: p_trip_id IN NUMBER,
195: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
196: x_return_status OUT NOCOPY VARCHAR2);
197:

Line 195: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,

191:
192: PROCEDURE assign_trip(
193: p_line_rows IN wsh_util_core.id_tab_type,
194: p_trip_id IN NUMBER,
195: x_del_rows OUT NOCOPY wsh_util_core.id_tab_type,
196: x_return_status OUT NOCOPY VARCHAR2);
197:
198: --
199: -- Procedure: Assign_Trip (for deliveries)

Line 213: p_del_rows IN wsh_util_core.id_tab_type,

209: /* H integration - for sequence number added parameters */
210:
211:
212: PROCEDURE assign_trip(
213: p_del_rows IN wsh_util_core.id_tab_type,
214: p_trip_id IN NUMBER,
215: p_pickup_stop_id IN NUMBER := NULL,
216: p_pickup_stop_seq IN NUMBER := NULL,
217: p_dropoff_stop_id IN NUMBER := NULL,

Line 249: p_trip_rows IN wsh_util_core.id_tab_type,

245: -- 2) any trip stop does not have uom info
246: -- 3) delivery wt/vol calculation fails
247:
248: PROCEDURE Trip_weight_volume(
249: p_trip_rows IN wsh_util_core.id_tab_type,
250: p_override_flag IN VARCHAR2,
251: p_calc_wv_if_frozen IN VARCHAR2 DEFAULT 'Y',
252: p_start_departure_date IN DATE,
253: p_calc_del_wv IN VARCHAR2 DEFAULT 'Y',

Line 279: p_del_rows IN wsh_util_core.id_tab_type,

275: -- returns a trip_id
276: -- x_return_status - this returns an error if the sequence is invalid
277:
278: PROCEDURE Check_Unassign_Trip(
279: p_del_rows IN wsh_util_core.id_tab_type,
280: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,
281: x_return_status OUT NOCOPY VARCHAR2);
282:
283:

Line 280: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,

276: -- x_return_status - this returns an error if the sequence is invalid
277:
278: PROCEDURE Check_Unassign_Trip(
279: p_del_rows IN wsh_util_core.id_tab_type,
280: x_trip_rows OUT NOCOPY wsh_util_core.id_tab_type,
281: x_return_status OUT NOCOPY VARCHAR2);
282:
283:
284: --

Line 291: p_del_rows IN wsh_util_core.id_tab_type,

287: -- Description: Unassigns deliveries from a trip by calling the
288: -- wsh_delivery_legs_actions.unassign_deliveries procedure
289:
290: PROCEDURE Unassign_Trip(
291: p_del_rows IN wsh_util_core.id_tab_type,
292: p_trip_id IN NUMBER,
293: x_return_status OUT NOCOPY VARCHAR2);
294:
295:

Line 377: ( p_trip_ids IN wsh_util_core.id_tab_type,

373: p_caller IN VARCHAR2,
374: x_return_status OUT NOCOPY VARCHAR2);
375:
376: PROCEDURE reset_stop_planned_dates
377: ( p_trip_ids IN wsh_util_core.id_tab_type,
378: p_caller IN VARCHAR2,
379: x_success_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
380: x_return_status OUT NOCOPY VARCHAR2);
381:

Line 379: x_success_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,

375:
376: PROCEDURE reset_stop_planned_dates
377: ( p_trip_ids IN wsh_util_core.id_tab_type,
378: p_caller IN VARCHAR2,
379: x_success_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
380: x_return_status OUT NOCOPY VARCHAR2);
381:
382:
383: PROCEDURE Handle_Internal_Stops

Line 384: ( p_trip_ids IN wsh_util_core.id_tab_type,

380: x_return_status OUT NOCOPY VARCHAR2);
381:
382:
383: PROCEDURE Handle_Internal_Stops
384: ( p_trip_ids IN wsh_util_core.id_tab_type,
385: p_caller IN VARCHAR2,
386: x_success_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
387: x_return_status OUT NOCOPY VARCHAR2);
388:

Line 386: x_success_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,

382:
383: PROCEDURE Handle_Internal_Stops
384: ( p_trip_ids IN wsh_util_core.id_tab_type,
385: p_caller IN VARCHAR2,
386: x_success_trip_ids OUT NOCOPY wsh_util_core.id_tab_type,
387: x_return_status OUT NOCOPY VARCHAR2);
388:
389: PROCEDURE PROCESS_CARRIER_SELECTION (
390: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 391: p_trip_id_tab IN wsh_util_core.id_tab_type,

387: x_return_status OUT NOCOPY VARCHAR2);
388:
389: PROCEDURE PROCESS_CARRIER_SELECTION (
390: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
391: p_trip_id_tab IN wsh_util_core.id_tab_type,
392: p_caller IN VARCHAR2 DEFAULT NULL, -- WSH_FSTRX / WSH_PUB / WSH_GROUP/ FTE
393: x_msg_count OUT NOCOPY NUMBER,
394: x_msg_data OUT NOCOPY VARCHAR2,
395: x_return_status OUT NOCOPY VARCHAR2);

Line 402: p_trip_id_tab IN wsh_util_core.id_tab_type,

398: --Set to trip_id for which WSH_FTE_INTEGRATION.Rate_Trip api has been called.
399: g_rate_trip_id NUMBER;
400:
401: PROCEDURE Remove_Consolidation(
402: p_trip_id_tab IN wsh_util_core.id_tab_type,
403: p_unassign_all IN VARCHAR2,
404: p_caller IN VARCHAR2,
405: x_return_status OUT NOCOPY VARCHAR2);
406: