APPS.AMS_DM_SCORE_PVT dependencies on AMS_DM_SCORES_VL

Line 755: FROM ams_dm_scores_vl

751: l_target_id NUMBER;
752:
753: CURSOR c_reference (p_score_id IN NUMBER) IS
754: SELECT *
755: FROM ams_dm_scores_vl
756: WHERE score_id = p_score_id;
757: l_reference_rec c_reference%ROWTYPE;
758:
759: CURSOR c_status (p_id IN NUMBER) IS

Line 1543: WHERE EXISTS ( SELECT * from ams_dm_scores_vl

1539: l_valid_flag VARCHAR2(1);
1540:
1541: CURSOR c_score_name
1542: IS SELECT 1 from dual
1543: WHERE EXISTS ( SELECT * from ams_dm_scores_vl
1544: WHERE UPPER(score_name) = UPPER(p_score_rec.score_name)) ;
1545: CURSOR c_score_name_updt
1546: IS SELECT 1 from dual
1547: WHERE EXISTS ( SELECT * from ams_dm_scores_vl

Line 1547: WHERE EXISTS ( SELECT * from ams_dm_scores_vl

1543: WHERE EXISTS ( SELECT * from ams_dm_scores_vl
1544: WHERE UPPER(score_name) = UPPER(p_score_rec.score_name)) ;
1545: CURSOR c_score_name_updt
1546: IS SELECT 1 from dual
1547: WHERE EXISTS ( SELECT * from ams_dm_scores_vl
1548: WHERE UPPER(score_name) = UPPER(p_score_rec.score_name)
1549: AND score_id <> p_score_rec.score_id );
1550:
1551: l_dummy NUMBER ;

Line 1893: FROM ams_dm_scores_vl

1889: l_return_status VARCHAR2(1);
1890:
1891: CURSOR c_complete IS
1892: SELECT *
1893: FROM ams_dm_scores_vl
1894: WHERE score_id = p_score_rec.score_id;
1895: l_score_rec c_complete%ROWTYPE;
1896: BEGIN
1897: x_complete_rec := p_score_rec;

Line 2561: FROM ams_dm_scores_vl

2557: l_is_enabled BOOLEAN;
2558:
2559: CURSOR c_ref_score (p_score_id IN NUMBER) IS
2560: SELECT *
2561: FROM ams_dm_scores_vl
2562: WHERE score_id = p_score_id
2563: ;
2564:
2565: CURSOR c_target (p_score_id IN NUMBER) IS

Line 2762: FROM ams_dm_scores_vl

2758: l_errmsg VARCHAR2(4000);
2759:
2760: CURSOR c_score (p_score_id IN NUMBER) IS
2761: SELECT *
2762: FROM ams_dm_scores_vl
2763: WHERE score_id = p_score_id
2764: ;
2765: --start changes rosharma 20-aug-2003 bug 3104201
2766: CURSOR c_data_source (p_model_id IN NUMBER) IS

Line 3190: FROM ams_dm_scores_vl

3186: IS
3187:
3188: CURSOR c_ref_score (p_score_id IN NUMBER) IS
3189: SELECT *
3190: FROM ams_dm_scores_vl
3191: WHERE score_id = p_score_id
3192: ;
3193: l_ref_score_rec c_ref_score%ROWTYPE;
3194:

Line 3619: FROM ams_dm_scores_vl

3615: L_API_NAME CONSTANT VARCHAR2(30) := 'getScoreStatus';
3616:
3617: CURSOR c_score_status (p_score_id IN NUMBER) IS
3618: SELECT status_code, user_status_id
3619: FROM ams_dm_scores_vl
3620: WHERE score_id = p_score_id
3621: ;
3622:
3623: BEGIN

Line 3661: FROM ams_dm_scores_vl

3657: L_API_NAME CONSTANT VARCHAR2(30) := 'check_data_size_changes';
3658:
3659: CURSOR c_ref_score (p_score_id IN NUMBER) IS
3660: SELECT *
3661: FROM ams_dm_scores_vl
3662: WHERE score_id = p_score_id
3663: ;
3664: l_ref_score_rec c_ref_score%ROWTYPE;
3665:

Line 3785: FROM ams_dm_scores_vl

3781: L_API_NAME CONSTANT VARCHAR2(30) := 'handle_data_selection_changes';
3782:
3783: CURSOR c_ref_score (p_score_id IN NUMBER) IS
3784: SELECT *
3785: FROM ams_dm_scores_vl
3786: WHERE score_id = p_score_id
3787: ;
3788: l_ref_score_rec c_ref_score%ROWTYPE;
3789: