The following lines contain the word 'select', 'insert', 'update' or 'delete':
select budget_status_code
into x_budget_status_code
from pa_budget_versions
where budget_version_id = p_budget_version_id;
select project_id
into l_project_id
from pa_budget_versions
where budget_version_id = p_orgfcst_version_id;
select nvl(org_id,-99)
into l_org_id
from pa_projects_all
where project_id = l_project_id;
select fin_plan_start_date, fin_plan_end_date
into ll_plan_start_date,ll_plan_end_date
from pa_proj_fp_options
where fin_plan_version_id = p_orgfcst_version_id;
select pp.plan_period_type
into ll_plan_period_type
from pa_proj_period_profiles pp,
pa_budget_versions pbv
where pbv.budget_version_id = p_orgfcst_version_id
and pp.period_profile_id = pbv.period_profile_id;
select pe.adjustment_comments
into x_adj_comments
from pa_fp_adj_elements pe,
pa_resource_assignments pra
where pra.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
and resource_assignment_type = 'OWN'
and pe.budget_version_id = pa_fin_plan_view_global.Get_Version_ID()
and pe.resource_assignment_id = pra.resource_assignment_id
and pe.ADJUSTMENT_REASON_CODE = pa_fin_plan_view_global.Get_Adj_Reason_Code();
SELECT * FROM(
SELECT start_date,end_date
FROM pa_orgfcst_periods_tmp_v
WHERE start_date >= l_start_date
order by start_date
)
where rownum <= l_rownum;
SELECT value
INTO l_format_mask
FROM nls_session_parameters
WHERE parameter='NLS_DATE_FORMAT';
SELECT start_date
FROM pa_orgfcst_periods_tmp_v
WHERE start_date > l_start_date
order by start_date;
SELECT start_date
FROM pa_orgfcst_periods_tmp_v
WHERE start_date < l_start_date
order by start_date desc;
PROCEDURE pa_fp_update_tables( p_amount_type_code IN VARCHAR2,
p_amount_subtype_code IN VARCHAR2,
p_adj_reason_code IN VARCHAR2,
p_adj_comments IN VARCHAR2,
p_currency_code IN VARCHAR2,
p_project_id IN NUMBER,
p_period1 IN NUMBER,
p_period2 IN NUMBER,
p_period3 IN NUMBER,
p_period4 IN NUMBER,
p_period5 IN NUMBER,
p_period6 IN NUMBER,
p_period7 IN NUMBER,
p_period8 IN NUMBER,
p_period9 IN NUMBER,
p_period10 IN NUMBER,
p_period11 IN NUMBER,
p_period12 IN NUMBER,
p_period13 IN NUMBER,
p_period_type IN VARCHAR2,
p_budget_version_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
l_msg_count NUMBER;
insert into PA_FP_ADJ_GLOB_TMP
(AMOUNT_TYPE_CODE,
AMOUNT_SUBTYPE_CODE,
ADJUSTMENT_COMMENTS,
CURRENCY_CODE,
ADJUSTMENT_REASON_CODE,
BUDGET_VERSION_ID,
PROJECT_ID,
PERIOD1_AMOUNT,
PERIOD1_NAME,
PERIOD2_AMOUNT,
PERIOD2_NAME ,
PERIOD3_AMOUNT,
PERIOD3_NAME ,
PERIOD4_AMOUNT ,
PERIOD4_NAME ,
PERIOD5_AMOUNT ,
PERIOD5_NAME ,
PERIOD6_AMOUNT ,
PERIOD6_NAME ,
PERIOD7_AMOUNT ,
PERIOD7_NAME ,
PERIOD8_AMOUNT ,
PERIOD8_NAME,
PERIOD9_AMOUNT,
PERIOD9_NAME ,
PERIOD10_AMOUNT,
PERIOD10_NAME ,
PERIOD11_AMOUNT ,
PERIOD11_NAME,
PERIOD12_AMOUNT,
PERIOD12_NAME ,
PERIOD13_AMOUNT ,
PERIOD13_NAME)
select p_amount_type_code,
p_amount_subtype_code,
p_adj_comments,
p_currency_code,
p_adj_reason_code,
l_budget_version_id,
p_project_id,
p_period1,
pn.period_name1,
p_period2,
pn.period_name2,
p_period3,
pn.period_name3,
p_period4,
pn.period_name4,
p_period5,
pn.period_name5,
p_period6,
pn.period_name6,
p_period7,
pn.period_name7,
p_period8,
pn.period_name8,
p_period9,
pn.period_name9,
p_period10,
pn.period_name10,
p_period11,
pn.period_name11,
p_period12,
pn.period_name12,
p_period13,
pn.period_name13
from pa_fp_period_names_v pn;
select period_name1,
period_name2,
period_name3,
period_name4,
period_name5,
period_name6,
period_name7,
period_name8,
period_name9,
period_name10,
period_name11,
period_name12,
period_name13
into l_period_name1,
l_period_name2,
l_period_name3,
l_period_name4,
l_period_name5,
l_period_name6,
l_period_name7,
l_period_name8,
l_period_name9,
l_period_name10,
l_period_name11,
l_period_name12,
l_period_name13
from pa_fp_period_names_v;
select pp.number_of_periods
into l_number_of_periods
from pa_proj_period_profiles pp,
pa_budget_versions pbv
where pbv.budget_version_id = l_budget_version_id
and pp.period_profile_id = pbv.period_profile_id;
select resource_assignment_id,task_id
into l_ra_id_pl,l_task_id_pl
from pa_resource_assignments
where budget_version_id = l_budget_version_id
and resource_assignment_type = 'PROJECT';
select resource_assignment_id,task_id
into l_ra_id_tl,l_task_id_tl
from pa_resource_assignments
where budget_version_id = l_budget_version_id
and resource_assignment_type = 'OWN';
/*Update pa_fp_adj_elements*/
/***************************************************************************************/
begin
select adj_element_id
into l_adj_element_id_pl
from pa_fp_adj_elements
where resource_assignment_id = l_ra_id_pl
and adjustment_reason_code = l_adj_reason_code;
update_row(p_adj_element_id => l_adj_element_id_pl,
p_adjustment_comments => l_adj_comments,
x_return_status => l_return_status );
insert_row(px_adj_element_id => l_adj_element_id_pl,
p_resource_assignment_id => l_ra_id_pl,
p_budget_version_id => l_budget_version_id,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_adjustment_reason_code =>l_adj_reason_code,
p_adjustment_comments => l_adj_comments,
x_row_id => l_row_id,
x_return_status =>l_return_status );
select adj_element_id
into l_adj_element_id_tl
from pa_fp_adj_elements
where resource_assignment_id = l_ra_id_tl
and adjustment_reason_code = l_adj_reason_code;
update_row(p_adj_element_id => l_adj_element_id_tl,
p_adjustment_comments => l_adj_comments,
x_return_status => l_return_status );
insert_row(px_adj_element_id => l_adj_element_id_tl,
p_resource_assignment_id => l_ra_id_tl,
p_budget_version_id => l_budget_version_id,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_adjustment_reason_code =>l_adj_reason_code,
p_adjustment_comments => l_adj_comments,
x_row_id => l_row_id,
x_return_status =>l_return_status );
/*End of Update pa_fp_adj_elements*/
/***************************************************************************************/
/****************************************************************************************/
/*Update pa_fin_plan_adj_lines*/
/***************************************************************************************/
/*for period 1*/
if l_period_name1 is not null then
begin
l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id1
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_project_id => l_project_id,
p_adj_element_id => l_adj_element_id_tl,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id2
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id3
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id4
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id5
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id6
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id7
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_project_id => l_project_id,
p_adj_element_id => l_adj_element_id_tl,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id8
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id9
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id10
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id11
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id12
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id13
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_tl
and adj_element_id = l_adj_element_id_tl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_tl,
p_project_id => l_project_id,
p_task_id => l_task_id_tl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_tl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id1
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id1,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id2
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id2,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id3
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id3,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id4
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id4,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id5
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id5,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id6
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id6,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id7
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id7,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id8
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id8,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id9
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id9,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id10
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id10,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id11
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id11,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id12
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id12,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
select FIN_PLAN_ADJ_LINE_ID
into l_fin_plan_adj_line_id13
from pa_fin_plan_adj_lines
where budget_version_id = l_budget_version_id
and period_name=l_period_name
and resource_assignment_id = l_ra_id_pl
and adj_element_id = l_adj_element_id_pl;
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_revenue_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_burdened_cost_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_utilization_adjustment => l_period_amount,
x_return_status => l_return_status);
update_row(p_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_head_count_adjustment => l_period_amount,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_revenue_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_burdened_cost_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_utilization_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
insert_row(px_fin_plan_adj_line_id => l_fin_plan_adj_line_id13,
p_adj_element_id => l_adj_element_id_pl,
p_project_id => l_project_id,
p_task_id => l_task_id_pl,
p_budget_version_id => l_budget_version_id,
p_resource_assignment_id => l_ra_id_pl,
p_period_name => l_period_name,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_head_count_adjustment => l_period_amount,
x_row_id => l_row_id,
x_return_status => l_return_status);
/*End of update pa_fin_plan_adj_lines*/
/***************************************************************************************/
/********************************************************************************************/
/* update pa_budget_lines */
/********************************************************************************************/
---->Bug 4947912. In the code below that updates pa_budget_lines did the following changes
---->Handled the no_data_found exception on the Selects on pa_budget_lines
---->Call to pa_fp_budget_lines_pkg.Update_Row is made only if the budget line exists.
/* for period1 */
if l_period_name1 is not null then
/*for l_ra_id_pl project level resource_assignment_id*/
l_start_date := pa_fin_plan_view_global.G_FP_VIEW_START_DATE1;
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_pl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
select budget_line_id
into l_budget_line_id
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date
and txn_currency_code = p_currency_code;
select sum(nvl(revenue_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_revenue_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(burdened_cost_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_cost_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(head_count_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_head_count_adj => l_period_amount,
x_return_status =>l_return_status);
select sum(nvl(utilization_adjustment,0))
into l_period_amount
from pa_fin_plan_adj_lines
where resource_assignment_id = l_ra_id_tl
and start_date = l_start_date;
Update_Row(p_budget_line_id =>l_budget_line_id,
p_utilization_adj => l_period_amount,
x_return_status =>l_return_status);
/*End of update pa_budget_lines*/
/***************************************************************************************/
-- End IF;
/*Begin of update pa_resource_assignments*/
/***************************************************************************************/
begin
/*for task level resource_assignment_id*/
select sum(nvl(REVENUE_ADJ,0)), sum(nvl(COST_ADJ,0)),
sum(nvl(UTILIZATION_ADJ,0)),
round(sum(nvl(HEAD_COUNT_ADJ,0)),0)
into l_adj_rev_amount,l_adj_cost_amount,
l_adj_util_amount,l_adj_hc_amount
from pa_budget_lines
where resource_assignment_id = l_ra_id_tl;
update_row(
p_resource_assignment_id => l_ra_id_tl,
p_total_revenue_adj => l_adj_rev_amount,
p_total_cost_adj => l_adj_cost_amount,
p_total_utilization_adj => l_adj_util_amount,
p_total_head_count_adj => l_adj_hc_amount,
x_return_status => l_return_status);
select sum(nvl(REVENUE_ADJ,0)), sum(nvl(COST_ADJ,0)),
sum(nvl(UTILIZATION_ADJ,0)),
round(sum(nvl(HEAD_COUNT_ADJ,0)),0)
into l_adj_rev_amount,l_adj_cost_amount,
l_adj_util_amount,l_adj_hc_amount
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl;
update_row(
p_resource_assignment_id => l_ra_id_pl,
p_total_revenue_adj => l_adj_rev_amount,
p_total_cost_adj => l_adj_cost_amount,
p_total_utilization_adj => l_adj_util_amount,
p_total_head_count_adj => l_adj_hc_amount,
x_return_status => l_return_status);
/*End of update pa_resource_assignments*/
/***************************************************************************************/
/****************************************************************************************/
/*Begin of update pa_budget_versions*/
/***************************************************************************************/
begin
l_record_version_number := pa_fin_plan_utils.
Retrieve_Record_Version_Number(l_budget_version_id);
select sum(nvl(REVENUE_ADJ,0)), sum(nvl(COST_ADJ,0)),
sum(nvl(UTILIZATION_ADJ,0))/l_number_of_periods,
round(sum(nvl(HEAD_COUNT_ADJ,0))/l_number_of_periods,0)
into l_adj_rev_amount,l_adj_cost_amount,
l_adj_util_amount,l_adj_hc_amount
from pa_budget_lines
where resource_assignment_id = l_ra_id_pl;
update_row(
p_budget_version_id => l_budget_version_id,
p_total_revenue_adj => l_adj_rev_amount,
p_total_cost_adj => l_adj_cost_amount,
p_total_utilization_adj => l_adj_util_amount,
p_total_head_count_adj => l_adj_hc_amount,
x_return_status => l_return_status
);
/*End of update pa_budget_versions*/
/***************************************************************************************/
/****************************************************************************************/
/*Begin of update pa_proj_periods_denorm*/
/***************************************************************************************/
BEGIN
select nvl(period_col_name1,'period_amount40'),
nvl(period_col_name2,'period_amount41'),
nvl(period_col_name3,'period_amount42'),
nvl(period_col_name4,'period_amount43'),
nvl(period_col_name5,'period_amount44'),
nvl(period_col_name6,'period_amount45'),
nvl(period_col_name7,'period_amount46'),
nvl(period_col_name8,'period_amount47'),
nvl(period_col_name9,'period_amount48'),
nvl(period_col_name10,'period_amount49'),
nvl(period_col_name11,'period_amount50'),
nvl(period_col_name12,'period_amount51'),
nvl(period_col_name13,'period_amount52')
into colname1,colname2,colname3,colname4,colname5,colname6,
colname7,colname8,colname9,colname10,colname11,colname12,colname13
from pa_fp_period_col_names_v;
select period_profile_id
into l_period_profile_id
from pa_budget_versions
where budget_version_id = l_budget_version_id;
select amount_type_id
into l_amount_type_id
from pa_amount_types_vl
where amount_type_code = l_amount_type_code;
select amount_type_id
into l_amount_subtype_id
from pa_amount_types_vl
where amount_type_code = l_amount_subtype_code;
select object_id
into l_element_id_pl
from pa_proj_periods_denorm
where object_type_code = 'ADJ_ELEMENTS'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = -1
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_adj_element_id_pl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
select object_id
into l_element_id_tl
from pa_proj_periods_denorm
where object_type_code = 'ADJ_ELEMENTS'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = -2
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_adj_element_id_tl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
/*update denorm from budget_lines and resource assignment*/
/* for project level res id */
begin
select object_id
into ll_ra_id_pl
from pa_proj_periods_denorm
where object_type_code = 'RES_ASSIGNMENT'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = l_ra_id_pl
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_ra_id_pl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
select object_id
into ll_ra_id_tl
from pa_proj_periods_denorm
where object_type_code = 'RES_ASSIGNMENT'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = l_ra_id_tl
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_ra_id_tl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
/* Need to update the Margin and Margin% Also*/
/* for project level res id */
/* Get Revenue */
begin
select period1,period2,period3,period4,period5,period6
into l_rev1_pl,l_rev2_pl,l_rev3_pl,l_rev4_pl,l_rev5_pl,l_rev6_pl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'REVENUE';
l_stmt := 'select sum(nvl('||colname1||',0)),'||
'sum(nvl('||colname2||',0)),'||
'sum(nvl('||colname3||',0)),'||
'sum(nvl('||colname4||',0)),'||
'sum(nvl('||colname5||',0)),'||
'sum(nvl('||colname6||',0))'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select period1,period2,period3,period4,period5,period6
into l_cost1_pl,l_cost2_pl,l_cost3_pl,l_cost4_pl,l_cost5_pl,l_cost6_pl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'COST';
l_stmt := 'select sum(nvl('||colname1||',0)),'||
'sum(nvl('||colname2||',0)),'||
'sum(nvl('||colname3||',0)),'||
'sum(nvl('||colname4||',0)),'||
'sum(nvl('||colname5||',0)),'||
'sum(nvl('||colname6||',0))'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6'||'
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6'||'
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select period1,period2,period3,period4,period5,period6
into l_rev1_tl,l_rev2_tl,l_rev3_tl,l_rev4_tl,l_rev5_tl,l_rev6_tl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'REVENUE';
l_stmt := 'select sum('||colname1||'),'||
'sum('||colname2||'),'||
'sum('||colname3||'),'||
'sum('||colname4||'),'||
'sum('||colname5||'),'||
'sum('||colname6||')'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select period1,period2,period3,period4,period5,period6
into l_cost1_tl,l_cost2_tl,l_cost3_tl,l_cost4_tl,l_cost5_tl,l_cost6_tl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'COST';
l_stmt := 'select sum('||colname1||'),'||
'sum('||colname2||'),'||
'sum('||colname3||'),'||
'sum('||colname4||'),'||
'sum('||colname5||'),'||
'sum('||colname6||')'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6'||'
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6'||'
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select object_id
into l_element_id_pl
from pa_proj_periods_denorm
where object_type_code = 'ADJ_ELEMENTS'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = -1
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_adj_element_id_pl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||','||
colname7||','||
colname8||','||
colname9||','||
colname10||','||
colname11||','||
colname12||','||
colname13||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6,
:n7,
:n8,
:n9,
:n10,
:n11,
:n12,
:n13 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
select object_id
into l_element_id_tl
from pa_proj_periods_denorm
where object_type_code = 'ADJ_ELEMENTS'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = -2
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_adj_element_id_tl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||','||
colname7||','||
colname8||','||
colname9||','||
colname10||','||
colname11||','||
colname12||','||
colname13||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6,
:n7,
:n8,
:n9,
:n10,
:n11,
:n12,
:n13 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
/*update denorm from budget_lines and resource assignment*/
/* for project level res id */
begin
select object_id
into ll_ra_id_pl
from pa_proj_periods_denorm
where object_type_code = 'RES_ASSIGNMENT'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = l_ra_id_pl
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_ra_id_pl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||','||
colname7||','||
colname8||','||
colname9||','||
colname10||','||
colname11||','||
colname12||','||
colname13||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6,
:n7,
:n8,
:n9,
:n10,
:n11,
:n12,
:n13 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
select object_id
into ll_ra_id_tl
from pa_proj_periods_denorm
where object_type_code = 'RES_ASSIGNMENT'
and amount_type_code = l_amount_type_code
and amount_subtype_code = l_amount_subtype_code
and budget_version_id = l_budget_version_id
and resource_assignment_id = l_ra_id_tl
and currency_code = l_currency_code
and currency_type = l_currency_type
and object_id = l_ra_id_tl;
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'insert into pa_proj_periods_denorm
( CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
budget_version_id,
project_id,
resource_assignment_id,
object_id,
object_type_code,
period_profile_id,
amount_type_code,
amount_subtype_code,
amount_type_id,
amount_subtype_id,
currency_type,
currency_code,'||
colname1||','||
colname2||','||
colname3||','||
colname4||','||
colname5||','||
colname6||','||
colname7||','||
colname8||','||
colname9||','||
colname10||','||
colname11||','||
colname12||','||
colname13||')
values( :creationDate,
:createdBy,
:lastUpdateLogin,
:lastUpdatedBy,
:lastUpdatedDate,
:versionId,
:projectId,
:resId,
:elementId,
:elementCode,
:profileId,
:amountTypeCode,
:amountSubtypeCode,
:amountTypeId,
:amountSubTypeId,
:currencyType,
:currencyCode,
:n1,
:n2,
:n3,
:n4,
:n5,
:n6,
:n7,
:n8,
:n9,
:n10,
:n11,
:n12,
:n13 )';
dbms_sql.bind_variable(cursor_id,':lastUpdateLogin',fnd_global.login_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedBy',fnd_global.user_id);
dbms_sql.bind_variable(cursor_id,':lastUpdatedDate',sysdate);
/* Need to update the Margin and Margin% Also*/
/* for project level res id */
/* Get Revenue */
begin
select period1,period2,period3,period4,period5,period6,period7,
period8,period9,period10,period11,period12,period13
into l_rev1_pl,l_rev2_pl,l_rev3_pl,l_rev4_pl,l_rev5_pl,l_rev6_pl,
l_rev7_pl,l_rev8_pl,l_rev9_pl,l_rev10_pl,l_rev11_pl,l_rev12_pl,l_rev13_pl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'REVENUE';
l_stmt := 'select sum(nvl('||colname1||',0)),'||
'sum(nvl('||colname2||',0)),'||
'sum(nvl('||colname3||',0)),'||
'sum(nvl('||colname4||',0)),'||
'sum(nvl('||colname5||',0)),'||
'sum(nvl('||colname6||',0)),'||
'sum(nvl('||colname7||',0)),'||
'sum(nvl('||colname8||',0)),'||
'sum(nvl('||colname9||',0)),'||
'sum(nvl('||colname10||',0)),'||
'sum(nvl('||colname11||',0)),'||
'sum(nvl('||colname12||',0)),'||
'sum(nvl('||colname13||',0))'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select period1,period2,period3,period4,period5,period6,period7,
period8,period9,period10,period11,period12,period13
into l_cost1_pl,l_cost2_pl,l_cost3_pl,l_cost4_pl,l_cost5_pl,l_cost6_pl,
l_cost7_pl,l_cost8_pl,l_cost9_pl,l_cost10_pl,l_cost11_pl,l_cost12_pl,l_cost13_pl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'COST';
l_stmt := 'select sum(nvl('||colname1||',0)),'||
'sum(nvl('||colname2||',0)),'||
'sum(nvl('||colname3||',0)),'||
'sum(nvl('||colname4||',0)),'||
'sum(nvl('||colname5||',0)),'||
'sum(nvl('||colname6||',0)),'||
'sum(nvl('||colname7||',0)),'||
'sum(nvl('||colname8||',0)),'||
'sum(nvl('||colname9||',0)),'||
'sum(nvl('||colname10||',0)),'||
'sum(nvl('||colname11||',0)),'||
'sum(nvl('||colname12||',0)),'||
'sum(nvl('||colname13||',0))'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select period1,period2,period3,period4,period5,period6,period7,
period8,period9,period10,period11,period12,period13
into l_rev1_tl,l_rev2_tl,l_rev3_tl,l_rev4_tl,l_rev5_tl,l_rev6_tl,
l_rev7_tl,l_rev8_tl,l_rev9_tl,l_rev10_tl,l_rev11_tl,l_rev12_tl,l_rev13_tl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'REVENUE';
l_stmt := 'select sum(nvl('||colname1||',0)),'||
'sum(nvl('||colname2||',0)),'||
'sum(nvl('||colname3||',0)),'||
'sum(nvl('||colname4||',0)),'||
'sum(nvl('||colname5||',0)),'||
'sum(nvl('||colname6||',0)),'||
'sum(nvl('||colname7||',0)),'||
'sum(nvl('||colname8||',0)),'||
'sum(nvl('||colname9||',0)),'||
'sum(nvl('||colname10||',0)),'||
'sum(nvl('||colname11||',0)),'||
'sum(nvl('||colname12||',0)),'||
'sum(nvl('||colname13||',0))'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
select period1,period2,period3,period4,period5,period6,period7,
period8,period9,period10,period11,period12,period13
into l_cost1_tl,l_cost2_tl,l_cost3_tl,l_cost4_tl,l_cost5_tl,l_cost6_tl,
l_cost7_tl,l_cost8_tl,l_cost9_tl,l_cost10_tl,l_cost11_tl,l_cost12_tl,l_cost13_tl
from pa_fp_sum_pv_v
where resource_assignment_id = l_ra_id_pl
and AMOUNT_TYPE_CODE = 'COST';
l_stmt := 'select sum(nvl('||colname1||',0)),'||
'sum(nvl('||colname2||',0)),'||
'sum(nvl('||colname3||',0)),'||
'sum(nvl('||colname4||',0)),'||
'sum(nvl('||colname5||',0)),'||
'sum(nvl('||colname6||',0)),'||
'sum(nvl('||colname7||',0)),'||
'sum(nvl('||colname8||',0)),'||
'sum(nvl('||colname9||',0)),'||
'sum(nvl('||colname10||',0)),'||
'sum(nvl('||colname11||',0)),'||
'sum(nvl('||colname12||',0)),'||
'sum(nvl('||colname13||',0))'||'
from pa_proj_periods_denorm
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
l_stmt := 'update pa_proj_periods_denorm
set '|| colname1|| '= :n1,'||
colname2|| '= :n2,'||
colname3|| '= :n3,'||
colname4|| '= :n4,'||
colname5|| '= :n5,'||
colname6|| '= :n6,'||
colname7|| '= :n7,'||
colname8|| '= :n8,'||
colname9|| '= :n9,'||
colname10|| '= :n10,'||
colname11|| '= :n11,'||
colname12|| '= :n12,'||
colname13|| '= :n13
where budget_version_id = :versionId
and resource_assignment_id = :resId
and object_id = :elementId
and object_type_code = :elementCode
and amount_type_code = :amountTypeCode
and amount_subtype_code = :amountSubtypeCode
and currency_type = :currencyType
and currency_code = :currencyCode';
/*End update denorm table*/
/****************************************************************************************/
/*End of update pa_proj_periods_denorm*/
/***************************************************************************************/
END pa_fp_update_tables;