1266:
1267: BEGIN
1268: SELECT 1
1269: INTO l_count 1270: FROM xdo_lobs tmpl, xdo_templates_vl t 1271: WHERE t.APPLICATION_SHORT_NAME = 'QP'
1272: AND t.TEMPLATE_CODE = tmpl.LOB_CODE
1273: AND tmpl.LOB_TYPE in ('TEMPLATE','MLS_TEMPLATE')
1274: AND tmpl.FILE_STATUS = 'E'