APPS.PAY_ITERATE SQL Statements

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

Line: 126

    select distinct assignment_id
      into l_asg_id
      from pay_element_entries_f
     where element_entry_id = p_entry_id;

Line: 132

      g_entry_list.entry_id.delete;

Line: 133

      g_entry_list.high_value.delete;

Line: 134

      g_entry_list.low_value.delete;

Line: 135

      g_entry_list.high_value_result.delete;

Line: 136

      g_entry_list.low_value_result.delete;

Line: 137

      g_entry_list.guess_value.delete;

Line: 138

      g_entry_list.target_value.delete;

Line: 139

      g_entry_list.inter_mode.delete;

Line: 146

      g_entry_list.entry_id.delete;

Line: 147

      g_entry_list.high_value.delete;

Line: 148

      g_entry_list.low_value.delete;

Line: 149

      g_entry_list.high_value_result.delete;

Line: 150

      g_entry_list.low_value_result.delete;

Line: 151

      g_entry_list.guess_value.delete;

Line: 152

      g_entry_list.target_value.delete;

Line: 153

      g_entry_list.inter_mode.delete;

Line: 385

         g_entry_list.entry_id.delete;

Line: 386

         g_entry_list.high_value.delete;

Line: 387

         g_entry_list.low_value.delete;

Line: 388

         g_entry_list.high_value_result.delete;

Line: 389

         g_entry_list.low_value_result.delete;

Line: 390

         g_entry_list.guess_value.delete;

Line: 391

         g_entry_list.target_value.delete;

Line: 392

         g_entry_list.inter_mode.delete;

Line: 425

         g_entry_list.entry_id.delete;

Line: 426

         g_entry_list.high_value.delete;

Line: 427

         g_entry_list.low_value.delete;

Line: 428

         g_entry_list.high_value_result.delete;

Line: 429

         g_entry_list.low_value_result.delete;

Line: 430

         g_entry_list.guess_value.delete;

Line: 431

         g_entry_list.target_value.delete;

Line: 432

         g_entry_list.inter_mode.delete;

Line: 507

   select legislation_code
     into l_leg_code
     from per_business_groups_perf
    where business_group_id = p_bg_id;

Line: 588

select run_type_id
,      run_type_name
,      shortname
,      srs_flag
,      run_information_category
,      run_information1
,      run_information2
,      run_information3
,      run_information4
,      run_information5
,      run_information6
,      run_information7
,      run_information8
,      run_information9
,      run_information10
,      run_information11
,      run_information12
,      run_information13
,      run_information14
,      run_information15
,      run_information16
,      run_information17
,      run_information18
,      run_information19
,      run_information20
,      run_information21
,      run_information22
,      run_information23
,      run_information24
,      run_information25
,      run_information26
,      run_information27
,      run_information28
,      run_information29
,      run_information30
,      legislation_code
,      business_group_id
,      effective_start_date
,      effective_end_date
,      object_version_number
from   pay_run_types_f
where  run_type_name = p_rt_name
and    business_group_id = (select pbg.business_group_id
                            from   per_business_groups pbg
                            where  upper(pbg.name) = upper(p_business_group))
and    legislation_code is null;

Line: 637

select run_type_id
,      run_type_name
,      shortname
,      srs_flag
,      run_information_category
,      run_information1
,      run_information2
,      run_information3
,      run_information4
,      run_information5
,      run_information6
,      run_information7
,      run_information8
,      run_information9
,      run_information10
,      run_information11
,      run_information12
,      run_information13
,      run_information14
,      run_information15
,      run_information16
,      run_information17
,      run_information18
,      run_information19
,      run_information20
,      run_information21
,      run_information22
,      run_information23
,      run_information24
,      run_information25
,      run_information26
,      run_information27
,      run_information28
,      run_information29
,      run_information30
,      legislation_code
,      business_group_id
,      effective_start_date
,      effective_end_date
,      object_version_number
from   pay_run_types_f
where  run_type_name = p_rt_name
and    legislation_code = p_legislative_code
and    business_group_id is null;

Line: 684

select run_type_id
,      run_type_name
,      shortname
,      srs_flag
,      run_information_category
,      run_information1
,      run_information2
,      run_information3
,      run_information4
,      run_information5
,      run_information6
,      run_information7
,      run_information8
,      run_information9
,      run_information10
,      run_information11
,      run_information12
,      run_information13
,      run_information14
,      run_information15
,      run_information16
,      run_information17
,      run_information18
,      run_information19
,      run_information20
,      run_information21
,      run_information22
,      run_information23
,      run_information24
,      run_information25
,      run_information26
,      run_information27
,      run_information28
,      run_information29
,      run_information30
,      legislation_code
,      business_group_id
,      effective_start_date
,      effective_end_date
,      object_version_number
from   pay_run_types_f prt
where  run_type_name = p_rt_name
and    business_group_id is null
and    legislation_code is null;

Line: 731

select business_group_id
from   per_business_groups
where  upper(name) = upper(p_business_group);

Line: 784

procedure insert_row is
--
begin
--
hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 791

    hr_startup_data_api_support.delete_owner_definitions;

Line: 846

  select run_type_id
  ,      run_type_name
  ,      shortname
  ,      srs_flag
  ,      run_information_category
  ,      run_information1
  ,      run_information2
  ,      run_information3
  ,      run_information4
  ,      run_information5
  ,      run_information6
  ,      run_information7
  ,      run_information8
  ,      run_information9
  ,      run_information10
  ,      run_information11
  ,      run_information12
  ,      run_information13
  ,      run_information14
  ,      run_information15
  ,      run_information16
  ,      run_information17
  ,      run_information18
  ,      run_information19
  ,      run_information20
  ,      run_information21
  ,      run_information22
  ,      run_information23
  ,      run_information24
  ,      run_information25
  ,      run_information26
  ,      run_information27
  ,      run_information28
  ,      run_information29
  ,      run_information30
  ,      legislation_code
  ,      business_group_id
  ,      effective_start_date
  ,      effective_end_date
  ,      object_version_number
  ,      l_mode
  into   rec_uploaded
  from   pay_run_types_f
  where  run_type_id = l_out_rt_id;

Line: 891

end insert_row;

Line: 902

procedure zap_insert(p_rt_id number) is
--
cursor chk_for_children
is
select run_type_usage_id
,      object_version_number
,      business_group_id
,      legislation_code
,      effective_start_date
from   pay_run_type_usages_f
where  parent_run_type_id = l_rt_id;

Line: 916

select 1
from   pay_run_types_f_tl
where  run_type_id = l_rt_id;

Line: 922

select product_short_name
from hr_owner_definitions
where session_id = p_sess;

Line: 928

select l.language_code
from   fnd_languages l
where  l.installed_flag in ('I','B')
and    exists (select null
               from pay_run_types_f_tl rtt
               where rtt.run_type_id = p_rt_id
               and rtt.language = l.language_code);

Line: 949

    hr_startup_data_api_support.delete_owner_definitions;

Line: 966

  delete from pay_run_types_f
  where  run_type_id = p_rt_id;

Line: 974

    delete from pay_run_types_f_tl
    where  run_type_id = p_rt_id
    and    language = each_row.language_code;

Line: 986

   delete from hr_application_ownerships
   where  key_name     = 'RUN_TYPE_ID'
   and    key_value    = p_rt_id
   and    product_name = each_row.product_short_name;

Line: 1041

  select run_type_id
  ,      run_type_name
  ,      shortname
  ,      srs_flag
  ,      run_information_category
  ,      run_information1
  ,      run_information2
  ,      run_information3
  ,      run_information4
  ,      run_information5
  ,      run_information6
  ,      run_information7
  ,      run_information8
  ,      run_information9
  ,      run_information10
  ,      run_information11
  ,      run_information12
  ,      run_information13
  ,      run_information14
  ,      run_information15
  ,      run_information16
  ,      run_information17
  ,      run_information18
  ,      run_information19
  ,      run_information20
  ,      run_information21
  ,      run_information22
  ,      run_information23
  ,      run_information24
  ,      run_information25
  ,      run_information26
  ,      run_information27
  ,      run_information28
  ,      run_information29
  ,      run_information30
  ,      legislation_code
  ,      business_group_id
  ,      effective_start_date
  ,      effective_end_date
  ,      object_version_number
  ,      l_mode
  into   rec_uploaded
  from   pay_run_types_f
  where  run_type_id = l_out_rt_id;

Line: 1086

end zap_insert;

Line: 1096

procedure update_row is
--
begin
--
hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 1103

    hr_startup_data_api_support.delete_owner_definitions;

Line: 1107

  pay_run_type_api.update_run_type
               (p_effective_date        => p_effective_start_date
               ,p_datetrack_update_mode => 'UPDATE'
               ,p_run_type_id           => rec_uploaded.rt_id
               ,p_object_version_number => rec_uploaded.rt_ovn
               ,p_business_group_id     => l_bg
               ,p_legislation_code      => p_legislative_code
               ,p_shortname             => p_shortname
               ,p_srs_flag              => p_srs_flag
	       ,p_run_information_category    => p_run_information_category
	       ,p_run_information1		=> p_run_information1
	       ,p_run_information2		=> p_run_information2
	       ,p_run_information3		=> p_run_information3
	       ,p_run_information4		=> p_run_information4
	       ,p_run_information5		=> p_run_information5
	       ,p_run_information6		=> p_run_information6
	       ,p_run_information7		=> p_run_information7
	       ,p_run_information8		=> p_run_information8
	       ,p_run_information9		=> p_run_information9
	       ,p_run_information10		=> p_run_information10
	       ,p_run_information11		=> p_run_information11
	       ,p_run_information12		=> p_run_information12
	       ,p_run_information13		=> p_run_information13
	       ,p_run_information14		=> p_run_information14
	       ,p_run_information15		=> p_run_information15
	       ,p_run_information16		=> p_run_information16
	       ,p_run_information17		=> p_run_information17
	       ,p_run_information18		=> p_run_information18
	       ,p_run_information19		=> p_run_information19
	       ,p_run_information20		=> p_run_information20
	       ,p_run_information21		=> p_run_information21
	       ,p_run_information22		=> p_run_information22
	       ,p_run_information23		=> p_run_information23
	       ,p_run_information24		=> p_run_information24
	       ,p_run_information25		=> p_run_information25
	       ,p_run_information26		=> p_run_information26
	       ,p_run_information27		=> p_run_information27
	       ,p_run_information28		=> p_run_information28
	       ,p_run_information29		=> p_run_information29
	       ,p_run_information30		=> p_run_information30
               ,p_effective_start_date  => l_out_esd
               ,p_effective_end_date    => l_out_eed
               );

Line: 1153

  select run_type_id
  ,      run_type_name
  ,      shortname
  ,      srs_flag
  ,      run_information_category
  ,      run_information1
  ,      run_information2
  ,      run_information3
  ,      run_information4
  ,      run_information5
  ,      run_information6
  ,      run_information7
  ,      run_information8
  ,      run_information9
  ,      run_information10
  ,      run_information11
  ,      run_information12
  ,      run_information13
  ,      run_information14
  ,      run_information15
  ,      run_information16
  ,      run_information17
  ,      run_information18
  ,      run_information19
  ,      run_information20
  ,      run_information21
  ,      run_information22
  ,      run_information23
  ,      run_information24
  ,      run_information25
  ,      run_information26
  ,      run_information27
  ,      run_information28
  ,      run_information29
  ,      run_information30
  ,      legislation_code
  ,      business_group_id
  ,      effective_start_date
  ,      effective_end_date
  ,      object_version_number
  ,      l_mode
  into   rec_uploaded
  from   pay_run_types_f
  where  run_type_id = rec_uploaded.rt_id
  and    effective_start_date = l_out_esd
  and    effective_end_date = l_out_eed;

Line: 1200

end update_row;

Line: 1215

select run_type_usage_id
,      object_version_number
,      business_group_id
,      legislation_code
from   pay_run_type_usages_f
where  parent_run_type_id = rec_uploaded.rt_id
and    effective_end_date >= g_to_be_uploaded_eed;

Line: 1225

select 1
from   pay_run_types_f_tl
where  run_type_id = rec_uploaded.rt_id;

Line: 1240

    hr_startup_data_api_support.delete_owner_definitions;

Line: 1251

    pay_run_type_usage_api.delete_run_type_usage
     (p_effective_date        => g_to_be_uploaded_eed
     ,p_datetrack_delete_mode => 'ZAP'
     ,p_run_type_usage_id     => each_child.run_type_usage_id
     ,p_object_version_number => each_child.object_version_number
     ,p_business_group_id     => each_child.business_group_id
     ,p_legislation_code      => each_child.legislation_code
     ,p_effective_start_date  => l_out_esd
     ,p_effective_end_date    => l_out_eed
     );

