[Home] [Help]
PACKAGE: APPS.FTE_TENDER_PVT
Source
1 PACKAGE FTE_TENDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: FTETEPVS.pls 120.1.12000000.1 2007/01/18 21:26:08 appldev ship $ */
3
4
5 S_TENDERED CONSTANT VARCHAR2(30) := 'TENDERED';
6 S_ACCEPTED CONSTANT VARCHAR2(30) := 'ACCEPTED';
7 S_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED';
8 S_SHIPPER_CANCELLED CONSTANT VARCHAR2(30) := 'SHIPPER_CANCELLED';
9 S_AUTO_ACCEPTED CONSTANT VARCHAR2(30) := 'AUTO_ACCEPTED';
10 S_NORESPONSE CONSTANT VARCHAR2(30) := 'NORESPONSE';
11 S_RETENDERED CONSTANT VARCHAR2(30) := 'RETENDERED';
12 S_SHIPPER_UPDATED CONSTANT VARCHAR2(30) := 'SHIPPER_UPDATED';
13
14 S_SOURCE_XML CONSTANT VARCHAR2(10) := 'XML';
15 S_SOURCE_CP CONSTANT VARCHAR2(10) := 'CP';
16 S_SOURCE_WL CONSTANT VARCHAR2(10) := 'WL';
17
18
19 PROCEDURE RAISE_TENDER_EVENT(
20 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_tender_id IN NUMBER,
25 p_item_key IN VARCHAR2,
26 p_shipper_wait_time IN NUMBER,
27 p_shipper_name IN VARCHAR2,
28 p_carrier_name IN VARCHAR2,
29 p_contact_perf IN VARCHAR2,
30 p_contact_name IN VARCHAR2,
31 p_autoaccept IN VARCHAR2,
32 p_action IN VARCHAR2,
33 p_url IN VARCHAR2);
34
35
36 FUNCTION CAN_PERFORM_THIS_ACTION (
37 p_trip_seg_status VARCHAR2,
38 p_tender_action VARCHAR2)
39 RETURN BOOLEAN;
40
41 FUNCTION CAN_PERFORM_THIS_ACTION_STR (
42 p_trip_seg_status VARCHAR2,
43 p_tender_action VARCHAR2)
44 RETURN VARCHAR2;
45
46 PROCEDURE VALIDATE_TENDER_REQUEST(
47 p_api_version_number IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_trip_id IN NUMBER,
53 p_action_code IN VARCHAR2,
54 p_tender_action IN VARCHAR2,
55 p_trip_name IN VARCHAR2 DEFAULT NULL);
56
57
58 FUNCTION IS_AUTO_ACCEPT_ENABLED (p_carrier_id VARCHAR2) RETURN BOOLEAN;
59
60
61 FUNCTION GET_ITEM_KEY(p_trip_seg_id NUMBER) RETURN VARCHAR2;
62
63 PROCEDURE DELETE_TENDER_SNAPSHOT(
64 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_tender_id IN NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69
70 PROCEDURE TAKE_TENDER_SNAPSHOT(
71 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72 p_tender_id IN NUMBER,
73 p_trip_id IN NUMBER,
74 p_stop_id IN NUMBER,
75 p_total_weight IN NUMBER,
76 p_total_volume IN NUMBER,
77 p_weight_uom IN VARCHAR2,
78 p_volume_uom IN VARCHAR2,
79 p_session_value IN VARCHAR2,
80 p_action IN VARCHAR2,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84
85
86 PROCEDURE CHECK_THRESHOLD_FOR_STOP(
87 P_api_version IN NUMBER,
88 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 X_return_status OUT NOCOPY VARCHAR2,
90 X_msg_count OUT NOCOPY NUMBER,
91 X_msg_data OUT NOCOPY VARCHAR2,
92 P_trip_segment_rec IN WSH_TRIPS_PVT.Trip_Rec_Type,
93 P_new_segment_stop_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type);
94
95 PROCEDURE RAISE_TENDER_ACCEPT(
96 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_item_key IN VARCHAR2,
101 p_tender_id IN NUMBER,
102 p_shipper_name IN VARCHAR2,
103 p_carrier_name IN VARCHAR2,
104 p_contact_name IN VARCHAR2,
105 p_contact_perf IN VARCHAR2);
106
107 PROCEDURE RAISE_TENDER_REJECT(
108 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_item_key IN VARCHAR2,
113 p_tender_id IN NUMBER,
114 p_shipper_name IN VARCHAR2,
115 p_carrier_name IN VARCHAR2,
116 p_contact_name IN VARCHAR2,
117 p_contact_perf IN VARCHAR2);
118
119 PROCEDURE RAISE_TENDER_UPDATE(
120 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_item_key IN VARCHAR2,
125 p_tender_id IN NUMBER,
126 p_contact_perf IN VARCHAR2);
127
128
129 --Added for Rel 12 Shravisa
130 PROCEDURE CHECK_CARRIER_ARRIVAL_TIME(
131 p_tender_id IN NUMBER,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 ) ;
136 --Added for Rel 12 Shravisa
137 PROCEDURE LOG_CARRIER_ARR_EXC(
138 p_tender_id IN NUMBER,
139 p_planned_arrival_date IN DATE,
140 p_carrier_est_arrival_date IN DATE,
141 p_first_stop_location_id IN NUMBER,
142 P_planned_departure_date in date,
143 P_carrier_est_departure_date in date,
144 P_last_stop_location_id in Number,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 PROCEDURE COMPLETE_CANCEL_TENDER (
151 p_tender_id IN NUMBER,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2) ;
155
156 --End of Rel 12 Shravisa
157
158 ---For Rel 12 HBHAGAVA
159 PROCEDURE RAISE_TENDER_EVENT(
160 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_trip_info IN FTE_TENDER_ATTR_REC,
165 p_mbol_number IN VARCHAR2);
166
167
168 PROCEDURE UPDATE_CARRIER_RESPONSE(
169 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
170 p_carrier_response_rec IN FTE_TENDER_ATTR_REC,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2);
174
175
176
177 PROCEDURE HANDLE_TENDER_RESPONSE(
178 p_init_msg_list IN VARCHAR2,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_trip_info IN FTE_TENDER_ATTR_REC);
183
184 PROCEDURE HANDLE_CANCEL_TENDER(
185 p_init_msg_list IN VARCHAR2,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_trip_info IN FTE_TENDER_ATTR_REC);
190
191
192
193 PROCEDURE RELEASE_TENDER_BLOCK(
194 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_trip_info IN FTE_TENDER_ATTR_REC);
199
200 PROCEDURE HANDLE_UPDATE_TENDER(
201 p_init_msg_list IN VARCHAR2,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_trip_info IN FTE_TENDER_ATTR_REC);
206
207
208 PROCEDURE TAKE_TENDER_SNAPSHOT(
209 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210 p_trip_id IN NUMBER,
211 p_action IN VARCHAR2,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2);
215 --- For rel 12 hbhagava
216
217
218 END FTE_TENDER_PVT;