The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Preferred_Language
(
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 NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_pref_lang_id IN NUMBER,
p_object_version_number IN NUMBER,
p_resp_appl_id IN NUMBER := NULL,
p_resp_id IN NUMBER := NULL,
p_user_id IN NUMBER ,
p_login_id IN NUMBER := NULL,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER :=NULL,
p_last_update_date IN DATE,
p_preferred_language_rec IN CS_SR_Preferred_Lang_PVT.preferred_language_rec_type
)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Preferred_Language';
l_user_id NUMBER := p_last_updated_by;
l_login_id NUMBER := p_last_update_login;
SAVEPOINT Update_Preferred_Language_PUB;
CS_SR_Preferred_Lang_PVT.Update_Preferred_Language
( p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
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_pref_lang_id => p_pref_lang_id,
p_object_version_number => p_object_version_number,
p_resp_appl_id => p_resp_appl_id,
p_resp_id => p_resp_id,
p_user_id => p_user_id,
p_login_id => p_login_id,
p_last_updated_by => l_user_id,
p_last_update_login => l_login_id,
p_last_update_date => p_last_update_date,
p_preferred_language_rec => l_preferred_language_rec
);
ROLLBACK TO Update_Preferred_Language_PUB;
ROLLBACK TO Update_Preferred_Language_PUB;
ROLLBACK TO Update_Preferred_Language_PUB;
END Update_Preferred_Language;