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_COPY_FROM_PKG dependencies on PA_PROJECTS_ALL

Line 255: l_project_id pa_projects_all.project_id%TYPE;

251:
252: l_source_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
253: l_target_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE ;
254: --l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
255: l_project_id pa_projects_all.project_id%TYPE;
256: l_source_resource_list_id pa_budget_versions.resource_list_id%TYPE;
257: l_baselined_resource_list_id pa_budget_versions.resource_list_id%TYPE;
258:
259: --This variable contains the resource list id of baselined version

Line 1029: l_source_project_id pa_projects_all.project_id%TYPE;

1025: l_return_status VARCHAR2(2000);
1026: l_debug_mode VARCHAR2(30);
1027:
1028: l_adj_percentage NUMBER;
1029: l_source_project_id pa_projects_all.project_id%TYPE;
1030: l_target_project_id pa_projects_all.project_id%TYPE;
1031: l_version_name pa_budget_versions.version_name%TYPE;
1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;

Line 1030: l_target_project_id pa_projects_all.project_id%TYPE;

1026: l_debug_mode VARCHAR2(30);
1027:
1028: l_adj_percentage NUMBER;
1029: l_source_project_id pa_projects_all.project_id%TYPE;
1030: l_target_project_id pa_projects_all.project_id%TYPE;
1031: l_version_name pa_budget_versions.version_name%TYPE;
1032: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1033: l_current_profile_id pa_budget_versions.period_profile_id%TYPE;
1034: l_max_version pa_budget_versions.version_number%TYPE;

Line 2267: l_source_project_id pa_projects_all.project_id%TYPE;

2263: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
2264: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
2265:
2266: l_tmp NUMBER;
2267: l_source_project_id pa_projects_all.project_id%TYPE;
2268: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2269: l_control_flag pa_resource_lists_all_bg.control_flag%TYPE;
2270: l_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2271:

Line 2272: l_project_org pa_projects_all.carrying_out_organization_id%TYPE; -- bug 6161031

2268: l_fin_plan_level_code pa_proj_fp_options.cost_fin_plan_level_code%TYPE;
2269: l_control_flag pa_resource_lists_all_bg.control_flag%TYPE;
2270: l_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
2271:
2272: l_project_org pa_projects_all.carrying_out_organization_id%TYPE; -- bug 6161031
2273:
2274:
2275: BEGIN
2276: x_msg_count := 0;

Line 4023: from pa_projects_all ppa,

4019: IF p_calling_context='WORKPLAN' THEN
4020:
4021: select ppa.carrying_out_organization_id
4022: into l_project_org
4023: from pa_projects_all ppa,
4024: pa_budget_versions pbv
4025: where pbv.budget_version_id = p_target_plan_version_id
4026: and pbv.project_id = ppa.project_id;
4027:

Line 6040: l_source_template_flag pa_projects_all.template_flag%TYPE;

6036: l_period_type VARCHAR2(15);
6037:
6038: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;
6039:
6040: l_source_template_flag pa_projects_all.template_flag%TYPE;
6041: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6042: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6043: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6044: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;

Line 6145: FROM pa_projects_all

6141: END IF;
6142:
6143: SELECT template_flag
6144: INTO l_source_template_flag
6145: FROM pa_projects_all
6146: WHERE project_id = p_source_project_id;
6147:
6148: --Fetch project_level_funding_flag for target project to
6149: --baseline it or not

Line 8455: FROM pa_projects_all p

8451: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL ,NULL) --pa_period_type
8452: INTO l_period_set_name
8453: ,l_accounted_period_type
8454: ,l_pa_period_type
8455: FROM pa_projects_all p
8456: -- MOAC changes
8457: -- replaced with pa_implementations_all table.
8458: --,pa_implementations a
8459: ,pa_implementations_all a

Line 10096: p_project_id IN pa_projects_all.project_id%TYPE

10092: copied as it is from the source version retaining the version level rolled up figures.
10093: ==============================================================================*/
10094:
10095: PROCEDURE Update_Plan_Setup_For_WP_Copy(
10096: p_project_id IN pa_projects_all.project_id%TYPE
10097: ,p_wp_version_id IN pa_budget_versions.fin_plan_type_id%TYPE
10098: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10099: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10100: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895