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_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
561: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
562: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type

Line 602: l_project_id pa_budget_versions.project_id%TYPE;

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

Line 603: l_fin_structure_ver_id pa_budget_versions.project_structure_version_id%Type;

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

Line 664: FROM pa_budget_versions

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

Line 741: ,pa_budget_versions pbv

737: ,pra.resource_class_code
738: ,pra.rate_based_flag
739: FROM pa_projects_all p
740: ,pa_resource_assignments pra
741: ,pa_budget_versions pbv
742: ,pa_proj_fp_options pfo
743: ,pa_rbs_plans_out_tmp tmp
744: ,pa_budget_lines pbl
745: ,(SELECT 'OLD' as rbs_elem_id

Line 842: ,pa_budget_versions pbv

838: ,pra.resource_class_code
839: ,pra.rate_based_flag
840: FROM pa_projects_all p
841: ,pa_resource_assignments pra
842: ,pa_budget_versions pbv
843: ,pa_proj_fp_options pfo
844: ,pa_fp_ra_map_tmp tmp
845: ,pa_budget_lines pbl
846: WHERE p.project_id=pbv.project_id

Line 937: pa_budget_versions pbv

933: ,p_res_class_code_tbl(i)
934: ,p_rate_based_flag_tbl(i)
935: FROM pa_projects_all p,
936: pa_proj_fp_options pfo,
937: pa_budget_versions pbv
938: WHERE p.project_id=pbv.project_id
939: AND pbv.budget_version_id=p_budget_version_id
940: AND pfo.fin_plan_version_id=p_budget_version_id
941: AND p_cost_rejection_code_tbl(i) IS NULL

Line 1027: pa_budget_versions pbv,

1023: ,pra.resource_class_code
1024: ,pra.rate_based_flag
1025: FROM pa_projects_all p,
1026: pa_proj_fp_options pfo,
1027: pa_budget_versions pbv,
1028: pa_budget_lines pbl,
1029: pa_resource_assignments pra
1030: WHERE p.project_id=pbv.project_id
1031: AND pbv.budget_version_id=p_budget_version_id