DBA Data[Home] [Help]

APPS.OKC_XPRT_RULES_ENGINE_PVT dependencies on OKC_XPRT_DOC_QUES_RESPONSE_S

Line 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

1579: DELETE okc_xprt_doc_ques_response WHERE doc_id = p_doc_id AND doc_type = p_doc_type;
1580:
1581: --copying the responses to okc_xprt_doc_ques_response
1582: INSERT INTO okc_xprt_doc_ques_response (doc_question_response_id, doc_id, doc_type, question_id, response)
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