[Home] [Help]
106:
107:
108: PROCEDURE Drop_Shift_Cancelled_Excepts IS
109: BEGIN
110: delete from BOM_SHIFT_EXCEPTIONS
111: where created_by = '-99999';
112:
113: if (SQL%NOTFOUND) then
114: null;
193:
194: /* ********************************************************************** */
195: /* copy_type = 7 */
196: /* copies exceptions from a shift to a calendar */
197: /* from BOM_SHIFT_EXCEPTIONS into BOM_CALENDAR_EXCEPTIONS */
198: /* ********************************************************************** */
199:
200: elsif copy_type = 7 then
201: Copy_Shift_Exceptions_Cal (x_calendar_code_from, x_calendar_code_to,
204:
205: /* ********************************************************************** */
206: /* copy_type = 8 */
207: /* copies exceptions from an exception set to a shift */
208: /* from BOM_EXCEPTION_SETS into BOM_SHIFT_EXCEPTIONS */
209: /* ********************************************************************** */
210:
211: elsif copy_type = 8 then
212: Copy_Exceptions_Shift (x_calendar_code_to, x_shift_num_to,
215:
216: /* ********************************************************************** */
217: /* copy_type = 9 */
218: /* copies exceptions from a calendar to a shift */
219: /* from BOM_CALENDAR_EXCEPTIONS into BOM_SHIFT_EXCEPTIONS */
220: /* ********************************************************************** */
221:
222: elsif copy_type = 9 then
223: Copy_Cal_Exceptions_Shift (x_calendar_code_from, x_calendar_code_to,
226:
227: /* ********************************************************************** */
228: /* copy_type = 10 */
229: /* copies exceptions from one shift to another */
230: /* from BOM_SHIFT_EXCEPTIONS into BOM_SHIFT_EXCEPTIONS */
231: /* ********************************************************************** */
232:
233: elsif copy_type = 10 then
234: Copy_Shift_Exceptions (x_calendar_code_from, x_calendar_code_to,
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;
671:
672: insert into BOM_SHIFT_EXCEPTIONS
673: ( calendar_code,
674: shift_num,
675: exception_set_id,
676: exception_date,
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
931: from BOM_WORKDAY_PATTERNS bwp7
932: where bwp7.calendar_code = x_calendar_code_from
933: and bwp7.shift_num = x_shift_num_from;
934:
935: insert into BOM_SHIFT_EXCEPTIONS
936: ( calendar_code,
937: shift_num,
938: exception_set_id,
939: exception_date,
985: bse1.attribute12,
986: bse1.attribute13,
987: bse1.attribute14,
988: bse1.attribute15
989: from BOM_SHIFT_EXCEPTIONS bse1
990: where bse1.calendar_code = x_calendar_code_from
991: and bse1.shift_num = x_shift_num_from
992: and bse1.exception_date >= x_start_date
993: and bse1.exception_date <= x_end_date;
1079: x_userid NUMBER) IS
1080:
1081: BEGIN
1082:
1083: insert into BOM_SHIFT_EXCEPTIONS
1084: ( calendar_code,
1085: shift_num,
1086: exception_set_id,
1087: exception_date,
1133: bse.attribute12,
1134: bse.attribute13,
1135: bse.attribute14,
1136: bse.attribute15
1137: from BOM_SHIFT_EXCEPTIONS bse
1138: where bse.calendar_code = x_calendar_code_from
1139: and bse.shift_num = x_shift_num_from
1140: and bse.exception_date not in
1141: (select bse1.exception_date
1138: where bse.calendar_code = x_calendar_code_from
1139: and bse.shift_num = x_shift_num_from
1140: and bse.exception_date not in
1141: (select bse1.exception_date
1142: from BOM_SHIFT_EXCEPTIONS bse1
1143: where bse1.calendar_code = x_calendar_code_to
1144: and bse1.shift_num = x_shift_num_to)
1145: and bse.exception_date >= x_start_date
1146: and bse.exception_date <= x_end_date;
1283: bse9.attribute12,
1284: bse9.attribute13,
1285: bse9.attribute14,
1286: bse9.attribute15
1287: from BOM_SHIFT_EXCEPTIONS bse9
1288: where bse9.calendar_code = x_calendar_code_from
1289: and bse9.shift_num = x_shift_num_from
1290: and bse9.exception_date not in
1291: (select bce9.exception_date
1306: x_userid NUMBER) IS
1307:
1308: BEGIN
1309:
1310: insert into BOM_SHIFT_EXCEPTIONS
1311: ( calendar_code,
1312: shift_num,
1313: exception_set_id,
1314: exception_date,
1365: where bes.exception_set_name = x_exception_set_name
1366: and bes.exception_set_id = besd.exception_set_id
1367: and trunc(besd.exception_date) not in (
1368: select trunc(bse.exception_date)
1369: from BOM_SHIFT_EXCEPTIONS bse
1370: where bse.calendar_code = x_calendar_code_to
1371: and bse.shift_num = x_shift_num_to )
1372: and trunc(besd.exception_date) >= x_start_date
1373: and trunc(besd.exception_date) <= x_end_date ;
1383: x_userid NUMBER) IS
1384:
1385: BEGIN
1386:
1387: insert into BOM_SHIFT_EXCEPTIONS
1388: ( calendar_code,
1389: shift_num,
1390: exception_set_id,
1391: exception_date,
1441: from BOM_CALENDAR_EXCEPTIONS bce9
1442: where bce9.calendar_code = x_calendar_code_from
1443: and bce9.exception_date not in
1444: (select bse9.exception_date
1445: from BOM_SHIFT_EXCEPTIONS bse9
1446: where bse9.calendar_code = x_calendar_code_to
1447: and bse9.shift_num = x_shift_num_to)
1448: and bce9.exception_date >= x_start_date
1449: and bce9.exception_date <= x_end_date;