eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_FP_VIEW_PLANS_UTIL

Line 842: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then

838: /*
839: -- **** if have TWO versions, may need to set x_primary_pp_bv_id ****
840: -- if p_orgfcst_version_id does not have a period_profile_id
841: if (x_time_phase_code <> 'N') and
842: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then
843: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then
844: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
845: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
846: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;

Line 843: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then

839: -- **** if have TWO versions, may need to set x_primary_pp_bv_id ****
840: -- if p_orgfcst_version_id does not have a period_profile_id
841: if (x_time_phase_code <> 'N') and
842: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then
843: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then
844: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
845: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
846: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
847: end if;

Line 845: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then

841: if (x_time_phase_code <> 'N') and
842: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then
843: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then
844: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
845: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
846: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
847: end if;
848: end if;
849: */

Line 2978: if (pa_fp_view_plans_util.check_compatible_pd_profiles

2974: into l_period_profile_id2
2975: from pa_budget_versions
2976: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2977: --hr_utility.trace('retrieved the period profile ids');
2978: if (pa_fp_view_plans_util.check_compatible_pd_profiles
2979: (p_period_profile_id1 => l_period_profile_id1,
2980: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
2981: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
2982: --hr_utility.trace('user_specified: period_profile matches');

Line 3232: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3228: select period_profile_id
3229: into l_period_profile_id2
3230: from pa_budget_versions
3231: where budget_version_id = l_compl_budget_version_id;
3232: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3233: (p_period_profile_id1 => l_period_profile_id1,
3234: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3235: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3236: --merge the COST and REVENUE versions

Line 3361: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3357: select period_profile_id
3358: into l_period_profile_id2
3359: from pa_budget_versions
3360: where budget_version_id = l_compl_budget_version_id;
3361: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3362: (p_period_profile_id1 => l_period_profile_id1,
3363: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3364: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3365: --merge the COST and REVENUE versions

Line 3493: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3489: select period_profile_id
3490: into l_period_profile_id2
3491: from pa_budget_versions
3492: where budget_version_id = l_compl_budget_version_id;
3493: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3494: (p_period_profile_id1 => l_period_profile_id1,
3495: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3496: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3497: --merge the COST and REVENUE versions

Line 3621: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3617: select period_profile_id
3618: into l_period_profile_id2
3619: from pa_budget_versions
3620: where budget_version_id = l_compl_budget_version_id;
3621: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3622: (p_period_profile_id1 => l_period_profile_id1,
3623: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3624: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3625: --merge the COST and REVENUE versions

Line 3782: pa_fp_view_plans_util.assign_element_name

3778: ra.budget_version_id,
3779: ra.resource_assignment_id,
3780: -1 as revenue_budget_version_id, -- revenue_budget_version_id
3781: -1 as revenue_res_assignment_id, -- revenue_resource_assignment_id
3782: pa_fp_view_plans_util.assign_element_name
3783: (ra.project_id,
3784: ra.task_id,
3785: ra.resource_list_member_id) as element_name, -- element_name
3786: pa_fp_view_plans_util.assign_element_level

Line 3786: pa_fp_view_plans_util.assign_element_level

3782: pa_fp_view_plans_util.assign_element_name
3783: (ra.project_id,
3784: ra.task_id,
3785: ra.resource_list_member_id) as element_name, -- element_name
3786: pa_fp_view_plans_util.assign_element_level
3787: (ra.project_id,
3788: ra.budget_version_id,
3789: ra.task_id,
3790: ra.resource_list_member_id) as element_level, -- element_level

Line 3808: pa_fp_view_plans_util.assign_row_level

3804: DECODE(ra.resource_assignment_type,
3805: 'ROLLED_UP', 'N',
3806: 'USER_ENTERED', 'Y',
3807: 'Y') as line_editable_flag, -- line_editable_flag
3808: pa_fp_view_plans_util.assign_row_level
3809: (ra.project_id,
3810: ra.task_id,
3811: ra.resource_list_member_id) as row_level,
3812: pa_fp_view_plans_util.assign_parent_element

Line 3812: pa_fp_view_plans_util.assign_parent_element

3808: pa_fp_view_plans_util.assign_row_level
3809: (ra.project_id,
3810: ra.task_id,
3811: ra.resource_list_member_id) as row_level,
3812: pa_fp_view_plans_util.assign_parent_element
3813: (ra.project_id,
3814: ra.task_id,
3815: ra.resource_list_member_id) as parent_element_name,
3816: ra.unit_of_measure

Line 3833: pa_fp_view_plans_util.assign_element_name

3829: -1 as cost_budget_version_id, -- cost_budget_version_id
3830: -1 as cost_res_assignment_id, -- cost_resource_assignment_id
3831: ra.budget_version_id,
3832: ra.resource_assignment_id,
3833: pa_fp_view_plans_util.assign_element_name
3834: (ra.project_id,
3835: ra.task_id,
3836: ra.resource_list_member_id) as element_name, -- element_name
3837: pa_fp_view_plans_util.assign_element_level

Line 3837: pa_fp_view_plans_util.assign_element_level

3833: pa_fp_view_plans_util.assign_element_name
3834: (ra.project_id,
3835: ra.task_id,
3836: ra.resource_list_member_id) as element_name, -- element_name
3837: pa_fp_view_plans_util.assign_element_level
3838: (ra.project_id,
3839: ra.budget_version_id,
3840: ra.task_id,
3841: ra.resource_list_member_id) as element_level, -- element_level

Line 3857: pa_fp_view_plans_util.assign_row_level

3853: DECODE(ra.resource_assignment_type,
3854: 'ROLLED_UP', 'N',
3855: 'USER_ENTERED', 'Y',
3856: 'Y'), -- line_editable_flag
3857: pa_fp_view_plans_util.assign_row_level
3858: (ra.project_id,
3859: ra.task_id,
3860: ra.resource_list_member_id) as row_level,
3861: pa_fp_view_plans_util.assign_parent_element

Line 3861: pa_fp_view_plans_util.assign_parent_element

3857: pa_fp_view_plans_util.assign_row_level
3858: (ra.project_id,
3859: ra.task_id,
3860: ra.resource_list_member_id) as row_level,
3861: pa_fp_view_plans_util.assign_parent_element
3862: (ra.project_id,
3863: ra.task_id,
3864: ra.resource_list_member_id) as parent_element_name,
3865: ra.unit_of_measure

Line 4082: pa_fp_view_plans_util.assign_element_name

4078: 0,
4079: l_c_cost_budget_version_id(1),
4080: -2,
4081: -2,
4082: pa_fp_view_plans_util.assign_element_name
4083: (l_c_project_id(1),
4084: 0,
4085: 0) ,
4086: pa_fp_view_plans_util.assign_element_level

Line 4086: pa_fp_view_plans_util.assign_element_level

4082: pa_fp_view_plans_util.assign_element_name
4083: (l_c_project_id(1),
4084: 0,
4085: 0) ,
4086: pa_fp_view_plans_util.assign_element_level
4087: (l_c_project_id(1),
4088: l_c_cost_budget_version_id(1),
4089: 0,
4090: 0),

Line 4098: pa_fp_view_plans_util.assign_row_level

4094: 0,
4095: 0, -- margin
4096: 0, -- margin_percent
4097: 'N', -- line_editable_flag
4098: pa_fp_view_plans_util.assign_row_level
4099: (l_c_project_id(1),
4100: 0,
4101: 0) ,
4102: pa_fp_view_plans_util.assign_parent_element

Line 4102: pa_fp_view_plans_util.assign_parent_element

4098: pa_fp_view_plans_util.assign_row_level
4099: (l_c_project_id(1),
4100: 0,
4101: 0) ,
4102: pa_fp_view_plans_util.assign_parent_element
4103: (l_c_project_id(1),
4104: 0,
4105: 0) ,
4106: l_c_unit_of_measure(1),

Line 4175: pa_fp_view_plans_util.assign_element_name

4171: 0,
4172: l_c_cost_budget_version_id(i),
4173: -2,
4174: -2,
4175: pa_fp_view_plans_util.assign_element_name
4176: (l_c_project_id(i),
4177: task_rec.task_id,
4178: 0) ,
4179: pa_fp_view_plans_util.assign_element_level

Line 4179: pa_fp_view_plans_util.assign_element_level

4175: pa_fp_view_plans_util.assign_element_name
4176: (l_c_project_id(i),
4177: task_rec.task_id,
4178: 0) ,
4179: pa_fp_view_plans_util.assign_element_level
4180: (l_c_project_id(i),
4181: l_c_cost_budget_version_id(i),
4182: task_rec.task_id,
4183: 0),

Line 4191: pa_fp_view_plans_util.assign_row_level

4187: 0,
4188: 0, -- margin
4189: 0, -- margin_percent
4190: 'N', -- line_editable_flag
4191: pa_fp_view_plans_util.assign_row_level
4192: (l_c_project_id(i),
4193: task_rec.task_id,
4194: 0) ,
4195: pa_fp_view_plans_util.assign_parent_element

Line 4195: pa_fp_view_plans_util.assign_parent_element

4191: pa_fp_view_plans_util.assign_row_level
4192: (l_c_project_id(i),
4193: task_rec.task_id,
4194: 0) ,
4195: pa_fp_view_plans_util.assign_parent_element
4196: (l_c_project_id(i),
4197: task_rec.task_id,
4198: 0) ,
4199: l_c_unit_of_measure(i),

Line 4250: pa_fp_view_plans_util.assign_element_name

4246: l_r_cost_budget_version_id(1),
4247: -2,
4248: -2,
4249: l_r_revenue_budget_version_id(1),
4250: pa_fp_view_plans_util.assign_element_name
4251: (l_r_project_id(1),
4252: 0,
4253: 0) ,
4254: pa_fp_view_plans_util.assign_element_level

Line 4254: pa_fp_view_plans_util.assign_element_level

4250: pa_fp_view_plans_util.assign_element_name
4251: (l_r_project_id(1),
4252: 0,
4253: 0) ,
4254: pa_fp_view_plans_util.assign_element_level
4255: (l_r_project_id(1),
4256: l_r_cost_budget_version_id(1),
4257: 0,
4258: 0),

Line 4266: pa_fp_view_plans_util.assign_row_level

4262: 0,
4263: 0, -- margin
4264: 0, -- margin_percent
4265: 'N', -- line_editable_flag
4266: pa_fp_view_plans_util.assign_row_level
4267: (l_r_project_id(1),
4268: 0,
4269: 0) ,
4270: pa_fp_view_plans_util.assign_parent_element

Line 4270: pa_fp_view_plans_util.assign_parent_element

4266: pa_fp_view_plans_util.assign_row_level
4267: (l_r_project_id(1),
4268: 0,
4269: 0) ,
4270: pa_fp_view_plans_util.assign_parent_element
4271: (l_r_project_id(1),
4272: 0,
4273: 0) ,
4274: l_r_unit_of_measure(1),

Line 4345: pa_fp_view_plans_util.assign_element_name

4341: l_r_cost_budget_version_id(i),
4342: -2,
4343: -2,
4344: l_r_revenue_budget_version_id(i),
4345: pa_fp_view_plans_util.assign_element_name
4346: (l_r_project_id(i),
4347: task_rec.task_id,
4348: 0) ,
4349: pa_fp_view_plans_util.assign_element_level

Line 4349: pa_fp_view_plans_util.assign_element_level

4345: pa_fp_view_plans_util.assign_element_name
4346: (l_r_project_id(i),
4347: task_rec.task_id,
4348: 0) ,
4349: pa_fp_view_plans_util.assign_element_level
4350: (l_r_project_id(i),
4351: l_r_cost_budget_version_id(i),
4352: task_rec.task_id,
4353: 0),

Line 4361: pa_fp_view_plans_util.assign_row_level

4357: 0,
4358: 0, -- margin
4359: 0, -- margin_percent
4360: 'N', -- line_editable_flag
4361: pa_fp_view_plans_util.assign_row_level
4362: (l_r_project_id(i),
4363: task_rec.task_id,
4364: 0) ,
4365: pa_fp_view_plans_util.assign_parent_element

Line 4365: pa_fp_view_plans_util.assign_parent_element

4361: pa_fp_view_plans_util.assign_row_level
4362: (l_r_project_id(i),
4363: task_rec.task_id,
4364: 0) ,
4365: pa_fp_view_plans_util.assign_parent_element
4366: (l_r_project_id(i),
4367: task_rec.task_id,
4368: 0) ,
4369: l_r_unit_of_measure(i),

Line 4497: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4493: l_pd_has_child_element(l_row_number) := 'N';
4494: else
4495: l_pd_has_child_element(l_row_number) := 'Y';
4496: end if;
4497: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4498: (p_period_profile_id => l_period_profile_id,
4499: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4500: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4501: p_project_currency_type => l_currency_type,

Line 4506: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4502: p_amount_type_id => 215,
4503: p_period_number => 1);
4504: --hr_utility.trace('VALUE is = ' || to_char(l_pd_period_1(l_row_number)));
4505: --hr_utility.trace('get_period_n_value for period 2');
4506: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4507: (p_period_profile_id => l_period_profile_id,
4508: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4509: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4510: p_project_currency_type => l_currency_type,

Line 4513: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4509: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4510: p_project_currency_type => l_currency_type,
4511: p_amount_type_id => 215,
4512: p_period_number => 2);
4513: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4514: (p_period_profile_id => l_period_profile_id,
4515: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4516: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4517: p_project_currency_type => l_currency_type,

Line 4520: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4516: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4517: p_project_currency_type => l_currency_type,
4518: p_amount_type_id => 215,
4519: p_period_number => 3);
4520: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4521: (p_period_profile_id => l_period_profile_id,
4522: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4523: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4524: p_project_currency_type => l_currency_type,

Line 4527: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4523: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4524: p_project_currency_type => l_currency_type,
4525: p_amount_type_id => 215,
4526: p_period_number => 4);
4527: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4528: (p_period_profile_id => l_period_profile_id,
4529: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4530: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4531: p_project_currency_type => l_currency_type,

Line 4534: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4530: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4531: p_project_currency_type => l_currency_type,
4532: p_amount_type_id => 215,
4533: p_period_number => 5);
4534: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4535: (p_period_profile_id => l_period_profile_id,
4536: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4537: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4538: p_project_currency_type => l_currency_type,

Line 4541: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4537: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4538: p_project_currency_type => l_currency_type,
4539: p_amount_type_id => 215,
4540: p_period_number => 6);
4541: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4542: (p_period_profile_id => l_period_profile_id,
4543: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4544: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4545: p_project_currency_type => l_currency_type,

Line 4548: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4544: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4545: p_project_currency_type => l_currency_type,
4546: p_amount_type_id => 215,
4547: p_period_number => 7);
4548: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4549: (p_period_profile_id => l_period_profile_id,
4550: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4551: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4552: p_project_currency_type => l_currency_type,

Line 4555: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4551: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4552: p_project_currency_type => l_currency_type,
4553: p_amount_type_id => 215,
4554: p_period_number => 8);
4555: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4556: (p_period_profile_id => l_period_profile_id,
4557: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4558: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4559: p_project_currency_type => l_currency_type,

Line 4562: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4558: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4559: p_project_currency_type => l_currency_type,
4560: p_amount_type_id => 215,
4561: p_period_number => 9);
4562: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4563: (p_period_profile_id => l_period_profile_id,
4564: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4565: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4566: p_project_currency_type => l_currency_type,

Line 4569: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4565: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4566: p_project_currency_type => l_currency_type,
4567: p_amount_type_id => 215,
4568: p_period_number => 10);
4569: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4570: (p_period_profile_id => l_period_profile_id,
4571: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4572: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4573: p_project_currency_type => l_currency_type,

Line 4576: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4572: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4573: p_project_currency_type => l_currency_type,
4574: p_amount_type_id => 215,
4575: p_period_number => 11);
4576: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4577: (p_period_profile_id => l_period_profile_id,
4578: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4579: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4580: p_project_currency_type => l_currency_type,

Line 4583: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4579: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4580: p_project_currency_type => l_currency_type,
4581: p_amount_type_id => 215,
4582: p_period_number => 12);
4583: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4584: (p_period_profile_id => l_period_profile_id,
4585: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4586: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4587: p_project_currency_type => l_currency_type,

Line 4590: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4586: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4587: p_project_currency_type => l_currency_type,
4588: p_amount_type_id => 215,
4589: p_period_number => 13);
4590: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4591: (p_period_profile_id => l_period_profile_id,
4592: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4593: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4594: p_project_currency_type => l_currency_type,

Line 4597: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4593: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4594: p_project_currency_type => l_currency_type,
4595: p_amount_type_id => 215,
4596: p_period_number => 0);
4597: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4598: (p_period_profile_id => l_period_profile_id,
4599: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4600: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4601: p_project_currency_type => l_currency_type,

Line 4647: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4643: l_pd_has_child_element(l_row_number) := 'N';
4644: else
4645: l_pd_has_child_element(l_row_number) := 'Y';
4646: end if;
4647: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4648: (p_period_profile_id => l_period_profile_id,
4649: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4650: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4651: p_project_currency_type => l_currency_type,

Line 4656: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4652: --p_amount_type_id => 150,
4653: p_amount_type_id => 165,
4654: p_period_number => 1);
4655: --hr_utility.trace('VALUE is = ' || to_char(l_pd_period_1(l_row_number)));
4656: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4657: (p_period_profile_id => l_period_profile_id,
4658: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4659: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4660: p_project_currency_type => l_currency_type,

Line 4664: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4660: p_project_currency_type => l_currency_type,
4661: --p_amount_type_id => 150,
4662: p_amount_type_id => 165,
4663: p_period_number => 2);
4664: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4665: (p_period_profile_id => l_period_profile_id,
4666: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4667: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4668: p_project_currency_type => l_currency_type,

Line 4672: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4668: p_project_currency_type => l_currency_type,
4669: --p_amount_type_id => 150,
4670: p_amount_type_id => 165,
4671: p_period_number => 3);
4672: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4673: (p_period_profile_id => l_period_profile_id,
4674: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4675: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4676: p_project_currency_type => l_currency_type,

Line 4680: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4676: p_project_currency_type => l_currency_type,
4677: --p_amount_type_id => 150,
4678: p_amount_type_id => 165,
4679: p_period_number => 4);
4680: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4681: (p_period_profile_id => l_period_profile_id,
4682: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4683: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4684: p_project_currency_type => l_currency_type,

Line 4688: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4684: p_project_currency_type => l_currency_type,
4685: --p_amount_type_id => 150,
4686: p_amount_type_id => 165,
4687: p_period_number => 5);
4688: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4689: (p_period_profile_id => l_period_profile_id,
4690: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4691: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4692: p_project_currency_type => l_currency_type,

Line 4696: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4692: p_project_currency_type => l_currency_type,
4693: --p_amount_type_id => 150,
4694: p_amount_type_id => 165,
4695: p_period_number => 6);
4696: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4697: (p_period_profile_id => l_period_profile_id,
4698: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4699: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4700: p_project_currency_type => l_currency_type,

Line 4704: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4700: p_project_currency_type => l_currency_type,
4701: --p_amount_type_id => 150,
4702: p_amount_type_id => 165,
4703: p_period_number => 7);
4704: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4705: (p_period_profile_id => l_period_profile_id,
4706: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4707: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4708: p_project_currency_type => l_currency_type,

Line 4712: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4708: p_project_currency_type => l_currency_type,
4709: --p_amount_type_id => 150,
4710: p_amount_type_id => 165,
4711: p_period_number => 8);
4712: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4713: (p_period_profile_id => l_period_profile_id,
4714: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4715: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4716: p_project_currency_type => l_currency_type,

Line 4720: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4716: p_project_currency_type => l_currency_type,
4717: --p_amount_type_id => 150,
4718: p_amount_type_id => 165,
4719: p_period_number => 9);
4720: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4721: (p_period_profile_id => l_period_profile_id,
4722: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4723: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4724: p_project_currency_type => l_currency_type,

Line 4728: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4724: p_project_currency_type => l_currency_type,
4725: --p_amount_type_id => 150,
4726: p_amount_type_id => 165,
4727: p_period_number => 10);
4728: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4729: (p_period_profile_id => l_period_profile_id,
4730: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4731: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4732: p_project_currency_type => l_currency_type,

Line 4736: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4732: p_project_currency_type => l_currency_type,
4733: --p_amount_type_id => 150,
4734: p_amount_type_id => 165,
4735: p_period_number => 11);
4736: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4737: (p_period_profile_id => l_period_profile_id,
4738: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4739: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4740: p_project_currency_type => l_currency_type,

Line 4744: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4740: p_project_currency_type => l_currency_type,
4741: --p_amount_type_id => 150,
4742: p_amount_type_id => 165,
4743: p_period_number => 12);
4744: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4745: (p_period_profile_id => l_period_profile_id,
4746: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4747: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4748: p_project_currency_type => l_currency_type,

Line 4752: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4748: p_project_currency_type => l_currency_type,
4749: --p_amount_type_id => 150,
4750: p_amount_type_id => 165,
4751: p_period_number => 13);
4752: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4753: (p_period_profile_id => l_period_profile_id,
4754: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4755: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4756: p_project_currency_type => l_currency_type,

Line 4760: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4756: p_project_currency_type => l_currency_type,
4757: --p_amount_type_id => 150,
4758: p_amount_type_id => 165,
4759: p_period_number => 0);
4760: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4761: (p_period_profile_id => l_period_profile_id,
4762: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4763: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4764: p_project_currency_type => l_currency_type,

Line 4810: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4806: l_pd_has_child_element(l_row_number) := 'N';
4807: else
4808: l_pd_has_child_element(l_row_number) := 'Y';
4809: end if;
4810: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4811: (p_period_profile_id => l_period_profile_id,
4812: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4813: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4814: p_project_currency_type => l_currency_type,

Line 4818: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4814: p_project_currency_type => l_currency_type,
4815: --p_amount_type_id => 150,
4816: p_amount_type_id => 160,
4817: p_period_number => 1);
4818: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4819: (p_period_profile_id => l_period_profile_id,
4820: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4821: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4822: p_project_currency_type => l_currency_type,

Line 4826: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4822: p_project_currency_type => l_currency_type,
4823: --p_amount_type_id => 150,
4824: p_amount_type_id => 160,
4825: p_period_number => 2);
4826: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4827: (p_period_profile_id => l_period_profile_id,
4828: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4829: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4830: p_project_currency_type => l_currency_type,

Line 4834: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4830: p_project_currency_type => l_currency_type,
4831: --p_amount_type_id => 150,
4832: p_amount_type_id => 160,
4833: p_period_number => 3);
4834: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4835: (p_period_profile_id => l_period_profile_id,
4836: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4837: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4838: p_project_currency_type => l_currency_type,

Line 4842: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4838: p_project_currency_type => l_currency_type,
4839: --p_amount_type_id => 150,
4840: p_amount_type_id => 160,
4841: p_period_number => 4);
4842: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4843: (p_period_profile_id => l_period_profile_id,
4844: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4845: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4846: p_project_currency_type => l_currency_type,

Line 4850: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4846: p_project_currency_type => l_currency_type,
4847: --p_amount_type_id => 150,
4848: p_amount_type_id => 160,
4849: p_period_number => 5);
4850: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4851: (p_period_profile_id => l_period_profile_id,
4852: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4853: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4854: p_project_currency_type => l_currency_type,

Line 4858: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4854: p_project_currency_type => l_currency_type,
4855: --p_amount_type_id => 150,
4856: p_amount_type_id => 160,
4857: p_period_number => 6);
4858: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4859: (p_period_profile_id => l_period_profile_id,
4860: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4861: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4862: p_project_currency_type => l_currency_type,

Line 4866: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4862: p_project_currency_type => l_currency_type,
4863: --p_amount_type_id => 150,
4864: p_amount_type_id => 160,
4865: p_period_number => 7);
4866: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4867: (p_period_profile_id => l_period_profile_id,
4868: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4869: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4870: p_project_currency_type => l_currency_type,

Line 4874: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4870: p_project_currency_type => l_currency_type,
4871: --p_amount_type_id => 150,
4872: p_amount_type_id => 160,
4873: p_period_number => 8);
4874: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4875: (p_period_profile_id => l_period_profile_id,
4876: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4877: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4878: p_project_currency_type => l_currency_type,

Line 4882: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4878: p_project_currency_type => l_currency_type,
4879: --p_amount_type_id => 150,
4880: p_amount_type_id => 160,
4881: p_period_number => 9);
4882: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4883: (p_period_profile_id => l_period_profile_id,
4884: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4885: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4886: p_project_currency_type => l_currency_type,

Line 4890: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4886: p_project_currency_type => l_currency_type,
4887: --p_amount_type_id => 150,
4888: p_amount_type_id => 160,
4889: p_period_number => 10);
4890: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4891: (p_period_profile_id => l_period_profile_id,
4892: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4893: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4894: p_project_currency_type => l_currency_type,

Line 4898: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4894: p_project_currency_type => l_currency_type,
4895: --p_amount_type_id => 150,
4896: p_amount_type_id => 160,
4897: p_period_number => 11);
4898: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4899: (p_period_profile_id => l_period_profile_id,
4900: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4901: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4902: p_project_currency_type => l_currency_type,

Line 4906: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4902: p_project_currency_type => l_currency_type,
4903: --p_amount_type_id => 150,
4904: p_amount_type_id => 160,
4905: p_period_number => 12);
4906: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4907: (p_period_profile_id => l_period_profile_id,
4908: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4909: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4910: p_project_currency_type => l_currency_type,

Line 4914: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4910: p_project_currency_type => l_currency_type,
4911: --p_amount_type_id => 150,
4912: p_amount_type_id => 160,
4913: p_period_number => 13);
4914: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4915: (p_period_profile_id => l_period_profile_id,
4916: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4917: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4918: p_project_currency_type => l_currency_type,

Line 4922: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4918: p_project_currency_type => l_currency_type,
4919: --p_amount_type_id => 150,
4920: p_amount_type_id => 160,
4921: p_period_number => 0);
4922: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4923: (p_period_profile_id => l_period_profile_id,
4924: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4925: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4926: p_project_currency_type => l_currency_type,

Line 4966: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4962: l_pd_has_child_element(l_row_number) := 'N';
4963: else
4964: l_pd_has_child_element(l_row_number) := 'Y';
4965: end if;
4966: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4967: (p_period_profile_id => l_period_profile_id,
4968: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4969: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4970: p_project_currency_type => l_currency_type,

Line 4973: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4969: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4970: p_project_currency_type => l_currency_type,
4971: p_amount_type_id => 215,
4972: p_period_number => 1);
4973: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4974: (p_period_profile_id => l_period_profile_id,
4975: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4976: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4977: p_project_currency_type => l_currency_type,

Line 4980: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4976: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4977: p_project_currency_type => l_currency_type,
4978: p_amount_type_id => 215,
4979: p_period_number => 1);
4980: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4981: (p_period_profile_id => l_period_profile_id,
4982: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4983: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4984: p_project_currency_type => l_currency_type,

Line 4987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4983: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4984: p_project_currency_type => l_currency_type,
4985: p_amount_type_id => 215,
4986: p_period_number => 2);
4987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4988: (p_period_profile_id => l_period_profile_id,
4989: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4990: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4991: p_project_currency_type => l_currency_type,

Line 4994: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4990: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4991: p_project_currency_type => l_currency_type,
4992: p_amount_type_id => 215,
4993: p_period_number => 3);
4994: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4995: (p_period_profile_id => l_period_profile_id,
4996: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4997: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4998: p_project_currency_type => l_currency_type,

Line 5001: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

4997: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4998: p_project_currency_type => l_currency_type,
4999: p_amount_type_id => 215,
5000: p_period_number => 4);
5001: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5002: (p_period_profile_id => l_period_profile_id,
5003: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5004: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5005: p_project_currency_type => l_currency_type,

Line 5008: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5004: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5005: p_project_currency_type => l_currency_type,
5006: p_amount_type_id => 215,
5007: p_period_number => 5);
5008: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5009: (p_period_profile_id => l_period_profile_id,
5010: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5011: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5012: p_project_currency_type => l_currency_type,

Line 5015: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5011: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5012: p_project_currency_type => l_currency_type,
5013: p_amount_type_id => 215,
5014: p_period_number => 6);
5015: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5016: (p_period_profile_id => l_period_profile_id,
5017: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5018: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5019: p_project_currency_type => l_currency_type,

Line 5022: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5018: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5019: p_project_currency_type => l_currency_type,
5020: p_amount_type_id => 215,
5021: p_period_number => 7);
5022: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5023: (p_period_profile_id => l_period_profile_id,
5024: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5025: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5026: p_project_currency_type => l_currency_type,

Line 5029: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5025: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5026: p_project_currency_type => l_currency_type,
5027: p_amount_type_id => 215,
5028: p_period_number => 8);
5029: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5030: (p_period_profile_id => l_period_profile_id,
5031: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5032: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5033: p_project_currency_type => l_currency_type,

Line 5036: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5032: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5033: p_project_currency_type => l_currency_type,
5034: p_amount_type_id => 215,
5035: p_period_number => 9);
5036: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5037: (p_period_profile_id => l_period_profile_id,
5038: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5039: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5040: p_project_currency_type => l_currency_type,

Line 5043: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5039: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5040: p_project_currency_type => l_currency_type,
5041: p_amount_type_id => 215,
5042: p_period_number => 10);
5043: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5044: (p_period_profile_id => l_period_profile_id,
5045: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5046: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5047: p_project_currency_type => l_currency_type,

Line 5050: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5046: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5047: p_project_currency_type => l_currency_type,
5048: p_amount_type_id => 215,
5049: p_period_number => 11);
5050: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5051: (p_period_profile_id => l_period_profile_id,
5052: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5053: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5054: p_project_currency_type => l_currency_type,

Line 5057: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5053: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5054: p_project_currency_type => l_currency_type,
5055: p_amount_type_id => 215,
5056: p_period_number => 12);
5057: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5058: (p_period_profile_id => l_period_profile_id,
5059: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5060: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5061: p_project_currency_type => l_currency_type,

Line 5064: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5060: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5061: p_project_currency_type => l_currency_type,
5062: p_amount_type_id => 215,
5063: p_period_number => 13);
5064: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5065: (p_period_profile_id => l_period_profile_id,
5066: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5067: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5068: p_project_currency_type => l_currency_type,

Line 5071: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5067: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5068: p_project_currency_type => l_currency_type,
5069: p_amount_type_id => 215,
5070: p_period_number => 0);
5071: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5072: (p_period_profile_id => l_period_profile_id,
5073: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5074: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5075: p_project_currency_type => l_currency_type,

Line 5113: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5109: l_pd_has_child_element(l_row_number) := 'N';
5110: else
5111: l_pd_has_child_element(l_row_number) := 'Y';
5112: end if;
5113: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5114: (p_period_profile_id => l_period_profile_id,
5115: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5116: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5117: p_project_currency_type => l_currency_type,

Line 5120: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5116: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5117: p_project_currency_type => l_currency_type,
5118: p_amount_type_id => 100,
5119: p_period_number => 1);
5120: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5121: (p_period_profile_id => l_period_profile_id,
5122: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5123: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5124: p_project_currency_type => l_currency_type,

Line 5127: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5123: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5124: p_project_currency_type => l_currency_type,
5125: p_amount_type_id => 100,
5126: p_period_number => 2);
5127: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5128: (p_period_profile_id => l_period_profile_id,
5129: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5130: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5131: p_project_currency_type => l_currency_type,

Line 5134: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5130: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5131: p_project_currency_type => l_currency_type,
5132: p_amount_type_id => 100,
5133: p_period_number => 3);
5134: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5135: (p_period_profile_id => l_period_profile_id,
5136: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5137: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5138: p_project_currency_type => l_currency_type,

Line 5141: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5137: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5138: p_project_currency_type => l_currency_type,
5139: p_amount_type_id => 100,
5140: p_period_number => 4);
5141: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5142: (p_period_profile_id => l_period_profile_id,
5143: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5144: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5145: p_project_currency_type => l_currency_type,

Line 5148: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5144: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5145: p_project_currency_type => l_currency_type,
5146: p_amount_type_id => 100,
5147: p_period_number => 5);
5148: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5149: (p_period_profile_id => l_period_profile_id,
5150: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5151: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5152: p_project_currency_type => l_currency_type,

Line 5155: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5151: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5152: p_project_currency_type => l_currency_type,
5153: p_amount_type_id => 100,
5154: p_period_number => 6);
5155: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5156: (p_period_profile_id => l_period_profile_id,
5157: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5158: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5159: p_project_currency_type => l_currency_type,

Line 5162: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5158: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5159: p_project_currency_type => l_currency_type,
5160: p_amount_type_id => 100,
5161: p_period_number => 7);
5162: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5163: (p_period_profile_id => l_period_profile_id,
5164: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5165: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5166: p_project_currency_type => l_currency_type,

Line 5169: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5165: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5166: p_project_currency_type => l_currency_type,
5167: p_amount_type_id => 100,
5168: p_period_number => 8);
5169: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5170: (p_period_profile_id => l_period_profile_id,
5171: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5172: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5173: p_project_currency_type => l_currency_type,

Line 5176: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5172: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5173: p_project_currency_type => l_currency_type,
5174: p_amount_type_id => 100,
5175: p_period_number => 9);
5176: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5177: (p_period_profile_id => l_period_profile_id,
5178: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5179: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5180: p_project_currency_type => l_currency_type,

Line 5183: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5179: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5180: p_project_currency_type => l_currency_type,
5181: p_amount_type_id => 100,
5182: p_period_number => 10);
5183: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5184: (p_period_profile_id => l_period_profile_id,
5185: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5186: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5187: p_project_currency_type => l_currency_type,

Line 5190: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5186: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5187: p_project_currency_type => l_currency_type,
5188: p_amount_type_id => 100,
5189: p_period_number => 11);
5190: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5191: (p_period_profile_id => l_period_profile_id,
5192: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5193: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5194: p_project_currency_type => l_currency_type,

Line 5197: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5193: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5194: p_project_currency_type => l_currency_type,
5195: p_amount_type_id => 100,
5196: p_period_number => 12);
5197: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5198: (p_period_profile_id => l_period_profile_id,
5199: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5200: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5201: p_project_currency_type => l_currency_type,

Line 5204: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5200: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5201: p_project_currency_type => l_currency_type,
5202: p_amount_type_id => 100,
5203: p_period_number => 13);
5204: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5205: (p_period_profile_id => l_period_profile_id,
5206: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5207: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5208: p_project_currency_type => l_currency_type,

Line 5211: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5207: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5208: p_project_currency_type => l_currency_type,
5209: p_amount_type_id => 100,
5210: p_period_number => 0);
5211: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5212: (p_period_profile_id => l_period_profile_id,
5213: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5214: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5215: p_project_currency_type => l_currency_type,

Line 5302: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));

5298: l_pd_has_child_element(l_row_number) := 'N';
5299: else
5300: l_pd_has_child_element(l_row_number) := 'Y';
5301: end if;
5302: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));

Line 5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));

5299: else
5300: l_pd_has_child_element(l_row_number) := 'Y';
5301: end if;
5302: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));

Line 5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));

5300: l_pd_has_child_element(l_row_number) := 'Y';
5301: end if;
5302: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));

