DBA Data[Home] [Help]

APPS.WSH_TRIPS_GRP dependencies on WSH_TRIPS

Line 1: PACKAGE WSH_TRIPS_GRP AUTHID CURRENT_USER as

1: PACKAGE WSH_TRIPS_GRP AUTHID CURRENT_USER as
2: /* $Header: WSHTRGPS.pls 120.0.12000000.1 2007/01/16 05:51:38 appldev ship $ */
3:
4: --===================
5: -- PUBLIC VARS

Line 112: ,trip_name wsh_trips.name%TYPE

108: ,action_code VARCHAR2(500)
109: ,organization_id NUMBER
110: ,report_set_id NUMBER
111: ,override_flag VARCHAR2(500)
112: ,trip_name wsh_trips.name%TYPE
113: ,actual_date DATE
114: ,stop_id NUMBER --] These parameters
115: ,action_flag VARCHAR2(1) --] are used for
116: ,autointransit_flag VARCHAR2(1) --] action_code = 'CONFIRM'

Line 143: -- COMMENT : Creates or updates a record in wsh_trips table with information

139: -- p_trip_IN_rec Input Attributes for the trip entity
140: -- p_trip_OUT_rec Output Attributes for the trip entity
141: -- VERSION : current version 1.0
142: -- initial version 1.0
143: -- COMMENT : Creates or updates a record in wsh_trips table with information
144: -- specified in p_trip_info
145: --========================================================================
146: PROCEDURE Create_Update_Trip_New
147: ( p_api_version_number IN NUMBER,

Line 207: -- COMMENT : Creates or updates a record in wsh_trips table with information

203: -- x_trip_id Trip id of new trip
204: -- x_trip_name Trip name of new trip
205: -- VERSION : current version 1.0
206: -- initial version 1.0
207: -- COMMENT : Creates or updates a record in wsh_trips table with information
208: -- specified in p_trip_info
209: --========================================================================
210: PROCEDURE Create_Update_Trip
211: ( p_api_version_number IN NUMBER,

Line 264: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

260: ( p_api_version_number IN NUMBER,
261: p_init_msg_list IN VARCHAR2,
262: p_commit IN VARCHAR2,
263: p_action_prms IN action_parameters_rectype,
264: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
265: x_trip_out_rec OUT NOCOPY tripActionOutRecType,
266: x_def_rec OUT NOCOPY default_parameters_rectype,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,

Line 280: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

276: PROCEDURE Create_Update_Trip(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2,
279: p_commit IN VARCHAR2,
280: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
281: p_In_rec IN tripInRecType,
282: x_Out_Tab OUT NOCOPY trip_Out_Tab_Type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,

Line 292: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,

288:
289: -- API to get trip details
290: PROCEDURE get_trip_details_pvt
291: (p_trip_id IN NUMBER,
292: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
293: x_return_status OUT NOCOPY VARCHAR2);
294:
295: END WSH_TRIPS_GRP;

Line 295: END WSH_TRIPS_GRP;

291: (p_trip_id IN NUMBER,
292: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
293: x_return_status OUT NOCOPY VARCHAR2);
294:
295: END WSH_TRIPS_GRP;