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.

[Home] [Help]

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 844: FUNCTION get_asset_query(p_forecast_rec eam_forecasts%rowtype)

840: return l_asset_cursor;
841:
842: END get_asset_cursor;
843:
844: FUNCTION get_asset_query(p_forecast_rec eam_forecasts%rowtype)
845: RETURN VARCHAR2
846: IS
847:
848: BEGIN

Line 1035: p_forecast_id IN eam_forecasts.forecast_id%TYPE,

1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1034: p_debug IN VARCHAR2 ,
1035: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2 ,
1037: x_msg_count OUT NOCOPY NUMBER ,
1038: x_msg_data OUT NOCOPY VARCHAR2
1039:

Line 1047: v_forecast_rec eam_forecasts%ROWTYPE;

1043: l_api_name CONSTANT VARCHAR2(30) := 'Extract_Forecast';
1044: l_api_version CONSTANT NUMBER := 1.0;
1045: l_return_status VARCHAR2(1);
1046:
1047: v_forecast_rec eam_forecasts%ROWTYPE;
1048:
1049:
1050: begin
1051: -- Standard Start of API savepoint

Line 1070: FROM eam_forecasts

1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068:
1069: SELECT * INTO v_forecast_rec
1070: FROM eam_forecasts
1071: WHERE forecast_id = p_forecast_id;
1072:
1073: -- Set profile so org is visible to pjm_projects
1074:

Line 1206: p_forecast_rec IN eam_forecasts%ROWTYPE,

1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1204: p_debug IN VARCHAR2 ,
1205:
1206: p_forecast_rec IN eam_forecasts%ROWTYPE,
1207:
1208:
1209: --p_acct_period_from IN NUMBER,
1210: --p_acct_period_to IN NUMBER,

Line 1385: p_forecast_rec IN eam_forecasts%ROWTYPE,

1381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1383: p_debug IN VARCHAR2 ,
1384:
1385: p_forecast_rec IN eam_forecasts%ROWTYPE,
1386:
1387:
1388: --p_acct_period_from IN NUMBER,
1389: --p_acct_period_to IN NUMBER,

Line 1410: l_forecast_rec EAM_FORECASTS%ROWTYPE;

1406: l_forecast_id NUMBER;
1407: l_forecast_DATE date;
1408: l_start_date DATE;
1409: l_end_date DATE;
1410: l_forecast_rec EAM_FORECASTS%ROWTYPE;
1411: l_count NUMBER;
1412:
1413:
1414: BEGIN

Line 1513: p_forecast_rec IN eam_forecasts%ROWTYPE,

1509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1511: p_debug IN VARCHAR2 ,
1512:
1513: p_forecast_rec IN eam_forecasts%ROWTYPE,
1514:
1515:
1516: --p_acct_period_from IN NUMBER,
1517: --p_acct_period_to IN NUMBER,

Line 1698: p_forecast_rec IN eam_forecasts%ROWTYPE,

1694: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1696: p_debug IN VARCHAR2 ,
1697:
1698: p_forecast_rec IN eam_forecasts%ROWTYPE,
1699: p_wip_id_table IN wo_table_type,
1700:
1701: --p_acct_period_from IN NUMBER,
1702: --p_acct_period_to IN NUMBER,

Line 1819: p_forecast_rec IN eam_forecasts%ROWTYPE,

1815: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817: p_debug IN VARCHAR2 ,
1818:
1819: p_forecast_rec IN eam_forecasts%ROWTYPE,
1820: p_wip_id_table IN wo_table_type,
1821:
1822: --p_acct_period_from IN NUMBER,
1823: --p_acct_period_to IN NUMBER,

Line 2026: p_forecast_rec IN eam_forecasts%ROWTYPE,

2022: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2024: p_debug IN VARCHAR2 ,
2025:
2026: p_forecast_rec IN eam_forecasts%ROWTYPE,
2027: p_wip_id_table IN wo_table_type,
2028:
2029: --p_acct_period_from IN NUMBER,
2030: --p_acct_period_to IN NUMBER,

