14: --G_glc_rowinfo RowInfoTab;
15: --
16: --Run-Time Parameters
17: --
18: G_rp_forecast_header_id CE_FORECAST_HEADERS.forecast_header_id%TYPE;
19: G_rp_forecast_runname CE_FORECASTS.name%TYPE;
20: G_rp_forecast_start_period CE_FORECASTS.start_period%TYPE;
21: G_rp_forecast_start_date CE_FORECASTS.start_date%TYPE;
22: G_rp_forecast_currency FND_CURRENCIES.currency_code%TYPE;
36:
37: --
38: --Header Info
39: --
40: G_aging_type CE_FORECAST_HEADERS.aging_type%TYPE;
41: G_forecast_id CE_FORECASTS.forecast_id%TYPE;
42: G_forecast_name CE_FORECAST_HEADERS.name%TYPE;
43: --G_forecast_history_date DATE;
44: --G_forecast_history_period VARCHAR2(30);
38: --Header Info
39: --
40: G_aging_type CE_FORECAST_HEADERS.aging_type%TYPE;
41: G_forecast_id CE_FORECASTS.forecast_id%TYPE;
42: G_forecast_name CE_FORECAST_HEADERS.name%TYPE;
43: --G_forecast_history_date DATE;
44: --G_forecast_history_period VARCHAR2(30);
45: G_period_set_name GL_PERIODS.period_set_name%TYPE;
46: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
42: G_forecast_name CE_FORECAST_HEADERS.name%TYPE;
43: --G_forecast_history_date DATE;
44: --G_forecast_history_period VARCHAR2(30);
45: G_period_set_name GL_PERIODS.period_set_name%TYPE;
46: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
47: --G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
48: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
50: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
43: --G_forecast_history_date DATE;
44: --G_forecast_history_period VARCHAR2(30);
45: G_period_set_name GL_PERIODS.period_set_name%TYPE;
46: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
47: --G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
48: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
50: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
51: G_treasury_template CE_FORECAST_HEADERS.treasury_template%TYPE;
44: --G_forecast_history_period VARCHAR2(30);
45: G_period_set_name GL_PERIODS.period_set_name%TYPE;
46: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
47: --G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
48: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
50: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
51: G_treasury_template CE_FORECAST_HEADERS.treasury_template%TYPE;
52: G_party_code XTR_PARTY_INFO.party_code%TYPE;
45: G_period_set_name GL_PERIODS.period_set_name%TYPE;
46: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
47: --G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
48: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
50: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
51: G_treasury_template CE_FORECAST_HEADERS.treasury_template%TYPE;
52: G_party_code XTR_PARTY_INFO.party_code%TYPE;
53:
46: G_overdue_transactions CE_FORECAST_HEADERS.overdue_transactions%TYPE;
47: --G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
48: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
50: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
51: G_treasury_template CE_FORECAST_HEADERS.treasury_template%TYPE;
52: G_party_code XTR_PARTY_INFO.party_code%TYPE;
53:
54: --row info
47: --G_cutoff_period CE_FORECAST_HEADERS.cutoff_period%TYPE;
48: G_transaction_calendar_id CE_FORECAST_HEADERS.transaction_calendar_id%TYPE;
49: G_start_project_id CE_FORECAST_HEADERS.start_project_id%TYPE;
50: G_end_project_id CE_FORECAST_HEADERS.end_project_id%TYPE;
51: G_treasury_template CE_FORECAST_HEADERS.treasury_template%TYPE;
52: G_party_code XTR_PARTY_INFO.party_code%TYPE;
53:
54: --row info
55: G_rowid VARCHAR2(30);