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 109: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE

105: PROCEDURE Process_res_chg_Derv_calc_prms
106: (
107: p_context IN VARCHAR2
108: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
109: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
110: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
111: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
112: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 169: ,pa_budget_versions pbv

165: ,pbv.ci_id ci_id
166: ,pbv.etc_start_date etc_start_date
167: ,pbv.wp_version_flag wp_version_flag
168: FROM pa_proj_fp_options pfo
169: ,pa_budget_versions pbv
170: WHERE pfo.fin_plan_version_id=p_budget_version_id
171: AND pbv.budget_version_id=p_budget_version_id;
172:
173:

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

1274: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
1275: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1276: ,p_project_id IN Pa_projects_all.project_id%TYPE
1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1278: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1279: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1280: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
1281: DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --bug#16200605
1282: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 1359: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1355: l_return_status VARCHAR2(2000);
1356: l_debug_mode VARCHAR2(30);
1357: --End of variables used for debugging
1358:
1359: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1360: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1361: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1362: l_rlm_id_tbl_count NUMBER := 0;
1363: l_elem_version_id_count NUMBER := 0;

Line 5959: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE

5955: (
5956: p_context IN VARCHAR2
5957: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
5958: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
5959: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5960: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5961: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5962: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5963: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 6082: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

6078: l_module_name VARCHAR2(100) := 'Update_Planning_Transactions' || 'pa.plsql.pa_fp_planning_transaction_pub';
6079: l_loop_start NUMBER;
6080: l_loop_end NUMBER;
6081:
6082: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
6083: l_project_id pa_projects_all.project_id%TYPE;
6084: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
6085: l_pji_rollup_required VARCHAR2(1); --Bug 4200168
6086:

Line 6429: FROM pa_budget_versions

6425: */
6426: BEGIN
6427: SELECT project_id
6428: INTO l_project_id
6429: FROM pa_budget_versions
6430: WHERE budget_version_id = l_budget_version_id;
6431: EXCEPTION
6432: WHEN OTHERS THEN
6433: IF l_debug_mode = 'Y' THEN

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

6430: WHERE budget_version_id = l_budget_version_id;
6431: EXCEPTION
6432: WHEN OTHERS THEN
6433: IF l_debug_mode = 'Y' THEN
6434: pa_debug.g_err_stage:='Select failed on pa_budget_versions.';
6435: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6436: END IF;
6437: RAISE;
6438: END;

Line 7756: pa_budget_versions pbv

7752: l_txn_raw_cost_tbl,
7753: l_txn_burdened_cost_tbl,
7754: l_delete_budget_lines_tbl
7755: FROM pa_budget_lines pbl,
7756: pa_budget_versions pbv
7757: WHERE pbl.budget_version_id=l_budget_version_id
7758: AND pbl.resource_assignment_id=l_resource_assignment_id_tbl(i)
7759: AND pbl.txn_currency_code=l_currency_code_tbl(i)
7760: AND pbv.budget_version_id=pbl.budget_version_id

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

8319: p_context IN VARCHAR2
8320: ,p_copy_external_flag IN VARCHAR2
8321: ,p_src_project_id IN pa_projects_all.project_id%TYPE
8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE
8323: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8324: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8325: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8326: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8327: ,p_copy_people_flag IN VARCHAR2 := NULL

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

8320: ,p_copy_external_flag IN VARCHAR2
8321: ,p_src_project_id IN pa_projects_all.project_id%TYPE
8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE
8323: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8324: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8325: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8326: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8327: ,p_copy_people_flag IN VARCHAR2 := NULL
8328: ,p_copy_equip_flag IN VARCHAR2 := NULL

Line 8352: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;

8348: l_adj_percent NUMBER;
8349: i NUMBER;
8350: j NUMBER;
8351: l_row_count NUMBER;
8352: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;

8349: i NUMBER;
8350: j NUMBER;
8351: l_row_count NUMBER;
8352: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 8521: pa_budget_versions pbv

8517: --Derive the plan version id for the source and target element version ids
8518: SELECT pbv.budget_version_id
8519: INTO l_src_budget_version_id
8520: FROM pa_struct_task_wbs_v pt,
8521: pa_budget_versions pbv
8522: WHERE pbv.project_structure_version_id= pt.parent_structure_version_id
8523: AND pt.element_version_id=p_src_version_id_tbl(1)
8524: AND pbv.wp_version_flag='Y';
8525:

Line 8535: FROM pa_budget_versions pbv

8531:
8532: --dbms_output.put_line('in copy plan txn2.5');
8533: SELECT pbv.budget_version_id
8534: INTO l_targ_budget_version_id
8535: FROM pa_budget_versions pbv
8536: ,pa_struct_task_wbs_v pt
8537: WHERE pt.element_version_id=p_targ_version_id_tbl(1)
8538: AND pbv.project_structure_version_id=pt.parent_structure_version_id
8539: AND pbv.wp_version_flag='Y';

Line 9400: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

9396: l_task_assmt_ids_tbl SYSTEM.pa_num_tbl_type;
9397:
9398: l_counter NUMBER;
9399: l_ra_index NUMBER;
9400: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
9401: l_ci_id pa_budget_versions.ci_id%TYPE;
9402: l_exists VARCHAR2(1);
9403: SKIP_LOOP EXCEPTION;
9404: i NUMBER;

Line 9401: l_ci_id pa_budget_versions.ci_id%TYPE;

9397:
9398: l_counter NUMBER;
9399: l_ra_index NUMBER;
9400: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
9401: l_ci_id pa_budget_versions.ci_id%TYPE;
9402: l_exists VARCHAR2(1);
9403: SKIP_LOOP EXCEPTION;
9404: i NUMBER;
9405: l_cntr NUMBER;

Line 9671: ,pa_budget_Versions pbv

9667: INTO l_project_id
9668: ,l_budget_version_id
9669: ,l_ci_id
9670: FROM pa_resource_assignments pra
9671: ,pa_budget_Versions pbv
9672: WHERE pbv.budget_version_id=pra.budget_version_id
9673: AND pbv.wp_version_flag='Y'
9674: AND pra.wbs_element_version_id=p_element_version_id_tbl(l_cntr)
9675: AND rownum < 2 ;

Line 9707: ,pa_budget_Versions pbv

9703: INTO l_project_id
9704: ,l_budget_version_id
9705: ,l_ci_id
9706: FROM pa_resource_assignments pra
9707: ,pa_budget_Versions pbv
9708: WHERE pbv.budget_version_id=pra.budget_version_id
9709: AND pra.resource_assignment_id =l_task_assmt_ids_tbl(1);
9710: EXCEPTION
9711: WHEN NO_DATA_FOUND THEN

Line 9743: ,pa_budget_Versions pbv

9739: INTO l_project_id
9740: ,l_budget_version_id
9741: ,l_ci_id
9742: FROM pa_resource_assignments pra
9743: ,pa_budget_Versions pbv
9744: WHERE pbv.budget_version_id=pra.budget_version_id
9745: AND pra.resource_assignment_id =p_resource_assignment_tbl(1);
9746: EXCEPTION
9747: WHEN NO_DATA_FOUND THEN

Line 10125: pa_budget_versions pbv

10121: DELETE
10122: FROM pa_budget_lines pbl
10123: WHERE pbl.resource_assignment_id IN (SELECT pra.resource_assignment_id
10124: FROM pa_resource_assignments pra,
10125: pa_budget_versions pbv
10126: WHERE pra.budget_Version_id=pbv.budget_Version_id
10127: AND nvl(pbv.wp_version_flag,'N')=l_wp_version_flag
10128: AND pra.budget_Version_id = l_budget_version_id--Bug#4548675--Bug 4218331
10129: AND pbv.budget_Version_id = l_budget_version_id--Bug#4548675--Bug 4218331

Line 10216: FROM pa_budget_Versions pbv

10212: DELETE
10213: FROM pa_resource_assignments pra
10214: WHERE pra.wbs_element_version_id=p_element_version_id_tbl(i)
10215: AND EXISTS (SELECT 'X'
10216: FROM pa_budget_Versions pbv
10217: WHERE pbv.budget_version_id=pra.budget_Version_id
10218: AND pbv.budget_Version_id = l_budget_version_id--Bug#4548675--Bug 4218331
10219: AND nvl(pbv.wp_version_flag,'N')=l_wp_version_flag
10220: AND nvl(l_ta_display_flag , '-99')=nvl(ta_display_flag,'-99'))

Line 11572: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

11568:
11569: ==============================================================================*/
11570:
11571: PROCEDURE Refresh_Plan_Txns(
11572: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
11573: ,p_plan_level_change IN VARCHAR2
11574: ,p_resource_list_change IN VARCHAR2
11575: ,p_rbs_version_change IN VARCHAR2
11576: ,p_time_phase_change_flag IN VARCHAR2

Line 11621: FROM pa_proj_fp_options pfo, pa_budget_versions bv

11617: ,'ALL', all_fin_plan_level_code) fin_plan_level_code
11618: ,pfo.rbs_version_id rbs_version_id
11619: ,pfo.fin_plan_type_id fin_plan_type_id
11620: ,bv.ci_id ci_id
11621: FROM pa_proj_fp_options pfo, pa_budget_versions bv
11622: WHERE bv.project_id = pfo.project_id
11623: AND pfo.fin_plan_version_id = bv.budget_version_id
11624: AND bv.budget_version_id = p_budget_version_id;
11625:

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

12005: -- END of IPM changes Bug 5003827 Issue 22
12006:
12007:
12008: -- Calling the rollup api to correct the amounts related data in
12009: -- pa_budget_versions and pa_resource_assignments for the entire version
12010: PA_FP_ROLLUP_PKG.rollup_budget_version
12011: (p_budget_version_id => p_budget_version_id
12012: ,p_entire_version => 'Y'
12013: ,x_return_status => l_return_status

Line 12203: from pa_budget_versions bv,

12199: ,DECODE(fin_plan_preference_code,
12200: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, pfo.all_resource_list_id,
12201: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, pfo.cost_resource_list_id,
12202: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, pfo.revenue_resource_list_id) resource_list_id
12203: from pa_budget_versions bv,
12204: pa_proj_fp_options pfo
12205: where bv.budget_version_id = c_budget_version_id
12206: and pfo.project_id = bv.project_id
12207: and pfo.fin_plan_type_id = bv.fin_plan_type_id

Line 12576: pa_budget_versions should be updated with changed values.

12572: This api is called upon save from Additional Workplan Options page.
12573: For versioning disabled case working version should be updated with values
12574: that of parent plan type record. The changes include deleting all the
12575: existing budget lines, resource assignments. Pa_proj_fp_options and
12576: pa_budget_versions should be updated with changed values.
12577:
12578: Bug 3595063 For a shared structure, update current working version with the
12579: new settings.
12580:

Line 12610: p_project_id IN pa_budget_versions.project_id%TYPE

12606: plan_delete(), plan_create() at the end.
12607: ===============================================================================*/
12608:
12609: PROCEDURE REFRESH_WP_SETTINGS(
12610: p_project_id IN pa_budget_versions.project_id%TYPE
12611: ,p_resource_list_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
12612: ,p_time_phase_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
12613: ,p_rbs_version_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687
12614: ,p_track_costs_flag_change IN VARCHAR2 DEFAULT 'N' -- Bug 3619687

Line 12698: FROM pa_budget_versions bv,

12694: CURSOR working_workplan_versions_cur IS
12695: SELECT bv.budget_version_id
12696: ,pfo.proj_fp_options_id
12697: ,bv.project_structure_version_id
12698: FROM pa_budget_versions bv,
12699: pa_proj_elem_ver_structure ver,
12700: pa_proj_fp_options pfo
12701: WHERE bv.project_id = p_project_id
12702: AND bv.wp_version_flag = 'Y'

Line 12713: FROM pa_budget_versions bv,

12709:
12710: CURSOR published_versions_cur IS
12711: SELECT bv.budget_version_id
12712: ,pfo.proj_fp_options_id
12713: FROM pa_budget_versions bv,
12714: pa_proj_elem_ver_structure ver,
12715: pa_proj_fp_options pfo
12716: WHERE bv.project_id = p_project_id
12717: AND bv.wp_version_flag = 'Y'

Line 12758: FROM pa_budget_versions bv

12754: -- including the publsihed versions for RBS refresh
12755: CURSOR all_workplan_versions_cur IS
12756: SELECT bv.budget_version_id
12757: ,pfo.proj_fp_options_id
12758: FROM pa_budget_versions bv
12759: ,pa_proj_fp_options pfo
12760: WHERE bv.project_id = p_project_id
12761: AND bv.wp_version_flag = 'Y'
12762: AND pfo.fin_plan_version_id = bv.budget_version_id

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

12929: /* Note that we are not updating working wp versions pa_progress_rollup since there is some
12930: processing done for working wp versions in the loop below (delete planning transactions etc
12931: and we want to ensure this update is done after the processing */
12932:
12933: /* We also need to update the resource list id in the pa_budget_versions table as well as the
12934: pa_proj_fp_options table .*/
12935: FORALL i IN l_pub_proj_fp_options_id_tbl.first .. l_pub_proj_fp_options_id_tbl.last
12936: UPDATE pa_proj_fp_options
12937: SET cost_resource_list_id = parent_plan_type_rec.cost_resource_list_id

Line 12945: UPDATE pa_budget_versions

12941: ,last_update_login = FND_GLOBAL.login_id
12942: where proj_fp_options_id = l_pub_proj_fp_options_id_tbl(i);
12943:
12944: FORALL i IN l_pub_budget_version_id_tbl.first .. l_pub_budget_version_id_tbl.last
12945: UPDATE pa_budget_versions
12946: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12947: ,record_version_number = record_version_number + 1
12948: ,last_update_date = SYSDATE
12949: ,last_updated_by = FND_GLOBAL.user_id

Line 12995: UPDATE pa_budget_versions

12991:
12992: -- Update budget_versions data for all the working versions in bulk
12993:
12994: FORALL i IN l_budget_version_id_tbl.first .. l_budget_version_id_tbl.last
12995: UPDATE pa_budget_versions
12996: SET resource_list_id = parent_plan_type_rec.cost_resource_list_id
12997: ,current_planning_period = parent_plan_type_rec.cost_current_planning_period
12998: ,period_mask_id = parent_plan_type_rec.cost_period_mask_id
12999: -- Bug 3630069 Amounts should not be updated with 0. These columns are taken care of

Line 13478: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

13474: ==============================================================================*/
13475:
13476: PROCEDURE Refresh_rbs_for_versions(
13477: p_project_id IN pa_projects_all.project_id%TYPE
13478: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
13479: ,p_calling_context IN VARCHAR2 -- Default 'ALL_CHILD_VERSIONS'
13480: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null
13481: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13482: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

13476: PROCEDURE Refresh_rbs_for_versions(
13477: p_project_id IN pa_projects_all.project_id%TYPE
13478: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
13479: ,p_calling_context IN VARCHAR2 -- Default 'ALL_CHILD_VERSIONS'
13480: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null
13481: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13482: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13483: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
13484: AS

Line 13505: pa_budget_versions bv

13501: SELECT o.proj_fp_options_id,
13502: o.fin_plan_version_id,
13503: bv.resource_list_id
13504: FROM pa_proj_fp_options o,
13505: pa_budget_versions bv
13506: WHERE o.project_id = p_project_id
13507: AND o.fin_plan_type_id = p_fin_plan_type_id
13508: AND o.fin_plan_version_id = bv.budget_version_id
13509: AND bv.ci_id IS NULL -- bug 3867302

Line 13518: FROM pa_budget_versions bv,

13514: ,o.fin_plan_version_id
13515: ,bv.resource_list_id
13516: ,o.fin_plan_type_id
13517: ,bv.ci_id
13518: FROM pa_budget_versions bv,
13519: pa_proj_fp_options o
13520: WHERE bv.project_id = o.project_id
13521: AND bv.fin_plan_type_id = o.fin_plan_type_id
13522: AND bv.budget_version_id = o.fin_plan_version_id

Line 13814: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

13810: --This function returns 'N' if a record already exists in pa_resource_assignments
13811: --for a given budget version id, task id and resource list member id
13812: --Returns 'Y' if the record is not already there
13813: FUNCTION DUP_EXISTS
13814: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
13815: ,p_task_id IN pa_tasks.task_id%TYPE
13816: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
13817: ,p_project_id IN pa_projects_all.project_id%TYPE)
13818: RETURN VARCHAR2