eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_FORECAST_PVT dependencies on EAM_FORECASTS

Line 22: -- values passed by this API into EAM_FORECASTS_CEBBA table. --

18: -- work order and passes the record back to the calling program. --
19: -- --
20: -- It is called from the Maintenance and Budgeting engine, to detemine --
21: -- costs of Historical Type Forecats. The calling program will insert --
22: -- values passed by this API into EAM_FORECASTS_CEBBA table. --
23: -- --
24: -- PURPOSE: --
25: -- Oracle Applications Rel 12 --
26: -- --

Line 371: delete from eam_forecasts where

367: procedure delete_forecast(p_forecast_id IN number)IS
368:
369: BEGIN
370:
371: delete from eam_forecasts where
372: forecast_id = p_forecast_id;
373:
374: delete from eam_forecast_wdj where
375: forecast_id = p_forecast_id;

Line 442: update eam_forecasts

438: x_return_status => l_return_status,
439: x_msg_count => l_msg_count,
440: x_msg_data => l_msg_data);
441:
442: update eam_forecasts
443: set completion_date = SYSDATE
444: where forecast_id = p_forecast_id;
445:
446:

Line 472: FUNCTION get_asset_cursor(p_forecast_rec eam_forecasts%rowtype)

468: END IF;
469: END debug;
470:
471:
472: FUNCTION get_asset_cursor(p_forecast_rec eam_forecasts%rowtype)
473: RETURN forecast_asset_cursor_type
474: IS
475:
476: BEGIN

Line 489: FUNCTION get_wip_table(p_forecast_rec eam_forecasts%rowtype)

485: p_forecast_rec.area_to);
486: END get_asset_cursor;
487:
488:
489: FUNCTION get_wip_table(p_forecast_rec eam_forecasts%rowtype)
490: RETURN wo_table_type
491: IS
492: --
493: TYPE wo_cursor IS REF CURSOR;

Line 865: FUNCTION get_asset_query(p_forecast_rec eam_forecasts%rowtype)

861: return l_asset_cursor;
862:
863: END get_asset_cursor;
864:
865: FUNCTION get_asset_query(p_forecast_rec eam_forecasts%rowtype)
866: RETURN VARCHAR2
867: IS
868:
869: BEGIN

Line 1056: p_forecast_id IN eam_forecasts.forecast_id%TYPE,

1052: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1055: p_debug IN VARCHAR2 ,
1056: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
1057: x_return_status OUT NOCOPY VARCHAR2 ,
1058: x_msg_count OUT NOCOPY NUMBER ,
1059: x_msg_data OUT NOCOPY VARCHAR2
1060:

Line 1068: v_forecast_rec eam_forecasts%ROWTYPE;

1064: l_api_name CONSTANT VARCHAR2(30) := 'Extract_Forecast';
1065: l_api_version CONSTANT NUMBER := 1.0;
1066: l_return_status VARCHAR2(1);
1067:
1068: v_forecast_rec eam_forecasts%ROWTYPE;
1069:
1070:
1071: begin
1072: -- Standard Start of API savepoint

Line 1091: FROM eam_forecasts

1087: -- Initialize API return status to success
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:
1090: SELECT * INTO v_forecast_rec
1091: FROM eam_forecasts
1092: WHERE forecast_id = p_forecast_id;
1093:
1094: -- Set profile so org is visible to pjm_projects
1095:

Line 1227: p_forecast_rec IN eam_forecasts%ROWTYPE,

1223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1225: p_debug IN VARCHAR2 ,
1226:
1227: p_forecast_rec IN eam_forecasts%ROWTYPE,
1228:
1229:
1230: --p_acct_period_from IN NUMBER,
1231: --p_acct_period_to IN NUMBER,

Line 1406: p_forecast_rec IN eam_forecasts%ROWTYPE,

