[Home] [Help]
PACKAGE BODY: APPS.XDO_TEMPLATES_PKG
Source
1 package body XDO_TEMPLATES_PKG as
2 /* $Header: XDOTMPTB.pls 120.1.12010000.2 2008/10/17 20:13:49 bgkim ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_APPLICATION_SHORT_NAME in VARCHAR2,
7 X_TEMPLATE_CODE in VARCHAR2,
8 X_ATTRIBUTE6 in VARCHAR2,
9 X_ATTRIBUTE7 in VARCHAR2,
10 X_ATTRIBUTE8 in VARCHAR2,
11 X_ATTRIBUTE9 in VARCHAR2,
12 X_TEMPLATE_ID in NUMBER,
13 X_APPLICATION_ID in NUMBER,
14 X_DS_APP_SHORT_NAME in VARCHAR2,
15 X_DATA_SOURCE_CODE in VARCHAR2,
16 X_TEMPLATE_TYPE_CODE in VARCHAR2,
17 X_DEFAULT_LANGUAGE in VARCHAR2,
18 X_DEFAULT_TERRITORY in VARCHAR2,
19 X_DEFAULT_OUTPUT_TYPE in VARCHAR2,
20 X_MLS_LANGUAGE in VARCHAR2,
21 X_MLS_TERRITORY in VARCHAR2,
22 X_TEMPLATE_STATUS in VARCHAR2,
23 X_USE_ALIAS_TABLE in VARCHAR2,
24 X_START_DATE in DATE,
25 X_END_DATE in DATE,
26 X_DEPENDENCY_FLAG in VARCHAR2,
27 X_OBJECT_VERSION_NUMBER in NUMBER,
28 X_ATTRIBUTE_CATEGORY in VARCHAR2,
29 X_ATTRIBUTE1 in VARCHAR2,
30 X_ATTRIBUTE2 in VARCHAR2,
31 X_ATTRIBUTE3 in VARCHAR2,
32 X_ATTRIBUTE4 in VARCHAR2,
33 X_ATTRIBUTE5 in VARCHAR2,
34 X_ATTRIBUTE10 in VARCHAR2,
35 X_ATTRIBUTE11 in VARCHAR2,
36 X_ATTRIBUTE12 in VARCHAR2,
37 X_ATTRIBUTE13 in VARCHAR2,
38 X_ATTRIBUTE14 in VARCHAR2,
39 X_ATTRIBUTE15 in VARCHAR2,
40 X_TEMPLATE_NAME in VARCHAR2,
41 X_DESCRIPTION in VARCHAR2,
42 X_CREATION_DATE in DATE,
43 X_CREATED_BY in NUMBER,
44 X_LAST_UPDATE_DATE in DATE,
45 X_LAST_UPDATED_BY in NUMBER,
46 X_LAST_UPDATE_LOGIN in NUMBER
47 ) is
48 cursor C is select ROWID from XDO_TEMPLATES_B
49 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
50 and TEMPLATE_CODE = X_TEMPLATE_CODE
51 ;
52 begin
53 insert into XDO_TEMPLATES_B (
54 ATTRIBUTE6,
55 ATTRIBUTE7,
56 ATTRIBUTE8,
57 ATTRIBUTE9,
58 TEMPLATE_ID,
59 APPLICATION_ID,
60 APPLICATION_SHORT_NAME,
61 TEMPLATE_CODE,
62 DS_APP_SHORT_NAME,
63 DATA_SOURCE_CODE,
64 TEMPLATE_TYPE_CODE,
65 DEFAULT_LANGUAGE,
66 DEFAULT_TERRITORY,
67 DEFAULT_OUTPUT_TYPE,
68 MLS_LANGUAGE,
69 MLS_TERRITORY,
70 TEMPLATE_STATUS,
71 USE_ALIAS_TABLE,
72 START_DATE,
73 END_DATE,
74 DEPENDENCY_FLAG,
75 OBJECT_VERSION_NUMBER,
76 ATTRIBUTE_CATEGORY,
77 ATTRIBUTE1,
78 ATTRIBUTE2,
79 ATTRIBUTE3,
80 ATTRIBUTE4,
81 ATTRIBUTE5,
82 ATTRIBUTE10,
83 ATTRIBUTE11,
84 ATTRIBUTE12,
85 ATTRIBUTE13,
86 ATTRIBUTE14,
87 ATTRIBUTE15,
88 CREATION_DATE,
89 CREATED_BY,
90 LAST_UPDATE_DATE,
91 LAST_UPDATED_BY,
92 LAST_UPDATE_LOGIN
93 ) values (
94 X_ATTRIBUTE6,
95 X_ATTRIBUTE7,
96 X_ATTRIBUTE8,
97 X_ATTRIBUTE9,
98 X_TEMPLATE_ID,
99 X_APPLICATION_ID,
100 X_APPLICATION_SHORT_NAME,
101 X_TEMPLATE_CODE,
102 X_DS_APP_SHORT_NAME,
103 X_DATA_SOURCE_CODE,
104 X_TEMPLATE_TYPE_CODE,
105 X_DEFAULT_LANGUAGE,
106 X_DEFAULT_TERRITORY,
107 X_DEFAULT_OUTPUT_TYPE,
108 X_MLS_LANGUAGE,
109 X_MLS_TERRITORY,
110 X_TEMPLATE_STATUS,
111 X_USE_ALIAS_TABLE,
112 X_START_DATE,
113 X_END_DATE,
114 nvl(X_DEPENDENCY_FLAG,'P'),
115 X_OBJECT_VERSION_NUMBER,
116 X_ATTRIBUTE_CATEGORY,
117 X_ATTRIBUTE1,
118 X_ATTRIBUTE2,
119 X_ATTRIBUTE3,
120 X_ATTRIBUTE4,
121 X_ATTRIBUTE5,
122 X_ATTRIBUTE10,
123 X_ATTRIBUTE11,
124 X_ATTRIBUTE12,
125 X_ATTRIBUTE13,
126 X_ATTRIBUTE14,
127 X_ATTRIBUTE15,
128 X_CREATION_DATE,
129 X_CREATED_BY,
130 X_LAST_UPDATE_DATE,
131 X_LAST_UPDATED_BY,
132 X_LAST_UPDATE_LOGIN
133 );
134
135 insert into XDO_TEMPLATES_TL (
136 APPLICATION_SHORT_NAME,
137 TEMPLATE_CODE,
138 TEMPLATE_NAME,
139 DESCRIPTION,
140 CREATED_BY,
141 CREATION_DATE,
142 LAST_UPDATED_BY,
143 LAST_UPDATE_DATE,
144 LAST_UPDATE_LOGIN,
145 LANGUAGE,
146 SOURCE_LANG
147 ) select
148 X_APPLICATION_SHORT_NAME,
149 X_TEMPLATE_CODE,
150 X_TEMPLATE_NAME,
151 X_DESCRIPTION,
152 X_CREATED_BY,
153 X_CREATION_DATE,
154 X_LAST_UPDATED_BY,
155 X_LAST_UPDATE_DATE,
156 X_LAST_UPDATE_LOGIN,
157 L.LANGUAGE_CODE,
158 userenv('LANG')
159 from FND_LANGUAGES L
160 where L.INSTALLED_FLAG in ('I', 'B')
161 and not exists
162 (select NULL
163 from XDO_TEMPLATES_TL T
164 where T.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
165 and T.TEMPLATE_CODE = X_TEMPLATE_CODE
166 and T.LANGUAGE = L.LANGUAGE_CODE);
167
168 open c;
169 fetch c into X_ROWID;
170 if (c%notfound) then
171 close c;
172 raise no_data_found;
173 end if;
174 close c;
175
176 end INSERT_ROW;
177
178 -- Backward Compatibility Wrapper
179 -- This procedure always set DEPENDENCY_FLAG to 'P'
180 procedure INSERT_ROW (
181 X_ROWID in out nocopy VARCHAR2,
182 X_APPLICATION_SHORT_NAME in VARCHAR2,
183 X_TEMPLATE_CODE in VARCHAR2,
184 X_ATTRIBUTE6 in VARCHAR2,
185 X_ATTRIBUTE7 in VARCHAR2,
186 X_ATTRIBUTE8 in VARCHAR2,
187 X_ATTRIBUTE9 in VARCHAR2,
188 X_TEMPLATE_ID in NUMBER,
189 X_APPLICATION_ID in NUMBER,
190 X_DS_APP_SHORT_NAME in VARCHAR2,
191 X_DATA_SOURCE_CODE in VARCHAR2,
192 X_TEMPLATE_TYPE_CODE in VARCHAR2,
193 X_DEFAULT_LANGUAGE in VARCHAR2,
194 X_DEFAULT_TERRITORY in VARCHAR2,
195 X_DEFAULT_OUTPUT_TYPE in VARCHAR2,
196 X_MLS_LANGUAGE in VARCHAR2,
197 X_MLS_TERRITORY in VARCHAR2,
198 X_TEMPLATE_STATUS in VARCHAR2,
199 X_USE_ALIAS_TABLE in VARCHAR2,
200 X_START_DATE in DATE,
201 X_END_DATE in DATE,
202 X_OBJECT_VERSION_NUMBER in NUMBER,
203 X_ATTRIBUTE_CATEGORY in VARCHAR2,
204 X_ATTRIBUTE1 in VARCHAR2,
205 X_ATTRIBUTE2 in VARCHAR2,
206 X_ATTRIBUTE3 in VARCHAR2,
207 X_ATTRIBUTE4 in VARCHAR2,
208 X_ATTRIBUTE5 in VARCHAR2,
209 X_ATTRIBUTE10 in VARCHAR2,
210 X_ATTRIBUTE11 in VARCHAR2,
211 X_ATTRIBUTE12 in VARCHAR2,
212 X_ATTRIBUTE13 in VARCHAR2,
213 X_ATTRIBUTE14 in VARCHAR2,
214 X_ATTRIBUTE15 in VARCHAR2,
215 X_TEMPLATE_NAME in VARCHAR2,
216 X_DESCRIPTION in VARCHAR2,
217 X_CREATION_DATE in DATE,
218 X_CREATED_BY in NUMBER,
219 X_LAST_UPDATE_DATE in DATE,
220 X_LAST_UPDATED_BY in NUMBER,
221 X_LAST_UPDATE_LOGIN in NUMBER
222 ) is
223
224 begin
225
226 INSERT_ROW (
227 X_ROWID => X_ROWID,
228 X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
229 X_TEMPLATE_CODE => X_TEMPLATE_CODE,
230 X_ATTRIBUTE6 => X_ATTRIBUTE6,
231 X_ATTRIBUTE7 => X_ATTRIBUTE7,
232 X_ATTRIBUTE8 => X_ATTRIBUTE8,
233 X_ATTRIBUTE9 => X_ATTRIBUTE9,
234 X_TEMPLATE_ID => X_TEMPLATE_ID,
235 X_APPLICATION_ID => X_APPLICATION_ID,
236 X_DS_APP_SHORT_NAME => X_DS_APP_SHORT_NAME,
237 X_DATA_SOURCE_CODE => X_DATA_SOURCE_CODE,
238 X_TEMPLATE_TYPE_CODE => X_TEMPLATE_TYPE_CODE,
239 X_DEFAULT_LANGUAGE => X_DEFAULT_LANGUAGE,
240 X_DEFAULT_TERRITORY => X_DEFAULT_TERRITORY,
241 X_DEFAULT_OUTPUT_TYPE => X_DEFAULT_OUTPUT_TYPE,
242 X_MLS_LANGUAGE => X_MLS_LANGUAGE,
243 X_MLS_TERRITORY => X_MLS_TERRITORY,
244 X_TEMPLATE_STATUS => X_TEMPLATE_STATUS,
245 X_USE_ALIAS_TABLE => X_USE_ALIAS_TABLE,
246 X_START_DATE => X_START_DATE,
247 X_END_DATE => X_END_DATE,
248 X_DEPENDENCY_FLAG => 'P',
249 X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
250 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
251 X_ATTRIBUTE1 => X_ATTRIBUTE1,
252 X_ATTRIBUTE2 => X_ATTRIBUTE2,
253 X_ATTRIBUTE3 => X_ATTRIBUTE3,
254 X_ATTRIBUTE4 => X_ATTRIBUTE4,
255 X_ATTRIBUTE5 => X_ATTRIBUTE5,
256 X_ATTRIBUTE10 => X_ATTRIBUTE10,
257 X_ATTRIBUTE11 => X_ATTRIBUTE11,
258 X_ATTRIBUTE12 => X_ATTRIBUTE12,
259 X_ATTRIBUTE13 => X_ATTRIBUTE13,
260 X_ATTRIBUTE14 => X_ATTRIBUTE14,
261 X_ATTRIBUTE15 => X_ATTRIBUTE15,
262 X_TEMPLATE_NAME => X_TEMPLATE_NAME,
263 X_DESCRIPTION => X_DESCRIPTION,
264 X_CREATION_DATE => X_CREATION_DATE,
265 X_CREATED_BY => X_CREATED_BY,
266 X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
267 X_LAST_UPDATED_BY => X_LAST_UPDATED_BY,
268 X_LAST_UPDATE_LOGIN => X_LAST_UPDATE_LOGIN
269 );
270
271 end INSERT_ROW;
272
273 procedure LOCK_ROW (
274 X_APPLICATION_SHORT_NAME in VARCHAR2,
275 X_TEMPLATE_CODE in VARCHAR2,
276 X_ATTRIBUTE6 in VARCHAR2,
277 X_ATTRIBUTE7 in VARCHAR2,
278 X_ATTRIBUTE8 in VARCHAR2,
279 X_ATTRIBUTE9 in VARCHAR2,
280 X_TEMPLATE_ID in NUMBER,
281 X_APPLICATION_ID in NUMBER,
282 X_DS_APP_SHORT_NAME in VARCHAR2,
283 X_DATA_SOURCE_CODE in VARCHAR2,
284 X_TEMPLATE_TYPE_CODE in VARCHAR2,
285 X_DEFAULT_LANGUAGE in VARCHAR2,
286 X_DEFAULT_TERRITORY in VARCHAR2,
287 X_DEFAULT_OUTPUT_TYPE in VARCHAR2,
288 X_MLS_LANGUAGE in VARCHAR2,
289 X_MLS_TERRITORY in VARCHAR2,
290 X_TEMPLATE_STATUS in VARCHAR2,
291 X_USE_ALIAS_TABLE in VARCHAR2,
292 X_START_DATE in DATE,
293 X_END_DATE in DATE,
294 X_DEPENDENCY_FLAG in VARCHAR2,
295 X_OBJECT_VERSION_NUMBER in NUMBER,
296 X_ATTRIBUTE_CATEGORY in VARCHAR2,
297 X_ATTRIBUTE1 in VARCHAR2,
298 X_ATTRIBUTE2 in VARCHAR2,
299 X_ATTRIBUTE3 in VARCHAR2,
300 X_ATTRIBUTE4 in VARCHAR2,
301 X_ATTRIBUTE5 in VARCHAR2,
302 X_ATTRIBUTE10 in VARCHAR2,
303 X_ATTRIBUTE11 in VARCHAR2,
304 X_ATTRIBUTE12 in VARCHAR2,
305 X_ATTRIBUTE13 in VARCHAR2,
306 X_ATTRIBUTE14 in VARCHAR2,
307 X_ATTRIBUTE15 in VARCHAR2,
308 X_TEMPLATE_NAME in VARCHAR2,
309 X_DESCRIPTION in VARCHAR2
310 ) is
311 cursor c is select
312 ATTRIBUTE6,
313 ATTRIBUTE7,
314 ATTRIBUTE8,
315 ATTRIBUTE9,
316 TEMPLATE_ID,
317 APPLICATION_ID,
318 DS_APP_SHORT_NAME,
319 DATA_SOURCE_CODE,
320 TEMPLATE_TYPE_CODE,
321 DEFAULT_LANGUAGE,
322 DEFAULT_TERRITORY,
323 DEFAULT_OUTPUT_TYPE,
324 MLS_LANGUAGE,
325 MLS_TERRITORY,
326 TEMPLATE_STATUS,
327 USE_ALIAS_TABLE,
328 START_DATE,
329 END_DATE,
330 DEPENDENCY_FLAG,
331 OBJECT_VERSION_NUMBER,
332 ATTRIBUTE_CATEGORY,
333 ATTRIBUTE1,
334 ATTRIBUTE2,
335 ATTRIBUTE3,
336 ATTRIBUTE4,
337 ATTRIBUTE5,
338 ATTRIBUTE10,
339 ATTRIBUTE11,
340 ATTRIBUTE12,
341 ATTRIBUTE13,
342 ATTRIBUTE14,
343 ATTRIBUTE15
344 from XDO_TEMPLATES_B
345 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
346 and TEMPLATE_CODE = X_TEMPLATE_CODE
347 for update of APPLICATION_SHORT_NAME nowait;
348 recinfo c%rowtype;
349
350 cursor c1 is select
351 TEMPLATE_NAME,
352 DESCRIPTION,
353 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
354 from XDO_TEMPLATES_TL
355 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
356 and TEMPLATE_CODE = X_TEMPLATE_CODE
357 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
358 for update of APPLICATION_SHORT_NAME nowait;
359 begin
360 open c;
361 fetch c into recinfo;
362 if (c%notfound) then
363 close c;
364 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
365 app_exception.raise_exception;
366 end if;
367 close c;
368 if ( ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
369 OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
370 AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
371 OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
372 AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
373 OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
374 AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
375 OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
376 AND (recinfo.TEMPLATE_ID = X_TEMPLATE_ID)
377 AND (recinfo.APPLICATION_ID = X_APPLICATION_ID)
378 AND ((recinfo.DS_APP_SHORT_NAME = X_DS_APP_SHORT_NAME)
379 OR ((recinfo.DS_APP_SHORT_NAME is null) AND (X_DS_APP_SHORT_NAME is null)))
380 AND ((recinfo.DATA_SOURCE_CODE = X_DATA_SOURCE_CODE)
381 OR ((recinfo.DATA_SOURCE_CODE is null) AND (X_DATA_SOURCE_CODE is null)))
382 AND (recinfo.TEMPLATE_TYPE_CODE = X_TEMPLATE_TYPE_CODE)
383 AND (recinfo.DEFAULT_LANGUAGE = X_DEFAULT_LANGUAGE)
384 AND (recinfo.DEFAULT_TERRITORY = X_DEFAULT_TERRITORY)
385 AND ((recinfo.DEFAULT_OUTPUT_TYPE = X_DEFAULT_OUTPUT_TYPE)
386 OR ((recinfo.DEFAULT_OUTPUT_TYPE is null) AND (X_DEFAULT_OUTPUT_TYPE is null)))
387 AND ((recinfo.MLS_LANGUAGE = X_MLS_LANGUAGE)
388 OR ((recinfo.MLS_LANGUAGE is null) AND (X_MLS_LANGUAGE is null)))
389 AND ((recinfo.MLS_TERRITORY = X_MLS_TERRITORY)
390 OR ((recinfo.MLS_TERRITORY is null) AND (X_MLS_TERRITORY is null)))
391 AND (recinfo.TEMPLATE_STATUS = X_TEMPLATE_STATUS)
392 AND (recinfo.USE_ALIAS_TABLE = X_USE_ALIAS_TABLE)
393 AND (recinfo.START_DATE = X_START_DATE)
394 AND ((recinfo.END_DATE = X_END_DATE)
395 OR ((recinfo.END_DATE is null) AND (X_END_DATE is null)))
396 AND ((recinfo.DEPENDENCY_FLAG = X_DEPENDENCY_FLAG)
397 OR ((recinfo.DEPENDENCY_FLAG is null) AND (X_DEPENDENCY_FLAG is null)))
398 AND (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
399 AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
400 OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
401 AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
402 OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
403 AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
404 OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
405 AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
406 OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
407 AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
408 OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
409 AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
413 AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
410 OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
411 AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
412 OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
414 OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
415 AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
416 OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
417 AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
418 OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
419 AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
420 OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
421 AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
422 OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
423 ) then
424 null;
425 else
426 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
427 app_exception.raise_exception;
428 end if;
429
430 for tlinfo in c1 loop
431 if (tlinfo.BASELANG = 'Y') then
432 if ( (tlinfo.TEMPLATE_NAME = X_TEMPLATE_NAME)
433 AND ((tlinfo.DESCRIPTION = X_DESCRIPTION)
434 OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
435 ) then
436 null;
437 else
438 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
439 app_exception.raise_exception;
440 end if;
441 end if;
442 end loop;
443 return;
444 end LOCK_ROW;
445
446 procedure UPDATE_ROW (
447 X_APPLICATION_SHORT_NAME in VARCHAR2,
448 X_TEMPLATE_CODE in VARCHAR2,
449 X_ATTRIBUTE6 in VARCHAR2,
450 X_ATTRIBUTE7 in VARCHAR2,
451 X_ATTRIBUTE8 in VARCHAR2,
452 X_ATTRIBUTE9 in VARCHAR2,
453 X_TEMPLATE_ID in NUMBER,
454 X_APPLICATION_ID in NUMBER,
455 X_DS_APP_SHORT_NAME in VARCHAR2,
456 X_DATA_SOURCE_CODE in VARCHAR2,
457 X_TEMPLATE_TYPE_CODE in VARCHAR2,
458 X_DEFAULT_LANGUAGE in VARCHAR2,
459 X_DEFAULT_TERRITORY in VARCHAR2,
460 X_DEFAULT_OUTPUT_TYPE in VARCHAR2,
461 X_MLS_LANGUAGE in VARCHAR2,
462 X_MLS_TERRITORY in VARCHAR2,
463 X_TEMPLATE_STATUS in VARCHAR2,
464 X_USE_ALIAS_TABLE in VARCHAR2,
465 X_START_DATE in DATE,
466 X_END_DATE in DATE,
467 X_DEPENDENCY_FLAG in VARCHAR2,
468 X_OBJECT_VERSION_NUMBER in NUMBER,
469 X_ATTRIBUTE_CATEGORY in VARCHAR2,
470 X_ATTRIBUTE1 in VARCHAR2,
471 X_ATTRIBUTE2 in VARCHAR2,
472 X_ATTRIBUTE3 in VARCHAR2,
473 X_ATTRIBUTE4 in VARCHAR2,
474 X_ATTRIBUTE5 in VARCHAR2,
475 X_ATTRIBUTE10 in VARCHAR2,
476 X_ATTRIBUTE11 in VARCHAR2,
477 X_ATTRIBUTE12 in VARCHAR2,
478 X_ATTRIBUTE13 in VARCHAR2,
479 X_ATTRIBUTE14 in VARCHAR2,
480 X_ATTRIBUTE15 in VARCHAR2,
481 X_TEMPLATE_NAME in VARCHAR2,
482 X_DESCRIPTION in VARCHAR2,
483 X_LAST_UPDATE_DATE in DATE,
484 X_LAST_UPDATED_BY in NUMBER,
485 X_LAST_UPDATE_LOGIN in NUMBER
486 ) is
487 begin
488 update XDO_TEMPLATES_B set
489 ATTRIBUTE6 = X_ATTRIBUTE6,
490 ATTRIBUTE7 = X_ATTRIBUTE7,
491 ATTRIBUTE8 = X_ATTRIBUTE8,
492 ATTRIBUTE9 = X_ATTRIBUTE9,
493 TEMPLATE_ID = X_TEMPLATE_ID,
494 APPLICATION_ID = X_APPLICATION_ID,
495 DS_APP_SHORT_NAME = X_DS_APP_SHORT_NAME,
496 DATA_SOURCE_CODE = X_DATA_SOURCE_CODE,
497 TEMPLATE_TYPE_CODE = X_TEMPLATE_TYPE_CODE,
498 DEFAULT_LANGUAGE = X_DEFAULT_LANGUAGE,
499 DEFAULT_TERRITORY = X_DEFAULT_TERRITORY,
500 DEFAULT_OUTPUT_TYPE = X_DEFAULT_OUTPUT_TYPE,
501 MLS_LANGUAGE = X_MLS_LANGUAGE,
502 MLS_TERRITORY = X_MLS_TERRITORY,
503 TEMPLATE_STATUS = X_TEMPLATE_STATUS,
504 USE_ALIAS_TABLE = X_USE_ALIAS_TABLE,
505 START_DATE = X_START_DATE,
506 END_DATE = X_END_DATE,
507 DEPENDENCY_FLAG = X_DEPENDENCY_FLAG,
508 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
509 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
510 ATTRIBUTE1 = X_ATTRIBUTE1,
511 ATTRIBUTE2 = X_ATTRIBUTE2,
512 ATTRIBUTE3 = X_ATTRIBUTE3,
513 ATTRIBUTE4 = X_ATTRIBUTE4,
514 ATTRIBUTE5 = X_ATTRIBUTE5,
515 ATTRIBUTE10 = X_ATTRIBUTE10,
516 ATTRIBUTE11 = X_ATTRIBUTE11,
517 ATTRIBUTE12 = X_ATTRIBUTE12,
518 ATTRIBUTE13 = X_ATTRIBUTE13,
519 ATTRIBUTE14 = X_ATTRIBUTE14,
520 ATTRIBUTE15 = X_ATTRIBUTE15,
521 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
522 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
523 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
524 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
525 and TEMPLATE_CODE = X_TEMPLATE_CODE;
526
527 if (sql%notfound) then
528 raise no_data_found;
529 end if;
530
531 update XDO_TEMPLATES_TL set
532 TEMPLATE_NAME = X_TEMPLATE_NAME,
533 DESCRIPTION = X_DESCRIPTION,
534 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
535 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
536 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
537 SOURCE_LANG = userenv('LANG')
538 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
539 and TEMPLATE_CODE = X_TEMPLATE_CODE
540 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
541
542 if (sql%notfound) then
543 raise no_data_found;
544 end if;
545 end UPDATE_ROW;
546
550 ) is
547 procedure DELETE_ROW (
548 X_APPLICATION_SHORT_NAME in VARCHAR2,
549 X_TEMPLATE_CODE in VARCHAR2
551 begin
552 delete from XDO_TEMPLATES_TL
553 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
554 and TEMPLATE_CODE = X_TEMPLATE_CODE;
555
556 if (sql%notfound) then
557 raise no_data_found;
558 end if;
559
560 delete from XDO_TEMPLATES_B
561 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
562 and TEMPLATE_CODE = X_TEMPLATE_CODE;
563
564 if (sql%notfound) then
565 raise no_data_found;
566 end if;
567 end DELETE_ROW;
568
569 procedure ADD_LANGUAGE
570 is
571 begin
572 delete from XDO_TEMPLATES_TL T
573 where not exists
574 (select NULL
575 from XDO_TEMPLATES_B B
576 where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
577 and B.TEMPLATE_CODE = T.TEMPLATE_CODE
578 );
579
580 update XDO_TEMPLATES_TL T set (
581 TEMPLATE_NAME,
582 DESCRIPTION
583 ) = (select
584 B.TEMPLATE_NAME,
585 B.DESCRIPTION
586 from XDO_TEMPLATES_TL B
587 where B.APPLICATION_SHORT_NAME = T.APPLICATION_SHORT_NAME
588 and B.TEMPLATE_CODE = T.TEMPLATE_CODE
589 and B.LANGUAGE = T.SOURCE_LANG)
590 where (
591 T.APPLICATION_SHORT_NAME,
592 T.TEMPLATE_CODE,
593 T.LANGUAGE
594 ) in (select
595 SUBT.APPLICATION_SHORT_NAME,
596 SUBT.TEMPLATE_CODE,
597 SUBT.LANGUAGE
598 from XDO_TEMPLATES_TL SUBB, XDO_TEMPLATES_TL SUBT
599 where SUBB.APPLICATION_SHORT_NAME = SUBT.APPLICATION_SHORT_NAME
600 and SUBB.TEMPLATE_CODE = SUBT.TEMPLATE_CODE
601 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
602 and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
603 or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
604 or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
605 or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
606 ));
607
608 insert into XDO_TEMPLATES_TL (
609 APPLICATION_SHORT_NAME,
610 TEMPLATE_CODE,
611 TEMPLATE_NAME,
612 DESCRIPTION,
613 CREATED_BY,
614 CREATION_DATE,
615 LAST_UPDATED_BY,
616 LAST_UPDATE_DATE,
617 LAST_UPDATE_LOGIN,
618 LANGUAGE,
619 SOURCE_LANG
620 ) select /*+ ORDERED */
621 B.APPLICATION_SHORT_NAME,
622 B.TEMPLATE_CODE,
623 B.TEMPLATE_NAME,
624 B.DESCRIPTION,
625 B.CREATED_BY,
626 B.CREATION_DATE,
627 B.LAST_UPDATED_BY,
628 B.LAST_UPDATE_DATE,
629 B.LAST_UPDATE_LOGIN,
630 L.LANGUAGE_CODE,
631 B.SOURCE_LANG
632 from XDO_TEMPLATES_TL B, FND_LANGUAGES L
633 where L.INSTALLED_FLAG in ('I', 'B')
634 and B.LANGUAGE = userenv('LANG')
635 and not exists
636 (select NULL
637 from XDO_TEMPLATES_TL T
638 where T.APPLICATION_SHORT_NAME = B.APPLICATION_SHORT_NAME
639 and T.TEMPLATE_CODE = B.TEMPLATE_CODE
640 and T.LANGUAGE = L.LANGUAGE_CODE);
641 end ADD_LANGUAGE;
642
643 procedure TRANSLATE_ROW (
644 X_APPLICATION_SHORT_NAME in VARCHAR2,
645 X_TEMPLATE_CODE in VARCHAR2,
646 X_TEMPLATE_NAME in VARCHAR2,
647 X_DESCRIPTION in VARCHAR2,
648 X_OWNER in VARCHAR2,
649 X_LAST_UPDATE_DATE in VARCHAR2,
650 X_CUSTOM_MODE in VARCHAR2
651 ) is
652 f_luby number; -- entity owner in file
653 f_ludate date; -- entity update date in file
654 db_luby number; -- entity owner in db
655 db_ludate date; -- entity update date in db
656 begin
657
658 -- Translate owner to file_last_updated_by
659 f_luby := fnd_load_util.OWNER_ID(x_owner);
660
661 -- Translate char last_update_date to date
662 f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
663
664 begin
665 select LAST_UPDATED_BY, LAST_UPDATE_DATE
666 into db_luby, db_ludate
667 from XDO_TEMPLATES_TL
668 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
669 and TEMPLATE_CODE = X_TEMPLATE_CODE
670 and LANGUAGE = userenv('LANG');
671
672 -- Update record, honoring customization mode.
673 -- Record should be updated only if:
674 -- a. CUSTOM_MODE = FORCE, or
675 -- b. file owner is USER, db owner is SEED
676 -- c. owners are the same, and file_date > db_date
677 if (fnd_load_util.UPLOAD_TEST(
678 p_file_id => f_luby,
679 p_file_lud => f_ludate,
680 p_db_id => db_luby,
681 p_db_lud => db_ludate,
682 p_custom_mode => x_custom_mode))
683 then
684 update XDO_TEMPLATES_TL set
685 TEMPLATE_NAME =
686 nvl(x_template_name, template_name),
687 DESCRIPTION = nvl(x_description, DESCRIPTION),
688 SOURCE_LANG = userenv('LANG'),
689 LAST_UPDATE_DATE = f_ludate,
690 LAST_UPDATED_BY = f_luby,
691 LAST_UPDATE_LOGIN = 0
692 where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
693 and TEMPLATE_CODE = X_TEMPLATE_CODE
694 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
695 end if;
696 exception
697 when no_data_found then
698 null;
699 end;
703 X_APPLICATION_SHORT_NAME in VARCHAR2,
700 end TRANSLATE_ROW;
701
702 procedure LOAD_ROW (
704 X_TEMPLATE_CODE in VARCHAR2,
705 X_DS_APP_SHORT_NAME in VARCHAR2,
706 X_DATA_SOURCE_CODE in VARCHAR2,
707 X_TEMPLATE_TYPE_CODE in VARCHAR2,
708 X_DEFAULT_LANGUAGE in VARCHAR2,
709 X_DEFAULT_TERRITORY in VARCHAR2,
710 X_DEFAULT_OUTPUT_TYPE in VARCHAR2,
711 X_MLS_LANGUAGE in VARCHAR2,
712 X_MLS_TERRITORY in VARCHAR2,
713 X_TEMPLATE_STATUS in VARCHAR2,
714 X_USE_ALIAS_TABLE in VARCHAR2,
715 X_START_DATE in VARCHAR2,
716 X_END_DATE in VARCHAR2,
717 X_TEMPLATE_NAME in VARCHAR2,
718 X_DESCRIPTION in VARCHAR2,
719 X_OWNER in VARCHAR2,
720 X_LAST_UPDATE_DATE in VARCHAR2,
721 X_CUSTOM_MODE in VARCHAR2,
722 X_DEPENDENCY_FLAG in VARCHAR2,
723 X_OBJECT_VERSION_NUMBER in NUMBER,
724 X_ATTRIBUTE_CATEGORY in VARCHAR2,
725 X_ATTRIBUTE1 in VARCHAR2,
726 X_ATTRIBUTE2 in VARCHAR2,
727 X_ATTRIBUTE3 in VARCHAR2,
728 X_ATTRIBUTE4 in VARCHAR2,
729 X_ATTRIBUTE5 in VARCHAR2,
730 X_ATTRIBUTE6 in VARCHAR2,
731 X_ATTRIBUTE7 in VARCHAR2,
732 X_ATTRIBUTE8 in VARCHAR2,
733 X_ATTRIBUTE9 in VARCHAR2,
734 X_ATTRIBUTE10 in VARCHAR2,
735 X_ATTRIBUTE11 in VARCHAR2,
736 X_ATTRIBUTE12 in VARCHAR2,
737 X_ATTRIBUTE13 in VARCHAR2,
738 X_ATTRIBUTE14 in VARCHAR2,
739 X_ATTRIBUTE15 in VARCHAR2
740 ) is
741 app_id number;
742 tmpl_id number;
743 f_luby number; -- entity owner in file
744 f_ludate date; -- entity update date in file
745 db_luby number; -- entity owner in db
746 db_ludate date; -- entity update date in db
747 row_id varchar2(64);
748
749 begin
750
751 -- Translate owner to file_last_updated_by
752 f_luby := fnd_load_util.owner_id(x_owner);
753
754 -- Translate char last_update_date to date
755 f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
756
757 begin
758 select application_id into app_id
759 from fnd_application
760 where application_short_name=x_application_short_name;
761 exception
762 when no_data_found then
763 fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
764 fnd_message.set_token('TABLE', 'FND_APPLICATION');
765 fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
766 fnd_message.set_token('VALUE', x_application_short_name);
767 app_exception.raise_exception;
768 end;
769
770 begin
771 select TEMPLATE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
772 into tmpl_id, db_luby, db_ludate
773 from xdo_templates_b
774 where template_code=x_template_code
775 and application_short_name=x_application_short_name;
776
777 -- Update record, honoring customization mode.
778 -- Record should be updated only if:
779 -- a. CUSTOM_MODE = FORCE, or
780 -- b. file owner is CUSTOM, db owner is SEED
781 -- c. owners are the same, and file_date > db_date
782 if (fnd_load_util.UPLOAD_TEST(
783 p_file_id => f_luby,
784 p_file_lud => f_ludate,
785 p_db_id => db_luby,
786 p_db_lud => db_ludate,
787 p_custom_mode => x_custom_mode))
788 then
789 XDO_TEMPLATES_PKG.UPDATE_ROW(
790 X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
791 X_TEMPLATE_CODE => X_TEMPLATE_CODE,
792 X_ATTRIBUTE6 => X_ATTRIBUTE6,
793 X_ATTRIBUTE7 => X_ATTRIBUTE7,
794 X_ATTRIBUTE8 => X_ATTRIBUTE8,
795 X_ATTRIBUTE9 => X_ATTRIBUTE9,
796 X_TEMPLATE_ID => tmpl_id,
797 X_APPLICATION_ID => app_id,
798 X_DS_APP_SHORT_NAME => X_DS_APP_SHORT_NAME,
799 X_DATA_SOURCE_CODE => X_DATA_SOURCE_CODE,
800 X_TEMPLATE_TYPE_CODE => X_TEMPLATE_TYPE_CODE,
801 X_DEFAULT_LANGUAGE => X_DEFAULT_LANGUAGE,
802 X_DEFAULT_TERRITORY => X_DEFAULT_TERRITORY,
803 X_DEFAULT_OUTPUT_TYPE => X_DEFAULT_OUTPUT_TYPE,
804 X_MLS_LANGUAGE => X_MLS_LANGUAGE,
805 X_MLS_TERRITORY => X_MLS_TERRITORY,
806 X_TEMPLATE_STATUS => X_TEMPLATE_STATUS,
807 X_USE_ALIAS_TABLE => X_USE_ALIAS_TABLE,
808 X_START_DATE => to_date(X_START_DATE,'YYYY/MM/DD'),
809 X_END_DATE => to_date(X_END_DATE,'YYYY/MM/DD'),
810 X_DEPENDENCY_FLAG => X_DEPENDENCY_FLAG,
811 X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
812 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
813 X_ATTRIBUTE1 => X_ATTRIBUTE1,
814 X_ATTRIBUTE2 => X_ATTRIBUTE2,
815 X_ATTRIBUTE3 => X_ATTRIBUTE3,
816 X_ATTRIBUTE4 => X_ATTRIBUTE4,
817 X_ATTRIBUTE5 => X_ATTRIBUTE5,
818 X_ATTRIBUTE10 => X_ATTRIBUTE10,
819 X_ATTRIBUTE11 => X_ATTRIBUTE11,
820 X_ATTRIBUTE12 => X_ATTRIBUTE12,
824 X_TEMPLATE_NAME => X_TEMPLATE_NAME,
821 X_ATTRIBUTE13 => X_ATTRIBUTE13,
822 X_ATTRIBUTE14 => X_ATTRIBUTE14,
823 X_ATTRIBUTE15 => X_ATTRIBUTE15,
825 X_DESCRIPTION => X_DESCRIPTION,
826 X_LAST_UPDATE_DATE => f_ludate,
827 X_LAST_UPDATED_BY => f_luby,
828 X_LAST_UPDATE_LOGIN => 0
829 );
830 end if;
831 exception when no_data_found then
832
833 if ( tmpl_id < 1 or tmpl_id is null ) then
834 select xdo_templates_seq.nextval into tmpl_id from dual;
835 end if;
836
837 XDO_TEMPLATES_PKG.INSERT_ROW(
838 X_ROWID => row_id,
839 X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
840 X_TEMPLATE_CODE => X_TEMPLATE_CODE,
841 X_ATTRIBUTE6 => X_ATTRIBUTE6,
842 X_ATTRIBUTE7 => X_ATTRIBUTE7,
843 X_ATTRIBUTE8 => X_ATTRIBUTE8,
844 X_ATTRIBUTE9 => X_ATTRIBUTE9,
845 X_TEMPLATE_ID => tmpl_id,
846 X_APPLICATION_ID => app_id,
847 X_DS_APP_SHORT_NAME => X_DS_APP_SHORT_NAME,
848 X_DATA_SOURCE_CODE => X_DATA_SOURCE_CODE,
849 X_TEMPLATE_TYPE_CODE => X_TEMPLATE_TYPE_CODE,
850 X_DEFAULT_LANGUAGE => X_DEFAULT_LANGUAGE,
851 X_DEFAULT_TERRITORY => X_DEFAULT_TERRITORY,
852 X_DEFAULT_OUTPUT_TYPE => X_DEFAULT_OUTPUT_TYPE,
853 X_MLS_LANGUAGE => X_MLS_LANGUAGE,
854 X_MLS_TERRITORY => X_MLS_TERRITORY,
855 X_TEMPLATE_STATUS => X_TEMPLATE_STATUS,
856 X_USE_ALIAS_TABLE => X_USE_ALIAS_TABLE,
857 X_START_DATE => to_date(X_START_DATE,'YYYY/MM/DD'),
858 X_END_DATE => to_date(X_END_DATE,'YYYY/MM/DD'),
859 X_DEPENDENCY_FLAG => X_DEPENDENCY_FLAG,
860 X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
861 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
862 X_ATTRIBUTE1 => X_ATTRIBUTE1,
863 X_ATTRIBUTE2 => X_ATTRIBUTE2,
864 X_ATTRIBUTE3 => X_ATTRIBUTE3,
865 X_ATTRIBUTE4 => X_ATTRIBUTE4,
866 X_ATTRIBUTE5 => X_ATTRIBUTE5,
867 X_ATTRIBUTE10 => X_ATTRIBUTE10,
868 X_ATTRIBUTE11 => X_ATTRIBUTE11,
869 X_ATTRIBUTE12 => X_ATTRIBUTE12,
870 X_ATTRIBUTE13 => X_ATTRIBUTE13,
871 X_ATTRIBUTE14 => X_ATTRIBUTE14,
872 X_ATTRIBUTE15 => X_ATTRIBUTE15,
873 X_TEMPLATE_NAME => X_TEMPLATE_NAME,
874 X_DESCRIPTION => X_DESCRIPTION,
875 X_CREATION_DATE => f_ludate,
876 X_CREATED_BY => f_luby,
877 X_LAST_UPDATE_DATE => f_ludate,
878 X_LAST_UPDATED_BY => f_luby,
879 X_LAST_UPDATE_LOGIN => 0
880 );
881 end;
882
883 end LOAD_ROW;
884
885 -- Backward Compatiblity Wrapper
886 -- Always set DEPENDENCY_FLAG to 'P'
887 procedure LOAD_ROW (
888 X_APPLICATION_SHORT_NAME in VARCHAR2,
889 X_TEMPLATE_CODE in VARCHAR2,
890 X_DS_APP_SHORT_NAME in VARCHAR2,
891 X_DATA_SOURCE_CODE in VARCHAR2,
892 X_TEMPLATE_TYPE_CODE in VARCHAR2,
893 X_DEFAULT_LANGUAGE in VARCHAR2,
894 X_DEFAULT_TERRITORY in VARCHAR2,
895 X_DEFAULT_OUTPUT_TYPE in VARCHAR2,
896 X_MLS_LANGUAGE in VARCHAR2,
897 X_MLS_TERRITORY in VARCHAR2,
898 X_TEMPLATE_STATUS in VARCHAR2,
899 X_USE_ALIAS_TABLE in VARCHAR2,
900 X_START_DATE in VARCHAR2,
901 X_END_DATE in VARCHAR2,
902 X_TEMPLATE_NAME in VARCHAR2,
903 X_DESCRIPTION in VARCHAR2,
904 X_OWNER in VARCHAR2,
905 X_LAST_UPDATE_DATE in VARCHAR2,
906 X_CUSTOM_MODE in VARCHAR2,
907 X_OBJECT_VERSION_NUMBER in NUMBER,
908 X_ATTRIBUTE_CATEGORY in VARCHAR2,
909 X_ATTRIBUTE1 in VARCHAR2,
910 X_ATTRIBUTE2 in VARCHAR2,
911 X_ATTRIBUTE3 in VARCHAR2,
912 X_ATTRIBUTE4 in VARCHAR2,
913 X_ATTRIBUTE5 in VARCHAR2,
914 X_ATTRIBUTE6 in VARCHAR2,
915 X_ATTRIBUTE7 in VARCHAR2,
916 X_ATTRIBUTE8 in VARCHAR2,
917 X_ATTRIBUTE9 in VARCHAR2,
918 X_ATTRIBUTE10 in VARCHAR2,
919 X_ATTRIBUTE11 in VARCHAR2,
920 X_ATTRIBUTE12 in VARCHAR2,
921 X_ATTRIBUTE13 in VARCHAR2,
922 X_ATTRIBUTE14 in VARCHAR2,
923 X_ATTRIBUTE15 in VARCHAR2
924 ) is
925 begin
926
927 LOAD_ROW (
928 X_APPLICATION_SHORT_NAME => X_APPLICATION_SHORT_NAME,
929 X_TEMPLATE_CODE => X_TEMPLATE_CODE,
930 X_DS_APP_SHORT_NAME => X_DS_APP_SHORT_NAME,
931 X_DATA_SOURCE_CODE => X_DATA_SOURCE_CODE,
932 X_TEMPLATE_TYPE_CODE => X_TEMPLATE_TYPE_CODE,
933 X_DEFAULT_LANGUAGE => X_DEFAULT_LANGUAGE,
934 X_DEFAULT_TERRITORY => X_DEFAULT_TERRITORY,
935 X_DEFAULT_OUTPUT_TYPE => X_DEFAULT_OUTPUT_TYPE,
936 X_MLS_LANGUAGE => X_MLS_LANGUAGE,
937 X_MLS_TERRITORY => X_MLS_TERRITORY,
938 X_TEMPLATE_STATUS => X_TEMPLATE_STATUS,
939 X_USE_ALIAS_TABLE => X_USE_ALIAS_TABLE,
940 X_START_DATE => X_START_DATE,
941 X_END_DATE => X_END_DATE,
942 X_TEMPLATE_NAME => X_TEMPLATE_NAME,
943 X_DESCRIPTION => X_DESCRIPTION,
944 X_OWNER => X_OWNER,
945 X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
946 X_CUSTOM_MODE => X_CUSTOM_MODE,
947 X_DEPENDENCY_FLAG => 'P',
948 X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
949 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
950 X_ATTRIBUTE1 => X_ATTRIBUTE1,
951 X_ATTRIBUTE2 => X_ATTRIBUTE2,
952 X_ATTRIBUTE3 => X_ATTRIBUTE3,
953 X_ATTRIBUTE4 => X_ATTRIBUTE4,
954 X_ATTRIBUTE5 => X_ATTRIBUTE5,
955 X_ATTRIBUTE6 => X_ATTRIBUTE6,
956 X_ATTRIBUTE7 => X_ATTRIBUTE7,
957 X_ATTRIBUTE8 => X_ATTRIBUTE8,
958 X_ATTRIBUTE9 => X_ATTRIBUTE9,
959 X_ATTRIBUTE10 => X_ATTRIBUTE10,
960 X_ATTRIBUTE11 => X_ATTRIBUTE11,
961 X_ATTRIBUTE12 => X_ATTRIBUTE12,
962 X_ATTRIBUTE13 => X_ATTRIBUTE13,
963 X_ATTRIBUTE14 => X_ATTRIBUTE14,
964 X_ATTRIBUTE15 => X_ATTRIBUTE15
965 );
966 end LOAD_ROW;
967
968 end XDO_TEMPLATES_PKG;