[Home] [Help]
PACKAGE: APPS.OE_HEADER_ADJ_UTIL
Source
1 PACKAGE OE_Header_Adj_Util AS
2 /* $Header: OEXUHADS.pls 120.1.12010000.1 2008/07/25 07:55:56 appldev ship $ */
3
4 -- Attributes global constants
5 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
6 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
7 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
8 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
9 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
10 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
11 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
12 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
13 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
14 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
15 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
16 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
17 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
18 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
19 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
20 G_AUTOMATIC CONSTANT NUMBER := 16;
21 G_CONTEXT CONSTANT NUMBER := 17;
22 G_CREATED_BY CONSTANT NUMBER := 18;
23 G_CREATION_DATE CONSTANT NUMBER := 19;
24 G_DISCOUNT CONSTANT NUMBER := 20;
25 G_DISCOUNT_LINE CONSTANT NUMBER := 21;
26 G_HEADER CONSTANT NUMBER := 22;
27 G_LAST_UPDATED_BY CONSTANT NUMBER := 23;
28 G_LAST_UPDATE_DATE CONSTANT NUMBER := 24;
29 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 25;
30 G_LINE CONSTANT NUMBER := 26;
31 G_PERCENT CONSTANT NUMBER := 27;
32 G_PRICE_ADJUSTMENT CONSTANT NUMBER := 28;
33 G_PROGRAM_APPLICATION CONSTANT NUMBER := 29;
34 G_PROGRAM CONSTANT NUMBER := 30;
35 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 31;
36 G_REQUEST CONSTANT NUMBER := 32;
37 G_ORIG_SYS_DISCOUNT_REF CONSTANT NUMBER := 33;
38 G_CHANGE_SEQUENCE_ID CONSTANT NUMBER := 34;
39 G_MAX_ATTR_ID CONSTANT NUMBER := 35;
40 G_LIST_HEADER_ID CONSTANT NUMBER := 36;
41 G_LIST_LINE_ID CONSTANT NUMBER := 37;
42 G_LIST_LINE_TYPE_CODE CONSTANT NUMBER := 38;
43 G_MODIFIER_MECHANISM_TYPE_CODE CONSTANT NUMBER := 39;
44 G_MODIFIED_FROM CONSTANT NUMBER := 40;
45 G_MODIFIED_TO CONSTANT NUMBER := 41;
46 G_UPDATED_FLAG CONSTANT NUMBER := 42;
47 G_UPDATE_ALLOWED CONSTANT NUMBER := 43;
48 G_APPLIED_FLAG CONSTANT NUMBER := 44;
49 G_CHANGE_REASON_CODE CONSTANT NUMBER := 45;
50 G_CHANGE_REASON_TEXT CONSTANT NUMBER := 46;
51 G_OPERAND CONSTANT NUMBER := 47;
52 G_ARITHMETIC_OPERATOR CONSTANT NUMBER := 48;
53 G_COST_ID CONSTANT NUMBER := 49;
54 G_TAX_CODE CONSTANT NUMBER := 50;
55 G_TAX_EXEMPT_FLAG CONSTANT NUMBER := 51;
56 G_TAX_EXEMPT_NUMBER CONSTANT NUMBER := 52;
57 G_TAX_EXEMPT_REASON_CODE CONSTANT NUMBER := 53;
58 G_PARENT_ADJUSTMENT_ID CONSTANT NUMBER := 54;
59 G_INVOICED_FLAG CONSTANT NUMBER := 55;
60 G_ESTIMATED_FLAG CONSTANT NUMBER := 56;
61 G_INC_IN_SALES_PERFORMANCE CONSTANT NUMBER := 57;
62 G_SPLIT_ACTION_CODE CONSTANT NUMBER := 58;
63 G_ADJUSTED_AMOUNT CONSTANT NUMBER := 59;
64 G_PRICING_PHASE_ID CONSTANT NUMBER := 60;
65 G_CHARGE_TYPE_CODE CONSTANT NUMBER := 61;
66 G_CHARGE_SUBTYPE_CODE CONSTANT NUMBER := 62;
67 G_LIST_LINE_NO CONSTANT NUMBER := 63;
68 G_SOURCE_SYSTEM_CODE CONSTANT NUMBER := 64;
69 G_BENEFIT_QTY CONSTANT NUMBER := 65;
70 G_BENEFIT_UOM_CODE CONSTANT NUMBER := 66;
71 G_PRINT_ON_INVOICE_FLAG CONSTANT NUMBER := 67;
72 G_EXPIRATION_DATE CONSTANT NUMBER := 68;
73 G_REBATE_TRANSACTION_TYPE_CODE CONSTANT NUMBER := 69;
74 G_REBATE_TRANSACTION_REFERENCE CONSTANT NUMBER := 70;
75 G_REBATE_PAYMENT_SYSTEM_CODE CONSTANT NUMBER := 71;
76 G_REDEEMED_DATE CONSTANT NUMBER := 72;
77 G_REDEEMED_FLAG CONSTANT NUMBER := 73;
78 G_ACCRUAL_FLAG CONSTANT NUMBER := 74;
79 G_range_break_quantity CONSTANT NUMBER := 75;
80 G_accrual_conversion_rate CONSTANT NUMBER := 76;
81 G_pricing_group_sequence CONSTANT NUMBER := 77;
82 G_modifier_level_code CONSTANT NUMBER := 78;
83 G_price_break_type_code CONSTANT NUMBER := 79;
84 G_substitution_attribute CONSTANT NUMBER := 80;
85 G_proration_type_code CONSTANT NUMBER := 81;
86 G_CREDIT_OR_CHARGE_FLAG CONSTANT NUMBER := 82;
87 G_INCLUDE_ON_RETURNS_FLAG CONSTANT NUMBER := 83;
88 G_AC_CONTEXT CONSTANT NUMBER := 84;
89 G_AC_ATTRIBUTE1 CONSTANT NUMBER := 85;
90 G_AC_ATTRIBUTE2 CONSTANT NUMBER := 86;
91 G_AC_ATTRIBUTE3 CONSTANT NUMBER := 87;
92 G_AC_ATTRIBUTE4 CONSTANT NUMBER := 88;
93 G_AC_ATTRIBUTE5 CONSTANT NUMBER := 89;
94 G_AC_ATTRIBUTE6 CONSTANT NUMBER := 90;
95 G_AC_ATTRIBUTE7 CONSTANT NUMBER := 91;
96 G_AC_ATTRIBUTE8 CONSTANT NUMBER := 92;
97 G_AC_ATTRIBUTE9 CONSTANT NUMBER := 93;
98 G_AC_ATTRIBUTE10 CONSTANT NUMBER := 94;
99 G_AC_ATTRIBUTE11 CONSTANT NUMBER := 95;
100 G_AC_ATTRIBUTE12 CONSTANT NUMBER := 96;
101 G_AC_ATTRIBUTE13 CONSTANT NUMBER := 97;
102 G_AC_ATTRIBUTE14 CONSTANT NUMBER := 98;
103 G_AC_ATTRIBUTE15 CONSTANT NUMBER := 99;
104 --uom begin
105 --G_OPERAND_PER_PQTY CONSTANT NUMBER := 100;
106 --G_ADJUSTED_AMOUNT_PER_PQTY CONSTANT NUMBER := 101;
107 --uom end
108
109 --Manual begin
110 G_OVERRIDE_ALLOWED_FLAG CONSTANT NUMBER := 106;
111 --Manual end
112 G_OPERAND_PER_PQTY CONSTANT NUMBER := 107;
113 G_ADJUSTED_AMOUNT_PER_PQTY CONSTANT NUMBER := 108;
114 G_INVOICED_AMOUNT CONSTANT NUMBER := 109;
115
116 type line_adjustments_rec_type is record
117 (price_adjustment_id number :=null,
118 adjustment_name varchar2(240) :=null,
119 adjustment_description varchar2(2000) := null, --Enhancement 3816014
120 list_line_no varchar2(240) :=null,
121 adjustment_type_code varchar2(30) :=null,
122 operand number :=null,
123 arithmetic_operator varchar2(30) :=null,
124 unit_discount_amount number := null
125 );
126
127 Type line_adjustments_tab_type is Table of line_adjustments_rec_type
128 index by binary_integer;
129
130 procedure get_line_adjustments
131 (p_header_id number
132 ,p_line_id number
133 ,x_line_adjustments out nocopy line_adjustments_tab_type
134
135 );
136
137 FUNCTION G_MISS_OE_AK_HEADER_ADJ_REC
138 RETURN OE_AK_HEADER_PRCADJS_V%ROWTYPE;
139
140 PROCEDURE API_Rec_To_Rowtype_Rec
141 ( p_HEADER_ADJ_rec IN OE_Order_PUB.HEADER_ADJ_Rec_Type
142 , x_rowtype_rec OUT nocopy OE_AK_HEADER_PRCADJS_V%ROWTYPE
143 );
144
145 PROCEDURE Rowtype_Rec_To_API_Rec
146 ( p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
147 , x_api_rec OUT nocopy OE_Order_PUB.HEADER_ADJ_Rec_Type
148 );
149
150
151 -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
152
153 PROCEDURE Clear_Dependent_Attr
154 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
155 , p_x_Header_Adj_rec IN OUT NOCOPY OE_AK_HEADER_PRCADJS_V%ROWTYPE
156 , p_old_Header_Adj_rec IN OE_AK_HEADER_PRCADJS_V%ROWTYPE :=
157 G_MISS_OE_AK_HEADER_ADJ_REC
158 );
159
160 -- Procedure Clear_Dependent_Attr
161
162 PROCEDURE Clear_Dependent_Attr
163 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
164 , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
165 , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
166 OE_Order_PUB.G_MISS_HEADER_ADJ_REC
167 --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
168 );
169
170 --Bug 4060297
171 Procedure log_request_for_margin(p_header_id in number);
172
173
174 -- Procedure Apply_Attribute_Changes
175
176 PROCEDURE Apply_Attribute_Changes
177 ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
178 , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
179 OE_Order_PUB.G_MISS_HEADER_ADJ_REC
180 --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
181 );
182
183 -- Procedure Complete_Record
184
185 PROCEDURE Complete_Record
186 ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
187 , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
188 );
189
190 -- Procedure Convert_Miss_To_Null
191
192 PROCEDURE Convert_Miss_To_Null
193 ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
194 );
195
196 -- Procedure Update_Row
197
198 PROCEDURE Update_Row
199 ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
200 );
201
202 -- Procedure Insert_Row
203
204 PROCEDURE Insert_Row
205 ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
206 );
207
208 -- Procedure Delete_Row
209
210 PROCEDURE Delete_Row
211 ( p_price_adjustment_id IN NUMBER :=
212 FND_API.G_MISS_NUM
213 , p_header_id IN NUMBER :=
214 FND_API.G_MISS_NUM
215 );
216
217 -- Procedure Delete_Header_Charges
218
219 Procedure Delete_Header_Charges
220 (
221 p_header_id IN Number
222 );
223
224 -- Procedure Query_Row
225
226 PROCEDURE Query_Row
227 ( p_price_adjustment_id IN NUMBER
228 , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
229 );
230
231 -- Procedure Query_Rows
232
233 PROCEDURE Query_Rows
234 ( p_price_adjustment_id IN NUMBER :=
235 FND_API.G_MISS_NUM
236 , p_header_id IN NUMBER :=
237 FND_API.G_MISS_NUM
238 , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
239 );
240
241 -- Procedure lock_Row
242
243 PROCEDURE Lock_Row
244 ( x_return_status OUT NOCOPY VARCHAR2
245
246 , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
247 -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
248 , p_price_adjustment_id IN NUMBER
249 := FND_API.G_MISS_NUM
250 );
251
252 -- Procedure lock_Rows
253 PROCEDURE Lock_Rows
254 ( p_price_adjustment_id IN NUMBER
255 := FND_API.G_MISS_NUM
256 , p_header_id IN NUMBER
257 := FND_API.G_MISS_NUM
258 , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
259 , x_return_status OUT NOCOPY VARCHAR2
260
261 );
262
263 -- Function Get_Values
264
265 FUNCTION Get_Values
266 ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
267 , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
268 OE_Order_PUB.G_MISS_HEADER_ADJ_REC
269 ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type;
270
271 -- Procedure Get_Ids
272
273 PROCEDURE Get_Ids
274 ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
275 , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
276 );
277
278
279 PROCEDURE Log_Adj_Requests
280 ( x_return_status OUT NOCOPY VARCHAR2
281
282 , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
283 , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
284 , p_delete_flag IN BOOLEAN DEFAULT FALSE
285 );
286
287
288 FUNCTION get_adj_total
289 ( p_header_id IN NUMBER := NULL
290 , p_line_id IN NUMBER := NULL
291 )
292 RETURN NUMBER;
293
294 /* Start AuditTrail */
295 PROCEDURE Pre_Write_Process
296 ( p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
297 p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) ;
298 /* End Audit Trail */
299
300 /* Fix for 1559906: New Procedure to Copy Freight Charges */
301
302 PROCEDURE copy_freight_charges
303 ( p_from_header_id IN NUMBER
304 , p_to_header_id IN NUMBER
305 , p_to_order_category IN VARCHAR2
306 , x_return_status OUT NOCOPY VARCHAR2
307
308 );
309
310 /* Fix for 2170086: New Procedure to Copy Header Adjustments */
311
312 PROCEDURE copy_header_adjustments
313 ( p_from_header_id IN NUMBER
314 , p_to_header_id IN NUMBER
315 , p_to_order_category IN VARCHAR2
316 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
317 );
318
319 --Recurring CHarges
320 FUNCTION get_rec_adj_total
321 ( p_header_id IN NUMBER := NULL
322 , p_line_id IN NUMBER := NULL
323 , p_charge_periodicity_code IN VARCHAR2
324 )
325 RETURN NUMBER;
326 --Recurring CHarges
327
328 --rc pviprana this function will return recurring amount given the order level modifier and periodicity
329 FUNCTION get_rec_order_adj_total
330 ( p_header_id IN NUMBER DEFAULT NULL
331 , p_price_adjustment_id IN NUMBER DEFAULT NULL
332 , p_charge_periodicity_code IN VARCHAR2 DEFAULT NULL
333 ) RETURN NUMBER;
334
335
336 END OE_Header_Adj_Util;