APPS.AMS_DM_MODEL_PVT dependencies on AMS_DM_MODELS_VL

Line 537: FROM ams_dm_models_vl

533: FROM DUAL;
534:
535: CURSOR c_dm_model_count(p_model_id IN NUMBER) IS
536: SELECT 1
537: FROM ams_dm_models_vl
538: WHERE model_id = p_model_id;
539:
540: CURSOR c_pass_status_code (p_user_status_id IN NUMBER) IS
541: SELECT system_status_code

Line 857: FROM ams_dm_models_vl

853: WHERE user_status_id = p_user_status_id;
854:
855: CURSOR c_ref_model (p_model_id IN NUMBER) IS
856: SELECT *
857: FROM ams_dm_models_vl
858: WHERE model_id = p_model_id
859: ;
860:
861: l_ref_model_rec c_ref_model%ROWTYPE;

Line 1723: WHERE EXISTS ( SELECT * from ams_dm_models_vl

1719: WHERE EXISTS ( SELECT * from ams_dm_models_all_tl
1720: WHERE UPPER(model_name) = UPPER(p_dm_model_rec.model_name) and LANGUAGE = userenv('LANG')) ;
1721: CURSOR c_model_name_updt
1722: IS SELECT 1 from dual
1723: WHERE EXISTS ( SELECT * from ams_dm_models_vl
1724: WHERE UPPER(model_name) = UPPER(p_dm_model_rec.model_name)
1725: AND model_id <> p_DM_MODEL_rec.model_id );
1726:
1727: l_dummy NUMBER ;

Line 2238: FROM ams_dm_models_vl

2234: )
2235: IS
2236: CURSOR c_complete IS
2237: SELECT *
2238: FROM ams_dm_models_vl
2239: WHERE model_id = p_dm_model_rec.model_id
2240: ;
2241: l_model_rec c_complete%ROWTYPE;
2242: BEGIN

Line 2845: FROM ams_dm_models_vl

2841: IS
2842:
2843: CURSOR c_ref_model (p_model_id IN NUMBER) IS
2844: SELECT *
2845: FROM ams_dm_models_vl
2846: WHERE model_id = p_model_id
2847: ;
2848: l_ref_model_rec c_ref_model%ROWTYPE;
2849:

Line 3023: FROM ams_dm_models_vl

3019: l_is_enabled BOOLEAN;
3020:
3021: CURSOR c_ref_model (p_model_id IN NUMBER) IS
3022: SELECT *
3023: FROM ams_dm_models_vl
3024: WHERE model_id = p_model_id
3025: ;
3026:
3027: CURSOR c_target (p_model_id IN NUMBER) IS

Line 3028: SELECT target_id from ams_dm_models_vl

3024: WHERE model_id = p_model_id
3025: ;
3026:
3027: CURSOR c_target (p_model_id IN NUMBER) IS
3028: SELECT target_id from ams_dm_models_vl
3029: WHERE model_id = p_model_id
3030: ;
3031:
3032: l_ref_model_rec c_ref_model%ROWTYPE;

Line 3225: FROM ams_dm_models_vl

3221: l_errmsg VARCHAR2(4000);
3222:
3223: CURSOR c_model (p_model_id IN NUMBER) IS
3224: SELECT *
3225: FROM ams_dm_models_vl
3226: WHERE model_id = p_model_id
3227: ;
3228: --start changes rosharma 20-aug-2003 bug 3104201
3229: CURSOR c_data_source (p_model_id IN NUMBER) IS

Line 3718: FROM ams_dm_models_vl

3714: -- l_return_status VARCHAR2(1);
3715:
3716: CURSOR c_model_status (p_model_id IN NUMBER) IS
3717: SELECT status_code, user_status_id
3718: FROM ams_dm_models_vl
3719: WHERE model_id = p_model_id
3720: ;
3721:
3722: BEGIN

Line 3967: FROM ams_dm_models_vl

3963: L_API_NAME CONSTANT VARCHAR2(30) := 'check_data_size_changes';
3964:
3965: CURSOR c_ref_model (p_model_id IN NUMBER) IS
3966: SELECT *
3967: FROM ams_dm_models_vl
3968: WHERE model_id = p_model_id
3969: ;
3970: l_ref_model_rec c_ref_model%ROWTYPE;
3971:

Line 4045: FROM ams_dm_models_vl

4041: L_API_NAME CONSTANT VARCHAR2(30) := 'handle_data_selection_changes';
4042:
4043: CURSOR c_ref_model (p_model_id IN NUMBER) IS
4044: SELECT *
4045: FROM ams_dm_models_vl
4046: WHERE model_id = p_model_id
4047: ;
4048: l_ref_model_rec c_ref_model%ROWTYPE;
4049: