APPS.OTA_EVT_BUS SQL Statements

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

Line: 170

    SELECT inf.org_information14
    FROM   hr_organization_information inf
          ,ota_events evt
    WHERE  evt.event_id       = p_event_id
    AND    inf.organization_id               = evt.business_group_id
    AND    inf.org_information_context || '' = 'Business Group Information';

Line: 262

          select legislation_code
          from   per_business_groups_perf pbg,
                 ota_events evt
          where  pbg.business_group_id    = evt.business_group_id
            and  evt.event_id = p_event_id;

Line: 331

    select BST.TYPE
    FROM  OTA_BOOKING_STATUS_TYPES BST ,
          PER_ALL_PEOPLE_F DEL ,
          OTA_EVENTS EVT ,
          OTA_DELEGATE_BOOKINGS TDB
   where  tdb.business_group_id = p_business_group_id
  and evt.event_id = p_event_id
  AND TDB.BOOKING_STATUS_TYPE_ID = BST.BOOKING_STATUS_TYPE_ID
  AND TDB.EVENT_ID = EVT.EVENT_ID
  AND TDB.DELEGATE_PERSON_ID = DEL.PERSON_ID (+)
  AND tdb.date_booking_placed between nvl(del.effective_start_date, tdb.date_booking_placed) and nvl(del.effective_end_date, tdb.date_booking_placed);

Line: 369

    select a.title
    from   ota_events_tl a,
	   ota_program_memberships b
    where  a.event_id = b.program_event_id
    and    b.event_id = p_event_id
    and    a.language = USERENV('LANG');

Line: 406

  SELECT null
    FROM ota_offerings o,
	     ota_category_usages c
   WHERE o.offering_id = p_parent_offering_id
     AND o.delivery_mode_id = c.category_usage_id
     AND c.synchronous_flag = 'Y'
     AND c.online_flag = 'N';

Line: 415

  SELECT null
    FROM ota_event_associations
   WHERE event_id = p_event_id
     AND (l_cust_associations = 'N' or customer_id is not null)
     AND (l_non_cust_associations = 'N' or customer_id is null);

Line: 544

    select null
    from   ota_program_memberships mem,
	   ota_events evt
    where  mem.program_event_id = p_event_id
    and    mem.event_id = evt.event_id
    and    evt.event_status = 'P';

Line: 744

    select null
    from   ota_resource_bookings
    where  event_id = p_event_id
    and    (required_date_from = p_course_start_date
	    and required_start_time <
	    p_start_time
	    or
	    required_date_to = p_course_end_date
	    and required_end_time >
	    p_end_time);

Line: 796

select null
from   ota_delegate_bookings
where  event_id = p_event_id;

Line: 801

select null
from   ota_event_associations
where  event_id = p_event_id;

Line: 860

    select start_date, end_date
    from ota_offerings
    where offering_id = p_parent_offering_id;

Line: 905

    select start_date, end_date
    from ota_activity_versions_v
    where activity_version_id = p_activity_version_id;

Line: 1083

    select start_date, end_date, activity_version_id
    from ota_offerings
    where offering_id = p_parent_offering_id;

Line: 1088

    select start_date, end_date
    from ota_activity_versions
    where activity_version_id = l_act_vrsn_id;

Line: 1232

    select start_date, end_date
    from ota_activity_versions
    where activity_version_id = p_activity_version_id;

Line: 1308

    select 'X'
    from   ota_delegate_bookings
    where  event_id = p_event_id
    -- Modified for bug#5107347
    and    ota_timezone_util.convert_date(trunc(date_booking_placed)
                                         , to_char(date_booking_placed, 'HH24:MI')
					 , ota_timezone_util.get_server_timezone_code
					 , p_timezone)
       not between nvl(p_enrolment_start_date,hr_api.g_sot) and nvl(p_enrolment_end_date +1,hr_api.g_eot);

Line: 1359

    select start_date, end_date
    from   ota_booking_deals
    where  event_id = p_event_id;

Line: 1421

    select null
    from ota_events
    where parent_event_id = p_event_id
    and   event_type = 'SESSION'
    and   (course_start_date < nvl(p_course_start_date,hr_api.g_sot)
    or    course_start_date > nvl(p_course_end_date,hr_api.g_eot));

Line: 1430

    select 'X'
    from ota_events
    where parent_event_id = p_event_id
    and   event_type = 'SESSION';

Line: 1489

		select 1
		  from OTA_EVENTS_VL			EVT
		  where EVT.BUSINESS_GROUP_ID	      = P_BUSINESS_GROUP_ID
		    and (    (P_PARENT_EVENT_ID      is null             )
		         or  (EVT.PARENT_EVENT_ID     = P_PARENT_EVENT_ID))
		    and upper (EVT.TITLE)	      = upper (P_TITLE)
		    and (    (P_EVENT_ID	     is null      )
		         or  (EVT.EVENT_ID	     <> P_EVENT_ID));

