APPS.AMS_DMSELECTION_PVT dependencies on AMS_DM_SCORES_ALL_B

Line 514: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model

510: ;
511:
512: CURSOR c_score (p_score_id IN NUMBER) IS
513: SELECT model.target_id
514: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model
515: WHERE score.score_id = p_score_id
516: AND model.model_id = score.model_id
517: ;
518:

Line 831: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_targets_b target

827: ;
828:
829: CURSOR c_score (p_score_id IN NUMBER) IS
830: SELECT target.data_source_id , target.target_id
831: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_targets_b target
832: WHERE score.score_id = p_score_id
833: AND model.model_id = score.model_id
834: AND target.target_id = model.target_id
835: ;

Line 1247: FROM ams_dm_scores_all_b

1243: ;
1244:
1245: CURSOR c_model_id (p_score_id IN NUMBER) IS
1246: SELECT model_id
1247: FROM ams_dm_scores_all_b
1248: WHERE score_id = p_score_id
1249: ;
1250:
1251: L_API_NAME CONSTANT VARCHAR2(30) := 'Purge Target Staging';

Line 1454: FROM ams_dm_scores_all_b

1450: WHERE model_id = p_model_id;
1451:
1452: CURSOR c_score_status (p_score_id IN NUMBER) IS
1453: SELECT status_code
1454: FROM ams_dm_scores_all_b
1455: WHERE score_id = p_score_id;
1456:
1457: CURSOR c_model_id (p_score_id IN NUMBER) IS
1458: SELECT model_id

Line 1459: FROM ams_dm_scores_all_b

1455: WHERE score_id = p_score_id;
1456:
1457: CURSOR c_model_id (p_score_id IN NUMBER) IS
1458: SELECT model_id
1459: FROM ams_dm_scores_all_b
1460: WHERE score_id = p_score_id
1461: ;
1462:
1463: CURSOR c_model_type(p_model_id IN NUMBER) is

Line 1510: UPDATE ams_dm_scores_all_b

1506: FETCH c_model_status INTO l_status_code;
1507: CLOSE c_model_status;
1508:
1509: ELSE
1510: UPDATE ams_dm_scores_all_b
1511: SET total_records = 0,
1512: total_positives = 0
1513: WHERE score_id = p_object_for_id
1514: ;

Line 1767: UPDATE ams_dm_scores_all_b

1763: END IF;
1764: ELSE
1765: -- use the results of the previous insert statement
1766: l_row_count := SQL%rowcount;
1767: UPDATE ams_dm_scores_all_b
1768: SET total_records = l_row_count
1769: WHERE score_id = p_object_for_id
1770: ;
1771:

Line 2441: FROM ams_dm_models_all_b m, ams_dm_scores_all_b s, ams_dm_targets_b t

2437: , m.model_type
2438: , m.target_positive_value
2439: , t.target_id
2440: , t.data_source_id
2441: FROM ams_dm_models_all_b m, ams_dm_scores_all_b s, ams_dm_targets_b t
2442: WHERE m.model_id = s.model_id
2443: AND s.score_id = p_score_id
2444: AND t.target_id = m.target_id
2445: ;

Line 2642: FROM ams_dm_scores_all_b

2638: max_records,
2639: row_selection_type,
2640: every_nth_row,
2641: pct_random
2642: FROM ams_dm_scores_all_b
2643: WHERE score_id = p_score_id
2644: ;
2645:
2646: CURSOR c_total_records (p_arc_object IN VARCHAR2, p_object_id IN NUMBER) IS

Line 3083: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst

3079: ;
3080:
3081: CURSOR c_score_child_ds (p_score_id IN NUMBER) IS
3082: SELECT source.data_source_id
3083: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst
3084: WHERE score.score_id = p_score_id
3085: AND model.model_id = score.model_id
3086: AND source.target_id = model.target_id
3087: AND lst.list_source_type_id = source.data_source_id