APPS.AMS_DMPERFORMANCE_PUB SQL Statements

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

Line: 167

PROCEDURE Update_Performance(
    p_api_version_number      IN   NUMBER,
    p_init_msg_list           IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                  IN   VARCHAR2     := FND_API.G_FALSE,

    x_return_status           OUT  VARCHAR2,
    x_msg_count               OUT  NUMBER,
    x_msg_data                OUT  VARCHAR2,

    p_performance_rec         IN    performance_rec_type,
    x_object_version_number   OUT  NUMBER
)
IS
   L_API_NAME                 CONSTANT VARCHAR2(30) := 'Update_Performance';

Line: 186

      SAVEPOINT Update_Performance_PUB;

Line: 223

    AMS_DMPerformance_PVT.Update_Performance (
       p_api_version_number      => 1.0,
       p_init_msg_list           => FND_API.G_FALSE,
       p_commit                  => p_commit,
       p_validation_level        => FND_API.G_VALID_LEVEL_FULL,
       x_return_status           => x_return_status,
       x_msg_count               => x_msg_count,
       x_msg_data                => x_msg_data,
       p_performance_rec         =>  l_pvt_performance_rec,
       x_object_version_number   => l_object_version_number
    );

Line: 271

     ROLLBACK TO Update_Performance_PUB;

Line: 281

     ROLLBACK TO Update_Performance_PUB;

Line: 291

     ROLLBACK TO Update_Performance_PUB;

Line: 303

End Update_Performance;

Line: 306

PROCEDURE Delete_Performance (
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    x_return_status              OUT  VARCHAR2,
    x_msg_count                  OUT  NUMBER,
    x_msg_data                   OUT  VARCHAR2,
    p_performance_id             IN  NUMBER,
    p_object_version_number      IN   NUMBER
)

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

Line: 322

      SAVEPOINT Delete_Performance_PUB;

Line: 349

    AMS_DMPerformance_PVT.Delete_Performance(
       p_api_version_number      => 1.0,
       p_init_msg_list           => FND_API.G_FALSE,
       p_commit                  => p_commit,
       p_validation_level        => FND_API.G_VALID_LEVEL_FULL,
       x_return_status           => x_return_status,
       x_msg_count               => x_msg_count,
       x_msg_data                => x_msg_data,
       p_performance_id          => p_performance_id,
       p_object_version_number   => p_object_version_number
    );

Line: 397

     ROLLBACK TO Delete_Performance_PUB;

Line: 407

     ROLLBACK TO Delete_Performance_PUB;

Line: 417

     ROLLBACK TO Delete_Performance_PUB;

Line: 429

End Delete_Performance;

Line: 562

      SELECT ams_dm_performance_s.NEXTVAL
      FROM   dual;

Line: 566

      SELECT 1
      FROM   dual
      WHERE EXISTS (SELECT 1
                    FROM   ams_dm_performance
                    WHERE  performance_id = p_performance_id)
      ;

Line: 615

   ams_dm_performance_pkg.insert_row (
      px_performance_id       => l_performance_id,
      p_last_update_date      => SYSDATE,
      p_last_updated_by       => FND_GLOBAL.user_id,
      p_creation_date         => SYSDATE,
      p_created_by            => FND_GLOBAL.user_id,
      p_last_update_login     => FND_GLOBAL.conc_login_id,
      px_object_version_number   => l_object_version_number,
      p_predicted_value       => p_predicted_value,
      p_actual_value          => p_actual_value,
      p_evaluated_records     => p_evaluated_records,
      p_total_records_predicted  => p_total_records_predicted,
      p_model_id              => p_model_id
   );