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.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_BUDGET_VERSIONS

Line 470: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

466: for k in 1 .. p_fp_version_ids.count loop
467:
468: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
469: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
470: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
471: where b.budget_version_id = p_fp_version_ids(k)
472: and b.project_id = p.project_id
473: AND b.fin_plan_type_id = fpo.fin_plan_type_id
474: AND b.budget_version_id = fpo.fin_plan_version_id

Line 578: FROM pa_proj_fp_options a, pa_budget_versions b

574: CURSOR res_list IS
575: SELECT decode(b.version_type, 'COST', cost_resource_list_id,
576: 'REVENUE',revenue_resource_list_id,
577: 'ALL', all_resource_list_id) resource_list_id
578: FROM pa_proj_fp_options a, pa_budget_versions b
579: WHERE a.fin_plan_version_id = b.budget_version_id
580: AND a.fin_plan_version_id = p_plan_version_id;
581:
582: CURSOR res_class IS

Line 591: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo, pji_fm_extr_plan_lines extr

587: -- OLAP START CHANGE
588:
589: cursor plan_versions is
590: select extr.plan_version_id, p.pjt_rollup_enabled_flag , nvl(p.CBS_ENABLE_FLAG, 'N') cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
591: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo, pji_fm_extr_plan_lines extr
592: where b.budget_version_id = extr.plan_version_id
593: and b.project_id = p.project_id
594: AND b.fin_plan_type_id = fpo.fin_plan_type_id
595: AND b.budget_version_id = fpo.fin_plan_version_id

Line 709: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

705: END IF;
706:
707: select p.pjt_rollup_enabled_flag , p.CBS_ENABLE_FLAG, p.project_id , fpo.rbs_version_id , p.cbs_version_id
708: into l_pjt_rollup_enabled_flag , l_cbs_enable_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
709: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
710: where b.budget_version_id = p_plan_version_id
711: and b.project_id = p.project_id
712: AND b.fin_plan_type_id = fpo.fin_plan_type_id
713: AND b.budget_version_id = fpo.fin_plan_version_id

Line 1191: FROM pa_budget_versions

1187: */
1188:
1189: SELECT COUNT(1)
1190: INTO l_temp
1191: FROM pa_budget_versions
1192: WHERE 1=1
1193: AND budget_version_id IN (l_plan_version_id , l_prev_pub_version_id );
1194:
1195:

Line 1493: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

1489: -- OLAP START CHANGE
1490:
1491: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
1492: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
1493: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
1494: where b.budget_version_id = p_dest_fp_version_ids(i)
1495: and b.project_id = p.project_id
1496: AND b.fin_plan_type_id = fpo.fin_plan_type_id
1497: AND b.budget_version_id = fpo.fin_plan_version_id

Line 1709: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;

1705: l_project_id NUMBER := NULL;
1706: l_curr_bl_ver_id NUMBER := NULL;
1707: l_plan_type_id NUMBER := NULL;
1708: l_new_project_type pa_projects_all.project_type%TYPE;
1709: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1710: l_plan_type_code CHAR(1);
1711: l_processing_code VARCHAR2(12000);
1712: l_wp_version_flag VARCHAR2(1) := NULL;
1713:

Line 1746: FROM pa_budget_versions bv1

1742: BEGIN
1743: SELECT bv1.project_id, bv1.fin_plan_type_id, bv1.wp_version_flag,
1744: DECODE(bv1.version_type, 'COST' , 'C' , 'REVENUE' , 'R' , 'A')
1745: INTO l_project_id, l_plan_type_id, l_wp_version_flag,l_plan_type_code
1746: FROM pa_budget_versions bv1
1747: WHERE bv1.budget_version_id = p_baseline_version_id;
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: NULL;

Line 1798: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

1794: -- OLAP START CHANGE
1795:
1796: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
1797: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
1798: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
1799: where b.budget_version_id = p_new_version_id
1800: and b.project_id = p.project_id
1801: AND b.fin_plan_type_id = fpo.fin_plan_type_id
1802: AND b.budget_version_id = fpo.fin_plan_version_id

Line 2053: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;

2049: l_curr_or_ver_id NUMBER := NULL;
2050: l_plan_type_id NUMBER := NULL;
2051: l_plan_type_code char(1);
2052: l_new_project_type pa_projects_all.project_type%TYPE;
2053: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
2054: l_processing_code VARCHAR2(1500) := NULL;
2055:
2056: BEGIN
2057:

Line 2094: FROM pa_budget_versions bv1

2090:
2091: SELECT bv1.project_id, bv1.fin_plan_type_id,
2092: DECODE(bv1.version_type, 'COST' , 'C' , 'REVENUE' , 'R' , 'A')
2093: INTO l_project_id, l_plan_type_id, l_plan_type_code
2094: FROM pa_budget_versions bv1
2095: WHERE bv1.budget_version_id = p_original_version_id;
2096:
2097: EXCEPTION
2098: WHEN OTHERS THEN

Line 2179: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;

