APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 1590: l_intent okc_bus_doc_types_b.intent%type;

1586: 2. for TEMPLATE doc types, get selected draft versions also
1587: */
1588: --Repository Enhancement 12.1 (For Validate Action)
1589: p_rep_doc_type varchar2(30);
1590: l_intent okc_bus_doc_types_b.intent%type;
1591: -- Repository Enhancement 12.1 Ends (For Validate Action)
1592:
1593: CURSOR l_check_usage_csr IS
1594: -- no change for non TEMPLATE document types

Line 1676: FROM okc_bus_doc_types_b

1672:
1673: -- Repository Enhancement 12.1 (For Validate Action)
1674: CURSOR l_get_intent is
1675: SELECT intent
1676: FROM okc_bus_doc_types_b
1677: WHERE document_type = p_doc_type;
1678: -- Repository Enhancement 12.1 Ends (For Validate Action)
1679:
1680:

Line 2500: FROM OKC_BUS_DOC_TYPES_B

2496: l_disable_amend_yn VARCHAR2(1);
2497:
2498: CURSOR l_get_doc_disable_amend_csr IS
2499: SELECT NVL(disable_amend_yn,'N')
2500: FROM OKC_BUS_DOC_TYPES_B
2501: WHERE document_type = p_doc_type;
2502:
2503: BEGIN
2504:

Line 2601: FROM OKC_BUS_DOC_TYPES_B

2597: l_disable_amend_yn VARCHAR2(1);
2598:
2599: CURSOR l_get_doc_disable_amend_csr IS
2600: SELECT NVL(disable_amend_yn,'N')
2601: FROM OKC_BUS_DOC_TYPES_B
2602: WHERE document_type = p_doc_type;
2603:
2604: BEGIN
2605: