40: xtr_debug_pkg.debug('G_roll_forward_period : ' || XTR_CASH_FCST.G_roll_forward_period);
41:
42: xtr_debug_pkg.debug('G_start_period: ' || XTR_CASH_FCST.G_rp_forecast_start_period);
43:
44: xtr_debug_pkg.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);
45:
46: END IF;
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
45:
46: END IF;
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
46: END IF;
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
47:
48: IF (XTR_CASH_FCST.G_roll_forward_type = 'D') THEN
49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
59: SELECT gps.period_name
52: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'M') THEN
53: history_date:= ADD_MONTHS(XTR_CASH_FCST.G_rp_forecast_start_date,- XTR_CASH_FCST.G_roll_forward_period);
54: CEFC_VIEW_CONST.set_start_date(history_date);
55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);
56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);
57: ELSIF (XTR_CASH_FCST.G_roll_forward_type = 'A') THEN
58: BEGIN
59: SELECT gps.period_name
60: INTO history_period
73: AND gp.period_set_name = gps.period_set_name
74: AND gps.period_type = gp.period_type
75: AND gpt.period_type = gp.period_type
76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period
77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
75: AND gpt.period_type = gp.period_type
76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period
77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
76: AND gp.period_name = XTR_CASH_FCST.G_rp_forecast_start_period
77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
78:
79: CEFC_VIEW_CONST.set_start_period_name(history_period);
80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);
81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
85: xtr_debug_pkg.debug('NO DATA FOUND FOR HISTORY PERIOD');
92: raise;
93: END;
94: END IF;
95:
96: min_col := CEFC_VIEW_CONST.get_min_col;
97: max_col := CEFC_VIEW_CONST.get_max_col;
98: XTR_CASH_FCST.G_invalid_overdue_row := FALSE;
99: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
100: xtr_debug_pkg.debug('<
93: END;
94: END IF;
95:
96: min_col := CEFC_VIEW_CONST.get_min_col;
97: max_col := CEFC_VIEW_CONST.get_max_col;
98: XTR_CASH_FCST.G_invalid_overdue_row := FALSE;
99: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
100: xtr_debug_pkg.debug('<