APPS.AMS_TRIG_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 109

   SELECT ams_triggers_s.NEXTVAL
   FROM   dual;

Line: 113

   SELECT 1
     FROM dual
    WHERE EXISTS (SELECT 1
   FROM   ams_triggers
                    WHERE trigger_id = l_my_trig_id);

Line: 120

   SELECT COUNT(1)
   FROM   ams_triggers
   WHERE  trigger_id = l_my_trig_id;

Line: 223

        AMS_Utility_PVT.debug_message(l_full_name ||': insert Trigger');

Line: 240

         AMS_Utility_PVT.debug_message(l_full_name ||': insert Trigger id is '||l_trig_rec.trigger_id);

Line: 246

         AMS_Utility_PVT.debug_message(l_full_name ||': insert Trigger count is '||l_trig_count);

Line: 253

   INSERT INTO ams_triggers
            (trigger_id
            -- standard who columns
            ,last_update_date
            ,last_updated_by
            ,creation_date
            ,created_by
            ,last_update_login
            ,object_version_number
            ,process_id
            ,trigger_created_for_id
            ,arc_trigger_created_for
            ,triggering_type
            ,trigger_name
            ,view_application_id
            ,timezone_id
            ,user_start_date_time
            ,start_date_time
            ,user_last_run_date_time
            ,last_run_date_time
            ,user_next_run_date_time
            ,next_run_date_time
            ,user_repeat_daily_start_time
            ,repeat_daily_start_time
            ,user_repeat_daily_end_time
            ,repeat_daily_end_time
            ,repeat_frequency_type
            ,repeat_every_x_frequency
            ,user_repeat_stop_date_time
            ,repeat_stop_date_time
            ,metrics_refresh_type
            ,description
            -- removed by soagrawa on 24-sep-2001
            -- ,security_group_id
	    --added by cgoyal for 11.5.8 backport
	    ,notify_flag
	    ,execute_schedule_flag
	    ,TRIGGERED_STATUS --anchaudh added for monitors,R12.
            ,USAGE --anchaudh added for monitors,R12.
   )
   VALUES
   (
            l_trig_rec.trigger_id
   -- standard who columns
            ,SYSDATE
            ,FND_GLOBAL.User_Id
            ,SYSDATE
            ,FND_GLOBAL.User_Id
            ,FND_GLOBAL.Conc_Login_Id

            ,1                                     -- Object Version Number
            ,l_trig_rec.process_id
            ,l_trig_rec.trigger_created_for_id
            ,l_trig_rec.arc_trigger_created_for
            ,l_trig_rec.triggering_type
            ,NULL                                  -- As trigger name will be stored in the tl table
            ,l_trig_rec.view_application_id
            ,l_trig_rec.timezone_id
            ,l_trig_rec.user_start_date_time
            ,l_trig_rec.start_date_time
            ,l_trig_rec.user_last_run_date_time
            ,l_trig_rec.last_run_date_time
            ,l_trig_rec.user_next_run_date_time
            ,l_trig_rec.next_run_date_time
            ,l_trig_rec.user_repeat_daily_start_time
            ,l_trig_rec.repeat_daily_start_time
            ,l_trig_rec.user_repeat_daily_end_time
            ,l_trig_rec.repeat_daily_end_time
            ,l_trig_rec.repeat_frequency_type
            ,l_trig_rec.repeat_every_x_frequency
            ,l_trig_rec.user_repeat_stop_date_time
            ,l_trig_rec.repeat_stop_date_time
            ,l_trig_rec.metrics_refresh_type
            ,NULL                                   -- As Description will be stored in tl table.
            -- removed by soagrawa on 24-sep-2001
            -- ,l_trig_rec.security_group_id
            --added by cgoyal for 11.5.8 backport
            ,nvl(l_trig_rec.notify_flag,'N')
            ,nvl(l_trig_rec.execute_schedule_flag,'N')
	    ,l_trig_rec.TRIGGERED_STATUS--anchaudh added for monitors,R12.
	    ,l_trig_rec.USAGE--anchaudh added for monitors,R12.
              );

Line: 337

   INSERT INTO ams_triggers_tl
      (trigger_id
      ,language
      ,last_update_date
      ,last_upated_by
      ,creation_date
      ,created_by
      ,last_update_login
      ,source_lang
      ,trigger_name
      ,description
      -- removed by soagrawa on 24-sep-2001
      -- ,security_group_id
      )
   VALUES
      (l_trig_rec.trigger_id
      ,USERENV('LANG')
      ,SYSDATE
      ,FND_GLOBAL.User_Id
      ,SYSDATE
      ,FND_GLOBAL.User_Id
      ,FND_GLOBAL.Conc_Login_Id
      ,USERENV('LANG')
      ,l_trig_rec.trigger_name
      ,l_trig_rec.description
      -- removed by soagrawa on 24-sep-2001
      -- ,l_trig_rec.security_group_id
      ) ;

