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;
511:
512: EXCEPTION
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;
511:
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
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
674: WHERE case_folder_id = p_case_folder_id;
675:
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
674: WHERE case_folder_id = p_case_folder_id;
675:
676: FOR cScoreDataPoint_rec IN cScoreDataPoint
677: LOOP
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
777: WHERE case_folder_id = p_case_folder_id;
778: * Changes end------------------------------------------------------------------
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
777: WHERE case_folder_id = p_case_folder_id;
778: * Changes end------------------------------------------------------------------
779: * bug#5007954
780: */
782: /* UPDATE ar_cmgt_case_folders
783: set score_model_id = p_score_model_id,
784: last_updated = SYSDATE,
785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id
788: WHERE case_folder_id = p_case_folder_id; */
789:
790: FOR cScoreDataPoint_rec IN cScoreDataPoint
783: set score_model_id = p_score_model_id,
784: last_updated = SYSDATE,
785: last_update_date = sysdate,
786: last_updated_by = fnd_global.user_id,
787: last_update_login = fnd_global.login_id
788: WHERE case_folder_id = p_case_folder_id; */
789:
790: FOR cScoreDataPoint_rec IN cScoreDataPoint
791: LOOP