12: G_glc_rowinfo RowInfoTab;
13: --
14: --Run-Time Parameters
15: --
16: G_rp_forecast_header_id CE_FORECAST_HEADERS.forecast_header_id%TYPE;
17: G_rp_forecast_runname CE_FORECASTS.name%TYPE;
18: G_rp_forecast_start_period CE_FORECASTS.start_period%TYPE;
19: G_rp_forecast_start_date CE_FORECASTS.start_date%TYPE;
20: G_rp_forecast_currency FND_CURRENCIES.currency_code%TYPE;
38:
39: --
40: --Header Info
41: --
42: G_aging_type CE_FORECAST_HEADERS.aging_type%TYPE;
43: G_forecast_id CE_FORECASTS.forecast_id%TYPE;
44: G_forecast_name CE_FORECAST_HEADERS.name%TYPE;
45: G_forecast_history_date DATE;
46: G_forecast_history_period VARCHAR2(30);
40: --Header Info
41: --
42: G_aging_type CE_FORECAST_HEADERS.aging_type%TYPE;
43: G_forecast_id CE_FORECASTS.forecast_id%TYPE;
44: G_forecast_name CE_FORECAST_HEADERS.name%TYPE;
45: G_forecast_history_date DATE;
46: G_forecast_history_period VARCHAR2(30);
47: G_period_set_name GL_PERIODS.period_set_name%TYPE;
48: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
44: G_forecast_name CE_FORECAST_HEADERS.name%TYPE;
45: G_forecast_history_date DATE;
46: G_forecast_history_period VARCHAR2(30);
47: G_period_set_name GL_PERIODS.period_set_name%TYPE;
48: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
49: G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
50: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
51: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
52: G_start_project_no PA_PROJECTS_ALL.segment1%TYPE;
45: G_forecast_history_date DATE;
46: G_forecast_history_period VARCHAR2(30);
47: G_period_set_name GL_PERIODS.period_set_name%TYPE;
48: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
49: G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
50: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
51: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
52: G_start_project_no PA_PROJECTS_ALL.segment1%TYPE;
53: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
46: G_forecast_history_period VARCHAR2(30);
47: G_period_set_name GL_PERIODS.period_set_name%TYPE;
48: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
49: G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
50: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
51: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
52: G_start_project_no PA_PROJECTS_ALL.segment1%TYPE;
53: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
54: G_end_project_no PA_PROJECTS_ALL.segment1%TYPE;
47: G_period_set_name GL_PERIODS.period_set_name%TYPE;
48: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
49: G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
50: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
51: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
52: G_start_project_no PA_PROJECTS_ALL.segment1%TYPE;
53: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
54: G_end_project_no PA_PROJECTS_ALL.segment1%TYPE;
55: G_display_debug VARCHAR2(1);
49: G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
50: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
51: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
52: G_start_project_no PA_PROJECTS_ALL.segment1%TYPE;
53: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
54: G_end_project_no PA_PROJECTS_ALL.segment1%TYPE;
55: G_display_debug VARCHAR2(1);
56: G_debug_path VARCHAR2(100);
57: G_debug_file VARCHAR2(100);