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.IBE_MSITE_INFORMATION_PVT SQL Statements

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

Line: 28


  IS SELECT msite_id FROM ibe_msites_b
    WHERE msite_id = l_c_msite_id
    AND master_msite_flag = 'N' and site_type = 'I';

Line: 100


  IS SELECT 1 FROM fnd_lookups
    WHERE lookup_type = 'IBE_PAYMENT_TYPE'
    AND lookup_code = l_c_payment_method_code
    AND enabled_flag = 'Y'
    AND (sysdate BETWEEN NVL(start_date_active, sysdate)
    AND NVL(end_date_active, sysdate));

Line: 175


  IS SELECT 1 FROM iby_creditcard_issuers_v
    WHERE card_issuer_code = l_c_credit_card_code;

Line: 245


  IS SELECT 1 FROM oe_ship_methods_v
    WHERE lookup_type = 'SHIP_METHOD'
    AND lookup_code = l_c_shipment_method_code
    AND enabled_flag = 'Y'
    AND (sysdate BETWEEN NVL(start_date_active, sysdate)
    AND NVL(end_date_active, sysdate));

Line: 345


  IS SELECT 1 FROM ibe_msite_information
    WHERE msite_information_context = 'PMT_MTHD'
    AND msite_information1 = l_c_msite_information1
    AND msite_id = l_c_msite_id;

Line: 351


  IS SELECT 1 FROM ibe_msite_information
    WHERE msite_information_context = 'CC_TYPE'
    AND msite_information1 = l_c_msite_information1
    AND msite_id = l_c_msite_id;

Line: 357


  IS SELECT 1 FROM ibe_msite_information
    WHERE msite_information_context = 'SHPMT_MTHD'
    AND msite_information1 = l_c_msite_information1
    AND msite_id = l_c_msite_id;

Line: 724


PROCEDURE Validate_Update
  (
   p_init_msg_list                  IN VARCHAR2 := FND_API.G_FALSE,
   p_validation_level               IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
   p_msite_information_id           IN NUMBER,
   p_object_version_number          IN NUMBER,
   p_msite_information1             IN VARCHAR2,
   p_msite_information2             IN VARCHAR2,
   p_msite_information3             IN VARCHAR2,
   p_msite_information4             IN VARCHAR2,
   p_msite_information5             IN VARCHAR2,
   p_msite_information6             IN VARCHAR2,
   p_msite_information7             IN VARCHAR2,
   p_msite_information8             IN VARCHAR2,
   p_msite_information9             IN VARCHAR2,
   p_msite_information10            IN VARCHAR2,
   p_msite_information11            IN VARCHAR2,
   p_msite_information12            IN VARCHAR2,
   p_msite_information13            IN VARCHAR2,
   p_msite_information14            IN VARCHAR2,
   p_msite_information15            IN VARCHAR2,
   p_msite_information16            IN VARCHAR2,
   p_msite_information17            IN VARCHAR2,
   p_msite_information18            IN VARCHAR2,
   p_msite_information19            IN VARCHAR2,
   p_msite_information20            IN VARCHAR2,
   p_attribute_category             IN VARCHAR2,
   p_attribute1                     IN VARCHAR2,
   p_attribute2                     IN VARCHAR2,
   p_attribute3                     IN VARCHAR2,
   p_attribute4                     IN VARCHAR2,
   p_attribute5                     IN VARCHAR2,
   p_attribute6                     IN VARCHAR2,
   p_attribute7                     IN VARCHAR2,
   p_attribute8                     IN VARCHAR2,
   p_attribute9                     IN VARCHAR2,
   p_attribute10                    IN VARCHAR2,
   p_attribute11                    IN VARCHAR2,
   p_attribute12                    IN VARCHAR2,
   p_attribute13                    IN VARCHAR2,
   p_attribute14                    IN VARCHAR2,
   p_attribute15                    IN VARCHAR2,
   x_return_status                  OUT NOCOPY VARCHAR2,
   x_msg_count                      OUT NOCOPY NUMBER,
   x_msg_data                       OUT NOCOPY VARCHAR2
  )
IS
  l_api_name              CONSTANT VARCHAR2(30) := 'Validate_Update';

Line: 778


    SELECT msite_information_context, msite_id FROM ibe_msite_information
      WHERE msite_information_id = l_c_msite_information_id;

Line: 945


END Validate_Update;