Line 5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));

5301: end if;
5302: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));

Line 5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));

5302: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));

Line 5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));

5303: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));

Line 5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));

5304: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));

Line 5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));

5305: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));

Line 5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));

5306: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));

Line 5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));

5307: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));

Line 5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));

5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));

Line 5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));

5309: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
5317: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651

Line 5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));

5310: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
5317: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
5318: end if; -- display_flag: MARGIN PERCENT

Line 5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));

5311: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
5317: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
5318: end if; -- display_flag: MARGIN PERCENT
5319: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'

Line 5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));

5312: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
5317: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
5318: end if; -- display_flag: MARGIN PERCENT
5319: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
5320: /*

Line 5317: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651

5313: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
5314: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
5315: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
5316: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
5317: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
5318: end if; -- display_flag: MARGIN PERCENT
5319: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
5320: /*
5321: l_r_project_id.delete(j);

Line 5439: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5435: l_pd_has_child_element(l_row_number) := 'N';
5436: else
5437: l_pd_has_child_element(l_row_number) := 'Y';
5438: end if;
5439: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5440: (p_period_profile_id => l_period_profile_id,
5441: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5442: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5443: p_project_currency_type => l_currency_type,

Line 5446: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5442: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5443: p_project_currency_type => l_currency_type,
5444: p_amount_type_id => 215,
5445: p_period_number => 1);
5446: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5447: (p_period_profile_id => l_period_profile_id,
5448: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5449: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5450: p_project_currency_type => l_currency_type,

Line 5453: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5449: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5450: p_project_currency_type => l_currency_type,
5451: p_amount_type_id => 215,
5452: p_period_number => 2);
5453: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5454: (p_period_profile_id => l_period_profile_id,
5455: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5456: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5457: p_project_currency_type => l_currency_type,

Line 5460: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5456: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5457: p_project_currency_type => l_currency_type,
5458: p_amount_type_id => 215,
5459: p_period_number => 3);
5460: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5461: (p_period_profile_id => l_period_profile_id,
5462: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5463: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5464: p_project_currency_type => l_currency_type,

Line 5467: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5463: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5464: p_project_currency_type => l_currency_type,
5465: p_amount_type_id => 215,
5466: p_period_number => 4);
5467: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5468: (p_period_profile_id => l_period_profile_id,
5469: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5470: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5471: p_project_currency_type => l_currency_type,

Line 5474: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5470: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5471: p_project_currency_type => l_currency_type,
5472: p_amount_type_id => 215,
5473: p_period_number => 5);
5474: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5475: (p_period_profile_id => l_period_profile_id,
5476: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5477: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5478: p_project_currency_type => l_currency_type,

Line 5481: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5477: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5478: p_project_currency_type => l_currency_type,
5479: p_amount_type_id => 215,
5480: p_period_number => 6);
5481: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5482: (p_period_profile_id => l_period_profile_id,
5483: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5484: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5485: p_project_currency_type => l_currency_type,

Line 5488: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5484: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5485: p_project_currency_type => l_currency_type,
5486: p_amount_type_id => 215,
5487: p_period_number => 7);
5488: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5489: (p_period_profile_id => l_period_profile_id,
5490: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5491: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5492: p_project_currency_type => l_currency_type,

Line 5495: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5491: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5492: p_project_currency_type => l_currency_type,
5493: p_amount_type_id => 215,
5494: p_period_number => 8);
5495: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5496: (p_period_profile_id => l_period_profile_id,
5497: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5498: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5499: p_project_currency_type => l_currency_type,

Line 5502: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5498: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5499: p_project_currency_type => l_currency_type,
5500: p_amount_type_id => 215,
5501: p_period_number => 9);
5502: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5503: (p_period_profile_id => l_period_profile_id,
5504: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5505: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5506: p_project_currency_type => l_currency_type,

Line 5509: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5505: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5506: p_project_currency_type => l_currency_type,
5507: p_amount_type_id => 215,
5508: p_period_number => 10);
5509: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5510: (p_period_profile_id => l_period_profile_id,
5511: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5512: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5513: p_project_currency_type => l_currency_type,

Line 5516: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5512: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5513: p_project_currency_type => l_currency_type,
5514: p_amount_type_id => 215,
5515: p_period_number => 11);
5516: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5517: (p_period_profile_id => l_period_profile_id,
5518: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5519: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5520: p_project_currency_type => l_currency_type,

Line 5523: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5519: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5520: p_project_currency_type => l_currency_type,
5521: p_amount_type_id => 215,
5522: p_period_number => 12);
5523: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5524: (p_period_profile_id => l_period_profile_id,
5525: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5526: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5527: p_project_currency_type => l_currency_type,

Line 5530: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5526: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5527: p_project_currency_type => l_currency_type,
5528: p_amount_type_id => 215,
5529: p_period_number => 13);
5530: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5531: (p_period_profile_id => l_period_profile_id,
5532: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5533: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5534: p_project_currency_type => l_currency_type,

Line 5537: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5533: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5534: p_project_currency_type => l_currency_type,
5535: p_amount_type_id => 215,
5536: p_period_number => 0);
5537: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5538: (p_period_profile_id => l_period_profile_id,
5539: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5540: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5541: p_project_currency_type => l_currency_type,

Line 5623: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5619: l_pd_has_child_element(l_row_number) := 'N';
5620: else
5621: l_pd_has_child_element(l_row_number) := 'Y';
5622: end if;
5623: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5624: (p_period_profile_id => l_period_profile_id,
5625: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5626: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5627: p_project_currency_type => l_currency_type,

Line 5630: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5626: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5627: p_project_currency_type => l_currency_type,
5628: p_amount_type_id => 165,
5629: p_period_number => 1);
5630: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5631: (p_period_profile_id => l_period_profile_id,
5632: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5633: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5634: p_project_currency_type => l_currency_type,

Line 5637: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5633: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5634: p_project_currency_type => l_currency_type,
5635: p_amount_type_id => 165,
5636: p_period_number => 2);
5637: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5638: (p_period_profile_id => l_period_profile_id,
5639: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5640: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5641: p_project_currency_type => l_currency_type,

Line 5644: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5640: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5641: p_project_currency_type => l_currency_type,
5642: p_amount_type_id => 165,
5643: p_period_number => 3);
5644: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5645: (p_period_profile_id => l_period_profile_id,
5646: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5647: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5648: p_project_currency_type => l_currency_type,

Line 5651: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5647: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5648: p_project_currency_type => l_currency_type,
5649: p_amount_type_id => 165,
5650: p_period_number => 4);
5651: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5652: (p_period_profile_id => l_period_profile_id,
5653: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5654: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5655: p_project_currency_type => l_currency_type,

Line 5659: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5655: p_project_currency_type => l_currency_type,
5656: --p_amount_type_id => 150,
5657: p_amount_type_id => 165,
5658: p_period_number => 5);
5659: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5660: (p_period_profile_id => l_period_profile_id,
5661: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5662: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5663: p_project_currency_type => l_currency_type,

Line 5666: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5662: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5663: p_project_currency_type => l_currency_type,
5664: p_amount_type_id => 165,
5665: p_period_number => 6);
5666: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5667: (p_period_profile_id => l_period_profile_id,
5668: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5669: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5670: p_project_currency_type => l_currency_type,

Line 5673: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5669: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5670: p_project_currency_type => l_currency_type,
5671: p_amount_type_id => 165,
5672: p_period_number => 7);
5673: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5674: (p_period_profile_id => l_period_profile_id,
5675: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5676: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5677: p_project_currency_type => l_currency_type,

Line 5680: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5676: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5677: p_project_currency_type => l_currency_type,
5678: p_amount_type_id => 165,
5679: p_period_number => 8);
5680: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5681: (p_period_profile_id => l_period_profile_id,
5682: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5683: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5684: p_project_currency_type => l_currency_type,

Line 5687: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5683: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5684: p_project_currency_type => l_currency_type,
5685: p_amount_type_id => 165,
5686: p_period_number => 9);
5687: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5688: (p_period_profile_id => l_period_profile_id,
5689: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5690: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5691: p_project_currency_type => l_currency_type,

Line 5694: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5690: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5691: p_project_currency_type => l_currency_type,
5692: p_amount_type_id => 165,
5693: p_period_number => 10);
5694: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5695: (p_period_profile_id => l_period_profile_id,
5696: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5697: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5698: p_project_currency_type => l_currency_type,

Line 5701: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5697: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5698: p_project_currency_type => l_currency_type,
5699: p_amount_type_id => 165,
5700: p_period_number => 11);
5701: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5702: (p_period_profile_id => l_period_profile_id,
5703: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5704: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5705: p_project_currency_type => l_currency_type,

Line 5708: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5704: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5705: p_project_currency_type => l_currency_type,
5706: p_amount_type_id => 165,
5707: p_period_number => 12);
5708: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5709: (p_period_profile_id => l_period_profile_id,
5710: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5711: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5712: p_project_currency_type => l_currency_type,

Line 5715: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5711: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5712: p_project_currency_type => l_currency_type,
5713: p_amount_type_id => 165,
5714: p_period_number => 13);
5715: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5716: (p_period_profile_id => l_period_profile_id,
5717: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5718: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5719: p_project_currency_type => l_currency_type,

Line 5722: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5718: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5719: p_project_currency_type => l_currency_type,
5720: p_amount_type_id => 165,
5721: p_period_number => 0);
5722: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5723: (p_period_profile_id => l_period_profile_id,
5724: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5725: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5726: p_project_currency_type => l_currency_type,

Line 5761: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5757: l_pd_has_child_element(l_row_number) := 'N';
5758: else
5759: l_pd_has_child_element(l_row_number) := 'Y';
5760: end if;
5761: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5762: (p_period_profile_id => l_period_profile_id,
5763: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5764: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5765: p_project_currency_type => l_currency_type,

Line 5768: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5764: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5765: p_project_currency_type => l_currency_type,
5766: p_amount_type_id => 160,
5767: p_period_number => 1);
5768: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5769: (p_period_profile_id => l_period_profile_id,
5770: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5771: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5772: p_project_currency_type => l_currency_type,

Line 5775: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5771: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5772: p_project_currency_type => l_currency_type,
5773: p_amount_type_id => 160,
5774: p_period_number => 2);
5775: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5776: (p_period_profile_id => l_period_profile_id,
5777: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5778: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5779: p_project_currency_type => l_currency_type,

Line 5782: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5778: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5779: p_project_currency_type => l_currency_type,
5780: p_amount_type_id => 160,
5781: p_period_number => 3);
5782: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5783: (p_period_profile_id => l_period_profile_id,
5784: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5785: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5786: p_project_currency_type => l_currency_type,

Line 5789: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5785: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5786: p_project_currency_type => l_currency_type,
5787: p_amount_type_id => 160,
5788: p_period_number => 4);
5789: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5790: (p_period_profile_id => l_period_profile_id,
5791: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5792: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5793: p_project_currency_type => l_currency_type,

Line 5796: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5792: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5793: p_project_currency_type => l_currency_type,
5794: p_amount_type_id => 160,
5795: p_period_number => 5);
5796: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5797: (p_period_profile_id => l_period_profile_id,
5798: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5799: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5800: p_project_currency_type => l_currency_type,

Line 5803: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5799: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5800: p_project_currency_type => l_currency_type,
5801: p_amount_type_id => 160,
5802: p_period_number => 6);
5803: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5804: (p_period_profile_id => l_period_profile_id,
5805: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5806: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5807: p_project_currency_type => l_currency_type,

Line 5810: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5806: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5807: p_project_currency_type => l_currency_type,
5808: p_amount_type_id => 160,
5809: p_period_number => 7);
5810: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5811: (p_period_profile_id => l_period_profile_id,
5812: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5813: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5814: p_project_currency_type => l_currency_type,

Line 5817: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5813: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5814: p_project_currency_type => l_currency_type,
5815: p_amount_type_id => 160,
5816: p_period_number => 8);
5817: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5818: (p_period_profile_id => l_period_profile_id,
5819: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5820: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5821: p_project_currency_type => l_currency_type,

Line 5824: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5820: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5821: p_project_currency_type => l_currency_type,
5822: p_amount_type_id => 160,
5823: p_period_number => 9);
5824: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5825: (p_period_profile_id => l_period_profile_id,
5826: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5827: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5828: p_project_currency_type => l_currency_type,

Line 5831: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5827: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5828: p_project_currency_type => l_currency_type,
5829: p_amount_type_id => 160,
5830: p_period_number => 10);
5831: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5832: (p_period_profile_id => l_period_profile_id,
5833: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5834: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5835: p_project_currency_type => l_currency_type,

Line 5838: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5834: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5835: p_project_currency_type => l_currency_type,
5836: p_amount_type_id => 160,
5837: p_period_number => 11);
5838: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5839: (p_period_profile_id => l_period_profile_id,
5840: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5841: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5842: p_project_currency_type => l_currency_type,

Line 5845: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5841: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5842: p_project_currency_type => l_currency_type,
5843: p_amount_type_id => 160,
5844: p_period_number => 12);
5845: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5846: (p_period_profile_id => l_period_profile_id,
5847: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5848: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5849: p_project_currency_type => l_currency_type,

Line 5852: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5848: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5849: p_project_currency_type => l_currency_type,
5850: p_amount_type_id => 160,
5851: p_period_number => 13);
5852: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5853: (p_period_profile_id => l_period_profile_id,
5854: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5855: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5856: p_project_currency_type => l_currency_type,

Line 5859: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

5855: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5856: p_project_currency_type => l_currency_type,
5857: p_amount_type_id => 160,
5858: p_period_number => 0);
5859: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5860: (p_period_profile_id => l_period_profile_id,
5861: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5862: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5863: p_project_currency_type => l_currency_type,

Line 6055: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6051: l_pd_has_child_element(l_row_number) := 'N';
6052: else
6053: l_pd_has_child_element(l_row_number) := 'Y';
6054: end if;
6055: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6056: (p_period_profile_id => l_period_profile_id,
6057: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6058: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6059: p_project_currency_type => l_currency_type,

Line 6062: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6058: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6059: p_project_currency_type => l_currency_type,
6060: p_amount_type_id => 215,
6061: p_period_number => 1);
6062: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6063: (p_period_profile_id => l_period_profile_id,
6064: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6065: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6066: p_project_currency_type => l_currency_type,

Line 6069: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6065: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6066: p_project_currency_type => l_currency_type,
6067: p_amount_type_id => 215,
6068: p_period_number => 2);
6069: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6070: (p_period_profile_id => l_period_profile_id,
6071: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6072: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6073: p_project_currency_type => l_currency_type,

Line 6076: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6072: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6073: p_project_currency_type => l_currency_type,
6074: p_amount_type_id => 215,
6075: p_period_number => 3);
6076: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6077: (p_period_profile_id => l_period_profile_id,
6078: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6079: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6080: p_project_currency_type => l_currency_type,

Line 6083: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6079: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6080: p_project_currency_type => l_currency_type,
6081: p_amount_type_id => 215,
6082: p_period_number => 4);
6083: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6084: (p_period_profile_id => l_period_profile_id,
6085: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6086: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6087: p_project_currency_type => l_currency_type,

Line 6090: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6086: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6087: p_project_currency_type => l_currency_type,
6088: p_amount_type_id => 215,
6089: p_period_number => 5);
6090: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6091: (p_period_profile_id => l_period_profile_id,
6092: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6093: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6094: p_project_currency_type => l_currency_type,

Line 6097: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6093: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6094: p_project_currency_type => l_currency_type,
6095: p_amount_type_id => 215,
6096: p_period_number => 6);
6097: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6098: (p_period_profile_id => l_period_profile_id,
6099: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6100: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6101: p_project_currency_type => l_currency_type,

Line 6104: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6100: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6101: p_project_currency_type => l_currency_type,
6102: p_amount_type_id => 215,
6103: p_period_number => 7);
6104: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6105: (p_period_profile_id => l_period_profile_id,
6106: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6107: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6108: p_project_currency_type => l_currency_type,

Line 6111: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6107: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6108: p_project_currency_type => l_currency_type,
6109: p_amount_type_id => 215,
6110: p_period_number => 8);
6111: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6112: (p_period_profile_id => l_period_profile_id,
6113: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6114: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6115: p_project_currency_type => l_currency_type,

Line 6118: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6114: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6115: p_project_currency_type => l_currency_type,
6116: p_amount_type_id => 215,
6117: p_period_number => 9);
6118: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6119: (p_period_profile_id => l_period_profile_id,
6120: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6121: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6122: p_project_currency_type => l_currency_type,

Line 6125: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6121: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6122: p_project_currency_type => l_currency_type,
6123: p_amount_type_id => 215,
6124: p_period_number => 10);
6125: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6126: (p_period_profile_id => l_period_profile_id,
6127: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6128: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6129: p_project_currency_type => l_currency_type,

Line 6132: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6128: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6129: p_project_currency_type => l_currency_type,
6130: p_amount_type_id => 215,
6131: p_period_number => 11);
6132: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6133: (p_period_profile_id => l_period_profile_id,
6134: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6135: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6136: p_project_currency_type => l_currency_type,

Line 6139: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6135: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6136: p_project_currency_type => l_currency_type,
6137: p_amount_type_id => 215,
6138: p_period_number => 12);
6139: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6140: (p_period_profile_id => l_period_profile_id,
6141: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6142: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6143: p_project_currency_type => l_currency_type,

Line 6146: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6142: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6143: p_project_currency_type => l_currency_type,
6144: p_amount_type_id => 215,
6145: p_period_number => 13);
6146: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6147: (p_period_profile_id => l_period_profile_id,
6148: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6149: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6150: p_project_currency_type => l_currency_type,

Line 6153: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6149: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6150: p_project_currency_type => l_currency_type,
6151: p_amount_type_id => 215,
6152: p_period_number => 0);
6153: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6154: (p_period_profile_id => l_period_profile_id,
6155: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6156: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6157: p_project_currency_type => l_currency_type,

Line 6239: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6235: l_pd_has_child_element(l_row_number) := 'N';
6236: else
6237: l_pd_has_child_element(l_row_number) := 'Y';
6238: end if;
6239: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6240: (p_period_profile_id => l_period_profile_id,
6241: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6242: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6243: p_project_currency_type => l_currency_type,

Line 6246: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6242: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6243: p_project_currency_type => l_currency_type,
6244: p_amount_type_id => 100,
6245: p_period_number => 1);
6246: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6247: (p_period_profile_id => l_period_profile_id,
6248: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6249: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6250: p_project_currency_type => l_currency_type,

Line 6253: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6249: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6250: p_project_currency_type => l_currency_type,
6251: p_amount_type_id => 100,
6252: p_period_number => 2);
6253: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6254: (p_period_profile_id => l_period_profile_id,
6255: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6256: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6257: p_project_currency_type => l_currency_type,

Line 6260: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6256: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6257: p_project_currency_type => l_currency_type,
6258: p_amount_type_id => 100,
6259: p_period_number => 3);
6260: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6261: (p_period_profile_id => l_period_profile_id,
6262: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6263: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6264: p_project_currency_type => l_currency_type,

Line 6267: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6263: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6264: p_project_currency_type => l_currency_type,
6265: p_amount_type_id => 100,
6266: p_period_number => 4);
6267: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6268: (p_period_profile_id => l_period_profile_id,
6269: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6270: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6271: p_project_currency_type => l_currency_type,

Line 6274: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6270: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6271: p_project_currency_type => l_currency_type,
6272: p_amount_type_id => 100,
6273: p_period_number => 5);
6274: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6275: (p_period_profile_id => l_period_profile_id,
6276: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6277: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6278: p_project_currency_type => l_currency_type,

Line 6281: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6277: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6278: p_project_currency_type => l_currency_type,
6279: p_amount_type_id => 100,
6280: p_period_number => 6);
6281: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6282: (p_period_profile_id => l_period_profile_id,
6283: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6284: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6285: p_project_currency_type => l_currency_type,

Line 6288: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6284: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6285: p_project_currency_type => l_currency_type,
6286: p_amount_type_id => 100,
6287: p_period_number => 7);
6288: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6289: (p_period_profile_id => l_period_profile_id,
6290: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6291: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6292: p_project_currency_type => l_currency_type,

Line 6295: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6291: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6292: p_project_currency_type => l_currency_type,
6293: p_amount_type_id => 100,
6294: p_period_number => 8);
6295: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6296: (p_period_profile_id => l_period_profile_id,
6297: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6298: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6299: p_project_currency_type => l_currency_type,

Line 6302: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6298: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6299: p_project_currency_type => l_currency_type,
6300: p_amount_type_id => 100,
6301: p_period_number => 9);
6302: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6303: (p_period_profile_id => l_period_profile_id,
6304: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6305: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6306: p_project_currency_type => l_currency_type,

Line 6309: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6305: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6306: p_project_currency_type => l_currency_type,
6307: p_amount_type_id => 100,
6308: p_period_number => 10);
6309: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6310: (p_period_profile_id => l_period_profile_id,
6311: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6312: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6313: p_project_currency_type => l_currency_type,

Line 6316: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6312: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6313: p_project_currency_type => l_currency_type,
6314: p_amount_type_id => 100,
6315: p_period_number => 11);
6316: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6317: (p_period_profile_id => l_period_profile_id,
6318: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6319: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6320: p_project_currency_type => l_currency_type,

Line 6323: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6319: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6320: p_project_currency_type => l_currency_type,
6321: p_amount_type_id => 100,
6322: p_period_number => 12);
6323: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6324: (p_period_profile_id => l_period_profile_id,
6325: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6326: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6327: p_project_currency_type => l_currency_type,

Line 6330: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6326: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6327: p_project_currency_type => l_currency_type,
6328: p_amount_type_id => 100,
6329: p_period_number => 13);
6330: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6331: (p_period_profile_id => l_period_profile_id,
6332: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6333: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6334: p_project_currency_type => l_currency_type,

Line 6337: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

6333: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6334: p_project_currency_type => l_currency_type,
6335: p_amount_type_id => 100,
6336: p_period_number => 0);
6337: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6338: (p_period_profile_id => l_period_profile_id,
6339: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
6340: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
6341: p_project_currency_type => l_currency_type,

Line 6882: pa_fp_view_plans_util.assign_element_name

6878: ra.task_id,
6879: ra.resource_list_member_id,
6880: ra.budget_version_id,
6881: ra.resource_assignment_id,
6882: pa_fp_view_plans_util.assign_element_name
6883: (ra.project_id,
6884: ra.task_id,
6885: ra.resource_list_member_id) as element_name, -- element_name
6886: pa_fp_view_plans_util.assign_element_level

Line 6886: pa_fp_view_plans_util.assign_element_level

6882: pa_fp_view_plans_util.assign_element_name
6883: (ra.project_id,
6884: ra.task_id,
6885: ra.resource_list_member_id) as element_name, -- element_name
6886: pa_fp_view_plans_util.assign_element_level
6887: (ra.project_id,
6888: ra.budget_version_id,
6889: ra.task_id,
6890: ra.resource_list_member_id) as element_level, -- element_level

Line 6931: pa_fp_view_plans_util.assign_row_level

6927: DECODE(ra.resource_assignment_type,
6928: 'ROLLED_UP', 'N',
6929: 'USER_ENTERED', 'Y',
6930: 'Y') as line_editable_flag, -- line_editable_flag
6931: pa_fp_view_plans_util.assign_row_level
6932: (ra.project_id,
6933: ra.task_id,
6934: ra.resource_list_member_id) as row_level,
6935: pa_fp_view_plans_util.assign_parent_element

Line 6935: pa_fp_view_plans_util.assign_parent_element

6931: pa_fp_view_plans_util.assign_row_level
6932: (ra.project_id,
6933: ra.task_id,
6934: ra.resource_list_member_id) as row_level,
6935: pa_fp_view_plans_util.assign_parent_element
6936: (ra.project_id,
6937: ra.task_id,
6938: ra.resource_list_member_id) as parent_element_name,
6939: ra.unit_of_measure,

Line 7152: pa_fp_view_plans_util.assign_element_name

7148: 0,
7149: 0,
7150: l_budget_version_id(1),
7151: -2,
7152: pa_fp_view_plans_util.assign_element_name
7153: (l_project_id(1),
7154: 0,
7155: 0) ,
7156: pa_fp_view_plans_util.assign_element_level

Line 7156: pa_fp_view_plans_util.assign_element_level

7152: pa_fp_view_plans_util.assign_element_name
7153: (l_project_id(1),
7154: 0,
7155: 0) ,
7156: pa_fp_view_plans_util.assign_element_level
7157: (l_project_id(1),
7158: l_budget_version_id(1),
7159: 0,
7160: 0),

Line 7168: pa_fp_view_plans_util.assign_row_level

7164: 0,
7165: 0, -- margin
7166: 0, -- margin_percent
7167: 'N', -- line_editable_flag
7168: pa_fp_view_plans_util.assign_row_level
7169: (l_project_id(1),
7170: 0,
7171: 0) ,
7172: pa_fp_view_plans_util.assign_parent_element

Line 7172: pa_fp_view_plans_util.assign_parent_element

7168: pa_fp_view_plans_util.assign_row_level
7169: (l_project_id(1),
7170: 0,
7171: 0) ,
7172: pa_fp_view_plans_util.assign_parent_element
7173: (l_project_id(1),
7174: 0,
7175: 0) ,
7176: l_unit_of_measure(1),

Line 7243: pa_fp_view_plans_util.assign_element_name

7239: task_rec.task_id,
7240: 0,
7241: l_budget_version_id(i),
7242: -2,
7243: pa_fp_view_plans_util.assign_element_name
7244: (l_project_id(i),
7245: task_rec.task_id,
7246: 0) ,
7247: pa_fp_view_plans_util.assign_element_level

Line 7247: pa_fp_view_plans_util.assign_element_level

7243: pa_fp_view_plans_util.assign_element_name
7244: (l_project_id(i),
7245: task_rec.task_id,
7246: 0) ,
7247: pa_fp_view_plans_util.assign_element_level
7248: (l_project_id(i),
7249: l_budget_version_id(i),
7250: task_rec.task_id,
7251: 0),

Line 7259: pa_fp_view_plans_util.assign_row_level

7255: l_revenue(i),
7256: 0, -- margin
7257: 0, -- margin_percent
7258: 'N', -- line_editable_flag
7259: pa_fp_view_plans_util.assign_row_level
7260: (l_project_id(i),
7261: task_rec.task_id,
7262: 0) ,
7263: pa_fp_view_plans_util.assign_parent_element

Line 7263: pa_fp_view_plans_util.assign_parent_element

7259: pa_fp_view_plans_util.assign_row_level
7260: (l_project_id(i),
7261: task_rec.task_id,
7262: 0) ,
7263: pa_fp_view_plans_util.assign_parent_element
7264: (l_project_id(i),
7265: task_rec.task_id,
7266: 0) ,
7267: l_unit_of_measure(i),

Line 7348: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7344: --hr_utility.trace('quantity: period1');
7345: --hr_utility.trace('p_period_profile_id= ' || to_char(l_period_profile_id));
7346: --hr_utility.trace('p_resource_assignment_id= ' || to_char(l_pd_res_assignment_id(l_row_number)));
7347: --hr_utility.trace('p_project_currency_type= ' || l_currency_type);
7348: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7349: (p_period_profile_id => l_period_profile_id,
7350: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7351: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7352: p_project_currency_type => l_currency_type,

Line 7355: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7351: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7352: p_project_currency_type => l_currency_type,
7353: p_amount_type_id => 215,
7354: p_period_number => 1);
7355: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7356: (p_period_profile_id => l_period_profile_id,
7357: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7358: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7359: p_project_currency_type => l_currency_type,

Line 7362: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7358: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7359: p_project_currency_type => l_currency_type,
7360: p_amount_type_id => 215,
7361: p_period_number => 2);
7362: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7363: (p_period_profile_id => l_period_profile_id,
7364: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7365: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7366: p_project_currency_type => l_currency_type,

Line 7369: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7365: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7366: p_project_currency_type => l_currency_type,
7367: p_amount_type_id => 215,
7368: p_period_number => 3);
7369: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7370: (p_period_profile_id => l_period_profile_id,
7371: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7372: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7373: p_project_currency_type => l_currency_type,

Line 7376: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7372: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7373: p_project_currency_type => l_currency_type,
7374: p_amount_type_id => 215,
7375: p_period_number => 4);
7376: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7377: (p_period_profile_id => l_period_profile_id,
7378: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7379: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7380: p_project_currency_type => l_currency_type,

Line 7383: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7379: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7380: p_project_currency_type => l_currency_type,
7381: p_amount_type_id => 215,
7382: p_period_number => 5);
7383: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7384: (p_period_profile_id => l_period_profile_id,
7385: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7386: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7387: p_project_currency_type => l_currency_type,

Line 7390: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7386: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7387: p_project_currency_type => l_currency_type,
7388: p_amount_type_id => 215,
7389: p_period_number => 6);
7390: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7391: (p_period_profile_id => l_period_profile_id,
7392: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7393: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7394: p_project_currency_type => l_currency_type,

Line 7397: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7393: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7394: p_project_currency_type => l_currency_type,
7395: p_amount_type_id => 215,
7396: p_period_number => 7);
7397: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7398: (p_period_profile_id => l_period_profile_id,
7399: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7400: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7401: p_project_currency_type => l_currency_type,

Line 7404: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7400: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7401: p_project_currency_type => l_currency_type,
7402: p_amount_type_id => 215,
7403: p_period_number => 8);
7404: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7405: (p_period_profile_id => l_period_profile_id,
7406: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7407: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7408: p_project_currency_type => l_currency_type,

Line 7411: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7407: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7408: p_project_currency_type => l_currency_type,
7409: p_amount_type_id => 215,
7410: p_period_number => 9);
7411: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7412: (p_period_profile_id => l_period_profile_id,
7413: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7414: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7415: p_project_currency_type => l_currency_type,

Line 7418: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7414: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7415: p_project_currency_type => l_currency_type,
7416: p_amount_type_id => 215,
7417: p_period_number => 10);
7418: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7419: (p_period_profile_id => l_period_profile_id,
7420: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7421: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7422: p_project_currency_type => l_currency_type,

Line 7425: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7421: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7422: p_project_currency_type => l_currency_type,
7423: p_amount_type_id => 215,
7424: p_period_number => 11);
7425: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7426: (p_period_profile_id => l_period_profile_id,
7427: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7428: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7429: p_project_currency_type => l_currency_type,

Line 7432: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7428: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7429: p_project_currency_type => l_currency_type,
7430: p_amount_type_id => 215,
7431: p_period_number => 12);
7432: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7433: (p_period_profile_id => l_period_profile_id,
7434: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7435: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7436: p_project_currency_type => l_currency_type,

Line 7439: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7435: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7436: p_project_currency_type => l_currency_type,
7437: p_amount_type_id => 215,
7438: p_period_number => 13);
7439: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7440: (p_period_profile_id => l_period_profile_id,
7441: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7442: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7443: p_project_currency_type => l_currency_type,

Line 7446: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7442: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7443: p_project_currency_type => l_currency_type,
7444: p_amount_type_id => 215,
7445: p_period_number => 0);
7446: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7447: (p_period_profile_id => l_period_profile_id,
7448: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7449: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7450: p_project_currency_type => l_currency_type,

Line 7493: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7489: l_cost_row_number := l_row_number;
7490: end if;
7491: */
7492: --hr_utility.trace('burdened cost: period1');
7493: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7494: (p_period_profile_id => l_period_profile_id,
7495: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7496: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7497: p_project_currency_type => l_currency_type,

Line 7501: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7497: p_project_currency_type => l_currency_type,
7498: --p_amount_type_id => 150,
7499: p_amount_type_id => 165,
7500: p_period_number => 1);
7501: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7502: (p_period_profile_id => l_period_profile_id,
7503: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7504: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7505: p_project_currency_type => l_currency_type,

Line 7509: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7505: p_project_currency_type => l_currency_type,
7506: --p_amount_type_id => 150,
7507: p_amount_type_id => 165,
7508: p_period_number => 2);
7509: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7510: (p_period_profile_id => l_period_profile_id,
7511: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7512: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7513: p_project_currency_type => l_currency_type,

Line 7517: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7513: p_project_currency_type => l_currency_type,
7514: --p_amount_type_id => 150,
7515: p_amount_type_id => 165,
7516: p_period_number => 3);
7517: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7518: (p_period_profile_id => l_period_profile_id,
7519: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7520: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7521: p_project_currency_type => l_currency_type,

Line 7525: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7521: p_project_currency_type => l_currency_type,
7522: --p_amount_type_id => 150,
7523: p_amount_type_id => 165,
7524: p_period_number => 4);
7525: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7526: (p_period_profile_id => l_period_profile_id,
7527: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7528: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7529: p_project_currency_type => l_currency_type,

Line 7533: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7529: p_project_currency_type => l_currency_type,
7530: --p_amount_type_id => 150,
7531: p_amount_type_id => 165,
7532: p_period_number => 5);
7533: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7534: (p_period_profile_id => l_period_profile_id,
7535: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7536: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7537: p_project_currency_type => l_currency_type,

Line 7541: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7537: p_project_currency_type => l_currency_type,
7538: --p_amount_type_id => 150,
7539: p_amount_type_id => 165,
7540: p_period_number => 6);
7541: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7542: (p_period_profile_id => l_period_profile_id,
7543: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7544: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7545: p_project_currency_type => l_currency_type,

Line 7549: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7545: p_project_currency_type => l_currency_type,
7546: --p_amount_type_id => 150,
7547: p_amount_type_id => 165,
7548: p_period_number => 7);
7549: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7550: (p_period_profile_id => l_period_profile_id,
7551: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7552: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7553: p_project_currency_type => l_currency_type,

Line 7557: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7553: p_project_currency_type => l_currency_type,
7554: --p_amount_type_id => 150,
7555: p_amount_type_id => 165,
7556: p_period_number => 8);
7557: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7558: (p_period_profile_id => l_period_profile_id,
7559: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7560: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7561: p_project_currency_type => l_currency_type,

Line 7565: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7561: p_project_currency_type => l_currency_type,
7562: --p_amount_type_id => 150,
7563: p_amount_type_id => 165,
7564: p_period_number => 9);
7565: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7566: (p_period_profile_id => l_period_profile_id,
7567: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7568: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7569: p_project_currency_type => l_currency_type,

Line 7573: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7569: p_project_currency_type => l_currency_type,
7570: --p_amount_type_id => 150,
7571: p_amount_type_id => 165,
7572: p_period_number => 10);
7573: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7574: (p_period_profile_id => l_period_profile_id,
7575: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7576: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7577: p_project_currency_type => l_currency_type,

Line 7581: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7577: p_project_currency_type => l_currency_type,
7578: --p_amount_type_id => 150,
7579: p_amount_type_id => 165,
7580: p_period_number => 11);
7581: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7582: (p_period_profile_id => l_period_profile_id,
7583: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7584: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7585: p_project_currency_type => l_currency_type,

Line 7589: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7585: p_project_currency_type => l_currency_type,
7586: --p_amount_type_id => 150,
7587: p_amount_type_id => 165,
7588: p_period_number => 12);
7589: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7590: (p_period_profile_id => l_period_profile_id,
7591: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7592: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7593: p_project_currency_type => l_currency_type,

Line 7597: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7593: p_project_currency_type => l_currency_type,
7594: --p_amount_type_id => 150,
7595: p_amount_type_id => 165,
7596: p_period_number => 13);
7597: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7598: (p_period_profile_id => l_period_profile_id,
7599: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7600: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7601: p_project_currency_type => l_currency_type,

Line 7605: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7601: p_project_currency_type => l_currency_type,
7602: --p_amount_type_id => 150,
7603: p_amount_type_id => 165,
7604: p_period_number => 0);
7605: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7606: (p_period_profile_id => l_period_profile_id,
7607: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7608: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7609: p_project_currency_type => l_currency_type,

Line 7653: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7649: l_cost_row_number := l_row_number;
7650: end if;
7651: */
7652: --hr_utility.trace('raw cost: period1');
7653: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7654: (p_period_profile_id => l_period_profile_id,
7655: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7656: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7657: p_project_currency_type => l_currency_type,

Line 7661: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7657: p_project_currency_type => l_currency_type,
7658: --p_amount_type_id => 150,
7659: p_amount_type_id => 160,
7660: p_period_number => 1);
7661: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7662: (p_period_profile_id => l_period_profile_id,
7663: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7664: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7665: p_project_currency_type => l_currency_type,

Line 7669: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7665: p_project_currency_type => l_currency_type,
7666: --p_amount_type_id => 150,
7667: p_amount_type_id => 160,
7668: p_period_number => 2);
7669: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7670: (p_period_profile_id => l_period_profile_id,
7671: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7672: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7673: p_project_currency_type => l_currency_type,

Line 7677: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7673: p_project_currency_type => l_currency_type,
7674: --p_amount_type_id => 150,
7675: p_amount_type_id => 160,
7676: p_period_number => 3);
7677: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7678: (p_period_profile_id => l_period_profile_id,
7679: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7680: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7681: p_project_currency_type => l_currency_type,

Line 7685: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7681: p_project_currency_type => l_currency_type,
7682: --p_amount_type_id => 150,
7683: p_amount_type_id => 160,
7684: p_period_number => 4);
7685: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7686: (p_period_profile_id => l_period_profile_id,
7687: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7688: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7689: p_project_currency_type => l_currency_type,

Line 7693: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7689: p_project_currency_type => l_currency_type,
7690: --p_amount_type_id => 150,
7691: p_amount_type_id => 160,
7692: p_period_number => 5);
7693: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7694: (p_period_profile_id => l_period_profile_id,
7695: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7696: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7697: p_project_currency_type => l_currency_type,

Line 7701: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7697: p_project_currency_type => l_currency_type,
7698: --p_amount_type_id => 150,
7699: p_amount_type_id => 160,
7700: p_period_number => 6);
7701: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7702: (p_period_profile_id => l_period_profile_id,
7703: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7704: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7705: p_project_currency_type => l_currency_type,

Line 7709: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7705: p_project_currency_type => l_currency_type,
7706: --p_amount_type_id => 150,
7707: p_amount_type_id => 160,
7708: p_period_number => 7);
7709: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7710: (p_period_profile_id => l_period_profile_id,
7711: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7712: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7713: p_project_currency_type => l_currency_type,

Line 7717: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7713: p_project_currency_type => l_currency_type,
7714: --p_amount_type_id => 150,
7715: p_amount_type_id => 160,
7716: p_period_number => 8);
7717: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7718: (p_period_profile_id => l_period_profile_id,
7719: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7720: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7721: p_project_currency_type => l_currency_type,

Line 7725: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7721: p_project_currency_type => l_currency_type,
7722: --p_amount_type_id => 150,
7723: p_amount_type_id => 160,
7724: p_period_number => 9);
7725: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7726: (p_period_profile_id => l_period_profile_id,
7727: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7728: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7729: p_project_currency_type => l_currency_type,

Line 7733: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7729: p_project_currency_type => l_currency_type,
7730: --p_amount_type_id => 150,
7731: p_amount_type_id => 160,
7732: p_period_number => 10);
7733: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7734: (p_period_profile_id => l_period_profile_id,
7735: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7736: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7737: p_project_currency_type => l_currency_type,

Line 7741: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7737: p_project_currency_type => l_currency_type,
7738: --p_amount_type_id => 150,
7739: p_amount_type_id => 160,
7740: p_period_number => 11);
7741: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7742: (p_period_profile_id => l_period_profile_id,
7743: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7744: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7745: p_project_currency_type => l_currency_type,

Line 7749: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7745: p_project_currency_type => l_currency_type,
7746: --p_amount_type_id => 150,
7747: p_amount_type_id => 160,
7748: p_period_number => 12);
7749: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7750: (p_period_profile_id => l_period_profile_id,
7751: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7752: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7753: p_project_currency_type => l_currency_type,

Line 7757: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7753: p_project_currency_type => l_currency_type,
7754: --p_amount_type_id => 150,
7755: p_amount_type_id => 160,
7756: p_period_number => 13);
7757: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7758: (p_period_profile_id => l_period_profile_id,
7759: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7760: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7761: p_project_currency_type => l_currency_type,

Line 7765: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7761: p_project_currency_type => l_currency_type,
7762: --p_amount_type_id => 150,
7763: p_amount_type_id => 160,
7764: p_period_number => 0);
7765: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7766: (p_period_profile_id => l_period_profile_id,
7767: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7768: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7769: p_project_currency_type => l_currency_type,

Line 7805: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7801: l_pd_has_child_element(l_row_number) := 'Y';
7802: end if;
7803: l_revenue_row_number := l_row_number;
7804: --hr_utility.trace('revenue: period1');
7805: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7806: (p_period_profile_id => l_period_profile_id,
7807: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7808: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7809: p_project_currency_type => l_currency_type,

Line 7812: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7808: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7809: p_project_currency_type => l_currency_type,
7810: p_amount_type_id => 100,
7811: p_period_number => 1);
7812: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7813: (p_period_profile_id => l_period_profile_id,
7814: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7815: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7816: p_project_currency_type => l_currency_type,

Line 7819: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7815: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7816: p_project_currency_type => l_currency_type,
7817: p_amount_type_id => 100,
7818: p_period_number => 2);
7819: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7820: (p_period_profile_id => l_period_profile_id,
7821: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7822: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7823: p_project_currency_type => l_currency_type,

Line 7826: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7822: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7823: p_project_currency_type => l_currency_type,
7824: p_amount_type_id => 100,
7825: p_period_number => 3);
7826: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7827: (p_period_profile_id => l_period_profile_id,
7828: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7829: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7830: p_project_currency_type => l_currency_type,

Line 7833: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7829: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7830: p_project_currency_type => l_currency_type,
7831: p_amount_type_id => 100,
7832: p_period_number => 4);
7833: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7834: (p_period_profile_id => l_period_profile_id,
7835: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7836: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7837: p_project_currency_type => l_currency_type,

Line 7840: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7836: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7837: p_project_currency_type => l_currency_type,
7838: p_amount_type_id => 100,
7839: p_period_number => 5);
7840: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7841: (p_period_profile_id => l_period_profile_id,
7842: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7843: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7844: p_project_currency_type => l_currency_type,

Line 7847: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7843: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7844: p_project_currency_type => l_currency_type,
7845: p_amount_type_id => 100,
7846: p_period_number => 6);
7847: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7848: (p_period_profile_id => l_period_profile_id,
7849: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7850: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7851: p_project_currency_type => l_currency_type,

Line 7854: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7850: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7851: p_project_currency_type => l_currency_type,
7852: p_amount_type_id => 100,
7853: p_period_number => 7);
7854: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7855: (p_period_profile_id => l_period_profile_id,
7856: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7857: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7858: p_project_currency_type => l_currency_type,

Line 7861: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7857: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7858: p_project_currency_type => l_currency_type,
7859: p_amount_type_id => 100,
7860: p_period_number => 8);
7861: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7862: (p_period_profile_id => l_period_profile_id,
7863: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7864: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7865: p_project_currency_type => l_currency_type,

Line 7868: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7864: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7865: p_project_currency_type => l_currency_type,
7866: p_amount_type_id => 100,
7867: p_period_number => 9);
7868: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7869: (p_period_profile_id => l_period_profile_id,
7870: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7871: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7872: p_project_currency_type => l_currency_type,

Line 7875: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7871: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7872: p_project_currency_type => l_currency_type,
7873: p_amount_type_id => 100,
7874: p_period_number => 10);
7875: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7876: (p_period_profile_id => l_period_profile_id,
7877: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7878: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7879: p_project_currency_type => l_currency_type,

Line 7882: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7878: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7879: p_project_currency_type => l_currency_type,
7880: p_amount_type_id => 100,
7881: p_period_number => 11);
7882: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7883: (p_period_profile_id => l_period_profile_id,
7884: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7885: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7886: p_project_currency_type => l_currency_type,

Line 7889: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7885: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7886: p_project_currency_type => l_currency_type,
7887: p_amount_type_id => 100,
7888: p_period_number => 12);
7889: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7890: (p_period_profile_id => l_period_profile_id,
7891: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7892: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7893: p_project_currency_type => l_currency_type,

Line 7896: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7892: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7893: p_project_currency_type => l_currency_type,
7894: p_amount_type_id => 100,
7895: p_period_number => 13);
7896: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7897: (p_period_profile_id => l_period_profile_id,
7898: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7899: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7900: p_project_currency_type => l_currency_type,

Line 7903: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7899: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7900: p_project_currency_type => l_currency_type,
7901: p_amount_type_id => 100,
7902: p_period_number => 0);
7903: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7904: (p_period_profile_id => l_period_profile_id,
7905: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7906: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7907: p_project_currency_type => l_currency_type,

Line 7985: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));

7981: l_pd_has_child_element(l_row_number) := 'N';
7982: else
7983: l_pd_has_child_element(l_row_number) := 'Y';
7984: end if;
7985: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));

Line 7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));

7982: else
7983: l_pd_has_child_element(l_row_number) := 'Y';
7984: end if;
7985: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));

Line 7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));

7983: l_pd_has_child_element(l_row_number) := 'Y';
7984: end if;
7985: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));

Line 7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));

7984: end if;
7985: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));

Line 7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));

7985: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_1(l_cost_row_number),l_pd_period_1(l_revenue_row_number));
7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));

Line 7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));

7986: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_2(l_cost_row_number),l_pd_period_2(l_revenue_row_number));
7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));

Line 7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));

7987: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_3(l_cost_row_number),l_pd_period_3(l_revenue_row_number));
7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));

Line 7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));

7988: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_4(l_cost_row_number),l_pd_period_4(l_revenue_row_number));
7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));

Line 7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));

7989: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_5(l_cost_row_number),l_pd_period_5(l_revenue_row_number));
7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));

Line 7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));

7990: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_6(l_cost_row_number),l_pd_period_6(l_revenue_row_number));
7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));

Line 7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));

7991: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_7(l_cost_row_number),l_pd_period_7(l_revenue_row_number));
7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));

Line 7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));

7992: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_8(l_cost_row_number),l_pd_period_8(l_revenue_row_number));
7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
8000: end if; -- display_from: MARGIN PERCENT

Line 7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));

7993: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_9(l_cost_row_number),l_pd_period_9(l_revenue_row_number));
7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
8000: end if; -- display_from: MARGIN PERCENT
8001: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651

Line 7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));

7994: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_10(l_cost_row_number),l_pd_period_10(l_revenue_row_number));
7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
8000: end if; -- display_from: MARGIN PERCENT
8001: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
8002: end loop;

Line 7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));

7995: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_11(l_cost_row_number),l_pd_period_11(l_revenue_row_number));
7996: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_12(l_cost_row_number),l_pd_period_12(l_revenue_row_number));
7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
8000: end if; -- display_from: MARGIN PERCENT
8001: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
8002: end loop;
8003: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'

Line 8001: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651

7997: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_period_13(l_cost_row_number),l_pd_period_13(l_revenue_row_number));
7998: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_preceding(l_cost_row_number),l_pd_preceding(l_revenue_row_number));
7999: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_succeeding(l_cost_row_number),l_pd_succeeding(l_revenue_row_number));
8000: end if; -- display_from: MARGIN PERCENT
8001: l_pd_project_total(l_row_number) := pa_fp_view_plans_util.calc_margin_percent(l_pd_project_total(l_cost_row_number),l_pd_project_total(l_revenue_row_number)); -- bug 2699651
8002: end loop;
8003: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
8004: l_err_stage := 400;
8005: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_together', '400: populated the pds pl/sql tables', 1);

