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.CE_CASH_FCST dependencies on CE_FORECASTS

Line 355: FROM ce_forecasts

351: END IF;
352:
353: SELECT forecast_header_id
354: INTO l_forecast_header_id
355: FROM ce_forecasts
356: WHERE forecast_id = G_forecast_id;
357:
358: req_id := FND_REQUEST.SUBMIT_REQUEST('CE',
359: 'CEFCAMTS',

Line 1206: | Create forecast header for new forecast in ce_forecasts table |

1202: /* ---------------------------------------------------------------------
1203: | PRIVATE PROCEDURE |
1204: | create_forecast_header |
1205: | DESCRIPTION |
1206: | Create forecast header for new forecast in ce_forecasts table |
1207: | CALLED BY |
1208: | create_forecast |
1209: | HISTORY |
1210: | 12-JUL-1996 Created Bidemi Carrol |

Line 1234: FROM ce_forecasts

1230: BEGIN
1231: IF G_forecast_id is null THEN
1232: SELECT forecast_id
1233: INTO fid
1234: FROM ce_forecasts
1235: WHERE name = G_rp_forecast_runname;
1236: ELSE
1237: SELECT forecast_id
1238: INTO fid

Line 1239: FROM ce_forecasts

1235: WHERE name = G_rp_forecast_runname;
1236: ELSE
1237: SELECT forecast_id
1238: INTO fid
1239: FROM ce_forecasts
1240: WHERE name = G_rp_forecast_runname
1241: AND forecast_id <> G_forecast_id;
1242: END IF;
1243:

Line 1254: FROM ce_forecasts

1250: END IF;
1251:
1252: SELECT count(1)
1253: INTO l_fc_count
1254: FROM ce_forecasts
1255: WHERE forecast_id = G_forecast_id;
1256:
1257: IF l_fc_count = 0 THEN
1258: CE_FORECASTS_TABLE_PKG.Insert_Row(

Line 1258: CE_FORECASTS_TABLE_PKG.Insert_Row(

1254: FROM ce_forecasts
1255: WHERE forecast_id = G_forecast_id;
1256:
1257: IF l_fc_count = 0 THEN
1258: CE_FORECASTS_TABLE_PKG.Insert_Row(
1259: X_Rowid => l_forecast_rowid,
1260: X_forecast_id => G_forecast_id,
1261: X_forecast_header_id => G_rp_forecast_header_id,
1262: X_name => G_rp_forecast_runname,

Line 1312: UPDATE ce_forecasts

1308: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1309: error_msg := FND_MESSAGE.GET;
1310: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
1311: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1312: UPDATE ce_forecasts
1313: SET error_status = 'X'
1314: WHERE forecast_id = G_forecast_id;
1315: END IF;
1316:

Line 1396: UPDATE ce_forecasts

1392: valid_pmr := FALSE;
1393: END IF;
1394:
1395: IF(NOT valid_pmr)THEN
1396: UPDATE ce_forecasts
1397: SET error_status = 'E'
1398: WHERE forecast_id = G_forecast_id;
1399:
1400: cep_standard.debug('Forecast NOT run');

Line 1488: UPDATE ce_forecasts

1484: --
1485: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
1486: CE_CASH_FCST.G_rp_exchange_type IS NULL )THEN
1487: IF( NOT populate_xrate_table ) THEN
1488: UPDATE ce_forecasts
1489: SET error_status = 'X'
1490: WHERE forecast_id = G_forecast_id;
1491: END IF;
1492: END IF;

Line 1505: UPDATE ce_forecasts

1501: IF (NOT G_gl_cash_only) THEN
1502: IF( CE_CASH_FCST.G_rp_src_curr_type = 'F' AND
1503: CE_CASH_FCST.G_rp_amount_threshold IS NOT NULL )THEN
1504: IF( NOT populate_base_xrate_table )THEN
1505: UPDATE ce_forecasts
1506: set error_status = 'X'
1507: where forecast_id = G_forecast_id;
1508: END IF;
1509: END IF;

Line 1513: UPDATE ce_forecasts

1509: END IF;
1510: END IF;
1511:
1512: IF( NOT valid_col_range )THEN
1513: UPDATE ce_forecasts
1514: SET error_status = 'X'
1515: WHERE forecast_id = G_forecast_id;
1516: END IF;
1517: END IF;

Line 1594: FROM ce_forecasts

1590: END IF;
1591:
1592: SELECT error_status
1593: INTO l_status
1594: FROM ce_forecasts
1595: WHERE forecast_id = G_forecast_id;
1596:
1597: IF (wrap_up_process(req_data) OR standalone_process) THEN
1598: clear_xrate_table;

Line 1608: UPDATE ce_forecasts

1604: END IF;
1605: END IF;
1606:
1607: IF l_status = 'R' THEN
1608: UPDATE ce_forecasts
1609: SET error_status = 'S'
1610: WHERE forecast_id = G_forecast_id;
1611: ELSIF l_status = 'X' THEN
1612: UPDATE ce_forecasts

Line 1612: UPDATE ce_forecasts

1608: UPDATE ce_forecasts
1609: SET error_status = 'S'
1610: WHERE forecast_id = G_forecast_id;
1611: ELSIF l_status = 'X' THEN
1612: UPDATE ce_forecasts
1613: SET error_status = 'W'
1614: WHERE forecast_id = G_forecast_id;
1615: END IF;
1616:

Line 1700: UPDATE ce_forecasts

1696:
1697: -- Now the process is officially 'Running' and not 'Pending'
1698: --bug 4345353 convert amount threshold from canonical to number
1699: p_amount_threshold := fnd_number.canonical_to_number(p_amount_threshold_x);
1700: UPDATE ce_forecasts
1701: SET error_status = 'R'
1702: WHERE forecast_id = p_forecast_id
1703: AND error_status = 'P';
1704: commit;

Line 1711: UPDATE ce_forecasts

1707: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1708: error_msg := FND_MESSAGE.GET;
1709: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
1710: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1711: UPDATE ce_forecasts
1712: SET error_status = 'X'
1713: WHERE forecast_id = p_forecast_id;
1714: END IF;
1715:

Line 1859: UPDATE ce_forecasts

1855: -- Now the process is officially 'Running' and not 'Pending'
1856: -- --bug 4345353 convert amount threshold from canonical to number
1857: p_amount_threshold := fnd_number.canonical_to_number(p_amount_threshold_x);
1858:
1859: UPDATE ce_forecasts
1860: SET error_status = 'R'
1861: WHERE forecast_id = p_forecast_id
1862: AND error_status = 'P';
1863: commit;

Line 1870: UPDATE ce_forecasts

1866: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1867: error_msg := FND_MESSAGE.GET;
1868: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
1869: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1870: UPDATE ce_forecasts
1871: SET error_status = 'X'
1872: WHERE forecast_id = p_forecast_id;
1873: END IF;
1874: