APPS.OKC_TERMS_COPY_GRP dependencies on OKC_TEMPLATE_USAGES

Line 808: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_target_doc_id;

804:
805: l_api_version CONSTANT NUMBER := 1;
806: l_api_name CONSTANT VARCHAR2(30) := 'copy_terms';
807: l_ok_to_commit VARCHAR2(1);
808: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_target_doc_id;
809: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_target_doc_type;
810:
811: CURSOR target_response_cur IS
812: SELECT TARGET_RESPONSE_DOC_TYPE

Line 821: FROM okc_template_usages

817: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
818:
819: CURSOR l_get_num_scheme_id(p_doc_type IN VARCHAR2, p_doc_id IN NUMBER) IS
820: SELECT doc_numbering_scheme
821: FROM okc_template_usages
822: WHERE document_type = p_doc_type
823: AND document_id = p_doc_id;
824:
825: l_num_scheme_id NUMBER:=0;