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_UTILS dependencies on PJI_PLAN_EXTR_TMP

Line 1660: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

1656: print_time (' p_base_struct_ver_id ' || p_base_struct_ver_id || ' p_plan_version_id ' || p_plan_version_id );
1657: print_time ( ' p_as_of_date ' || p_as_of_date );
1658: print_time (' p_delete_flag ' || p_delete_flag || ' p_workplan_flag ' || p_workplan_flag );
1659:
1660: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1661: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1662:
1663: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1664: /* Added for workplan progress */

Line 1661: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

1657: print_time ( ' p_as_of_date ' || p_as_of_date );
1658: print_time (' p_delete_flag ' || p_delete_flag || ' p_workplan_flag ' || p_workplan_flag );
1659:
1660: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1661: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1662:
1663: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1664: /* Added for workplan progress */
1665: -- Get the Latest Published Version for the Project

Line 1928: DELETE FROM PJI_PLAN_EXTR_TMP;

1924: END IF ; -- end if for If p_as_of_date IS NOT NULL then
1925:
1926:
1927:
1928: DELETE FROM PJI_PLAN_EXTR_TMP;
1929: print_time ( ' # rows deleted from tmp = ' || SQL%ROWCOUNT ) ;
1930:
1931:
1932: --Ensures that data is cleaned up for the Project / Program and the linked sub projects

Line 1947: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)

1943: -- The Temp table is populated with the PROJECT_ID and the PROJECT_ELEMENT_ID
1944:
1945: IF p_structure_flag ='N' THEN
1946:
1947: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)
1948: select sup_project_id,sub_emt_id
1949: from pji_xbs_Denorm
1950: where sup_project_id=p_project_id
1951: and struct_version_id = p_struct_ver_id

Line 1956: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)

1952: and sup_emt_id=p_project_element_id
1953: and sup_level <> sub_level
1954: and abs(sup_level - sub_level) <=p_level ;
1955: ELSE
1956: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)
1957: select sub.sup_project_id,sub.sub_emt_id
1958: from pji_xbs_Denorm sup,pji_xbs_Denorm sub
1959: where sup.sup_project_id=p_project_id
1960: and sup.sup_project_id =sub.sup_project_id

Line 2515: pji_plan_extr_tmp head

2511: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
2512: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id, 8), 8, 'a'), 'b') = 'a'
2513: or decode ( cc_src.curr_type, 'POU', DECODE(BITAND(fact.curr_record_type_id, 4), 4, 'a'), 'b') = 'a' )
2514: ) fact,
2515: pji_plan_extr_tmp head
2516: WHERE 1=1
2517: and fact.PROJECT_ID = head.PROJECT_ID
2518: and fact.PLAN_VERSION_ID in (l_plan_ver_id,l_lpb_plan_ver_id,l_base_plan_ver_id)
2519: and fact.PROJECT_ELEMENT_ID = head.plan_ver_id -- plan_version_id contains the project_element_id

Line 2864: DELETE FROM PJI_PLAN_EXTR_TMP; --- Bug 5653800

2860:
2861: IF NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N') = 'Y' THEN
2862: debug_accum ; /* bug#3993830 */
2863: END IF;
2864: DELETE FROM PJI_PLAN_EXTR_TMP; --- Bug 5653800
2865: x_return_status := l_return_status;
2866:
2867: EXCEPTION
2868: WHEN OTHERS THEN

Line 2930: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

2926: , x_return_status => x_return_status );
2927:
2928: pa_debug.log_message('populate_workplan_data:p_project_id_tbl'||p_populate_in_tbl.COUNT, 3);
2929: pa_debug.log_message('populate_workplan_data: p_delete_flag '|| p_delete_flag, 3);
2930: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
2931:
2932: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2933: delete from pji_plan_extr_tmp;
2934: PRINT_TIME ( ' populate_workplan_data 0003.1 ' ) ;

Line 2933: delete from pji_plan_extr_tmp;

2929: pa_debug.log_message('populate_workplan_data: p_delete_flag '|| p_delete_flag, 3);
2930: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
2931:
2932: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2933: delete from pji_plan_extr_tmp;
2934: PRINT_TIME ( ' populate_workplan_data 0003.1 ' ) ;
2935:
2936: IF p_project_id is not null then
2937:

Line 2938: INSERT INTO pji_plan_extr_tmp

2934: PRINT_TIME ( ' populate_workplan_data 0003.1 ' ) ;
2935:
2936: IF p_project_id is not null then
2937:
2938: INSERT INTO pji_plan_extr_tmp
2939: ( PROJECT_ID , PLAN_VER_ID , STRUCT_VER_ID , BASE_STRUCT_VER_ID , AS_OF_DATE , PROJ_ELEM_ID )
2940: VALUES ( p_project_id,p_plan_version_id,p_struct_ver_id , p_base_struct_ver_id,p_as_of_date,p_project_element_id );
2941:
2942: print_time (' p_project_id ' || p_project_id || ' p_struct_ver_id ' || p_struct_ver_id );

