APPS.AMS_TRIGGER_PVT dependencies on AMS_TRIGGERS

Line 45: -- This procedure is to create a row in ams_triggers,ams_trigger_checks,ams_trigger_actions

41: -- NAME
42: -- Create_Trigger
43: --
44: -- PURPOSE
45: -- This procedure is to create a row in ams_triggers,ams_trigger_checks,ams_trigger_actions
46: -- table that satisfy caller needs
47: --
48: -- NOTES
49: -- As soon as the Trigger is created Start the Workflow Process

Line 109: FROM ams_triggers

105:
106: -- soagrawa added on 09-jul-2003 for bug 3043277
107: CURSOR c_st_dt (p_trigger_id NUMBER) IS
108: SELECT start_date_time
109: FROM ams_triggers
110: WHERE trigger_id = p_trigger_id;
111:
112: l_st_dt DATE;
113:

Line 352: UPDATE ams_triggers

348: p_msg_data => 'Create_Trigger : raised with send date '||to_char(l_st_dt,'DD-MM-YYYY HH:MI:SS AM'),
349: p_msg_type => 'DEBUG'
350: );
351:
352: UPDATE ams_triggers
353: SET process_id = to_number(l_new_item_key)
354: WHERE trigger_id = x_trigger_id;
355:
356: srivikri - end comment*/

Line 426: -- This procedure is to update a ams_triggers,ams_trigger_checks,ams_trigger_actions table

422: -- NAME
423: -- Update_Trigger
424: --
425: -- PURPOSE
426: -- This procedure is to update a ams_triggers,ams_trigger_checks,ams_trigger_actions table
427: -- that satisfy caller needs . It will also Call the Cancel Workflow Process
428: --
429: -- NOTES
430: -- As soon as the Trigger is modied Abort the Workflow Process and Submit the new one

Line 471: FROM ams_triggers

467: l_trigger_process_id NUMBER ;
468:
469: CURSOR c_trig_process_id (l_my_trig_id IN number) IS
470: SELECT process_id
471: FROM ams_triggers
472: WHERE trigger_id = l_my_trig_id;
473:
474: CURSOR c_trig_actions_det (l_my_trig_id IN number) IS
475: SELECT notify_flag, EXECUTE_SCHEDULE_FLAG

Line 476: FROM ams_triggers

472: WHERE trigger_id = l_my_trig_id;
473:
474: CURSOR c_trig_actions_det (l_my_trig_id IN number) IS
475: SELECT notify_flag, EXECUTE_SCHEDULE_FLAG
476: FROM ams_triggers
477: WHERE trigger_id = l_my_trig_id;
478:
479: CURSOR c_actions_det (p_my_trig_id IN number, p_action_type IN VARCHAR2) IS
480: SELECT trigger_action_id, object_version_number

Line 1038: FROM ams_triggers

1034: CURSOR c_st_dt (p_trig_id NUMBER) IS
1035: SELECT start_date_time,
1036: timezone_id,
1037: user_start_date_time
1038: FROM ams_triggers
1039: WHERE trigger_id = p_trig_id;
1040:
1041: l_st_dt DATE;
1042: l_timezone_id NUMBER;

Line 1132: UPDATE ams_triggers

1128: p_msg_data => 'Activate_Trigger : raised with send date '||to_char(l_st_dt,'DD-MM-YYYY HH:MI:SS AM'),
1129: p_msg_type => 'DEBUG'
1130: );
1131:
1132: UPDATE ams_triggers
1133: SET process_id = to_number(l_new_item_key)
1134: , start_date_time = l_st_dt
1135: , user_start_date_time = l_user_st_dt
1136: WHERE trigger_id = p_trigger_id;