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

Line 38: p_struct_elem_version_id IN pa_budget_versions.project_structure_version_id%TYPE

34: - project_structure_version_id
35: =======================================================================*/
36:
37: FUNCTION Get_Wp_Budget_Version_Id (
38: p_struct_elem_version_id IN pa_budget_versions.project_structure_version_id%TYPE
39: )
40: RETURN NUMBER
41: IS
42: l_budget_version_id NUMBER;

Line 61: FROM pa_budget_versions

57: --------------------------------------------------------------------
58: BEGIN
59: SELECT budget_version_id
60: INTO l_budget_version_id
61: FROM pa_budget_versions
62: WHERE project_structure_version_id = p_struct_elem_version_id
63: AND nvl(wp_version_flag,'N') = 'Y';
64:
65: RETURN l_budget_version_id;

Line 251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE

247:
248: PROCEDURE get_default_planning_dates
249: ( p_project_id IN pa_projects_all.project_id%TYPE
250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type
251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895
255: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895

Line 558: ,p_budget_version_id IN pa_budget_versions.budget_Version_id%TYPE

554:
555: PROCEDURE call_update_rep_lines_api
556: (
557: p_source IN VARCHAR2
558: ,p_budget_version_id IN pa_budget_versions.budget_Version_id%TYPE
559: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
560: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type -- cbs enhancement bug#16688443
561: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
562: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type

Line 603: l_project_id pa_budget_versions.project_id%TYPE;

599: --End of variables used for debugging
600: l_rows_inserted NUMBER:=0;
601: l_msg_code VARCHAR2(2000);
602:
603: l_project_id pa_budget_versions.project_id%TYPE;
604: l_fin_structure_ver_id pa_budget_versions.project_structure_version_id%Type;
605: BEGIN
606: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
607: l_debug_mode := NVL(l_debug_mode, 'N');

Line 604: l_fin_structure_ver_id pa_budget_versions.project_structure_version_id%Type;

600: l_rows_inserted NUMBER:=0;
601: l_msg_code VARCHAR2(2000);
602:
603: l_project_id pa_budget_versions.project_id%TYPE;
604: l_fin_structure_ver_id pa_budget_versions.project_structure_version_id%Type;
605: BEGIN
606: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
607: l_debug_mode := NVL(l_debug_mode, 'N');
608: x_msg_count := 0;

Line 665: FROM pa_budget_versions

661: END IF;
662:
663: --Getting the project id to call the function PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID
664: SELECT project_id INTO l_project_id
665: FROM pa_budget_versions
666: WHERE budget_version_id=p_budget_version_id;
667:
668: l_fin_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
669:

Line 744: ,pa_budget_versions pbv

740: ,pra.rate_based_flag
741: ,pra.CBS_ELEMENT_ID
742: FROM pa_projects_all p
743: ,pa_resource_assignments pra
744: ,pa_budget_versions pbv
745: ,pa_proj_fp_options pfo
746: ,pa_rbs_plans_out_tmp tmp
747: ,pa_budget_lines pbl
748: ,(SELECT 'OLD' as rbs_elem_id

Line 847: ,pa_budget_versions pbv

843: ,pra.rate_based_flag
844: ,pra.CBS_ELEMENT_ID
845: FROM pa_projects_all p
846: ,pa_resource_assignments pra
847: ,pa_budget_versions pbv
848: ,pa_proj_fp_options pfo
849: ,pa_fp_ra_map_tmp tmp
850: ,pa_budget_lines pbl
851: WHERE p.project_id=pbv.project_id

Line 977: pa_budget_versions pbv

973: ,p_rate_based_flag_tbl(i)
974: ,p_cbs_element_id_tbl(i)
975: FROM pa_projects_all p,
976: pa_proj_fp_options pfo,
977: pa_budget_versions pbv
978: WHERE p.project_id=pbv.project_id
979: AND pbv.budget_version_id=p_budget_version_id
980: AND pfo.fin_plan_version_id=p_budget_version_id
981: AND p_cost_rejection_code_tbl(i) IS NULL

Line 1070: pa_budget_versions pbv,

1066: ,pra.rate_based_flag
1067: ,pra.CBS_ELEMENT_ID
1068: FROM pa_projects_all p,
1069: pa_proj_fp_options pfo,
1070: pa_budget_versions pbv,
1071: pa_budget_lines pbl,
1072: pa_resource_assignments pra
1073: WHERE p.project_id=pbv.project_id
1074: AND pbv.budget_version_id=p_budget_version_id