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_THLDACT_PVT SQL Statements

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

Line: 81


       SELECT ams_trigger_actions_s.NEXTVAL
       FROM DUAL;

Line: 85


       SELECT  COUNT(*)
       FROM    ams_trigger_actions
            WHERE     trigger_action_id = l_my_act_id;

Line: 172


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

Line: 234


   INSERT INTO ams_trigger_actions
   (trigger_action_id
   -- standard who columns
    ,last_update_date
    ,last_updated_by
    ,creation_date
    ,created_by
   ,last_update_login
   ,object_version_number
   ,process_id
   ,trigger_id
   ,order_number
   ,notify_flag
   --,action_notif_user_id
   ,generate_list_flag
   ,action_need_approval_flag
   ,action_approver_user_id
   ,execute_action_type
        ,list_header_id
   ,list_connected_to_id
   ,arc_list_connected_to
        ,deliverable_id
        ,activity_offer_id
        ,dscript_name
   ,program_to_call
        ,cover_letter_id
        ,mail_subject
        ,mail_sender_name
        ,from_fax_no
        , action_for_id
   )
   VALUES
   (
   l_thldact_rec.trigger_action_id
   -- standard who columns
   ,sysdate
   ,FND_GLOBAL.User_Id
   ,sysdate
   ,FND_GLOBAL.User_Id
   ,FND_GLOBAL.Conc_Login_Id
   -- end standard who columns
   ,1                   -- Object Version Number
   ,l_thldact_rec.process_id          --??
   ,l_thldact_rec.trigger_id
   ,l_thldact_rec.order_number          --??
   ,nvl(l_thldact_rec.notify_flag,'N')              -- cgoyal changed default value to 'N'
   --,l_thldact_rec.action_notif_user_id
   ,nvl(l_thldact_rec.generate_list_flag,'N')
   ,nvl(l_thldact_rec.action_need_approval_flag,'N')
   ,l_thldact_rec.action_approver_user_id       --??
   ,l_thldact_rec.execute_action_type       --??
   ,l_thldact_rec.list_header_id          --??
   ,l_thldact_rec.list_connected_to_id       --??
   ,l_thldact_rec.arc_list_connected_to       --??
        ,l_thldact_rec.deliverable_id          --??
        ,l_thldact_rec.activity_offer_id       --??
        ,l_thldact_rec.dscript_name          --??
   ,l_thldact_rec.program_to_call          --??
   ,l_thldact_rec.cover_letter_id          --??
   ,l_thldact_rec.mail_subject          --??
   ,l_thldact_rec.mail_sender_name          --??
   ,l_thldact_rec.from_fax_no          --??
   ,l_thldact_rec.action_for_id
   );

Line: 375


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

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

Line: 396


  SAVEPOINT Delete_Thldact_PVT;

Line: 436


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

Line: 445


  DELETE FROM ams_trigger_actions
  WHERE  trigger_action_id = p_trigger_action_id
  AND     object_version_number = p_object_version_number ;

Line: 484


           ROLLBACK TO Delete_Thldact_PVT;

Line: 494


           ROLLBACK TO Delete_Thldact_PVT;

Line: 504


           ROLLBACK TO Delete_Thldact_PVT;

Line: 517


END Delete_Thldact;

Line: 556


       SELECT trigger_action_id
      FROM   ams_trigger_actions
       WHERE  trigger_action_id = p_trigger_action_id
      AND      object_version_number = p_object_version_number
      FOR UPDATE of trigger_action_id NOWAIT;

Line: 706


PROCEDURE Update_Thldact
( 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_thldact_rec                IN     thldact_rec_type
) IS

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

Line: 732


   SAVEPOINT Update_Thldact_PVT;

Line: 780


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

Line: 809


   UPDATE ams_trigger_actions
   SET   last_update_date           = sysdate
              ,last_updated_by             = FND_GLOBAL.User_Id
              ,last_update_login         = FND_GLOBAL.Conc_Login_Id
              ,object_version_number     = l_thldact_rec.object_version_number + 1
              ,process_id                = l_thldact_rec.process_id
              ,trigger_id                = l_thldact_rec.trigger_id
              ,order_number              = l_thldact_rec.order_number
              ,notify_flag               = nvl(l_thldact_rec.notify_flag,'N')               --cgoyal modified the default value of notify_flag as 'N' for 11.5.8 backport
         --,ACTION_NOTIF_USER_ID      = l_thldact_rec.ACTION_NOTIF_USER_ID          --cgoyal added column for 11.5.8 backport
              ,generate_list_flag        = nvl(l_thldact_rec.generate_list_flag,'N')
              ,action_need_approval_flag = nvl(l_thldact_rec.action_need_approval_flag,'N')
              ,action_approver_user_id    = l_thldact_rec.action_approver_user_id
              ,execute_action_type       = l_thldact_rec.execute_action_type
              ,list_header_id            = l_thldact_rec.list_header_id
              ,list_connected_to_id      = l_thldact_rec.list_connected_to_id
              ,arc_list_connected_to     = l_thldact_rec.arc_list_connected_to
              ,deliverable_id            = l_thldact_rec.deliverable_id
              ,activity_offer_id         = l_thldact_rec.activity_offer_id
              ,dscript_name              = l_thldact_rec.dscript_name
              ,program_to_call           = l_thldact_rec.program_to_call
              ,cover_letter_id           = l_thldact_rec.cover_letter_id
              ,mail_subject              = l_thldact_rec.mail_subject
              ,mail_sender_name          = l_thldact_rec.mail_sender_name
              ,from_fax_no               = l_thldact_rec.from_fax_no
              ,action_for_id             = l_thldact_rec.action_for_id
   WHERE   trigger_action_id = l_thldact_Rec.trigger_action_id
   AND object_version_number = l_thldact_rec.object_version_number;

Line: 881


           ROLLBACK TO Update_Thldact_PVT;

Line: 891


           ROLLBACK TO Update_Thldact_PVT;

Line: 901


           ROLLBACK TO Update_Thldact_PVT;

Line: 914


END Update_Thldact;

Line: 1710


select  arc_trigger_created_for,
        trigger_created_for_id
from    ams_triggers
where   trigger_id = l_trig_id ;

Line: 1885


  x_thldact_rec.last_update_date              := FND_API.G_MISS_DATE ;

Line: 1886


  x_thldact_rec.last_updated_by               := FND_API.G_MISS_NUM ;

Line: 1889


  x_thldact_rec.last_update_login             := FND_API.G_MISS_NUM ;

Line: 1942


   SELECT *
     FROM ams_trigger_actions
    WHERE trigger_action_id = p_thldact_rec.trigger_action_id;