APPS.AMS_SCORERESULT_PUB SQL Statements

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

Line: 157

PROCEDURE Update_Scoreresult(
    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_scoreresult_rec         IN    scoreresult_rec_type,
    x_object_version_number   OUT  NUMBER
)
IS
   L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Scoreresult';

Line: 176

      SAVEPOINT UPDATE_Scoreresult_PUB;

Line: 213

      AMS_Scoreresult_PVT.Update_Scoreresult(
         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_scoreresult_rec    => l_pvt_scoreresult_rec,
         x_object_version_number => l_object_version_number
      );

Line: 255

     ROLLBACK TO UPDATE_Scoreresult_PUB;

Line: 265

     ROLLBACK TO UPDATE_Scoreresult_PUB;

Line: 275

     ROLLBACK TO UPDATE_Scoreresult_PUB;

Line: 287

End Update_Scoreresult;

Line: 290

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

Line: 305

      SAVEPOINT DELETE_Scoreresult_PUB;

Line: 332

      AMS_Scoreresult_PVT.Delete_Scoreresult(
         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_score_result_id   => p_score_result_id,
         p_object_version_number   => p_object_version_number
      );

Line: 374

     ROLLBACK TO DELETE_Scoreresult_PUB;

Line: 384

     ROLLBACK TO DELETE_Scoreresult_PUB;

Line: 394

     ROLLBACK TO DELETE_Scoreresult_PUB;

Line: 406

End Delete_Scoreresult;

Line: 538

      SELECT ams_dm_score_results_s.NEXTVAL
      FROM   dual;

Line: 542

      SELECT 1
      FROM   dual
      WHERE  EXISTS (SELECT 1
                     FROM   ams_dm_score_results
                     WHERE  score_result_id = p_result_id)
      ;

Line: 596

   ams_dm_score_results_pkg.insert_row (
      PX_SCORE_RESULT_ID         => l_score_result_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_SCORE_ID                 => p_score_id,
      P_DECILE                   => NULL, -- need to add when needed
      P_NUM_RECORDS              => p_num_records,
      P_SCORE                    => p_score,
      P_CONFIDENCE               => p_confidence
   );