APPS.BOM_COPY_CALENDAR dependencies on BOM_EXCEPTION_SETS

Line 175: /* from BOM_EXCEPTION_SETS into BOM_CALENDAR_EXCEPTIONS */

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,

Line 208: /* from BOM_EXCEPTION_SETS into BOM_SHIFT_EXCEPTIONS */

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,

Line 1212: from BOM_EXCEPTION_SET_DATES besd, BOM_EXCEPTION_SETS bes

1208: besd.attribute12,
1209: besd.attribute13,
1210: besd.attribute14,
1211: besd.attribute15
1212: from BOM_EXCEPTION_SET_DATES besd, BOM_EXCEPTION_SETS bes
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)

Line 1364: from BOM_EXCEPTION_SET_DATES besd, BOM_EXCEPTION_SETS bes

1360: besd.attribute12,
1361: besd.attribute13,
1362: besd.attribute14,
1363: besd.attribute15
1364: from BOM_EXCEPTION_SET_DATES besd, BOM_EXCEPTION_SETS bes
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)