[Home] [Help]
153: pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID := p_orgfcst_version_id;
154: pa_fp_view_plans_pub.G_AMT_OR_PD := p_amt_or_pd; -- this will be used by other procedures
155:
156: -- populate G_UNCAT_RLM_ID: the uncategorized resource list member id
157: pa_fin_plan_utils.Get_Uncat_Resource_List_Info
158: (x_resource_list_id => l_uncat_resource_list_id
159: ,x_resource_list_member_id => l_uncat_rlm_id
160: ,x_track_as_labor_flag => l_track_as_labor_flag
161: ,x_unit_of_measure => l_unit_of_measure
955: x_cost_budget_status_code
956: from pa_budget_versions
957: --4/16/03 where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
958: where budget_version_id = x_cost_bv_id;
959: pa_fin_plan_utils.Check_Locked_By_User
960: (p_user_id => p_user_id,
961: --4/16/03 p_budget_version_id => pa_fp_view_plans_pub.G_FP_COST_VERSION_ID,
962: p_budget_version_id => x_cost_bv_id,
963: x_is_locked_by_userid => l_is_cost_locked_by_user,
968: if l_is_cost_locked_by_user = 'N' then
969: if l_cost_locked_by_person_id is null then
970: x_cost_locked_name := 'NONE';
971: else
972: x_cost_locked_name := pa_fin_plan_utils.get_person_name(l_cost_locked_by_person_id);
973: end if;
974: else
975: x_cost_locked_name := 'SELF';
976: end if; -- is_cost_locked_by_user
986: x_rev_budget_status_code
987: from pa_budget_versions
988: -- where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
989: where budget_version_id = x_revenue_bv_id;
990: pa_fin_plan_utils.Check_Locked_By_User
991: (p_user_id => p_user_id,
992: -- p_budget_version_id => pa_fp_view_plans_pub.G_FP_REV_VERSION_ID,
993: p_budget_version_id => x_revenue_bv_id,
994: x_is_locked_by_userid => l_is_rev_locked_by_user,
999: if l_is_rev_locked_by_user = 'N' then
1000: if l_rev_locked_by_person_id is null then
1001: x_rev_locked_name := 'NONE';
1002: else
1003: x_rev_locked_name := pa_fin_plan_utils.get_person_name(l_rev_locked_by_person_id);
1004: end if;
1005: else
1006: x_rev_locked_name := 'SELF';
1007: end if; -- is_rev_locked_by_user
1187: x_auto_baselined_flag :=
1188: Pa_Fp_Control_Items_Utils.IsFpAutoBaselineEnabled(p_project_id);
1189:
1190: -- populate G_UNCAT_RLM_ID: the uncategorized resource list member id
1191: pa_fin_plan_utils.Get_Uncat_Resource_List_Info
1192: (x_resource_list_id => l_uncat_resource_list_id
1193: ,x_resource_list_member_id => l_uncat_rlm_id
1194: ,x_track_as_labor_flag => l_track_as_labor_flag
1195: ,x_unit_of_measure => l_unit_of_measure
2064: into x_cost_rv_number,
2065: x_budget_status_code
2066: from pa_budget_versions
2067: where budget_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
2068: pa_fin_plan_utils.Check_Locked_By_User
2069: (p_user_id => p_user_id,
2070: p_budget_version_id => pa_fp_view_plans_pub.G_FP_COST_VERSION_ID,
2071: x_is_locked_by_userid => l_is_cost_locked_by_user,
2072: x_locked_by_person_id => l_cost_locked_by_person_id,
2076: if l_is_cost_locked_by_user = 'N' then
2077: if l_cost_locked_by_person_id is null then
2078: x_cost_locked_name := 'NONE';
2079: else
2080: x_cost_locked_name := pa_fin_plan_utils.get_person_name(l_cost_locked_by_person_id);
2081: end if;
2082: else
2083: x_cost_locked_name := 'SELF';
2084: end if; -- is_cost_locked_by_user
2092: into x_rev_rv_number,
2093: x_budget_status_code
2094: from pa_budget_versions
2095: where budget_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
2096: pa_fin_plan_utils.Check_Locked_By_User
2097: (p_user_id => p_user_id,
2098: p_budget_version_id => pa_fp_view_plans_pub.G_FP_REV_VERSION_ID,
2099: x_is_locked_by_userid => l_is_rev_locked_by_user,
2100: x_locked_by_person_id => l_rev_locked_by_person_id,
2104: if l_is_rev_locked_by_user = 'N' then
2105: if l_rev_locked_by_person_id is null then
2106: x_rev_locked_name := 'NONE';
2107: else
2108: x_rev_locked_name := pa_fin_plan_utils.get_person_name(l_rev_locked_by_person_id);
2109: end if;
2110: else
2111: x_rev_locked_name := 'SELF';
2112: end if; -- is_rev_locked_by_user