APPS.EAM_WB_UTILS dependencies on EAM_WB_UTILS

Line 1: PACKAGE BODY EAM_WB_UTILS AS

1: PACKAGE BODY EAM_WB_UTILS AS
2: /* $Header: EAMWBUTB.pls 120.26.12020000.5 2013/01/30 13:04:32 srkotika ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'EAM_WB_UTILS';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30):= 'EAM_WB_UTILS';

1: PACKAGE BODY EAM_WB_UTILS AS
2: /* $Header: EAMWBUTB.pls 120.26.12020000.5 2013/01/30 13:04:32 srkotika ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'EAM_WB_UTILS';
5:
6: procedure add_forecast(p_pm_forecast_id number) IS
7: begin
8: if current_forecasts.COUNT = 0 then

Line 1391: l_forecast_total := eam_wb_utils.get_forecast_total;

1387: l_prev_maint_id := -2;
1388: l_prev_maint_type := -2;
1389: l_prev_act_ass_id := -2;
1390: i:=1;
1391: l_forecast_total := eam_wb_utils.get_forecast_total;
1392:
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

Line 1436: l_forecast_id :=eam_wb_utils.current_forecasts.FIRST;

1432: end loop;
1433:
1434: if l_total = l_cnt then
1435: i:=1;
1436: l_forecast_id :=eam_wb_utils.current_forecasts.FIRST;
1437: while ( i <= l_forecast_total ) loop
1438:
1439: delete from eam_forecasted_work_orders
1440: where PM_FORECAST_ID = l_forecast_id;

Line 1443: l_forecast_id := eam_wb_utils.current_forecasts.NEXT(l_forecast_id);

1439: delete from eam_forecasted_work_orders
1440: where PM_FORECAST_ID = l_forecast_id;
1441:
1442: if i < l_forecast_total then
1443: l_forecast_id := eam_wb_utils.current_forecasts.NEXT(l_forecast_id);
1444: end if;
1445: i:=i+1;
1446: end loop;
1447: return true;

Line 1485: END eam_wb_utils;

1481: );
1482: return l_owning_department_id;
1483: END get_owning_dept_default;
1484:
1485: END eam_wb_utils;
1486: