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

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

Line: 48


      SELECT AMS_SYSTEM_PRETTY_URL_s.NEXTVAL
      FROM dual;

Line: 52


      SELECT 1
      FROM AMS_SYSTEM_PRETTY_URL
      WHERE SYSTEM_URL_ID = l_id;

Line: 133


      AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row(
          px_system_url_id  => l_system_url_id,
          p_creation_date  => SYSDATE,
          p_created_by  => G_USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => G_USER_ID,
          p_last_update_login  => G_LOGIN_ID,
          px_object_version_number  => l_object_version_number,
          p_pretty_url_id  => p_system_pretty_url_rec.pretty_url_id,
          p_additional_url_param  => p_system_pretty_url_rec.additional_url_param,
          p_system_url  => p_system_pretty_url_rec.system_url,
          p_ctd_id  => p_system_pretty_url_rec.ctd_id,
          p_track_url  => p_system_pretty_url_rec.track_url);

Line: 212


PROCEDURE Update_System_Pretty_Url(
    p_api_version_number         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_system_pretty_url_rec               IN    system_pretty_url_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS
    CURSOR c_get_system_pretty_url(system_url_id NUMBER) IS
    SELECT *
    FROM  AMS_SYSTEM_PRETTY_URL;

Line: 231


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_System_Pretty_Url';

Line: 242


      SAVEPOINT UPDATE_System_Pretty_Url_PVT;

Line: 267


      AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 275


  AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'System_Pretty_Url') ;

Line: 290


 p_token_value  => 'Last_Update_Date') ;

Line: 322


      AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 325


      AMS_SYSTEM_PRETTY_URL_PKG.Update_Row(
          p_system_url_id  => p_system_pretty_url_rec.system_url_id,
          p_creation_date  => SYSDATE,
          p_created_by  => G_USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => G_USER_ID,
          p_last_update_login  => G_LOGIN_ID,
          p_object_version_number  => p_system_pretty_url_rec.object_version_number,
          p_pretty_url_id  => p_system_pretty_url_rec.pretty_url_id,
          p_additional_url_param  => p_system_pretty_url_rec.additional_url_param,
          p_system_url  => p_system_pretty_url_rec.system_url,
          p_ctd_id  => p_system_pretty_url_rec.ctd_id,
          p_track_url  => p_system_pretty_url_rec.track_url);

Line: 364


     ROLLBACK TO UPDATE_System_Pretty_Url_PVT;

Line: 374


     ROLLBACK TO UPDATE_System_Pretty_Url_PVT;

Line: 384


     ROLLBACK TO UPDATE_System_Pretty_Url_PVT;

Line: 396


End Update_System_Pretty_Url;

Line: 399


PROCEDURE Delete_System_Pretty_Url(
    p_api_version_number         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_system_url_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_System_Pretty_Url';

Line: 418


      SAVEPOINT DELETE_System_Pretty_Url_PVT;

Line: 446


      AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 449


      AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row(
          p_SYSTEM_URL_ID  => p_SYSTEM_URL_ID);

Line: 477


     ROLLBACK TO DELETE_System_Pretty_Url_PVT;

Line: 487


     ROLLBACK TO DELETE_System_Pretty_Url_PVT;

Line: 497


     ROLLBACK TO DELETE_System_Pretty_Url_PVT;

Line: 509


End Delete_System_Pretty_Url;

Line: 533


   SELECT SYSTEM_URL_ID
   FROM AMS_SYSTEM_PRETTY_URL
   WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 693


      IF p_system_pretty_url_rec.last_update_date = FND_API.g_miss_date OR p_system_pretty_url_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');

Line: 700


      IF p_system_pretty_url_rec.last_updated_by = FND_API.g_miss_num OR p_system_pretty_url_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');

Line: 743


      IF p_system_pretty_url_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');

Line: 750


      IF p_system_pretty_url_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');

Line: 851


      SELECT *
      FROM ams_system_pretty_url
      WHERE system_url_id = p_system_pretty_url_rec.system_url_id;

Line: 879


   IF p_system_pretty_url_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_system_pretty_url_rec.last_update_date;

Line: 884


   IF p_system_pretty_url_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_system_pretty_url_rec.last_updated_by;

Line: 889


   IF p_system_pretty_url_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_system_pretty_url_rec.last_update_login;

Line: 961


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