[Home] [Help]
348: 'select a.template_name, I.NAME||'': ''||T.territory_short_name, '||
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 '||
375: a.template_type_code
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
398: 'select a.template_name, I.NAME, '||
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 '||
424: a.template_type_code
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
488: 'select a.template_name, I.NAME||'': ''||T.territory_short_name, '||
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 '||
516: a.application_short_name, a.template_code, a.template_type_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
540: 'select a.template_name, I.NAME, '||
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 '||
568: a.application_short_name, a.template_code, a.template_type_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
631: 'select a.template_name, I.NAME, '||
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 '||
657: a.application_short_name, a.template_code, a.template_type_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
680: 'select a.template_name, I.NAME, '||
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 '||
706: a.template_type_code
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
915: begin
916: begin
917: SELECT lower(L1.iso_language), upper(L2.territory_code)
918: INTO iso_lang, iso_terr
919: FROM FND_LANGUAGES L1, FND_TERRITORIES_VL L2
920: WHERE L1.NLS_LANGUAGE = nls_lang
921: AND L2.NLS_TERRITORY = nls_terr
922: AND ROWNUM = 1;
923: exception
940: begin
941: begin
942: SELECT upper(L2.territory_code)
943: INTO def_iso_terr
944: FROM FND_LANGUAGES L1, FND_TERRITORIES_VL L2
945: WHERE L1.NLS_LANGUAGE = nls_lang
946: AND L1.NLS_TERRITORY = L2.NLS_TERRITORY
947: AND ROWNUM = 1;
948: exception