Line 8321: pa_fp_view_plans_util.assign_element_name

8317: ra.task_id,
8318: ra.resource_list_member_id,
8319: ra.budget_version_id,
8320: ra.resource_assignment_id,
8321: pa_fp_view_plans_util.assign_element_name
8322: (ra.project_id,
8323: ra.task_id,
8324: ra.resource_list_member_id) as element_name, -- element_name
8325: pa_fp_view_plans_util.assign_element_level

Line 8325: pa_fp_view_plans_util.assign_element_level

8321: pa_fp_view_plans_util.assign_element_name
8322: (ra.project_id,
8323: ra.task_id,
8324: ra.resource_list_member_id) as element_name, -- element_name
8325: pa_fp_view_plans_util.assign_element_level
8326: (ra.project_id,
8327: ra.budget_version_id,
8328: ra.task_id,
8329: ra.resource_list_member_id) as element_level, -- element_level

Line 8347: pa_fp_view_plans_util.assign_row_level

8343: DECODE(ra.resource_assignment_type,
8344: 'ROLLED_UP', 'N',
8345: 'USER_ENTERED', 'Y',
8346: 'Y') as line_editable_flag, -- line_editable_flag
8347: pa_fp_view_plans_util.assign_row_level
8348: (ra.project_id,
8349: ra.task_id,
8350: ra.resource_list_member_id) as row_level,
8351: pa_fp_view_plans_util.assign_parent_element

Line 8351: pa_fp_view_plans_util.assign_parent_element

8347: pa_fp_view_plans_util.assign_row_level
8348: (ra.project_id,
8349: ra.task_id,
8350: ra.resource_list_member_id) as row_level,
8351: pa_fp_view_plans_util.assign_parent_element
8352: (ra.project_id,
8353: ra.task_id,
8354: ra.resource_list_member_id) as parent_element_name,
8355: ra.unit_of_measure,

Line 8381: pa_fp_view_plans_util.assign_element_name

8377: ra.task_id,
8378: ra.resource_list_member_id,
8379: ra.budget_version_id,
8380: ra.resource_assignment_id,
8381: pa_fp_view_plans_util.assign_element_name
8382: (ra.project_id,
8383: ra.task_id,
8384: ra.resource_list_member_id) as element_name, -- element_name
8385: pa_fp_view_plans_util.assign_element_level

Line 8385: pa_fp_view_plans_util.assign_element_level

8381: pa_fp_view_plans_util.assign_element_name
8382: (ra.project_id,
8383: ra.task_id,
8384: ra.resource_list_member_id) as element_name, -- element_name
8385: pa_fp_view_plans_util.assign_element_level
8386: (ra.project_id,
8387: ra.budget_version_id,
8388: ra.task_id,
8389: ra.resource_list_member_id) as element_level, -- element_level

Line 8405: pa_fp_view_plans_util.assign_row_level

8401: DECODE(ra.resource_assignment_type,
8402: 'ROLLED_UP', 'N',
8403: 'USER_ENTERED', 'Y',
8404: 'Y') as line_editable_flag, -- line_editable_flag
8405: pa_fp_view_plans_util.assign_row_level
8406: (ra.project_id,
8407: ra.task_id,
8408: ra.resource_list_member_id) as row_level,
8409: pa_fp_view_plans_util.assign_parent_element