Line 2951: INSERT INTO pji_plan_extr_tmp

2947: ELSE
2948: IF p_populate_in_tbl.COUNT >0 THEN
2949: FOR i IN p_populate_in_tbl.FIRST .. p_populate_in_tbl.LAST
2950: LOOP
2951: INSERT INTO pji_plan_extr_tmp
2952: ( PROJECT_ID , PLAN_VER_ID , STRUCT_VER_ID , BASE_STRUCT_VER_ID , AS_OF_DATE , PROJ_ELEM_ID )
2953: VALUES ( p_populate_in_tbl(i).PROJECT_ID,p_populate_in_tbl(i).plan_version_id, p_populate_in_tbl(i).struct_ver_id,p_populate_in_tbl(i).base_struct_ver_id,
2954: p_populate_in_tbl(i).as_of_date,p_populate_in_tbl(i).project_element_id );
2955:

Line 2980: update pji_plan_extr_tmp t1

2976:
2977:
2978: -- since project_id is changed to negative value , the downstream code will not process new ppr enabled projects .
2979:
2980: update pji_plan_extr_tmp t1
2981: set t1.project_id = ( select -1*p.project_id from pa_projects_all p where p.project_id = t1.project_id
2982: and nvl(p.pjt_rollup_enabled_flag,'N') = 'Y' )
2983: where exists
2984: ( select 'x' from pa_projects_all p2 where p2.project_id = t1.project_id and nvl(p2.pjt_rollup_enabled_flag,'N') = 'Y' );

Line 2993: FROM PJI_PLAN_EXTR_TMP HEAD

2989:
2990:
2991: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1
2992: WHERE EXISTS ( SELECT 'x'
2993: FROM PJI_PLAN_EXTR_TMP HEAD
2994: WHERE -1*HEAD.PROJECT_ID=TMP1.PROJECT_ID);
2995:
2996: END IF;
2997:

Line 3002: UPDATE pji_plan_extr_tmp TMP

2998:
2999: IF p_workplan_flag ='Y' THEN
3000:
3001:
3002: UPDATE pji_plan_extr_tmp TMP
3003: SET (WK_PLAN_VER_ID)=
3004: (
3005: SELECT bv.budget_version_id
3006: FROM pa_budget_versions bv

Line 3012: UPDATE pji_plan_extr_tmp TMP

3008: AND -1*tmp.project_id = bv.project_id
3009: )
3010: where tmp.project_id < 0 ;
3011:
3012: UPDATE pji_plan_extr_tmp TMP
3013: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID)=
3014: (
3015: SELECT element_version_id,bv.budget_version_id
3016: FROM pa_proj_elem_ver_structure ppevs,

Line 3031: UPDATE pji_plan_extr_tmp TMP

3027: )
3028: where tmp.project_id < 0 ;
3029:
3030:
3031: UPDATE pji_plan_extr_tmp TMP
3032: SET BASE_PLAN_VER_ID= (
3033: SELECT bv.budget_version_id
3034: FROM pa_budget_versions bv
3035: WHERE 1=1

Line 3052: UPDATE pji_plan_extr_tmp TMP

3048:
3049: else
3050:
3051:
3052: UPDATE pji_plan_extr_tmp TMP
3053: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID,BASE_STRUCT_VER_ID,BASE_PLAN_VER_ID,
3054: WK_STRUCT_VER_ID,WK_PLAN_VER_ID)=
3055: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual )
3056: where tmp.project_id < 0 ;

Line 3465: from pji_plan_extr_tmp tmp, pa_pjt_wbs_fact fact, pa_projects_all p

3461: sum(decode(p.project_currency_code,
3462: fact.currency_code, decode(fact.plan_version_id, WK_PLAN_VER_ID, fact.ETC_labor_raw_cost, 0 ))) P_ETC_LBR_RAW_COST,
3463: sum(decode(p.project_currency_code,
3464: fact.currency_code,decode(fact.plan_version_id, WK_PLAN_VER_ID, fact.ETC_equip_raw_cost, 0 ))) P_ETC_EQP_RAW_COST
3465: from pji_plan_extr_tmp tmp, pa_pjt_wbs_fact fact, pa_projects_all p
3466: where -1*tmp.project_id = fact.project_id
3467: and tmp.WK_PLAN_VER_ID = fact.plan_version_id
3468: and p.project_id = fact.project_id
3469: and fact.wbs_rollup_flag = 'Y'

Line 3480: delete from pji_plan_extr_tmp where project_id < 0 ;

