[Home] [Help]
349: ' b.nls_language, x.language, x.territory, '||
350: ' a.application_short_name, a.template_code, '||
351: ' a.template_type_code, a.default_output_type '||
352: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
353: ' fnd_iso_languages_vl I, fnd_territories_vl T '||
354: ' where a.ds_app_short_name = :prog_app_name '||
355: ' and a.data_source_code = :conc_prog_name '||
356: ' and a.template_code = x.lob_code '||
357: ' and lower(x.language) = lower(:iso_lang) '||
376: into template_name, template_language, request_language,
377: iso_language, iso_territory, template_app_name,
378: template_code, format_type
379: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
380: fnd_iso_languages_vl I, fnd_territories_vl T
381: where a.ds_app_short_name = prog_app_name
382: and a.data_source_code = conc_prog_name
383: and a.template_code = x.lob_code
384: and lower(x.language) = lower(iso_lang)
399: ' b.nls_language, x.language, x.territory, '||
400: ' a.application_short_name, a.template_code, '||
401: ' a.template_type_code, a.default_output_type '||
402: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
403: ' fnd_iso_languages_vl I '||
404: ' where a.ds_app_short_name = :prog_app_name '||
405: ' and a.data_source_code = :conc_prog_name '||
406: ' and a.template_code = x.lob_code '||
407: ' and lower(x.language) = lower(:iso_lang) '||
425: into template_name, template_language, request_language,
426: iso_language, iso_territory, template_app_name,
427: template_code, format_type
428: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
429: fnd_iso_languages_vl I
430: where a.ds_app_short_name = prog_app_name
431: and a.data_source_code = conc_prog_name
432: and a.template_code = x.lob_code
433: and lower(x.language) = lower(iso_lang)
489: ' b.nls_language, x.language, x.territory, '||
490: ' a.application_short_name, a.template_code, '||
491: ' a.template_type_code, a.default_output_type '||
492: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
493: ' fnd_iso_languages_vl I, fnd_territories_vl T '||
494: ' where a.ds_app_short_name = :prog_app_name '||
495: ' and a.data_source_code = :conc_prog_name '||
496: ' and a.template_code = :def_templ_code '||
497: ' and a.template_code = x.lob_code '||
517: into template_name, template_language, request_language,
518: iso_language, iso_territory, template_app_name, template_code,
519: format_type
520: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
521: fnd_iso_languages_vl I, fnd_territories_vl T
522: where a.ds_app_short_name = prog_app_name
523: and a.data_source_code = conc_prog_name
524: and a.template_code = def_templ_code
525: and a.template_code = x.lob_code
541: ' b.nls_language, x.language, x.territory, '||
542: ' a.application_short_name, a.template_code, '||
543: ' a.template_type_code, a.default_output_type '||
544: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
545: ' fnd_iso_languages_vl I '||
546: ' where a.ds_app_short_name = :prog_app_name '||
547: ' and a.data_source_code = :conc_prog_name '||
548: ' and a.template_code = :def_templ_code '||
549: ' and a.template_code = x.lob_code '||
569: into template_name, template_language, request_language,
570: iso_language, iso_territory, template_app_name, template_code,
571: format_type
572: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
573: fnd_iso_languages_vl I
574: where a.ds_app_short_name = prog_app_name
575: and a.data_source_code = conc_prog_name
576: and a.template_code = def_templ_code
577: and a.template_code = x.lob_code
632: ' b.nls_language, x.language, x.territory, '||
633: ' a.application_short_name, a.template_code, '||
634: ' a.template_type_code, a.default_output_type '||
635: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
636: ' fnd_iso_languages_vl I '||
637: ' where a.ds_app_short_name = :default_templ_shrt_name '||
638: ' and a.data_source_code = :conc_prog_name '||
639: ' and a.template_code = :def_templ_code '||
640: ' and a.template_code = x.lob_code '||
658: into template_name, template_language, request_language,
659: iso_language, iso_territory, template_app_name, template_code,
660: format_type
661: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
662: fnd_iso_languages_vl I
663: where a.ds_app_short_name = default_templ_shrt_name
664: and a.data_source_code = conc_prog_name
665: and a.template_code = def_templ_code
666: and a.template_code = x.lob_code
681: ' b.nls_language, x.language, x.territory, '||
682: ' a.application_short_name, a.template_code, '||
683: ' a.template_type_code, a.default_output_type '||
684: ' from xdo_lobs x, xdo_templates_vl a, fnd_languages b, '||
685: ' fnd_iso_languages_vl I '||
686: ' where a.ds_app_short_name = :prog_app_name '||
687: ' and a.data_source_code = :conc_prog_name '||
688: ' and a.template_code = x.lob_code '||
689: ' and lower(x.language) = lower(:iso_lang) '||
707: into template_name, template_language, request_language,
708: iso_language, iso_territory, template_app_name,
709: template_code, format_type
710: from xdo_lobs x, xdo_templates_vl a, fnd_languages b,
711: fnd_iso_languages_vl I
712: where a.ds_app_short_name = prog_app_name
713: and a.data_source_code = conc_prog_name
714: and a.template_code = x.lob_code
715: and lower(x.language) = lower(iso_lang)
840: if ( iso_territory = '00' ) then
841: begin
842: select I.name
843: into template_language
844: from fnd_iso_languages_vl I
845: where I.iso_language_2 = lower(iso_language);
846: exception
847: when NO_DATA_FOUND then
848: NULL;
850: else
851: begin
852: select I.name||': '||T.territory_short_name
853: into template_language
854: from fnd_iso_languages_vl I, fnd_territories_vl T
855: where I.iso_language_2 = lower(iso_language)
856: and T.territory_code = upper(iso_territory);
857: exception
858: when NO_DATA_FOUND then