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

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

Line: 60


      SELECT AMS_DM_BIN_VALUES_s.NEXTVAL
      FROM dual;

Line: 64


      SELECT 1
      FROM AMS_DM_BIN_VALUES
      WHERE BIN_VALUE_ID = l_id;

Line: 117


   AMS_UTILITY_PVT.debug_message( l_api_name || ' New Bin Value ID to Insert = ' || l_dm_binvalues_rec.BIN_VALUE_ID);

Line: 163


   AMS_DM_BIN_VALUES_PKG.Insert_Row(
       px_bin_value_id		      => l_dm_binvalues_rec.bin_value_id,
       p_last_update_date		   => SYSDATE,
       p_last_updated_by		   => G_USER_ID,
       p_creation_date		      => SYSDATE,
       p_created_by			      => G_USER_ID,
       p_last_update_login		   => G_LOGIN_ID,
       px_object_version_number	=> l_object_version_number,
       p_source_field_id		   => l_dm_binvalues_rec.source_field_id,
       p_bucket			         => l_dm_binvalues_rec.bucket,
       p_bin_value			      => l_dm_binvalues_rec.bin_value,
       p_start_value			      => l_dm_binvalues_rec.start_value,
       p_end_value			      => l_dm_binvalues_rec.end_value);

Line: 247


PROCEDURE Update_Dm_Binvalues(
    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_dm_binvalues_rec           IN   dm_binvalues_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

IS


   CURSOR c_get_dm_binvalues(bin_value_id NUMBER) IS
   SELECT *
   FROM AMS_DM_BIN_VALUES
   WHERE bin_value_id = bin_value_id;

Line: 270


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

Line: 282


      SAVEPOINT UPDATE_Dm_Binvalues_PVT;

Line: 325


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

Line: 335


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

Line: 353


                                        p_token_value  => 'Last_Update_Date') ;

Line: 409


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

Line: 436


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

Line: 440


      AMS_DM_BIN_VALUES_PKG.Update_Row(
          p_bin_value_id		      => l_tar_dm_binvalues_rec.bin_value_id,
          p_last_update_date		   => SYSDATE,
          p_last_updated_by		   => G_USER_ID,
          p_creation_date		      => SYSDATE,
          p_created_by			      => G_USER_ID,
          p_last_update_login		   => G_LOGIN_ID,
          p_object_version_number	=> l_tar_dm_binvalues_rec.object_version_number,
          p_source_field_id		   => l_tar_dm_binvalues_rec.source_field_id,
          p_bucket			         => l_tar_dm_binvalues_rec.bucket,
          p_bin_value			      => l_tar_dm_binvalues_rec.bin_value,
          p_start_value			      => l_tar_dm_binvalues_rec.start_value,
          p_end_value			      => l_tar_dm_binvalues_rec.end_value);

Line: 486


      ROLLBACK TO UPDATE_Dm_Binvalues_PVT;

Line: 496


      ROLLBACK TO UPDATE_Dm_Binvalues_PVT;

Line: 506


      ROLLBACK TO UPDATE_Dm_Binvalues_PVT;

Line: 519


End Update_Dm_Binvalues;

Line: 521


PROCEDURE Delete_Dm_Binvalues_For_Field(
   p_datasource_field_id        IN  NUMBER
)
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Dm_Binvalues_For_Field';

Line: 529


   SAVEPOINT Delete_Dm_Binvalues_For_Field;

Line: 540


   DELETE FROM AMS_DM_BIN_VALUES
    WHERE source_field_id = p_datasource_field_id;

Line: 559


     ROLLBACK TO Delete_TgtValues_For_Target;

Line: 562


     ROLLBACK TO Delete_TgtValues_For_Target;

Line: 565


     ROLLBACK TO Delete_TgtValues_For_Target;

Line: 567


End Delete_Dm_Binvalues_For_Field;

Line: 571


PROCEDURE Delete_Dm_Binvalues(
   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_bin_value_id               IN   NUMBER,
   p_object_version_number      IN   NUMBER
)
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Dm_Binvalues';

Line: 589


   SAVEPOINT DELETE_Dm_Binvalues_PVT;

Line: 622


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

Line: 626


   AMS_DM_BIN_VALUES_PKG.Delete_Row(
       p_BIN_VALUE_ID  => p_BIN_VALUE_ID);

Line: 658


      ROLLBACK TO DELETE_Dm_Binvalues_PVT;

Line: 668


      ROLLBACK TO DELETE_Dm_Binvalues_PVT;

Line: 678


      ROLLBACK TO DELETE_Dm_Binvalues_PVT;

Line: 690


End Delete_Dm_Binvalues;

Line: 713


      SELECT BIN_VALUE_ID
        FROM AMS_DM_BIN_VALUES
       WHERE BIN_VALUE_ID = p_BIN_VALUE_ID
         AND object_version_number = p_object_version
         FOR UPDATE NOWAIT;

Line: 888


      ams_utility_pvt.debug_message('Private API:check_req_items for UPDATE');

Line: 895


      IF p_dm_binvalues_rec.last_update_date IS NULL THEN
         AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_DATE');

Line: 899


      IF p_dm_binvalues_rec.last_updated_by IS NULL THEN
         AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATED_BY');

Line: 1015


      SELECT *
      FROM ams_dm_bin_values
      WHERE bin_value_id = p_dm_binvalues_rec.bin_value_id;

Line: 1034


   IF p_dm_binvalues_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_dm_binvalues_rec.last_update_date;

Line: 1039


   IF p_dm_binvalues_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_dm_binvalues_rec.last_updated_by;

Line: 1054


   IF p_dm_binvalues_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_dm_binvalues_rec.last_update_login;