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_ELEMENTS_PUB dependencies on PA_BUDGET_VERSIONS

Line 2094: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;

2090: l_debug_mode VARCHAR2(30);
2091:
2092: l_max_fetch_size NUMBER := 200; -- limiting the max fetch size
2093:
2094: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;
2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;

Line 2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;

2091:
2092: l_max_fetch_size NUMBER := 200; -- limiting the max fetch size
2093:
2094: l_resource_list_id PA_BUDGET_VERSIONS.RESOURCE_LIST_ID%TYPE;
2095: l_project_id PA_BUDGET_VERSIONS.PROJECT_ID%TYPE;
2096: l_uncat_flag PA_RESOURCE_LISTS.UNCATEGORIzED_FLAG%TYPE;
2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;

Line 2224: FROM pa_budget_versions

2220: SELECT resource_list_id
2221: ,project_id
2222: INTO l_resource_list_id
2223: ,l_project_id
2224: FROM pa_budget_versions
2225: WHERE budget_version_id = p_plan_version_id;
2226:
2227: -- 3062798 fetch options_id and use in the cursors to
2228: -- avoid full table scan on pa_fp_elements

Line 2752: ,p_from_version_id IN pa_budget_versions.budget_version_id%TYPE

2748: ===================================================================*/
2749: PROCEDURE Create_elements_from_version(
2750: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2751: ,p_element_type IN pa_fp_elements.element_type%TYPE
2752: ,p_from_version_id IN pa_budget_versions.budget_version_id%TYPE
2753: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2754: ,x_mixed_resource_planned_flag OUT NOCOPY VARCHAR2 -- new parameter for Bug :- 2625872 --File.Sql.39 bug 4440895
2755: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2756: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2753: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

2749: PROCEDURE Create_elements_from_version(
2750: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2751: ,p_element_type IN pa_fp_elements.element_type%TYPE
2752: ,p_from_version_id IN pa_budget_versions.budget_version_id%TYPE
2753: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2754: ,x_mixed_resource_planned_flag OUT NOCOPY VARCHAR2 -- new parameter for Bug :- 2625872 --File.Sql.39 bug 4440895
2755: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2756: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2757: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 2813: c_from_version_id IN pa_budget_versions.budget_version_id%TYPE) IS

2809: -- The following cursor is opened for the case of project level planning and
2810: -- categorized resource list
2811:
2812: CURSOR resources_for_proj_level_cur(
2813: c_from_version_id IN pa_budget_versions.budget_version_id%TYPE) IS
2814: SELECT 0 task_id
2815: ,0 top_task_id
2816: ,pra.resource_list_member_id resource_list_member_id
2817: ,NULL top_task_planning_level

Line 2839: c_from_version_id IN pa_budget_versions.budget_version_id%TYPE) IS

2835: -- The following cursor is opened for the case of task level planning and
2836: -- categorized resource list to fetch resource level records
2837:
2838: CURSOR resources_for_task_level_cur(
2839: c_from_version_id IN pa_budget_versions.budget_version_id%TYPE) IS
2840: SELECT pra.task_id task_id
2841: ,pt.top_task_id top_task_id
2842: ,pra.resource_list_member_id resource_list_member_id
2843: ,NULL top_task_planning_level

Line 2886: c_from_version_id IN pa_budget_versions.budget_version_id%TYPE) IS

