[Home] [Help]
PACKAGE BODY: APPS.OZF_RESALE_BATCHES_PKG
Source
1 PACKAGE BODY OZF_RESALE_BATCHES_PKG as
2 /* $Header: ozftrsbb.pls 120.2.12000000.2 2007/05/28 10:32:13 ateotia ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_RESALE_BATCHES_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_BATCHES_PKG';
19 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftrsbb.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_batch_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_batch_number VARCHAR2,
52 p_batch_type VARCHAR2,
53 p_batch_count NUMBER,
54 p_year NUMBER,
55 p_month NUMBER,
56 p_report_date DATE,
57 p_report_start_date DATE,
58 p_report_end_date DATE,
59 p_status_code VARCHAR2,
60 p_data_source_code VARCHAR2, -- BUG 5077213
61 p_reference_type VARCHAR2,
62 p_reference_number VARCHAR2,
63 p_comments VARCHAR2,
64 p_partner_claim_number VARCHAR2,
65 p_transaction_purpose_code VARCHAR2,
66 p_transaction_type_code VARCHAR2,
67 p_partner_type VARCHAR2,
68 p_partner_id NUMBER,
69 p_partner_party_id NUMBER,
70 p_partner_cust_account_id NUMBER,
71 p_partner_site_id NUMBER,
72 p_partner_contact_party_id NUMBER,
73 p_partner_contact_name VARCHAR2,
74 p_partner_email VARCHAR2,
75 p_partner_phone VARCHAR2,
76 p_partner_fax VARCHAR2,
77 p_header_tolerance_operand NUMBER,
78 p_header_tolerance_calc_code VARCHAR2,
79 p_line_tolerance_operand NUMBER,
80 p_line_tolerance_calc_code VARCHAR2,
81 p_currency_code VARCHAR2,
82 p_claimed_amount NUMBER,
83 p_allowed_amount NUMBER,
84 p_paid_amount NUMBER,
85 p_disputed_amount NUMBER,
86 p_accepted_amount NUMBER,
87 p_lines_invalid NUMBER,
88 p_lines_w_tolerance NUMBER,
89 p_lines_disputed NUMBER,
90 p_batch_set_id_code VARCHAR2,
91 p_credit_code VARCHAR2,
92 p_credit_advice_date DATE,
93 p_purge_flag VARCHAR2,
94 p_attribute_category VARCHAR2,
95 p_attribute1 VARCHAR2,
96 p_attribute2 VARCHAR2,
97 p_attribute3 VARCHAR2,
98 p_attribute4 VARCHAR2,
99 p_attribute5 VARCHAR2,
100 p_attribute6 VARCHAR2,
101 p_attribute7 VARCHAR2,
102 p_attribute8 VARCHAR2,
103 p_attribute9 VARCHAR2,
104 p_attribute10 VARCHAR2,
105 p_attribute11 VARCHAR2,
106 p_attribute12 VARCHAR2,
107 p_attribute13 VARCHAR2,
108 p_attribute14 VARCHAR2,
109 p_attribute15 VARCHAR2,
110 px_org_id IN OUT NOCOPY NUMBER)
111
112 IS
113 x_rowid VARCHAR2(30);
114
115 BEGIN
116
117 -- Start: bug # 5997978 fixed
118 -- org id can be null at batch level but then should always be given at lines level.
119 /*IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM)
120 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
121 INTO px_org_id
122 FROM DUAL;
123 END IF; */
124 -- End: bug # 5997978 fixed
125
126 px_object_version_number := 1;
127
128
129 INSERT INTO OZF_RESALE_BATCHES_ALL(
130 resale_batch_id,
131 object_version_number,
132 last_update_date,
133 last_updated_by,
134 creation_date,
135 request_id,
136 created_by,
137 created_from,
138 last_update_login,
139 program_application_id,
140 program_update_date,
141 program_id,
142 batch_number,
143 batch_type,
144 batch_count,
145 year,
146 month,
147 report_date,
148 batch_set_id_code,
149 reference_type,
150 reference_number,
151 report_start_date,
152 report_end_date,
153 status_code,
154 data_source_code, -- BUG 5077213
155 comments,
156 transaction_purpose_code,
157 transaction_type_code,
158 partner_type,
159 partner_id,
160 partner_party_id,
161 partner_cust_account_id,
162 partner_site_id,
163 partner_contact_party_id,
164 partner_contact_name,
165 partner_email,
166 partner_phone,
167 partner_fax,
168 partner_claim_number,
169 claimed_amount,
170 allowed_amount,
171 paid_amount,
172 disputed_amount,
173 accepted_amount,
174 currency_code,
175 credit_code,
176 credit_advice_date,
177 lines_w_tolerance,
178 lines_disputed,
179 lines_invalid,
180 header_tolerance_operand,
181 header_tolerance_calc_code,
182 line_tolerance_operand,
183 line_tolerance_calc_code,
184 purge_flag,
185 attribute_category,
186 attribute1,
187 attribute2,
188 attribute3,
189 attribute4,
190 attribute5,
191 attribute6,
192 attribute7,
193 attribute8,
194 attribute9,
195 attribute10,
196 attribute11,
197 attribute12,
198 attribute13,
199 attribute14,
200 attribute15,
201 org_id
202 ) VALUES (
203 px_resale_batch_id,
204 px_object_version_number,
205 p_last_update_date,
206 p_last_updated_by,
207 p_creation_date,
208 p_request_id,
209 p_created_by,
210 p_created_from,
211 p_last_update_login,
212 p_program_application_id,
213 p_program_update_date,
214 p_program_id,
215 p_batch_number,
216 p_batch_type,
217 p_batch_count,
218 p_year,
219 p_month,
220 p_report_date,
221 p_batch_set_id_code,
222 p_reference_type,
223 p_reference_number,
224 p_report_start_date,
225 p_report_end_date,
226 p_status_code,
227 p_data_source_code, -- BUG 5077213
228 p_comments,
229 p_transaction_purpose_code,
230 p_transaction_type_code,
231 p_partner_type,
232 p_partner_id,
233 p_partner_party_id,
234 p_partner_cust_account_id,
235 p_partner_site_id,
236 p_partner_contact_party_id,
237 p_partner_contact_name,
238 p_partner_email,
239 p_partner_phone,
240 p_partner_fax,
241 p_partner_claim_number,
242 p_claimed_amount,
243 p_allowed_amount,
244 p_paid_amount,
245 p_disputed_amount,
246 p_accepted_amount,
247 p_currency_code,
248 p_credit_code,
249 p_credit_advice_date,
250 p_lines_w_tolerance,
251 p_lines_disputed,
252 p_lines_invalid,
253 p_header_tolerance_operand,
254 p_header_tolerance_calc_code,
255 p_line_tolerance_operand,
256 p_line_tolerance_calc_code,
257 p_purge_flag,
258 p_attribute_category,
259 p_attribute1,
260 p_attribute2,
261 p_attribute3,
262 p_attribute4,
263 p_attribute5,
264 p_attribute6,
265 p_attribute7,
266 p_attribute8,
267 p_attribute9,
268 p_attribute10,
269 p_attribute11,
270 p_attribute12,
271 p_attribute13,
272 p_attribute14,
273 p_attribute15,
274 px_org_id);
275 END Insert_Row;
276
277
278 ----------------------------------------------------------
279 ---- MEDIA ----
280 ----------------------------------------------------------
281
282 -- ========================================================
283 --
284 -- NAME
285 -- createUpdateBody
286 --
287 -- PURPOSE
288 --
289 -- NOTES
290 --
291 -- HISTORY
292 --
293 -- ========================================================
294 PROCEDURE Update_Row(
295 p_resale_batch_id NUMBER,
296 p_object_version_number NUMBER,
297 p_last_update_date DATE,
298 p_last_updated_by NUMBER,
299 p_request_id NUMBER,
300 p_created_from VARCHAR2,
301 p_last_update_login NUMBER,
302 p_program_application_id NUMBER,
303 p_program_update_date DATE,
304 p_program_id NUMBER,
305 p_batch_number VARCHAR2,
306 p_batch_type VARCHAR2,
307 p_batch_count NUMBER,
308 p_year NUMBER,
309 p_month NUMBER,
310 p_report_date DATE,
311 p_report_start_date DATE,
312 p_report_end_date DATE,
313 p_status_code VARCHAR2,
314 --p_data_source_code VARCHAR2, -- BUG 5077213
315 p_reference_type VARCHAR2,
316 p_reference_number VARCHAR2,
317 p_comments VARCHAR2,
318 p_partner_claim_number VARCHAR2,
319 p_transaction_purpose_code VARCHAR2,
320 p_transaction_type_code VARCHAR2,
321 p_partner_type VARCHAR2,
322 p_partner_id NUMBER,
323 p_partner_party_id NUMBER,
324 p_partner_cust_account_id NUMBER,
325 p_partner_site_id NUMBER,
326 p_partner_contact_party_id NUMBER,
327 p_partner_contact_name VARCHAR2,
328 p_partner_email VARCHAR2,
329 p_partner_phone VARCHAR2,
330 p_partner_fax VARCHAR2,
331 p_header_tolerance_operand NUMBER,
332 p_header_tolerance_calc_code VARCHAR2,
333 p_line_tolerance_operand NUMBER,
334 p_line_tolerance_calc_code VARCHAR2,
335 p_currency_code VARCHAR2,
336 p_claimed_amount NUMBER,
337 p_allowed_amount NUMBER,
338 p_paid_amount NUMBER,
339 p_disputed_amount NUMBER,
340 p_accepted_amount NUMBER,
341 p_lines_invalid NUMBER,
342 p_lines_w_tolerance NUMBER,
343 p_lines_disputed NUMBER,
344 p_batch_set_id_code VARCHAR2,
345 p_credit_code VARCHAR2,
346 p_credit_advice_date DATE,
347 p_purge_flag VARCHAR2,
348 p_attribute_category VARCHAR2,
349 p_attribute1 VARCHAR2,
350 p_attribute2 VARCHAR2,
351 p_attribute3 VARCHAR2,
352 p_attribute4 VARCHAR2,
353 p_attribute5 VARCHAR2,
354 p_attribute6 VARCHAR2,
355 p_attribute7 VARCHAR2,
356 p_attribute8 VARCHAR2,
357 p_attribute9 VARCHAR2,
358 p_attribute10 VARCHAR2,
359 p_attribute11 VARCHAR2,
360 p_attribute12 VARCHAR2,
361 p_attribute13 VARCHAR2,
362 p_attribute14 VARCHAR2,
363 p_attribute15 VARCHAR2,
364 p_org_id NUMBER)
365
366 IS
367 BEGIN
368 UPDATE OZF_RESALE_BATCHES_ALL
369 SET
370 resale_batch_id = p_resale_batch_id,
371 object_version_number = p_object_version_number,
372 last_update_date = p_last_update_date,
373 last_updated_by = p_last_updated_by,
374 request_id = p_request_id,
375 created_from = p_created_from,
376 last_update_login = p_last_update_login,
377 program_application_id = p_program_application_id,
378 program_update_date = p_program_update_date,
379 program_id = p_program_id,
380 batch_number = p_batch_number,
381 batch_type = p_batch_type,
382 batch_count = p_batch_count,
383 year = p_year,
384 month = p_month,
385 report_date = p_report_date,
386 batch_set_id_code = p_batch_set_id_code,
387 reference_type = p_reference_type,
388 reference_number = p_reference_number,
389 report_start_date = p_report_start_date,
390 report_end_date = p_report_end_date,
391 status_code = p_status_code,
392 comments = p_comments,
393 transaction_purpose_code = p_transaction_purpose_code,
394 transaction_type_code = p_transaction_type_code,
395 partner_type = p_partner_type,
396 partner_id = p_partner_id,
397 partner_party_id = p_partner_party_id,
398 partner_cust_account_id = p_partner_cust_account_id,
399 partner_site_id = p_partner_site_id,
400 partner_contact_party_id = p_partner_contact_party_id,
401 partner_contact_name = p_partner_contact_name,
402 partner_email = p_partner_email,
403 partner_phone = p_partner_phone,
404 partner_fax = p_partner_fax,
405 partner_claim_number = p_partner_claim_number,
406 claimed_amount = p_claimed_amount,
407 allowed_amount = p_allowed_amount,
408 paid_amount = p_paid_amount,
409 disputed_amount = p_disputed_amount,
410 accepted_amount = p_accepted_amount,
411 currency_code = p_currency_code,
412 credit_code = p_credit_code,
413 credit_advice_date = p_credit_advice_date,
414 lines_w_tolerance = p_lines_w_tolerance,
415 lines_disputed = p_lines_disputed,
416 lines_invalid = p_lines_invalid,
417 header_tolerance_operand = p_header_tolerance_operand,
418 header_tolerance_calc_code = p_header_tolerance_calc_code,
419 line_tolerance_operand = p_line_tolerance_operand,
420 line_tolerance_calc_code = p_line_tolerance_calc_code,
424 attribute2 = p_attribute2,
421 purge_flag = p_purge_flag,
422 attribute_category = p_attribute_category,
423 attribute1 = p_attribute1,
425 attribute3 = p_attribute3,
426 attribute4 = p_attribute4,
427 attribute5 = p_attribute5,
428 attribute6 = p_attribute6,
429 attribute7 = p_attribute7,
430 attribute8 = p_attribute8,
431 attribute9 = p_attribute9,
432 attribute10 = p_attribute10,
433 attribute11 = p_attribute11,
434 attribute12 = p_attribute12,
435 attribute13 = p_attribute13,
436 attribute14 = p_attribute14,
437 attribute15 = p_attribute15,
438 org_id = p_org_id
439 WHERE resale_batch_id = p_resale_batch_id
440 AND object_version_number = p_object_version_number;
441
442 IF (SQL%NOTFOUND) THEN
443 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444 END IF;
445 END Update_Row;
446
447
448 ----------------------------------------------------------
449 ---- MEDIA ----
450 ----------------------------------------------------------
451
452 -- ========================================================
453 --
454 -- NAME
455 -- createDeleteBody
456 --
457 -- PURPOSE
458 --
459 -- NOTES
460 --
461 -- HISTORY
462 --
463 -- ========================================================
464 PROCEDURE Delete_Row(
465 p_RESALE_BATCH_ID NUMBER)
466 IS
467 BEGIN
468 DELETE FROM OZF_RESALE_BATCHES_ALL
469 WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID;
470 If (SQL%NOTFOUND) then
471 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472 End If;
473 END Delete_Row ;
474
475
476
477 ----------------------------------------------------------
478 ---- MEDIA ----
479 ----------------------------------------------------------
480
481 -- ========================================================
482 --
483 -- NAME
484 -- createLockBody
485 --
486 -- PURPOSE
487 --
488 -- NOTES
489 --
490 -- HISTORY
491 --
492 -- ========================================================
493 PROCEDURE Lock_Row(
494 p_resale_batch_id NUMBER,
495 p_object_version_number NUMBER,
496 p_last_update_date DATE,
497 p_last_updated_by NUMBER,
498 p_creation_date DATE,
499 p_request_id NUMBER,
500 p_created_by NUMBER,
501 p_created_from VARCHAR2,
502 p_last_update_login NUMBER,
503 p_program_application_id NUMBER,
504 p_program_update_date DATE,
505 p_program_id NUMBER,
506 p_batch_number VARCHAR2,
507 p_batch_type VARCHAR2,
508 p_batch_count NUMBER,
509 p_year NUMBER,
510 p_month NUMBER,
511 p_report_date DATE,
512 p_report_start_date DATE,
513 p_report_end_date DATE,
514 p_status_code VARCHAR2,
515 p_data_source_code VARCHAR2,
516 p_reference_type VARCHAR2,
517 p_reference_number VARCHAR2,
518 p_comments VARCHAR2,
519 p_partner_claim_number VARCHAR2,
520 p_transaction_purpose_code VARCHAR2,
521 p_transaction_type_code VARCHAR2,
522 p_partner_type VARCHAR2,
523 p_partner_id NUMBER,
524 p_partner_party_id NUMBER,
525 p_partner_cust_account_id NUMBER,
526 p_partner_site_id NUMBER,
527 p_partner_contact_party_id NUMBER,
528 p_partner_contact_name VARCHAR2,
529 p_partner_email VARCHAR2,
530 p_partner_phone VARCHAR2,
531 p_partner_fax VARCHAR2,
532 p_header_tolerance_operand NUMBER,
533 p_header_tolerance_calc_code VARCHAR2,
534 p_line_tolerance_operand NUMBER,
535 p_line_tolerance_calc_code VARCHAR2,
536 p_currency_code VARCHAR2,
537 p_claimed_amount NUMBER,
538 p_allowed_amount NUMBER,
539 p_paid_amount NUMBER,
540 p_disputed_amount NUMBER,
541 p_accepted_amount NUMBER,
542 p_lines_invalid NUMBER,
543 p_lines_w_tolerance NUMBER,
544 p_lines_disputed NUMBER,
545 p_batch_set_id_code VARCHAR2,
546 p_credit_code VARCHAR2,
547 p_credit_advice_date DATE,
548 p_purge_flag VARCHAR2,
549 p_attribute_category VARCHAR2,
550 p_attribute1 VARCHAR2,
551 p_attribute2 VARCHAR2,
552 p_attribute3 VARCHAR2,
553 p_attribute4 VARCHAR2,
554 p_attribute5 VARCHAR2,
555 p_attribute6 VARCHAR2,
556 p_attribute7 VARCHAR2,
557 p_attribute8 VARCHAR2,
558 p_attribute9 VARCHAR2,
559 p_attribute10 VARCHAR2,
560 p_attribute11 VARCHAR2,
561 p_attribute12 VARCHAR2,
562 p_attribute13 VARCHAR2,
563 p_attribute14 VARCHAR2,
564 p_attribute15 VARCHAR2,
568 CURSOR C IS
565 p_org_id NUMBER)
566
567 IS
569 SELECT *
570 FROM OZF_RESALE_BATCHES_ALL
571 WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID
572 FOR UPDATE of RESALE_BATCH_ID NOWAIT;
573 Recinfo C%ROWTYPE;
574 BEGIN
575 OPEN c;
576 FETCH c INTO Recinfo;
577 If (c%NOTFOUND) then
578 CLOSE c;
579 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
580 APP_EXCEPTION.RAISE_EXCEPTION;
581 END IF;
582 CLOSE C;
583 IF (
584 ( Recinfo.resale_batch_id = p_resale_batch_id)
585 AND ( ( Recinfo.object_version_number = p_object_version_number)
586 OR ( ( Recinfo.object_version_number IS NULL )
587 AND ( p_object_version_number IS NULL )))
588 AND ( ( Recinfo.last_update_date = p_last_update_date)
589 OR ( ( Recinfo.last_update_date IS NULL )
590 AND ( p_last_update_date IS NULL )))
591 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
592 OR ( ( Recinfo.last_updated_by IS NULL )
593 AND ( p_last_updated_by IS NULL )))
594 AND ( ( Recinfo.creation_date = p_creation_date)
595 OR ( ( Recinfo.creation_date IS NULL )
596 AND ( p_creation_date IS NULL )))
597 AND ( ( Recinfo.request_id = p_request_id)
598 OR ( ( Recinfo.request_id IS NULL )
599 AND ( p_request_id IS NULL )))
600 AND ( ( Recinfo.created_by = p_created_by)
601 OR ( ( Recinfo.created_by IS NULL )
602 AND ( p_created_by IS NULL )))
603 AND ( ( Recinfo.created_from = p_created_from)
604 OR ( ( Recinfo.created_from IS NULL )
605 AND ( p_created_from IS NULL )))
606 AND ( ( Recinfo.last_update_login = p_last_update_login)
607 OR ( ( Recinfo.last_update_login IS NULL )
608 AND ( p_last_update_login IS NULL )))
609 AND ( ( Recinfo.program_application_id = p_program_application_id)
610 OR ( ( Recinfo.program_application_id IS NULL )
611 AND ( p_program_application_id IS NULL )))
612 AND ( ( Recinfo.program_update_date = p_program_update_date)
613 OR ( ( Recinfo.program_update_date IS NULL )
614 AND ( p_program_update_date IS NULL )))
615 AND ( ( Recinfo.program_id = p_program_id)
616 OR ( ( Recinfo.program_id IS NULL )
617 AND ( p_program_id IS NULL )))
618 AND ( ( Recinfo.batch_number = p_batch_number)
619 OR ( ( Recinfo.batch_number IS NULL )
620 AND ( p_batch_number IS NULL )))
621 AND ( ( Recinfo.batch_type = p_batch_type)
622 OR ( ( Recinfo.batch_type IS NULL )
623 AND ( p_batch_type IS NULL )))
624 AND ( ( Recinfo.batch_count = p_batch_count)
625 OR ( ( Recinfo.batch_count IS NULL )
626 AND ( p_batch_count IS NULL )))
627 AND ( ( Recinfo.year = p_year)
628 OR ( ( Recinfo.year IS NULL )
629 AND ( p_year IS NULL )))
630 AND ( ( Recinfo.month = p_month)
631 OR ( ( Recinfo.month IS NULL )
632 AND ( p_month IS NULL )))
633 AND ( ( Recinfo.report_date = p_report_date)
634 OR ( ( Recinfo.report_date IS NULL )
635 AND ( p_report_date IS NULL )))
636 AND ( ( Recinfo.batch_set_id_code = p_batch_set_id_code)
637 OR ( ( Recinfo.batch_set_id_code IS NULL )
638 AND ( p_batch_set_id_code IS NULL )))
639 AND ( ( Recinfo.reference_type = p_reference_type)
640 OR ( ( Recinfo.reference_type IS NULL )
641 AND ( p_reference_type IS NULL )))
642 AND ( ( Recinfo.reference_number = p_reference_number)
643 OR ( ( Recinfo.reference_number IS NULL )
644 AND ( p_reference_number IS NULL )))
645 AND ( ( Recinfo.report_start_date = p_report_start_date)
646 OR ( ( Recinfo.report_start_date IS NULL )
647 AND ( p_report_start_date IS NULL )))
648 AND ( ( Recinfo.report_end_date = p_report_end_date)
649 OR ( ( Recinfo.report_end_date IS NULL )
650 AND ( p_report_end_date IS NULL )))
651 AND ( ( Recinfo.status_code = p_status_code)
652 OR ( ( Recinfo.status_code IS NULL )
653 AND ( p_status_code IS NULL )))
654 AND ( ( Recinfo.comments = p_comments)
655 OR ( ( Recinfo.comments IS NULL )
656 AND ( p_comments IS NULL )))
657 AND ( ( Recinfo.transaction_purpose_code = p_transaction_purpose_code)
658 OR ( ( Recinfo.transaction_purpose_code IS NULL )
659 AND ( p_transaction_purpose_code IS NULL )))
660 AND ( ( Recinfo.transaction_type_code = p_transaction_type_code)
661 OR ( ( Recinfo.transaction_type_code IS NULL )
662 AND ( p_transaction_type_code IS NULL )))
663 AND ( ( Recinfo.partner_type = p_partner_type)
664 OR ( ( Recinfo.partner_type IS NULL )
665 AND ( p_partner_type IS NULL )))
666 AND ( ( Recinfo.partner_id = p_partner_id)
667 OR ( ( Recinfo.partner_id IS NULL )
671 AND ( p_partner_party_id IS NULL )))
668 AND ( p_partner_id IS NULL )))
669 AND ( ( Recinfo.partner_party_id = p_partner_party_id)
670 OR ( ( Recinfo.partner_party_id IS NULL )
672 AND ( ( Recinfo.partner_cust_account_id = p_partner_cust_account_id)
673 OR ( ( Recinfo.partner_cust_account_id IS NULL )
674 AND ( p_partner_cust_account_id IS NULL )))
675 AND ( ( Recinfo.partner_site_id = p_partner_site_id)
676 OR ( ( Recinfo.partner_site_id IS NULL )
677 AND ( p_partner_site_id IS NULL )))
678 AND ( ( Recinfo.partner_contact_party_id = p_partner_contact_party_id)
679 OR ( ( Recinfo.partner_contact_party_id IS NULL )
680 AND ( p_partner_contact_party_id IS NULL )))
681 AND ( ( Recinfo.partner_contact_name = p_partner_contact_name)
682 OR ( ( Recinfo.partner_contact_name IS NULL )
683 AND ( p_partner_contact_name IS NULL )))
684 AND ( ( Recinfo.partner_email = p_partner_email)
685 OR ( ( Recinfo.partner_email IS NULL )
686 AND ( p_partner_email IS NULL )))
687 AND ( ( Recinfo.partner_phone = p_partner_phone)
688 OR ( ( Recinfo.partner_phone IS NULL )
689 AND ( p_partner_phone IS NULL )))
690 AND ( ( Recinfo.partner_fax = p_partner_fax)
691 OR ( ( Recinfo.partner_fax IS NULL )
692 AND ( p_partner_fax IS NULL )))
693 AND ( ( Recinfo.partner_claim_number = p_partner_claim_number)
694 OR ( ( Recinfo.partner_claim_number IS NULL )
695 AND ( p_partner_claim_number IS NULL )))
696 AND ( ( Recinfo.claimed_amount = p_claimed_amount)
697 OR ( ( Recinfo.claimed_amount IS NULL )
698 AND ( p_claimed_amount IS NULL )))
699 AND ( ( Recinfo.allowed_amount = p_allowed_amount)
700 OR ( ( Recinfo.allowed_amount IS NULL )
701 AND ( p_allowed_amount IS NULL )))
702 AND ( ( Recinfo.paid_amount = p_paid_amount)
703 OR ( ( Recinfo.paid_amount IS NULL )
704 AND ( p_paid_amount IS NULL )))
705 AND ( ( Recinfo.disputed_amount = p_disputed_amount)
706 OR ( ( Recinfo.disputed_amount IS NULL )
707 AND ( p_disputed_amount IS NULL )))
708 AND ( ( Recinfo.accepted_amount = p_accepted_amount)
709 OR ( ( Recinfo.accepted_amount IS NULL )
710 AND ( p_accepted_amount IS NULL )))
711 AND ( ( Recinfo.currency_code = p_currency_code)
712 OR ( ( Recinfo.currency_code IS NULL )
713 AND ( p_currency_code IS NULL )))
714 AND ( ( Recinfo.credit_code = p_credit_code)
715 OR ( ( Recinfo.credit_code IS NULL )
716 AND ( p_credit_code IS NULL )))
717 AND ( ( Recinfo.credit_advice_date = p_credit_advice_date)
718 OR ( ( Recinfo.credit_advice_date IS NULL )
719 AND ( p_credit_advice_date IS NULL )))
720 AND ( ( Recinfo.lines_w_tolerance = p_lines_w_tolerance)
721 OR ( ( Recinfo.lines_w_tolerance IS NULL )
722 AND ( p_lines_w_tolerance IS NULL )))
723 AND ( ( Recinfo.lines_disputed = p_lines_disputed)
724 OR ( ( Recinfo.lines_disputed IS NULL )
725 AND ( p_lines_disputed IS NULL )))
726 AND ( ( Recinfo.lines_invalid = p_lines_invalid)
727 OR ( ( Recinfo.lines_invalid IS NULL )
728 AND ( p_lines_invalid IS NULL )))
729 AND ( ( Recinfo.header_tolerance_operand = p_header_tolerance_operand)
730 OR ( ( Recinfo.header_tolerance_operand IS NULL )
731 AND ( p_header_tolerance_operand IS NULL )))
732 AND ( ( Recinfo.header_tolerance_calc_code = p_header_tolerance_calc_code)
733 OR ( ( Recinfo.header_tolerance_calc_code IS NULL )
734 AND ( p_header_tolerance_calc_code IS NULL )))
735 AND ( ( Recinfo.line_tolerance_operand = p_line_tolerance_operand)
736 OR ( ( Recinfo.line_tolerance_operand IS NULL )
737 AND ( p_line_tolerance_operand IS NULL )))
738 AND ( ( Recinfo.line_tolerance_calc_code = p_line_tolerance_calc_code)
739 OR ( ( Recinfo.line_tolerance_calc_code IS NULL )
740 AND ( p_line_tolerance_calc_code IS NULL )))
741 AND ( ( Recinfo.purge_flag = p_purge_flag)
742 OR ( ( Recinfo.purge_flag IS NULL )
743 AND ( p_purge_flag IS NULL )))
744 AND ( ( Recinfo.attribute_category = p_attribute_category)
745 OR ( ( Recinfo.attribute_category IS NULL )
746 AND ( p_attribute_category IS NULL )))
747 AND ( ( Recinfo.attribute1 = p_attribute1)
748 OR ( ( Recinfo.attribute1 IS NULL )
749 AND ( p_attribute1 IS NULL )))
750 AND ( ( Recinfo.attribute2 = p_attribute2)
751 OR ( ( Recinfo.attribute2 IS NULL )
752 AND ( p_attribute2 IS NULL )))
753 AND ( ( Recinfo.attribute3 = p_attribute3)
754 OR ( ( Recinfo.attribute3 IS NULL )
755 AND ( p_attribute3 IS NULL )))
756 AND ( ( Recinfo.attribute4 = p_attribute4)
757 OR ( ( Recinfo.attribute4 IS NULL )
761 AND ( p_attribute5 IS NULL )))
758 AND ( p_attribute4 IS NULL )))
759 AND ( ( Recinfo.attribute5 = p_attribute5)
760 OR ( ( Recinfo.attribute5 IS NULL )
762 AND ( ( Recinfo.attribute6 = p_attribute6)
763 OR ( ( Recinfo.attribute6 IS NULL )
764 AND ( p_attribute6 IS NULL )))
765 AND ( ( Recinfo.attribute7 = p_attribute7)
766 OR ( ( Recinfo.attribute7 IS NULL )
767 AND ( p_attribute7 IS NULL )))
768 AND ( ( Recinfo.attribute8 = p_attribute8)
769 OR ( ( Recinfo.attribute8 IS NULL )
770 AND ( p_attribute8 IS NULL )))
771 AND ( ( Recinfo.attribute9 = p_attribute9)
772 OR ( ( Recinfo.attribute9 IS NULL )
773 AND ( p_attribute9 IS NULL )))
774 AND ( ( Recinfo.attribute10 = p_attribute10)
775 OR ( ( Recinfo.attribute10 IS NULL )
776 AND ( p_attribute10 IS NULL )))
777 AND ( ( Recinfo.attribute11 = p_attribute11)
778 OR ( ( Recinfo.attribute11 IS NULL )
779 AND ( p_attribute11 IS NULL )))
780 AND ( ( Recinfo.attribute12 = p_attribute12)
781 OR ( ( Recinfo.attribute12 IS NULL )
782 AND ( p_attribute12 IS NULL )))
783 AND ( ( Recinfo.attribute13 = p_attribute13)
784 OR ( ( Recinfo.attribute13 IS NULL )
785 AND ( p_attribute13 IS NULL )))
786 AND ( ( Recinfo.attribute14 = p_attribute14)
787 OR ( ( Recinfo.attribute14 IS NULL )
788 AND ( p_attribute14 IS NULL )))
789 AND ( ( Recinfo.attribute15 = p_attribute15)
790 OR ( ( Recinfo.attribute15 IS NULL )
791 AND ( p_attribute15 IS NULL )))
792 AND ( ( Recinfo.org_id = p_org_id)
793 OR ( ( Recinfo.org_id IS NULL )
794 AND ( p_org_id IS NULL )))
795 ) THEN
796 RETURN;
797 ELSE
798 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
799 APP_EXCEPTION.RAISE_EXCEPTION;
800 END IF;
801 END Lock_Row;
802
803 END OZF_RESALE_BATCHES_PKG;