1402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1404: p_debug IN VARCHAR2 ,
1405:
1406: p_forecast_rec IN eam_forecasts%ROWTYPE,
1407:
1408:
1409: --p_acct_period_from IN NUMBER,
1410: --p_acct_period_to IN NUMBER,

Line 1431: l_forecast_rec EAM_FORECASTS%ROWTYPE;

1427: l_forecast_id NUMBER;
1428: l_forecast_DATE date;
1429: l_start_date DATE;
1430: l_end_date DATE;
1431: l_forecast_rec EAM_FORECASTS%ROWTYPE;
1432: l_count NUMBER;
1433:
1434:
1435: BEGIN

Line 1534: p_forecast_rec IN eam_forecasts%ROWTYPE,

1530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_debug IN VARCHAR2 ,
1533:
1534: p_forecast_rec IN eam_forecasts%ROWTYPE,
1535:
1536:
1537: --p_acct_period_from IN NUMBER,
1538: --p_acct_period_to IN NUMBER,

Line 1719: p_forecast_rec IN eam_forecasts%ROWTYPE,

1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1717: p_debug IN VARCHAR2 ,
1718:
1719: p_forecast_rec IN eam_forecasts%ROWTYPE,
1720: p_wip_id_table IN wo_table_type,
1721:
1722: --p_acct_period_from IN NUMBER,
1723: --p_acct_period_to IN NUMBER,

Line 1840: p_forecast_rec IN eam_forecasts%ROWTYPE,

1836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1838: p_debug IN VARCHAR2 ,
1839:
1840: p_forecast_rec IN eam_forecasts%ROWTYPE,
1841: p_wip_id_table IN wo_table_type,
1842:
1843: --p_acct_period_from IN NUMBER,
1844: --p_acct_period_to IN NUMBER,

Line 2018: p_forecast_rec IN eam_forecasts%ROWTYPE,

2014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2015: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2016: p_debug IN VARCHAR2 ,
2017:
2018: p_forecast_rec IN eam_forecasts%ROWTYPE,
2019: p_wip_id_table IN wo_table_type,
2020:
2021: --p_acct_period_from IN NUMBER,
2022: --p_acct_period_to IN NUMBER,

Line 2088: p_forecast_rec IN eam_forecasts%ROWTYPE,

2084: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2086: p_debug IN VARCHAR2 ,
2087:
2088: p_forecast_rec IN eam_forecasts%ROWTYPE,
2089: p_wip_id_table IN wo_table_type,
2090:
2091: --p_acct_period_from IN NUMBER,
2092: --p_acct_period_to IN NUMBER,

Line 2179: p_forecast_rec IN eam_forecasts%ROWTYPE,

2175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2177: p_debug IN VARCHAR2 ,
2178:
2179: p_forecast_rec IN eam_forecasts%ROWTYPE,
2180: p_wip_id_table IN wo_table_type,
2181:
2182: --p_acct_period_from IN NUMBER,
2183: --p_acct_period_to IN NUMBER,

Line 2262: p_forecast_rec IN eam_forecasts%ROWTYPE,

2258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2260: p_debug IN VARCHAR2 ,
2261:
2262: p_forecast_rec IN eam_forecasts%ROWTYPE,
2263: p_wip_id_table IN wo_table_type,
2264:
2265: --p_acct_period_from IN NUMBER,
2266: --p_acct_period_to IN NUMBER,

Line 2358: p_forecast_rec IN eam_forecasts%ROWTYPE,

2354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2356: p_debug IN VARCHAR2 ,
2357:
2358: p_forecast_rec IN eam_forecasts%ROWTYPE,
2359: p_wip_id_table IN wo_table_type,
2360:
2361: --p_acct_period_from IN NUMBER,
2362: --p_acct_period_to IN NUMBER,

Line 2440: p_forecast_rec IN eam_forecasts%ROWTYPE,