Line: 1277

  pay_run_type_api.delete_run_type
        (p_effective_date        => g_to_be_uploaded_eed
        ,p_datetrack_delete_mode => 'DELETE'
        ,p_run_type_id           => rec_uploaded.rt_id
        ,p_object_version_number => rec_uploaded.rt_ovn
        ,p_business_group_id     => rec_uploaded.rt_bg
        ,p_legislation_code      => rec_uploaded.rt_leg_code
        ,p_effective_start_date  => l_out_esd
        ,p_effective_end_date    => l_out_eed
        );

Line: 1420

      insert_row;

Line: 1494

        zap_insert(l_rt_id);

Line: 1583

      insert_row;

Line: 1655

        zap_insert(l_rt_id);

Line: 1744

      insert_row;

Line: 1816

        zap_insert(l_rt_id);

Line: 1925

    update_row;

Line: 1968

select run_type_usage_id
,      parent_run_type_id
,      child_run_type_id
,      sequence
,      legislation_code
,      business_group_id
,      effective_start_date
,      effective_end_date
,      object_version_number
from   pay_run_type_usages_f
where  parent_run_type_id = p_parent_rt_id
and    child_run_type_id = p_child_rt_id
and    business_group_id = (select pbg.business_group_id
                                  from per_business_groups pbg
                                  where upper(pbg.name) = p_business_group)
and    legislation_code is null;

Line: 1988

select run_type_usage_id
,      parent_run_type_id
,      child_run_type_id
,      sequence
,      legislation_code
,      business_group_id
,      effective_start_date
,      effective_end_date
,      object_version_number
from   pay_run_type_usages_f
where  parent_run_type_id = p_parent_rt_id
and    child_run_type_id = p_child_rt_id
and    legislation_code = p_legislation_code
and    business_group_id is null;

Line: 2006

select run_type_usage_id
,      parent_run_type_id
,      child_run_type_id
,      sequence
,      legislation_code
,      business_group_id
,      effective_start_date
,      effective_end_date
,      object_version_number
from   pay_run_type_usages_f
where  parent_run_type_id = p_parent_rt_id
and    child_run_type_id = p_child_rt_id
and    business_group_id is null
and    legislation_code is null;

Line: 2023

select business_group_id
from   per_business_groups
where  UPPER(name) = upper(p_bg_name);

Line: 2029

select prt.run_type_id
from   pay_run_types_f prt
where  prt.run_type_name = p_parent_run_type_name
and    p_effective_start_date between prt.effective_start_date
                                  and prt.effective_end_date
and    ((p_business_group is not null
and      prt.business_group_id = p_bg_id)
or      (p_legislation_code is not null
and      prt.legislation_code = p_legislation_code)
or      (p_business_group      is null
and      p_legislation_code    is null
and      prt.business_group_id is null
and      prt.legislation_code  is null));

Line: 2045

select prt.run_type_id
from   pay_run_types_f prt
where  prt.run_type_name = p_child_run_type_name
and    p_effective_start_date between prt.effective_start_date
                                  and prt.effective_end_date
and    ((p_child_bg is not null
and      prt.business_group_id = p_bg_id)
or      (p_child_leg_code is not null
and      prt.legislation_code = p_child_leg_code)
or      (p_child_bg            is null
and      p_legislation_code    is null
and      prt.business_group_id is null
and      prt.legislation_code  is null));

Line: 2063

select run_type_usage_id
from   pay_run_type_usages_f
where  parent_run_type_id = p_par_id
and    sequence = p_sequence_num
and    p_eff_st_date between effective_start_date
                         and effective_end_date;

Line: 2090

procedure insert_row is
--
begin
--
hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 2097

    hr_startup_data_api_support.delete_owner_definitions;

Line: 2119

  select run_type_usage_id
  ,      parent_run_type_id
  ,      child_run_type_id
  ,      sequence
  ,      legislation_code
  ,      business_group_id
  ,      effective_start_date
  ,      effective_end_date
  ,      object_version_number
  ,      l_mode
  into   rec_rtu_uploaded
  from   pay_run_type_usages_f
  where  run_type_usage_id = l_out_rtu_id;

