[Home] [Help]
PACKAGE BODY: APPS.FA_CATEGORIES_PKG
Source
1 package body FA_CATEGORIES_PKG as
2 /* $Header: faxicab.pls 120.7 2009/04/10 07:39:49 deemitta ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_CATEGORY_ID in NUMBER,
6 X_SUMMARY_FLAG in VARCHAR2,
7 X_ENABLED_FLAG in VARCHAR2,
8 X_OWNED_LEASED in VARCHAR2,
9 X_CATEGORY_TYPE in VARCHAR2,
10 X_CAPITALIZE_FLAG in VARCHAR2,
11 X_DESCRIPTION in VARCHAR2,
12 X_SEGMENT1 in VARCHAR2,
13 X_SEGMENT2 in VARCHAR2,
14 X_SEGMENT3 in VARCHAR2,
15 X_SEGMENT4 in VARCHAR2,
16 X_SEGMENT5 in VARCHAR2,
17 X_SEGMENT6 in VARCHAR2,
18 X_SEGMENT7 in VARCHAR2,
19 X_START_DATE_ACTIVE in DATE,
20 X_END_DATE_ACTIVE in DATE,
21 X_PROPERTY_TYPE_CODE in VARCHAR2,
22 X_PROPERTY_1245_1250_CODE in VARCHAR2,
23 X_DATE_INEFFECTIVE in DATE,
24 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
25 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
26 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
27 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
28 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
29 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
30 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
31 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
32 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
33 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
34 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
35 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
36 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
37 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
38 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
39 X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
40 X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
41 X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
42 X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
43 X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
44 X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
45 X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
46 X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
47 X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
48 X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
49 X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
50 X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
51 X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
52 X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
53 X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
54 X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
55 X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
56 X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
57 X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
58 X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
59 X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
60 X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
61 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
62 X_INVENTORIAL in VARCHAR2,
63 X_CREATION_DATE in DATE,
64 X_CREATED_BY in NUMBER,
65 X_LAST_UPDATE_DATE in DATE,
66 X_LAST_UPDATED_BY in NUMBER,
67 X_LAST_UPDATE_LOGIN in NUMBER
68 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
69 cursor C is select ROWID from FA_CATEGORIES_B
70 where CATEGORY_ID = X_CATEGORY_ID
71 ;
72 begin
73 insert into FA_CATEGORIES_B (
74 CATEGORY_ID,
75 SUMMARY_FLAG,
76 ENABLED_FLAG,
77 OWNED_LEASED,
78 CATEGORY_TYPE,
79 CAPITALIZE_FLAG,
80 SEGMENT1,
81 SEGMENT2,
82 SEGMENT3,
83 SEGMENT4,
84 SEGMENT5,
85 SEGMENT6,
86 SEGMENT7,
87 START_DATE_ACTIVE,
88 END_DATE_ACTIVE,
89 PROPERTY_TYPE_CODE,
90 PROPERTY_1245_1250_CODE,
91 DATE_INEFFECTIVE,
92 ATTRIBUTE1,
93 ATTRIBUTE2,
94 ATTRIBUTE3,
95 ATTRIBUTE4,
96 ATTRIBUTE5,
97 ATTRIBUTE6,
98 ATTRIBUTE7,
99 ATTRIBUTE8,
100 ATTRIBUTE9,
101 ATTRIBUTE10,
102 ATTRIBUTE11,
103 ATTRIBUTE12,
104 ATTRIBUTE13,
105 ATTRIBUTE14,
106 ATTRIBUTE15,
107 ATTRIBUTE_CATEGORY_CODE,
108 PRODUCTION_CAPACITY,
109 GLOBAL_ATTRIBUTE1,
110 GLOBAL_ATTRIBUTE2,
111 GLOBAL_ATTRIBUTE3,
112 GLOBAL_ATTRIBUTE4,
113 GLOBAL_ATTRIBUTE5,
114 GLOBAL_ATTRIBUTE6,
115 GLOBAL_ATTRIBUTE7,
116 GLOBAL_ATTRIBUTE8,
117 GLOBAL_ATTRIBUTE9,
118 GLOBAL_ATTRIBUTE10,
119 GLOBAL_ATTRIBUTE11,
120 GLOBAL_ATTRIBUTE12,
121 GLOBAL_ATTRIBUTE13,
122 GLOBAL_ATTRIBUTE14,
123 GLOBAL_ATTRIBUTE15,
124 GLOBAL_ATTRIBUTE16,
125 GLOBAL_ATTRIBUTE17,
126 GLOBAL_ATTRIBUTE18,
127 GLOBAL_ATTRIBUTE19,
128 GLOBAL_ATTRIBUTE20,
129 GLOBAL_ATTRIBUTE_CATEGORY,
130 INVENTORIAL,
131 CREATION_DATE,
132 CREATED_BY,
133 LAST_UPDATE_DATE,
134 LAST_UPDATED_BY,
135 LAST_UPDATE_LOGIN
136 ) values (
137 X_CATEGORY_ID,
138 X_SUMMARY_FLAG,
139 X_ENABLED_FLAG,
140 X_OWNED_LEASED,
141 X_CATEGORY_TYPE,
142 X_CAPITALIZE_FLAG,
143 X_SEGMENT1,
144 X_SEGMENT2,
145 X_SEGMENT3,
146 X_SEGMENT4,
147 X_SEGMENT5,
148 X_SEGMENT6,
149 X_SEGMENT7,
150 X_START_DATE_ACTIVE,
151 X_END_DATE_ACTIVE,
152 X_PROPERTY_TYPE_CODE,
153 X_PROPERTY_1245_1250_CODE,
154 X_DATE_INEFFECTIVE,
155 X_ATTRIBUTE1,
156 X_ATTRIBUTE2,
157 X_ATTRIBUTE3,
158 X_ATTRIBUTE4,
159 X_ATTRIBUTE5,
160 X_ATTRIBUTE6,
161 X_ATTRIBUTE7,
162 X_ATTRIBUTE8,
163 X_ATTRIBUTE9,
164 X_ATTRIBUTE10,
165 X_ATTRIBUTE11,
166 X_ATTRIBUTE12,
167 X_ATTRIBUTE13,
168 X_ATTRIBUTE14,
169 X_ATTRIBUTE15,
170 X_ATTRIBUTE_CATEGORY_CODE,
171 X_PRODUCTION_CAPACITY,
172 X_GLOBAL_ATTRIBUTE1,
173 X_GLOBAL_ATTRIBUTE2,
174 X_GLOBAL_ATTRIBUTE3,
175 X_GLOBAL_ATTRIBUTE4,
176 X_GLOBAL_ATTRIBUTE5,
177 X_GLOBAL_ATTRIBUTE6,
178 X_GLOBAL_ATTRIBUTE7,
179 X_GLOBAL_ATTRIBUTE8,
180 X_GLOBAL_ATTRIBUTE9,
181 X_GLOBAL_ATTRIBUTE10,
182 X_GLOBAL_ATTRIBUTE11,
183 X_GLOBAL_ATTRIBUTE12,
184 X_GLOBAL_ATTRIBUTE13,
185 X_GLOBAL_ATTRIBUTE14,
186 X_GLOBAL_ATTRIBUTE15,
187 X_GLOBAL_ATTRIBUTE16,
188 X_GLOBAL_ATTRIBUTE17,
189 X_GLOBAL_ATTRIBUTE18,
190 X_GLOBAL_ATTRIBUTE19,
191 X_GLOBAL_ATTRIBUTE20,
192 X_GLOBAL_ATTRIBUTE_CATEGORY,
193 X_INVENTORIAL,
194 X_CREATION_DATE,
195 X_CREATED_BY,
196 X_LAST_UPDATE_DATE,
197 X_LAST_UPDATED_BY,
198 X_LAST_UPDATE_LOGIN
199 );
200
201 insert into FA_CATEGORIES_TL (
202 DESCRIPTION,
203 LAST_UPDATE_DATE,
204 LAST_UPDATED_BY,
205 CREATED_BY,
206 CREATION_DATE,
207 LAST_UPDATE_LOGIN,
208 CATEGORY_ID,
209 LANGUAGE,
210 SOURCE_LANG
211 ) select
212 X_DESCRIPTION,
213 X_LAST_UPDATE_DATE,
214 X_LAST_UPDATED_BY,
215 X_CREATED_BY,
216 X_CREATION_DATE,
217 X_LAST_UPDATE_LOGIN,
218 X_CATEGORY_ID,
219 L.LANGUAGE_CODE,
220 userenv('LANG')
221 from FND_LANGUAGES L
222 where L.INSTALLED_FLAG in ('I', 'B')
223 and not exists
224 (select NULL
225 from FA_CATEGORIES_TL T
226 where T.CATEGORY_ID = X_CATEGORY_ID
227 and T.LANGUAGE = L.LANGUAGE_CODE);
228
229 open c;
230 fetch c into X_ROWID;
231 if (c%notfound) then
232 close c;
233 raise no_data_found;
234 end if;
235 close c;
236
237 end INSERT_ROW;
238
239 procedure LOCK_ROW (
240 X_CATEGORY_ID in NUMBER,
241 X_SUMMARY_FLAG in VARCHAR2,
242 X_ENABLED_FLAG in VARCHAR2,
243 X_OWNED_LEASED in VARCHAR2,
244 X_CATEGORY_TYPE in VARCHAR2,
245 X_CAPITALIZE_FLAG in VARCHAR2,
246 X_DESCRIPTION in VARCHAR2,
247 X_SEGMENT1 in VARCHAR2,
248 X_SEGMENT2 in VARCHAR2,
249 X_SEGMENT3 in VARCHAR2,
250 X_SEGMENT4 in VARCHAR2,
251 X_SEGMENT5 in VARCHAR2,
252 X_SEGMENT6 in VARCHAR2,
253 X_SEGMENT7 in VARCHAR2,
254 X_START_DATE_ACTIVE in DATE,
255 X_END_DATE_ACTIVE in DATE,
256 X_PROPERTY_TYPE_CODE in VARCHAR2,
257 X_PROPERTY_1245_1250_CODE in VARCHAR2,
258 X_DATE_INEFFECTIVE in DATE,
259 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
260 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
261 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
262 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
263 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
264 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
265 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
266 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
267 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
268 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
269 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
270 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
271 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
272 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
273 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
274 X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
275 X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
276 X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
277 X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
278 X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
279 X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
280 X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
281 X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
282 X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
283 X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
284 X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
285 X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
286 X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
287 X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
288 X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
289 X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
290 X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
291 X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
292 X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
293 X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
294 X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
295 X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
296 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
297 X_INVENTORIAL in VARCHAR2
298 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
299 cursor c is select
300 SUMMARY_FLAG,
301 ENABLED_FLAG,
302 OWNED_LEASED,
303 CATEGORY_TYPE,
304 CAPITALIZE_FLAG,
305 SEGMENT1,
306 SEGMENT2,
307 SEGMENT3,
308 SEGMENT4,
309 SEGMENT5,
310 SEGMENT6,
311 SEGMENT7,
312 START_DATE_ACTIVE,
313 END_DATE_ACTIVE,
314 PROPERTY_TYPE_CODE,
315 PROPERTY_1245_1250_CODE,
316 DATE_INEFFECTIVE,
317 ATTRIBUTE1,
318 ATTRIBUTE2,
319 ATTRIBUTE3,
320 ATTRIBUTE4,
321 ATTRIBUTE5,
322 ATTRIBUTE6,
323 ATTRIBUTE7,
324 ATTRIBUTE8,
325 ATTRIBUTE9,
326 ATTRIBUTE10,
327 ATTRIBUTE11,
328 ATTRIBUTE12,
329 ATTRIBUTE13,
330 ATTRIBUTE14,
331 ATTRIBUTE15,
332 ATTRIBUTE_CATEGORY_CODE,
333 PRODUCTION_CAPACITY,
334 GLOBAL_ATTRIBUTE1,
335 GLOBAL_ATTRIBUTE2,
336 GLOBAL_ATTRIBUTE3,
337 GLOBAL_ATTRIBUTE4,
338 GLOBAL_ATTRIBUTE5,
339 GLOBAL_ATTRIBUTE6,
340 GLOBAL_ATTRIBUTE7,
341 GLOBAL_ATTRIBUTE8,
342 GLOBAL_ATTRIBUTE9,
343 GLOBAL_ATTRIBUTE10,
344 GLOBAL_ATTRIBUTE11,
345 GLOBAL_ATTRIBUTE12,
346 GLOBAL_ATTRIBUTE13,
347 GLOBAL_ATTRIBUTE14,
348 GLOBAL_ATTRIBUTE15,
349 GLOBAL_ATTRIBUTE16,
350 GLOBAL_ATTRIBUTE17,
351 GLOBAL_ATTRIBUTE18,
352 GLOBAL_ATTRIBUTE19,
353 GLOBAL_ATTRIBUTE20,
354 GLOBAL_ATTRIBUTE_CATEGORY,
355 INVENTORIAL
356 from FA_CATEGORIES_B
357 where CATEGORY_ID = X_CATEGORY_ID
358 for update of CATEGORY_ID nowait;
359 recinfo c%rowtype;
360
361 cursor c1 is select
362 DESCRIPTION,
363 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
364 from FA_CATEGORIES_TL
365 where CATEGORY_ID = X_CATEGORY_ID
366 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
367 for update of CATEGORY_ID nowait;
368 begin
369 open c;
370 fetch c into recinfo;
371 if (c%notfound) then
372 close c;
373 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
374 app_exception.raise_exception;
375 end if;
376 close c;
377 if ( (recinfo.SUMMARY_FLAG = X_SUMMARY_FLAG)
378 AND (recinfo.ENABLED_FLAG = X_ENABLED_FLAG)
379 AND (recinfo.OWNED_LEASED = X_OWNED_LEASED)
380 AND (recinfo.CATEGORY_TYPE = X_CATEGORY_TYPE)
381 AND (recinfo.CAPITALIZE_FLAG = X_CAPITALIZE_FLAG)
382 AND ((recinfo.SEGMENT1 = X_SEGMENT1)
383 OR ((recinfo.SEGMENT1 is null) AND (X_SEGMENT1 is null)))
384 AND ((recinfo.SEGMENT2 = X_SEGMENT2)
385 OR ((recinfo.SEGMENT2 is null) AND (X_SEGMENT2 is null)))
386 AND ((recinfo.SEGMENT3 = X_SEGMENT3)
387 OR ((recinfo.SEGMENT3 is null) AND (X_SEGMENT3 is null)))
388 AND ((recinfo.SEGMENT4 = X_SEGMENT4)
389 OR ((recinfo.SEGMENT4 is null) AND (X_SEGMENT4 is null)))
390 AND ((recinfo.SEGMENT5 = X_SEGMENT5)
391 OR ((recinfo.SEGMENT5 is null) AND (X_SEGMENT5 is null)))
392 AND ((recinfo.SEGMENT6 = X_SEGMENT6)
393 OR ((recinfo.SEGMENT6 is null) AND (X_SEGMENT6 is null)))
394 AND ((recinfo.SEGMENT7 = X_SEGMENT7)
395 OR ((recinfo.SEGMENT7 is null) AND (X_SEGMENT7 is null)))
396 AND ((recinfo.START_DATE_ACTIVE = X_START_DATE_ACTIVE)
397 OR ((recinfo.START_DATE_ACTIVE is null) AND (X_START_DATE_ACTIVE is null)))
398 AND ((recinfo.END_DATE_ACTIVE = X_END_DATE_ACTIVE)
399 OR ((recinfo.END_DATE_ACTIVE is null) AND (X_END_DATE_ACTIVE is null)))
400 AND ((recinfo.PROPERTY_TYPE_CODE = X_PROPERTY_TYPE_CODE)
401 OR ((recinfo.PROPERTY_TYPE_CODE is null) AND (X_PROPERTY_TYPE_CODE is null)))
402 AND ((recinfo.PROPERTY_1245_1250_CODE = X_PROPERTY_1245_1250_CODE)
403 OR ((recinfo.PROPERTY_1245_1250_CODE is null) AND (X_PROPERTY_1245_1250_CODE is null)))
404 AND ((recinfo.DATE_INEFFECTIVE = X_DATE_INEFFECTIVE)
405 OR ((recinfo.DATE_INEFFECTIVE is null) AND (X_DATE_INEFFECTIVE is null)))
406 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
407 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
408 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
409 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
410 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
411 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
412 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
413 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
414 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
415 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
416 AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
417 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
418 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
419 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
420 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
421 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
422 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
423 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
424 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
425 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
426 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
427 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
428 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
429 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
430 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
431 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
432 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
433 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
434 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
435 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
436 AND ((recinfo.ATTRIBUTE_CATEGORY_CODE = X_ATTRIBUTE_CATEGORY_CODE)
437 OR ((recinfo.ATTRIBUTE_CATEGORY_CODE is null) AND (X_ATTRIBUTE_CATEGORY_CODE is null)))
438 AND ((recinfo.PRODUCTION_CAPACITY = X_PRODUCTION_CAPACITY)
439 OR ((recinfo.PRODUCTION_CAPACITY is null) AND (X_PRODUCTION_CAPACITY is null)))
440 AND ((recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1)
441 OR ((recinfo.GLOBAL_ATTRIBUTE1 is null) AND (X_GLOBAL_ATTRIBUTE1 is null)))
442 AND ((recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2)
443 OR ((recinfo.GLOBAL_ATTRIBUTE2 is null) AND (X_GLOBAL_ATTRIBUTE2 is null)))
444 AND ((recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3)
445 OR ((recinfo.GLOBAL_ATTRIBUTE3 is null) AND (X_GLOBAL_ATTRIBUTE3 is null)))
446 AND ((recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4)
447 OR ((recinfo.GLOBAL_ATTRIBUTE4 is null) AND (X_GLOBAL_ATTRIBUTE4 is null)))
448 AND ((recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5)
449 OR ((recinfo.GLOBAL_ATTRIBUTE5 is null) AND (X_GLOBAL_ATTRIBUTE5 is null)))
450 AND ((recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6)
451 OR ((recinfo.GLOBAL_ATTRIBUTE6 is null) AND (X_GLOBAL_ATTRIBUTE6 is null)))
452 AND ((recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7)
453 OR ((recinfo.GLOBAL_ATTRIBUTE7 is null) AND (X_GLOBAL_ATTRIBUTE7 is null)))
454 AND ((recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8)
455 OR ((recinfo.GLOBAL_ATTRIBUTE8 is null) AND (X_GLOBAL_ATTRIBUTE8 is null)))
456 AND ((recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9)
457 OR ((recinfo.GLOBAL_ATTRIBUTE9 is null) AND (X_GLOBAL_ATTRIBUTE9 is null)))
458 AND ((recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10)
459 OR ((recinfo.GLOBAL_ATTRIBUTE10 is null) AND (X_GLOBAL_ATTRIBUTE10 is null)))
460 AND ((recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11)
461 OR ((recinfo.GLOBAL_ATTRIBUTE11 is null) AND (X_GLOBAL_ATTRIBUTE11 is null)))
462 AND ((recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12)
463 OR ((recinfo.GLOBAL_ATTRIBUTE12 is null) AND (X_GLOBAL_ATTRIBUTE12 is null)))
464 AND ((recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13)
465 OR ((recinfo.GLOBAL_ATTRIBUTE13 is null) AND (X_GLOBAL_ATTRIBUTE13 is null)))
466 AND ((recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14)
467 OR ((recinfo.GLOBAL_ATTRIBUTE14 is null) AND (X_GLOBAL_ATTRIBUTE14 is null)))
468 AND ((recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15)
469 OR ((recinfo.GLOBAL_ATTRIBUTE15 is null) AND (X_GLOBAL_ATTRIBUTE15 is null)))
470 AND ((recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16)
471 OR ((recinfo.GLOBAL_ATTRIBUTE16 is null) AND (X_GLOBAL_ATTRIBUTE16 is null)))
472 AND ((recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17)
473 OR ((recinfo.GLOBAL_ATTRIBUTE17 is null) AND (X_GLOBAL_ATTRIBUTE17 is null)))
474 AND ((recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18)
475 OR ((recinfo.GLOBAL_ATTRIBUTE18 is null) AND (X_GLOBAL_ATTRIBUTE18 is null)))
476 AND ((recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19)
477 OR ((recinfo.GLOBAL_ATTRIBUTE19 is null) AND (X_GLOBAL_ATTRIBUTE19 is null)))
478 AND ((recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20)
479 OR ((recinfo.GLOBAL_ATTRIBUTE20 is null) AND (X_GLOBAL_ATTRIBUTE20 is null)))
480 AND ((recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY)
481 OR ((recinfo.GLOBAL_ATTRIBUTE_CATEGORY is null) AND (X_GLOBAL_ATTRIBUTE_CATEGORY is null)))
482 AND ((recinfo.INVENTORIAL = X_INVENTORIAL)
483 OR ((recinfo.INVENTORIAL is null) AND (X_INVENTORIAL is null)))
484 ) then
485 null;
486 else
487 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488 app_exception.raise_exception;
489 end if;
490
491 for tlinfo in c1 loop
492 if (tlinfo.BASELANG = 'Y') then
493 if ( ((tlinfo.DESCRIPTION = X_DESCRIPTION)
494 OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
495 ) then
496 null;
497 else
498 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
499 app_exception.raise_exception;
500 end if;
501 end if;
502 end loop;
503 return;
504 end LOCK_ROW;
505
506 procedure UPDATE_ROW (
507 X_CATEGORY_ID in NUMBER,
508 X_SUMMARY_FLAG in VARCHAR2,
509 X_ENABLED_FLAG in VARCHAR2,
510 X_OWNED_LEASED in VARCHAR2,
511 X_CATEGORY_TYPE in VARCHAR2,
512 X_CAPITALIZE_FLAG in VARCHAR2,
513 X_DESCRIPTION in VARCHAR2,
514 X_SEGMENT1 in VARCHAR2,
515 X_SEGMENT2 in VARCHAR2,
516 X_SEGMENT3 in VARCHAR2,
517 X_SEGMENT4 in VARCHAR2,
518 X_SEGMENT5 in VARCHAR2,
519 X_SEGMENT6 in VARCHAR2,
520 X_SEGMENT7 in VARCHAR2,
521 X_START_DATE_ACTIVE in DATE,
522 X_END_DATE_ACTIVE in DATE,
523 X_PROPERTY_TYPE_CODE in VARCHAR2,
524 X_PROPERTY_1245_1250_CODE in VARCHAR2,
525 X_DATE_INEFFECTIVE in DATE,
526 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
527 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
528 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
529 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
530 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
531 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
532 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
533 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
534 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
535 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
536 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
537 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
538 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
539 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
540 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
541 X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
542 X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
543 X_GLOBAL_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
544 X_GLOBAL_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
545 X_GLOBAL_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
546 X_GLOBAL_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
547 X_GLOBAL_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
548 X_GLOBAL_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
549 X_GLOBAL_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
550 X_GLOBAL_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
551 X_GLOBAL_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
552 X_GLOBAL_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
553 X_GLOBAL_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
554 X_GLOBAL_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
555 X_GLOBAL_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
556 X_GLOBAL_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
557 X_GLOBAL_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
558 X_GLOBAL_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
559 X_GLOBAL_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
560 X_GLOBAL_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
561 X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
562 X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
563 X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
564 X_INVENTORIAL in VARCHAR2,
565 X_LAST_UPDATE_DATE in DATE,
566 X_LAST_UPDATED_BY in NUMBER,
567 X_LAST_UPDATE_LOGIN in NUMBER
568 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
569 begin
570 update FA_CATEGORIES_B set
571 SUMMARY_FLAG = X_SUMMARY_FLAG,
572 ENABLED_FLAG = X_ENABLED_FLAG,
573 OWNED_LEASED = X_OWNED_LEASED,
574 CATEGORY_TYPE = X_CATEGORY_TYPE,
575 CAPITALIZE_FLAG = X_CAPITALIZE_FLAG,
576 SEGMENT1 = X_SEGMENT1,
577 SEGMENT2 = X_SEGMENT2,
578 SEGMENT3 = X_SEGMENT3,
579 SEGMENT4 = X_SEGMENT4,
580 SEGMENT5 = X_SEGMENT5,
581 SEGMENT6 = X_SEGMENT6,
582 SEGMENT7 = X_SEGMENT7,
583 START_DATE_ACTIVE = X_START_DATE_ACTIVE,
584 END_DATE_ACTIVE = X_END_DATE_ACTIVE,
585 PROPERTY_TYPE_CODE = X_PROPERTY_TYPE_CODE,
586 PROPERTY_1245_1250_CODE = X_PROPERTY_1245_1250_CODE,
587 DATE_INEFFECTIVE = X_DATE_INEFFECTIVE,
588 ATTRIBUTE1 = X_ATTRIBUTE1,
589 ATTRIBUTE2 = X_ATTRIBUTE2,
590 ATTRIBUTE3 = X_ATTRIBUTE3,
591 ATTRIBUTE4 = X_ATTRIBUTE4,
592 ATTRIBUTE5 = X_ATTRIBUTE5,
593 ATTRIBUTE6 = X_ATTRIBUTE6,
594 ATTRIBUTE7 = X_ATTRIBUTE7,
595 ATTRIBUTE8 = X_ATTRIBUTE8,
596 ATTRIBUTE9 = X_ATTRIBUTE9,
597 ATTRIBUTE10 = X_ATTRIBUTE10,
598 ATTRIBUTE11 = X_ATTRIBUTE11,
599 ATTRIBUTE12 = X_ATTRIBUTE12,
600 ATTRIBUTE13 = X_ATTRIBUTE13,
601 ATTRIBUTE14 = X_ATTRIBUTE14,
602 ATTRIBUTE15 = X_ATTRIBUTE15,
603 ATTRIBUTE_CATEGORY_CODE = X_ATTRIBUTE_CATEGORY_CODE,
604 PRODUCTION_CAPACITY = X_PRODUCTION_CAPACITY,
605 GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
606 GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
607 GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
608 GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
609 GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
610 GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
611 GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
612 GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
613 GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
614 GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
615 GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
616 GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
617 GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
618 GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
619 GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
620 GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
621 GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
622 GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
623 GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
624 GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
625 GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
626 INVENTORIAL = X_INVENTORIAL,
627 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
628 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
629 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
630 where CATEGORY_ID = X_CATEGORY_ID;
631
632 if (sql%notfound) then
633 raise no_data_found;
634 end if;
635
636 update FA_CATEGORIES_TL set
637 DESCRIPTION = X_DESCRIPTION,
638 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
639 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
640 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
641 SOURCE_LANG = userenv('LANG')
642 where CATEGORY_ID = X_CATEGORY_ID
643 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
644
645 if (sql%notfound) then
646 raise no_data_found;
647 end if;
648 end UPDATE_ROW;
649
650 procedure DELETE_ROW (
651 X_CATEGORY_ID in NUMBER
652 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
653 begin
654 delete from FA_CATEGORIES_TL
655 where CATEGORY_ID = X_CATEGORY_ID;
656
657 if (sql%notfound) then
658 raise no_data_found;
659 end if;
660
661 delete from FA_CATEGORIES_B
662 where CATEGORY_ID = X_CATEGORY_ID;
663
664 if (sql%notfound) then
665 raise no_data_found;
666 end if;
667 end DELETE_ROW;
668
669 procedure ADD_LANGUAGE
670 is
671 begin
672 delete from FA_CATEGORIES_TL T
673 where not exists
674 (select NULL
675 from FA_CATEGORIES_B B
676 where B.CATEGORY_ID = T.CATEGORY_ID
677 );
678
679 update FA_CATEGORIES_TL T set (
680 DESCRIPTION
681 ) = (select
682 B.DESCRIPTION
683 from FA_CATEGORIES_TL B
684 where B.CATEGORY_ID = T.CATEGORY_ID
685 and B.LANGUAGE = T.SOURCE_LANG)
686 where (
687 T.CATEGORY_ID,
688 T.LANGUAGE
689 ) in (select
690 SUBT.CATEGORY_ID,
691 SUBT.LANGUAGE
692 from FA_CATEGORIES_TL SUBB, FA_CATEGORIES_TL SUBT
693 where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
694 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
695 and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
696 or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
697 or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
698 ));
699
700 insert into FA_CATEGORIES_TL (
701 DESCRIPTION,
702 LAST_UPDATE_DATE,
703 LAST_UPDATED_BY,
704 CREATED_BY,
705 CREATION_DATE,
706 LAST_UPDATE_LOGIN,
707 CATEGORY_ID,
708 LANGUAGE,
709 SOURCE_LANG
710 ) select
711 B.DESCRIPTION,
712 B.LAST_UPDATE_DATE,
713 B.LAST_UPDATED_BY,
714 B.CREATED_BY,
715 B.CREATION_DATE,
716 B.LAST_UPDATE_LOGIN,
717 B.CATEGORY_ID,
718 L.LANGUAGE_CODE,
719 B.SOURCE_LANG
720 from FA_CATEGORIES_TL B, FND_LANGUAGES L
721 where L.INSTALLED_FLAG in ('I', 'B')
722 and B.LANGUAGE = userenv('LANG')
723 and not exists
724 (select NULL
725 from FA_CATEGORIES_TL T
726 where T.CATEGORY_ID = B.CATEGORY_ID
727 and T.LANGUAGE = L.LANGUAGE_CODE);
728 end ADD_LANGUAGE;
729
730 procedure LOAD_ROW (
731 X_CATEGORY_ID in NUMBER,
732 X_SUMMARY_FLAG in VARCHAR2,
733 X_ENABLED_FLAG in VARCHAR2,
734 X_OWNED_LEASED in VARCHAR2,
735 X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
736 X_CATEGORY_TYPE in VARCHAR2,
737 X_CAPITALIZE_FLAG in VARCHAR2,
738 X_DESCRIPTION in VARCHAR2,
739 X_SEGMENT1 in VARCHAR2,
740 X_SEGMENT2 in VARCHAR2,
741 X_SEGMENT3 in VARCHAR2,
742 X_SEGMENT4 in VARCHAR2,
743 X_SEGMENT5 in VARCHAR2,
744 X_SEGMENT6 in VARCHAR2,
745 X_SEGMENT7 in VARCHAR2,
746 X_START_DATE_ACTIVE in DATE,
747 X_END_DATE_ACTIVE in DATE,
748 X_PROPERTY_TYPE_CODE in VARCHAR2,
749 X_PROPERTY_1245_1250_CODE in VARCHAR2,
750 X_DATE_INEFFECTIVE in DATE,
751 X_INVENTORIAL in VARCHAR2,
752 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
753 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
754 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
755 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
756 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
757 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
758 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
759 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
760 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
761 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
762 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
763 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
764 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
765 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
766 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
767 X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
768 X_GF_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
769 X_GF_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
770 X_GF_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
771 X_GF_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
772 X_GF_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
773 X_GF_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
774 X_GF_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
775 X_GF_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
776 X_GF_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
777 X_GF_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
778 X_GF_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
779 X_GF_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
780 X_GF_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
781 X_GF_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
782 X_GF_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
783 X_GF_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
784 X_GF_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
785 X_GF_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
786 X_GF_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
787 X_GF_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
788 X_GF_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL
789 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
790
791 h_record_exists number(15);
792
793 user_id number;
794 row_id varchar2(64);
795
796 begin
797
798 -- No SEED data. All custom.
799 user_id := 0;
800
801 select count(*)
802 into h_record_exists
803 from fa_categories_b
804 where category_id = X_Category_Id;
805
806 if (h_record_exists > 0) then
807 fa_categories_pkg.update_row (
808 X_Category_ID => X_Category_Id,
809 X_Summary_Flag => X_Summary_Flag,
810 X_Enabled_Flag => X_Enabled_Flag,
811 X_Owned_Leased => X_Owned_Leased,
812 X_Category_Type => X_Category_Type,
813 X_Capitalize_Flag => X_Capitalize_Flag,
814 X_Description => X_Description,
815 X_Segment1 => X_Segment1,
816 X_Segment2 => X_Segment2,
817 X_Segment3 => X_Segment3,
818 X_Segment4 => X_Segment4,
819 X_Segment5 => X_Segment5,
820 X_Segment6 => X_Segment6,
821 X_Segment7 => X_Segment7,
822 X_Start_Date_Active => X_Start_Date_Active,
823 X_End_Date_Active => X_End_Date_Active,
824 X_Property_Type_Code => X_Property_Type_Code,
825 X_Property_1245_1250_Code => X_Property_1245_1250_Code,
826 X_Date_Ineffective => X_Date_Ineffective,
827 X_Attribute1 => X_Attribute1,
828 X_Attribute2 => X_Attribute2,
829 X_Attribute3 => X_Attribute3,
830 X_Attribute4 => X_Attribute4,
831 X_Attribute5 => X_Attribute5,
832 X_Attribute6 => X_Attribute6,
833 X_Attribute7 => X_Attribute7,
834 X_Attribute8 => X_Attribute8,
835 X_Attribute9 => X_Attribute9,
836 X_Attribute10 => X_Attribute10,
837 X_Attribute11 => X_Attribute11,
838 X_Attribute12 => X_Attribute12,
839 X_Attribute13 => X_Attribute13,
840 X_Attribute14 => X_Attribute14,
841 X_Attribute15 => X_Attribute15,
842 X_Attribute_Category_Code => X_Attribute_Category_Code,
843 X_Production_Capacity => X_Production_Capacity,
844 X_Global_Attribute1 => X_gf_Attribute1,
845 X_Global_Attribute2 => X_gf_Attribute2,
846 X_Global_Attribute3 => X_gf_Attribute3,
847 X_Global_Attribute4 => X_gf_Attribute4,
848 X_Global_Attribute5 => X_gf_Attribute5,
849 X_Global_Attribute6 => X_gf_Attribute6,
850 X_Global_Attribute7 => X_gf_Attribute7,
851 X_Global_Attribute8 => X_gf_Attribute8,
852 X_Global_Attribute9 => X_gf_Attribute9,
853 X_Global_Attribute10 => X_gf_Attribute10,
854 X_Global_Attribute11 => X_gf_Attribute11,
855 X_Global_Attribute12 => X_gf_Attribute12,
856 X_Global_Attribute13 => X_gf_Attribute13,
857 X_Global_Attribute14 => X_gf_Attribute14,
858 X_Global_Attribute15 => X_gf_Attribute15,
859 X_Global_Attribute16 => X_gf_Attribute16,
860 X_Global_Attribute17 => X_gf_Attribute17,
861 X_Global_Attribute18 => X_gf_Attribute18,
862 X_Global_Attribute19 => X_gf_Attribute19,
863 X_Global_Attribute20 => X_gf_Attribute20,
864 X_Inventorial => X_Inventorial,
865 X_Last_Update_Date => sysdate,
866 X_Last_Updated_By => user_id,
867 X_Last_Update_Login => 0
868 , p_log_level_rec => p_log_level_rec);
869 else
870 fa_categories_pkg.insert_row (
871 X_Rowid => row_id,
872 X_Category_Id => X_Category_Id,
873 X_Summary_Flag => X_Summary_Flag,
874 X_Enabled_Flag => X_Enabled_Flag,
875 X_Owned_Leased => X_Owned_Leased,
876 X_Category_Type => X_Category_Type,
877 X_Capitalize_Flag => X_Capitalize_Flag,
878 X_Description => X_Description,
879 X_Segment1 => X_Segment1,
880 X_Segment2 => X_Segment2,
881 X_Segment3 => X_Segment3,
882 X_Segment4 => X_Segment4,
883 X_Segment5 => X_Segment5,
884 X_Segment6 => X_Segment6,
885 X_Segment7 => X_Segment7,
886 X_Start_Date_Active => X_Start_Date_Active,
887 X_End_Date_Active => X_End_Date_Active,
888 X_Property_Type_Code => X_Property_Type_Code,
889 X_Property_1245_1250_Code => X_Property_1245_1250_Code,
890 X_Date_Ineffective => X_Date_Ineffective,
891 X_Attribute1 => X_Attribute1,
892 X_Attribute2 => X_Attribute2,
893 X_Attribute3 => X_Attribute3,
894 X_Attribute4 => X_Attribute4,
895 X_Attribute5 => X_Attribute5,
896 X_Attribute6 => X_Attribute6,
897 X_Attribute7 => X_Attribute7,
898 X_Attribute8 => X_Attribute8,
899 X_Attribute9 => X_Attribute9,
900 X_Attribute10 => X_Attribute10,
901 X_Attribute11 => X_Attribute11,
902 X_Attribute12 => X_Attribute12,
903 X_Attribute13 => X_Attribute13,
904 X_Attribute14 => X_Attribute14,
905 X_Attribute15 => X_Attribute15,
906 X_Production_Capacity => X_Production_Capacity,
907 X_Global_Attribute1 => X_gf_Attribute1,
908 X_Global_Attribute2 => X_gf_Attribute2,
909 X_Global_Attribute3 => X_gf_Attribute3,
910 X_Global_Attribute4 => X_gf_Attribute4,
911 X_Global_Attribute5 => X_gf_Attribute5,
912 X_Global_Attribute6 => X_gf_Attribute6,
913 X_Global_Attribute7 => X_gf_Attribute7,
914 X_Global_Attribute8 => X_gf_Attribute8,
915 X_Global_Attribute9 => X_gf_Attribute9,
916 X_Global_Attribute10 => X_gf_Attribute10,
917 X_Global_Attribute11 => X_gf_Attribute11,
918 X_Global_Attribute12 => X_gf_Attribute12,
919 X_Global_Attribute13 => X_gf_Attribute13,
920 X_Global_Attribute14 => X_gf_Attribute14,
921 X_Global_Attribute15 => X_gf_Attribute15,
922 X_Global_Attribute16 => X_gf_Attribute16,
923 X_Global_Attribute17 => X_gf_Attribute17,
924 X_Global_Attribute18 => X_gf_Attribute18,
925 X_Global_Attribute19 => X_gf_Attribute19,
926 X_Global_Attribute20 => X_gf_Attribute20,
927 X_Inventorial => X_Inventorial,
928 X_Creation_Date => sysdate,
929 X_Created_By => user_id,
930 X_Last_Update_Date => sysdate,
931 X_Last_Updated_By => user_id,
932 X_Last_Update_Login => 0
933 , p_log_level_rec => p_log_level_rec);
934 end if;
935
936 exception
937 when others then
938 FA_STANDARD_PKG.RAISE_ERROR(
939 CALLED_FN => 'fa_categories_pkg.load_row',
940 CALLING_FN => 'upload fa_additions', p_log_level_rec => p_log_level_rec);
941
942 end LOAD_ROW;
943
944 /*Bug 8355119 overloading function for release specific signatures*/
945 procedure LOAD_ROW (
946 X_CUSTOM_MODE in VARCHAR2,
947 X_CATEGORY_ID in NUMBER,
948 X_OWNER in VARCHAR2,
949 X_LAST_UPDATE_DATE in DATE,
950 X_SUMMARY_FLAG in VARCHAR2,
951 X_ENABLED_FLAG in VARCHAR2,
952 X_OWNED_LEASED in VARCHAR2,
953 X_PRODUCTION_CAPACITY in NUMBER DEFAULT NULL,
954 X_CATEGORY_TYPE in VARCHAR2,
955 X_CAPITALIZE_FLAG in VARCHAR2,
956 X_DESCRIPTION in VARCHAR2,
957 X_SEGMENT1 in VARCHAR2,
958 X_SEGMENT2 in VARCHAR2,
959 X_SEGMENT3 in VARCHAR2,
960 X_SEGMENT4 in VARCHAR2,
961 X_SEGMENT5 in VARCHAR2,
962 X_SEGMENT6 in VARCHAR2,
963 X_SEGMENT7 in VARCHAR2,
964 X_START_DATE_ACTIVE in DATE,
965 X_END_DATE_ACTIVE in DATE,
966 X_PROPERTY_TYPE_CODE in VARCHAR2,
967 X_PROPERTY_1245_1250_CODE in VARCHAR2,
968 X_DATE_INEFFECTIVE in DATE,
969 X_INVENTORIAL in VARCHAR2,
970 X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
971 X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
972 X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
973 X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
974 X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
975 X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
976 X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
977 X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
978 X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
979 X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
980 X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
981 X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
982 X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
983 X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
984 X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
985 X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2 DEFAULT NULL,
986 X_GF_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
987 X_GF_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
988 X_GF_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
989 X_GF_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
990 X_GF_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
991 X_GF_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
992 X_GF_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
993 X_GF_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
994 X_GF_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
995 X_GF_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
996 X_GF_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
997 X_GF_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
998 X_GF_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
999 X_GF_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
1000 X_GF_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
1001 X_GF_ATTRIBUTE16 in VARCHAR2 DEFAULT NULL,
1002 X_GF_ATTRIBUTE17 in VARCHAR2 DEFAULT NULL,
1003 X_GF_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
1004 X_GF_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
1005 X_GF_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
1006 X_GF_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
1007 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
1008
1009 h_record_exists number(15);
1010
1011 user_id number;
1012 row_id varchar2(64);
1013
1014 db_last_updated_by number;
1015 db_last_update_date date;
1016
1017 begin
1018
1019 user_id := fnd_load_util.owner_id (X_Owner);
1020
1021 select count(*)
1022 into h_record_exists
1023 from fa_categories_b
1024 where category_id = X_Category_Id;
1025
1026 if (h_record_exists > 0) then
1027
1028 select last_updated_by, last_update_date
1029 into db_last_updated_by, db_last_update_date
1030 from fa_categories_b
1031 where category_id = X_Category_Id;
1032
1033 if (fnd_load_util.upload_test(user_id, x_last_update_date,
1034 db_last_updated_by, db_last_update_date,
1035 X_CUSTOM_MODE)) then
1036
1037 fa_categories_pkg.update_row (
1038 X_Category_ID => X_Category_Id,
1039 X_Summary_Flag => X_Summary_Flag,
1040 X_Enabled_Flag => X_Enabled_Flag,
1041 X_Owned_Leased => X_Owned_Leased,
1042 X_Category_Type => X_Category_Type,
1043 X_Capitalize_Flag => X_Capitalize_Flag,
1044 X_Description => X_Description,
1045 X_Segment1 => X_Segment1,
1046 X_Segment2 => X_Segment2,
1047 X_Segment3 => X_Segment3,
1048 X_Segment4 => X_Segment4,
1049 X_Segment5 => X_Segment5,
1050 X_Segment6 => X_Segment6,
1051 X_Segment7 => X_Segment7,
1052 X_Start_Date_Active => X_Start_Date_Active,
1053 X_End_Date_Active => X_End_Date_Active,
1054 X_Property_Type_Code => X_Property_Type_Code,
1055 X_Property_1245_1250_Code => X_Property_1245_1250_Code,
1056 X_Date_Ineffective => X_Date_Ineffective,
1057 X_Attribute1 => X_Attribute1,
1058 X_Attribute2 => X_Attribute2,
1059 X_Attribute3 => X_Attribute3,
1060 X_Attribute4 => X_Attribute4,
1061 X_Attribute5 => X_Attribute5,
1062 X_Attribute6 => X_Attribute6,
1063 X_Attribute7 => X_Attribute7,
1064 X_Attribute8 => X_Attribute8,
1065 X_Attribute9 => X_Attribute9,
1066 X_Attribute10 => X_Attribute10,
1067 X_Attribute11 => X_Attribute11,
1068 X_Attribute12 => X_Attribute12,
1069 X_Attribute13 => X_Attribute13,
1070 X_Attribute14 => X_Attribute14,
1071 X_Attribute15 => X_Attribute15,
1072 X_Attribute_Category_Code => X_Attribute_Category_Code,
1073 X_Production_Capacity => X_Production_Capacity,
1074 X_Global_Attribute1 => X_gf_Attribute1,
1075 X_Global_Attribute2 => X_gf_Attribute2,
1076 X_Global_Attribute3 => X_gf_Attribute3,
1077 X_Global_Attribute4 => X_gf_Attribute4,
1078 X_Global_Attribute5 => X_gf_Attribute5,
1079 X_Global_Attribute6 => X_gf_Attribute6,
1080 X_Global_Attribute7 => X_gf_Attribute7,
1081 X_Global_Attribute8 => X_gf_Attribute8,
1082 X_Global_Attribute9 => X_gf_Attribute9,
1083 X_Global_Attribute10 => X_gf_Attribute10,
1084 X_Global_Attribute11 => X_gf_Attribute11,
1085 X_Global_Attribute12 => X_gf_Attribute12,
1086 X_Global_Attribute13 => X_gf_Attribute13,
1087 X_Global_Attribute14 => X_gf_Attribute14,
1088 X_Global_Attribute15 => X_gf_Attribute15,
1089 X_Global_Attribute16 => X_gf_Attribute16,
1090 X_Global_Attribute17 => X_gf_Attribute17,
1091 X_Global_Attribute18 => X_gf_Attribute18,
1092 X_Global_Attribute19 => X_gf_Attribute19,
1093 X_Global_Attribute20 => X_gf_Attribute20,
1094 X_Inventorial => X_Inventorial,
1095 X_Last_Update_Date => sysdate,
1096 X_Last_Updated_By => user_id,
1097 X_Last_Update_Login => 0
1098 ,p_log_level_rec => p_log_level_rec);
1099 end if;
1100 else
1101 fa_categories_pkg.insert_row (
1102 X_Rowid => row_id,
1103 X_Category_Id => X_Category_Id,
1104 X_Summary_Flag => X_Summary_Flag,
1105 X_Enabled_Flag => X_Enabled_Flag,
1106 X_Owned_Leased => X_Owned_Leased,
1107 X_Category_Type => X_Category_Type,
1108 X_Capitalize_Flag => X_Capitalize_Flag,
1109 X_Description => X_Description,
1110 X_Segment1 => X_Segment1,
1111 X_Segment2 => X_Segment2,
1112 X_Segment3 => X_Segment3,
1113 X_Segment4 => X_Segment4,
1114 X_Segment5 => X_Segment5,
1115 X_Segment6 => X_Segment6,
1116 X_Segment7 => X_Segment7,
1117 X_Start_Date_Active => X_Start_Date_Active,
1118 X_End_Date_Active => X_End_Date_Active,
1119 X_Property_Type_Code => X_Property_Type_Code,
1120 X_Property_1245_1250_Code => X_Property_1245_1250_Code,
1121 X_Date_Ineffective => X_Date_Ineffective,
1122 X_Attribute1 => X_Attribute1,
1123 X_Attribute2 => X_Attribute2,
1124 X_Attribute3 => X_Attribute3,
1125 X_Attribute4 => X_Attribute4,
1126 X_Attribute5 => X_Attribute5,
1127 X_Attribute6 => X_Attribute6,
1128 X_Attribute7 => X_Attribute7,
1129 X_Attribute8 => X_Attribute8,
1130 X_Attribute9 => X_Attribute9,
1131 X_Attribute10 => X_Attribute10,
1132 X_Attribute11 => X_Attribute11,
1133 X_Attribute12 => X_Attribute12,
1134 X_Attribute13 => X_Attribute13,
1135 X_Attribute14 => X_Attribute14,
1136 X_Attribute15 => X_Attribute15,
1137 X_Production_Capacity => X_Production_Capacity,
1138 X_Global_Attribute1 => X_gf_Attribute1,
1139 X_Global_Attribute2 => X_gf_Attribute2,
1140 X_Global_Attribute3 => X_gf_Attribute3,
1141 X_Global_Attribute4 => X_gf_Attribute4,
1142 X_Global_Attribute5 => X_gf_Attribute5,
1143 X_Global_Attribute6 => X_gf_Attribute6,
1144 X_Global_Attribute7 => X_gf_Attribute7,
1145 X_Global_Attribute8 => X_gf_Attribute8,
1146 X_Global_Attribute9 => X_gf_Attribute9,
1147 X_Global_Attribute10 => X_gf_Attribute10,
1148 X_Global_Attribute11 => X_gf_Attribute11,
1149 X_Global_Attribute12 => X_gf_Attribute12,
1150 X_Global_Attribute13 => X_gf_Attribute13,
1151 X_Global_Attribute14 => X_gf_Attribute14,
1152 X_Global_Attribute15 => X_gf_Attribute15,
1153 X_Global_Attribute16 => X_gf_Attribute16,
1154 X_Global_Attribute17 => X_gf_Attribute17,
1155 X_Global_Attribute18 => X_gf_Attribute18,
1156 X_Global_Attribute19 => X_gf_Attribute19,
1157 X_Global_Attribute20 => X_gf_Attribute20,
1158 X_Inventorial => X_Inventorial,
1159 X_Creation_Date => sysdate,
1160 X_Created_By => user_id,
1161 X_Last_Update_Date => sysdate,
1162 X_Last_Updated_By => user_id,
1163 X_Last_Update_Login => 0
1164 ,p_log_level_rec => p_log_level_rec);
1165 end if;
1166
1167 exception
1168 when others then
1169 FA_STANDARD_PKG.RAISE_ERROR(
1170 CALLED_FN => 'fa_categories_pkg.load_row',
1171 CALLING_FN => 'upload fa_additions'
1172 ,p_log_level_rec => p_log_level_rec);
1173
1174 end LOAD_ROW;
1175
1176 procedure TRANSLATE_ROW (
1177 X_CATEGORY_ID in NUMBER,
1178 X_DESCRIPTION in VARCHAR2
1179 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
1180 begin
1181
1182 update FA_CATEGORIES_TL set
1183 DESCRIPTION = nvl(X_Description, DESCRIPTION),
1184 LAST_UPDATE_DATE = sysdate,
1185 LAST_UPDATED_BY = 0,
1186 LAST_UPDATE_LOGIN = 0,
1187 SOURCE_LANG = userenv('LANG')
1188 where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1189 and CATEGORY_ID = X_Category_ID;
1190
1191 exception
1192 when no_data_found then null;
1193
1194 when others then
1195 FA_STANDARD_PKG.RAISE_ERROR(
1196 CALLED_FN => 'fa_categories_pkg.translate_row',
1197 CALLING_FN => 'upload fa_categories', p_log_level_rec => p_log_level_rec);
1198
1199 end TRANSLATE_ROW;
1200 /*Bug 8355119 overloading function for release specific signatures*/
1201 procedure TRANSLATE_ROW (
1202 X_CUSTOM_MODE in VARCHAR2,
1203 X_CATEGORY_ID in NUMBER,
1204 X_OWNER in VARCHAR2,
1205 X_LAST_UPDATE_DATE in DATE,
1206 X_DESCRIPTION in VARCHAR2,
1207 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
1208
1209 user_id number;
1210
1211 db_last_updated_by number;
1212 db_last_update_date date;
1213
1214 begin
1215
1216 select last_updated_by, last_update_date
1217 into db_last_updated_by, db_last_update_date
1218 from fa_categories_tl
1219 where category_id = X_Category_Id
1220 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1221
1222 user_id := fnd_load_util.owner_id (X_Owner);
1223
1224 if (fnd_load_util.upload_test(user_id, x_last_update_date,
1225 db_last_updated_by, db_last_update_date,
1226 X_CUSTOM_MODE)) then
1227
1228 update FA_CATEGORIES_TL set
1229 DESCRIPTION = nvl(X_Description, DESCRIPTION),
1230 LAST_UPDATE_DATE = sysdate,
1231 LAST_UPDATED_BY = 0,
1232 LAST_UPDATE_LOGIN = 0,
1233 SOURCE_LANG = userenv('LANG')
1234 where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1235 and CATEGORY_ID = X_Category_ID;
1236
1237 end if;
1238
1239 exception
1240 when no_data_found then null;
1241
1242 when others then
1243 FA_STANDARD_PKG.RAISE_ERROR(
1244 CALLED_FN => 'fa_categories_pkg.translate_row',
1245 CALLING_FN => 'upload fa_categories'
1246 ,p_log_level_rec => p_log_level_rec);
1247
1248 end TRANSLATE_ROW;
1249
1250 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
1251 procedure LOAD_SEED_ROW (
1252 x_upload_mode IN VARCHAR2,
1253 x_custom_mode IN VARCHAR2,
1254 x_category_id IN NUMBER,
1255 x_owner IN VARCHAR2,
1256 x_last_update_date IN DATE,
1257 x_summary_flag IN VARCHAR2,
1258 x_enabled_flag IN VARCHAR2,
1259 x_owned_leased IN VARCHAR2,
1260 x_production_capacity IN NUMBER,
1261 x_category_type IN VARCHAR2,
1262 x_capitalize_flag IN VARCHAR2,
1263 x_description IN VARCHAR2,
1264 x_segment1 IN VARCHAR2,
1265 x_segment2 IN VARCHAR2,
1266 x_segment3 IN VARCHAR2,
1267 x_segment4 IN VARCHAR2,
1268 x_segment5 IN VARCHAR2,
1269 x_segment6 IN VARCHAR2,
1270 x_segment7 IN VARCHAR2,
1271 x_start_date_active IN DATE,
1272 x_end_date_active IN DATE,
1273 x_property_type_code IN VARCHAR2,
1274 x_property_1245_1250_code IN VARCHAR2,
1275 x_date_ineffective IN DATE,
1276 x_inventorial IN VARCHAR2,
1277 x_attribute1 IN VARCHAR2,
1278 x_attribute2 IN VARCHAR2,
1279 x_attribute3 IN VARCHAR2,
1280 x_attribute4 IN VARCHAR2,
1281 x_attribute5 IN VARCHAR2,
1282 x_attribute6 IN VARCHAR2,
1283 x_attribute7 IN VARCHAR2,
1284 x_attribute8 IN VARCHAR2,
1285 x_attribute9 IN VARCHAR2,
1286 x_attribute10 IN VARCHAR2,
1287 x_attribute11 IN VARCHAR2,
1288 x_attribute12 IN VARCHAR2,
1289 x_attribute13 IN VARCHAR2,
1290 x_attribute14 IN VARCHAR2,
1291 x_attribute15 IN VARCHAR2,
1292 x_attribute_category_code IN VARCHAR2,
1293 x_gf_attribute1 IN VARCHAR2,
1294 x_gf_attribute2 IN VARCHAR2,
1295 x_gf_attribute3 IN VARCHAR2,
1296 x_gf_attribute4 IN VARCHAR2,
1297 x_gf_attribute5 IN VARCHAR2,
1298 x_gf_attribute6 IN VARCHAR2,
1299 x_gf_attribute7 IN VARCHAR2,
1300 x_gf_attribute8 IN VARCHAR2,
1301 x_gf_attribute9 IN VARCHAR2,
1302 x_gf_attribute10 IN VARCHAR2,
1303 x_gf_attribute11 IN VARCHAR2,
1304 x_gf_attribute12 IN VARCHAR2,
1305 x_gf_attribute13 IN VARCHAR2,
1306 x_gf_attribute14 IN VARCHAR2,
1307 x_gf_attribute15 IN VARCHAR2,
1308 x_gf_attribute16 IN VARCHAR2,
1309 x_gf_attribute17 IN VARCHAR2,
1310 x_gf_attribute18 IN VARCHAR2,
1311 x_gf_attribute19 IN VARCHAR2,
1312 x_gf_attribute20 IN VARCHAR2,
1313 x_gf_attribute_category IN VARCHAR2) IS
1314
1315 BEGIN
1316
1317 if (x_upload_mode = 'NLS') then
1318 fa_categories_pkg.TRANSLATE_ROW (
1319 x_custom_mode => x_custom_mode,
1320 x_category_id => x_category_id,
1321 x_owner => x_owner,
1322 x_last_update_date => x_last_update_date,
1323 x_description => x_description);
1324 else
1325 fa_categories_pkg.LOAD_ROW (
1326 x_custom_mode => x_custom_mode,
1327 x_category_id => x_category_id,
1328 x_owner => x_owner,
1329 x_last_update_date => x_last_update_date,
1330 x_summary_flag => x_summary_flag,
1331 x_enabled_flag => x_enabled_flag,
1332 x_owned_leased => x_owned_leased,
1333 x_production_capacity => x_production_capacity,
1334 x_category_type => x_category_type,
1335 x_capitalize_flag => x_capitalize_flag,
1336 x_description => x_description,
1337 x_segment1 => x_segment1,
1338 x_segment2 => x_segment2,
1339 x_segment3 => x_segment3,
1340 x_segment4 => x_segment4,
1341 x_segment5 => x_segment5,
1342 x_segment6 => x_segment6,
1343 x_segment7 => x_segment7,
1344 x_start_date_active => x_start_date_active,
1345 x_end_date_active => x_end_date_active,
1346 x_property_type_code => x_property_type_code,
1347 x_property_1245_1250_code => x_property_1245_1250_code,
1348 x_date_ineffective => x_date_ineffective,
1349 x_inventorial => x_inventorial,
1350 x_attribute1 => x_attribute1,
1351 x_attribute2 => x_attribute2,
1352 x_attribute3 => x_attribute3,
1353 x_attribute4 => x_attribute4,
1354 x_attribute5 => x_attribute5,
1355 x_attribute6 => x_attribute6,
1356 x_attribute7 => x_attribute7,
1357 x_attribute8 => x_attribute8,
1358 x_attribute9 => x_attribute9,
1359 x_attribute10 => x_attribute10,
1360 x_attribute11 => x_attribute11,
1361 x_attribute12 => x_attribute12,
1362 x_attribute13 => x_attribute13,
1363 x_attribute14 => x_attribute14,
1364 x_attribute15 => x_attribute15,
1365 x_attribute_category_code => x_attribute_category_code,
1366 x_gf_attribute1 => x_gf_attribute1,
1367 x_gf_attribute2 => x_gf_attribute2,
1368 x_gf_attribute3 => x_gf_attribute3,
1369 x_gf_attribute4 => x_gf_attribute4,
1370 x_gf_attribute5 => x_gf_attribute5,
1371 x_gf_attribute6 => x_gf_attribute6,
1372 x_gf_attribute7 => x_gf_attribute7,
1373 x_gf_attribute8 => x_gf_attribute8,
1374 x_gf_attribute9 => x_gf_attribute9,
1375 x_gf_attribute10 => x_gf_attribute10,
1376 x_gf_attribute11 => x_gf_attribute11,
1377 x_gf_attribute12 => x_gf_attribute12,
1378 x_gf_attribute13 => x_gf_attribute13,
1379 x_gf_attribute14 => x_gf_attribute14,
1380 x_gf_attribute15 => x_gf_attribute15,
1381 x_gf_attribute16 => x_gf_attribute16,
1382 x_gf_attribute17 => x_gf_attribute17,
1383 x_gf_attribute18 => x_gf_attribute18,
1384 x_gf_attribute19 => x_gf_attribute19,
1385 x_gf_attribute20 => x_gf_attribute20,
1386 x_gf_attribute_category => x_gf_attribute_category);
1387 end if;
1388
1389 END LOAD_SEED_ROW;
1390
1391 end FA_CATEGORIES_PKG;