[Home] [Help]
14: -- 7017250 - This variable is used to determine if the new xdo columns exits.
15: xdo_columns_cntr number := null;
16:
17: default_templ_shrt_name fnd_application.application_short_name%TYPE;
18: default_templ_code xdo_templates_b.template_code%TYPE;
19: default_templ_shrt_name_opt fnd_application.application_short_name%TYPE;
20: default_templ_code_opt xdo_templates_b.template_code%TYPE;
21: l_special_template_case varchar2(2);
22:
16:
17: default_templ_shrt_name fnd_application.application_short_name%TYPE;
18: default_templ_code xdo_templates_b.template_code%TYPE;
19: default_templ_shrt_name_opt fnd_application.application_short_name%TYPE;
20: default_templ_code_opt xdo_templates_b.template_code%TYPE;
21: l_special_template_case varchar2(2);
22:
23: --
24: -- Exception info.
271: end if;
272:
273:
274: l_special_template_case := '10';
275: -- 10th Final chk No Def Template, get template from xdo_templates_b
276: if (no_def_template_check(
277: prog_app_name, conc_prog_name,
278: nls_lang, wo_xdo_iso_language, wo_xdo_iso_territory,
279: 'N',
769: 'select x.template_name, a.default_language, '||
770: ' a.default_territory, a.application_short_name, '||
771: ' a.template_code, a.template_type_code, '||
772: ' a.default_output_type '||
773: ' from xdo_templates_b a, xdo_templates_vl x '||
774: ' where a.ds_app_short_name = :prog_app_name '||
775: ' and a.data_source_code = :conc_prog_name '||
776: ' and a.template_code = x.template_code '||
777: ' and a.template_status = ''E'' '||
786: a.application_short_name, a.template_code,
787: a.template_type_code
788: into template_name, iso_language, iso_territory,
789: template_app_name, template_code, format_type
790: from xdo_templates_b a, xdo_templates_vl x
791: where a.ds_app_short_name = prog_app_name
792: and a.data_source_code = conc_prog_name
793: and a.template_code = x.template_code
794: and a.template_status = 'E'
803: 'select x.template_name, a.default_language, '||
804: ' a.default_territory, a.application_short_name, '||
805: ' a.template_code, a.template_type_code, '||
806: ' a.default_output_type '||
807: ' from xdo_templates_b a, xdo_templates_vl x '||
808: ' where a.ds_app_short_name = :prog_app_name '||
809: ' and a.data_source_code = :conc_prog_name '||
810: ' and a.template_code = :def_templ_code '||
811: ' and a.template_code = x.template_code '||
821: a.application_short_name, a.template_code,
822: a.template_type_code
823: into template_name, iso_language, iso_territory,
824: template_app_name, template_code, format_type
825: from xdo_templates_b a, xdo_templates_vl x
826: where a.ds_app_short_name = prog_app_name
827: and a.data_source_code = conc_prog_name
828: and a.template_code = def_templ_code
829: and a.template_code = x.template_code
1117:
1118:
1119:
1120: l_special_template_case := '10';
1121: -- 10th Final chk No new Template, get template from xdo_templates_b
1122: if (def_template_check(
1123: prog_app_name, conc_prog_name, new_template_code,
1124: nls_lang, wo_xdo_iso_language, def_iso_territory,
1125: 'N',
1320: select count(*) into xdo_columns_cntr
1321: from (
1322: select syn.table_name, col.column_name
1323: from user_synonyms syn, all_tab_columns col
1324: where syn.synonym_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')
1325: and col.column_name = 'DEFAULT_OUTPUT_TYPE'
1326: and col.owner = syn.table_owner
1327: and col.table_name = syn.table_name
1328: UNION
1327: and col.table_name = syn.table_name
1328: UNION
1329: select col.table_name, col.column_name
1330: from user_tab_columns col
1331: where col.table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')
1332: and col.column_name = 'DEFAULT_OUTPUT_TYPE'
1333: );
1334:
1335: