DBA Data[Home] [Help]

APPS.AR_CMGT_SCORING_ENGINE dependencies on FND_GLOBAL

Line 508: last_updated_by = fnd_global.user_id, last_update_date = sysdate,

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

Line 509: last_update_login = fnd_global.login_id

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

Line 671: last_updated_by = fnd_global.user_id,

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:

Line 673: last_update_login = fnd_global.login_id

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

Line 774: last_updated_by = fnd_global.user_id,

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------------------------------------------------------------------

Line 776: last_update_login = fnd_global.login_id

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: */

Line 786: last_updated_by = fnd_global.user_id,

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

Line 787: last_update_login = fnd_global.login_id

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