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

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

Line: 97


      SELECT pv_ge_history_log_b_s.NEXTVAL
      FROM dual;

Line: 101


      SELECT 1
      FROM PV_GE_HISTORY_LOG_B
      WHERE entity_history_log_id = l_id;

Line: 198


      Pv_Ge_Hist_Log_Pkg.Insert_Row(
          px_entity_history_log_id  => l_entity_history_log_id,
          px_object_version_number  => l_object_version_number,
          p_arc_history_for_entity_code  => p_ge_hist_log_rec.arc_history_for_entity_code,
          p_history_for_entity_id  => p_ge_hist_log_rec.history_for_entity_id,
          p_message_code  => p_ge_hist_log_rec.message_code,
          p_history_category_code  => p_ge_hist_log_rec.history_category_code,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          p_partner_id  => p_ge_hist_log_rec.partner_id,
          p_access_level_flag  => p_ge_hist_log_rec.access_level_flag,
          p_interaction_level  => p_ge_hist_log_rec.interaction_level,
          p_comments  => p_ge_hist_log_rec.comments
);

Line: 318


PROCEDURE Update_Ge_Hist_Log(
    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_ge_hist_log_rec               IN    ge_hist_log_rec_type
    )

 IS


CURSOR c_get_ge_hist_log(entity_history_log_id NUMBER) IS
    SELECT *
    FROM  PV_GE_HISTORY_LOG_B
    WHERE  entity_history_log_id = p_ge_hist_log_rec.entity_history_log_id;

Line: 341


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

Line: 352


      SAVEPOINT update_ge_hist_log_pvt;

Line: 386


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

Line: 394


  PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'Ge_Hist_Log') ;

Line: 411


 p_token_value  => 'Last_Update_Date') ;

Line: 436


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

Line: 451


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

Line: 455


      Pv_Ge_Hist_Log_Pkg.Update_Row(
          p_entity_history_log_id  => p_ge_hist_log_rec.entity_history_log_id,
          p_object_version_number  => p_ge_hist_log_rec.object_version_number,
          p_arc_history_for_entity_code  => p_ge_hist_log_rec.arc_history_for_entity_code,
          p_history_for_entity_id  => p_ge_hist_log_rec.history_for_entity_id,
          p_message_code  => p_ge_hist_log_rec.message_code,
          p_history_category_code  => p_ge_hist_log_rec.history_category_code,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_date  => SYSDATE,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          p_partner_id  => p_ge_hist_log_rec.partner_id,
          p_access_level_flag  => p_ge_hist_log_rec.access_level_flag,
          p_interaction_level  => p_ge_hist_log_rec.interaction_level,
          p_comments  => p_ge_hist_log_rec.comments
);

Line: 500


     ROLLBACK TO UPDATE_Ge_Hist_Log_PVT;

Line: 510


     ROLLBACK TO UPDATE_Ge_Hist_Log_PVT;

Line: 520


     ROLLBACK TO UPDATE_Ge_Hist_Log_PVT;

Line: 532


End Update_Ge_Hist_Log;

Line: 569


PROCEDURE Delete_Ge_Hist_Log(
    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_entity_history_log_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 588


      SAVEPOINT delete_ge_hist_log_pvt;

Line: 625


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

Line: 629


      Pv_Ge_Hist_Log_Pkg.Delete_Row(
          p_entity_history_log_id  => p_entity_history_log_id,
          p_object_version_number => p_object_version_number     );

Line: 662


     ROLLBACK TO DELETE_Ge_Hist_Log_PVT;

Line: 672


     ROLLBACK TO DELETE_Ge_Hist_Log_PVT;

Line: 682


     ROLLBACK TO DELETE_Ge_Hist_Log_PVT;

Line: 694


End Delete_Ge_Hist_Log;

Line: 1067


      SELECT *
      FROM pv_ge_history_log_b
      WHERE entity_history_log_id = p_ge_hist_log_rec.entity_history_log_id;

Line: 1120


   IF p_ge_hist_log_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_ge_hist_log_rec.last_updated_by;

Line: 1125


   IF p_ge_hist_log_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_ge_hist_log_rec.last_update_date;

Line: 1130


   IF p_ge_hist_log_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_ge_hist_log_rec.last_update_login;

Line: 1383


	    SELECT param_type, lookup_type, param_name, param_value
	    FROM pv_ge_history_log_params
	    WHERE entity_history_log_id = p_entity_history_log_id;

Line: 1402


	            l_query := ' SELECT meaning FROM FND_LOOKUP_VALUES ' ||
	                       ' WHERE  lookup_type = :1 ' ||
	                       ' AND    lookup_code = :2 ' ||
                           ' AND    language = USERENV(''LANG'') ' ;

Line: 1424


                FOR x IN (SELECT n.NOTES FROM jtf_notes_vl n, PV_GE_HISTORY_LOG_PARAMS p
                          WHERE p.ENTITY_HISTORY_LOG_ID = p_entity_history_log_id
                          AND   n.jtf_note_id = p.param_value
                          AND   p.param_type = 'NOTE')
                LOOP
                    l_note_text := x.NOTES;