3476: IF g_debug_mode='Y' THEN
3477: debug_accum ; /* bug#3993830 */
3478:
3479: END IF;
3480: delete from pji_plan_extr_tmp where project_id < 0 ;
3481:
3482: -- OLAP END CHANGE
3483:
3484: end if ;

Line 3493: UPDATE pji_plan_extr_tmp TMP

3489: -- Get the Latest Published Version for the Project
3490:
3491: IF p_workplan_flag ='Y' THEN --bug#5554311
3492:
3493: UPDATE pji_plan_extr_tmp TMP
3494: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID)=
3495: (
3496: SELECT element_version_id,bv.budget_version_id
3497: FROM pa_proj_elem_ver_structure ppevs,

Line 3515: UPDATE pji_plan_extr_tmp TMP

3511:
3512:
3513: PRINT_TIME ( ' populate_workplan_data 0003.3 ' ) ;
3514:
3515: UPDATE pji_plan_extr_tmp TMP
3516: SET WK_STRUCT_VER_ID=
3517: (
3518: SELECT WBS_VERSION_ID
3519: FROM pji_pjp_wbs_header wbs

Line 3526: UPDATE pji_plan_extr_tmp TMP

3522: );
3523:
3524: PRINT_TIME ( ' populate_workplan_data 0003.4 ' ) ;
3525:
3526: UPDATE pji_plan_extr_tmp TMP
3527: SET WK_PLAN_VER_ID= (
3528: SELECT head.PLAN_VERSION_ID
3529: FROM pji_pjp_wbs_header head,
3530: pa_budget_versions bv

Line 3548: UPDATE pji_plan_extr_tmp TMP

3544: AND head.PLAN_VERSION_ID > 0);
3545:
3546: PRINT_TIME ( ' populate_workplan_data 0003.4.1 ' ) ;
3547:
3548: UPDATE pji_plan_extr_tmp TMP
3549: SET WK_STRUCT_VER_ID = STRUCT_VER_ID
3550: where WK_STRUCT_VER_ID is null;
3551:
3552: PRINT_TIME ( ' populate_workplan_data 0003.5 ' ) ;

Line 3554: UPDATE pji_plan_extr_tmp TMP

3550: where WK_STRUCT_VER_ID is null;
3551:
3552: PRINT_TIME ( ' populate_workplan_data 0003.5 ' ) ;
3553:
3554: UPDATE pji_plan_extr_tmp TMP
3555: SET BASE_PLAN_VER_ID= (
3556: SELECT head.PLAN_VERSION_ID
3557: FROM pji_pjp_wbs_header head,
3558: pa_budget_versions bv

Line 3578: UPDATE pji_plan_extr_tmp TMP

3574: ELSE --- when p_workplan_flag ='N' bug#5554311
3575:
3576: PRINT_TIME ( ' populate_workplan_data 0003.5.1 ' ) ;
3577:
3578: UPDATE pji_plan_extr_tmp TMP
3579: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID,BASE_STRUCT_VER_ID,BASE_PLAN_VER_ID,
3580: WK_STRUCT_VER_ID,WK_PLAN_VER_ID)=
3581: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual );
3582:

Line 3589: UPDATE pji_plan_extr_tmp TMP

