[Home] [Help]
PACKAGE BODY: APPS.OZF_CUST_TRD_PRFLS_PKG
Source
1 PACKAGE BODY OZF_cust_trd_prfls_PKG as
2 /* $Header: ozftctpb.pls 120.2 2005/09/14 05:11:43 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_cust_trd_prfls_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_cust_trd_prfls_PKG';
17 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftctpb.pls';
18
19 G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
20
21 ----------------------------------------------------------
22 ---- MEDIA ----
23 ----------------------------------------------------------
24
25 -- ========================================================
26 --
27 -- NAME
28 -- createInsertBody
29 --
30 -- PURPOSE
31 --
32 -- NOTES
33 --
34 -- HISTORY
35 --
36 -- ========================================================
37 PROCEDURE Insert_Row(
38 px_trade_profile_id IN OUT NOCOPY NUMBER,
39 px_object_version_number IN OUT NOCOPY NUMBER,
40 p_last_update_date DATE,
41 p_last_updated_by NUMBER,
42 p_creation_date DATE,
43 p_created_by NUMBER,
44 p_last_update_login NUMBER,
45 p_request_id NUMBER,
46 p_program_application_id NUMBER,
47 p_program_update_date DATE,
48 p_program_id NUMBER,
49 p_created_from VARCHAR2,
50 p_party_id NUMBER,
51 p_site_use_id NUMBER,
52 p_autopay_flag VARCHAR2,
53 p_claim_threshold NUMBER,
54 p_claim_currency VARCHAR2,
55 p_print_flag VARCHAR2,
56 p_internet_deal_view_flag VARCHAR2,
57 p_internet_claims_flag VARCHAR2,
58 p_autopay_periodicity NUMBER,
59 p_autopay_periodicity_type VARCHAR2,
60 p_payment_method VARCHAR2,
61 p_discount_type VARCHAR2,
62 p_cust_account_id NUMBER,
63 p_cust_acct_site_id NUMBER,
64 p_vendor_id NUMBER,
65 p_vendor_site_id NUMBER,
66 p_vendor_site_code VARCHAR2,
67 p_context VARCHAR2,
68 p_attribute_category VARCHAR2,
69 p_attribute1 VARCHAR2,
70 p_attribute2 VARCHAR2,
71 p_attribute3 VARCHAR2,
72 p_attribute4 VARCHAR2,
73 p_attribute5 VARCHAR2,
74 p_attribute6 VARCHAR2,
75 p_attribute7 VARCHAR2,
76 p_attribute8 VARCHAR2,
77 p_attribute9 VARCHAR2,
78 p_attribute10 VARCHAR2,
79 p_attribute11 VARCHAR2,
80 p_attribute12 VARCHAR2,
81 p_attribute13 VARCHAR2,
82 p_attribute14 VARCHAR2,
83 p_attribute15 VARCHAR2,
84 px_org_id IN OUT NOCOPY NUMBER,
85 p_days_due NUMBER,
86 p_pos_write_off_threshold NUMBER,
87 p_neg_write_off_threshold NUMBER,
88 p_un_earned_pay_allow_to VARCHAR2,
89 p_un_earned_pay_thold_type VARCHAR2,
90 p_un_earned_pay_threshold NUMBER,
91 p_un_earned_pay_thold_flag VARCHAR2,
92 p_header_tolerance_calc_code VARCHAR2,
93 p_header_tolerance_operand NUMBER,
94 p_line_tolerance_calc_code VARCHAR2,
95 p_line_tolerance_operand NUMBER
96 )
97
98 IS
99 x_rowid VARCHAR2(30);
100
101
102 BEGIN
103 IF g_debug THEN
104 OZF_UTILITY_PVT.debug_message( 'Into begin 1');
105 END IF;
106
107 -- R12 Enhancements
108 IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
109 px_org_id := MO_GLOBAL.get_current_org_id();
110 END IF;
111
112 px_object_version_number := 1;
113 IF g_debug THEN
114 OZF_UTILITY_PVT.debug_message( 'before insert 2');
115 OZF_UTILITY_PVT.debug_message( 'Party id is'||p_party_id );
116 OZF_UTILITY_PVT.debug_message( 'vendor id is'||p_vendor_id );
117 OZF_UTILITY_PVT.debug_message( 'vendor site id is'||p_vendor_site_id );
118 END IF;
119
120 INSERT INTO ozf_cust_trd_prfls_all(
121 trade_profile_id,
122 object_version_number,
123 last_update_date,
124 last_updated_by,
125 creation_date,
126 created_by,
127 last_update_login,
128 request_id,
129 program_application_id,
130 program_update_date,
131 program_id,
132 created_from,
133 party_id,
134 site_use_id,
135 autopay_flag,
136 claim_threshold,
137 claim_currency,
138 print_flag,
139 internet_deal_view_flag,
140 internet_claims_flag,
141 autopay_periodicity,
142 autopay_periodicity_type,
143 payment_method,
144 discount_type,
145 cust_account_id,
146 cust_acct_site_id,
147 vendor_id,
148 vendor_site_id,
149 vendor_site_code,
150 context,
151 attribute_category,
152 attribute1,
153 attribute2,
154 attribute3,
155 attribute4,
156 attribute5,
157 attribute6,
158 attribute7,
159 attribute8,
160 attribute9,
161 attribute10,
162 attribute11,
163 attribute12,
164 attribute13,
165 attribute14,
166 attribute15,
167 org_id,
168 days_due,
169 pos_write_off_threshold,
170 neg_write_off_threshold,
171 un_earned_pay_allow_to,
172 un_earned_pay_thold_type,
173 un_earned_pay_thold_amount,
174 un_earned_pay_thold_flag,
175 header_tolerance_calc_code,
176 header_tolerance_operand,
177 line_tolerance_calc_code,
178 line_tolerance_operand
179 ) VALUES (
180 px_trade_profile_id,
181 px_object_version_number,
182 p_last_update_date,
183 p_last_updated_by,
184 p_creation_date,
185 p_created_by,
186 p_last_update_login,
187 p_request_id,
188 p_program_application_id,
189 p_program_update_date,
190 p_program_id,
191 p_created_from,
192 p_party_id,
193 p_site_use_id,
194 p_autopay_flag,
195 p_claim_threshold,
196 p_claim_currency,
197 p_print_flag,
198 p_internet_deal_view_flag,
199 p_internet_claims_flag,
200 p_autopay_periodicity,
201 p_autopay_periodicity_type,
202 p_payment_method,
203 p_discount_type,
204 p_cust_account_id,
205 p_cust_acct_site_id,
206 p_vendor_id,
207 p_vendor_site_id,
208 p_vendor_site_code,
209 p_context,
210 p_attribute_category,
211 p_attribute1,
212 p_attribute2,
213 p_attribute3,
214 p_attribute4,
215 p_attribute5,
216 p_attribute6,
217 p_attribute7,
218 p_attribute8,
219 p_attribute9,
220 p_attribute10,
221 p_attribute11,
222 p_attribute12,
223 p_attribute13,
224 p_attribute14,
225 p_attribute15,
226 px_org_id,
227 p_days_due,
228 p_pos_write_off_threshold,
229 p_neg_write_off_threshold,
230 p_un_earned_pay_allow_to,
231 p_un_earned_pay_thold_type,
232 p_un_earned_pay_threshold,
233 p_un_earned_pay_thold_flag,
234 p_header_tolerance_calc_code,
235 p_header_tolerance_operand,
236 p_line_tolerance_calc_code,
237 p_line_tolerance_operand
238 );
239 IF g_debug THEN
240 OZF_UTILITY_PVT.debug_message( 'after insert 2');
241 END IF;
242
243 END Insert_Row;
244
245
246 ----------------------------------------------------------
247 ---- MEDIA ----
248 ----------------------------------------------------------
249
250 -- ========================================================
251 --
252 -- NAME
253 -- createUpdateBody
254 --
255 -- PURPOSE
256 --
257 -- NOTES
258 --
259 -- HISTORY
260 --
261 -- ========================================================
262 PROCEDURE Update_Row(
263 p_trade_profile_id NUMBER,
264 p_object_version_number NUMBER,
265 p_last_update_date DATE,
266 p_last_updated_by NUMBER,
267 p_last_update_login NUMBER,
268 p_request_id NUMBER,
269 p_program_application_id NUMBER,
270 p_program_update_date DATE,
271 p_program_id NUMBER,
272 p_created_from VARCHAR2,
273 p_party_id NUMBER,
274 p_site_use_id NUMBER,
275 p_autopay_flag VARCHAR2,
276 p_claim_threshold NUMBER,
277 p_claim_currency VARCHAR2,
278 p_print_flag VARCHAR2,
279 p_internet_deal_view_flag VARCHAR2,
280 p_internet_claims_flag VARCHAR2,
281 p_autopay_periodicity NUMBER,
282 p_autopay_periodicity_type VARCHAR2,
283 p_payment_method VARCHAR2,
284 p_discount_type VARCHAR2,
285 p_cust_account_id NUMBER,
286 p_cust_acct_site_id NUMBER,
287 p_vendor_id NUMBER,
288 p_vendor_site_id NUMBER,
289 p_vendor_site_code VARCHAR2,
290 p_context VARCHAR2,
291 p_attribute_category VARCHAR2,
292 p_attribute1 VARCHAR2,
293 p_attribute2 VARCHAR2,
294 p_attribute3 VARCHAR2,
295 p_attribute4 VARCHAR2,
296 p_attribute5 VARCHAR2,
297 p_attribute6 VARCHAR2,
298 p_attribute7 VARCHAR2,
299 p_attribute8 VARCHAR2,
300 p_attribute9 VARCHAR2,
301 p_attribute10 VARCHAR2,
302 p_attribute11 VARCHAR2,
303 p_attribute12 VARCHAR2,
304 p_attribute13 VARCHAR2,
305 p_attribute14 VARCHAR2,
306 p_attribute15 VARCHAR2,
307 p_org_id NUMBER,
308 p_days_due NUMBER,
309 p_pos_write_off_threshold NUMBER,
310 p_neg_write_off_threshold NUMBER,
311 p_un_earned_pay_allow_to VARCHAR2,
312 p_un_earned_pay_thold_type VARCHAR2,
313 p_un_earned_pay_threshold NUMBER,
314 p_un_earned_pay_thold_flag VARCHAR2,
315 p_header_tolerance_calc_code VARCHAR2,
316 p_header_tolerance_operand NUMBER,
317 p_line_tolerance_calc_code VARCHAR2,
318 p_line_tolerance_operand NUMBER
319 )
320 IS
321 BEGIN
322
323 IF g_debug THEN
324 OZF_UTILITY_PVT.debug_message( 'Inside update table ');
325 OZF_UTILITY_PVT.debug_message( 'Inside update table 2' || p_trade_profile_id);
326 OZF_UTILITY_PVT.debug_message( 'Inside update table3'|| p_object_version_number);
327 END IF;
328
329 Update ozf_cust_trd_prfls_all
330 SET
331 trade_profile_id = p_trade_profile_id,
332 object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number + 1),
333 last_update_date = p_last_update_date,
334 last_updated_by = p_last_updated_by,
335 last_update_login = p_last_update_login,
336 request_id = p_request_id,
337 program_application_id = p_program_application_id,
338 program_update_date = p_program_update_date,
339 program_id = p_program_id,
340 created_from = p_created_from,
341 party_id = p_party_id,
342 site_use_id = p_site_use_id,
343 autopay_flag = p_autopay_flag,
344 claim_threshold = p_claim_threshold,
345 claim_currency = p_claim_currency,
346 print_flag = p_print_flag,
347 internet_deal_view_flag = p_internet_deal_view_flag,
348 internet_claims_flag = p_internet_claims_flag,
349 autopay_periodicity = p_autopay_periodicity,
350 autopay_periodicity_type = p_autopay_periodicity_type,
351 payment_method = p_payment_method,
352 discount_type = p_discount_type,
353 cust_account_id = p_cust_account_id,
354 cust_acct_site_id = p_cust_acct_site_id,
355 vendor_id = p_vendor_id,
356 vendor_site_id = p_vendor_site_id,
357 vendor_site_code = p_vendor_site_code,
358 context = p_context,
359 attribute_category = p_attribute_category,
360 attribute1 = p_attribute1,
361 attribute2 = p_attribute2,
362 attribute3 = p_attribute3,
363 attribute4 = p_attribute4,
364 attribute5 = p_attribute5,
365 attribute6 = p_attribute6,
366 attribute7 = p_attribute7,
367 attribute8 = p_attribute8,
368 attribute9 = p_attribute9,
369 attribute10 = p_attribute10,
370 attribute11 = p_attribute11,
371 attribute12 = p_attribute12,
372 attribute13 = p_attribute13,
373 attribute14 = p_attribute14,
374 attribute15 = p_attribute15,
375 org_id = p_org_id,
376 days_due = p_days_due,
377 pos_write_off_threshold = p_pos_write_off_threshold,
378 neg_write_off_threshold = p_neg_write_off_threshold,
379 un_earned_pay_allow_to = p_un_earned_pay_allow_to,
380 un_earned_pay_thold_type = p_un_earned_pay_thold_type,
381 un_earned_pay_thold_amount = p_un_earned_pay_threshold,
382 un_earned_pay_thold_flag = p_un_earned_pay_thold_flag,
383 header_tolerance_calc_code = p_header_tolerance_calc_code,
384 header_tolerance_operand = p_header_tolerance_operand,
385 line_tolerance_calc_code = p_line_tolerance_calc_code,
386 line_tolerance_operand = p_line_tolerance_operand
387 WHERE TRADE_PROFILE_ID = p_trade_profile_id;
388 IF (SQL%NOTFOUND) THEN
389 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390 END IF;
391 END Update_Row;
392
393
394 ----------------------------------------------------------
395 ---- MEDIA ----
396 ----------------------------------------------------------
397
398 -- ========================================================
399 --
400 -- NAME
401 -- createDeleteBody
402 --
403 -- PURPOSE
404 --
405 -- NOTES
406 --
407 -- HISTORY
408 --
409 -- ========================================================
410 PROCEDURE Delete_Row(
411 p_TRADE_PROFILE_ID NUMBER)
412 IS
413 BEGIN
414 DELETE FROM ozf_cust_trd_prfls_all
415 WHERE TRADE_PROFILE_ID = p_TRADE_PROFILE_ID;
416 If (SQL%NOTFOUND) then
417 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418 End If;
419 END Delete_Row ;
420
421
422
423 ----------------------------------------------------------
424 ---- MEDIA ----
425 ----------------------------------------------------------
426
427 -- ========================================================
428 --
429 -- NAME
430 -- createLockBody
431 --
432 -- PURPOSE
433 --
434 -- NOTES
435 --
436 -- HISTORY
437 --
441 p_object_version_number NUMBER,
438 -- ========================================================
439 PROCEDURE Lock_Row(
440 p_trade_profile_id NUMBER,
442 p_last_update_date DATE,
443 p_last_updated_by NUMBER,
444 p_creation_date DATE,
445 p_created_by NUMBER,
446 p_last_update_login NUMBER,
447 p_request_id NUMBER,
448 p_program_application_id NUMBER,
449 p_program_update_date DATE,
450 p_program_id NUMBER,
451 p_created_from VARCHAR2,
452 p_party_id NUMBER,
453 p_site_use_id NUMBER,
454 p_autopay_flag VARCHAR2,
455 p_claim_threshold NUMBER,
456 p_claim_currency VARCHAR2,
457 p_print_flag VARCHAR2,
458 p_internet_deal_view_flag VARCHAR2,
459 p_internet_claims_flag VARCHAR2,
460 p_autopay_periodicity NUMBER,
461 p_autopay_periodicity_type VARCHAR2,
462 p_payment_method VARCHAR2,
463 p_discount_type VARCHAR2,
464 p_cust_account_id NUMBER,
465 p_cust_acct_site_id NUMBER,
466 p_vendor_id NUMBER,
467 p_vendor_site_id NUMBER,
468 p_vendor_site_code VARCHAR2,
469 p_context VARCHAR2,
470 p_attribute_category VARCHAR2,
471 p_attribute1 VARCHAR2,
472 p_attribute2 VARCHAR2,
473 p_attribute3 VARCHAR2,
474 p_attribute4 VARCHAR2,
475 p_attribute5 VARCHAR2,
476 p_attribute6 VARCHAR2,
477 p_attribute7 VARCHAR2,
478 p_attribute8 VARCHAR2,
479 p_attribute9 VARCHAR2,
480 p_attribute10 VARCHAR2,
481 p_attribute11 VARCHAR2,
482 p_attribute12 VARCHAR2,
483 p_attribute13 VARCHAR2,
484 p_attribute14 VARCHAR2,
485 p_attribute15 VARCHAR2,
486 p_org_id NUMBER,
487 p_days_due NUMBER)
488
489 IS
490 CURSOR C IS
491 SELECT *
492 FROM ozf_cust_trd_prfls_all
493 WHERE TRADE_PROFILE_ID = p_TRADE_PROFILE_ID
494 FOR UPDATE of TRADE_PROFILE_ID NOWAIT;
495 Recinfo C%ROWTYPE;
496 BEGIN
497 OPEN c;
498 FETCH c INTO Recinfo;
499 If (c%NOTFOUND) then
500 CLOSE c;
501 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
502 APP_EXCEPTION.RAISE_EXCEPTION;
503 END IF;
504 CLOSE C;
505 IF(
506 ( Recinfo.trade_profile_id = p_trade_profile_id)
507 AND ( ( Recinfo.object_version_number = p_object_version_number)
508 OR ( ( Recinfo.object_version_number IS NULL )
509 AND ( p_object_version_number IS NULL )))
510 AND ( ( Recinfo.last_update_date = p_last_update_date)
511 OR ( ( Recinfo.last_update_date IS NULL )
512 AND ( p_last_update_date IS NULL )))
513 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
514 OR ( ( Recinfo.last_updated_by IS NULL )
515 AND ( p_last_updated_by IS NULL )))
516 AND ( ( Recinfo.creation_date = p_creation_date)
517 OR ( ( Recinfo.creation_date IS NULL )
518 AND ( p_creation_date IS NULL )))
519 AND ( ( Recinfo.created_by = p_created_by)
520 OR ( ( Recinfo.created_by IS NULL )
521 AND ( p_created_by IS NULL )))
522 AND ( ( Recinfo.last_update_login = p_last_update_login)
523 OR ( ( Recinfo.last_update_login IS NULL )
524 AND ( p_last_update_login IS NULL )))
525 AND ( ( Recinfo.request_id = p_request_id)
526 OR ( ( Recinfo.request_id IS NULL )
527 AND ( p_request_id IS NULL )))
528 AND ( ( Recinfo.program_application_id = p_program_application_id)
529 OR ( ( Recinfo.program_application_id IS NULL )
530 AND ( p_program_application_id IS NULL )))
531 AND ( ( Recinfo.program_update_date = p_program_update_date)
532 OR ( ( Recinfo.program_update_date IS NULL )
533 AND ( p_program_update_date IS NULL )))
534 AND ( ( Recinfo.program_id = p_program_id)
535 OR ( ( Recinfo.program_id IS NULL )
536 AND ( p_program_id IS NULL )))
537 AND ( ( Recinfo.created_from = p_created_from)
538 OR ( ( Recinfo.created_from IS NULL )
539 AND ( p_created_from IS NULL )))
540 AND ( ( Recinfo.party_id = p_party_id)
541 OR ( ( Recinfo.party_id IS NULL )
542 AND ( p_party_id IS NULL )))
543 AND ( ( Recinfo.site_use_id = p_site_use_id)
544 OR ( ( Recinfo.site_use_id IS NULL )
545 AND ( p_site_use_id IS NULL )))
546 AND ( ( Recinfo.autopay_flag = p_autopay_flag)
547 OR ( ( Recinfo.autopay_flag IS NULL )
548 AND ( p_autopay_flag IS NULL )))
549 AND ( ( Recinfo.claim_threshold = p_claim_threshold)
550 OR ( ( Recinfo.claim_threshold IS NULL )
551 AND ( p_claim_threshold IS NULL )))
555 AND ( ( Recinfo.print_flag = p_print_flag)
552 AND ( ( Recinfo.claim_currency = p_claim_currency)
553 OR ( ( Recinfo.claim_currency IS NULL )
554 AND ( p_claim_currency IS NULL )))
556 OR ( ( Recinfo.print_flag IS NULL )
557 AND ( p_print_flag IS NULL )))
558 AND ( ( Recinfo.internet_deal_view_flag = p_internet_deal_view_flag)
559 OR ( ( Recinfo.internet_deal_view_flag IS NULL )
560 AND ( p_internet_deal_view_flag IS NULL )))
561 AND ( ( Recinfo.internet_claims_flag = p_internet_claims_flag)
562 OR ( ( Recinfo.internet_claims_flag IS NULL )
563 AND ( p_internet_claims_flag IS NULL )))
564 AND ( ( Recinfo.autopay_periodicity = p_autopay_periodicity)
565 OR ( ( Recinfo.autopay_periodicity IS NULL )
566 AND ( p_autopay_periodicity IS NULL )))
567 AND ( ( Recinfo.autopay_periodicity_type = p_autopay_periodicity_type)
568 OR ( ( Recinfo.autopay_periodicity_type IS NULL )
569 AND ( p_autopay_periodicity_type IS NULL )))
570 AND ( ( Recinfo.payment_method = p_payment_method)
571 OR ( ( Recinfo.payment_method IS NULL )
572 AND ( p_payment_method IS NULL )))
573 AND ( ( Recinfo.discount_type = p_discount_type)
574 OR ( ( Recinfo.discount_type IS NULL )
575 AND ( p_discount_type IS NULL )))
576 AND ( ( Recinfo.cust_account_id = p_cust_account_id)
577 OR ( ( Recinfo.cust_account_id IS NULL )
578 AND ( p_cust_account_id IS NULL )))
579 AND ( ( Recinfo.cust_acct_site_id = p_cust_acct_site_id)
580 OR ( ( Recinfo.cust_acct_site_id IS NULL )
581 AND ( p_cust_acct_site_id IS NULL )))
582 AND ( ( Recinfo.vendor_id = p_vendor_id)
583 OR ( ( Recinfo.vendor_id IS NULL )
584 AND ( p_vendor_id IS NULL )))
585 AND ( ( Recinfo.vendor_site_id = p_vendor_site_id)
586 OR ( ( Recinfo.vendor_site_id IS NULL )
587 AND ( p_vendor_site_id IS NULL )))
588 AND ( ( Recinfo.vendor_site_code = p_vendor_site_code)
589 OR ( ( Recinfo.vendor_site_code IS NULL )
590 AND ( p_vendor_site_code IS NULL )))
591 AND ( ( Recinfo.context = p_context)
592 OR ( ( Recinfo.context IS NULL )
593 AND ( p_context IS NULL )))
594 AND ( ( Recinfo.attribute_category = p_attribute_category)
595 OR ( ( Recinfo.attribute_category IS NULL )
596 AND ( p_attribute_category IS NULL )))
597 AND ( ( Recinfo.attribute1 = p_attribute1)
598 OR ( ( Recinfo.attribute1 IS NULL )
599 AND ( p_attribute1 IS NULL )))
600 AND ( ( Recinfo.attribute2 = p_attribute2)
601 OR ( ( Recinfo.attribute2 IS NULL )
602 AND ( p_attribute2 IS NULL )))
603 AND ( ( Recinfo.attribute3 = p_attribute3)
604 OR ( ( Recinfo.attribute3 IS NULL )
605 AND ( p_attribute3 IS NULL )))
606 AND ( ( Recinfo.attribute4 = p_attribute4)
607 OR ( ( Recinfo.attribute4 IS NULL )
608 AND ( p_attribute4 IS NULL )))
609 AND ( ( Recinfo.attribute5 = p_attribute5)
610 OR ( ( Recinfo.attribute5 IS NULL )
611 AND ( p_attribute5 IS NULL )))
612 AND ( ( Recinfo.attribute6 = p_attribute6)
613 OR ( ( Recinfo.attribute6 IS NULL )
614 AND ( p_attribute6 IS NULL )))
615 AND ( ( Recinfo.attribute7 = p_attribute7)
616 OR ( ( Recinfo.attribute7 IS NULL )
617 AND ( p_attribute7 IS NULL )))
618 AND ( ( Recinfo.attribute8 = p_attribute8)
619 OR ( ( Recinfo.attribute8 IS NULL )
620 AND ( p_attribute8 IS NULL )))
621 AND ( ( Recinfo.attribute9 = p_attribute9)
622 OR ( ( Recinfo.attribute9 IS NULL )
623 AND ( p_attribute9 IS NULL )))
624 AND ( ( Recinfo.attribute10 = p_attribute10)
625 OR ( ( Recinfo.attribute10 IS NULL )
626 AND ( p_attribute10 IS NULL )))
627 AND ( ( Recinfo.attribute11 = p_attribute11)
628 OR ( ( Recinfo.attribute11 IS NULL )
629 AND ( p_attribute11 IS NULL )))
630 AND ( ( Recinfo.attribute12 = p_attribute12)
631 OR ( ( Recinfo.attribute12 IS NULL )
632 AND ( p_attribute12 IS NULL )))
633 AND ( ( Recinfo.attribute13 = p_attribute13)
634 OR ( ( Recinfo.attribute13 IS NULL )
635 AND ( p_attribute13 IS NULL )))
636 AND ( ( Recinfo.attribute14 = p_attribute14)
637 OR ( ( Recinfo.attribute14 IS NULL )
638 AND ( p_attribute14 IS NULL )))
639 AND ( ( Recinfo.attribute15 = p_attribute15)
640 OR ( ( Recinfo.attribute15 IS NULL )
641 AND ( p_attribute15 IS NULL )))
642 AND ( ( Recinfo.org_id = p_org_id)
643 OR ( ( Recinfo.org_id IS NULL )
644 AND ( p_org_id IS NULL )))
645 AND ( ( Recinfo.days_due = p_days_due)
646 OR ( ( Recinfo.days_due IS NULL )
647 AND ( p_days_due IS NULL )))
648 ) THEN
649 RETURN;
650 ELSE
651 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
652 APP_EXCEPTION.RAISE_EXCEPTION;
653 END IF;
654 END Lock_Row;
655
656 END OZF_cust_trd_prfls_PKG;