330: THEN
331: BEGIN
332: SELECT 'Y'
333: INTO l_tmpl_change 334: FROM dual 335: WHERE NOT exists
336: (SELECT 'Y'
337: FROM okc_template_usages
338: WHERE DOCUMENT_TYPE = p_doc_type
Line 358: FROM dual
354: THEN
355: BEGIN
356: SELECT 'D'
357: INTO l_tmpl_change 358: FROM dual 359: WHERE NOT exists
360: (SELECT 'Y'
361: FROM okc_template_usages
362: WHERE DOCUMENT_TYPE = p_doc_type