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_XPRT_RULES_ENGINE_PVT dependencies on OKC_XPRT_DOC_QUES_RESPONSE

Line 304: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

300: AND outcome.object_value_id = q.question_id;
301:
302: CURSOR c_question_and_response is
303: SELECT distinct cond.object_code, resp.response, q.mandatory_flag display_flag
304: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
305: WHERE cond.doc_id = p_doc_id
306: AND cond.doc_type = p_doc_type
307: AND cond.condition_type = 'QUESTION'
308: AND resp.doc_id (+) = cond.doc_id

Line 315: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

311: AND q.template_id = p_template_id
312: AND cond.object_code = q.question_id
313: UNION
314: SELECT distinct cond.object_value_code, resp.response, q.mandatory_flag display_flag
315: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
316: WHERE cond.doc_id = p_doc_id
317: AND cond.doc_type = p_doc_type
318: AND cond.object_value_type = 'QUESTION'
319: AND resp.doc_id (+) = cond.doc_id

Line 326: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

322: AND q.template_id = p_template_id
323: AND cond.object_value_code = q.question_id
324: UNION
325: SELECT distinct to_char(outcome.object_value_id), resp.response, q.mandatory_flag display_flag
326: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
327: WHERE rultmpl.template_id = p_template_id
328: AND outcome.rule_id = rultmpl.rule_id
329: AND outcome.object_type = 'QUESTION'
330: AND resp.doc_id (+) = p_doc_id

Line 337: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

333: AND q.template_id = p_template_id
334: AND outcome.object_value_id = q.question_id
335: UNION
336: SELECT distinct to_char(outcome.object_value_id), resp.response, q.mandatory_flag display_flag
337: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
338: WHERE rul.org_wide_flag = 'Y'
339: AND outcome.rule_id = rul.rule_id
340: AND outcome.object_type = 'QUESTION'
341: AND resp.doc_id (+) = p_doc_id

Line 366: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND response IS NOT NULL);

362: END IF;
363:
364: BEGIN
365: SELECT 'Y' INTO is_contract_expert_run FROM dual
366: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND response IS NOT NULL);
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: NULL;
370: END;

Line 1578: --deleting the responses and copying the new responses into okc_xprt_doc_ques_response table

1574: END IF;
1575: END IF; -- p_create_lock_for_xprt = 'Y'
1576: --concurrent mod chanegs end
1577:
1578: --deleting the responses and copying the new responses into okc_xprt_doc_ques_response table
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)

Line 1579: DELETE okc_xprt_doc_ques_response WHERE doc_id = p_doc_id AND doc_type = p_doc_type;

1575: END IF; -- p_create_lock_for_xprt = 'Y'
1576: --concurrent mod chanegs end
1577:
1578: --deleting the responses and copying the new responses into okc_xprt_doc_ques_response table
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

Line 1581: --copying the responses to okc_xprt_doc_ques_response

1577:
1578: --deleting the responses and copying the new responses into okc_xprt_doc_ques_response table
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:

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

1578: --deleting the responses and copying the new responses into okc_xprt_doc_ques_response table
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

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

Line 1667: --copying the responses to okc_xprt_doc_ques_response_h

1663:
1664: p_doc_id := doc_id;
1665: p_doc_type := doc_type;
1666:
1667: --copying the responses to okc_xprt_doc_ques_response_h
1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)
1669: (SELECT doc_question_response_id, p_doc_id, p_doc_type, p_major_version, question_id, response FROM okc_xprt_doc_ques_response
1670: WHERE doc_id = p_doc_id AND doc_type = p_doc_type);
1671:

Line 1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)

1664: p_doc_id := doc_id;
1665: p_doc_type := doc_type;
1666:
1667: --copying the responses to okc_xprt_doc_ques_response_h
1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)
1669: (SELECT doc_question_response_id, p_doc_id, p_doc_type, p_major_version, question_id, response FROM okc_xprt_doc_ques_response
1670: WHERE doc_id = p_doc_id AND doc_type = p_doc_type);
1671:
1672: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1669: (SELECT doc_question_response_id, p_doc_id, p_doc_type, p_major_version, question_id, response FROM okc_xprt_doc_ques_response

1665: p_doc_type := doc_type;
1666:
1667: --copying the responses to okc_xprt_doc_ques_response_h
1668: INSERT INTO okc_xprt_doc_ques_response_h (doc_question_response_id, doc_id, doc_type, major_version, question_id, response)
1669: (SELECT doc_question_response_id, p_doc_id, p_doc_type, p_major_version, question_id, response FROM okc_xprt_doc_ques_response
1670: WHERE doc_id = p_doc_id AND doc_type = p_doc_type);
1671:
1672: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '110: no. of rows copied : ' || sql%rowcount);

Line 1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table

1700:
1701: p_doc_id := doc_id;
1702: p_doc_type := doc_type;
1703:
1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table
1705: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h
1707: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version);
1708:

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

1701: p_doc_id := doc_id;
1702: p_doc_type := doc_type;
1703:
1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table
1705: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h
1707: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version);
1708:
1709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h

1702: p_doc_type := doc_type;
1703:
1704: --copying the responses to okc_xprt_doc_ques_response from okc_xprt_doc_ques_response_h table
1705: INSERT INTO okc_xprt_doc_ques_response(doc_question_response_id, doc_id, doc_type, question_id, response)
1706: (SELECT doc_question_response_id, p_doc_id, p_doc_type, question_id, response FROM okc_xprt_doc_ques_response_h
1707: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version);
1708:
1709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1710: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '110: no. of rows copied : ' || sql%rowcount);

Line 1741: --deleting the responses from okc_xprt_doc_ques_response_h history table as the revision is deleted.

1737:
1738: p_doc_id := doc_id;
1739: p_doc_type := doc_type;
1740:
1741: --deleting the responses from okc_xprt_doc_ques_response_h history table as the revision is deleted.
1742: DELETE FROM okc_xprt_doc_ques_response_h
1743: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version;
1744:
1745: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1742: DELETE FROM okc_xprt_doc_ques_response_h

1738: p_doc_id := doc_id;
1739: p_doc_type := doc_type;
1740:
1741: --deleting the responses from okc_xprt_doc_ques_response_h history table as the revision is deleted.
1742: DELETE FROM okc_xprt_doc_ques_response_h
1743: WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND major_version = p_major_version;
1744:
1745: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1746: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '110: no. of rows deleted : ' || sql%rowcount);