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 104: cep_standard.debug('14164001: CEFC_VIEW_CONST.period_set_name=' || CEFC_VIEW_CONST.get_period_set_name);

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

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

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

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

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

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

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

Line 113: CEFC_VIEW_CONST.set_start_date(history_date);

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

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

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

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

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

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

134: AND gp.period_set_name = gps.period_set_name
135: AND gps.period_type = gp.period_type
136: AND gpt.period_type = gp.period_type
137: AND gp.period_name = CE_CASH_FCST.G_rp_forecast_start_period
138: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
139:
140: cep_standard.debug('14164001: CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||history_period);
141: CEFC_VIEW_CONST.set_start_period_name(history_period);
142: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);

Line 140: cep_standard.debug('14164001: CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||history_period);

136: AND gpt.period_type = gp.period_type
137: AND gp.period_name = CE_CASH_FCST.G_rp_forecast_start_period
138: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
139:
140: cep_standard.debug('14164001: CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||history_period);
141: CEFC_VIEW_CONST.set_start_period_name(history_period);
142: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
143: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
144: EXCEPTION

Line 141: CEFC_VIEW_CONST.set_start_period_name(history_period);

137: AND gp.period_name = CE_CASH_FCST.G_rp_forecast_start_period
138: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
139:
140: cep_standard.debug('14164001: CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||history_period);
141: CEFC_VIEW_CONST.set_start_period_name(history_period);
142: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
143: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN

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

138: AND gp.period_set_name = CEFC_VIEW_CONST.get_period_set_name;
139:
140: cep_standard.debug('14164001: CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||history_period);
141: CEFC_VIEW_CONST.set_start_period_name(history_period);
142: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
143: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN
146: cep_standard.debug('CE_CASH_FCST.Set_History EXCEPTION - NO DATA FOUND FOR HISTORY PERIOD');

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

139:
140: cep_standard.debug('14164001: CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||history_period);
141: CEFC_VIEW_CONST.set_start_period_name(history_period);
142: CEFC_VIEW_CONST.set_min_col(nvl(CE_CASH_FCST.G_min_col,0) + CE_CASH_FCST.G_roll_forward_period);
143: CEFC_VIEW_CONST.set_max_col(nvl(CE_CASH_FCST.G_max_col,0) + CE_CASH_FCST.G_roll_forward_period);
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN
146: cep_standard.debug('CE_CASH_FCST.Set_History EXCEPTION - NO DATA FOUND FOR HISTORY PERIOD');
147: RAISE;

Line 154: min_col := CEFC_VIEW_CONST.get_min_col;

150: raise;
151: END;
152: END IF;
153:
154: min_col := CEFC_VIEW_CONST.get_min_col;
155: max_col := CEFC_VIEW_CONST.get_max_col;
156: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_min_col='||min_col);
157: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_max_col='||max_col);
158:

Line 155: max_col := CEFC_VIEW_CONST.get_max_col;

151: END;
152: END IF;
153:
154: min_col := CEFC_VIEW_CONST.get_min_col;
155: max_col := CEFC_VIEW_CONST.get_max_col;
156: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_min_col='||min_col);
157: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_max_col='||max_col);
158:
159: CE_CASH_FCST.G_invalid_overdue_row := FALSE;

Line 156: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_min_col='||min_col);

152: END IF;
153:
154: min_col := CEFC_VIEW_CONST.get_min_col;
155: max_col := CEFC_VIEW_CONST.get_max_col;
156: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_min_col='||min_col);
157: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_max_col='||max_col);
158:
159: CE_CASH_FCST.G_invalid_overdue_row := FALSE;
160:

Line 157: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_max_col='||max_col);

153:
154: min_col := CEFC_VIEW_CONST.get_min_col;
155: max_col := CEFC_VIEW_CONST.get_max_col;
156: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_min_col='||min_col);
157: cep_standard.debug('14164001: CEFC_VIEW_CONST.get_max_col='||max_col);
158:
159: CE_CASH_FCST.G_invalid_overdue_row := FALSE;
160:
161: OPEN cCol;

Line 246: cep_standard.debug('CEFC_VIEW_CONST.GET_MIN_COL='||CEFC_VIEW_CONST.GET_MIN_COL);

242: ||to_char(CE_CSH_FCST_POP.G_calendar_end,'dd-mon-yyyy hh24:mi:ss'));
243:
244: -- debug statements added for bug 14164001
245: cep_standard.debug('-- bug 14164001 ----------------------------------------------------------');
246: cep_standard.debug('CEFC_VIEW_CONST.GET_MIN_COL='||CEFC_VIEW_CONST.GET_MIN_COL);
247: cep_standard.debug('CEFC_VIEW_CONST.GET_MAX_COL='||CEFC_VIEW_CONST.GET_MAX_COL);
248: cep_standard.debug('CEFC_VIEW_CONST.GET_HEADER_ID='||CEFC_VIEW_CONST.GET_HEADER_ID);
249: cep_standard.debug('CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||CEFC_VIEW_CONST.GET_START_PERIOD_NAME);
250: cep_standard.debug('CEFC_VIEW_CONST.GET_PERIOD_SET_NAME='||CEFC_VIEW_CONST.GET_PERIOD_SET_NAME);

Line 247: cep_standard.debug('CEFC_VIEW_CONST.GET_MAX_COL='||CEFC_VIEW_CONST.GET_MAX_COL);

243:
244: -- debug statements added for bug 14164001
245: cep_standard.debug('-- bug 14164001 ----------------------------------------------------------');
246: cep_standard.debug('CEFC_VIEW_CONST.GET_MIN_COL='||CEFC_VIEW_CONST.GET_MIN_COL);
247: cep_standard.debug('CEFC_VIEW_CONST.GET_MAX_COL='||CEFC_VIEW_CONST.GET_MAX_COL);
248: cep_standard.debug('CEFC_VIEW_CONST.GET_HEADER_ID='||CEFC_VIEW_CONST.GET_HEADER_ID);
249: cep_standard.debug('CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||CEFC_VIEW_CONST.GET_START_PERIOD_NAME);
250: cep_standard.debug('CEFC_VIEW_CONST.GET_PERIOD_SET_NAME='||CEFC_VIEW_CONST.GET_PERIOD_SET_NAME);
251: cep_standard.debug('--------------------------------------------------------------------------');

Line 248: cep_standard.debug('CEFC_VIEW_CONST.GET_HEADER_ID='||CEFC_VIEW_CONST.GET_HEADER_ID);

244: -- debug statements added for bug 14164001
245: cep_standard.debug('-- bug 14164001 ----------------------------------------------------------');
246: cep_standard.debug('CEFC_VIEW_CONST.GET_MIN_COL='||CEFC_VIEW_CONST.GET_MIN_COL);
247: cep_standard.debug('CEFC_VIEW_CONST.GET_MAX_COL='||CEFC_VIEW_CONST.GET_MAX_COL);
248: cep_standard.debug('CEFC_VIEW_CONST.GET_HEADER_ID='||CEFC_VIEW_CONST.GET_HEADER_ID);
249: cep_standard.debug('CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||CEFC_VIEW_CONST.GET_START_PERIOD_NAME);
250: cep_standard.debug('CEFC_VIEW_CONST.GET_PERIOD_SET_NAME='||CEFC_VIEW_CONST.GET_PERIOD_SET_NAME);
251: cep_standard.debug('--------------------------------------------------------------------------');
252: OPEN C1;

Line 249: cep_standard.debug('CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||CEFC_VIEW_CONST.GET_START_PERIOD_NAME);

245: cep_standard.debug('-- bug 14164001 ----------------------------------------------------------');
246: cep_standard.debug('CEFC_VIEW_CONST.GET_MIN_COL='||CEFC_VIEW_CONST.GET_MIN_COL);
247: cep_standard.debug('CEFC_VIEW_CONST.GET_MAX_COL='||CEFC_VIEW_CONST.GET_MAX_COL);
248: cep_standard.debug('CEFC_VIEW_CONST.GET_HEADER_ID='||CEFC_VIEW_CONST.GET_HEADER_ID);
249: cep_standard.debug('CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||CEFC_VIEW_CONST.GET_START_PERIOD_NAME);
250: cep_standard.debug('CEFC_VIEW_CONST.GET_PERIOD_SET_NAME='||CEFC_VIEW_CONST.GET_PERIOD_SET_NAME);
251: cep_standard.debug('--------------------------------------------------------------------------');
252: OPEN C1;
253: FETCH C1 INTO fid, start_date, end_date;

Line 250: cep_standard.debug('CEFC_VIEW_CONST.GET_PERIOD_SET_NAME='||CEFC_VIEW_CONST.GET_PERIOD_SET_NAME);

246: cep_standard.debug('CEFC_VIEW_CONST.GET_MIN_COL='||CEFC_VIEW_CONST.GET_MIN_COL);
247: cep_standard.debug('CEFC_VIEW_CONST.GET_MAX_COL='||CEFC_VIEW_CONST.GET_MAX_COL);
248: cep_standard.debug('CEFC_VIEW_CONST.GET_HEADER_ID='||CEFC_VIEW_CONST.GET_HEADER_ID);
249: cep_standard.debug('CEFC_VIEW_CONST.GET_START_PERIOD_NAME='||CEFC_VIEW_CONST.GET_START_PERIOD_NAME);
250: cep_standard.debug('CEFC_VIEW_CONST.GET_PERIOD_SET_NAME='||CEFC_VIEW_CONST.GET_PERIOD_SET_NAME);
251: cep_standard.debug('--------------------------------------------------------------------------');
252: OPEN C1;
253: FETCH C1 INTO fid, start_date, end_date;
254: LOOP