[Home] [Help]
PACKAGE BODY: APPS.OZF_SUPP_TRD_PRFLS_PKG
Source
1 PACKAGE BODY OZF_SUPP_TRD_PRFLS_PKG as
2 /* $Header: ozftstpb.pls 120.0.12010000.3 2008/10/10 09:35:34 kdass ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_supp_trd_prfls_PKG
7 -- Purpose
8 --
9 -- History
10 -- 16-SEP-2008 kdass ER 7377460 - added DFFs for DPP section
11 -- 09-OCT-2008 kdass ER 7475578 - Supplier Trade Profile changes for Price Protection price increase enhancement
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_supp_trd_prfls_PKG';
19 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftstpb.pls';
20
21 G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
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_supp_trade_profile_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_created_by NUMBER,
46 p_last_update_login NUMBER,
47 p_request_id NUMBER,
48 p_program_application_id NUMBER,
49 p_program_update_date DATE,
50 p_program_id NUMBER,
51 p_created_from VARCHAR2,
52 p_party_id NUMBER,
53 p_site_use_id NUMBER,
54 p_cust_account_id NUMBER,
55 p_cust_acct_site_id NUMBER,
56 p_supplier_id NUMBER,
57 p_supplier_site_id NUMBER,
58 p_attribute_category VARCHAR2,
59 p_attribute1 VARCHAR2,
60 p_attribute2 VARCHAR2,
61 p_attribute3 VARCHAR2,
62 p_attribute4 VARCHAR2,
63 p_attribute5 VARCHAR2,
64 p_attribute6 VARCHAR2,
65 p_attribute7 VARCHAR2,
66 p_attribute8 VARCHAR2,
67 p_attribute9 VARCHAR2,
68 p_attribute10 VARCHAR2,
69 p_attribute11 VARCHAR2,
70 p_attribute12 VARCHAR2,
71 p_attribute13 VARCHAR2,
72 p_attribute14 VARCHAR2,
73 p_attribute15 VARCHAR2,
74 p_attribute16 VARCHAR2,
75 p_attribute17 VARCHAR2,
76 p_attribute18 VARCHAR2,
77 p_attribute19 VARCHAR2,
78 p_attribute20 VARCHAR2,
79 p_attribute21 VARCHAR2,
80 p_attribute22 VARCHAR2,
81 p_attribute23 VARCHAR2,
82 p_attribute24 VARCHAR2,
83 p_attribute25 VARCHAR2,
84 p_attribute26 VARCHAR2,
85 p_attribute27 VARCHAR2,
86 p_attribute28 VARCHAR2,
87 p_attribute29 VARCHAR2,
88 p_attribute30 VARCHAR2,
89 p_dpp_attribute_category VARCHAR2,
90 p_dpp_attribute1 VARCHAR2,
91 p_dpp_attribute2 VARCHAR2,
92 p_dpp_attribute3 VARCHAR2,
93 p_dpp_attribute4 VARCHAR2,
94 p_dpp_attribute5 VARCHAR2,
95 p_dpp_attribute6 VARCHAR2,
96 p_dpp_attribute7 VARCHAR2,
97 p_dpp_attribute8 VARCHAR2,
98 p_dpp_attribute9 VARCHAR2,
99 p_dpp_attribute10 VARCHAR2,
100 p_dpp_attribute11 VARCHAR2,
101 p_dpp_attribute12 VARCHAR2,
102 p_dpp_attribute13 VARCHAR2,
103 p_dpp_attribute14 VARCHAR2,
104 p_dpp_attribute15 VARCHAR2,
105 p_dpp_attribute16 VARCHAR2,
106 p_dpp_attribute17 VARCHAR2,
107 p_dpp_attribute18 VARCHAR2,
108 p_dpp_attribute19 VARCHAR2,
109 p_dpp_attribute20 VARCHAR2,
110 p_dpp_attribute21 VARCHAR2,
111 p_dpp_attribute22 VARCHAR2,
112 p_dpp_attribute23 VARCHAR2,
113 p_dpp_attribute24 VARCHAR2,
114 p_dpp_attribute25 VARCHAR2,
115 p_dpp_attribute26 VARCHAR2,
116 p_dpp_attribute27 VARCHAR2,
117 p_dpp_attribute28 VARCHAR2,
118 p_dpp_attribute29 VARCHAR2,
119 p_dpp_attribute30 VARCHAR2,
120
121 px_org_id IN OUT NOCOPY NUMBER ,
122 p_pre_approval_flag VARCHAR2,
123 p_approval_communication VARCHAR2,
124 p_gl_contra_liability_acct NUMBER,
125 p_gl_cost_adjustment_acct NUMBER,
126 p_default_days_covered NUMBER,
127 p_create_claim_price_increase VARCHAR2,
128 p_authorization_period NUMBER,
129 p_grace_days NUMBER,
130 p_allow_qty_increase VARCHAR2,
131 p_qty_increase_tolerance NUMBER,
132 p_request_communication VARCHAR2,
133 p_claim_communication VARCHAR2,
134 p_claim_frequency NUMBER,
135 p_claim_frequency_unit VARCHAR2,
136 p_claim_computation_basis NUMBER,
137 p_claim_currency_code VARCHAR2,
138 p_min_claim_amt NUMBER,
139 p_min_claim_amt_line_lvl NUMBER,
140 p_auto_debit VARCHAR2,
141 p_days_before_claiming_debit NUMBER
142
143
144 )
145
146 IS
147 x_rowid VARCHAR2(30);
148
149
150 BEGIN
151 IF g_debug THEN
152 OZF_UTILITY_PVT.debug_message( 'Into begin 1');
153 END IF;
154
155 -- R12 Enhancements
156 IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
157 px_org_id := MO_GLOBAL.get_current_org_id();
158 END IF;
159
160 px_object_version_number := 1;
161 IF g_debug THEN
162 OZF_UTILITY_PVT.debug_message( 'before insert 2');
163 OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
164 OZF_UTILITY_PVT.debug_message( 'supplier id is'||p_supplier_id );
165 OZF_UTILITY_PVT.debug_message( 'supplier site id is'||p_supplier_site_id );
166 END IF;
167
168 INSERT INTO ozf_supp_trd_prfls_all(
169 supp_trade_profile_id,
170 object_version_number,
171 last_update_date,
172 last_updated_by,
173 creation_date,
174 created_by,
175 last_update_login,
176 request_id,
177 program_application_id,
178 program_update_date,
179 program_id,
180 created_from,
181 party_id,
182 site_use_id,
183 cust_account_id,
184 cust_acct_site_id,
185 supplier_id,
186 supplier_site_id,
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 attribute16,
204 attribute17,
205 attribute18,
206 attribute19,
207 attribute20,
208 attribute21,
209 attribute22,
210 attribute23,
211 attribute24,
212 attribute25,
213 attribute26,
214 attribute27,
215 attribute28,
216 attribute29,
217 attribute30,
218 dpp_attribute_category,
219 dpp_attribute1,
220 dpp_attribute2,
221 dpp_attribute3,
222 dpp_attribute4,
223 dpp_attribute5,
224 dpp_attribute6,
225 dpp_attribute7,
226 dpp_attribute8,
227 dpp_attribute9,
228 dpp_attribute10,
229 dpp_attribute11,
230 dpp_attribute12,
231 dpp_attribute13,
232 dpp_attribute14,
233 dpp_attribute15,
234 dpp_attribute16,
235 dpp_attribute17,
236 dpp_attribute18,
237 dpp_attribute19,
238 dpp_attribute20,
239 dpp_attribute21,
240 dpp_attribute22,
241 dpp_attribute23,
242 dpp_attribute24,
243 dpp_attribute25,
244 dpp_attribute26,
245 dpp_attribute27,
246 dpp_attribute28,
247 dpp_attribute29,
248 dpp_attribute30,
249 org_id ,
250 pre_approval_flag ,
251 approval_communication ,
252 gl_contra_liability_acct ,
253 gl_cost_adjustment_acct ,
254 default_days_covered ,
255 create_claim_price_increase ,
256 authorization_period ,
257 grace_days ,
258 allow_qty_increase ,
259 qty_increase_tolerance ,
260 request_communication ,
261 claim_communication ,
262 claim_frequency ,
263 claim_frequency_unit ,
264 claim_computation_basis ,
265 claim_currency_code ,
266 min_claim_amt ,
267 min_claim_amt_line_lvl ,
268 auto_debit ,
269 days_before_claiming_debit
270
271
272
273 ) VALUES (
274 px_supp_trade_profile_id,
275 px_object_version_number,
276 p_last_update_date,
277 p_last_updated_by,
278 p_creation_date,
279 p_created_by,
280 p_last_update_login,
281 p_request_id,
282 p_program_application_id,
283 p_program_update_date,
284 p_program_id,
285 p_created_from,
286 p_party_id,
287 p_site_use_id,
288 p_cust_account_id,
289 p_cust_acct_site_id,
290 p_supplier_id,
291 p_supplier_site_id,
292 p_attribute_category,
293 p_attribute1,
294 p_attribute2,
295 p_attribute3,
296 p_attribute4,
297 p_attribute5,
298 p_attribute6,
299 p_attribute7,
300 p_attribute8,
301 p_attribute9,
302 p_attribute10,
303 p_attribute11,
304 p_attribute12,
305 p_attribute13,
306 p_attribute14,
307 p_attribute15,
308 p_attribute16,
309 p_attribute17,
310 p_attribute18 ,
311 p_attribute19 ,
312 p_attribute20 ,
313 p_attribute21 ,
314 p_attribute22 ,
315 p_attribute23 ,
316 p_attribute24 ,
317 p_attribute25 ,
318 p_attribute26 ,
319 p_attribute27 ,
320 p_attribute28 ,
321 p_attribute29 ,
322 p_attribute30 ,
323 p_dpp_attribute_category,
324 p_dpp_attribute1,
325 p_dpp_attribute2,
326 p_dpp_attribute3,
327 p_dpp_attribute4,
328 p_dpp_attribute5,
329 p_dpp_attribute6,
330 p_dpp_attribute7,
331 p_dpp_attribute8,
332 p_dpp_attribute9,
333 p_dpp_attribute10,
334 p_dpp_attribute11,
335 p_dpp_attribute12,
336 p_dpp_attribute13,
337 p_dpp_attribute14,
338 p_dpp_attribute15,
339 p_dpp_attribute16,
340 p_dpp_attribute17,
341 p_dpp_attribute18,
342 p_dpp_attribute19,
343 p_dpp_attribute20,
344 p_dpp_attribute21,
345 p_dpp_attribute22,
346 p_dpp_attribute23,
347 p_dpp_attribute24,
348 p_dpp_attribute25,
349 p_dpp_attribute26,
350 p_dpp_attribute27,
351 p_dpp_attribute28,
352 p_dpp_attribute29,
353 p_dpp_attribute30,
354 px_org_id ,
355 p_pre_approval_flag ,
356 p_approval_communication ,
357 p_gl_contra_liability_acct ,
358 p_gl_cost_adjustment_acct ,
359 p_default_days_covered ,
360 p_create_claim_price_increase ,
361 p_authorization_period ,
362 p_grace_days ,
363 p_allow_qty_increase ,
364 p_qty_increase_tolerance ,
365 p_request_communication ,
366 p_claim_communication ,
367 p_claim_frequency ,
368 p_claim_frequency_unit ,
369 p_claim_computation_basis ,
370 p_claim_currency_code ,
371 p_min_claim_amt ,
372 p_min_claim_amt_line_lvl ,
373 p_auto_debit ,
374 p_days_before_claiming_debit
375
376
377
378 );
379 IF g_debug THEN
380 OZF_UTILITY_PVT.debug_message( 'after insert 2');
381 END IF;
382
383 END Insert_Row;
384
385
386 ----------------------------------------------------------
387 ---- MEDIA ----
388 ----------------------------------------------------------
389
390 -- ========================================================
391 --
392 -- NAME
393 -- createUpdateBody
394 --
395 -- PURPOSE
396 --
397 -- NOTES
398 --
399 -- HISTORY
400 --
401 -- ========================================================
402 PROCEDURE Update_Row(
403 p_supp_trade_profile_id NUMBER,
404 p_object_version_number NUMBER,
405 p_last_update_date DATE,
406 p_last_updated_by NUMBER,
407 p_last_update_login NUMBER,
408 p_request_id NUMBER,
409 p_program_application_id NUMBER,
410 p_program_update_date DATE,
411 p_program_id NUMBER,
412 p_created_from VARCHAR2,
413 p_party_id NUMBER,
414 p_site_use_id NUMBER,
415 p_cust_account_id NUMBER,
416 p_cust_acct_site_id NUMBER,
417 p_supplier_id NUMBER,
418 p_supplier_site_id NUMBER,
419 p_attribute_category VARCHAR2,
420 p_attribute1 VARCHAR2,
421 p_attribute2 VARCHAR2,
422 p_attribute3 VARCHAR2,
423 p_attribute4 VARCHAR2,
424 p_attribute5 VARCHAR2,
425 p_attribute6 VARCHAR2,
426 p_attribute7 VARCHAR2,
427 p_attribute8 VARCHAR2,
428 p_attribute9 VARCHAR2,
429 p_attribute10 VARCHAR2,
430 p_attribute11 VARCHAR2,
431 p_attribute12 VARCHAR2,
432 p_attribute13 VARCHAR2,
433 p_attribute14 VARCHAR2,
434 p_attribute15 VARCHAR2,
435 p_attribute16 VARCHAR2,
436 p_attribute17 VARCHAR2,
437 p_attribute18 VARCHAR2,
438 p_attribute19 VARCHAR2,
439 p_attribute20 VARCHAR2,
440 p_attribute21 VARCHAR2,
441 p_attribute22 VARCHAR2,
442 p_attribute23 VARCHAR2,
443 p_attribute24 VARCHAR2,
444 p_attribute25 VARCHAR2,
445 p_attribute26 VARCHAR2,
446 p_attribute27 VARCHAR2,
447 p_attribute28 VARCHAR2,
448 p_attribute29 VARCHAR2,
449 p_attribute30 VARCHAR2,
450 p_dpp_attribute_category VARCHAR2,
454 p_dpp_attribute4 VARCHAR2,
451 p_dpp_attribute1 VARCHAR2,
452 p_dpp_attribute2 VARCHAR2,
453 p_dpp_attribute3 VARCHAR2,
455 p_dpp_attribute5 VARCHAR2,
456 p_dpp_attribute6 VARCHAR2,
457 p_dpp_attribute7 VARCHAR2,
458 p_dpp_attribute8 VARCHAR2,
459 p_dpp_attribute9 VARCHAR2,
460 p_dpp_attribute10 VARCHAR2,
461 p_dpp_attribute11 VARCHAR2,
462 p_dpp_attribute12 VARCHAR2,
463 p_dpp_attribute13 VARCHAR2,
464 p_dpp_attribute14 VARCHAR2,
465 p_dpp_attribute15 VARCHAR2,
466 p_dpp_attribute16 VARCHAR2,
467 p_dpp_attribute17 VARCHAR2,
468 p_dpp_attribute18 VARCHAR2,
469 p_dpp_attribute19 VARCHAR2,
470 p_dpp_attribute20 VARCHAR2,
471 p_dpp_attribute21 VARCHAR2,
472 p_dpp_attribute22 VARCHAR2,
473 p_dpp_attribute23 VARCHAR2,
474 p_dpp_attribute24 VARCHAR2,
475 p_dpp_attribute25 VARCHAR2,
476 p_dpp_attribute26 VARCHAR2,
477 p_dpp_attribute27 VARCHAR2,
478 p_dpp_attribute28 VARCHAR2,
479 p_dpp_attribute29 VARCHAR2,
480 p_dpp_attribute30 VARCHAR2,
481 p_org_id NUMBER ,
482 p_pre_approval_flag VARCHAR2,
483 p_approval_communication VARCHAR2,
484 p_gl_contra_liability_acct NUMBER,
485 p_gl_cost_adjustment_acct NUMBER,
486 p_default_days_covered NUMBER,
487 p_create_claim_price_increase VARCHAR2,
488 p_authorization_period NUMBER,
489 p_grace_days NUMBER,
490 p_allow_qty_increase VARCHAR2,
491 p_qty_increase_tolerance NUMBER,
492 p_request_communication VARCHAR2,
493 p_claim_communication VARCHAR2,
494 p_claim_frequency NUMBER,
495 p_claim_frequency_unit VARCHAR2,
496 p_claim_computation_basis NUMBER ,
497 p_claim_currency_code VARCHAR2,
498 p_min_claim_amt NUMBER,
499 p_min_claim_amt_line_lvl NUMBER,
500 p_auto_debit VARCHAR2,
501 p_days_before_claiming_debit NUMBER
502 )
503 IS
504 BEGIN
505
506 IF g_debug THEN
507 OZF_UTILITY_PVT.debug_message( 'Inside update table ');
508 OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_supp_trade_profile_id);
509 OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
510 END IF;
511
512 Update ozf_supp_trd_prfls_all
513 SET
514 supp_trade_profile_id = p_supp_trade_profile_id,
515 object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),
516 last_update_date = p_last_update_date,
517 last_updated_by = p_last_updated_by,
518 last_update_login = p_last_update_login,
519 request_id = p_request_id,
520 program_application_id = p_program_application_id,
521 program_update_date = p_program_update_date,
522 program_id = p_program_id,
523 created_from = p_created_from,
524 party_id = p_party_id,
525 site_use_id = p_site_use_id,
526 cust_account_id = p_cust_account_id,
527 cust_acct_site_id = p_cust_acct_site_id,
528 supplier_id = p_supplier_id,
529 supplier_site_id = p_supplier_site_id,
530 attribute_category = p_attribute_category,
531 attribute1 = p_attribute1,
532 attribute2 = p_attribute2,
533 attribute3 = p_attribute3,
534 attribute4 = p_attribute4,
535 attribute5 = p_attribute5,
536 attribute6 = p_attribute6,
537 attribute7 = p_attribute7,
538 attribute8 = p_attribute8,
539 attribute9 = p_attribute9,
540 attribute10 = p_attribute10,
541 attribute11 = p_attribute11,
542 attribute12 = p_attribute12,
543 attribute13 = p_attribute13,
544 attribute14 = p_attribute14,
545 attribute15 = p_attribute15,
546 attribute16 = p_attribute16 ,
547 attribute17 = p_attribute17 ,
548 attribute18 = p_attribute18 ,
549 attribute19 = p_attribute19 ,
550 attribute20 = p_attribute20 ,
551 attribute21 = p_attribute21 ,
552 attribute22 = p_attribute22 ,
553 attribute23 = p_attribute23 ,
554 attribute24 = p_attribute24 ,
555 attribute25 = p_attribute25 ,
556 attribute26 = p_attribute26 ,
557 attribute27 = p_attribute27 ,
558 attribute28 = p_attribute28 ,
559 attribute29 = p_attribute29 ,
560 attribute30 = p_attribute30 ,
561 dpp_attribute_category = p_dpp_attribute_category,
562 dpp_attribute1 = p_dpp_attribute1,
563 dpp_attribute2 = p_dpp_attribute2,
564 dpp_attribute3 = p_dpp_attribute3,
565 dpp_attribute4 = p_dpp_attribute4,
566 dpp_attribute5 = p_dpp_attribute5,
567 dpp_attribute6 = p_dpp_attribute6,
568 dpp_attribute7 = p_dpp_attribute7,
569 dpp_attribute8 = p_dpp_attribute8,
573 dpp_attribute12 = p_dpp_attribute12,
570 dpp_attribute9 = p_dpp_attribute9,
571 dpp_attribute10 = p_dpp_attribute10,
572 dpp_attribute11 = p_dpp_attribute11,
574 dpp_attribute13 = p_dpp_attribute13,
575 dpp_attribute14 = p_dpp_attribute14,
576 dpp_attribute15 = p_dpp_attribute15,
577 dpp_attribute16 = p_dpp_attribute16,
578 dpp_attribute17 = p_dpp_attribute17,
579 dpp_attribute18 = p_dpp_attribute18,
580 dpp_attribute19 = p_dpp_attribute19,
581 dpp_attribute20 = p_dpp_attribute20,
582 dpp_attribute21 = p_dpp_attribute21,
583 dpp_attribute22 = p_dpp_attribute22,
584 dpp_attribute23 = p_dpp_attribute23,
585 dpp_attribute24 = p_dpp_attribute24,
586 dpp_attribute25 = p_dpp_attribute25,
587 dpp_attribute26 = p_dpp_attribute26,
588 dpp_attribute27 = p_dpp_attribute27,
589 dpp_attribute28 = p_dpp_attribute28,
590 dpp_attribute29 = p_dpp_attribute29,
591 dpp_attribute30 = p_dpp_attribute30,
592
593 org_id = p_org_id ,
594 pre_approval_flag = p_pre_approval_flag ,
595 approval_communication = p_approval_communication ,
596 gl_contra_liability_acct = p_gl_contra_liability_acct ,
597 gl_cost_adjustment_acct = p_gl_cost_adjustment_acct ,
598 default_days_covered = p_default_days_covered ,
599 create_claim_price_increase = p_create_claim_price_increase ,
600 authorization_period = p_authorization_period ,
601 grace_days = p_grace_days ,
602 allow_qty_increase = p_allow_qty_increase ,
603 qty_increase_tolerance = p_qty_increase_tolerance ,
604 request_communication = p_request_communication ,
605 claim_communication = p_claim_communication ,
606 claim_frequency = p_claim_frequency ,
607 claim_frequency_unit = p_claim_frequency_unit ,
608 claim_computation_basis = p_claim_computation_basis ,
609 claim_currency_code = p_claim_currency_code ,
610 min_claim_amt = p_min_claim_amt ,
611 min_claim_amt_line_lvl = p_min_claim_amt_line_lvl ,
612 auto_debit = p_auto_debit ,
613 days_before_claiming_debit = p_days_before_claiming_debit
614
615 WHERE supp_trade_profile_id = p_supp_trade_profile_id;
616 IF (SQL%NOTFOUND) THEN
617 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618 END IF;
619 END Update_Row;
620
621
622 ----------------------------------------------------------
623 ---- MEDIA ----
624 ----------------------------------------------------------
625
626 -- ========================================================
627 --
628 -- NAME
629 -- createDeleteBody
630 --
631 -- PURPOSE
632 --
633 -- NOTES
634 --
635 -- HISTORY
636 --
637 -- ========================================================
638 PROCEDURE Delete_Row(
639 p_supp_trade_profile_id NUMBER)
640 IS
641 BEGIN
642 DELETE FROM ozf_supp_trd_prfls_all
643 WHERE supp_trade_profile_id = p_supp_trade_profile_id;
644 If (SQL%NOTFOUND) then
645 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
646 End If;
647 END Delete_Row ;
648
649
650
651 ----------------------------------------------------------
652 ---- MEDIA ----
653 ----------------------------------------------------------
654
655 -- ========================================================
656 --
657 -- NAME
658 -- createLockBody
659 --
660 -- PURPOSE
661 --
662 -- NOTES
663 --
664 -- HISTORY
665 --
666 -- ========================================================
667 PROCEDURE Lock_Row(
668 p_supp_trade_profile_id NUMBER,
669 p_object_version_number NUMBER,
670 p_last_update_date DATE,
671 p_last_updated_by NUMBER,
672 p_creation_date DATE,
673 p_created_by NUMBER,
674 p_last_update_login NUMBER,
675 p_request_id NUMBER,
676 p_program_application_id NUMBER,
677 p_program_update_date DATE,
678 p_program_id NUMBER,
679 p_created_from VARCHAR2,
680 p_party_id NUMBER,
681 p_site_use_id NUMBER,
682 p_cust_account_id NUMBER,
683 p_cust_acct_site_id NUMBER,
684 p_supplier_id NUMBER,
685 p_supplier_site_id NUMBER,
686 p_attribute_category VARCHAR2,
687 p_attribute1 VARCHAR2,
688 p_attribute2 VARCHAR2,
692 p_attribute6 VARCHAR2,
689 p_attribute3 VARCHAR2,
690 p_attribute4 VARCHAR2,
691 p_attribute5 VARCHAR2,
693 p_attribute7 VARCHAR2,
694 p_attribute8 VARCHAR2,
695 p_attribute9 VARCHAR2,
696 p_attribute10 VARCHAR2,
697 p_attribute11 VARCHAR2,
698 p_attribute12 VARCHAR2,
699 p_attribute13 VARCHAR2,
700 p_attribute14 VARCHAR2,
701 p_attribute15 VARCHAR2,
702 p_attribute16 VARCHAR2,
703 p_attribute17 VARCHAR2,
704 p_attribute18 VARCHAR2,
705 p_attribute19 VARCHAR2,
706 p_attribute20 VARCHAR2,
707 p_attribute21 VARCHAR2,
708 p_attribute22 VARCHAR2,
709 p_attribute23 VARCHAR2,
710 p_attribute24 VARCHAR2,
711 p_attribute25 VARCHAR2,
712 p_attribute26 VARCHAR2,
713 p_attribute27 VARCHAR2,
714 p_attribute28 VARCHAR2,
715 p_attribute29 VARCHAR2,
716 p_attribute30 VARCHAR2,
717 p_dpp_attribute_category VARCHAR2,
718 p_dpp_attribute1 VARCHAR2,
719 p_dpp_attribute2 VARCHAR2,
720 p_dpp_attribute3 VARCHAR2,
721 p_dpp_attribute4 VARCHAR2,
722 p_dpp_attribute5 VARCHAR2,
723 p_dpp_attribute6 VARCHAR2,
724 p_dpp_attribute7 VARCHAR2,
725 p_dpp_attribute8 VARCHAR2,
726 p_dpp_attribute9 VARCHAR2,
727 p_dpp_attribute10 VARCHAR2,
728 p_dpp_attribute11 VARCHAR2,
729 p_dpp_attribute12 VARCHAR2,
730 p_dpp_attribute13 VARCHAR2,
731 p_dpp_attribute14 VARCHAR2,
732 p_dpp_attribute15 VARCHAR2,
733 p_dpp_attribute16 VARCHAR2,
734 p_dpp_attribute17 VARCHAR2,
735 p_dpp_attribute18 VARCHAR2,
736 p_dpp_attribute19 VARCHAR2,
737 p_dpp_attribute20 VARCHAR2,
738 p_dpp_attribute21 VARCHAR2,
739 p_dpp_attribute22 VARCHAR2,
740 p_dpp_attribute23 VARCHAR2,
741 p_dpp_attribute24 VARCHAR2,
742 p_dpp_attribute25 VARCHAR2,
743 p_dpp_attribute26 VARCHAR2,
744 p_dpp_attribute27 VARCHAR2,
745 p_dpp_attribute28 VARCHAR2,
746 p_dpp_attribute29 VARCHAR2,
747 p_dpp_attribute30 VARCHAR2,
748
749 p_org_id NUMBER ,
750 p_pre_approval_flag VARCHAR2,
751 p_approval_communication VARCHAR2,
752 p_gl_contra_liability_acct NUMBER,
753 p_gl_cost_adjustment_acct NUMBER,
754 p_default_days_covered NUMBER,
755 p_create_claim_price_increase VARCHAR2,
756 p_authorization_period NUMBER,
757 p_grace_days NUMBER,
758 p_allow_qty_increase VARCHAR2,
759 p_qty_increase_tolerance NUMBER,
760 p_request_communication VARCHAR2,
761 p_claim_communication VARCHAR2,
762 p_claim_frequency NUMBER,
763 p_claim_frequency_unit VARCHAR2,
764 p_claim_computation_basis NUMBER,
765 p_claim_currency_code VARCHAR2,
766 p_min_claim_amt NUMBER,
767 p_min_claim_amt_line_lvl NUMBER,
768 p_auto_debit VARCHAR2,
769 p_days_before_claiming_debit NUMBER
770 )
771
772 IS
773 CURSOR C IS
774 SELECT *
775 FROM ozf_supp_trd_prfls_all
776 WHERE supp_trade_profile_id = p_supp_trade_profile_id
777 FOR UPDATE of supp_trade_profile_id NOWAIT;
778 Recinfo C%ROWTYPE;
779 BEGIN
780 OPEN c;
781 FETCH c INTO Recinfo;
782 If (c%NOTFOUND) then
783 CLOSE c;
784 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
785 APP_EXCEPTION.RAISE_EXCEPTION;
786 END IF;
787 CLOSE C;
788 IF(
789 ( Recinfo.supp_trade_profile_id = p_supp_trade_profile_id)
790 AND ( ( Recinfo.object_version_number = p_object_version_number)
791 OR ( ( Recinfo.object_version_number IS NULL )
792 AND ( p_object_version_number IS NULL )))
793 AND ( ( Recinfo.last_update_date = p_last_update_date)
794 OR ( ( Recinfo.last_update_date IS NULL )
795 AND ( p_last_update_date IS NULL )))
796 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
797 OR ( ( Recinfo.last_updated_by IS NULL )
798 AND ( p_last_updated_by IS NULL )))
799 AND ( ( Recinfo.creation_date = p_creation_date)
800 OR ( ( Recinfo.creation_date IS NULL )
801 AND ( p_creation_date IS NULL )))
802 AND ( ( Recinfo.created_by = p_created_by)
803 OR ( ( Recinfo.created_by IS NULL )
804 AND ( p_created_by IS NULL )))
805 AND ( ( Recinfo.last_update_login = p_last_update_login)
806 OR ( ( Recinfo.last_update_login IS NULL )
807 AND ( p_last_update_login IS NULL )))
808 AND ( ( Recinfo.request_id = p_request_id)
809 OR ( ( Recinfo.request_id IS NULL )
810 AND ( p_request_id IS NULL )))
811 AND ( ( Recinfo.program_application_id = p_program_application_id)
812 OR ( ( Recinfo.program_application_id IS NULL )
813 AND ( p_program_application_id IS NULL )))
817 AND ( ( Recinfo.program_id = p_program_id)
814 AND ( ( Recinfo.program_update_date = p_program_update_date)
815 OR ( ( Recinfo.program_update_date IS NULL )
816 AND ( p_program_update_date IS NULL )))
818 OR ( ( Recinfo.program_id IS NULL )
819 AND ( p_program_id IS NULL )))
820 AND ( ( Recinfo.created_from = p_created_from)
821 OR ( ( Recinfo.created_from IS NULL )
822 AND ( p_created_from IS NULL )))
823 AND ( ( Recinfo.party_id = p_party_id)
824 OR ( ( Recinfo.party_id IS NULL )
825 AND ( p_party_id IS NULL )))
826 AND ( ( Recinfo.site_use_id = p_site_use_id)
827 OR ( ( Recinfo.site_use_id IS NULL )
828 AND ( p_site_use_id IS NULL )))
829 AND ( ( Recinfo.pre_approval_flag = p_pre_approval_flag)
830 OR ( ( Recinfo.pre_approval_flag IS NULL )
831 AND ( p_pre_approval_flag IS NULL )))
832 AND ( ( Recinfo.approval_communication = p_approval_communication)
833 OR ( ( Recinfo.approval_communication IS NULL )
834 AND ( p_approval_communication IS NULL )))
835 AND ( ( Recinfo.gl_contra_liability_acct = p_gl_contra_liability_acct)
836 OR ( ( Recinfo.gl_contra_liability_acct IS NULL )
837 AND ( p_gl_contra_liability_acct IS NULL )))
838 AND ( ( Recinfo.gl_cost_adjustment_acct = p_gl_cost_adjustment_acct)
839 OR ( ( Recinfo.gl_cost_adjustment_acct IS NULL )
840 AND ( p_gl_cost_adjustment_acct IS NULL )))
841
842 AND ( ( Recinfo.default_days_covered = p_default_days_covered)
843 OR ( ( Recinfo.default_days_covered IS NULL )
844 AND ( p_default_days_covered IS NULL )))
845
846 AND ( ( Recinfo.create_claim_price_increase = p_create_claim_price_increase)
847 OR ( ( Recinfo.create_claim_price_increase IS NULL )
848 AND ( p_create_claim_price_increase IS NULL )))
849
850 AND ( ( Recinfo.authorization_period= p_authorization_period)
851 OR ( ( Recinfo.authorization_period IS NULL )
852 AND ( p_authorization_period IS NULL )))
853
854
855 AND ( ( Recinfo.grace_days = p_grace_days)
856 OR ( ( Recinfo.grace_days IS NULL )
857 AND ( p_grace_days IS NULL )))
858
859 AND ( ( Recinfo.allow_qty_increase = p_allow_qty_increase)
860 OR ( ( Recinfo.allow_qty_increase IS NULL )
861 AND ( p_allow_qty_increase IS NULL )))
862
863 AND ( ( Recinfo.qty_increase_tolerance = p_qty_increase_tolerance)
864 OR ( ( Recinfo.qty_increase_tolerance IS NULL )
865 AND ( p_qty_increase_tolerance IS NULL )))
866
867
868 AND ( ( Recinfo.request_communication = p_request_communication)
869 OR ( ( Recinfo.request_communication IS NULL )
870 AND ( p_request_communication IS NULL )))
871
872 AND ( ( Recinfo.claim_communication = p_claim_communication)
873 OR ( ( Recinfo.claim_communication IS NULL )
874 AND ( p_claim_communication IS NULL )))
875
876 AND ( ( Recinfo.claim_frequency = p_claim_frequency)
877 OR ( ( Recinfo.claim_frequency IS NULL )
878 AND ( p_claim_frequency IS NULL )))
879
880
881 AND ( ( Recinfo.claim_frequency_unit = p_claim_frequency_unit)
882 OR ( ( Recinfo.claim_frequency_unit IS NULL )
883 AND ( p_claim_frequency_unit IS NULL )))
884
885 AND ( ( Recinfo.claim_computation_basis = p_claim_computation_basis)
886 OR ( ( Recinfo.claim_computation_basis IS NULL )
887 AND ( p_claim_computation_basis IS NULL )))
888
889 AND ( ( Recinfo.claim_currency_code = p_claim_currency_code)
890 OR ( ( Recinfo.claim_currency_code IS NULL )
891 AND ( p_claim_currency_code IS NULL )))
892
893 AND ( ( Recinfo.min_claim_amt = p_min_claim_amt)
894 OR ( ( Recinfo.min_claim_amt IS NULL )
895 AND ( p_min_claim_amt IS NULL )))
896
897 AND ( ( Recinfo.min_claim_amt_line_lvl = p_min_claim_amt_line_lvl)
898 OR ( ( Recinfo.min_claim_amt_line_lvl IS NULL )
899 AND ( p_min_claim_amt_line_lvl IS NULL )))
900
901
902 AND ( ( Recinfo.auto_debit = p_auto_debit)
903 OR ( ( Recinfo.auto_debit IS NULL )
904 AND ( p_auto_debit IS NULL )))
905
906 AND ( ( Recinfo.days_before_claiming_debit = p_days_before_claiming_debit)
907 OR ( ( Recinfo.days_before_claiming_debit IS NULL )
908 AND ( p_days_before_claiming_debit IS NULL )))
909
910 AND ( ( Recinfo.cust_account_id = p_cust_account_id)
911 OR ( ( Recinfo.cust_account_id IS NULL )
912 AND ( p_cust_account_id IS NULL )))
913 AND ( ( Recinfo.cust_acct_site_id = p_cust_acct_site_id)
914 OR ( ( Recinfo.cust_acct_site_id IS NULL )
915 AND ( p_cust_acct_site_id IS NULL )))
916 AND ( ( Recinfo.supplier_id = p_supplier_id)
917 OR ( ( Recinfo.supplier_id IS NULL )
918 AND ( p_supplier_id IS NULL )))
919 AND ( ( Recinfo.supplier_site_id = p_supplier_site_id)
920 OR ( ( Recinfo.supplier_site_id IS NULL )
921 AND ( p_supplier_site_id IS NULL )))
922
923 AND ( ( Recinfo.attribute_category = p_attribute_category)
924 OR ( ( Recinfo.attribute_category IS NULL )
925 AND ( p_attribute_category IS NULL )))
926 AND ( ( Recinfo.attribute1 = p_attribute1)
930 OR ( ( Recinfo.attribute2 IS NULL )
927 OR ( ( Recinfo.attribute1 IS NULL )
928 AND ( p_attribute1 IS NULL )))
929 AND ( ( Recinfo.attribute2 = p_attribute2)
931 AND ( p_attribute2 IS NULL )))
932 AND ( ( Recinfo.attribute3 = p_attribute3)
933 OR ( ( Recinfo.attribute3 IS NULL )
934 AND ( p_attribute3 IS NULL )))
935 AND ( ( Recinfo.attribute4 = p_attribute4)
936 OR ( ( Recinfo.attribute4 IS NULL )
937 AND ( p_attribute4 IS NULL )))
938 AND ( ( Recinfo.attribute5 = p_attribute5)
939 OR ( ( Recinfo.attribute5 IS NULL )
940 AND ( p_attribute5 IS NULL )))
941 AND ( ( Recinfo.attribute6 = p_attribute6)
942 OR ( ( Recinfo.attribute6 IS NULL )
943 AND ( p_attribute6 IS NULL )))
944 AND ( ( Recinfo.attribute7 = p_attribute7)
945 OR ( ( Recinfo.attribute7 IS NULL )
946 AND ( p_attribute7 IS NULL )))
947 AND ( ( Recinfo.attribute8 = p_attribute8)
948 OR ( ( Recinfo.attribute8 IS NULL )
949 AND ( p_attribute8 IS NULL )))
950 AND ( ( Recinfo.attribute9 = p_attribute9)
951 OR ( ( Recinfo.attribute9 IS NULL )
952 AND ( p_attribute9 IS NULL )))
953 AND ( ( Recinfo.attribute10 = p_attribute10)
954 OR ( ( Recinfo.attribute10 IS NULL )
955 AND ( p_attribute10 IS NULL )))
956 AND ( ( Recinfo.attribute11 = p_attribute11)
957 OR ( ( Recinfo.attribute11 IS NULL )
958 AND ( p_attribute11 IS NULL )))
959 AND ( ( Recinfo.attribute12 = p_attribute12)
960 OR ( ( Recinfo.attribute12 IS NULL )
961 AND ( p_attribute12 IS NULL )))
962 AND ( ( Recinfo.attribute13 = p_attribute13)
963 OR ( ( Recinfo.attribute13 IS NULL )
964 AND ( p_attribute13 IS NULL )))
965 AND ( ( Recinfo.attribute14 = p_attribute14)
966 OR ( ( Recinfo.attribute14 IS NULL )
967 AND ( p_attribute14 IS NULL )))
968 AND ( ( Recinfo.attribute15 = p_attribute15)
969 OR ( ( Recinfo.attribute15 IS NULL )
970 AND ( p_attribute15 IS NULL )))
971 AND ( ( Recinfo.attribute16 = p_attribute16)
972 OR ( ( Recinfo.attribute16 IS NULL )
973 AND ( p_attribute16 IS NULL )))
974 AND ( ( Recinfo.attribute17 = p_attribute17)
975 OR ( ( Recinfo.attribute17 IS NULL )
976 AND ( p_attribute17 IS NULL )))
977 AND ( ( Recinfo.attribute18 = p_attribute18)
978 OR ( ( Recinfo.attribute18 IS NULL )
979 AND ( p_attribute18 IS NULL )))
980 AND ( ( Recinfo.attribute19 = p_attribute19)
981 OR ( ( Recinfo.attribute19 IS NULL )
982 AND ( p_attribute19 IS NULL )))
983 AND ( ( Recinfo.attribute20 = p_attribute20)
984 OR ( ( Recinfo.attribute20 IS NULL )
985 AND ( p_attribute20 IS NULL )))
986 AND ( ( Recinfo.attribute21 = p_attribute21)
987 OR ( ( Recinfo.attribute21 IS NULL )
988 AND ( p_attribute21 IS NULL )))
989 AND ( ( Recinfo.attribute22 = p_attribute22)
990 OR ( ( Recinfo.attribute22 IS NULL )
991 AND ( p_attribute22 IS NULL )))
992 AND ( ( Recinfo.attribute23 = p_attribute23)
993 OR ( ( Recinfo.attribute23 IS NULL )
994 AND ( p_attribute23 IS NULL )))
995 AND ( ( Recinfo.attribute24 = p_attribute24)
996 OR ( ( Recinfo.attribute24 IS NULL )
997 AND ( p_attribute24 IS NULL )))
998 AND ( ( Recinfo.attribute25 = p_attribute25)
999 OR ( ( Recinfo.attribute25 IS NULL )
1000 AND ( p_attribute25 IS NULL )))
1001 AND ( ( Recinfo.attribute26 = p_attribute26)
1002 OR ( ( Recinfo.attribute26 IS NULL )
1003 AND ( p_attribute26 IS NULL )))
1004 AND ( ( Recinfo.attribute27 = p_attribute27)
1005 OR ( ( Recinfo.attribute27 IS NULL )
1006 AND ( p_attribute27 IS NULL )))
1007 AND ( ( Recinfo.attribute28 = p_attribute28)
1008 OR ( ( Recinfo.attribute28 IS NULL )
1009 AND ( p_attribute28 IS NULL )))
1010 AND ( ( Recinfo.attribute29 = p_attribute29)
1011 OR ( ( Recinfo.attribute29 IS NULL )
1012 AND ( p_attribute19 IS NULL )))
1013 AND ( ( Recinfo.attribute30 = p_attribute30)
1014 OR ( ( Recinfo.attribute30 IS NULL )
1015 AND ( p_attribute30 IS NULL )))
1016 AND ( ( Recinfo.dpp_attribute_category = p_dpp_attribute_category)
1017 OR ( ( Recinfo.dpp_attribute_category IS NULL )
1018 AND ( p_dpp_attribute_category IS NULL )))
1019 AND ( ( Recinfo.dpp_attribute1 = p_dpp_attribute1)
1020 OR ( ( Recinfo.dpp_attribute1 IS NULL )
1021 AND ( p_dpp_attribute1 IS NULL )))
1022 AND ( ( Recinfo.dpp_attribute2 = p_dpp_attribute2)
1023 OR ( ( Recinfo.dpp_attribute2 IS NULL )
1024 AND ( p_dpp_attribute2 IS NULL )))
1025 AND ( ( Recinfo.dpp_attribute3 = p_dpp_attribute3)
1026 OR ( ( Recinfo.dpp_attribute3 IS NULL )
1027 AND ( p_dpp_attribute3 IS NULL )))
1028 AND ( ( Recinfo.dpp_attribute4 = p_dpp_attribute4)
1029 OR ( ( Recinfo.dpp_attribute4 IS NULL )
1030 AND ( p_dpp_attribute4 IS NULL )))
1031 AND ( ( Recinfo.dpp_attribute5 = p_dpp_attribute5)
1032 OR ( ( Recinfo.dpp_attribute5 IS NULL )
1033 AND ( p_dpp_attribute5 IS NULL )))
1034 AND ( ( Recinfo.dpp_attribute6 = p_dpp_attribute6)
1035 OR ( ( Recinfo.dpp_attribute6 IS NULL )
1036 AND ( p_dpp_attribute6 IS NULL )))
1037 AND ( ( Recinfo.dpp_attribute7 = p_dpp_attribute7)
1038 OR ( ( Recinfo.dpp_attribute7 IS NULL )
1039 AND ( p_dpp_attribute7 IS NULL )))
1040 AND ( ( Recinfo.dpp_attribute8 = p_dpp_attribute8)
1041 OR ( ( Recinfo.dpp_attribute8 IS NULL )
1042 AND ( p_dpp_attribute8 IS NULL )))
1043 AND ( ( Recinfo.dpp_attribute9 = p_dpp_attribute9)
1044 OR ( ( Recinfo.dpp_attribute9 IS NULL )
1045 AND ( p_dpp_attribute9 IS NULL )))
1046 AND ( ( Recinfo.dpp_attribute10 = p_dpp_attribute10)
1047 OR ( ( Recinfo.dpp_attribute10 IS NULL )
1048 AND ( p_dpp_attribute10 IS NULL )))
1049 AND ( ( Recinfo.dpp_attribute11 = p_dpp_attribute11)
1050 OR ( ( Recinfo.dpp_attribute11 IS NULL )
1051 AND ( p_dpp_attribute11 IS NULL )))
1052 AND ( ( Recinfo.dpp_attribute12 = p_dpp_attribute12)
1053 OR ( ( Recinfo.dpp_attribute12 IS NULL )
1054 AND ( p_dpp_attribute12 IS NULL )))
1055 AND ( ( Recinfo.dpp_attribute13 = p_dpp_attribute13)
1056 OR ( ( Recinfo.dpp_attribute13 IS NULL )
1057 AND ( p_dpp_attribute13 IS NULL )))
1058 AND ( ( Recinfo.dpp_attribute14 = p_dpp_attribute14)
1059 OR ( ( Recinfo.dpp_attribute14 IS NULL )
1060 AND ( p_dpp_attribute14 IS NULL )))
1061 AND ( ( Recinfo.dpp_attribute15 = p_dpp_attribute15)
1062 OR ( ( Recinfo.dpp_attribute15 IS NULL )
1063 AND ( p_dpp_attribute15 IS NULL )))
1064 AND ( ( Recinfo.dpp_attribute16 = p_dpp_attribute16)
1065 OR ( ( Recinfo.dpp_attribute16 IS NULL )
1066 AND ( p_dpp_attribute16 IS NULL )))
1067 AND ( ( Recinfo.dpp_attribute17 = p_dpp_attribute17)
1068 OR ( ( Recinfo.dpp_attribute17 IS NULL )
1069 AND ( p_dpp_attribute17 IS NULL )))
1070 AND ( ( Recinfo.dpp_attribute18 = p_dpp_attribute18)
1071 OR ( ( Recinfo.dpp_attribute18 IS NULL )
1072 AND ( p_dpp_attribute18 IS NULL )))
1073 AND ( ( Recinfo.dpp_attribute19 = p_dpp_attribute19)
1074 OR ( ( Recinfo.dpp_attribute19 IS NULL )
1075 AND ( p_dpp_attribute19 IS NULL )))
1076 AND ( ( Recinfo.dpp_attribute20 = p_dpp_attribute20)
1077 OR ( ( Recinfo.dpp_attribute20 IS NULL )
1078 AND ( p_dpp_attribute20 IS NULL )))
1079 AND ( ( Recinfo.dpp_attribute21 = p_dpp_attribute21)
1080 OR ( ( Recinfo.dpp_attribute21 IS NULL )
1081 AND ( p_dpp_attribute21 IS NULL )))
1082 AND ( ( Recinfo.dpp_attribute22 = p_dpp_attribute22)
1083 OR ( ( Recinfo.dpp_attribute22 IS NULL )
1084 AND ( p_dpp_attribute22 IS NULL )))
1085 AND ( ( Recinfo.dpp_attribute23 = p_dpp_attribute23)
1086 OR ( ( Recinfo.dpp_attribute23 IS NULL )
1087 AND ( p_dpp_attribute23 IS NULL )))
1088 AND ( ( Recinfo.dpp_attribute24 = p_dpp_attribute24)
1089 OR ( ( Recinfo.dpp_attribute24 IS NULL )
1090 AND ( p_dpp_attribute24 IS NULL )))
1091 AND ( ( Recinfo.dpp_attribute25 = p_dpp_attribute25)
1092 OR ( ( Recinfo.dpp_attribute25 IS NULL )
1093 AND ( p_dpp_attribute25 IS NULL )))
1094 AND ( ( Recinfo.dpp_attribute26 = p_dpp_attribute26)
1095 OR ( ( Recinfo.dpp_attribute26 IS NULL )
1096 AND ( p_dpp_attribute26 IS NULL )))
1097 AND ( ( Recinfo.dpp_attribute27 = p_dpp_attribute27)
1098 OR ( ( Recinfo.dpp_attribute27 IS NULL )
1099 AND ( p_dpp_attribute27 IS NULL )))
1100 AND ( ( Recinfo.dpp_attribute28 = p_dpp_attribute28)
1101 OR ( ( Recinfo.dpp_attribute28 IS NULL )
1102 AND ( p_dpp_attribute28 IS NULL )))
1103 AND ( ( Recinfo.dpp_attribute29 = p_dpp_attribute29)
1104 OR ( ( Recinfo.dpp_attribute29 IS NULL )
1105 AND ( p_dpp_attribute19 IS NULL )))
1106 AND ( ( Recinfo.dpp_attribute30 = p_dpp_attribute30)
1107 OR ( ( Recinfo.dpp_attribute30 IS NULL )
1108 AND ( p_dpp_attribute30 IS NULL )))
1109 AND ( ( Recinfo.org_id = p_org_id)
1110 OR ( ( Recinfo.org_id IS NULL )
1111 AND ( p_org_id IS NULL )))
1112
1113 ) THEN
1114 RETURN;
1115 ELSE
1116 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1117 APP_EXCEPTION.RAISE_EXCEPTION;
1118 END IF;
1119 END Lock_Row;
1120
1121 END OZF_supp_trd_prfls_PKG;
1122
1123