3585: PRINT_TIME ( ' populate_workplan_data 0003.6 ' ) ;
3586:
3587:
3588:
3589: UPDATE pji_plan_extr_tmp TMP
3590: SET (CAL_TYPE,ORG_ID)=
3591: (
3592: SELECT DECODE(NVL(NVL(fp.cost_time_phased_code, fp.revenue_time_phased_code ), fp.all_time_phased_code), 'G', 'G', 'P', 'P', 'A') calendar_type,
3593: pa.ORG_ID

Line 3607: UPDATE pji_plan_extr_tmp TMP

3603: WHERE tmp.AS_OF_DATE is not null;
3604:
3605: PRINT_TIME ( ' populate_workplan_data 0003.7.1 ' ) ;
3606:
3607: UPDATE pji_plan_extr_tmp TMP
3608: SET (END_PERIOD_ID,PERIOD_ID)=
3609: (
3610: SELECT cal.CAL_PERIOD_ID ,DECODE(tmp.cal_type, 'A', 2048, 32) PERIOD_TYPE_ID
3611: FROM pji_time_cal_period_v cal,

Line 3631: FROM PJI_PLAN_EXTR_TMP;

3627: CAL_TYPE,PERIOD_ID,END_PERIOD_ID
3628: BULK COLLECT INTO
3629: l_project_id_tbl,l_wk_struct_ver_id_tbl,l_lpb_struct_ver_id_tbl,l_base_struct_ver_id_tbl,
3630: l_cal_type_tbl,l_period_id_tbl, l_end_period_id_tbl
3631: FROM PJI_PLAN_EXTR_TMP;
3632:
3633: PRINT_TIME ( ' populate_workplan_data 0003.9 ' ) ;
3634:
3635: IF p_program_rollup_flag='Y' and p_calling_context='SUMMARIZE' and p_workplan_flag ='Y' THEN

Line 3641: INSERT into PJI_PLAN_EXTR_TMP

3637: PRINT_TIME ( ' populate_workplan_data 0003.9.1 ' ) ;
3638:
3639: FOR i IN 1 .. l_project_id_tbl.count
3640: LOOP
3641: INSERT into PJI_PLAN_EXTR_TMP
3642: (project_id,wk_plan_ver_id,lpb_plan_ver_id,base_plan_ver_id,struct_ver_id,cal_type,period_id,end_period_id) --Bug#5660324
3643: SELECT
3644: head.PROJECT_ID,
3645: MAX(DECODE(SUBSTR(den.RECORD_TYPE,1,1), 'W', head.plan_version_id, NULL)) wk_plan_ver_id,

Line 3739: INSERT into PJI_PLAN_EXTR_TMP

3735:
3736: FOR i IN 1 .. l_project_id_tbl.count
3737: LOOP
3738:
3739: INSERT into PJI_PLAN_EXTR_TMP
3740: (project_id,wk_plan_ver_id,lpb_plan_ver_id,base_plan_ver_id,struct_ver_id,cal_type,period_id,end_period_id) --Bug#5660324
3741: SELECT
3742: head.PROJECT_ID,
3743: MAX(DECODE(den.RECORD_TYPE, 'W', head.plan_version_id, NULL)) wk_plan_ver_id,

Line 3800: UPDATE pji_plan_extr_tmp

3796: /* Start of changes for bug 5751250 */
3797:
3798: IF p_calling_context = 'MSP' THEN
3799:
3800: UPDATE pji_plan_extr_tmp
3801: SET WK_PLAN_VER_ID = -1, BASE_PLAN_VER_ID = -1, LPB_PLAN_VER_ID = -1;
3802:
3803: END IF;
3804:

Line 3818: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp

3814: DELETE FROM pji_fm_xbs_accum_tmp1
3815: WHERE rowid IN
3816: (
3817: SELECT tmp.rowid
3818: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp
3819: WHERE head.project_id=tmp.project_id
3820: );
3821: */
3822: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1

Line 3824: FROM PJI_PLAN_EXTR_TMP HEAD

3820: );
3821: */
3822: DELETE FROM PJI_FM_XBS_ACCUM_TMP1 TMP1
3823: WHERE EXISTS ( SELECT 'x'
3824: FROM PJI_PLAN_EXTR_TMP HEAD
3825: WHERE HEAD.PROJECT_ID=TMP1.PROJECT_ID);
3826:
3827: END IF;
3828:

Line 3831: DELETE FROM PJI_PLAN_EXTR_TMP tmp1

3827: END IF;
3828:
3829: PRINT_TIME ( ' populate_workplan_data 0003.10.1 ' ) ;
3830:
3831: DELETE FROM PJI_PLAN_EXTR_TMP tmp1
3832: WHERE EXISTS
3833: ( SELECT * FROM PJI_PLAN_EXTR_TMP tmp2
3834: WHERE tmp1.PROJECT_ID=tmp2.PROJECT_ID
3835: AND tmp1.ROWID > tmp2.ROWID );

Line 3833: ( SELECT * FROM PJI_PLAN_EXTR_TMP tmp2

3829: PRINT_TIME ( ' populate_workplan_data 0003.10.1 ' ) ;
3830:
3831: DELETE FROM PJI_PLAN_EXTR_TMP tmp1
3832: WHERE EXISTS
3833: ( SELECT * FROM PJI_PLAN_EXTR_TMP tmp2
3834: WHERE tmp1.PROJECT_ID=tmp2.PROJECT_ID
3835: AND tmp1.ROWID > tmp2.ROWID );
3836:
3837: IF g_debug_mode='Y' THEN

Line 4319: pji_plan_extr_tmp head

4315: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
4316: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id , 8), 8, 'a'), 'b') = 'a'
4317: or decode ( cc_src.curr_type, 'POU', DECODE(BITAND(fact.curr_record_type_id, 4), 4, 'a'), 'b') = 'a' )
4318: ) fact,
4319: pji_plan_extr_tmp head
4320: WHERE 1=1
4321: and fact.PROJECT_ID = head.PROJECT_ID
4322: and fact.PLAN_VERSION_ID in (head.WK_PLAN_VER_ID , head.BASE_PLAN_VER_ID,
4323: head.LPB_PLAN_VER_ID )

Line 4349: DELETE FROM PJI_PLAN_EXTR_TMP;

4345:
4346:
4347:
4348:
4349: DELETE FROM PJI_PLAN_EXTR_TMP;
4350:
4351: x_return_status := l_return_status;
4352:
4353: PRINT_TIME ( ' populate_workplan_data 0003.13 ' ) ;