[Home] [Help]
PACKAGE BODY: APPS.ORG_FREIGHT_TL_PKG
Source
1 package body ORG_FREIGHT_TL_PKG as
2 /* $Header: INVORFCB.pls 120.1 2005/06/17 17:10:47 appldev $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_FREIGHT_CODE in VARCHAR2,
6 X_FREIGHT_CODE_TL in VARCHAR2,
7 X_ORGANIZATION_ID in NUMBER,
8 X_DISABLE_DATE in DATE,
9 X_DISTRIBUTION_ACCOUNT in NUMBER,
10 X_ATTRIBUTE_CATEGORY in VARCHAR2,
11 X_ATTRIBUTE1 in VARCHAR2,
12 X_ATTRIBUTE2 in VARCHAR2,
13 X_ATTRIBUTE3 in VARCHAR2,
14 X_ATTRIBUTE4 in VARCHAR2,
15 X_ATTRIBUTE5 in VARCHAR2,
16 X_ATTRIBUTE6 in VARCHAR2,
17 X_ATTRIBUTE7 in VARCHAR2,
18 X_ATTRIBUTE8 in VARCHAR2,
19 X_ATTRIBUTE9 in VARCHAR2,
20 X_ATTRIBUTE10 in VARCHAR2,
21 X_ATTRIBUTE11 in VARCHAR2,
22 X_ATTRIBUTE12 in VARCHAR2,
23 X_ATTRIBUTE13 in VARCHAR2,
24 X_ATTRIBUTE14 in VARCHAR2,
25 X_ATTRIBUTE15 in VARCHAR2,
26 X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
27 X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
28 X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
29 X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
30 X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
31 X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
32 X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
33 X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
34 X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
35 X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
36 X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
37 X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
38 X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
39 X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
40 X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
41 X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
42 X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
43 X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
44 X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
45 X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
46 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
47 X_DESCRIPTION in VARCHAR2,
48 X_CREATION_DATE in DATE,
49 X_CREATED_BY in NUMBER,
50 X_LAST_UPDATE_DATE in DATE,
51 X_LAST_UPDATED_BY in NUMBER,
52 X_LAST_UPDATE_LOGIN in NUMBER
53 ) is
54 cursor C is select ROWID from ORG_FREIGHT_TL
55 where FREIGHT_CODE = X_FREIGHT_CODE
56 and ORGANIZATION_ID = X_ORGANIZATION_ID
57 and LANGUAGE = userenv('LANG')
58 ;
59 begin
60 insert into ORG_FREIGHT_TL (
61 FREIGHT_CODE,
62 FREIGHT_CODE_TL,
63 ORGANIZATION_ID,
64 LAST_UPDATE_DATE,
65 LAST_UPDATED_BY,
66 CREATION_DATE,
67 CREATED_BY,
68 LAST_UPDATE_LOGIN,
69 DESCRIPTION,
70 DISABLE_DATE,
71 DISTRIBUTION_ACCOUNT,
72 ATTRIBUTE_CATEGORY,
73 ATTRIBUTE1,
74 ATTRIBUTE2,
75 ATTRIBUTE3,
76 ATTRIBUTE4,
77 ATTRIBUTE5,
78 ATTRIBUTE6,
79 ATTRIBUTE7,
80 ATTRIBUTE8,
81 ATTRIBUTE9,
82 ATTRIBUTE10,
83 ATTRIBUTE11,
84 ATTRIBUTE12,
85 ATTRIBUTE13,
86 ATTRIBUTE14,
87 ATTRIBUTE15,
88 GLOBAL_ATTRIBUTE1,
89 GLOBAL_ATTRIBUTE2,
90 GLOBAL_ATTRIBUTE3,
91 GLOBAL_ATTRIBUTE4,
92 GLOBAL_ATTRIBUTE5,
93 GLOBAL_ATTRIBUTE6,
94 GLOBAL_ATTRIBUTE7,
95 GLOBAL_ATTRIBUTE8,
96 GLOBAL_ATTRIBUTE9,
97 GLOBAL_ATTRIBUTE10,
98 GLOBAL_ATTRIBUTE11,
99 GLOBAL_ATTRIBUTE12,
100 GLOBAL_ATTRIBUTE13,
101 GLOBAL_ATTRIBUTE14,
102 GLOBAL_ATTRIBUTE15,
103 GLOBAL_ATTRIBUTE16,
104 GLOBAL_ATTRIBUTE17,
105 GLOBAL_ATTRIBUTE18,
106 GLOBAL_ATTRIBUTE19,
107 GLOBAL_ATTRIBUTE20,
108 GLOBAL_ATTRIBUTE_CATEGORY,
109 LANGUAGE,
110 SOURCE_LANG
111 ) select
112 X_FREIGHT_CODE,
113 X_FREIGHT_CODE_TL,
114 X_ORGANIZATION_ID,
115 X_LAST_UPDATE_DATE,
116 X_LAST_UPDATED_BY,
117 X_CREATION_DATE,
118 X_CREATED_BY,
119 X_LAST_UPDATE_LOGIN,
120 X_DESCRIPTION,
121 X_DISABLE_DATE,
122 X_DISTRIBUTION_ACCOUNT,
123 X_ATTRIBUTE_CATEGORY,
124 X_ATTRIBUTE1,
125 X_ATTRIBUTE2,
126 X_ATTRIBUTE3,
127 X_ATTRIBUTE4,
128 X_ATTRIBUTE5,
129 X_ATTRIBUTE6,
130 X_ATTRIBUTE7,
131 X_ATTRIBUTE8,
132 X_ATTRIBUTE9,
133 X_ATTRIBUTE10,
134 X_ATTRIBUTE11,
135 X_ATTRIBUTE12,
136 X_ATTRIBUTE13,
137 X_ATTRIBUTE14,
138 X_ATTRIBUTE15,
139 X_GLOBAL_ATTRIBUTE1,
140 X_GLOBAL_ATTRIBUTE2,
141 X_GLOBAL_ATTRIBUTE3,
142 X_GLOBAL_ATTRIBUTE4,
143 X_GLOBAL_ATTRIBUTE5,
144 X_GLOBAL_ATTRIBUTE6,
145 X_GLOBAL_ATTRIBUTE7,
146 X_GLOBAL_ATTRIBUTE8,
147 X_GLOBAL_ATTRIBUTE9,
148 X_GLOBAL_ATTRIBUTE10,
149 X_GLOBAL_ATTRIBUTE11,
150 X_GLOBAL_ATTRIBUTE12,
151 X_GLOBAL_ATTRIBUTE13,
152 X_GLOBAL_ATTRIBUTE14,
153 X_GLOBAL_ATTRIBUTE15,
154 X_GLOBAL_ATTRIBUTE16,
155 X_GLOBAL_ATTRIBUTE17,
156 X_GLOBAL_ATTRIBUTE18,
157 X_GLOBAL_ATTRIBUTE19,
158 X_GLOBAL_ATTRIBUTE20,
159 X_GLOBAL_ATTRIBUTE_CATEGORY,
160 L.LANGUAGE_CODE,
161 userenv('LANG')
162 from FND_LANGUAGES L
163 where L.INSTALLED_FLAG in ('I', 'B')
164 and not exists
165 (select NULL
166 from ORG_FREIGHT_TL T
167 where T.FREIGHT_CODE = X_FREIGHT_CODE
168 and T.ORGANIZATION_ID = X_ORGANIZATION_ID
169 and T.LANGUAGE = L.LANGUAGE_CODE);
170
171 open c;
172 fetch c into X_ROWID;
173 if (c%notfound) then
174 close c;
175 raise no_data_found;
176 end if;
177 close c;
178
179 end INSERT_ROW;
180
181 procedure LOCK_ROW (
182 X_FREIGHT_CODE in VARCHAR2,
183 X_FREIGHT_CODE_TL in VARCHAR2,
184 X_ORGANIZATION_ID in NUMBER,
185 X_DISABLE_DATE in DATE,
186 X_DISTRIBUTION_ACCOUNT in NUMBER,
187 X_ATTRIBUTE_CATEGORY in VARCHAR2,
188 X_ATTRIBUTE1 in VARCHAR2,
189 X_ATTRIBUTE2 in VARCHAR2,
190 X_ATTRIBUTE3 in VARCHAR2,
191 X_ATTRIBUTE4 in VARCHAR2,
192 X_ATTRIBUTE5 in VARCHAR2,
193 X_ATTRIBUTE6 in VARCHAR2,
194 X_ATTRIBUTE7 in VARCHAR2,
195 X_ATTRIBUTE8 in VARCHAR2,
196 X_ATTRIBUTE9 in VARCHAR2,
197 X_ATTRIBUTE10 in VARCHAR2,
198 X_ATTRIBUTE11 in VARCHAR2,
199 X_ATTRIBUTE12 in VARCHAR2,
200 X_ATTRIBUTE13 in VARCHAR2,
201 X_ATTRIBUTE14 in VARCHAR2,
202 X_ATTRIBUTE15 in VARCHAR2,
203 X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
204 X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
205 X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
206 X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
207 X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
208 X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
209 X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
210 X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
211 X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
212 X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
213 X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
214 X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
215 X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
216 X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
217 X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
218 X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
219 X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
220 X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
221 X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
222 X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
223 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
224 X_DESCRIPTION in VARCHAR2
225 ) AS
226 cursor c1 is select
227 DISABLE_DATE,
228 DISTRIBUTION_ACCOUNT,
229 ATTRIBUTE_CATEGORY,
230 ATTRIBUTE1,
231 ATTRIBUTE2,
232 ATTRIBUTE3,
233 ATTRIBUTE4,
234 ATTRIBUTE5,
235 ATTRIBUTE6,
236 ATTRIBUTE7,
237 ATTRIBUTE8,
238 ATTRIBUTE9,
239 ATTRIBUTE10,
240 ATTRIBUTE11,
241 ATTRIBUTE12,
242 ATTRIBUTE13,
243 ATTRIBUTE14,
244 ATTRIBUTE15,
245 GLOBAL_ATTRIBUTE1,
246 GLOBAL_ATTRIBUTE2,
247 GLOBAL_ATTRIBUTE3,
248 GLOBAL_ATTRIBUTE4,
249 GLOBAL_ATTRIBUTE5,
250 GLOBAL_ATTRIBUTE6,
251 GLOBAL_ATTRIBUTE7,
252 GLOBAL_ATTRIBUTE8,
253 GLOBAL_ATTRIBUTE9,
254 GLOBAL_ATTRIBUTE10,
255 GLOBAL_ATTRIBUTE11,
256 GLOBAL_ATTRIBUTE12,
257 GLOBAL_ATTRIBUTE13,
258 GLOBAL_ATTRIBUTE14,
259 GLOBAL_ATTRIBUTE15,
260 GLOBAL_ATTRIBUTE16,
261 GLOBAL_ATTRIBUTE17,
262 GLOBAL_ATTRIBUTE18,
263 GLOBAL_ATTRIBUTE19,
264 GLOBAL_ATTRIBUTE20,
265 GLOBAL_ATTRIBUTE_CATEGORY,
266 DESCRIPTION,
267 FREIGHT_CODE,
268 FREIGHT_CODE_TL,
269 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
270 from ORG_FREIGHT_TL
271 where FREIGHT_CODE = X_FREIGHT_CODE
272 and ORGANIZATION_ID = X_ORGANIZATION_ID
273 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
274 for update of FREIGHT_CODE nowait;
275 begin
276 for tlinfo in c1 loop
277 if (tlinfo.BASELANG = 'Y') then
278 if ( ((tlinfo.DESCRIPTION = X_DESCRIPTION)
279 OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
280 AND ((tlinfo.FREIGHT_CODE_TL = X_FREIGHT_CODE_TL)
281 OR ((tlinfo.FREIGHT_CODE_TL is null) AND (X_FREIGHT_CODE_TL is null)))
282 AND ((tlinfo.DISABLE_DATE = X_DISABLE_DATE)
283 OR ((tlinfo.DISABLE_DATE is null) AND (X_DISABLE_DATE is null)))
284 AND ((tlinfo.DISTRIBUTION_ACCOUNT = X_DISTRIBUTION_ACCOUNT)
285 OR ((tlinfo.DISTRIBUTION_ACCOUNT is null) AND (X_DISTRIBUTION_ACCOUNT is null)))
286 AND ((tlinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
287 OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
288 AND ((tlinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
289 OR ((tlinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
290 AND ((tlinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
291 OR ((tlinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
292 AND ((tlinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
293 OR ((tlinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
294 AND ((tlinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
295 OR ((tlinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
296 AND ((tlinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
297 OR ((tlinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
298 AND ((tlinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
299 OR ((tlinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
300 AND ((tlinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
301 OR ((tlinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
302 AND ((tlinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
303 OR ((tlinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
304 AND ((tlinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
305 OR ((tlinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
306 AND ((tlinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
307 OR ((tlinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
308 AND ((tlinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
309 OR ((tlinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
310 AND ((tlinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
311 OR ((tlinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
312 AND ((tlinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
313 OR ((tlinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
314 AND ((tlinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
315 OR ((tlinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
316 AND ((tlinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
317 OR ((tlinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
318 AND ((tlinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1)
319 OR ((tlinfo.GLOBAL_ATTRIBUTE1 is null) AND (X_GLOBAL_ATTRIBUTE1 is null)))
320 AND ((tlinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2)
321 OR ((tlinfo.GLOBAL_ATTRIBUTE2 is null) AND (X_GLOBAL_ATTRIBUTE2 is null)))
322 AND ((tlinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3)
323 OR ((tlinfo.GLOBAL_ATTRIBUTE3 is null) AND (X_GLOBAL_ATTRIBUTE3 is null)))
324 AND ((tlinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4)
325 OR ((tlinfo.GLOBAL_ATTRIBUTE4 is null) AND (X_GLOBAL_ATTRIBUTE4 is null)))
326 AND ((tlinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5)
327 OR ((tlinfo.GLOBAL_ATTRIBUTE5 is null) AND (X_GLOBAL_ATTRIBUTE5 is null)))
328 AND ((tlinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6)
329 OR ((tlinfo.GLOBAL_ATTRIBUTE6 is null) AND (X_GLOBAL_ATTRIBUTE6 is null)))
330 AND ((tlinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7)
331 OR ((tlinfo.GLOBAL_ATTRIBUTE7 is null) AND (X_GLOBAL_ATTRIBUTE7 is null)))
332 AND ((tlinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8)
333 OR ((tlinfo.GLOBAL_ATTRIBUTE8 is null) AND (X_GLOBAL_ATTRIBUTE8 is null)))
334 AND ((tlinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9)
335 OR ((tlinfo.GLOBAL_ATTRIBUTE9 is null) AND (X_GLOBAL_ATTRIBUTE9 is null)))
336 AND ((tlinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10)
337 OR ((tlinfo.GLOBAL_ATTRIBUTE10 is null) AND (X_GLOBAL_ATTRIBUTE10 is null)))
338 AND ((tlinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11)
339 OR ((tlinfo.GLOBAL_ATTRIBUTE11 is null) AND (X_GLOBAL_ATTRIBUTE11 is null)))
340 AND ((tlinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12)
341 OR ((tlinfo.GLOBAL_ATTRIBUTE12 is null) AND (X_GLOBAL_ATTRIBUTE12 is null)))
342 AND ((tlinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13)
343 OR ((tlinfo.GLOBAL_ATTRIBUTE13 is null) AND (X_GLOBAL_ATTRIBUTE13 is null)))
344 AND ((tlinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14)
345 OR ((tlinfo.GLOBAL_ATTRIBUTE14 is null) AND (X_GLOBAL_ATTRIBUTE14 is null)))
346 AND ((tlinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15)
347 OR ((tlinfo.GLOBAL_ATTRIBUTE15 is null) AND (X_GLOBAL_ATTRIBUTE15 is null)))
348 AND ((tlinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16)
349 OR ((tlinfo.GLOBAL_ATTRIBUTE16 is null) AND (X_GLOBAL_ATTRIBUTE16 is null)))
350 AND ((tlinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17)
351 OR ((tlinfo.GLOBAL_ATTRIBUTE17 is null) AND (X_GLOBAL_ATTRIBUTE17 is null)))
352 AND ((tlinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18)
353 OR ((tlinfo.GLOBAL_ATTRIBUTE18 is null) AND (X_GLOBAL_ATTRIBUTE18 is null)))
354 AND ((tlinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19)
355 OR ((tlinfo.GLOBAL_ATTRIBUTE19 is null) AND (X_GLOBAL_ATTRIBUTE19 is null)))
356 AND ((tlinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20)
357 OR ((tlinfo.GLOBAL_ATTRIBUTE20 is null) AND (X_GLOBAL_ATTRIBUTE20 is null)))
358 AND ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY)
359 OR ((tlinfo.GLOBAL_ATTRIBUTE_CATEGORY is null) AND (X_GLOBAL_ATTRIBUTE_CATEGORY is null)))
360 ) then
361 null;
362 else
363 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
364 app_exception.raise_exception;
365 end if;
366 end if;
367 end loop;
368 return;
369 end LOCK_ROW;
370
371 procedure UPDATE_ROW (
372 X_FREIGHT_CODE in VARCHAR2,
373 X_FREIGHT_CODE_TL in VARCHAR2,
374 X_ORGANIZATION_ID in NUMBER,
375 X_DISABLE_DATE in DATE,
376 X_DISTRIBUTION_ACCOUNT in NUMBER,
377 X_ATTRIBUTE_CATEGORY in VARCHAR2,
378 X_ATTRIBUTE1 in VARCHAR2,
379 X_ATTRIBUTE2 in VARCHAR2,
380 X_ATTRIBUTE3 in VARCHAR2,
381 X_ATTRIBUTE4 in VARCHAR2,
382 X_ATTRIBUTE5 in VARCHAR2,
383 X_ATTRIBUTE6 in VARCHAR2,
384 X_ATTRIBUTE7 in VARCHAR2,
385 X_ATTRIBUTE8 in VARCHAR2,
386 X_ATTRIBUTE9 in VARCHAR2,
387 X_ATTRIBUTE10 in VARCHAR2,
388 X_ATTRIBUTE11 in VARCHAR2,
389 X_ATTRIBUTE12 in VARCHAR2,
390 X_ATTRIBUTE13 in VARCHAR2,
391 X_ATTRIBUTE14 in VARCHAR2,
392 X_ATTRIBUTE15 in VARCHAR2,
393 X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
394 X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
395 X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
396 X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
397 X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
398 X_GLOBAL_ATTRIBUTE6 in VARCHAR2,
399 X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
400 X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
401 X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
402 X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
403 X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
404 X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
405 X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
406 X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
407 X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
408 X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
409 X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
410 X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
411 X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
412 X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
413 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
414 X_DESCRIPTION in VARCHAR2,
415 X_LAST_UPDATE_DATE in DATE,
416 X_LAST_UPDATED_BY in NUMBER,
417 X_LAST_UPDATE_LOGIN in NUMBER
418 ) as
419 begin
420 update ORG_FREIGHT_TL set
421 DISABLE_DATE = X_DISABLE_DATE,
422 DISTRIBUTION_ACCOUNT = X_DISTRIBUTION_ACCOUNT,
423 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
424 ATTRIBUTE1 = X_ATTRIBUTE1,
425 ATTRIBUTE2 = X_ATTRIBUTE2,
426 ATTRIBUTE3 = X_ATTRIBUTE3,
427 ATTRIBUTE4 = X_ATTRIBUTE4,
428 ATTRIBUTE5 = X_ATTRIBUTE5,
429 ATTRIBUTE6 = X_ATTRIBUTE6,
430 ATTRIBUTE7 = X_ATTRIBUTE7,
431 ATTRIBUTE8 = X_ATTRIBUTE8,
432 ATTRIBUTE9 = X_ATTRIBUTE9,
433 ATTRIBUTE10 = X_ATTRIBUTE10,
434 ATTRIBUTE11 = X_ATTRIBUTE11,
435 ATTRIBUTE12 = X_ATTRIBUTE12,
436 ATTRIBUTE13 = X_ATTRIBUTE13,
437 ATTRIBUTE14 = X_ATTRIBUTE14,
438 ATTRIBUTE15 = X_ATTRIBUTE15,
439 GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
440 GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
441 GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
442 GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
443 GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
444 GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
445 GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
446 GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
447 GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
448 GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
449 GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
450 GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
451 GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
452 GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
453 GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
454 GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
455 GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
456 GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
457 GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
458 GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
459 GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
460 DESCRIPTION = X_DESCRIPTION,
461 FREIGHT_CODE_TL = X_FREIGHT_CODE_TL,
462 FREIGHT_CODE = X_FREIGHT_CODE_TL,
463 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
464 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
465 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
466 SOURCE_LANG = userenv('LANG')
467 where FREIGHT_CODE = X_FREIGHT_CODE
468 and ORGANIZATION_ID = X_ORGANIZATION_ID
469 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
470
471 -- Bug 1909262 . To ensure that when updating freight_code_tl,freight_code
472 -- should also have the same value . Setting Freight_code = x_freight_code_tl .
473 if (sql%notfound) then
474 raise no_data_found;
475 end if;
476 end UPDATE_ROW;
477
478 procedure DELETE_ROW (
479 X_FREIGHT_CODE in VARCHAR2,
480 X_ORGANIZATION_ID in NUMBER
481 ) as
482 begin
483 delete from ORG_FREIGHT_TL
484 where FREIGHT_CODE = X_FREIGHT_CODE
485 and ORGANIZATION_ID = X_ORGANIZATION_ID;
486
487 if (sql%notfound) then
488 raise no_data_found;
489 end if;
490
491 end DELETE_ROW;
492
493 procedure ADD_LANGUAGE
494 as
495 begin
496 update ORG_FREIGHT_TL T set (
497 DESCRIPTION,
498 FREIGHT_CODE_TL
499 ) = (select
500 B.DESCRIPTION,
501 B.FREIGHT_CODE
502 from ORG_FREIGHT_TL B
503 where B.FREIGHT_CODE = T.FREIGHT_CODE
504 and B.ORGANIZATION_ID = T.ORGANIZATION_ID
505 and B.LANGUAGE = T.SOURCE_LANG)
506 where (
507 T.FREIGHT_CODE_TL,
508 T.FREIGHT_CODE,
509 T.ORGANIZATION_ID,
510 T.LANGUAGE
511 ) in (select
512 SUBT.FREIGHT_CODE_TL,
513 SUBT.FREIGHT_CODE,
514 SUBT.ORGANIZATION_ID,
515 SUBT.LANGUAGE
516 from ORG_FREIGHT_TL SUBB, ORG_FREIGHT_TL SUBT
517 where SUBB.FREIGHT_CODE = SUBT.FREIGHT_CODE
518 and SUBB.ORGANIZATION_ID = SUBT.ORGANIZATION_ID
519 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
520 and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
521 or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
522 or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
523 or SUBB.FREIGHT_CODE <> SUBT.FREIGHT_CODE
524 ));
525
526 insert into ORG_FREIGHT_TL (
527 FREIGHT_CODE_TL,
528 FREIGHT_CODE,
529 ORGANIZATION_ID,
530 LAST_UPDATE_DATE,
531 LAST_UPDATED_BY,
532 CREATION_DATE,
533 CREATED_BY,
534 LAST_UPDATE_LOGIN,
535 DESCRIPTION,
536 DISABLE_DATE,
537 DISTRIBUTION_ACCOUNT,
538 ATTRIBUTE_CATEGORY,
539 ATTRIBUTE1,
540 ATTRIBUTE2,
541 ATTRIBUTE3,
542 ATTRIBUTE4,
543 ATTRIBUTE5,
544 ATTRIBUTE6,
545 ATTRIBUTE7,
546 ATTRIBUTE8,
547 ATTRIBUTE9,
548 ATTRIBUTE10,
549 ATTRIBUTE11,
550 ATTRIBUTE12,
551 ATTRIBUTE13,
552 ATTRIBUTE14,
553 ATTRIBUTE15,
554 GLOBAL_ATTRIBUTE1,
555 GLOBAL_ATTRIBUTE2,
556 GLOBAL_ATTRIBUTE3,
557 GLOBAL_ATTRIBUTE4,
558 GLOBAL_ATTRIBUTE5,
559 GLOBAL_ATTRIBUTE6,
560 GLOBAL_ATTRIBUTE7,
561 GLOBAL_ATTRIBUTE8,
562 GLOBAL_ATTRIBUTE9,
563 GLOBAL_ATTRIBUTE10,
564 GLOBAL_ATTRIBUTE11,
565 GLOBAL_ATTRIBUTE12,
566 GLOBAL_ATTRIBUTE13,
567 GLOBAL_ATTRIBUTE14,
568 GLOBAL_ATTRIBUTE15,
569 GLOBAL_ATTRIBUTE16,
570 GLOBAL_ATTRIBUTE17,
571 GLOBAL_ATTRIBUTE18,
572 GLOBAL_ATTRIBUTE19,
573 GLOBAL_ATTRIBUTE20,
574 GLOBAL_ATTRIBUTE_CATEGORY,
575 LANGUAGE,
576 SOURCE_LANG
577 ) select
578 B.FREIGHT_CODE_TL,
579 B.FREIGHT_CODE,
580 B.ORGANIZATION_ID,
581 B.LAST_UPDATE_DATE,
582 B.LAST_UPDATED_BY,
583 B.CREATION_DATE,
584 B.CREATED_BY,
585 B.LAST_UPDATE_LOGIN,
586 B.DESCRIPTION,
587 B.DISABLE_DATE,
588 B.DISTRIBUTION_ACCOUNT,
589 B.ATTRIBUTE_CATEGORY,
590 B.ATTRIBUTE1,
591 B.ATTRIBUTE2,
592 B.ATTRIBUTE3,
593 B.ATTRIBUTE4,
594 B.ATTRIBUTE5,
595 B.ATTRIBUTE6,
596 B.ATTRIBUTE7,
597 B.ATTRIBUTE8,
598 B.ATTRIBUTE9,
599 B.ATTRIBUTE10,
600 B.ATTRIBUTE11,
601 B.ATTRIBUTE12,
602 B.ATTRIBUTE13,
603 B.ATTRIBUTE14,
604 B.ATTRIBUTE15,
605 B.GLOBAL_ATTRIBUTE1,
606 B.GLOBAL_ATTRIBUTE2,
607 B.GLOBAL_ATTRIBUTE3,
608 B.GLOBAL_ATTRIBUTE4,
609 B.GLOBAL_ATTRIBUTE5,
610 B.GLOBAL_ATTRIBUTE6,
611 B.GLOBAL_ATTRIBUTE7,
612 B.GLOBAL_ATTRIBUTE8,
613 B.GLOBAL_ATTRIBUTE9,
614 B.GLOBAL_ATTRIBUTE10,
615 B.GLOBAL_ATTRIBUTE11,
616 B.GLOBAL_ATTRIBUTE12,
617 B.GLOBAL_ATTRIBUTE13,
618 B.GLOBAL_ATTRIBUTE14,
619 B.GLOBAL_ATTRIBUTE15,
620 B.GLOBAL_ATTRIBUTE16,
621 B.GLOBAL_ATTRIBUTE17,
622 B.GLOBAL_ATTRIBUTE18,
623 B.GLOBAL_ATTRIBUTE19,
624 B.GLOBAL_ATTRIBUTE20,
625 B.GLOBAL_ATTRIBUTE_CATEGORY,
626 L.LANGUAGE_CODE,
627 B.SOURCE_LANG
628 from ORG_FREIGHT_TL B, FND_LANGUAGES L
629 where L.INSTALLED_FLAG in ('I', 'B')
630 and B.LANGUAGE = userenv('LANG')
631 and not exists
632 (select NULL
633 from ORG_FREIGHT_TL T
634 where T.FREIGHT_CODE = B.FREIGHT_CODE
635 and T.ORGANIZATION_ID = B.ORGANIZATION_ID
636 and T.LANGUAGE = L.LANGUAGE_CODE);
637 end ADD_LANGUAGE;
638
639 procedure LOAD_ROW(
640 X_FREIGHT_CODE in VARCHAR2,
641 X_ORGANIZATION_CODE in VARCHAR2,
642 X_OWNER in VARCHAR2,
643 X_FREIGHT_CODE_TL in VARCHAR2,
644 X_DISABLE_DATE in DATE,
645 X_DISTRIBUTION_ACCOUNT in NUMBER,
646 X_ATTRIBUTE_CATEGORY in VARCHAR2,
647 X_ATTRIBUTE1 in VARCHAR2,
648 X_ATTRIBUTE2 in VARCHAR2,
649 X_ATTRIBUTE3 in VARCHAR2,
650 X_ATTRIBUTE4 in VARCHAR2,
651 X_ATTRIBUTE5 in VARCHAR2,
652 X_ATTRIBUTE6 in VARCHAR2,
653 X_ATTRIBUTE7 in VARCHAR2,
654 X_ATTRIBUTE8 in VARCHAR2,
655 X_ATTRIBUTE9 in VARCHAR2,
656 X_ATTRIBUTE10 in VARCHAR2,
657 X_ATTRIBUTE11 in VARCHAR2,
658 X_ATTRIBUTE12 in VARCHAR2,
659 X_ATTRIBUTE13 in VARCHAR2,
660 X_ATTRIBUTE14 in VARCHAR2,
661 X_ATTRIBUTE15 in VARCHAR2,
662 X_GLOBAL_ATTRIBUTE1 in VARCHAR2,
663 X_GLOBAL_ATTRIBUTE2 in VARCHAR2,
664 X_GLOBAL_ATTRIBUTE3 in VARCHAR2,
665 X_GLOBAL_ATTRIBUTE4 in VARCHAR2,
666 X_GLOBAL_ATTRIBUTE5 in VARCHAR2,
667 x_GLOBAL_ATTRIBUTE6 in VARCHAR2,
668 X_GLOBAL_ATTRIBUTE7 in VARCHAR2,
669 X_GLOBAL_ATTRIBUTE8 in VARCHAR2,
670 X_GLOBAL_ATTRIBUTE9 in VARCHAR2,
671 X_GLOBAL_ATTRIBUTE10 in VARCHAR2,
672 X_GLOBAL_ATTRIBUTE11 in VARCHAR2,
673 X_GLOBAL_ATTRIBUTE12 in VARCHAR2,
674 X_GLOBAL_ATTRIBUTE13 in VARCHAR2,
675 X_GLOBAL_ATTRIBUTE14 in VARCHAR2,
676 X_GLOBAL_ATTRIBUTE15 in VARCHAR2,
677 X_GLOBAL_ATTRIBUTE16 in VARCHAR2,
678 X_GLOBAL_ATTRIBUTE17 in VARCHAR2,
679 X_GLOBAL_ATTRIBUTE18 in VARCHAR2,
680 X_GLOBAL_ATTRIBUTE19 in VARCHAR2,
681 X_GLOBAL_ATTRIBUTE20 in VARCHAR2,
682 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2,
683 X_DESCRIPTION in VARCHAR2,
684 X_LAST_UPDATE_DATE in DATE,
685 X_LAST_UPDATED_BY in NUMBER,
686 X_LAST_UPDATE_LOGIN in NUMBER)
687 as
688 row_id varchar2(64);
689 user_id NUMBER;
690 org_id NUMBER;
691 begin
692 if( X_OWNER = 'SEED') then
693 user_id := 1;
694 end if;
695
696 -- fix bug 1858065 for performance issue
697 -- Use mtl_parameters instead of mtl_organizations
698 select organization_id
699 into org_id
700 from mtl_parameters
701 where organization_code = X_ORGANIZATION_CODE;
702
703 org_freight_tl_pkg.Update_row(
704 X_FREIGHT_CODE => X_FREIGHT_CODE,
705 X_FREIGHT_CODE_TL => X_FREIGHT_CODE_TL,
706 X_ORGANIZATION_ID => org_id,
707 X_DISABLE_DATE => X_DISABLE_DATE,
708 X_DISTRIBUTION_ACCOUNT => X_DISTRIBUTION_ACCOUNT,
709 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
710 X_ATTRIBUTE1 => X_ATTRIBUTE1,
711 X_ATTRIBUTE2 => X_ATTRIBUTE2,
712 X_ATTRIBUTE3 => X_ATTRIBUTE3,
713 X_ATTRIBUTE4 => X_ATTRIBUTE4,
714 X_ATTRIBUTE5 => X_ATTRIBUTE5,
715 X_ATTRIBUTE6 => X_ATTRIBUTE6,
716 X_ATTRIBUTE7 => X_ATTRIBUTE7,
717 X_ATTRIBUTE8 => X_ATTRIBUTE8,
718 X_ATTRIBUTE9 => X_ATTRIBUTE9,
719 X_ATTRIBUTE10 => X_ATTRIBUTE10,
720 X_ATTRIBUTE11 => X_ATTRIBUTE11,
721 X_ATTRIBUTE12 => X_ATTRIBUTE12,
722 X_ATTRIBUTE13 => X_ATTRIBUTE13,
723 X_ATTRIBUTE14 => X_ATTRIBUTE14,
724 X_ATTRIBUTE15 => X_ATTRIBUTE15,
725 X_GLOBAL_ATTRIBUTE1 => X_GLOBAL_ATTRIBUTE1,
726 X_GLOBAL_ATTRIBUTE2 => X_GLOBAL_ATTRIBUTE2,
727 X_GLOBAL_ATTRIBUTE3 => X_GLOBAL_ATTRIBUTE3,
728 X_GLOBAL_ATTRIBUTE4 => X_GLOBAL_ATTRIBUTE4,
729 X_GLOBAL_ATTRIBUTE5 => X_GLOBAL_ATTRIBUTE5,
730 X_GLOBAL_ATTRIBUTE6 => X_GLOBAL_ATTRIBUTE6,
731 X_GLOBAL_ATTRIBUTE7 => X_GLOBAL_ATTRIBUTE7,
732 X_GLOBAL_ATTRIBUTE8 => X_GLOBAL_ATTRIBUTE8,
733 X_GLOBAL_ATTRIBUTE9 => X_GLOBAL_ATTRIBUTE9,
734 X_GLOBAL_ATTRIBUTE10 => X_GLOBAL_ATTRIBUTE10,
735 X_GLOBAL_ATTRIBUTE11 => X_GLOBAL_ATTRIBUTE11,
736 X_GLOBAL_ATTRIBUTE12 => X_GLOBAL_ATTRIBUTE12,
737 X_GLOBAL_ATTRIBUTE13 => X_GLOBAL_ATTRIBUTE13,
738 X_GLOBAL_ATTRIBUTE14 => X_GLOBAL_ATTRIBUTE14,
739 X_GLOBAL_ATTRIBUTE15 => X_GLOBAL_ATTRIBUTE15,
740 X_GLOBAL_ATTRIBUTE16 => X_GLOBAL_ATTRIBUTE16,
741 X_GLOBAL_ATTRIBUTE17 => X_GLOBAL_ATTRIBUTE17,
742 X_GLOBAL_ATTRIBUTE18 => X_GLOBAL_ATTRIBUTE18,
743 X_GLOBAL_ATTRIBUTE19 => X_GLOBAL_ATTRIBUTE19,
744 X_GLOBAL_ATTRIBUTE20 => X_GLOBAL_ATTRIBUTE20,
745 X_GLOBAL_ATTRIBUTE_CATEGORY => X_GLOBAL_ATTRIBUTE_CATEGORY,
746 X_DESCRIPTION => X_DESCRIPTION,
747 X_LAST_UPDATE_DATE => sysdate,
748 X_LAST_UPDATED_BY => user_id,
749 X_LAST_UPDATE_LOGIN => 0);
750 exception
751 when no_data_found then
752 org_freight_tl_pkg.insert_row(
753 X_ROWID => row_id,
754 X_FREIGHT_CODE => X_FREIGHT_CODE,
755 X_FREIGHT_CODE_TL=> X_FREIGHT_CODE_TL,
756 X_ORGANIZATION_ID => org_id,
757 X_DISABLE_DATE => X_DISABLE_DATE,
758 X_DISTRIBUTION_ACCOUNT => X_DISTRIBUTION_ACCOUNT,
759 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
760 X_ATTRIBUTE1 => X_ATTRIBUTE1,
761 X_ATTRIBUTE2 => X_ATTRIBUTE2,
762 X_ATTRIBUTE3 => X_ATTRIBUTE3,
763 X_ATTRIBUTE4 => X_ATTRIBUTE4,
764 X_ATTRIBUTE5 => X_ATTRIBUTE5,
765 X_ATTRIBUTE6 => X_ATTRIBUTE6,
766 X_ATTRIBUTE7 => X_ATTRIBUTE7,
767 X_ATTRIBUTE8 => X_ATTRIBUTE8,
768 X_ATTRIBUTE9 => X_ATTRIBUTE9,
769 X_ATTRIBUTE10 => X_ATTRIBUTE10,
770 X_ATTRIBUTE11 => X_ATTRIBUTE11,
771 X_ATTRIBUTE12 => X_ATTRIBUTE12,
772 X_ATTRIBUTE13 => X_ATTRIBUTE13,
773 X_ATTRIBUTE14 => X_ATTRIBUTE14,
774 X_ATTRIBUTE15 => X_ATTRIBUTE15,
775 X_GLOBAL_ATTRIBUTE1 => X_GLOBAL_ATTRIBUTE1,
776 X_GLOBAL_ATTRIBUTE2 => X_GLOBAL_ATTRIBUTE2,
777 X_GLOBAL_ATTRIBUTE3 => X_GLOBAL_ATTRIBUTE3,
778 X_GLOBAL_ATTRIBUTE4 => X_GLOBAL_ATTRIBUTE4,
779 X_GLOBAL_ATTRIBUTE5 => X_GLOBAL_ATTRIBUTE5,
780 X_GLOBAL_ATTRIBUTE6 => X_GLOBAL_ATTRIBUTE6,
781 X_GLOBAL_ATTRIBUTE7 => X_GLOBAL_ATTRIBUTE7,
782 X_GLOBAL_ATTRIBUTE8 => X_GLOBAL_ATTRIBUTE8,
783 X_GLOBAL_ATTRIBUTE9 => X_GLOBAL_ATTRIBUTE9,
784 X_GLOBAL_ATTRIBUTE10 => X_GLOBAL_ATTRIBUTE10,
785 X_GLOBAL_ATTRIBUTE11 => X_GLOBAL_ATTRIBUTE11,
786 X_GLOBAL_ATTRIBUTE12 => X_GLOBAL_ATTRIBUTE12,
787 X_GLOBAL_ATTRIBUTE13 => X_GLOBAL_ATTRIBUTE13,
788 X_GLOBAL_ATTRIBUTE14 => X_GLOBAL_ATTRIBUTE14,
789 X_GLOBAL_ATTRIBUTE15 => X_GLOBAL_ATTRIBUTE15,
790 X_GLOBAL_ATTRIBUTE16 => X_GLOBAL_ATTRIBUTE16,
791 X_GLOBAL_ATTRIBUTE17 => X_GLOBAL_ATTRIBUTE17,
792 X_GLOBAL_ATTRIBUTE18 => X_GLOBAL_ATTRIBUTE18,
793 X_GLOBAL_ATTRIBUTE19 => X_GLOBAL_ATTRIBUTE19,
794 X_GLOBAL_ATTRIBUTE20 => X_GLOBAL_ATTRIBUTE20,
795 X_GLOBAL_ATTRIBUTE_CATEGORY => X_GLOBAL_ATTRIBUTE_CATEGORY,
796 X_DESCRIPTION => X_DESCRIPTION,
797 X_CREATION_DATE => sysdate,
798 X_CREATED_BY => user_id,
799 X_LAST_UPDATE_DATE => sysdate,
800 X_LAST_UPDATED_BY => user_id,
801 X_LAST_UPDATE_LOGIN => 0);
802 end LOAD_ROW;
803
804
805
806 procedure TRANSLATE_ROW(
807 X_FREIGHT_CODE in VARCHAR2,
808 X_ORGANIZATION_ID in NUMBER,
809 X_FREIGHT_CODE_TL in VARCHAR2,
810 X_DESCRIPTION in VARCHAR2,
811 X_OWNER in VARCHAR2)
812 as
813 Begin
814
815 update ORG_FREIGHT_TL set
816 FREIGHT_CODE_TL = X_FREIGHT_CODE_TL,
817 DESCRIPTION = X_DESCRIPTION,
818 LAST_UPDATE_DATE = sysdate,
819 LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
820 LAST_UPDATE_LOGIN = 0,
821 SOURCE_LANG = userenv('LANG')
822 where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
823 and FREIGHT_CODE = X_FREIGHT_CODE
824 and ORGANIZATION_ID = X_ORGANIZATION_ID;
825
826 end TRANSLATE_ROW;
827
828 end ORG_FREIGHT_TL_PKG;