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 746: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then

742: /*
743: -- **** if have TWO versions, may need to set x_primary_pp_bv_id ****
744: -- if p_orgfcst_version_id does not have a period_profile_id
745: if (x_time_phase_code <> 'N') and
746: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then
747: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then
748: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
749: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
750: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;

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

743: -- **** if have TWO versions, may need to set x_primary_pp_bv_id ****
744: -- if p_orgfcst_version_id does not have a period_profile_id
745: if (x_time_phase_code <> 'N') and
746: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then
747: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then
748: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
749: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
750: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
751: end if;

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

745: if (x_time_phase_code <> 'N') and
746: (pa_fp_view_plans_util.has_period_profile_id(p_orgfcst_version_id) = 'N') then
747: if pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' then
748: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
749: elsif pa_fp_view_plans_util.has_period_profile_id(pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
750: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
751: end if;
752: end if;
753: */

Line 2860: if (pa_fp_view_plans_util.check_compatible_pd_profiles

2856: into l_period_profile_id2
2857: from pa_budget_versions
2858: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2859: --hr_utility.trace('retrieved the period profile ids');
2860: if (pa_fp_view_plans_util.check_compatible_pd_profiles
2861: (p_period_profile_id1 => l_period_profile_id1,
2862: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
2863: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
2864: --hr_utility.trace('user_specified: period_profile matches');

Line 3114: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3110: select period_profile_id
3111: into l_period_profile_id2
3112: from pa_budget_versions
3113: where budget_version_id = l_compl_budget_version_id;
3114: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3115: (p_period_profile_id1 => l_period_profile_id1,
3116: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3117: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3118: --merge the COST and REVENUE versions

Line 3243: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3239: select period_profile_id
3240: into l_period_profile_id2
3241: from pa_budget_versions
3242: where budget_version_id = l_compl_budget_version_id;
3243: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3244: (p_period_profile_id1 => l_period_profile_id1,
3245: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3246: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3247: --merge the COST and REVENUE versions

Line 3375: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3371: select period_profile_id
3372: into l_period_profile_id2
3373: from pa_budget_versions
3374: where budget_version_id = l_compl_budget_version_id;
3375: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3376: (p_period_profile_id1 => l_period_profile_id1,
3377: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3378: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3379: --merge the COST and REVENUE versions

Line 3503: if (pa_fp_view_plans_util.check_compatible_pd_profiles

3499: select period_profile_id
3500: into l_period_profile_id2
3501: from pa_budget_versions
3502: where budget_version_id = l_compl_budget_version_id;
3503: if (pa_fp_view_plans_util.check_compatible_pd_profiles
3504: (p_period_profile_id1 => l_period_profile_id1,
3505: p_period_profile_id2 => l_period_profile_id2) = 'Y') or
3506: not (pa_fp_view_plans_pub.G_AMT_OR_PD = 'P') then
3507: --merge the COST and REVENUE versions

Line 3653: pa_fp_view_plans_util.assign_element_name

3649: ra.budget_version_id,
3650: ra.resource_assignment_id,
3651: -1 as revenue_budget_version_id, -- revenue_budget_version_id
3652: -1 as revenue_res_assignment_id, -- revenue_resource_assignment_id
3653: pa_fp_view_plans_util.assign_element_name
3654: (ra.project_id,
3655: ra.task_id,
3656: ra.resource_list_member_id) as element_name, -- element_name
3657: pa_fp_view_plans_util.assign_element_level

Line 3657: pa_fp_view_plans_util.assign_element_level

3653: pa_fp_view_plans_util.assign_element_name
3654: (ra.project_id,
3655: ra.task_id,
3656: ra.resource_list_member_id) as element_name, -- element_name
3657: pa_fp_view_plans_util.assign_element_level
3658: (ra.project_id,
3659: ra.budget_version_id,
3660: ra.task_id,
3661: ra.resource_list_member_id) as element_level, -- element_level

Line 3679: pa_fp_view_plans_util.assign_row_level

3675: DECODE(ra.resource_assignment_type,
3676: 'ROLLED_UP', 'N',
3677: 'USER_ENTERED', 'Y',
3678: 'Y') as line_editable_flag, -- line_editable_flag
3679: pa_fp_view_plans_util.assign_row_level
3680: (ra.project_id,
3681: ra.task_id,
3682: ra.resource_list_member_id) as row_level,
3683: pa_fp_view_plans_util.assign_parent_element

Line 3683: pa_fp_view_plans_util.assign_parent_element

3679: pa_fp_view_plans_util.assign_row_level
3680: (ra.project_id,
3681: ra.task_id,
3682: ra.resource_list_member_id) as row_level,
3683: pa_fp_view_plans_util.assign_parent_element
3684: (ra.project_id,
3685: ra.task_id,
3686: ra.resource_list_member_id) as parent_element_name,
3687: ra.unit_of_measure

Line 3704: pa_fp_view_plans_util.assign_element_name

3700: -1 as cost_budget_version_id, -- cost_budget_version_id
3701: -1 as cost_res_assignment_id, -- cost_resource_assignment_id
3702: ra.budget_version_id,
3703: ra.resource_assignment_id,
3704: pa_fp_view_plans_util.assign_element_name
3705: (ra.project_id,
3706: ra.task_id,
3707: ra.resource_list_member_id) as element_name, -- element_name
3708: pa_fp_view_plans_util.assign_element_level

Line 3708: pa_fp_view_plans_util.assign_element_level

3704: pa_fp_view_plans_util.assign_element_name
3705: (ra.project_id,
3706: ra.task_id,
3707: ra.resource_list_member_id) as element_name, -- element_name
3708: pa_fp_view_plans_util.assign_element_level
3709: (ra.project_id,
3710: ra.budget_version_id,
3711: ra.task_id,
3712: ra.resource_list_member_id) as element_level, -- element_level

Line 3728: pa_fp_view_plans_util.assign_row_level

3724: DECODE(ra.resource_assignment_type,
3725: 'ROLLED_UP', 'N',
3726: 'USER_ENTERED', 'Y',
3727: 'Y'), -- line_editable_flag
3728: pa_fp_view_plans_util.assign_row_level
3729: (ra.project_id,
3730: ra.task_id,
3731: ra.resource_list_member_id) as row_level,
3732: pa_fp_view_plans_util.assign_parent_element

Line 3732: pa_fp_view_plans_util.assign_parent_element

3728: pa_fp_view_plans_util.assign_row_level
3729: (ra.project_id,
3730: ra.task_id,
3731: ra.resource_list_member_id) as row_level,
3732: pa_fp_view_plans_util.assign_parent_element
3733: (ra.project_id,
3734: ra.task_id,
3735: ra.resource_list_member_id) as parent_element_name,
3736: ra.unit_of_measure

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

3998: l_pd_has_child_element(l_row_number) := 'N';
3999: else
4000: l_pd_has_child_element(l_row_number) := 'Y';
4001: end if;
4002: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4003: (p_period_profile_id => l_period_profile_id,
4004: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4005: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4006: p_project_currency_type => l_currency_type,

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

4007: p_amount_type_id => 215,
4008: p_period_number => 1);
4009: --hr_utility.trace('VALUE is = ' || to_char(l_pd_period_1(l_row_number)));
4010: --hr_utility.trace('get_period_n_value for period 2');
4011: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4012: (p_period_profile_id => l_period_profile_id,
4013: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4014: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4015: p_project_currency_type => l_currency_type,

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

4014: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4015: p_project_currency_type => l_currency_type,
4016: p_amount_type_id => 215,
4017: p_period_number => 2);
4018: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4019: (p_period_profile_id => l_period_profile_id,
4020: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4021: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4022: p_project_currency_type => l_currency_type,

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

4021: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4022: p_project_currency_type => l_currency_type,
4023: p_amount_type_id => 215,
4024: p_period_number => 3);
4025: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4026: (p_period_profile_id => l_period_profile_id,
4027: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4028: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4029: p_project_currency_type => l_currency_type,

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

4028: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4029: p_project_currency_type => l_currency_type,
4030: p_amount_type_id => 215,
4031: p_period_number => 4);
4032: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4033: (p_period_profile_id => l_period_profile_id,
4034: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4035: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4036: p_project_currency_type => l_currency_type,

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

4035: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4036: p_project_currency_type => l_currency_type,
4037: p_amount_type_id => 215,
4038: p_period_number => 5);
4039: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4040: (p_period_profile_id => l_period_profile_id,
4041: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4042: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4043: p_project_currency_type => l_currency_type,

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

4042: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4043: p_project_currency_type => l_currency_type,
4044: p_amount_type_id => 215,
4045: p_period_number => 6);
4046: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4047: (p_period_profile_id => l_period_profile_id,
4048: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4049: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4050: p_project_currency_type => l_currency_type,

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

4049: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4050: p_project_currency_type => l_currency_type,
4051: p_amount_type_id => 215,
4052: p_period_number => 7);
4053: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4054: (p_period_profile_id => l_period_profile_id,
4055: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4056: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4057: p_project_currency_type => l_currency_type,

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

4056: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4057: p_project_currency_type => l_currency_type,
4058: p_amount_type_id => 215,
4059: p_period_number => 8);
4060: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4061: (p_period_profile_id => l_period_profile_id,
4062: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4063: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4064: p_project_currency_type => l_currency_type,

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

4063: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4064: p_project_currency_type => l_currency_type,
4065: p_amount_type_id => 215,
4066: p_period_number => 9);
4067: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4068: (p_period_profile_id => l_period_profile_id,
4069: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4070: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4071: p_project_currency_type => l_currency_type,

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

4070: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4071: p_project_currency_type => l_currency_type,
4072: p_amount_type_id => 215,
4073: p_period_number => 10);
4074: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4075: (p_period_profile_id => l_period_profile_id,
4076: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4077: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4078: p_project_currency_type => l_currency_type,

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

4077: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4078: p_project_currency_type => l_currency_type,
4079: p_amount_type_id => 215,
4080: p_period_number => 11);
4081: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4082: (p_period_profile_id => l_period_profile_id,
4083: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4084: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4085: p_project_currency_type => l_currency_type,

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

4084: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4085: p_project_currency_type => l_currency_type,
4086: p_amount_type_id => 215,
4087: p_period_number => 12);
4088: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4089: (p_period_profile_id => l_period_profile_id,
4090: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4091: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4092: p_project_currency_type => l_currency_type,

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

4091: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4092: p_project_currency_type => l_currency_type,
4093: p_amount_type_id => 215,
4094: p_period_number => 13);
4095: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4096: (p_period_profile_id => l_period_profile_id,
4097: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4098: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4099: p_project_currency_type => l_currency_type,

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

4098: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4099: p_project_currency_type => l_currency_type,
4100: p_amount_type_id => 215,
4101: p_period_number => 0);
4102: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4103: (p_period_profile_id => l_period_profile_id,
4104: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4105: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4106: p_project_currency_type => l_currency_type,

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

4148: l_pd_has_child_element(l_row_number) := 'N';
4149: else
4150: l_pd_has_child_element(l_row_number) := 'Y';
4151: end if;
4152: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4153: (p_period_profile_id => l_period_profile_id,
4154: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4155: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4156: p_project_currency_type => l_currency_type,

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

4157: --p_amount_type_id => 150,
4158: p_amount_type_id => 165,
4159: p_period_number => 1);
4160: --hr_utility.trace('VALUE is = ' || to_char(l_pd_period_1(l_row_number)));
4161: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4162: (p_period_profile_id => l_period_profile_id,
4163: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4164: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4165: p_project_currency_type => l_currency_type,

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

4165: p_project_currency_type => l_currency_type,
4166: --p_amount_type_id => 150,
4167: p_amount_type_id => 165,
4168: p_period_number => 2);
4169: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4170: (p_period_profile_id => l_period_profile_id,
4171: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4172: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4173: p_project_currency_type => l_currency_type,

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

4173: p_project_currency_type => l_currency_type,
4174: --p_amount_type_id => 150,
4175: p_amount_type_id => 165,
4176: p_period_number => 3);
4177: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4178: (p_period_profile_id => l_period_profile_id,
4179: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4180: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4181: p_project_currency_type => l_currency_type,

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

4181: p_project_currency_type => l_currency_type,
4182: --p_amount_type_id => 150,
4183: p_amount_type_id => 165,
4184: p_period_number => 4);
4185: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4186: (p_period_profile_id => l_period_profile_id,
4187: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4188: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4189: p_project_currency_type => l_currency_type,

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

4189: p_project_currency_type => l_currency_type,
4190: --p_amount_type_id => 150,
4191: p_amount_type_id => 165,
4192: p_period_number => 5);
4193: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4194: (p_period_profile_id => l_period_profile_id,
4195: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4196: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4197: p_project_currency_type => l_currency_type,

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

4197: p_project_currency_type => l_currency_type,
4198: --p_amount_type_id => 150,
4199: p_amount_type_id => 165,
4200: p_period_number => 6);
4201: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4202: (p_period_profile_id => l_period_profile_id,
4203: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4204: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4205: p_project_currency_type => l_currency_type,

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

4205: p_project_currency_type => l_currency_type,
4206: --p_amount_type_id => 150,
4207: p_amount_type_id => 165,
4208: p_period_number => 7);
4209: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4210: (p_period_profile_id => l_period_profile_id,
4211: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4212: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4213: p_project_currency_type => l_currency_type,

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

4213: p_project_currency_type => l_currency_type,
4214: --p_amount_type_id => 150,
4215: p_amount_type_id => 165,
4216: p_period_number => 8);
4217: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4218: (p_period_profile_id => l_period_profile_id,
4219: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4220: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4221: p_project_currency_type => l_currency_type,

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

4221: p_project_currency_type => l_currency_type,
4222: --p_amount_type_id => 150,
4223: p_amount_type_id => 165,
4224: p_period_number => 9);
4225: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4226: (p_period_profile_id => l_period_profile_id,
4227: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4228: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4229: p_project_currency_type => l_currency_type,

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

4229: p_project_currency_type => l_currency_type,
4230: --p_amount_type_id => 150,
4231: p_amount_type_id => 165,
4232: p_period_number => 10);
4233: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4234: (p_period_profile_id => l_period_profile_id,
4235: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4236: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4237: p_project_currency_type => l_currency_type,

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

4237: p_project_currency_type => l_currency_type,
4238: --p_amount_type_id => 150,
4239: p_amount_type_id => 165,
4240: p_period_number => 11);
4241: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4242: (p_period_profile_id => l_period_profile_id,
4243: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4244: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4245: p_project_currency_type => l_currency_type,

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

4245: p_project_currency_type => l_currency_type,
4246: --p_amount_type_id => 150,
4247: p_amount_type_id => 165,
4248: p_period_number => 12);
4249: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4250: (p_period_profile_id => l_period_profile_id,
4251: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4252: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4253: p_project_currency_type => l_currency_type,

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

4253: p_project_currency_type => l_currency_type,
4254: --p_amount_type_id => 150,
4255: p_amount_type_id => 165,
4256: p_period_number => 13);
4257: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4258: (p_period_profile_id => l_period_profile_id,
4259: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4260: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4261: p_project_currency_type => l_currency_type,

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

4261: p_project_currency_type => l_currency_type,
4262: --p_amount_type_id => 150,
4263: p_amount_type_id => 165,
4264: p_period_number => 0);
4265: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4266: (p_period_profile_id => l_period_profile_id,
4267: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4268: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4269: p_project_currency_type => l_currency_type,

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

4311: l_pd_has_child_element(l_row_number) := 'N';
4312: else
4313: l_pd_has_child_element(l_row_number) := 'Y';
4314: end if;
4315: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4316: (p_period_profile_id => l_period_profile_id,
4317: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4318: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4319: p_project_currency_type => l_currency_type,

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

4319: p_project_currency_type => l_currency_type,
4320: --p_amount_type_id => 150,
4321: p_amount_type_id => 160,
4322: p_period_number => 1);
4323: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4324: (p_period_profile_id => l_period_profile_id,
4325: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4326: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4327: p_project_currency_type => l_currency_type,

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

4327: p_project_currency_type => l_currency_type,
4328: --p_amount_type_id => 150,
4329: p_amount_type_id => 160,
4330: p_period_number => 2);
4331: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4332: (p_period_profile_id => l_period_profile_id,
4333: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4334: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4335: p_project_currency_type => l_currency_type,

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

4335: p_project_currency_type => l_currency_type,
4336: --p_amount_type_id => 150,
4337: p_amount_type_id => 160,
4338: p_period_number => 3);
4339: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4340: (p_period_profile_id => l_period_profile_id,
4341: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4342: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4343: p_project_currency_type => l_currency_type,

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

4343: p_project_currency_type => l_currency_type,
4344: --p_amount_type_id => 150,
4345: p_amount_type_id => 160,
4346: p_period_number => 4);
4347: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4348: (p_period_profile_id => l_period_profile_id,
4349: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4350: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4351: p_project_currency_type => l_currency_type,

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

4351: p_project_currency_type => l_currency_type,
4352: --p_amount_type_id => 150,
4353: p_amount_type_id => 160,
4354: p_period_number => 5);
4355: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4356: (p_period_profile_id => l_period_profile_id,
4357: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4358: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4359: p_project_currency_type => l_currency_type,

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

4359: p_project_currency_type => l_currency_type,
4360: --p_amount_type_id => 150,
4361: p_amount_type_id => 160,
4362: p_period_number => 6);
4363: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4364: (p_period_profile_id => l_period_profile_id,
4365: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4366: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4367: p_project_currency_type => l_currency_type,

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

4367: p_project_currency_type => l_currency_type,
4368: --p_amount_type_id => 150,
4369: p_amount_type_id => 160,
4370: p_period_number => 7);
4371: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4372: (p_period_profile_id => l_period_profile_id,
4373: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4374: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4375: p_project_currency_type => l_currency_type,

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

4375: p_project_currency_type => l_currency_type,
4376: --p_amount_type_id => 150,
4377: p_amount_type_id => 160,
4378: p_period_number => 8);
4379: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4380: (p_period_profile_id => l_period_profile_id,
4381: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4382: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4383: p_project_currency_type => l_currency_type,

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

4383: p_project_currency_type => l_currency_type,
4384: --p_amount_type_id => 150,
4385: p_amount_type_id => 160,
4386: p_period_number => 9);
4387: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4388: (p_period_profile_id => l_period_profile_id,
4389: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4390: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4391: p_project_currency_type => l_currency_type,

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

4391: p_project_currency_type => l_currency_type,
4392: --p_amount_type_id => 150,
4393: p_amount_type_id => 160,
4394: p_period_number => 10);
4395: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4396: (p_period_profile_id => l_period_profile_id,
4397: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4398: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4399: p_project_currency_type => l_currency_type,

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

4399: p_project_currency_type => l_currency_type,
4400: --p_amount_type_id => 150,
4401: p_amount_type_id => 160,
4402: p_period_number => 11);
4403: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4404: (p_period_profile_id => l_period_profile_id,
4405: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4406: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4407: p_project_currency_type => l_currency_type,

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

4407: p_project_currency_type => l_currency_type,
4408: --p_amount_type_id => 150,
4409: p_amount_type_id => 160,
4410: p_period_number => 12);
4411: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4412: (p_period_profile_id => l_period_profile_id,
4413: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4414: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4415: p_project_currency_type => l_currency_type,

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

4415: p_project_currency_type => l_currency_type,
4416: --p_amount_type_id => 150,
4417: p_amount_type_id => 160,
4418: p_period_number => 13);
4419: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4420: (p_period_profile_id => l_period_profile_id,
4421: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4422: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4423: p_project_currency_type => l_currency_type,

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

4423: p_project_currency_type => l_currency_type,
4424: --p_amount_type_id => 150,
4425: p_amount_type_id => 160,
4426: p_period_number => 0);
4427: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4428: (p_period_profile_id => l_period_profile_id,
4429: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4430: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4431: p_project_currency_type => l_currency_type,

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

4467: l_pd_has_child_element(l_row_number) := 'N';
4468: else
4469: l_pd_has_child_element(l_row_number) := 'Y';
4470: end if;
4471: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4472: (p_period_profile_id => l_period_profile_id,
4473: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4474: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4475: p_project_currency_type => l_currency_type,

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

4474: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4475: p_project_currency_type => l_currency_type,
4476: p_amount_type_id => 215,
4477: p_period_number => 1);
4478: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4479: (p_period_profile_id => l_period_profile_id,
4480: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4481: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4482: p_project_currency_type => l_currency_type,

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

4481: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4482: p_project_currency_type => l_currency_type,
4483: p_amount_type_id => 215,
4484: p_period_number => 1);
4485: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4486: (p_period_profile_id => l_period_profile_id,
4487: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4488: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4489: p_project_currency_type => l_currency_type,

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

4488: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4489: p_project_currency_type => l_currency_type,
4490: p_amount_type_id => 215,
4491: p_period_number => 2);
4492: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4493: (p_period_profile_id => l_period_profile_id,
4494: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4495: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4496: p_project_currency_type => l_currency_type,

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

4495: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4496: p_project_currency_type => l_currency_type,
4497: p_amount_type_id => 215,
4498: p_period_number => 3);
4499: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4500: (p_period_profile_id => l_period_profile_id,
4501: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4502: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4503: p_project_currency_type => l_currency_type,

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

4502: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4503: p_project_currency_type => l_currency_type,
4504: p_amount_type_id => 215,
4505: p_period_number => 4);
4506: l_pd_period_5(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_revenue_budget_version_id(l_row_number),
4509: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4510: p_project_currency_type => l_currency_type,

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

4509: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4510: p_project_currency_type => l_currency_type,
4511: p_amount_type_id => 215,
4512: p_period_number => 5);
4513: l_pd_period_6(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_revenue_budget_version_id(l_row_number),
4516: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4517: p_project_currency_type => l_currency_type,

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

4516: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4517: p_project_currency_type => l_currency_type,
4518: p_amount_type_id => 215,
4519: p_period_number => 6);
4520: l_pd_period_7(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_revenue_budget_version_id(l_row_number),
4523: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4524: p_project_currency_type => l_currency_type,

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

4523: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4524: p_project_currency_type => l_currency_type,
4525: p_amount_type_id => 215,
4526: p_period_number => 7);
4527: l_pd_period_8(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_revenue_budget_version_id(l_row_number),
4530: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4531: p_project_currency_type => l_currency_type,

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

4530: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4531: p_project_currency_type => l_currency_type,
4532: p_amount_type_id => 215,
4533: p_period_number => 8);
4534: l_pd_period_9(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_revenue_budget_version_id(l_row_number),
4537: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4538: p_project_currency_type => l_currency_type,

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

4537: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4538: p_project_currency_type => l_currency_type,
4539: p_amount_type_id => 215,
4540: p_period_number => 9);
4541: l_pd_period_10(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_revenue_budget_version_id(l_row_number),
4544: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4545: p_project_currency_type => l_currency_type,

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

4544: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4545: p_project_currency_type => l_currency_type,
4546: p_amount_type_id => 215,
4547: p_period_number => 10);
4548: l_pd_period_11(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_revenue_budget_version_id(l_row_number),
4551: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4552: p_project_currency_type => l_currency_type,

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

4551: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4552: p_project_currency_type => l_currency_type,
4553: p_amount_type_id => 215,
4554: p_period_number => 11);
4555: l_pd_period_12(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_revenue_budget_version_id(l_row_number),
4558: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4559: p_project_currency_type => l_currency_type,

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

4558: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4559: p_project_currency_type => l_currency_type,
4560: p_amount_type_id => 215,
4561: p_period_number => 12);
4562: l_pd_period_13(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_revenue_budget_version_id(l_row_number),
4565: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4566: p_project_currency_type => l_currency_type,

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

4565: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4566: p_project_currency_type => l_currency_type,
4567: p_amount_type_id => 215,
4568: p_period_number => 13);
4569: l_pd_preceding(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_revenue_budget_version_id(l_row_number),
4572: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4573: p_project_currency_type => l_currency_type,

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

4572: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4573: p_project_currency_type => l_currency_type,
4574: p_amount_type_id => 215,
4575: p_period_number => 0);
4576: l_pd_succeeding(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_revenue_budget_version_id(l_row_number),
4579: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4580: p_project_currency_type => l_currency_type,

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

4614: l_pd_has_child_element(l_row_number) := 'N';
4615: else
4616: l_pd_has_child_element(l_row_number) := 'Y';
4617: end if;
4618: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4619: (p_period_profile_id => l_period_profile_id,
4620: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4621: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4622: p_project_currency_type => l_currency_type,

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

4621: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4622: p_project_currency_type => l_currency_type,
4623: p_amount_type_id => 100,
4624: p_period_number => 1);
4625: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4626: (p_period_profile_id => l_period_profile_id,
4627: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4628: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4629: p_project_currency_type => l_currency_type,

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

4628: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4629: p_project_currency_type => l_currency_type,
4630: p_amount_type_id => 100,
4631: p_period_number => 2);
4632: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4633: (p_period_profile_id => l_period_profile_id,
4634: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4635: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4636: p_project_currency_type => l_currency_type,

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

4635: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4636: p_project_currency_type => l_currency_type,
4637: p_amount_type_id => 100,
4638: p_period_number => 3);
4639: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4640: (p_period_profile_id => l_period_profile_id,
4641: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4642: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4643: p_project_currency_type => l_currency_type,

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

4642: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4643: p_project_currency_type => l_currency_type,
4644: p_amount_type_id => 100,
4645: p_period_number => 4);
4646: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4647: (p_period_profile_id => l_period_profile_id,
4648: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4649: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4650: p_project_currency_type => l_currency_type,

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

4649: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4650: p_project_currency_type => l_currency_type,
4651: p_amount_type_id => 100,
4652: p_period_number => 5);
4653: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4654: (p_period_profile_id => l_period_profile_id,
4655: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4656: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4657: p_project_currency_type => l_currency_type,

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

4656: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4657: p_project_currency_type => l_currency_type,
4658: p_amount_type_id => 100,
4659: p_period_number => 6);
4660: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4661: (p_period_profile_id => l_period_profile_id,
4662: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4663: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4664: p_project_currency_type => l_currency_type,

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

4663: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4664: p_project_currency_type => l_currency_type,
4665: p_amount_type_id => 100,
4666: p_period_number => 7);
4667: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4668: (p_period_profile_id => l_period_profile_id,
4669: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4670: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4671: p_project_currency_type => l_currency_type,

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

4670: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4671: p_project_currency_type => l_currency_type,
4672: p_amount_type_id => 100,
4673: p_period_number => 8);
4674: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4675: (p_period_profile_id => l_period_profile_id,
4676: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4677: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4678: p_project_currency_type => l_currency_type,

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

4677: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4678: p_project_currency_type => l_currency_type,
4679: p_amount_type_id => 100,
4680: p_period_number => 9);
4681: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4682: (p_period_profile_id => l_period_profile_id,
4683: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4684: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4685: p_project_currency_type => l_currency_type,

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

4684: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4685: p_project_currency_type => l_currency_type,
4686: p_amount_type_id => 100,
4687: p_period_number => 10);
4688: l_pd_period_11(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_revenue_budget_version_id(l_row_number),
4691: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4692: p_project_currency_type => l_currency_type,

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

4691: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4692: p_project_currency_type => l_currency_type,
4693: p_amount_type_id => 100,
4694: p_period_number => 11);
4695: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4696: (p_period_profile_id => l_period_profile_id,
4697: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4698: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4699: p_project_currency_type => l_currency_type,

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

4698: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4699: p_project_currency_type => l_currency_type,
4700: p_amount_type_id => 100,
4701: p_period_number => 12);
4702: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4703: (p_period_profile_id => l_period_profile_id,
4704: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4705: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4706: p_project_currency_type => l_currency_type,

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

4705: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4706: p_project_currency_type => l_currency_type,
4707: p_amount_type_id => 100,
4708: p_period_number => 13);
4709: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4710: (p_period_profile_id => l_period_profile_id,
4711: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4712: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4713: p_project_currency_type => l_currency_type,

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

4712: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4713: p_project_currency_type => l_currency_type,
4714: p_amount_type_id => 100,
4715: p_period_number => 0);
4716: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4717: (p_period_profile_id => l_period_profile_id,
4718: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
4719: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
4720: p_project_currency_type => l_currency_type,

Line 4807: 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));

4803: l_pd_has_child_element(l_row_number) := 'N';
4804: else
4805: l_pd_has_child_element(l_row_number) := 'Y';
4806: end if;
4807: 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));
4808: 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));
4809: 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));
4810: 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));
4811: 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 4808: 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));

