APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_SCORE_DTLS

Line 20: l_max_score ar_cmgt_score_dtls.scores%TYPE;

16: p_score OUT NOCOPY NUMBER,
17: p_error_msg OUT NOCOPY VARCHAR2,
18: p_resultout OUT NOCOPY VARCHAR2 ) IS
19:
20: l_max_score ar_cmgt_score_dtls.scores%TYPE;
21: l_scores ar_cmgt_score_dtls.scores%TYPE;
22: l_weight ar_cmgt_score_weights.weight%TYPE;
23: l_data_point_type VARCHAR2(255);
24: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

Line 21: l_scores ar_cmgt_score_dtls.scores%TYPE;

17: p_error_msg OUT NOCOPY VARCHAR2,
18: p_resultout OUT NOCOPY VARCHAR2 ) IS
19:
20: l_max_score ar_cmgt_score_dtls.scores%TYPE;
21: l_scores ar_cmgt_score_dtls.scores%TYPE;
22: l_weight ar_cmgt_score_weights.weight%TYPE;
23: l_data_point_type VARCHAR2(255);
24: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
25: l_date_format VARCHAR2(255);

Line 39: FROM ar_cmgt_score_dtls

35:
36: BEGIN
37: SELECT max(scores)
38: INTO l_max_score
39: FROM ar_cmgt_score_dtls
40: WHERE score_model_id = p_score_model_id
41: AND data_point_id = p_data_point_id;
42: --output.put_line('the max score is = ' || l_max_score);
43:

Line 150: FROM ar_cmgt_score_dtls score,

146: --output.put_line('data point id = ' || p_data_point_id);
147:
148: SELECT score.scores, NVL(weight.weight,0)
149: INTO l_scores, l_weight
150: FROM ar_cmgt_score_dtls score,
151: AR_CMGT_SCORE_WEIGHTS weight
152: WHERE score.score_model_id = p_score_model_id
153: AND score.data_point_id = p_data_point_id
154: AND score.score_model_id = weight.score_model_id

Line 195: FROM ar_cmgt_score_dtls score,

191: THEN
192: BEGIN
193: SELECT score.scores, NVL(weight.weight,0)
194: INTO l_scores, l_weight
195: FROM ar_cmgt_score_dtls score,
196: AR_CMGT_SCORE_WEIGHTS weight
197: WHERE score.score_model_id = p_score_model_id
198: AND score.data_point_id = p_data_point_id
199: AND score.score_model_id = weight.score_model_id

Line 235: FROM ar_cmgt_score_dtls score,

231: THEN
232: BEGIN
233: SELECT score.scores, NVL(weight.weight,0)
234: INTO l_scores, l_weight
235: FROM ar_cmgt_score_dtls score,
236: AR_CMGT_SCORE_WEIGHTS weight
237: WHERE score.score_model_id = p_score_model_id
238: AND score.data_point_id = p_data_point_id
239: AND score.score_model_id = weight.score_model_id

Line 650: FROM ar_cmgt_score_dtls score,

646:
647:
648: CURSOR cScoreDataPoint IS
649: SELECT distinct score.data_point_id, score.score_model_id
650: FROM ar_cmgt_score_dtls score,
651: ar_cmgt_case_folders case1
652: WHERE case_folder_id = p_case_folder_id
653: AND case1.score_model_id = score.score_model_id;
654: l_total_score NUMBER := 0;

Line 725: FROM ar_cmgt_score_dtls score

721: p_resultout OUT NOCOPY VARCHAR2) IS
722:
723: CURSOR cScoreDataPoint IS
724: SELECT distinct score.data_point_id, score.score_model_id
725: FROM ar_cmgt_score_dtls score
726: WHERE score_model_id = p_score_model_id;
727:
728: l_total_score NUMBER := 0;
729: l_result VARCHAR2(1);