[Home] [Help]
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,
547: shift_num,
548: from_time,
549: to_time,
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;
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
814: ( calendar_code,
815: shift_num,
816: from_time,
817: to_time,
861: bst4.attribute12,
862: bst4.attribute13,
863: bst4.attribute14,
864: bst4.attribute15
865: from BOM_SHIFT_TIMES bst4
866: where bst4.calendar_code = x_calendar_code_from
867: and bst4.shift_num = x_shift_num_from;
868:
869:
1003: x_userid NUMBER) IS
1004:
1005: BEGIN
1006:
1007: insert into BOM_SHIFT_TIMES
1008: ( calendar_code,
1009: shift_num,
1010: from_time,
1011: to_time,
1055: bst.attribute12,
1056: bst.attribute13,
1057: bst.attribute14,
1058: bst.attribute15
1059: from BOM_SHIFT_TIMES bst
1060: where bst.calendar_code = x_calendar_code_from
1061: and bst.shift_num = x_shift_num_from
1062: and not exists ( select 1
1063: from BOM_SHIFT_TIMES bst1
1059: from BOM_SHIFT_TIMES bst
1060: where bst.calendar_code = x_calendar_code_from
1061: and bst.shift_num = x_shift_num_from
1062: and not exists ( select 1
1063: from BOM_SHIFT_TIMES bst1
1064: where bst1.calendar_code = x_calendar_code_to
1065: and bst1.shift_num = x_shift_num_to
1066: and bst1.from_time = bst.from_time
1067: and bst1.to_time = bst.to_time );