1 PACKAGE WSH_FC_INTERFACE_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHFCIFS.pls 120.2 2006/02/19 20:39:49 somanaam noship $ */
3
4 --<TPA_PUBLIC_NAME=WSH_TPA_FREIGHT_COSTS_PKG>
5 --<TPA_PUBLIC_FILE_NAME=WSHTPFC>
6
7 TYPE RelavantInfoRecType IS RECORD (
8 delivery_detail_id NUMBER
9 , container_id NUMBER
10 , delivery_id NUMBER
11 , stop_id NUMBER
12 , trip_id NUMBER
13 , inventory_item_id NUMBER
14 , requested_quantity NUMBER
15 , shipped_quantity NUMBER
16 , requested_quantity_uom VARCHAR2(3)
17 , net_weight NUMBER
18 , weight_uom_code VARCHAR2(3)
19 , volume NUMBER
20 , volume_uom_code VARCHAR2(3)
21 );
22
23 TYPE RelavantInfoTabType IS TABLE OF RelavantInfoRecType
24 INDEX BY BINARY_INTEGER;
25
26 TYPE ContainerRelationshipRecType IS RECORD (
27 container_id NUMBER
28 , parent_container_id NUMBER
29 );
30
31 TYPE ContainerRelationshipTabType IS TABLE OF ContainerRelationshipRecType
32 INDEX BY BINARY_INTEGER;
33
34
35 TYPE CostBreakdownRecType IS RECORD (
36 delivery_detail_id NUMBER
37 , inventory_item_id NUMBER
38 , container_id NUMBER
39 , delivery_id NUMBER
40 , stop_id NUMBER
41 , trip_id NUMBER
42 , quantity NUMBER
43 , uom VARCHAR2(10)
44 );
45
46 TYPE CostBreakdownTabType IS TABLE OF CostBreakdownRecType
47 INDEX BY BINARY_INTEGER;
48
49 TYPE OMInterfaceCostRecType IS RECORD (
50 source_line_id NUMBER
51 , freight_cost_type_code VARCHAR2(30)
52 , freight_cost_id NUMBER
53 , amount NUMBER
54 , currency_code VARCHAR2(15)
55 , source_header_id NUMBER --HVOP heali
56 );
57
58 TYPE OMInterfaceCostTabType IS TABLE OF OMInterfaceCostRecType
59 INDEX BY BINARY_INTEGER;
60
61 TYPE ProratedCostRecType IS RECORD (
62 delivery_detail_id NUMBER
63 , freight_cost_type_code VARCHAR2(30)
64 , freight_cost_id NUMBER
65 , amount NUMBER
66 , currency_code VARCHAR2(15)
67 , conversion_type_code WSH_FREIGHT_COSTS.conversion_type_code%TYPE
68 , conversion_rate WSH_FREIGHT_COSTS.conversion_rate%TYPE
69
70 );
71
72 TYPE ProratedCostTabType IS TABLE OF ProratedCostRecType
73 INDEX BY BINARY_INTEGER;
74
75 TYPE ProratedChargeRecType IS RECORD (
76 delivery_detail_id NUMBER
77 , amount NUMBER
78
79 );
80
81 TYPE ProratedChargeTabType IS TABLE OF ProratedChargeRecType
82 INDEX BY BINARY_INTEGER;
83
84
85
86 PROCEDURE Round_Cost_Amount(
87 p_Amount IN NUMBER
88 , p_Currency_Code IN VARCHAR2
89 , x_Round_Amount OUT NOCOPY NUMBER
90 , x_return_status OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE Source_Line_Level_Cost(
94 p_stop_id IN NUMBER
95 , p_prorated_freight_cost IN ProratedCostTabType
96 , x_Final_Cost IN OUT NOCOPY OMInterfaceCostTabType
97 , x_return_status OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE Calculate_Freight_Costs(
101 p_stop_id IN NUMBER
102 , x_Freight_costs OUT NOCOPY OMInterfaceCostTabType
103 , x_return_status OUT NOCOPY VARCHAR2
104 );
105
106 --HVOP heali
107 PROCEDURE Process_Freight_Costs(
108 p_stop_id IN NUMBER
109 , p_start_index IN NUMBER
110 , p_line_id_tbl IN OE_WSH_BULK_GRP.T_NUM
111 , x_freight_costs_all IN OUT NOCOPY OMInterfaceCostTabType
112 , x_freight_costs IN OUT NOCOPY OE_Ship_Confirmation_Pub.Ship_Adj_Rec_Type
113 , x_end_index OUT NOCOPY NUMBER
114 , x_return_status OUT NOCOPY VARCHAR2
115 );
116 --HVOP heali
117
118
119 FUNCTION Prorate_Freight_Charge (
120 p_delivery_detail_id IN NUMBER
121 , p_charge_id IN NUMBER
122 ) RETURN NUMBER;
123
124
125
126 -- Name Get_Cost_Factor
127 -- Purpose dummy function
128 -- Since TPA does not support deleting obsolete APIs,
129 -- this function needs to remain in this package
130 -- (bug 1948149).
131 --
132 -- TPA Selector WSH_TPA_SELECTOR_PKG.FreightCostTP
133 FUNCTION Get_Cost_Factor(
134 p_delivery_id IN NUMBER
135 , p_container_instance_id IN NUMBER
136 , x_return_status OUT NOCOPY VARCHAR2
137 ) RETURN VARCHAR2;
138 --<TPA_PUBLIC_NAME>
139 --<TPA_DEFAULT_TPS=WSH_TPA_SELECTOR_PKG.FreightCostTP>
140
141
142
143
144
145 END WSH_FC_INTERFACE_PKG;