[Home] [Help]
PACKAGE: APPS.FTE_RTG_GLOBALS
Source
1 PACKAGE FTE_RTG_GLOBALS AUTHID CURRENT_USER AS
2 /* $Header: FTEUTLGS.pls 115.8 2004/02/27 01:38:11 vphalak noship $ */
3
4 -- Basis codes (used internally)
5 G_WEIGHT_BASIS NUMBER := 1;
6 G_VOLUME_BASIS NUMBER := 2;
7 G_CONTAINER_BASIS NUMBER := 3;
8 G_PALLET_BASIS NUMBER := 4;
9 G_DISTANCE_BASIS NUMBER := 5;
10 G_TIME_BASIS NUMBER := 6;
11 G_FLAT_BASIS NUMBER := 7;
12
13 --Basis codes used for cost allocation
14
15 G_CA_WEIGHT_BASIS VARCHAR2(30):='W';
16 G_CA_VOLUME_BASIS VARCHAR2(30):='V';
17 G_CA_PICKUP_STOP VARCHAR2(30):='P';
18 G_CA_DELIVERY_STOP VARCHAR2(30):='D';
19 G_CA_DIRECT_DISTANCE VARCHAR2(30):='D';
20 G_CA_TOTAL_DISTANCE VARCHAR2(30):='A';
21
22 --Carrier unit basis codes
23 G_CARRIER_WEIGHT_BASIS VARCHAR2(30):='WEIGHT';
24 G_CARRIER_VOLUME_BASIS VARCHAR2(30):='VOLUME';
25 G_CARRIER_CONTAINER_BASIS VARCHAR2(30):='CONTAINER';
26 G_CARRIER_PALLET_BASIS VARCHAR2(30):='PALLET';
27
28
29 -- TL Rating pricing attributes and contexts
30
31 G_AX_TL_RATE_BASIS VARCHAR2(30) := 'LOGISTICS';
32 G_A_TL_RATE_BASIS VARCHAR2(30) := 'PRICING_ATTRIBUTE11';
33 G_AX_TL_CM_DISCOUNT_FLG VARCHAR2(30) := 'LOGISTICS';
34 G_A_TL_CM_DISCOUNT_FLG VARCHAR2(30) := 'PRICING_ATTRIBUTE18';
35 G_AX_TL_DEADHEAD_RT_VAR VARCHAR2(30) := 'LOGISTICS';
36 G_A_TL_DEADHEAD_RT_VAR VARCHAR2(30) := 'PRICING_ATTRIBUTE19';
37 G_AX_TL_DISTANCE_TYPE VARCHAR2(30) := 'LOGISTICS';
38 G_A_TL_DISTANCE_TYPE VARCHAR2(30) := 'PRICING_ATTRIBUTE12';
39 G_AX_TL_RATE_TYPE VARCHAR2(30) := 'LOGISTICS';
40 G_A_TL_RATE_TYPE VARCHAR2(30) := 'PRICING_ATTRIBUTE13';
41 G_AX_SERVICE_TYPE VARCHAR2(30) := 'LOGISTICS';
42 G_A_SERVICE_TYPE VARCHAR2(30) := 'PRICING_ATTRIBUTE14';
43 G_AX_VEHICLE VARCHAR2(30) := 'LOGISTICS';
44 G_A_VEHICLE VARCHAR2(30) := 'PRICING_ATTRIBUTE15';
45 G_AX_ORIGIN_ZONE VARCHAR2(30) := 'LOGISTICS';
46 G_A_ORIGIN_ZONE VARCHAR2(30) := 'PRICING_ATTRIBUTE7';
47 G_AX_DESTINATION_ZONE VARCHAR2(30) := 'LOGISTICS';
48 G_A_DESTINATION_ZONE VARCHAR2(30) := 'PRICING_ATTRIBUTE8';
49 G_AX_TL_NUM_WEEKEND_LAYOVERS VARCHAR2(30) := 'LOGISTICS';
50 G_A_TL_NUM_WEEKEND_LAYOVERS VARCHAR2(30) := 'PRICING_ATTRIBUTE16';
51 G_AX_LOADING_PROTOCOL VARCHAR2(30) := 'LOGISTICS';
52 G_A_LOADING_PROTOCOL VARCHAR2(30) := 'PRICING_ATTRIBUTE17';
53 G_AX_TL_STOP_LOADING_ACT VARCHAR2(30) := 'LOGISTICS';
54 G_A_TL_STOP_LOADING_ACT VARCHAR2(30) := 'PRICING_ATTRIBUTE20';
55 G_AX_TL_STOP_UNLOADING_ACT VARCHAR2(30) := 'LOGISTICS';
56 G_A_TL_STOP_UNLOADING_ACT VARCHAR2(30) := 'PRICING_ATTRIBUTE21';
57 G_AX_TL_HANDLING_ACT VARCHAR2(30) := 'LOGISTICS';
58 G_A_TL_HANDLING_ACT VARCHAR2(30) := 'PRICING_ATTRIBUTE22';
59
60 G_AX_TL_NUM_STOPS VARCHAR2(30) := 'VOLUME';
61 G_A_TL_NUM_STOPS VARCHAR2(30) := 'PRICING_ATTRIBUTE21';
62 G_AX_TL_CHARGED_OUT_RT_DIST VARCHAR2(30) := 'VOLUME';
66 G_AX_TL_WEEKEND_LAYOVER_MIL VARCHAR2(30) := 'VOLUME';
63 G_A_TL_CHARGED_OUT_RT_DIST VARCHAR2(30) := 'PRICING_ATTRIBUTE22';
64 G_AX_TL_NUM_WEEKDAY_LAYOVERS VARCHAR2(30) := 'VOLUME';
65 G_A_TL_NUM_WEEKDAY_LAYOVERS VARCHAR2(30) := 'PRICING_ATTRIBUTE23';
67 G_A_TL_WEEKEND_LAYOVER_MIL VARCHAR2(30) := 'PRICING_ATTRIBUTE24';
68 G_AX_TL_PICKUP_WT VARCHAR2(30) := 'VOLUME';
72 G_AX_TL_PICKUP_CONTAINER VARCHAR2(30) := 'VOLUME';
69 G_A_TL_PICKUP_WT VARCHAR2(30) := 'PRICING_ATTRIBUTE25';
70 G_AX_TL_PICKUP_VOL VARCHAR2(30) := 'VOLUME';
71 G_A_TL_PICKUP_VOL VARCHAR2(30) := 'PRICING_ATTRIBUTE26';
73 G_A_TL_PICKUP_CONTAINER VARCHAR2(30) := 'PRICING_ATTRIBUTE27';
74 G_AX_TL_PICKUP_PALLET VARCHAR2(30) := 'VOLUME';
75 G_A_TL_PICKUP_PALLET VARCHAR2(30) := 'PRICING_ATTRIBUTE28';
76 G_AX_TL_DROPOFF_WT VARCHAR2(30) := 'VOLUME';
77 G_A_TL_DROPOFF_WT VARCHAR2(30) := 'PRICING_ATTRIBUTE29';
78 G_AX_TL_DROPOFF_VOL VARCHAR2(30) := 'VOLUME';
79 G_A_TL_DROPOFF_VOL VARCHAR2(30) := 'PRICING_ATTRIBUTE30';
80 G_AX_TL_DROPOFF_CONTAINER VARCHAR2(30) := 'VOLUME';
81 G_A_TL_DROPOFF_CONTAINER VARCHAR2(30) := 'PRICING_ATTRIBUTE31';
82 G_AX_TL_DROPOFF_PALLET VARCHAR2(30) := 'VOLUME';
83 G_A_TL_DROPOFF_PALLET VARCHAR2(30) := 'PRICING_ATTRIBUTE32';
84 G_AX_TL_HANDLING_WT VARCHAR2(30) := 'VOLUME';
85 G_A_TL_HANDLING_WT VARCHAR2(30) := 'PRICING_ATTRIBUTE33';
86 G_AX_TL_HANDLING_VOL VARCHAR2(30) := 'VOLUME';
87 G_A_TL_HANDLING_VOL VARCHAR2(30) := 'PRICING_ATTRIBUTE34';
88 G_AX_FAC_PICKUP_WT VARCHAR2(30) := 'VOLUME';
89 G_A_FAC_PICKUP_WT VARCHAR2(30) := 'PRICING_ATTRIBUTE35';
90 G_AX_FAC_PICKUP_VOL VARCHAR2(30) := 'VOLUME';
91 G_A_FAC_PICKUP_VOL VARCHAR2(30) := 'PRICING_ATTRIBUTE36';
92 G_AX_FAC_PICKUP_CONTAINER VARCHAR2(30) := 'VOLUME';
93 G_A_FAC_PICKUP_CONTAINER VARCHAR2(30) := 'PRICING_ATTRIBUTE37';
94 G_AX_FAC_PICKUP_PALLET VARCHAR2(30) := 'VOLUME';
95 G_A_FAC_PICKUP_PALLET VARCHAR2(30) := 'PRICING_ATTRIBUTE38';
96 G_AX_FAC_DROPOFF_WT VARCHAR2(30) := 'VOLUME';
97 G_A_FAC_DROPOFF_WT VARCHAR2(30) := 'PRICING_ATTRIBUTE39';
98 G_AX_FAC_DROPOFF_VOL VARCHAR2(30) := 'VOLUME';
99 G_A_FAC_DROPOFF_VOL VARCHAR2(30) := 'PRICING_ATTRIBUTE40';
100 G_AX_FAC_DROPOFF_CONTAINER VARCHAR2(30) := 'VOLUME';
101 G_A_FAC_DROPOFF_CONTAINER VARCHAR2(30) := 'PRICING_ATTRIBUTE41';
102 G_AX_FAC_DROPOFF_PALLET VARCHAR2(30) := 'VOLUME';
103 G_A_FAC_DROPOFF_PALLET VARCHAR2(30) := 'PRICING_ATTRIBUTE42';
104 G_AX_FAC_HANDLING_WT VARCHAR2(30) := 'VOLUME';
105 G_A_FAC_HANDLING_WT VARCHAR2(30) := 'PRICING_ATTRIBUTE43';
106 G_AX_FAC_HANDLING_VOL VARCHAR2(30) := 'VOLUME';
107 G_A_FAC_HANDLING_VOL VARCHAR2(30) := 'PRICING_ATTRIBUTE44';
108 G_AX_FAC_HANDLING_CONTAINER VARCHAR2(30) := 'VOLUME';
109 G_A_FAC_HANDLING_CONTAINER VARCHAR2(30) := 'PRICING_ATTRIBUTE45';
110 G_AX_FAC_HANDLING_PALLET VARCHAR2(30) := 'VOLUME';
111 G_A_FAC_HANDLING_PALLET VARCHAR2(30) := 'PRICING_ATTRIBUTE46';
112
113
114 -- TL Rating qualifier attributes and contexts
115
116 G_QX_MODE_OF_TRANSPORT VARCHAR2(30) := 'LOGISTICS';
117 G_Q_MODE_OF_TRANSPORT VARCHAR2(30) := 'QUALIFIER_ATTRIBUTE7';
118 G_QX_SERVICE_TYPE VARCHAR2(30) := 'LOGISTICS';
119 G_Q_SERVICE_TYPE VARCHAR2(30) := 'QUALIFIER_ATTRIBUTE10';
120
121 -- charge sub type codes for modifiers
122
123 -- min charges for base prices
124
125 G_C_MIN_DISTANCE_CH VARCHAR2(30) := 'C_MIN_DISTANCE_CHRG';
126 G_C_MIN_UNIT_CH VARCHAR2(30) := 'C_MIN_UNIT_CHRG';
127 G_C_MIN_TIME_CH VARCHAR2(30) := 'C_MIN_TIME_CHRG';
128
129 -- Accessorial charges
130
131 G_C_STOP_OFF_CH VARCHAR2(30) := 'C_STOP_OFF_CHRG';
132 G_C_OUT_OF_ROUTE_CH VARCHAR2(30) := 'C_OUT_OF_ROUTE_CHRG';
133 G_C_DOCUMENT_CH VARCHAR2(30) := 'C_DOCUMENT_CHRG';
134 G_C_HANDLING_WEIGHT_CH VARCHAR2(30) := 'C_HANDLING_WEIGHT_CHRG';
135 G_C_HANDLING_VOLUME_CH VARCHAR2(30) := 'C_HANDLING_VOLUME_CHRG';
136 G_C_HANDLING_FLAT_CH VARCHAR2(30) := 'C_HANDLING_FLAT_CHRG';
137 G_C_LOADING_WEIGHT_CH VARCHAR2(30) := 'C_LOADING_WEIGHT_CHRG';
141 G_C_LOADING_FLAT_CH VARCHAR2(30) := 'C_LOADING_FLAT_CHRG';
138 G_C_LOADING_VOLUME_CH VARCHAR2(30) := 'C_LOADING_VOLUME_CHRG';
139 G_C_LOADING_PALLET_CH VARCHAR2(30) := 'C_LOADING_PALLET_CHRG';
140 G_C_LOADING_CONTAINER_CH VARCHAR2(30) := 'C_LOADING_CONTAINER_CHRG';
142 G_C_AST_LOADING_WEIGHT_CH VARCHAR2(30) := 'C_AST_LOADING_WEIGHT_CHRG';
143 G_C_AST_LOADING_VOLUME_CH VARCHAR2(30) := 'C_AST_LOADING_VOLUME_CHRG';
144 G_C_AST_LOADING_PALLET_CH VARCHAR2(30) := 'C_AST_LOADING_PALLET_CHRG';
145 G_C_AST_LOADING_CONTAINER_CH VARCHAR2(30) := 'C_AST_LOADING_CONTAINER_CHRG';
146 G_C_AST_LOADING_FLAT_CH VARCHAR2(30) := 'C_AST_LOADING_FLAT_CHRG';
147 G_C_UNLOADING_WEIGHT_CH VARCHAR2(30) := 'C_UNLOADING_WEIGHT_CHRG';
148 G_C_UNLOADING_VOLUME_CH VARCHAR2(30) := 'C_UNLOADING_VOLUME_CHRG';
149 G_C_UNLOADING_PALLET_CH VARCHAR2(30) := 'C_UNLOADING_PALLET_CHRG';
150 G_C_UNLOADING_CONTAINER_CH VARCHAR2(30) := 'C_UNLOADING_CONTAINER_CHRG';
154 G_C_AST_UNLOADING_PALLET_CH VARCHAR2(30) := 'C_AST_UNLOADING_PALLET_CHRG';
151 G_C_UNLOADING_FLAT_CH VARCHAR2(30) := 'C_UNLOADING_FLAT_CHRG';
152 G_C_AST_UNLOADING_WEIGHT_CH VARCHAR2(30) := 'C_AST_UNLOADING_WEIGHT_CHRG';
153 G_C_AST_UNLOADING_VOLUME_CH VARCHAR2(30) := 'C_AST_UNLOADING_VOLUME_CHRG';
155 G_C_AST_UNLOADING_CONTAINER_CH VARCHAR2(30) := 'C_AST_UNLOADING_CONTAINER_CHRG';
156 G_C_AST_UNLOADING_FLAT_CH VARCHAR2(30) := 'C_AST_UNLOADING_FLAT_CHRG';
157 G_C_WEEKEND_LAYOVER_CH VARCHAR2(30) := 'C_WEEKEND_LAYOVER_CHRG';
158 G_C_WEEKDAY_LAYOVER_CH VARCHAR2(30) := 'C_WEEKDAY_LAYOVER_CHRG';
159 G_C_ORIGIN_SURCHRG VARCHAR2(30) := 'C_ORIGIN_SURCHRG';
160 G_C_DESTINATION_SURCHRG VARCHAR2(30) := 'C_DESTINATION_SURCHRG';
161 G_C_CONTINUOUS_MOVE_DISCOUNT VARCHAR2(30) := 'C_CONTINUOUS_MOVE_DISCOUNT';
162 G_F_LOADING_WEIGHT_CH VARCHAR2(30) := 'F_LOADING_WEIGHT_CHRG';
163 G_F_LOADING_VOLUME_CH VARCHAR2(30) := 'F_LOADING_VOLUME_CHRG';
164 G_F_LOADING_PALLET_CH VARCHAR2(30) := 'F_LOADING_PALLET_CHRG';
165 G_F_LOADING_CONTAINER_CH VARCHAR2(30) := 'F_LOADING_CONTAINER_CHRG';
166 G_F_LOADING_FLAT_CH VARCHAR2(30) := 'F_LOADING_FLAT_CHRG';
167 G_F_AST_LOADING_WEIGHT_CH VARCHAR2(30) := 'F_AST_LOADING_WEIGHT_CHRG';
168 G_F_AST_LOADING_VOLUME_CH VARCHAR2(30) := 'F_AST_LOADING_VOLUME_CHRG';
169 G_F_AST_LOADING_PALLET_CH VARCHAR2(30) := 'F_AST_LOADING_PALLET_CHRG';
170 G_F_AST_LOADING_CONTAINER_CH VARCHAR2(30) := 'F_AST_LOADING_CONTAINER_CHRG';
171 G_F_AST_LOADING_FLAT_CH VARCHAR2(30) := 'F_AST_LOADING_FLAT_CHRG';
172 G_F_UNLOADING_WEIGHT_CH VARCHAR2(30) := 'F_UNLOADING_WEIGHT_CHRG';
173 G_F_UNLOADING_VOLUME_CH VARCHAR2(30) := 'F_UNLOADING_VOLUME_CHRG';
174 G_F_UNLOADING_PALLET_CH VARCHAR2(30) := 'F_UNLOADING_PALLET_CHRG';
175 G_F_UNLOADING_CONTAINER_CH VARCHAR2(30) := 'F_UNLOADING_CONTAINER_CHRG';
176 G_F_UNLOADING_FLAT_CH VARCHAR2(30) := 'F_UNLOADING_FLAT_CHRG';
177 G_F_AST_UNLOADING_WEIGHT_CH VARCHAR2(30) := 'F_AST_UNLOADING_WEIGHT_CHRG';
178 G_F_AST_UNLOADING_VOLUME_CH VARCHAR2(30) := 'F_AST_UNLOADING_VOLUME_CHRG';
182 G_F_HANDLING_WEIGHT_CH VARCHAR2(30) := 'F_HANDLING_WEIGHT_CHRG';
179 G_F_AST_UNLOADING_PALLET_CH VARCHAR2(30) := 'F_AST_UNLOADING_PALLET_CHRG';
180 G_F_AST_UNLOADING_CONTAINER_CH VARCHAR2(30) := 'F_AST_UNLOADING_CONTAINER_CHRG';
181 G_F_AST_UNLOADING_FLAT_CH VARCHAR2(30) := 'F_AST_UNLOADING_FLAT_CHRG';
186 G_F_HANDLING_FLAT_CH VARCHAR2(30) := 'F_HANDLING_FLAT_CHRG';
183 G_F_HANDLING_VOLUME_CH VARCHAR2(30) := 'F_HANDLING_VOLUME_CHRG';
184 G_F_HANDLING_PALLET_CH VARCHAR2(30) := 'F_HANDLING_PALLET_CHRG';
185 G_F_HANDLING_CONTAINER_CH VARCHAR2(30) := 'F_HANDLING_CONTAINER_CHRG';
187 G_C_FUEL_CH VARCHAR2(30) := 'C_FUEL_CHRG'; --enh 3353264
188
189
190 -- Min charges for surcharges
191
192 G_C_MIN_HANDLING_CH VARCHAR2(30) := 'C_MIN_HANDLING_CHRG';
193 G_C_MIN_LOADING_CH VARCHAR2(30) := 'C_MIN_LOADING_CHRG';
194 G_C_MIN_AST_LOADING_CH VARCHAR2(30) := 'C_MIN_AST_LOADING_CHRG';
195 G_C_MIN_UNLOADING_CH VARCHAR2(30) := 'C_MIN_UNLOADING_CHRG';
196 G_C_MIN_AST_UNLOADING_CH VARCHAR2(30) := 'C_MIN_AST_UNLOADING_CHRG';
197
198 G_F_MIN_LOADING_CH VARCHAR2(30) := 'F_MIN_LOADING_CHRG';
199 G_F_MIN_AST_LOADING_CH VARCHAR2(30) := 'F_MIN_AST_LOADING_CHRG';
200 G_F_MIN_UNLOADING_CH VARCHAR2(30) := 'F_MIN_UNLOADING_CHRG';
201 G_F_MIN_AST_UNLOADING_CH VARCHAR2(30) := 'F_MIN_AST_UNLOADING_CHRG';
202 G_F_MIN_HANDLING_CH VARCHAR2(30) := 'F_MIN_HANDLING_CHRG';
203
204
205 -- Values for naming base price list lines (qp_list_lines.attribute1)
206
207 G_C_LOADED_DISTANCE_RT VARCHAR2(30) := 'C_LOADED_DISTANCE_RT';
208 G_C_UNLOADED_DISTANCE_RT VARCHAR2(30) := 'C_UNLOADED_DISTANCE_RT';
209 G_C_UNIT_WT_RT VARCHAR2(30) := 'C_UNIT_WEIGHT_RT';
210 G_C_UNIT_VOL_RT VARCHAR2(30) := 'C_UNIT_VOLUME_RT';
211 G_C_UNIT_CONT_RT VARCHAR2(30) := 'C_UNIT_CONTAINER_RT';
212 G_C_UNIT_PALLET_RT VARCHAR2(30) := 'C_UNIT_PALLET_RT';
213 G_C_TIME_RT VARCHAR2(30) := 'C_TIME_RT';
214 G_C_FLAT_RT VARCHAR2(30) := 'C_FLAT_RT';
215 G_C_LOAD_LEVEL_CHARGES_RT VARCHAR2(30) := 'C_LOAD_LEVEL_CHARGES';
216 G_C_STOP_LEVEL_CHARGES_RT VARCHAR2(30) := 'C_STOP_LEVEL_CHARGES';
217 G_C_CONTINUOUS_MOVE_DIST_RT VARCHAR2(30) := 'C_CONTINUOUS_MOVE_DISTANCE_RT';
218 G_C_CONTINUOUS_MOVE_DH_RT VARCHAR2(30) := 'C_CONTINUOUS_MOVE_DEADHEAD_RT';
219
220 -- Possible Pricing Attribute Values
221
222 -- For G_A_TL_RATE_BASIS
223
224 G_TL_RATE_BASIS_DIST VARCHAR2(30) := 'DISTANCE';
225 G_TL_RATE_BASIS_WT VARCHAR2(30) := 'WEIGHT';
226 G_TL_RATE_BASIS_VOL VARCHAR2(30) := 'VOLUME';
227 G_TL_RATE_BASIS_CONT VARCHAR2(30) := 'CONTAINER';
228 G_TL_RATE_BASIS_PALLET VARCHAR2(30) := 'PALLET';
229 G_TL_RATE_BASIS_TIME VARCHAR2(30) := 'TIME';
230 G_TL_RATE_BASIS_FLAT VARCHAR2(30) := 'FLAT';
231
232
233 -- For G_A_TL_RATE_TYPE
234 G_TL_RATE_TYPE_BASE VARCHAR2(30) := 'BASE_RATE';
235 G_TL_RATE_TYPE_LOAD VARCHAR2(30) := 'LOAD_CHARGE';
236 G_TL_RATE_TYPE_STOP VARCHAR2(30) := 'STOP_CHARGE';
237
238 -- For G_A_DISTANCE_TYPE
239 G_TL_DIST_TYPE_UNLOADED VARCHAR2(30) := 'UNLOADED';
240 G_TL_DIST_TYPE_CM VARCHAR2(30) := 'CONTINUOUS_MOVE';
241
242 -- For G_A_TL_DEADHEAD_RT_VAR
243 G_TL_DEADHEAD_RT_VAR_YES VARCHAR2(30) := 'Y';
244
245
246 END FTE_RTG_GLOBALS;