APPS.CS_SR_PREFERRED_LANG_PUB SQL Statements

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

Line: 146

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;

Line: 167

  l_api_name	       CONSTANT	VARCHAR2(30)	:= 'Update_Preferred_Language';

Line: 178

  l_user_id			NUMBER		:= p_last_updated_by;

Line: 179

  l_login_id			NUMBER		:= p_last_update_login;

Line: 183

  SAVEPOINT Update_Preferred_Language_PUB;

Line: 199

  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
    );

Line: 239

    ROLLBACK TO Update_Preferred_Language_PUB;

Line: 246

    ROLLBACK TO Update_Preferred_Language_PUB;

Line: 253

    ROLLBACK TO Update_Preferred_Language_PUB;

Line: 263

END Update_Preferred_Language;