2175: l_old_orig_ver_id NUMBER := NULL;
2176: l_new_orig_ver_id NUMBER := NULL;
2177: l_plan_type_id NUMBER := NULL;
2178: l_new_project_type pa_projects_all.project_type%TYPE;
2179: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
2180: l_original_exists NUMBER := NULL;
2181: l_processing_code VARCHAR2(1) := NULL;
2182:
2183: l_last_update_date date := SYSDATE;

Line 2800: PA_BUDGET_VERSIONS ver,

2796: ver.BUDGET_VERSION_ID,
2797: ver.FIN_PLAN_TYPE_ID,
2798: sub_wbs_hdr.PLAN_TYPE_CODE
2799: from
2800: PA_BUDGET_VERSIONS ver,
2801: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2802: PJI_XBS_DENORM prg
2803: where
2804: ver.BUDGET_VERSION_ID = p_plan_version_id and

Line 2941: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.

2937: , PA_PROJ_STRUCTURE_TYPES ppst
2938: , PA_STRUCTURE_TYPES pst
2939: , PA_PROJ_ELEM_VER_STRUCTURE ppevs
2940: , pji_pjp_wbs_header wh
2941: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.
2942: WHERE 1=1
2943: AND ppe.project_id = ppwa.project_id
2944: AND ppe.proj_element_id = ppwa.proj_element_id
2945: AND ppe.proj_element_id = ppst.proj_element_id

Line 3149: FROM pa_budget_versions bv

3145: AND (l_fp_version_ids(l_count) > 0)) THEN -- 2
3146:
3147: SELECT PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3148: INTO l_wbs_version_id
3149: FROM pa_budget_versions bv
3150: WHERE budget_version_id = l_fp_version_ids(l_count);
3151:
3152: print_time ( ' wbs hdrs baseline lock 1.1 wbs version id is .. ' || l_wbs_version_id );
3153:

Line 3241: , pa_budget_versions hd3 -- to get plan type id

3237: INTO l_count1
3238: FROM pji_xbs_denorm den
3239: , pji_pjp_wbs_header hd1 -- SUB
3240: , pji_pjp_wbs_header hd2 -- SUP
3241: , pa_budget_versions hd3 -- to get plan type id
3242: WHERE
3243: den.struct_version_id IS NULL
3244: AND den.struct_type = 'PRG'
3245: AND hd1.wbs_version_id = den.sub_id -- struct_version_id

Line 3529: FROM pa_budget_versions

3525: --Introduced below if condition for bug 7187487
3526: if p_source_fp_version_ids(i) <> p_dest_fp_version_ids(i) then
3527: SELECT pji_summarized_flag
3528: INTO l_pji_summarized_flag
3529: FROM pa_budget_versions
3530: WHERE budget_version_id = p_source_fp_version_ids(i);
3531:
3532: UPDATE pa_budget_versions
3533: SET pji_summarized_flag = l_pji_summarized_flag

Line 3532: UPDATE pa_budget_versions

3528: INTO l_pji_summarized_flag
3529: FROM pa_budget_versions
3530: WHERE budget_version_id = p_source_fp_version_ids(i);
3531:
3532: UPDATE pa_budget_versions
3533: SET pji_summarized_flag = l_pji_summarized_flag
3534: WHERE budget_version_id = p_dest_fp_version_ids(i);
3535: elsif p_source_fp_version_ids(i) = p_dest_fp_version_ids(i) then
3536: UPDATE pa_budget_versions

Line 3536: UPDATE pa_budget_versions

3532: UPDATE pa_budget_versions
3533: SET pji_summarized_flag = l_pji_summarized_flag
3534: WHERE budget_version_id = p_dest_fp_version_ids(i);
3535: elsif p_source_fp_version_ids(i) = p_dest_fp_version_ids(i) then
3536: UPDATE pa_budget_versions
3537: SET pji_summarized_flag = 'Y'
3538: WHERE budget_version_id = p_dest_fp_version_ids(i);
3539: end if;
3540:

Line 3571: UPDATE pa_budget_versions

3567: ( p_package_name => g_package_name
3568: , x_return_status => x_return_status );
3569:
3570: -- Todo: verifiy logic with VR.
3571: UPDATE pa_budget_versions
3572: SET original_flag = 'Y'
3573: , last_update_date = SYSDATE
3574: , last_updated_by = Fnd_Global.USER_ID
3575: , last_update_login = Fnd_Global.LOGIN_ID

Line 5887: from pa_budget_versions b , pa_proj_fp_options fpo

5883: begin
5884:
5885: select fpo.rbs_version_id
5886: into l_new_rbs_version_id
5887: from pa_budget_versions b , pa_proj_fp_options fpo
5888: where b.budget_version_id =p_plan_version_id_tbl(i)
5889: AND b.fin_plan_type_id = fpo.fin_plan_type_id
5890: AND b.budget_version_id = fpo.fin_plan_version_id
5891: AND b.project_id = fpo.project_id

Line 7051: FROM pa_budget_versions

7047: BEGIN
7048:
7049: SELECT PROJECT_ID
7050: INTO l_project_id
7051: FROM pa_budget_versions
7052: WHERE budget_version_id = p_fp_version_ids(i);
7053:
7054: print_time ( ' plan version id # ' || i || ' is ' || p_fp_version_ids(i) || ' exists in budget versions.');
7055: