APPS.AMS_DM_TARGET_VALUE_PVT SQL Statements

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

Line: 68

      SELECT AMS_DM_TARGET_VALUES_B_s.NEXTVAL
      FROM dual;

Line: 72

      SELECT 1
      FROM AMS_DM_TARGET_VALUES_VL
      WHERE TARGET_VALUE_ID = l_id;

Line: 78

   SELECT data_source_id
     FROM ams_dm_targets_vl
    WHERE target_id = l_tgtId;

Line: 132

   AMS_UTILITY_PVT.debug_message( l_api_name || ' New Target Value ID to Insert = ' || l_dm_target_value_rec.TARGET_VALUE_ID);

Line: 172

   AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(
       px_target_value_id        => l_dm_target_value_rec.TARGET_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_target_id               => l_dm_target_value_rec.target_id,
       p_target_value            => l_dm_target_value_rec.target_value,
       p_target_operator         => l_dm_target_value_rec.target_operator,
       p_range_value             => l_dm_target_value_rec.range_value,
       p_description             => l_dm_target_value_rec.description
   );

Line: 203

   update ams_dm_targets_b
      set active_flag = 'Y'
    where target_id = l_dm_target_value_rec.target_id;

Line: 213

   update ams_list_src_types
      set enabled_flag = 'Y',
          object_version_number = object_version_number + 1
    where list_source_type_id = l_datasource_id;

Line: 280

PROCEDURE Update_Dm_Target_Value(
    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_target_value_rec        IN   dm_target_value_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
)

 IS


    CURSOR c_get_dm_target_value(p_target_value_id NUMBER) IS
        SELECT *
        FROM  AMS_DM_TARGET_VALUES_VL
        WHERE target_value_id = p_target_value_id;

Line: 303

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

Line: 315

      SAVEPOINT UPDATE_Dm_Target_Value_PVT;

Line: 375

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

Line: 393

                                        p_token_value  => 'Last_Update_Date') ;

Line: 411

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

Line: 425

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

Line: 429

      AMS_DM_TARGET_VALUES_B_PKG.Update_Row(
          p_target_value_id         => l_tar_dm_target_value_rec.target_value_id,
          p_last_update_date        => SYSDATE,
          p_last_updated_by         => G_USER_ID,
          p_last_update_login       => G_LOGIN_ID,
          p_object_version_number   => l_tar_dm_target_value_rec.object_version_number + 1,
          p_target_id               => l_tar_dm_target_value_rec.target_id,
          p_target_value            => l_tar_dm_target_value_rec.target_value,
          p_target_operator         => l_tar_dm_target_value_rec.target_operator,
          p_range_value             => l_tar_dm_target_value_rec.range_value,
          p_description             => l_tar_dm_target_value_rec.description
      );

Line: 472

     ROLLBACK TO UPDATE_Dm_Target_Value_PVT;

Line: 482

     ROLLBACK TO UPDATE_Dm_Target_Value_PVT;

Line: 492

     ROLLBACK TO UPDATE_Dm_Target_Value_PVT;

Line: 504

End Update_Dm_Target_Value;

Line: 506

PROCEDURE Delete_TgtValues_For_Target ( p_target_id IN   NUMBER)
 IS
      L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_TgtValues_For_Target';

Line: 512

      SAVEPOINT Delete_TgtValues_For_Target;

Line: 523

      DELETE FROM ams_dm_target_values_tl
       WHERE TARGET_VALUE_ID in (SELECT TARGET_VALUE_ID FROM AMS_DM_TARGET_VALUES_B WHERE TARGET_ID = p_TARGET_ID);

Line: 526

      DELETE FROM AMS_DM_TARGET_VALUES_B
       WHERE TARGET_ID = p_TARGET_ID;

Line: 545

     ROLLBACK TO Delete_TgtValues_For_Target;

Line: 548

     ROLLBACK TO Delete_TgtValues_For_Target;

Line: 551

     ROLLBACK TO Delete_TgtValues_For_Target;

Line: 553

End Delete_TgtValues_For_Target;

Line: 558

PROCEDURE Delete_Dm_Target_Value(
    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_target_value_id            IN   NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 581

      SELECT target_id
        FROM ams_dm_target_values_vl
       WHERE target_value_id = l_tgtValueId;

Line: 587

      SELECT count(*)
      FROM AMS_DM_TARGET_VALUES_VL
      WHERE TARGET_ID = l_tgtId;

Line: 593

      SELECT data_source_id
        FROM ams_dm_targets_vl
       WHERE target_id = l_tgtId;

Line: 599

      SELECT count(*)
      FROM AMS_DM_TARGETS_VL
      WHERE DATA_SOURCE_ID = l_dsId
        AND ACTIVE_FLAG = 'Y';

Line: 606

      SAVEPOINT DELETE_Dm_Target_Value_PVT;

Line: 639

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

Line: 651

      AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Before Delete: TARGET_ID = ' || l_target_id );

Line: 656

      AMS_DM_TARGET_VALUES_B_PKG.Delete_Row(
          p_TARGET_VALUE_ID  => p_TARGET_VALUE_ID);

Line: 670

         update ams_dm_targets_b
            set active_flag = 'N'
          where target_id = l_target_id;

Line: 686

            update ams_list_src_types
               set enabled_flag = 'N'
             where list_source_type_id = l_datasource_id;

Line: 724

     ROLLBACK TO DELETE_Dm_Target_Value_PVT;

Line: 734

     ROLLBACK TO DELETE_Dm_Target_Value_PVT;

Line: 744

     ROLLBACK TO DELETE_Dm_Target_Value_PVT;

Line: 756

End Delete_Dm_Target_Value;

Line: 780

       SELECT TARGET_VALUE_ID
         FROM AMS_DM_TARGET_VALUES_B
        WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
          AND object_version_number = p_object_version
          FOR UPDATE NOWAIT;

Line: 897

      SELECT FND_API.g_false
      FROM   ams_dm_target_values_b tvb
      WHERE  tvb.target_id = p_dm_target_value_rec.target_id
      AND    tvb.target_operator = p_dm_target_value_rec.target_operator
      AND    tvb.target_value = p_dm_target_value_rec.target_value
      ;

Line: 907

      SELECT FND_API.g_false
      FROM   ams_dm_target_values_b tvb
      WHERE  tvb.target_id = p_dm_target_value_rec.target_id
      AND    tvb.target_operator = p_dm_target_value_rec.target_operator
      AND    tvb.target_value = p_dm_target_value_rec.target_value
      AND    tvb.target_value_id <> p_dm_target_value_rec.target_value_id
      ;

Line: 1002

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

Line: 1008

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

Line: 1012

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

Line: 1024

      IF p_dm_target_value_rec.last_update_login IS NULL THEN
         AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD','LAST_UPDATE_LOGIN');

Line: 1157

      SELECT *
      FROM ams_dm_target_values_vl
      WHERE target_value_id = p_dm_target_value_rec.target_value_id;

Line: 1176

   IF p_dm_target_value_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_dm_target_value_rec.last_update_date;

Line: 1181

   IF p_dm_target_value_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_dm_target_value_rec.last_updated_by;

Line: 1196

   IF p_dm_target_value_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_dm_target_value_rec.last_update_login;

Line: 1375

    SELECT a.field_data_type
      FROM ams_list_src_fields a, ams_dm_targets_b b
    WHERE b.target_id = l_tgtId
    AND a.list_source_field_id = b.source_field_id;