eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_CSH_FCST_POP dependencies on CEFC_VIEW_CONST

Line 44: xtr_debug_pkg.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);

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

Line 49: CEFC_VIEW_CONST.set_start_date(XTR_CASH_FCST.G_rp_forecast_start_date - XTR_CASH_FCST.G_roll_forward_period);

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);

Line 50: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + 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);

Line 51: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period);

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);

Line 54: CEFC_VIEW_CONST.set_start_date(history_date);

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

Line 55: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period*30);

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

Line 56: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_period*30);

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

Line 77: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;

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);

Line 79: CEFC_VIEW_CONST.set_start_period_name(history_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

Line 80: CEFC_VIEW_CONST.set_min_col(XTR_CASH_FCST.G_min_col + XTR_CASH_FCST.G_roll_forward_period);

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

Line 81: CEFC_VIEW_CONST.set_max_col(XTR_CASH_FCST.G_max_col + XTR_CASH_FCST.G_roll_forward_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
85: xtr_debug_pkg.debug('NO DATA FOUND FOR HISTORY PERIOD');

Line 96: min_col := CEFC_VIEW_CONST.get_min_col;

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('<

Line 97: max_col := CEFC_VIEW_CONST.get_max_col;

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('< 101: END IF;