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 913: FROM pa_budget_versions

909: */
910:
911: SELECT COUNT(1)
912: INTO l_temp
913: FROM pa_budget_versions
914: WHERE 1=1
915: AND budget_version_id IN (l_plan_version_id , l_prev_pub_version_id );
916:
917:

Line 1379: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;

1375: l_project_id NUMBER := NULL;
1376: l_curr_bl_ver_id NUMBER := NULL;
1377: l_plan_type_id NUMBER := NULL;
1378: l_new_project_type pa_projects_all.project_type%TYPE;
1379: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1380: l_plan_type_code CHAR(1);
1381: l_processing_code VARCHAR2(12000);
1382: l_wp_version_flag VARCHAR2(1) := NULL;
1383:

Line 1405: FROM pa_budget_versions bv1

1401: BEGIN
1402: SELECT bv1.project_id, bv1.fin_plan_type_id, bv1.wp_version_flag,
1403: DECODE(bv1.version_type, 'COST' , 'C' , 'REVENUE' , 'R' , 'A')
1404: INTO l_project_id, l_plan_type_id, l_wp_version_flag,l_plan_type_code
1405: FROM pa_budget_versions bv1
1406: WHERE bv1.budget_version_id = p_baseline_version_id;
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: NULL;

Line 1677: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;

1673: l_curr_or_ver_id NUMBER := NULL;
1674: l_plan_type_id NUMBER := NULL;
1675: l_plan_type_code char(1);
1676: l_new_project_type pa_projects_all.project_type%TYPE;
1677: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1678: l_processing_code VARCHAR2(1500) := NULL;
1679:
1680: BEGIN
1681:

Line 1718: FROM pa_budget_versions bv1

1714:
1715: SELECT bv1.project_id, bv1.fin_plan_type_id,
1716: DECODE(bv1.version_type, 'COST' , 'C' , 'REVENUE' , 'R' , 'A')
1717: INTO l_project_id, l_plan_type_id, l_plan_type_code
1718: FROM pa_budget_versions bv1
1719: WHERE bv1.budget_version_id = p_original_version_id;
1720:
1721: EXCEPTION
1722: WHEN OTHERS THEN

Line 1803: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;

1799: l_old_orig_ver_id NUMBER := NULL;
1800: l_new_orig_ver_id NUMBER := NULL;
1801: l_plan_type_id NUMBER := NULL;
1802: l_new_project_type pa_projects_all.project_type%TYPE;
1803: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1804: l_original_exists NUMBER := NULL;
1805: l_processing_code VARCHAR2(1) := NULL;
1806:
1807: l_last_update_date date := SYSDATE;

Line 2424: PA_BUDGET_VERSIONS ver,

2420: ver.BUDGET_VERSION_ID,
2421: ver.FIN_PLAN_TYPE_ID,
2422: sub_wbs_hdr.PLAN_TYPE_CODE
2423: from
2424: PA_BUDGET_VERSIONS ver,
2425: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2426: PJI_XBS_DENORM prg
2427: where
2428: ver.BUDGET_VERSION_ID = p_plan_version_id and

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

2561: , PA_PROJ_STRUCTURE_TYPES ppst
2562: , PA_STRUCTURE_TYPES pst
2563: , PA_PROJ_ELEM_VER_STRUCTURE ppevs
2564: , pji_pjp_wbs_header wh
2565: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.
2566: WHERE 1=1
2567: AND ppe.project_id = ppwa.project_id
2568: AND ppe.proj_element_id = ppwa.proj_element_id
2569: AND ppe.proj_element_id = ppst.proj_element_id

Line 2773: FROM pa_budget_versions bv

2769: AND (l_fp_version_ids(l_count) > 0)) THEN -- 2
2770:
2771: SELECT PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2772: INTO l_wbs_version_id
2773: FROM pa_budget_versions bv
2774: WHERE budget_version_id = l_fp_version_ids(l_count);
2775:
2776: print_time ( ' wbs hdrs baseline lock 1.1 wbs version id is .. ' || l_wbs_version_id );
2777:

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

2861: INTO l_count1
2862: FROM pji_xbs_denorm den
2863: , pji_pjp_wbs_header hd1 -- SUB
2864: , pji_pjp_wbs_header hd2 -- SUP
2865: , pa_budget_versions hd3 -- to get plan type id
2866: WHERE
2867: den.struct_version_id IS NULL
2868: AND den.struct_type = 'PRG'
2869: AND hd1.wbs_version_id = den.sub_id -- struct_version_id

Line 3153: FROM pa_budget_versions

3149: --Introduced below if condition for bug 7187487
3150: if p_source_fp_version_ids(i) <> p_dest_fp_version_ids(i) then
3151: SELECT pji_summarized_flag
3152: INTO l_pji_summarized_flag
3153: FROM pa_budget_versions
3154: WHERE budget_version_id = p_source_fp_version_ids(i);
3155:
3156: UPDATE pa_budget_versions
3157: SET pji_summarized_flag = l_pji_summarized_flag

Line 3156: UPDATE pa_budget_versions

3152: INTO l_pji_summarized_flag
3153: FROM pa_budget_versions
3154: WHERE budget_version_id = p_source_fp_version_ids(i);
3155:
3156: UPDATE pa_budget_versions
3157: SET pji_summarized_flag = l_pji_summarized_flag
3158: WHERE budget_version_id = p_dest_fp_version_ids(i);
3159: elsif p_source_fp_version_ids(i) = p_dest_fp_version_ids(i) then
3160: UPDATE pa_budget_versions

Line 3160: UPDATE pa_budget_versions

3156: UPDATE pa_budget_versions
3157: SET pji_summarized_flag = l_pji_summarized_flag
3158: WHERE budget_version_id = p_dest_fp_version_ids(i);
3159: elsif p_source_fp_version_ids(i) = p_dest_fp_version_ids(i) then
3160: UPDATE pa_budget_versions
3161: SET pji_summarized_flag = 'Y'
3162: WHERE budget_version_id = p_dest_fp_version_ids(i);
3163: end if;
3164:

Line 3195: UPDATE pa_budget_versions

3191: ( p_package_name => g_package_name
3192: , x_return_status => x_return_status );
3193:
3194: -- Todo: verifiy logic with VR.
3195: UPDATE pa_budget_versions
3196: SET original_flag = 'Y'
3197: , last_update_date = SYSDATE
3198: , last_updated_by = Fnd_Global.USER_ID
3199: , last_update_login = Fnd_Global.LOGIN_ID

Line 6531: FROM pa_budget_versions

6527: BEGIN
6528:
6529: SELECT PROJECT_ID
6530: INTO l_project_id
6531: FROM pa_budget_versions
6532: WHERE budget_version_id = p_fp_version_ids(i);
6533:
6534: print_time ( ' plan version id # ' || i || ' is ' || p_fp_version_ids(i) || ' exists in budget versions.');
6535: