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

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

Line: 54


Procedure update_dml
  (p_rec in out nocopy per_cnl_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 70


  update per_ri_config_locations
    set
     configuration_code              = p_rec.configuration_code
    ,configuration_context           = p_rec.configuration_context
    ,location_id                     = p_rec.location_id
    ,location_code                   = p_rec.location_code
    ,description                     = p_rec.description
    ,style                           = p_rec.style
    ,address_line_1                  = p_rec.address_line_1
    ,address_line_2                  = p_rec.address_line_2
    ,address_line_3                  = p_rec.address_line_3
    ,town_or_city                    = p_rec.town_or_city
    ,country                         = p_rec.country
    ,postal_code                     = p_rec.postal_code
    ,region_1                        = p_rec.region_1
    ,region_2                        = p_rec.region_2
    ,region_3                        = p_rec.region_3
    ,telephone_number_1              = p_rec.telephone_number_1
    ,telephone_number_2              = p_rec.telephone_number_2
    ,telephone_number_3              = p_rec.telephone_number_3
    ,loc_information13               = p_rec.loc_information13
    ,loc_information14               = p_rec.loc_information14
    ,loc_information15               = p_rec.loc_information15
    ,loc_information16               = p_rec.loc_information16
    ,loc_information17               = p_rec.loc_information17
    ,loc_information18               = p_rec.loc_information18
    ,loc_information19               = p_rec.loc_information19
    ,loc_information20               = p_rec.loc_information20
    ,object_version_number           = p_rec.object_version_number
    where location_id = p_rec.location_id;

Line: 124


End update_dml;

Line: 158


Procedure pre_update
  (p_rec in per_cnl_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 168


End pre_update;

Line: 202


Procedure post_update
  (p_effective_date               in date
  ,p_rec                          in per_cnl_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 213


    per_cnl_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_configuration_code          => p_rec.configuration_code
      ,p_configuration_context       => p_rec.configuration_context
      ,p_location_id                 => p_rec.location_id
      ,p_location_code               => p_rec.location_code
      ,p_description                 => p_rec.description
      ,p_style                       => p_rec.style
      ,p_address_line_1              => p_rec.address_line_1
      ,p_address_line_2              => p_rec.address_line_2
      ,p_address_line_3              => p_rec.address_line_3
      ,p_town_or_city                => p_rec.town_or_city
      ,p_country                     => p_rec.country
      ,p_postal_code                 => p_rec.postal_code
      ,p_region_1                    => p_rec.region_1
      ,p_region_2                    => p_rec.region_2
      ,p_region_3                    => p_rec.region_3
      ,p_telephone_number_1          => p_rec.telephone_number_1
      ,p_telephone_number_2          => p_rec.telephone_number_2
      ,p_telephone_number_3          => p_rec.telephone_number_3
      ,p_loc_information13           => p_rec.loc_information13
      ,p_loc_information14           => p_rec.loc_information14
      ,p_loc_information15           => p_rec.loc_information15
      ,p_loc_information16           => p_rec.loc_information16
      ,p_loc_information17           => p_rec.loc_information17
      ,p_loc_information18           => p_rec.loc_information18
      ,p_loc_information19           => p_rec.loc_information19
      ,p_loc_information20           => p_rec.loc_information20
      ,p_object_version_number       => p_rec.object_version_number
      ,p_configuration_code_o        => per_cnl_shd.g_old_rec.configuration_code
      ,p_configuration_context_o     => per_cnl_shd.g_old_rec.configuration_context
      ,p_location_code_o             => per_cnl_shd.g_old_rec.location_code
      ,p_description_o               => per_cnl_shd.g_old_rec.description
      ,p_style_o                     => per_cnl_shd.g_old_rec.style
      ,p_address_line_1_o            => per_cnl_shd.g_old_rec.address_line_1
      ,p_address_line_2_o            => per_cnl_shd.g_old_rec.address_line_2
      ,p_address_line_3_o            => per_cnl_shd.g_old_rec.address_line_3
      ,p_town_or_city_o              => per_cnl_shd.g_old_rec.town_or_city
      ,p_country_o                   => per_cnl_shd.g_old_rec.country
      ,p_postal_code_o               => per_cnl_shd.g_old_rec.postal_code
      ,p_region_1_o                  => per_cnl_shd.g_old_rec.region_1
      ,p_region_2_o                  => per_cnl_shd.g_old_rec.region_2
      ,p_region_3_o                  => per_cnl_shd.g_old_rec.region_3
      ,p_telephone_number_1_o        => per_cnl_shd.g_old_rec.telephone_number_1
      ,p_telephone_number_2_o        => per_cnl_shd.g_old_rec.telephone_number_2
      ,p_telephone_number_3_o        => per_cnl_shd.g_old_rec.telephone_number_3
      ,p_loc_information13_o         => per_cnl_shd.g_old_rec.loc_information13
      ,p_loc_information14_o         => per_cnl_shd.g_old_rec.loc_information14
      ,p_loc_information15_o         => per_cnl_shd.g_old_rec.loc_information15
      ,p_loc_information16_o         => per_cnl_shd.g_old_rec.loc_information16
      ,p_loc_information17_o         => per_cnl_shd.g_old_rec.loc_information17
      ,p_loc_information18_o         => per_cnl_shd.g_old_rec.loc_information18
      ,p_loc_information19_o         => per_cnl_shd.g_old_rec.loc_information19
      ,p_loc_information20_o         => per_cnl_shd.g_old_rec.loc_information20
      ,p_object_version_number_o     => per_cnl_shd.g_old_rec.object_version_number
      );

Line: 281


End post_update;

Line: 467


  per_cnl_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 477


  per_cnl_upd.pre_update(p_rec);

Line: 481


  per_cnl_upd.update_dml(p_rec);

Line: 485


  per_cnl_upd.post_update
     (p_effective_date
     ,p_rec
     );