APPS.AMS_DM_TARGET_PVT dependencies on AMS_DM_TARGETS_VL

Line 68: FROM AMS_DM_TARGETS_VL

64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1
68: FROM AMS_DM_TARGETS_VL
69: WHERE TARGET_ID = l_id;
70:
71: BEGIN
72: -- Standard Start of API savepoint

Line 273: FROM AMS_DM_TARGETS_VL

269:
270: IS
271: CURSOR c_get_dmtarget(p_target_id IN NUMBER) IS
272: SELECT *
273: FROM AMS_DM_TARGETS_VL
274: WHERE target_id = p_target_id;
275:
276: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Dmtarget';
277: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 559: FROM ams_dm_targets_vl

555:
556: -- Cursor to get the data source id for the target
557: CURSOR c_datasource_id (l_tgtId IN NUMBER) IS
558: SELECT data_source_id
559: FROM ams_dm_targets_vl
560: WHERE target_id = l_tgtId;
561:
562: -- Cursor to count the active targets defined for a data source
563: CURSOR c_target_count (l_dsId IN NUMBER) IS

Line 565: FROM AMS_DM_TARGETS_VL

561:
562: -- Cursor to count the active targets defined for a data source
563: CURSOR c_target_count (l_dsId IN NUMBER) IS
564: SELECT count(*)
565: FROM AMS_DM_TARGETS_VL
566: WHERE DATA_SOURCE_ID = l_dsId
567: AND ACTIVE_FLAG = 'Y';
568:
569:

Line 882: WHERE EXISTS ( SELECT * from ams_dm_targets_vl

878: l_number NUMBER;
879:
880: CURSOR c_target_name
881: IS SELECT 1 from dual
882: WHERE EXISTS ( SELECT * from ams_dm_targets_vl
883: WHERE UPPER(target_name) = UPPER(p_dm_target_rec.target_name)) ;
884: CURSOR c_target_name_updt
885: IS SELECT 1 from dual
886: WHERE EXISTS ( SELECT * from ams_dm_targets_vl

Line 886: WHERE EXISTS ( SELECT * from ams_dm_targets_vl

882: WHERE EXISTS ( SELECT * from ams_dm_targets_vl
883: WHERE UPPER(target_name) = UPPER(p_dm_target_rec.target_name)) ;
884: CURSOR c_target_name_updt
885: IS SELECT 1 from dual
886: WHERE EXISTS ( SELECT * from ams_dm_targets_vl
887: WHERE UPPER(target_name) = UPPER(p_dm_target_rec.target_name)
888: AND target_id <> p_dm_target_rec.target_id );
889:
890: l_dummy NUMBER ;

Line 895: FROM AMS_DM_TARGETS_VL

891:
892: /* commented rosharma. not needed anymore for 11.5.10 and hence
893: CURSOR c_unique_values (l_dsId IN NUMBER, l_sfId IN NUMBER, l_modelType IN VARCHAR2, l_targetId IN NUMBER) IS
894: SELECT count(*)
895: FROM AMS_DM_TARGETS_VL
896: WHERE DATA_SOURCE_ID = l_dsId
897: AND SOURCE_FIELD_ID = l_sfId
898: AND MODEL_TYPE = l_modelType
899: AND TARGET_ID <> l_targetId;

Line 1209: FROM ams_dm_targets_vl

1205: l_return_status VARCHAR2(1);
1206:
1207: CURSOR c_complete IS
1208: SELECT *
1209: FROM ams_dm_targets_vl
1210: WHERE target_id = p_dm_target_rec.target_id;
1211: l_dm_target_rec c_complete%ROWTYPE;
1212:
1213: BEGIN