APPS.AMS_WFTRIG_PVT dependencies on AMS_TRIGGER_ACTIONS

Line 382: -- FROM ams_trigger_actions

378: -- As the trigger action table is no longer required.
379: -- DECLARE
380: -- CURSOR c_trigger_action(l_my_trigger_id NUMBER) IS
381: -- SELECT trigger_id
382: -- FROM ams_trigger_actions
383: -- WHERE trigger_id = l_my_trigger_id ;
384: -- l_dummy NUMBER;
385: -- BEGIN
386: UPDATE ams_triggers

Line 393: -- UPDATE ams_trigger_actions

389:
390: -- OPEN c_trigger_action(p_trigger_id);
391: -- FETCH c_trigger_action INTO l_dummy ;
392: -- IF c_trigger_action%FOUND THEN
393: -- UPDATE ams_trigger_actions
394: -- SET process_id = TO_NUMBER(itemkey)
395: -- WHERE trigger_id = p_trigger_id ;
396: -- END IF;
397: -- CLOSE c_trigger_action;

Line 2262: FROM ams_trigger_actions

2258: WHERE trigger_id = p_trig_id;
2259:
2260: CURSOR c_notify_action_det (p_trig_id NUMBER) IS
2261: SELECT *
2262: FROM ams_trigger_actions
2263: WHERE trigger_id = p_trig_id
2264: AND execute_action_type = 'NOTIFY';
2265:
2266: l_notify_action_det c_notify_action_det%ROWTYPE;

Line 3374: FROM ams_trigger_actions

3370: l_check_rec c_check_det%ROWTYPE;
3371:
3372: CURSOR c_notify_action_det IS
3373: SELECT *
3374: FROM ams_trigger_actions
3375: WHERE trigger_id = l_trigger_id
3376: AND execute_action_type = 'NOTIFY';
3377: l_notify_action_det c_notify_action_det%ROWTYPE;
3378: