eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_K_ENTITY_LOCKS_GRP dependencies on OKC_XPRT_DOC_QUES_RESPONSE

Line 1578: DELETE FROM okc_xprt_doc_ques_response

1574: --------------------------------------------
1575: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
1576:
1577: --deleting the responses
1578: DELETE FROM okc_xprt_doc_ques_response
1579: WHERE doc_id = p_target_document_id
1580: AND doc_type = p_target_document_type;
1581:
1582: ELSE --configurator rule engine

Line 1638: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)

1634: -----------------------------------------------------
1635: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
1636: --okc rules engine
1637: --copying responses from the base document
1638: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1639: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL, p_target_document_id, p_target_document_type, question_id, response
1640: FROM okc_xprt_doc_ques_response WHERE doc_id = l_src_document_id AND doc_type = l_src_document_type );
1641:
1642: --updating the finish flag to the previous state of the base document

Line 1639: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL, p_target_document_id, p_target_document_type, question_id, response

1635: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
1636: --okc rules engine
1637: --copying responses from the base document
1638: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1639: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL, p_target_document_id, p_target_document_type, question_id, response
1640: FROM okc_xprt_doc_ques_response WHERE doc_id = l_src_document_id AND doc_type = l_src_document_type );
1641:
1642: --updating the finish flag to the previous state of the base document
1643: UPDATE okc_template_usages

Line 1640: FROM okc_xprt_doc_ques_response WHERE doc_id = l_src_document_id AND doc_type = l_src_document_type );

1636: --okc rules engine
1637: --copying responses from the base document
1638: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1639: (SELECT okc_xprt_doc_ques_response_s.NEXTVAL, p_target_document_id, p_target_document_type, question_id, response
1640: FROM okc_xprt_doc_ques_response WHERE doc_id = l_src_document_id AND doc_type = l_src_document_type );
1641:
1642: --updating the finish flag to the previous state of the base document
1643: UPDATE okc_template_usages
1644: SET contract_expert_finish_flag = (SELECT contract_expert_finish_flag FROM okc_template_usages WHERE document_type = l_src_document_type AND document_id = l_src_document_id)