[Home] [Help]
5:
6: procedure add_forecast(p_pm_forecast_id number) IS
7: begin
8: if current_forecasts.COUNT = 0 then
9: current_forecasts_index := system.eam_wipid_tab_type();
10: end if;
11: current_forecasts(p_pm_forecast_id) := p_pm_forecast_id;
12: current_forecasts_index.extend;
13: current_forecasts_index2(p_pm_forecast_id) := current_forecasts_index.last;
26: begin
27: current_forecasts := empty_id_list;
28: current_forecasts_index2 := empty_id_list;
29: if current_forecasts.COUNT = 0 then
30: current_forecasts_index := system.eam_wipid_tab_type();
31: end if;
32: current_forecasts_index.delete;
33: end clear_forecasts;
34:
1393: for c1 in (
1394: select fwo.cycle_id,fwo.seq_id,eps.maintenance_object_id,eps.maintenance_object_type,fwo.activity_association_id
1395: from eam_forecasted_work_orders fwo,eam_pm_schedulings eps
1396: where fwo.pm_schedule_id=eps.pm_schedule_id and fwo.pm_forecast_id in (
1397: ( select * from table( cast ( current_forecasts_index as system.eam_wipid_tab_type
1398: )
1399: )
1400: ) )
1401: and action_type <>3 and action_type <> 4 order by maintenance_object_id,maintenance_object_type,fwo.activity_association_id,cycle_id desc,seq_id desc