APPS.GMP_CALENDAR_API dependencies on BOM_CALENDARS

Line 82: FROM bom_Calendars

78: AND DECODE(sht.to_time,0,86400,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 664: FROM bom_Calendars

660: x_return_status OUT NOCOPY VARCHAR2) IS
661:
662: CURSOR Cur_cal_check ( c_calendar_code VARCHAR2 ) IS
663: SELECT COUNT(1)
664: FROM bom_Calendars
665: WHERE calendar_code = c_calendar_code;
666:
667: CURSOR Cur_cal_date ( c_calendar_code VARCHAR2 ) IS
668: SELECT calendar_start_date ,

Line 670: FROM bom_Calendars

666:
667: CURSOR Cur_cal_date ( c_calendar_code VARCHAR2 ) IS
668: SELECT calendar_start_date ,
669: calendar_end_date
670: FROM bom_Calendars
671: WHERE calendar_code = c_calendar_code;
672:
673: v_min_date date;
674: v_max_date date;

Line 799: FROM bom_calendars cal,

795: c_start_date DATE,
796: c_end_date DATE) IS
797: SELECT sd.shift_date calendar_date,
798: decode(SUM(decode(sd.seq_num,NULL,0,1)),0,0,1) l_work_day
799: FROM bom_calendars cal,
800: bom_shift_dates sd,
801: bom_shift_times st
802: WHERE cal.calendar_code = c_calendar_code
803: AND sd.calendar_code = cal.calendar_code

Line 937: FROM bom_calendars cal,

933: c_start_date DATE ,
934: c_end_date DATE ) IS
935: SELECT sd.shift_date calendar_date,
936: SUM((DECODE(st.to_time,0,86400,st.to_time) - st.from_time)/3600) duration
937: FROM bom_calendars cal,
938: bom_shift_dates sd,
939: bom_shift_times st
940: WHERE cal.calendar_code = c_calendar_code
941: AND sd.calendar_code = cal.calendar_code

Line 1168: FROM bom_Calendars

1164: x_return_status OUT NOCOPY VARCHAR2) IS
1165:
1166: CURSOR Cur_cal_check IS
1167: SELECT COUNT(1)
1168: FROM bom_Calendars
1169: WHERE calendar_code = p_calendar_code;
1170:
1171: CURSOR Cur_cal_date IS
1172: SELECT calendar_start_date ,

Line 1174: FROM bom_Calendars

1170:
1171: CURSOR Cur_cal_date IS
1172: SELECT calendar_start_date ,
1173: calendar_end_date
1174: FROM bom_Calendars
1175: WHERE calendar_code = p_calendar_code;
1176:
1177: GMP_SDATE_BEFORE_CAL_SDATE EXCEPTION;
1178: GMP_EDATE_AFTER_CAL_EDATE EXCEPTION;

Line 1262: FROM bom_Calendars

1258: x_return_status OUT NOCOPY VARCHAR2) IS
1259:
1260: CURSOR Cur_cal_check (c_calendar_code VARCHAR2 ) IS
1261: SELECT COUNT(1)
1262: FROM bom_Calendars
1263: WHERE calendar_code = c_calendar_code;
1264:
1265: INVALID_DATE_RANGE EXCEPTION;
1266: CALENDAR_NULL EXCEPTION;

Line 1385: FROM bom_calendars cal,

1381: x_date date;
1382:
1383: CURSOR get_datetime_cur (c_calendar_code VARCHAR2, c_cal_date DATE) IS
1384: SELECT 1
1385: FROM bom_calendars cal,
1386: bom_shift_dates sd,
1387: bom_shift_times st
1388: WHERE cal.calendar_code = c_calendar_code
1389: AND sd.calendar_code = cal.calendar_code

Line 1561: FROM bom_calendars bd,

1557: SELECT 1
1558: FROM sys.dual
1559: WHERE EXISTS (
1560: select 'x'
1561: FROM bom_calendars bd,
1562: bom_shift_dates sd,
1563: bom_shift_times st
1564: WHERE bd.calendar_code = p_calendar_id
1565: AND sd.calendar_code = bd.calendar_code

Line 1579: FROM bom_calendars bd,

1575:
1576:
1577: CURSOR get_NextDatetime_cur (p_calendar_id VARCHAR2 , p_cal_date DATE) IS
1578: SELECT min (sd.shift_date + (st.from_time/86400))
1579: FROM bom_calendars bd,
1580: bom_shift_dates sd,
1581: bom_shift_times st
1582: WHERE bd.calendar_code = p_calendar_id
1583: AND sd.calendar_code = bd.calendar_code

Line 1598: FROM bom_calendars bd,

1594: (sd.shift_date+1),sd.shift_date) ) +
1595: (decode(sign(st.from_time + (Decode(St.To_Time,0,86400,St.To_Time)- st.from_time) - 86400),1,(st.from_time
1596: + (Decode(St.To_Time,0,86400,St.To_Time)- st.from_time) - 86400),(st.from_time + (Decode(St.To_Time,0,86400,St.To_Time)- st.from_time)))/86400 ) )
1597: )
1598: FROM bom_calendars bd,
1599: bom_shift_dates sd,
1600: bom_shift_times st
1601: WHERE bd.calendar_code = p_calendar_id
1602: AND sd.calendar_code = bd.calendar_code

Line 1809: || ' FROM bom_calendars cal, '

1805: sql_cal := ' SELECT sd.shift_date calendar_date, '
1806: || ' sd.shift_num shift_no, '
1807: || ' st.from_time from_time, '
1808: || ' decode(st.to_time,0,86400,st.to_time) to_time '
1809: || ' FROM bom_calendars cal, '
1810: || ' bom_shift_dates sd, '
1811: || ' bom_shift_times st '
1812: || ' WHERE cal.calendar_code = :curr_cal_code '
1813: || ' AND sd.calendar_code = cal.calendar_code '