eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DM_SCORE_PVT dependencies on AMS_DM_SCORES_ALL_B

Line 265: FROM ams_dm_scores_all_b

261: l_score_id NUMBER;
262:
263: CURSOR c_Score_b IS
264: SELECT score_id
265: FROM ams_dm_scores_all_b
266: WHERE score_id = p_score_id
267: AND object_version_number = p_object_version
268: FOR UPDATE NOWAIT;
269:

Line 410: SELECT ams_dm_scores_all_b_s.NEXTVAL

406:
407: l_is_org_prod BOOLEAN;
408:
409: CURSOR c_id IS
410: SELECT ams_dm_scores_all_b_s.NEXTVAL
411: FROM dual;
412:
413: CURSOR c_id_exists (l_id IN NUMBER) IS
414: SELECT 1

Line 415: FROM ams_dm_scores_all_b

411: FROM dual;
412:
413: CURSOR c_id_exists (l_id IN NUMBER) IS
414: SELECT 1
415: FROM ams_dm_scores_all_b
416: WHERE score_id = l_id;
417:
418: CURSOR c_status_code (p_user_status_id IN NUMBER) IS
419: SELECT system_status_code

Line 765: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s

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

Line 1378: FROM ams_dm_scores_all_b

1374: IS
1375:
1376: CURSOR c_obj_version(c_id NUMBER) IS
1377: SELECT object_version_number
1378: FROM ams_dm_scores_all_b
1379: WHERE score_id = c_id;
1380:
1381: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Score';
1382: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1564: 'AMS_DM_SCORES_ALL_B',

