APPS.OTA_ADT_BUS SQL Statements

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

Line: 115

    select 'Y'
      from ota_activity_definitions tad, ota_activity_definitions_tl adt
   --Modified for Bug#3547758
   --  where upper(adt.name)           =    upper(p_name)
      where adt.name           =    p_name
       and (tad.business_group_id    =    p_business_group_id
           OR p_business_group_id is NULL )
       and adt.activity_id          =    tad.activity_id
       and (adt.activity_id          <>   p_activity_id
           OR p_activity_id is NULL )
       and adt.language            =    p_language ;

Line: 171

    Select adt.business_group_id
    from   ota_activity_definitions adt
    where  adt.activity_id = Nvl(p_rec.activity_id,p_activity_id) ;

Line: 211

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups pbg
         , ota_activity_definitions tad
      where tad.activity_id = p_activity_id
      and pbg.business_group_id = tad.business_group_id;

Line: 284

    select pbg.legislation_code
      from per_business_groups     pbg
         , ota_activity_definitions tad
     where tad.activity_id = p_activity_id
       and pbg.business_group_id = tad.business_group_id;

Line: 376

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

Line: 399

End chk_non_updateable_args;

Line: 404

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

Line: 425

End insert_validate;

Line: 430

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

Line: 448

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

Line: 455

End update_validate;

Line: 460

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

Line: 472

End delete_validate;