542:
543: CURSOR l_alwd_usgs_csr(l_template_id IN NUMBER) IS
544: SELECT 1
545: FROM
546: OKC_ALLOWED_TMPL_USAGES
547: WHERE document_type = p_document_type
548: AND template_id = l_template_id;
549:
550: CURSOR l_fnd_lobs_nextval_csr IS
3207:
3208: CURSOR l_alwd_usgs_csr(l_template_id IN NUMBER) IS
3209: SELECT 1
3210: FROM
3211: OKC_ALLOWED_TMPL_USAGES
3212: WHERE document_type = p_document_type
3213: AND template_id = l_template_id;
3214:
3215: CURSOR c_get_intent_csr IS