[Home] [Help]
106: x_rowid VARCHAR2(30);
107:
108: CURSOR c_trig_seq IS
109: SELECT ams_triggers_s.NEXTVAL
110: FROM dual;
111:
112: CURSOR c_trig_exists(l_my_trig_id IN NUMBER) IS
113: SELECT 1
114: FROM dual
110: FROM dual;
111:
112: CURSOR c_trig_exists(l_my_trig_id IN NUMBER) IS
113: SELECT 1
114: FROM dual
115: WHERE EXISTS (SELECT 1
116: FROM ams_triggers
117: WHERE trigger_id = l_my_trig_id);
118:
1728: -- following 2 cursors c_trig_name , c_trig_name_updt added by soagrawa on 07-Aug-2001
1729: -- to replace call to Ams_Utility_Pvt.check_uniqueness
1730: CURSOR c_trig_name IS
1731: -- modified by dhsingh on 20.05.2004 for bug# 3631107
1732: -- SELECT 1 from dual
1733: -- WHERE EXISTS (SELECT *
1734: -- FROM AMS_TRIGGERS_VL
1735: -- WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name));
1736: SELECT 1 from dual
1732: -- SELECT 1 from dual
1733: -- WHERE EXISTS (SELECT *
1734: -- FROM AMS_TRIGGERS_VL
1735: -- WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name));
1736: SELECT 1 from dual
1737: WHERE EXISTS (SELECT *
1738: FROM AMS_TRIGGERS_TL
1739: WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name)
1740: AND language = USERENV('LANG'));
1741: -- end of modification by dhsingh
1742:
1743: CURSOR c_trig_name_updt IS
1744: -- modified by dhsingh on 20.05.2004 for bug# 3631107
1745: -- SELECT 1 from dual
1746: -- WHERE EXISTS (SELECT *
1747: -- FROM AMS_TRIGGERS_VL
1748: -- WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name)
1749: -- AND TRIGGER_ID <> p_trig_rec.trigger_id);
1746: -- WHERE EXISTS (SELECT *
1747: -- FROM AMS_TRIGGERS_VL
1748: -- WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name)
1749: -- AND TRIGGER_ID <> p_trig_rec.trigger_id);
1750: SELECT 1 from dual
1751: WHERE EXISTS (SELECT *
1752: FROM AMS_TRIGGERS_TL
1753: WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name)
1754: AND TRIGGER_ID <> p_trig_rec.trigger_id