[Home] [Help]
PACKAGE: APPS.WSH_FREIGHT_COSTS_PVT
Source
1 PACKAGE WSH_FREIGHT_COSTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHFCTHS.pls 120.1 2007/01/05 23:00:12 schennal noship $ */
3 -- set tabstop=3 to read in correct alignment
4 --
5 -- Package type declarations
6 --
7 TYPE Freight_Cost_Rec_Type IS RECORD (
8 FREIGHT_COST_ID NUMBER
9 , FREIGHT_COST_TYPE_ID NUMBER
10 , UNIT_AMOUNT NUMBER
11 /* H Integration: datamodel changes wrudge (15->30) */
12 , CALCULATION_METHOD VARCHAR2(30)
13 , UOM VARCHAR2(15)
14 , QUANTITY NUMBER
15 , TOTAL_AMOUNT NUMBER
16 , CURRENCY_CODE VARCHAR2(15)
17 , CONVERSION_DATE DATE
18 , CONVERSION_RATE NUMBER
19 , CONVERSION_TYPE_CODE VARCHAR2(30)
20 , TRIP_ID NUMBER
21 , STOP_ID NUMBER
22 , DELIVERY_ID NUMBER
23 , DELIVERY_LEG_ID NUMBER
24 , DELIVERY_DETAIL_ID NUMBER
25 , ATTRIBUTE_CATEGORY VARCHAR2(150)
26 , ATTRIBUTE1 VARCHAR2(150)
27 , ATTRIBUTE2 VARCHAR2(150)
28 , ATTRIBUTE3 VARCHAR2(150)
29 , ATTRIBUTE4 VARCHAR2(150)
30 , ATTRIBUTE5 VARCHAR2(150)
31 , ATTRIBUTE6 VARCHAR2(150)
32 , ATTRIBUTE7 VARCHAR2(150)
33 , ATTRIBUTE8 VARCHAR2(150)
34 , ATTRIBUTE9 VARCHAR2(150)
35 , ATTRIBUTE10 VARCHAR2(150)
36 , ATTRIBUTE11 VARCHAR2(150)
37 , ATTRIBUTE12 VARCHAR2(150)
38 , ATTRIBUTE13 VARCHAR2(150)
39 , ATTRIBUTE14 VARCHAR2(150)
40 , ATTRIBUTE15 VARCHAR2(150)
41 , CREATION_DATE DATE
42 , CREATED_BY NUMBER
43 , LAST_UPDATE_DATE DATE
44 , LAST_UPDATED_BY NUMBER
45 , LAST_UPDATE_LOGIN NUMBER
46 , PROGRAM_APPLICATION_ID NUMBER
47 , PROGRAM_ID NUMBER
48 , PROGRAM_UPDATE_DATE DATE
49 , REQUEST_ID NUMBER
50 /* H Integration: datamodel changes wrudge */
51 , PRICING_LIST_HEADER_ID NUMBER
52 , PRICING_LIST_LINE_ID NUMBER
53 , APPLIED_TO_CHARGE_ID NUMBER
54 , CHARGE_UNIT_VALUE NUMBER
55 , CHARGE_SOURCE_CODE VARCHAR2(30)
56 , LINE_TYPE_CODE VARCHAR2(30)
57 , ESTIMATED_FLAG VARCHAR2(1)
58 /* Harmonizing project I: heali */
59 , FREIGHT_CODE VARCHAR2(30)
60 , TRIP_NAME VARCHAR2(30)
61 , DELIVERY_NAME VARCHAR2(30)
62 , FREIGHT_COST_TYPE VARCHAR2(30)
63 , STOP_LOCATION_ID NUMBER
64 , PLANNED_DEP_DATE DATE
65 , COMMODITY_CATEGORY_ID NUMBER
66 /* R12 new attributes */
67 , BILLABLE_QUANTITY NUMBER
68 , BILLABLE_UOM VARCHAR2(15)
69 , BILLABLE_BASIS VARCHAR2(30)
70 );
71
72 --
73 -- Procedure: Create_Freight_Cost
74 --
75 PROCEDURE Create_Freight_Cost(
76 p_freight_cost_info IN Freight_Cost_Rec_Type
77 , x_rowid OUT NOCOPY VARCHAR2
78 , x_freight_cost_id OUT NOCOPY NUMBER
79 , x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE Update_Freight_Cost(
83 p_rowid IN VARCHAR2
84 , p_freight_cost_info IN Freight_Cost_Rec_Type
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE Lock_Freight_Cost(
89 p_rowid IN VARCHAR2
90 , p_freight_cost_info IN Freight_Cost_Rec_Type
91 );
92
93 PROCEDURE Delete_Freight_Cost(
94 p_rowid IN VARCHAR2
95 , p_freight_cost_id IN NUMBER
96 , x_return_status OUT NOCOPY VARCHAR2
97 );
98
99
100 PROCEDURE Split_Freight_Cost(
101 p_from_freight_cost_id IN NUMBER
102 , x_new_freight_cost_id OUT NOCOPY NUMBER
103 , p_new_delivery_detail_id IN NUMBER
104 , p_requested_quantity IN NUMBER
105 , p_split_requested_quantity IN NUMBER
106 , x_return_status OUT NOCOPY VARCHAR2
107 );
108
109
110 --This procedure needs to be removed as this is no longer used - post I.
111 --Waiting for STF changes before removing this.
112 --Replaced by another procedure with same name
113 PROCEDURE Get_Total_Freight_Cost(
114 p_entity_level IN VARCHAR2,
115 p_entity_id IN NUMBER,
116 p_currency_code IN VARCHAR2,
117 x_total_amount OUT NOCOPY NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2);
119
120 PROCEDURE Get_Total_Freight_Cost(
121 p_entity_level IN VARCHAR2,
122 p_entity_id IN NUMBER,
123 p_currency_code IN VARCHAR2,
124 x_detail_amount OUT NOCOPY NUMBER ,
125 x_lpn_amount OUT NOCOPY NUMBER ,
126 x_main_lpn_amount OUT NOCOPY NUMBER,
127 x_delivery_amount OUT NOCOPY NUMBER ,
128 x_stop_amount OUT NOCOPY NUMBER ,
129 x_trip_amount OUT NOCOPY NUMBER ,
130 x_return_status OUT NOCOPY VARCHAR2);
131
132 PROCEDURE Get_Summary_Freight_Cost(
133 p_entity_level IN VARCHAR2,
134 p_entity_id IN NUMBER,
135 p_currency_code IN VARCHAR2,
136 x_total_amount OUT NOCOPY NUMBER,
137 x_reprice_required OUT NOCOPY VARCHAR2,
138 x_return_status OUT NOCOPY VARCHAR2);
139
140
141
142 PROCEDURE Convert_Amount (
143 p_from_currency IN VARCHAR2,
144 p_to_currency IN VARCHAR2,
145 p_conversion_date IN DATE,
146 p_conversion_rate IN NUMBER,
147 p_conversion_type IN VARCHAR2,
148 p_amount IN NUMBER,
149 x_converted_amount OUT NOCOPY NUMBER,
150 x_return_status OUT NOCOPY VARCHAR2);
151
152 PROCEDURE Remove_FTE_Freight_Costs(
153 p_delivery_details_tab IN WSH_UTIL_CORE.Id_Tab_Type,
154 x_return_status OUT NOCOPY VARCHAR2 );
155
156 PROCEDURE Get_Trip_Manual_Freight_Cost(
157 p_trip_id IN NUMBER,
158 p_currency_code IN VARCHAR2,
159 x_trip_amount OUT NOCOPY NUMBER,
160 x_return_status OUT NOCOPY VARCHAR2);
161
162 END WSH_FREIGHT_COSTS_PVT;