1560:
1561: x_return_status := FND_API.g_ret_sts_success;
1562: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1563: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1564: 'AMS_DM_SCORES_ALL_B',
1565: 'SCORE_ID = ''' || p_score_rec.score_id ||''''
1566: );
1567: ELSE
1568: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1569: 'AMS_DM_scoreS_ALL_B',

1565: 'SCORE_ID = ''' || p_score_rec.score_id ||''''
1566: );
1567: ELSE
1568: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1569: 'AMS_DM_scoreS_ALL_B',
1570: 'score_ID = ''' || p_score_rec.score_id ||
1571: ''' AND score_ID <> ' || p_score_rec.score_id
1572: );
1573: END IF;

Line 2253: FROM ams_dm_scores_all_b

2249:
2250: -- add to select list as needed
2251: CURSOR c_reference (p_score_id IN NUMBER) IS
2252: SELECT owner_user_id
2253: FROM ams_dm_scores_all_b
2254: WHERE score_id = p_score_id;
2255: l_reference_rec c_reference%ROWTYPE;
2256: BEGIN
2257: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2424: FROM ams_dm_scores_all_b

2420: l_model_status_id NUMBER;
2421:
2422: CURSOR c_score (p_score_id IN NUMBER) IS
2423: SELECT *
2424: FROM ams_dm_scores_all_b
2425: WHERE score_id = p_score_id
2426: ;
2427: l_score_rec c_score%ROWTYPE;
2428: BEGIN

Line 2463: UPDATE ams_dm_scores_all_b

2459: OPEN c_user_status_id (G_STATUS_TYPE_SCORE, p_status_code);
2460: FETCH c_user_status_id INTO l_user_status_id;
2461: CLOSE c_user_status_id;
2462:
2463: UPDATE ams_dm_scores_all_b
2464: SET last_update_date = SYSDATE
2465: , last_updated_by = FND_GLOBAL.user_id
2466: , last_update_login = FND_GLOBAL.conc_login_id
2467: , object_version_number = object_version_number + 1

Line 2486: FROM ams_dm_scores_all_b

2482: l_model_status_id NUMBER;
2483:
2484: CURSOR c_score (p_score_id IN NUMBER) IS
2485: SELECT *
2486: FROM ams_dm_scores_all_b
2487: WHERE score_id = p_score_id
2488: ;
2489: l_score_rec c_score%ROWTYPE;
2490: BEGIN

Line 2525: UPDATE ams_dm_scores_all_b

2521: OPEN c_user_status_id (G_STATUS_TYPE_SCORE, p_status_code);
2522: FETCH c_user_status_id INTO l_user_status_id;
2523: CLOSE c_user_status_id;
2524:
2525: UPDATE ams_dm_scores_all_b
2526: SET object_version_number = object_version_number + 1
2527: , last_update_date = SYSDATE
2528: , last_updated_by = FND_GLOBAL.user_id
2529: , status_date = SYSDATE

Line 2566: SELECT m.target_id from ams_dm_models_all_b m,ams_dm_scores_all_b s

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:

Line 2670: UPDATE ams_dm_scores_all_b

2666: x_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_score_rec.wf_itemkey, 'NO');
2667:
2668: -- Update the Scoring Run record with the new status code (PREVIEWING) and Id
2669: -- and also with the WF Item Key
2670: UPDATE ams_dm_scores_all_b
2671: SET logs_flag = 'Y',
2672: object_version_number = object_version_number + 1,
2673: last_update_date = SYSDATE,
2674: last_updated_by = FND_GLOBAL.user_id,

Line 3030: FROM ams_dm_scores_all_b

3026: l_model_rec c_model%ROWTYPE;
3027:
3028: CURSOR c_score (p_score_id IN NUMBER) IS
3029: SELECT *
3030: FROM ams_dm_scores_all_b
3031: WHERE score_id = p_score_id;
3032: l_score_rec c_score%ROWTYPE;
3033: BEGIN
3034: -- Initialize API return status to SUCCESS

Line 3079: UPDATE ams_dm_scores_all_b

3075: OPEN c_user_status_id (G_STATUS_TYPE_SCORE, G_STATUS_SCORING);
3076: FETCH c_user_status_id INTO l_user_status_id;
3077: CLOSE c_user_status_id;
3078:
3079: UPDATE ams_dm_scores_all_b
3080: SET last_update_date = SYSDATE
3081: , last_updated_by = FND_GLOBAL.user_id
3082: , last_update_login = FND_GLOBAL.conc_login_id
3083: , object_version_number = object_version_number + 1

Line 3107: FROM ams_dm_scores_all_b

3103: CURSOR c_scoring_model IS
3104: SELECT 1
3105: FROM dual
3106: WHERE EXISTS (SELECT 1
3107: FROM ams_dm_scores_all_b
3108: WHERE model_id = p_model_id
3109: AND status_code = G_STATUS_SCORING
3110: AND score_id <> p_current_score_id)
3111: ;

Line 3295: UPDATE ams_dm_scores_all_b

3291: END IF;
3292:
3293:
3294: -- update the Scoring Run record with new status code and id and with NULL wf_itemkey
3295: UPDATE ams_dm_scores_all_b
3296: SET object_version_number = object_version_number + 1,
3297: last_update_date = SYSDATE,
3298: last_updated_by = FND_GLOBAL.user_id,
3299: status_date = SYSDATE,

Line 3454: UPDATE ams_dm_scores_all_b

3450: delete from ams_dm_score_pct_results
3451: where score_id = p_score_id;
3452:
3453: -- Set the results_flag to 'N'
3454: UPDATE ams_dm_scores_all_b
3455: SET results_flag = 'N'
3456: WHERE score_id = p_score_id;
3457:
3458: -- Debug Message

Line 3492: FROM ams_dm_scores_all_b

3488: AND action_used_by_id = p_score_id;
3489:
3490: CURSOR l_modelId (p_score_id IN NUMBER) IS
3491: SELECT model_id
3492: FROM ams_dm_scores_all_b
3493: WHERE score_id = p_score_id;
3494:
3495: BEGIN
3496:

Line 3746: FROM ams_dm_scores_all_b

3742: l_model_rec c_model%ROWTYPE;
3743:
3744: CURSOR c_score (p_score_id IN NUMBER) IS
3745: SELECT *
3746: FROM ams_dm_scores_all_b
3747: WHERE score_id = p_score_id;
3748: l_score_rec c_score%ROWTYPE;
3749: BEGIN
3750: -- Initialize API return status to SUCCESS

Line 3813: -- UPDATE ams_dm_scores_all_b

3809: FETCH c_user_status_id INTO l_status_id;
3810: CLOSE c_user_status_id;
3811:
3812: -- update the Scoring Run record with new status code and id and with NULL wf_itemkey
3813: -- UPDATE ams_dm_scores_all_b
3814: -- SET object_version_number = object_version_number + 1,
3815: -- last_update_date = SYSDATE,
3816: -- last_updated_by = FND_GLOBAL.user_id,
3817: -- status_date = SYSDATE,

Line 3822: UPDATE ams_dm_scores_all_b

3818: -- status_code = G_STATUS_INVALID,
3819: -- user_status_id = l_status_id
3820: -- WHERE score_id = p_score_id;
3821:
3822: UPDATE ams_dm_scores_all_b
3823: SET last_update_date = SYSDATE,
3824: last_updated_by = FND_GLOBAL.user_id,
3825: status_date = SYSDATE,
3826: status_code = G_STATUS_INVALID,