PACKAGE: APPS.FTE_TL_COST_ALLOCATION

Source

1 PACKAGE FTE_TL_COST_ALLOCATION AUTHID CURRENT_USER AS
2 /* $Header: FTEVTLAS.pls 120.0 2005/05/26 18:12:06 appldev noship $ */
3 
4 C_LOADED_DISTANCE_RT 	NUMBER:=10;
5 C_UNLOADED_DISTANCE_RT	NUMBER:=11;
6 C_UNIT_WEIGHT_RT	NUMBER:= 12;
7 C_UNIT_VOLUME_RT NUMBER:=13;
8 C_UNIT_CONTAINER_RT	NUMBER:=14;
9 C_UNIT_PALLET_RT NUMBER:=15;
10 C_TIME_RT	NUMBER:=16;
11 C_FLAT_RT	NUMBER:=17;
12 C_CONTINUOUS_MOVE_DISTANCE_RT	NUMBER:=18;
13 
14 C_MIN_DISTANCE_CHRG	NUMBER:=19;
15 C_MIN_UNIT_CHRG	NUMBER:=20;
16 C_MIN_TIME_CHRG	NUMBER:=21;
17 
18 C_STOP_OFF_CHRG	NUMBER:=22;
19 C_OUT_OF_ROUTE_CHRG	NUMBER:=23;
20 C_DOCUMENT_CHRG	NUMBER:=24;
21 C_HANDLING_CHRG NUMBER:=25;
22 
23 C_LOADING_CHRG NUMBER:=26;
24 C_AST_LOADING_CHRG NUMBER:=27;
25 C_UNLOADING_CHRG NUMBER:=28;
26 C_AST_UNLOADING_CHRG NUMBER:=29;
27 C_WEEKEND_LAYOVER_CHRG NUMBER:=30;
28 C_WEEKDAY_LAYOVER_CHRG NUMBER:=31;
29 C_ORIGIN_SURCHRG NUMBER:=32;
30 C_DESTINATION_SURCHRG NUMBER:=33;
31 C_CONTINUOUS_MOVE_DISCOUNT NUMBER:=34;
32 F_LOADING_CHRG NUMBER:=35;
33 F_AST_LOADING_CHRG NUMBER:=36;
34 F_UNLOADING_CHRG NUMBER:=37;
35 F_AST_UNLOADING_CHRG  NUMBER:=38;
36 F_HANDLING_CHRG NUMBER:=39;
37 
38 C_FUEL_CHRG NUMBER:=40;
39 C_SUMMARY NUMBER:=41;
40 
41 
42 
43 TYPE TL_allocation_params_rec_type IS RECORD(
44 
45 principal_alloc_basis          VARCHAR2(30),
46 distance_alloc_method          VARCHAR2(30),
47 tl_stop_alloc_method           VARCHAR2(30),
48 output_type                    VARCHAR2(1),
49 comparison_request_id 		NUMBER);
50 
51 
52 TYPE TL_freight_code_rec_type IS RECORD(
53 name 			VARCHAR2(60),
54 summary_name		VARCHAR2(60),
55 fte_price_code_id	NUMBER,
56 fte_charge_code_id	NUMBER,
57 fte_summary_code_id	NUMBER);
58 
59 TYPE TL_freight_code_tab_type IS TABLE OF TL_freight_code_rec_type INDEX BY BINARY_INTEGER;
60 
61 g_tl_freight_codes TL_freight_code_tab_type;
62 
63 PROCEDURE TL_COST_ALLOCATION(
64 	p_trip_index 		IN 	NUMBER,
65 	p_trip_charges_rec 	IN 	FTE_TL_CACHE.TL_trip_output_rec_type ,
66 	p_stop_charges_tab 	IN 	FTE_TL_CACHE.TL_trip_stop_output_tab_type,
67 	p_cost_allocation_parameters  IN	TL_allocation_params_rec_type,
68 	x_output_cost_tab 	IN OUT 	NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
69 	x_return_status 	OUT 	NOCOPY	VARCHAR2);
70 
71 
72 
73 
74 PROCEDURE Scale_Trip_Charges(
75 	p_discount IN NUMBER,
76 	x_trip_charges_rec IN OUT NOCOPY FTE_TL_CACHE.TL_TRIP_OUTPUT_REC_TYPE,
77 	x_return_status OUT NOCOPY VARCHAR2);
78 
79 PROCEDURE Scale_Stop_Charges(
80 	p_discount IN NUMBER,
81 	x_stop_charges_rec IN OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_OUTPUT_REC_TYPE,
82 	x_return_status OUT NOCOPY VARCHAR2);
83 
84 PROCEDURE Get_Total_Trip_Cost(
85 	p_trip_index IN NUMBER,
86 	p_trip_charges_rec IN FTE_TL_CACHE.TL_TRIP_OUTPUT_REC_TYPE,
87 	p_stop_charges_tab IN FTE_TL_CACHE.TL_TRIP_STOP_OUTPUT_TAB_TYPE,
88 	x_charge IN OUT NOCOPY NUMBER,
89 	x_return_status OUT NOCOPY Varchar2);
90 
91 PROCEDURE Get_Cost_Allocation_Parameters(
92 	x_cost_allocation_parameters IN OUT NOCOPY TL_allocation_params_rec_type,
93 	x_return_status OUT NOCOPY Varchar2);
94 
95 PROCEDURE TEST;
96 
97 END FTE_TL_COST_ALLOCATION;