3204: -- Cursor to check provision allowed for doc type
3205: --
3206: CURSOR l_get_prov_csr IS
3207: SELECT NVL(PROVISION_ALLOWED_YN,'Y')
3208: FROM OKC_BUS_DOC_TYPES_B
3209: WHERE DOCUMENT_TYPE=p_document_type;
3210:
3211: --
3212: -- Currsor to Select the Expert Articles
3815: -- Cursor to check provision allowed for doc type
3816: --
3817: CURSOR l_get_prov_csr IS
3818: SELECT NVL(PROVISION_ALLOWED_YN,'Y')
3819: FROM OKC_BUS_DOC_TYPES_B
3820: WHERE DOCUMENT_TYPE=p_document_type;
3821:
3822:
3823: --
6822: -- then contract expert button must be disabled.
6823: CURSOR csr_sourcing_level IS
6824: SELECT document_type_class,
6825: NVL(variable_resolution_am,'X')
6826: FROM okc_bus_doc_types_b
6827: WHERE document_type = p_document_type;
6828:
6829: l_document_type_class okc_bus_doc_types_b.document_type_class%TYPE;
6830: l_variable_resolution_am okc_bus_doc_types_b.variable_resolution_am%TYPE;
6825: NVL(variable_resolution_am,'X')
6826: FROM okc_bus_doc_types_b
6827: WHERE document_type = p_document_type;
6828:
6829: l_document_type_class okc_bus_doc_types_b.document_type_class%TYPE;
6830: l_variable_resolution_am okc_bus_doc_types_b.variable_resolution_am%TYPE;
6831:
6832:
6833: BEGIN
6826: FROM okc_bus_doc_types_b
6827: WHERE document_type = p_document_type;
6828:
6829: l_document_type_class okc_bus_doc_types_b.document_type_class%TYPE;
6830: l_variable_resolution_am okc_bus_doc_types_b.variable_resolution_am%TYPE;
6831:
6832:
6833: BEGIN
6834:
7065: -- Cursor to check provision allowed for doc type
7066: --
7067: CURSOR l_get_prov_csr IS
7068: SELECT NVL(PROVISION_ALLOWED_YN,'Y')
7069: FROM OKC_BUS_DOC_TYPES_B
7070: WHERE DOCUMENT_TYPE=p_document_type;
7071:
7072:
7073: --