APPS.AMS_DMLIFT_PUB SQL Statements

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

Line: 281

PROCEDURE Update_Lift(
    p_api_version         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_lift_rec               IN    lift_rec_type,
    x_object_version_number      OUT  NUMBER
    )

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

Line: 301

      SAVEPOINT Update_Lift_PUB;

Line: 328

    AMS_DMLift_PVT.Update_Lift(
    p_api_version         => 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_lift_rec  =>  l_pvt_lift_rec,
    x_object_version_number      => l_object_version_number );

Line: 375

     ROLLBACK TO Update_Lift_PUB;

Line: 385

     ROLLBACK TO Update_Lift_PUB;

Line: 395

     ROLLBACK TO Update_Lift_PUB;

Line: 407

End Update_Lift;

Line: 410

PROCEDURE Delete_Lift(
    p_api_version         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_lift_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 429

      SAVEPOINT Delete_Lift_PUB;

Line: 456

    AMS_DMLift_PVT.Delete_Lift(
    p_api_version         => 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_lift_id     => l_lift_id,
    p_object_version_number      => l_object_version_number );

Line: 503

     ROLLBACK TO Delete_Lift_PUB;

Line: 513

     ROLLBACK TO Delete_Lift_PUB;

Line: 523

     ROLLBACK TO Delete_Lift_PUB;

Line: 535

End Delete_Lift;

Line: 566

      SELECT ams_dm_lift_s.NEXTVAL
      FROM   dual;

Line: 570

      SELECT 1
      FROM   dual
      WHERE  EXISTS (SELECT 1
                     FROM   ams_dm_lift
                     WHERE  lift_id = p_lift_id)
      ;

Line: 598

      p_validation_mode    => JTF_PLSQL_API.G_UPDATE,
      p_lift_rec           => l_lift_rec,
      x_return_status      => x_return_status,
      x_msg_count          => l_msg_count,
      x_msg_data           => l_msg_data
   );

Line: 628

   ams_dm_lift_pkg.Insert_Row(
      px_LIFT_ID           => l_lift_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_MODEL_ID           => p_model_id,
      p_QUANTILE           => p_quantile,
      p_LIFT               =>p_lift,
      p_TARGETS            => p_targets,
      p_NON_TARGETS        => p_non_targets,
      p_TARGETS_CUMM       => p_targets_cumm,
      p_TARGET_DENSITY_CUMM   => p_target_density_cumm,
      p_TARGET_DENSITY     => p_target_density,
      p_MARGIN             => NULL,
      p_ROI                => NULL,
      p_TARGET_CONFIDENCE  => p_target_confidence,
      p_NON_TARGET_CONFIDENCE => p_non_target_confidence
   );