APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 1609: l_intent okc_bus_doc_types_b.intent%type;

1605: 2. for TEMPLATE doc types, get selected draft versions also
1606: */
1607: --Repository Enhancement 12.1 (For Validate Action)
1608: p_rep_doc_type varchar2(30);
1609: l_intent okc_bus_doc_types_b.intent%type;
1610: -- Repository Enhancement 12.1 Ends (For Validate Action)
1611:
1612: CURSOR l_check_usage_csr IS
1613: -- no change for non TEMPLATE document types

Line 1695: FROM okc_bus_doc_types_b

1691:
1692: -- Repository Enhancement 12.1 (For Validate Action)
1693: CURSOR l_get_intent is
1694: SELECT intent
1695: FROM okc_bus_doc_types_b
1696: WHERE document_type = p_doc_type;
1697: -- Repository Enhancement 12.1 Ends (For Validate Action)
1698:
1699:

Line 2534: FROM OKC_BUS_DOC_TYPES_B

2530: l_disable_amend_yn VARCHAR2(1);
2531:
2532: CURSOR l_get_doc_disable_amend_csr IS
2533: SELECT NVL(disable_amend_yn,'N')
2534: FROM OKC_BUS_DOC_TYPES_B
2535: WHERE document_type = p_doc_type;
2536:
2537: BEGIN
2538:

Line 2635: FROM OKC_BUS_DOC_TYPES_B

2631: l_disable_amend_yn VARCHAR2(1);
2632:
2633: CURSOR l_get_doc_disable_amend_csr IS
2634: SELECT NVL(disable_amend_yn,'N')
2635: FROM OKC_BUS_DOC_TYPES_B
2636: WHERE document_type = p_doc_type;
2637:
2638: BEGIN
2639: