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

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

Line: 54


      SELECT AMS_VENUE_RATES_B_s.NEXTVAL
      FROM dual;

Line: 58


      SELECT 1
      FROM AMS_VENUE_RATES_B
      WHERE RATE_ID = l_id;

Line: 161


      AMS_VENUE_RATES_B_PKG.Insert_Row(
          px_rate_id  => l_rate_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_active_flag  => p_venue_rates_rec.active_flag,
          p_venue_id  => p_venue_rates_rec.venue_id,
          p_metric_id  => p_venue_rates_rec.metric_id,
          p_transactional_value  => p_venue_rates_rec.transactional_value,
          p_transactional_currency_code  => p_venue_rates_rec.transactional_currency_code,
          p_functional_value  => l_venue_rates_rec.functional_value,
          p_functional_currency_code  => l_venue_rates_rec.functional_currency_code,
          p_uom_code  => p_venue_rates_rec.uom_code,
          p_rate_code => p_venue_rates_rec.rate_code,
          p_attribute_category  => p_venue_rates_rec.attribute_category,
          p_attribute1  => p_venue_rates_rec.attribute1,
          p_attribute2  => p_venue_rates_rec.attribute2,
          p_attribute3  => p_venue_rates_rec.attribute3,
          p_attribute4  => p_venue_rates_rec.attribute4,
          p_attribute5  => p_venue_rates_rec.attribute5,
          p_attribute6  => p_venue_rates_rec.attribute6,
          p_attribute7  => p_venue_rates_rec.attribute7,
          p_attribute8  => p_venue_rates_rec.attribute8,
          p_attribute9  => p_venue_rates_rec.attribute9,
          p_attribute10  => p_venue_rates_rec.attribute10,
          p_attribute11  => p_venue_rates_rec.attribute11,
          p_attribute12  => p_venue_rates_rec.attribute12,
          p_attribute13  => p_venue_rates_rec.attribute13,
          p_attribute14  => p_venue_rates_rec.attribute14,
          p_attribute15  => p_venue_rates_rec.attribute15,
	  p_description  => p_venue_rates_rec.description);

Line: 264


PROCEDURE Update_Venue_Rates(
    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_venue_rates_rec               IN    venue_rates_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS

CURSOR c_get_venue_rates(rate_id NUMBER) IS
    SELECT *
    FROM  AMS_VENUE_RATES_B;

Line: 285


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

Line: 296


      SAVEPOINT UPDATE_Venue_Rates_PVT;

Line: 326


          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  => 'Venue_Rates') ;

Line: 353


 p_token_value  => 'Last_Update_Date') ;

Line: 376


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

Line: 391


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

Line: 395


      AMS_VENUE_RATES_B_PKG.Update_Row(
          p_rate_id  => p_venue_rates_rec.rate_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  => p_venue_rates_rec.object_version_number,
          p_active_flag  => p_venue_rates_rec.active_flag,
          p_venue_id  => p_venue_rates_rec.venue_id,
          p_metric_id  => p_venue_rates_rec.metric_id,
          p_transactional_value  => p_venue_rates_rec.transactional_value,
          p_transactional_currency_code  => p_venue_rates_rec.transactional_currency_code,
          p_functional_value  => p_venue_rates_rec.functional_value,
          p_functional_currency_code  => p_venue_rates_rec.functional_currency_code,
          p_uom_code  => p_venue_rates_rec.uom_code,
          p_rate_code => p_venue_rates_rec.rate_code,
          p_attribute_category  => p_venue_rates_rec.attribute_category,
          p_attribute1  => p_venue_rates_rec.attribute1,
          p_attribute2  => p_venue_rates_rec.attribute2,
          p_attribute3  => p_venue_rates_rec.attribute3,
          p_attribute4  => p_venue_rates_rec.attribute4,
          p_attribute5  => p_venue_rates_rec.attribute5,
          p_attribute6  => p_venue_rates_rec.attribute6,
          p_attribute7  => p_venue_rates_rec.attribute7,
          p_attribute8  => p_venue_rates_rec.attribute8,
          p_attribute9  => p_venue_rates_rec.attribute9,
          p_attribute10  => p_venue_rates_rec.attribute10,
          p_attribute11  => p_venue_rates_rec.attribute11,
          p_attribute12  => p_venue_rates_rec.attribute12,
          p_attribute13  => p_venue_rates_rec.attribute13,
          p_attribute14  => p_venue_rates_rec.attribute14,
          p_attribute15  => p_venue_rates_rec.attribute15,
          p_description  => p_venue_rates_rec.description);

Line: 461


     ROLLBACK TO UPDATE_Venue_Rates_PVT;

Line: 471


     ROLLBACK TO UPDATE_Venue_Rates_PVT;

Line: 481


     ROLLBACK TO UPDATE_Venue_Rates_PVT;

Line: 493


End Update_Venue_Rates;

Line: 496


PROCEDURE Delete_Venue_Rates(
    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_rate_id                    IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 515


      SAVEPOINT DELETE_Venue_Rates_PVT;

Line: 548


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

Line: 552


      AMS_VENUE_RATES_B_PKG.Delete_Row(
          p_RATE_ID  => p_RATE_ID);

Line: 583


     ROLLBACK TO DELETE_Venue_Rates_PVT;

Line: 593


     ROLLBACK TO DELETE_Venue_Rates_PVT;

Line: 603


     ROLLBACK TO DELETE_Venue_Rates_PVT;

Line: 615


End Delete_Venue_Rates;

Line: 639


   SELECT RATE_ID
   FROM AMS_VENUE_RATES_B
   WHERE RATE_ID = p_RATE_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 801


      IF p_venue_rates_rec.last_update_date = FND_API.g_miss_date OR p_venue_rates_rec.last_update_date IS NULL THEN
         FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

Line: 803


         FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');

Line: 810


      IF p_venue_rates_rec.last_updated_by = FND_API.g_miss_num OR p_venue_rates_rec.last_updated_by IS NULL THEN
         FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

Line: 812


         FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');

Line: 900


      IF p_venue_rates_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_last_update_date');

Line: 907


      IF p_venue_rates_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_last_updated_by');

Line: 1081


      SELECT *
      FROM ams_venue_rates_b
      WHERE rate_id = p_venue_rates_rec.rate_id;

Line: 1099


   IF p_venue_rates_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_venue_rates_rec.last_update_date;

Line: 1104


   IF p_venue_rates_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_venue_rates_rec.last_updated_by;

Line: 1119


   IF p_venue_rates_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_venue_rates_rec.last_update_login;