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

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 2262: l_target_project_id pa_projects.project_id%TYPE;

2258: l_return_status VARCHAR2(2000);
2259: l_debug_mode VARCHAR2(30);
2260:
2261: l_adj_percentage NUMBER ;
2262: l_target_project_id pa_projects.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;

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 4011: from pa_projects_all ppa,

4007: IF p_calling_context='WORKPLAN' THEN
4008:
4009: select ppa.carrying_out_organization_id
4010: into l_project_org
4011: from pa_projects_all ppa,
4012: pa_budget_versions pbv
4013: where pbv.budget_version_id = p_target_plan_version_id
4014: and pbv.project_id = ppa.project_id;
4015:

Line 5278: l_target_project_id pa_projects.project_id%TYPE;

5274: l_msg_index_out NUMBER;
5275: l_return_status VARCHAR2(2000);
5276: l_debug_mode VARCHAR2(30);
5277: l_ignore_amount_type pa_proj_periods_denorm.amount_type_code%TYPE;
5278: l_target_project_id pa_projects.project_id%TYPE;
5279:
5280: BEGIN
5281:
5282: x_msg_count := 0;

Line 5600: x_new_project_id pa_projects.project_id%TYPE;

5596: l_return_status VARCHAR2(2000);
5597: l_msg_count NUMBER :=0;
5598: l_msg_data VARCHAR2(2000);
5599: x_delta NUMBER;
5600: x_new_project_id pa_projects.project_id%TYPE;
5601: x_orig_project_id pa_projects.project_id%TYPE;
5602: x_orig_template_flag pa_projects.template_flag%TYPE;
5603: l_agreement_amount NUMBER; -- Added for bug 2986930
5604: l_baseline_funding_flag VARCHAR2(1); -- Added for bug 2986930

Line 5601: x_orig_project_id pa_projects.project_id%TYPE;

5597: l_msg_count NUMBER :=0;
5598: l_msg_data VARCHAR2(2000);
5599: x_delta NUMBER;
5600: x_new_project_id pa_projects.project_id%TYPE;
5601: x_orig_project_id pa_projects.project_id%TYPE;
5602: x_orig_template_flag pa_projects.template_flag%TYPE;
5603: l_agreement_amount NUMBER; -- Added for bug 2986930
5604: l_baseline_funding_flag VARCHAR2(1); -- Added for bug 2986930
5605: BEGIN

Line 5602: x_orig_template_flag pa_projects.template_flag%TYPE;

5598: l_msg_data VARCHAR2(2000);
5599: x_delta NUMBER;
5600: x_new_project_id pa_projects.project_id%TYPE;
5601: x_orig_project_id pa_projects.project_id%TYPE;
5602: x_orig_template_flag pa_projects.template_flag%TYPE;
5603: l_agreement_amount NUMBER; -- Added for bug 2986930
5604: l_baseline_funding_flag VARCHAR2(1); -- Added for bug 2986930
5605: BEGIN
5606:

Line 6027: l_source_template_flag pa_projects_all.template_flag%TYPE;

6023: l_period_type VARCHAR2(15);
6024:
6025: l_proj_fp_options_id_tbl PA_FP_COPY_FROM_PKG.PROJ_FP_OPTIONS_ID_TBL_TYP;
6026:
6027: l_source_template_flag pa_projects_all.template_flag%TYPE;
6028: l_source_current_flag pa_budget_versions.current_flag%TYPE;
6029: l_source_version_id pa_budget_versions.budget_version_id%TYPE;
6030: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
6031: l_source_record_version_num pa_budget_versions.record_version_number%TYPE;

Line 6064: FROM pa_projects

6060: AND approved_rev_plan_type_flag = 'Y');
6061:
6062: CURSOR c_bfl IS
6063: SELECT baseline_funding_flag
6064: FROM pa_projects
6065: WHERE project_id = p_source_project_id;
6066:
6067: l_ar_exists VARCHAR2(1);
6068: l_baseline_funding_flag VARCHAR2(1);

Line 6132: FROM pa_projects_all

6128: END IF;
6129:
6130: SELECT template_flag
6131: INTO l_source_template_flag
6132: FROM pa_projects_all
6133: WHERE project_id = p_source_project_id;
6134:
6135: --Fetch project_level_funding_flag for target project to
6136: --baseline it or not

Line 7417: FROM pa_projects p

7413: SELECT start_date,
7414: completion_date
7415: INTO l_target_proj_start_date,
7416: l_target_proj_completion_date
7417: FROM pa_projects p
7418: WHERE p.project_id = p_target_project_id;
7419:
7420: IF l_shift_days <> 0
7421: AND l_target_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,

Line 7433: FROM pa_projects p

7429: END IF;
7430:
7431: SELECT p.start_date
7432: INTO l_start_date
7433: FROM pa_projects p
7434: WHERE p.project_id = p_source_project_id;
7435:
7436: IF l_start_date IS NULL THEN
7437:

Line 8144: ( p_target_project_id IN pa_projects.project_id%TYPE

8140: profiles of the source project.
8141: ===================================================================*/
8142:
8143: PROCEDURE Copy_Current_Period_Profiles
8144: ( p_target_project_id IN pa_projects.project_id%TYPE
8145: ,p_source_project_id IN pa_projects.project_id%TYPE
8146: ,p_shift_days IN NUMBER
8147: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8148: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 8145: ,p_source_project_id IN pa_projects.project_id%TYPE

8141: ===================================================================*/
8142:
8143: PROCEDURE Copy_Current_Period_Profiles
8144: ( p_target_project_id IN pa_projects.project_id%TYPE
8145: ,p_source_project_id IN pa_projects.project_id%TYPE
8146: ,p_shift_days IN NUMBER
8147: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8148: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8149: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 8289: ( p_target_project_id IN pa_projects.project_id%TYPE

8285: we make the target project start date as period profile start date.
8286: ================================================================================*/
8287:
8288: PROCEDURE Get_Create_Shifted_PD_Profile
8289: ( p_target_project_id IN pa_projects.project_id%TYPE
8290: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE
8291: ,p_shift_days IN NUMBER
8292: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895
8293: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8428: FROM pa_projects_all p

8424: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL ,NULL) --pa_period_type
8425: INTO l_period_set_name
8426: ,l_accounted_period_type
8427: ,l_pa_period_type
8428: FROM pa_projects_all p
8429: -- MOAC changes
8430: -- replaced with pa_implementations_all table.
8431: --,pa_implementations a
8432: ,pa_implementations_all a

Line 10069: p_project_id IN pa_projects_all.project_id%TYPE

10065: copied as it is from the source version retaining the version level rolled up figures.
10066: ==============================================================================*/
10067:
10068: PROCEDURE Update_Plan_Setup_For_WP_Copy(
10069: p_project_id IN pa_projects_all.project_id%TYPE
10070: ,p_wp_version_id IN pa_budget_versions.fin_plan_type_id%TYPE
10071: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10072: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10073: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895