Line: 1093


    Ibe_Msite_Information_Pkg.insert_row
      (
      p_msite_information_id               => FND_API.G_MISS_NUM,
      p_object_version_number              => l_object_version_number,
      p_msite_id                           => p_msite_id,
      p_msite_information_context          => p_msite_information_context,
      p_msite_information1                 => p_msite_information1,
      p_msite_information2                 => p_msite_information2,
      p_msite_information3                 => p_msite_information3,
      p_msite_information4                 => p_msite_information4,
      p_msite_information5                 => p_msite_information5,
      p_msite_information6                 => p_msite_information6,
      p_msite_information7                 => p_msite_information7,
      p_msite_information8                 => p_msite_information8,
      p_msite_information9                 => p_msite_information9,
      p_msite_information10                => p_msite_information10,
      p_msite_information11                => p_msite_information11,
      p_msite_information12                => p_msite_information12,
      p_msite_information13                => p_msite_information13,
      p_msite_information14                => p_msite_information14,
      p_msite_information15                => p_msite_information15,
      p_msite_information16                => p_msite_information16,
      p_msite_information17                => p_msite_information17,
      p_msite_information18                => p_msite_information18,
      p_msite_information19                => p_msite_information19,
      p_msite_information20                => p_msite_information20,
      p_attribute_category                 => p_attribute_category,
      p_attribute1                         => p_attribute1,
      p_attribute2                         => p_attribute2,
      p_attribute3                         => p_attribute3,
      p_attribute4                         => p_attribute4,
      p_attribute5                         => p_attribute5,
      p_attribute6                         => p_attribute6,
      p_attribute7                         => p_attribute7,
      p_attribute8                         => p_attribute8,
      p_attribute9                         => p_attribute9,
      p_attribute10                        => p_attribute10,
      p_attribute11                        => p_attribute11,
      p_attribute12                        => p_attribute12,
      p_attribute13                        => p_attribute13,
      p_attribute14                        => p_attribute14,
      p_attribute15                        => p_attribute15,
      p_creation_date                      => sysdate,
      p_created_by                         => FND_GLOBAL.user_id,
      p_last_update_date                   => sysdate,
      p_last_updated_by                    => FND_GLOBAL.user_id,
      p_last_update_login                  => FND_GLOBAL.login_id,
      x_rowid                              => l_rowid,
      x_msite_information_id               => x_msite_information_id
      );

Line: 1146


       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');

Line: 1156


       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INSERT_FL');

Line: 1211


PROCEDURE Update_Msite_Information
  (
   p_api_version                    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,
   p_msite_information_id           IN NUMBER,
   p_object_version_number          IN NUMBER,
   p_msite_information1             IN VARCHAR2,
   p_msite_information2             IN VARCHAR2,
   p_msite_information3             IN VARCHAR2,
   p_msite_information4             IN VARCHAR2,
   p_msite_information5             IN VARCHAR2,
   p_msite_information6             IN VARCHAR2,
   p_msite_information7             IN VARCHAR2,
   p_msite_information8             IN VARCHAR2,
   p_msite_information9             IN VARCHAR2,
   p_msite_information10            IN VARCHAR2,
   p_msite_information11            IN VARCHAR2,
   p_msite_information12            IN VARCHAR2,
   p_msite_information13            IN VARCHAR2,
   p_msite_information14            IN VARCHAR2,
   p_msite_information15            IN VARCHAR2,
   p_msite_information16            IN VARCHAR2,
   p_msite_information17            IN VARCHAR2,
   p_msite_information18            IN VARCHAR2,
   p_msite_information19            IN VARCHAR2,
   p_msite_information20            IN VARCHAR2,
   p_attribute_category             IN VARCHAR2,
   p_attribute1                     IN VARCHAR2,
   p_attribute2                     IN VARCHAR2,
   p_attribute3                     IN VARCHAR2,
   p_attribute4                     IN VARCHAR2,
   p_attribute5                     IN VARCHAR2,
   p_attribute6                     IN VARCHAR2,
   p_attribute7                     IN VARCHAR2,
   p_attribute8                     IN VARCHAR2,
   p_attribute9                     IN VARCHAR2,
   p_attribute10                    IN VARCHAR2,
   p_attribute11                    IN VARCHAR2,
   p_attribute12                    IN VARCHAR2,
   p_attribute13                    IN VARCHAR2,
   p_attribute14                    IN VARCHAR2,
   p_attribute15                    IN VARCHAR2,
   x_return_status                  OUT NOCOPY VARCHAR2,
   x_msg_count                      OUT NOCOPY NUMBER,
   x_msg_data                       OUT NOCOPY VARCHAR2
  )
IS
  l_api_name          CONSTANT VARCHAR2(30) := 'Update_Msite_Information';

Line: 1266


  SAVEPOINT update_msite_information_pvt;

