APPS.PVX_TIMEOUT_SETUP_PVT SQL Statements

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

Line: 52

   SELECT PV_COUNTRY_TIMEOUTS_S.NEXTVAL
     FROM DUAL;

Line: 57

   SELECT  'ANYTHING'
     FROM  PV_COUNTRY_TIMEOUTS
     WHERE timeout_id = cv_timeout_setup_id;

Line: 119

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

Line: 142

  INSERT INTO PV_COUNTRY_TIMEOUTS (
       timeout_id
      ,last_update_date
      ,last_updated_by
      ,creation_date
      ,created_by
      ,last_update_login
      ,timeout_period
      ,timeout_type
      ,country_code
      ,object_version_number
       )
    VALUES (
      l_timeout_setup_rec.timeout_id
      ,SYSDATE                                -- LAST_UPDATE_DATE
      ,NVL(FND_GLOBAL.user_id,-1)             -- LAST_UPDATED_BY
      ,SYSDATE                                -- CREATION_DATE
      ,NVL(FND_GLOBAL.user_id,-1)             -- CREATED_BY
      ,NVL(FND_GLOBAL.conc_login_id,-1)       -- LAST_UPDATE_LOGIN
      ,l_timeout_setup_rec.timeout_period
      ,l_timeout_setup_rec.timeout_type
      ,l_timeout_setup_rec.country_code
      ,l_object_version_number                -- object_version_number
      );

Line: 238

PROCEDURE Delete_timeout_setup(
   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_timeout_id        IN  NUMBER
  ,p_object_version    IN  NUMBER

)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 254

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

Line: 260

   SAVEPOINT Delete_timeout_setup;

Line: 284

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

Line: 289

   DELETE FROM PV_country_timeouts
   WHERE timeout_id = p_timeout_id
   AND   object_version_number = p_object_version;

Line: 322

      ROLLBACK TO Delete_timeout_setup;

Line: 331

      ROLLBACK TO Delete_timeout_setup;

Line: 340

      ROLLBACK TO Delete_timeout_setup;

Line: 354

END Delete_timeout_setup;

Line: 361

PROCEDURE Update_timeout_setup(
   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_timeout_setup_rec IN  timeout_setup_rec_type
)
IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 375

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

Line: 380

   l_mode            VARCHAR2(30) := 'UPDATE';

Line: 386

   SAVEPOINT Update_timeout_setup;

Line: 420

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

Line: 451

      PVX_Utility_PVT.debug_message(l_full_name ||': update');

Line: 455

   UPDATE PV_COUNTRY_TIMEOUTS
   SET
       last_update_date           = SYSDATE
      ,last_updated_by            = NVL(FND_GLOBAL.user_id,-1)
      ,last_update_login          = NVL(FND_GLOBAL.conc_login_id,-1)
      ,timeout_period             = l_timeout_setup_rec.timeout_period
      ,timeout_type               = l_timeout_setup_rec.timeout_type
      ,country_code               = l_timeout_setup_rec.country_code
      ,object_version_number      = l_timeout_setup_rec.object_version_number + 1
   WHERE timeout_id = l_timeout_setup_rec.timeout_id
   AND   object_version_number = l_timeout_setup_rec.object_version_number;

Line: 497

      ROLLBACK TO Update_timeout_setup;

Line: 506

      ROLLBACK TO Update_timeout_setup;

Line: 515

      ROLLBACK TO Update_timeout_setup;

Line: 529

END Update_timeout_setup;

Line: 540

  ,p_mode              IN  VARCHAR2 := 'INSERT'
  ,x_return_status     OUT NOCOPY VARCHAR2
)
IS
    BEGIN
        x_return_status := FND_API.g_ret_sts_success;

Line: 577

   SELECT  'ANYTHING'
   FROM  PV_COUNTRY_TIMEOUTS
   WHERE country_code = p_timeout_setup_rec.country_code
   AND   timeout_type = p_timeout_setup_rec.timeout_type;

Line: 774

x_timeout_setup_rec.last_update_date           := FND_API.G_MISS_DATE;

Line: 775

x_timeout_setup_rec.last_updated_by            := FND_API.G_MISS_NUM;

Line: 778

x_timeout_setup_rec.last_update_login          := FND_API.G_MISS_NUM;

Line: 809

   SELECT  timeout_id
     FROM  PV_COUNTRY_TIMEOUTS
     WHERE timeout_id = p_timeout_id
     AND   object_version_number = p_object_version
   FOR UPDATE OF timeout_id NOWAIT;

Line: 928

   SELECT *
     FROM  PV_COUNTRY_TIMEOUTS
     WHERE timeout_id = p_timeout_setup_rec.timeout_id;