[Home] [Help]
7: -- 20-Nov-2000 julou created
8: -- 21-Nov-2000 julou added foreign key validation and lookup validation
9: -- added name and description to insert_row and update_row
10: -- 18-Dec-2000 julou added validation for object_version_number in delete procedure
11: -- 23-Jan-2001 choang Changed ams_dm_models_b to ams_dm_models_all_b in uk validation.
12: -- 24-Jan-2001 choang Changed package name to AMS_DM_SCORE_PVT.
13: -- 26-Jan-2001 choang Added increment of object ver num in update api.
14: -- 29-Jan-2001 choang Removed return statement in req item validation.
15: -- 12-Feb-2001 choang 1) Changed model_score to score. 2) added new columns.
441: -- 22-Aug-2003 - nyostos
442: -- Cursor to get the model_type for the scoring run
443: CURSOR c_model_type (l_model_id IN NUMBER) IS
444: SELECT model_type
445: FROM ams_dm_models_all_b
446: WHERE model_id = l_model_id
447: ;
448:
449: BEGIN
761: FROM ams_user_statuses_vl
762: WHERE user_status_id = p_id;
763:
764: CURSOR c_target_id (p_score_id IN NUMBER) IS
765: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s
766: WHERE m.model_id = s.model_id
767: AND s.score_id = p_score_id
768: ;
769: BEGIN
1727:
1728: --------------------model_id---------------------------
1729: IF p_score_rec.model_id <> FND_API.g_miss_num THEN
1730: IF AMS_Utility_PVT.check_fk_exists(
1731: 'AMS_DM_MODELS_ALL_B',
1732: 'MODEL_ID',
1733: p_score_rec.model_id
1734: ) = FND_API.g_false
1735: THEN
2443: OPEN c_user_status_id (G_STATUS_TYPE_MODEL, G_STATUS_AVAILABLE);
2444: FETCH c_user_status_id INTO l_model_status_id;
2445: CLOSE c_user_status_id;
2446:
2447: UPDATE ams_dm_models_all_b
2448: SET last_update_date = SYSDATE
2449: , last_updated_by = FND_GLOBAL.user_id
2450: , last_update_login = FND_GLOBAL.conc_login_id
2451: , object_version_number = object_version_number + 1
2505: OPEN c_user_status_id (G_STATUS_TYPE_MODEL, G_STATUS_AVAILABLE);
2506: FETCH c_user_status_id INTO l_model_status_id;
2507: CLOSE c_user_status_id;
2508:
2509: UPDATE ams_dm_models_all_b
2510: SET last_update_date = SYSDATE
2511: , last_updated_by = FND_GLOBAL.user_id
2512: , last_update_login = FND_GLOBAL.conc_login_id
2513: , object_version_number = object_version_number + 1
2562: WHERE score_id = p_score_id
2563: ;
2564:
2565: CURSOR c_target (p_score_id IN NUMBER) IS
2566: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s
2567: WHERE m.model_id = s.model_id
2568: AND s.score_id = p_score_id
2569: ;
2570:
2764: ;
2765: --start changes rosharma 20-aug-2003 bug 3104201
2766: CURSOR c_data_source (p_model_id IN NUMBER) IS
2767: SELECT t.DATA_SOURCE_ID , t.target_id
2768: FROM ams_dm_models_all_b m,ams_dm_targets_b t
2769: WHERE m.model_id = p_model_id
2770: AND m.target_id = t.target_id
2771: ;
2772:
3020: l_model_status_id NUMBER;
3021:
3022: CURSOR c_model (p_model_id IN NUMBER) IS
3023: SELECT *
3024: FROM ams_dm_models_all_b
3025: WHERE model_id = p_model_id;
3026: l_model_rec c_model%ROWTYPE;
3027:
3028: CURSOR c_score (p_score_id IN NUMBER) IS
3060: OPEN c_user_status_id (G_STATUS_TYPE_MODEL, G_STATUS_SCORING);
3061: FETCH c_user_status_id INTO l_model_status_id;
3062: CLOSE c_user_status_id;
3063:
3064: UPDATE ams_dm_models_all_b
3065: SET last_update_date = SYSDATE
3066: , last_updated_by = FND_GLOBAL.user_id
3067: , last_update_login = FND_GLOBAL.conc_login_id
3068: , object_version_number = object_version_number + 1
3308: OPEN c_user_status_id (G_STATUS_TYPE_MODEL, G_STATUS_AVAILABLE);
3309: FETCH c_user_status_id INTO l_model_status_id;
3310: CLOSE c_user_status_id;
3311:
3312: UPDATE ams_dm_models_all_b
3313: SET last_update_date = SYSDATE
3314: , last_updated_by = FND_GLOBAL.user_id
3315: , last_update_login = FND_GLOBAL.conc_login_id
3316: , object_version_number = object_version_number + 1
3736: l_model_status_id NUMBER;
3737:
3738: CURSOR c_model (p_model_id IN NUMBER) IS
3739: SELECT *
3740: FROM ams_dm_models_all_b
3741: WHERE model_id = p_model_id;
3742: l_model_rec c_model%ROWTYPE;
3743:
3744: CURSOR c_score (p_score_id IN NUMBER) IS