[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bv.budget_version_id,bv.project_id,bv.resource_list_id
from pa_budget_versions bv
where bv.fin_plan_type_id is not null
and bv.budget_version_id = c_budget_version_id
and exists (select 'X' from pa_resource_assignments ra
where bv.budget_version_id = ra.budget_version_id);
select ra.resource_assignment_id,ra.resource_list_member_id,
rlm.migrated_rbs_element_id,
min(bl.start_date) min_date,max(bl.end_date) max_date
from pa_resource_assignments ra,pa_resource_list_members rlm,pa_budget_lines bl
where ra.budget_version_id = c_budget_version_id and
ra.project_id = c_project_id
AND ra.resource_list_member_id = rlm.resource_list_member_id
AND rlm.res_format_id is not null -- Added for bug#4765774
and ra.budget_version_id = bl.budget_version_id
group by ra.resource_assignment_id,ra.resource_list_member_id,rlm.migrated_rbs_element_id
order by ra.resource_assignment_id,ra.resource_list_member_id;
select spread_curve_id
INTO l_spread_curve_id
from pa_spread_curves_b
where spread_curve_code='FIXED_DATE';
l_res_assign_id_tbl.delete;
l_max_date_tbl.delete;
l_min_date_tbl.delete;
l_rbs_element_id_tbl.delete;
l_sys_rlm_ids_tbl.delete;
l_resource_class_flag_tbl.delete;
l_resource_class_code_tbl.delete;
l_resource_class_id_tbl.delete;
l_res_type_code_tbl.delete;
l_person_id_tbl.delete;
l_job_id_tbl.delete;
l_person_type_code_tbl.delete;
l_named_role_tbl.delete;
l_bom_resource_id_tbl.delete;
l_non_labor_resource_tbl.delete;
l_inventory_item_id_tbl.delete;
l_item_category_id_tbl.delete;
l_project_role_id_tbl.delete;
l_organization_id_tbl.delete;
l_fc_res_type_code_tbl.delete;
l_expenditure_type_tbl.delete;
l_expenditure_category_tbl.delete;
l_event_type_tbl.delete;
l_revenue_category_code_tbl.delete;
l_supplier_id_tbl.delete;
l_unit_of_measure_tbl.delete;
l_spread_curve_id_tbl.delete;
l_etc_method_code_tbl.delete;
l_mfc_cost_type_id_tbl.delete;
l_incurred_by_res_flag_tbl.delete;
l_incur_by_res_class_code_tbl.delete;
l_Incur_by_role_id_tbl.delete;
l_org_id_tbl.delete;
l_rate_based_flag_tbl.delete;
l_rate_expenditure_type_tbl.delete;
l_rate_exp_func_curr_code_tbl.delete;
l_incur_by_res_type_tbl.delete;
update pa_resource_assignments
set
record_version_number = record_version_number + 1,
rbs_element_id = l_rbs_element_id_tbl(j),
resource_class_code = l_resource_class_code_tbl(j) ,
spread_curve_id = decode(l_spread_curve_id,l_spread_curve_id_tbl(j),NULL,l_spread_curve_id_tbl(j)),
sp_fixed_date = NULL,
etc_method_code = l_etc_method_code_tbl(j),
res_type_code = l_res_type_code_tbl(j),
organization_id = l_organization_id_tbl(j),
job_id = l_job_id_tbl(j),
person_id = l_person_id_tbl(j),
expenditure_type = l_expenditure_type_tbl(j),
expenditure_category = l_expenditure_category_tbl(j),
revenue_category_code = l_revenue_category_code_tbl(j),
event_type = l_event_type_tbl(j),
supplier_id = l_supplier_id_tbl(j),
project_role_id = l_project_role_id_tbl(j),
person_type_code = l_person_type_code_tbl(j),
non_labor_resource = l_non_labor_resource_tbl(j),
bom_resource_id = l_bom_resource_id_tbl(j),
inventory_item_id = l_inventory_item_id_tbl(j),
item_category_id = l_item_category_id_tbl(j),
transaction_source_code = null,
mfc_cost_type_id = l_mfc_cost_type_id_tbl(j),
procure_resource_flag = null,
incurred_by_res_flag = l_incurred_by_res_flag_tbl(j),
rate_job_id = null,
rate_expenditure_type = l_rate_expenditure_type_tbl(j),
rate_based_flag = l_rate_based_flag_tbl(j),
use_task_schedule_flag = null,
rate_exp_func_curr_code = l_rate_exp_func_curr_code_tbl(j),
rate_expenditure_org_id = l_org_id_tbl(j), /* bug: 3799921: assigned local var */
incur_by_res_class_code = l_incur_by_res_class_code_tbl(j),
incur_by_role_id = l_incur_by_role_id_tbl(j),
resource_class_flag = l_resource_class_flag_tbl(j),
named_role = l_named_role_tbl(j),
planning_start_date = l_min_date_tbl(j),
planning_end_date = l_max_date_tbl(j),
fc_res_type_code = l_fc_res_type_code_tbl(j), /* Bug 3799921 */
unit_of_measure = l_unit_of_measure_tbl(j), /* Bug 3799921 */
resource_rate_based_flag = l_rate_based_flag_tbl(j) /* Bug 5144013: IPM Changes */
where resource_assignment_id = l_res_assign_id_tbl(j);