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.

[Home] [Help]

APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_PROJ_PERIOD_PROFILES

Line 113: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

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);

Line 451: from pa_proj_period_profiles pp,

447: pp.period_profile_id
448: into ll_plan_period_type,
449: pp_plan_start_date,
450: l_period_profile_id
451: from pa_proj_period_profiles pp,
452: pa_budget_versions pbv
453: where pbv.budget_version_id = p_orgfcst_version_id
454: and pbv.period_profile_id = pp.period_profile_id;
455: EXCEPTION

Line 464: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');

460: FND_MSG_PUB.add_exc_msg
461: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
462: p_procedure_name => 'pa_fp_viewplan_hgrid_init:plan period type: 300');
463: END;
464: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');
465:
466: -- get period info based on period_profile_id
467: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(
468: p_period_profile_id => l_period_profile_id,

Line 1026: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

1022: l_plan_end_date DATE;
1023: l_number_of_periods NUMBER;
1024:
1025: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1026: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1027: l_cur_start_period VARCHAR2(30);
1028: l_cur_end_period VARCHAR2(30);
1029:
1030: -- variables for default settings

Line 1729: from pa_proj_period_profiles pp,

1725: pp.period_profile_id
1726: into ll_plan_period_type,
1727: pp_plan_start_date,
1728: l_period_profile_id
1729: from pa_proj_period_profiles pp,
1730: pa_budget_versions pbv
1731: where pbv.budget_version_id = pa_fp_view_plans_pub.G_FP_VIEW_VERSION_ID
1732: and pp.period_profile_id = pbv.period_profile_id;
1733: EXCEPTION

Line 1742: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');

1738: FND_MSG_PUB.add_exc_msg
1739: ( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
1740: p_procedure_name => 'pa_fp_viewplan_hgrid_init:plan period type: 300');
1741: END;
1742: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');
1743:
1744:
1745: -- SETTING PERIOD INFORMATION --
1746: -- ONLY IF IN PERIODIC MODE --

Line 2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;

2709: l_working_or_baselined VARCHAR2(1);
2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;
2717: l_cost_version_name pa_budget_versions.version_name%TYPE;

Line 2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;

2710: l_compl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2711: l_compl_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2712: l_compl_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2713: l_period_profile_id1 pa_proj_period_profiles.period_profile_id%TYPE;
2714: l_period_profile_id2 pa_proj_period_profiles.period_profile_id%TYPE;
2715: l_cost_version_number pa_budget_versions.version_number%TYPE;
2716: l_rev_version_number pa_budget_versions.version_number%TYPE;
2717: l_cost_version_name pa_budget_versions.version_name%TYPE;
2718: l_rev_version_name pa_budget_versions.version_name%TYPE;

Line 3640: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

3636: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3637: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3638: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3639: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
3640: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
3641: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
3642: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
3643: l_currency_type VARCHAR2(30);
3644:

Line 6261: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

6257: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
6258: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
6259: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6260: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
6261: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
6262: l_default_amount_type_code pa_proj_fp_options.default_amount_type_code%TYPE;
6263: l_default_amount_subtype_code pa_proj_fp_options.default_amount_subtype_code%TYPE;
6264: l_currency_type VARCHAR2(30);
6265:

Line 7341: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

7337: /* local variables */
7338: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
7339: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7340: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
7341: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
7342: l_default_amount_type_code VARCHAR2(30);
7343: l_default_amount_subtype_code VARCHAR2(30);
7344: l_currency_type VARCHAR2(30);
7345: