APPS.CE_FORECAST_UTILS dependencies on CE_FORECASTS

Line 85: from ce_forecasts

81: into l_forecast_header_id,
82: l_period_set_name,
83: l_start_period,
84: l_start_date
85: from ce_forecasts
86: where forecast_id = X_forecast_id;
87: else
88: l_forecast_header_id := X_forecast_header_id;
89: l_period_set_name := X_period_set_name;

Line 210: FROM ce_forecasts

206: --------------------------------------------------------------------- */
207:
208: PROCEDURE Create_Dummy_Rows (X_forecast_header_id NUMBER) IS
209: CURSOR C_fc IS SELECT forecast_id
210: FROM ce_forecasts
211: WHERE forecast_header_id = X_forecast_header_id;
212: CURSOR C_frow(p_forecast_id NUMBER) IS SELECT forecast_row_id
213: FROM ce_forecast_rows
214: WHERE forecast_header_id = X_forecast_header_id

Line 560: from ce_forecasts

556:
557: if X_forecast_id is not null then
558: select nvl(drilldown_flag,'N')
559: into l_drilldown_flag
560: from ce_forecasts
561: where forecast_id = X_forecast_id;
562:
563: UPDATE ce_forecasts
564: SET forecast_header_id = l_forecast_header_id

Line 563: UPDATE ce_forecasts

559: into l_drilldown_flag
560: from ce_forecasts
561: where forecast_id = X_forecast_id;
562:
563: UPDATE ce_forecasts
564: SET forecast_header_id = l_forecast_header_id
565: WHERE forecast_id = X_forecast_id;
566:
567: if l_drilldown_flag = 'Y' then

Line 1080: CE_FORECASTS_TABLE_PKG.Insert_Row(

1076: WHERE forecast_header_id = p_forecast_header_id;
1077:
1078: IF (p_start_project_num is null AND p_end_project_num is null
1079: AND nvl(p_sub_request,'N') = 'N') THEN
1080: CE_FORECASTS_TABLE_PKG.Insert_Row(
1081: X_Rowid => l_forecast_rowid,
1082: X_forecast_id => l_forecast_id,
1083: X_forecast_header_id => p_forecast_header_id,
1084: X_name => p_forecast_name,

Line 1211: UPDATE ce_forecasts

1207: '','','','','','','','','','',
1208: '','','','','','','','','','');
1209: END IF;
1210:
1211: UPDATE ce_forecasts
1212: SET request_id = l_request_id
1213: WHERE forecast_id = l_forecast_id;
1214:
1215: EXCEPTION

Line 1241: FROM ce_forecasts

1237:
1238: PROCEDURE Refresh_Processing_Status IS
1239: CURSOR C_fc IS SELECT forecast_id,
1240: request_id
1241: FROM ce_forecasts
1242: WHERE error_status in ('P','R','X')
1243: AND request_id is not null;
1244: call_status BOOLEAN;
1245: rphase VARCHAR2(80);

Line 1255: UPDATE ce_forecasts

1251: FOR p_fc in C_fc LOOP
1252: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(p_fc.request_id,'','',
1253: rphase, rstatus, dphase, dstatus, message);
1254: IF (dstatus in ('ERROR','CANCELLED','TERMINATED')) THEN
1255: UPDATE ce_forecasts
1256: SET error_status = 'F'
1257: WHERE forecast_id = p_fc.forecast_id;
1258: END IF;
1259: IF (dphase = 'RUNNING') THEN

Line 1260: UPDATE ce_forecasts

1256: SET error_status = 'F'
1257: WHERE forecast_id = p_fc.forecast_id;
1258: END IF;
1259: IF (dphase = 'RUNNING') THEN
1260: UPDATE ce_forecasts
1261: SET error_status = 'R'
1262: WHERE forecast_id = p_fc.forecast_id
1263: AND error_status = 'P';
1264: END IF;