APPS.AMS_CONTCAMPAIGN_PVT dependencies on AMS_TRIGGER_RESULTS

Line 685: SELECT ams_trigger_results_s.NEXTVAL

681: x_result_id OUT NOCOPY NUMBER,
682: x_return_status OUT NOCOPY VARCHAR2)
683: IS
684: CURSOR c_result_seq IS
685: SELECT ams_trigger_results_s.NEXTVAL
686: FROM dual ;
687:
688: CURSOR c_act_det IS
689: SELECT COUNT(1)

Line 690: FROM ams_trigger_results

686: FROM dual ;
687:
688: CURSOR c_act_det IS
689: SELECT COUNT(1)
690: FROM ams_trigger_results
691: WHERE trigger_result_id = p_process_id ;
692:
693:
694: l_result_id NUMBER;

Line 706: UPDATE ams_trigger_results

702: FETCH c_act_det INTO l_count ;
703: CLOSE c_act_det;
704:
705: IF l_count > 0 THEN
706: UPDATE ams_trigger_results
707: SET
708: trigger_finish_time = SYSDATE ,
709: object_version_number = object_version_number + 1,
710: actions_performed = p_action_taken

Line 735: INSERT INTO ams_trigger_results

731: -- colse cursor
732: close c_result_seq;
733:
734:
735: INSERT INTO ams_trigger_results
736: (trigger_result_id
737:
738: --Standard Who Columns
739: ,last_update_date