4804: else
4805: l_pd_has_child_element(l_row_number) := 'Y';
4806: end if;
4807: 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));
4808: 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));
4809: 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));
4810: 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));
4811: 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));
4812: 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 4809: 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));

4805: l_pd_has_child_element(l_row_number) := 'Y';
4806: end if;
4807: 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));
4808: 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));
4809: 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));
4810: 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));
4811: 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));
4812: 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));
4813: 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 4810: 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));

4806: end if;
4807: 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));
4808: 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));
4809: 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));
4810: 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));
4811: 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));
4812: 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));
4813: 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));
4814: 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 4811: 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));

4807: 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));
4808: 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));
4809: 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));
4810: 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));
4811: 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));
4812: 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));
4813: 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));
4814: 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));
4815: 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 4812: 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));

4808: 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));
4809: 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));
4810: 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));
4811: 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));
4812: 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));
4813: 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));
4814: 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));
4815: 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));
4816: 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 4813: 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));

4809: 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));
4810: 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));
4811: 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));
4812: 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));
4813: 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));
4814: 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));
4815: 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));
4816: 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));
4817: 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 4814: 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));

4810: 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));
4811: 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));
4812: 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));
4813: 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));
4814: 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));
4815: 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));
4816: 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));
4817: 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));
4818: 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 4815: 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));

