[Home] [Help]
PACKAGE: APPS.FTE_TRIPS_PVT
Source
1 PACKAGE FTE_TRIPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: FTETRTHS.pls 115.8 2002/12/17 02:17:16 nltan noship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 --
8 -- Type: Trip_Rectype
9 -- Definition: In sync with the table definition for trips
10 -- Use: In table handlers, calling packages
11
12
13 TYPE fte_trip_rec_type IS RECORD (
14 FTE_TRIP_ID NUMBER,
15 NAME VARCHAR2(30),
16 STATUS_CODE VARCHAR2(30),
17 PRIVATE_TRIP VARCHAR2(1),
18 VALIDATION_REQUIRED VARCHAR2(1),
19 CREATION_DATE DATE,
20 CREATED_BY NUMBER,
21 LAST_UPDATE_DATE DATE,
22 LAST_UPDATED_BY NUMBER,
23 LAST_UPDATE_LOGIN NUMBER,
24 PROGRAM_APPLICATION_ID NUMBER,
25 PROGRAM_ID NUMBER,
26 PROGRAM_UPDATE_DATE DATE,
27 REQUEST_ID NUMBER,
28 ATTRIBUTE_CATEGORY VARCHAR2(150),
29 ATTRIBUTE1 VARCHAR2(150),
30 ATTRIBUTE2 VARCHAR2(150),
31 ATTRIBUTE3 VARCHAR2(150),
32 ATTRIBUTE4 VARCHAR2(150),
33 ATTRIBUTE5 VARCHAR2(150),
34 ATTRIBUTE6 VARCHAR2(150),
35 ATTRIBUTE7 VARCHAR2(150),
36 ATTRIBUTE8 VARCHAR2(150),
37 ATTRIBUTE9 VARCHAR2(150),
38 ATTRIBUTE10 VARCHAR2(150),
39 ATTRIBUTE11 VARCHAR2(150),
40 ATTRIBUTE12 VARCHAR2(150),
41 ATTRIBUTE13 VARCHAR2(150),
42 ATTRIBUTE14 VARCHAR2(150),
43 ATTRIBUTE15 VARCHAR2(150),
44 ROUTE_ID NUMBER
45 );
46
47
48 PROCEDURE get_trip_name
49 (
50 p_trip_id IN NUMBER,
51 x_trip_name OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 -- Wrapper around create_trip and update_trip
56 -- (create pl/sql record and depending on p_action_code is 'CREATE' or 'UPDATE' or 'DELETE'
57
58 PROCEDURE Create_Update_Delete_Fte_Trip
59 (
60 p_api_version_number IN NUMBER,
61 p_init_msg_list IN VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
65 pp_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66 pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
67 pp_PRIVATE_TRIP IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
68 pp_VALIDATION_REQUIRED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
69 pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
70 pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
71 pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
72 pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
73 pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
74 pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
75 pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
76 pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
77 pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
78 pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79 pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80 pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
81 pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
82 pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
83 pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84 pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
85 pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86 pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
87 pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
88 pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89 pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
90 pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91 pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
92 pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
93 pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94 pp_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
95 p_action_code IN VARCHAR2,
96 x_trip_id OUT NOCOPY NUMBER,
97 x_name OUT NOCOPY VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2
99 );
100
101
102 --========================================================================
103 -- PROCEDURE : Create_Trip
104 --
105 -- PARAMETERS: p_trip_info Attributes for the trip entity
106 -- x_return_status Return status of API
107 -- COMMENT : Creates trip record with p_trip_info information
108 --========================================================================
109
110 PROCEDURE Create_Trip
111 (p_trip_info IN fte_trip_rec_type,
112 x_trip_id OUT NOCOPY NUMBER,
113 x_name OUT NOCOPY VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2
115 );
116
117
118 PROCEDURE Validate_CreateTrip
119 (p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
120 p_trip_name IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2
122 );
123
124 --========================================================================
125 -- PROCEDURE : Update_Trip
126 --
127 -- PARAMETERS: p_trip_info Attributes for the trip entity
128 -- x_return_status Return status of API
129 -- COMMENT : Updates trip record with p_trip_info information
130 --========================================================================
131
132 PROCEDURE Update_Trip(
133 p_trip_info IN fte_trip_rec_type,
134 x_return_status OUT NOCOPY VARCHAR2);
135
136
137 PROCEDURE Validate_UpdateTrip(
138 p_trip_id IN NUMBER,
139 p_trip_name IN VARCHAR2,
140 p_trip_status IN VARCHAR2,
141 x_return_status OUT NOCOPY VARCHAR2);
142
143
144 PROCEDURE Delete_Trip(
145 p_trip_id IN NUMBER,
146 x_return_status OUT NOCOPY VARCHAR2
147 );
148
149
150 PROCEDURE Validate_DeleteTrip(
151 p_trip_id IN NUMBER,
152 x_return_status OUT NOCOPY VARCHAR2
153 );
154
155
156 -- Trip Segment validation for a Trip
157 PROCEDURE Validate_Trip(
158 p_trip_id IN NUMBER,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 -- pass in del ids as a comma seperated list which will
165 -- be assigned to fte_trip
166 -- comma seperated list will be of form d100, d101, .. (have to remove
167 -- "d" before update)
168
169 PROCEDURE assign_deliveries_to_ftetrip
170 (
171 p_del_ids IN VARCHAR2,
172 p_fte_trip_id IN NUMBER,
173 p_wsh_trip_id IN NUMBER,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2
177 );
178
179 -- Added in Pack I (hbhagava) --
180
181
182 FUNCTION GET_TRIP_BY_TENDER_NUMBER(p_tender_number NUMBER) RETURN NUMBER;
183
184
185 ---
186 PROCEDURE GET_LAST_STOP_LOCATION_INFO
187 (
188 P_trip_segment_id IN NUMBER,
189 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
190 x_last_stop_location_id OUT NOCOPY NUMBER,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_planned_arvl_dt OUT NOCOPY DATE,
193 x_planned_dept_dt OUT NOCOPY DATE
194 );
195
196 ---
197 ---
198 PROCEDURE GET_FIRST_STOP_LOCATION_INFO
199 (
200 P_trip_segment_id IN NUMBER,
201 x_trip_segment_name IN OUT NOCOPY VARCHAR2,
202 x_first_stop_location_id OUT NOCOPY NUMBER,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_planned_arvl_dt OUT NOCOPY DATE,
205 x_planned_dept_dt OUT NOCOPY DATE
206 );
207
208 ---
209 --
210 --
211 PROCEDURE GET_TRIP_SEGMENT_NAME
212 (
213 p_trip_segment_id IN NUMBER,
214 x_trip_segment_name OUT NOCOPY VARCHAR2,
215 x_return_status OUT NOCOPY VARCHAR2
216 );
217 --
218 --
219
220 PROCEDURE GET_SHIPMENT_INFORMATION
221 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
222 p_tender_number IN NUMBER,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 x_shipment_info OUT NOCOPY VARCHAR2,
227 x_shipping_org_name OUT NOCOPY VARCHAR2);
228
229 PROCEDURE GET_TRIP_INFO_FROM_DLVY
230 (p_tender_number IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 x_total_weight OUT NOCOPY NUMBER,
236 x_weight_uom OUT NOCOPY VARCHAR2,
237 x_total_volume OUT NOCOPY NUMBER,
238 x_volume_uom OUT NOCOPY VARCHAR2);
239
240
241 END fte_trips_pvt;