eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OE_OE_FORM_LINE_ADJ

Source


1 PACKAGE OE_OE_Form_Line_Adj AUTHID CURRENT_USER AS
2 /* $Header: OEXFLADS.pls 120.0 2005/06/01 01:13:25 appldev noship $ */
3 
4 --  Procedure : Default_Attributes
5 --
6 
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY VARCHAR2
9 
10 , x_msg_count OUT NOCOPY NUMBER
11 
12 , x_msg_data OUT NOCOPY VARCHAR2
13 
14 ,   p_header_id                     IN  NUMBER
15 ,   p_line_id			           IN  NUMBER
16 , x_price_adjustment_id OUT NOCOPY NUMBER
17 
18 , x_header_id OUT NOCOPY NUMBER
19 
20 , x_discount_id OUT NOCOPY NUMBER
21 
22 , x_discount_line_id OUT NOCOPY NUMBER
23 
24 , x_automatic_flag OUT NOCOPY VARCHAR2
25 
26 , x_percent OUT NOCOPY NUMBER
27 
28 , x_line_id OUT NOCOPY NUMBER
29 
30 , x_context OUT NOCOPY VARCHAR2
31 
32 , x_attribute1 OUT NOCOPY VARCHAR2
33 
34 , x_attribute2 OUT NOCOPY VARCHAR2
35 
36 , x_attribute3 OUT NOCOPY VARCHAR2
37 
38 , x_attribute4 OUT NOCOPY VARCHAR2
39 
40 , x_attribute5 OUT NOCOPY VARCHAR2
41 
42 , x_attribute6 OUT NOCOPY VARCHAR2
43 
44 , x_attribute7 OUT NOCOPY VARCHAR2
45 
46 , x_attribute8 OUT NOCOPY VARCHAR2
47 
48 , x_attribute9 OUT NOCOPY VARCHAR2
49 
50 , x_attribute10 OUT NOCOPY VARCHAR2
51 
52 , x_attribute11 OUT NOCOPY VARCHAR2
53 
54 , x_attribute12 OUT NOCOPY VARCHAR2
55 
56 , x_attribute13 OUT NOCOPY VARCHAR2
57 
58 , x_attribute14 OUT NOCOPY VARCHAR2
59 
60 , x_attribute15 OUT NOCOPY VARCHAR2
61 
62 , x_discount OUT NOCOPY VARCHAR2
63 
64 , x_list_header_id OUT NOCOPY NUMBER
65 
66 , x_list_line_id OUT NOCOPY NUMBER
67 
68 , x_list_line_type_code OUT NOCOPY VARCHAR2
69 
70 , x_modifier_mechanism_type_code OUT NOCOPY VARCHAR2
71 
72 , x_updated_flag OUT NOCOPY VARCHAR2
73 
74 , x_update_allowed OUT NOCOPY VARCHAR2
75 
76 , x_applied_flag OUT NOCOPY VARCHAR2
77 
78 , x_change_reason_code OUT NOCOPY VARCHAR2
79 
80 , x_change_reason_text OUT NOCOPY VARCHAR2
81 
82 , x_modified_from OUT NOCOPY VARCHAR2
83 
84 , x_modified_to OUT NOCOPY VARCHAR2
85 
86 , x_operand OUT NOCOPY NUMBER
87 
88 , x_arithmetic_operator OUT NOCOPY VARCHAR2
89 
90 , x_adjusted_amount OUT NOCOPY NUMBER
91 
92 , x_pricing_phase_id OUT NOCOPY NUMBER
93 
94 , x_list_line_no OUT NOCOPY varchar2
95 
96 , x_source_system_code OUT NOCOPY varchar2
97 
98 , x_benefit_qty OUT NOCOPY NUMBER
99 
100 , x_benefit_uom_code OUT NOCOPY varchar2
101 
102 , x_print_on_invoice_flag OUT NOCOPY varchar2
103 
104 , x_expiration_date OUT NOCOPY DATE
105 
106 , x_rebate_transaction_type_code OUT NOCOPY varchar2
107 
108 , x_rebate_transaction_reference OUT NOCOPY varchar2
109 
110 , x_rebate_payment_system_code OUT NOCOPY varchar2
111 
112 , x_redeemed_date OUT NOCOPY DATE
113 
114 , x_redeemed_flag OUT NOCOPY varchar2
115 
116 , x_accrual_flag OUT NOCOPY varchar2
117 
118 , x_invoiced_flag OUT NOCOPY varchar2
119 
120 , x_estimated_flag OUT NOCOPY varchar2
121 
122 , x_credit_or_charge_flag OUT NOCOPY varchar2
123 
124 , x_include_on_returns_flag OUT NOCOPY varchar2
125 
126 , x_charge_type_code OUT NOCOPY varchar2
127 
128 , x_charge_subtype_code OUT NOCOPY varchar2
129 
130 , x_ac_context OUT NOCOPY VARCHAR2
131 
132 , x_ac_attribute1 OUT NOCOPY VARCHAR2
133 
134 , x_ac_attribute2 OUT NOCOPY VARCHAR2
135 
136 , x_ac_attribute3 OUT NOCOPY VARCHAR2
137 
138 , x_ac_attribute4 OUT NOCOPY VARCHAR2
139 
140 , x_ac_attribute5 OUT NOCOPY VARCHAR2
141 
142 , x_ac_attribute6 OUT NOCOPY VARCHAR2
143 
144 , x_ac_attribute7 OUT NOCOPY VARCHAR2
145 
146 , x_ac_attribute8 OUT NOCOPY VARCHAR2
147 
148 , x_ac_attribute9 OUT NOCOPY VARCHAR2
149 
150 , x_ac_attribute10 OUT NOCOPY VARCHAR2
151 
152 , x_ac_attribute11 OUT NOCOPY VARCHAR2
153 
154 , x_ac_attribute12 OUT NOCOPY VARCHAR2
155 
156 , x_ac_attribute13 OUT NOCOPY VARCHAR2
157 
158 , x_ac_attribute14 OUT NOCOPY VARCHAR2
159 
160 , x_ac_attribute15 OUT NOCOPY VARCHAR2
161 
162 --uom begin
163 , x_operand_per_pqty OUT NOCOPY NUMBER
164 
165 , x_adjusted_amount_per_pqty OUT NOCOPY NUMBER
166 
167 --uom end
168 );
169 
170 --  Procedure   :   Change_Attributes
171 --
172 
173 PROCEDURE Change_Attributes
174 ( x_return_status OUT NOCOPY VARCHAR2
175 
176 , x_msg_count OUT NOCOPY NUMBER
177 
178 , x_msg_data OUT NOCOPY VARCHAR2
179 
180 ,   p_price_adjustment_id           IN  NUMBER
181 ,   p_attr_id                       IN  NUMBER
182 ,   p_attr_value1                   IN  VARCHAR2
183 ,   p_attr_value2                   IN  VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
184 ,   p_context                       IN  VARCHAR2
185 ,   p_attribute1                    IN  VARCHAR2
186 ,   p_attribute2                    IN  VARCHAR2
187 ,   p_attribute3                    IN  VARCHAR2
188 ,   p_attribute4                    IN  VARCHAR2
189 ,   p_attribute5                    IN  VARCHAR2
190 ,   p_attribute6                    IN  VARCHAR2
191 ,   p_attribute7                    IN  VARCHAR2
192 ,   p_attribute8                    IN  VARCHAR2
193 ,   p_attribute9                    IN  VARCHAR2
194 ,   p_attribute10                   IN  VARCHAR2
195 ,   p_attribute11                   IN  VARCHAR2
196 ,   p_attribute12                   IN  VARCHAR2
197 ,   p_attribute13                   IN  VARCHAR2
198 ,   p_attribute14                   IN  VARCHAR2
199 ,   p_attribute15                   IN  VARCHAR2
200 ,   p_ac_context                    IN  VARCHAR2
201 ,   p_ac_attribute1                 IN  VARCHAR2
202 ,   p_ac_attribute2                 IN  VARCHAR2
203 ,   p_ac_attribute3                 IN  VARCHAR2
204 ,   p_ac_attribute4                 IN  VARCHAR2
205 ,   p_ac_attribute5                 IN  VARCHAR2
206 ,   p_ac_attribute6                 IN  VARCHAR2
207 ,   p_ac_attribute7                 IN  VARCHAR2
208 ,   p_ac_attribute8                 IN  VARCHAR2
209 ,   p_ac_attribute9                 IN  VARCHAR2
210 ,   p_ac_attribute10                IN  VARCHAR2
211 ,   p_ac_attribute11                IN  VARCHAR2
212 ,   p_ac_attribute12                IN  VARCHAR2
213 ,   p_ac_attribute13                IN  VARCHAR2
214 ,   p_ac_attribute14                IN  VARCHAR2
215 ,   p_ac_attribute15                IN  VARCHAR2
216 , x_price_adjustment_id OUT NOCOPY NUMBER
217 
218 , x_header_id OUT NOCOPY NUMBER
219 
220 , x_discount_id OUT NOCOPY NUMBER
221 
222 , x_discount_line_id OUT NOCOPY NUMBER
223 
224 , x_automatic_flag OUT NOCOPY VARCHAR2
225 
226 , x_percent OUT NOCOPY NUMBER
227 
228 , x_line_id OUT NOCOPY NUMBER
229 
230 , x_context OUT NOCOPY VARCHAR2
231 
232 , x_attribute1 OUT NOCOPY VARCHAR2
233 
234 , x_attribute2 OUT NOCOPY VARCHAR2
235 
236 , x_attribute3 OUT NOCOPY VARCHAR2
237 
238 , x_attribute4 OUT NOCOPY VARCHAR2
239 
240 , x_attribute5 OUT NOCOPY VARCHAR2
241 
242 , x_attribute6 OUT NOCOPY VARCHAR2
243 
244 , x_attribute7 OUT NOCOPY VARCHAR2
245 
246 , x_attribute8 OUT NOCOPY VARCHAR2
247 
248 , x_attribute9 OUT NOCOPY VARCHAR2
249 
250 , x_attribute10 OUT NOCOPY VARCHAR2
251 
252 , x_attribute11 OUT NOCOPY VARCHAR2
253 
254 , x_attribute12 OUT NOCOPY VARCHAR2
255 
256 , x_attribute13 OUT NOCOPY VARCHAR2
257 
258 , x_attribute14 OUT NOCOPY VARCHAR2
259 
260 , x_attribute15 OUT NOCOPY VARCHAR2
261 
262 , x_ac_context OUT NOCOPY VARCHAR2
263 
264 , x_ac_attribute1 OUT NOCOPY VARCHAR2
265 
266 , x_ac_attribute2 OUT NOCOPY VARCHAR2
267 
268 , x_ac_attribute3 OUT NOCOPY VARCHAR2
269 
270 , x_ac_attribute4 OUT NOCOPY VARCHAR2
271 
272 , x_ac_attribute5 OUT NOCOPY VARCHAR2
273 
274 , x_ac_attribute6 OUT NOCOPY VARCHAR2
275 
276 , x_ac_attribute7 OUT NOCOPY VARCHAR2
277 
278 , x_ac_attribute8 OUT NOCOPY VARCHAR2
279 
280 , x_ac_attribute9 OUT NOCOPY VARCHAR2
281 
282 , x_ac_attribute10 OUT NOCOPY VARCHAR2
283 
284 , x_ac_attribute11 OUT NOCOPY VARCHAR2
285 
286 , x_ac_attribute12 OUT NOCOPY VARCHAR2
287 
288 , x_ac_attribute13 OUT NOCOPY VARCHAR2
289 
290 , x_ac_attribute14 OUT NOCOPY VARCHAR2
291 
292 , x_ac_attribute15 OUT NOCOPY VARCHAR2
293 
294 , x_discount OUT NOCOPY VARCHAR2
295 
296 ,   p_enforce_fixed_price	      IN  VARCHAR2
297 
298 -- New code Added :: New columns
299 , x_list_header_id OUT NOCOPY NUMBER
300 
301 , x_list_line_id OUT NOCOPY NUMBER
302 
303 , x_list_line_type_code OUT NOCOPY VARCHAR2
304 
305 , x_modifier_mechanism_type_code OUT NOCOPY VARCHAR2
306 
307 , x_updated_flag OUT NOCOPY VARCHAR2
308 
309 , x_update_allowed OUT NOCOPY VARCHAR2
310 
311 , x_applied_flag OUT NOCOPY VARCHAR2
312 
313 , x_change_reason_code OUT NOCOPY VARCHAR2
314 
315 , x_change_reason_text OUT NOCOPY VARCHAR2
316 
317 , x_modified_from OUT NOCOPY VARCHAR2
318 
319 , x_modified_to OUT NOCOPY VARCHAR2
320 
321 , x_operand OUT NOCOPY NUMBER
322 
323 , x_arithmetic_operator OUT NOCOPY varchar2
324 
325 , x_adjusted_amount OUT NOCOPY NUMBER
326 
327 , x_pricing_phase_id OUT NOCOPY NUMBER
328 
329 , x_list_line_no OUT NOCOPY varchar2
330 
331 , x_source_system_code OUT NOCOPY varchar2
332 
333 , x_benefit_qty OUT NOCOPY NUMBER
334 
335 , x_benefit_uom_code OUT NOCOPY varchar2
336 
337 , x_print_on_invoice_flag OUT NOCOPY varchar2
338 
339 , x_expiration_date OUT NOCOPY DATE
340 
341 , x_rebate_transaction_type_code OUT NOCOPY varchar2
342 
343 , x_rebate_transaction_reference OUT NOCOPY varchar2
344 
345 , x_rebate_payment_system_code OUT NOCOPY varchar2
346 
347 , x_redeemed_date OUT NOCOPY DATE
348 
349 , x_redeemed_flag OUT NOCOPY varchar2
350 
351 , x_accrual_flag OUT NOCOPY varchar2
352 
353 , x_invoiced_flag OUT NOCOPY varchar2
354 
355 , x_estimated_flag OUT NOCOPY varchar2
356 
357 , x_credit_or_charge_flag OUT NOCOPY varchar2
358 
359 , x_include_on_returns_flag OUT NOCOPY varchar2
360 
361 , x_charge_type_code OUT NOCOPY varchar2
362 
363 , x_charge_subtype_code OUT NOCOPY varchar2
364 
365 --uom begin
366 , x_operand_per_pqty OUT NOCOPY NUMBER
367 
368 , x_adjusted_amount_per_pqty OUT NOCOPY NUMBER
369 
370 --uom end
371 );
372 
373 --  Procedure       Validate_And_Write
374 --
375 
376 PROCEDURE Validate_And_Write
377 ( x_return_status OUT NOCOPY VARCHAR2
378 
379 , x_msg_count OUT NOCOPY NUMBER
380 
381 , x_msg_data OUT NOCOPY VARCHAR2
382 
383 ,   p_price_adjustment_id           IN  NUMBER
384 , x_creation_date OUT NOCOPY DATE
385 
386 , x_created_by OUT NOCOPY NUMBER
387 
388 , x_last_update_date OUT NOCOPY DATE
389 
390 , x_last_updated_by OUT NOCOPY NUMBER
391 
392 , x_last_update_login OUT NOCOPY NUMBER
393 
394 ,   p_ok_flag			    		 IN VARCHAR2
395 , x_program_id OUT NOCOPY NUMBER
396 
397 , x_program_application_id OUT NOCOPY NUMBER
398 
399 , x_program_update_date OUT NOCOPY DATE
400 
401 , x_request_id OUT NOCOPY NUMBER
402 
403 , x_lock_control OUT NOCOPY NUMBER
404 
405 );
406 
407 --  Procedure       Delete_Row
408 --
409 
410 PROCEDURE Delete_Row
411 ( x_return_status OUT NOCOPY VARCHAR2
412 
413 , x_msg_count OUT NOCOPY NUMBER
414 
415 , x_msg_data OUT NOCOPY VARCHAR2
416 
417 ,   p_price_adjustment_id           IN  NUMBER
418 , p_change_reason_code            IN  VARCHAR2 Default Null
419 , p_change_comments               IN  VARCHAR2 Default Null
420 );
421 
422 --  Procedure       Process_Entity
423 --
424 
425 PROCEDURE Process_Delayed_Requests
426 ( x_return_status OUT NOCOPY VARCHAR2
427 
428 , x_msg_count OUT NOCOPY NUMBER
429 
430 , x_msg_data OUT NOCOPY VARCHAR2
431 
432 ,   p_header_id			    IN  NUMBER
433 ,   p_line_id			    IN  NUMBER
434 );
435 
436 
437 --  procedure       replace_attributes
438 --  this is a specialized function to replace a price_adjustment
439 --  with a new one. this function is exclusively for internal use only.
440 --  it presently only being called from OEXOELIN when modifying
441 --  selling_price
442 
443 PROCEDURE REPLACE_ATTRIBUTES
444 (x_return_status OUT NOCOPY VARCHAR2,
445 
446 x_msg_count OUT NOCOPY NUMBER,
447 
448 x_msg_data OUT NOCOPY VARCHAR2,
449 
450    p_price_adjustment_id	IN  NUMBER,
451    p_adjusted_amount	IN  NUMBER,
452    p_adjusted_amount_per_pqty	IN  NUMBER DEFAULT NULL,
456    p_applied_flag		IN  VARCHAR2,
453    p_arithmetic_operator	IN  VARCHAR2,
454    p_operand			IN  NUMBER,
455    p_operand_per_pqty			IN  NUMBER DEFAULT NULL,
457    p_updated_flag		IN  VARCHAR2,
458    p_change_reason_code         In  Varchar2:=NULL,
459    p_change_reason_text         In  Varchar2:=NULL
460    );
461 
462 --  Procedure       lock_Row
463 --
464 
465 PROCEDURE Lock_Row
466 ( x_return_status OUT NOCOPY VARCHAR2
467 
468 , x_msg_count OUT NOCOPY NUMBER
469 
470 , x_msg_data OUT NOCOPY VARCHAR2
471 
472 ,   p_price_adjustment_id           IN  NUMBER
473 ,   p_lock_control		           IN  NUMBER
474 );
475 
476 --Manual Begin
477 Procedure Insert_Row(p_line_adj_rec In Oe_Order_Pub.line_adj_rec_type
478 ,x_return_status OUT NOCOPY VARCHAR2
479 
480 ,x_msg_count OUT NOCOPY NUMBER
481 
482 ,x_msg_data OUT NOCOPY VARCHAR2
483 
484 ,x_price_adjustment_id OUT NOCOPY NUMBER);
485 
486 --Manual End
487 
488 
489 END OE_OE_Form_Line_Adj;