APPS.OKC_TERMS_COPY_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 15: G_TEMPLATE_DOC_TYPE CONSTANT okc_bus_doc_types_b.document_type%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;

11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_PVT';
13: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_TEMPLATE_DOC_TYPE CONSTANT okc_bus_doc_types_b.document_type%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
16: G_ATTACHED_CONTRACT_SOURCE CONSTANT okc_template_usages.contract_source_code%TYPE := 'ATTACHED';
17:
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS

Line 482: SELECT nvl(PROVISION_ALLOWED_YN,'Y') FROM OKC_BUS_DOC_TYPES_B

478: Label_tbl1 LabelList;
479: Display_sequence_tbl1 DisplaySequenceList;
480:
481: CURSOR l_get_prov_csr IS
482: SELECT nvl(PROVISION_ALLOWED_YN,'Y') FROM OKC_BUS_DOC_TYPES_B
483: WHERE DOCUMENT_TYPE=p_target_doc_type;
484:
485: CURSOR l_get_std_csr(b_article_id NUMBER) IS
486: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL

Line 2051: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;

2047: l_dummy_var VARCHAR2(1) :='?';
2048: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;
2049: l_article_effective_date DATE;
2050: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2051: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
2052: l_document_id NUMBER;
2053: l_get_from_library VARCHAR2(1);
2054: l_no_terms_found BOOLEAN :=FALSE;
2055: l_tmpl_usage_id NUMBER;