Line 2096: p_forecast_rec IN eam_forecasts%ROWTYPE,

2092: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2093: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2094: p_debug IN VARCHAR2 ,
2095:
2096: p_forecast_rec IN eam_forecasts%ROWTYPE,
2097: p_wip_id_table IN wo_table_type,
2098:
2099: --p_acct_period_from IN NUMBER,
2100: --p_acct_period_to IN NUMBER,

Line 2185: p_forecast_rec IN eam_forecasts%ROWTYPE,

2181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2183: p_debug IN VARCHAR2 ,
2184:
2185: p_forecast_rec IN eam_forecasts%ROWTYPE,
2186: p_wip_id_table IN wo_table_type,
2187:
2188: --p_acct_period_from IN NUMBER,
2189: --p_acct_period_to IN NUMBER,

Line 2281: p_forecast_rec IN eam_forecasts%ROWTYPE,

2277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2279: p_debug IN VARCHAR2 ,
2280:
2281: p_forecast_rec IN eam_forecasts%ROWTYPE,
2282: p_wip_id_table IN wo_table_type,
2283:
2284: --p_acct_period_from IN NUMBER,
2285: --p_acct_period_to IN NUMBER,

Line 2399: p_forecast_rec IN eam_forecasts%ROWTYPE,

2395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2396: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2397: p_debug IN VARCHAR2 ,
2398:
2399: p_forecast_rec IN eam_forecasts%ROWTYPE,
2400: p_wip_id_table IN wo_table_type,
2401:
2402: --p_acct_period_from IN NUMBER,
2403: --p_acct_period_to IN NUMBER,

Line 2573: p_forecast_rec IN eam_forecasts%ROWTYPE,

2569: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2570: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2571: p_debug IN VARCHAR2 ,
2572:
2573: p_forecast_rec IN eam_forecasts%ROWTYPE,
2574: p_wip_id_table IN wo_table_type,
2575:
2576: --p_acct_period_from IN NUMBER,
2577: --p_acct_period_to IN NUMBER,

Line 2674: from eam_forecasts

2670: l_forecast_id := p_forecast_id;
2671:
2672: -- get the organization id of the forecast
2673: select organization_id into l_organization_id
2674: from eam_forecasts
2675: where forecast_id = l_forecast_id;
2676:
2677: EAM_COMMON_UTILITIES_PVT.
2678: set_profile('MFG_ORGANIZATION_ID', l_organization_id);

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

2694: )
2695: FROM
2696:
2697: (SELECT glp.period_name, glp.start_date, ef2.forecast_id
2698: FROM gl_periods glp, gl_periods glp2, gl_periods glp3, eam_forecasts ef2
2699: WHERE
2700: glp.start_date >= glp2.start_date
2701: AND glp.end_date <= glp3.end_date
2702: AND glp.period_type = glp2.period_type

Line 2711: FROM eam_forecast_cebba cebba, eam_forecasts ef3

2707: AND glp3.period_name = ef2.period_to
2708: )periods,
2709:
2710: (SELECT cebba.wip_entity_id , ef3.forecast_id, cebba.ccid, cebba.period_name AS period_name,SUM(cebba.acct_value) AS cost
2711: FROM eam_forecast_cebba cebba, eam_forecasts ef3
2712: WHERE cebba.forecast_id = ef3.forecast_id
2713: GROUP BY cebba.wip_entity_id, cebba.ccid, cebba.period_name, ef3.forecast_id
2714: ) costs
2715:

Line 2741: FROM eam_forecasts ef, eam_forecast_wdj job, wip_entities entity,

2737: job.class_code AS CLASS,
2738: pjm_project.all_proj_idtonum(job.project_id) AS PROJECT
2739: )
2740: )))
2741: FROM eam_forecasts ef, eam_forecast_wdj job, wip_entities entity,
2742: mtl_system_items_kfv msi, mtl_serial_numbers msn,
2743: mtl_eam_locations loc, mtl_system_items_kfv msi2,
2744: bom_departments bd, hr_organization_units hou,
2745: