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.PV_PRGM_BENEFITS_PVT SQL Statements

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

Line: 58


      SELECT PV_PROGRAM_BENEFITS_S.NEXTVAL
      FROM dual;

Line: 64


      SELECT  'X'
      FROM PV_PROGRAM_BENEFITS
      WHERE PROGRAM_BENEFITS_ID = l_id;

Line: 141


      l_prgm_benefits_rec.last_update_date      := SYSDATE;

Line: 142


      l_prgm_benefits_rec.last_updated_by       := FND_GLOBAL.user_id;

Line: 145


      l_prgm_benefits_rec.last_update_login     := FND_GLOBAL.conc_login_id;

Line: 192


      PV_PRGM_BENEFITS_PKG.Insert_Row(
           px_program_benefits_id    => l_prgm_benefits_rec.program_benefits_id
          ,p_program_id              => l_prgm_benefits_rec.program_id
          ,p_benefit_code            => l_prgm_benefits_rec.benefit_code
          ,p_benefit_id              => l_prgm_benefits_rec.benefit_id
          ,p_benefit_type_code       => l_prgm_benefits_rec.benefit_type_code
          ,p_delete_flag             => l_prgm_benefits_rec.delete_flag
          ,p_last_update_login       => l_prgm_benefits_rec.last_update_login
          ,p_object_version_number   => l_object_version_number
          ,p_last_update_date        => l_prgm_benefits_rec.last_update_date
          ,p_last_updated_by         => l_prgm_benefits_rec.last_updated_by
          ,p_created_by              => l_prgm_benefits_rec.created_by
          ,p_creation_date           => l_prgm_benefits_rec.creation_date
          );

Line: 272


PROCEDURE Update_Prgm_Benefits(
     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_prgm_benefits_rec          IN   prgm_benefits_rec_type
    )

IS

CURSOR c_get_prgm_benefits(cv_program_benefits_id NUMBER) IS
    SELECT *
    FROM  PV_PROGRAM_BENEFITS
    WHERE PROGRAM_BENEFITS_ID = cv_program_benefits_id;

Line: 292


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

Line: 305


      SAVEPOINT UPDATE_Prgm_Benefits_PVT;

Line: 331


         FND_MESSAGE.set_token('MODE','Update');

Line: 374


            ,p_validation_mode        => JTF_PLSQL_API.g_update
            ,p_prgm_benefits_rec      => p_prgm_benefits_rec
            ,x_return_status          => x_return_status
            ,x_msg_count              => x_msg_count
            ,x_msg_data               => x_msg_data
            );

Line: 397


      Pvx_Utility_Pvt.debug_message('Private API: '||l_full_name||' - Calling update table handler');

Line: 401


      PV_PRGM_BENEFITS_PKG.Update_Row(
           p_program_benefits_id    => l_tar_prgm_benefits_rec.program_benefits_id
          ,p_program_id             => l_tar_prgm_benefits_rec.program_id
          ,p_benefit_code           => l_tar_prgm_benefits_rec.benefit_code
          ,p_benefit_id             => l_tar_prgm_benefits_rec.benefit_id
          ,p_benefit_type_code      => l_tar_prgm_benefits_rec.benefit_type_code
          ,p_delete_flag            => l_tar_prgm_benefits_rec.delete_flag
          ,p_last_update_login      => FND_GLOBAL.conc_login_id
          ,p_object_version_number  => l_tar_prgm_benefits_rec.object_version_number
          ,p_last_update_date       => SYSDATE
          ,p_last_updated_by        => FND_GLOBAL.user_id
          );

Line: 433


     ROLLBACK TO UPDATE_Prgm_Benefits_PVT;

Line: 443


     ROLLBACK TO UPDATE_Prgm_Benefits_PVT;

Line: 453


     ROLLBACK TO UPDATE_Prgm_Benefits_PVT;

Line: 466


End Update_Prgm_Benefits;

Line: 470


PROCEDURE Delete_Prgm_Benefits(
     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_program_benefits_id        IN   NUMBER
    ,p_object_version_number      IN   NUMBER
    )

IS

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

Line: 494


      SAVEPOINT DELETE_Prgm_Benefits_PVT;

Line: 524


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

Line: 528


      PV_PRGM_BENEFITS_PKG.Delete_Row(
           p_program_benefits_id   => p_program_benefits_id
          ,p_object_version_number => p_object_version_number
          );

Line: 552


     ROLLBACK TO DELETE_Prgm_Benefits_PVT;

Line: 562


     ROLLBACK TO DELETE_Prgm_Benefits_PVT;

Line: 572


     ROLLBACK TO DELETE_Prgm_Benefits_PVT;

Line: 585


END Delete_Prgm_Benefits;

Line: 609


   SELECT program_benefits_id
   FROM PV_PROGRAM_BENEFITS
   WHERE program_benefits_id = px_program_benefits_id
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 828


      IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
        OR p_prgm_benefits_rec.delete_flag IS NULL THEN
         FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 831


         FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');

Line: 838


      IF p_prgm_benefits_rec.last_update_login = FND_API.g_miss_num
        OR p_prgm_benefits_rec.last_update_login IS NULL THEN
         FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 841


         FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');

Line: 858


      IF p_prgm_benefits_rec.last_update_date = FND_API.g_miss_date
        OR p_prgm_benefits_rec.last_update_date IS NULL THEN
         FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 861


         FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');

Line: 868


      IF p_prgm_benefits_rec.last_updated_by = FND_API.g_miss_num
        OR p_prgm_benefits_rec.last_updated_by IS NULL THEN
         FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 871


         FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');

Line: 931


      IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
        OR p_prgm_benefits_rec.delete_flag IS NULL THEN
         FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 934


         FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');

Line: 1161


      SELECT *
      FROM pv_program_benefits
      WHERE program_benefits_id = p_prgm_benefits_rec.program_benefits_id;

Line: 1214


   IF p_prgm_benefits_rec.delete_flag IS NULL THEN
      x_complete_rec.delete_flag := l_prgm_benefits_rec.delete_flag;

Line: 1220


   IF p_prgm_benefits_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_prgm_benefits_rec.last_update_login;

Line: 1232


   IF p_prgm_benefits_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_prgm_benefits_rec.last_update_date;

Line: 1238


   IF p_prgm_benefits_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_prgm_benefits_rec.last_updated_by;

Line: 1263


    ,p_validation_mode            IN   VARCHAR2     	:= JTF_PLSQL_API.G_UPDATE
    ,x_return_status              OUT NOCOPY  VARCHAR2
    ,x_msg_count                  OUT NOCOPY  NUMBER
    ,x_msg_data                   OUT NOCOPY  VARCHAR2
    )

IS

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