[Home] [Help]
109: l_plan_end_date DATE;
110: l_number_of_periods NUMBER;
111:
112: -- local variables for calling Pa_Prj_Period_Profile_Utils procedures
113: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
114: l_cur_start_period VARCHAR2(30);
115: l_cur_end_period VARCHAR2(30);
116: l_cur_period_number NUMBER;
117: l_cur_period_name VARCHAR2(100);
451: pp.period_profile_id
452: into ll_plan_period_type,
453: pp_plan_start_date,
454: l_period_profile_id
455: from pa_proj_period_profiles pp,
456: pa_budget_versions pbv
457: where pbv.budget_version_id = p_orgfcst_version_id
458: and pbv.period_profile_id = pp.period_profile_id;
459: Ends commented for 7514054 and added below code
478: FND_MSG_PUB.add_exc_msg
479: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
480: p_procedure_name => 'pa_fp_viewplan_hgrid_init:plan period type: 300');
481: END;
482: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');
483:
484: -- get period info based on period_profile_id
485: /* Starts Commented for bug 7456425
486: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(
1118: l_plan_end_date DATE;
1119: l_number_of_periods NUMBER;
1120:
1121: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1122: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1123: l_cur_start_period VARCHAR2(30);
1124: l_cur_end_period VARCHAR2(30);
1125:
1126: -- variables for default settings
1822: pp.period_profile_id
1823: into ll_plan_period_type,
1824: pp_plan_start_date,
1825: l_period_profile_id
1826: from pa_proj_period_profiles pp,
1827: pa_budget_versions pbv
1828: where pbv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID
1829: and pp.period_profile_id = pbv.period_profile_id;
1830: Ends commented for 7514054 and added below code
1849: FND_MSG_PUB.add_exc_msg
1850: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
1851: p_procedure_name => 'pa_fp_viewplan_hgrid_init:plan period type: 300');
1852: END;
1853: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');
1854:
1855:
1856: -- SETTING PERIOD INFORMATION --
1857: -- ONLY IF IN PERIODIC MODE --
2827: l_working_or_baselined VARCHAR2(1);
2828: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2829: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2830: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2831: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2833: l_cost_version_number pa_budget_versions.version_number%TYPE;
2834: l_rev_version_number pa_budget_versions.version_number%TYPE;
2835: l_cost_version_name pa_budget_versions.version_name%TYPE;
2828: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2829: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2830: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2831: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2832: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2833: l_cost_version_number pa_budget_versions.version_number%TYPE;
2834: l_rev_version_number pa_budget_versions.version_number%TYPE;
2835: l_cost_version_name pa_budget_versions.version_name%TYPE;
2836: l_rev_version_name pa_budget_versions.version_name%TYPE;
3754: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3755: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3756: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3757: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
3758: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
3759: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
3760: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
3761: l_currency_type VARCHAR2(30);
3762:
6856: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
6857: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
6858: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6859: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
6860: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
6861: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
6862: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
6863: l_currency_type VARCHAR2(30);
6864:
8291: /* local variables */
8292: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
8293: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8294: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
8295: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
8296: l_default_amount_type_code VARCHAR2(30);
8297: l_default_amount_subtype_code VARCHAR2(30);
8298: l_currency_type VARCHAR2(30);
8299: