APPS.IRC_ILP_BUS SQL Statements

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

Line: 47

    select 1
      from per_business_groups
     where business_group_id = p_business_group_id;

Line: 116

    select 1
      from fnd_territories
     where territory_code = p_country_code;

Line: 185

    select 1
      from hr_locations_all
     where location_id = p_location_id;

Line: 262

    select 1
      from irc_location_preferences
     where object_id            = p_object_id
       and object_type          = p_object_type
       and business_group_id    = p_business_group_id
       and country_code         = p_country_code
       and location_id          = p_location_id;

Line: 502

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in irc_ilp_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 527

End chk_non_updateable_args;

Line: 532

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

Line: 611

End insert_validate;

Line: 616

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

Line: 656

  chk_non_updateable_args
    (p_effective_date    => p_effective_date
    ,p_rec               => p_rec
    );

Line: 665

End update_validate;

Line: 670

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

Line: 682

End delete_validate;