APPS.BOM_COPY_CALENDAR dependencies on BOM_CALENDAR_SHIFTS

Line 484: insert into BOM_CALENDAR_SHIFTS

480:
481: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;
482: BEGIN
483:
484: insert into BOM_CALENDAR_SHIFTS
485: ( calendar_code,
486: shift_num,
487: last_update_date,
488: last_updated_by,

Line 538: from BOM_CALENDAR_SHIFTS bcs

534: bcs.attribute12,
535: bcs.attribute13,
536: bcs.attribute14,
537: bcs.attribute15
538: from BOM_CALENDAR_SHIFTS bcs
539: where bcs.calendar_code = x_calendar_code_from
540: and bcs.shift_num not in
541: ( select bcs1.shift_num
542: from BOM_CALENDAR_SHIFTS bcs1

Line 542: from BOM_CALENDAR_SHIFTS bcs1

538: from BOM_CALENDAR_SHIFTS bcs
539: where bcs.calendar_code = x_calendar_code_from
540: and bcs.shift_num not in
541: ( select bcs1.shift_num
542: from BOM_CALENDAR_SHIFTS bcs1
543: where bcs1.calendar_code = x_calendar_code_to );
544:
545: insert into BOM_SHIFT_TIMES
546: ( calendar_code,

Line 597: from BOM_SHIFT_TIMES bst1, BOM_CALENDAR_SHIFTS bcs5

593: bst1.attribute12,
594: bst1.attribute13,
595: bst1.attribute14,
596: bst1.attribute15
597: from BOM_SHIFT_TIMES bst1, BOM_CALENDAR_SHIFTS bcs5
598: where bcs5.last_updated_by = '-99999'
599: and bcs5.calendar_code = x_calendar_code_to
600: and bcs5.shift_num = bst1.shift_num
601: and bst1.calendar_code = x_calendar_code_from;

Line 666: from BOM_WORKDAY_PATTERNS bwp1, BOM_CALENDAR_SHIFTS bcs5

662: bwp1.attribute12,
663: bwp1.attribute13,
664: bwp1.attribute14,
665: bwp1.attribute15
666: from BOM_WORKDAY_PATTERNS bwp1, BOM_CALENDAR_SHIFTS bcs5
667: where bcs5.last_updated_by = '-99999'
668: and bcs5.calendar_code = x_calendar_code_to
669: and bcs5.shift_num = bwp1.shift_num
670: and bwp1.calendar_code = x_calendar_code_from;

Line 726: from BOM_SHIFT_EXCEPTIONS bse1, BOM_CALENDAR_SHIFTS bcs5

722: bse1.attribute12,
723: bse1.attribute13,
724: bse1.attribute14,
725: bse1.attribute15
726: from BOM_SHIFT_EXCEPTIONS bse1, BOM_CALENDAR_SHIFTS bcs5
727: where bcs5.last_updated_by = '-99999'
728: and bcs5.calendar_code = x_calendar_code_to
729: and bcs5.shift_num = bse1.shift_num
730: and bse1.calendar_code = x_calendar_code_from

Line 734: update BOM_CALENDAR_SHIFTS set

730: and bse1.calendar_code = x_calendar_code_from
731: and bse1.exception_date >= x_start_date
732: and bse1.exception_date <= x_end_date;
733:
734: update BOM_CALENDAR_SHIFTS set
735: last_updated_by = x_userid
736: where calendar_code = x_calendar_code_to
737: and last_updated_by = '-99999';
738:

Line 755: insert into BOM_CALENDAR_SHIFTS

751:
752:
753: BEGIN
754:
755: insert into BOM_CALENDAR_SHIFTS
756: ( calendar_code,
757: shift_num,
758: last_update_date,
759: last_updated_by,

Line 809: from BOM_CALENDAR_SHIFTS bcs

805: bcs.attribute12,
806: bcs.attribute13,
807: bcs.attribute14,
808: bcs.attribute15
809: from BOM_CALENDAR_SHIFTS bcs
810: where bcs.calendar_code = x_calendar_code_from
811: and bcs.shift_num = x_shift_num_from;
812:
813: insert into BOM_SHIFT_TIMES