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

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

Line: 194


      select CS_SR_PREFERRED_LANG_S.nextval
      into l_key_val
      from dual;

Line: 222


      select 'x' into l_dummy
      from fnd_languages
      where language_code = l_preferred_language_rec.language_code;

Line: 240


      select 'x' into l_dummy
      from CS_SR_PREFERRED_LANG
      where language_code = l_preferred_language_rec.language_code;

Line: 402


CS_SR_PREFERRED_LANG_PKG.INSERT_ROW (
  X_ROWID              => l_preferred_language_rec.row_id,
  X_PREF_LANG_ID       => l_preferred_language_rec.pref_lang_id,
  X_LANGUAGE_CODE      => l_preferred_language_rec.language_code,
  X_START_DATE_ACTIVE  => l_preferred_language_rec.start_date_active,
  X_END_DATE_ACTIVE    => l_preferred_language_rec.end_date_active,
  X_ATTRIBUTE_CATEGORY => l_preferred_language_rec.attribute_category,
  X_ATTRIBUTE1         => l_preferred_language_rec.attribute1,
  X_ATTRIBUTE2         => l_preferred_language_rec.attribute2,
  X_ATTRIBUTE3         => l_preferred_language_rec.attribute3,
  X_ATTRIBUTE4         => l_preferred_language_rec.attribute4,
  X_ATTRIBUTE5         => l_preferred_language_rec.attribute5,
  X_ATTRIBUTE6         => l_preferred_language_rec.attribute6,
  X_ATTRIBUTE7         => l_preferred_language_rec.attribute7,
  X_ATTRIBUTE8         => l_preferred_language_rec.attribute8,
  X_ATTRIBUTE9         => l_preferred_language_rec.attribute9,
  X_ATTRIBUTE10        => l_preferred_language_rec.attribute10,
  X_ATTRIBUTE11        => l_preferred_language_rec.attribute11,
  X_ATTRIBUTE12        => l_preferred_language_rec.attribute12,
  X_ATTRIBUTE13        => l_preferred_language_rec.attribute13,
  X_ATTRIBUTE14        => l_preferred_language_rec.attribute14,
  X_ATTRIBUTE15        => l_preferred_language_rec.attribute15,
  X_OBJECT_VERSION_NUMBER => l_preferred_language_rec.object_version_number,
  X_CREATION_DATE      => sysdate,
  X_CREATED_BY         => p_user_id,
  X_LAST_UPDATE_DATE   => sysdate,
  X_LAST_UPDATED_BY    => p_user_id,
  X_LAST_UPDATE_LOGIN  => p_login_id);

Line: 588


PROCEDURE Update_Preferred_Language
  ( p_api_version	    IN	NUMBER,
    p_init_msg_list	    IN	VARCHAR2 DEFAULT fnd_api.g_false,
    p_commit		    IN	VARCHAR2 DEFAULT fnd_api.g_false,
    p_validation_level	    IN	NUMBER   DEFAULT fnd_api.g_valid_level_full,
    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   DEFAULT NULL,
    p_resp_id		    IN	NUMBER   DEFAULT NULL,
    p_user_id               IN  NUMBER,
    p_login_id              IN  NUMBER   DEFAULT NULL,
    p_last_updated_by	    IN	NUMBER,
    p_last_update_login	    IN	NUMBER   DEFAULT NULL,
    p_last_update_date	    IN	DATE,
    p_preferred_language_rec IN  preferred_language_rec_type
    )
  IS
     l_api_name                   CONSTANT VARCHAR2(30)    := 'Update_Preferred_Language';

Line: 620


       SELECT *
       FROM   cs_sr_preferred_lang
       WHERE  pref_lang_id = p_id
       AND    object_version_number = p_obj_num
       FOR UPDATE OF pref_lang_id;

Line: 634


  SAVEPOINT Update_Preferred_Language_PVT;

Line: 701


                                      'Update_ServiceRequest',
                                      'B', 'C')  THEN

    cs_servicerequest_cuhk.Update_ServiceRequest_Pre(p_request_id => p_request_id,
                                                     p_service_request_rec=>l_service_request_rec,
                                                     x_return_status=>l_return_status);

Line: 709


    cs_servicerequest_cuhk.Update_ServiceRequest_Pre
  ( p_api_version         => l_api_version,
    p_init_msg_list       => p_init_msg_list,
    p_commit              => p_commit,
    p_validation_level      =>  p_validation_level,
    x_return_status         =>  l_return_status,
    x_msg_count             =>  x_msg_count,
    x_msg_data              =>  x_msg_data,
    p_request_id            =>   p_request_id ,
    p_object_version_number  =>  p_object_version_number,
    p_resp_appl_id           =>  p_resp_appl_id,
    p_resp_id                =>  p_resp_id,
    p_last_updated_by        =>  p_last_updated_by,
    p_last_update_login      =>  p_last_update_login,
    p_last_update_date       =>  p_last_update_date,
    p_service_request_rec    =>  l_service_request_rec);

Line: 742


                                      'Update_ServiceRequest',
                                      'B', 'V')  THEN


    cs_servicerequest_vuhk.Update_ServiceRequest_Pre(p_request_id => p_request_id,
                                                     p_service_request_rec=>l_service_request_rec,
                                                     x_return_status=>l_return_status);

Line: 750


    cs_servicerequest_vuhk.Update_ServiceRequest_Pre
  ( p_api_version         => l_api_version,
    p_init_msg_list       => p_init_msg_list,
    p_commit              => p_commit,
    p_validation_level      =>  p_validation_level,
    x_return_status         =>  l_return_status,
    x_msg_count             =>  x_msg_count,
    x_msg_data              =>  x_msg_data,
    p_request_id            =>   p_request_id ,
    p_object_version_number  =>  p_object_version_number,
    p_resp_appl_id           =>  p_resp_appl_id,
    p_resp_id                =>  p_resp_id,
    p_last_updated_by        =>  p_last_updated_by,
    p_last_update_login      =>  p_last_update_login,
    p_last_update_date       =>  p_last_update_date,
    p_service_request_rec    =>  l_service_request_rec);

Line: 789


                                      'Update_ServiceRequest',
                                      'B', 'I')  THEN


 --  cs_servicerequest_iuhk.Update_ServiceRequest_Pre(x_return_status=>l_return_status);

Line: 797


									  p_api_name  => 'Update_ServiceRequest'
									  p_processing_type => 'B',
                                               x_return_status=>l_return_status);

Line: 828


      select 'x' into l_dummy
      from fnd_languages
      where language_code = l_preferred_language_rec.language_code;

Line: 846


      select 'x' into l_dummy
      from CS_SR_PREFERRED_LANG
      where language_code = l_preferred_language_rec.language_code
      and   pref_lang_id  <> p_pref_lang_id;

Line: 1035


CS_SR_PREFERRED_LANG_PKG.UPDATE_ROW (
  X_PREF_LANG_ID       => l_preferred_language_rec.pref_lang_id,
  X_LANGUAGE_CODE      => l_preferred_language_rec.language_code,
  X_START_DATE_ACTIVE  => l_preferred_language_rec.start_date_active,
  X_END_DATE_ACTIVE    => l_preferred_language_rec.end_date_active,
  X_ATTRIBUTE_CATEGORY => l_preferred_language_rec.attribute_category,
  X_ATTRIBUTE1         => l_preferred_language_rec.attribute1,
  X_ATTRIBUTE2         => l_preferred_language_rec.attribute2,
  X_ATTRIBUTE3         => l_preferred_language_rec.attribute3,
  X_ATTRIBUTE4         => l_preferred_language_rec.attribute4,
  X_ATTRIBUTE5         => l_preferred_language_rec.attribute5,
  X_ATTRIBUTE6         => l_preferred_language_rec.attribute6,
  X_ATTRIBUTE7         => l_preferred_language_rec.attribute7,
  X_ATTRIBUTE8         => l_preferred_language_rec.attribute8,
  X_ATTRIBUTE9         => l_preferred_language_rec.attribute9,
  X_ATTRIBUTE10        => l_preferred_language_rec.attribute10,
  X_ATTRIBUTE11        => l_preferred_language_rec.attribute11,
  X_ATTRIBUTE12        => l_preferred_language_rec.attribute12,
  X_ATTRIBUTE13        => l_preferred_language_rec.attribute13,
  X_ATTRIBUTE14        => l_preferred_language_rec.attribute14,
  X_ATTRIBUTE15        => l_preferred_language_rec.attribute15,
  X_OBJECT_VERSION_NUMBER => p_object_version_number + 1,
  X_LAST_UPDATE_DATE   => sysdate,
  X_LAST_UPDATED_BY    => p_last_updated_by,
  X_LAST_UPDATE_LOGIN  => p_last_update_login);

Line: 1072


                                      'Update_ServiceRequest',
                                      'A', 'C')  THEN

    cs_servicerequest_cuhk.Update_ServiceRequest_Post( p_request_id  => p_request_id,
                                                      p_service_request_rec=>l_service_request_rec,
                                                     x_return_status=>l_return_status);

Line: 1080


    cs_servicerequest_cuhk.Update_ServiceRequest_Post
    ( p_api_version         => l_api_version,
      p_init_msg_list       => p_init_msg_list,
      p_commit              => p_commit,
    p_validation_level      =>  p_validation_level,
    x_return_status         =>  l_return_status,
    x_msg_count             =>  x_msg_count,
    x_msg_data              =>  x_msg_data,
    p_request_id            =>   p_request_id ,
    p_object_version_number  =>  p_object_version_number,
    p_resp_appl_id           =>  p_resp_appl_id,
    p_resp_id                =>  p_resp_id,
    p_last_updated_by        =>  p_last_updated_by,
    p_last_update_login      =>  p_last_update_login,
    p_last_update_date       =>  p_last_update_date,
    p_service_request_rec    =>  l_service_request_rec);

