DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 3208: FROM OKC_BUS_DOC_TYPES_B

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

Line 3819: FROM OKC_BUS_DOC_TYPES_B

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: --

Line 6826: FROM okc_bus_doc_types_b

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;

Line 6829: l_document_type_class okc_bus_doc_types_b.document_type_class%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

Line 6830: l_variable_resolution_am okc_bus_doc_types_b.variable_resolution_am%TYPE;

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:

Line 7069: FROM OKC_BUS_DOC_TYPES_B

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: --