4811: 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));
4812: 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));
4813: 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));
4814: 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));
4815: 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));
4816: 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));
4817: 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));
4818: 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));
4819: 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 4816: 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));

4812: 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));
4813: 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));
4814: 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));
4815: 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));
4816: 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));
4817: 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));
4818: 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));
4819: 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));
4820: 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 4817: 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));

4813: 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));
4814: 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));
4815: 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));
4816: 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));
4817: 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));
4818: 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));
4819: 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));
4820: 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));
4821: 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 4818: 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));

4814: 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));
4815: 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));
4816: 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));
4817: 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));
4818: 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));
4819: 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));
4820: 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));
4821: 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));
4822: 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 4819: 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));

4815: 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));
4816: 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));
4817: 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));
4818: 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));
4819: 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));
4820: 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));
4821: 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));
4822: 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
4823: end if; -- display_flag: MARGIN PERCENT

Line 4820: 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));

4816: 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));
4817: 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));
4818: 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));
4819: 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));
4820: 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));
4821: 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));
4822: 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
4823: end if; -- display_flag: MARGIN PERCENT
4824: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'

Line 4821: 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));

4817: 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));
4818: 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));
4819: 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));
4820: 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));
4821: 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));
4822: 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
4823: end if; -- display_flag: MARGIN PERCENT
4824: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
4825: /*

Line 4822: 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

4818: 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));
4819: 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));
4820: 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));
4821: 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));
4822: 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
4823: end if; -- display_flag: MARGIN PERCENT
4824: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
4825: /*
4826: l_r_project_id.delete(j);

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

4940: l_pd_has_child_element(l_row_number) := 'N';
4941: else
4942: l_pd_has_child_element(l_row_number) := 'Y';
4943: end if;
4944: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4945: (p_period_profile_id => l_period_profile_id,
4946: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4947: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4948: p_project_currency_type => l_currency_type,

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

4947: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4948: p_project_currency_type => l_currency_type,
4949: p_amount_type_id => 215,
4950: p_period_number => 1);
4951: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4952: (p_period_profile_id => l_period_profile_id,
4953: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4954: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4955: p_project_currency_type => l_currency_type,

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

4954: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4955: p_project_currency_type => l_currency_type,
4956: p_amount_type_id => 215,
4957: p_period_number => 2);
4958: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4959: (p_period_profile_id => l_period_profile_id,
4960: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4961: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4962: p_project_currency_type => l_currency_type,

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

4961: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4962: p_project_currency_type => l_currency_type,
4963: p_amount_type_id => 215,
4964: p_period_number => 3);
4965: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4966: (p_period_profile_id => l_period_profile_id,
4967: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4968: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4969: p_project_currency_type => l_currency_type,

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

4968: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4969: p_project_currency_type => l_currency_type,
4970: p_amount_type_id => 215,
4971: p_period_number => 4);
4972: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4973: (p_period_profile_id => l_period_profile_id,
4974: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4975: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4976: p_project_currency_type => l_currency_type,

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

4975: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4976: p_project_currency_type => l_currency_type,
4977: p_amount_type_id => 215,
4978: p_period_number => 5);
4979: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4980: (p_period_profile_id => l_period_profile_id,
4981: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4982: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4983: p_project_currency_type => l_currency_type,

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

4982: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4983: p_project_currency_type => l_currency_type,
4984: p_amount_type_id => 215,
4985: p_period_number => 6);
4986: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4987: (p_period_profile_id => l_period_profile_id,
4988: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4989: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4990: p_project_currency_type => l_currency_type,

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

4989: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4990: p_project_currency_type => l_currency_type,
4991: p_amount_type_id => 215,
4992: p_period_number => 7);
4993: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
4994: (p_period_profile_id => l_period_profile_id,
4995: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
4996: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4997: p_project_currency_type => l_currency_type,

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

4996: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
4997: p_project_currency_type => l_currency_type,
4998: p_amount_type_id => 215,
4999: p_period_number => 8);
5000: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5001: (p_period_profile_id => l_period_profile_id,
5002: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5003: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5004: p_project_currency_type => l_currency_type,

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

5003: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5004: p_project_currency_type => l_currency_type,
5005: p_amount_type_id => 215,
5006: p_period_number => 9);
5007: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5008: (p_period_profile_id => l_period_profile_id,
5009: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5010: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5011: p_project_currency_type => l_currency_type,

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

5010: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5011: p_project_currency_type => l_currency_type,
5012: p_amount_type_id => 215,
5013: p_period_number => 10);
5014: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5015: (p_period_profile_id => l_period_profile_id,
5016: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5017: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5018: p_project_currency_type => l_currency_type,

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

5017: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5018: p_project_currency_type => l_currency_type,
5019: p_amount_type_id => 215,
5020: p_period_number => 11);
5021: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5022: (p_period_profile_id => l_period_profile_id,
5023: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5024: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5025: p_project_currency_type => l_currency_type,

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

5024: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5025: p_project_currency_type => l_currency_type,
5026: p_amount_type_id => 215,
5027: p_period_number => 12);
5028: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5029: (p_period_profile_id => l_period_profile_id,
5030: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5031: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5032: p_project_currency_type => l_currency_type,

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

5031: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5032: p_project_currency_type => l_currency_type,
5033: p_amount_type_id => 215,
5034: p_period_number => 13);
5035: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5036: (p_period_profile_id => l_period_profile_id,
5037: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5038: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5039: p_project_currency_type => l_currency_type,

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

5038: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5039: p_project_currency_type => l_currency_type,
5040: p_amount_type_id => 215,
5041: p_period_number => 0);
5042: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5043: (p_period_profile_id => l_period_profile_id,
5044: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5045: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5046: p_project_currency_type => l_currency_type,

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

5124: l_pd_has_child_element(l_row_number) := 'N';
5125: else
5126: l_pd_has_child_element(l_row_number) := 'Y';
5127: end if;
5128: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5129: (p_period_profile_id => l_period_profile_id,
5130: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5131: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5132: p_project_currency_type => l_currency_type,

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

5131: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5132: p_project_currency_type => l_currency_type,
5133: p_amount_type_id => 165,
5134: p_period_number => 1);
5135: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5136: (p_period_profile_id => l_period_profile_id,
5137: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5138: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5139: p_project_currency_type => l_currency_type,

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

5138: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5139: p_project_currency_type => l_currency_type,
5140: p_amount_type_id => 165,
5141: p_period_number => 2);
5142: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5143: (p_period_profile_id => l_period_profile_id,
5144: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5145: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5146: p_project_currency_type => l_currency_type,

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

5145: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5146: p_project_currency_type => l_currency_type,
5147: p_amount_type_id => 165,
5148: p_period_number => 3);
5149: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5150: (p_period_profile_id => l_period_profile_id,
5151: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5152: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5153: p_project_currency_type => l_currency_type,

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

5152: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5153: p_project_currency_type => l_currency_type,
5154: p_amount_type_id => 165,
5155: p_period_number => 4);
5156: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5157: (p_period_profile_id => l_period_profile_id,
5158: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5159: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5160: p_project_currency_type => l_currency_type,

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

5160: p_project_currency_type => l_currency_type,
5161: --p_amount_type_id => 150,
5162: p_amount_type_id => 165,
5163: p_period_number => 5);
5164: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5165: (p_period_profile_id => l_period_profile_id,
5166: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5167: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5168: p_project_currency_type => l_currency_type,

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

5167: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5168: p_project_currency_type => l_currency_type,
5169: p_amount_type_id => 165,
5170: p_period_number => 6);
5171: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5172: (p_period_profile_id => l_period_profile_id,
5173: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5174: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5175: p_project_currency_type => l_currency_type,

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

5174: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5175: p_project_currency_type => l_currency_type,
5176: p_amount_type_id => 165,
5177: p_period_number => 7);
5178: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5179: (p_period_profile_id => l_period_profile_id,
5180: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5181: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5182: p_project_currency_type => l_currency_type,

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

5181: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5182: p_project_currency_type => l_currency_type,
5183: p_amount_type_id => 165,
5184: p_period_number => 8);
5185: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5186: (p_period_profile_id => l_period_profile_id,
5187: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5188: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5189: p_project_currency_type => l_currency_type,

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

5188: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5189: p_project_currency_type => l_currency_type,
5190: p_amount_type_id => 165,
5191: p_period_number => 9);
5192: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5193: (p_period_profile_id => l_period_profile_id,
5194: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5195: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5196: p_project_currency_type => l_currency_type,

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

5195: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5196: p_project_currency_type => l_currency_type,
5197: p_amount_type_id => 165,
5198: p_period_number => 10);
5199: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5200: (p_period_profile_id => l_period_profile_id,
5201: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5202: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5203: p_project_currency_type => l_currency_type,

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

5202: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5203: p_project_currency_type => l_currency_type,
5204: p_amount_type_id => 165,
5205: p_period_number => 11);
5206: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5207: (p_period_profile_id => l_period_profile_id,
5208: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5209: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5210: p_project_currency_type => l_currency_type,

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

5209: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5210: p_project_currency_type => l_currency_type,
5211: p_amount_type_id => 165,
5212: p_period_number => 12);
5213: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5214: (p_period_profile_id => l_period_profile_id,
5215: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5216: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5217: p_project_currency_type => l_currency_type,

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

5216: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5217: p_project_currency_type => l_currency_type,
5218: p_amount_type_id => 165,
5219: p_period_number => 13);
5220: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5221: (p_period_profile_id => l_period_profile_id,
5222: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5223: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5224: p_project_currency_type => l_currency_type,

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

5223: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5224: p_project_currency_type => l_currency_type,
5225: p_amount_type_id => 165,
5226: p_period_number => 0);
5227: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5228: (p_period_profile_id => l_period_profile_id,
5229: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5230: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5231: p_project_currency_type => l_currency_type,

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

5262: l_pd_has_child_element(l_row_number) := 'N';
5263: else
5264: l_pd_has_child_element(l_row_number) := 'Y';
5265: end if;
5266: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5267: (p_period_profile_id => l_period_profile_id,
5268: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5269: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5270: p_project_currency_type => l_currency_type,

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

5269: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5270: p_project_currency_type => l_currency_type,
5271: p_amount_type_id => 160,
5272: p_period_number => 1);
5273: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5274: (p_period_profile_id => l_period_profile_id,
5275: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5276: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5277: p_project_currency_type => l_currency_type,

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

5276: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5277: p_project_currency_type => l_currency_type,
5278: p_amount_type_id => 160,
5279: p_period_number => 2);
5280: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5281: (p_period_profile_id => l_period_profile_id,
5282: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5283: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5284: p_project_currency_type => l_currency_type,

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

5283: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5284: p_project_currency_type => l_currency_type,
5285: p_amount_type_id => 160,
5286: p_period_number => 3);
5287: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5288: (p_period_profile_id => l_period_profile_id,
5289: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5290: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5291: p_project_currency_type => l_currency_type,

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

5290: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5291: p_project_currency_type => l_currency_type,
5292: p_amount_type_id => 160,
5293: p_period_number => 4);
5294: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5295: (p_period_profile_id => l_period_profile_id,
5296: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5297: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5298: p_project_currency_type => l_currency_type,

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

5297: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5298: p_project_currency_type => l_currency_type,
5299: p_amount_type_id => 160,
5300: p_period_number => 5);
5301: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5302: (p_period_profile_id => l_period_profile_id,
5303: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5304: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5305: p_project_currency_type => l_currency_type,

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

5304: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5305: p_project_currency_type => l_currency_type,
5306: p_amount_type_id => 160,
5307: p_period_number => 6);
5308: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5309: (p_period_profile_id => l_period_profile_id,
5310: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5311: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5312: p_project_currency_type => l_currency_type,

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

5311: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5312: p_project_currency_type => l_currency_type,
5313: p_amount_type_id => 160,
5314: p_period_number => 7);
5315: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5316: (p_period_profile_id => l_period_profile_id,
5317: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5318: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5319: p_project_currency_type => l_currency_type,

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

5318: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5319: p_project_currency_type => l_currency_type,
5320: p_amount_type_id => 160,
5321: p_period_number => 8);
5322: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5323: (p_period_profile_id => l_period_profile_id,
5324: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5325: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5326: p_project_currency_type => l_currency_type,

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

5325: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5326: p_project_currency_type => l_currency_type,
5327: p_amount_type_id => 160,
5328: p_period_number => 9);
5329: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5330: (p_period_profile_id => l_period_profile_id,
5331: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5332: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5333: p_project_currency_type => l_currency_type,

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

5332: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5333: p_project_currency_type => l_currency_type,
5334: p_amount_type_id => 160,
5335: p_period_number => 10);
5336: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5337: (p_period_profile_id => l_period_profile_id,
5338: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5339: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5340: p_project_currency_type => l_currency_type,

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

5339: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5340: p_project_currency_type => l_currency_type,
5341: p_amount_type_id => 160,
5342: p_period_number => 11);
5343: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5344: (p_period_profile_id => l_period_profile_id,
5345: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5346: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5347: p_project_currency_type => l_currency_type,

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

5346: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5347: p_project_currency_type => l_currency_type,
5348: p_amount_type_id => 160,
5349: p_period_number => 12);
5350: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5351: (p_period_profile_id => l_period_profile_id,
5352: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5353: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5354: p_project_currency_type => l_currency_type,

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

5353: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5354: p_project_currency_type => l_currency_type,
5355: p_amount_type_id => 160,
5356: p_period_number => 13);
5357: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5358: (p_period_profile_id => l_period_profile_id,
5359: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5360: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5361: p_project_currency_type => l_currency_type,

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

5360: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5361: p_project_currency_type => l_currency_type,
5362: p_amount_type_id => 160,
5363: p_period_number => 0);
5364: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5365: (p_period_profile_id => l_period_profile_id,
5366: p_budget_version_id => l_pd_cost_budget_version_id(l_row_number),
5367: p_resource_assignment_id => l_pd_cost_res_assignment_id(l_row_number),
5368: p_project_currency_type => l_currency_type,

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

5556: l_pd_has_child_element(l_row_number) := 'N';
5557: else
5558: l_pd_has_child_element(l_row_number) := 'Y';
5559: end if;
5560: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5561: (p_period_profile_id => l_period_profile_id,
5562: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5563: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5564: p_project_currency_type => l_currency_type,

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

5563: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5564: p_project_currency_type => l_currency_type,
5565: p_amount_type_id => 215,
5566: p_period_number => 1);
5567: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5568: (p_period_profile_id => l_period_profile_id,
5569: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5570: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5571: p_project_currency_type => l_currency_type,

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

5570: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5571: p_project_currency_type => l_currency_type,
5572: p_amount_type_id => 215,
5573: p_period_number => 2);
5574: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5575: (p_period_profile_id => l_period_profile_id,
5576: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5577: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5578: p_project_currency_type => l_currency_type,

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

5577: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5578: p_project_currency_type => l_currency_type,
5579: p_amount_type_id => 215,
5580: p_period_number => 3);
5581: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5582: (p_period_profile_id => l_period_profile_id,
5583: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5584: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5585: p_project_currency_type => l_currency_type,

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

5584: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5585: p_project_currency_type => l_currency_type,
5586: p_amount_type_id => 215,
5587: p_period_number => 4);
5588: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5589: (p_period_profile_id => l_period_profile_id,
5590: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5591: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5592: p_project_currency_type => l_currency_type,

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

5591: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5592: p_project_currency_type => l_currency_type,
5593: p_amount_type_id => 215,
5594: p_period_number => 5);
5595: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5596: (p_period_profile_id => l_period_profile_id,
5597: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5598: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5599: p_project_currency_type => l_currency_type,

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

5598: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5599: p_project_currency_type => l_currency_type,
5600: p_amount_type_id => 215,
5601: p_period_number => 6);
5602: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5603: (p_period_profile_id => l_period_profile_id,
5604: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5605: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5606: p_project_currency_type => l_currency_type,

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

5605: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5606: p_project_currency_type => l_currency_type,
5607: p_amount_type_id => 215,
5608: p_period_number => 7);
5609: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5610: (p_period_profile_id => l_period_profile_id,
5611: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5612: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5613: p_project_currency_type => l_currency_type,

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

5612: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5613: p_project_currency_type => l_currency_type,
5614: p_amount_type_id => 215,
5615: p_period_number => 8);
5616: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5617: (p_period_profile_id => l_period_profile_id,
5618: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5619: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5620: p_project_currency_type => l_currency_type,

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

5619: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5620: p_project_currency_type => l_currency_type,
5621: p_amount_type_id => 215,
5622: p_period_number => 9);
5623: l_pd_period_10(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_revenue_budget_version_id(l_row_number),
5626: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5627: p_project_currency_type => l_currency_type,

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

5626: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5627: p_project_currency_type => l_currency_type,
5628: p_amount_type_id => 215,
5629: p_period_number => 10);
5630: l_pd_period_11(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_revenue_budget_version_id(l_row_number),
5633: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5634: p_project_currency_type => l_currency_type,

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

5633: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5634: p_project_currency_type => l_currency_type,
5635: p_amount_type_id => 215,
5636: p_period_number => 11);
5637: l_pd_period_12(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_revenue_budget_version_id(l_row_number),
5640: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5641: p_project_currency_type => l_currency_type,

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

5640: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5641: p_project_currency_type => l_currency_type,
5642: p_amount_type_id => 215,
5643: p_period_number => 12);
5644: l_pd_period_13(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_revenue_budget_version_id(l_row_number),
5647: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5648: p_project_currency_type => l_currency_type,

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

5647: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5648: p_project_currency_type => l_currency_type,
5649: p_amount_type_id => 215,
5650: p_period_number => 13);
5651: l_pd_preceding(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_revenue_budget_version_id(l_row_number),
5654: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5655: p_project_currency_type => l_currency_type,

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

5654: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5655: p_project_currency_type => l_currency_type,
5656: p_amount_type_id => 215,
5657: p_period_number => 0);
5658: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5659: (p_period_profile_id => l_period_profile_id,
5660: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5661: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5662: p_project_currency_type => l_currency_type,

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

5740: l_pd_has_child_element(l_row_number) := 'N';
5741: else
5742: l_pd_has_child_element(l_row_number) := 'Y';
5743: end if;
5744: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5745: (p_period_profile_id => l_period_profile_id,
5746: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5747: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5748: p_project_currency_type => l_currency_type,

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

5747: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5748: p_project_currency_type => l_currency_type,
5749: p_amount_type_id => 100,
5750: p_period_number => 1);
5751: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5752: (p_period_profile_id => l_period_profile_id,
5753: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5754: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5755: p_project_currency_type => l_currency_type,

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

5754: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5755: p_project_currency_type => l_currency_type,
5756: p_amount_type_id => 100,
5757: p_period_number => 2);
5758: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5759: (p_period_profile_id => l_period_profile_id,
5760: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5761: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5762: p_project_currency_type => l_currency_type,

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

5761: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5762: p_project_currency_type => l_currency_type,
5763: p_amount_type_id => 100,
5764: p_period_number => 3);
5765: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5766: (p_period_profile_id => l_period_profile_id,
5767: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5768: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5769: p_project_currency_type => l_currency_type,

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

5768: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5769: p_project_currency_type => l_currency_type,
5770: p_amount_type_id => 100,
5771: p_period_number => 4);
5772: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5773: (p_period_profile_id => l_period_profile_id,
5774: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5775: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5776: p_project_currency_type => l_currency_type,

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

5775: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5776: p_project_currency_type => l_currency_type,
5777: p_amount_type_id => 100,
5778: p_period_number => 5);
5779: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5780: (p_period_profile_id => l_period_profile_id,
5781: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5782: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5783: p_project_currency_type => l_currency_type,

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

5782: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5783: p_project_currency_type => l_currency_type,
5784: p_amount_type_id => 100,
5785: p_period_number => 6);
5786: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5787: (p_period_profile_id => l_period_profile_id,
5788: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5789: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5790: p_project_currency_type => l_currency_type,

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

5789: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5790: p_project_currency_type => l_currency_type,
5791: p_amount_type_id => 100,
5792: p_period_number => 7);
5793: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5794: (p_period_profile_id => l_period_profile_id,
5795: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5796: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5797: p_project_currency_type => l_currency_type,

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

5796: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5797: p_project_currency_type => l_currency_type,
5798: p_amount_type_id => 100,
5799: p_period_number => 8);
5800: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5801: (p_period_profile_id => l_period_profile_id,
5802: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5803: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5804: p_project_currency_type => l_currency_type,

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

5803: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5804: p_project_currency_type => l_currency_type,
5805: p_amount_type_id => 100,
5806: p_period_number => 9);
5807: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5808: (p_period_profile_id => l_period_profile_id,
5809: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5810: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5811: p_project_currency_type => l_currency_type,

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

5810: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5811: p_project_currency_type => l_currency_type,
5812: p_amount_type_id => 100,
5813: p_period_number => 10);
5814: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5815: (p_period_profile_id => l_period_profile_id,
5816: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5817: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5818: p_project_currency_type => l_currency_type,

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

5817: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5818: p_project_currency_type => l_currency_type,
5819: p_amount_type_id => 100,
5820: p_period_number => 11);
5821: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5822: (p_period_profile_id => l_period_profile_id,
5823: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5824: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5825: p_project_currency_type => l_currency_type,

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

5824: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5825: p_project_currency_type => l_currency_type,
5826: p_amount_type_id => 100,
5827: p_period_number => 12);
5828: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5829: (p_period_profile_id => l_period_profile_id,
5830: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5831: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5832: p_project_currency_type => l_currency_type,

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

5831: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5832: p_project_currency_type => l_currency_type,
5833: p_amount_type_id => 100,
5834: p_period_number => 13);
5835: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5836: (p_period_profile_id => l_period_profile_id,
5837: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5838: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5839: p_project_currency_type => l_currency_type,

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

5838: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5839: p_project_currency_type => l_currency_type,
5840: p_amount_type_id => 100,
5841: p_period_number => 0);
5842: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
5843: (p_period_profile_id => l_period_profile_id,
5844: p_budget_version_id => l_pd_revenue_budget_version_id(l_row_number),
5845: p_resource_assignment_id => l_pd_revenue_res_assignment_id(l_row_number),
5846: p_project_currency_type => l_currency_type,

Line 6272: pa_fp_view_plans_util.assign_element_name

6268: ra.task_id,
6269: ra.resource_list_member_id,
6270: ra.budget_version_id,
6271: ra.resource_assignment_id,
6272: pa_fp_view_plans_util.assign_element_name
6273: (ra.project_id,
6274: ra.task_id,
6275: ra.resource_list_member_id) as element_name, -- element_name
6276: pa_fp_view_plans_util.assign_element_level

Line 6276: pa_fp_view_plans_util.assign_element_level

6272: pa_fp_view_plans_util.assign_element_name
6273: (ra.project_id,
6274: ra.task_id,
6275: ra.resource_list_member_id) as element_name, -- element_name
6276: pa_fp_view_plans_util.assign_element_level
6277: (ra.project_id,
6278: ra.budget_version_id,
6279: ra.task_id,
6280: ra.resource_list_member_id) as element_level, -- element_level

Line 6321: pa_fp_view_plans_util.assign_row_level

6317: DECODE(ra.resource_assignment_type,
6318: 'ROLLED_UP', 'N',
6319: 'USER_ENTERED', 'Y',
6320: 'Y') as line_editable_flag, -- line_editable_flag
6321: pa_fp_view_plans_util.assign_row_level
6322: (ra.project_id,
6323: ra.task_id,
6324: ra.resource_list_member_id) as row_level,
6325: pa_fp_view_plans_util.assign_parent_element

Line 6325: pa_fp_view_plans_util.assign_parent_element

6321: pa_fp_view_plans_util.assign_row_level
6322: (ra.project_id,
6323: ra.task_id,
6324: ra.resource_list_member_id) as row_level,
6325: pa_fp_view_plans_util.assign_parent_element
6326: (ra.project_id,
6327: ra.task_id,
6328: ra.resource_list_member_id) as parent_element_name,
6329: ra.unit_of_measure,

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

6505: --hr_utility.trace('quantity: period1');
6506: --hr_utility.trace('p_period_profile_id= ' || to_char(l_period_profile_id));
6507: --hr_utility.trace('p_resource_assignment_id= ' || to_char(l_pd_res_assignment_id(l_row_number)));
6508: --hr_utility.trace('p_project_currency_type= ' || l_currency_type);
6509: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6510: (p_period_profile_id => l_period_profile_id,
6511: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6512: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6513: p_project_currency_type => l_currency_type,

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

6512: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6513: p_project_currency_type => l_currency_type,
6514: p_amount_type_id => 215,
6515: p_period_number => 1);
6516: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6517: (p_period_profile_id => l_period_profile_id,
6518: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6519: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6520: p_project_currency_type => l_currency_type,

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

6519: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6520: p_project_currency_type => l_currency_type,
6521: p_amount_type_id => 215,
6522: p_period_number => 2);
6523: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6524: (p_period_profile_id => l_period_profile_id,
6525: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6526: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6527: p_project_currency_type => l_currency_type,

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

6526: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6527: p_project_currency_type => l_currency_type,
6528: p_amount_type_id => 215,
6529: p_period_number => 3);
6530: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6531: (p_period_profile_id => l_period_profile_id,
6532: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6533: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6534: p_project_currency_type => l_currency_type,

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

6533: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6534: p_project_currency_type => l_currency_type,
6535: p_amount_type_id => 215,
6536: p_period_number => 4);
6537: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6538: (p_period_profile_id => l_period_profile_id,
6539: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6540: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6541: p_project_currency_type => l_currency_type,

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

6540: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6541: p_project_currency_type => l_currency_type,
6542: p_amount_type_id => 215,
6543: p_period_number => 5);
6544: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6545: (p_period_profile_id => l_period_profile_id,
6546: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6547: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6548: p_project_currency_type => l_currency_type,

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

6547: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6548: p_project_currency_type => l_currency_type,
6549: p_amount_type_id => 215,
6550: p_period_number => 6);
6551: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6552: (p_period_profile_id => l_period_profile_id,
6553: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6554: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6555: p_project_currency_type => l_currency_type,

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

6554: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6555: p_project_currency_type => l_currency_type,
6556: p_amount_type_id => 215,
6557: p_period_number => 7);
6558: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6559: (p_period_profile_id => l_period_profile_id,
6560: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6561: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6562: p_project_currency_type => l_currency_type,

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

6561: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6562: p_project_currency_type => l_currency_type,
6563: p_amount_type_id => 215,
6564: p_period_number => 8);
6565: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6566: (p_period_profile_id => l_period_profile_id,
6567: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6568: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6569: p_project_currency_type => l_currency_type,

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

6568: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6569: p_project_currency_type => l_currency_type,
6570: p_amount_type_id => 215,
6571: p_period_number => 9);
6572: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6573: (p_period_profile_id => l_period_profile_id,
6574: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6575: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6576: p_project_currency_type => l_currency_type,

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

6575: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6576: p_project_currency_type => l_currency_type,
6577: p_amount_type_id => 215,
6578: p_period_number => 10);
6579: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6580: (p_period_profile_id => l_period_profile_id,
6581: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6582: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6583: p_project_currency_type => l_currency_type,

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

6582: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6583: p_project_currency_type => l_currency_type,
6584: p_amount_type_id => 215,
6585: p_period_number => 11);
6586: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6587: (p_period_profile_id => l_period_profile_id,
6588: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6589: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6590: p_project_currency_type => l_currency_type,

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

6589: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6590: p_project_currency_type => l_currency_type,
6591: p_amount_type_id => 215,
6592: p_period_number => 12);
6593: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6594: (p_period_profile_id => l_period_profile_id,
6595: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6596: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6597: p_project_currency_type => l_currency_type,

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

6596: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6597: p_project_currency_type => l_currency_type,
6598: p_amount_type_id => 215,
6599: p_period_number => 13);
6600: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6601: (p_period_profile_id => l_period_profile_id,
6602: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6603: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6604: p_project_currency_type => l_currency_type,

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

6603: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6604: p_project_currency_type => l_currency_type,
6605: p_amount_type_id => 215,
6606: p_period_number => 0);
6607: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6608: (p_period_profile_id => l_period_profile_id,
6609: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6610: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6611: p_project_currency_type => l_currency_type,

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

6650: l_cost_row_number := l_row_number;
6651: end if;
6652: */
6653: --hr_utility.trace('burdened cost: period1');
6654: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6655: (p_period_profile_id => l_period_profile_id,
6656: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6657: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6658: p_project_currency_type => l_currency_type,

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

6658: p_project_currency_type => l_currency_type,
6659: --p_amount_type_id => 150,
6660: p_amount_type_id => 165,
6661: p_period_number => 1);
6662: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6663: (p_period_profile_id => l_period_profile_id,
6664: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6665: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6666: p_project_currency_type => l_currency_type,

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

6666: p_project_currency_type => l_currency_type,
6667: --p_amount_type_id => 150,
6668: p_amount_type_id => 165,
6669: p_period_number => 2);
6670: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6671: (p_period_profile_id => l_period_profile_id,
6672: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6673: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6674: p_project_currency_type => l_currency_type,

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

6674: p_project_currency_type => l_currency_type,
6675: --p_amount_type_id => 150,
6676: p_amount_type_id => 165,
6677: p_period_number => 3);
6678: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6679: (p_period_profile_id => l_period_profile_id,
6680: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6681: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6682: p_project_currency_type => l_currency_type,

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

6682: p_project_currency_type => l_currency_type,
6683: --p_amount_type_id => 150,
6684: p_amount_type_id => 165,
6685: p_period_number => 4);
6686: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6687: (p_period_profile_id => l_period_profile_id,
6688: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6689: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6690: p_project_currency_type => l_currency_type,

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

6690: p_project_currency_type => l_currency_type,
6691: --p_amount_type_id => 150,
6692: p_amount_type_id => 165,
6693: p_period_number => 5);
6694: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6695: (p_period_profile_id => l_period_profile_id,
6696: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6697: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6698: p_project_currency_type => l_currency_type,

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

6698: p_project_currency_type => l_currency_type,
6699: --p_amount_type_id => 150,
6700: p_amount_type_id => 165,
6701: p_period_number => 6);
6702: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6703: (p_period_profile_id => l_period_profile_id,
6704: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6705: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6706: p_project_currency_type => l_currency_type,

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

6706: p_project_currency_type => l_currency_type,
6707: --p_amount_type_id => 150,
6708: p_amount_type_id => 165,
6709: p_period_number => 7);
6710: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6711: (p_period_profile_id => l_period_profile_id,
6712: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6713: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6714: p_project_currency_type => l_currency_type,

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

6714: p_project_currency_type => l_currency_type,
6715: --p_amount_type_id => 150,
6716: p_amount_type_id => 165,
6717: p_period_number => 8);
6718: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6719: (p_period_profile_id => l_period_profile_id,
6720: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6721: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6722: p_project_currency_type => l_currency_type,

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

6722: p_project_currency_type => l_currency_type,
6723: --p_amount_type_id => 150,
6724: p_amount_type_id => 165,
6725: p_period_number => 9);
6726: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6727: (p_period_profile_id => l_period_profile_id,
6728: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6729: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6730: p_project_currency_type => l_currency_type,

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

6730: p_project_currency_type => l_currency_type,
6731: --p_amount_type_id => 150,
6732: p_amount_type_id => 165,
6733: p_period_number => 10);
6734: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6735: (p_period_profile_id => l_period_profile_id,
6736: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6737: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6738: p_project_currency_type => l_currency_type,

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

6738: p_project_currency_type => l_currency_type,
6739: --p_amount_type_id => 150,
6740: p_amount_type_id => 165,
6741: p_period_number => 11);
6742: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6743: (p_period_profile_id => l_period_profile_id,
6744: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6745: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6746: p_project_currency_type => l_currency_type,

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

6746: p_project_currency_type => l_currency_type,
6747: --p_amount_type_id => 150,
6748: p_amount_type_id => 165,
6749: p_period_number => 12);
6750: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6751: (p_period_profile_id => l_period_profile_id,
6752: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6753: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6754: p_project_currency_type => l_currency_type,

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

6754: p_project_currency_type => l_currency_type,
6755: --p_amount_type_id => 150,
6756: p_amount_type_id => 165,
6757: p_period_number => 13);
6758: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6759: (p_period_profile_id => l_period_profile_id,
6760: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6761: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6762: p_project_currency_type => l_currency_type,

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

6762: p_project_currency_type => l_currency_type,
6763: --p_amount_type_id => 150,
6764: p_amount_type_id => 165,
6765: p_period_number => 0);
6766: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6767: (p_period_profile_id => l_period_profile_id,
6768: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6769: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6770: p_project_currency_type => l_currency_type,

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

6810: l_cost_row_number := l_row_number;
6811: end if;
6812: */
6813: --hr_utility.trace('raw cost: period1');
6814: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6815: (p_period_profile_id => l_period_profile_id,
6816: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6817: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6818: p_project_currency_type => l_currency_type,

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

6818: p_project_currency_type => l_currency_type,
6819: --p_amount_type_id => 150,
6820: p_amount_type_id => 160,
6821: p_period_number => 1);
6822: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6823: (p_period_profile_id => l_period_profile_id,
6824: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6825: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6826: p_project_currency_type => l_currency_type,

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

6826: p_project_currency_type => l_currency_type,
6827: --p_amount_type_id => 150,
6828: p_amount_type_id => 160,
6829: p_period_number => 2);
6830: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6831: (p_period_profile_id => l_period_profile_id,
6832: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6833: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6834: p_project_currency_type => l_currency_type,

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

6834: p_project_currency_type => l_currency_type,
6835: --p_amount_type_id => 150,
6836: p_amount_type_id => 160,
6837: p_period_number => 3);
6838: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6839: (p_period_profile_id => l_period_profile_id,
6840: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6841: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6842: p_project_currency_type => l_currency_type,

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

6842: p_project_currency_type => l_currency_type,
6843: --p_amount_type_id => 150,
6844: p_amount_type_id => 160,
6845: p_period_number => 4);
6846: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6847: (p_period_profile_id => l_period_profile_id,
6848: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6849: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6850: p_project_currency_type => l_currency_type,

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

6850: p_project_currency_type => l_currency_type,
6851: --p_amount_type_id => 150,
6852: p_amount_type_id => 160,
6853: p_period_number => 5);
6854: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6855: (p_period_profile_id => l_period_profile_id,
6856: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6857: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6858: p_project_currency_type => l_currency_type,

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

6858: p_project_currency_type => l_currency_type,
6859: --p_amount_type_id => 150,
6860: p_amount_type_id => 160,
6861: p_period_number => 6);
6862: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6863: (p_period_profile_id => l_period_profile_id,
6864: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6865: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6866: p_project_currency_type => l_currency_type,

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

6866: p_project_currency_type => l_currency_type,
6867: --p_amount_type_id => 150,
6868: p_amount_type_id => 160,
6869: p_period_number => 7);
6870: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6871: (p_period_profile_id => l_period_profile_id,
6872: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6873: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6874: p_project_currency_type => l_currency_type,

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

6874: p_project_currency_type => l_currency_type,
6875: --p_amount_type_id => 150,
6876: p_amount_type_id => 160,
6877: p_period_number => 8);
6878: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6879: (p_period_profile_id => l_period_profile_id,
6880: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6881: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6882: p_project_currency_type => l_currency_type,

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

6882: p_project_currency_type => l_currency_type,
6883: --p_amount_type_id => 150,
6884: p_amount_type_id => 160,
6885: p_period_number => 9);
6886: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6887: (p_period_profile_id => l_period_profile_id,
6888: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6889: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6890: p_project_currency_type => l_currency_type,

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

6890: p_project_currency_type => l_currency_type,
6891: --p_amount_type_id => 150,
6892: p_amount_type_id => 160,
6893: p_period_number => 10);
6894: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6895: (p_period_profile_id => l_period_profile_id,
6896: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6897: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6898: p_project_currency_type => l_currency_type,

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

6898: p_project_currency_type => l_currency_type,
6899: --p_amount_type_id => 150,
6900: p_amount_type_id => 160,
6901: p_period_number => 11);
6902: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6903: (p_period_profile_id => l_period_profile_id,
6904: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6905: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6906: p_project_currency_type => l_currency_type,

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

6906: p_project_currency_type => l_currency_type,
6907: --p_amount_type_id => 150,
6908: p_amount_type_id => 160,
6909: p_period_number => 12);
6910: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6911: (p_period_profile_id => l_period_profile_id,
6912: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6913: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6914: p_project_currency_type => l_currency_type,

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

6914: p_project_currency_type => l_currency_type,
6915: --p_amount_type_id => 150,
6916: p_amount_type_id => 160,
6917: p_period_number => 13);
6918: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6919: (p_period_profile_id => l_period_profile_id,
6920: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6921: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6922: p_project_currency_type => l_currency_type,

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

6922: p_project_currency_type => l_currency_type,
6923: --p_amount_type_id => 150,
6924: p_amount_type_id => 160,
6925: p_period_number => 0);
6926: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6927: (p_period_profile_id => l_period_profile_id,
6928: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6929: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6930: p_project_currency_type => l_currency_type,

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

6962: l_pd_has_child_element(l_row_number) := 'Y';
6963: end if;
6964: l_revenue_row_number := l_row_number;
6965: --hr_utility.trace('revenue: period1');
6966: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6967: (p_period_profile_id => l_period_profile_id,
6968: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6969: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6970: p_project_currency_type => l_currency_type,

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

6969: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6970: p_project_currency_type => l_currency_type,
6971: p_amount_type_id => 100,
6972: p_period_number => 1);
6973: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6974: (p_period_profile_id => l_period_profile_id,
6975: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6976: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6977: p_project_currency_type => l_currency_type,

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

6976: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6977: p_project_currency_type => l_currency_type,
6978: p_amount_type_id => 100,
6979: p_period_number => 2);
6980: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6981: (p_period_profile_id => l_period_profile_id,
6982: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6983: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6984: p_project_currency_type => l_currency_type,

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

6983: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6984: p_project_currency_type => l_currency_type,
6985: p_amount_type_id => 100,
6986: p_period_number => 3);
6987: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6988: (p_period_profile_id => l_period_profile_id,
6989: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6990: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6991: p_project_currency_type => l_currency_type,

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

6990: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6991: p_project_currency_type => l_currency_type,
6992: p_amount_type_id => 100,
6993: p_period_number => 4);
6994: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
6995: (p_period_profile_id => l_period_profile_id,
6996: p_budget_version_id => l_pd_budget_version_id(l_row_number),
6997: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6998: p_project_currency_type => l_currency_type,

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

6997: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
6998: p_project_currency_type => l_currency_type,
6999: p_amount_type_id => 100,
7000: p_period_number => 5);
7001: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7002: (p_period_profile_id => l_period_profile_id,
7003: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7004: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7005: p_project_currency_type => l_currency_type,

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

7004: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7005: p_project_currency_type => l_currency_type,
7006: p_amount_type_id => 100,
7007: p_period_number => 6);
7008: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7009: (p_period_profile_id => l_period_profile_id,
7010: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7011: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7012: p_project_currency_type => l_currency_type,

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

7011: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7012: p_project_currency_type => l_currency_type,
7013: p_amount_type_id => 100,
7014: p_period_number => 7);
7015: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7016: (p_period_profile_id => l_period_profile_id,
7017: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7018: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7019: p_project_currency_type => l_currency_type,

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

7018: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7019: p_project_currency_type => l_currency_type,
7020: p_amount_type_id => 100,
7021: p_period_number => 8);
7022: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7023: (p_period_profile_id => l_period_profile_id,
7024: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7025: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7026: p_project_currency_type => l_currency_type,

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

7025: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7026: p_project_currency_type => l_currency_type,
7027: p_amount_type_id => 100,
7028: p_period_number => 9);
7029: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7030: (p_period_profile_id => l_period_profile_id,
7031: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7032: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7033: p_project_currency_type => l_currency_type,

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

7032: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7033: p_project_currency_type => l_currency_type,
7034: p_amount_type_id => 100,
7035: p_period_number => 10);
7036: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7037: (p_period_profile_id => l_period_profile_id,
7038: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7039: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7040: p_project_currency_type => l_currency_type,

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

7039: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7040: p_project_currency_type => l_currency_type,
7041: p_amount_type_id => 100,
7042: p_period_number => 11);
7043: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7044: (p_period_profile_id => l_period_profile_id,
7045: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7046: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7047: p_project_currency_type => l_currency_type,

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

7046: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7047: p_project_currency_type => l_currency_type,
7048: p_amount_type_id => 100,
7049: p_period_number => 12);
7050: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7051: (p_period_profile_id => l_period_profile_id,
7052: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7053: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7054: p_project_currency_type => l_currency_type,

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

7053: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7054: p_project_currency_type => l_currency_type,
7055: p_amount_type_id => 100,
7056: p_period_number => 13);
7057: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7058: (p_period_profile_id => l_period_profile_id,
7059: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7060: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7061: p_project_currency_type => l_currency_type,

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

7060: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7061: p_project_currency_type => l_currency_type,
7062: p_amount_type_id => 100,
7063: p_period_number => 0);
7064: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7065: (p_period_profile_id => l_period_profile_id,
7066: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7067: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7068: p_project_currency_type => l_currency_type,

Line 7146: 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));

7142: l_pd_has_child_element(l_row_number) := 'N';
7143: else
7144: l_pd_has_child_element(l_row_number) := 'Y';
7145: end if;
7146: 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));
7147: 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));
7148: 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));
7149: 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));
7150: 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 7147: 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));

