[Home] [Help]
PACKAGE BODY: APPS.ARP_LOCK_LINE_COVER
Source
1 PACKAGE BODY ARP_LOCK_LINE_COVER AS
2 /* $Header: ARTCTLLB.pls 120.3 2005/10/07 18:32:40 ralat ship $ */
3
4 /*===========================================================================+
5 | PROCEDURE |
6 | lock_compare_cover |
7 | |
8 | DESCRIPTION |
9 | Converts column parameters to a line record and |
10 | lockss a line line. |
11 | |
12 | SCOPE - PUBLIC |
13 | |
14 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
15 | arp_util.debug |
16 | |
17 | ARGUMENTS : IN: |
18 | p_customer_trx_line_id |
19 | p_customer_trx_id |
20 | p_line_number |
21 | p_line_type |
22 | p_quantity_credited |
23 | p_quantity_invoiced |
24 | p_quantity_ordered |
25 | p_unit_selling_price |
26 | p_unit_standard_price |
27 | p_extended_amount |
28 | p_memo_line_id |
29 | p_inventory_item_id |
30 | p_item_exception_rate_id |
31 | p_description |
32 | p_item_context |
33 | p_initial_customer_trx_line_id |
34 | p_link_to_cust_trx_line_id |
35 | p_previous_customer_trx_id |
36 | p_prev_customer_trx_line_id |
37 | p_accounting_rule_duration |
38 | p_accounting_rule_id |
39 | p_rule_start_date |
40 | p_autorule_complete_flag |
41 | p_autorule_duration_processed |
42 | p_reason_code |
43 | p_last_period_to_credit |
44 | p_sales_order |
45 | p_sales_order_date |
46 | p_sales_order_line |
47 | p_sales_order_revision |
48 | p_sales_order_source |
49 | p_vat_tax_id |
50 | p_tax_exempt_flag |
51 | p_sales_tax_id |
52 | p_location_segment_id |
53 | p_tax_exempt_number |
54 | p_tax_exempt_reason_code |
55 | p_tax_vendor_return_code |
56 | p_taxable_flag |
57 | p_tax_exemption_id |
58 | p_tax_precedence |
59 | p_tax_rate |
60 | p_uom_code |
61 | p_autotax |
62 | p_movement_id |
63 | p_default_ussgl_trx_code |
64 | p_default_ussgl_trx_code_cntxt |
65 | p_interface_line_context |
66 | p_interface_line_attribute1 |
67 | p_interface_line_attribute2 |
68 | p_interface_line_attribute3 |
69 | p_interface_line_attribute4 |
70 | p_interface_line_attribute5 |
71 | p_interface_line_attribute6 |
72 | p_interface_line_attribute7 |
73 | p_interface_line_attribute8 |
74 | p_interface_line_attribute9 |
75 | p_interface_line_attribute10 |
76 | p_interface_line_attribute11 |
77 | p_interface_line_attribute12 |
78 | p_interface_line_attribute13 |
79 | p_interface_line_attribute14 |
80 | p_interface_line_attribute15 |
81 | p_attribute_category |
82 | p_attribute1 |
83 | p_attribute2 |
84 | p_attribute3 |
85 | p_attribute4 |
86 | p_attribute5 |
87 | p_attribute6 |
88 | p_attribute7 |
89 | p_attribute8 |
90 | p_attribute9 |
91 | p_attribute10 |
92 | p_attribute11 |
93 | p_attribute12 |
94 | p_attribute13 |
95 | p_attribute14 |
96 | p_attribute15 |
97 | p_warehouse_id |
98 | p_rule_end_date |
99 | OUT: |
100 | None |
101 | IN/ OUT: |
102 | None |
103 | |
104 | RETURNS : NONE |
105 | |
106 | NOTES |
107 | |
108 | MODIFICATION HISTORY |
109 | 01-DEC-95 Martin Johnson Created |
110 | |
111 | Rel 11.5 Changes: |
112 | 10-JAN-99 Saloni Shah added warehouse_id |
113 +===========================================================================*/
114
115 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
116
117 PROCEDURE lock_compare_cover(
118 p_customer_trx_line_id IN
119 ra_customer_trx_lines.customer_trx_line_id%type,
120 p_customer_trx_id IN
121 ra_customer_trx_lines.customer_trx_id%type,
122 p_line_number IN
123 ra_customer_trx_lines.line_number%type,
124 p_line_type IN
125 ra_customer_trx_lines.line_type%type,
126 p_quantity_credited IN
127 ra_customer_trx_lines.quantity_credited%type,
128 p_quantity_invoiced IN
129 ra_customer_trx_lines.quantity_invoiced%type,
130 p_quantity_ordered IN
131 ra_customer_trx_lines.quantity_ordered%type,
132 p_gross_unit_selling_price IN
133 ra_customer_trx_lines.unit_selling_price%type,
134 p_unit_standard_price IN
135 ra_customer_trx_lines.unit_standard_price%type,
136 p_gross_extended_amount IN
137 ra_customer_trx_lines.extended_amount%type,
138 p_memo_line_id IN
139 ra_customer_trx_lines.memo_line_id%type,
140 p_inventory_item_id IN
141 ra_customer_trx_lines.inventory_item_id%type,
142 p_item_exception_rate_id IN
143 ra_customer_trx_lines.item_exception_rate_id%type,
144 p_description IN
145 ra_customer_trx_lines.description%type,
146 p_item_context IN
147 ra_customer_trx_lines.item_context%type,
148 p_initial_customer_trx_line_id IN
149 ra_customer_trx_lines.initial_customer_trx_line_id%type,
150 p_link_to_cust_trx_line_id IN
151 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
152 p_previous_customer_trx_id IN
153 ra_customer_trx_lines.previous_customer_trx_id%type,
154 p_prev_customer_trx_line_id IN
155 ra_customer_trx_lines.previous_customer_trx_line_id%type,
156 p_accounting_rule_duration IN
157 ra_customer_trx_lines.accounting_rule_duration%type,
158 p_accounting_rule_id IN
159 ra_customer_trx_lines.accounting_rule_id%type,
160 p_rule_start_date IN
161 ra_customer_trx_lines.rule_start_date%type,
162 p_autorule_complete_flag IN
163 ra_customer_trx_lines.autorule_complete_flag%type,
164 p_autorule_duration_processed IN
165 ra_customer_trx_lines.autorule_duration_processed%type,
166 p_reason_code IN
167 ra_customer_trx_lines.reason_code%type,
168 p_last_period_to_credit IN
169 ra_customer_trx_lines.last_period_to_credit%type,
170 p_sales_order IN
171 ra_customer_trx_lines.sales_order%type,
172 p_sales_order_date IN
173 ra_customer_trx_lines.sales_order_date%type,
174 p_sales_order_line IN
175 ra_customer_trx_lines.sales_order_line%type,
176 p_sales_order_revision IN
177 ra_customer_trx_lines.sales_order_revision%type,
178 p_sales_order_source IN
179 ra_customer_trx_lines.sales_order_source%type,
180 p_vat_tax_id IN
181 ra_customer_trx_lines.vat_tax_id%type,
182 p_tax_exempt_flag IN
183 ra_customer_trx_lines.tax_exempt_flag%type,
184 p_sales_tax_id IN
185 ra_customer_trx_lines.sales_tax_id%type,
186 p_location_segment_id IN
187 ra_customer_trx_lines.location_segment_id%type,
188 p_tax_exempt_number IN
189 ra_customer_trx_lines.tax_exempt_number%type,
190 p_tax_exempt_reason_code IN
191 ra_customer_trx_lines.tax_exempt_reason_code%type,
192 p_tax_vendor_return_code IN
193 ra_customer_trx_lines.tax_vendor_return_code%type,
194 p_taxable_flag IN
195 ra_customer_trx_lines.taxable_flag%type,
196 p_tax_exemption_id IN
197 ra_customer_trx_lines.tax_exemption_id%type,
198 p_tax_precedence IN
199 ra_customer_trx_lines.tax_precedence%type,
200 p_tax_rate IN
201 ra_customer_trx_lines.tax_rate%type,
202 p_uom_code IN
203 ra_customer_trx_lines.uom_code%type,
204 p_autotax IN
205 ra_customer_trx_lines.autotax%type,
206 p_movement_id IN
207 ra_customer_trx_lines.movement_id%type,
208 p_default_ussgl_trx_code IN
209 ra_customer_trx_lines.default_ussgl_transaction_code%type,
210 p_default_ussgl_trx_code_cntxt IN
211 ra_customer_trx_lines.default_ussgl_trx_code_context%type,
212 p_interface_line_context IN
213 ra_customer_trx_lines.interface_line_context%type,
214 p_interface_line_attribute1 IN
215 ra_customer_trx_lines.interface_line_attribute1%type,
216 p_interface_line_attribute2 IN
217 ra_customer_trx_lines.interface_line_attribute2%type,
218 p_interface_line_attribute3 IN
219 ra_customer_trx_lines.interface_line_attribute3%type,
220 p_interface_line_attribute4 IN
221 ra_customer_trx_lines.interface_line_attribute4%type,
222 p_interface_line_attribute5 IN
223 ra_customer_trx_lines.interface_line_attribute5%type,
224 p_interface_line_attribute6 IN
225 ra_customer_trx_lines.interface_line_attribute6%type,
226 p_interface_line_attribute7 IN
227 ra_customer_trx_lines.interface_line_attribute7%type,
228 p_interface_line_attribute8 IN
229 ra_customer_trx_lines.interface_line_attribute8%type,
230 p_interface_line_attribute9 IN
231 ra_customer_trx_lines.interface_line_attribute9%type,
232 p_interface_line_attribute10 IN
233 ra_customer_trx_lines.interface_line_attribute10%type,
234 p_interface_line_attribute11 IN
235 ra_customer_trx_lines.interface_line_attribute11%type,
236 p_interface_line_attribute12 IN
237 ra_customer_trx_lines.interface_line_attribute12%type,
238 p_interface_line_attribute13 IN
239 ra_customer_trx_lines.interface_line_attribute13%type,
240 p_interface_line_attribute14 IN
241 ra_customer_trx_lines.interface_line_attribute14%type,
242 p_interface_line_attribute15 IN
243 ra_customer_trx_lines.interface_line_attribute15%type,
244 p_attribute_category IN
245 ra_customer_trx_lines.attribute_category%type,
246 p_attribute1 IN
247 ra_customer_trx_lines.attribute1%type,
248 p_attribute2 IN
249 ra_customer_trx_lines.attribute2%type,
250 p_attribute3 IN
251 ra_customer_trx_lines.attribute3%type,
252 p_attribute4 IN
253 ra_customer_trx_lines.attribute4%type,
254 p_attribute5 IN
255 ra_customer_trx_lines.attribute5%type,
256 p_attribute6 IN
257 ra_customer_trx_lines.attribute6%type,
258 p_attribute7 IN
259 ra_customer_trx_lines.attribute7%type,
260 p_attribute8 IN
261 ra_customer_trx_lines.attribute8%type,
262 p_attribute9 IN
263 ra_customer_trx_lines.attribute9%type,
264 p_attribute10 IN
265 ra_customer_trx_lines.attribute10%type,
266 p_attribute11 IN
267 ra_customer_trx_lines.attribute11%type,
268 p_attribute12 IN
269 ra_customer_trx_lines.attribute12%type,
270 p_attribute13 IN
271 ra_customer_trx_lines.attribute13%type,
272 p_attribute14 IN
273 ra_customer_trx_lines.attribute14%type,
274 p_attribute15 IN
275 ra_customer_trx_lines.attribute15%type,
276 p_unit_selling_price IN
277 ra_customer_trx_lines.unit_selling_price%type,
278 p_extended_amount IN
279 ra_customer_trx_lines.extended_amount%type,
280 p_amount_includes_tax_flag IN
281 ra_customer_trx_lines.amount_includes_tax_flag%type,
282 p_global_attribute_category IN
283 ra_customer_trx_lines.global_attribute_category%type,
284 p_global_attribute1 IN
285 ra_customer_trx_lines.global_attribute1%type,
286 p_global_attribute2 IN
287 ra_customer_trx_lines.global_attribute2%type,
288 p_global_attribute3 IN
289 ra_customer_trx_lines.global_attribute3%type,
290 p_global_attribute4 IN
291 ra_customer_trx_lines.global_attribute4%type,
292 p_global_attribute5 IN
293 ra_customer_trx_lines.global_attribute5%type,
294 p_global_attribute6 IN
295 ra_customer_trx_lines.global_attribute6%type,
296 p_global_attribute7 IN
297 ra_customer_trx_lines.global_attribute7%type,
298 p_global_attribute8 IN
299 ra_customer_trx_lines.global_attribute8%type,
300 p_global_attribute9 IN
301 ra_customer_trx_lines.global_attribute9%type,
302 p_global_attribute10 IN
303 ra_customer_trx_lines.global_attribute10%type,
304 p_global_attribute11 IN
305 ra_customer_trx_lines.global_attribute11%type,
306 p_global_attribute12 IN
307 ra_customer_trx_lines.global_attribute12%type,
308 p_global_attribute13 IN
309 ra_customer_trx_lines.global_attribute13%type,
310 p_global_attribute14 IN
311 ra_customer_trx_lines.global_attribute14%type,
312 p_global_attribute15 IN
313 ra_customer_trx_lines.global_attribute15%type,
314 p_global_attribute16 IN
315 ra_customer_trx_lines.global_attribute16%type,
316 p_global_attribute17 IN
317 ra_customer_trx_lines.global_attribute17%type,
318 p_global_attribute18 IN
319 ra_customer_trx_lines.global_attribute18%type,
320 p_global_attribute19 IN
321 ra_customer_trx_lines.global_attribute19%type,
322 p_global_attribute20 IN
323 ra_customer_trx_lines.global_attribute20%type,
324 p_warehouse_id IN
325 ra_customer_trx_lines.warehouse_id%type ,
326 p_rule_end_date IN
327 ra_customer_trx_lines.rule_end_date%type DEFAULT NULL)
328
329 IS
330
331 l_line_rec ra_customer_trx_lines%rowtype;
332
333 BEGIN
334
335 IF PG_DEBUG in ('Y', 'C') THEN
336 arp_util.debug('arp_lock_line_cover.lock_compare_cover()+');
337 END IF;
338
339 /*------------------------------------------------+
340 | Populate the line record group with |
341 | the values passed in as parameters. |
342 +------------------------------------------------*/
343
344 arp_ctl_pkg.set_to_dummy(l_line_rec);
345
346 l_line_rec.customer_trx_line_id := p_customer_trx_line_id;
347 l_line_rec.customer_trx_id := p_customer_trx_id;
348 l_line_rec.line_number := p_line_number;
349 l_line_rec.line_type := p_line_type;
350 l_line_rec.quantity_credited := p_quantity_credited;
351 l_line_rec.quantity_invoiced := p_quantity_invoiced;
352 l_line_rec.quantity_ordered := p_quantity_ordered;
353 -- l_line_rec.unit_selling_price := p_unit_selling_price;
354 l_line_rec.unit_standard_price := p_unit_standard_price;
355 -- l_line_rec.extended_amount := p_extended_amount;
356 l_line_rec.memo_line_id := p_memo_line_id;
357 l_line_rec.inventory_item_id := p_inventory_item_id;
358 l_line_rec.item_exception_rate_id := p_item_exception_rate_id;
359 l_line_rec.description := p_description;
360 l_line_rec.item_context := p_item_context;
361
362 --
363 -- do not compare as this will be populated in insert procedure
364 --
365 -- l_line_rec.initial_customer_trx_line_id := p_initial_customer_trx_line_id;
366
367 l_line_rec.link_to_cust_trx_line_id := p_link_to_cust_trx_line_id;
368 l_line_rec.previous_customer_trx_id := p_previous_customer_trx_id;
369 l_line_rec.previous_customer_trx_line_id := p_prev_customer_trx_line_id;
370 l_line_rec.accounting_rule_duration := p_accounting_rule_duration;
371 l_line_rec.accounting_rule_id := p_accounting_rule_id;
372 l_line_rec.rule_start_date := p_rule_start_date;
373 l_line_rec.autorule_complete_flag := p_autorule_complete_flag;
374 l_line_rec.autorule_duration_processed := p_autorule_duration_processed;
375 l_line_rec.reason_code := p_reason_code;
376 l_line_rec.last_period_to_credit := p_last_period_to_credit;
377 l_line_rec.sales_order := p_sales_order;
378 l_line_rec.sales_order_date := p_sales_order_date;
379 l_line_rec.sales_order_line := p_sales_order_line;
380 l_line_rec.sales_order_revision := p_sales_order_revision;
381 l_line_rec.sales_order_source := p_sales_order_source;
382 l_line_rec.vat_tax_id := p_vat_tax_id;
383 l_line_rec.tax_exempt_flag := p_tax_exempt_flag;
384 l_line_rec.sales_tax_id := p_sales_tax_id;
385 l_line_rec.location_segment_id := p_location_segment_id;
386 l_line_rec.tax_exempt_number := p_tax_exempt_number;
387 l_line_rec.tax_exempt_reason_code := p_tax_exempt_reason_code;
388 l_line_rec.tax_vendor_return_code := p_tax_vendor_return_code;
389 l_line_rec.taxable_flag := p_taxable_flag;
390 l_line_rec.tax_exemption_id := p_tax_exemption_id;
391 l_line_rec.tax_precedence := p_tax_precedence;
392 l_line_rec.tax_rate := p_tax_rate;
393 l_line_rec.uom_code := p_uom_code;
394 l_line_rec.autotax := p_autotax;
395 l_line_rec.movement_id := p_movement_id;
396 l_line_rec.default_ussgl_transaction_code :=
397 p_default_ussgl_trx_code;
398 l_line_rec.default_ussgl_trx_code_context :=
399 p_default_ussgl_trx_code_cntxt;
400 l_line_rec.interface_line_context := p_interface_line_context;
401 l_line_rec.interface_line_attribute1 := p_interface_line_attribute1;
402 l_line_rec.interface_line_attribute2 := p_interface_line_attribute2;
403 l_line_rec.interface_line_attribute3 := p_interface_line_attribute3;
404 l_line_rec.interface_line_attribute4 := p_interface_line_attribute4;
405 l_line_rec.interface_line_attribute5 := p_interface_line_attribute5;
406 l_line_rec.interface_line_attribute6 := p_interface_line_attribute6;
407 l_line_rec.interface_line_attribute7 := p_interface_line_attribute7;
408 l_line_rec.interface_line_attribute8 := p_interface_line_attribute8;
409 l_line_rec.interface_line_attribute9 := p_interface_line_attribute9;
410 l_line_rec.interface_line_attribute10 := p_interface_line_attribute10;
411 l_line_rec.interface_line_attribute11 := p_interface_line_attribute11;
412 l_line_rec.interface_line_attribute12 := p_interface_line_attribute12;
413 l_line_rec.interface_line_attribute13 := p_interface_line_attribute13;
414 l_line_rec.interface_line_attribute14 := p_interface_line_attribute14;
415 l_line_rec.interface_line_attribute15 := p_interface_line_attribute15;
416 l_line_rec.attribute_category := p_attribute_category;
417 l_line_rec.attribute1 := p_attribute1;
418 l_line_rec.attribute2 := p_attribute2;
419 l_line_rec.attribute3 := p_attribute3;
420 l_line_rec.attribute4 := p_attribute4;
421 l_line_rec.attribute5 := p_attribute5;
422 l_line_rec.attribute6 := p_attribute6;
423 l_line_rec.attribute7 := p_attribute7;
424 l_line_rec.attribute8 := p_attribute8;
425 l_line_rec.attribute9 := p_attribute9;
426 l_line_rec.attribute10 := p_attribute10;
427 l_line_rec.attribute11 := p_attribute11;
428 l_line_rec.attribute12 := p_attribute12;
429 l_line_rec.attribute13 := p_attribute13;
430 l_line_rec.attribute14 := p_attribute14;
431 l_line_rec.attribute15 := p_attribute15;
432
433 -- Rel. 11 changes:
434
435 l_line_rec.amount_includes_tax_flag := p_amount_includes_tax_flag;
436 l_line_rec.unit_selling_price := p_unit_selling_price;
437 l_line_rec.extended_amount := p_extended_amount;
438 l_line_rec.gross_unit_selling_price := p_gross_unit_selling_price;
439 l_line_rec.gross_extended_amount := p_gross_extended_amount;
440
441 -- Rel. 11 Changes: Global Desc. Flex.
442
443 l_line_rec.global_attribute_category := p_global_attribute_category;
444 l_line_rec.global_attribute1 := p_global_attribute1;
445 l_line_rec.global_attribute2 := p_global_attribute2;
446 l_line_rec.global_attribute3 := p_global_attribute3;
447 l_line_rec.global_attribute4 := p_global_attribute4;
448 l_line_rec.global_attribute5 := p_global_attribute5;
449 l_line_rec.global_attribute6 := p_global_attribute6;
450 l_line_rec.global_attribute7 := p_global_attribute7;
451 l_line_rec.global_attribute8 := p_global_attribute8;
452 l_line_rec.global_attribute9 := p_global_attribute9;
453 l_line_rec.global_attribute10 := p_global_attribute10;
454 l_line_rec.global_attribute11 := p_global_attribute11;
455 l_line_rec.global_attribute12 := p_global_attribute12;
456 l_line_rec.global_attribute13 := p_global_attribute13;
457 l_line_rec.global_attribute14 := p_global_attribute14;
458 l_line_rec.global_attribute15 := p_global_attribute15;
459 l_line_rec.global_attribute16 := p_global_attribute16;
460 l_line_rec.global_attribute17 := p_global_attribute17;
461 l_line_rec.global_attribute18 := p_global_attribute18;
462 l_line_rec.global_attribute19 := p_global_attribute19;
463 l_line_rec.global_attribute20 := p_global_attribute20;
464
465 -- Rel. 11.5 changes: Warehouse_id.
466 l_line_rec.warehouse_id := p_warehouse_id;
467 l_line_rec.rule_end_date := p_rule_end_date;
468
469
470
471 /*----------------------------------------------+
472 | Call the standard line table handler |
473 +----------------------------------------------*/
474
475 arp_ctl_pkg.lock_compare_p(
476 l_line_rec,
477 p_customer_trx_line_id,
478 TRUE -- ignore who columns
479 );
480
481 IF PG_DEBUG in ('Y', 'C') THEN
482 arp_util.debug('arp_lock_line_cover.lock_compare_cover()-');
483 END IF;
484
485 EXCEPTION
486 WHEN OTHERS THEN
487
488 IF PG_DEBUG in ('Y', 'C') THEN
489 arp_util.debug('EXCEPTION: arp_lock_line_cover.lock_compare_cover()');
490 arp_util.debug('------- parameters for lock_compare_cover() ' ||
491 '---------');
492 arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id);
493 arp_util.debug('lock_compare_cover: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
494 arp_util.debug('lock_compare_cover: ' || 'p_line_number = ' || p_line_number);
495 arp_util.debug('lock_compare_cover: ' || 'p_line_type = ' || p_line_type);
496 arp_util.debug('lock_compare_cover: ' || 'p_quantity_credited = ' || p_quantity_credited);
497 arp_util.debug('lock_compare_cover: ' || 'p_quantity_invoiced = ' || p_quantity_invoiced);
498 arp_util.debug('lock_compare_cover: ' || 'p_quantity_ordered = ' || p_quantity_ordered);
499 arp_util.debug('lock_compare_cover: ' || 'p_unit_selling_price = ' || p_unit_selling_price);
500 arp_util.debug('lock_compare_cover: ' || 'p_unit_standard_price = ' || p_unit_standard_price);
501 arp_util.debug('lock_compare_cover: ' || 'p_extended_amount = ' || p_extended_amount);
502 arp_util.debug('lock_compare_cover: ' || 'p_memo_line_id = ' || p_memo_line_id);
503 arp_util.debug('lock_compare_cover: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
504 arp_util.debug('lock_compare_cover: ' || 'p_item_exception_rate_id = ' || p_item_exception_rate_id);
505 arp_util.debug('lock_compare_cover: ' || 'p_description = ' || p_description);
506 arp_util.debug('lock_compare_cover: ' || 'p_item_context = ' || p_item_context);
507 arp_util.debug('lock_compare_cover: ' || 'p_initial_customer_trx_line_id = ' ||
508 p_initial_customer_trx_line_id);
509 arp_util.debug('lock_compare_cover: ' || 'p_link_to_cust_trx_line_id = ' ||
510 p_link_to_cust_trx_line_id);
511 arp_util.debug('lock_compare_cover: ' || 'p_previous_customer_trx_id = ' ||
512 p_previous_customer_trx_id);
513 arp_util.debug('lock_compare_cover: ' || 'p_prev_customer_trx_line_id = ' ||
514 p_prev_customer_trx_line_id);
515 arp_util.debug('lock_compare_cover: ' || 'p_accounting_rule_duration = ' ||
516 p_accounting_rule_duration);
517 arp_util.debug('lock_compare_cover: ' || 'p_accounting_rule_id = ' || p_accounting_rule_id);
518 arp_util.debug('lock_compare_cover: ' || 'p_rule_start_date = ' || p_rule_start_date);
519 arp_util.debug('lock_compare_cover: ' || 'p_autorule_complete_flag = ' || p_autorule_complete_flag);
520 arp_util.debug('lock_compare_cover: ' || 'p_autorule_duration_processed = ' ||
521 p_autorule_duration_processed);
522 arp_util.debug('lock_compare_cover: ' || 'p_reason_code = ' || p_reason_code);
523 arp_util.debug('lock_compare_cover: ' || 'p_last_period_to_credit = ' || p_last_period_to_credit);
524 arp_util.debug('lock_compare_cover: ' || 'p_sales_order = ' || p_sales_order);
525 arp_util.debug('lock_compare_cover: ' || 'p_sales_order_date = ' || p_sales_order_date);
526 arp_util.debug('lock_compare_cover: ' || 'p_sales_order_line = ' || p_sales_order_line);
527 arp_util.debug('lock_compare_cover: ' || 'p_sales_order_revision = ' || p_sales_order_revision);
528 arp_util.debug('lock_compare_cover: ' || 'p_sales_order_source = ' || p_sales_order_source);
529 arp_util.debug('lock_compare_cover: ' || 'p_vat_tax_id = ' || p_vat_tax_id);
530 arp_util.debug('lock_compare_cover: ' || 'p_tax_exempt_flag = ' || p_tax_exempt_flag);
531 arp_util.debug('lock_compare_cover: ' || 'p_sales_tax_id = ' || p_sales_tax_id);
532 arp_util.debug('lock_compare_cover: ' || 'p_location_segment_id = ' || p_location_segment_id);
533 arp_util.debug('lock_compare_cover: ' || 'p_tax_exempt_number = ' || p_tax_exempt_number);
534 arp_util.debug('lock_compare_cover: ' || 'p_tax_exempt_reason_code = ' || p_tax_exempt_reason_code);
535 arp_util.debug('lock_compare_cover: ' || 'p_tax_vendor_return_code = ' || p_tax_vendor_return_code);
536 arp_util.debug('lock_compare_cover: ' || 'p_taxable_flag = ' || p_taxable_flag);
537 arp_util.debug('lock_compare_cover: ' || 'p_tax_exemption_id = ' || p_tax_exemption_id);
538 arp_util.debug('lock_compare_cover: ' || 'p_tax_precedence = ' || p_tax_precedence);
539 arp_util.debug('lock_compare_cover: ' || 'p_tax_rate = ' || p_tax_rate);
540 arp_util.debug('lock_compare_cover: ' || 'p_uom_code = ' || p_uom_code);
541 arp_util.debug('lock_compare_cover: ' || 'p_autotax = ' || p_autotax);
542 arp_util.debug('lock_compare_cover: ' || 'p_movement_id = ' || p_movement_id);
543 arp_util.debug('lock_compare_cover: ' || 'p_default_ussgl_trx_code = ' ||
544 p_default_ussgl_trx_code);
545 arp_util.debug('lock_compare_cover: ' || 'p_default_ussgl_trx_code_cntxt = ' ||
546 p_default_ussgl_trx_code_cntxt);
547 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_context = ' || p_interface_line_context);
548 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute1 = ' ||
549 p_interface_line_attribute1);
550 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute2 = ' ||
551 p_interface_line_attribute2);
552 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute3 = ' ||
553 p_interface_line_attribute3);
554 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute4 = ' ||
555 p_interface_line_attribute4);
556 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute5 = ' ||
557 p_interface_line_attribute5);
558 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute6 = ' ||
559 p_interface_line_attribute6);
560 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute7 = ' ||
561 p_interface_line_attribute7);
562 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute8 = ' ||
563 p_interface_line_attribute8);
564 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute9 = ' ||
565 p_interface_line_attribute9);
566 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute10 = ' ||
567 p_interface_line_attribute10);
568 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute11 = ' ||
569 p_interface_line_attribute11);
570 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute12 = ' ||
571 p_interface_line_attribute12);
572 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute13 = ' ||
573 p_interface_line_attribute13);
574 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute14 = ' ||
575 p_interface_line_attribute14);
576 arp_util.debug('lock_compare_cover: ' || 'p_interface_line_attribute15 = ' ||
577 p_interface_line_attribute15);
578 arp_util.debug('lock_compare_cover: ' || 'p_attribute_category = ' || p_attribute_category);
579 arp_util.debug('lock_compare_cover: ' || 'p_attribute1 = ' || p_attribute1);
580 arp_util.debug('lock_compare_cover: ' || 'p_attribute2 = ' || p_attribute2);
581 arp_util.debug('lock_compare_cover: ' || 'p_attribute3 = ' || p_attribute3);
582 arp_util.debug('lock_compare_cover: ' || 'p_attribute4 = ' || p_attribute4);
583 arp_util.debug('lock_compare_cover: ' || 'p_attribute5 = ' || p_attribute5);
584 arp_util.debug('lock_compare_cover: ' || 'p_attribute6 = ' || p_attribute6);
585 arp_util.debug('lock_compare_cover: ' || 'p_attribute7 = ' || p_attribute7);
586 arp_util.debug('lock_compare_cover: ' || 'p_attribute8 = ' || p_attribute8);
587 arp_util.debug('lock_compare_cover: ' || 'p_attribute9 = ' || p_attribute9);
588 arp_util.debug('lock_compare_cover: ' || 'p_attribute10 = ' || p_attribute10);
589 arp_util.debug('lock_compare_cover: ' || 'p_attribute11 = ' || p_attribute11);
590 arp_util.debug('lock_compare_cover: ' || 'p_attribute12 = ' || p_attribute12);
591 arp_util.debug('lock_compare_cover: ' || 'p_attribute13 = ' || p_attribute13);
592 arp_util.debug('lock_compare_cover: ' || 'p_attribute14 = ' || p_attribute14);
593 arp_util.debug('lock_compare_cover: ' || 'p_attribute15 = ' || p_attribute15);
594 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute_category = ' || p_global_attribute_category);
595 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute1 = ' || p_global_attribute1);
596 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute2 = ' || p_global_attribute2);
597 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute3 = ' || p_global_attribute3);
598 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute4 = ' || p_global_attribute4);
599 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute5 = ' || p_global_attribute5);
600 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute6 = ' || p_global_attribute6);
601 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute7 = ' || p_global_attribute7);
602 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute8 = ' || p_global_attribute8);
603 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute9 = ' || p_global_attribute9);
604 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute10 = ' || p_global_attribute10);
605 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute11 = ' || p_global_attribute11);
606 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute12 = ' || p_global_attribute12);
607 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute13 = ' || p_global_attribute13);
608 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute14 = ' || p_global_attribute14);
609 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute15 = ' || p_global_attribute15);
610 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute16 = ' || p_global_attribute16);
611 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute17 = ' || p_global_attribute17);
612 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute18 = ' || p_global_attribute18);
613 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute19 = ' || p_global_attribute19);
614 arp_util.debug('lock_compare_cover: ' || 'p_global_attribute20 = ' || p_global_attribute20);
615 arp_util.debug('lock_compare_cover: ' || 'p_warehouse_id = ' || p_warehouse_id);
616 arp_util.debug('lock_compare_cover: ' || 'p_rule_end_date = ' || p_rule_end_date);
617 END IF;
618
619
620 RAISE;
621
622 END lock_compare_cover;
623
624 END ARP_LOCK_LINE_COVER;