[Home] [Help]
48:
49: x_has_questions := 'N';
50:
51: BEGIN
52: SELECT 'Y' INTO x_has_questions FROM dual
53: WHERE EXISTS (SELECT 1 FROM okc_xprt_rule_eval_condval_t WHERE doc_id = p_doc_id AND doc_type = p_doc_type
54: AND object_type = 'QUESTION' AND display_flag = 'Y');
55: EXCEPTION
56: WHEN NO_DATA_FOUND THEN
361: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '100: Entering method');
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;
623: AND result_tmp.doc_id = p_doc_id
624: AND result_tmp.doc_type = p_doc_type;
625:
626: BEGIN
627: SELECT 'Y' INTO has_clauses FROM dual
628: WHERE EXISTS (SELECT 1 FROM okc_xprt_rule_eval_result_t WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND condition_type = 'CLAUSE');
629: EXCEPTION
630: WHEN NO_DATA_FOUND THEN
631: NULL;
1088: rule_ids2.trim(reeval_rules.count - (k - 1));
1089: rule_ids3.trim(reeval_rules.count - (l - 1));
1090:
1091: BEGIN
1092: SELECT 'Y' INTO has_clauses FROM dual
1093: WHERE EXISTS (SELECT 1 FROM okc_xprt_rule_eval_result_t WHERE doc_id = p_doc_id AND doc_type = p_doc_type AND condition_type = 'CLAUSE');
1094: EXCEPTION
1095: WHEN NO_DATA_FOUND THEN
1096: NULL;
1621: p_doc_id := doc_id;
1622: p_doc_type := doc_type;
1623:
1624: BEGIN
1625: SELECT 'N' INTO has_all_ques_answered FROM dual
1626: WHERE EXISTS (SELECT 1 FROM okc_xprt_rule_eval_condval_t WHERE doc_id = p_doc_id AND doc_type = p_doc_type
1627: AND object_type = 'QUESTION' AND display_flag = 'Y' AND value_or_response IS NULL);
1628: EXCEPTION
1629: WHEN NO_DATA_FOUND THEN