2436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2437: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2438: p_debug IN VARCHAR2 ,
2439:
2440: p_forecast_rec IN eam_forecasts%ROWTYPE,
2441: p_wip_id_table IN wo_table_type,
2442:
2443: --p_acct_period_from IN NUMBER,
2444: --p_acct_period_to IN NUMBER,

Line 2559: p_forecast_rec IN eam_forecasts%ROWTYPE,

2555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2556: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2557: p_debug IN VARCHAR2 ,
2558:
2559: p_forecast_rec IN eam_forecasts%ROWTYPE,
2560: p_wip_id_table IN wo_table_type,
2561:
2562: --p_acct_period_from IN NUMBER,
2563: --p_acct_period_to IN NUMBER,

Line 2640: p_forecast_rec IN eam_forecasts%ROWTYPE,

2636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2638: p_debug IN VARCHAR2 ,
2639:
2640: p_forecast_rec IN eam_forecasts%ROWTYPE,
2641: p_wip_id_table IN wo_table_type,
2642:
2643: --p_acct_period_from IN NUMBER,
2644: --p_acct_period_to IN NUMBER,

Line 2814: p_forecast_rec IN eam_forecasts%ROWTYPE,

2810: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2812: p_debug IN VARCHAR2 ,
2813:
2814: p_forecast_rec IN eam_forecasts%ROWTYPE,
2815: p_wip_id_table IN wo_table_type,
2816:
2817: --p_acct_period_from IN NUMBER,
2818: --p_acct_period_to IN NUMBER,

Line 2886: p_forecast_rec IN eam_forecasts%ROWTYPE,

2882: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2883: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2884: p_debug IN VARCHAR2 ,
2885:
2886: p_forecast_rec IN eam_forecasts%ROWTYPE,
2887: p_wip_id_table IN wo_table_type,
2888:
2889: --p_acct_period_from IN NUMBER,
2890: --p_acct_period_to IN NUMBER,

Line 2997: from eam_forecasts

2993: l_forecast_id := p_forecast_id;
2994:
2995: -- get the organization id of the forecast
2996: select organization_id into l_organization_id
2997: from eam_forecasts
2998: where forecast_id = l_forecast_id;
2999:
3000: EAM_COMMON_UTILITIES_PVT.
3001: set_profile('MFG_ORGANIZATION_ID', l_organization_id);

Line 3023: FROM gl_periods glp, gl_periods glp2, gl_periods glp3, eam_forecasts ef2

3019: )
3020: FROM
3021:
3022: (SELECT glp.period_name, glp.start_date, ef2.forecast_id
3023: FROM gl_periods glp, gl_periods glp2, gl_periods glp3, eam_forecasts ef2
3024: WHERE
3025: glp.start_date >= glp2.start_date
3026: AND glp.end_date <= glp3.end_date
3027: AND glp.period_type = glp2.period_type

Line 3036: FROM eam_forecast_cebba cebba, eam_forecasts ef3

3032: AND glp3.period_name = ef2.period_to
3033: )periods,
3034:
3035: (SELECT cebba.wip_entity_id , ef3.forecast_id, cebba.ccid, cebba.period_name AS period_name,SUM(cebba.acct_value) AS cost
3036: FROM eam_forecast_cebba cebba, eam_forecasts ef3
3037: WHERE cebba.forecast_id = ef3.forecast_id
3038: GROUP BY cebba.wip_entity_id, cebba.ccid, cebba.period_name, ef3.forecast_id
3039: ) costs
3040:

Line 3075: eam_forecasts ef, wip_entities entity,

3071: cebba.forecast_id AS id
3072: FROM eam_forecast_cebba cebba
3073: WHERE cebba.forecast_id = :6) efc,
3074: eam_forecast_wdj job, mtl_system_items_kfv msi,
3075: eam_forecasts ef, wip_entities entity,
3076: mtl_serial_numbers msn,
3077: csi_item_instances cii,
3078: mtl_eam_locations loc, mtl_system_items_kfv msi2,
3079: bom_departments bd, hr_organization_units hou,