APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_EXT_TEMP

Line 271: INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, start_date, end_date,

267: -- Bug # 1927006
268: new_start_date := trunc(new_start_date);
269: new_end_date := to_date(to_char(new_end_date, 'DD-MM-RR') || ' 23:59:59', 'DD-MM-RR HH24:MI:SS');
270:
271: INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, start_date, end_date,
272: forecast_column_id, conversion_rate)
273: VALUES ('A', CE_CASH_FCST.G_forecast_id, new_start_date, new_end_date, fid, CE_CASH_FCST.G_forecast_row_id);
274:
275: FETCH C1 INTO fid, start_date, end_date;

Line 289: delete from ce_forecast_ext_temp

285: END populate_aging_buckets;
286:
287: PROCEDURE clear_aging_buckets IS
288: BEGIN
289: delete from ce_forecast_ext_temp
290: where context_value = 'A' and
291: forecast_request_id = CE_CASH_FCST.G_forecast_id and
292: conversion_rate = CE_CASH_FCST.G_forecast_row_id;
293: cep_standard.debug('<

Line 403: ce_forecast_ext_temp cab ';

399: from_clause VARCHAR2(500);
400: BEGIN
401: from_clause := '
402: FROM '||view_name ||' src,
403: ce_forecast_ext_temp cab ';
404:
405: IF( CE_CASH_FCST.G_rp_exchange_type IS NULL OR
406: CE_CASH_FCST.G_rp_exchange_type <> 'User')THEN
407: from_clause := from_clause || ' ,

Line 2581: ce_forecast_ext_temp cab ';

2577:
2578: main_query := main_query || '
2579: FROM gl_balances src,
2580: gl_periods gp,
2581: ce_forecast_ext_temp cab ';
2582:
2583: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
2584: CE_CASH_FCST.G_rp_exchange_type IS NULL)THEN
2585: main_query := main_query || ',

Line 2839: FROM ce_forecast_ext_temp

2835: CURSOR C_period IS
2836: SELECT start_date,
2837: end_date,
2838: forecast_column_id
2839: FROM ce_forecast_ext_temp
2840: WHERE context_value = 'A'
2841: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
2842: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
2843:

Line 3133: FROM ce_forecast_ext_temp

3129: populate_aging_buckets;
3130:
3131: SELECT max(end_date)
3132: INTO l_max_end_date
3133: FROM ce_forecast_ext_temp
3134: WHERE context_value = 'A'
3135: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
3136: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
3137: cep_standard.debug('l_max_end_date = ' || to_char(l_max_end_date, 'DD-MON-YYYY'));

Line 3803: FROM ce_forecast_ext_temp

3799: CURSOR C_period IS
3800: SELECT start_date,
3801: end_date,
3802: forecast_column_id
3803: FROM ce_forecast_ext_temp
3804: WHERE context_value = 'A'
3805: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
3806: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
3807:

Line 3888: FROM ce_forecast_ext_temp

3884: populate_aging_buckets;
3885:
3886: SELECT trunc(max(end_date))
3887: INTO l_max_end_date
3888: FROM ce_forecast_ext_temp
3889: WHERE context_value = 'A'
3890: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
3891: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
3892: cep_standard.debug('l_max_end_date = ' || to_char(l_max_end_date, 'DD-MON-YYYY'));

Line 4929: FROM ce_forecast_ext_temp

4925: CURSOR C_period IS
4926: SELECT start_date,
4927: end_date,
4928: forecast_column_id
4929: FROM ce_forecast_ext_temp
4930: WHERE context_value = 'A'
4931: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
4932: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
4933:

Line 5239: FROM ce_forecast_ext_temp

5235:
5236: IF( db_link IS NOT NULL )THEN
5237: main_query := main_query ||'
5238: CURSOR aging_cursor IS SELECT forecast_column_id, start_date, end_date
5239: FROM ce_forecast_ext_temp
5240: WHERE context_value = ''A'' and
5241: forecast_request_id = CE_CASH_FCST.G_forecast_id and
5242: conversion_rate = CE_CASH_FCST.G_forecast_row_id; ';
5243: END IF;