4234: and b.budget_type_code = t.budget_type_code;
4235:
4236: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4237: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4238: l_start_period_name pa_periods_all.period_name%type;
4239: l_start_period_date pa_periods_all.start_date%type;
4240: l_budget_version_id pa_budget_versions.budget_version_id%type;
4241: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4242: x_err_code number;
4235:
4236: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%type;
4237: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%type;
4238: l_start_period_name pa_periods_all.period_name%type;
4239: l_start_period_date pa_periods_all.start_date%type;
4240: l_budget_version_id pa_budget_versions.budget_version_id%type;
4241: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4242: x_err_code number;
4243: x_err_stage varchar2(2000);
4342: l_budget_entry_method_code pa_budget_entry_methods.time_phased_type_code%type;
4343: l_budget_version_id pa_budget_versions.budget_version_id%type;
4344:
4345:
4346: l_start_period_date pa_periods_all.start_date%type;
4347: l_end_period_date pa_periods_all.end_date%type;
4348:
4349: l_request_id number;
4350:
4343: l_budget_version_id pa_budget_versions.budget_version_id%type;
4344:
4345:
4346: l_start_period_date pa_periods_all.start_date%type;
4347: l_end_period_date pa_periods_all.end_date%type;
4348:
4349: l_request_id number;
4350:
4351: exc_wrong_period_set exception;