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