Line 8409: pa_fp_view_plans_util.assign_parent_element

8405: pa_fp_view_plans_util.assign_row_level
8406: (ra.project_id,
8407: ra.task_id,
8408: ra.resource_list_member_id) as row_level,
8409: pa_fp_view_plans_util.assign_parent_element
8410: (ra.project_id,
8411: ra.task_id,
8412: ra.resource_list_member_id) as parent_element_name,
8413: ra.unit_of_measure,

Line 8628: pa_fp_view_plans_util.assign_element_name

8624: 0,
8625: 0,
8626: l_budget_version_id(1),
8627: -2,
8628: pa_fp_view_plans_util.assign_element_name
8629: (l_project_id(1),
8630: 0,
8631: 0) ,
8632: pa_fp_view_plans_util.assign_element_level

Line 8632: pa_fp_view_plans_util.assign_element_level

8628: pa_fp_view_plans_util.assign_element_name
8629: (l_project_id(1),
8630: 0,
8631: 0) ,
8632: pa_fp_view_plans_util.assign_element_level
8633: (l_project_id(1),
8634: l_budget_version_id(1),
8635: 0,
8636: 0),

Line 8644: pa_fp_view_plans_util.assign_row_level

8640: 0,
8641: 0, -- margin
8642: 0, -- margin_percent
8643: 'N', -- line_editable_flag
8644: pa_fp_view_plans_util.assign_row_level
8645: (l_project_id(1),
8646: 0,
8647: 0) ,
8648: pa_fp_view_plans_util.assign_parent_element

Line 8648: pa_fp_view_plans_util.assign_parent_element

8644: pa_fp_view_plans_util.assign_row_level
8645: (l_project_id(1),
8646: 0,
8647: 0) ,
8648: pa_fp_view_plans_util.assign_parent_element
8649: (l_project_id(1),
8650: 0,
8651: 0) ,
8652: l_unit_of_measure(1),

Line 8719: pa_fp_view_plans_util.assign_element_name

8715: task_rec.task_id,
8716: 0,
8717: l_budget_version_id(i),
8718: -2,
8719: pa_fp_view_plans_util.assign_element_name
8720: (l_project_id(i),
8721: task_rec.task_id,
8722: 0) ,
8723: pa_fp_view_plans_util.assign_element_level

Line 8723: pa_fp_view_plans_util.assign_element_level

8719: pa_fp_view_plans_util.assign_element_name
8720: (l_project_id(i),
8721: task_rec.task_id,
8722: 0) ,
8723: pa_fp_view_plans_util.assign_element_level
8724: (l_project_id(i),
8725: l_budget_version_id(i),
8726: task_rec.task_id,
8727: 0),

Line 8735: pa_fp_view_plans_util.assign_row_level

8731: 0,
8732: 0, -- margin
8733: 0, -- margin_percent
8734: 'N', -- line_editable_flag
8735: pa_fp_view_plans_util.assign_row_level
8736: (l_project_id(i),
8737: task_rec.task_id,
8738: 0) ,
8739: pa_fp_view_plans_util.assign_parent_element

Line 8739: pa_fp_view_plans_util.assign_parent_element

8735: pa_fp_view_plans_util.assign_row_level
8736: (l_project_id(i),
8737: task_rec.task_id,
8738: 0) ,
8739: pa_fp_view_plans_util.assign_parent_element
8740: (l_project_id(i),
8741: task_rec.task_id,
8742: 0) ,
8743: l_unit_of_measure(i),

Line 8823: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8819: if (l_report_labor_hrs_from_code = 'COST') then
8820: --hr_utility.trace('try to getperiodnvalue');
8821: --hr_utility.trace('raid= ' || to_char(l_pd_res_assignment_id(l_row_number)));
8822: --hr_utility.trace('ppid= ' || to_char(l_period_profile_id));
8823: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8824: (p_period_profile_id => l_period_profile_id,
8825: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8826: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8827: p_project_currency_type => l_currency_type,

Line 8831: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8827: p_project_currency_type => l_currency_type,
8828: p_amount_type_id => 215,
8829: p_period_number => 1);
8830: --hr_utility.trace('reached here');
8831: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8832: (p_period_profile_id => l_period_profile_id,
8833: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8834: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8835: p_project_currency_type => l_currency_type,

Line 8838: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8834: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8835: p_project_currency_type => l_currency_type,
8836: p_amount_type_id => 215,
8837: p_period_number => 2);
8838: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8839: (p_period_profile_id => l_period_profile_id,
8840: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8841: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8842: p_project_currency_type => l_currency_type,

Line 8845: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8841: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8842: p_project_currency_type => l_currency_type,
8843: p_amount_type_id => 215,
8844: p_period_number => 3);
8845: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8846: (p_period_profile_id => l_period_profile_id,
8847: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8848: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8849: p_project_currency_type => l_currency_type,

Line 8852: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8848: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8849: p_project_currency_type => l_currency_type,
8850: p_amount_type_id => 215,
8851: p_period_number => 4);
8852: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8853: (p_period_profile_id => l_period_profile_id,
8854: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8855: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8856: p_project_currency_type => l_currency_type,

Line 8859: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8855: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8856: p_project_currency_type => l_currency_type,
8857: p_amount_type_id => 215,
8858: p_period_number => 5);
8859: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8860: (p_period_profile_id => l_period_profile_id,
8861: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8862: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8863: p_project_currency_type => l_currency_type,

Line 8866: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8862: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8863: p_project_currency_type => l_currency_type,
8864: p_amount_type_id => 215,
8865: p_period_number => 6);
8866: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8867: (p_period_profile_id => l_period_profile_id,
8868: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8869: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8870: p_project_currency_type => l_currency_type,

Line 8873: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8869: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8870: p_project_currency_type => l_currency_type,
8871: p_amount_type_id => 215,
8872: p_period_number => 7);
8873: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8874: (p_period_profile_id => l_period_profile_id,
8875: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8876: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8877: p_project_currency_type => l_currency_type,

Line 8880: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8876: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8877: p_project_currency_type => l_currency_type,
8878: p_amount_type_id => 215,
8879: p_period_number => 8);
8880: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8881: (p_period_profile_id => l_period_profile_id,
8882: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8883: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8884: p_project_currency_type => l_currency_type,

Line 8887: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8883: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8884: p_project_currency_type => l_currency_type,
8885: p_amount_type_id => 215,
8886: p_period_number => 9);
8887: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8888: (p_period_profile_id => l_period_profile_id,
8889: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8890: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8891: p_project_currency_type => l_currency_type,

Line 8894: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8890: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8891: p_project_currency_type => l_currency_type,
8892: p_amount_type_id => 215,
8893: p_period_number => 10);
8894: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8895: (p_period_profile_id => l_period_profile_id,
8896: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8897: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8898: p_project_currency_type => l_currency_type,

Line 8901: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8897: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8898: p_project_currency_type => l_currency_type,
8899: p_amount_type_id => 215,
8900: p_period_number => 11);
8901: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8902: (p_period_profile_id => l_period_profile_id,
8903: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8904: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8905: p_project_currency_type => l_currency_type,

Line 8908: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8904: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8905: p_project_currency_type => l_currency_type,
8906: p_amount_type_id => 215,
8907: p_period_number => 12);
8908: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8909: (p_period_profile_id => l_period_profile_id,
8910: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8911: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8912: p_project_currency_type => l_currency_type,

Line 8915: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8911: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8912: p_project_currency_type => l_currency_type,
8913: p_amount_type_id => 215,
8914: p_period_number => 13);
8915: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8916: (p_period_profile_id => l_period_profile_id,
8917: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8918: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8919: p_project_currency_type => l_currency_type,

Line 8922: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8918: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8919: p_project_currency_type => l_currency_type,
8920: p_amount_type_id => 215,
8921: p_period_number => 0);
8922: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8923: (p_period_profile_id => l_period_profile_id,
8924: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8925: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8926: p_project_currency_type => l_currency_type,

Line 8979: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8975: l_pd_has_child_element(l_row_number) := 'N';
8976: else
8977: l_pd_has_child_element(l_row_number) := 'Y';
8978: end if;
8979: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8980: (p_period_profile_id => l_period_profile_id,
8981: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8982: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8983: p_project_currency_type => l_currency_type,

Line 8987: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8983: p_project_currency_type => l_currency_type,
8984: --p_amount_type_id => 150,
8985: p_amount_type_id => 165,
8986: p_period_number => 1);
8987: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8988: (p_period_profile_id => l_period_profile_id,
8989: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8990: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8991: p_project_currency_type => l_currency_type,

Line 8995: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8991: p_project_currency_type => l_currency_type,
8992: --p_amount_type_id => 150,
8993: p_amount_type_id => 165,
8994: p_period_number => 2);
8995: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8996: (p_period_profile_id => l_period_profile_id,
8997: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8998: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8999: p_project_currency_type => l_currency_type,

Line 9003: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

8999: p_project_currency_type => l_currency_type,
9000: --p_amount_type_id => 150,
9001: p_amount_type_id => 165,
9002: p_period_number => 3);
9003: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9004: (p_period_profile_id => l_period_profile_id,
9005: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9006: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9007: p_project_currency_type => l_currency_type,

Line 9011: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9007: p_project_currency_type => l_currency_type,
9008: --p_amount_type_id => 150,
9009: p_amount_type_id => 165,
9010: p_period_number => 4);
9011: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9012: (p_period_profile_id => l_period_profile_id,
9013: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9014: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9015: p_project_currency_type => l_currency_type,

Line 9019: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9015: p_project_currency_type => l_currency_type,
9016: --p_amount_type_id => 150,
9017: p_amount_type_id => 165,
9018: p_period_number => 5);
9019: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9020: (p_period_profile_id => l_period_profile_id,
9021: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9022: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9023: p_project_currency_type => l_currency_type,

Line 9027: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9023: p_project_currency_type => l_currency_type,
9024: --p_amount_type_id => 150,
9025: p_amount_type_id => 165,
9026: p_period_number => 6);
9027: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9028: (p_period_profile_id => l_period_profile_id,
9029: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9030: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9031: p_project_currency_type => l_currency_type,

Line 9035: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9031: p_project_currency_type => l_currency_type,
9032: --p_amount_type_id => 150,
9033: p_amount_type_id => 165,
9034: p_period_number => 7);
9035: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9036: (p_period_profile_id => l_period_profile_id,
9037: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9038: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9039: p_project_currency_type => l_currency_type,

Line 9043: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9039: p_project_currency_type => l_currency_type,
9040: --p_amount_type_id => 150,
9041: p_amount_type_id => 165,
9042: p_period_number => 8);
9043: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9044: (p_period_profile_id => l_period_profile_id,
9045: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9046: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9047: p_project_currency_type => l_currency_type,

Line 9051: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9047: p_project_currency_type => l_currency_type,
9048: --p_amount_type_id => 150,
9049: p_amount_type_id => 165,
9050: p_period_number => 9);
9051: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9052: (p_period_profile_id => l_period_profile_id,
9053: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9054: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9055: p_project_currency_type => l_currency_type,

Line 9059: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9055: p_project_currency_type => l_currency_type,
9056: --p_amount_type_id => 150,
9057: p_amount_type_id => 165,
9058: p_period_number => 10);
9059: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9060: (p_period_profile_id => l_period_profile_id,
9061: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9062: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9063: p_project_currency_type => l_currency_type,

Line 9067: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9063: p_project_currency_type => l_currency_type,
9064: --p_amount_type_id => 150,
9065: p_amount_type_id => 165,
9066: p_period_number => 11);
9067: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9068: (p_period_profile_id => l_period_profile_id,
9069: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9070: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9071: p_project_currency_type => l_currency_type,

Line 9075: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9071: p_project_currency_type => l_currency_type,
9072: --p_amount_type_id => 150,
9073: p_amount_type_id => 165,
9074: p_period_number => 12);
9075: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9076: (p_period_profile_id => l_period_profile_id,
9077: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9078: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9079: p_project_currency_type => l_currency_type,

Line 9083: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9079: p_project_currency_type => l_currency_type,
9080: --p_amount_type_id => 150,
9081: p_amount_type_id => 165,
9082: p_period_number => 13);
9083: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9084: (p_period_profile_id => l_period_profile_id,
9085: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9086: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9087: p_project_currency_type => l_currency_type,

Line 9091: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9087: p_project_currency_type => l_currency_type,
9088: --p_amount_type_id => 150,
9089: p_amount_type_id => 165,
9090: p_period_number => 0);
9091: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9092: (p_period_profile_id => l_period_profile_id,
9093: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9094: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9095: p_project_currency_type => l_currency_type,

Line 9129: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9125: l_pd_has_child_element(l_row_number) := 'N';
9126: else
9127: l_pd_has_child_element(l_row_number) := 'Y';
9128: end if;
9129: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9130: (p_period_profile_id => l_period_profile_id,
9131: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9132: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9133: p_project_currency_type => l_currency_type,

Line 9137: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9133: p_project_currency_type => l_currency_type,
9134: --p_amount_type_id => 150,
9135: p_amount_type_id => 160,
9136: p_period_number => 1);
9137: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9138: (p_period_profile_id => l_period_profile_id,
9139: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9140: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9141: p_project_currency_type => l_currency_type,

Line 9145: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9141: p_project_currency_type => l_currency_type,
9142: --p_amount_type_id => 150,
9143: p_amount_type_id => 160,
9144: p_period_number => 2);
9145: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9146: (p_period_profile_id => l_period_profile_id,
9147: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9148: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9149: p_project_currency_type => l_currency_type,

Line 9153: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9149: p_project_currency_type => l_currency_type,
9150: --p_amount_type_id => 150,
9151: p_amount_type_id => 160,
9152: p_period_number => 3);
9153: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9154: (p_period_profile_id => l_period_profile_id,
9155: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9156: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9157: p_project_currency_type => l_currency_type,

Line 9161: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9157: p_project_currency_type => l_currency_type,
9158: --p_amount_type_id => 150,
9159: p_amount_type_id => 160,
9160: p_period_number => 4);
9161: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9162: (p_period_profile_id => l_period_profile_id,
9163: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9164: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9165: p_project_currency_type => l_currency_type,

Line 9169: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9165: p_project_currency_type => l_currency_type,
9166: --p_amount_type_id => 150,
9167: p_amount_type_id => 160,
9168: p_period_number => 5);
9169: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9170: (p_period_profile_id => l_period_profile_id,
9171: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9172: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9173: p_project_currency_type => l_currency_type,

Line 9177: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9173: p_project_currency_type => l_currency_type,
9174: --p_amount_type_id => 150,
9175: p_amount_type_id => 160,
9176: p_period_number => 6);
9177: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9178: (p_period_profile_id => l_period_profile_id,
9179: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9180: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9181: p_project_currency_type => l_currency_type,

Line 9185: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9181: p_project_currency_type => l_currency_type,
9182: --p_amount_type_id => 150,
9183: p_amount_type_id => 160,
9184: p_period_number => 7);
9185: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9186: (p_period_profile_id => l_period_profile_id,
9187: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9188: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9189: p_project_currency_type => l_currency_type,

Line 9193: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9189: p_project_currency_type => l_currency_type,
9190: --p_amount_type_id => 150,
9191: p_amount_type_id => 160,
9192: p_period_number => 8);
9193: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9194: (p_period_profile_id => l_period_profile_id,
9195: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9196: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9197: p_project_currency_type => l_currency_type,

Line 9201: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9197: p_project_currency_type => l_currency_type,
9198: --p_amount_type_id => 150,
9199: p_amount_type_id => 160,
9200: p_period_number => 9);
9201: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9202: (p_period_profile_id => l_period_profile_id,
9203: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9204: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9205: p_project_currency_type => l_currency_type,

Line 9209: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9205: p_project_currency_type => l_currency_type,
9206: --p_amount_type_id => 150,
9207: p_amount_type_id => 160,
9208: p_period_number => 10);
9209: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9210: (p_period_profile_id => l_period_profile_id,
9211: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9212: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9213: p_project_currency_type => l_currency_type,

Line 9217: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9213: p_project_currency_type => l_currency_type,
9214: --p_amount_type_id => 150,
9215: p_amount_type_id => 160,
9216: p_period_number => 11);
9217: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9218: (p_period_profile_id => l_period_profile_id,
9219: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9220: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9221: p_project_currency_type => l_currency_type,

Line 9225: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9221: p_project_currency_type => l_currency_type,
9222: --p_amount_type_id => 150,
9223: p_amount_type_id => 160,
9224: p_period_number => 12);
9225: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9226: (p_period_profile_id => l_period_profile_id,
9227: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9228: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9229: p_project_currency_type => l_currency_type,

Line 9233: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9229: p_project_currency_type => l_currency_type,
9230: --p_amount_type_id => 150,
9231: p_amount_type_id => 160,
9232: p_period_number => 13);
9233: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9234: (p_period_profile_id => l_period_profile_id,
9235: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9236: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9237: p_project_currency_type => l_currency_type,

Line 9241: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9237: p_project_currency_type => l_currency_type,
9238: --p_amount_type_id => 150,
9239: p_amount_type_id => 160,
9240: p_period_number => 0);
9241: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9242: (p_period_profile_id => l_period_profile_id,
9243: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9244: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9245: p_project_currency_type => l_currency_type,

Line 9687: pa_fp_view_plans_util.assign_element_name

9683: 0,
9684: 0,
9685: l_budget_version_id(1),
9686: -2,
9687: pa_fp_view_plans_util.assign_element_name
9688: (l_project_id(1),
9689: 0,
9690: 0) ,
9691: pa_fp_view_plans_util.assign_element_level

Line 9691: pa_fp_view_plans_util.assign_element_level

9687: pa_fp_view_plans_util.assign_element_name
9688: (l_project_id(1),
9689: 0,
9690: 0) ,
9691: pa_fp_view_plans_util.assign_element_level
9692: (l_project_id(1),
9693: l_budget_version_id(1),
9694: 0,
9695: 0),

Line 9703: pa_fp_view_plans_util.assign_row_level

9699: 0,
9700: 0, -- margin
9701: 0, -- margin_percent
9702: 'N', -- line_editable_flag
9703: pa_fp_view_plans_util.assign_row_level
9704: (l_project_id(1),
9705: 0,
9706: 0) ,
9707: pa_fp_view_plans_util.assign_parent_element

Line 9707: pa_fp_view_plans_util.assign_parent_element

9703: pa_fp_view_plans_util.assign_row_level
9704: (l_project_id(1),
9705: 0,
9706: 0) ,
9707: pa_fp_view_plans_util.assign_parent_element
9708: (l_project_id(1),
9709: 0,
9710: 0) ,
9711: l_unit_of_measure(1),

Line 9774: pa_fp_view_plans_util.assign_element_name

9770: task_rec.task_id,
9771: 0,
9772: l_budget_version_id(i),
9773: -2,
9774: pa_fp_view_plans_util.assign_element_name
9775: (l_project_id(i),
9776: task_rec.task_id,
9777: 0) ,
9778: pa_fp_view_plans_util.assign_element_level

Line 9778: pa_fp_view_plans_util.assign_element_level

9774: pa_fp_view_plans_util.assign_element_name
9775: (l_project_id(i),
9776: task_rec.task_id,
9777: 0) ,
9778: pa_fp_view_plans_util.assign_element_level
9779: (l_project_id(i),
9780: l_budget_version_id(i),
9781: task_rec.task_id,
9782: 0),

Line 9790: pa_fp_view_plans_util.assign_row_level

9786: l_revenue(i),
9787: 0, -- margin
9788: 0, -- margin_percent
9789: 'N', -- line_editable_flag
9790: pa_fp_view_plans_util.assign_row_level
9791: (l_project_id(i),
9792: task_rec.task_id,
9793: 0) ,
9794: pa_fp_view_plans_util.assign_parent_element

Line 9794: pa_fp_view_plans_util.assign_parent_element

9790: pa_fp_view_plans_util.assign_row_level
9791: (l_project_id(i),
9792: task_rec.task_id,
9793: 0) ,
9794: pa_fp_view_plans_util.assign_parent_element
9795: (l_project_id(i),
9796: task_rec.task_id,
9797: 0) ,
9798: l_unit_of_measure(i),

Line 9876: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9872: else
9873: l_pd_has_child_element(l_row_number) := 'Y';
9874: end if;
9875: if (l_report_labor_hrs_from_code = 'REVENUE') then
9876: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9877: (p_period_profile_id => l_period_profile_id,
9878: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9879: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9880: p_project_currency_type => l_currency_type,

Line 9883: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9879: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9880: p_project_currency_type => l_currency_type,
9881: p_amount_type_id => 215,
9882: p_period_number => 1);
9883: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9884: (p_period_profile_id => l_period_profile_id,
9885: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9886: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9887: p_project_currency_type => l_currency_type,

Line 9890: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9886: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9887: p_project_currency_type => l_currency_type,
9888: p_amount_type_id => 215,
9889: p_period_number => 2);
9890: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9891: (p_period_profile_id => l_period_profile_id,
9892: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9893: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9894: p_project_currency_type => l_currency_type,

Line 9897: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9893: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9894: p_project_currency_type => l_currency_type,
9895: p_amount_type_id => 215,
9896: p_period_number => 3);
9897: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9898: (p_period_profile_id => l_period_profile_id,
9899: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9900: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9901: p_project_currency_type => l_currency_type,

Line 9904: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9900: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9901: p_project_currency_type => l_currency_type,
9902: p_amount_type_id => 215,
9903: p_period_number => 4);
9904: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9905: (p_period_profile_id => l_period_profile_id,
9906: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9907: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9908: p_project_currency_type => l_currency_type,

Line 9911: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9907: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9908: p_project_currency_type => l_currency_type,
9909: p_amount_type_id => 215,
9910: p_period_number => 5);
9911: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9912: (p_period_profile_id => l_period_profile_id,
9913: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9914: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9915: p_project_currency_type => l_currency_type,

Line 9918: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9914: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9915: p_project_currency_type => l_currency_type,
9916: p_amount_type_id => 215,
9917: p_period_number => 6);
9918: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9919: (p_period_profile_id => l_period_profile_id,
9920: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9921: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9922: p_project_currency_type => l_currency_type,

Line 9925: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9921: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9922: p_project_currency_type => l_currency_type,
9923: p_amount_type_id => 215,
9924: p_period_number => 7);
9925: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9926: (p_period_profile_id => l_period_profile_id,
9927: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9928: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9929: p_project_currency_type => l_currency_type,

Line 9932: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9928: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9929: p_project_currency_type => l_currency_type,
9930: p_amount_type_id => 215,
9931: p_period_number => 8);
9932: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9933: (p_period_profile_id => l_period_profile_id,
9934: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9935: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9936: p_project_currency_type => l_currency_type,

Line 9939: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9935: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9936: p_project_currency_type => l_currency_type,
9937: p_amount_type_id => 215,
9938: p_period_number => 9);
9939: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9940: (p_period_profile_id => l_period_profile_id,
9941: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9942: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9943: p_project_currency_type => l_currency_type,

Line 9946: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9942: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9943: p_project_currency_type => l_currency_type,
9944: p_amount_type_id => 215,
9945: p_period_number => 10);
9946: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9947: (p_period_profile_id => l_period_profile_id,
9948: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9949: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9950: p_project_currency_type => l_currency_type,

Line 9953: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9949: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9950: p_project_currency_type => l_currency_type,
9951: p_amount_type_id => 215,
9952: p_period_number => 11);
9953: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9954: (p_period_profile_id => l_period_profile_id,
9955: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9956: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9957: p_project_currency_type => l_currency_type,

Line 9960: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9956: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9957: p_project_currency_type => l_currency_type,
9958: p_amount_type_id => 215,
9959: p_period_number => 12);
9960: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9961: (p_period_profile_id => l_period_profile_id,
9962: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9963: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9964: p_project_currency_type => l_currency_type,

Line 9967: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9963: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9964: p_project_currency_type => l_currency_type,
9965: p_amount_type_id => 215,
9966: p_period_number => 13);
9967: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9968: (p_period_profile_id => l_period_profile_id,
9969: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9970: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9971: p_project_currency_type => l_currency_type,

Line 9974: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

9970: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9971: p_project_currency_type => l_currency_type,
9972: p_amount_type_id => 215,
9973: p_period_number => 0);
9974: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
9975: (p_period_profile_id => l_period_profile_id,
9976: p_budget_version_id => l_pd_budget_version_id(l_row_number),
9977: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
9978: p_project_currency_type => l_currency_type,

Line 10032: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10028: l_pd_has_child_element(l_row_number) := 'N';
10029: else
10030: l_pd_has_child_element(l_row_number) := 'Y';
10031: end if;
10032: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10033: (p_period_profile_id => l_period_profile_id,
10034: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10035: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10036: p_project_currency_type => l_currency_type,

Line 10039: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10035: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10036: p_project_currency_type => l_currency_type,
10037: p_amount_type_id => 100,
10038: p_period_number => 1);
10039: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10040: (p_period_profile_id => l_period_profile_id,
10041: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10042: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10043: p_project_currency_type => l_currency_type,

Line 10046: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10042: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10043: p_project_currency_type => l_currency_type,
10044: p_amount_type_id => 100,
10045: p_period_number => 2);
10046: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10047: (p_period_profile_id => l_period_profile_id,
10048: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10049: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10050: p_project_currency_type => l_currency_type,

Line 10053: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10049: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10050: p_project_currency_type => l_currency_type,
10051: p_amount_type_id => 100,
10052: p_period_number => 3);
10053: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10054: (p_period_profile_id => l_period_profile_id,
10055: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10056: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10057: p_project_currency_type => l_currency_type,

Line 10060: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10056: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10057: p_project_currency_type => l_currency_type,
10058: p_amount_type_id => 100,
10059: p_period_number => 4);
10060: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10061: (p_period_profile_id => l_period_profile_id,
10062: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10063: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10064: p_project_currency_type => l_currency_type,

Line 10067: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10063: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10064: p_project_currency_type => l_currency_type,
10065: p_amount_type_id => 100,
10066: p_period_number => 5);
10067: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10068: (p_period_profile_id => l_period_profile_id,
10069: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10070: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10071: p_project_currency_type => l_currency_type,

Line 10074: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10070: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10071: p_project_currency_type => l_currency_type,
10072: p_amount_type_id => 100,
10073: p_period_number => 6);
10074: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10075: (p_period_profile_id => l_period_profile_id,
10076: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10077: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10078: p_project_currency_type => l_currency_type,

Line 10081: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10077: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10078: p_project_currency_type => l_currency_type,
10079: p_amount_type_id => 100,
10080: p_period_number => 7);
10081: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10082: (p_period_profile_id => l_period_profile_id,
10083: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10084: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10085: p_project_currency_type => l_currency_type,

Line 10088: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10084: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10085: p_project_currency_type => l_currency_type,
10086: p_amount_type_id => 100,
10087: p_period_number => 8);
10088: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10089: (p_period_profile_id => l_period_profile_id,
10090: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10091: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10092: p_project_currency_type => l_currency_type,

Line 10095: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10091: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10092: p_project_currency_type => l_currency_type,
10093: p_amount_type_id => 100,
10094: p_period_number => 9);
10095: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10096: (p_period_profile_id => l_period_profile_id,
10097: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10098: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10099: p_project_currency_type => l_currency_type,

Line 10102: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10098: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10099: p_project_currency_type => l_currency_type,
10100: p_amount_type_id => 100,
10101: p_period_number => 10);
10102: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10103: (p_period_profile_id => l_period_profile_id,
10104: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10105: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10106: p_project_currency_type => l_currency_type,

Line 10109: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10105: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10106: p_project_currency_type => l_currency_type,
10107: p_amount_type_id => 100,
10108: p_period_number => 11);
10109: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10110: (p_period_profile_id => l_period_profile_id,
10111: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10112: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10113: p_project_currency_type => l_currency_type,

Line 10116: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10112: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10113: p_project_currency_type => l_currency_type,
10114: p_amount_type_id => 100,
10115: p_period_number => 12);
10116: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10117: (p_period_profile_id => l_period_profile_id,
10118: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10119: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10120: p_project_currency_type => l_currency_type,

Line 10123: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10119: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10120: p_project_currency_type => l_currency_type,
10121: p_amount_type_id => 100,
10122: p_period_number => 13);
10123: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10124: (p_period_profile_id => l_period_profile_id,
10125: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10126: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10127: p_project_currency_type => l_currency_type,

Line 10130: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value

10126: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10127: p_project_currency_type => l_currency_type,
10128: p_amount_type_id => 100,
10129: p_period_number => 0);
10130: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
10131: (p_period_profile_id => l_period_profile_id,
10132: p_budget_version_id => l_pd_budget_version_id(l_row_number),
10133: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
10134: p_project_currency_type => l_currency_type,