APPS.OKC_ALLOWED_TMPL_USAGES_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 508: l_template_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;

504: p_attribute15 IN VARCHAR2
505: ) RETURN VARCHAR2 IS
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

Line 514: FROM okc_terms_templates_all

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
515: WHERE TEMPLATE_ID = p_template_id;
516:
517: CURSOR l_document_type_csr is
518: SELECT '!'

Line 524: FROM okc_terms_templates_all

520: WHERE DOCUMENT_TYPE = p_document_type;
521:
522: CURSOR l_template_intent_csr IS
523: SELECT intent
524: FROM okc_terms_templates_all
525: WHERE template_id = p_template_id;
526:
527: CURSOR l_doc_intent_csr IS
528: SELECT intent

Line 714: l_def_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

710: ) RETURN VARCHAR2 IS
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

Line 716: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;

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
720: FROM okc_terms_templates_all

Line 720: FROM okc_terms_templates_all

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
720: FROM okc_terms_templates_all
721: WHERE template_id = p_template_id;
722:
723: CURSOR l_default_doc_type_csr(pc_parent_tmpl_id NUMBER,
724: pc_org_id NUMBER) is

Line 727: okc_terms_templates_all tmpl

723: CURSOR l_default_doc_type_csr(pc_parent_tmpl_id NUMBER,
724: pc_org_id NUMBER) is
725: SELECT tmpl.template_name
726: FROM okc_allowed_tmpl_usages usg,
727: okc_terms_templates_all tmpl
728: WHERE document_type = p_document_type
729: AND allowed_tmpl_usages_id <> nvl(p_allowed_tmpl_usages_id, -9999)
730: AND nvl(usg.default_yn,'N') = 'Y'
731: AND ((tmpl.template_id <> pc_parent_tmpl_id AND pc_parent_tmpl_id IS NOT NULL) OR