APPS.PAY_ETM_BUS SQL Statements

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

Line: 13

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

Line: 91

End chk_non_updateable_args;

Line: 103

  select null
  from   fnd_territories ft
  where  ft.territory_code = p_legislation_code;

Line: 163

    select null
    from   pay_element_templates pet
    where  pet.template_type = 'T'
    and    upper(pet.template_name) = upper(p_template_name)
    and
    (
     (pet.legislation_code is null and pet.business_group_id is null) or
     (p_legislation_code is null and p_business_group_id is null) or
     (pet.legislation_code = p_legislation_code) or
     (pet.business_group_id = p_business_group_id) or
     (p_legislation_code = (select legislation_code from per_business_groups_perf
                            where business_group_id = pet.business_group_id))
    );

Line: 241

  select null
  from   pay_shadow_element_types pset
  where  pset.template_id = p_template_id
  and    pset.relative_processing_priority + p_base_processing_priority >
         pay_etm_shd.g_max_processing_priority;

Line: 270

      fnd_message.set_name('PAY', 'PAY_50072_ETM_PRIORITY_UPDATE');

Line: 484

  select null
  from   pay_element_templates pet
  where  pet.template_type = 'U'
  and    upper(pet.base_name) = upper(p_base_name)
  and    pet.business_group_id = p_business_group_id;

Line: 494

  select null
  from   pay_element_templates pet
  where  pet.template_type = 'U'
  and    upper(pet.base_name) = upper(p_base_name)
  and    pet.template_name    = p_template_name
  and    pet.business_group_id = p_business_group_id;

Line: 595

Procedure chk_delete
  (p_template_id in     number
  ) is
  --
  -- Cursors to check for rows referencing the template.
  --
  cursor csr_element_types is
  select null
  from   pay_shadow_element_types pset
  where  pset.template_id = p_template_id;

Line: 607

  select null
  from   pay_template_exclusion_rules ter
  where  ter.template_id = p_template_id;

Line: 612

  select null
  from   pay_shadow_balance_types sbt
  where  sbt.template_id = p_template_id;

Line: 617

  select null
  from   pay_template_core_objects tco
  where  tco.template_id = p_template_id;

Line: 621

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

Line: 666

    fnd_message.set_name('PAY', 'PAY_50075_ETM_INVALID_DELETE');

Line: 671

End chk_delete;

Line: 675

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

Line: 735

End insert_validate;

Line: 740

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

Line: 752

  chk_non_updateable_args(p_rec => p_rec);

Line: 775

End update_validate;

Line: 780

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

Line: 789

  chk_delete(p_rec.template_id);

Line: 791

End delete_validate;