APPS.XTR_CSH_FCST_POP dependencies on XTR_FORECAST_PERIOD_TEMP

Line 146: DELETE FROM xtr_forecast_period_temp;

142: l_period_id NUMBER := 0;
143: l_count NUMBER;
144: BEGIN
145: BEGIN
146: DELETE FROM xtr_forecast_period_temp;
147: IF SQL%FOUND THEN
148: COMMIT;
149: END IF;
150: EXCEPTION

Line 181: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)

177: ELSE
178: l_start := l_start_date;
179: END IF;
180:
181: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
182: VALUES (l_period_id, l_start_date, l_start, 'D');
183:
184: IF l_start = l_end_date THEN
185: l_period_id := l_period_id + 1;

Line 218: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)

214: ELSE
215: l_start := l_od_start;
216: END IF;
217:
218: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
219: VALUES (l_period_id, l_od_start, l_start, 'D');
220:
221: l_period_id := l_period_id + 1;
222: l_od_start := l_start + 1;

Line 232: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)

228: IF l_end > LAST_DAY(l_start_date) THEN
229: l_end := LAST_DAY(l_start_date);
230: END IF;
231:
232: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
233: VALUES (l_period_id, l_start_date, l_end, 'W');
234:
235: l_period_id := l_period_id + 1;
236: l_start_date := l_end + 1;

Line 246: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)

242: ELSIF p_rec.level_of_summary = 'M' THEN
243: l_end := LAST_DAY(l_start_date);
244: WHILE l_end <= l_end_date LOOP
245:
246: INSERT INTO xtr_forecast_period_temp(forecast_period_temp_id, start_date, end_date, level_of_summary)
247: VALUES (l_period_id, l_start_date, l_end, 'M');
248:
249: l_start_date := l_end + 1;
250: l_end := LAST_DAY(l_start_date);

Line 278: from xtr_forecast_period_temp;

274: | 30-DEC-1998 Created BHChung |
275: --------------------------------------------------------------------- */
276: PROCEDURE populate_aging_buckets IS
277: CURSOR C1 IS select forecast_period_temp_id, start_date, end_date
278: from xtr_forecast_period_temp;
279: start_date DATE;
280: end_date DATE;
281: new_start_date DATE;
282: new_end_date DATE;

Line 345: UPDATE xtr_forecast_period_temp

341: new_end_date := G_calendar_start -1;
342: END;
343: END IF;
344:
345: UPDATE xtr_forecast_period_temp
346: SET start_date = new_start_date,
347: end_date = new_end_date
348: WHERE forecast_period_temp_id = fid;
349: END IF;

Line 367: delete from xtr_forecast_period_temp;

363: END populate_aging_buckets;
364:
365: PROCEDURE clear_aging_buckets IS
366: BEGIN
367: delete from xtr_forecast_period_temp;
368: IF SQL%FOUND THEN
369: COMMIT;
370: END IF;
371: EXCEPTION

Line 432: xtr_forecast_period_temp cab ';

428: from_clause VARCHAR2(500);
429: BEGIN
430: from_clause := '
431: FROM '||view_name ||' src,
432: xtr_forecast_period_temp cab ';
433:
434: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
435: xtr_debug_pkg.debug('Get_From_Clause: ' || from_clause);
436: END IF;

Line 648: FROM xtr_forecast_period_temp

644:
645: CURSOR C_period(p_pid NUMBER) IS
646: SELECT end_date,
647: level_of_summary
648: FROM xtr_forecast_period_temp
649: WHERE forecast_period_temp_id = p_pid;
650:
651: cursor_id INTEGER;
652: exec_id INTEGER;