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.GMP_CALENDAR_API dependencies on BOM_CALENDARS

Line 82: FROM bom_Calendars

78: AND sht.to_time > sht.from_time);
79: --
80: CURSOR Cur_cal_check IS
81: SELECT COUNT(1)
82: FROM bom_Calendars
83: WHERE calendar_code = p_calendar_code;
84:
85: CURSOR Cur_cal_date IS
86: SELECT calendar_start_date,

Line 88: FROM bom_calendars

84:
85: CURSOR Cur_cal_date IS
86: SELECT calendar_start_date,
87: calendar_end_date
88: FROM bom_calendars
89: WHERE calendar_code = p_calendar_code;
90:
91: l_duration NUMBER := 0 ;
92: v_min_date date ;

Line 240: FROM bom_calendars cal,

236: sd.shift_num shift_num,
237: st.from_time from_time,
238: decode(sign(st.to_time - st.from_time),1,(st.to_time - st.from_time),0,0,((86400 - st.from_time)+ st.from_time)) duration,
239: st.to_time to_time
240: FROM bom_calendars cal,
241: bom_shift_dates sd,
242: bom_shift_times st
243: WHERE cal.calendar_code = c_calendar_code
244: AND sd.calendar_code = cal.calendar_code

Line 260: FROM bom_calendars cal,

256: sd.shift_num shift_num,
257: st.from_time from_time,
258: decode(sign(st.to_time - st.from_time),1,(st.to_time - st.from_time),0,0,((86400 - st.from_time)+ st.from_time)) duration,
259: st.to_time to_time
260: FROM bom_calendars cal,
261: bom_shift_dates sd,
262: bom_shift_times st
263: WHERE cal.calendar_code = c_calendar_code
264: AND sd.calendar_code = cal.calendar_code

Line 600: FROM bom_Calendars

596: x_return_status OUT NOCOPY VARCHAR2) IS
597:
598: CURSOR Cur_cal_check ( c_calendar_code VARCHAR2 ) IS
599: SELECT COUNT(1)
600: FROM bom_Calendars
601: WHERE calendar_code = c_calendar_code;
602:
603: CURSOR Cur_cal_date ( c_calendar_code VARCHAR2 ) IS
604: SELECT calendar_start_date ,

Line 606: FROM bom_Calendars

602:
603: CURSOR Cur_cal_date ( c_calendar_code VARCHAR2 ) IS
604: SELECT calendar_start_date ,
605: calendar_end_date
606: FROM bom_Calendars
607: WHERE calendar_code = c_calendar_code;
608:
609: v_min_date date;
610: v_max_date date;

Line 735: FROM bom_calendars cal,

731: c_start_date DATE,
732: c_end_date DATE) IS
733: SELECT sd.shift_date calendar_date,
734: decode(SUM(decode(sd.seq_num,NULL,0,1)),0,0,1) l_work_day
735: FROM bom_calendars cal,
736: bom_shift_dates sd,
737: bom_shift_times st
738: WHERE cal.calendar_code = c_calendar_code
739: AND sd.calendar_code = cal.calendar_code

Line 873: FROM bom_calendars cal,

869: c_start_date DATE ,
870: c_end_date DATE ) IS
871: SELECT sd.shift_date calendar_date,
872: SUM((st.to_time - st.from_time)/3600) duration
873: FROM bom_calendars cal,
874: bom_shift_dates sd,
875: bom_shift_times st
876: WHERE cal.calendar_code = c_calendar_code
877: AND sd.calendar_code = cal.calendar_code

Line 1104: FROM bom_Calendars

1100: x_return_status OUT NOCOPY VARCHAR2) IS
1101:
1102: CURSOR Cur_cal_check IS
1103: SELECT COUNT(1)
1104: FROM bom_Calendars
1105: WHERE calendar_code = p_calendar_code;
1106:
1107: CURSOR Cur_cal_date IS
1108: SELECT calendar_start_date ,

Line 1110: FROM bom_Calendars

1106:
1107: CURSOR Cur_cal_date IS
1108: SELECT calendar_start_date ,
1109: calendar_end_date
1110: FROM bom_Calendars
1111: WHERE calendar_code = p_calendar_code;
1112:
1113: GMP_SDATE_BEFORE_CAL_SDATE EXCEPTION;
1114: GMP_EDATE_AFTER_CAL_EDATE EXCEPTION;

Line 1198: FROM bom_Calendars

1194: x_return_status OUT NOCOPY VARCHAR2) IS
1195:
1196: CURSOR Cur_cal_check (c_calendar_code VARCHAR2 ) IS
1197: SELECT COUNT(1)
1198: FROM bom_Calendars
1199: WHERE calendar_code = c_calendar_code;
1200:
1201: INVALID_DATE_RANGE EXCEPTION;
1202: CALENDAR_NULL EXCEPTION;

Line 1321: FROM bom_calendars cal,

1317: x_date date;
1318:
1319: CURSOR get_datetime_cur (c_calendar_code VARCHAR2, c_cal_date DATE) IS
1320: SELECT 1
1321: FROM bom_calendars cal,
1322: bom_shift_dates sd,
1323: bom_shift_times st
1324: WHERE cal.calendar_code = c_calendar_code
1325: AND sd.calendar_code = cal.calendar_code

Line 1494: FROM bom_calendars bd,

1490: SELECT 1
1491: FROM sys.dual
1492: WHERE EXISTS (
1493: select 'x'
1494: FROM bom_calendars bd,
1495: bom_shift_dates sd,
1496: bom_shift_times st
1497: WHERE bd.calendar_code = p_calendar_id
1498: AND sd.calendar_code = bd.calendar_code

Line 1512: FROM bom_calendars bd,

1508:
1509:
1510: CURSOR get_NextDatetime_cur (p_calendar_id VARCHAR2 , p_cal_date DATE) IS
1511: SELECT min (sd.shift_date + (st.from_time/86400))
1512: FROM bom_calendars bd,
1513: bom_shift_dates sd,
1514: bom_shift_times st
1515: WHERE bd.calendar_code = p_calendar_id
1516: AND sd.calendar_code = bd.calendar_code

Line 1531: FROM bom_calendars bd,

1527: (sd.shift_date+1),sd.shift_date) ) +
1528: (decode(sign(st.from_time + (st.to_time- st.from_time) - 86400),1,(st.from_time
1529: + (st.to_time- st.from_time) - 86400),(st.from_time + (st.to_time- st.from_time)))/86400 ) )
1530: )
1531: FROM bom_calendars bd,
1532: bom_shift_dates sd,
1533: bom_shift_times st
1534: WHERE bd.calendar_code = p_calendar_id
1535: AND sd.calendar_code = bd.calendar_code