2882: top task records only.
2883: */
2884:
2885: CURSOR task_level_elements_cur(
2886: c_from_version_id IN pa_budget_versions.budget_version_id%TYPE) IS
2887: SELECT DISTINCT pra.task_id task_id
2888: ,pt.top_task_id top_task_id
2889: ,0 resource_list_member_id
2890: /* Bug 3019572

Line 3757: ( p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

3753: pa_fp_rollup_tmp table(task_id in system_reference1 and resource_list_member_id in
3754: system_reference2). The resource assignment id contains -1 if the RA id doesnot exist.
3755: */
3756: PROCEDURE CREATE_ASSGMT_FROM_ROLLUPTMP
3757: ( p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
3758: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3759: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3760: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3761:

Line 3795: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

3791:
3792: l_project_id pa_projects_all.project_id%TYPE;
3793: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3794: l_element_type pa_fp_elements.element_type%TYPE;
3795: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3796: l_mixed_resource_planned_flag VARCHAR2(1); -- Added for Bug:- 2625872
3797:
3798: --Bug # 3507156 : Patchset M: B and F impact changes : AMG
3799: --Added some variables.

Line 3850: SELECT pfp.plan_class_code FROM pa_fin_plan_types_b pfp,pa_budget_versions pbv

3846: --Bug # 3507156 : Patchset M: B and F impact changes : AMG
3847: --Added a curosr to get the value of plan_class_code
3848:
3849: CURSOR get_context_csr IS
3850: SELECT pfp.plan_class_code FROM pa_fin_plan_types_b pfp,pa_budget_versions pbv
3851: WHERE pfp.FIN_PLAN_TYPE_ID = pbv.FIN_PLAN_TYPE_ID
3852: AND pbv.budget_version_id =p_fin_plan_version_id ;
3853:
3854: BEGIN

Line 3903: from pa_proj_fp_options opt,pa_budget_versions pbv

3899: l_project_id
3900: ,l_fp_options_id
3901: ,l_element_type
3902: ,l_resource_list_id
3903: from pa_proj_fp_options opt,pa_budget_versions pbv
3904: where opt.fin_plan_version_id = pbv.budget_version_id
3905: and pbv.budget_version_id = p_fin_plan_version_id;
3906: EXCEPTION
3907: WHEN NO_DATA_FOUND THEN

Line 4127: ( p_project_id IN pa_budget_versions.project_id%TYPE

4123: -- target resource list member id should be derived and
4124: -- passed to the api
4125:
4126: PROCEDURE Create_CI_Resource_Assignments
4127: ( p_project_id IN pa_budget_versions.project_id%TYPE
4128: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4129: ,p_version_type IN pa_budget_versions.version_type%TYPE
4130: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4128: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4124: -- passed to the api
4125:
4126: PROCEDURE Create_CI_Resource_Assignments
4127: ( p_project_id IN pa_budget_versions.project_id%TYPE
4128: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4129: ,p_version_type IN pa_budget_versions.version_type%TYPE
4130: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4132: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4129: ,p_version_type IN pa_budget_versions.version_type%TYPE

4125:
4126: PROCEDURE Create_CI_Resource_Assignments
4127: ( p_project_id IN pa_budget_versions.project_id%TYPE
4128: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4129: ,p_version_type IN pa_budget_versions.version_type%TYPE
4130: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4132: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4133: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4157: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;

4153: -- Bug Fix: 4569365. Removed MRC code.
4154: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
4155: l_calling_context VARCHAR2(30);
4156:
4157: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
4158: l_plan_version_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4159:
4160: /* PL/SQL table types to be passed to create_res_task_map */
4161:

Line 4265: FROM pa_budget_versions bv

4261:
4262: BEGIN
4263: SELECT bv.fin_plan_type_id
4264: INTO l_fin_plan_type_id
4265: FROM pa_budget_versions bv
4266: WHERE budget_version_id = p_budget_version_id;
4267: EXCEPTION
4268: WHEN OTHERS THEN
4269: pa_debug.g_err_stage:= 'Failed to fetch plan type and resource list for given budget version';

Line 5616: FROM pa_budget_versions bv,

5612: (c_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE)
5613: IS
5614: SELECT bv.ci_id,
5615: impacted_task_id
5616: FROM pa_budget_versions bv,
5617: pa_ci_impacts ci
5618: WHERE budget_version_id = c_plan_version_id
5619: AND bv.ci_id = ci.ci_id
5620: AND bv.ci_id IS NOT NULL;

Line 6468: FROM pa_budget_versions bv,

6464: WHERE pfo.project_id = p_project_id
6465: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6466: UNION ALL
6467: SELECT pfo.proj_fp_options_id
6468: FROM pa_budget_versions bv,
6469: pa_proj_fp_options pfo
6470: WHERE bv.project_id = p_project_id
6471: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6472: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */

Line 7176: UPDATE pa_budget_versions bv

7172: for the new task, the version has been modified and its
7173: record version number has to be increased */
7174:
7175: FORALL i in l_all_fp_options_tbl.first..l_all_fp_options_tbl.last
7176: UPDATE pa_budget_versions bv
7177: SET bv.record_version_number = bv.record_version_number + 1,
7178: bv.last_update_date = sysdate,
7179: bv.last_updated_by = FND_GLOBAL.USER_ID,
7180: bv.last_update_login = FND_GLOBAL.LOGIN_ID