APPS.AMS_TRIG_PVT dependencies on AMS_TRIGGERS_VL

Line 1734: -- FROM AMS_TRIGGERS_VL

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
1737: WHERE EXISTS (SELECT *
1738: FROM AMS_TRIGGERS_TL

Line 1747: -- FROM AMS_TRIGGERS_VL

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);
1750: SELECT 1 from dual
1751: WHERE EXISTS (SELECT *

Line 1797: p_table_name => 'AMS_TRIGGERS_VL',

1793: l_where_clause := l_where_clause || ' AND TRIGGER_ID <> ' || p_trig_rec.trigger_id;
1794: END IF;
1795:
1796: IF AMS_Utility_PVT.Check_Uniqueness(
1797: p_table_name => 'AMS_TRIGGERS_VL',
1798: p_where_clause => l_where_clause
1799: ) = FND_API.g_false
1800: THEN
1801: AMS_UTILITY_PVT.Error_Message('AMS_TRIG_DUP_TRIG_NAME');

Line 2399: FROM ams_triggers_vl

2395: IS
2396:
2397: CURSOR c_trig IS
2398: SELECT *
2399: FROM ams_triggers_vl
2400: WHERE trigger_id = p_trig_rec.trigger_id;
2401:
2402: l_trig_rec c_trig%ROWTYPE;
2403: