APPS.WSH_WF_INTERFACE dependencies on WSH_TRIP_STOPS

Line 147: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

143:
144: --l_init_msg_list VARCHAR2 := FND_API.G_FALSE; -- fnd_api.g_true or fnd_api.g_false
145: --l_commit VARCHAR2 := FND_API.G_TRUE ; -- fnd_api.g_true or fnd_api.g_false
146:
147: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
148:
149: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
150: l_stop_info WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
151:

Line 149: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

145: --l_commit VARCHAR2 := FND_API.G_TRUE ; -- fnd_api.g_true or fnd_api.g_false
146:
147: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
148:
149: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
150: l_stop_info WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
151:
152: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
153: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;

Line 150: l_stop_info WSH_TRIP_STOPS_PVT.trip_stop_rec_type;

146:
147: l_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
148:
149: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
150: l_stop_info WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
151:
152: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
153: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;
154:

Line 152: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;

148:
149: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
150: l_stop_info WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
151:
152: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
153: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;
154:
155: l_return_status VARCHAR2(1);
156: l_msg_count NUMBER;

Line 153: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;

149: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
150: l_stop_info WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
151:
152: l_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
153: l_def_rec WSH_TRIP_STOPS_GRP.default_parameters_rectype;
154:
155: l_return_status VARCHAR2(1);
156: l_msg_count NUMBER;
157: l_msg_data VARCHAR2(32767);

Line 161: FROM wsh_trip_stops wts,

157: l_msg_data VARCHAR2(32767);
158:
159: CURSOR get_pickup_stop_id IS
160: SELECT wts.stop_id
161: FROM wsh_trip_stops wts,
162: wsh_delivery_legs wdl,
163: wsh_new_deliveries wnd
164: WHERE wnd.delivery_id = to_number(itemkey)
165: AND wdl.delivery_id = wnd.delivery_id

Line 201: WSH_TRIP_STOPS_PVT.Populate_Record (l_pickup_stop_id,l_stop_info,l_return_status);

197: OPEN get_pickup_stop_id;
198: FETCH get_pickup_stop_id into l_pickup_stop_id;
199: CLOSE get_pickup_stop_id ;
200:
201: WSH_TRIP_STOPS_PVT.Populate_Record (l_pickup_stop_id,l_stop_info,l_return_status);
202: l_rec_attr_tab(l_rec_attr_tab.COUNT + 1) := l_stop_info;
203:
204: l_action_prms.caller := 'PLSQL';
205: l_action_prms.phase := NULL;

Line 219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.STOP_ACTION ',

215: SET del_wf_intransit_attr = 'P'
216: WHERE delivery_id = l_delivery_id;
217:
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.STOP_ACTION ',
220: WSH_DEBUG_SV.C_PROC_LEVEL);
221: END IF;
222:
223: WSH_TRIP_STOPS_GRP.Stop_Action (

Line 223: WSH_TRIP_STOPS_GRP.Stop_Action (

219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.STOP_ACTION ',
220: WSH_DEBUG_SV.C_PROC_LEVEL);
221: END IF;
222:
223: WSH_TRIP_STOPS_GRP.Stop_Action (
224: p_api_version_number => 1.0,
225: p_init_msg_list => FND_API.G_FALSE,
226: p_commit => FND_API.G_FALSE,
227: p_action_prms => l_action_prms,