Line: 2133

end insert_row;

Line: 2144

procedure zap_insert(p_rtu_id number) is
--
begin
--
hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 2151

    hr_startup_data_api_support.delete_owner_definitions;

Line: 2163

delete from pay_run_type_usages_f
where  run_type_usage_id = p_rtu_id;

Line: 2168

  delete from pay_run_type_usages_f
  where  run_type_usage_id = l_valid_seq;

Line: 2189

  select run_type_usage_id
  ,      parent_run_type_id
  ,      child_run_type_id
  ,      sequence
  ,      legislation_code
  ,      business_group_id
  ,      effective_start_date
  ,      effective_end_date
  ,      object_version_number
  ,      l_mode
  into   rec_rtu_uploaded
  from   pay_run_type_usages_f
  where  run_type_usage_id = l_out_rtu_id;

Line: 2203

end zap_insert;

Line: 2213

procedure update_row is
--
begin
--
hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 2220

    hr_startup_data_api_support.delete_owner_definitions;

Line: 2224

  pay_run_type_usage_api.update_run_type_usage
               (p_effective_date        => p_effective_start_date
               ,p_datetrack_update_mode => 'UPDATE'
               ,p_run_type_usage_id     => rec_rtu_uploaded.rtu_id
               ,p_object_version_number => rec_rtu_uploaded.rtu_ovn
               ,p_sequence              => p_sequence
               ,p_business_group_id     => l_bg
               ,p_legislation_code      => p_legislation_code
               ,p_effective_start_date  => l_out_esd
               ,p_effective_end_date    => l_out_eed
               );

Line: 2238

  select run_type_usage_id
  ,      parent_run_type_id
  ,      child_run_type_id
  ,      sequence
  ,      legislation_code
  ,      business_group_id
  ,      effective_start_date
  ,      effective_end_date
  ,      object_version_number
  ,      l_mode
  into   rec_rtu_uploaded
  from   pay_run_type_usages_f
  where  run_type_usage_id = rec_rtu_uploaded.rtu_id
  and    effective_start_date = l_out_esd
  and    effective_end_date = l_out_eed;

Line: 2254

end update_row;

Line: 2269

    hr_startup_data_api_support.delete_owner_definitions;

Line: 2275

  pay_run_type_usage_api.delete_run_type_usage
        (p_effective_date        => g_rtu_to_be_uploaded_eed
        ,p_datetrack_delete_mode => 'DELETE'
        ,p_run_type_usage_id     => rec_rtu_uploaded.rtu_id
        ,p_object_version_number => rec_rtu_uploaded.rtu_ovn
        ,p_business_group_id     => rec_rtu_uploaded.rtu_bg
        ,p_legislation_code      => rec_rtu_uploaded.rtu_leg_code
        ,p_effective_start_date  => l_out_esd
        ,p_effective_end_date    => l_out_eed
        );

Line: 2382

      insert_row;

Line: 2390

        zap_insert(l_rtu_id);

Line: 2430

      insert_row;

Line: 2458

        zap_insert(l_rtu_id);

Line: 2500

      insert_row;

Line: 2508

        zap_insert(l_rtu_id);

Line: 2556

    update_row;

Line: 2585

select business_group_id
from   per_business_groups
where upper(name) = p_rt_bg;

Line: 2591

select run_type_id
from   pay_run_types_f
where  run_type_name = p_base_rt_name
and    nvl(business_group_id, -1) = nvl(p_bg_id, -1)
and    nvl(legislation_code, 'CORE') = nvl(p_rt_leg_code, 'CORE');

Line: 2657

     select run_type_org_method_id
     ,      object_version_number
     ,      effective_start_date
     ,      effective_end_date
     from   pay_run_type_org_methods_f
     where  run_type_id = l_rt_id
     and    org_payment_method_id = l_opm_id
     and    business_group_id = l_bg_id;

Line: 2666

   procedure zap_insert_rom is
   --
   begin
   --
     hr_startup_data_api_support.enable_startup_mode('USER');