7143: else
7144: l_pd_has_child_element(l_row_number) := 'Y';
7145: end if;
7146: 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));
7147: 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));
7148: 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));
7149: 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));
7150: 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));
7151: 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 7148: 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));

7144: l_pd_has_child_element(l_row_number) := 'Y';
7145: end if;
7146: 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));
7147: 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));
7148: 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));
7149: 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));
7150: 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));
7151: 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));
7152: 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 7149: 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));

7145: end if;
7146: 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));
7147: 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));
7148: 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));
7149: 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));
7150: 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));
7151: 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));
7152: 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));
7153: 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 7150: 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));

7146: 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));
7147: 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));
7148: 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));
7149: 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));
7150: 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));
7151: 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));
7152: 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));
7153: 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));
7154: 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 7151: 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));

7147: 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));
7148: 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));
7149: 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));
7150: 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));
7151: 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));
7152: 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));
7153: 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));
7154: 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));
7155: 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 7152: 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));

7148: 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));
7149: 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));
7150: 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));
7151: 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));
7152: 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));
7153: 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));
7154: 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));
7155: 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));
7156: 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 7153: 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));

7149: 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));
7150: 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));
7151: 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));
7152: 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));
7153: 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));
7154: 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));
7155: 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));
7156: 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));
7157: 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 7154: 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));

