[Home] [Help]
PACKAGE BODY: APPS.OZF_RESALE_LINES_INT_PKG
Source
1 PACKAGE BODY OZF_RESALE_LINES_INT_PKG as
2 /* $Header: ozftrlib.pls 120.1.12000000.2 2007/05/28 10:28:42 ateotia ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_RESALE_LINES_INT_PKG
7 -- Purpose
8 --
9 -- History
10 -- Anuj Teotia 28/05/2007 bug # 5997978 fixed
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17
18 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_RESALE_LINES_INT_PKG';
19 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftrlib.pls';
20
21
22 ----------------------------------------------------------
23 ---- MEDIA ----
24 ----------------------------------------------------------
25
26 -- ========================================================
27 --
28 -- NAME
29 -- createInsertBody
30 --
31 -- PURPOSE
32 --
33 -- NOTES
34 --
35 -- HISTORY
36 --
37 -- ========================================================
38 PROCEDURE Insert_Row(
39 px_resale_line_int_id IN OUT NOCOPY NUMBER,
40 px_object_version_number IN OUT NOCOPY NUMBER,
41 p_last_update_date DATE,
42 p_last_updated_by NUMBER,
43 p_creation_date DATE,
44 p_request_id NUMBER,
45 p_created_by NUMBER,
46 p_created_from VARCHAR2,
47 p_last_update_login NUMBER,
48 p_program_application_id NUMBER,
49 p_program_update_date DATE,
50 p_program_id NUMBER,
51 p_response_type VARCHAR2,
52 p_response_code VARCHAR2,
53 p_reject_reason_code VARCHAR2,
54 p_followup_action_code VARCHAR2,
55 p_resale_transfer_type VARCHAR2,
56 p_product_trans_movement_type VARCHAR2,
57 p_product_transfer_date DATE,
58 p_resale_batch_id NUMBER,
59 p_status_code VARCHAR2,
60 p_end_cust_party_id NUMBER,
61 p_end_cust_site_use_id NUMBER,
62 p_end_cust_site_use_code VARCHAR2,
63 p_end_cust_party_site_id NUMBER,
64 p_end_cust_party_name VARCHAR2,
65 p_end_cust_location VARCHAR2,
66 p_end_cust_address VARCHAR2,
67 p_end_cust_city VARCHAR2,
68 p_end_cust_state VARCHAR2,
69 p_end_cust_postal_code VARCHAR2,
70 p_end_cust_country VARCHAR2,
71 p_end_cust_contact_party_id NUMBER,
72 p_end_cust_contact_name VARCHAR2,
73 p_end_cust_email VARCHAR2,
74 p_end_cust_phone VARCHAR2,
75 p_end_cust_fax VARCHAR2,
76 p_bill_to_cust_account_id NUMBER,
77 p_bill_to_site_use_id NUMBER,
78 p_bill_to_PARTY_NAME VARCHAR2,
79 p_bill_to_PARTY_ID NUMBER,
80 p_bill_to_PARTY_site_id NUMBER,
81 p_bill_to_location VARCHAR2,
82 p_bill_to_duns_number varchar2,
83 p_bill_to_address VARCHAR2,
84 p_bill_to_city VARCHAR2,
85 p_bill_to_state VARCHAR2,
86 p_bill_to_postal_code VARCHAR2,
87 p_bill_to_country VARCHAR2,
88 p_bill_to_contact_party_id NUMBER,
89 p_bill_to_contact_name VARCHAR2,
90 p_bill_to_email VARCHAR2,
91 p_bill_to_phone VARCHAR2,
92 p_bill_to_fax VARCHAR2,
93 p_ship_to_cust_account_id NUMBER,
94 p_ship_to_site_use_id NUMBER,
95 p_ship_to_PARTY_NAME VARCHAR2,
96 p_ship_to_PARTY_ID NUMBER,
97 p_ship_to_PARTY_site_id NUMBER,
98 p_ship_to_duns_number varchar2,
99 p_ship_to_location VARCHAR2,
100 p_ship_to_address VARCHAR2,
101 p_ship_to_city VARCHAR2,
102 p_ship_to_state VARCHAR2,
103 p_ship_to_postal_code VARCHAR2,
104 p_ship_to_country VARCHAR2,
105 p_ship_to_contact_party_id NUMBER,
106 p_ship_to_contact_name VARCHAR2,
107 p_ship_to_email VARCHAR2,
108 p_ship_to_phone VARCHAR2,
109 p_ship_to_fax VARCHAR2,
110 p_ship_from_cust_account_id NUMBER,
111 p_ship_from_site_id NUMBER,
112 p_ship_from_PARTY_NAME VARCHAR2,
113 p_ship_from_location VARCHAR2,
114 p_ship_from_address VARCHAR2,
115 p_ship_from_city VARCHAR2,
116 p_ship_from_state VARCHAR2,
117 p_ship_from_postal_code VARCHAR2,
118 p_ship_from_country VARCHAR2,
119 p_ship_from_contact_party_id NUMBER,
120 p_ship_from_contact_name VARCHAR2,
121 p_ship_from_email VARCHAR2,
122 p_ship_from_phone VARCHAR2,
123 p_ship_from_fax VARCHAR2,
124 p_sold_from_cust_account_id NUMBER,
125 p_sold_from_site_id NUMBER,
126 p_sold_from_PARTY_NAME VARCHAR2,
127 p_sold_from_location VARCHAR2,
128 p_sold_from_address VARCHAR2,
129 p_sold_from_city VARCHAR2,
130 p_sold_from_state VARCHAR2,
131 p_sold_from_postal_code VARCHAR2,
132 p_sold_from_country VARCHAR2,
133 p_sold_from_contact_party_id NUMBER,
134 p_sold_from_contact_name VARCHAR2,
135 p_sold_from_email VARCHAR2,
136 p_sold_from_phone VARCHAR2,
137 p_sold_from_fax VARCHAR2,
138 p_order_number VARCHAR2,
139 p_date_ordered DATE,
140 p_po_number VARCHAR2,
141 p_po_release_number VARCHAR2,
142 p_po_type VARCHAR2,
143 p_agreement_id NUMBER,
144 p_agreement_name VARCHAR2,
145 p_agreement_type VARCHAR2,
146 p_agreement_price NUMBER,
147 p_agreement_uom_code VARCHAR2,
148 p_corrected_agreement_id NUMBER,
149 p_corrected_agreement_name VARCHAR2,
150 p_price_list_id NUMBER,
151 p_price_list_name VARCHAR2,
152 p_orig_system_quantity NUMBER,
153 p_orig_system_uom VARCHAR2,
154 p_orig_system_currency_code VARCHAR2,
155 p_orig_system_selling_price NUMBER,
156 p_orig_system_reference VARCHAR2,
157 p_orig_system_line_reference VARCHAR2,
158 p_orig_system_purchase_uom varchar2,
159 p_orig_system_purchase_curr VARCHAR2,
160 p_orig_system_purchase_price NUMBER,
161 p_orig_system_purchase_quant NUMBER,
162 p_orig_system_agreement_uom varchar2,
163 p_ORIG_SYSTEM_AGREEMENT_name varchar2,
164 p_orig_system_agreement_type VARCHAR2,
165 p_orig_system_agreement_status VARCHAR2,
166 p_orig_system_agreement_curr VARCHAR2,
167 p_orig_system_agreement_price NUMBER,
168 p_orig_system_agreement_quant NUMBER,
169 p_orig_system_item_number varchar2,
170 p_quantity NUMBER,
171 p_uom_code VARCHAR2,
172 p_currency_code VARCHAR2,
173 p_exchange_rate NUMBER,
174 p_exchange_rate_type VARCHAR2,
175 p_exchange_rate_date DATE,
176 p_selling_price NUMBER,
177 p_purchase_uom_code VARCHAR2,
178 p_invoice_number VARCHAR2,
179 p_date_invoiced DATE,
180 p_date_shipped DATE,
181 p_credit_advice_date DATE,
182 p_product_category_id NUMBER,
183 p_category_name VARCHAR2,
184 p_inventory_item_segment1 VARCHAR2,
185 p_inventory_item_segment2 VARCHAR2,
186 p_inventory_item_segment3 VARCHAR2,
187 p_inventory_item_segment4 VARCHAR2,
188 p_inventory_item_segment5 VARCHAR2,
189 p_inventory_item_segment6 VARCHAR2,
190 p_inventory_item_segment7 VARCHAR2,
191 p_inventory_item_segment8 VARCHAR2,
192 p_inventory_item_segment9 VARCHAR2,
193 p_inventory_item_segment10 VARCHAR2,
194 p_inventory_item_segment11 VARCHAR2,
195 p_inventory_item_segment12 VARCHAR2,
196 p_inventory_item_segment13 VARCHAR2,
197 p_inventory_item_segment14 VARCHAR2,
198 p_inventory_item_segment15 VARCHAR2,
199 p_inventory_item_segment16 VARCHAR2,
200 p_inventory_item_segment17 VARCHAR2,
201 p_inventory_item_segment18 VARCHAR2,
202 p_inventory_item_segment19 VARCHAR2,
203 p_inventory_item_segment20 VARCHAR2,
204 p_inventory_item_id NUMBER,
205 p_item_description VARCHAR2,
206 p_upc_code VARCHAR2,
207 p_item_number VARCHAR2,
208 p_claimed_amount NUMBER,
209 p_purchase_price NUMBER,
210 p_acctd_purchase_price NUMBER,
211 p_net_adjusted_amount NUMBER,
212 p_accepted_amount NUMBER,
213 p_total_accepted_amount NUMBER,
214 p_allowed_amount NUMBER,
215 p_total_allowed_amount NUMBER,
216 p_calculated_price NUMBER,
217 p_acctd_calculated_price NUMBER,
218 p_calculated_amount NUMBER,
219 p_line_tolerance_amount NUMBER,
220 p_total_claimed_amount NUMBER,
221 p_credit_code VARCHAR2,
222 p_direct_customer_flag VARCHAR2,
223 p_duplicated_line_id number,
224 p_duplicated_adjustment_id number,
225 p_order_type_id NUMBER,
226 p_order_type VARCHAR2,
227 p_order_category VARCHAR2,
228 p_dispute_code VARCHAR2,
229 p_data_source_code VARCHAR2,
230 p_tracing_flag VARCHAR2,
231 p_header_attribute_category VARCHAR2,
232 p_header_attribute1 VARCHAR2,
233 p_header_attribute2 VARCHAR2,
234 p_header_attribute3 VARCHAR2,
235 p_header_attribute4 VARCHAR2,
236 p_header_attribute5 VARCHAR2,
237 p_header_attribute6 VARCHAR2,
238 p_header_attribute7 VARCHAR2,
239 p_header_attribute8 VARCHAR2,
240 p_header_attribute9 VARCHAR2,
241 p_header_attribute10 VARCHAR2,
242 p_header_attribute11 VARCHAR2,
243 p_header_attribute12 VARCHAR2,
244 p_header_attribute13 VARCHAR2,
245 p_header_attribute14 VARCHAR2,
246 p_header_attribute15 VARCHAR2,
247 p_line_attribute_category VARCHAR2,
248 p_line_attribute1 VARCHAR2,
249 p_line_attribute2 VARCHAR2,
250 p_line_attribute3 VARCHAR2,
251 p_line_attribute4 VARCHAR2,
252 p_line_attribute5 VARCHAR2,
253 p_line_attribute6 VARCHAR2,
254 p_line_attribute7 VARCHAR2,
255 p_line_attribute8 VARCHAR2,
256 p_line_attribute9 VARCHAR2,
257 p_line_attribute10 VARCHAR2,
258 p_line_attribute11 VARCHAR2,
259 p_line_attribute12 VARCHAR2,
260 p_line_attribute13 VARCHAR2,
261 p_line_attribute14 VARCHAR2,
262 p_line_attribute15 VARCHAR2,
263 px_org_id IN OUT NOCOPY NUMBER)
264
265 IS
266 x_rowid VARCHAR2(30);
267 l_batch_org_id NUMBER; -- bug # 5997978 fixed
268
269 BEGIN
270
271 -- Start: bug # 5997978 fixed
272 IF px_org_id IS NULL THEN
273 OPEN OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr(p_resale_batch_id);
274 FETCH OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr INTO l_batch_org_id;
275 CLOSE OZF_RESALE_COMMON_PVT.g_resale_batch_org_id_csr;
276 px_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
277 IF (l_batch_org_id IS NULL OR px_org_id IS NULL) THEN
278 OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
279 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280 END IF;
281 /*IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
282 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
283 INTO px_org_id
284 FROM DUAL;*/
285 END IF;
286 -- End: bug # 5997978 fixed
287
288 px_object_version_number := 1;
289
290
291 INSERT INTO OZF_RESALE_LINES_INT_ALL(
292 resale_line_int_id,
293 object_version_number,
294 last_update_date,
295 last_updated_by,
296 creation_date,
297 request_id,
298 created_by,
299 created_from,
300 last_update_login,
301 program_application_id,
302 program_update_date,
303 program_id,
304 response_type,
305 response_code,
306 reject_reason_code,
307 followup_action_code,
308 resale_transfer_type,
309 product_transfer_movement_type,
310 product_transfer_date,
311 resale_batch_id,
312 status_code,
313 end_cust_party_id,
314 end_cust_site_use_id,
315 end_cust_site_use_code,
316 end_cust_party_site_id,
317 end_cust_party_name,
318 end_cust_location,
319 end_cust_address,
320 end_cust_city,
321 end_cust_state,
322 end_cust_postal_code,
323 end_cust_country,
324 end_cust_contact_party_id,
325 end_cust_contact_name,
326 end_cust_email,
327 end_cust_phone,
328 end_cust_fax,
329 bill_to_cust_account_id,
330 bill_to_site_use_id,
331 bill_to_PARTY_NAME,
332 bill_to_PARTY_ID,
333 bill_to_PARTY_site_id,
334 bill_to_duns_number,
335 bill_to_location,
336 bill_to_address,
337 bill_to_city,
338 bill_to_state,
339 bill_to_postal_code,
340 bill_to_country,
341 bill_to_contact_party_id,
342 bill_to_contact_name,
343 bill_to_email,
344 bill_to_phone,
345 bill_to_fax,
346 ship_to_cust_account_id,
347 ship_to_site_use_id,
348 ship_to_PARTY_NAME,
349 ship_to_PARTY_ID,
350 ship_to_PARTY_site_id,
351 ship_to_duns_number,
352 ship_to_location,
353 ship_to_address,
354 ship_to_city,
355 ship_to_state,
356 ship_to_postal_code,
357 ship_to_country,
358 ship_to_contact_party_id,
359 ship_to_contact_name,
360 ship_to_email,
361 ship_to_phone,
362 ship_to_fax,
363 ship_from_cust_account_id,
364 ship_from_site_id,
365 ship_from_PARTY_NAME,
366 ship_from_location,
367 ship_from_address,
368 ship_from_city,
369 ship_from_state,
370 ship_from_postal_code,
371 ship_from_country,
372 ship_from_contact_party_id,
373 ship_from_contact_name,
374 ship_from_email,
375 ship_from_phone,
376 ship_from_fax,
377 sold_from_cust_account_id,
378 sold_from_site_id,
379 sold_from_PARTY_NAME,
380 sold_from_location,
381 sold_from_address,
382 sold_from_city,
383 sold_from_state,
384 sold_from_postal_code,
385 sold_from_country,
386 sold_from_contact_party_id,
387 sold_from_contact_name,
388 sold_from_email,
389 sold_from_phone,
390 sold_from_fax,
391 order_number,
392 date_ordered,
393 po_number,
394 po_release_number,
395 po_type,
396 agreement_id,
397 agreement_name,
398 agreement_type,
399 agreement_price,
400 agreement_uom_code,
401 corrected_agreement_id,
402 corrected_agreement_name,
403 price_list_id,
404 price_list_name,
405 orig_system_quantity,
406 orig_system_uom,
407 orig_system_currency_code,
408 orig_system_selling_price,
409 orig_system_reference,
410 orig_system_line_reference,
411 orig_system_purchase_uom,
412 orig_system_purchase_curr,
413 orig_system_purchase_price,
414 orig_system_purchase_quantity,
415 orig_system_agreement_uom,
416 ORIG_SYSTEM_AGREEMENT_name,
417 orig_system_agreement_type,
418 orig_system_agreement_status ,
419 orig_system_agreement_curr,
420 orig_system_agreement_price,
421 orig_system_agreement_quantity,
422 orig_system_item_number,
423 quantity,
424 uom_code,
425 currency_code,
426 exchange_rate,
427 exchange_rate_type,
428 exchange_rate_date,
429 selling_price,
430 purchase_uom_code,
431 invoice_number,
432 date_invoiced,
433 date_shipped,
434 credit_advice_date,
435 product_category_id,
436 category_name,
437 inventory_item_segment1,
438 inventory_item_segment2,
439 inventory_item_segment3,
440 inventory_item_segment4,
441 inventory_item_segment5,
442 inventory_item_segment6,
443 inventory_item_segment7,
444 inventory_item_segment8,
445 inventory_item_segment9,
446 inventory_item_segment10,
447 inventory_item_segment11,
448 inventory_item_segment12,
449 inventory_item_segment13,
450 inventory_item_segment14,
451 inventory_item_segment15,
452 inventory_item_segment16,
453 inventory_item_segment17,
454 inventory_item_segment18,
455 inventory_item_segment19,
456 inventory_item_segment20,
457 inventory_item_id,
458 item_description,
459 upc_code,
460 item_number,
461 claimed_amount,
462 purchase_price,
463 acctd_purchase_price,
464 net_adjusted_amount,
465 accepted_amount,
466 total_accepted_amount,
467 allowed_amount,
468 total_allowed_amount,
469 calculated_price,
470 acctd_calculated_price,
471 calculated_amount,
472 line_tolerance_amount,
473 total_claimed_amount,
474 credit_code,
475 direct_customer_flag,
476 duplicated_line_id,
477 duplicated_adjustment_id,
478 order_type_id,
479 order_type,
480 order_category,
481 dispute_code,
482 data_source_code,
483 tracing_flag,
484 header_attribute_category,
485 header_attribute1,
486 header_attribute2,
487 header_attribute3,
488 header_attribute4,
489 header_attribute5,
490 header_attribute6,
491 header_attribute7,
492 header_attribute8,
493 header_attribute9,
494 header_attribute10,
495 header_attribute11,
496 header_attribute12,
497 header_attribute13,
498 header_attribute14,
499 header_attribute15,
500 line_attribute_category,
501 line_attribute1,
502 line_attribute2,
503 line_attribute3,
504 line_attribute4,
505 line_attribute5,
506 line_attribute6,
507 line_attribute7,
508 line_attribute8,
509 line_attribute9,
510 line_attribute10,
511 line_attribute11,
512 line_attribute12,
513 line_attribute13,
514 line_attribute14,
515 line_attribute15,
516 org_id
517 ) VALUES (
518 px_resale_line_int_id,
519 px_object_version_number,
520 p_last_update_date,
521 p_last_updated_by,
522 p_creation_date,
523 p_request_id,
524 p_created_by,
525 p_created_from,
526 p_last_update_login,
527 p_program_application_id,
528 p_program_update_date,
529 p_program_id,
530 p_response_type,
531 p_response_code,
532 p_reject_reason_code,
533 p_followup_action_code,
534 p_resale_transfer_type,
535 p_product_trans_movement_type,
536 p_product_transfer_date,
537 p_resale_batch_id,
538 p_status_code,
539 p_end_cust_party_id,
540 p_end_cust_site_use_id,
541 p_end_cust_site_use_code,
542 p_end_cust_party_site_id,
543 p_end_cust_party_name,
544 p_end_cust_location,
545 p_end_cust_address,
546 p_end_cust_city,
547 p_end_cust_state,
548 p_end_cust_postal_code,
549 p_end_cust_country,
550 p_end_cust_contact_party_id,
551 p_end_cust_contact_name,
552 p_end_cust_email,
553 p_end_cust_phone,
554 p_end_cust_fax,
555 p_bill_to_cust_account_id,
556 p_bill_to_site_use_id,
557 p_bill_to_PARTY_NAME,
558 p_bill_to_PARTY_ID,
559 p_bill_to_PARTY_site_id,
560 p_bill_to_duns_number ,
561 p_bill_to_location,
562 p_bill_to_address,
563 p_bill_to_city,
564 p_bill_to_state,
565 p_bill_to_postal_code,
566 p_bill_to_country,
567 p_bill_to_contact_party_id,
568 p_bill_to_contact_name,
569 p_bill_to_email,
570 p_bill_to_phone,
571 p_bill_to_fax,
572 p_ship_to_cust_account_id,
573 p_ship_to_site_use_id,
574 p_ship_to_PARTY_NAME,
575 p_ship_to_PARTY_ID,
576 p_ship_to_PARTY_site_id,
577 p_ship_to_duns_number,
578 p_ship_to_location,
579 p_ship_to_address,
580 p_ship_to_city,
581 p_ship_to_state,
582 p_ship_to_postal_code,
583 p_ship_to_country,
584 p_ship_to_contact_party_id,
585 p_ship_to_contact_name,
586 p_ship_to_email,
587 p_ship_to_phone,
588 p_ship_to_fax,
589 p_ship_from_cust_account_id,
590 p_ship_from_site_id,
591 p_ship_from_PARTY_NAME,
592 p_ship_from_location,
593 p_ship_from_address,
594 p_ship_from_city,
595 p_ship_from_state,
596 p_ship_from_postal_code,
597 p_ship_from_country,
598 p_ship_from_contact_party_id,
599 p_ship_from_contact_name,
600 p_ship_from_email,
601 p_ship_from_phone,
602 p_ship_from_fax,
603 p_sold_from_cust_account_id,
604 p_sold_from_site_id,
605 p_sold_from_PARTY_NAME,
606 p_sold_from_location,
607 p_sold_from_address,
608 p_sold_from_city,
609 p_sold_from_state,
610 p_sold_from_postal_code,
611 p_sold_from_country,
612 p_sold_from_contact_party_id,
613 p_sold_from_contact_name,
614 p_sold_from_email,
615 p_sold_from_phone,
616 p_sold_from_fax,
617 p_order_number,
618 p_date_ordered,
619 p_po_number,
620 p_po_release_number,
621 p_po_type,
622 p_agreement_id,
623 p_agreement_name,
624 p_agreement_type,
625 p_agreement_price,
626 p_agreement_uom_code,
627 p_corrected_agreement_id,
628 p_corrected_agreement_name,
629 p_price_list_id,
630 p_price_list_name,
631 p_orig_system_quantity,
632 p_orig_system_uom,
633 p_orig_system_currency_code,
634 p_orig_system_selling_price,
635 p_orig_system_reference,
636 p_orig_system_line_reference,
637 p_orig_system_purchase_uom,
638 p_orig_system_purchase_curr,
639 p_orig_system_purchase_price,
640 p_orig_system_purchase_quant,
641 p_orig_system_agreement_uom,
642 p_ORIG_SYSTEM_AGREEMENT_name,
643 p_orig_system_agreement_type,
644 p_orig_system_agreement_status ,
645 p_orig_system_agreement_curr,
646 p_orig_system_agreement_price,
647 p_orig_system_agreement_quant,
648 p_orig_system_item_number,
649 p_quantity,
650 p_uom_code,
651 p_currency_code,
652 p_exchange_rate,
653 p_exchange_rate_type,
654 p_exchange_rate_date,
655 p_selling_price,
656 p_purchase_uom_code,
657 p_invoice_number,
658 p_date_invoiced,
659 p_date_shipped,
660 p_credit_advice_date,
661 p_product_category_id,
662 p_category_name,
663 p_inventory_item_segment1,
664 p_inventory_item_segment2,
665 p_inventory_item_segment3,
666 p_inventory_item_segment4,
667 p_inventory_item_segment5,
668 p_inventory_item_segment6,
669 p_inventory_item_segment7,
670 p_inventory_item_segment8,
671 p_inventory_item_segment9,
672 p_inventory_item_segment10,
673 p_inventory_item_segment11,
674 p_inventory_item_segment12,
675 p_inventory_item_segment13,
676 p_inventory_item_segment14,
677 p_inventory_item_segment15,
678 p_inventory_item_segment16,
679 p_inventory_item_segment17,
680 p_inventory_item_segment18,
681 p_inventory_item_segment19,
682 p_inventory_item_segment20,
683 p_inventory_item_id,
684 p_item_description,
685 p_upc_code,
686 p_item_number,
687 p_claimed_amount,
688 p_purchase_price,
689 p_acctd_purchase_price,
690 p_net_adjusted_amount,
691 p_accepted_amount,
692 p_total_accepted_amount,
693 p_allowed_amount,
694 p_total_allowed_amount,
695 p_calculated_price,
696 p_acctd_calculated_price,
697 p_calculated_amount,
698 p_line_tolerance_amount,
699 p_total_claimed_amount,
700 p_credit_code,
701 p_direct_customer_flag,
702 p_duplicated_line_id,
703 p_duplicated_adjustment_id,
704 p_order_type_id,
705 p_order_type,
706 p_order_category,
707 p_dispute_code,
708 p_data_source_code,
709 p_tracing_flag,
710 p_header_attribute_category,
711 p_header_attribute1,
712 p_header_attribute2,
713 p_header_attribute3,
714 p_header_attribute4,
715 p_header_attribute5,
716 p_header_attribute6,
717 p_header_attribute7,
718 p_header_attribute8,
719 p_header_attribute9,
720 p_header_attribute10,
721 p_header_attribute11,
722 p_header_attribute12,
723 p_header_attribute13,
724 p_header_attribute14,
725 p_header_attribute15,
726 p_line_attribute_category,
727 p_line_attribute1,
728 p_line_attribute2,
729 p_line_attribute3,
730 p_line_attribute4,
731 p_line_attribute5,
732 p_line_attribute6,
733 p_line_attribute7,
734 p_line_attribute8,
735 p_line_attribute9,
736 p_line_attribute10,
737 p_line_attribute11,
738 p_line_attribute12,
739 p_line_attribute13,
740 p_line_attribute14,
741 p_line_attribute15,
742 px_org_id);
743 END Insert_Row;
744
745
746 ----------------------------------------------------------
747 ---- MEDIA ----
748 ----------------------------------------------------------
749
750 -- ========================================================
751 --
752 -- NAME
753 -- createUpdateBody
754 --
755 -- PURPOSE
756 --
757 -- NOTES
758 --
759 -- HISTORY
760 --
761 -- ========================================================
762 PROCEDURE Update_Row(
763 p_resale_line_int_id NUMBER,
764 p_object_version_number NUMBER,
765 p_last_update_date DATE,
766 p_last_updated_by NUMBER,
767 p_request_id NUMBER,
768 p_created_from VARCHAR2,
769 p_last_update_login NUMBER,
770 p_program_application_id NUMBER,
771 p_program_update_date DATE,
772 p_program_id NUMBER,
773 p_response_type VARCHAR2,
774 p_response_code VARCHAR2,
775 p_reject_reason_code VARCHAR2,
776 p_followup_action_code VARCHAR2,
777 p_resale_transfer_type VARCHAR2,
778 p_product_trans_movement_type VARCHAR2,
779 p_product_transfer_date DATE,
780 p_resale_batch_id NUMBER,
781 p_status_code VARCHAR2,
782 p_end_cust_party_id NUMBER,
783 p_end_cust_site_use_id NUMBER,
784 p_end_cust_site_use_code VARCHAR2,
785 p_end_cust_party_site_id NUMBER,
786 p_end_cust_party_name VARCHAR2,
787 p_end_cust_location VARCHAR2,
788 p_end_cust_address VARCHAR2,
789 p_end_cust_city VARCHAR2,
790 p_end_cust_state VARCHAR2,
791 p_end_cust_postal_code VARCHAR2,
792 p_end_cust_country VARCHAR2,
793 p_end_cust_contact_party_id NUMBER,
794 p_end_cust_contact_name VARCHAR2,
795 p_end_cust_email VARCHAR2,
796 p_end_cust_phone VARCHAR2,
797 p_end_cust_fax VARCHAR2,
798 p_bill_to_cust_account_id NUMBER,
799 p_bill_to_site_use_id NUMBER,
800 p_bill_to_PARTY_NAME VARCHAR2,
801 p_bill_to_PARTY_ID NUMBER,
802 p_bill_to_PARTY_site_id NUMBER,
803 p_bill_to_location VARCHAR2,
804 p_bill_to_duns_number varchar2,
805 p_bill_to_address VARCHAR2,
806 p_bill_to_city VARCHAR2,
807 p_bill_to_state VARCHAR2,
808 p_bill_to_postal_code VARCHAR2,
809 p_bill_to_country VARCHAR2,
810 p_bill_to_contact_party_id NUMBER,
811 p_bill_to_contact_name VARCHAR2,
812 p_bill_to_email VARCHAR2,
813 p_bill_to_phone VARCHAR2,
814 p_bill_to_fax VARCHAR2,
815 p_ship_to_cust_account_id NUMBER,
816 p_ship_to_site_use_id NUMBER,
817 p_ship_to_PARTY_NAME VARCHAR2,
818 p_ship_to_PARTY_ID NUMBER,
819 p_ship_to_PARTY_site_id NUMBER,
820 p_ship_to_duns_number varchar2,
821 p_ship_to_location VARCHAR2,
822 p_ship_to_address VARCHAR2,
823 p_ship_to_city VARCHAR2,
824 p_ship_to_state VARCHAR2,
825 p_ship_to_postal_code VARCHAR2,
826 p_ship_to_country VARCHAR2,
827 p_ship_to_contact_party_id NUMBER,
828 p_ship_to_contact_name VARCHAR2,
829 p_ship_to_email VARCHAR2,
830 p_ship_to_phone VARCHAR2,
831 p_ship_to_fax VARCHAR2,
832 p_ship_from_cust_account_id NUMBER,
833 p_ship_from_site_id NUMBER,
834 p_ship_from_PARTY_NAME VARCHAR2,
835 p_ship_from_location VARCHAR2,
836 p_ship_from_address VARCHAR2,
837 p_ship_from_city VARCHAR2,
838 p_ship_from_state VARCHAR2,
839 p_ship_from_postal_code VARCHAR2,
840 p_ship_from_country VARCHAR2,
841 p_ship_from_contact_party_id NUMBER,
842 p_ship_from_contact_name VARCHAR2,
843 p_ship_from_email VARCHAR2,
844 p_ship_from_phone VARCHAR2,
845 p_ship_from_fax VARCHAR2,
846 p_sold_from_cust_account_id NUMBER,
847 p_sold_from_site_id NUMBER,
848 p_sold_from_PARTY_NAME VARCHAR2,
849 p_sold_from_location VARCHAR2,
850 p_sold_from_address VARCHAR2,
851 p_sold_from_city VARCHAR2,
852 p_sold_from_state VARCHAR2,
853 p_sold_from_postal_code VARCHAR2,
854 p_sold_from_country VARCHAR2,
855 p_sold_from_contact_party_id NUMBER,
856 p_sold_from_contact_name VARCHAR2,
857 p_sold_from_email VARCHAR2,
858 p_sold_from_phone VARCHAR2,
859 p_sold_from_fax VARCHAR2,
860 p_order_number VARCHAR2,
861 p_date_ordered DATE,
862 p_po_number VARCHAR2,
863 p_po_release_number VARCHAR2,
864 p_po_type VARCHAR2,
865 p_agreement_id NUMBER,
866 p_agreement_name VARCHAR2,
867 p_agreement_type VARCHAR2,
868 p_agreement_price NUMBER,
869 p_agreement_uom_code VARCHAR2,
870 p_corrected_agreement_id NUMBER,
871 p_corrected_agreement_name VARCHAR2,
872 p_price_list_id NUMBER,
873 p_price_list_name VARCHAR2,
874 p_orig_system_quantity NUMBER,
875 p_orig_system_uom VARCHAR2,
876 p_orig_system_currency_code VARCHAR2,
877 p_orig_system_selling_price NUMBER,
878 p_orig_system_reference VARCHAR2,
879 p_orig_system_line_reference VARCHAR2,
880 p_orig_system_purchase_uom varchar2,
881 p_orig_system_purchase_curr VARCHAR2,
882 p_orig_system_purchase_price NUMBER,
883 p_orig_system_purchase_quant NUMBER,
884 p_orig_system_agreement_uom varchar2,
885 p_ORIG_SYSTEM_AGREEMENT_name varchar2,
886 p_orig_system_agreement_type VARCHAR2,
887 p_orig_system_agreement_status VARCHAR2,
888 p_orig_system_agreement_curr VARCHAR2,
889 p_orig_system_agreement_price NUMBER,
890 p_orig_system_agreement_quant NUMBER,
891 p_orig_system_item_number varchar2,
892 p_quantity NUMBER,
893 p_uom_code VARCHAR2,
894 p_currency_code VARCHAR2,
895 p_exchange_rate NUMBER,
896 p_exchange_rate_type VARCHAR2,
897 p_exchange_rate_date DATE,
898 p_selling_price NUMBER,
899 p_purchase_uom_code VARCHAR2,
900 p_invoice_number VARCHAR2,
901 p_date_invoiced DATE,
902 p_date_shipped DATE,
903 p_credit_advice_date DATE,
904 p_product_category_id NUMBER,
905 p_category_name VARCHAR2,
906 p_inventory_item_segment1 VARCHAR2,
907 p_inventory_item_segment2 VARCHAR2,
908 p_inventory_item_segment3 VARCHAR2,
909 p_inventory_item_segment4 VARCHAR2,
910 p_inventory_item_segment5 VARCHAR2,
911 p_inventory_item_segment6 VARCHAR2,
912 p_inventory_item_segment7 VARCHAR2,
913 p_inventory_item_segment8 VARCHAR2,
914 p_inventory_item_segment9 VARCHAR2,
915 p_inventory_item_segment10 VARCHAR2,
916 p_inventory_item_segment11 VARCHAR2,
917 p_inventory_item_segment12 VARCHAR2,
918 p_inventory_item_segment13 VARCHAR2,
919 p_inventory_item_segment14 VARCHAR2,
920 p_inventory_item_segment15 VARCHAR2,
921 p_inventory_item_segment16 VARCHAR2,
922 p_inventory_item_segment17 VARCHAR2,
923 p_inventory_item_segment18 VARCHAR2,
924 p_inventory_item_segment19 VARCHAR2,
925 p_inventory_item_segment20 VARCHAR2,
926 p_inventory_item_id NUMBER,
927 p_item_description VARCHAR2,
928 p_upc_code VARCHAR2,
929 p_item_number VARCHAR2,
930 p_claimed_amount NUMBER,
931 p_purchase_price NUMBER,
932 p_acctd_purchase_price NUMBER,
933 p_net_adjusted_amount NUMBER,
934 p_accepted_amount NUMBER,
935 p_total_accepted_amount NUMBER,
936 p_allowed_amount NUMBER,
937 p_total_allowed_amount NUMBER,
938 p_calculated_price NUMBER,
939 p_acctd_calculated_price NUMBER,
940 p_calculated_amount NUMBER,
941 p_line_tolerance_amount NUMBER,
942 p_total_claimed_amount NUMBER,
943 p_credit_code VARCHAR2,
944 p_direct_customer_flag VARCHAR2,
945 p_duplicated_line_id number,
946 p_duplicated_adjustment_id number,
947 p_order_type_id NUMBER,
948 p_order_type VARCHAR2,
949 p_order_category VARCHAR2,
950 p_dispute_code VARCHAR2,
951 p_data_source_code VARCHAR2,
952 p_tracing_flag VARCHAR2,
953 p_header_attribute_category VARCHAR2,
954 p_header_attribute1 VARCHAR2,
955 p_header_attribute2 VARCHAR2,
956 p_header_attribute3 VARCHAR2,
957 p_header_attribute4 VARCHAR2,
958 p_header_attribute5 VARCHAR2,
959 p_header_attribute6 VARCHAR2,
960 p_header_attribute7 VARCHAR2,
961 p_header_attribute8 VARCHAR2,
962 p_header_attribute9 VARCHAR2,
963 p_header_attribute10 VARCHAR2,
964 p_header_attribute11 VARCHAR2,
965 p_header_attribute12 VARCHAR2,
966 p_header_attribute13 VARCHAR2,
967 p_header_attribute14 VARCHAR2,
968 p_header_attribute15 VARCHAR2,
969 p_line_attribute_category VARCHAR2,
970 p_line_attribute1 VARCHAR2,
971 p_line_attribute2 VARCHAR2,
972 p_line_attribute3 VARCHAR2,
973 p_line_attribute4 VARCHAR2,
974 p_line_attribute5 VARCHAR2,
975 p_line_attribute6 VARCHAR2,
976 p_line_attribute7 VARCHAR2,
977 p_line_attribute8 VARCHAR2,
978 p_line_attribute9 VARCHAR2,
979 p_line_attribute10 VARCHAR2,
980 p_line_attribute11 VARCHAR2,
981 p_line_attribute12 VARCHAR2,
982 p_line_attribute13 VARCHAR2,
983 p_line_attribute14 VARCHAR2,
984 p_line_attribute15 VARCHAR2,
985 p_org_id NUMBER)
986
987 IS
988 BEGIN
989 Update OZF_RESALE_LINES_INT_ALL
990 SET
991 resale_line_int_id = p_resale_line_int_id,
992 object_version_number = p_object_version_number,
993 last_update_date = p_last_update_date,
994 last_updated_by = p_last_updated_by,
995 request_id = p_request_id,
996 created_from = p_created_from,
997 last_update_login = p_last_update_login,
998 program_application_id = p_program_application_id,
999 program_update_date = p_program_update_date,
1000 program_id = p_program_id,
1001 response_type = p_response_type,
1002 response_code = p_response_code,
1003 reject_reason_code = p_reject_reason_code,
1004 followup_action_code = p_followup_action_code,
1005 resale_transfer_type = p_resale_transfer_type,
1006 product_transfer_movement_type = p_product_trans_movement_type,
1007 product_transfer_date = p_product_transfer_date,
1008 resale_batch_id = p_resale_batch_id,
1009 status_code = p_status_code,
1010 end_cust_party_id = p_end_cust_party_id,
1011 end_cust_site_use_id = p_end_cust_site_use_id,
1012 end_cust_site_use_code = p_end_cust_site_use_code,
1013 end_cust_party_site_id = p_end_cust_party_site_id,
1014 end_cust_party_name = p_end_cust_party_name,
1015 end_cust_location = p_end_cust_location,
1016 end_cust_address = p_end_cust_address,
1017 end_cust_city = p_end_cust_city,
1018 end_cust_state = p_end_cust_state,
1019 end_cust_postal_code = p_end_cust_postal_code,
1020 end_cust_country = p_end_cust_country,
1021 end_cust_contact_party_id = p_end_cust_contact_party_id,
1022 end_cust_contact_name = p_end_cust_contact_name,
1023 end_cust_email = p_end_cust_email,
1024 end_cust_phone = p_end_cust_phone,
1025 end_cust_fax = p_end_cust_fax,
1026 bill_to_cust_account_id = p_bill_to_cust_account_id,
1027 bill_to_site_use_id = p_bill_to_site_use_id,
1028 bill_to_PARTY_NAME = p_bill_to_PARTY_NAME,
1029 bill_to_PARTY_ID = p_bill_to_PARTY_ID,
1030 bill_to_PARTY_site_id = p_bill_to_PARTY_site_id,
1031 bill_to_duns_number = p_bill_to_duns_number,
1032 bill_to_location = p_bill_to_location,
1033 bill_to_address = p_bill_to_address,
1034 bill_to_city = p_bill_to_city,
1035 bill_to_state = p_bill_to_state,
1036 bill_to_postal_code = p_bill_to_postal_code,
1037 bill_to_country = p_bill_to_country,
1038 bill_to_contact_party_id = p_bill_to_contact_party_id,
1039 bill_to_contact_name = p_bill_to_contact_name,
1040 bill_to_email = p_bill_to_email,
1041 bill_to_phone = p_bill_to_phone,
1042 bill_to_fax = p_bill_to_fax,
1043 ship_to_cust_account_id = p_ship_to_cust_account_id,
1044 ship_to_site_use_id = p_ship_to_site_use_id,
1045 ship_to_PARTY_NAME = p_ship_to_PARTY_NAME,
1046 ship_to_PARTY_ID = p_ship_to_PARTY_ID,
1047 ship_to_PARTY_site_id = p_ship_to_PARTY_site_id,
1048 ship_to_duns_number = p_ship_to_duns_number,
1049 ship_to_location = p_ship_to_location,
1050 ship_to_address = p_ship_to_address,
1051 ship_to_city = p_ship_to_city,
1052 ship_to_state = p_ship_to_state,
1053 ship_to_postal_code = p_ship_to_postal_code,
1054 ship_to_country = p_ship_to_country,
1055 ship_to_contact_party_id = p_ship_to_contact_party_id,
1056 ship_to_contact_name = p_ship_to_contact_name,
1057 ship_to_email = p_ship_to_email,
1058 ship_to_phone = p_ship_to_phone,
1059 ship_to_fax = p_ship_to_fax,
1060 ship_from_cust_account_id = p_ship_from_cust_account_id,
1061 ship_from_site_id = p_ship_from_site_id,
1062 ship_from_PARTY_NAME = p_ship_from_PARTY_NAME,
1063 ship_from_location = p_ship_from_location,
1064 ship_from_address = p_ship_from_address,
1065 ship_from_city = p_ship_from_city,
1066 ship_from_state = p_ship_from_state,
1067 ship_from_postal_code = p_ship_from_postal_code,
1068 ship_from_country = p_ship_from_country,
1069 ship_from_contact_party_id = p_ship_from_contact_party_id,
1070 ship_from_contact_name = p_ship_from_contact_name,
1071 ship_from_email = p_ship_from_email,
1072 ship_from_phone = p_ship_from_phone,
1073 ship_from_fax = p_ship_from_fax,
1074 sold_from_cust_account_id = p_sold_from_cust_account_id,
1075 sold_from_site_id = p_sold_from_site_id,
1076 sold_from_PARTY_NAME = p_sold_from_PARTY_NAME,
1077 sold_from_address = p_sold_from_address,
1078 sold_from_location = p_sold_from_location,
1079 sold_from_city = p_sold_from_city,
1080 sold_from_state = p_sold_from_state,
1081 sold_from_postal_code = p_sold_from_postal_code,
1082 sold_from_country = p_sold_from_country,
1083 sold_from_contact_party_id = p_sold_from_contact_party_id,
1084 sold_from_contact_name = p_sold_from_contact_name,
1085 sold_from_email = p_sold_from_email,
1086 sold_from_phone = p_sold_from_phone,
1087 sold_from_fax = p_sold_from_fax,
1088 order_number = p_order_number,
1089 date_ordered = p_date_ordered,
1090 po_number = p_po_number,
1091 po_release_number = p_po_release_number,
1092 po_type = p_po_type,
1093 agreement_id = p_agreement_id,
1094 agreement_name = p_agreement_name,
1095 agreement_type = p_agreement_type,
1096 agreement_price = p_agreement_price,
1097 agreement_uom_code = p_agreement_uom_code,
1098 corrected_agreement_id = p_corrected_agreement_id,
1099 corrected_agreement_name = p_corrected_agreement_name,
1100 price_list_id = p_price_list_id,
1101 price_list_name = p_price_list_name,
1102 orig_system_quantity = p_orig_system_quantity,
1103 orig_system_uom = p_orig_system_uom,
1104 orig_system_currency_code = p_orig_system_currency_code,
1105 orig_system_selling_price = p_orig_system_selling_price,
1106 orig_system_reference = p_orig_system_reference,
1107 orig_system_line_reference = p_orig_system_line_reference,
1108 orig_system_purchase_uom = p_orig_system_purchase_uom,
1109 orig_system_purchase_curr = p_orig_system_purchase_curr,
1110 orig_system_purchase_price = p_orig_system_purchase_price,
1111 orig_system_purchase_quantity = p_orig_system_purchase_quant,
1112 orig_system_agreement_uom = p_orig_system_agreement_uom,
1113 ORIG_SYSTEM_AGREEMENT_name = p_ORIG_SYSTEM_AGREEMENT_name,
1114 orig_system_agreement_type = p_orig_system_agreement_type,
1115 orig_system_agreement_status = p_orig_system_agreement_status,
1116 orig_system_agreement_curr = p_orig_system_agreement_curr,
1117 orig_system_agreement_price = p_orig_system_agreement_price,
1118 orig_system_agreement_quantity = p_orig_system_agreement_quant,
1119 orig_system_item_number = p_orig_system_item_number,
1120 quantity = p_quantity,
1121 uom_code = p_uom_code,
1122 currency_code = p_currency_code,
1123 exchange_rate = p_exchange_rate,
1124 exchange_rate_type = p_exchange_rate_type,
1125 exchange_rate_date = p_exchange_rate_date,
1126 selling_price = p_selling_price,
1127 purchase_uom_code = p_purchase_uom_code,
1128 invoice_number = p_invoice_number,
1129 date_invoiced= p_date_invoiced,
1130 date_shipped = p_date_shipped,
1131 credit_advice_date = p_credit_advice_date,
1132 product_category_id = p_product_category_id,
1133 category_name = p_category_name,
1134 inventory_item_segment1 = p_inventory_item_segment1,
1135 inventory_item_segment2 = p_inventory_item_segment2,
1136 inventory_item_segment3 = p_inventory_item_segment3,
1137 inventory_item_segment4 = p_inventory_item_segment4,
1138 inventory_item_segment5 = p_inventory_item_segment5,
1139 inventory_item_segment6 = p_inventory_item_segment6,
1140 inventory_item_segment7 = p_inventory_item_segment7,
1141 inventory_item_segment8 = p_inventory_item_segment8,
1142 inventory_item_segment9 = p_inventory_item_segment9,
1143 inventory_item_segment10 = p_inventory_item_segment10,
1144 inventory_item_segment11 = p_inventory_item_segment11,
1145 inventory_item_segment12 = p_inventory_item_segment12,
1146 inventory_item_segment13 = p_inventory_item_segment13,
1147 inventory_item_segment14 = p_inventory_item_segment14,
1148 inventory_item_segment15 = p_inventory_item_segment15,
1149 inventory_item_segment16 = p_inventory_item_segment16,
1150 inventory_item_segment17 = p_inventory_item_segment17,
1151 inventory_item_segment18 = p_inventory_item_segment18,
1152 inventory_item_segment19 = p_inventory_item_segment19,
1153 inventory_item_segment20 = p_inventory_item_segment20,
1154 inventory_item_id = p_inventory_item_id,
1155 item_description = p_item_description,
1156 upc_code = p_upc_code,
1157 item_number = p_item_number,
1158 claimed_amount = p_claimed_amount,
1159 purchase_price = p_purchase_price,
1160 acctd_purchase_price = p_acctd_purchase_price,
1161 net_adjusted_amount = p_net_adjusted_amount,
1162 accepted_amount = p_accepted_amount,
1163 total_accepted_amount = p_total_accepted_amount,
1164 allowed_amount = p_allowed_amount,
1165 total_allowed_amount = p_total_allowed_amount,
1166 calculated_price = p_calculated_price,
1167 acctd_calculated_price = p_acctd_calculated_price,
1168 calculated_amount = p_calculated_amount,
1169 line_tolerance_amount = p_line_tolerance_amount,
1170 total_claimed_amount = p_total_claimed_amount,
1171 credit_code = p_credit_code,
1172 direct_customer_flag = p_direct_customer_flag,
1173 duplicated_line_id = p_duplicated_line_id,
1174 duplicated_adjustment_id = p_duplicated_adjustment_id,
1175 order_type_id = p_order_type_id,
1176 order_type = p_order_type,
1177 order_category = p_order_category,
1178 dispute_code = p_dispute_code,
1179 data_source_code = p_data_source_code,
1180 tracing_flag = p_tracing_flag,
1181 header_attribute_category = p_header_attribute_category,
1182 header_attribute1 = p_header_attribute1,
1183 header_attribute2 = p_header_attribute2,
1184 header_attribute3 = p_header_attribute3,
1185 header_attribute4 = p_header_attribute4,
1186 header_attribute5 = p_header_attribute5,
1187 header_attribute6 = p_header_attribute6,
1188 header_attribute7 = p_header_attribute7,
1189 header_attribute8 = p_header_attribute8,
1190 header_attribute9 = p_header_attribute9,
1191 header_attribute10 = p_header_attribute10,
1192 header_attribute11 = p_header_attribute11,
1193 header_attribute12 = p_header_attribute12,
1194 header_attribute13 = p_header_attribute13,
1195 header_attribute14 = p_header_attribute14,
1196 header_attribute15 = p_header_attribute15,
1197 line_attribute_category = p_line_attribute_category,
1198 line_attribute1 = p_line_attribute1,
1199 line_attribute2 = p_line_attribute2,
1200 line_attribute3 = p_line_attribute3,
1201 line_attribute4 = p_line_attribute4,
1202 line_attribute5 = p_line_attribute5,
1203 line_attribute6 = p_line_attribute6,
1204 line_attribute7 = p_line_attribute7,
1205 line_attribute8 = p_line_attribute8,
1206 line_attribute9 = p_line_attribute9,
1207 line_attribute10 = p_line_attribute10,
1208 line_attribute11 = p_line_attribute11,
1209 line_attribute12 = p_line_attribute12,
1210 line_attribute13 = p_line_attribute13,
1211 line_attribute14 = p_line_attribute14,
1212 line_attribute15 = p_line_attribute15,
1213 org_id = p_org_id
1214 WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID
1215 AND object_version_number = p_object_version_number;
1216
1217 IF (SQL%NOTFOUND) THEN
1218 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219 END IF;
1220 END Update_Row;
1221
1222
1223 ----------------------------------------------------------
1224 ---- MEDIA ----
1225 ----------------------------------------------------------
1226
1227 -- ========================================================
1228 --
1229 -- NAME
1230 -- createDeleteBody
1231 --
1232 -- PURPOSE
1233 --
1234 -- NOTES
1235 --
1236 -- HISTORY
1237 --
1238 -- ========================================================
1239 PROCEDURE Delete_Row(
1240 p_RESALE_LINE_INT_ID NUMBER)
1241 IS
1242 BEGIN
1243 DELETE FROM OZF_RESALE_LINES_INT_ALL
1244 WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID;
1245 If (SQL%NOTFOUND) then
1246 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247 End If;
1248 END Delete_Row ;
1249
1250
1251
1252 ----------------------------------------------------------
1253 ---- MEDIA ----
1254 ----------------------------------------------------------
1255
1256 -- ========================================================
1257 --
1258 -- NAME
1259 -- createLockBody
1260 --
1261 -- PURPOSE
1262 --
1263 -- NOTES
1264 --
1265 -- HISTORY
1266 --
1267 -- ========================================================
1268 PROCEDURE Lock_Row(
1269 p_resale_line_int_id NUMBER,
1270 p_object_version_number NUMBER,
1271 p_last_update_date DATE,
1272 p_last_updated_by NUMBER,
1273 p_creation_date DATE,
1274 p_request_id NUMBER,
1275 p_created_by NUMBER,
1276 p_created_from VARCHAR2,
1277 p_last_update_login NUMBER,
1278 p_program_application_id NUMBER,
1279 p_program_update_date DATE,
1280 p_program_id NUMBER,
1281 p_response_type VARCHAR2,
1282 p_response_code VARCHAR2,
1283 p_reject_reason_code VARCHAR2,
1284 p_followup_action_code VARCHAR2,
1285 p_resale_transfer_type VARCHAR2,
1286 p_product_trans_movement_type VARCHAR2,
1287 p_product_transfer_date DATE,
1288 p_resale_batch_id NUMBER,
1289 p_status_code VARCHAR2,
1290 p_end_cust_party_id NUMBER,
1291 p_end_cust_site_use_id NUMBER,
1292 p_end_cust_site_use_code VARCHAR2,
1293 p_end_cust_party_site_id NUMBER,
1294 p_end_cust_party_name VARCHAR2,
1295 p_end_cust_location VARCHAR2,
1296 p_end_cust_address VARCHAR2,
1297 p_end_cust_city VARCHAR2,
1298 p_end_cust_state VARCHAR2,
1299 p_end_cust_postal_code VARCHAR2,
1300 p_end_cust_country VARCHAR2,
1301 p_end_cust_contact_party_id NUMBER,
1302 p_end_cust_contact_name VARCHAR2,
1303 p_end_cust_email VARCHAR2,
1304 p_end_cust_phone VARCHAR2,
1305 p_end_cust_fax VARCHAR2,
1306 p_bill_to_cust_account_id NUMBER,
1307 p_bill_to_site_use_id NUMBER,
1308 p_bill_to_PARTY_NAME VARCHAR2,
1309 p_bill_to_PARTY_ID NUMBER,
1310 p_bill_to_PARTY_site_id NUMBER,
1311 p_bill_to_location VARCHAR2,
1312 p_bill_to_duns_number varchar2,
1313 p_bill_to_address VARCHAR2,
1314 p_bill_to_city VARCHAR2,
1315 p_bill_to_state VARCHAR2,
1316 p_bill_to_postal_code VARCHAR2,
1317 p_bill_to_country VARCHAR2,
1318 p_bill_to_contact_party_id NUMBER,
1319 p_bill_to_contact_name VARCHAR2,
1320 p_bill_to_email VARCHAR2,
1321 p_bill_to_phone VARCHAR2,
1322 p_bill_to_fax VARCHAR2,
1323 p_ship_to_cust_account_id NUMBER,
1324 p_ship_to_site_use_id NUMBER,
1325 p_ship_to_PARTY_NAME VARCHAR2,
1326 p_ship_to_PARTY_ID NUMBER,
1327 p_ship_to_PARTY_site_id NUMBER,
1328 p_ship_to_duns_number varchar2,
1329 p_ship_to_location VARCHAR2,
1330 p_ship_to_address VARCHAR2,
1331 p_ship_to_city VARCHAR2,
1332 p_ship_to_state VARCHAR2,
1333 p_ship_to_postal_code VARCHAR2,
1334 p_ship_to_country VARCHAR2,
1335 p_ship_to_contact_party_id NUMBER,
1336 p_ship_to_contact_name VARCHAR2,
1337 p_ship_to_email VARCHAR2,
1338 p_ship_to_phone VARCHAR2,
1339 p_ship_to_fax VARCHAR2,
1340 p_ship_from_cust_account_id NUMBER,
1341 p_ship_from_site_id NUMBER,
1342 p_ship_from_PARTY_NAME VARCHAR2,
1343 p_ship_from_location VARCHAR2,
1344 p_ship_from_address VARCHAR2,
1345 p_ship_from_city VARCHAR2,
1346 p_ship_from_state VARCHAR2,
1347 p_ship_from_postal_code VARCHAR2,
1348 p_ship_from_country VARCHAR2,
1349 p_ship_from_contact_party_id NUMBER,
1350 p_ship_from_contact_name VARCHAR2,
1351 p_ship_from_email VARCHAR2,
1352 p_ship_from_phone VARCHAR2,
1353 p_ship_from_fax VARCHAR2,
1354 p_sold_from_cust_account_id NUMBER,
1355 p_sold_from_site_id NUMBER,
1356 p_sold_from_PARTY_NAME VARCHAR2,
1357 p_sold_from_location VARCHAR2,
1358 p_sold_from_address VARCHAR2,
1359 p_sold_from_city VARCHAR2,
1360 p_sold_from_state VARCHAR2,
1361 p_sold_from_postal_code VARCHAR2,
1362 p_sold_from_country VARCHAR2,
1363 p_sold_from_contact_party_id NUMBER,
1364 p_sold_from_contact_name VARCHAR2,
1365 p_sold_from_email VARCHAR2,
1366 p_sold_from_phone VARCHAR2,
1367 p_sold_from_fax VARCHAR2,
1368 p_order_number VARCHAR2,
1369 p_date_ordered DATE,
1370 p_po_number VARCHAR2,
1371 p_po_release_number VARCHAR2,
1372 p_po_type VARCHAR2,
1373 p_agreement_id NUMBER,
1374 p_agreement_name VARCHAR2,
1375 p_agreement_type VARCHAR2,
1376 p_agreement_price NUMBER,
1377 p_agreement_uom_code VARCHAR2,
1378 p_corrected_agreement_id NUMBER,
1379 p_corrected_agreement_name VARCHAR2,
1380 p_price_list_id NUMBER,
1381 p_price_list_name VARCHAR2,
1382 p_orig_system_quantity NUMBER,
1383 p_orig_system_uom VARCHAR2,
1384 p_orig_system_currency_code VARCHAR2,
1385 p_orig_system_selling_price NUMBER,
1386 p_orig_system_reference VARCHAR2,
1387 p_orig_system_line_reference VARCHAR2,
1388 p_orig_system_purchase_uom varchar2,
1389 p_orig_system_purchase_curr VARCHAR2,
1390 p_orig_system_purchase_price NUMBER,
1391 p_orig_system_purchase_quant NUMBER,
1392 p_orig_system_agreement_uom varchar2,
1393 p_ORIG_SYSTEM_AGREEMENT_name varchar2,
1394 p_orig_system_agreement_type VARCHAR2,
1395 p_orig_system_agreement_status VARCHAR2,
1396 p_orig_system_agreement_curr VARCHAR2,
1397 p_orig_system_agreement_price NUMBER,
1398 p_orig_system_agreement_quant NUMBER,
1399 p_orig_system_item_number varchar2,
1400 p_quantity NUMBER,
1401 p_uom_code VARCHAR2,
1402 p_currency_code VARCHAR2,
1403 p_exchange_rate NUMBER,
1404 p_exchange_rate_type VARCHAR2,
1405 p_exchange_rate_date DATE,
1406 p_selling_price NUMBER,
1407 p_purchase_uom_code VARCHAR2,
1408 p_invoice_number VARCHAR2,
1409 p_date_invoiced DATE,
1410 p_date_shipped DATE,
1411 p_credit_advice_date DATE,
1412 p_product_category_id NUMBER,
1413 p_category_name VARCHAR2,
1414 p_inventory_item_segment1 VARCHAR2,
1415 p_inventory_item_segment2 VARCHAR2,
1416 p_inventory_item_segment3 VARCHAR2,
1417 p_inventory_item_segment4 VARCHAR2,
1418 p_inventory_item_segment5 VARCHAR2,
1419 p_inventory_item_segment6 VARCHAR2,
1420 p_inventory_item_segment7 VARCHAR2,
1421 p_inventory_item_segment8 VARCHAR2,
1422 p_inventory_item_segment9 VARCHAR2,
1423 p_inventory_item_segment10 VARCHAR2,
1424 p_inventory_item_segment11 VARCHAR2,
1425 p_inventory_item_segment12 VARCHAR2,
1426 p_inventory_item_segment13 VARCHAR2,
1427 p_inventory_item_segment14 VARCHAR2,
1428 p_inventory_item_segment15 VARCHAR2,
1429 p_inventory_item_segment16 VARCHAR2,
1430 p_inventory_item_segment17 VARCHAR2,
1431 p_inventory_item_segment18 VARCHAR2,
1432 p_inventory_item_segment19 VARCHAR2,
1433 p_inventory_item_segment20 VARCHAR2,
1434 p_inventory_item_id NUMBER,
1435 p_item_description VARCHAR2,
1436 p_upc_code VARCHAR2,
1437 p_item_number VARCHAR2,
1438 p_claimed_amount NUMBER,
1439 p_purchase_price NUMBER,
1440 p_acctd_purchase_price NUMBER,
1441 p_net_adjusted_amount NUMBER,
1442 p_accepted_amount NUMBER,
1443 p_total_accepted_amount NUMBER,
1444 p_allowed_amount NUMBER,
1445 p_total_allowed_amount NUMBER,
1446 p_calculated_price NUMBER,
1447 p_acctd_calculated_price NUMBER,
1448 p_calculated_amount NUMBER,
1449 p_line_tolerance_amount NUMBER,
1450 p_total_claimed_amount NUMBER,
1451 p_credit_code VARCHAR2,
1452 p_direct_customer_flag VARCHAR2,
1453 p_duplicated_line_id number,
1454 p_duplicated_adjustment_id number,
1455 p_order_type_id NUMBER,
1456 p_order_type VARCHAR2,
1457 p_order_category VARCHAR2,
1458 p_dispute_code VARCHAR2,
1459 p_data_source_code VARCHAR2,
1460 p_tracing_flag VARCHAR2,
1461 p_header_attribute_category VARCHAR2,
1462 p_header_attribute1 VARCHAR2,
1463 p_header_attribute2 VARCHAR2,
1464 p_header_attribute3 VARCHAR2,
1465 p_header_attribute4 VARCHAR2,
1466 p_header_attribute5 VARCHAR2,
1467 p_header_attribute6 VARCHAR2,
1468 p_header_attribute7 VARCHAR2,
1469 p_header_attribute8 VARCHAR2,
1470 p_header_attribute9 VARCHAR2,
1471 p_header_attribute10 VARCHAR2,
1472 p_header_attribute11 VARCHAR2,
1473 p_header_attribute12 VARCHAR2,
1474 p_header_attribute13 VARCHAR2,
1475 p_header_attribute14 VARCHAR2,
1476 p_header_attribute15 VARCHAR2,
1477 p_line_attribute_category VARCHAR2,
1478 p_line_attribute1 VARCHAR2,
1479 p_line_attribute2 VARCHAR2,
1480 p_line_attribute3 VARCHAR2,
1481 p_line_attribute4 VARCHAR2,
1482 p_line_attribute5 VARCHAR2,
1483 p_line_attribute6 VARCHAR2,
1484 p_line_attribute7 VARCHAR2,
1485 p_line_attribute8 VARCHAR2,
1486 p_line_attribute9 VARCHAR2,
1487 p_line_attribute10 VARCHAR2,
1488 p_line_attribute11 VARCHAR2,
1489 p_line_attribute12 VARCHAR2,
1490 p_line_attribute13 VARCHAR2,
1491 p_line_attribute14 VARCHAR2,
1492 p_line_attribute15 VARCHAR2,
1493 p_org_id NUMBER)
1494
1495 IS
1496 CURSOR C IS
1497 SELECT *
1498 FROM OZF_RESALE_LINES_INT_ALL
1499 WHERE RESALE_LINE_INT_ID = p_RESALE_LINE_INT_ID
1500 FOR UPDATE of RESALE_LINE_INT_ID NOWAIT;
1501 Recinfo C%ROWTYPE;
1502 BEGIN
1503 OPEN c;
1504 FETCH c INTO Recinfo;
1505 If (c%NOTFOUND) then
1506 CLOSE c;
1507 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1508 APP_EXCEPTION.RAISE_EXCEPTION;
1509 END IF;
1510 CLOSE C;
1511 IF (
1512 ( Recinfo.resale_line_int_id = p_resale_line_int_id)
1513 AND ( ( Recinfo.object_version_number = p_object_version_number)
1514 OR ( ( Recinfo.object_version_number IS NULL )
1515 AND ( p_object_version_number IS NULL )))
1516 AND ( ( Recinfo.last_update_date = p_last_update_date)
1517 OR ( ( Recinfo.last_update_date IS NULL )
1518 AND ( p_last_update_date IS NULL )))
1519 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
1520 OR ( ( Recinfo.last_updated_by IS NULL )
1521 AND ( p_last_updated_by IS NULL )))
1522 AND ( ( Recinfo.creation_date = p_creation_date)
1523 OR ( ( Recinfo.creation_date IS NULL )
1524 AND ( p_creation_date IS NULL )))
1525 AND ( ( Recinfo.request_id = p_request_id)
1526 OR ( ( Recinfo.request_id IS NULL )
1527 AND ( p_request_id IS NULL )))
1528 AND ( ( Recinfo.created_by = p_created_by)
1529 OR ( ( Recinfo.created_by IS NULL )
1530 AND ( p_created_by IS NULL )))
1531 AND ( ( Recinfo.created_from = p_created_from)
1532 OR ( ( Recinfo.created_from IS NULL )
1533 AND ( p_created_from IS NULL )))
1534 AND ( ( Recinfo.last_update_login = p_last_update_login)
1535 OR ( ( Recinfo.last_update_login IS NULL )
1536 AND ( p_last_update_login IS NULL )))
1537 AND ( ( Recinfo.program_application_id = p_program_application_id)
1538 OR ( ( Recinfo.program_application_id IS NULL )
1539 AND ( p_program_application_id IS NULL )))
1540 AND ( ( Recinfo.program_update_date = p_program_update_date)
1541 OR ( ( Recinfo.program_update_date IS NULL )
1542 AND ( p_program_update_date IS NULL )))
1543 AND ( ( Recinfo.program_id = p_program_id)
1544 OR ( ( Recinfo.program_id IS NULL )
1545 AND ( p_program_id IS NULL )))
1546 AND ( ( Recinfo.response_type = p_response_type)
1547 OR ( ( Recinfo.response_type IS NULL )
1548 AND ( p_response_type IS NULL )))
1549 AND ( ( Recinfo.response_code = p_response_code)
1550 OR ( ( Recinfo.response_code IS NULL )
1551 AND ( p_response_code IS NULL )))
1552 AND ( ( Recinfo.reject_reason_code = p_reject_reason_code)
1553 OR ( ( Recinfo.reject_reason_code IS NULL )
1554 AND ( p_reject_reason_code IS NULL )))
1555 AND ( ( Recinfo.followup_action_code = p_followup_action_code)
1556 OR ( ( Recinfo.followup_action_code IS NULL )
1557 AND ( p_followup_action_code IS NULL )))
1558 AND ( ( Recinfo.resale_transfer_type = p_resale_transfer_type)
1559 OR ( ( Recinfo.resale_transfer_type IS NULL )
1560 AND ( p_resale_transfer_type IS NULL )))
1561 AND ( ( Recinfo.product_transfer_movement_type = p_product_trans_movement_type)
1562 OR ( ( Recinfo.product_transfer_movement_type IS NULL )
1563 AND ( p_product_trans_movement_type IS NULL )))
1564 AND ( ( Recinfo.product_transfer_date = p_product_transfer_date)
1565 OR ( ( Recinfo.product_transfer_date IS NULL )
1566 AND ( p_product_transfer_date IS NULL )))
1567 AND ( ( Recinfo.resale_batch_id = p_resale_batch_id)
1568 OR ( ( Recinfo.resale_batch_id IS NULL )
1569 AND ( p_resale_batch_id IS NULL )))
1570 AND ( ( Recinfo.status_code = p_status_code)
1571 OR ( ( Recinfo.status_code IS NULL )
1572 AND ( p_status_code IS NULL )))
1573 AND ( ( Recinfo.end_cust_party_id = p_end_cust_party_id)
1574 OR ( ( Recinfo.end_cust_party_id IS NULL )
1575 AND ( p_end_cust_party_id IS NULL )))
1576 AND ( ( Recinfo.end_cust_site_use_id = p_end_cust_site_use_id)
1577 OR ( ( Recinfo.end_cust_site_use_id IS NULL )
1578 AND ( p_end_cust_site_use_id IS NULL )))
1579 AND ( ( Recinfo.end_cust_site_use_code = p_end_cust_site_use_code)
1580 OR ( ( Recinfo.end_cust_site_use_code IS NULL )
1581 AND ( p_end_cust_site_use_code IS NULL )))
1582 AND ( ( Recinfo.end_cust_party_site_id = p_end_cust_party_site_id)
1583 OR ( ( Recinfo.end_cust_party_site_id IS NULL )
1584 AND ( p_end_cust_party_site_id IS NULL )))
1585 AND ( ( Recinfo.end_cust_party_name = p_end_cust_party_name)
1586 OR ( ( Recinfo.end_cust_party_name IS NULL )
1587 AND ( p_end_cust_party_name IS NULL )))
1588 AND ( ( Recinfo.end_cust_location = p_end_cust_location)
1589 OR ( ( Recinfo.end_cust_location IS NULL )
1590 AND ( p_end_cust_location IS NULL )))
1591 AND ( ( Recinfo.end_cust_address = p_end_cust_address)
1592 OR ( ( Recinfo.end_cust_address IS NULL )
1593 AND ( p_end_cust_address IS NULL )))
1594 AND ( ( Recinfo.end_cust_city = p_end_cust_city)
1595 OR ( ( Recinfo.end_cust_city IS NULL )
1596 AND ( p_end_cust_city IS NULL )))
1597 AND ( ( Recinfo.end_cust_state = p_end_cust_state)
1598 OR ( ( Recinfo.end_cust_state IS NULL )
1599 AND ( p_end_cust_state IS NULL )))
1600 AND ( ( Recinfo.end_cust_postal_code = p_end_cust_postal_code)
1601 OR ( ( Recinfo.end_cust_postal_code IS NULL )
1602 AND ( p_end_cust_postal_code IS NULL )))
1603 AND ( ( Recinfo.end_cust_country = p_end_cust_country)
1604 OR ( ( Recinfo.end_cust_country IS NULL )
1605 AND ( p_end_cust_country IS NULL )))
1606 AND ( ( Recinfo.end_cust_contact_party_id = p_end_cust_contact_party_id)
1607 OR ( ( Recinfo.end_cust_contact_party_id IS NULL )
1608 AND ( p_end_cust_contact_party_id IS NULL )))
1609 AND ( ( Recinfo.end_cust_contact_name = p_end_cust_contact_name)
1610 OR ( ( Recinfo.end_cust_contact_name IS NULL )
1611 AND ( p_end_cust_contact_name IS NULL )))
1612 AND ( ( Recinfo.end_cust_email = p_end_cust_email)
1613 OR ( ( Recinfo.end_cust_email IS NULL )
1614 AND ( p_end_cust_email IS NULL )))
1615 AND ( ( Recinfo.end_cust_phone = p_end_cust_phone)
1616 OR ( ( Recinfo.end_cust_phone IS NULL )
1617 AND ( p_end_cust_phone IS NULL )))
1618 AND ( ( Recinfo.end_cust_fax = p_end_cust_fax)
1619 OR ( ( Recinfo.end_cust_fax IS NULL )
1620 AND ( p_end_cust_fax IS NULL )))
1621 AND ( ( Recinfo.bill_to_cust_account_id = p_bill_to_cust_account_id)
1622 OR ( ( Recinfo.bill_to_cust_account_id IS NULL )
1623 AND ( p_bill_to_cust_account_id IS NULL )))
1624 AND ( ( Recinfo.bill_to_site_use_id = p_bill_to_site_use_id)
1625 OR ( ( Recinfo.bill_to_site_use_id IS NULL )
1626 AND ( p_bill_to_site_use_id IS NULL )))
1627 AND ( ( Recinfo.bill_to_PARTY_NAME = p_bill_to_PARTY_NAME)
1628 OR ( ( Recinfo.bill_to_PARTY_NAME IS NULL )
1629 AND ( p_bill_to_PARTY_NAME IS NULL )))
1630 AND ( ( Recinfo.bill_to_PARTY_ID = p_bill_to_PARTY_ID)
1631 OR ( ( Recinfo.bill_to_PARTY_ID IS NULL )
1632 AND ( p_bill_to_PARTY_ID IS NULL )))
1633 AND ( ( Recinfo.bill_to_PARTY_site_id = p_bill_to_PARTY_site_id)
1634 OR ( ( Recinfo.bill_to_PARTY_site_id IS NULL )
1635 AND ( p_bill_to_PARTY_site_id IS NULL )))
1636 AND ( ( Recinfo.bill_to_duns_number = p_bill_to_duns_number)
1637 OR ( ( Recinfo.bill_to_duns_number IS NULL )
1638 AND ( p_bill_to_duns_number IS NULL )))
1639 AND ( ( Recinfo.bill_to_location = p_bill_to_location)
1640 OR ( ( Recinfo.bill_to_location IS NULL )
1641 AND ( p_bill_to_location IS NULL )))
1642 AND ( ( Recinfo.bill_to_address = p_bill_to_address)
1643 OR ( ( Recinfo.bill_to_address IS NULL )
1644 AND ( p_bill_to_address IS NULL )))
1645 AND ( ( Recinfo.bill_to_city = p_bill_to_city)
1646 OR ( ( Recinfo.bill_to_city IS NULL )
1647 AND ( p_bill_to_city IS NULL )))
1648 AND ( ( Recinfo.bill_to_state = p_bill_to_state)
1649 OR ( ( Recinfo.bill_to_state IS NULL )
1650 AND ( p_bill_to_state IS NULL )))
1651 AND ( ( Recinfo.bill_to_postal_code = p_bill_to_postal_code)
1652 OR ( ( Recinfo.bill_to_postal_code IS NULL )
1653 AND ( p_bill_to_postal_code IS NULL )))
1654 AND ( ( Recinfo.bill_to_country = p_bill_to_country)
1655 OR ( ( Recinfo.bill_to_country IS NULL )
1656 AND ( p_bill_to_country IS NULL )))
1657 AND ( ( Recinfo.bill_to_contact_party_id = p_bill_to_contact_party_id)
1658 OR ( ( Recinfo.bill_to_contact_party_id IS NULL )
1659 AND ( p_bill_to_contact_party_id IS NULL )))
1660 AND ( ( Recinfo.bill_to_contact_name = p_bill_to_contact_name)
1661 OR ( ( Recinfo.bill_to_contact_name IS NULL )
1662 AND ( p_bill_to_contact_name IS NULL )))
1663 AND ( ( Recinfo.bill_to_email = p_bill_to_email)
1664 OR ( ( Recinfo.bill_to_email IS NULL )
1665 AND ( p_bill_to_email IS NULL )))
1666 AND ( ( Recinfo.bill_to_phone = p_bill_to_phone)
1667 OR ( ( Recinfo.bill_to_phone IS NULL )
1668 AND ( p_bill_to_phone IS NULL )))
1669 AND ( ( Recinfo.bill_to_fax = p_bill_to_fax)
1670 OR ( ( Recinfo.bill_to_fax IS NULL )
1671 AND ( p_bill_to_fax IS NULL )))
1672 AND ( ( Recinfo.ship_to_cust_account_id = p_ship_to_cust_account_id)
1673 OR ( ( Recinfo.ship_to_cust_account_id IS NULL )
1674 AND ( p_ship_to_cust_account_id IS NULL )))
1675 AND ( ( Recinfo.ship_to_site_use_id = p_ship_to_site_use_id)
1676 OR ( ( Recinfo.ship_to_site_use_id IS NULL )
1677 AND ( p_ship_to_site_use_id IS NULL )))
1678 AND ( ( Recinfo.ship_to_PARTY_NAME = p_ship_to_PARTY_NAME)
1679 OR ( ( Recinfo.ship_to_PARTY_NAME IS NULL )
1680 AND ( p_ship_to_PARTY_NAME IS NULL )))
1681 AND ( ( Recinfo.ship_to_PARTY_ID = p_ship_to_PARTY_ID)
1682 OR ( ( Recinfo.ship_to_PARTY_ID IS NULL )
1683 AND ( p_ship_to_PARTY_ID IS NULL )))
1684 AND ( ( Recinfo.ship_to_PARTY_site_id = p_ship_to_PARTY_site_id)
1685 OR ( ( Recinfo.ship_to_PARTY_site_id IS NULL )
1686 AND ( p_ship_to_PARTY_site_id IS NULL )))
1687 AND ( ( Recinfo.ship_to_duns_number = p_ship_to_duns_number)
1688 OR ( ( Recinfo.ship_to_duns_number IS NULL )
1689 AND ( p_ship_to_duns_number IS NULL )))
1690 AND ( ( Recinfo.ship_to_location = p_ship_to_location)
1691 OR ( ( Recinfo.ship_to_location IS NULL )
1692 AND ( p_ship_to_location IS NULL )))
1693 AND ( ( Recinfo.ship_to_address = p_ship_to_address)
1694 OR ( ( Recinfo.ship_to_address IS NULL )
1695 AND ( p_ship_to_address IS NULL )))
1696 AND ( ( Recinfo.ship_to_city = p_ship_to_city)
1697 OR ( ( Recinfo.ship_to_city IS NULL )
1698 AND ( p_ship_to_city IS NULL )))
1699 AND ( ( Recinfo.ship_to_state = p_ship_to_state)
1700 OR ( ( Recinfo.ship_to_state IS NULL )
1701 AND ( p_ship_to_state IS NULL )))
1702 AND ( ( Recinfo.ship_to_postal_code = p_ship_to_postal_code)
1703 OR ( ( Recinfo.ship_to_postal_code IS NULL )
1704 AND ( p_ship_to_postal_code IS NULL )))
1705 AND ( ( Recinfo.ship_to_country = p_ship_to_country)
1706 OR ( ( Recinfo.ship_to_country IS NULL )
1707 AND ( p_ship_to_country IS NULL )))
1708 AND ( ( Recinfo.ship_to_contact_party_id = p_ship_to_contact_party_id)
1709 OR ( ( Recinfo.ship_to_contact_party_id IS NULL )
1710 AND ( p_ship_to_contact_party_id IS NULL )))
1711 AND ( ( Recinfo.ship_to_contact_party_id = p_ship_to_contact_party_id)
1712 OR ( ( Recinfo.ship_to_contact_name IS NULL )
1713 AND ( p_ship_to_contact_name IS NULL )))
1714 AND ( ( Recinfo.ship_to_email = p_ship_to_email)
1715 OR ( ( Recinfo.ship_to_email IS NULL )
1716 AND ( p_ship_to_email IS NULL )))
1717 AND ( ( Recinfo.ship_to_phone = p_ship_to_phone)
1718 OR ( ( Recinfo.ship_to_phone IS NULL )
1719 AND ( p_ship_to_phone IS NULL )))
1720 AND ( ( Recinfo.ship_to_fax = p_ship_to_fax)
1721 OR ( ( Recinfo.ship_to_fax IS NULL )
1722 AND ( p_ship_to_fax IS NULL )))
1723 AND ( ( Recinfo.ship_from_cust_account_id = p_ship_from_cust_account_id)
1724 OR ( ( Recinfo.ship_from_cust_account_id IS NULL )
1725 AND ( p_ship_from_cust_account_id IS NULL )))
1726 AND ( ( Recinfo.ship_from_site_id = p_ship_from_site_id)
1727 OR ( ( Recinfo.ship_from_site_id IS NULL )
1728 AND ( p_ship_from_site_id IS NULL )))
1729 AND ( ( Recinfo.ship_from_PARTY_NAME = p_ship_from_PARTY_NAME)
1730 OR ( ( Recinfo.ship_from_PARTY_NAME IS NULL )
1731 AND ( p_ship_from_PARTY_NAME IS NULL )))
1732 AND ( ( Recinfo.ship_from_location = p_ship_from_location)
1733 OR ( ( Recinfo.ship_from_location IS NULL )
1734 AND ( p_ship_from_location IS NULL )))
1735 AND ( ( Recinfo.ship_from_address = p_ship_from_address)
1736 OR ( ( Recinfo.ship_from_address IS NULL )
1737 AND ( p_ship_from_address IS NULL )))
1738 AND ( ( Recinfo.ship_from_city = p_ship_from_city)
1739 OR ( ( Recinfo.ship_from_city IS NULL )
1740 AND ( p_ship_from_city IS NULL )))
1741 AND ( ( Recinfo.ship_from_state = p_ship_from_state)
1742 OR ( ( Recinfo.ship_from_state IS NULL )
1743 AND ( p_ship_from_state IS NULL )))
1744 AND ( ( Recinfo.ship_from_postal_code = p_ship_from_postal_code)
1745 OR ( ( Recinfo.ship_from_postal_code IS NULL )
1746 AND ( p_ship_from_postal_code IS NULL )))
1747 AND ( ( Recinfo.ship_from_country = p_ship_from_country)
1748 OR ( ( Recinfo.ship_from_country IS NULL )
1749 AND ( p_ship_from_country IS NULL )))
1750 AND ( ( Recinfo.ship_from_contact_party_id = p_ship_from_contact_party_id)
1751 OR ( ( Recinfo.ship_from_contact_party_id IS NULL )
1752 AND ( p_ship_from_contact_party_id IS NULL )))
1753 AND ( ( Recinfo.ship_from_contact_name = p_ship_from_contact_name)
1754 OR ( ( Recinfo.ship_from_contact_name IS NULL )
1755 AND ( p_ship_from_contact_name IS NULL )))
1756 AND ( ( Recinfo.ship_from_email = p_ship_from_email)
1757 OR ( ( Recinfo.ship_from_email IS NULL )
1758 AND ( p_ship_from_email IS NULL )))
1759 AND ( ( Recinfo.ship_from_phone = p_ship_from_phone)
1760 OR ( ( Recinfo.ship_from_phone IS NULL )
1761 AND ( p_ship_from_phone IS NULL )))
1762 AND ( ( Recinfo.ship_from_fax = p_ship_from_fax)
1763 OR ( ( Recinfo.ship_from_fax IS NULL )
1764 AND ( p_ship_from_fax IS NULL )))
1765 AND ( ( Recinfo.sold_from_cust_account_id = p_sold_from_cust_account_id)
1766 OR ( ( Recinfo.sold_from_cust_account_id IS NULL )
1767 AND ( p_sold_from_cust_account_id IS NULL )))
1768 AND ( ( Recinfo.sold_from_site_id = p_sold_from_site_id)
1769 OR ( ( Recinfo.sold_from_site_id IS NULL )
1770 AND ( p_sold_from_site_id IS NULL )))
1771 AND ( ( Recinfo.sold_from_PARTY_NAME = p_sold_from_PARTY_NAME)
1772 OR ( ( Recinfo.sold_from_PARTY_NAME IS NULL )
1773 AND ( p_sold_from_PARTY_NAME IS NULL )))
1774 AND ( ( Recinfo.sold_from_location = p_sold_from_location)
1775 OR ( ( Recinfo.sold_from_location IS NULL )
1776 AND ( p_sold_from_location IS NULL )))
1777 AND ( ( Recinfo.sold_from_address = p_sold_from_address)
1778 OR ( ( Recinfo.sold_from_address IS NULL )
1779 AND ( p_sold_from_address IS NULL )))
1780 AND ( ( Recinfo.sold_from_city = p_sold_from_city)
1781 OR ( ( Recinfo.sold_from_city IS NULL )
1782 AND ( p_sold_from_city IS NULL )))
1783 AND ( ( Recinfo.sold_from_state = p_sold_from_state)
1784 OR ( ( Recinfo.sold_from_state IS NULL )
1785 AND ( p_sold_from_state IS NULL )))
1786 AND ( ( Recinfo.sold_from_postal_code = p_sold_from_postal_code)
1787 OR ( ( Recinfo.sold_from_postal_code IS NULL )
1788 AND ( p_sold_from_postal_code IS NULL )))
1789 AND ( ( Recinfo.sold_from_country = p_sold_from_country)
1790 OR ( ( Recinfo.sold_from_country IS NULL )
1791 AND ( p_sold_from_country IS NULL )))
1792 AND ( ( Recinfo.sold_from_contact_party_id = p_sold_from_contact_party_id)
1793 OR ( ( Recinfo.sold_from_contact_party_id IS NULL )
1794 AND ( p_sold_from_contact_party_id IS NULL )))
1795 AND ( ( Recinfo.sold_from_contact_name = p_sold_from_contact_name)
1796 OR ( ( Recinfo.sold_from_contact_name IS NULL )
1797 AND ( p_sold_from_contact_name IS NULL )))
1798 AND ( ( Recinfo.sold_from_email = p_sold_from_email)
1799 OR ( ( Recinfo.sold_from_email IS NULL )
1800 AND ( p_sold_from_email IS NULL )))
1801 AND ( ( Recinfo.sold_from_phone = p_sold_from_phone)
1802 OR ( ( Recinfo.sold_from_phone IS NULL )
1803 AND ( p_sold_from_phone IS NULL )))
1804 AND ( ( Recinfo.sold_from_fax = p_sold_from_fax)
1805 OR ( ( Recinfo.sold_from_fax IS NULL )
1806 AND ( p_sold_from_fax IS NULL )))
1807 AND ( ( Recinfo.order_number = p_order_number)
1808 OR ( ( Recinfo.order_number IS NULL )
1809 AND ( p_order_number IS NULL )))
1810 AND ( ( Recinfo.date_ordered = p_date_ordered)
1811 OR ( ( Recinfo.date_ordered IS NULL )
1812 AND ( p_date_ordered IS NULL )))
1813 AND ( ( Recinfo.po_number = p_po_number)
1814 OR ( ( Recinfo.po_number IS NULL )
1815 AND ( p_po_number IS NULL )))
1816 AND ( ( Recinfo.po_release_number = p_po_release_number)
1817 OR ( ( Recinfo.po_release_number IS NULL )
1818 AND ( p_po_release_number IS NULL )))
1819 AND ( ( Recinfo.po_type = p_po_type)
1820 OR ( ( Recinfo.po_type IS NULL )
1821 AND ( p_po_type IS NULL )))
1822 AND ( ( Recinfo.agreement_id = p_agreement_id)
1823 OR ( ( Recinfo.agreement_id IS NULL )
1824 AND ( p_agreement_id IS NULL )))
1825 AND ( ( Recinfo.agreement_name = p_agreement_name)
1826 OR ( ( Recinfo.agreement_name IS NULL )
1827 AND ( p_agreement_name IS NULL )))
1828 AND ( ( Recinfo.agreement_type = p_agreement_type)
1829 OR ( ( Recinfo.agreement_type IS NULL )
1830 AND ( p_agreement_type IS NULL )))
1831 AND ( ( Recinfo.agreement_price = p_agreement_price)
1832 OR ( ( Recinfo.agreement_price IS NULL )
1833 AND ( p_agreement_price IS NULL )))
1834 AND ( ( Recinfo.agreement_uom_code = p_agreement_uom_code)
1835 OR ( ( Recinfo.agreement_uom_code IS NULL )
1836 AND ( p_agreement_uom_code IS NULL )))
1837 AND ( ( Recinfo.corrected_agreement_id = p_corrected_agreement_id)
1838 OR ( ( Recinfo.corrected_agreement_id IS NULL )
1839 AND ( p_corrected_agreement_id IS NULL )))
1840 AND ( ( Recinfo.corrected_agreement_name = p_corrected_agreement_name)
1841 OR ( ( Recinfo.corrected_agreement_name IS NULL )
1842 AND ( p_corrected_agreement_name IS NULL )))
1843 AND ( ( Recinfo.price_list_id = p_price_list_id)
1844 OR ( ( Recinfo.price_list_id IS NULL )
1845 AND ( p_price_list_id IS NULL )))
1846 AND ( ( Recinfo.price_list_name = p_price_list_name)
1847 OR ( ( Recinfo.price_list_name IS NULL )
1848 AND ( p_price_list_name IS NULL )))
1849 AND ( ( Recinfo.orig_system_quantity = p_orig_system_quantity)
1850 OR ( ( Recinfo.orig_system_quantity IS NULL )
1851 AND ( p_orig_system_quantity IS NULL )))
1852 AND ( ( Recinfo.orig_system_uom = p_orig_system_uom)
1853 OR ( ( Recinfo.orig_system_uom IS NULL )
1854 AND ( p_orig_system_uom IS NULL )))
1855 AND ( ( Recinfo.orig_system_currency_code = p_orig_system_currency_code)
1856 OR ( ( Recinfo.orig_system_currency_code IS NULL )
1857 AND ( p_orig_system_currency_code IS NULL )))
1858 AND ( ( Recinfo.orig_system_selling_price = p_orig_system_selling_price)
1859 OR ( ( Recinfo.orig_system_selling_price IS NULL )
1860 AND ( p_orig_system_selling_price IS NULL )))
1861 AND ( ( Recinfo.orig_system_reference = p_orig_system_reference)
1862 OR ( ( Recinfo.orig_system_reference IS NULL )
1863 AND ( p_orig_system_reference IS NULL )))
1864 AND ( ( Recinfo.orig_system_line_reference = p_orig_system_line_reference)
1865 OR ( ( Recinfo.orig_system_line_reference IS NULL )
1866 AND ( p_orig_system_line_reference IS NULL )))
1867 AND ( ( Recinfo.orig_system_purchase_uom = p_orig_system_purchase_uom)
1868 OR ( ( Recinfo.orig_system_purchase_uom IS NULL )
1869 AND ( p_orig_system_purchase_uom IS NULL )))
1870 AND ( ( Recinfo.orig_system_purchase_curr = p_orig_system_purchase_curr)
1871 OR ( ( Recinfo.orig_system_purchase_curr IS NULL )
1872 AND ( p_orig_system_purchase_curr IS NULL )))
1873 AND ( ( Recinfo.orig_system_purchase_price = p_orig_system_purchase_price)
1874 OR ( ( Recinfo.orig_system_purchase_price IS NULL )
1875 AND ( p_orig_system_purchase_price IS NULL )))
1876 AND ( ( Recinfo.orig_system_purchase_quantity = p_orig_system_purchase_quant)
1877 OR ( ( Recinfo.orig_system_purchase_quantity IS NULL )
1878 AND ( p_orig_system_purchase_quant IS NULL )))
1879 AND ( ( Recinfo.orig_system_agreement_uom = p_orig_system_agreement_uom)
1880 OR ( ( Recinfo.orig_system_agreement_uom IS NULL )
1881 AND ( p_orig_system_agreement_uom IS NULL )))
1882 AND ( ( Recinfo.ORIG_SYSTEM_AGREEMENT_name = p_ORIG_SYSTEM_AGREEMENT_name)
1883 OR ( ( Recinfo.ORIG_SYSTEM_AGREEMENT_name IS NULL )
1884 AND ( p_ORIG_SYSTEM_AGREEMENT_name IS NULL )))
1885 AND ( ( Recinfo.orig_system_agreement_type = p_orig_system_agreement_type)
1886 OR ( ( Recinfo.orig_system_agreement_type IS NULL )
1887 AND ( p_orig_system_agreement_type IS NULL )))
1888 AND ( ( Recinfo.orig_system_agreement_status = p_orig_system_agreement_status)
1889 OR ( ( Recinfo.orig_system_agreement_status IS NULL )
1890 AND ( p_orig_system_agreement_status IS NULL )))
1891 AND ( ( Recinfo.orig_system_agreement_curr = p_orig_system_agreement_curr)
1892 OR ( ( Recinfo.orig_system_agreement_curr IS NULL )
1893 AND ( p_orig_system_agreement_curr IS NULL )))
1894 AND ( ( Recinfo.orig_system_agreement_price = p_orig_system_agreement_price)
1895 OR ( ( Recinfo.orig_system_agreement_price IS NULL )
1896 AND ( p_orig_system_agreement_price IS NULL )))
1897 AND ( ( Recinfo.orig_system_agreement_quantity = p_orig_system_agreement_quant)
1898 OR ( ( Recinfo.orig_system_agreement_quantity IS NULL )
1899 AND ( p_orig_system_agreement_quant IS NULL )))
1900 AND ( ( Recinfo.orig_system_item_number = p_orig_system_item_number)
1901 OR ( ( Recinfo.orig_system_item_number IS NULL )
1902 AND ( p_orig_system_item_number IS NULL )))
1903 AND ( ( Recinfo.quantity = p_quantity)
1904 OR ( ( Recinfo.quantity IS NULL )
1905 AND ( p_quantity IS NULL )))
1906 AND ( ( Recinfo.uom_code = p_uom_code)
1907 OR ( ( Recinfo.uom_code IS NULL )
1908 AND ( p_uom_code IS NULL )))
1909 AND ( ( Recinfo.currency_code = p_currency_code)
1910 OR ( ( Recinfo.currency_code IS NULL )
1911 AND ( p_currency_code IS NULL )))
1912 AND ( ( Recinfo.exchange_rate = p_exchange_rate)
1913 OR ( ( Recinfo.exchange_rate IS NULL )
1914 AND ( p_exchange_rate IS NULL )))
1915 AND ( ( Recinfo.exchange_rate_type = p_exchange_rate_type)
1916 OR ( ( Recinfo.exchange_rate_type IS NULL )
1917 AND ( p_exchange_rate_type IS NULL )))
1918 AND ( ( Recinfo.exchange_rate_date = p_exchange_rate_date)
1919 OR ( ( Recinfo.exchange_rate_date IS NULL )
1920 AND ( p_exchange_rate_date IS NULL )))
1921 AND ( ( Recinfo.selling_price = p_selling_price)
1922 OR ( ( Recinfo.selling_price IS NULL )
1923 AND ( p_selling_price IS NULL )))
1924 AND ( ( Recinfo.purchase_uom_code = p_purchase_uom_code)
1925 OR ( ( Recinfo.purchase_uom_code IS NULL )
1926 AND ( p_purchase_uom_code IS NULL )))
1927 AND ( ( Recinfo.invoice_number = p_invoice_number)
1928 OR ( ( Recinfo.invoice_number IS NULL )
1929 AND ( p_invoice_number IS NULL )))
1930 AND ( ( Recinfo.date_invoiced= p_date_invoiced)
1931 OR ( ( Recinfo.date_invoiced IS NULL )
1932 AND ( p_date_invoiced IS NULL )))
1933 AND ( ( Recinfo.date_shipped = p_date_shipped)
1934 OR ( ( Recinfo.date_shipped IS NULL )
1935 AND ( p_date_shipped IS NULL )))
1936 AND ( ( Recinfo.credit_advice_date = p_credit_advice_date)
1937 OR ( ( Recinfo.credit_advice_date IS NULL )
1938 AND ( p_credit_advice_date IS NULL )))
1939 AND ( ( Recinfo.product_category_id = p_product_category_id)
1940 OR ( ( Recinfo.product_category_id IS NULL )
1941 AND ( p_product_category_id IS NULL )))
1942 AND ( ( Recinfo.category_name = p_category_name)
1943 OR ( ( Recinfo.category_name IS NULL )
1944 AND ( p_category_name IS NULL )))
1945 AND ( ( Recinfo.inventory_item_segment1 = p_inventory_item_segment1)
1946 OR ( ( Recinfo.inventory_item_segment1 IS NULL )
1947 AND ( p_inventory_item_segment1 IS NULL )))
1948 AND ( ( Recinfo.inventory_item_segment2 = p_inventory_item_segment2)
1949 OR ( ( Recinfo.inventory_item_segment2 IS NULL )
1950 AND ( p_inventory_item_segment2 IS NULL )))
1951 AND ( ( Recinfo.inventory_item_segment3 = p_inventory_item_segment3)
1952 OR ( ( Recinfo.inventory_item_segment3 IS NULL )
1953 AND ( p_inventory_item_segment3 IS NULL )))
1954 AND ( ( Recinfo.inventory_item_segment4 = p_inventory_item_segment4)
1955 OR ( ( Recinfo.inventory_item_segment4 IS NULL )
1956 AND ( p_inventory_item_segment4 IS NULL )))
1957 AND ( ( Recinfo.inventory_item_segment5 = p_inventory_item_segment5)
1958 OR ( ( Recinfo.inventory_item_segment5 IS NULL )
1959 AND ( p_inventory_item_segment5 IS NULL )))
1960 AND ( ( Recinfo.inventory_item_segment6 = p_inventory_item_segment6)
1961 OR ( ( Recinfo.inventory_item_segment6 IS NULL )
1962 AND ( p_inventory_item_segment6 IS NULL )))
1963 AND ( ( Recinfo.inventory_item_segment7 = p_inventory_item_segment7)
1964 OR ( ( Recinfo.inventory_item_segment7 IS NULL )
1965 AND ( p_inventory_item_segment7 IS NULL )))
1966 AND ( ( Recinfo.inventory_item_segment8 = p_inventory_item_segment8)
1967 OR ( ( Recinfo.inventory_item_segment8 IS NULL )
1968 AND ( p_inventory_item_segment8 IS NULL )))
1969 AND ( ( Recinfo.inventory_item_segment9 = p_inventory_item_segment9)
1970 OR ( ( Recinfo.inventory_item_segment9 IS NULL )
1971 AND ( p_inventory_item_segment9 IS NULL )))
1972 AND ( ( Recinfo.inventory_item_segment10 = p_inventory_item_segment10)
1973 OR ( ( Recinfo.inventory_item_segment10 IS NULL )
1974 AND ( p_inventory_item_segment10 IS NULL )))
1975 AND ( ( Recinfo.inventory_item_segment11 = p_inventory_item_segment11)
1976 OR ( ( Recinfo.inventory_item_segment11 IS NULL )
1977 AND ( p_inventory_item_segment11 IS NULL )))
1978 AND ( ( Recinfo.inventory_item_segment12 = p_inventory_item_segment12)
1979 OR ( ( Recinfo.inventory_item_segment12 IS NULL )
1980 AND ( p_inventory_item_segment12 IS NULL )))
1981 AND ( ( Recinfo.inventory_item_segment13 = p_inventory_item_segment13)
1982 OR ( ( Recinfo.inventory_item_segment13 IS NULL )
1983 AND ( p_inventory_item_segment13 IS NULL )))
1984 AND ( ( Recinfo.inventory_item_segment14 = p_inventory_item_segment14)
1985 OR ( ( Recinfo.inventory_item_segment14 IS NULL )
1986 AND ( p_inventory_item_segment14 IS NULL )))
1987 AND ( ( Recinfo.inventory_item_segment15 = p_inventory_item_segment15)
1988 OR ( ( Recinfo.inventory_item_segment15 IS NULL )
1989 AND ( p_inventory_item_segment15 IS NULL )))
1990 AND ( ( Recinfo.inventory_item_segment16 = p_inventory_item_segment16)
1991 OR ( ( Recinfo.inventory_item_segment16 IS NULL )
1992 AND ( p_inventory_item_segment16 IS NULL )))
1993 AND ( ( Recinfo.inventory_item_segment17 = p_inventory_item_segment17)
1994 OR ( ( Recinfo.inventory_item_segment17 IS NULL )
1995 AND ( p_inventory_item_segment17 IS NULL )))
1996 AND ( ( Recinfo.inventory_item_segment18 = p_inventory_item_segment18)
1997 OR ( ( Recinfo.inventory_item_segment18 IS NULL )
1998 AND ( p_inventory_item_segment18 IS NULL )))
1999 AND ( ( Recinfo.inventory_item_segment19 = p_inventory_item_segment19)
2000 OR ( ( Recinfo.inventory_item_segment19 IS NULL )
2001 AND ( p_inventory_item_segment19 IS NULL )))
2002 AND ( ( Recinfo.inventory_item_segment20 = p_inventory_item_segment20)
2003 OR ( ( Recinfo.inventory_item_segment20 IS NULL )
2004 AND ( p_inventory_item_segment20 IS NULL )))
2005 AND ( ( Recinfo.inventory_item_id = p_inventory_item_id)
2006 OR ( ( Recinfo.inventory_item_id IS NULL )
2007 AND ( p_inventory_item_id IS NULL )))
2008 AND ( ( Recinfo.item_description = p_item_description)
2009 OR ( ( Recinfo.item_description IS NULL )
2010 AND ( p_item_description IS NULL )))
2011 AND ( ( Recinfo.upc_code = p_upc_code)
2012 OR ( ( Recinfo.upc_code IS NULL )
2013 AND ( p_upc_code IS NULL )))
2014 AND ( ( Recinfo.item_number = p_item_number)
2015 OR ( ( Recinfo.item_number IS NULL )
2016 AND ( p_item_number IS NULL )))
2017 AND ( ( Recinfo.claimed_amount = p_claimed_amount)
2018 OR ( ( Recinfo.claimed_amount IS NULL )
2019 AND ( p_claimed_amount IS NULL )))
2020 AND ( ( Recinfo.purchase_price = p_purchase_price)
2021 OR ( ( Recinfo.purchase_price IS NULL )
2022 AND ( p_purchase_price IS NULL )))
2023 AND ( ( Recinfo.acctd_purchase_price = p_acctd_purchase_price)
2024 OR ( ( Recinfo.acctd_purchase_price IS NULL )
2025 AND ( p_acctd_purchase_price IS NULL )))
2026 AND ( ( Recinfo.net_adjusted_amount = p_net_adjusted_amount)
2027 OR ( ( Recinfo.net_adjusted_amount IS NULL )
2028 AND ( p_net_adjusted_amount IS NULL )))
2029 AND ( ( Recinfo.accepted_amount = p_accepted_amount)
2030 OR ( ( Recinfo.accepted_amount IS NULL )
2031 AND ( p_accepted_amount IS NULL )))
2032 AND ( ( Recinfo.total_accepted_amount = p_total_accepted_amount)
2033 OR ( ( Recinfo.total_accepted_amount IS NULL )
2034 AND ( p_total_accepted_amount IS NULL )))
2035 AND ( ( Recinfo.allowed_amount = p_allowed_amount)
2036 OR ( ( Recinfo.allowed_amount IS NULL )
2037 AND ( p_allowed_amount IS NULL )))
2038 AND ( ( Recinfo.total_allowed_amount = p_total_allowed_amount)
2039 OR ( ( Recinfo.total_allowed_amount IS NULL )
2040 AND ( p_total_allowed_amount IS NULL )))
2041 AND ( ( Recinfo.calculated_price = p_calculated_price)
2042 OR ( ( Recinfo.calculated_price IS NULL )
2043 AND ( p_calculated_price IS NULL )))
2044 AND ( ( Recinfo.acctd_calculated_price = p_acctd_calculated_price)
2045 OR ( ( Recinfo.acctd_calculated_price IS NULL )
2046 AND ( p_acctd_calculated_price IS NULL )))
2047 AND ( ( Recinfo.calculated_amount = p_calculated_amount)
2048 OR ( ( Recinfo.calculated_amount IS NULL )
2049 AND ( p_calculated_amount IS NULL )))
2050 AND ( ( Recinfo.line_tolerance_amount = p_line_tolerance_amount)
2051 OR ( ( Recinfo.line_tolerance_amount IS NULL )
2052 AND ( p_line_tolerance_amount IS NULL )))
2053 AND ( ( Recinfo.total_claimed_amount = p_total_claimed_amount)
2054 OR ( ( Recinfo.total_claimed_amount IS NULL )
2055 AND ( p_total_claimed_amount IS NULL )))
2056 AND ( ( Recinfo.credit_code = p_credit_code)
2057 OR ( ( Recinfo.credit_code IS NULL )
2058 AND ( p_credit_code IS NULL )))
2059 AND ( ( Recinfo.direct_customer_flag = p_direct_customer_flag)
2060 OR ( ( Recinfo.direct_customer_flag IS NULL )
2061 AND ( p_direct_customer_flag IS NULL )))
2062 AND ( ( Recinfo.duplicated_line_id = p_duplicated_line_id)
2063 OR ( ( Recinfo.duplicated_line_id IS NULL )
2064 AND ( p_duplicated_line_id IS NULL )))
2065 AND ( ( Recinfo.duplicated_adjustment_id = p_duplicated_adjustment_id)
2066 OR ( ( Recinfo.duplicated_adjustment_id IS NULL )
2067 AND ( p_duplicated_adjustment_id IS NULL )))
2068 AND ( ( Recinfo.order_type_id = p_order_type_id)
2069 OR ( ( Recinfo.order_type_id IS NULL )
2070 AND ( p_order_type_id IS NULL )))
2071 AND ( ( Recinfo.order_type = p_order_type)
2072 OR ( ( Recinfo.order_type IS NULL )
2073 AND ( p_order_type IS NULL )))
2074 AND ( ( Recinfo.order_category = p_order_category)
2075 OR ( ( Recinfo.order_category IS NULL )
2076 AND ( p_order_category IS NULL )))
2077 AND ( ( Recinfo.dispute_code = p_dispute_code)
2078 OR ( ( Recinfo.dispute_code IS NULL )
2079 AND ( p_dispute_code IS NULL )))
2080 AND ( ( Recinfo.data_source_code = p_data_source_code)
2081 OR ( ( Recinfo.data_source_code IS NULL )
2082 AND ( p_data_source_code IS NULL )))
2083 AND ( ( Recinfo.tracing_flag = p_tracing_flag)
2084 OR ( ( Recinfo.tracing_flag IS NULL )
2085 AND ( p_tracing_flag IS NULL )))
2086 AND ( ( Recinfo.header_attribute_category = p_header_attribute_category)
2087 OR ( ( Recinfo.header_attribute_category IS NULL )
2088 AND ( p_header_attribute_category IS NULL )))
2089 AND ( ( Recinfo.header_attribute1 = p_header_attribute1)
2090 OR ( ( Recinfo.header_attribute1 IS NULL )
2091 AND ( p_header_attribute1 IS NULL )))
2092 AND ( ( Recinfo.header_attribute2 = p_header_attribute2)
2093 OR ( ( Recinfo.header_attribute2 IS NULL )
2094 AND ( p_header_attribute2 IS NULL )))
2095 AND ( ( Recinfo.header_attribute3 = p_header_attribute3)
2096 OR ( ( Recinfo.header_attribute3 IS NULL )
2097 AND ( p_header_attribute3 IS NULL )))
2098 AND ( ( Recinfo.header_attribute4 = p_header_attribute4)
2099 OR ( ( Recinfo.header_attribute4 IS NULL )
2100 AND ( p_header_attribute4 IS NULL )))
2101 AND ( ( Recinfo.header_attribute5 = p_header_attribute5)
2102 OR ( ( Recinfo.header_attribute5 IS NULL )
2103 AND ( p_header_attribute5 IS NULL )))
2104 AND ( ( Recinfo.header_attribute6 = p_header_attribute6)
2105 OR ( ( Recinfo.header_attribute6 IS NULL )
2106 AND ( p_header_attribute6 IS NULL )))
2107 AND ( ( Recinfo.header_attribute7 = p_header_attribute7)
2108 OR ( ( Recinfo.header_attribute7 IS NULL )
2109 AND ( p_header_attribute7 IS NULL )))
2110 AND ( ( Recinfo.header_attribute8 = p_header_attribute8)
2111 OR ( ( Recinfo.header_attribute8 IS NULL )
2112 AND ( p_header_attribute8 IS NULL )))
2113 AND ( ( Recinfo.header_attribute9 = p_header_attribute9)
2114 OR ( ( Recinfo.header_attribute9 IS NULL )
2115 AND ( p_header_attribute9 IS NULL )))
2116 AND ( ( Recinfo.header_attribute10 = p_header_attribute10)
2117 OR ( ( Recinfo.header_attribute10 IS NULL )
2118 AND ( p_header_attribute10 IS NULL )))
2119 AND ( ( Recinfo.header_attribute11 = p_header_attribute11)
2120 OR ( ( Recinfo.header_attribute11 IS NULL )
2121 AND ( p_header_attribute11 IS NULL )))
2122 AND ( ( Recinfo.header_attribute12 = p_header_attribute12)
2123 OR ( ( Recinfo.header_attribute12 IS NULL )
2124 AND ( p_header_attribute12 IS NULL )))
2125 AND ( ( Recinfo.header_attribute13 = p_header_attribute13)
2126 OR ( ( Recinfo.header_attribute13 IS NULL )
2127 AND ( p_header_attribute13 IS NULL )))
2128 AND ( ( Recinfo.header_attribute14 = p_header_attribute14)
2129 OR ( ( Recinfo.header_attribute14 IS NULL )
2130 AND ( p_header_attribute14 IS NULL )))
2131 AND ( ( Recinfo.header_attribute15 = p_header_attribute15)
2132 OR ( ( Recinfo.header_attribute15 IS NULL )
2133 AND ( p_header_attribute15 IS NULL )))
2134 AND ( ( Recinfo.line_attribute_category = p_line_attribute_category)
2135 OR ( ( Recinfo.line_attribute_category IS NULL )
2136 AND ( p_line_attribute_category IS NULL )))
2137 AND ( ( Recinfo.line_attribute1 = p_line_attribute1)
2138 OR ( ( Recinfo.line_attribute1 IS NULL )
2139 AND ( p_line_attribute1 IS NULL )))
2140 AND ( ( Recinfo.line_attribute2 = p_line_attribute2)
2141 OR ( ( Recinfo.line_attribute2 IS NULL )
2142 AND ( p_line_attribute2 IS NULL )))
2143 AND ( ( Recinfo.line_attribute3 = p_line_attribute3)
2144 OR ( ( Recinfo.line_attribute3 IS NULL )
2145 AND ( p_line_attribute3 IS NULL )))
2146 AND ( ( Recinfo.line_attribute4 = p_line_attribute4)
2147 OR ( ( Recinfo.line_attribute4 IS NULL )
2148 AND ( p_line_attribute4 IS NULL )))
2149 AND ( ( Recinfo.line_attribute5 = p_line_attribute5)
2150 OR ( ( Recinfo.line_attribute5 IS NULL )
2151 AND ( p_line_attribute5 IS NULL )))
2152 AND ( ( Recinfo.line_attribute6 = p_line_attribute6)
2153 OR ( ( Recinfo.line_attribute6 IS NULL )
2154 AND ( p_line_attribute6 IS NULL )))
2155 AND ( ( Recinfo.line_attribute7 = p_line_attribute7)
2156 OR ( ( Recinfo.line_attribute7 IS NULL )
2157 AND ( p_line_attribute7 IS NULL )))
2158 AND ( ( Recinfo.line_attribute8 = p_line_attribute8)
2159 OR ( ( Recinfo.line_attribute8 IS NULL )
2160 AND ( p_line_attribute8 IS NULL )))
2161 AND ( ( Recinfo.line_attribute9 = p_line_attribute9)
2162 OR ( ( Recinfo.line_attribute9 IS NULL )
2163 AND ( p_line_attribute9 IS NULL )))
2164 AND ( ( Recinfo.line_attribute10 = p_line_attribute10)
2165 OR ( ( Recinfo.line_attribute10 IS NULL )
2166 AND ( p_line_attribute10 IS NULL )))
2167 AND ( ( Recinfo.line_attribute11 = p_line_attribute11)
2168 OR ( ( Recinfo.line_attribute11 IS NULL )
2169 AND ( p_line_attribute11 IS NULL )))
2170 AND ( ( Recinfo.line_attribute12 = p_line_attribute12)
2171 OR ( ( Recinfo.line_attribute12 IS NULL )
2172 AND ( p_line_attribute12 IS NULL )))
2173 AND ( ( Recinfo.line_attribute13 = p_line_attribute13)
2174 OR ( ( Recinfo.line_attribute13 IS NULL )
2175 AND ( p_line_attribute13 IS NULL )))
2176 AND ( ( Recinfo.line_attribute14 = p_line_attribute14)
2177 OR ( ( Recinfo.line_attribute14 IS NULL )
2178 AND ( p_line_attribute14 IS NULL )))
2179 AND ( ( Recinfo.line_attribute15 = p_line_attribute15)
2180 OR ( ( Recinfo.line_attribute15 IS NULL )
2181 AND ( p_line_attribute15 IS NULL )))
2182 AND ( ( Recinfo.org_id = p_org_id)
2183 OR ( ( Recinfo.org_id IS NULL )
2184 AND ( p_org_id IS NULL )))
2185 ) THEN
2186 RETURN;
2187 ELSE
2188 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
2189 APP_EXCEPTION.RAISE_EXCEPTION;
2190 END IF;
2191 END Lock_Row;
2192
2193 END OZF_RESALE_LINES_INT_PKG;