APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_HEADERS

Line 96: from ce_forecast_headers

92: end if;
93:
94: select aging_type
95: into l_aging_type
96: from ce_forecast_headers
97: where forecast_header_id = l_forecast_header_id;
98:
99: CEFC_VIEW_CONST.set_constants(l_forecast_header_id,
100: l_period_set_name,

Line 321: from ce_forecast_headers

317: l_column_setup VARCHAR2(1);
318: BEGIN
319: select column_setup
320: into l_column_setup
321: from ce_forecast_headers
322: where forecast_header_id = X_forecast_header_id;
323:
324: if l_column_setup = 'A' then
325: update ce_forecast_headers

Line 325: update ce_forecast_headers

321: from ce_forecast_headers
322: where forecast_header_id = X_forecast_header_id;
323:
324: if l_column_setup = 'A' then
325: update ce_forecast_headers
326: set column_setup = 'M'
327: where forecast_header_id = X_forecast_header_id;
328: end if;
329:

Line 487: select ce_forecast_headers_s.nextval

483: l_forecast_column_id NUMBER;
484: l_forecast_period_id NUMBER;
485: l_drilldown_flag VARCHAR2(1);
486: BEGIN
487: select ce_forecast_headers_s.nextval
488: into l_forecast_header_id
489: from dual;
490:
491: INSERT INTO ce_forecast_headers(

Line 491: INSERT INTO ce_forecast_headers(

487: select ce_forecast_headers_s.nextval
488: into l_forecast_header_id
489: from dual;
490:
491: INSERT INTO ce_forecast_headers(
492: forecast_header_id,
493: name,
494: description,
495: aging_type,

Line 554: FROM ce_forecast_headers

550: attribute12,
551: attribute13,
552: attribute14,
553: attribute15
554: FROM ce_forecast_headers
555: WHERE forecast_header_id = X_forecast_header_id;
556:
557: if X_forecast_id is not null then
558: select nvl(drilldown_flag,'N')

Line 1075: FROM ce_forecast_headers

1071: l_request_id NUMBER;
1072: BEGIN
1073: SELECT aging_type
1074: INTO l_aging_type
1075: FROM ce_forecast_headers
1076: WHERE forecast_header_id = p_forecast_header_id;
1077:
1078: IF (p_start_project_num is null AND p_end_project_num is null
1079: AND nvl(p_sub_request,'N') = 'N') THEN