APPS.AMS_TRIGGER_PVT SQL Statements

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

Line: 108

   SELECT start_date_time
     FROM ams_triggers
    WHERE trigger_id = p_trigger_id;

Line: 161

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

Line: 352

   UPDATE ams_triggers
      SET process_id = to_number(l_new_item_key)
    WHERE trigger_id = x_trigger_id;

Line: 443

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     Ams_Trig_pvt.trig_rec_type,
  p_thldchk_rec         IN     Ams_Thldchk_pvt.thldchk_rec_type DEFAULT NULL,
  p_thldact_rec         IN     Ams_Thldact_pvt.thldact_rec_type
--  p_updt_type           IN     VARCHAR2

) IS

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

Line: 470

   SELECT process_id
   FROM ams_triggers
   WHERE trigger_id = l_my_trig_id;

Line: 475

   SELECT notify_flag, EXECUTE_SCHEDULE_FLAG
   FROM ams_triggers
   WHERE trigger_id = l_my_trig_id;

Line: 480

   SELECT trigger_action_id, object_version_number
   FROM ams_trigger_Actions
   WHERE trigger_id = p_my_trig_id
   AND   execute_Action_type = p_action_type;

Line: 498

   SAVEPOINT Update_Trig_PVT;

Line: 536

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

Line: 542

   AMS_TRIG_PVT.Update_Trigger
      ( p_api_version         => l_api_version,
        p_init_msg_list       => p_init_msg_list,
        p_commit              => FND_API.G_FALSE,
        p_validation_level    => p_validation_level,
        x_return_status       => l_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_trig_rec            => p_trig_rec
          ) ;

Line: 573

      AMS_THLDCHK_PVT.Update_Thldchk
         ( p_api_version         => l_api_version,
         p_init_msg_list       => FND_API.G_FALSE,
           p_commit              => FND_API.G_FALSE,
           p_validation_level    => p_validation_level,
           x_return_status       => l_return_status,
           x_msg_count           => x_msg_count,
           x_msg_data            => x_msg_data,
         p_thldchk_rec         => l_thldchk_rec
               ) ;

Line: 695

      AMS_THLDACT_PVT.Update_ThldAct
                 ( p_api_version         => l_api_version,
                   p_init_msg_list       => FND_API.G_FALSE,
                   p_commit              => FND_API.G_FALSE,
                   p_validation_level    => p_validation_level,
                   x_return_status       => l_return_status,
                   x_msg_count           => x_msg_count,
                   x_msg_data            => x_msg_data,
                   p_thldact_rec         => l_thldact_rec
                ) ;

Line: 761

      AMS_THLDACT_PVT.Delete_ThldAct
                 ( p_api_version         => l_api_version,
                   p_init_msg_list       => FND_API.G_FALSE,
                   p_commit              => FND_API.G_FALSE,
                   x_return_status       => l_return_status,
                   x_msg_count           => x_msg_count,
                   x_msg_data            => x_msg_data,
                   p_trigger_action_id   => l_trig_action_id,
                   p_object_version_number => l_object_version_number
                ) ;

Line: 806

      AMS_THLDACT_PVT.Update_ThldAct
                 ( p_api_version         => l_api_version,
                   p_init_msg_list       => FND_API.G_FALSE,
                   p_commit              => FND_API.G_FALSE,
                   p_validation_level    => p_validation_level,
                   x_return_status       => l_return_status,
                   x_msg_count           => x_msg_count,
                   x_msg_data            => x_msg_data,
                   p_thldact_rec         => l_thldact_rec
                ) ;

Line: 873

      AMS_THLDACT_PVT.Delete_ThldAct
                 ( p_api_version         => l_api_version,
                   p_init_msg_list       => FND_API.G_FALSE,
                   p_commit              => FND_API.G_FALSE,
                   x_return_status       => l_return_status,
                   x_msg_count           => x_msg_count,
                   x_msg_data            => x_msg_data,
                   p_trigger_action_id   => l_trig_action_id,
                   p_object_version_number => l_object_version_number
                ) ;

Line: 894

   /* ------------------- update trigger now ---------------------- */
   -- moved to later by soagrawa 30-apr-2003

   IF (AMS_DEBUG_HIGH_ON) THEN
   AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');

Line: 904

   AMS_TRIG_PVT.Update_Trigger
      ( p_api_version         => l_api_version,
        p_init_msg_list       => FND_API.G_FALSE,
        p_commit              => FND_API.G_FALSE,
        p_validation_level    => p_validation_level,

        x_return_status       => l_return_status,
        x_msg_count           => x_msg_count,
        x_msg_data            => x_msg_data,
        p_trig_rec            => p_trig_rec
          ) ;

Line: 964

      ROLLBACK TO Update_Trig_PVT;

Line: 973

      ROLLBACK TO Update_Trig_PVT;

Line: 982

      ROLLBACK TO Update_Trig_PVT;

Line: 993

END Update_Trigger;

Line: 1035

   SELECT start_date_time,
          timezone_id,
          user_start_date_time
     FROM ams_triggers
    WHERE trigger_id = p_trig_id;

Line: 1132

   UPDATE ams_triggers
      SET process_id = to_number(l_new_item_key)
          , start_date_time = l_st_dt
          , user_start_date_time = l_user_st_dt
    WHERE trigger_id = p_trigger_id;