APPS.AMS_WFMOD_PVT dependencies on AMS_DM_MODELS_ALL_B

Line 605: FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target

601: , score.score_name
602: , score.status_code
603: , score.owner_user_id
604: , target.active_flag
605: FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target
606: WHERE score_id = p_obj_id
607: AND score.model_id = model.model_id
608: AND target.target_id = model.target_id
609: ;

Line 2173: UPDATE ams_dm_models_all_b

2169: -- update the logs_flag in model/score table
2170: -- to Y. don't increment version because this
2171: -- could happen often
2172: IF p_object_type = G_OBJECT_TYPE_MODEL THEN
2173: UPDATE ams_dm_models_all_b
2174: SET logs_flag = 'Y',
2175: last_update_date = SYSDATE,
2176: last_updated_by = FND_GLOBAL.user_id,
2177: last_update_login = FND_GLOBAL.conc_login_id

Line 2374: FROM ams_dm_models_all_b

2370: -- Cursor to get the wf_itemkey for a Model that is Building, Scoring or Previewing,
2371: -- excluding the current wf_itemkey
2372: CURSOR c_modelProcessing IS
2373: SELECT wf_itemkey
2374: FROM ams_dm_models_all_b
2375: WHERE status_code = G_STATUS_BUILDING
2376: OR status_code = G_STATUS_SCORING
2377: OR status_code = G_STATUS_PREVIEWING
2378: AND wf_itemkey <> p_itemkey;

Line 2908: FROM ams_dm_models_all_b

2904: l_is_enabled BOOLEAN;
2905:
2906: CURSOR c_target_id_model (p_model_id IN NUMBER) IS
2907: SELECT target_id
2908: FROM ams_dm_models_all_b
2909: WHERE model_id = p_model_id
2910: ;
2911:
2912: CURSOR c_target_id_score (p_score_id IN NUMBER) IS

Line 2914: FROM ams_dm_models_all_b m , ams_dm_scores_all_b s

2910: ;
2911:
2912: CURSOR c_target_id_score (p_score_id IN NUMBER) IS
2913: SELECT m.target_id
2914: FROM ams_dm_models_all_b m , ams_dm_scores_all_b s
2915: WHERE m.model_id = s.model_id
2916: AND s.score_id = p_score_id
2917: ;
2918: