The following lines contain the word 'select', 'insert', 'update' or 'delete':
select budget_version_id
from pa_budget_versions
where project_id = p_project_id and
fin_plan_type_id = p_fin_plan_type_id and
plan_processing_code = 'WUE' and
process_update_wbs_flag = 'Y';
select
fin_plan_preference_code,
margin_derived_from_code,
report_labor_hrs_from_code,
nvl(approved_rev_plan_type_flag, 'N')
into
l_fin_plan_pref_code,
l_derive_margin_from_code,
l_report_labor_hrs_from_code,
x_ar_flag
from
pa_proj_fp_options
where
proj_fp_options_id=p_fin_plan_options_id;
select
p.projfunc_currency_code,
p.project_currency_code,
NVL(pt.org_project_flag, 'N')
into
l_currency_code,
l_proj_currency_code,
l_org_project_flag
from
pa_projects_all p,
pa_project_types_all pt
where
p.project_id=p_project_id and
p.project_type=pt.project_type and
p.org_id = pt.org_id; -- R12 MOAC 4447573: nvl(p.org_id, -99) = nvl(pt.org_id, -99)
select
name
into
l_fin_plan_type_name
from
pa_fin_plan_types_tl
where
fin_plan_type_id = p_fin_plan_type_id
and language = USERENV('LANG');
Code added to select plan_type_code so that Maintain
Versions page can distinguish between ORG_FORECAST and
non-ORG_FORECAST.
Code added to select plan_class_code so that Maintain
Versions page can set "Return to" link appropriately
================================================ */
select fin_plan_type_code,
plan_class_code
into l_fin_plan_type_code,
l_plan_class_code
from pa_fin_plan_types_b
where fin_plan_type_id = p_fin_plan_type_id;
select version_name
into l_version_name
from pa_budget_versions
where budget_version_id = px_target_version_id;
update pa_budget_versions
set version_name = l_version_name
where budget_version_id = px_target_version_id;
PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
(p_project_id => p_project_id,
p_structure_version_id => l_structure_version_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);