eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_COPY_CALENDAR dependencies on BOM_WORKDAY_PATTERNS

Line 251: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;

247:
248: PROCEDURE Copy_Cal_Workday_Patterns (x_calendar_code_from VARCHAR2,
249: x_calendar_code_to VARCHAR2,
250: x_userid NUMBER) IS
251: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;
252: BEGIN
253:
254: select NVL(MAX(seq_num),0)
255: into v_max_seq_num

Line 256: from BOM_WORKDAY_PATTERNS bwp

252: BEGIN
253:
254: select NVL(MAX(seq_num),0)
255: into v_max_seq_num
256: from BOM_WORKDAY_PATTERNS bwp
257: where bwp.calendar_code = x_calendar_code_to
258: and shift_num is null;
259:
260: insert into BOM_WORKDAY_PATTERNS

Line 260: insert into BOM_WORKDAY_PATTERNS

256: from BOM_WORKDAY_PATTERNS bwp
257: where bwp.calendar_code = x_calendar_code_to
258: and shift_num is null;
259:
260: insert into BOM_WORKDAY_PATTERNS
261: ( calendar_code,
262: seq_num,
263: last_update_date,
264: last_updated_by,

Line 314: from BOM_WORKDAY_PATTERNS bwp

310: bwp.attribute12,
311: bwp.attribute13,
312: bwp.attribute14,
313: bwp.attribute15
314: from BOM_WORKDAY_PATTERNS bwp
315: where bwp.calendar_code = x_calendar_code_from
316: and bwp.shift_num is null;
317:
318: END Copy_Cal_Workday_Patterns;

Line 327: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;

323: x_shift_num_from NUMBER,
324: x_shift_num_to NUMBER,
325: x_userid NUMBER) IS
326:
327: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;
328:
329: BEGIN
330:
331: select NVL(MAX(seq_num),0)

Line 333: from BOM_WORKDAY_PATTERNS bwp

329: BEGIN
330:
331: select NVL(MAX(seq_num),0)
332: into v_max_seq_num
333: from BOM_WORKDAY_PATTERNS bwp
334: where bwp.calendar_code = x_calendar_code_to
335: and shift_num is not null;
336:
337: insert into BOM_WORKDAY_PATTERNS

Line 337: insert into BOM_WORKDAY_PATTERNS

333: from BOM_WORKDAY_PATTERNS bwp
334: where bwp.calendar_code = x_calendar_code_to
335: and shift_num is not null;
336:
337: insert into BOM_WORKDAY_PATTERNS
338: ( calendar_code,
339: shift_num,
340: seq_num,
341: last_update_date,

Line 393: from BOM_WORKDAY_PATTERNS bwp1

389: bwp1.attribute12,
390: bwp1.attribute13,
391: bwp1.attribute14,
392: bwp1.attribute15
393: from BOM_WORKDAY_PATTERNS bwp1
394: where bwp1.calendar_code = x_calendar_code_from
395: and bwp1.shift_num = x_shift_num_from;
396:
397: END Copy_Shift_Workday_Patterns;

Line 481: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;

477: x_start_date DATE,
478: x_end_date DATE,
479: x_userid NUMBER) IS
480:
481: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;
482: BEGIN
483:
484: insert into BOM_CALENDAR_SHIFTS
485: ( calendar_code,

Line 606: from BOM_WORKDAY_PATTERNS bwp

602:
603:
604: select NVL(MAX(seq_num),0)
605: into v_max_seq_num
606: from BOM_WORKDAY_PATTERNS bwp
607: where bwp.calendar_code = x_calendar_code_to
608: and shift_num is not null;
609:
610: insert into BOM_WORKDAY_PATTERNS

Line 610: insert into BOM_WORKDAY_PATTERNS

606: from BOM_WORKDAY_PATTERNS bwp
607: where bwp.calendar_code = x_calendar_code_to
608: and shift_num is not null;
609:
610: insert into BOM_WORKDAY_PATTERNS
611: ( calendar_code,
612: shift_num,
613: seq_num,
614: last_update_date,

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 750: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;

746: x_start_date DATE,
747: x_end_date DATE,
748: x_userid NUMBER) IS
749:
750: v_max_seq_num BOM_WORKDAY_PATTERNS.seq_num%TYPE;
751:
752:
753: BEGIN
754:

Line 872: from BOM_WORKDAY_PATTERNS bwp

868:
869:
870: select NVL(MAX(seq_num),0)
871: into v_max_seq_num
872: from BOM_WORKDAY_PATTERNS bwp
873: where bwp.calendar_code = x_calendar_code_to;
874:
875: insert into BOM_WORKDAY_PATTERNS
876: ( calendar_code,

Line 875: insert into BOM_WORKDAY_PATTERNS

871: into v_max_seq_num
872: from BOM_WORKDAY_PATTERNS bwp
873: where bwp.calendar_code = x_calendar_code_to;
874:
875: insert into BOM_WORKDAY_PATTERNS
876: ( calendar_code,
877: shift_num,
878: seq_num,
879: last_update_date,

Line 931: from BOM_WORKDAY_PATTERNS bwp7

927: bwp7.attribute12,
928: bwp7.attribute13,
929: bwp7.attribute14,
930: bwp7.attribute15
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