7150: 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));
7151: 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));
7152: 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));
7153: 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));
7154: 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));
7155: 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));
7156: 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));
7157: 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));
7158: 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 7155: 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));

7151: 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));
7152: 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));
7153: 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));
7154: 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));
7155: 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));
7156: 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));
7157: 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));
7158: 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));
7159: 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 7156: 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));

7152: 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));
7153: 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));
7154: 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));
7155: 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));
7156: 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));
7157: 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));
7158: 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));
7159: 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));
7160: 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 7157: 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));

7153: 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));
7154: 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));
7155: 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));
7156: 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));
7157: 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));
7158: 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));
7159: 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));
7160: 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));
7161: end if; -- display_from: MARGIN PERCENT

Line 7158: 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));

7154: 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));
7155: 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));
7156: 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));
7157: 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));
7158: 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));
7159: 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));
7160: 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));
7161: end if; -- display_from: MARGIN PERCENT
7162: 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 7159: 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));

7155: 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));
7156: 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));
7157: 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));
7158: 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));
7159: 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));
7160: 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));
7161: end if; -- display_from: MARGIN PERCENT
7162: 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
7163: end loop;

Line 7160: 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));

7156: 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));
7157: 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));
7158: 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));
7159: 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));
7160: 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));
7161: end if; -- display_from: MARGIN PERCENT
7162: 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
7163: end loop;
7164: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'

