APPS.IBE_MSITE_INFORMATION_MGR_PVT SQL Statements

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

Line: 169

      Ibe_Msite_Information_Pvt.Update_Msite_Information
        (
        p_api_version                     => p_api_version,
        p_init_msg_list                   => FND_API.G_FALSE,
        p_commit                          => FND_API.G_FALSE,
        p_validation_level                => p_validation_level,
        p_msite_information_id            => p_msite_information_ids(i),
        p_object_version_number           => p_object_version_numbers(i),
        p_msite_information1              => p_msite_informations1(i),
        p_msite_information2              => p_msite_informations2(i),
        p_msite_information3              => p_msite_informations3(i),
        p_msite_information4              => p_msite_informations4(i),
        p_msite_information5              => p_msite_informations5(i),
        p_msite_information6              => p_msite_informations6(i),
        p_msite_information7              => p_msite_informations7(i),
        p_msite_information8              => p_msite_informations8(i),
        p_msite_information9              => p_msite_informations9(i),
        p_msite_information10             => p_msite_informations10(i),
        p_msite_information11             => p_msite_informations11(i),
        p_msite_information12             => p_msite_informations12(i),
        p_msite_information13             => p_msite_informations13(i),
        p_msite_information14             => p_msite_informations14(i),
        p_msite_information15             => p_msite_informations15(i),
        p_msite_information16             => p_msite_informations16(i),
        p_msite_information17             => p_msite_informations17(i),
        p_msite_information18             => p_msite_informations18(i),
        p_msite_information19             => p_msite_informations19(i),
        p_msite_information20             => p_msite_informations20(i),
        p_attribute_category              => p_attribute_categorys(i),
        p_attribute1                      => p_attributes1(i),
        p_attribute2                      => p_attributes2(i),
        p_attribute3                      => p_attributes3(i),
        p_attribute4                      => p_attributes4(i),
        p_attribute5                      => p_attributes5(i),
        p_attribute6                      => p_attributes6(i),
        p_attribute7                      => p_attributes7(i),
        p_attribute8                      => p_attributes8(i),
        p_attribute9                      => p_attributes9(i),
        p_attribute10                     => p_attributes10(i),
        p_attribute11                     => p_attributes11(i),
        p_attribute12                     => p_attributes12(i),
        p_attribute13                     => p_attributes13(i),
        p_attribute14                     => p_attributes14(i),
        p_attribute15                     => p_attributes15(i),
        x_return_status                   => x_msite_info_return_statuses(i),
        x_msg_count                       => x_msg_count,
        x_msg_data                        => x_msg_data
        );

Line: 219

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

Line: 223

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

Line: 232

      Ibe_Msite_Information_Pvt.Delete_Msite_Information
        (
        p_api_version                  => p_api_version,
        p_init_msg_list                => FND_API.G_FALSE,
        p_commit                       => FND_API.G_FALSE,
        p_validation_level             => p_validation_level,
        p_msite_information_id         => p_msite_information_ids(i),
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data
        );

Line: 245

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

Line: 249

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

Line: 350

  OPEN x_msite_csr FOR SELECT msite_id, msite_name
    FROM ibe_msites_vl
    WHERE msite_id = p_msite_id and site_type = 'I';

Line: 355

  OPEN x_msite_information_csr FOR SELECT msite_information_id,
    object_version_number, msite_id, msite_information_context,
    msite_information1, msite_information2, msite_information3,
    msite_information4, msite_information5, msite_information6,
    msite_information7, msite_information8, msite_information9,
    msite_information10, msite_information11, msite_information12,
    msite_information13, msite_information14, msite_information15,
    msite_information16, msite_information17, msite_information18,
    msite_information19, msite_information20, attribute_category, attribute1,
    attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
    attribute8, attribute9, attribute10, attribute11, attribute12,
    attribute13, attribute14, attribute15
    FROM ibe_msite_information
    WHERE msite_id = p_msite_id
    AND msite_information_context = p_msite_information_context;

Line: 501

  SELECT MSITE_INFORMATION_CONTEXT, MSITE_INFORMATION1, MSITE_INFORMATION2,
    MSITE_INFORMATION3, MSITE_INFORMATION4, MSITE_INFORMATION5,
    MSITE_INFORMATION6, MSITE_INFORMATION7, MSITE_INFORMATION8,
    MSITE_INFORMATION9, MSITE_INFORMATION10, MSITE_INFORMATION11,
    MSITE_INFORMATION12, MSITE_INFORMATION13, MSITE_INFORMATION14,
    MSITE_INFORMATION15, MSITE_INFORMATION16, MSITE_INFORMATION17,
    MSITE_INFORMATION18, MSITE_INFORMATION19, MSITE_INFORMATION20,
    ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
    ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7,
    ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
    ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
   FROM IBE_MSITE_INFORMATION
  WHERE MSITE_ID = c_msite_id;