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

Line 53: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE

49: PROCEDURE Process_res_chg_Derv_calc_prms
50: (
51: p_context IN VARCHAR2
52: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
53: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
54: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
55: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
56: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
57: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 113: ,pa_budget_versions pbv

109: ,pbv.ci_id ci_id
110: ,pbv.etc_start_date etc_start_date
111: ,pbv.wp_version_flag wp_version_flag
112: FROM pa_proj_fp_options pfo
113: ,pa_budget_versions pbv
114: WHERE pfo.fin_plan_version_id=p_budget_version_id
115: AND pbv.budget_version_id=p_budget_version_id;
116:
117:

Line 1221: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

1217: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
1218: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1219: ,p_project_id IN Pa_projects_all.project_id%TYPE
1220: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1221: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1222: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1224: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 1299: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1295: l_return_status VARCHAR2(2000);
1296: l_debug_mode VARCHAR2(30);
1297: --End of variables used for debugging
1298:
1299: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1300: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1301: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1302: l_rlm_id_tbl_count NUMBER := 0;
1303: l_elem_version_id_count NUMBER := 0;

Line 5304: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE

5300: (
5301: p_context IN VARCHAR2
5302: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
5303: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
5304: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5305: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5307: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5308: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 5426: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

5422: l_module_name VARCHAR2(100) := 'Update_Planning_Transactions' || 'pa.plsql.pa_fp_planning_transaction_pub';
5423: l_loop_start NUMBER;
5424: l_loop_end NUMBER;
5425:
5426: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5427: l_project_id pa_projects_all.project_id%TYPE;
5428: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
5429: l_pji_rollup_required VARCHAR2(1); --Bug 4200168
5430:

Line 5760: FROM pa_budget_versions

5756: */
5757: BEGIN
5758: SELECT project_id
5759: INTO l_project_id
5760: FROM pa_budget_versions
5761: WHERE budget_version_id = l_budget_version_id;
5762: EXCEPTION
5763: WHEN OTHERS THEN
5764: IF l_debug_mode = 'Y' THEN

Line 5765: pa_debug.g_err_stage:='Select failed on pa_budget_versions.';

5761: WHERE budget_version_id = l_budget_version_id;
5762: EXCEPTION
5763: WHEN OTHERS THEN
5764: IF l_debug_mode = 'Y' THEN
5765: pa_debug.g_err_stage:='Select failed on pa_budget_versions.';
5766: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5767: END IF;
5768: RAISE;
5769: END;

Line 7497: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

7493: p_context IN VARCHAR2
7494: ,p_copy_external_flag IN VARCHAR2
7495: ,p_src_project_id IN pa_projects_all.project_id%TYPE
7496: ,p_target_project_id IN pa_projects_all.project_id%TYPE
7497: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7498: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7499: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
7500: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
7501: ,p_copy_people_flag IN VARCHAR2 := NULL

Line 7498: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

7494: ,p_copy_external_flag IN VARCHAR2
7495: ,p_src_project_id IN pa_projects_all.project_id%TYPE
7496: ,p_target_project_id IN pa_projects_all.project_id%TYPE
7497: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7498: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7499: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
7500: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
7501: ,p_copy_people_flag IN VARCHAR2 := NULL
7502: ,p_copy_equip_flag IN VARCHAR2 := NULL

Line 7526: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;

7522: l_adj_percent NUMBER;
7523: i NUMBER;
7524: j NUMBER;
7525: l_row_count NUMBER;
7526: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7527: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7528: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7529: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7530: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 7527: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;

7523: i NUMBER;
7524: j NUMBER;
7525: l_row_count NUMBER;
7526: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7527: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7528: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7529: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7530: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7531: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 7695: pa_budget_versions pbv

7691: --Derive the plan version id for the source and target element version ids
7692: SELECT pbv.budget_version_id
7693: INTO l_src_budget_version_id
7694: FROM pa_struct_task_wbs_v pt,
7695: pa_budget_versions pbv
7696: WHERE pbv.project_structure_version_id= pt.parent_structure_version_id
7697: AND pt.element_version_id=p_src_version_id_tbl(1)
7698: AND pbv.wp_version_flag='Y';
7699:

Line 7709: FROM pa_budget_versions pbv

7705:
7706: --dbms_output.put_line('in copy plan txn2.5');
7707: SELECT pbv.budget_version_id
7708: INTO l_targ_budget_version_id
7709: FROM pa_budget_versions pbv
7710: ,pa_struct_task_wbs_v pt
7711: WHERE pt.element_version_id=p_targ_version_id_tbl(1)
7712: AND pbv.project_structure_version_id=pt.parent_structure_version_id
7713: AND pbv.wp_version_flag='Y';

Line 8574: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

8570: l_task_assmt_ids_tbl SYSTEM.pa_num_tbl_type;
8571:
8572: l_counter NUMBER;
8573: l_ra_index NUMBER;
8574: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8575: l_ci_id pa_budget_versions.ci_id%TYPE;
8576: l_exists VARCHAR2(1);
8577: SKIP_LOOP EXCEPTION;
8578: i NUMBER;

Line 8575: l_ci_id pa_budget_versions.ci_id%TYPE;

8571:
8572: l_counter NUMBER;
8573: l_ra_index NUMBER;
8574: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8575: l_ci_id pa_budget_versions.ci_id%TYPE;
8576: l_exists VARCHAR2(1);
8577: SKIP_LOOP EXCEPTION;
8578: i NUMBER;
8579: l_cntr NUMBER;

Line 8839: ,pa_budget_Versions pbv

8835: INTO l_project_id
8836: ,l_budget_version_id
8837: ,l_ci_id
8838: FROM pa_resource_assignments pra
8839: ,pa_budget_Versions pbv
8840: WHERE pbv.budget_version_id=pra.budget_version_id
8841: AND pbv.wp_version_flag='Y'
8842: AND pra.wbs_element_version_id=p_element_version_id_tbl(l_cntr)
8843: AND rownum < 2 ;

Line 8875: ,pa_budget_Versions pbv

8871: INTO l_project_id
8872: ,l_budget_version_id
8873: ,l_ci_id
8874: FROM pa_resource_assignments pra
8875: ,pa_budget_Versions pbv
8876: WHERE pbv.budget_version_id=pra.budget_version_id
8877: AND pra.resource_assignment_id =l_task_assmt_ids_tbl(1);
8878: EXCEPTION
8879: WHEN NO_DATA_FOUND THEN

Line 8911: ,pa_budget_Versions pbv

8907: INTO l_project_id
8908: ,l_budget_version_id
8909: ,l_ci_id
8910: FROM pa_resource_assignments pra
8911: ,pa_budget_Versions pbv
8912: WHERE pbv.budget_version_id=pra.budget_version_id
8913: AND pra.resource_assignment_id =p_resource_assignment_tbl(1);
8914: EXCEPTION
8915: WHEN NO_DATA_FOUND THEN

Line 9279: pa_budget_versions pbv

9275: DELETE
9276: FROM pa_budget_lines pbl
9277: WHERE pbl.resource_assignment_id IN (SELECT pra.resource_assignment_id
9278: FROM pa_resource_assignments pra,
9279: pa_budget_versions pbv
9280: WHERE pra.budget_Version_id=pbv.budget_Version_id
9281: AND nvl(pbv.wp_version_flag,'N')=l_wp_version_flag
9282: AND pra.budget_Version_id = l_budget_version_id--Bug#4548675--Bug 4218331
9283: AND pbv.budget_Version_id = l_budget_version_id--Bug#4548675--Bug 4218331

Line 9362: FROM pa_budget_Versions pbv

9358: DELETE
9359: FROM pa_resource_assignments pra
9360: WHERE pra.wbs_element_version_id=p_element_version_id_tbl(i)
9361: AND EXISTS (SELECT 'X'
9362: FROM pa_budget_Versions pbv
9363: WHERE pbv.budget_version_id=pra.budget_Version_id
9364: AND pbv.budget_Version_id = l_budget_version_id--Bug#4548675--Bug 4218331
9365: AND nvl(pbv.wp_version_flag,'N')=l_wp_version_flag
9366: AND nvl(l_ta_display_flag , '-99')=nvl(ta_display_flag,'-99'))

Line 10706: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

10702:
10703: ==============================================================================*/
10704:
10705: PROCEDURE Refresh_Plan_Txns(
10706: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10707: ,p_plan_level_change IN VARCHAR2
10708: ,p_resource_list_change IN VARCHAR2
10709: ,p_rbs_version_change IN VARCHAR2
10710: ,p_time_phase_change_flag IN VARCHAR2

Line 10755: FROM pa_proj_fp_options pfo, pa_budget_versions bv

10751: ,'ALL', all_fin_plan_level_code) fin_plan_level_code
10752: ,pfo.rbs_version_id rbs_version_id
10753: ,pfo.fin_plan_type_id fin_plan_type_id
10754: ,bv.ci_id ci_id
10755: FROM pa_proj_fp_options pfo, pa_budget_versions bv
10756: WHERE bv.project_id = pfo.project_id
10757: AND pfo.fin_plan_version_id = bv.budget_version_id
10758: AND bv.budget_version_id = p_budget_version_id;
10759:

Line 11135: -- pa_budget_versions and pa_resource_assignments for the entire version

11131: -- END of IPM changes Bug 5003827 Issue 22
11132:
11133:
11134: -- Calling the rollup api to correct the amounts related data in
11135: -- pa_budget_versions and pa_resource_assignments for the entire version
11136: PA_FP_ROLLUP_PKG.rollup_budget_version
11137: (p_budget_version_id => p_budget_version_id
11138: ,p_entire_version => 'Y'
11139: ,x_return_status => l_return_status

Line 11329: from pa_budget_versions bv,

11325: ,DECODE(fin_plan_preference_code,
11326: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, pfo.all_resource_list_id,
11327: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, pfo.cost_resource_list_id,
11328: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, pfo.revenue_resource_list_id) resource_list_id
11329: from pa_budget_versions bv,
11330: pa_proj_fp_options pfo
11331: where bv.budget_version_id = c_budget_version_id
11332: and pfo.project_id = bv.project_id
11333: and pfo.fin_plan_type_id = bv.fin_plan_type_id

Line 11702: pa_budget_versions should be updated with changed values.

11698: This api is called upon save from Additional Workplan Options page.
11699: For versioning disabled case working version should be updated with values
11700: that of parent plan type record. The changes include deleting all the
11701: existing budget lines, resource assignments. Pa_proj_fp_options and
11702: pa_budget_versions should be updated with changed values.
11703:
11704: Bug 3595063 For a shared structure, update current working version with the
11705: new settings.
11706:

Line 11736: p_project_id IN pa_budget_versions.project_id%TYPE

11732: plan_delete(), plan_create() at the end.
11733: ===============================================================================*/
11734:
11735: PROCEDURE REFRESH_WP_SETTINGS(
11736: p_project_id IN pa_budget_versions.project_id%TYPE
11737: ,p_resource_list_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
11738: ,p_time_phase_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
11739: ,p_rbs_version_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
11740: ,p_track_costs_flag_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687

Line 11824: FROM pa_budget_versions bv,

11820: CURSOR working_workplan_versions_cur IS
11821: SELECT bv.budget_version_id
11822: ,pfo.proj_fp_options_id
11823: ,bv.project_structure_version_id
11824: FROM pa_budget_versions bv,
11825: pa_proj_elem_ver_structure ver,
11826: pa_proj_fp_options pfo
11827: WHERE bv.project_id = p_project_id
11828: AND bv.wp_version_flag = 'Y'

Line 11839: FROM pa_budget_versions bv,

11835:
11836: CURSOR published_versions_cur IS
11837: SELECT bv.budget_version_id
11838: ,pfo.proj_fp_options_id
11839: FROM pa_budget_versions bv,
11840: pa_proj_elem_ver_structure ver,
11841: pa_proj_fp_options pfo
11842: WHERE bv.project_id = p_project_id
11843: AND bv.wp_version_flag = 'Y'

Line 11871: FROM pa_budget_versions bv

11867: -- including the publsihed versions for RBS refresh
11868: CURSOR all_workplan_versions_cur IS
11869: SELECT bv.budget_version_id
11870: ,pfo.proj_fp_options_id
11871: FROM pa_budget_versions bv
11872: ,pa_proj_fp_options pfo
11873: WHERE bv.project_id = p_project_id
11874: AND bv.wp_version_flag = 'Y'
11875: AND pfo.fin_plan_version_id = bv.budget_version_id

Line 12046: /* We also need to update the resource list id in the pa_budget_versions table as well as the

12042: /* Note that we are not updating working wp versions pa_progress_rollup since there is some
12043: processing done for working wp versions in the loop below (delete planning transactions etc
12044: and we want to ensure this update is done after the processing */
12045:
12046: /* We also need to update the resource list id in the pa_budget_versions table as well as the
12047: pa_proj_fp_options table .*/
12048: FORALL i IN l_pub_proj_fp_options_id_tbl.first .. l_pub_proj_fp_options_id_tbl.last
12049: UPDATE pa_proj_fp_options
12050: SET cost_resource_list_id = parent_plan_type_rec.cost_resource_list_id

Line 12058: UPDATE pa_budget_versions

12054: ,last_update_login = FND_GLOBAL.login_id
12055: where proj_fp_options_id = l_pub_proj_fp_options_id_tbl(i);
12056:
12057: FORALL i IN l_pub_budget_version_id_tbl.first .. l_pub_budget_version_id_tbl.last
12058: UPDATE pa_budget_versions
12059: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12060: ,record_version_number = record_version_number + 1
12061: ,last_update_date = SYSDATE
12062: ,last_updated_by = FND_GLOBAL.user_id

Line 12108: UPDATE pa_budget_versions

12104:
12105: -- Update budget_versions data for all the working versions in bulk
12106:
12107: FORALL i IN l_budget_version_id_tbl.first .. l_budget_version_id_tbl.last
12108: UPDATE pa_budget_versions
12109: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12110: ,current_planning_period = parent_plan_type_rec.cost_current_planning_period
12111: ,period_mask_id = parent_plan_type_rec.cost_period_mask_id
12112: -- Bug 3630069 Amounts should not be updated with 0. These columns are taken care of

Line 12577: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

12573: ==============================================================================*/
12574:
12575: PROCEDURE Refresh_rbs_for_versions(
12576: p_project_id IN pa_projects_all.project_id%TYPE
12577: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
12578: ,p_calling_context IN VARCHAR2 -- Default 'ALL_CHILD_VERSIONS'
12579: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null
12580: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12581: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 12579: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null

12575: PROCEDURE Refresh_rbs_for_versions(
12576: p_project_id IN pa_projects_all.project_id%TYPE
12577: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
12578: ,p_calling_context IN VARCHAR2 -- Default 'ALL_CHILD_VERSIONS'
12579: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null
12580: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12581: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
12582: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
12583: AS

Line 12604: pa_budget_versions bv

12600: SELECT o.proj_fp_options_id,
12601: o.fin_plan_version_id,
12602: bv.resource_list_id
12603: FROM pa_proj_fp_options o,
12604: pa_budget_versions bv
12605: WHERE o.project_id = p_project_id
12606: AND o.fin_plan_type_id = p_fin_plan_type_id
12607: AND o.fin_plan_version_id = bv.budget_version_id
12608: AND bv.ci_id IS NULL -- bug 3867302

Line 12617: FROM pa_budget_versions bv,

12613: ,o.fin_plan_version_id
12614: ,bv.resource_list_id
12615: ,o.fin_plan_type_id
12616: ,bv.ci_id
12617: FROM pa_budget_versions bv,
12618: pa_proj_fp_options o
12619: WHERE bv.project_id = o.project_id
12620: AND bv.fin_plan_type_id = o.fin_plan_type_id
12621: AND bv.budget_version_id = o.fin_plan_version_id

Line 12913: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

12909: --This function returns 'N' if a record already exists in pa_resource_assignments
12910: --for a given budget version id, task id and resource list member id
12911: --Returns 'Y' if the record is not already there
12912: FUNCTION DUP_EXISTS
12913: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12914: ,p_task_id IN pa_tasks.task_id%TYPE
12915: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
12916: ,p_project_id IN pa_projects_all.project_id%TYPE)
12917: RETURN VARCHAR2