APPS.PER_CNL_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into per_ri_config_locations
      (configuration_code
      ,configuration_context
      ,location_id
      ,location_code
      ,description
      ,style
      ,address_line_1
      ,address_line_2
      ,address_line_3
      ,town_or_city
      ,country
      ,postal_code
      ,region_1
      ,region_2
      ,region_3
      ,telephone_number_1
      ,telephone_number_2
      ,telephone_number_3
      ,loc_information13
      ,loc_information14
      ,loc_information15
      ,loc_information16
      ,loc_information17
      ,loc_information18
      ,loc_information19
      ,loc_information20
      ,object_version_number
      )
  Values
    (p_rec.configuration_code
    ,p_rec.configuration_context
    ,p_rec.location_id
    ,p_rec.location_code
    ,p_rec.description
    ,p_rec.style
    ,p_rec.address_line_1
    ,p_rec.address_line_2
    ,p_rec.address_line_3
    ,p_rec.town_or_city
    ,p_rec.country
    ,p_rec.postal_code
    ,p_rec.region_1
    ,p_rec.region_2
    ,p_rec.region_3
    ,p_rec.telephone_number_1
    ,p_rec.telephone_number_2
    ,p_rec.telephone_number_3
    ,p_rec.loc_information13
    ,p_rec.loc_information14
    ,p_rec.loc_information15
    ,p_rec.loc_information16
    ,p_rec.loc_information17
    ,p_rec.loc_information18
    ,p_rec.loc_information19
    ,p_rec.loc_information20
    ,p_rec.object_version_number
    );

Line: 170

End insert_dml;

Line: 209

Procedure pre_insert
  (p_rec  in out nocopy per_cnl_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select per_ri_config_locations_s.nextval from sys.dual;

Line: 216

    Select null
      from per_ri_config_locations
     where location_id =
             per_cnl_ins.g_location_id_i;

Line: 221

  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 262

End pre_insert;

Line: 296

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

Line: 307

    per_cnl_rki.after_insert
      (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
      );

Line: 349

End post_insert;

Line: 366

  per_cnl_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 376

  per_cnl_ins.pre_insert(p_rec);

Line: 380

  per_cnl_ins.insert_dml(p_rec);

Line: 384

  per_cnl_ins.post_insert
     (p_effective_date ,p_rec );