APPS.OKC_TERMS_COPY_GRP dependencies on OKC_TEMPLATE_USAGES

Line 106: FROM okc_template_usages

102:
103: -- CLM changes Begins
104: CURSOR l_get_num_scheme_id(p_doc_type IN VARCHAR2, p_doc_id IN NUMBER) IS
105: SELECT doc_numbering_scheme
106: FROM okc_template_usages
107: WHERE document_type = p_doc_type
108: AND document_id = p_doc_id;
109:
110: l_num_scheme_id NUMBER:=0;

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

923:
924: l_api_version CONSTANT NUMBER := 1;
925: l_api_name CONSTANT VARCHAR2(30) := 'copy_terms';
926: l_ok_to_commit VARCHAR2(1);
927: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := p_target_doc_id;
928: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE := p_target_doc_type;
929: l_template_exists VARCHAR2(1);
930:
931: CURSOR target_response_cur IS

Line 941: FROM okc_template_usages

937: l_target_response_doctype okc_bus_doc_types_b.TARGET_RESPONSE_DOC_TYPE%TYPE;
938:
939: CURSOR l_get_num_scheme_id(p_doc_type IN VARCHAR2, p_doc_id IN NUMBER) IS
940: SELECT doc_numbering_scheme
941: FROM okc_template_usages
942: WHERE document_type = p_doc_type
943: AND document_id = p_doc_id;
944:
945: l_num_scheme_id NUMBER:=0;