132: g_pos_ws_col_no NUMBER;
133: g_total_budget_years NUMBER;
134:
135:
136: g_ws_cols PSB_EXCEL_PVT.g_ws_col_tbl_type;
137: g_pos_ws_cols PSB_EXCEL_PVT.g_pos_ws_col_tbl_type;
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
133: g_total_budget_years NUMBER;
134:
135:
136: g_ws_cols PSB_EXCEL_PVT.g_ws_col_tbl_type;
137: g_pos_ws_cols PSB_EXCEL_PVT.g_pos_ws_col_tbl_type;
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
134:
135:
136: g_ws_cols PSB_EXCEL_PVT.g_ws_col_tbl_type;
137: g_pos_ws_cols PSB_EXCEL_PVT.g_pos_ws_col_tbl_type;
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
142: g_wal_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
135:
136: g_ws_cols PSB_EXCEL_PVT.g_ws_col_tbl_type;
137: g_pos_ws_cols PSB_EXCEL_PVT.g_pos_ws_col_tbl_type;
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
142: g_wal_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
143: g_fte_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
136: g_ws_cols PSB_EXCEL_PVT.g_ws_col_tbl_type;
137: g_pos_ws_cols PSB_EXCEL_PVT.g_pos_ws_col_tbl_type;
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
142: g_wal_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
143: g_fte_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
144:
137: g_pos_ws_cols PSB_EXCEL_PVT.g_pos_ws_col_tbl_type;
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
142: g_wal_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
143: g_fte_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
144:
145: TYPE g_estimate_year_type IS RECORD
138: g_year_amts PSB_EXCEL_PVT.g_year_amount_tbl_type;
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
142: g_wal_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
143: g_fte_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
144:
145: TYPE g_estimate_year_type IS RECORD
146: (
139: g_year_num_periods PSB_EXCEL_PVT.g_year_num_periods_tbl_type;
140: g_acl_ids PSB_EXCEL_PVT.g_acl_id_tbl_type;
141: g_wlbi_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1.. 168
142: g_wal_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
143: g_fte_period_amounts PSB_EXCEL_PVT.g_period_amount_tbl_type; --1..12(upto 60)
144:
145: TYPE g_estimate_year_type IS RECORD
146: (
147: total_column NUMBER,
552: raise FND_API.G_EXC_ERROR;
553: end if;
554:
555: -- Setup the Calendar Info in Globals
556: PSB_EXCEL_PVT.Get_Calendar_Dates
557: ( p_budget_calendar_id => g_budget_calendar_id,
558: p_calendar_start_date => g_calendar_start_date,
559: p_calendar_end_date => g_calendar_end_date,
560: p_cy_end_date => g_cy_end_date,