APPS.BOM_CALENDARS_PKG SQL Statements

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

Line: 11

    select count(*) into workday_pattern
      from BOM_WORKDAY_PATTERNS
     where calendar_code = x_calendar_code
       and shift_num is null;

Line: 16

    select count(*) into workday_pattern from BOM_WORKDAY_PATTERNS
     where calendar_code = x_calendar_code
       and shift_num = x_shift_num;

Line: 27

  select 1 into dummy from DUAL where not exists
    (select 1 from BOM_CALENDARS
      where calendar_code = x_calendar_code
    );

Line: 48

  select max(exception_date) into cal_except_date
    from BOM_CALENDAR_EXCEPTIONS
   where calendar_code = x_calendar_code;

Line: 52

  select max(exception_date) into shift_except_date
    from BOM_SHIFT_EXCEPTIONS
   where calendar_code = x_calendar_code;

Line: 75

  select min(exception_date) into cal_except_date
    from BOM_CALENDAR_EXCEPTIONS
   where calendar_code = x_calendar_code;

Line: 78

  select min(exception_date) into shift_except_date
    from BOM_SHIFT_EXCEPTIONS
   where calendar_code = x_calendar_code;

Line: 108

  select 1 into dummy from DUAL where not exists
    (select 1 from BOM_CALENDAR_EXCEPTIONS
      where calendar_code = x_calendar_code
        and exception_date = x_exception_date
    );

Line: 128

  select 1 into dummy from DUAL where not exists
    (select 1 from BOM_CALENDAR_SHIFTS
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
    );

Line: 148

  select 1 into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_EXCEPTIONS
      where calendar_code = x_calendar_code
	and shift_num = x_shift_num
        and exception_date = x_exception_date
    );

Line: 171

  select 1 into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time = x_start_time
        and to_time = x_end_time
	and (
	     rowid is null
	     or
	     rowid <> x_row_id
	    )
    );

Line: 202

    select count(*) into dummy from dual where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time < to_time
        and x_start_time > from_time
        and x_start_time < to_time
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and (x_start_time > from_time or x_start_time < to_time)
    );

Line: 217

    select count(*) into dummy from dual where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time < to_time
        and x_start_time > from_time
        and x_start_time < to_time
 	and x_rowid <> x_rowid
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and (x_start_time > from_time or x_start_time < to_time)
 	and x_rowid <> x_rowid
    );

Line: 240

    select count(*) into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time < to_time
        and x_end_time > from_time
        and x_end_time < to_time
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and (x_end_time < to_time or x_end_time > from_time)
    );

Line: 255

    select count(*) into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time < to_time
        and x_end_time > from_time
        and x_end_time < to_time
	and rowid <> x_rowid
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and (x_end_time < to_time or x_end_time > from_time)
      	and rowid <> x_rowid
    );

Line: 278

    select count(*) into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code =  x_calendar_code
        and shift_num =  x_shift_num
        and from_time < to_time
        and x_start_time < x_end_time
        and x_start_time < from_time
        and x_end_time > to_time
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time < to_time
        and x_start_time < x_end_time
        and x_start_time > from_time
        and x_end_time < to_time
    );

Line: 296

    select count(*) into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code =  x_calendar_code
        and shift_num =  x_shift_num
        and from_time < to_time
        and x_start_time < x_end_time
        and x_start_time < from_time
        and x_end_time > to_time
	and rowid <> x_rowid
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time < to_time
        and x_start_time < x_end_time
        and x_start_time > from_time
        and x_end_time < to_time
      	and rowid <> x_rowid
    );

Line: 322

    select count(*) into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and x_start_time > x_end_time
        and x_start_time < from_time
        and x_end_time > to_time
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and x_start_time > x_end_time
        and x_start_time > from_time
        and x_end_time < to_time
    );

Line: 340

    select count(*) into dummy from DUAL where not exists
    (select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and x_start_time > x_end_time
        and x_start_time < from_time
        and x_end_time > to_time
  	and rowid <> x_rowid
    union
     select 1 from BOM_SHIFT_TIMES
      where calendar_code = x_calendar_code
        and shift_num = x_shift_num
        and from_time > to_time
        and x_start_time > x_end_time
        and x_start_time > from_time
        and x_end_time < to_time
  	and rowid <> x_rowid
    );