APPS.AMS_TRIG_PVT dependencies on AMS_TRIGGERS_TL

Line 20: -- 08-jul-2003 cgoyal Modified data insertion in ams_triggers_tl for MLS

16: -- with a manual check)
17: -- 24-sep-2001 soagrawa Removed security group id from everywhere
18: -- 10-Dec-2002 ptendulk Modified calculate_system_time api to combine two parameters into one
19: -- 22/apr/03 cgoyal added notify_flag, EXECUTE_SCHEDULE_FLAG for 11.5.8 backport
20: -- 08-jul-2003 cgoyal Modified data insertion in ams_triggers_tl for MLS
21: -- 30-jul-2003 anchaudh modified comparison operator to fix P1 bug# 3064909 in check_trig_record
22: -- 21-aug-2003 soagrawa Fixed bug 3108929 in check_trig_record
23: -- 27-aug-2003 soagrawa Fixed bug 3115141 in check_trig_record
24: -- 20-May-2004 dhsingh Modified Check_Trig_Uk_Items and c_trig_name_updt for better performance

Line 337: INSERT INTO ams_triggers_tl

333: ,l_trig_rec.USAGE--anchaudh added for monitors,R12.
334: );
335: --cgoyal commented on 08/03 for MLS
336: /*
337: INSERT INTO ams_triggers_tl
338: (trigger_id
339: ,language
340: ,last_update_date
341: ,last_upated_by

Line 366: INSERT INTO ams_triggers_tl

362: -- removed by soagrawa on 24-sep-2001
363: -- ,l_trig_rec.security_group_id
364: ) ;
365: */
366: INSERT INTO ams_triggers_tl
367: (trigger_id
368: ,language
369: ,last_update_date
370: ,last_upated_by

Line 395: FROM ams_triggers_tl t

391: FROM fnd_languages l
392: WHERE l.installed_flag IN ('I','B')
393: AND NOT EXISTS(
394: SELECT NULL
395: FROM ams_triggers_tl t
396: WHERE t.trigger_id = l_trig_rec.trigger_id
397: AND t.language = l.language_code ) ;
398:
399: AMS_Utility_PVT.debug_message(l_full_name ||': inserted in tl table');

Line 678: DELETE FROM AMS_triggers_tl

674: );
675:
676: IF (l_trig_rec.process_id IS NULL OR l_trig_rec.process_id = '') THEN -- if trigger has not started yet
677:
678: DELETE FROM AMS_triggers_tl
679: WHERE trigger_id = p_trigger_id ;
680: IF (SQL%NOTFOUND) THEN
681: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 838: FROM ams_triggers_tl

834: FOR UPDATE of trigger_id NOWAIT;
835:
836: CURSOR c_trig_tl IS
837: SELECT trigger_id
838: FROM ams_triggers_tl
839: WHERE trigger_id = p_trigger_id
840: AND USERENV('LANG') IN (language, source_lang)
841: FOR UPDATE NOWAIT;
842:

Line 1190: UPDATE ams_triggers_tl

1186: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
1187: RAISE FND_API.g_exc_error;
1188: END IF;
1189:
1190: UPDATE ams_triggers_tl
1191: SET
1192: last_update_date = SYSDATE,
1193: last_upated_by = FND_GLOBAL.user_id,
1194: creation_date = SYSDATE,

Line 1738: FROM AMS_TRIGGERS_TL

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:

Line 1752: FROM AMS_TRIGGERS_TL

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
1755: AND language = USERENV('LANG'));
1756: -- end of modification by dhsingh