APPS.OKC_ALLOWED_TMPL_USAGES_PVT dependencies on OKC_BUS_DOC_TYPES_TL

Line 510: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

506: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
507: l_dummy_var VARCHAR2(1) := '?';
508: l_template_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
509: l_doc_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;
510: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
511:
512: CURSOR l_template_id_csr is
513: SELECT '!'
514: FROM okc_terms_templates_all

Line 715: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

711: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
712: l_dummy_var VARCHAR2(1) := '?';
713: l_parent_tmpl_id NUMBER;
714: l_def_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
715: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
716: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
717:
718: CURSOR l_default_tmpl_csr IS
719: SELECT parent_template_id,org_id