1 PACKAGE MST_REPORTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: MSTREPOS.pls 115.3 2004/06/17 15:44:32 bramacha noship $ */
3
4 --define/declare package level variables here
5 -- g_release_type number; -- being used in MSTEXCEP.pld
6
7 --declare functions/procedures here
8 --
9
10 function get_plan_order_count (p_plan_id in number
11 , p_report_for in number
12 , p_report_for_id in number) return number;
13
14 function get_order_group_count (p_plan_id in number
15 , p_report_for in number
16 , p_report_for_id in number) return number;
17
18 function get_weight (p_plan_id in number
19 , p_report_for in number
20 , p_report_for_id in number) return number;
21
22 function get_volume (p_plan_id in number
23 , p_report_for in number
24 , p_report_for_id in number) return number;
25
26 function get_pieces (p_plan_id in number
27 , p_report_for in number
28 , p_report_for_id in number) return number;
29
30 function get_plan_value (p_plan_id in number
31 , p_report_for in number
32 , p_report_for_id in number) return number;
33
34 function get_trips_per_mode (p_plan_id in number
35 , p_report_for in number
36 , p_report_for_id in number
37 , p_mode in varchar2) return number;
38
39 function get_trans_cost_per_mode (p_plan_id in number
40 , p_report_for in number
41 , p_report_for_id in number
42 , p_mode in varchar2) return number;
43
44 function get_handl_cost_per_mode (p_plan_id in number
45 , p_report_for in number
46 , p_report_for_id in number
47 , p_mode in varchar2) return number;
48
49 function get_total_cost_per_mode (p_plan_id in number
50 , p_report_for in number
51 , p_report_for_id in number
52 , p_mode in varchar2) return number;
53
54 function get_stops_per_load (p_plan_id in number
55 , p_report_for in number
56 , p_report_for_id in number) return number;
57
58 function get_TL_distance (p_plan_id in number
59 , p_report_for in number
60 , p_report_for_id in number) return number;
61
62 function get_carr_movements(p_plan_id in number
63 , p_report_for in number
64 , p_report_for_id in number
65 , p_carrier_id in number) return number;
66
67 function get_carr_cost(p_plan_id in number
68 , p_report_for in number
69 , p_report_for_id in number
70 , p_carrier_id in number) return number;
71
72 function get_orders_orig(p_plan_id in number
73 , p_report_for in number
74 , p_report_for_id in number
75 , p_orig_state in varchar2) return number;
76
77 function get_weight_orig(p_plan_id in number
78 , p_report_for in number
79 , p_report_for_id in number
80 , p_orig_state in varchar2) return number;
81
82 function get_volume_orig(p_plan_id in number
83 , p_report_for in number
84 , p_report_for_id in number
85 , p_orig_state in varchar2) return number;
86
87 function get_pieces_orig(p_plan_id in number
88 , p_report_for in number
89 , p_report_for_id in number
90 , p_orig_state in varchar2) return number;
91
92 function get_MTL_orig(p_plan_id in number
93 , p_report_for in number
94 , p_report_for_id in number
95 , p_orig_state in varchar2) return number;
96
97 function get_DTL_orig(p_plan_id in number
98 , p_report_for in number
99 , p_report_for_id in number
100 , p_orig_state in varchar2) return number;
101
102 function get_LTL_orig(p_plan_id in number
103 , p_report_for in number
104 , p_report_for_id in number
105 , p_orig_state in varchar2) return number;
106
107 function get_PCL_orig(p_plan_id in number
108 , p_report_for in number
109 , p_report_for_id in number
110 , p_orig_state in varchar2) return number;
111
112 function get_total_cost_mode_orig (p_plan_id in number
113 , p_report_for in number
114 , p_report_for_id in number
115 , p_mode in varchar2
116 , p_orig_state in varchar2) return number;
117
118 function get_orders_dest(p_plan_id in number
119 , p_report_for in number
120 , p_report_for_id in number
121 , p_destination_state in varchar2) return number;
122
123 function get_weight_dest(p_plan_id in number
124 , p_report_for in number
125 , p_report_for_id in number
126 , p_destination_state in varchar2) return number;
127
128 function get_volume_dest(p_plan_id in number
129 , p_report_for in number
130 , p_report_for_id in number
131 , p_destination_state in varchar2) return number;
132
133 function get_pieces_dest(p_plan_id in number
134 , p_report_for in number
135 , p_report_for_id in number
136 , p_destination_state in varchar2) return number;
137
138 function get_MTL_dest(p_plan_id in number
139 , p_report_for in number
140 , p_report_for_id in number
141 , p_destination_state in varchar2) return number;
142
143 function get_DTL_dest(p_plan_id in number
144 , p_report_for in number
145 , p_report_for_id in number
146 , p_destination_state in varchar2) return number;
147
148 function get_LTL_dest(p_plan_id in number
149 , p_report_for in number
150 , p_report_for_id in number
151 , p_destination_state in varchar2) return number;
152
153 function get_PCL_dest(p_plan_id in number
154 , p_report_for in number
155 , p_report_for_id in number
156 , p_destination_state in varchar2) return number;
157
158 function get_total_cost_mode_dest (p_plan_id in number
159 , p_report_for in number
160 , p_report_for_id in number
161 , p_mode in varchar2
162 , p_destination_state in varchar2) return number;
163
164 function get_orders_myfac (p_plan_id in number
165 , p_report_for in number
166 , p_report_for_id in number
167 , p_myfac_id in number) return number;
168
169 function get_weight_myfac (p_plan_id in number
170 , p_report_for in number
171 , p_report_for_id in number
172 , p_myfac_id in number) return number;
173
174 function get_volume_myfac (p_plan_id in number
175 , p_report_for in number
176 , p_report_for_id in number
177 , p_myfac_id in number) return number;
178
179 function get_pieces_myfac (p_plan_id in number
180 , p_report_for in number
181 , p_report_for_id in number
182 , p_myfac_id in number) return number;
183
184 function get_trips_per_mode_myfac (p_plan_id in number
185 , p_report_for in number
186 , p_report_for_id in number
187 , p_mode in varchar2
188 , p_myfac_id in number) return number;
189
190 function get_cost_per_mode_myfac (p_plan_id in number
191 , p_report_for in number
192 , p_report_for_id in number
193 , p_mode in varchar2
194 , p_myfac_id in number) return number;
195
196 function get_orders_c_s (p_plan_id in number
197 , p_report_for in number
198 , p_report_for_id in number
199 , p_c_s_ident in number
200 , p_cust_supp_id in number) return number;
201
202 function get_weight_c_s (p_plan_id in number
203 , p_report_for in number
204 , p_report_for_id in number
205 , p_c_s_ident in number
206 , p_cust_supp_id in number) return number;
207
208 function get_volume_c_s (p_plan_id in number
209 , p_report_for in number
210 , p_report_for_id in number
211 , p_c_s_ident in number
212 , p_cust_supp_id in number) return number;
213
214 function get_pieces_c_s (p_plan_id in number
215 , p_report_for in number
216 , p_report_for_id in number
217 , p_c_s_ident in number
218 , p_cust_supp_id in number) return number;
219
220 function get_trips_per_mode_c_s (p_plan_id in number
221 , p_report_for in number
222 , p_report_for_id in number
223 , p_mode in varchar2
224 , p_c_s_ident in number
225 , p_cust_supp_id in number) return number;
226
227 function get_cost_per_mode_c_s (p_plan_id in number
228 , p_report_for in number
229 , p_report_for_id in number
230 , p_mode in varchar2
231 , p_c_s_ident in number
232 , p_cust_supp_id in number) return number;
233
234 function get_DTL_c_s (p_plan_id in number
235 , p_report_for in number
236 , p_report_for_id in number
237 , p_c_s_ident in number
238 , p_cust_supp_id in varchar2) return number;
239
240 function get_MTL_c_s (p_plan_id in number
241 , p_report_for in number
242 , p_report_for_id in number
243 , p_c_s_ident in number
244 , p_cust_supp_id in varchar2) return number;
245
246 PROCEDURE Populate_Master_Summary_GTT (p_plan_id in number
247 , p_report_for in number
248 , p_report_for_id in number default 0);
249
250 function get_freight_classes_per_order (p_plan_id in number
251 , p_source_header_number in number) return varchar2;
252
253 /*
254 * To calculate the wait time at a particular stop for a given trip in a given plan
255 */
256 function get_wait_time_at_stop ( p_plan_id in number
257 , p_trip_id in number
258 , p_stop_id in number ) return varchar2;
259
260 END MST_REPORTS_PKG;