[Home] [Help]
PACKAGE: APPS.FTE_TRIP_RATING_GRP
Source
1 PACKAGE FTE_TRIP_RATING_GRP AUTHID CURRENT_USER AS
2 /* $Header: FTEGTRRS.pls 120.2 2005/07/15 14:10:20 susurend ship $ */
3
4
5 TYPE Sort_Value_Rec_Type IS RECORD(
6 value dbms_utility.number_array
7 );
8
9 TYPE Sort_Value_Tab_Type IS TABLE OF Sort_Value_Rec_Type INDEX BY BINARY_INTEGER;
10
11
12
13 TYPE action_param_rec IS RECORD (
14 caller VARCHAR2(30),
15 event VARCHAR2(30),
16 action VARCHAR2(30),
17 trip_id_list WSH_UTIL_CORE.id_tab_type); -- list of trip_ids
18
19
20
21
22
23 PROCEDURE Sort(
24 p_values_tab IN Sort_Value_Tab_Type,
25 p_sort_type IN VARCHAR2,--To support variations in the future
26 x_sorted_index OUT NOCOPY dbms_utility.number_array,
27 x_return_status OUT NOCOPY VARCHAR2);
28
29
30
31 -- Public Procedures --
32
33
34
35 -- +======================================================================+
36 -- Procedure :
37 -- Rate_Trip
38 --
39 -- Description:
40 -- Rate Trip from various event points
41 -- Inputs:
42 -- p_action_params => parameters identifying the
43 -- action to be performed
44 -- -> caller -> 'FTE','WSH'
45 -- -> event -> 'TP-RELEASE','SHIP-CONFIRM','RE-RATING'
46 -- -> action -> 'RATE'
47 -- -> trip_id -> valid wsh trip_id
48 -- p_commit => FND_API.G_FALSE / G_TRUE
49 -- Output:
50 -- x_return_status OUT NOCOPY VARCHAR2 => Return status
51 --
52 -- Global dependencies:
53 --
54 --
55 -- DB:
56 --
57 -- +======================================================================+
58
59
60 PROCEDURE Rate_Trip (
61 p_api_version IN NUMBER DEFAULT 1.0,
62 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 p_action_params IN FTE_TRIP_RATING_GRP.action_param_rec,
64 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69
70 -- This API is called directly from the trip re-rating concurrent program
71 -- The input to it should be either wsh trip id or wsh trip name
72
73 PROCEDURE Rate_Trip_conc (
74 errbuf OUT NOCOPY VARCHAR2,
75 retcode OUT NOCOPY VARCHAR2,
76 p_trip_id IN NUMBER DEFAULT NULL,
77 p_trip_name IN VARCHAR2 DEFAULT NULL );
78
79 -- +======================================================================+
80 -- Procedure :
81 -- Move_Records_To_Main
82 --
83 -- Description:
84 -- Move rates from temp table to main table
85 -- Inputs:
86 -- p_trip_id => trip_id (required)
87 -- p_lane_id => lane_id (either lane_id or schedule_id
88 -- required)
89 -- p_schedule_id => schedule_id
90 -- p_service_type_code => service_type_code
91 -- p_comparison_request_id => comparison_request_id (required)
92 -- Output:
93 -- x_return_status OUT NOCOPY VARCHAR2 => Return status
94 --
95 -- Global dependencies:
96 --
97 --
98 -- DB:
99 --
100 -- +======================================================================+
101
102
103 PROCEDURE Move_Records_To_Main(
104 p_trip_id IN NUMBER,
105 p_lane_id IN NUMBER,
106 p_schedule_id IN NUMBER,
107 p_service_type_code IN VARCHAR2 DEFAULT NULL,
108 p_comparison_request_id IN NUMBER,
109 p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
110 x_return_status OUT NOCOPY VARCHAR2);
111
112
113
114 -- +======================================================================+
115 -- Procedure :
116 -- Delete Main Records
117 --
118 -- Description:
119 -- Deletes all rates for a trip from WSH_FREIGHT_COSTS table
120 -- Inputs:
121 -- p_trip_id => trip_id
122 -- Output:
123 -- x_return_status OUT NOCOPY VARCHAR2 => Return status
124 --
125 -- Global dependencies:
126 --
127 --
128 -- DB:
129 --
130 -- +======================================================================+
131
132
133 PROCEDURE Delete_Main_Records(
134 p_trip_id IN NUMBER,
135 p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
136 x_return_status OUT NOCOPY VARCHAR2);
137
138
139 -- +======================================================================+
140 -- Procedure :
141 -- Compare_Trip_Rates
142 --
143 -- Description:
144 -- Compare trip rates
145 -- Inputs:
146 -- p_trip_id IN NUMBER => a valid wsh trip id
147 -- p_lane_sched_id_tab => lane_ids or schedule_ids
148 -- p_lane_sched_tab => 'L' or 'S' (Lane or Schedule)
149 -- p_service_type_tab => service type codes
150 -- p_vehicle_id_tab => vehicle item ids
151 -- p_event => Default 'FTE_TRIP_COMP'
152 -- p_commit => FND_API.G_FALSE / G_TRUE
153 -- Output:
154 -- x_request_id => handle to table fte_freight_costs_temp
155 -- x_return_status OUT NOCOPY VARCHAR2 => Return status
156 --
157 -- Global dependencies:
158 --
159 --
160 -- DB:
161 --
162 -- +======================================================================+
163
164
165 PROCEDURE Compare_Trip_Rates (
166 p_api_version IN NUMBER DEFAULT 1.0,
167 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168 p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
169 p_trip_id IN NUMBER DEFAULT NULL,
170 p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
171 p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
172 p_mode_tab IN FTE_CODE_TAB_TYPE,
173 p_service_type_tab IN FTE_CODE_TAB_TYPE,
174 p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
175 p_dep_date IN DATE DEFAULT sysdate,
176 p_arr_date IN DATE DEFAULT sysdate,
177 p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
178 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
179 x_request_id OUT NOCOPY NUMBER,
180 x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
181 x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
182 x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
183 x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
184 x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
185 x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
186 x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2);
190
191
192
193 PROCEDURE Search_Rate_Sort(
194 p_api_version IN NUMBER DEFAULT 1.0,
195 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196 p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
197 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198 p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
199 p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
200 p_ss_rate_sort_atr_rec IN FTE_SS_ATTR_REC,
201 x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
202 x_rating_request_id OUT NOCOPY NUMBER,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2);
206
207
208
209 PROCEDURE Display_Rank_Rec(p_rank_rec IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec);
210
211
212 END FTE_TRIP_RATING_GRP;