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

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

Line: 57


      SELECT PV_PROGRAM_PARTNER_TYPES_s.NEXTVAL
      FROM dual;

Line: 61


      SELECT 'X'
      FROM PV_PROGRAM_PARTNER_TYPES
      WHERE PROGRAM_PARTNER_TYPES_ID = l_id;

Line: 137


           l_prgm_ptr_types_rec.last_update_date      := SYSDATE;

Line: 138


           l_prgm_ptr_types_rec.last_updated_by       := FND_GLOBAL.user_id;

Line: 141


           l_prgm_ptr_types_rec.last_update_login     := FND_GLOBAL.conc_login_id;

Line: 176


       PV_PRGM_PTR_TYPES_PKG.Insert_Row(
            px_program_partner_types_id => l_prgm_ptr_types_rec.program_partner_types_id
           ,p_PROGRAM_TYPE_ID     => l_prgm_ptr_types_rec.PROGRAM_TYPE_ID
           ,p_partner_type              => l_prgm_ptr_types_rec.partner_type
           ,p_last_update_date          => l_prgm_ptr_types_rec.last_update_date
           ,p_last_updated_by           => l_prgm_ptr_types_rec.last_updated_by
           ,p_creation_date             => l_prgm_ptr_types_rec.creation_date
           ,p_created_by                => l_prgm_ptr_types_rec.created_by
           ,p_last_update_login         => l_prgm_ptr_types_rec.last_update_login
           ,p_object_version_number     => l_object_version_number
           );

Line: 251


 PROCEDURE Update_Prgm_Ptr_Type(
      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_ptr_types_rec         IN   prgm_ptr_types_rec_type
     )

  IS


 CURSOR c_get_pgm_tgt_ptr_typ(cv_program_partner_types_id NUMBER) IS
     SELECT *
     FROM  PV_PROGRAM_PARTNER_TYPES
     WHERE program_partner_types_id = cv_program_partner_types_id;

Line: 272


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

Line: 284


       SAVEPOINT UPDATE_PGM_TGT_PTR_TYP_PVT;

Line: 314


      PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');

Line: 322


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

Line: 367


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

Line: 390


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

Line: 394


     PV_PRGM_PTR_TYPES_PKG.Update_Row(
            p_program_partner_types_id  => p_prgm_ptr_types_rec.program_partner_types_id
           ,p_PROGRAM_TYPE_ID     => p_prgm_ptr_types_rec.PROGRAM_TYPE_ID
           ,p_partner_type              => p_prgm_ptr_types_rec.partner_type
           ,p_last_update_date          => SYSDATE
           ,p_last_updated_by           => FND_GLOBAL.user_id
           ,p_last_update_login         => FND_GLOBAL.conc_login_id
           ,p_object_version_number     => p_prgm_ptr_types_rec.object_version_number
          );

Line: 423


      ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;

Line: 433


      ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;

Line: 443


      ROLLBACK TO UPDATE_PGM_TGT_PTR_TYP_PVT;

Line: 456


END Update_Prgm_Ptr_Type;

Line: 460


PROCEDURE Delete_Prgm_Ptr_Type(
      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  VARCHAR
     ,x_msg_count                  OUT NOCOPY  NUMBER
     ,x_msg_data                   OUT NOCOPY  VARCHAR2
     ,p_program_partner_types_id   IN   NUMBER
     ,p_object_version_number      IN   NUMBER
     )

  IS

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

Line: 483


       SAVEPOINT DELETE_PGM_TGT_PTR_TYP_PVT;

Line: 513


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

Line: 517


       PV_PRGM_PTR_TYPES_PKG.Delete_Row(
             p_program_partner_types_id  => p_program_partner_types_id
          ,p_object_version_number => p_object_version_number
          );

Line: 542


       ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;

Line: 552


      ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;

Line: 562


       ROLLBACK TO DELETE_PGM_TGT_PTR_TYP_PVT;

Line: 575


 End Delete_Prgm_Ptr_Type;

Line: 599


    SELECT PROGRAM_PARTNER_TYPES_ID
    FROM PV_PROGRAM_PARTNER_TYPES
    WHERE PROGRAM_PARTNER_TYPES_ID = p_PROGRAM_PARTNER_TYPES_ID
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;

Line: 804


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

Line: 807


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

Line: 814


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

Line: 817


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

Line: 845


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

Line: 848


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

Line: 1073


       SELECT *
       FROM PV_PROGRAM_PARTNER_TYPES
       WHERE program_partner_types_id = p_prgm_ptr_types_rec.program_partner_types_id;

Line: 1110


    IF p_prgm_ptr_types_rec.last_update_date IS NULL THEN
       x_complete_rec.last_update_date := l_prgm_ptr_types_rec.last_update_date;

Line: 1115


    IF p_prgm_ptr_types_rec.last_updated_by IS NULL THEN
       x_complete_rec.last_updated_by := l_prgm_ptr_types_rec.last_updated_by;

Line: 1130


    IF p_prgm_ptr_types_rec.last_update_login IS NULL THEN
       x_complete_rec.last_update_login := l_prgm_ptr_types_rec.last_update_login;