1 PACKAGE OE_OE_TOTALS_SUMMARY AS
2 /* $Header: OEXVTOTS.pls 120.0.12000000.1 2007/01/16 22:12:54 appldev ship $ */
3
4 G_TAX_VALUE NUMBER :=0;
5 G_TOTAL_EXTENDED_PRICE NUMBER :=0;
6
7 /* Recurring totals */
8 G_REC_TAX_VALUE NUMBER :=0;
9 G_REC_TOTAL_EXTENDED_PRICE NUMBER :=0;
10
11 TYPE rec_charges_rec_type IS RECORD
12 (
13 charge_periodicity_code VARCHAR2(3),
14 charge_periodicity_desc VARCHAR2(100),
15 charge_periodicity_meaning VARCHAR2(100),
16 rec_subtotal NUMBER,
17 rec_tax NUMBER,
18 rec_charges NUMBER,
19 rec_total NUMBER
20 );
21
22 TYPE rec_charges_tbl_type IS TABLE OF rec_charges_rec_type
23 INDEX BY BINARY_INTEGER;
24
25 g_rec_charges_tbl_type rec_charges_tbl_type;
26 /* Recurring totals */
27
28
29 -- Function : PRICE_ADJUSTMENTS
30
31 FUNCTION PRICE_ADJUSTMENTS
32 (
33 p_header_id IN NUMBER
34 )
35 RETURN NUMBER;
36
37
38 FUNCTION LINE_PRICE_ADJ_ORDER_MODIFIER
39 (
40 x_header_id IN NUMBER,
41 x_line_id IN NUMBER,
42 x_list_line_id IN NUMBER
43 )
44 RETURN NUMBER;
45
46
47 FUNCTION LINE_EXT_ADJ_ORDER_MODIFIER
48 (
49 x_header_id IN NUMBER,
50 x_line_id IN NUMBER,
51 x_list_line_id IN NUMBER
52 )
53 RETURN NUMBER;
54
55 FUNCTION LINE_PRICE_ADJUSTMENTS
56 (
57 x_line_id IN NUMBER
58 )
59 RETURN NUMBER;
60
61 FUNCTION CHARGES
62 (
63 p_header_id IN NUMBER
64 )
65 RETURN NUMBER;
66
67
68 FUNCTION LINE_CHARGES
69 (
70 p_header_id IN NUMBER ,
71 p_line_id IN NUMBER
72 )
73 RETURN NUMBER;
74
75 FUNCTION TAXES
76 (
77 p_header_id IN NUMBER
78 )
79 RETURN NUMBER;
80
81 FUNCTION ORDER_SUBTOTALS
82 (
83 p_header_id IN NUMBER
84 )
85 RETURN NUMBER;
86
87 FUNCTION LINE_TOTAL
88 (
89 p_header_id IN NUMBER ,
90 p_line_id IN NUMBER ,
91 p_line_number IN NUMBER,
92 p_shipment_number IN NUMBER default null
93 )
94 RETURN NUMBER;
95
96 /* bug - 1480491 */
97 FUNCTION SERVICE_TOTAL
98 (
99 p_header_id IN NUMBER ,
100 p_line_number IN NUMBER,
101 p_service_number IN NUMBER
102 )
103 RETURN NUMBER;
104 /* bug - 1480491 */
105
106 PROCEDURE GLOBAL_TOTALS
107 (
108 p_header_id IN NUMBER
109 );
110
111 FUNCTION CONFIG_TOTALS
112 (
113 p_line_id IN NUMBER
114 )
115 RETURN NUMBER;
116
117 FUNCTION TOTAL_ORDERED_QTY
118 (
119 p_header_id IN NUMBER,
120 p_line_number IN NUMBER
121 )
122 RETURN NUMBER;
123
124 PROCEDURE ORDER_TOTALS
125 (
126 p_header_id IN NUMBER,
127 p_subtotal OUT NOCOPY NUMBER,
128
129 p_discount OUT NOCOPY NUMBER,
130
131 p_charges OUT NOCOPY NUMBER,
132
133 p_tax OUT NOCOPY NUMBER
134
135 );
136
137 FUNCTION PRT_ORDER_TOTAL
138 ( p_header_id IN NUMBER)
139 RETURN NUMBER;
140
141 FUNCTION OUTBOUND_ORDER_TOTAL
142 (
143 p_header_id IN NUMBER,
144 p_to_exclude_commitment IN VARCHAR2 DEFAULT NULL, -- bug 4013565
145 p_total_type IN VARCHAR2 DEFAULT NULL, -- bug 4013565
146 p_all_lines IN VARCHAR2 DEFAULT NULL
147 )
148 RETURN NUMBER;
149
150 FUNCTION OUTBOUND_ORDER_SUBTOTAL
151 (
152 p_header_id IN NUMBER
153 )
154 RETURN NUMBER;
155
156 Function Get_Order_Amount
157 (p_header_id In Number
158 )
159 Return Number;
160
161
162 -- This function is used to calculate the discount percentage for the line
163 -- items in a sales order. This uses the unit selling price and the unit
164 -- list price to calculate the discount
165 -- Input: unit_list_price, unit_selling_price Output: discount percent
166 -- Called from: OE_PRN_ORDER_LINES_V view
167
168 FUNCTION GET_DISCOUNT(p_unit_list_price IN number,p_unit_selling_price IN NUMBER)
169 RETURN NUMBER;
170
171 /* Recurring totals */
172
173 PROCEDURE GLOBAL_REC_TOTALS
174 (
175 p_header_id IN NUMBER,
176 p_charge_periodicity_code IN VARCHAR2
177 );
178
179 FUNCTION REC_TAXES
180 (
181 p_header_id IN NUMBER
182 )
183 RETURN NUMBER;
184
185 FUNCTION REC_ORDER_SUBTOTALS
186 (
187 p_header_id IN NUMBER
188 )
189 RETURN NUMBER;
190
191
192 FUNCTION REC_CHARGES
193 (
194 p_header_id IN NUMBER,
195 p_charge_periodicity_code IN VARCHAR2
196 )
197 RETURN NUMBER;
198
199 FUNCTION REC_PRICE_ADJUSTMENTS
200 (
201 p_header_id IN NUMBER,
202 p_charge_periodicity_code IN VARCHAR2
203 )
204 RETURN NUMBER;
205
206
207 PROCEDURE REC_ORDER_TOTALS
208 (
209 p_header_id IN NUMBER,
210 p_charge_periodicity_code IN VARCHAR2,
211 x_subtotal OUT NOCOPY NUMBER,
212 x_discount OUT NOCOPY NUMBER,
213 x_charges OUT NOCOPY NUMBER,
214 x_tax OUT NOCOPY NUMBER ,
215 x_total OUT NOCOPY NUMBER
216 );
217
218 PROCEDURE GET_RECURRING_TOTALS
219 (
220 p_header_id IN NUMBER,
221 x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type);
222
223 PROCEDURE GET_UI_RECURRING_TOTALS
224 (
225 p_header_id IN NUMBER,
226 x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type);
227
228 PROCEDURE GET_MODEL_RECURRING_TOTALS
229 (
230 p_header_id IN NUMBER,
231 p_line_id IN NUMBER,
232 p_line_number IN NUMBER,
233 x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type);
234
235 /* Recurring totals */
236
237 --rc pviprana start
238 /*Record structure to store the recurring amounts for an order level modifier in the View Adjustments window*/
239 TYPE recurring_amount_rec_type IS RECORD
240 (
241 charge_periodicity_code VARCHAR2(3),
242 charge_periodicity_meaning VARCHAR2(25),
243 recurring_amount NUMBER
244 );
245
246 TYPE recurring_amounts_tbl_type IS TABLE OF recurring_amount_rec_type
247 INDEX BY BINARY_INTEGER;
248
249 PROCEDURE SET_ADJ_RECURRING_AMOUNTS
250 (p_header_id IN NUMBER DEFAULT NULL,
251 p_price_adjustment_id NUMBER DEFAULT NULL);
252
253 PROCEDURE GET_ADJ_RECURRING_AMOUNTS
254 (x_recurring_amounts_tbl IN OUT NOCOPY /* file.sql.39 change */ Recurring_Amounts_Tbl_Type);
255
256 --rc pviprana end
257 --rc preview/print
258 FUNCTION PRN_REC_SUBTOTALS
259 (
260 p_header_id IN NUMBER,
261 p_charge_periodicity_code IN VARCHAR2
262 )
263 RETURN NUMBER;
264
265 FUNCTION PRN_REC_TAXES
266 (
267 p_header_id IN NUMBER,
268 p_charge_periodicity_code IN VARCHAR2
269 )
270 RETURN NUMBER;
271
272 FUNCTION PRN_REC_TOTALS
273 (
274 p_header_id IN NUMBER,
275 p_charge_periodicity_code IN VARCHAR2
276 )
277 RETURN NUMBER;
278
279 END OE_OE_TOTALS_SUMMARY;