APPS.AR_CMGT_SCORING_ENGINE dependencies on AR_CMGT_CF_DTLS

Line 24: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

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);
26: NULL_ZERO_CONVR_IND VARCHAR2(1);
27: BEGIN
28: IF pg_debug = 'Y'

Line 336: FROM AR_CMGT_CF_DTLS

332: BEGIN
333:
334: SELECT INCLUDED_IN_CHECKLIST
335: INTO l_chk_list
336: FROM AR_CMGT_CF_DTLS
337: WHERE CASE_FOLDER_ID=p_case_folder_id
338: AND DATA_POINT_ID=p_data_point_id;
339: EXCEPTION
340:

Line 359: Update ar_cmgt_cf_dtls

355: --not updated from PLSQL.
356:
357: if l_updt_flag ='Y' THEN
358:
359: Update ar_cmgt_cf_dtls
360: set data_point_value = p_data_point_value,
361: score = l_score
362: WHERE data_point_id = p_data_point_id
363: AND case_folder_id = p_case_folder_id;

Line 461: l_data_point_value ar_cmgt_cf_dtls.data_point_value%TYPE;

457: p_score OUT NOCOPY NUMBER,
458: p_error_msg OUT NOCOPY VARCHAR2,
459: p_resultout OUT NOCOPY VARCHAR2) IS
460:
461: l_data_point_value ar_cmgt_cf_dtls.data_point_value%TYPE;
462: l_data_point_id ar_cmgt_data_points_vl.data_point_id%TYPE;
463: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
464: l_total_score NUMBER := 0;
465: l_score NUMBER := 0;

Line 506: UPDATE ar_cmgt_cf_dtls

502: -- in because Scoreing model could be different for different
503: -- case folders for the same party account and site combination.
504: -- But the data records will be the same for the same combination.
505: -- So it would be idle to update score to null.
506: UPDATE ar_cmgt_cf_dtls
507: SET score = null,
508: last_updated_by = fnd_global.user_id, last_update_date = sysdate,
509: last_update_login = fnd_global.login_id
510: WHERE case_folder_id = g_data_case_folder_id;

Line 524: FROM ar_cmgt_cf_dtls

520: THEN */
521: BEGIN
522: SELECT data_point_value
523: INTO l_data_point_value
524: FROM ar_cmgt_cf_dtls
525: WHERE case_folder_id = p_case_folder_id
526: AND data_point_id = p_data_point_id;
527: EXCEPTION
528: WHEN OTHERS THEN

Line 561: FROM ar_cmgt_cf_dtls

557: THEN
558: BEGIN
559: SELECT data_point_value
560: INTO l_data_point_value
561: FROM ar_cmgt_cf_dtls
562: WHERE case_folder_id = p_case_folder_id
563: AND data_point_id = p_data_point_id;
564: EXCEPTION
565: WHEN NO_DATA_FOUND

Line 669: UPDATE ar_cmgt_cf_dtls

665: -- analysis. In case credit analyst change the scoring model
666: -- then the old score need to be updated with the new value.
667: -- Also the number of data points could vary from scoring model to
668: -- scoring model.
669: UPDATE ar_cmgt_cf_dtls
670: SET score = null,
671: last_updated_by = fnd_global.user_id,
672: last_update_date = sysdate,
673: last_update_login = fnd_global.login_id

Line 772: UPDATE ar_cmgt_cf_dtls

768: -- Also the number of data points could vary from scoring model to
769: -- scoring model.
770: /*Changes Start----------------------------------------------------------------
771: * bug#5007954
772: UPDATE ar_cmgt_cf_dtls
773: SET score = null,
774: last_updated_by = fnd_global.user_id,
775: last_update_date = sysdate,
776: last_update_login = fnd_global.login_id