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 3845: SELECT pfp.plan_class_code FROM pa_fin_plan_types_b pfp,pa_budget_versions pbv

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

Line 3898: from pa_proj_fp_options opt,pa_budget_versions pbv

3894: l_project_id
3895: ,l_fp_options_id
3896: ,l_element_type
3897: ,l_resource_list_id
3898: from pa_proj_fp_options opt,pa_budget_versions pbv
3899: where opt.fin_plan_version_id = pbv.budget_version_id
3900: and pbv.budget_version_id = p_fin_plan_version_id;
3901: EXCEPTION
3902: WHEN NO_DATA_FOUND THEN

Line 4118: ( p_project_id IN pa_budget_versions.project_id%TYPE

4114: -- target resource list member id should be derived and
4115: -- passed to the api
4116:
4117: PROCEDURE Create_CI_Resource_Assignments
4118: ( p_project_id IN pa_budget_versions.project_id%TYPE
4119: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4120: ,p_version_type IN pa_budget_versions.version_type%TYPE
4121: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4122: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4119: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4115: -- passed to the api
4116:
4117: PROCEDURE Create_CI_Resource_Assignments
4118: ( p_project_id IN pa_budget_versions.project_id%TYPE
4119: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4120: ,p_version_type IN pa_budget_versions.version_type%TYPE
4121: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4122: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4123: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4120: ,p_version_type IN pa_budget_versions.version_type%TYPE

4116:
4117: PROCEDURE Create_CI_Resource_Assignments
4118: ( p_project_id IN pa_budget_versions.project_id%TYPE
4119: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4120: ,p_version_type IN pa_budget_versions.version_type%TYPE
4121: ,p_impacted_task_id IN pa_resource_assignments.task_id%TYPE
4122: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4123: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4124: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

4144: -- Bug Fix: 4569365. Removed MRC code.
4145: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE;
4146: l_calling_context VARCHAR2(30);
4147:
4148: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
4149: l_plan_version_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4150:
4151: /* PL/SQL table types to be passed to create_res_task_map */
4152:

Line 4256: FROM pa_budget_versions bv

4252:
4253: BEGIN
4254: SELECT bv.fin_plan_type_id
4255: INTO l_fin_plan_type_id
4256: FROM pa_budget_versions bv
4257: WHERE budget_version_id = p_budget_version_id;
4258: EXCEPTION
4259: WHEN OTHERS THEN
4260: pa_debug.g_err_stage:= 'Failed to fetch plan type and resource list for given budget version';

Line 5607: FROM pa_budget_versions bv,

5603: (c_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE)
5604: IS
5605: SELECT bv.ci_id,
5606: impacted_task_id
5607: FROM pa_budget_versions bv,
5608: pa_ci_impacts ci
5609: WHERE budget_version_id = c_plan_version_id
5610: AND bv.ci_id = ci.ci_id
5611: AND bv.ci_id IS NOT NULL;

Line 6459: FROM pa_budget_versions bv,

6455: WHERE pfo.project_id = p_project_id
6456: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6457: UNION ALL
6458: SELECT pfo.proj_fp_options_id
6459: FROM pa_budget_versions bv,
6460: pa_proj_fp_options pfo
6461: WHERE bv.project_id = p_project_id
6462: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6463: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */

Line 7167: UPDATE pa_budget_versions bv

7163: for the new task, the version has been modified and its
7164: record version number has to be increased */
7165:
7166: FORALL i in l_all_fp_options_tbl.first..l_all_fp_options_tbl.last
7167: UPDATE pa_budget_versions bv
7168: SET bv.record_version_number = bv.record_version_number + 1,
7169: bv.last_update_date = sysdate,
7170: bv.last_updated_by = FND_GLOBAL.USER_ID,
7171: bv.last_update_login = FND_GLOBAL.LOGIN_ID