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