APPS.XTR_FORECAST_HEADERS_PKG dependencies on XTR_FORECAST_PERIODS

Line 182: XTR_FORECAST_PERIODS_PKG. Insert_Row(

178: end if;
179: CLOSE C;
180:
181: IF(X_overdue_transactions = 'INCLUDE')THEN
182: XTR_FORECAST_PERIODS_PKG. Insert_Row(
183: X_rowid => p_row_id,
184: X_forecast_period_id => p_forecast_period_id,
185: X_forecast_header_id => X_forecast_header_id,
186: X_period_number => 0,

Line 419: XTR_FORECAST_PERIODS_PKG. Insert_Row(

415: -- new column for overdue transactions in column table
416: --
417: IF(p_overdue_transactions = 'EXCLUDE' AND
418: X_overdue_transactions = 'INCLUDE')THEN
419: XTR_FORECAST_PERIODS_PKG. Insert_Row(
420: X_rowid => p_row_id,
421: X_forecast_period_id => p_forecast_period_id,
422: X_forecast_header_id => X_forecast_header_id,
423: X_period_number => 0,

Line 440: UPDATE XTR_FORECAST_PERIODS

436: --
437: IF(p_overdue_transactions = 'INCLUDE' AND
438: X_overdue_transactions = 'INCLUDE' AND
439: p_cutoff_period <> X_cutoff_period) THEN
440: UPDATE XTR_FORECAST_PERIODS
441: SET length_of_period = -X_cutoff_period+1,
442: level_of_summary = 'O',
443: length_type = 'D'
444: WHERE forecast_header_id = X_forecast_header_id

Line 454: DELETE FROM XTR_FORECAST_PERIODS

450: -- the overdue column from the column table
451: --
452: IF(p_overdue_transactions = 'INCLUDE' AND
453: X_overdue_transactions = 'EXCLUDE')THEN
454: DELETE FROM XTR_FORECAST_PERIODS
455: WHERE forecast_header_id = X_forecast_header_id
456: AND period_number = 0;
457: IF(SQL%NOTFOUND)THEN
458: RAISE NO_DATA_FOUND;

Line 489: DELETE FROM XTR_FORECAST_PERIODS

485:
486: DELETE FROM CE_FORECAST_ROWS
487: WHERE forecast_header_id = p_forecast_header_id;
488:
489: DELETE FROM XTR_FORECAST_PERIODS
490: WHERE forecast_header_id = p_forecast_header_id;
491:
492: DELETE FROM ce_forecast_headers
493: WHERE treasury_template = 'Y';