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 178: FROM ar_cmgt_score_dtls score,

174: -- Changed the value from 'l_data_point_value' to 'l_num_dp_value' in
175: -- the query.
176: SELECT score.scores, NVL(weight.weight,0)
177: INTO l_scores, l_weight
178: FROM ar_cmgt_score_dtls score,
179: AR_CMGT_SCORE_WEIGHTS weight
180: WHERE score.score_model_id = p_score_model_id
181: AND score.data_point_id = p_data_point_id
182: AND score.score_model_id = weight.score_model_id

Line 241: FROM ar_cmgt_score_dtls score,

237: BEGIN
238:
239: SELECT score.scores, NVL(weight.weight,0)
240: INTO l_scores, l_weight
241: FROM ar_cmgt_score_dtls score,
242: AR_CMGT_SCORE_WEIGHTS weight
243: WHERE score.score_model_id = p_score_model_id
244: AND score.data_point_id = p_data_point_id
245: AND score.score_model_id = weight.score_model_id

Line 299: FROM ar_cmgt_score_dtls score,

295: BEGIN
296:
297: SELECT score.scores, NVL(weight.weight,0)
298: INTO l_scores, l_weight
299: FROM ar_cmgt_score_dtls score,
300: AR_CMGT_SCORE_WEIGHTS weight
301: WHERE score.score_model_id = p_score_model_id
302: AND score.data_point_id = p_data_point_id
303: AND score.score_model_id = weight.score_model_id

Line 760: FROM ar_cmgt_score_dtls score,

756:
757:
758: CURSOR cScoreDataPoint IS
759: SELECT distinct score.data_point_id, score.score_model_id
760: FROM ar_cmgt_score_dtls score,
761: ar_cmgt_case_folders case1
762: WHERE case_folder_id = p_case_folder_id
763: AND case1.score_model_id = score.score_model_id;
764: l_total_score NUMBER := 0;

Line 836: FROM ar_cmgt_score_dtls score

832: p_resultout OUT NOCOPY VARCHAR2) IS
833:
834: CURSOR cScoreDataPoint IS
835: SELECT distinct score.data_point_id, score.score_model_id
836: FROM ar_cmgt_score_dtls score
837: WHERE score_model_id = p_score_model_id;
838:
839: l_total_score NUMBER := 0;
840: l_result VARCHAR2(1);