DBA Data[Home] [Help]

APPS.AR_CMGT_SCORING_ENGINE dependencies on FND_GLOBAL

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

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;
639:
640: EXCEPTION

Line 637: last_update_login = fnd_global.login_id

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;
639:
640: EXCEPTION
641: WHEN NO_DATA_FOUND THEN

Line 781: last_updated_by = fnd_global.user_id,

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
784: WHERE case_folder_id = p_case_folder_id;
785:

Line 783: last_update_login = fnd_global.login_id

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
784: WHERE case_folder_id = p_case_folder_id;
785:
786: FOR cScoreDataPoint_rec IN cScoreDataPoint
787: LOOP

Line 908: last_updated_by = fnd_global.user_id,

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
911: WHERE case_folder_id = p_case_folder_id;
912: * Changes end------------------------------------------------------------------

Line 910: last_update_login = fnd_global.login_id

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
911: WHERE case_folder_id = p_case_folder_id;
912: * Changes end------------------------------------------------------------------
913: * bug#5007954
914: */

Line 920: last_updated_by = fnd_global.user_id,

916: /* UPDATE ar_cmgt_case_folders
917: set score_model_id = p_score_model_id,
918: last_updated = SYSDATE,
919: last_update_date = sysdate,
920: last_updated_by = fnd_global.user_id,
921: last_update_login = fnd_global.login_id
922: WHERE case_folder_id = p_case_folder_id; */
923:
924: FOR cScoreDataPoint_rec IN cScoreDataPoint

Line 921: last_update_login = fnd_global.login_id

917: set score_model_id = p_score_model_id,
918: last_updated = SYSDATE,
919: last_update_date = sysdate,
920: last_updated_by = fnd_global.user_id,
921: last_update_login = fnd_global.login_id
922: WHERE case_folder_id = p_case_folder_id; */
923:
924: FOR cScoreDataPoint_rec IN cScoreDataPoint
925: LOOP