Line: 366

   INSERT INTO ams_triggers_tl
      (trigger_id
      ,language
      ,last_update_date
      ,last_upated_by
      ,creation_date
      ,created_by
      ,last_update_login
      ,source_lang
      ,trigger_name
      ,description
      -- removed by soagrawa on 24-sep-2001
      -- ,security_group_id
      )
   SELECT
           l_trig_rec.trigger_id,
           l.language_code,
           SYSDATE,
           FND_GLOBAL.user_id,
           SYSDATE,
           FND_GLOBAL.user_id,
           FND_GLOBAL.conc_login_id,
           USERENV('LANG'),
           l_trig_rec.trigger_name,
           l_trig_rec.description
   FROM    fnd_languages l
   WHERE   l.installed_flag IN ('I','B')
   AND     NOT EXISTS(
                      SELECT NULL
                      FROM   ams_triggers_tl t
                      WHERE  t.trigger_id = l_trig_rec.trigger_id
                      AND    t.language = l.language_code ) ;

Line: 399

    AMS_Utility_PVT.debug_message(l_full_name ||': inserted in tl table');

Line: 543

PROCEDURE Delete_Trigger
( p_api_version               IN     NUMBER,
  p_init_msg_list             IN     VARCHAR2    := FND_API.G_FALSE,
  p_commit                    IN     VARCHAR2    := FND_API.G_FALSE,

  x_return_status             OUT NOCOPY    VARCHAR2,
  x_msg_count                 OUT NOCOPY    NUMBER,
  x_msg_data                  OUT NOCOPY    VARCHAR2,

  p_trigger_id                IN     NUMBER,
  p_object_version_number     IN     NUMBER
) IS

  l_api_name       CONSTANT VARCHAR2(30)  := 'Delete_Trigger';

Line: 562

  SELECT repeat_frequency_type,
         last_run_date_time,
         arc_trigger_created_for,
         trigger_created_for_id,
         timezone_id,
         start_date_time,
         process_id
  FROM   ams_triggers
  WHERE  trigger_id = p_trigger_id ;

Line: 573

  SELECT count(*)
  FROM   ams_campaign_schedules_b
  WHERE  trigger_id = p_trigger_id;

Line: 588

   SAVEPOINT Delete_Trig_PVT;

Line: 628

   AMS_Utility_PVT.debug_message(l_full_name ||': delete');

Line: 645

   SELECT count(*)
   INTO l_assoc_sch -- number of schedules associated with this triggerId
   FROM   ams_campaign_schedules_b
   WHERE  trigger_id = p_trigger_id;

Line: 678

            DELETE FROM AMS_triggers_tl
            WHERE trigger_id = p_trigger_id ;

Line: 688

                  p_msg_data        => 'going to delete trigger_id:'||p_trigger_id,
                  p_msg_type        => 'DEBUG'
                  );

Line: 692

            DELETE FROM ams_triggers
            WHERE  trigger_id = p_trigger_id
            AND    object_version_number = p_object_version_number ;

Line: 701

               DELETE FROM ams_trigger_checks
               WHERE       trigger_id = p_trigger_id ;

Line: 704

               DELETE FROM ams_trigger_actions
               WHERE       trigger_id = p_trigger_id ;

Line: 753

      ROLLBACK TO Delete_Trig_PVT;

Line: 765

      ROLLBACK TO Delete_Trig_PVT;

Line: 777

      ROLLBACK TO Delete_Trig_PVT;

Line: 791

END Delete_Trigger;

Line: 830

      SELECT trigger_id
      FROM   ams_triggers
      WHERE  trigger_id = p_trigger_id
      AND    object_version_number = p_object_version_number
      FOR UPDATE of trigger_id NOWAIT;

Line: 837

   SELECT trigger_id
     FROM ams_triggers_tl
    WHERE trigger_id = p_trigger_id
      AND USERENV('LANG') IN (language, source_lang)
   FOR UPDATE NOWAIT;

Line: 994

PROCEDURE Update_Trigger
( p_api_version         IN     NUMBER,
  p_init_msg_list       IN     VARCHAR2    := FND_API.G_FALSE,
  p_commit              IN     VARCHAR2    := FND_API.G_FALSE,
  p_validation_level    IN     NUMBER      := FND_API.G_VALID_LEVEL_FULL,

  x_return_status       OUT NOCOPY    VARCHAR2,
  x_msg_count           OUT NOCOPY    NUMBER,
  x_msg_data            OUT NOCOPY    VARCHAR2,

  p_trig_rec            IN     trig_rec_type
) IS

   l_api_name           CONSTANT VARCHAR2(30)  := 'Update_Trigger';

Line: 1017

   SELECT repeat_frequency_type,last_run_date_time,
          repeat_stop_date_time
   FROM   ams_triggers
   WHERE  trigger_id = p_trig_rec.trigger_id ;

Line: 1028

   SAVEPOINT Update_Trig_PVT;

