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

5286: l_msg_index_out NUMBER;
5287: l_return_status VARCHAR2(2000);
5288: l_debug_mode VARCHAR2(30);
5289: l_ignore_amount_type pa_proj_periods_denorm.amount_type_code%TYPE;
5290: l_target_project_id pa_projects.project_id%TYPE;
5291:
5292: BEGIN
5293:
5294: x_msg_count := 0;

Line 5612: x_new_project_id pa_projects.project_id%TYPE;

5608: l_return_status VARCHAR2(2000);
5609: l_msg_count NUMBER :=0;
5610: l_msg_data VARCHAR2(2000);
5611: x_delta NUMBER;
5612: x_new_project_id pa_projects.project_id%TYPE;
5613: x_orig_project_id pa_projects.project_id%TYPE;
5614: x_orig_template_flag pa_projects.template_flag%TYPE;
5615: l_agreement_amount NUMBER; -- Added for bug 2986930
5616: l_baseline_funding_flag VARCHAR2(1); -- Added for bug 2986930

Line 5613: x_orig_project_id pa_projects.project_id%TYPE;

5609: l_msg_count NUMBER :=0;
5610: l_msg_data VARCHAR2(2000);
5611: x_delta NUMBER;
5612: x_new_project_id pa_projects.project_id%TYPE;
5613: x_orig_project_id pa_projects.project_id%TYPE;
5614: x_orig_template_flag pa_projects.template_flag%TYPE;
5615: l_agreement_amount NUMBER; -- Added for bug 2986930
5616: l_baseline_funding_flag VARCHAR2(1); -- Added for bug 2986930
5617: BEGIN

Line 5614: x_orig_template_flag pa_projects.template_flag%TYPE;

5610: l_msg_data VARCHAR2(2000);
5611: x_delta NUMBER;
5612: x_new_project_id pa_projects.project_id%TYPE;
5613: x_orig_project_id pa_projects.project_id%TYPE;
5614: x_orig_template_flag pa_projects.template_flag%TYPE;
5615: l_agreement_amount NUMBER; -- Added for bug 2986930
5616: l_baseline_funding_flag VARCHAR2(1); -- Added for bug 2986930
5617: BEGIN
5618:

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 6077: FROM pa_projects

6073: AND approved_rev_plan_type_flag = 'Y');
6074:
6075: CURSOR c_bfl IS
6076: SELECT baseline_funding_flag
6077: FROM pa_projects
6078: WHERE project_id = p_source_project_id;
6079:
6080: l_ar_exists VARCHAR2(1);
6081: l_baseline_funding_flag VARCHAR2(1);

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 7436: FROM pa_projects p

7432: SELECT start_date,
7433: completion_date
7434: INTO l_target_proj_start_date,
7435: l_target_proj_completion_date
7436: FROM pa_projects p
7437: WHERE p.project_id = p_target_project_id;
7438:
7439: IF l_shift_days <> 0
7440: AND l_target_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,

Line 7452: FROM pa_projects p

7448: END IF;
7449:
7450: SELECT p.start_date
7451: INTO l_start_date
7452: FROM pa_projects p
7453: WHERE p.project_id = p_source_project_id;
7454:
7455: IF l_start_date IS NULL THEN
7456:

Line 8171: ( p_target_project_id IN pa_projects.project_id%TYPE

8167: profiles of the source project.
8168: ===================================================================*/
8169:
8170: PROCEDURE Copy_Current_Period_Profiles
8171: ( p_target_project_id IN pa_projects.project_id%TYPE
8172: ,p_source_project_id IN pa_projects.project_id%TYPE
8173: ,p_shift_days IN NUMBER
8174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8175: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 8172: ,p_source_project_id IN pa_projects.project_id%TYPE

8168: ===================================================================*/
8169:
8170: PROCEDURE Copy_Current_Period_Profiles
8171: ( p_target_project_id IN pa_projects.project_id%TYPE
8172: ,p_source_project_id IN pa_projects.project_id%TYPE
8173: ,p_shift_days IN NUMBER
8174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8175: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8176: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 8316: ( p_target_project_id IN pa_projects.project_id%TYPE

8312: we make the target project start date as period profile start date.
8313: ================================================================================*/
8314:
8315: PROCEDURE Get_Create_Shifted_PD_Profile
8316: ( p_target_project_id IN pa_projects.project_id%TYPE
8317: ,p_source_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE
8318: ,p_shift_days IN NUMBER
8319: ,x_target_period_profile_id OUT NOCOPY pa_proj_period_profiles.period_profile_id%TYPE --File.Sql.39 bug 4440895
8320: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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