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 266: FROM okc_bus_doc_types_b

262: l_tar_amend NUMBER;
263:
264: CURSOR c_get_doc_type_class (c_doc_type VARCHAR2) IS
265: SELECT document_type_class
266: FROM okc_bus_doc_types_b
267: WHERE document_type = c_doc_type;
268:
269: CURSOR c_check_sol_amendment(c_doc_id NUMBER) IS
270: SELECT Nvl(AMENDMENT_NUMBER,0) FROM PON_AUCTION_HEADERS_ALL

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

719: Label_tbl1 LabelList;
720: Display_sequence_tbl1 DisplaySequenceList;
721:
722: CURSOR l_get_prov_csr IS
723: SELECT nvl(PROVISION_ALLOWED_YN,'Y') FROM OKC_BUS_DOC_TYPES_B
724: WHERE DOCUMENT_TYPE=p_target_doc_type;
725:
726: CURSOR l_get_std_csr(b_article_id NUMBER) IS
727: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL

Line 2622: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;

2618: l_dummy_var VARCHAR2(1) :='?';
2619: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;
2620: l_article_effective_date DATE;
2621: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2622: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
2623: l_document_id NUMBER;
2624: l_get_from_library VARCHAR2(1);
2625: l_no_terms_found BOOLEAN :=FALSE;
2626: l_tmpl_usage_id NUMBER;