APPS.AMS_CONTCAMPAIGN_PVT dependencies on AMS_TRIGGERS

Line 784: update ams_triggers

780: END IF;
781:
782: IF p_process_success = 'Y' THEN
783: IF p_check_met <> 'Y' THEN
784: update ams_triggers
785: set TRIGGERED_STATUS = 'DORMANT'
786: where trigger_id = p_result_for_id;
787: ELSE
788: update ams_triggers

Line 788: update ams_triggers

784: update ams_triggers
785: set TRIGGERED_STATUS = 'DORMANT'
786: where trigger_id = p_result_for_id;
787: ELSE
788: update ams_triggers
789: set TRIGGERED_STATUS = 'TRIGGERED'
790: where trigger_id = p_result_for_id;
791: END IF;
792: END IF;

Line 806: -- will calculate the next schedule run time. Will Update the AMS_TRIGGERS

802: -- Schedule_Next_Trigger_Run
803: --
804: -- PURPOSE
805: -- This Procedure will mark the Last run time fot the trigger and
806: -- will calculate the next schedule run time. Will Update the AMS_TRIGGERS
807: -- table with the new values for Last run time, next schedule run time
808: --
809: -- NOTES
810: --

Line 835: l_trigger_id ams_triggers.trigger_id%type := p_trigger_id ;

831: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
832:
833: l_return_status VARCHAR2(1);
834: l_sch_date DATE;
835: l_trigger_id ams_triggers.trigger_id%type := p_trigger_id ;
836:
837: l_user_last_run_date_time DATE ;
838: l_user_next_run_date_time DATE ;
839:

Line 850: FROM ams_triggers

846: l_str VARCHAR2(30) ;
847:
848: CURSOR c_triggers(l_my_trigger_id NUMBER) IS
849: SELECT *
850: FROM ams_triggers
851: WHERE trigger_id = l_my_trigger_id ;
852: l_trigger c_triggers%rowtype ;
853:
854: BEGIN

Line 899: -- First Mark the Last Run Date Time (Update AMS_TRIGGERS with this date

895: CLOSE c_triggers ;
896:
897:
898:
899: -- First Mark the Last Run Date Time (Update AMS_TRIGGERS with this date
900: -- at the end )
901: IF l_trigger.last_run_date_time IS NULL THEN
902: l_cur_date := l_trigger.start_date_time ;
903: l_last_run_date := l_trigger.start_date_time ;

Line 999: UPDATE ams_triggers

995: AMS_Utility_PVT.debug_message(l_full_name||': Update Schedule Date');
996: END IF;
997:
998:
999: UPDATE ams_triggers
1000: SET last_run_date_time = l_cur_date,
1001: next_run_date_time = l_sch_date,
1002: user_last_run_date_time = l_user_last_run_date_time,
1003: user_next_run_date_time = l_user_next_run_date_time