Line: 1292


  Validate_Update
    (
    p_init_msg_list                  => FND_API.G_FALSE,
    p_validation_level               => p_validation_level,
    p_msite_information_id           => p_msite_information_id,
    p_object_version_number          => p_object_version_number,
    p_msite_information1             => p_msite_information1,
    p_msite_information2             => p_msite_information2,
    p_msite_information3             => p_msite_information3,
    p_msite_information4             => p_msite_information4,
    p_msite_information5             => p_msite_information5,
    p_msite_information6             => p_msite_information6,
    p_msite_information7             => p_msite_information7,
    p_msite_information8             => p_msite_information8,
    p_msite_information9             => p_msite_information9,
    p_msite_information10            => p_msite_information10,
    p_msite_information11            => p_msite_information11,
    p_msite_information12            => p_msite_information12,
    p_msite_information13            => p_msite_information13,
    p_msite_information14            => p_msite_information14,
    p_msite_information15            => p_msite_information15,
    p_msite_information16            => p_msite_information16,
    p_msite_information17            => p_msite_information17,
    p_msite_information18            => p_msite_information18,
    p_msite_information19            => p_msite_information19,
    p_msite_information20            => p_msite_information20,
    p_attribute_category             => p_attribute_category,
    p_attribute1                     => p_attribute1,
    p_attribute2                     => p_attribute2,
    p_attribute3                     => p_attribute3,
    p_attribute4                     => p_attribute4,
    p_attribute5                     => p_attribute5,
    p_attribute6                     => p_attribute6,
    p_attribute7                     => p_attribute7,
    p_attribute8                     => p_attribute8,
    p_attribute9                     => p_attribute9,
    p_attribute10                    => p_attribute10,
    p_attribute11                    => p_attribute11,
    p_attribute12                    => p_attribute12,
    p_attribute13                    => p_attribute13,
    p_attribute14                    => p_attribute14,
    p_attribute15                    => p_attribute15,
    x_return_status                  => x_return_status,
    x_msg_count                      => x_msg_count,
    x_msg_data                       => x_msg_data
    );

Line: 1340


    FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');

Line: 1344


    FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_UPDATE');

Line: 1351


    Ibe_Msite_Information_Pkg.update_row
      (
      p_msite_information_id               => p_msite_information_id,
      p_object_version_number              => p_object_version_number,
      p_msite_information1                 => p_msite_information1,
      p_msite_information2                 => p_msite_information2,
      p_msite_information3                 => p_msite_information3,
      p_msite_information4                 => p_msite_information4,
      p_msite_information5                 => p_msite_information5,
      p_msite_information6                 => p_msite_information6,
      p_msite_information7                 => p_msite_information7,
      p_msite_information8                 => p_msite_information8,
      p_msite_information9                 => p_msite_information9,
      p_msite_information10                => p_msite_information10,
      p_msite_information11                => p_msite_information11,
      p_msite_information12                => p_msite_information12,
      p_msite_information13                => p_msite_information13,
      p_msite_information14                => p_msite_information14,
      p_msite_information15                => p_msite_information15,
      p_msite_information16                => p_msite_information16,
      p_msite_information17                => p_msite_information17,
      p_msite_information18                => p_msite_information18,
      p_msite_information19                => p_msite_information19,
      p_msite_information20                => p_msite_information20,
      p_attribute_category                 => p_attribute_category,
      p_attribute1                         => p_attribute1,
      p_attribute2                         => p_attribute2,
      p_attribute3                         => p_attribute3,
      p_attribute4                         => p_attribute4,
      p_attribute5                         => p_attribute5,
      p_attribute6                         => p_attribute6,
      p_attribute7                         => p_attribute7,
      p_attribute8                         => p_attribute8,
      p_attribute9                         => p_attribute9,
      p_attribute10                        => p_attribute10,
      p_attribute11                        => p_attribute11,
      p_attribute12                        => p_attribute12,
      p_attribute13                        => p_attribute13,
      p_attribute14                        => p_attribute14,
      p_attribute15                        => p_attribute15,
      p_last_update_date                   => sysdate,
      p_last_updated_by                    => FND_GLOBAL.user_id,
      p_last_update_login                  => FND_GLOBAL.login_id
      );

Line: 1398


       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');

Line: 1408


       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_UPDATE_FL');

Line: 1429


     ROLLBACK TO update_msite_information_pvt;

Line: 1436


     ROLLBACK TO update_msite_information_pvt;

Line: 1449


     ROLLBACK TO update_msite_information_pvt;

Line: 1461


END Update_Msite_Information;

Line: 1463


PROCEDURE Delete_Msite_Information
  (
   p_api_version                 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,
   p_msite_information_id        IN NUMBER      := FND_API.G_MISS_NUM,
   x_return_status               OUT NOCOPY VARCHAR2,
   x_msg_count                   OUT NOCOPY NUMBER,
   x_msg_data                    OUT NOCOPY VARCHAR2
  )
IS
  l_api_name          CONSTANT VARCHAR2(30)  := 'Delete_Msite_Information';

Line: 1481


  SAVEPOINT delete_msite_information_pvt;

Line: 1514


    Ibe_Msite_Information_Pkg.delete_row(p_msite_information_id);

Line: 1517


       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');

Line: 1527


       FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_DELETE_FL');

Line: 1548


     ROLLBACK TO delete_msite_information_pvt;

Line: 1555


     ROLLBACK TO delete_msite_information_pvt;

Line: 1568


     ROLLBACK TO delete_msite_information_pvt;

Line: 1580


END Delete_Msite_Information;