Line: 1076

         p_validation_mode => JTF_PLSQL_API.g_update,
         x_return_status   => l_return_status
      );

Line: 1143

   AMS_Utility_PVT.debug_message(l_full_name ||': update');

Line: 1146

   UPDATE ams_triggers
   SET
      last_update_date                = SYSDATE
      ,last_updated_by                = FND_GLOBAL.user_id
      ,last_update_login              = FND_GLOBAL.conc_login_id
      ,object_version_number          = l_trig_rec.object_version_number + 1
      ,process_id                     = l_trig_rec.process_id
      ,trigger_created_for_id         = l_trig_rec.trigger_created_for_id
      ,arc_trigger_created_for        = l_trig_rec.arc_trigger_created_for
      ,triggering_type                = l_trig_rec.triggering_type
      ,trigger_name                   = NULL          -- As Name will be stored in tl table.
      ,view_application_id            = l_trig_rec.view_application_id
      ,timezone_id                    = l_trig_rec.timezone_id
      ,user_start_date_time           = l_trig_rec.user_start_date_time
      ,start_date_time                = l_trig_rec.start_date_time
      ,user_last_run_date_time        = l_trig_rec.user_last_run_date_time
      ,last_run_date_time             = l_trig_rec.last_run_date_time
      ,user_next_run_date_time        = l_trig_rec.user_next_run_date_time
      ,next_run_date_time             = l_trig_rec.next_run_date_time
      ,user_repeat_daily_start_time   = l_trig_rec.user_repeat_daily_start_time
      ,repeat_daily_start_time        = l_trig_rec.repeat_daily_start_time
      ,user_repeat_daily_end_time     = l_trig_rec.user_repeat_daily_end_time
      ,repeat_daily_end_time          = l_trig_rec.repeat_daily_end_time
      ,repeat_frequency_type          = l_trig_rec.repeat_frequency_type
      ,repeat_every_x_frequency       = l_trig_rec.repeat_every_x_frequency
      ,user_repeat_stop_date_time     = l_trig_rec.user_repeat_stop_date_time
      ,repeat_stop_date_time          = l_trig_rec.repeat_stop_date_time
      ,metrics_refresh_type           = l_trig_rec.metrics_refresh_type
      ,description                    = null            -- As description will be stored in tl table.
      -- removed by soagrawa on 24-sep-2001
      -- ,security_group_id              = l_trig_rec.security_group_id
      ,notify_flag                    = l_trig_rec.notify_flag
      ,execute_schedule_flag          = l_trig_rec.execute_schedule_flag
      ,TRIGGERED_STATUS    = l_trig_rec.TRIGGERED_STATUS--anchaudh added for monitors,R12
      ,USAGE               = l_trig_rec.USAGE--anchaudh added for monitors,R12

   WHERE trigger_id = l_trig_rec.trigger_id
   AND   object_version_number = l_trig_rec.object_version_number ;

Line: 1190

   UPDATE ams_triggers_tl
   SET
      last_update_date                = SYSDATE,
      last_upated_by                  = FND_GLOBAL.user_id,
      creation_date                   = SYSDATE,
      created_by                      = FND_GLOBAL.user_id,
      last_update_login               = FND_GLOBAL.user_id,
      source_lang                     = USERENV('LANG'),
      trigger_name                    = l_trig_rec.trigger_name,
      description                     = l_trig_rec.description
      -- removed by soagrawa on 24-sep-2001
      -- security_group_id               = l_trig_rec.security_group_id
   WHERE trigger_id = l_trig_rec.trigger_id ;

Line: 1235

      ROLLBACK TO Update_Trig_PVT;

Line: 1246

      ROLLBACK TO Update_Trig_PVT;

Line: 1257

      ROLLBACK TO Update_Trig_PVT;

Line: 1270

END Update_Trigger;

Line: 1736

	SELECT 1 from dual
	WHERE EXISTS (SELECT *
		FROM  AMS_TRIGGERS_TL
		WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name)
		AND   language = USERENV('LANG'));

Line: 1750

	SELECT 1 from dual
	WHERE EXISTS (SELECT *
		FROM  AMS_TRIGGERS_TL
		WHERE UPPER(TRIGGER_NAME) = UPPER(p_trig_rec.trigger_name)
		AND   TRIGGER_ID <> p_trig_rec.trigger_id
		AND   language = USERENV('LANG'));

Line: 1807

   IF p_validation_mode = JTF_PLSQL_API.g_update THEN
         OPEN c_trig_name_updt;

Line: 2340

  x_trig_rec.last_update_date               :=   FND_API.G_MISS_DATE ;

Line: 2341

  x_trig_rec.last_updated_by                :=   FND_API.G_MISS_NUM  ;

Line: 2344

  x_trig_rec.last_update_login              :=   FND_API.G_MISS_NUM  ;

Line: 2398

   SELECT *
     FROM ams_triggers_vl
    WHERE trigger_id = p_trig_rec.trigger_id;