1 package body OZF_REQUEST_HEADERS_ALL_PKG as
2 /* $Header: ozftreqb.pls 120.1 2006/08/02 21:15:35 mkothari noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_REQUEST_HEADER_ID in NUMBER,
6 X_OBJECT_VERSION_NUMBER in NUMBER,
7 X_CREATION_DATE in DATE,
8 X_CREATED_BY in NUMBER,
9 X_LAST_UPDATE_DATE in DATE,
10 X_LAST_UPDATED_BY in NUMBER,
11 X_LAST_UPDATE_LOGIN in NUMBER,
12 X_REQUEST_ID in NUMBER,
13 X_program_application_id in NUMBER,
14 X_program_update_date in DATE,
15 X_program_id in NUMBER,
16 X_CREATE_FROM in VARCHAR2,
17 X_REQUEST_NUMBER in VARCHAR2,
18 X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
19 X_REQUEST_TYPE_CODE in VARCHAR2,
20 X_REQUEST_CLASS in VARCHAR2,
21 X_BENEFIT_ID in NUMBER,
22 X_ACTIVITY_MEDIA_ID in NUMBER,
23 X_SUBMITTED_BY in NUMBER,
24 X_SUBMITTED_DATE in DATE,
25 X_PARTNER_CONTACT_ID in NUMBER,
26 X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
27 X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
28 X_OFFER_ID in NUMBER,
29 X_OFFER_TYPE in VARCHAR2,
30 X_LINKED_REQUEST_HEADER_ID in NUMBER,
31 X_ROOT_REQUEST_HEADER_ID in NUMBER,
32 X_START_DATE in DATE,
33 X_END_DATE in DATE,
34 X_STATUS_CODE in VARCHAR2,
35 X_REQUEST_OUTCOME in VARCHAR2,
36 X_DECLINE_REASON_CODE in VARCHAR2,
37 X_RETURN_REASON_CODE in VARCHAR2,
38 X_CURRENCY_CODE in VARCHAR2,
39 X_PARTNER_AMOUNT in NUMBER,
40 X_REQUESTED_AMOUNT in NUMBER,
41 X_APPROVED_AMOUNT in NUMBER,
42 X_EXCHANGE_RATE_TYPE in VARCHAR2,
43 X_EXCHANGE_RATE_DATE in DATE,
44 X_EXCHANGE_RATE in NUMBER,
45 X_PARTNER_ACCTD_AMOUNT in NUMBER,
46 X_REQUESTED_ACCTD_AMOUNT in NUMBER,
47 X_APPROVED_ACCTD_AMOUNT in NUMBER,
48 X_APPROVED_BY in NUMBER,
49 X_APPROVED_DATE in DATE,
50 X_AUTHORIZATION_CODE in VARCHAR2,
51 X_AGREEMENT_NUMBER in VARCHAR2,
52 X_PARTNER_ID in NUMBER,
53 X_PARTNER_SITE_USE_ID in NUMBER,
54 X_END_CUST_PARTY_ID in NUMBER,
55 X_END_CUST_SITE_USE_ID in NUMBER,
56 X_END_CUST_DUNS_NUMBER in NUMBER,
57 X_END_CUST_NAME in VARCHAR2,
58 X_END_CUST_ADDRESS1 in VARCHAR2,
59 X_END_CUST_ADDRESS2 in VARCHAR2,
60 X_END_CUST_ADDRESS3 in VARCHAR2,
61 X_END_CUST_ADDRESS4 in VARCHAR2,
62 X_END_CUST_PROVINCE in VARCHAR2,
63 X_END_CUST_COUNTY in VARCHAR2,
64 X_END_CUST_CITY in VARCHAR2,
65 X_END_CUST_STATE in VARCHAR2,
66 X_END_CUST_POSTAL_CODE in VARCHAR2,
67 X_END_CUST_COUNTRY in VARCHAR2,
68 X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
69 X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
70 X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
71 X_END_CUST_CONTACT_TITLE in VARCHAR2,
72 X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
73 X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
74 X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
75 X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
76 X_RESELLER_PARTY_ID in NUMBER,
77 X_RESELLER_DUNS_NUMBER in NUMBER,
78 X_RESELLER_SITE_USE_ID in NUMBER,
79 X_RESELLER_NAME in VARCHAR2,
80 X_RESELLER_ADDRESS1 in VARCHAR2,
81 X_RESELLER_ADDRESS2 in VARCHAR2,
82 X_RESELLER_ADDRESS3 in VARCHAR2,
83 X_RESELLER_ADDRESS4 in VARCHAR2,
84 X_RESELLER_PROVINCE in VARCHAR2,
85 X_RESELLER_COUNTY in VARCHAR2,
86 X_RESELLER_CITY in VARCHAR2,
87 X_RESELLER_STATE in VARCHAR2,
88 X_RESELLER_POSTAL_CODE in VARCHAR2,
89 X_RESELLER_COUNTRY in VARCHAR2,
90 X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
91 X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
92 X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
93 X_RESELLER_CONTACT_TITLE in VARCHAR2,
94 X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
95 X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
96 X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
97 X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
98 X_CUSTOMER_MERGE_FLAG in VARCHAR2,
99 X_ATTRIBUTE_CATEGORY in VARCHAR2,
100 X_ATTRIBUTE1 in VARCHAR2,
101 X_ATTRIBUTE2 in VARCHAR2,
102 X_ATTRIBUTE3 in VARCHAR2,
103 X_ATTRIBUTE4 in VARCHAR2,
104 X_ATTRIBUTE5 in VARCHAR2,
105 X_ATTRIBUTE6 in VARCHAR2,
106 X_ATTRIBUTE7 in VARCHAR2,
107 X_ATTRIBUTE8 in VARCHAR2,
108 X_ATTRIBUTE9 in VARCHAR2,
109 X_ATTRIBUTE10 in VARCHAR2,
110 X_ATTRIBUTE11 in VARCHAR2,
111 X_ATTRIBUTE12 in VARCHAR2,
112 X_ATTRIBUTE13 in VARCHAR2,
113 X_ATTRIBUTE14 in VARCHAR2,
114 X_ATTRIBUTE15 in VARCHAR2,X_ORG_ID in NUMBER,
115 X_SECURITY_GROUP_ID in NUMBER,
116 X_REQUEST_NAME in VARCHAR2,
117 X_REQUEST_DESCRIPTION in VARCHAR2, X_COMMENTS in VARCHAR2
118 ) is
119 cursor C is select ROWID from OZF_REQUEST_HEADERS_ALL_B
120 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
121 ;
122 begin
123 insert into OZF_REQUEST_HEADERS_ALL_B (
124 REQUEST_HEADER_ID,
125 OBJECT_VERSION_NUMBER,
126 CREATION_DATE,
127 CREATED_BY,
128 LAST_UPDATE_DATE,
129 LAST_UPDATED_BY,
130 LAST_UPDATE_LOGIN,
131 REQUEST_ID,
132 program_application_id,
133 program_update_date,
134 program_id,
135 CREATED_FROM,
136 REQUEST_NUMBER,
137 SHIP_FROM_STOCK_FLAG,
138 REQUEST_TYPE_CODE,
139 REQUEST_CLASS,
140 BENEFIT_ID,
141 ACTIVITY_MEDIA_ID,
142 SUBMITTED_BY,
143 SUBMITTED_DATE,
144 PARTNER_CONTACT_ID,
145 PARTNER_CONTACT_PHONE_NUMBER,
146 PARTNER_CONTACT_EMAIL_ADDRESS,
147 OFFER_ID,
148 OFFER_TYPE,
149 LINKED_REQUEST_HEADER_ID,
150 ROOT_REQUEST_HEADER_ID,
151 START_DATE,
152 END_DATE,
153 STATUS_CODE,
154 REQUEST_OUTCOME,
155 DECLINE_REASON_CODE,
156 RETURN_REASON_CODE,
157 CURRENCY_CODE,
158 PARTNER_AMOUNT,
159 REQUESTED_AMOUNT,
160 APPROVED_AMOUNT,
161 EXCHANGE_RATE_TYPE,
162 EXCHANGE_RATE_DATE,
163 EXCHANGE_RATE,
164 PARTNER_ACCTD_AMOUNT,
165 REQUESTED_ACCTD_AMOUNT,
166 APPROVED_ACCTD_AMOUNT,
167 APPROVED_BY,
168 APPROVED_DATE,
169 AUTHORIZATION_CODE,
170 AGREEMENT_NUMBER,
171 PARTNER_ID,
172 PARTNER_SITE_USE_ID,
173 END_CUST_PARTY_ID,
174 END_CUST_SITE_USE_ID,
175 END_CUST_DUNS_NUMBER,
176 END_CUST_NAME,
177 END_CUST_ADDRESS1,
178 END_CUST_ADDRESS2,
179 END_CUST_ADDRESS3,
180 END_CUST_ADDRESS4,
181 END_CUST_PROVINCE,
182 END_CUST_COUNTY,
183 END_CUST_CITY,
184 END_CUST_STATE,
185 END_CUST_POSTAL_CODE,
186 END_CUST_COUNTRY,
187 END_CUST_ADDR_LINES_PHONETIC,
188 END_CUST_CONTACT_FIRST_NAME,
189 END_CUST_CONTACT_LAST_NAME,
190 END_CUST_CONTACT_TITLE,
191 END_CUST_CONTACT_EMAIL_ADDRESS,
192 END_CUST_CONTACT_PHONE_TYPE,
193 END_CUST_CONTACT_PHONE_NUMBER,
194 END_CUST_CONTACT_PHONE_EXTN,
195 RESELLER_PARTY_ID,
196 RESELLER_DUNS_NUMBER,
197 RESELLER_SITE_USE_ID,
198 RESELLER_NAME,
199 RESELLER_ADDRESS1,
200 RESELLER_ADDRESS2,
201 RESELLER_ADDRESS3,
202 RESELLER_ADDRESS4,
203 RESELLER_PROVINCE,
204 RESELLER_COUNTY,
205 RESELLER_CITY,
206 RESELLER_STATE,
207 RESELLER_POSTAL_CODE,
208 RESELLER_COUNTRY,
209 RESELLER_ADDR_LINES_PHONETIC,
210 RESELLER_CONTACT_FIRST_NAME,
211 RESELLER_CONTACT_LAST_NAME,
212 RESELLER_CONTACT_TITLE,
213 RESELLER_CONTACT_EMAIL_ADDRESS,
214 RESELLER_CONTACT_PHONE_NUMBER,
215 RESELLER_CONTACT_PHONE_TYPE,
216 RESELLER_CONTACT_PHONE_EXTN,
217 CUSTOMER_MERGE_FLAG,
218 ATTRIBUTE_CATEGORY,
219 ATTRIBUTE1,
220 ATTRIBUTE2,
221 ATTRIBUTE3,
222 ATTRIBUTE4,
223 ATTRIBUTE5,
224 ATTRIBUTE6,
225 ATTRIBUTE7,
226 ATTRIBUTE8,
227 ATTRIBUTE9,
228 ATTRIBUTE10,
229 ATTRIBUTE11,
230 ATTRIBUTE12,
231 ATTRIBUTE13,
232 ATTRIBUTE14,
233 ATTRIBUTE15,
234 ORG_ID,
235 SECURITY_GROUP_ID
236 ) values (
237 X_REQUEST_HEADER_ID,
238 X_OBJECT_VERSION_NUMBER,
239 X_CREATION_DATE,
240 X_CREATED_BY,
241 X_LAST_UPDATE_DATE,
242 X_LAST_UPDATED_BY,
243 X_LAST_UPDATE_LOGIN,
244 X_REQUEST_ID,
245 X_program_application_id,
246 X_program_update_date,
247 X_program_id,
248 X_CREATE_FROM,
249 X_REQUEST_NUMBER,
250 X_SHIP_FROM_STOCK_FLAG,
251 X_REQUEST_TYPE_CODE,
252 X_REQUEST_CLASS,
253 X_BENEFIT_ID,
254 X_ACTIVITY_MEDIA_ID,
255 X_SUBMITTED_BY,
256 X_SUBMITTED_DATE,
257 X_PARTNER_CONTACT_ID,
258 X_PARTNER_CONTACT_PHONE_NUMBER,
259 X_PARTNER_CONTACT_EMAIL_ADDRES,
260 X_OFFER_ID,X_OFFER_TYPE,
261 X_LINKED_REQUEST_HEADER_ID,
262 X_ROOT_REQUEST_HEADER_ID,
263 X_START_DATE,
264 X_END_DATE,
265 X_STATUS_CODE,
266 X_REQUEST_OUTCOME,
267 X_DECLINE_REASON_CODE,
268 X_RETURN_REASON_CODE,
269 X_CURRENCY_CODE,
270 X_PARTNER_AMOUNT,
271 X_REQUESTED_AMOUNT,
272 X_APPROVED_AMOUNT,
273 X_EXCHANGE_RATE_TYPE,
274 X_EXCHANGE_RATE_DATE,
275 X_EXCHANGE_RATE,
276 X_PARTNER_ACCTD_AMOUNT,
277 X_REQUESTED_ACCTD_AMOUNT,
278 X_APPROVED_ACCTD_AMOUNT,
279 X_APPROVED_BY,
280 X_APPROVED_DATE,
281 X_AUTHORIZATION_CODE,
282 X_AGREEMENT_NUMBER,
283 X_PARTNER_ID,
284 X_PARTNER_SITE_USE_ID,
285 X_END_CUST_PARTY_ID,
286 X_END_CUST_SITE_USE_ID,
287 X_END_CUST_DUNS_NUMBER,
288 X_END_CUST_NAME,
289 X_END_CUST_ADDRESS1,
290 X_END_CUST_ADDRESS2,
291 X_END_CUST_ADDRESS3,
292 X_END_CUST_ADDRESS4,
293 X_END_CUST_PROVINCE,
294 X_END_CUST_COUNTY,
295 X_END_CUST_CITY,
296 X_END_CUST_STATE,
297 X_END_CUST_POSTAL_CODE,
298 X_END_CUST_COUNTRY,
299 X_END_CUST_ADDR_LINES_PHONETIC,
300 X_END_CUST_CONTACT_FIRST_NAME,
301 X_END_CUST_CONTACT_LAST_NAME,
302 X_END_CUST_CONTACT_TITLE,
303 X_END_CUST_CONTACT_EMAIL_ADDRE,
304 X_END_CUST_CONTACT_PHONE_TYPE,
305 X_END_CUST_CONTACT_PHONE_NUMBE,
306 X_END_CUST_CONTACT_PHONE_EXTN,
307 X_RESELLER_PARTY_ID,
308 X_RESELLER_DUNS_NUMBER,
309 X_RESELLER_SITE_USE_ID,
310 X_RESELLER_NAME,
311 X_RESELLER_ADDRESS1,
312 X_RESELLER_ADDRESS2,
313 X_RESELLER_ADDRESS3,
314 X_RESELLER_ADDRESS4,
315 X_RESELLER_PROVINCE,
316 X_RESELLER_COUNTY,
317 X_RESELLER_CITY,
318 X_RESELLER_STATE,
319 X_RESELLER_POSTAL_CODE,
320 X_RESELLER_COUNTRY,
321 X_RESELLER_ADDR_LINES_PHONETIC,
322 X_RESELLER_CONTACT_FIRST_NAME,
323 X_RESELLER_CONTACT_LAST_NAME,
324 X_RESELLER_CONTACT_TITLE,
325 X_RESELLER_CONTACT_EMAIL_ADDRE,
326 X_RESELLER_CONTACT_PHONE_NUMBE,
327 X_RESELLER_CONTACT_PHONE_TYPE,
328 X_RESELLER_CONTACT_PHONE_EXTN,
329 X_CUSTOMER_MERGE_FLAG,
330 X_ATTRIBUTE_CATEGORY,
331 X_ATTRIBUTE1,
332 X_ATTRIBUTE2,
333 X_ATTRIBUTE3,
334 X_ATTRIBUTE4,
335 X_ATTRIBUTE5,
336 X_ATTRIBUTE6,
337 X_ATTRIBUTE7,
338 X_ATTRIBUTE8,
339 X_ATTRIBUTE9,
340 X_ATTRIBUTE10,
341 X_ATTRIBUTE11,
342 X_ATTRIBUTE12,
343 X_ATTRIBUTE13,
344 X_ATTRIBUTE14,
345 X_ATTRIBUTE15,X_ORG_ID,
346 X_SECURITY_GROUP_ID
347 );
348
349 insert into OZF_REQUEST_HEADERS_ALL_TL (
350 REQUEST_HEADER_ID,
351 LAST_UPDATE_DATE,
352 LAST_UPDATED_BY,
353 CREATION_DATE,
354 CREATED_BY,
355 LAST_UPDATE_LOGIN,
356 REQUEST_NAME,
357 REQUEST_DESCRIPTION,
358 COMMENTS,
359 SECURITY_GROUP_ID,
360 ORG_ID,
361 LANGUAGE,
362 SOURCE_LANG
363 ) select
364 X_REQUEST_HEADER_ID,
365 X_LAST_UPDATE_DATE,
366 X_LAST_UPDATED_BY,
367 X_CREATION_DATE,
368 X_CREATED_BY,
369 X_LAST_UPDATE_LOGIN,
370 X_REQUEST_NAME,
371 X_REQUEST_DESCRIPTION,
372 X_COMMENTS,
373 X_SECURITY_GROUP_ID,
374 X_ORG_ID,
375 L.LANGUAGE_CODE,
376 userenv('LANG')
377 from FND_LANGUAGES L
378 where L.INSTALLED_FLAG in ('I', 'B')
379 and not exists
380 (select NULL
381 from OZF_REQUEST_HEADERS_ALL_TL T
382 where T.REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
383 and T.LANGUAGE = L.LANGUAGE_CODE);
384
385 open c;
386 fetch c into X_ROWID;
387 if (c%notfound) then
388 close c;
389 raise no_data_found;
390 end if;
391 close c;
392
393 end INSERT_ROW;
394
395 procedure LOCK_ROW (
396 X_REQUEST_HEADER_ID in NUMBER,
397 X_REQUEST_CLASS in VARCHAR2,
398 X_OBJECT_VERSION_NUMBER in NUMBER,
399 X_REQUEST_ID in NUMBER,
400 X_CREATE_FROM in VARCHAR2,
401 X_REQUEST_NUMBER in VARCHAR2,
402 X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
403 X_REQUEST_TYPE_CODE in VARCHAR2,
404 X_BENEFIT_ID in NUMBER,
405 X_ACTIVITY_MEDIA_ID in NUMBER,
406 X_SUBMITTED_BY in NUMBER,
407 X_SUBMITTED_DATE in DATE,
408 X_PARTNER_CONTACT_ID in NUMBER,
409 X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
410 X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
411 X_OFFER_ID in NUMBER,
412 X_OFFER_TYPE in VARCHAR2,
413 X_LINKED_REQUEST_HEADER_ID in NUMBER,
414 X_ROOT_REQUEST_HEADER_ID in NUMBER,
415 X_START_DATE in DATE,
416 X_END_DATE in DATE,
417 X_STATUS_CODE in VARCHAR2,
418 X_REQUEST_OUTCOME in VARCHAR2,
419 X_DECLINE_REASON_CODE in VARCHAR2,
420 X_RETURN_REASON_CODE in VARCHAR2,
421 X_CURRENCY_CODE in VARCHAR2,
422 X_PARTNER_AMOUNT in NUMBER,
423 X_REQUESTED_AMOUNT in NUMBER,
424 X_APPROVED_AMOUNT in NUMBER,
425 X_EXCHANGE_RATE_TYPE in VARCHAR2,
426 X_EXCHANGE_RATE_DATE in DATE,
427 X_EXCHANGE_RATE in NUMBER,
428 X_PARTNER_ACCTD_AMOUNT in NUMBER,
429 X_REQUESTED_ACCTD_AMOUNT in NUMBER,
430 X_APPROVED_ACCTD_AMOUNT in NUMBER,
431 X_APPROVED_BY in NUMBER,
432 X_APPROVED_DATE in DATE,
433 X_AUTHORIZATION_CODE in VARCHAR2,
434 X_AGREEMENT_NUMBER in VARCHAR2,
435 X_PARTNER_ID in NUMBER,
436 X_PARTNER_SITE_USE_ID in NUMBER,
437 X_END_CUST_PARTY_ID in NUMBER,
438 X_END_CUST_SITE_USE_ID in NUMBER,
439 X_END_CUST_DUNS_NUMBER in NUMBER,
440 X_END_CUST_NAME in VARCHAR2,
441 X_END_CUST_ADDRESS1 in VARCHAR2,
442 X_END_CUST_ADDRESS2 in VARCHAR2,
443 X_END_CUST_ADDRESS3 in VARCHAR2,
444 X_END_CUST_ADDRESS4 in VARCHAR2,
445 X_END_CUST_PROVINCE in VARCHAR2,
446 X_END_CUST_COUNTY in VARCHAR2,
447 X_END_CUST_CITY in VARCHAR2,
448 X_END_CUST_STATE in VARCHAR2,
449 X_END_CUST_POSTAL_CODE in VARCHAR2,
450 X_END_CUST_COUNTRY in VARCHAR2,
451 X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
452 X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
453 X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
454 X_END_CUST_CONTACT_TITLE in VARCHAR2,
455 X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
456 X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
457 X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
458 X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
459 X_RESELLER_PARTY_ID in NUMBER,
460 X_RESELLER_DUNS_NUMBER in NUMBER,
461 X_RESELLER_SITE_USE_ID in NUMBER,
462 X_RESELLER_NAME in VARCHAR2,
463 X_RESELLER_ADDRESS1 in VARCHAR2,
464 X_RESELLER_ADDRESS2 in VARCHAR2,
468 X_RESELLER_COUNTY in VARCHAR2,
465 X_RESELLER_ADDRESS3 in VARCHAR2,
466 X_RESELLER_ADDRESS4 in VARCHAR2,
467 X_RESELLER_PROVINCE in VARCHAR2,
469 X_RESELLER_CITY in VARCHAR2,
470 X_RESELLER_STATE in VARCHAR2,
471 X_RESELLER_POSTAL_CODE in VARCHAR2,
472 X_RESELLER_COUNTRY in VARCHAR2,
473 X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
474 X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
475 X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
476 X_RESELLER_CONTACT_TITLE in VARCHAR2,
477 X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
478 X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
479 X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
480 X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
481 X_CUSTOMER_MERGE_FLAG in VARCHAR2,
482 X_ATTRIBUTE_CATEGORY in VARCHAR2,
483 X_ATTRIBUTE1 in VARCHAR2,
484 X_ATTRIBUTE2 in VARCHAR2,
485 X_ATTRIBUTE3 in VARCHAR2,
486 X_ATTRIBUTE4 in VARCHAR2,
487 X_ATTRIBUTE5 in VARCHAR2,
488 X_ATTRIBUTE6 in VARCHAR2,
489 X_ATTRIBUTE7 in VARCHAR2,
490 X_ATTRIBUTE8 in VARCHAR2,
491 X_ATTRIBUTE9 in VARCHAR2,
492 X_ATTRIBUTE10 in VARCHAR2,
493 X_ATTRIBUTE11 in VARCHAR2,
494 X_ATTRIBUTE12 in VARCHAR2,
495 X_ATTRIBUTE13 in VARCHAR2,
496 X_ATTRIBUTE14 in VARCHAR2,
497 X_ATTRIBUTE15 in VARCHAR2,
498 X_SECURITY_GROUP_ID in NUMBER,
499 X_REQUEST_NAME in VARCHAR2,
500 X_REQUEST_DESCRIPTION in VARCHAR2,
501 X_COMMENTS in VARCHAR2,
502 X_PROGRAM_ID NUMBER,
503 X_PROGRAM_APPLICATION_ID NUMBER,
504 X_PROGRAM_UPDATE_DATE date,
505 X_ORG_ID NUMBER
506 ) is
507 cursor c is select
508 OBJECT_VERSION_NUMBER,
509 REQUEST_ID,
510 program_application_id,
511 program_update_date,
512 program_id,
513 CREATED_FROM,
514 REQUEST_NUMBER,
515 SHIP_FROM_STOCK_FLAG,
516 REQUEST_TYPE_CODE,
517 REQUEST_CLASS,
518 BENEFIT_ID,
519 ACTIVITY_MEDIA_ID,
520 SUBMITTED_BY,
521 SUBMITTED_DATE,
522 PARTNER_CONTACT_ID,
523 PARTNER_CONTACT_PHONE_NUMBER,
524 PARTNER_CONTACT_EMAIL_ADDRESS,
525 OFFER_ID,
526 OFFER_TYPE,
527 LINKED_REQUEST_HEADER_ID,
528 ROOT_REQUEST_HEADER_ID,
529 START_DATE,
530 END_DATE,
531 STATUS_CODE,
532 REQUEST_OUTCOME,
533 DECLINE_REASON_CODE,
534 RETURN_REASON_CODE,
535 CURRENCY_CODE,
536 PARTNER_AMOUNT,
537 REQUESTED_AMOUNT,
538 APPROVED_AMOUNT,
539 EXCHANGE_RATE_TYPE,
540 EXCHANGE_RATE_DATE,
541 EXCHANGE_RATE,
542 PARTNER_ACCTD_AMOUNT,
543 REQUESTED_ACCTD_AMOUNT,
544 APPROVED_ACCTD_AMOUNT,
545 APPROVED_BY,
546 APPROVED_DATE,
547 AUTHORIZATION_CODE,
548 AGREEMENT_NUMBER,
549 PARTNER_ID,
550 PARTNER_SITE_USE_ID,
551 END_CUST_PARTY_ID,
552 END_CUST_SITE_USE_ID,
553 END_CUST_DUNS_NUMBER,
554 END_CUST_NAME,
555 END_CUST_ADDRESS1,
556 END_CUST_ADDRESS2,
557 END_CUST_ADDRESS3,
558 END_CUST_ADDRESS4,
559 END_CUST_PROVINCE,
560 END_CUST_COUNTY,
561 END_CUST_CITY,
562 END_CUST_STATE,
563 END_CUST_POSTAL_CODE,
564 END_CUST_COUNTRY,
565 END_CUST_ADDR_LINES_PHONETIC,
566 END_CUST_CONTACT_FIRST_NAME,
567 END_CUST_CONTACT_LAST_NAME,
568 END_CUST_CONTACT_TITLE,
569 END_CUST_CONTACT_EMAIL_ADDRESS,
570 END_CUST_CONTACT_PHONE_TYPE,
571 END_CUST_CONTACT_PHONE_NUMBER,
572 END_CUST_CONTACT_PHONE_EXTN,
573 RESELLER_PARTY_ID,
574 RESELLER_DUNS_NUMBER,
575 RESELLER_SITE_USE_ID,
576 RESELLER_NAME,
577 RESELLER_ADDRESS1,
578 RESELLER_ADDRESS2,
579 RESELLER_ADDRESS3,
580 RESELLER_ADDRESS4,
581 RESELLER_PROVINCE,
582 RESELLER_COUNTY,
583 RESELLER_CITY,
584 RESELLER_STATE,
585 RESELLER_POSTAL_CODE,
586 RESELLER_COUNTRY,
587 RESELLER_ADDR_LINES_PHONETIC,
588 RESELLER_CONTACT_FIRST_NAME,
589 RESELLER_CONTACT_LAST_NAME,
590 RESELLER_CONTACT_TITLE,
591 RESELLER_CONTACT_EMAIL_ADDRESS,
592 RESELLER_CONTACT_PHONE_NUMBER,
593 RESELLER_CONTACT_PHONE_TYPE,
594 RESELLER_CONTACT_PHONE_EXTN,
595 CUSTOMER_MERGE_FLAG,
596 ATTRIBUTE_CATEGORY,
597 ATTRIBUTE1,
598 ATTRIBUTE2,
599 ATTRIBUTE3,
600 ATTRIBUTE4,
601 ATTRIBUTE5,
602 ATTRIBUTE6,
603 ATTRIBUTE7,
604 ATTRIBUTE8,
605 ATTRIBUTE9,
606 ATTRIBUTE10,
607 ATTRIBUTE11,
608 ATTRIBUTE12,
609 ATTRIBUTE13,
610 ATTRIBUTE14,
611 ATTRIBUTE15,
612 SECURITY_GROUP_ID,
613 ORG_ID
614 from OZF_REQUEST_HEADERS_ALL_B
615 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
616 for update of REQUEST_HEADER_ID nowait;
617 recinfo c%rowtype;
618
619 cursor c1 is select
620 REQUEST_NAME,
621 REQUEST_DESCRIPTION,COMMENTS,
622 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
623 from OZF_REQUEST_HEADERS_ALL_TL
624 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
625 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
626 for update of REQUEST_HEADER_ID nowait;
627 begin
628 open c;
632 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629 fetch c into recinfo;
630 if (c%notfound) then
631 close c;
633 app_exception.raise_exception;
634 end if;
635 close c;
636 /*
637 if ( (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
638 AND ((recinfo.REQUEST_ID = X_REQUEST_ID)
639 OR ((recinfo.REQUEST_ID is null) AND (X_REQUEST_ID is null)))
640 AND ((recinfo.CREATED_FROM = X_CREATE_FROM)
641 OR ((recinfo.CREATED_FROM is null) AND (X_CREATE_FROM is null)))
642 AND (recinfo.REQUEST_NUMBER = X_REQUEST_NUMBER)
643 AND ((recinfo.SHIP_FROM_STOCK_FLAG = X_SHIP_FROM_STOCK_FLAG)
644 OR ((recinfo.SHIP_FROM_STOCK_FLAG is null) AND (X_SHIP_FROM_STOCK_FLAG is null)))
645 AND (recinfo.REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE)
646 AND ((recinfo.BENEFIT_ID = X_BENEFIT_ID)
647 OR ((recinfo.BENEFIT_ID is null) AND (X_BENEFIT_ID is null)))
648 AND ((recinfo.ACTIVITY_MEDIA_ID = X_ACTIVITY_MEDIA_ID)
649 OR ((recinfo.ACTIVITY_MEDIA_ID is null) AND (X_ACTIVITY_MEDIA_ID is null)))
650 AND ((recinfo.SUBMITTED_BY = X_SUBMITTED_BY)
651 OR ((recinfo.SUBMITTED_BY is null) AND (X_SUBMITTED_BY is null)))
652 AND ((recinfo.SUBMITTED_DATE = X_SUBMITTED_DATE)
653 OR ((recinfo.SUBMITTED_DATE is null) AND (X_SUBMITTED_DATE is null)))
654 AND ((recinfo.PARTNER_CONTACT_ID = X_PARTNER_CONTACT_ID)
655 OR ((recinfo.PARTNER_CONTACT_ID is null) AND (X_PARTNER_CONTACT_ID is null)))
656 AND ((recinfo.PARTNER_CONTACT_PHONE_NUMBER = X_PARTNER_CONTACT_PHONE_NUMBER)
657 OR ((recinfo.PARTNER_CONTACT_PHONE_NUMBER is null) AND (X_PARTNER_CONTACT_PHONE_NUMBER is null)))
658 AND ((recinfo.PARTNER_CONTACT_EMAIL_ADDRESS = X_PARTNER_CONTACT_EMAIL_ADDRES)
659 OR ((recinfo.PARTNER_CONTACT_EMAIL_ADDRESS is null) AND (X_PARTNER_CONTACT_EMAIL_ADDRES is null)))
660 AND ((recinfo.OFFER_ID = X_OFFER_ID)
661 OR ((recinfo.OFFER_ID is null) AND (X_OFFER_ID is null)))
662 AND ((recinfo.OFFER_TYPE = X_OFFER_TYPE)
663 OR ((recinfo.OFFER_TYPE is null) AND (X_OFFER_TYPE is null)))
664 AND ((recinfo.LINKED_REQUEST_HEADER_ID = X_LINKED_REQUEST_HEADER_ID)
665 OR ((recinfo.LINKED_REQUEST_HEADER_ID is null) AND (X_LINKED_REQUEST_HEADER_ID is null)))
666 AND ((recinfo.ROOT_REQUEST_HEADER_ID = X_ROOT_REQUEST_HEADER_ID)
667 OR ((recinfo.ROOT_REQUEST_HEADER_ID is null) AND (X_ROOT_REQUEST_HEADER_ID is null)))
668 AND ((recinfo.START_DATE = X_START_DATE)
669 OR ((recinfo.START_DATE is null) AND (X_START_DATE is null)))
670 AND ((recinfo.END_DATE = X_END_DATE)
671 OR ((recinfo.END_DATE is null) AND (X_END_DATE is null)))
672 AND (recinfo.STATUS_CODE = X_STATUS_CODE)
673 AND ((recinfo.REQUEST_OUTCOME = X_REQUEST_OUTCOME)
674 OR ((recinfo.REQUEST_OUTCOME is null) AND (X_REQUEST_OUTCOME is null)))
675 AND ((recinfo.DECLINE_REASON_CODE = X_DECLINE_REASON_CODE)
676 OR ((recinfo.DECLINE_REASON_CODE is null) AND (X_DECLINE_REASON_CODE is null)))
677 AND ((recinfo.CURRENCY_CODE = X_CURRENCY_CODE)
678 OR ((recinfo.CURRENCY_CODE is null) AND (X_CURRENCY_CODE is null)))
679 AND ((recinfo.PARTNER_AMOUNT = X_PARTNER_AMOUNT)
680 OR ((recinfo.PARTNER_AMOUNT is null) AND (X_PARTNER_AMOUNT is null)))
681 AND ((recinfo.REQUESTED_AMOUNT = X_REQUESTED_AMOUNT)
682 OR ((recinfo.REQUESTED_AMOUNT is null) AND (X_REQUESTED_AMOUNT is null)))
683 AND ((recinfo.APPROVED_AMOUNT = X_APPROVED_AMOUNT)
684 OR ((recinfo.APPROVED_AMOUNT is null) AND (X_APPROVED_AMOUNT is null)))
685 AND ((recinfo.EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE)
686 OR ((recinfo.EXCHANGE_RATE_TYPE is null) AND (X_EXCHANGE_RATE_TYPE is null)))
687 AND ((recinfo.EXCHANGE_RATE_DATE = X_EXCHANGE_RATE_DATE)
688 OR ((recinfo.EXCHANGE_RATE_DATE is null) AND (X_EXCHANGE_RATE_DATE is null)))
689 AND ((recinfo.EXCHANGE_RATE = X_EXCHANGE_RATE)
690 OR ((recinfo.EXCHANGE_RATE is null) AND (X_EXCHANGE_RATE is null)))
691 AND ((recinfo.PARTNER_ACCTD_AMOUNT = X_PARTNER_ACCTD_AMOUNT)
692 OR ((recinfo.PARTNER_ACCTD_AMOUNT is null) AND (X_PARTNER_ACCTD_AMOUNT is null)))
693 AND ((recinfo.REQUESTED_ACCTD_AMOUNT = X_REQUESTED_ACCTD_AMOUNT)
694 OR ((recinfo.REQUESTED_ACCTD_AMOUNT is null) AND (X_REQUESTED_ACCTD_AMOUNT is null)))
695 AND ((recinfo.APPROVED_ACCTD_AMOUNT = X_APPROVED_ACCTD_AMOUNT)
696 OR ((recinfo.APPROVED_ACCTD_AMOUNT is null) AND (X_APPROVED_ACCTD_AMOUNT is null)))
697 AND ((recinfo.APPROVED_BY = X_APPROVED_BY)
698 OR ((recinfo.APPROVED_BY is null) AND (X_APPROVED_BY is null)))
699 AND ((recinfo.APPROVED_DATE = X_APPROVED_DATE)
700 OR ((recinfo.APPROVED_DATE is null) AND (X_APPROVED_DATE is null)))
701 AND ((recinfo.AUTHORIZATION_CODE = X_AUTHORIZATION_CODE)
702 OR ((recinfo.AUTHORIZATION_CODE is null) AND (X_AUTHORIZATION_CODE is null)))
703 AND ((recinfo.AGREEMENT_NUMBER = X_AGREEMENT_NUMBER)
704 OR ((recinfo.AGREEMENT_NUMBER is null) AND (X_AGREEMENT_NUMBER is null)))
705 AND (recinfo.PARTNER_ID = X_PARTNER_ID)
706 AND ((recinfo.PARTNER_SITE_USE_ID = X_PARTNER_SITE_USE_ID)
707 OR ((recinfo.PARTNER_SITE_USE_ID is null) AND (X_PARTNER_SITE_USE_ID is null)))
708 AND ((recinfo.END_CUST_PARTY_ID = X_END_CUST_PARTY_ID)
709 OR ((recinfo.END_CUST_PARTY_ID is null) AND (X_END_CUST_PARTY_ID is null)))
710 AND ((recinfo.END_CUST_SITE_USE_ID = X_END_CUST_SITE_USE_ID)
711 OR ((recinfo.END_CUST_SITE_USE_ID is null) AND (X_END_CUST_SITE_USE_ID is null)))
715 OR ((recinfo.END_CUST_NAME is null) AND (X_END_CUST_NAME is null)))
712 AND ((recinfo.END_CUST_DUNS_NUMBER = X_END_CUST_DUNS_NUMBER)
713 OR ((recinfo.END_CUST_DUNS_NUMBER is null) AND (X_END_CUST_DUNS_NUMBER is null)))
714 AND ((recinfo.END_CUST_NAME = X_END_CUST_NAME)
716 AND ((recinfo.END_CUST_ADDRESS1 = X_END_CUST_ADDRESS1)
717 OR ((recinfo.END_CUST_ADDRESS1 is null) AND (X_END_CUST_ADDRESS1 is null)))
718 AND ((recinfo.END_CUST_CITY = X_END_CUST_CITY)
719 OR ((recinfo.END_CUST_CITY is null) AND (X_END_CUST_CITY is null)))
720 AND ((recinfo.END_CUST_STATE = X_END_CUST_STATE)
721 OR ((recinfo.END_CUST_STATE is null) AND (X_END_CUST_STATE is null)))
722 AND ((recinfo.END_CUST_POSTAL_CODE = X_END_CUST_POSTAL_CODE)
723 OR ((recinfo.END_CUST_POSTAL_CODE is null) AND (X_END_CUST_POSTAL_CODE is null)))
724 AND ((recinfo.END_CUST_COUNTRY = X_END_CUST_COUNTRY)
725 OR ((recinfo.END_CUST_COUNTRY is null) AND (X_END_CUST_COUNTRY is null)))
726 AND ((recinfo.END_CUST_CONTACT_FIRST_NAME = X_END_CUST_CONTACT_FIRST_NAME)
727 OR ((recinfo.END_CUST_CONTACT_FIRST_NAME is null) AND (X_END_CUST_CONTACT_FIRST_NAME is null)))
728 AND ((recinfo.END_CUST_CONTACT_LAST_NAME = X_END_CUST_CONTACT_LAST_NAME)
729 OR ((recinfo.END_CUST_CONTACT_LAST_NAME is null) AND (X_END_CUST_CONTACT_LAST_NAME is null)))
730 AND ((recinfo.END_CUST_CONTACT_TITLE = X_END_CUST_CONTACT_TITLE)
731 OR ((recinfo.END_CUST_CONTACT_TITLE is null) AND (X_END_CUST_CONTACT_TITLE is null)))
732 AND ((recinfo.END_CUST_CONTACT_EMAIL_ADDRESS = X_END_CUST_CONTACT_EMAIL_ADDRE)
733 OR ((recinfo.END_CUST_CONTACT_EMAIL_ADDRESS is null) AND (X_END_CUST_CONTACT_EMAIL_ADDRE is null)))
734 AND ((recinfo.END_CUST_CONTACT_PHONE_TYPE = X_END_CUST_CONTACT_PHONE_TYPE)
735 OR ((recinfo.END_CUST_CONTACT_PHONE_TYPE is null) AND (X_END_CUST_CONTACT_PHONE_TYPE is null)))
736 AND ((recinfo.END_CUST_CONTACT_PHONE_NUMBER = X_END_CUST_CONTACT_PHONE_NUMBE)
737 OR ((recinfo.END_CUST_CONTACT_PHONE_NUMBER is null) AND (X_END_CUST_CONTACT_PHONE_NUMBE is null)))
738 AND ((recinfo.END_CUST_CONTACT_PHONE_EXTN = X_END_CUST_CONTACT_PHONE_EXTN)
739 OR ((recinfo.END_CUST_CONTACT_PHONE_EXTN is null) AND (X_END_CUST_CONTACT_PHONE_EXTN is null)))
740 AND ((recinfo.RESELLER_PARTY_ID = X_RESELLER_PARTY_ID)
741 OR ((recinfo.RESELLER_PARTY_ID is null) AND (X_RESELLER_PARTY_ID is null)))
742 AND ((recinfo.RESELLER_DUNS_NUMBER = X_RESELLER_DUNS_NUMBER)
743 OR ((recinfo.RESELLER_DUNS_NUMBER is null) AND (X_RESELLER_DUNS_NUMBER is null)))
744 AND ((recinfo.RESELLER_SITE_USE_ID = X_RESELLER_SITE_USE_ID)
745 OR ((recinfo.RESELLER_SITE_USE_ID is null) AND (X_RESELLER_SITE_USE_ID is null)))
746 AND ((recinfo.RESELLER_NAME = X_RESELLER_NAME)
747 OR ((recinfo.RESELLER_NAME is null) AND (X_RESELLER_NAME is null)))
748 AND ((recinfo.RESELLER_ADDRESS1 = X_RESELLER_ADDRESS1)
749 OR ((recinfo.RESELLER_ADDRESS1 is null) AND (X_RESELLER_ADDRESS1 is null)))
750 AND ((recinfo.RESELLER_CITY = X_RESELLER_CITY)
751 OR ((recinfo.RESELLER_CITY is null) AND (X_RESELLER_CITY is null)))
752 AND ((recinfo.RESELLER_STATE = X_RESELLER_STATE)
753 OR ((recinfo.RESELLER_STATE is null) AND (X_RESELLER_STATE is null)))
754 AND ((recinfo.RESELLER_POSTAL_CODE = X_RESELLER_POSTAL_CODE)
755 OR ((recinfo.RESELLER_POSTAL_CODE is null) AND (X_RESELLER_POSTAL_CODE is null)))
756 AND ((recinfo.RESELLER_COUNTRY = X_RESELLER_COUNTRY)
757 OR ((recinfo.RESELLER_COUNTRY is null) AND (X_RESELLER_COUNTRY is null)))
758 AND ((recinfo.RESELLER_CONTACT_FIRST_NAME = X_RESELLER_CONTACT_FIRST_NAME)
759 OR ((recinfo.RESELLER_CONTACT_FIRST_NAME is null) AND (X_RESELLER_CONTACT_FIRST_NAME is null)))
760 AND ((recinfo.RESELLER_CONTACT_LAST_NAME = X_RESELLER_CONTACT_LAST_NAME)
761 OR ((recinfo.RESELLER_CONTACT_LAST_NAME is null) AND (X_RESELLER_CONTACT_LAST_NAME is null)))
762 AND ((recinfo.RESELLER_CONTACT_TITLE = X_RESELLER_CONTACT_TITLE)
763 OR ((recinfo.RESELLER_CONTACT_TITLE is null) AND (X_RESELLER_CONTACT_TITLE is null)))
764 AND ((recinfo.RESELLER_CONTACT_EMAIL_ADDRESS = X_RESELLER_CONTACT_EMAIL_ADDRE)
765 OR ((recinfo.RESELLER_CONTACT_EMAIL_ADDRESS is null) AND (X_RESELLER_CONTACT_EMAIL_ADDRE is null)))
766 AND ((recinfo.RESELLER_CONTACT_PHONE_NUMBER = X_RESELLER_CONTACT_PHONE_NUMBE)
767 OR ((recinfo.RESELLER_CONTACT_PHONE_NUMBER is null) AND (X_RESELLER_CONTACT_PHONE_NUMBE is null)))
768 AND ((recinfo.RESELLER_CONTACT_PHONE_TYPE = X_RESELLER_CONTACT_PHONE_TYPE)
769 OR ((recinfo.RESELLER_CONTACT_PHONE_TYPE is null) AND (X_RESELLER_CONTACT_PHONE_TYPE is null)))
770 AND ((recinfo.RESELLER_CONTACT_PHONE_EXTN = X_RESELLER_CONTACT_PHONE_EXTN)
771 OR ((recinfo.RESELLER_CONTACT_PHONE_EXTN is null) AND (X_RESELLER_CONTACT_PHONE_EXTN is null)))
772 AND ((recinfo.CUSTOMER_MERGE_FLAG = X_CUSTOMER_MERGE_FLAG)
773 OR ((recinfo.CUSTOMER_MERGE_FLAG is null) AND (X_CUSTOMER_MERGE_FLAG is null)))
774 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
775 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
776 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
777 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
778 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
779 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
780 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
784 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
781 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
782 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
783 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
785 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
786 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
787 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
788 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
789 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
790 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
791 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
792 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
793 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
794 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
795 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
796 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
797 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
798 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
799 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
800 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
801 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
802 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
803 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
804 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
805 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
806 AND ((recinfo.SECURITY_GROUP_ID = X_SECURITY_GROUP_ID)
807 OR ((recinfo.SECURITY_GROUP_ID is null) AND (X_SECURITY_GROUP_ID is null)))
808 )
809 then
810 null;
811 else
812 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
813 app_exception.raise_exception;
814 end if;
815 */
816
817 for tlinfo in c1 loop
818 if (tlinfo.BASELANG = 'Y') then
819 if ( ((tlinfo.REQUEST_NAME = X_REQUEST_NAME)
820 OR ((tlinfo.REQUEST_NAME is null) AND (X_REQUEST_NAME is null)))
821 AND ((tlinfo.REQUEST_DESCRIPTION = X_REQUEST_DESCRIPTION)
822 OR ((tlinfo.REQUEST_DESCRIPTION is null) AND (X_REQUEST_DESCRIPTION is null)))
823 AND ((tlinfo.COMMENTS = X_COMMENTS)
824 OR ((tlinfo.COMMENTS is null) AND (X_COMMENTS is null)))
825
826 ) then
827 null;
828 else
829 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
830 app_exception.raise_exception;
831 end if;
832 end if;
833 end loop;
834 return;
835 end LOCK_ROW;
836
837 procedure UPDATE_ROW (
838 X_REQUEST_HEADER_ID in NUMBER,
839 X_REQUEST_CLASS in VARCHAR2,
840 X_OBJECT_VERSION_NUMBER in NUMBER,
841 X_REQUEST_ID in NUMBER,
842 X_CREATE_FROM in VARCHAR2,
843 X_REQUEST_NUMBER in VARCHAR2,
844 X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
845 X_REQUEST_TYPE_CODE in VARCHAR2,
846 X_BENEFIT_ID in NUMBER,
847 X_ACTIVITY_MEDIA_ID in NUMBER,
848 X_SUBMITTED_BY in NUMBER,
849 X_SUBMITTED_DATE in DATE,
850 X_PARTNER_CONTACT_ID in NUMBER,
851 X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
852 X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
853 X_OFFER_ID in NUMBER,
854 X_OFFER_TYPE in VARCHAR2,
855 X_LINKED_REQUEST_HEADER_ID in NUMBER,
856 X_ROOT_REQUEST_HEADER_ID in NUMBER,
857 X_START_DATE in DATE,
858 X_END_DATE in DATE,
859 X_STATUS_CODE in VARCHAR2,
860 X_REQUEST_OUTCOME in VARCHAR2,
861 X_DECLINE_REASON_CODE in VARCHAR2,
862 X_RETURN_REASON_CODE in VARCHAR2,
863 X_CURRENCY_CODE in VARCHAR2,
864 X_PARTNER_AMOUNT in NUMBER,
865 X_REQUESTED_AMOUNT in NUMBER,
866 X_APPROVED_AMOUNT in NUMBER,
867 X_EXCHANGE_RATE_TYPE in VARCHAR2,
868 X_EXCHANGE_RATE_DATE in DATE,
869 X_EXCHANGE_RATE in NUMBER,
870 X_PARTNER_ACCTD_AMOUNT in NUMBER,
871 X_REQUESTED_ACCTD_AMOUNT in NUMBER,
872 X_APPROVED_ACCTD_AMOUNT in NUMBER,
873 X_APPROVED_BY in NUMBER,
874 X_APPROVED_DATE in DATE,
875 X_AUTHORIZATION_CODE in VARCHAR2,
876 X_AGREEMENT_NUMBER in VARCHAR2,
877 X_PARTNER_ID in NUMBER,
878 X_PARTNER_SITE_USE_ID in NUMBER,
879 X_END_CUST_PARTY_ID in NUMBER,
880 X_END_CUST_SITE_USE_ID in NUMBER,
881 X_END_CUST_DUNS_NUMBER in NUMBER,
882 X_END_CUST_NAME in VARCHAR2,
883 X_END_CUST_ADDRESS1 in VARCHAR2,
884 X_END_CUST_ADDRESS2 in VARCHAR2,
885 X_END_CUST_ADDRESS3 in VARCHAR2,
886 X_END_CUST_ADDRESS4 in VARCHAR2,
887 X_END_CUST_PROVINCE in VARCHAR2,
888 X_END_CUST_COUNTY in VARCHAR2,
889 X_END_CUST_CITY in VARCHAR2,
890 X_END_CUST_STATE in VARCHAR2,
891 X_END_CUST_POSTAL_CODE in VARCHAR2,
892 X_END_CUST_COUNTRY in VARCHAR2,
893 X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
894 X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
895 X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
896 X_END_CUST_CONTACT_TITLE in VARCHAR2,
897 X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
898 X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
899 X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
900 X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
901 X_RESELLER_PARTY_ID in NUMBER,
905 X_RESELLER_ADDRESS1 in VARCHAR2,
902 X_RESELLER_DUNS_NUMBER in NUMBER,
903 X_RESELLER_SITE_USE_ID in NUMBER,
904 X_RESELLER_NAME in VARCHAR2,
906 X_RESELLER_ADDRESS2 in VARCHAR2,
907 X_RESELLER_ADDRESS3 in VARCHAR2,
908 X_RESELLER_ADDRESS4 in VARCHAR2,
909 X_RESELLER_PROVINCE in VARCHAR2,
910 X_RESELLER_COUNTY in VARCHAR2,
911 X_RESELLER_CITY in VARCHAR2,
912 X_RESELLER_STATE in VARCHAR2,
913 X_RESELLER_POSTAL_CODE in VARCHAR2,
914 X_RESELLER_COUNTRY in VARCHAR2,
915 X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
916 X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
917 X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
918 X_RESELLER_CONTACT_TITLE in VARCHAR2,
919 X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
920 X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
921 X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
922 X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
923 X_CUSTOMER_MERGE_FLAG in VARCHAR2,
924 X_ATTRIBUTE_CATEGORY in VARCHAR2,
925 X_ATTRIBUTE1 in VARCHAR2,
926 X_ATTRIBUTE2 in VARCHAR2,
927 X_ATTRIBUTE3 in VARCHAR2,
928 X_ATTRIBUTE4 in VARCHAR2,
929 X_ATTRIBUTE5 in VARCHAR2,
930 X_ATTRIBUTE6 in VARCHAR2,
931 X_ATTRIBUTE7 in VARCHAR2,
932 X_ATTRIBUTE8 in VARCHAR2,
933 X_ATTRIBUTE9 in VARCHAR2,
934 X_ATTRIBUTE10 in VARCHAR2,
935 X_ATTRIBUTE11 in VARCHAR2,
936 X_ATTRIBUTE12 in VARCHAR2,
937 X_ATTRIBUTE13 in VARCHAR2,
938 X_ATTRIBUTE14 in VARCHAR2,
939 X_ATTRIBUTE15 in VARCHAR2,
940 X_SECURITY_GROUP_ID in NUMBER,
941 X_REQUEST_NAME in VARCHAR2,
942 X_REQUEST_DESCRIPTION in VARCHAR2,
943 X_COMMENTS in VARCHAR2,
944 X_LAST_UPDATE_DATE in DATE,
945 X_LAST_UPDATED_BY in NUMBER,
946 X_LAST_UPDATE_LOGIN in NUMBER,
947 X_PROGRAM_ID NUMBER,
948 X_PROGRAM_APPLICATION_ID NUMBER,
949 X_PROGRAM_UPDATE_DATE date,
950 X_ORG_ID NUMBER
951 ) is
952 begin
953 update OZF_REQUEST_HEADERS_ALL_B set
954 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
955 REQUEST_ID = X_REQUEST_ID,
956 program_application_id = X_program_application_id,
957 program_update_date = X_program_update_date,
958 program_id = X_program_id,
959 CREATED_FROM = X_CREATE_FROM,
960 REQUEST_NUMBER = X_REQUEST_NUMBER,
961 SHIP_FROM_STOCK_FLAG = X_SHIP_FROM_STOCK_FLAG,
962 REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE,
963 BENEFIT_ID = X_BENEFIT_ID,
964 ACTIVITY_MEDIA_ID = X_ACTIVITY_MEDIA_ID,
965 SUBMITTED_BY = X_SUBMITTED_BY,
966 SUBMITTED_DATE = X_SUBMITTED_DATE,
967 PARTNER_CONTACT_ID = X_PARTNER_CONTACT_ID,
968 PARTNER_CONTACT_PHONE_NUMBER = X_PARTNER_CONTACT_PHONE_NUMBER,
969 PARTNER_CONTACT_EMAIL_ADDRESS = X_PARTNER_CONTACT_EMAIL_ADDRES,
970 OFFER_ID = X_OFFER_ID,
971 OFFER_TYPE = X_OFFER_TYPE,
972 LINKED_REQUEST_HEADER_ID = X_LINKED_REQUEST_HEADER_ID,
973 ROOT_REQUEST_HEADER_ID = X_ROOT_REQUEST_HEADER_ID,
974 START_DATE = X_START_DATE,
975 END_DATE = X_END_DATE,
976 STATUS_CODE = X_STATUS_CODE,
977 REQUEST_OUTCOME = X_REQUEST_OUTCOME,
978 DECLINE_REASON_CODE = X_DECLINE_REASON_CODE,
979 RETURN_REASON_CODE = X_RETURN_REASON_CODE,
980 CURRENCY_CODE = X_CURRENCY_CODE,
981 PARTNER_AMOUNT = X_PARTNER_AMOUNT,
982 REQUESTED_AMOUNT = X_REQUESTED_AMOUNT,
983 APPROVED_AMOUNT = X_APPROVED_AMOUNT,
984 EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE,
985 EXCHANGE_RATE_DATE = X_EXCHANGE_RATE_DATE,
986 EXCHANGE_RATE = X_EXCHANGE_RATE,
987 PARTNER_ACCTD_AMOUNT = X_PARTNER_ACCTD_AMOUNT,
988 REQUESTED_ACCTD_AMOUNT = X_REQUESTED_ACCTD_AMOUNT,
989 APPROVED_ACCTD_AMOUNT = X_APPROVED_ACCTD_AMOUNT,
990 APPROVED_BY = X_APPROVED_BY,
991 APPROVED_DATE = X_APPROVED_DATE,
992 AUTHORIZATION_CODE = X_AUTHORIZATION_CODE,
993 AGREEMENT_NUMBER = X_AGREEMENT_NUMBER,
994 PARTNER_ID = X_PARTNER_ID,
995 PARTNER_SITE_USE_ID = X_PARTNER_SITE_USE_ID,
996 END_CUST_PARTY_ID = X_END_CUST_PARTY_ID,
997 END_CUST_SITE_USE_ID = X_END_CUST_SITE_USE_ID,
998 END_CUST_DUNS_NUMBER = X_END_CUST_DUNS_NUMBER,
999 END_CUST_NAME = X_END_CUST_NAME,
1000 END_CUST_ADDRESS1 = X_END_CUST_ADDRESS1,
1001 END_CUST_ADDRESS2 = X_END_CUST_ADDRESS2,
1002 END_CUST_ADDRESS3 = X_END_CUST_ADDRESS3,
1003 END_CUST_ADDRESS4 = X_END_CUST_ADDRESS4,
1004 END_CUST_PROVINCE = X_END_CUST_PROVINCE,
1005 END_CUST_COUNTY = X_END_CUST_COUNTY,
1006 END_CUST_CITY = X_END_CUST_CITY,
1007 END_CUST_STATE = X_END_CUST_STATE,
1008 END_CUST_POSTAL_CODE = X_END_CUST_POSTAL_CODE,
1009 END_CUST_COUNTRY = X_END_CUST_COUNTRY,
1010 END_CUST_ADDR_LINES_PHONETIC = X_END_CUST_ADDR_LINES_PHONETIC,
1011 END_CUST_CONTACT_FIRST_NAME = X_END_CUST_CONTACT_FIRST_NAME,
1012 END_CUST_CONTACT_LAST_NAME = X_END_CUST_CONTACT_LAST_NAME,
1013 END_CUST_CONTACT_TITLE = X_END_CUST_CONTACT_TITLE,
1014 END_CUST_CONTACT_EMAIL_ADDRESS = X_END_CUST_CONTACT_EMAIL_ADDRE,
1015 END_CUST_CONTACT_PHONE_TYPE = X_END_CUST_CONTACT_PHONE_TYPE,
1016 END_CUST_CONTACT_PHONE_NUMBER = X_END_CUST_CONTACT_PHONE_NUMBE,
1017 END_CUST_CONTACT_PHONE_EXTN = X_END_CUST_CONTACT_PHONE_EXTN,
1018 RESELLER_PARTY_ID = X_RESELLER_PARTY_ID,
1019 RESELLER_DUNS_NUMBER = X_RESELLER_DUNS_NUMBER,
1020 RESELLER_SITE_USE_ID = X_RESELLER_SITE_USE_ID,
1021 RESELLER_NAME = X_RESELLER_NAME,
1022 RESELLER_ADDRESS1 = X_RESELLER_ADDRESS1,
1023 RESELLER_ADDRESS2 = X_RESELLER_ADDRESS2,
1024 RESELLER_ADDRESS3 = X_RESELLER_ADDRESS3,
1025 RESELLER_ADDRESS4 = X_RESELLER_ADDRESS4,
1026 RESELLER_PROVINCE = X_RESELLER_PROVINCE,
1027 RESELLER_COUNTY = X_RESELLER_COUNTY,
1028 RESELLER_CITY = X_RESELLER_CITY,
1029 RESELLER_STATE = X_RESELLER_STATE,
1030 RESELLER_POSTAL_CODE = X_RESELLER_POSTAL_CODE,
1031 RESELLER_COUNTRY = X_RESELLER_COUNTRY,
1032 RESELLER_ADDR_LINES_PHONETIC = X_RESELLER_ADDR_LINES_PHONETIC,
1033 RESELLER_CONTACT_FIRST_NAME = X_RESELLER_CONTACT_FIRST_NAME,
1034 RESELLER_CONTACT_LAST_NAME = X_RESELLER_CONTACT_LAST_NAME,
1035 RESELLER_CONTACT_TITLE = X_RESELLER_CONTACT_TITLE,
1036 RESELLER_CONTACT_EMAIL_ADDRESS = X_RESELLER_CONTACT_EMAIL_ADDRE,
1037 RESELLER_CONTACT_PHONE_NUMBER = X_RESELLER_CONTACT_PHONE_NUMBE,
1038 RESELLER_CONTACT_PHONE_TYPE = X_RESELLER_CONTACT_PHONE_TYPE,
1039 RESELLER_CONTACT_PHONE_EXTN = X_RESELLER_CONTACT_PHONE_EXTN,
1040 CUSTOMER_MERGE_FLAG = X_CUSTOMER_MERGE_FLAG,
1041 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
1042 ATTRIBUTE1 = X_ATTRIBUTE1,
1043 ATTRIBUTE2 = X_ATTRIBUTE2,
1044 ATTRIBUTE3 = X_ATTRIBUTE3,
1045 ATTRIBUTE4 = X_ATTRIBUTE4,
1046 ATTRIBUTE5 = X_ATTRIBUTE5,
1047 ATTRIBUTE6 = X_ATTRIBUTE6,
1048 ATTRIBUTE7 = X_ATTRIBUTE7,
1049 ATTRIBUTE8 = X_ATTRIBUTE8,
1050 ATTRIBUTE9 = X_ATTRIBUTE9,
1051 ATTRIBUTE10 = X_ATTRIBUTE10,
1052 ATTRIBUTE11 = X_ATTRIBUTE11,
1053 ATTRIBUTE12 = X_ATTRIBUTE12,
1054 ATTRIBUTE13 = X_ATTRIBUTE13,
1055 ATTRIBUTE14 = X_ATTRIBUTE14,
1056 ATTRIBUTE15 = X_ATTRIBUTE15,
1057 SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
1058 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1059 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1060 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1061 REQUEST_CLASS = X_REQUEST_CLASS
1062 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
1063
1064 if (sql%notfound) then
1065 raise no_data_found;
1066 end if;
1067
1068 update OZF_REQUEST_HEADERS_ALL_TL set
1069 REQUEST_NAME = X_REQUEST_NAME,
1070 REQUEST_DESCRIPTION = X_REQUEST_DESCRIPTION,
1071 COMMENTS = X_COMMENTS,
1072 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1073 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1074 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1075 SOURCE_LANG = userenv('LANG')
1076 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
1077 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1078
1079 if (sql%notfound) then
1080 raise no_data_found;
1081 end if;
1082 end UPDATE_ROW;
1083
1084 procedure DELETE_ROW (
1085 X_REQUEST_HEADER_ID in NUMBER
1086 ) is
1087 begin
1088 delete from OZF_REQUEST_HEADERS_ALL_TL
1089 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
1090
1091 if (sql%notfound) then
1092 raise no_data_found;
1093 end if;
1094
1095 delete from OZF_REQUEST_HEADERS_ALL_B
1096 where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
1097
1098 if (sql%notfound) then
1099 raise no_data_found;
1100 end if;
1101 end DELETE_ROW;
1102
1103 procedure ADD_LANGUAGE
1104 is
1105 begin
1106 delete from OZF_REQUEST_HEADERS_ALL_TL T
1107 where not exists
1108 (select NULL
1109 from OZF_REQUEST_HEADERS_ALL_B B
1110 where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
1111 );
1112
1113 update OZF_REQUEST_HEADERS_ALL_TL T set (
1114 REQUEST_NAME,
1115 REQUEST_DESCRIPTION,COMMENTS
1116 ) = (select
1117 B.REQUEST_NAME,
1118 B.REQUEST_DESCRIPTION,B.COMMENTS
1119 from OZF_REQUEST_HEADERS_ALL_TL B
1120 where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
1121 and B.LANGUAGE = T.SOURCE_LANG)
1122 where (
1123 T.REQUEST_HEADER_ID,
1124 T.LANGUAGE
1125 ) in (select
1126 SUBT.REQUEST_HEADER_ID,
1127 SUBT.LANGUAGE
1128 from OZF_REQUEST_HEADERS_ALL_TL SUBB, OZF_REQUEST_HEADERS_ALL_TL SUBT
1129 where SUBB.REQUEST_HEADER_ID = SUBT.REQUEST_HEADER_ID
1130 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1131 and (SUBB.REQUEST_NAME <> SUBT.REQUEST_NAME
1132 or (SUBB.REQUEST_NAME is null and SUBT.REQUEST_NAME is not null)
1133 or (SUBB.REQUEST_NAME is not null and SUBT.REQUEST_NAME is null)
1134 or SUBB.REQUEST_DESCRIPTION <> SUBT.REQUEST_DESCRIPTION
1135 or (SUBB.REQUEST_DESCRIPTION is null and SUBT.REQUEST_DESCRIPTION is not null)
1136 or (SUBB.REQUEST_DESCRIPTION is not null and SUBT.REQUEST_DESCRIPTION is null)
1137 or SUBB.COMMENTS <> SUBT.COMMENTS
1138 or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
1139 or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
1140 ));
1141
1142 insert into OZF_REQUEST_HEADERS_ALL_TL (
1143 REQUEST_HEADER_ID,
1144 LAST_UPDATE_DATE,
1145 LAST_UPDATED_BY,
1146 CREATION_DATE,
1147 CREATED_BY,
1148 LAST_UPDATE_LOGIN,
1149 REQUEST_NAME,
1150 REQUEST_DESCRIPTION,
1151 COMMENTS,
1152 SECURITY_GROUP_ID,
1153 LANGUAGE,
1154 SOURCE_LANG
1155 ) select /*+ ORDERED */
1156 B.REQUEST_HEADER_ID,
1157 B.LAST_UPDATE_DATE,
1158 B.LAST_UPDATED_BY,
1159 B.CREATION_DATE,
1160 B.CREATED_BY,
1161 B.LAST_UPDATE_LOGIN,
1162 B.REQUEST_NAME,
1163 B.REQUEST_DESCRIPTION,
1164 B.COMMENTS,
1165 B.SECURITY_GROUP_ID,
1166 L.LANGUAGE_CODE,
1167 B.SOURCE_LANG
1171 and not exists
1168 from OZF_REQUEST_HEADERS_ALL_TL B, FND_LANGUAGES L
1169 where L.INSTALLED_FLAG in ('I', 'B')
1170 and B.LANGUAGE = userenv('LANG')
1172 (select NULL
1173 from OZF_REQUEST_HEADERS_ALL_TL T
1174 where T.REQUEST_HEADER_ID = B.REQUEST_HEADER_ID
1175 and T.LANGUAGE = L.LANGUAGE_CODE);
1176 end ADD_LANGUAGE;
1177
1178 end OZF_REQUEST_HEADERS_ALL_PKG;