Line: 1113


                                      'Update_ServiceRequest',
                                      'A', 'V')  THEN


    cs_servicerequest_vuhk.Update_ServiceRequest_Post( p_request_id  => p_request_id,

                                                      p_service_request_rec=>l_service_request_rec,
                                                     x_return_status=>l_return_status);

Line: 1123


    cs_servicerequest_vuhk.Update_ServiceRequest_Post
    ( p_api_version         => l_api_version,
      p_init_msg_list       => p_init_msg_list,
      p_commit              => p_commit,
    p_validation_level      =>  p_validation_level,
    x_return_status         =>  l_return_status,
    x_msg_count             =>  x_msg_count,
    x_msg_data              =>  x_msg_data,
    p_request_id            =>   p_request_id ,
    p_object_version_number  =>  p_object_version_number,
    p_resp_appl_id           =>  p_resp_appl_id,
    p_resp_id                =>  p_resp_id,
    p_last_updated_by        =>  p_last_updated_by,
    p_last_update_login      =>  p_last_update_login,
    p_last_update_date       =>  p_last_update_date,
    p_service_request_rec    =>  l_service_request_rec);

Line: 1155


                                      'Update_ServiceRequest',
                                      'A', 'I')  THEN

 --   cs_servicerequest_iuhk.Update_ServiceRequest_Post( x_return_status=>l_return_status);

Line: 1163


                                                                          p_api_name  => 'Update_ServiceRequest'
                                                                          p_processing_type => 'A',
                                               x_return_status=>l_return_status)
;

Line: 1221


                                      'Update_ServiceRequest',
                                      'A', 'C')  THEN



    cs_servicerequest_cuhk.Update_ServiceRequest_Post( p_request_id  => p_request_id,
                                                      p_service_request_rec=>l_service_request_rec,
                                                     x_return_status=>l_return_status);

Line: 1231


    cs_servicerequest_cuhk.Update_ServiceRequest_Post
    ( p_api_version         => l_api_version,
      p_init_msg_list       => p_init_msg_list,
      p_commit              => p_commit,
    p_validation_level      =>  p_validation_level,
    x_return_status         =>  l_return_status,
    x_msg_count             =>  x_msg_count,
    x_msg_data              =>  x_msg_data,
    p_request_id            =>   p_request_id ,
    p_object_version_number  =>  p_object_version_number,
    p_resp_appl_id           =>  p_resp_appl_id,
    p_resp_id                =>  p_resp_id,
    p_last_updated_by        =>  p_last_updated_by,
    p_last_update_login      =>  p_last_update_login,
    p_last_update_date       =>  p_last_update_date,
    p_service_request_rec    =>  l_service_request_rec);

Line: 1262


                                      'Update_ServiceRequest',
                                      'A', 'V')  THEN


    cs_servicerequest_vuhk.Update_ServiceRequest_Post( p_request_id  => p_request_id,
                                                      p_service_request_rec=>l_service_request_rec,
                                                     x_return_status=>l_return_status);

Line: 1271


    cs_servicerequest_vuhk.Update_ServiceRequest_Post
    ( p_api_version         => l_api_version,
      p_init_msg_list       => p_init_msg_list,
      p_commit              => p_commit,
    p_validation_level      =>  p_validation_level,
    x_return_status         =>  l_return_status,
    x_msg_count             =>  x_msg_count,
    x_msg_data              =>  x_msg_data,
    p_request_id            =>   p_request_id ,
    p_object_version_number  =>  p_object_version_number,
    p_resp_appl_id           =>  p_resp_appl_id,
    p_resp_id                =>  p_resp_id,
    p_last_updated_by        =>  p_last_updated_by,
    p_last_update_login      =>  p_last_update_login,
    p_last_update_date       =>  p_last_update_date,
    p_service_request_rec    =>  l_service_request_rec);

Line: 1303


                                      'Update_ServiceRequest',
                                      'A', 'I')  THEN


 --   cs_servicerequest_iuhk.Update_ServiceRequest_Post( x_return_status=>l_return_status);

Line: 1312


									  p_api_name  => 'Update_ServiceRequest'
									  p_processing_type => 'A',
                                               x_return_status=>l_return_status);

Line: 1378


    ROLLBACK TO Update_Preferred_Language_PVT;

Line: 1389


    ROLLBACK TO Update_Preferred_Language_PVT;

Line: 1400


    ROLLBACK TO Update_Preferred_Language_PVT;

Line: 1414


END Update_Preferred_Language;

Line: 1428


  p_preferred_lang_record.LAST_UPDATE_DATE       := FND_API.G_MISS_DATE;

Line: 1429


  p_preferred_lang_record.LAST_UPDATED_BY        := FND_API.G_MISS_NUM;

Line: 1432


  p_preferred_lang_record.LAST_UPDATE_LOGIN      := FND_API.G_MISS_NUM;