DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_TRIP_STOPS

Line 1: PACKAGE WSH_TRIP_STOPS_GRP as

1: PACKAGE WSH_TRIP_STOPS_GRP as
2: /* $Header: WSHSTGPS.pls 120.1.12000000.1 2007/01/16 05:50:43 appldev ship $ */
3:
4: c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5: c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;

Line 132: status_code wsh_trip_stops.status_code%TYPE

128: ,override_flag VARCHAR2(500)
129: );
130:
131: TYPE default_parameters_rectype IS RECORD (
132: status_code wsh_trip_stops.status_code%TYPE
133: ,date_field VARCHAR2(500)
134: ,defer_interface_flag VARCHAR2(500)
135: ,status_name VARCHAR2(500)
136: ,stop_action VARCHAR2(500)

Line 164: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information

160: -- p_stop_IN_rec Input Attributes for the stop entity
161: -- p_stop_OUT_rec Output Attributes for the stop entity
162: -- VERSION : current version 1.0
163: -- initial version 1.0
164: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information
165: -- specified in p_stop_info. Use p_trip_id, p_trip_name, p_stop_location_id,
166: -- p_stop_location_code or p_planned_dep_date to update these values
167: -- on an existing stop.These are part of p_stop_info.
168: --========================================================================

Line 176: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

172: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
177: p_stop_IN_rec IN stopInRecType,
178: x_stop_OUT_rec OUT NOCOPY stopOutRecType);
179:
180: --========================================================================

Line 211: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

207: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
212: p_stop_IN_rec IN stopActionInRecType,
213: x_stop_OUT_rec OUT NOCOPY stopActionOutRecType);
214:
215: --===================

Line 236: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information

232: -- p_planned_dep_date Planned departure date for update
233: -- x_stop_id - stop id of new stop
234: -- VERSION : current version 1.0
235: -- initial version 1.0
236: -- COMMENT : Creates or updates a record in wsh_trip_stops table with information
237: -- specified in p_stop_info. Use p_trip_id, p_trip_name, p_stop_location_id,
238: -- p_stop_location_code or p_planned_dep_date to update these values
239: -- on an existing stop.
240: --========================================================================

Line 248: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,

244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_action_code IN VARCHAR2,
248: p_stop_info IN OUT NOCOPY WSH_TRIP_STOPS_GRP.Trip_Stop_Pub_Rec_Type,
249: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
250: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
251: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
252: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 307: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

303: ( p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2,
305: p_commit IN VARCHAR2,
306: p_action_prms IN action_parameters_rectype,
307: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
308: x_stop_out_rec OUT NOCOPY stopActionOutRecType,
309: x_def_rec OUT NOCOPY default_parameters_rectype,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,

Line 324: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,

320: p_api_version_number IN NUMBER,
321: p_init_msg_list IN VARCHAR2,
322: p_commit IN VARCHAR2,
323: p_in_rec IN stopInRecType,
324: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
325: x_stop_out_tab OUT NOCOPY stop_out_tab_type,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2,

Line 337: x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,

333:
334: -- API to get Stop Details
335: PROCEDURE get_stop_details_pvt
336: (p_stop_id IN NUMBER,
337: x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,
338: x_return_status OUT NOCOPY VARCHAR2);
339:
340:
341: END WSH_TRIP_STOPS_GRP;

Line 341: END WSH_TRIP_STOPS_GRP;

337: x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE,
338: x_return_status OUT NOCOPY VARCHAR2);
339:
340:
341: END WSH_TRIP_STOPS_GRP;