The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
);
FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
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
);
FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
OPEN x_msite_csr FOR SELECT msite_id, msite_name
FROM ibe_msites_vl
WHERE msite_id = p_msite_id and site_type = 'I';
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;
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;