Line: 2672

     pay_run_type_org_method_api.delete_run_type_org_method(
       p_effective_date         => p_effective_start_date
      ,p_datetrack_delete_mode  => 'ZAP'
      ,p_run_type_org_method_id => l_rom_id
      ,p_object_version_number  => l_ovn
      ,p_effective_start_date   => l_esd
      ,p_effective_end_date     => l_eed);

Line: 2697

   procedure insert_rom is
   --
   begin
   --
     hr_startup_data_api_support.enable_startup_mode('USER');

Line: 2718

   procedure update_rom is
   --
   begin
   --
     hr_startup_data_api_support.enable_startup_mode('USER');

Line: 2724

     pay_run_type_org_method_api.update_run_type_org_method(
       p_effective_date          => p_effective_start_date
      ,p_datetrack_update_mode   => 'UPDATE'
      ,p_run_type_org_method_id  => g_rom_rec.new_rom_id
      ,p_object_version_number   => g_rom_rec.ovn
      ,p_priority                => p_priority
      ,p_percentage              => p_percentage
      ,p_amount                  => p_amount
      ,p_business_group_id       => l_bg_id
      ,p_effective_start_date    => l_out_esd
      ,p_effective_end_date      => l_out_eed);

Line: 2744

     pay_run_type_org_method_api.delete_run_type_org_method(
       p_effective_date         => g_rom_rec.old_eed
      ,p_datetrack_delete_mode  => 'DELETE'
      ,p_run_type_org_method_id => g_rom_rec.new_rom_id
      ,p_object_version_number  => g_rom_rec.ovn
      ,p_effective_start_date   => g_rom_rec.new_esd
      ,p_effective_end_date     => g_rom_rec.new_eed);

Line: 2762

     select business_group_id
     ,      legislation_code
     into   l_bg_id
     ,      l_lc
     from   per_business_groups
     where  UPPER(name) = p_business_group;

Line: 2773

     select prt.run_type_id
     into   l_rt_id
     from   pay_run_types_f prt
     where  UPPER(prt.run_type_name) = p_rt_name
     and    p_effective_start_date between prt.effective_start_date
                                   and     prt.effective_end_date
     and    ((p_rt_bg is not null
     and    prt.business_group_id = l_bg_id)
     or     (p_rt_lc is not null
     and    prt.legislation_code = p_rt_lc)
     or     (p_rt_bg is null
     and    p_rt_lc is null
     and    prt.business_group_id is null
     and    prt.legislation_code is null));

Line: 2792

     select popm.org_payment_method_id
     into   l_opm_id
     from   pay_org_payment_methods_f popm
     where  UPPER(popm.org_payment_method_name) = p_opm_name
     and    p_effective_start_date between popm.effective_start_date
                                   and     popm.effective_end_date
     and    popm.business_group_id = l_bg_id;

Line: 2808

         zap_insert_rom;

Line: 2810

         update_rom;

Line: 2816

       insert_rom;

Line: 2892

     select element_type_usage_id
     ,      object_version_number
     ,      legislation_code
     ,      business_group_id
     ,      effective_start_date
     ,      effective_end_date
     from   pay_element_type_usages_f
     where  run_type_id = l_in_rt_id
     and    element_type_id = l_in_et_id
     and    ((business_group_id = l_in_bg_id)
     or     (legislation_code = l_in_lc)
     or     (business_group_id is null
     and    legislation_code is null));

Line: 2907

     select element_type_usage_id
     ,      object_version_number
     ,      legislation_code
     ,      business_group_id
     ,      effective_start_date
     ,      effective_end_date
     from   pay_element_type_usages_f
     where  run_type_id = l_in_rt_id
     and    element_type_id = l_in_et_id
     and    ((business_group_id in (select business_group_id
                                   from per_business_groups
                                   where legislation_code = p_legislative_code))
     or     (legislation_code = p_legislative_code)
     or     (business_group_id is null
     and    legislation_code is null));

Line: 2924

     select element_type_usage_id
     ,      object_version_number
     ,      legislation_code
     ,      business_group_id
     ,      effective_start_date
     ,      effective_end_date
     from   pay_element_type_usages_f
     where  run_type_id = l_in_rt_id
     and    element_type_id = l_in_et_id;

Line: 2934

   procedure insert_etu is
   --
   begin
   --
     hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 2941

       hr_startup_data_api_support.delete_owner_definitions;

Line: 2967

       hr_startup_data_api_support.delete_owner_definitions;

Line: 2971

     pay_element_type_usage_api.delete_element_type_usage(
       p_effective_date        => g_etu_rec.old_eed
      ,p_datetrack_delete_mode => 'DELETE'
      ,p_element_type_usage_id => g_etu_rec.new_etu_id
      ,p_object_version_number => g_etu_rec.ovn
      ,p_effective_start_date  => g_etu_rec.new_esd
      ,p_effective_end_date    => g_etu_rec.new_eed);

Line: 2981

   procedure zap_insert_etu is
   --
   begin
   --
     hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 2988

       hr_startup_data_api_support.delete_owner_definitions;

Line: 2992

     pay_element_type_usage_api.delete_element_type_usage(
       p_effective_date        => p_effective_start_date
      ,p_datetrack_delete_mode => 'ZAP'
      ,p_element_type_usage_id => l_etu_id
      ,p_object_version_number => l_ovn
      ,p_effective_start_date  => l_esd
      ,p_effective_end_date    => l_eed);

Line: 3003

       hr_startup_data_api_support.delete_owner_definitions;

Line: 3022

   procedure update_etu is
   --
   begin
   --
    hr_startup_data_api_support.enable_startup_mode(l_mode);

Line: 3029

       hr_startup_data_api_support.delete_owner_definitions;

Line: 3033

     pay_element_type_usage_api.update_element_type_usage(
       p_effective_date        => p_effective_start_date
      ,p_datetrack_update_mode => 'UPDATE'
      ,p_inclusion_flag	       => p_inclusion_flag
      ,p_element_type_usage_id => l_etu_id
      ,p_object_version_number => l_ovn
      ,p_business_group_id     => l_in_bg_id
      ,p_legislation_code      => p_legislative_code
      ,p_usage_type	       => p_usage_type
      ,p_effective_start_date  => l_out_esd
      ,p_effective_end_date    => l_out_eed);

Line: 3083

       select business_group_id
       ,      legislation_code
       into   l_in_bg_id
       ,      l_in_lc
       from   per_business_groups
       where  UPPER(name) = p_business_group;

Line: 3094

     select prt.run_type_id
     into   l_in_rt_id
     from   pay_run_types_f prt
     where  UPPER(prt.run_type_name) = p_rt_name
     and    p_effective_start_date between prt.effective_start_date
                                   and     prt.effective_end_date
     and    ((p_rt_bg_name is not null
     and    prt.business_group_id = l_in_bg_id)
     or     (p_rt_leg_code is not null
     and    prt.legislation_code = p_rt_leg_code)
     or     (p_rt_bg_name is null
     and    p_rt_leg_code is null
     and    prt.business_group_id is null
     and    prt.legislation_code is null));

Line: 3111

     select pet.element_type_id
     into   l_in_et_id
     from   pay_element_types_f pet
     where  UPPER(pet.element_name) = p_element_name
     and    p_effective_start_date between pet.effective_start_date
                                   and     pet.effective_end_date
     and    ((p_et_bg_name is not null
     and    pet.business_group_id = l_in_bg_id)
     or     (p_et_leg_code is not null
     and    pet.legislation_code = p_et_leg_code)
     or     (p_et_bg_name is null
     and    p_et_leg_code is null
     and    pet.business_group_id is null
     and    pet.legislation_code is null));

Line: 3137

           update_etu;

Line: 3139

           zap_insert_etu;

Line: 3145

         insert_etu;

Line: 3159

           update_etu;

Line: 3161

           zap_insert_etu;

Line: 3167

         insert_etu;

Line: 3181

           update_etu;

Line: 3183

           zap_insert_etu;

Line: 3189

         insert_etu;

Line: 3239

select pbg.business_group_id
from   per_business_groups pbg
where  pbg.name = p_bg_name;

Line: 3247

select prt.run_type_name
,      prt.run_method
from   pay_run_types_f prt
,      pay_run_type_usages_f rtu
where  prt.run_method = 'C'
and    nvl(prt.legislation_code, 'NULL') = nvl(p_leg_code, 'NULL')
and    nvl(prt.business_group_id, -1) = nvl(p_bg, -1)
and    prt.run_type_name = p_rt_name
and    prt.run_type_id = rtu.child_run_type_id;