[Home] [Help]
PACKAGE BODY: APPS.OZF_RESALE_HEADERS_PKG
Source
1 PACKAGE BODY OZF_RESALE_HEADERS_PKG as
2 /* $Header: ozftrshb.pls 115.1 2003/12/02 11:02:11 jxwu noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_RESALE_HEADERS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_RESALE_HEADERS_PKG';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftrshb.pls';
19
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_resale_header_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_request_id NUMBER,
44 p_created_by NUMBER,
45 p_last_update_login 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_date_shipped DATE,
51 p_date_ordered DATE,
52 p_order_type_id NUMBER,
53 p_order_type VARCHAR2,
54 p_order_category VARCHAR2,
55 p_status_code VARCHAR2,
56 p_direct_customer_flag VARCHAR2,
57 p_order_number VARCHAR2,
58 p_price_list_id NUMBER,
59 p_bill_to_cust_account_id NUMBER,
60 p_bill_to_site_use_id NUMBER,
61 p_bill_to_PARTY_NAME VARCHAR2,
62 p_bill_to_PARTY_ID NUMBER,
63 p_bill_to_PARTY_site_id NUMBER,
64 p_bill_to_location VARCHAR2,
65 p_bill_to_duns_number VARCHAR2,
66 p_bill_to_address VARCHAR2,
67 p_bill_to_city VARCHAR2,
68 p_bill_to_state VARCHAR2,
69 p_bill_to_postal_code VARCHAR2,
70 p_bill_to_country VARCHAR2,
71 p_bill_to_contact_party_id NUMBER,
72 p_bill_to_contact_name VARCHAR2,
73 p_bill_to_email VARCHAR2,
74 p_bill_to_phone VARCHAR2,
75 p_bill_to_fax VARCHAR2,
76 p_ship_to_cust_account_id NUMBER,
77 p_ship_to_site_use_id NUMBER,
78 p_ship_to_PARTY_NAME VARCHAR2,
79 p_ship_to_PARTY_ID NUMBER,
80 p_ship_to_PARTY_site_id NUMBER,
81 p_ship_to_location VARCHAR2,
82 p_ship_to_duns_number VARCHAR2,
83 p_ship_to_address VARCHAR2,
84 p_ship_to_city VARCHAR2,
85 p_ship_to_state VARCHAR2,
86 p_ship_to_postal_code VARCHAR2,
87 p_ship_to_country VARCHAR2,
88 p_ship_to_contact_party_id NUMBER,
89 p_ship_to_contact_name VARCHAR2,
90 p_ship_to_email VARCHAR2,
91 p_ship_to_phone VARCHAR2,
92 p_ship_to_fax VARCHAR2,
93 p_sold_from_cust_account_id NUMBER,
94 p_ship_from_cust_account_id NUMBER,
95 p_header_attribute_category VARCHAR2,
96 p_header_attribute1 VARCHAR2,
97 p_header_attribute2 VARCHAR2,
98 p_header_attribute3 VARCHAR2,
99 p_header_attribute4 VARCHAR2,
100 p_header_attribute5 VARCHAR2,
101 p_header_attribute6 VARCHAR2,
102 p_header_attribute7 VARCHAR2,
103 p_header_attribute8 VARCHAR2,
104 p_header_attribute9 VARCHAR2,
105 p_header_attribute10 VARCHAR2,
106 p_header_attribute11 VARCHAR2,
107 p_header_attribute12 VARCHAR2,
108 p_header_attribute13 VARCHAR2,
109 p_header_attribute14 VARCHAR2,
110 p_header_attribute15 VARCHAR2,
111 p_attribute_category VARCHAR2,
112 p_attribute1 VARCHAR2,
113 p_attribute2 VARCHAR2,
114 p_attribute3 VARCHAR2,
115 p_attribute4 VARCHAR2,
116 p_attribute5 VARCHAR2,
117 p_attribute6 VARCHAR2,
118 p_attribute7 VARCHAR2,
119 p_attribute8 VARCHAR2,
120 p_attribute9 VARCHAR2,
121 p_attribute10 VARCHAR2,
122 p_attribute11 VARCHAR2,
123 p_attribute12 VARCHAR2,
124 p_attribute13 VARCHAR2,
125 p_attribute14 VARCHAR2,
126 p_attribute15 VARCHAR2,
127 px_org_id IN OUT NOCOPY NUMBER)
128
129 IS
130 x_rowid VARCHAR2(30);
131
132
133 BEGIN
134
135 IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
136 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
137 INTO px_org_id
138 FROM DUAL;
139 END IF;
140
141
142 px_object_version_number := 1;
143
144
145 INSERT INTO OZF_RESALE_HEADERS_ALL(
146 resale_header_id,
147 object_version_number,
148 last_update_date,
149 last_updated_by,
150 creation_date,
151 request_id,
152 created_by,
153 last_update_login,
154 program_application_id,
155 program_update_date,
156 program_id,
157 created_from,
158 date_shipped,
159 date_ordered,
160 order_type_id,
161 order_type,
162 order_category,
163 status_code,
164 direct_customer_flag,
165 order_number,
166 price_list_id,
167 bill_to_cust_account_id,
168 bill_to_site_use_id,
169 bill_to_PARTY_NAME,
170 bill_to_PARTY_ID,
171 bill_to_PARTY_site_id,
172 bill_to_location,
173 bill_to_duns_number,
174 bill_to_address,
175 bill_to_city,
176 bill_to_state,
177 bill_to_postal_code,
178 bill_to_country,
179 bill_to_contact_party_id,
180 bill_to_contact_name,
181 bill_to_email,
182 bill_to_phone,
183 bill_to_fax,
184 ship_to_cust_account_id,
185 ship_to_site_use_id,
186 ship_to_PARTY_NAME,
187 ship_to_PARTY_ID,
188 ship_to_PARTY_site_id,
189 ship_to_location,
190 ship_to_duns_number,
191 ship_to_address,
192 ship_to_city,
193 ship_to_state,
194 ship_to_postal_code,
195 ship_to_country,
196 ship_to_contact_party_id,
197 ship_to_contact_name,
198 ship_to_email,
199 ship_to_phone,
200 ship_to_fax,
201 sold_from_cust_account_id,
202 ship_from_cust_account_id,
203 header_attribute_category,
204 header_attribute1,
205 header_attribute2,
206 header_attribute3,
207 header_attribute4,
208 header_attribute5,
209 header_attribute6,
210 header_attribute7,
211 header_attribute8,
212 header_attribute9,
213 header_attribute10,
214 header_attribute11,
215 header_attribute12,
216 header_attribute13,
217 header_attribute14,
218 header_attribute15,
219 attribute_category,
220 attribute1,
221 attribute2,
222 attribute3,
223 attribute4,
224 attribute5,
225 attribute6,
226 attribute7,
227 attribute8,
228 attribute9,
229 attribute10,
230 attribute11,
231 attribute12,
232 attribute13,
233 attribute14,
234 attribute15,
235 org_id
236 ) VALUES (
237 px_resale_header_id,
238 px_object_version_number,
239 p_last_update_date,
240 p_last_updated_by,
241 p_creation_date,
242 p_request_id,
243 p_created_by,
244 p_last_update_login,
245 p_program_application_id,
246 p_program_update_date,
247 p_program_id,
248 p_created_from,
249 p_date_shipped,
250 p_date_ordered,
251 p_order_type_id,
252 p_order_type,
253 p_order_category,
254 p_status_code,
255 p_direct_customer_flag,
256 p_order_number,
257 p_price_list_id,
258 p_bill_to_cust_account_id,
259 p_bill_to_site_use_id,
260 p_bill_to_PARTY_NAME,
261 p_bill_to_PARTY_ID,
262 p_bill_to_PARTY_site_id,
263 p_bill_to_location,
264 p_bill_to_duns_number,
265 p_bill_to_address,
266 p_bill_to_city,
267 p_bill_to_state,
268 p_bill_to_postal_code,
269 p_bill_to_country,
270 p_bill_to_contact_party_id,
271 p_bill_to_contact_name,
272 p_bill_to_email,
273 p_bill_to_phone,
274 p_bill_to_fax,
275 p_ship_to_cust_account_id,
276 p_ship_to_site_use_id,
277 p_ship_to_PARTY_NAME,
278 p_ship_to_PARTY_ID,
279 p_ship_to_PARTY_site_id,
280 p_ship_to_location,
281 p_ship_to_duns_number,
282 p_ship_to_address,
283 p_ship_to_city,
284 p_ship_to_state,
285 p_ship_to_postal_code,
286 p_ship_to_country,
287 p_ship_to_contact_party_id,
288 p_ship_to_contact_name,
289 p_ship_to_email,
290 p_ship_to_phone,
291 p_ship_to_fax,
292 p_sold_from_cust_account_id,
293 p_ship_from_cust_account_id,
294 p_header_attribute_category,
295 p_header_attribute1,
296 p_header_attribute2,
297 p_header_attribute3,
298 p_header_attribute4,
299 p_header_attribute5,
300 p_header_attribute6,
301 p_header_attribute7,
302 p_header_attribute8,
303 p_header_attribute9,
304 p_header_attribute10,
305 p_header_attribute11,
306 p_header_attribute12,
307 p_header_attribute13,
308 p_header_attribute14,
309 p_header_attribute15,
310 p_attribute_category,
311 p_attribute1,
312 p_attribute2,
313 p_attribute3,
314 p_attribute4,
315 p_attribute5,
316 p_attribute6,
317 p_attribute7,
318 p_attribute8,
319 p_attribute9,
320 p_attribute10,
321 p_attribute11,
322 p_attribute12,
323 p_attribute13,
324 p_attribute14,
325 p_attribute15,
326 px_org_id);
327 END Insert_Row;
328
329
330 ----------------------------------------------------------
331 ---- MEDIA ----
332 ----------------------------------------------------------
333
334 -- ========================================================
335 --
336 -- NAME
337 -- createUpdateBody
338 --
339 -- PURPOSE
340 --
341 -- NOTES
342 --
343 -- HISTORY
344 --
345 -- ========================================================
349 p_last_update_date DATE,
346 PROCEDURE Update_Row(
347 p_resale_header_id NUMBER,
348 p_object_version_number NUMBER,
350 p_last_updated_by NUMBER,
351 p_request_id NUMBER,
352 p_last_update_login NUMBER,
353 p_program_application_id NUMBER,
354 p_program_update_date DATE,
355 p_program_id NUMBER,
356 p_created_from VARCHAR2,
357 p_date_shipped DATE,
358 p_date_ordered DATE,
359 p_order_type_id NUMBER,
360 p_order_type VARCHAR2,
361 p_order_category VARCHAR2,
362 p_status_code VARCHAR2,
363 p_direct_customer_flag VARCHAR2,
364 p_order_number VARCHAR2,
365 p_price_list_id NUMBER,
366 p_bill_to_cust_account_id NUMBER,
367 p_bill_to_site_use_id NUMBER,
368 p_bill_to_PARTY_NAME VARCHAR2,
369 p_bill_to_PARTY_ID NUMBER,
370 p_bill_to_PARTY_site_id NUMBER,
371 p_bill_to_location VARCHAR2,
372 p_bill_to_duns_number VARCHAR2,
373 p_bill_to_address VARCHAR2,
374 p_bill_to_city VARCHAR2,
375 p_bill_to_state VARCHAR2,
376 p_bill_to_postal_code VARCHAR2,
377 p_bill_to_country VARCHAR2,
378 p_bill_to_contact_party_id NUMBER,
379 p_bill_to_contact_name VARCHAR2,
380 p_bill_to_email VARCHAR2,
381 p_bill_to_phone VARCHAR2,
382 p_bill_to_fax VARCHAR2,
383 p_ship_to_cust_account_id NUMBER,
384 p_ship_to_site_use_id NUMBER,
385 p_ship_to_PARTY_NAME VARCHAR2,
386 p_ship_to_PARTY_ID NUMBER,
387 p_ship_to_PARTY_site_id NUMBER,
388 p_ship_to_location VARCHAR2,
389 p_ship_to_duns_number VARCHAR2,
390 p_ship_to_address VARCHAR2,
391 p_ship_to_city VARCHAR2,
392 p_ship_to_state VARCHAR2,
393 p_ship_to_postal_code VARCHAR2,
394 p_ship_to_country VARCHAR2,
395 p_ship_to_contact_party_id NUMBER,
396 p_ship_to_contact_name VARCHAR2,
397 p_ship_to_email VARCHAR2,
398 p_ship_to_phone VARCHAR2,
399 p_ship_to_fax VARCHAR2,
400 p_sold_from_cust_account_id NUMBER,
401 p_ship_from_cust_account_id NUMBER,
402 p_header_attribute_category VARCHAR2,
403 p_header_attribute1 VARCHAR2,
404 p_header_attribute2 VARCHAR2,
405 p_header_attribute3 VARCHAR2,
406 p_header_attribute4 VARCHAR2,
407 p_header_attribute5 VARCHAR2,
408 p_header_attribute6 VARCHAR2,
409 p_header_attribute7 VARCHAR2,
413 p_header_attribute11 VARCHAR2,
410 p_header_attribute8 VARCHAR2,
411 p_header_attribute9 VARCHAR2,
412 p_header_attribute10 VARCHAR2,
414 p_header_attribute12 VARCHAR2,
415 p_header_attribute13 VARCHAR2,
416 p_header_attribute14 VARCHAR2,
417 p_header_attribute15 VARCHAR2,
418 p_attribute_category VARCHAR2,
419 p_attribute1 VARCHAR2,
420 p_attribute2 VARCHAR2,
421 p_attribute3 VARCHAR2,
422 p_attribute4 VARCHAR2,
423 p_attribute5 VARCHAR2,
424 p_attribute6 VARCHAR2,
425 p_attribute7 VARCHAR2,
426 p_attribute8 VARCHAR2,
427 p_attribute9 VARCHAR2,
428 p_attribute10 VARCHAR2,
429 p_attribute11 VARCHAR2,
430 p_attribute12 VARCHAR2,
431 p_attribute13 VARCHAR2,
432 p_attribute14 VARCHAR2,
433 p_attribute15 VARCHAR2,
434 p_org_id NUMBER)
435
436 IS
437 BEGIN
438 Update OZF_RESALE_HEADERS_ALL
439 SET
440 resale_header_id = p_resale_header_id,
441 object_version_number = p_object_version_number,
442 last_update_date = p_last_update_date,
443 last_updated_by = p_last_updated_by,
444 request_id = p_request_id,
445 last_update_login = p_last_update_login,
446 program_application_id = p_program_application_id,
447 program_update_date = p_program_update_date,
448 program_id = p_program_id,
449 created_from = p_created_from,
450 date_shipped = p_date_shipped,
451 date_ordered = p_date_ordered,
452 order_type_id = p_order_type_id,
453 order_type = p_order_type,
454 order_category = p_order_category,
455 status_code = p_status_code,
456 direct_customer_flag = p_direct_customer_flag,
457 order_number = p_order_number,
458 price_list_id = p_price_list_id,
459 bill_to_cust_account_id = p_bill_to_cust_account_id,
460 bill_to_site_use_id = p_bill_to_site_use_id,
461 bill_to_PARTY_NAME = p_bill_to_PARTY_NAME,
462 bill_to_PARTY_ID = p_bill_to_PARTY_ID,
463 bill_to_PARTY_site_id = p_bill_to_PARTY_site_id,
464 bill_to_location = p_bill_to_location,
465 bill_to_duns_number = p_bill_to_duns_number,
466 bill_to_address = p_bill_to_address,
467 bill_to_city = p_bill_to_city,
468 bill_to_state = p_bill_to_state,
469 bill_to_postal_code = p_bill_to_postal_code,
470 bill_to_country = p_bill_to_country,
471 bill_to_contact_party_id = p_bill_to_contact_party_id,
472 bill_to_contact_name = p_bill_to_contact_name,
473 bill_to_email = p_bill_to_email,
474 bill_to_phone = p_bill_to_phone,
475 bill_to_fax = p_bill_to_fax,
476 ship_to_cust_account_id = p_ship_to_cust_account_id,
477 ship_to_site_use_id = p_ship_to_site_use_id,
478 ship_to_PARTY_NAME = p_ship_to_PARTY_NAME,
479 ship_to_PARTY_ID = p_ship_to_PARTY_ID,
480 ship_to_PARTY_site_id = p_ship_to_PARTY_site_id,
481 ship_to_location = p_ship_to_location,
482 ship_to_duns_number = p_ship_to_duns_number,
483 ship_to_address = p_ship_to_address,
484 ship_to_city = p_ship_to_city,
485 ship_to_state = p_ship_to_state,
486 ship_to_postal_code = p_ship_to_postal_code,
487 ship_to_country = p_ship_to_country,
488 ship_to_contact_party_id = p_ship_to_contact_party_id,
489 ship_to_contact_name = p_ship_to_contact_name,
490 ship_to_email = p_ship_to_email,
491 ship_to_phone = p_ship_to_phone,
492 ship_to_fax = p_ship_to_fax,
493 sold_from_cust_account_id = p_sold_from_cust_account_id,
494 ship_from_cust_account_id = p_ship_from_cust_account_id,
495 header_attribute_category = p_header_attribute_category,
496 header_attribute1 = p_header_attribute1,
497 header_attribute2 = p_header_attribute2,
498 header_attribute3 = p_header_attribute3,
499 header_attribute4 = p_header_attribute4,
500 header_attribute5 = p_header_attribute5,
501 header_attribute6 = p_header_attribute6,
502 header_attribute7 = p_header_attribute7,
503 header_attribute8 = p_header_attribute8,
507 header_attribute12 = p_header_attribute12,
504 header_attribute9 = p_header_attribute9,
505 header_attribute10 = p_header_attribute10,
506 header_attribute11 = p_header_attribute11,
508 header_attribute13 = p_header_attribute13,
509 header_attribute14 = p_header_attribute14,
510 header_attribute15 = p_header_attribute15,
511 attribute_category = p_attribute_category,
512 attribute1 = p_attribute1,
513 attribute2 = p_attribute2,
514 attribute3 = p_attribute3,
515 attribute4 = p_attribute4,
516 attribute5 = p_attribute5,
517 attribute6 = p_attribute6,
518 attribute7 = p_attribute7,
519 attribute8 = p_attribute8,
520 attribute9 = p_attribute9,
521 attribute10 = p_attribute10,
522 attribute11 = p_attribute11,
523 attribute12 = p_attribute12,
524 attribute13 = p_attribute13,
525 attribute14 = p_attribute14,
526 attribute15 = p_attribute15,
527 org_id = p_org_id
528 WHERE RESALE_HEADER_ID = p_RESALE_HEADER_ID
529 AND object_version_number = p_object_version_number;
530
531 IF (SQL%NOTFOUND) THEN
532 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533 END IF;
534 END Update_Row;
535
536
537 ----------------------------------------------------------
538 ---- MEDIA ----
539 ----------------------------------------------------------
540
541 -- ========================================================
542 --
543 -- NAME
544 -- createDeleteBody
545 --
546 -- PURPOSE
547 --
548 -- NOTES
549 --
550 -- HISTORY
551 --
552 -- ========================================================
553 PROCEDURE Delete_Row(
554 p_RESALE_HEADER_ID NUMBER)
555 IS
556 BEGIN
557 DELETE FROM OZF_RESALE_HEADERS_ALL
558 WHERE RESALE_HEADER_ID = p_RESALE_HEADER_ID;
559 If (SQL%NOTFOUND) then
560 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561 End If;
562 END Delete_Row ;
563
564
565
566 ----------------------------------------------------------
567 ---- MEDIA ----
568 ----------------------------------------------------------
569
570 -- ========================================================
571 --
572 -- NAME
573 -- createLockBody
574 --
575 -- PURPOSE
576 --
577 -- NOTES
578 --
579 -- HISTORY
580 --
581 -- ========================================================
582 PROCEDURE Lock_Row(
583 p_resale_header_id NUMBER,
584 p_object_version_number NUMBER,
585 p_last_update_date DATE,
586 p_last_updated_by NUMBER,
587 p_creation_date DATE,
588 p_request_id NUMBER,
589 p_created_by NUMBER,
590 p_last_update_login NUMBER,
591 p_program_application_id NUMBER,
592 p_program_update_date DATE,
593 p_program_id NUMBER,
594 p_created_from VARCHAR2,
595 p_date_shipped DATE,
596 p_date_ordered DATE,
597 p_order_type_id NUMBER,
598 p_order_type VARCHAR2,
599 p_order_category VARCHAR2,
600 p_status_code VARCHAR2,
601 p_direct_customer_flag VARCHAR2,
602 p_order_number VARCHAR2,
603 p_price_list_id NUMBER,
604 p_bill_to_cust_account_id NUMBER,
605 p_bill_to_site_use_id NUMBER,
606 p_bill_to_PARTY_NAME VARCHAR2,
607 p_bill_to_PARTY_ID NUMBER,
608 p_bill_to_PARTY_site_id NUMBER,
609 p_bill_to_location VARCHAR2,
610 p_bill_to_duns_number VARCHAR2,
611 p_bill_to_address VARCHAR2,
612 p_bill_to_city VARCHAR2,
613 p_bill_to_state VARCHAR2,
614 p_bill_to_postal_code VARCHAR2,
615 p_bill_to_country VARCHAR2,
616 p_bill_to_contact_party_id NUMBER,
617 p_bill_to_contact_name VARCHAR2,
618 p_bill_to_email VARCHAR2,
619 p_bill_to_phone VARCHAR2,
620 p_bill_to_fax VARCHAR2,
621 p_ship_to_cust_account_id NUMBER,
622 p_ship_to_site_use_id NUMBER,
623 p_ship_to_PARTY_NAME VARCHAR2,
624 p_ship_to_PARTY_ID NUMBER,
625 p_ship_to_PARTY_site_id NUMBER,
626 p_ship_to_location VARCHAR2,
627 p_ship_to_duns_number VARCHAR2,
628 p_ship_to_address VARCHAR2,
629 p_ship_to_city VARCHAR2,
630 p_ship_to_state VARCHAR2,
631 p_ship_to_postal_code VARCHAR2,
632 p_ship_to_country VARCHAR2,
633 p_ship_to_contact_party_id NUMBER,
634 p_ship_to_contact_name VARCHAR2,
635 p_ship_to_email VARCHAR2,
636 p_ship_to_phone VARCHAR2,
637 p_ship_to_fax VARCHAR2,
638 p_sold_from_cust_account_id NUMBER,
639 p_ship_from_cust_account_id NUMBER,
640 p_header_attribute_category VARCHAR2,
641 p_header_attribute1 VARCHAR2,
642 p_header_attribute2 VARCHAR2,
643 p_header_attribute3 VARCHAR2,
644 p_header_attribute4 VARCHAR2,
645 p_header_attribute5 VARCHAR2,
646 p_header_attribute6 VARCHAR2,
647 p_header_attribute7 VARCHAR2,
648 p_header_attribute8 VARCHAR2,
649 p_header_attribute9 VARCHAR2,
653 p_header_attribute13 VARCHAR2,
650 p_header_attribute10 VARCHAR2,
651 p_header_attribute11 VARCHAR2,
652 p_header_attribute12 VARCHAR2,
654 p_header_attribute14 VARCHAR2,
655 p_header_attribute15 VARCHAR2,
656 p_attribute_category VARCHAR2,
657 p_attribute1 VARCHAR2,
658 p_attribute2 VARCHAR2,
659 p_attribute3 VARCHAR2,
660 p_attribute4 VARCHAR2,
661 p_attribute5 VARCHAR2,
662 p_attribute6 VARCHAR2,
663 p_attribute7 VARCHAR2,
664 p_attribute8 VARCHAR2,
665 p_attribute9 VARCHAR2,
666 p_attribute10 VARCHAR2,
667 p_attribute11 VARCHAR2,
668 p_attribute12 VARCHAR2,
669 p_attribute13 VARCHAR2,
670 p_attribute14 VARCHAR2,
671 p_attribute15 VARCHAR2,
672 p_org_id NUMBER)
673
674 IS
675 CURSOR C IS
676 SELECT *
677 FROM OZF_RESALE_HEADERS_ALL
678 WHERE RESALE_HEADER_ID = p_RESALE_HEADER_ID
679 FOR UPDATE of RESALE_HEADER_ID NOWAIT;
680 Recinfo C%ROWTYPE;
681 BEGIN
682 OPEN c;
683 FETCH c INTO Recinfo;
684 If (c%NOTFOUND) then
685 CLOSE c;
686 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
687 APP_EXCEPTION.RAISE_EXCEPTION;
688 END IF;
689 CLOSE C;
690 IF (
691 ( Recinfo.resale_header_id = p_resale_header_id)
692 AND ( ( Recinfo.object_version_number = p_object_version_number)
693 OR ( ( Recinfo.object_version_number IS NULL )
694 AND ( p_object_version_number IS NULL )))
695 AND ( ( Recinfo.last_update_date = p_last_update_date)
696 OR ( ( Recinfo.last_update_date IS NULL )
697 AND ( p_last_update_date IS NULL )))
698 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
699 OR ( ( Recinfo.last_updated_by IS NULL )
700 AND ( p_last_updated_by IS NULL )))
701 AND ( ( Recinfo.creation_date = p_creation_date)
702 OR ( ( Recinfo.creation_date IS NULL )
703 AND ( p_creation_date IS NULL )))
704 AND ( ( Recinfo.request_id = p_request_id)
705 OR ( ( Recinfo.request_id IS NULL )
706 AND ( p_request_id IS NULL )))
707 AND ( ( Recinfo.created_by = p_created_by)
708 OR ( ( Recinfo.created_by IS NULL )
709 AND ( p_created_by IS NULL )))
710 AND ( ( Recinfo.last_update_login = p_last_update_login)
711 OR ( ( Recinfo.last_update_login IS NULL )
712 AND ( p_last_update_login IS NULL )))
713 AND ( ( Recinfo.program_application_id = p_program_application_id)
714 OR ( ( Recinfo.program_application_id IS NULL )
715 AND ( p_program_application_id IS NULL )))
716 AND ( ( Recinfo.program_update_date = p_program_update_date)
717 OR ( ( Recinfo.program_update_date IS NULL )
718 AND ( p_program_update_date IS NULL )))
719 AND ( ( Recinfo.program_id = p_program_id)
720 OR ( ( Recinfo.program_id IS NULL )
721 AND ( p_program_id IS NULL )))
722 AND ( ( Recinfo.created_from = p_created_from)
723 OR ( ( Recinfo.created_from IS NULL )
724 AND ( p_created_from IS NULL )))
725 AND ( ( Recinfo.date_shipped = p_date_shipped)
726 OR ( ( Recinfo.date_shipped IS NULL )
727 AND ( p_date_shipped IS NULL )))
728 AND ( ( Recinfo.date_ordered = p_date_ordered)
729 OR ( ( Recinfo.date_ordered IS NULL )
730 AND ( p_date_ordered IS NULL )))
731 AND ( ( Recinfo.order_type_id = p_order_type_id)
732 OR ( ( Recinfo.order_type_id IS NULL )
733 AND ( p_order_type_id IS NULL )))
734 AND ( ( Recinfo.order_type = p_order_type)
735 OR ( ( Recinfo.order_type IS NULL )
736 AND ( p_order_type IS NULL )))
737 AND ( ( Recinfo.order_category = p_order_category)
738 OR ( ( Recinfo.order_category IS NULL )
739 AND ( p_order_category IS NULL )))
740 AND ( ( Recinfo.status_code = p_status_code)
741 OR ( ( Recinfo.status_code IS NULL )
742 AND ( p_status_code IS NULL )))
743 AND ( ( Recinfo.direct_customer_flag = p_direct_customer_flag)
744 OR ( ( Recinfo.direct_customer_flag IS NULL )
745 AND ( p_direct_customer_flag IS NULL )))
746 AND ( ( Recinfo.order_number = p_order_number)
747 OR ( ( Recinfo.order_number IS NULL )
748 AND ( p_order_number IS NULL )))
749 AND ( ( Recinfo.price_list_id = p_price_list_id)
750 OR ( ( Recinfo.price_list_id IS NULL )
751 AND ( p_price_list_id IS NULL )))
752 AND ( ( Recinfo.bill_to_cust_account_id = p_bill_to_cust_account_id)
753 OR ( ( Recinfo.bill_to_cust_account_id IS NULL )
754 AND ( p_bill_to_cust_account_id IS NULL )))
755 AND ( ( Recinfo.bill_to_site_use_id = p_bill_to_site_use_id)
756 OR ( ( Recinfo.bill_to_site_use_id IS NULL )
757 AND ( p_bill_to_site_use_id IS NULL )))
758 AND ( ( Recinfo.bill_to_PARTY_NAME = p_bill_to_PARTY_NAME)
759 OR ( ( Recinfo.bill_to_PARTY_NAME IS NULL )
760 AND ( p_bill_to_PARTY_NAME IS NULL )))
761 AND ( ( Recinfo.bill_to_PARTY_ID = p_bill_to_PARTY_ID)
762 OR ( ( Recinfo.bill_to_PARTY_ID IS NULL )
763 AND ( p_bill_to_PARTY_ID IS NULL )))
764 AND ( ( Recinfo.bill_to_PARTY_site_id = p_bill_to_PARTY_site_id)
768 OR ( ( Recinfo.bill_to_location IS NULL )
765 OR ( ( Recinfo.bill_to_PARTY_site_id IS NULL )
766 AND ( p_bill_to_PARTY_site_id IS NULL )))
767 AND ( ( Recinfo.bill_to_location = p_bill_to_location)
769 AND ( p_bill_to_location IS NULL )))
770 AND ( ( Recinfo.bill_to_duns_number = p_bill_to_duns_number)
771 OR ( ( Recinfo.bill_to_duns_number IS NULL )
772 AND ( p_bill_to_duns_number IS NULL )))
773 AND ( ( Recinfo.bill_to_address = p_bill_to_address)
774 OR ( ( Recinfo.bill_to_address IS NULL )
775 AND ( p_bill_to_address IS NULL )))
776 AND ( ( Recinfo.bill_to_city = p_bill_to_city)
777 OR ( ( Recinfo.bill_to_city IS NULL )
778 AND ( p_bill_to_city IS NULL )))
779 AND ( ( Recinfo.bill_to_state = p_bill_to_state)
780 OR ( ( Recinfo.bill_to_state IS NULL )
781 AND ( p_bill_to_state IS NULL )))
782 AND ( ( Recinfo.bill_to_postal_code = p_bill_to_postal_code)
783 OR ( ( Recinfo.bill_to_postal_code IS NULL )
784 AND ( p_bill_to_postal_code IS NULL )))
785 AND ( ( Recinfo.bill_to_country = p_bill_to_country)
786 OR ( ( Recinfo.bill_to_country IS NULL )
787 AND ( p_bill_to_country IS NULL )))
788 AND ( ( Recinfo.bill_to_contact_party_id = p_bill_to_contact_party_id)
789 OR ( ( Recinfo.bill_to_contact_party_id IS NULL )
790 AND ( p_bill_to_contact_party_id IS NULL )))
791 AND ( ( Recinfo.bill_to_contact_name = p_bill_to_contact_name)
792 OR ( ( Recinfo.bill_to_contact_name IS NULL )
793 AND ( p_bill_to_contact_name IS NULL )))
794 AND ( ( Recinfo.bill_to_email = p_bill_to_email)
795 OR ( ( Recinfo.bill_to_email IS NULL )
796 AND ( p_bill_to_email IS NULL )))
797 AND ( ( Recinfo.bill_to_phone = p_bill_to_phone)
798 OR ( ( Recinfo.bill_to_phone IS NULL )
799 AND ( p_bill_to_phone IS NULL )))
800 AND ( ( Recinfo.bill_to_fax = p_bill_to_fax)
801 OR ( ( Recinfo.bill_to_fax IS NULL )
802 AND ( p_bill_to_fax IS NULL )))
803 AND ( ( Recinfo.ship_to_cust_account_id = p_ship_to_cust_account_id)
804 OR ( ( Recinfo.ship_to_cust_account_id IS NULL )
805 AND ( p_ship_to_cust_account_id IS NULL )))
806 AND ( ( Recinfo.ship_to_site_use_id = p_ship_to_site_use_id)
807 OR ( ( Recinfo.ship_to_site_use_id IS NULL )
808 AND ( p_ship_to_site_use_id IS NULL )))
809 AND ( ( Recinfo.ship_to_PARTY_NAME = p_ship_to_PARTY_NAME)
810 OR ( ( Recinfo.ship_to_PARTY_NAME IS NULL )
811 AND ( p_ship_to_PARTY_NAME IS NULL )))
812 AND ( ( Recinfo.ship_to_PARTY_ID = p_ship_to_PARTY_ID)
813 OR ( ( Recinfo.ship_to_PARTY_ID IS NULL )
814 AND ( p_ship_to_PARTY_ID IS NULL )))
815 AND ( ( Recinfo.ship_to_PARTY_site_id = p_ship_to_PARTY_site_id)
816 OR ( ( Recinfo.ship_to_PARTY_site_id IS NULL )
817 AND ( p_ship_to_PARTY_site_id IS NULL )))
818 AND ( ( Recinfo.ship_to_location = p_ship_to_location)
819 OR ( ( Recinfo.ship_to_location IS NULL )
820 AND ( p_ship_to_location IS NULL )))
821 AND ( ( Recinfo.ship_to_duns_number = p_ship_to_duns_number)
822 OR ( ( Recinfo.ship_to_duns_number IS NULL )
823 AND ( p_ship_to_duns_number IS NULL )))
824 AND ( ( Recinfo.ship_to_address = p_ship_to_address)
825 OR ( ( Recinfo.ship_to_address IS NULL )
826 AND ( p_ship_to_address IS NULL )))
827 AND ( ( Recinfo.ship_to_city = p_ship_to_city)
828 OR ( ( Recinfo.ship_to_city IS NULL )
829 AND ( p_ship_to_city IS NULL )))
830 AND ( ( Recinfo.ship_to_state = p_ship_to_state)
831 OR ( ( Recinfo.ship_to_state IS NULL )
832 AND ( p_ship_to_state IS NULL )))
833 AND ( ( Recinfo.ship_to_postal_code = p_ship_to_postal_code)
834 OR ( ( Recinfo.ship_to_postal_code IS NULL )
835 AND ( p_ship_to_postal_code IS NULL )))
836 AND ( ( Recinfo.ship_to_country = p_ship_to_country)
837 OR ( ( Recinfo.ship_to_country IS NULL )
838 AND ( p_ship_to_country IS NULL )))
839 AND ( ( Recinfo.ship_to_contact_party_id = p_ship_to_contact_party_id)
840 OR ( ( Recinfo.ship_to_contact_party_id IS NULL )
841 AND ( p_ship_to_contact_party_id IS NULL )))
842 AND ( ( Recinfo.ship_to_contact_name = p_ship_to_contact_name)
843 OR ( ( Recinfo.ship_to_contact_name IS NULL )
844 AND ( p_ship_to_contact_name IS NULL )))
845 AND ( ( Recinfo.ship_to_email = p_ship_to_email)
846 OR ( ( Recinfo.ship_to_email IS NULL )
847 AND ( p_ship_to_email IS NULL )))
848 AND ( ( Recinfo.ship_to_phone = p_ship_to_phone)
849 OR ( ( Recinfo.ship_to_phone IS NULL )
850 AND ( p_ship_to_phone IS NULL )))
851 AND ( ( Recinfo.ship_to_fax = p_ship_to_fax)
852 OR ( ( Recinfo.ship_to_fax IS NULL )
853 AND ( p_ship_to_fax IS NULL )))
854 AND ( ( Recinfo.sold_from_cust_account_id = p_sold_from_cust_account_id)
855 OR ( ( Recinfo.sold_from_cust_account_id IS NULL )
856 AND ( p_sold_from_cust_account_id IS NULL )))
857 AND ( ( Recinfo.ship_from_cust_account_id = p_ship_from_cust_account_id)
858 OR ( ( Recinfo.ship_from_cust_account_id IS NULL )
859 AND ( p_ship_from_cust_account_id IS NULL )))
860 AND ( ( Recinfo.header_attribute_category = p_header_attribute_category)
864 OR ( ( Recinfo.header_attribute1 IS NULL )
861 OR ( ( Recinfo.header_attribute_category IS NULL )
862 AND ( p_header_attribute_category IS NULL )))
863 AND ( ( Recinfo.header_attribute1 = p_header_attribute1)
865 AND ( p_header_attribute1 IS NULL )))
866 AND ( ( Recinfo.header_attribute2 = p_header_attribute2)
867 OR ( ( Recinfo.header_attribute2 IS NULL )
868 AND ( p_header_attribute2 IS NULL )))
869 AND ( ( Recinfo.header_attribute3 = p_header_attribute3)
870 OR ( ( Recinfo.header_attribute3 IS NULL )
871 AND ( p_header_attribute3 IS NULL )))
872 AND ( ( Recinfo.header_attribute4 = p_header_attribute4)
873 OR ( ( Recinfo.header_attribute4 IS NULL )
874 AND ( p_header_attribute4 IS NULL )))
875 AND ( ( Recinfo.header_attribute5 = p_header_attribute5)
876 OR ( ( Recinfo.header_attribute5 IS NULL )
877 AND ( p_header_attribute5 IS NULL )))
878 AND ( ( Recinfo.header_attribute6 = p_header_attribute6)
879 OR ( ( Recinfo.header_attribute6 IS NULL )
880 AND ( p_header_attribute6 IS NULL )))
881 AND ( ( Recinfo.header_attribute7 = p_header_attribute7)
882 OR ( ( Recinfo.header_attribute7 IS NULL )
883 AND ( p_header_attribute7 IS NULL )))
884 AND ( ( Recinfo.header_attribute8 = p_header_attribute8)
885 OR ( ( Recinfo.header_attribute8 IS NULL )
886 AND ( p_header_attribute8 IS NULL )))
887 AND ( ( Recinfo.header_attribute9 = p_header_attribute9)
888 OR ( ( Recinfo.header_attribute9 IS NULL )
889 AND ( p_header_attribute9 IS NULL )))
890 AND ( ( Recinfo.header_attribute10 = p_header_attribute10)
891 OR ( ( Recinfo.header_attribute10 IS NULL )
892 AND ( p_header_attribute10 IS NULL )))
893 AND ( ( Recinfo.header_attribute11 = p_header_attribute11)
894 OR ( ( Recinfo.header_attribute11 IS NULL )
895 AND ( p_header_attribute11 IS NULL )))
896 AND ( ( Recinfo.header_attribute12 = p_header_attribute12)
897 OR ( ( Recinfo.header_attribute12 IS NULL )
898 AND ( p_header_attribute12 IS NULL )))
899 AND ( ( Recinfo.header_attribute13 = p_header_attribute13)
900 OR ( ( Recinfo.header_attribute13 IS NULL )
901 AND ( p_header_attribute13 IS NULL )))
902 AND ( ( Recinfo.header_attribute14 = p_header_attribute14)
903 OR ( ( Recinfo.header_attribute14 IS NULL )
904 AND ( p_header_attribute14 IS NULL )))
905 AND ( ( Recinfo.header_attribute15 = p_header_attribute15)
906 OR ( ( Recinfo.header_attribute15 IS NULL )
907 AND ( p_header_attribute15 IS NULL )))
908 AND ( ( Recinfo.attribute_category = p_attribute_category)
909 OR ( ( Recinfo.attribute_category IS NULL )
910 AND ( p_attribute_category IS NULL )))
911 AND ( ( Recinfo.attribute1 = p_attribute1)
912 OR ( ( Recinfo.attribute1 IS NULL )
913 AND ( p_attribute1 IS NULL )))
914 AND ( ( Recinfo.attribute2 = p_attribute2)
915 OR ( ( Recinfo.attribute2 IS NULL )
916 AND ( p_attribute2 IS NULL )))
917 AND ( ( Recinfo.attribute3 = p_attribute3)
918 OR ( ( Recinfo.attribute3 IS NULL )
919 AND ( p_attribute3 IS NULL )))
920 AND ( ( Recinfo.attribute4 = p_attribute4)
921 OR ( ( Recinfo.attribute4 IS NULL )
922 AND ( p_attribute4 IS NULL )))
923 AND ( ( Recinfo.attribute5 = p_attribute5)
924 OR ( ( Recinfo.attribute5 IS NULL )
925 AND ( p_attribute5 IS NULL )))
926 AND ( ( Recinfo.attribute6 = p_attribute6)
927 OR ( ( Recinfo.attribute6 IS NULL )
928 AND ( p_attribute6 IS NULL )))
929 AND ( ( Recinfo.attribute7 = p_attribute7)
930 OR ( ( Recinfo.attribute7 IS NULL )
931 AND ( p_attribute7 IS NULL )))
932 AND ( ( Recinfo.attribute8 = p_attribute8)
933 OR ( ( Recinfo.attribute8 IS NULL )
934 AND ( p_attribute8 IS NULL )))
935 AND ( ( Recinfo.attribute9 = p_attribute9)
936 OR ( ( Recinfo.attribute9 IS NULL )
937 AND ( p_attribute9 IS NULL )))
938 AND ( ( Recinfo.attribute10 = p_attribute10)
939 OR ( ( Recinfo.attribute10 IS NULL )
940 AND ( p_attribute10 IS NULL )))
941 AND ( ( Recinfo.attribute11 = p_attribute11)
942 OR ( ( Recinfo.attribute11 IS NULL )
943 AND ( p_attribute11 IS NULL )))
944 AND ( ( Recinfo.attribute12 = p_attribute12)
945 OR ( ( Recinfo.attribute12 IS NULL )
946 AND ( p_attribute12 IS NULL )))
947 AND ( ( Recinfo.attribute13 = p_attribute13)
948 OR ( ( Recinfo.attribute13 IS NULL )
949 AND ( p_attribute13 IS NULL )))
950 AND ( ( Recinfo.attribute14 = p_attribute14)
951 OR ( ( Recinfo.attribute14 IS NULL )
952 AND ( p_attribute14 IS NULL )))
953 AND ( ( Recinfo.attribute15 = p_attribute15)
954 OR ( ( Recinfo.attribute15 IS NULL )
955 AND ( p_attribute15 IS NULL )))
956 AND ( ( Recinfo.org_id = p_org_id)
957 OR ( ( Recinfo.org_id IS NULL )
958 AND ( p_org_id IS NULL )))
959 ) THEN
960 RETURN;
961 ELSE
962 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
963 APP_EXCEPTION.RAISE_EXCEPTION;
964 END IF;
965 END Lock_Row;
966
967 END OZF_RESALE_HEADERS_PKG;