APPS.OKC_XPRT_RULES_ENGINE_PVT dependencies on OKC_TEMPLATE_USAGES

Line 1511: FROM okc_template_usages

1507: PROCEDURE save_responses(doc_id IN NUMBER, doc_type IN VARCHAR2, p_lock_xprt_yn IN VARCHAR2, x_return_status OUT NOCOPY VARCHAR2) IS
1508:
1509: CURSOR c_base_table_dtls IS
1510: SELECT orig_system_reference_code, orig_system_reference_id1
1511: FROM okc_template_usages
1512: WHERE document_type = p_doc_type
1513: AND document_id = p_doc_id;
1514:
1515: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;

Line 1515: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;

1511: FROM okc_template_usages
1512: WHERE document_type = p_doc_type
1513: AND document_id = p_doc_id;
1514:
1515: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
1516: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
1517: x_msg_data VARCHAR2(2000);
1518: x_msg_count NUMBER;
1519:

Line 1516: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;

1512: WHERE document_type = p_doc_type
1513: AND document_id = p_doc_id;
1514:
1515: l_src_document_type okc_template_usages.orig_system_reference_code%TYPE;
1516: l_src_document_id okc_template_usages.orig_system_reference_id1%TYPE;
1517: x_msg_data VARCHAR2(2000);
1518: x_msg_count NUMBER;
1519:
1520: l_api_name CONSTANT VARCHAR2(30) := 'save_responses';

Line 1587: UPDATE okc_template_usages

1583: (SELECT OKC_XPRT_DOC_QUES_RESPONSE_S.nextval, p_doc_id, p_doc_type, object_code, value_or_response FROM okc_xprt_rule_eval_condval_t
1584: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND object_type = 'QUESTION' AND display_flag = 'Y');
1585:
1586: --updating contract_expert_finish_flag to N to say that the process of contract expert is not finished
1587: UPDATE okc_template_usages
1588: SET contract_expert_finish_flag = 'N'
1589: WHERE document_id = p_doc_id
1590: AND document_type = p_doc_type;
1591: