APPS.OTA_PMM_BUS SQL Statements

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

Line: 24

select null
from   ota_program_memberships
where  program_event_id    = p_program_event_id
and    event_id            = p_event_id
and   (p_program_membership_id is null or
      (p_program_membership_id is not null and
       p_program_membership_id <> program_membership_id));

Line: 57

    select null
    from   ota_events evt
    where  evt.event_id = p_program_event_id
    and    evt.event_status = 'N'
    and    exists (select null
		   from   ota_events evt2
		   where  evt2.event_id = p_event_id
		   and    evt2.event_status = 'P');

Line: 98

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

Line: 115

End insert_validate;

Line: 120

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

Line: 137

End update_validate;

Line: 142

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

Line: 152

End delete_validate;