APPS.FND_CONC_TEMPLATES dependencies on XDO_TEMPLATES_B

Line 275: -- 10th Final chk No Def Template, get template from xdo_templates_b

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',

Line 772: ' from xdo_templates_b a, xdo_templates_vl x '||

768: 'select x.template_name, a.default_language, '||
769: ' a.default_territory, a.application_short_name, '||
770: ' a.template_code, a.template_type_code, '||
771: ' a.default_output_type '||
772: ' from xdo_templates_b a, xdo_templates_vl x '||
773: ' where a.ds_app_short_name = :prog_app_name '||
774: ' and a.data_source_code = :conc_prog_name '||
775: ' and a.template_code = x.template_code '||
776: ' and a.template_status = ''E'' '||

Line 789: from xdo_templates_b a, xdo_templates_vl x

785: a.application_short_name, a.template_code,
786: a.template_type_code
787: into template_name, iso_language, iso_territory,
788: template_app_name, template_code, format_type
789: from xdo_templates_b a, xdo_templates_vl x
790: where a.ds_app_short_name = prog_app_name
791: and a.data_source_code = conc_prog_name
792: and a.template_code = x.template_code
793: and a.template_status = 'E'

Line 805: ' from xdo_templates_b a, xdo_templates_vl x '||

801: 'select x.template_name, a.default_language, '||
802: ' a.default_territory, a.application_short_name, '||
803: ' a.template_code, a.template_type_code, '||
804: ' a.default_output_type '||
805: ' from xdo_templates_b a, xdo_templates_vl x '||
806: ' where a.ds_app_short_name = :prog_app_name '||
807: ' and a.data_source_code = :conc_prog_name '||
808: ' and a.template_code = :default_templ_code '||
809: ' and a.template_code = x.template_code '||

Line 823: from xdo_templates_b a, xdo_templates_vl x

819: a.application_short_name, a.template_code,
820: a.template_type_code
821: into template_name, iso_language, iso_territory,
822: template_app_name, template_code, format_type
823: from xdo_templates_b a, xdo_templates_vl x
824: where a.ds_app_short_name = prog_app_name
825: and a.data_source_code = conc_prog_name
826: and a.template_code = default_templ_code
827: and a.template_code = x.template_code

Line 1118: -- 10th Final chk No new Template, get template from xdo_templates_b

1114:
1115:
1116:
1117: l_special_template_case := '10';
1118: -- 10th Final chk No new Template, get template from xdo_templates_b
1119: if (def_template_check(
1120: prog_app_name, conc_prog_name, new_template_code,
1121: nls_lang, wo_xdo_iso_language, def_iso_territory,
1122: 'N',

Line 1299: where table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')

1295: -- Set it and Forget It! -- Ronco
1296: -- Obtain the count if the default_output_type column
1297: -- exist in the xdo tables.
1298: select count(*) into xdo_columns_cntr from sys.all_tab_columns
1299: where table_name in ('XDO_TEMPLATES_B', 'XDO_TEMPLATES_VL')
1300: and column_name = 'DEFAULT_OUTPUT_TYPE';
1301:
1302:
1303: end FND_CONC_TEMPLATES;