APPS.CE_FORECAST_REMOTE_SOURCES dependencies on CE_FORECAST_EXT_TEMP

Line 86: INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, start_date, end_date, forecast_column_id, conversion_rate)

82: -- Insert aging bucket and conversion rate information to temporary table
83: --
84: IF(db_link IS NOT NULL)THEN
85: FOR i IN 1 .. aging_table.count LOOP
86: INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, start_date, end_date, forecast_column_id, conversion_rate)
87: VALUES ('A', forecast_id, aging_table(i).start_date, aging_table(i).end_date, aging_table(i).column_id, forecast_row_id);
88: END LOOP;
89: END IF;
90:

Line 93: INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, from_currency_code, conversion_rate)

89: END IF;
90:
91: IF(rp_exchange_type <> 'User')THEN
92: FOR i IN 1 .. conversion_table.count LOOP
93: INSERT INTO CE_FORECAST_EXT_TEMP (context_value, forecast_request_id, from_currency_code, conversion_rate)
94: VALUES ('C', forecast_id, conversion_table(i).from_currency_code, conversion_table(i).conversion_rate);
95: END LOOP;
96: END IF;
97:

Line 142: CE_FORECAST_EXT_TEMP cab ';

138: END IF;
139:
140: from_where_clause := '
141: FROM '|| source_view ||' src,
142: CE_FORECAST_EXT_TEMP cab ';
143:
144: IF(rp_exchange_type <> 'User')THEN
145: from_where_clause := from_where_clause || ',
146: CE_FORECAST_EXT_TEMP curr ';

Line 146: CE_FORECAST_EXT_TEMP curr ';

142: CE_FORECAST_EXT_TEMP cab ';
143:
144: IF(rp_exchange_type <> 'User')THEN
145: from_where_clause := from_where_clause || ',
146: CE_FORECAST_EXT_TEMP curr ';
147: END IF;
148:
149: from_where_clause := from_where_clause || '
150: WHERE cab.context_value = ''A''

Line 281: DELETE FROM CE_FORECAST_EXT_TEMP

277:
278: --
279: -- Delete records from temporary table
280: --
281: DELETE FROM CE_FORECAST_EXT_TEMP
282: WHERE forecast_request_id = forecast_id
283: AND context_value = 'C';
284: DELETE FROM CE_FORECAST_EXT_TEMP
285: WHERE forecast_request_id = forecast_id

Line 284: DELETE FROM CE_FORECAST_EXT_TEMP

280: --
281: DELETE FROM CE_FORECAST_EXT_TEMP
282: WHERE forecast_request_id = forecast_id
283: AND context_value = 'C';
284: DELETE FROM CE_FORECAST_EXT_TEMP
285: WHERE forecast_request_id = forecast_id
286: AND conversion_rate = forecast_row_id
287: AND context_value = 'A';
288: