[Home] [Help]
208: l_days NUMBER :=0;
209:
210: CURSOR c1 IS
211: SELECT count(*) count
212: FROM bom_calendar_dates bcd,
213: mtl_parameters mp
214: WHERE mp.organization_id = g_kanban_info_rec.organization_id
215: AND bcd.calendar_code = mp.calendar_code
216: AND bcd.exception_set_id = mp.calendar_exception_set_id
313: IF p_bucket_type = 2 THEN
314:
315: SELECT count(*)
316: INTO l_total_workdays
317: FROM bom_calendar_dates cd,
318: bom_cal_week_start_dates ws,
319: mtl_parameters mp
320: WHERE mp.organization_id = g_kanban_info_rec.organization_id
321: AND ws.calendar_code = mp.calendar_code
330: ELSIF p_bucket_type = 3 THEN
331:
332: SELECT count(*)
333: INTO l_total_workdays
334: FROM bom_calendar_dates cd,
335: bom_period_start_dates ps,
336: mtl_parameters mp
337: WHERE mp.organization_id = g_kanban_info_rec.organization_id
338: AND ps.calendar_code = mp.calendar_code
392: -- are working with
393:
394: SELECT count(*)
395: INTO l_current_workdays
396: FROM bom_calendar_dates cd,
397: mtl_parameters mp
398: WHERE mp.organization_id = g_kanban_info_rec.organization_id
399: AND cd.calendar_code = mp.calendar_code
400: AND cd.exception_set_id = mp.calendar_exception_set_id
489:
490: -- cursor for repetitive daily forecast dates
491: cursor cur_daily_forecasts is
492: SELECT bcd.calendar_date
493: FROM bom_calendar_dates bcd, mtl_parameters mp
494: WHERE mp.organization_id = g_kanban_info_rec.organization_id
495: AND bcd.calendar_code = mp.calendar_code
496: AND bcd.exception_set_id = mp.calendar_exception_set_id
497: AND (bcd.calendar_date BETWEEN l_rate_start_date AND
4432: --first calculate the total number of workdays between start date
4433: --and cutoff date specified
4434: SELECT count(*)
4435: INTO l_total_workdays
4436: FROM bom_calendar_dates bcd,
4437: mtl_parameters mp
4438: WHERE mp.organization_id = g_kanban_info_rec.organization_id
4439: AND bcd.calendar_code = mp.calendar_code
4440: AND bcd.seq_num IS NOT NULL