Line 7162: 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

7158: 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));
7159: 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));
7160: 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));
7161: end if; -- display_from: MARGIN PERCENT
7162: 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
7163: end loop;
7164: end if; -- pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
7165: l_err_stage := 400;
7166: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_together', '400: populated the pds pl/sql tables', 1);

Line 7352: pa_fp_view_plans_util.assign_element_name

7348: ra.task_id,
7349: ra.resource_list_member_id,
7350: ra.budget_version_id,
7351: ra.resource_assignment_id,
7352: pa_fp_view_plans_util.assign_element_name
7353: (ra.project_id,
7354: ra.task_id,
7355: ra.resource_list_member_id) as element_name, -- element_name
7356: pa_fp_view_plans_util.assign_element_level

Line 7356: pa_fp_view_plans_util.assign_element_level

7352: pa_fp_view_plans_util.assign_element_name
7353: (ra.project_id,
7354: ra.task_id,
7355: ra.resource_list_member_id) as element_name, -- element_name
7356: pa_fp_view_plans_util.assign_element_level
7357: (ra.project_id,
7358: ra.budget_version_id,
7359: ra.task_id,
7360: ra.resource_list_member_id) as element_level, -- element_level

Line 7378: pa_fp_view_plans_util.assign_row_level

7374: DECODE(ra.resource_assignment_type,
7375: 'ROLLED_UP', 'N',
7376: 'USER_ENTERED', 'Y',
7377: 'Y') as line_editable_flag, -- line_editable_flag
7378: pa_fp_view_plans_util.assign_row_level
7379: (ra.project_id,
7380: ra.task_id,
7381: ra.resource_list_member_id) as row_level,
7382: pa_fp_view_plans_util.assign_parent_element

