eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_THLDCHK_PVT SQL Statements

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

Line: 89


      SELECT ams_trigger_checks_s.NEXTVAL
      FROM DUAL;

Line: 93


      SELECT  COUNT(*)
      FROM    ams_trigger_checks
      WHERE   trigger_check_id = l_my_chk_id;

Line: 166


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

Line: 187


   INSERT INTO ams_trigger_checks
      (trigger_check_id

      -- standard who columns
      ,last_update_date
      ,last_updated_by
      ,creation_date
      ,created_by
      ,last_update_login

      ,object_version_number
      ,trigger_id
      ,order_number
      ,chk1_type
      ,chk1_arc_source_code_from
      ,chk1_act_object_id
      ,chk1_source_code
      ,chk1_source_code_metric_id
      ,chk1_source_code_metric_type
      ,chk1_to_chk2_operator_type
      ,chk2_type
      ,chk2_value
      ,chk2_low_value
      ,chk2_high_value
      ,chk2_uom_code
      ,chk2_currency_code
      ,chk2_arc_source_code_from
      ,chk2_act_object_id
      ,chk2_source_code
      ,chk2_source_code_metric_id
      ,chk2_source_code_metric_type
      ,chk2_workbook_name
      ,chk2_workbook_owner
      ,chk2_worksheet_name

      )
   VALUES
      (
      l_thldchk_rec.trigger_check_id

      -- standard who columns
      ,sysdate
      ,FND_GLOBAL.User_Id
      ,sysdate
      ,FND_GLOBAL.User_Id
      ,FND_GLOBAL.Conc_Login_Id

      ,1      -- Object Version Number
      ,l_thldchk_rec.trigger_id
      ,1            -- Order Number
      ,l_thldchk_rec.chk1_type
      ,l_thldchk_rec.chk1_arc_source_code_from
      ,l_thldchk_rec.chk1_act_object_id
      ,l_thldchk_rec.chk1_source_code
      ,l_thldchk_rec.chk1_source_code_metric_id
      ,l_thldchk_rec.chk1_source_code_metric_type
      ,l_thldchk_rec.chk1_to_chk2_operator_type
      ,l_thldchk_rec.chk2_type
      ,l_thldchk_rec.chk2_value
      ,l_thldchk_rec.chk2_low_value
      ,l_thldchk_rec.chk2_high_value
      ,l_thldchk_rec.chk2_uom_code
      ,l_thldchk_rec.chk2_currency_code
      ,l_thldchk_rec.chk2_arc_source_code_from
      ,l_thldchk_rec.chk2_act_object_id
      ,l_thldchk_rec.chk2_source_code
      ,l_thldchk_rec.chk2_source_code_metric_id
      ,l_thldchk_rec.chk2_source_code_metric_type
      ,l_thldchk_rec.chk2_workbook_name
      ,l_thldchk_rec.chk2_workbook_owner
      ,l_thldchk_rec.chk2_worksheet_name

   );

Line: 350


PROCEDURE Delete_Thldchk
( 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_check_id          IN     NUMBER,
  p_object_version_number     IN     NUMBER
)
IS

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

Line: 372


   SAVEPOINT Delete_Thldchk_PVT;

Line: 412


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

Line: 421


   DELETE FROM ams_trigger_checks
   WHERE  trigger_check_id = p_trigger_check_id
   AND    object_version_number = p_object_version_number ;

Line: 459


      ROLLBACK TO Delete_Thldchk_PVT;

Line: 469


      ROLLBACK TO Delete_Thldchk_PVT;

Line: 479


      ROLLBACK TO Delete_Thldchk_PVT;

Line: 492


END Delete_Thldchk;

Line: 532


      SELECT trigger_check_id
      FROM   ams_trigger_checks
      WHERE  trigger_check_id = p_trigger_check_id
      AND      object_version_number = p_object_version_number
      FOR UPDATE of trigger_check_id NOWAIT;

Line: 684


PROCEDURE Update_Thldchk
( 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_thldchk_rec                IN     thldchk_rec_type
)
IS

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

Line: 711


   SAVEPOINT Update_Thldchk_PVT;

Line: 759


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

Line: 788


   UPDATE ams_trigger_checks
   SET
      last_update_date                = SYSDATE
      ,last_updated_by                =  FND_GLOBAL.User_Id
      ,last_update_login              = FND_GLOBAL.Conc_Login_Id

      ,object_version_number          = l_thldchk_rec.object_version_number + 1
      ,trigger_id                     = l_thldchk_rec.trigger_id
      ,order_number                   = l_thldchk_rec.order_number
      ,chk1_type                      = l_thldchk_rec.chk1_type
      ,chk1_arc_source_code_from      = l_thldchk_rec.chk1_arc_source_code_from
      ,chk1_act_object_id             = l_thldchk_rec.chk1_act_object_id
      ,chk1_source_code               = l_thldchk_rec.chk1_source_code
      ,chk1_source_code_metric_id     = l_thldchk_rec.chk1_source_code_metric_id
      ,chk1_source_code_metric_type   = l_thldchk_rec.chk1_source_code_metric_type
      ,chk1_to_chk2_operator_type     = l_thldchk_rec.chk1_to_chk2_operator_type
      ,chk2_type                      = l_thldchk_rec.chk2_type
      ,chk2_value                     = l_thldchk_rec.chk2_value
      ,chk2_low_value                 = l_thldchk_rec.chk2_low_value
      ,chk2_high_value                = l_thldchk_rec.chk2_high_value
      ,chk2_uom_code                  = l_thldchk_rec.chk2_uom_code
      ,chk2_currency_code             = l_thldchk_rec.chk2_currency_code
      ,chk2_source_code               = l_thldchk_rec.chk2_source_code
      ,chk2_arc_source_code_from      = l_thldchk_rec.chk2_arc_source_code_from
      ,chk2_act_object_id             = l_thldchk_rec.chk2_act_object_id
      ,chk2_source_code_metric_id     = l_thldchk_rec.chk2_source_code_metric_id
      ,chk2_source_code_metric_type   = l_thldchk_rec.chk2_source_code_metric_type
      ,chk2_workbook_name             = l_thldchk_rec.chk2_workbook_name
      ,chk2_workbook_owner            = l_thldchk_rec.chk2_workbook_owner
      ,chk2_worksheet_name            = l_thldchk_rec.chk2_worksheet_name
   WHERE   trigger_check_id = l_thldchk_Rec.trigger_check_id
   AND     object_version_number = l_thldchk_Rec.object_version_number;

Line: 861


      ROLLBACK TO Update_Thldchk_PVT;

Line: 871


      ROLLBACK TO Update_Thldchk_PVT;

Line: 881


      ROLLBACK TO Update_Thldchk_PVT;

Line: 894


END Update_Thldchk;

Line: 1438


   SELECT act.metric_uom_code metric_uom_code,
          act.transaction_currency_code transaction_currency_code,
          met.uom_type
   FROM   ams_act_metrics_all act,ams_metrics_all_b met
   WHERE  act.activity_metric_id =  l_act_met_id
   AND    act.metric_id = met.metric_id ;

Line: 1959


    x_thldchk_rec.last_update_date              := FND_API.G_MISS_DATE ;

Line: 1960


    x_thldchk_rec.last_updated_by               := FND_API.G_MISS_NUM ;

Line: 1963


    x_thldchk_rec.last_update_login             := FND_API.G_MISS_NUM ;

Line: 2014


   SELECT *
     FROM ams_trigger_checks
    WHERE trigger_check_id = p_thldchk_rec.trigger_check_id;