APPS.XTR_CASH_FCST dependencies on CE_FORECASTS

Line 78: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

74:
75: l_is_fixed_rate BOOLEAN;
76: l_relationship VARCHAR2(30);
77: error_msg VARCHAR2(2000);
78: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
79: CURSOR H IS SELECT CE_FORECAST_HEADERS_S.nextval FROM sys.dual;
80: BEGIN
81:
82: /* In the case where p_src_curr_type = 'Entered', ensure that there is no

Line 493: | Create forecast header for new forecast in ce_forecasts table |

489: /* ---------------------------------------------------------------------
490: | PRIVATE PROCEDURE |
491: | create_forecast_header |
492: | DESCRIPTION |
493: | Create forecast header for new forecast in ce_forecasts table |
494: | CALLED BY |
495: | create_forecast |
496: | HISTORY |
497: | 12-JAN-1999 Created BHCHUNG |

Line 505: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;

501: fid NUMBER;
502: error_msg FND_NEW_MESSAGES.message_text%TYPE;
503: duplicate_name BOOLEAN DEFAULT FALSE;
504:
505: CURSOR C IS SELECT CE_FORECASTS_S.nextval FROM sys.dual;
506: BEGIN
507: OPEN C;
508: FETCH C INTO G_forecast_id;
509: CLOSE C;

Line 517: FROM ce_forecasts

513: ELSE
514: BEGIN
515: SELECT forecast_id
516: INTO fid
517: FROM ce_forecasts
518: WHERE name = G_rp_forecast_runname;
519:
520: duplicate_name := TRUE;
521: G_rp_forecast_runname := G_rp_forecast_runname||'/'||to_char(sysdate,'DD-MON-RRRR HH:MI:SS');

Line 529: DELETE FROM ce_forecasts

525: END;
526: END IF;
527:
528: /* AW 1378198
529: DELETE FROM ce_forecasts
530: WHERE forecast_header_id = G_rp_forecast_header_id;
531:
532: DELETE FROM ce_forecast_errors
533: WHERE forecast_header_id = G_rp_forecast_header_id;

Line 536: INSERT INTO ce_forecasts(

532: DELETE FROM ce_forecast_errors
533: WHERE forecast_header_id = G_rp_forecast_header_id;
534: */
535:
536: INSERT INTO ce_forecasts(
537: FORECAST_ID,
538: FORECAST_HEADER_ID,
539: NAME,
540: START_DATE,

Line 715: FROM ce_forecasts

711:
712: IF (wrap_up_process(req_data) OR standalone_process) THEN
713: SELECT error_status
714: INTO l_status
715: FROM ce_forecasts
716: WHERE forecast_id = G_forecast_id;
717:
718: IF l_status <> 'E' THEN
719: print_report;

Line 800: DELETE FROM ce_forecasts

796:
797: -- AW Bug 1378198 The following is taken from procedure CREATE_FORECAST_HEADER
798: --
799: BEGIN
800: DELETE FROM ce_forecasts
801: WHERE forecast_header_id = G_rp_forecast_header_id;
802: IF SQL%FOUND THEN
803: COMMIT;
804: END IF;