Line 7382: pa_fp_view_plans_util.assign_parent_element

7378: pa_fp_view_plans_util.assign_row_level
7379: (ra.project_id,
7380: ra.task_id,
7381: ra.resource_list_member_id) as row_level,
7382: pa_fp_view_plans_util.assign_parent_element
7383: (ra.project_id,
7384: ra.task_id,
7385: ra.resource_list_member_id) as parent_element_name,
7386: ra.unit_of_measure,

Line 7412: pa_fp_view_plans_util.assign_element_name

7408: ra.task_id,
7409: ra.resource_list_member_id,
7410: ra.budget_version_id,
7411: ra.resource_assignment_id,
7412: pa_fp_view_plans_util.assign_element_name
7413: (ra.project_id,
7414: ra.task_id,
7415: ra.resource_list_member_id) as element_name, -- element_name
7416: pa_fp_view_plans_util.assign_element_level

Line 7416: pa_fp_view_plans_util.assign_element_level

7412: pa_fp_view_plans_util.assign_element_name
7413: (ra.project_id,
7414: ra.task_id,
7415: ra.resource_list_member_id) as element_name, -- element_name
7416: pa_fp_view_plans_util.assign_element_level
7417: (ra.project_id,
7418: ra.budget_version_id,
7419: ra.task_id,
7420: ra.resource_list_member_id) as element_level, -- element_level

Line 7436: pa_fp_view_plans_util.assign_row_level

7432: DECODE(ra.resource_assignment_type,
7433: 'ROLLED_UP', 'N',
7434: 'USER_ENTERED', 'Y',
7435: 'Y') as line_editable_flag, -- line_editable_flag
7436: pa_fp_view_plans_util.assign_row_level
7437: (ra.project_id,
7438: ra.task_id,
7439: ra.resource_list_member_id) as row_level,
7440: pa_fp_view_plans_util.assign_parent_element

Line 7440: pa_fp_view_plans_util.assign_parent_element

7436: pa_fp_view_plans_util.assign_row_level
7437: (ra.project_id,
7438: ra.task_id,
7439: ra.resource_list_member_id) as row_level,
7440: pa_fp_view_plans_util.assign_parent_element
7441: (ra.project_id,
7442: ra.task_id,
7443: ra.resource_list_member_id) as parent_element_name,
7444: ra.unit_of_measure,

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

