[Home] [Help]
145: ,x_last_updated_by
146: ,x_last_update_login)
147: ;
148:
149: INSERT INTO xla_sources_tl
150: (name
151: ,description
152: ,creation_date
153: ,created_by
175: FROM fnd_languages l
176: WHERE l.installed_flag IN ('I', 'B')
177: AND NOT EXISTS
178: (SELECT NULL
179: FROM xla_sources_tl t
180: WHERE t.application_id = x_application_id
181: AND t.source_code = x_source_code
182: AND t.source_type_code = x_source_type_code
183: AND t.language = l.language_code);
254: SELECT language
255: ,name
256: ,description
257: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
258: FROM xla_sources_tl
259: WHERE application_id = X_application_id
260: AND source_code = X_source_code
261: AND source_type_code = X_source_type_code
262: AND USERENV('LANG') IN (language ,source_lang)
452: IF (SQL%NOTFOUND) THEN
453: RAISE NO_DATA_FOUND;
454: END IF;
455:
456: UPDATE xla_sources_tl
457: SET
458: last_update_date = x_last_update_date
459: ,name = X_name
460: ,description = X_description
486: IS
487:
488: BEGIN
489: xla_utility_pkg.trace('> xla_sources_f_pkg.delete_row' ,20);
490: DELETE FROM xla_sources_tl
491: WHERE application_id = x_application_id
492: AND source_code = x_source_code
493: AND source_type_code = x_source_type_code;
494:
522:
523: BEGIN
524: xla_utility_pkg.trace('> xla_sources_f_pkg.add_language' ,20);
525:
526: DELETE FROM xla_sources_tl T
527: WHERE NOT EXISTS
528: (SELECT NULL
529: FROM xla_sources_b b
530: WHERE b.application_id = t.application_id
530: WHERE b.application_id = t.application_id
531: AND b.source_code = t.source_code
532: AND b.source_type_code = t.source_type_code);
533:
534: UPDATE xla_sources_tl t
535: SET (name
536: ,description)
537: = (SELECT b.name
538: ,b.description
535: SET (name
536: ,description)
537: = (SELECT b.name
538: ,b.description
539: FROM xla_sources_tl b
540: WHERE b.application_id = t.application_id
541: AND b.source_code = t.source_code
542: AND b.source_type_code = t.source_type_code
543: AND b.language = t.source_lang)
548: IN (SELECT subt.application_id
549: ,subt.source_code
550: ,subt.source_type_code
551: ,subt.language
552: FROM xla_sources_tl subb
553: ,xla_sources_tl subt
554: WHERE subb.application_id = subt.application_id
555: AND subb.source_code = subt.source_code
556: AND subb.source_type_code = subt.source_type_code
549: ,subt.source_code
550: ,subt.source_type_code
551: ,subt.language
552: FROM xla_sources_tl subb
553: ,xla_sources_tl subt
554: WHERE subb.application_id = subt.application_id
555: AND subb.source_code = subt.source_code
556: AND subb.source_type_code = subt.source_type_code
557: AND subb.language = subt.source_lang
563: AND subt.description IS NULL)
564: ))
565: ;
566:
567: INSERT INTO xla_sources_tl
568: (name
569: ,description
570: ,creation_date
571: ,created_by
589: ,b.source_type_code
590: ,b.source_code
591: ,l.language_code
592: ,b.source_lang
593: FROM xla_sources_tl b
594: ,fnd_languages l
595: WHERE l.installed_flag IN ('I', 'B')
596: AND b.language = userenv('LANG')
597: AND NOT EXISTS
595: WHERE l.installed_flag IN ('I', 'B')
596: AND b.language = userenv('LANG')
597: AND NOT EXISTS
598: (SELECT NULL
599: FROM xla_sources_tl t
600: WHERE t.application_id = b.application_id
601: AND t.source_code = b.source_code
602: AND t.source_type_code = b.source_type_code
603: AND t.language = l.language_code);
825:
826: BEGIN
827: SELECT last_updated_by, last_update_date
828: INTO db_luby, db_ludate
829: FROM xla_sources_tl
830: WHERE application_id = l_application_id
831: AND source_code = p_source_code
832: AND source_type_code = p_source_type_code
833: AND language = userenv('LANG');
833: AND language = userenv('LANG');
834:
835: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
836: db_ludate, p_custom_mode)) then
837: UPDATE xla_sources_tl
838: SET name = p_name
839: ,description = p_description
840: ,last_update_date = f_ludate
841: ,last_updated_by = f_luby