Line: 1547

	--	Do not perform the uniqueness check unless inserting, or updating
	--	with a value different from the current value (and not just changing
	--	case)
	--
	if (not (    (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
	         and (upper (P_TITLE) = upper (OTA_EVT_SHD.G_OLD_REC.TITLE)         ))) then
		--
		if (not UNIQUE_EVENT_TITLE (
				P_TITLE		     => P_TITLE,
				P_BUSINESS_GROUP_ID  => P_BUSINESS_GROUP_ID,
				P_PARENT_EVENT_ID    =>	P_PARENT_EVENT_ID,
				P_EVENT_ID	     =>	P_EVENT_ID)) then
			OTA_EVT_SHD.CONSTRAINT_ERROR ('OTA_EVENTS_UK2');

Line: 1593

  SELECT course_start_date,
         course_start_time,
         course_end_date,
         course_end_time
    FROM ota_events
   WHERE event_id = p_parent_event_id;

Line: 1799

		select 1
		  from ota_events
		  where	parent_event_id	      =	p_event_id
		    and	event_type	      = 'SESSION'
		    and	course_start_date
		    not between p_course_start_date
		        and p_course_end_date;

Line: 1848

  SELECT course_start_date,
         course_start_time,
         course_end_date,
         course_end_time
    FROM ota_events
   WHERE parent_event_id = p_event_id
     AND event_type = 'SESSION';

Line: 1936

procedure CHECK_UPDATED_COURSE_DATES (
	P_EVENT_ID			     in	number,
	P_OBJECT_VERSION_NUMBER		     in	number,
	P_EVENT_TYPE			     in	varchar2,
	P_COURSE_START_DATE		     in	date,
	P_COURSE_END_DATE		     in	date
	) is
--
W_PROC	constant varchar2(72) := G_PACKAGE||'check_updated_course_dates';

Line: 1960

	l_dates_updated	boolean := FALSE;

Line: 1966

	  l_dates_updated :=
	  (nvl (p_course_start_date, hr_general.start_of_time) <>
	  	nvl (OTA_EVT_SHD.g_old_rec.course_start_date, hr_general.start_of_time)
	  or nvl (p_course_end_date, hr_general.end_of_time) <>
	  	nvl (OTA_EVT_SHD.g_old_rec.course_end_date, hr_general.end_of_time)
	  		);

Line: 1975

	return l_dates_updated;

Line: 2008

end check_updated_course_dates;

Line: 2232

		select	1
		from	ota_events
		where	event_id = p_parent_event_id
		and	(p_enrolment_start_date not between enrolment_start_date
							and enrolment_end_date
		or	p_enrolment_end_date not between enrolment_start_date
							and enrolment_end_date);

Line: 2242

		select	1
		from	ota_events
		where	parent_event_id = p_event_id
		and ((p_enrolment_start_date not between enrolment_start_date
							and enrolment_end_date)
			or(p_enrolment_end_date not between enrolment_start_date
							and enrolment_end_date));

Line: 2350

select null
from   ota_delegate_bookings
where  event_id = p_event_id;

Line: 2355

select null
from ota_event_associations
where  event_id = p_event_id;

Line: 2642

	    ota_trng_plan_comp_ss.update_tpc_evt_change(p_rec.event_id,
                                                        p_rec.course_start_date,
                                                        p_rec.course_end_date);

Line: 2799

    select 'X'
    from ota_events
    where parent_event_id = p_event_id;

Line: 2806

    select 'X'
    from ota_resource_bookings
    where event_id = p_event_id;

Line: 2813

    select 'X'
    from ota_program_memberships
    where program_event_id = p_event_id;

Line: 2820

    select 'X'
    from ota_event_associations
    where event_id = p_event_id;

Line: 2827

    select 'X'
    from ota_delegate_bookings
    where event_id = p_event_id;

Line: 2834

    select 'X'
    from ota_evaluations
    where object_id = p_event_id
    and object_type = 'E';

Line: 2842

    select 'X'
    from ota_booking_deals
    where event_id = p_event_id;

Line: 2849

    select 'X'
    from ota_act_cat_inclusions
    where event_id = p_event_id;

Line: 2857

    select 'X'
    from ota_attempts
    where event_id = p_event_id;

Line: 2864

    select 'Y'
    from OTA_TRAINING_PLAN_COSTS
    where event_id = p_event_id;

Line: 2871

    select 'Y'
    from per_budget_elements
    where event_id = p_event_id;

Line: 2878

    select 'X'
    from OTA_CONFERENCES
    where event_id = p_event_id;

Line: 3086

		select 1
		  from ota_finance_lines tfl,
		       ota_delegate_bookings tdb
		  where	tdb.event_id = p_event_id
		    and	tdb.booking_id = tfl.booking_id
		    and	tfl.transfer_status = 'ST'
		    and tfl.cancelled_flag = 'N';

Line: 3127

SELECT null
FROM Per_all_people_f per
WHERE per.person_id = p_owner_id and
      per.business_group_id = p_business_group_id and
      NVL(p_course_start_date,TRUNC(SYSDATE)) between
	effective_start_date and effective_end_date;

Line: 3136

SELECT null
FROM Per_all_people_f per
WHERE per.person_id = p_owner_id and
      NVL(p_course_start_date,TRUNC(SYSDATE)) between
	effective_start_date and effective_end_date;

Line: 3209

     select null
     from oe_order_lines_all
     where line_id = p_line_id;

Line: 3414

  Select null
  From HR_ALL_ORGANIZATION_UNITS
  Where organization_id = p_training_center_id;

Line: 3470

  Select null
  From HR_LOCATIONS_ALL loc
  Where loc.location_id = p_location_id
  and nvl(loc.inactive_date,to_date('31-12-4712','DD-MM-YYYY')) >= nvl(p_course_end_date,sysdate);

Line: 3530

     select null
     from ota_events
     where offering_id = p_offering_id;

Line: 3587

     SELECT null
      FROM ota_offerings off,
           ota_activity_versions act
     WHERE off.offering_id = p_parent_offering_id
       AND off.activity_version_id = act.activity_version_id
       AND act.activity_version_id = p_activity_version_id;

Line: 3636

SELECT user_name
  FROM fnd_user f,
       per_all_assignments_f p
 WHERE p.organization_id = p_organization_id
   AND f.employee_id = p.person_id
   AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
   AND f.user_id = to_number(fnd_profile.value('USER_ID'));

Line: 3681

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

Line: 3720

End insert_validate;

Line: 3726

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

Line: 3782

End update_validate;

Line: 3787

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

Line: 3804

End delete_validate;