[Home] [Help]
94:
95:
96: PROCEDURE Drop_Cal_Cancelled_Excepts IS
97: BEGIN
98: delete from BOM_CALENDAR_EXCEPTIONS
99: where created_by = '-99999';
100:
101: if (SQL%NOTFOUND) then
102: null;
171:
172: /* ********************************************************************** */
173: /* copy_type = 5 */
174: /* copies exceptions from an exception set to a calendar */
175: /* from BOM_EXCEPTION_SETS into BOM_CALENDAR_EXCEPTIONS */
176: /* ********************************************************************** */
177:
178: elsif copy_type = 5 then
179: Copy_Exceptions_Cal (x_calendar_code_to, x_exception_set_name,
182:
183: /* ********************************************************************** */
184: /* copy_type = 6 */
185: /* copies exceptions from one calendar to another */
186: /* from BOM_CALENDAR_EXCEPTIONS into BOM_CALENDAR_EXCEPTIONS */
187: /* ********************************************************************** */
188:
189: elsif copy_type = 6 then
190: Copy_Cal_Exceptions (x_calendar_code_from, x_calendar_code_to,
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,
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,
405: x_userid NUMBER) IS
406:
407: BEGIN
408:
409: insert into BOM_CALENDAR_EXCEPTIONS
410: ( calendar_code,
411: exception_set_id,
412: exception_date,
413: last_update_date,
458: bce.attribute12,
459: bce.attribute13,
460: bce.attribute14,
461: bce.attribute15
462: from BOM_CALENDAR_EXCEPTIONS bce
463: where bce.calendar_code = x_calendar_code_from
464: and bce.exception_date not in
465: (select bce1.exception_date
466: from BOM_CALENDAR_EXCEPTIONS bce1
462: from BOM_CALENDAR_EXCEPTIONS bce
463: where bce.calendar_code = x_calendar_code_from
464: and bce.exception_date not in
465: (select bce1.exception_date
466: from BOM_CALENDAR_EXCEPTIONS bce1
467: where bce1.calendar_code = x_calendar_code_to)
468: and bce.exception_date >= x_start_date
469: and bce.exception_date <= x_end_date;
470: END Copy_Cal_Exceptions;
1156: x_userid NUMBER) IS
1157:
1158: BEGIN
1159:
1160: insert into BOM_CALENDAR_EXCEPTIONS
1161: ( calendar_code,
1162: exception_set_id,
1163: exception_date,
1164: exception_type,
1213: where bes.exception_set_name = x_exception_set_name
1214: and bes.exception_set_id = besd.exception_set_id
1215: and trunc(besd.exception_date) not in (
1216: select trunc(bce.exception_date)
1217: from BOM_CALENDAR_EXCEPTIONS bce
1218: where bce.calendar_code = x_calendar_code_to )
1219: and trunc(besd.exception_date) >= x_start_date
1220: and trunc(besd.exception_date) <= x_end_date;
1221:
1231: x_userid NUMBER) IS
1232:
1233: BEGIN
1234:
1235: insert into BOM_CALENDAR_EXCEPTIONS
1236: ( calendar_code,
1237: exception_set_id,
1238: exception_date,
1239: last_update_date,
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
1292: from BOM_CALENDAR_EXCEPTIONS bce9
1293: where bce9.calendar_code = x_calendar_code_to)
1294: and bse9.exception_date >= x_start_date
1295: and bse9.exception_date <= x_end_date;
1296:
1437: bce9.attribute12,
1438: bce9.attribute13,
1439: bce9.attribute14,
1440: bce9.attribute15
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