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.CE_CSH_FCST_POP dependencies on CEFC_VIEW_CONST

Line 101: cep_standard.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);

97:
98: cep_standard.debug('G_roll_forward_type: ' || CE_CASH_FCST.G_roll_forward_type);
99: cep_standard.debug('G_roll_forward_period : ' || CE_CASH_FCST.G_roll_forward_period);
100: cep_standard.debug('G_start_period: ' || CE_CASH_FCST.G_rp_forecast_start_period);
101: cep_standard.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);
102:
103: IF (CE_CASH_FCST.G_roll_forward_type = 'D') THEN
104: CEFC_VIEW_CONST.set_start_date(CE_CASH_FCST.G_rp_forecast_start_date - CE_CASH_FCST.G_roll_forward_period);
105: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);

Line 104: CEFC_VIEW_CONST.set_start_date(CE_CASH_FCST.G_rp_forecast_start_date - CE_CASH_FCST.G_roll_forward_period);

100: cep_standard.debug('G_start_period: ' || CE_CASH_FCST.G_rp_forecast_start_period);
101: cep_standard.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);
102:
103: IF (CE_CASH_FCST.G_roll_forward_type = 'D') THEN
104: CEFC_VIEW_CONST.set_start_date(CE_CASH_FCST.G_rp_forecast_start_date - CE_CASH_FCST.G_roll_forward_period);
105: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
106: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
107:
108: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'M') THEN

Line 105: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);

101: cep_standard.debug('period_set_name: ' || CEFC_VIEW_CONST.get_period_set_name);
102:
103: IF (CE_CASH_FCST.G_roll_forward_type = 'D') THEN
104: CEFC_VIEW_CONST.set_start_date(CE_CASH_FCST.G_rp_forecast_start_date - CE_CASH_FCST.G_roll_forward_period);
105: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
106: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
107:
108: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'M') THEN
109: history_date:= ADD_MONTHS(CE_CASH_FCST.G_rp_forecast_start_date,- CE_CASH_FCST.G_roll_forward_period);

Line 106: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);

102:
103: IF (CE_CASH_FCST.G_roll_forward_type = 'D') THEN
104: CEFC_VIEW_CONST.set_start_date(CE_CASH_FCST.G_rp_forecast_start_date - CE_CASH_FCST.G_roll_forward_period);
105: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
106: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
107:
108: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'M') THEN
109: history_date:= ADD_MONTHS(CE_CASH_FCST.G_rp_forecast_start_date,- CE_CASH_FCST.G_roll_forward_period);
110: CEFC_VIEW_CONST.set_start_date(history_date);

Line 110: CEFC_VIEW_CONST.set_start_date(history_date);

106: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
107:
108: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'M') THEN
109: history_date:= ADD_MONTHS(CE_CASH_FCST.G_rp_forecast_start_date,- CE_CASH_FCST.G_roll_forward_period);
110: CEFC_VIEW_CONST.set_start_date(history_date);
111: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period*30);
112: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period*30);
113:
114: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'A') THEN

Line 111: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period*30);

107:
108: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'M') THEN
109: history_date:= ADD_MONTHS(CE_CASH_FCST.G_rp_forecast_start_date,- CE_CASH_FCST.G_roll_forward_period);
110: CEFC_VIEW_CONST.set_start_date(history_date);
111: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period*30);
112: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period*30);
113:
114: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'A') THEN
115: BEGIN

Line 112: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period*30);

108: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'M') THEN
109: history_date:= ADD_MONTHS(CE_CASH_FCST.G_rp_forecast_start_date,- CE_CASH_FCST.G_roll_forward_period);
110: CEFC_VIEW_CONST.set_start_date(history_date);
111: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period*30);
112: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period*30);
113:
114: ELSIF (CE_CASH_FCST.G_roll_forward_type = 'A') THEN
115: BEGIN
116: SELECT gps.period_name

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

130: AND gp.period_set_name = gps.period_set_name
131: AND gps.period_type = gp.period_type
132: AND gpt.period_type = gp.period_type
133: AND gp.period_name = CE_CASH_FCST.G_rp_forecast_start_period
134: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
135:
136: CEFC_VIEW_CONST.set_start_period_name(history_period);
137: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
138: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);

Line 136: CEFC_VIEW_CONST.set_start_period_name(history_period);

132: AND gpt.period_type = gp.period_type
133: AND gp.period_name = CE_CASH_FCST.G_rp_forecast_start_period
134: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
135:
136: CEFC_VIEW_CONST.set_start_period_name(history_period);
137: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
138: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN

Line 137: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);

133: AND gp.period_name = CE_CASH_FCST.G_rp_forecast_start_period
134: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
135:
136: CEFC_VIEW_CONST.set_start_period_name(history_period);
137: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
138: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN
141: cep_standard.debug('NO DATA FOUND FOR HISTORY PERIOD');

Line 138: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);

134: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
135:
136: CEFC_VIEW_CONST.set_start_period_name(history_period);
137: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
138: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
139: EXCEPTION
140: WHEN NO_DATA_FOUND THEN
141: cep_standard.debug('NO DATA FOUND FOR HISTORY PERIOD');
142: RAISE;

Line 149: min_col := CEFC_VIEW_CONST.get_min_col;

145: raise;
146: END;
147: END IF;
148:
149: min_col := CEFC_VIEW_CONST.get_min_col;
150: max_col := CEFC_VIEW_CONST.get_max_col;
151: CE_CASH_FCST.G_invalid_overdue_row := FALSE;
152:
153: OPEN cCol;

Line 150: max_col := CEFC_VIEW_CONST.get_max_col;

146: END;
147: END IF;
148:
149: min_col := CEFC_VIEW_CONST.get_min_col;
150: max_col := CEFC_VIEW_CONST.get_max_col;
151: CE_CASH_FCST.G_invalid_overdue_row := FALSE;
152:
153: OPEN cCol;
154: FETCH cCol INTO cid, col_num, days_from, days_to;