7617: if (l_report_labor_hrs_from_code = 'COST') then
7618: --hr_utility.trace('try to getperiodnvalue');
7619: --hr_utility.trace('raid= ' || to_char(l_pd_res_assignment_id(l_row_number)));
7620: --hr_utility.trace('ppid= ' || to_char(l_period_profile_id));
7621: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7622: (p_period_profile_id => l_period_profile_id,
7623: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7624: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7625: p_project_currency_type => l_currency_type,

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

7625: p_project_currency_type => l_currency_type,
7626: p_amount_type_id => 215,
7627: p_period_number => 1);
7628: --hr_utility.trace('reached here');
7629: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7630: (p_period_profile_id => l_period_profile_id,
7631: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7632: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7633: p_project_currency_type => l_currency_type,

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

7632: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7633: p_project_currency_type => l_currency_type,
7634: p_amount_type_id => 215,
7635: p_period_number => 2);
7636: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7637: (p_period_profile_id => l_period_profile_id,
7638: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7639: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7640: p_project_currency_type => l_currency_type,

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

7639: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7640: p_project_currency_type => l_currency_type,
7641: p_amount_type_id => 215,
7642: p_period_number => 3);
7643: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7644: (p_period_profile_id => l_period_profile_id,
7645: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7646: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7647: p_project_currency_type => l_currency_type,

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

7646: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7647: p_project_currency_type => l_currency_type,
7648: p_amount_type_id => 215,
7649: p_period_number => 4);
7650: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7651: (p_period_profile_id => l_period_profile_id,
7652: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7653: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7654: p_project_currency_type => l_currency_type,

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

7653: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7654: p_project_currency_type => l_currency_type,
7655: p_amount_type_id => 215,
7656: p_period_number => 5);
7657: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7658: (p_period_profile_id => l_period_profile_id,
7659: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7660: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7661: p_project_currency_type => l_currency_type,

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

7660: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7661: p_project_currency_type => l_currency_type,
7662: p_amount_type_id => 215,
7663: p_period_number => 6);
7664: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7665: (p_period_profile_id => l_period_profile_id,
7666: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7667: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7668: p_project_currency_type => l_currency_type,

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

7667: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7668: p_project_currency_type => l_currency_type,
7669: p_amount_type_id => 215,
7670: p_period_number => 7);
7671: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7672: (p_period_profile_id => l_period_profile_id,
7673: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7674: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7675: p_project_currency_type => l_currency_type,

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

7674: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7675: p_project_currency_type => l_currency_type,
7676: p_amount_type_id => 215,
7677: p_period_number => 8);
7678: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7679: (p_period_profile_id => l_period_profile_id,
7680: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7681: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7682: p_project_currency_type => l_currency_type,

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

7681: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7682: p_project_currency_type => l_currency_type,
7683: p_amount_type_id => 215,
7684: p_period_number => 9);
7685: l_pd_period_10(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 7692: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7688: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7689: p_project_currency_type => l_currency_type,
7690: p_amount_type_id => 215,
7691: p_period_number => 10);
7692: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7693: (p_period_profile_id => l_period_profile_id,
7694: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7695: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7696: p_project_currency_type => l_currency_type,

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

7695: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7696: p_project_currency_type => l_currency_type,
7697: p_amount_type_id => 215,
7698: p_period_number => 11);
7699: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7700: (p_period_profile_id => l_period_profile_id,
7701: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7702: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7703: p_project_currency_type => l_currency_type,

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

7702: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7703: p_project_currency_type => l_currency_type,
7704: p_amount_type_id => 215,
7705: p_period_number => 12);
7706: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7707: (p_period_profile_id => l_period_profile_id,
7708: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7709: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7710: p_project_currency_type => l_currency_type,

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

7709: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7710: p_project_currency_type => l_currency_type,
7711: p_amount_type_id => 215,
7712: p_period_number => 13);
7713: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7714: (p_period_profile_id => l_period_profile_id,
7715: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7716: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7717: p_project_currency_type => l_currency_type,

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

7716: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7717: p_project_currency_type => l_currency_type,
7718: p_amount_type_id => 215,
7719: p_period_number => 0);
7720: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7721: (p_period_profile_id => l_period_profile_id,
7722: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7723: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7724: p_project_currency_type => l_currency_type,

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

7773: l_pd_has_child_element(l_row_number) := 'N';
7774: else
7775: l_pd_has_child_element(l_row_number) := 'Y';
7776: end if;
7777: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7778: (p_period_profile_id => l_period_profile_id,
7779: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7780: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7781: p_project_currency_type => l_currency_type,

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

7781: p_project_currency_type => l_currency_type,
7782: --p_amount_type_id => 150,
7783: p_amount_type_id => 165,
7784: p_period_number => 1);
7785: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7786: (p_period_profile_id => l_period_profile_id,
7787: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7788: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7789: p_project_currency_type => l_currency_type,

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

7789: p_project_currency_type => l_currency_type,
7790: --p_amount_type_id => 150,
7791: p_amount_type_id => 165,
7792: p_period_number => 2);
7793: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7794: (p_period_profile_id => l_period_profile_id,
7795: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7796: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7797: p_project_currency_type => l_currency_type,

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

7797: p_project_currency_type => l_currency_type,
7798: --p_amount_type_id => 150,
7799: p_amount_type_id => 165,
7800: p_period_number => 3);
7801: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7802: (p_period_profile_id => l_period_profile_id,
7803: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7804: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7805: p_project_currency_type => l_currency_type,

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

7805: p_project_currency_type => l_currency_type,
7806: --p_amount_type_id => 150,
7807: p_amount_type_id => 165,
7808: p_period_number => 4);
7809: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7810: (p_period_profile_id => l_period_profile_id,
7811: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7812: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7813: p_project_currency_type => l_currency_type,

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

7813: p_project_currency_type => l_currency_type,
7814: --p_amount_type_id => 150,
7815: p_amount_type_id => 165,
7816: p_period_number => 5);
7817: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7818: (p_period_profile_id => l_period_profile_id,
7819: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7820: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7821: p_project_currency_type => l_currency_type,

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

7821: p_project_currency_type => l_currency_type,
7822: --p_amount_type_id => 150,
7823: p_amount_type_id => 165,
7824: p_period_number => 6);
7825: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7826: (p_period_profile_id => l_period_profile_id,
7827: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7828: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7829: p_project_currency_type => l_currency_type,

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

7829: p_project_currency_type => l_currency_type,
7830: --p_amount_type_id => 150,
7831: p_amount_type_id => 165,
7832: p_period_number => 7);
7833: l_pd_period_8(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 7841: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7837: p_project_currency_type => l_currency_type,
7838: --p_amount_type_id => 150,
7839: p_amount_type_id => 165,
7840: p_period_number => 8);
7841: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7842: (p_period_profile_id => l_period_profile_id,
7843: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7844: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7845: p_project_currency_type => l_currency_type,

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

7845: p_project_currency_type => l_currency_type,
7846: --p_amount_type_id => 150,
7847: p_amount_type_id => 165,
7848: p_period_number => 9);
7849: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7850: (p_period_profile_id => l_period_profile_id,
7851: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7852: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7853: p_project_currency_type => l_currency_type,

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

7853: p_project_currency_type => l_currency_type,
7854: --p_amount_type_id => 150,
7855: p_amount_type_id => 165,
7856: p_period_number => 10);
7857: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7858: (p_period_profile_id => l_period_profile_id,
7859: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7860: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7861: p_project_currency_type => l_currency_type,

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

7861: p_project_currency_type => l_currency_type,
7862: --p_amount_type_id => 150,
7863: p_amount_type_id => 165,
7864: p_period_number => 11);
7865: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7866: (p_period_profile_id => l_period_profile_id,
7867: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7868: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7869: p_project_currency_type => l_currency_type,

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

7869: p_project_currency_type => l_currency_type,
7870: --p_amount_type_id => 150,
7871: p_amount_type_id => 165,
7872: p_period_number => 12);
7873: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7874: (p_period_profile_id => l_period_profile_id,
7875: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7876: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7877: p_project_currency_type => l_currency_type,

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

7877: p_project_currency_type => l_currency_type,
7878: --p_amount_type_id => 150,
7879: p_amount_type_id => 165,
7880: p_period_number => 13);
7881: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7882: (p_period_profile_id => l_period_profile_id,
7883: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7884: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7885: p_project_currency_type => l_currency_type,

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

7885: p_project_currency_type => l_currency_type,
7886: --p_amount_type_id => 150,
7887: p_amount_type_id => 165,
7888: p_period_number => 0);
7889: l_pd_succeeding(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 7927: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value

7923: l_pd_has_child_element(l_row_number) := 'N';
7924: else
7925: l_pd_has_child_element(l_row_number) := 'Y';
7926: end if;
7927: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7928: (p_period_profile_id => l_period_profile_id,
7929: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7930: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7931: p_project_currency_type => l_currency_type,

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

7931: p_project_currency_type => l_currency_type,
7932: --p_amount_type_id => 150,
7933: p_amount_type_id => 160,
7934: p_period_number => 1);
7935: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7936: (p_period_profile_id => l_period_profile_id,
7937: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7938: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7939: p_project_currency_type => l_currency_type,

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

7939: p_project_currency_type => l_currency_type,
7940: --p_amount_type_id => 150,
7941: p_amount_type_id => 160,
7942: p_period_number => 2);
7943: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7944: (p_period_profile_id => l_period_profile_id,
7945: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7946: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7947: p_project_currency_type => l_currency_type,

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

7947: p_project_currency_type => l_currency_type,
7948: --p_amount_type_id => 150,
7949: p_amount_type_id => 160,
7950: p_period_number => 3);
7951: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7952: (p_period_profile_id => l_period_profile_id,
7953: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7954: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7955: p_project_currency_type => l_currency_type,

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

7955: p_project_currency_type => l_currency_type,
7956: --p_amount_type_id => 150,
7957: p_amount_type_id => 160,
7958: p_period_number => 4);
7959: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7960: (p_period_profile_id => l_period_profile_id,
7961: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7962: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7963: p_project_currency_type => l_currency_type,

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

7963: p_project_currency_type => l_currency_type,
7964: --p_amount_type_id => 150,
7965: p_amount_type_id => 160,
7966: p_period_number => 5);
7967: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7968: (p_period_profile_id => l_period_profile_id,
7969: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7970: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7971: p_project_currency_type => l_currency_type,

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

7971: p_project_currency_type => l_currency_type,
7972: --p_amount_type_id => 150,
7973: p_amount_type_id => 160,
7974: p_period_number => 6);
7975: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7976: (p_period_profile_id => l_period_profile_id,
7977: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7978: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7979: p_project_currency_type => l_currency_type,

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

7979: p_project_currency_type => l_currency_type,
7980: --p_amount_type_id => 150,
7981: p_amount_type_id => 160,
7982: p_period_number => 7);
7983: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7984: (p_period_profile_id => l_period_profile_id,
7985: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7986: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7987: p_project_currency_type => l_currency_type,

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

7987: p_project_currency_type => l_currency_type,
7988: --p_amount_type_id => 150,
7989: p_amount_type_id => 160,
7990: p_period_number => 8);
7991: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
7992: (p_period_profile_id => l_period_profile_id,
7993: p_budget_version_id => l_pd_budget_version_id(l_row_number),
7994: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
7995: p_project_currency_type => l_currency_type,

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

7995: p_project_currency_type => l_currency_type,
7996: --p_amount_type_id => 150,
7997: p_amount_type_id => 160,
7998: p_period_number => 9);
7999: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8000: (p_period_profile_id => l_period_profile_id,
8001: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8002: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8003: p_project_currency_type => l_currency_type,

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

8003: p_project_currency_type => l_currency_type,
8004: --p_amount_type_id => 150,
8005: p_amount_type_id => 160,
8006: p_period_number => 10);
8007: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8008: (p_period_profile_id => l_period_profile_id,
8009: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8010: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8011: p_project_currency_type => l_currency_type,

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

8011: p_project_currency_type => l_currency_type,
8012: --p_amount_type_id => 150,
8013: p_amount_type_id => 160,
8014: p_period_number => 11);
8015: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8016: (p_period_profile_id => l_period_profile_id,
8017: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8018: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8019: p_project_currency_type => l_currency_type,

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

8019: p_project_currency_type => l_currency_type,
8020: --p_amount_type_id => 150,
8021: p_amount_type_id => 160,
8022: p_period_number => 12);
8023: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8024: (p_period_profile_id => l_period_profile_id,
8025: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8026: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8027: p_project_currency_type => l_currency_type,

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

8027: p_project_currency_type => l_currency_type,
8028: --p_amount_type_id => 150,
8029: p_amount_type_id => 160,
8030: p_period_number => 13);
8031: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8032: (p_period_profile_id => l_period_profile_id,
8033: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8034: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8035: p_project_currency_type => l_currency_type,

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

8035: p_project_currency_type => l_currency_type,
8036: --p_amount_type_id => 150,
8037: p_amount_type_id => 160,
8038: p_period_number => 0);
8039: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8040: (p_period_profile_id => l_period_profile_id,
8041: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8042: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8043: p_project_currency_type => l_currency_type,

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

8373: else
8374: l_pd_has_child_element(l_row_number) := 'Y';
8375: end if;
8376: if (l_report_labor_hrs_from_code = 'REVENUE') then
8377: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8378: (p_period_profile_id => l_period_profile_id,
8379: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8380: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8381: p_project_currency_type => l_currency_type,

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

8380: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8381: p_project_currency_type => l_currency_type,
8382: p_amount_type_id => 215,
8383: p_period_number => 1);
8384: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8385: (p_period_profile_id => l_period_profile_id,
8386: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8387: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8388: p_project_currency_type => l_currency_type,

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

8387: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8388: p_project_currency_type => l_currency_type,
8389: p_amount_type_id => 215,
8390: p_period_number => 2);
8391: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8392: (p_period_profile_id => l_period_profile_id,
8393: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8394: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8395: p_project_currency_type => l_currency_type,

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

8394: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8395: p_project_currency_type => l_currency_type,
8396: p_amount_type_id => 215,
8397: p_period_number => 3);
8398: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8399: (p_period_profile_id => l_period_profile_id,
8400: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8401: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8402: p_project_currency_type => l_currency_type,

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

8401: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8402: p_project_currency_type => l_currency_type,
8403: p_amount_type_id => 215,
8404: p_period_number => 4);
8405: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8406: (p_period_profile_id => l_period_profile_id,
8407: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8408: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8409: p_project_currency_type => l_currency_type,

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

8408: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8409: p_project_currency_type => l_currency_type,
8410: p_amount_type_id => 215,
8411: p_period_number => 5);
8412: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8413: (p_period_profile_id => l_period_profile_id,
8414: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8415: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8416: p_project_currency_type => l_currency_type,

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

8415: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8416: p_project_currency_type => l_currency_type,
8417: p_amount_type_id => 215,
8418: p_period_number => 6);
8419: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8420: (p_period_profile_id => l_period_profile_id,
8421: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8422: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8423: p_project_currency_type => l_currency_type,

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

8422: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8423: p_project_currency_type => l_currency_type,
8424: p_amount_type_id => 215,
8425: p_period_number => 7);
8426: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8427: (p_period_profile_id => l_period_profile_id,
8428: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8429: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8430: p_project_currency_type => l_currency_type,

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

8429: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8430: p_project_currency_type => l_currency_type,
8431: p_amount_type_id => 215,
8432: p_period_number => 8);
8433: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8434: (p_period_profile_id => l_period_profile_id,
8435: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8436: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8437: p_project_currency_type => l_currency_type,

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

8436: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8437: p_project_currency_type => l_currency_type,
8438: p_amount_type_id => 215,
8439: p_period_number => 9);
8440: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8441: (p_period_profile_id => l_period_profile_id,
8442: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8443: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8444: p_project_currency_type => l_currency_type,

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

8443: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8444: p_project_currency_type => l_currency_type,
8445: p_amount_type_id => 215,
8446: p_period_number => 10);
8447: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8448: (p_period_profile_id => l_period_profile_id,
8449: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8450: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8451: p_project_currency_type => l_currency_type,

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

8450: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8451: p_project_currency_type => l_currency_type,
8452: p_amount_type_id => 215,
8453: p_period_number => 11);
8454: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8455: (p_period_profile_id => l_period_profile_id,
8456: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8457: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8458: p_project_currency_type => l_currency_type,

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

8457: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8458: p_project_currency_type => l_currency_type,
8459: p_amount_type_id => 215,
8460: p_period_number => 12);
8461: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8462: (p_period_profile_id => l_period_profile_id,
8463: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8464: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8465: p_project_currency_type => l_currency_type,

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

8464: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8465: p_project_currency_type => l_currency_type,
8466: p_amount_type_id => 215,
8467: p_period_number => 13);
8468: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8469: (p_period_profile_id => l_period_profile_id,
8470: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8471: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8472: p_project_currency_type => l_currency_type,

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

8471: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8472: p_project_currency_type => l_currency_type,
8473: p_amount_type_id => 215,
8474: p_period_number => 0);
8475: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8476: (p_period_profile_id => l_period_profile_id,
8477: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8478: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8479: p_project_currency_type => l_currency_type,

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

8529: l_pd_has_child_element(l_row_number) := 'N';
8530: else
8531: l_pd_has_child_element(l_row_number) := 'Y';
8532: end if;
8533: l_pd_period_1(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8534: (p_period_profile_id => l_period_profile_id,
8535: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8536: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8537: p_project_currency_type => l_currency_type,

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

8536: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8537: p_project_currency_type => l_currency_type,
8538: p_amount_type_id => 100,
8539: p_period_number => 1);
8540: l_pd_period_2(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8541: (p_period_profile_id => l_period_profile_id,
8542: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8543: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8544: p_project_currency_type => l_currency_type,

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

8543: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8544: p_project_currency_type => l_currency_type,
8545: p_amount_type_id => 100,
8546: p_period_number => 2);
8547: l_pd_period_3(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8548: (p_period_profile_id => l_period_profile_id,
8549: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8550: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8551: p_project_currency_type => l_currency_type,

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

8550: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8551: p_project_currency_type => l_currency_type,
8552: p_amount_type_id => 100,
8553: p_period_number => 3);
8554: l_pd_period_4(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8555: (p_period_profile_id => l_period_profile_id,
8556: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8557: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8558: p_project_currency_type => l_currency_type,

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

8557: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8558: p_project_currency_type => l_currency_type,
8559: p_amount_type_id => 100,
8560: p_period_number => 4);
8561: l_pd_period_5(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8562: (p_period_profile_id => l_period_profile_id,
8563: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8564: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8565: p_project_currency_type => l_currency_type,

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

8564: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8565: p_project_currency_type => l_currency_type,
8566: p_amount_type_id => 100,
8567: p_period_number => 5);
8568: l_pd_period_6(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8569: (p_period_profile_id => l_period_profile_id,
8570: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8571: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8572: p_project_currency_type => l_currency_type,

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

8571: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8572: p_project_currency_type => l_currency_type,
8573: p_amount_type_id => 100,
8574: p_period_number => 6);
8575: l_pd_period_7(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8576: (p_period_profile_id => l_period_profile_id,
8577: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8578: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8579: p_project_currency_type => l_currency_type,

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

8578: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8579: p_project_currency_type => l_currency_type,
8580: p_amount_type_id => 100,
8581: p_period_number => 7);
8582: l_pd_period_8(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8583: (p_period_profile_id => l_period_profile_id,
8584: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8585: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8586: p_project_currency_type => l_currency_type,

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

8585: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8586: p_project_currency_type => l_currency_type,
8587: p_amount_type_id => 100,
8588: p_period_number => 8);
8589: l_pd_period_9(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8590: (p_period_profile_id => l_period_profile_id,
8591: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8592: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8593: p_project_currency_type => l_currency_type,

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

8592: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8593: p_project_currency_type => l_currency_type,
8594: p_amount_type_id => 100,
8595: p_period_number => 9);
8596: l_pd_period_10(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8597: (p_period_profile_id => l_period_profile_id,
8598: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8599: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8600: p_project_currency_type => l_currency_type,

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

8599: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8600: p_project_currency_type => l_currency_type,
8601: p_amount_type_id => 100,
8602: p_period_number => 10);
8603: l_pd_period_11(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8604: (p_period_profile_id => l_period_profile_id,
8605: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8606: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8607: p_project_currency_type => l_currency_type,

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

8606: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8607: p_project_currency_type => l_currency_type,
8608: p_amount_type_id => 100,
8609: p_period_number => 11);
8610: l_pd_period_12(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8611: (p_period_profile_id => l_period_profile_id,
8612: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8613: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8614: p_project_currency_type => l_currency_type,

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

8613: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8614: p_project_currency_type => l_currency_type,
8615: p_amount_type_id => 100,
8616: p_period_number => 12);
8617: l_pd_period_13(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8618: (p_period_profile_id => l_period_profile_id,
8619: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8620: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8621: p_project_currency_type => l_currency_type,

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

8620: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8621: p_project_currency_type => l_currency_type,
8622: p_amount_type_id => 100,
8623: p_period_number => 13);
8624: l_pd_preceding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8625: (p_period_profile_id => l_period_profile_id,
8626: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8627: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8628: p_project_currency_type => l_currency_type,

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

8627: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8628: p_project_currency_type => l_currency_type,
8629: p_amount_type_id => 100,
8630: p_period_number => 0);
8631: l_pd_succeeding(l_row_number) := pa_fp_view_plans_util.get_period_n_value
8632: (p_period_profile_id => l_period_profile_id,
8633: p_budget_version_id => l_pd_budget_version_id(l_row_number),
8634: p_resource_assignment_id => l_pd_res_assignment_id(l_row_number),
8635: p_project_currency_type => l_currency_type,