APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_EXT_TEMP

Line 321: cep_standard.debug('insert into CE_FORECAST_EXT_TEMP ...');

317: -- Bug # 1927006
318: new_start_date := trunc(new_start_date);
319: new_end_date := to_date(to_char(new_end_date, 'DD-MM-RR') || ' 23:59:59', 'DD-MM-RR HH24:MI:SS');
320:
321: cep_standard.debug('insert into CE_FORECAST_EXT_TEMP ...');
322: cep_standard.debug('forecast_request_id='||CE_CASH_FCST.G_forecast_id
323: ||',start_date='||new_start_date
324: ||',end_date='||new_end_date
325: ||',forecast_column_id='||fid

Line 328: INSERT INTO CE_FORECAST_EXT_TEMP

324: ||',end_date='||new_end_date
325: ||',forecast_column_id='||fid
326: ||',conversion_rate='||CE_CASH_FCST.G_forecast_row_id);
327:
328: INSERT INTO CE_FORECAST_EXT_TEMP
329: (context_value, forecast_request_id, start_date, end_date,
330: forecast_column_id, conversion_rate)
331: VALUES ('A', CE_CASH_FCST.G_forecast_id, new_start_date, new_end_date,
332: fid, CE_CASH_FCST.G_forecast_row_id);

Line 350: delete from ce_forecast_ext_temp

346: END populate_aging_buckets;
347:
348: PROCEDURE clear_aging_buckets IS
349: BEGIN
350: delete from ce_forecast_ext_temp
351: where context_value = 'A' and
352: forecast_request_id = CE_CASH_FCST.G_forecast_id and
353: conversion_rate = CE_CASH_FCST.G_forecast_row_id;
354:

Line 464: ce_forecast_ext_temp cab ';

460: from_clause VARCHAR2(500);
461: BEGIN
462: from_clause := '
463: FROM '||view_name ||' src,
464: ce_forecast_ext_temp cab ';
465:
466: IF( CE_CASH_FCST.G_rp_exchange_type IS NULL OR
467: CE_CASH_FCST.G_rp_exchange_type <> 'User')THEN
468: from_clause := from_clause || ' ,

Line 2657: ce_forecast_ext_temp cab ';

2653:
2654: main_query := main_query || '
2655: FROM gl_balances src,
2656: gl_periods gp,
2657: ce_forecast_ext_temp cab ';
2658:
2659: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR
2660: CE_CASH_FCST.G_rp_exchange_type IS NULL)THEN
2661: main_query := main_query || ',

Line 2915: FROM ce_forecast_ext_temp

2911: CURSOR C_period IS
2912: SELECT start_date,
2913: end_date,
2914: forecast_column_id
2915: FROM ce_forecast_ext_temp
2916: WHERE context_value = 'A'
2917: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
2918: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
2919:

Line 3209: FROM ce_forecast_ext_temp

3205: populate_aging_buckets;
3206:
3207: SELECT max(end_date)
3208: INTO l_max_end_date
3209: FROM ce_forecast_ext_temp
3210: WHERE context_value = 'A'
3211: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
3212: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
3213: cep_standard.debug('l_max_end_date = ' || to_char(l_max_end_date, 'DD-MON-YYYY'));

Line 3879: FROM ce_forecast_ext_temp

3875: CURSOR C_period IS
3876: SELECT start_date,
3877: end_date,
3878: forecast_column_id
3879: FROM ce_forecast_ext_temp
3880: WHERE context_value = 'A'
3881: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
3882: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
3883:

Line 3964: FROM ce_forecast_ext_temp

3960: populate_aging_buckets;
3961:
3962: SELECT trunc(max(end_date))
3963: INTO l_max_end_date
3964: FROM ce_forecast_ext_temp
3965: WHERE context_value = 'A'
3966: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
3967: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
3968: cep_standard.debug('l_max_end_date = ' || to_char(l_max_end_date, 'DD-MON-YYYY'));

Line 5004: FROM ce_forecast_ext_temp

5000: l_end_date DATE;
5001:
5002: CURSOR C_period IS
5003: SELECT start_date, end_date, forecast_column_id
5004: FROM ce_forecast_ext_temp
5005: WHERE context_value = 'A'
5006: AND forecast_request_id = CE_CASH_FCST.G_forecast_id
5007: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
5008:

Line 5390: FROM ce_forecast_ext_temp

5386:
5387: IF( db_link IS NOT NULL )THEN
5388: main_query := main_query ||'
5389: CURSOR aging_cursor IS SELECT forecast_column_id, start_date, end_date
5390: FROM ce_forecast_ext_temp
5391: WHERE context_value = ''A'' and
5392: forecast_request_id = CE_CASH_FCST.G_forecast_id and
5393: conversion_rate = CE_CASH_FCST.G_forecast_row_id; ';
5394: END IF;