APPS.HR_EXU_BUS SQL Statements

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

Line: 29

  select c.rowid
  from   hr_calendars c
  where  c.calendar_id = p_calendar_id;

Line: 36

  select u.rowid
  from   hr_calendar_usages u
  where  u.calendar_usage_id = p_calendar_usage_id;

Line: 99

    select '1'
    from   hr_calendar_usages  hcu,
	   hr_calendars         hc,
	   hr_patterns          hp,
	   hr_pattern_purposes hpp
    where  hcu.calendar_usage_id = p_calendar_usage_id
      and  hcu.calendar_id       = hc.calendar_id
      and  hc.pattern_id        = hp.pattern_id
      and  hp.pattern_id        = hpp.pattern_id
      and  hpp.pattern_purpose = 'SSP';

Line: 140

    select '1'
    from   hr_pattern_constructions hpc1,
	   hr_pattern_exceptions    hpe1
    where  hpc1.pattern_id = hpe1.pattern_id
      and  hpe1.exception_id = p_exception_id
      and  not ( hpc1.availability = 'QUALIFYING'
              or hpc1.availability = 'NON QUALIFYING')
    UNION ALL
    select '1'
    from   hr_pattern_constructions hpc2,
	   hr_pattern_constructions hpc3,
	   hr_pattern_exceptions    hpe2
    where  hpc2.component_pattern_id = hpc3.pattern_id
      and  hpc2.pattern_id = hpe2.pattern_id
      and  hpe2.exception_id = p_exception_id
      and  not ( hpc2.availability = 'QUALIFYING'
              or hpc2.availability = 'NON QUALIFYING');

Line: 227

    select  exp.exception_start_time start_time,
	    exp.exception_end_time   end_time
    from    hr_pattern_exceptions exp
    where   exp.exception_id = p_exception_id;

Line: 235

    select  '1'
    from    hr_exception_usages   u,
	    hr_pattern_exceptions e
    where   u.calendar_id = p_calendar_id
      and   u.exception_id = e.exception_id
      and   e.exception_start_time <= c1_rec.end_time
      /* bug fix 8816205 */
      -- and   e.exception_end_time   >= c1_rec.start_time
      and   e.exception_end_time   > c1_rec.start_time
  UNION ALL
    select '1'
    from    hr_exception_usages   u,
	    hr_pattern_exceptions e
    where   u.calendar_usage_id = p_calendar_usage_id
      and  u.exception_id = e.exception_id
      and   e.exception_start_time <= c1_rec.end_time
      /* bug fix 8816205 */
      -- and   e.exception_end_time   >= c1_rec.start_time;

Line: 285

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

Line: 317

End insert_validate;

Line: 322

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

Line: 360

End update_validate;

Line: 365

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

Line: 375

End delete_validate;