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 448: FROM AR_CMGT_CF_DTLS

444: BEGIN
445:
446: SELECT INCLUDED_IN_CHECKLIST
447: INTO l_chk_list
448: FROM AR_CMGT_CF_DTLS
449: WHERE CASE_FOLDER_ID=p_case_folder_id
450: AND DATA_POINT_ID=p_data_point_id;
451: EXCEPTION
452:

Line 479: Update ar_cmgt_cf_dtls

475: --not updated from PLSQL.
476:
477: if l_updt_flag ='Y' THEN
478:
479: Update ar_cmgt_cf_dtls
480: set data_point_value = p_data_point_value,
481: score = l_score
482: WHERE data_point_id = p_data_point_id
483: AND case_folder_id = p_case_folder_id;

Line 581: l_data_point_value ar_cmgt_cf_dtls.data_point_value%TYPE;

577: p_score OUT NOCOPY NUMBER,
578: p_error_msg OUT NOCOPY VARCHAR2,
579: p_resultout OUT NOCOPY VARCHAR2) IS
580:
581: l_data_point_value ar_cmgt_cf_dtls.data_point_value%TYPE;
582: l_data_point_id ar_cmgt_data_points_vl.data_point_id%TYPE;
583: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
584: l_total_score NUMBER := 0;
585: l_score NUMBER := 0;

Line 634: UPDATE ar_cmgt_cf_dtls

630: -- in because Scoreing model could be different for different
631: -- case folders for the same party account and site combination.
632: -- But the data records will be the same for the same combination.
633: -- So it would be idle to update score to null.
634: UPDATE ar_cmgt_cf_dtls
635: SET score = null,
636: last_updated_by = fnd_global.user_id, last_update_date = sysdate,
637: last_update_login = fnd_global.login_id
638: WHERE case_folder_id = g_data_case_folder_id;

Line 655: ar_cmgt_cf_dtls cfd

651: accomodate DNB datapoints */
652: SELECT cfd.data_point_value
653: INTO l_data_point_value
654: FROM ar_cmgt_scorable_data_points_v sdp,
655: ar_cmgt_cf_dtls cfd
656: WHERE cfd.case_folder_id = p_case_folder_id
657: AND sdp.data_point_id = cfd.data_point_id (+)
658: AND sdp.data_point_id = p_data_point_id;
659:

Line 779: UPDATE ar_cmgt_cf_dtls

775: -- analysis. In case credit analyst change the scoring model
776: -- then the old score need to be updated with the new value.
777: -- Also the number of data points could vary from scoring model to
778: -- scoring model.
779: UPDATE ar_cmgt_cf_dtls
780: SET score = null,
781: last_updated_by = fnd_global.user_id,
782: last_update_date = sysdate,
783: last_update_login = fnd_global.login_id

Line 906: UPDATE ar_cmgt_cf_dtls

902: -- Also the number of data points could vary from scoring model to
903: -- scoring model.
904: /*Changes Start----------------------------------------------------------------
905: * bug#5007954
906: UPDATE ar_cmgt_cf_dtls
907: SET score = null,
908: last_updated_by = fnd_global.user_id,
909: last_update_date = sysdate,
910: last_update_login = fnd_global.login_id