[Home] [Help]
205: l_days NUMBER :=0;
206:
207: CURSOR c1 IS
208: SELECT count(*) count
209: FROM bom_calendar_dates bcd,
210: mtl_parameters mp
211: WHERE mp.organization_id = g_kanban_info_rec.organization_id
212: AND bcd.calendar_code = mp.calendar_code
213: AND bcd.exception_set_id = mp.calendar_exception_set_id
310: IF p_bucket_type = 2 THEN
311:
312: SELECT count(*)
313: INTO l_total_workdays
314: FROM bom_calendar_dates cd,
315: bom_cal_week_start_dates ws,
316: mtl_parameters mp
317: WHERE mp.organization_id = g_kanban_info_rec.organization_id
318: AND ws.calendar_code = mp.calendar_code
327: ELSIF p_bucket_type = 3 THEN
328:
329: SELECT count(*)
330: INTO l_total_workdays
331: FROM bom_calendar_dates cd,
332: bom_period_start_dates ps,
333: mtl_parameters mp
334: WHERE mp.organization_id = g_kanban_info_rec.organization_id
335: AND ps.calendar_code = mp.calendar_code
389: -- are working with
390:
391: SELECT count(*)
392: INTO l_current_workdays
393: FROM bom_calendar_dates cd,
394: mtl_parameters mp
395: WHERE mp.organization_id = g_kanban_info_rec.organization_id
396: AND cd.calendar_code = mp.calendar_code
397: AND cd.exception_set_id = mp.calendar_exception_set_id
486:
487: -- cursor for repetitive daily forecast dates
488: cursor cur_daily_forecasts is
489: SELECT bcd.calendar_date
490: FROM bom_calendar_dates bcd, mtl_parameters mp
491: WHERE mp.organization_id = g_kanban_info_rec.organization_id
492: AND bcd.calendar_code = mp.calendar_code
493: AND bcd.exception_set_id = mp.calendar_exception_set_id
494: AND (bcd.calendar_date BETWEEN l_rate_start_date AND
3938: --first calculate the total number of workdays between start date
3939: --and cutoff date specified
3940: SELECT count(*)
3941: INTO l_total_workdays
3942: FROM bom_calendar_dates bcd,
3943: mtl_parameters mp
3944: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3945: AND bcd.calendar_code = mp.calendar_code
3946: AND bcd.seq_num IS NOT NULL