APPS.WSH_TP_RELEASE_INT dependencies on WSH_TRIP_STOPS_PVT

Line 292: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type

288:
289: PROCEDURE copy_stop_record(
290: p_plan_stop_rec IN plan_stop_rec_type,
291: p_plan_trips IN plan_trip_tab_type,
292: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type
293: );
294:
295: PROCEDURE create_update_plan_trips(
296: p_phase IN NUMBER,

Line 3674: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

3670: x_plan_stops(l_stop_index).wv_frozen_flag := l_map_stop_rec.wv_frozen_flag; -- WV changes
3671:
3672: -- lock stop
3673: BEGIN
3674: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
3675: p_stop_id => x_plan_stops(l_stop_index).stop_id);
3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: stamp_interface_error(

Line 4124: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

4120: x_plan_stops(l_stop_index).stop_id := l_map_stop_rec.stop_id;
4121:
4122: -- lock stop
4123: BEGIN
4124: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
4125: p_stop_id => x_plan_stops(l_stop_index).stop_id);
4126: EXCEPTION
4127: WHEN OTHERS THEN
4128: stamp_interface_error(

Line 4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;

4709: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4710: l_del_in_rec WSH_DELIVERIES_GRP.DEL_IN_REC_TYPE;
4711: l_del_out_tab WSH_DELIVERIES_GRP.DEL_OUT_TBL_TYPE;
4712:
4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

Line 6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;

6727: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
6728: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
6729: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
6730:
6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
6735:

Line 7193: WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare(trip.stop_id);

7189: FOR trip in c_trip_stops(x_trip_unassigns(i).trip_id) LOOP
7190:
7191: BEGIN
7192: -- Lock the stop
7193: WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare(trip.stop_id);
7194: examine_stop(p_stop_id => trip.stop_id,
7195: p_trip_id => x_trip_unassigns(i).trip_id);
7196: EXCEPTION
7197: WHEN OTHERS THEN

Line 9020: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

9016: WSH_DEBUG_SV.log(l_module_name,'matching linked stop', s.stop_id);
9017: END IF;
9018:
9019: BEGIN
9020: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
9021: p_stop_id => s.stop_id);
9022: EXCEPTION
9023: WHEN OTHERS THEN
9024: stamp_interface_error(

Line 9067: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

9063: END IF;
9064:
9065: -- Lock the stop.
9066: BEGIN
9067: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
9068: p_stop_id => s.stop_id);
9069: EXCEPTION
9070: WHEN OTHERS THEN
9071: stamp_interface_error(

Line 10016: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type

10012:
10013: PROCEDURE copy_stop_record(
10014: p_plan_stop_rec IN plan_stop_rec_type,
10015: p_plan_trips IN plan_trip_tab_type,
10016: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type
10017: ) IS
10018: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'COPY_STOP_RECORD';
10019: --
10020: l_debug_on BOOLEAN;