APPS.AMS_ACT_MESSAGES_PVT SQL Statements

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

Line: 56

   SELECT ams_act_messages_s.NEXTVAL
     FROM DUAL;

Line: 123

insert into ams_act_messages
(act_message_id,
   last_update_date,
   last_updated_by,
   creation_date,
   created_by,
   last_update_login,
   object_version_number,
   message_id,
   message_used_by,
   message_used_by_id
)
values
(x_act_msg_id,
 SYSDATE,
 FND_GLOBAL.user_id,
 SYSDATE,
 FND_GLOBAL.user_id,
 FND_GLOBAL.conc_login_id,
 1,  -- object_version_number
  p_message_id,
  p_message_used_by ,
  p_msg_used_by_id
  );

Line: 247

PROCEDURE update_act_messages
(
  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_act_msg_id                 IN      NUMBER,
  p_message_id               IN      NUMBER,
  p_msg_used_by	     IN      VARCHAR2,
  p_msg_used_by_id       IN      NUMBER,
  p_object_version            IN      NUMBER
)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 267

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

Line: 275

   SAVEPOINT update_act_messages;

Line: 324

UPDATE ams_act_messages  SET
      last_update_date = SYSDATE,
      last_updated_by = FND_GLOBAL.user_id,
      last_update_login = FND_GLOBAL.conc_login_id,
      object_version_number = p_object_version + 1,
      message_id = p_message_id,
      message_used_by = p_msg_used_by,
      message_used_by_id = p_msg_used_by_id
 WHERE act_message_id =  p_act_msg_id
  AND object_version_number = p_object_version;

Line: 356

      ROLLBACK TO update_act_messages;

Line: 365

      ROLLBACK TO update_act_messages;

Line: 375

      ROLLBACK TO update_act_messages;

Line: 389

  END update_act_messages;

Line: 398

PROCEDURE delete_act_messages
(
  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_act_msg_id       IN      NUMBER,
  p_object_version   IN      NUMBER
)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 414

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

Line: 423

   SELECT message_used_by_id, message_used_by
     FROM ams_act_messages
    WHERE act_message_id = p_act_msg_id;

Line: 428

   SELECT 1
     FROM ams_act_messages
   WHERE message_used_by_id = l_used_by_id
     AND message_used_by = l_used_by;

Line: 436

   SAVEPOINT delete_act_messages;

Line: 474

DELETE FROM ams_act_messages
WHERE  ACT_MESSAGE_ID = p_act_msg_id
AND         OBJECT_VERSION_NUMBER = p_object_version;

Line: 531

      ROLLBACK TO delete_act_messages;

Line: 540

      ROLLBACK TO delete_act_messages;

Line: 550

      ROLLBACK TO delete_act_messages;

Line: 564

  END delete_act_messages;

Line: 596

   SELECT act_message_id
     FROM ams_act_messages
    WHERE act_message_id  = p_act_msg_id
      AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 733

   select 'x'
   from    AMS_MESSAGES_B
   where message_id = p_message_id;

Line: 738

    select meaning
    from    ams_lookups
    where  lookup_type = 'AMS_SYS_ARC_QUALIFIER'
    and      lookup_code = p_msg_used_by;

Line: 744

   select  'x'
   from     ams_act_messages
   where  message_used_by =  p_msg_used_by
   and      message_used_by_id   = p_msg_used_by_id
   and      message_id = p_message_id;