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 1562: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);

1558: print_time (' p_base_struct_ver_id ' || p_base_struct_ver_id || ' p_plan_version_id ' || p_plan_version_id );
1559: print_time ( ' p_as_of_date ' || p_as_of_date );
1560: print_time (' p_delete_flag ' || p_delete_flag || ' p_workplan_flag ' || p_workplan_flag );
1561:
1562: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1563: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1564:
1565: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1566: /* Added for workplan progress */

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

1559: print_time ( ' p_as_of_date ' || p_as_of_date );
1560: print_time (' p_delete_flag ' || p_delete_flag || ' p_workplan_flag ' || p_workplan_flag );
1561:
1562: -- fnd_stats.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1563: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
1564:
1565: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1566: /* Added for workplan progress */
1567: -- Get the Latest Published Version for the Project

Line 1746: DELETE FROM PJI_PLAN_EXTR_TMP;

1742: END IF ; -- end if for If p_as_of_date IS NOT NULL then
1743:
1744:
1745:
1746: DELETE FROM PJI_PLAN_EXTR_TMP;
1747: print_time ( ' # rows deleted from tmp = ' || SQL%ROWCOUNT ) ;
1748:
1749:
1750: --Ensures that data is cleaned up for the Project / Program and the linked sub projects

Line 1765: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)

1761: -- The Temp table is populated with the PROJECT_ID and the PROJECT_ELEMENT_ID
1762:
1763: IF p_structure_flag ='N' THEN
1764:
1765: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)
1766: select sup_project_id,sub_emt_id
1767: from pji_xbs_Denorm
1768: where sup_project_id=p_project_id
1769: and struct_version_id = p_struct_ver_id

Line 1774: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)

1770: and sup_emt_id=p_project_element_id
1771: and sup_level <> sub_level
1772: and abs(sup_level - sub_level) <=p_level ;
1773: ELSE
1774: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)
1775: select sub.sup_project_id,sub.sub_emt_id
1776: from pji_xbs_Denorm sup,pji_xbs_Denorm sub
1777: where sup.sup_project_id=p_project_id
1778: and sup.sup_project_id =sub.sup_project_id

Line 2260: pji_plan_extr_tmp head

2256: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
2257: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id, 8), 8, 'a'), 'b') = 'a'
2258: or decode ( cc_src.curr_type, 'POU', DECODE(BITAND(fact.curr_record_type_id, 4), 4, 'a'), 'b') = 'a' )
2259: ) fact,
2260: pji_plan_extr_tmp head
2261: WHERE 1=1
2262: and fact.PROJECT_ID = head.PROJECT_ID
2263: and fact.PLAN_VERSION_ID in (l_plan_ver_id,l_lpb_plan_ver_id,l_base_plan_ver_id)
2264: and fact.PROJECT_ELEMENT_ID = head.plan_ver_id -- plan_version_id contains the project_element_id

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

2275:
2276: IF NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N') = 'Y' THEN
2277: debug_accum ; /* bug#3993830 */
2278: END IF;
2279: DELETE FROM PJI_PLAN_EXTR_TMP; --- Bug 5653800
2280: x_return_status := l_return_status;
2281:
2282: EXCEPTION
2283: WHEN OTHERS THEN

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

2335: , x_return_status => x_return_status );
2336:
2337: pa_debug.log_message('populate_workplan_data:p_project_id_tbl'||p_populate_in_tbl.COUNT, 3);
2338:
2339: pji_pjp_fp_curr_wrap.set_table_stats('PJI','PJI_PLAN_EXTR_TMP',10,10,10);
2340:
2341: l_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2342:
2343: PRINT_TIME ( ' populate_workplan_data 0003.1 ' ) ;

Line 2347: INSERT INTO pji_plan_extr_tmp

2343: PRINT_TIME ( ' populate_workplan_data 0003.1 ' ) ;
2344:
2345: IF p_project_id is not null then
2346:
2347: INSERT INTO pji_plan_extr_tmp
2348: ( PROJECT_ID , PLAN_VER_ID , STRUCT_VER_ID , BASE_STRUCT_VER_ID , AS_OF_DATE , PROJ_ELEM_ID )
2349: 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 );
2350:
2351: print_time (' p_project_id ' || p_project_id || ' p_struct_ver_id ' || p_struct_ver_id );

Line 2360: INSERT INTO pji_plan_extr_tmp

2356: ELSE
2357: IF p_populate_in_tbl.COUNT >0 THEN
2358: FOR i IN p_populate_in_tbl.FIRST .. p_populate_in_tbl.LAST
2359: LOOP
2360: INSERT INTO pji_plan_extr_tmp
2361: ( PROJECT_ID , PLAN_VER_ID , STRUCT_VER_ID , BASE_STRUCT_VER_ID , AS_OF_DATE , PROJ_ELEM_ID )
2362: 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,
2363: p_populate_in_tbl(i).as_of_date,p_populate_in_tbl(i).project_element_id );
2364:

Line 2385: UPDATE pji_plan_extr_tmp TMP

2381: -- Get the Latest Published Version for the Project
2382:
2383: IF p_workplan_flag ='Y' THEN --bug#5554311
2384:
2385: UPDATE pji_plan_extr_tmp TMP
2386: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID)=
2387: (
2388: SELECT element_version_id,bv.budget_version_id
2389: FROM pa_proj_elem_ver_structure ppevs,

Line 2407: UPDATE pji_plan_extr_tmp TMP

2403:
2404:
2405: PRINT_TIME ( ' populate_workplan_data 0003.3 ' ) ;
2406:
2407: UPDATE pji_plan_extr_tmp TMP
2408: SET WK_STRUCT_VER_ID=
2409: (
2410: SELECT WBS_VERSION_ID
2411: FROM pji_pjp_wbs_header wbs

Line 2418: UPDATE pji_plan_extr_tmp TMP

2414: );
2415:
2416: PRINT_TIME ( ' populate_workplan_data 0003.4 ' ) ;
2417:
2418: UPDATE pji_plan_extr_tmp TMP
2419: SET WK_PLAN_VER_ID= (
2420: SELECT head.PLAN_VERSION_ID
2421: FROM pji_pjp_wbs_header head,
2422: pa_budget_versions bv

Line 2440: UPDATE pji_plan_extr_tmp TMP

2436: AND head.PLAN_VERSION_ID > 0);
2437:
2438: PRINT_TIME ( ' populate_workplan_data 0003.4.1 ' ) ;
2439:
2440: UPDATE pji_plan_extr_tmp TMP
2441: SET WK_STRUCT_VER_ID = STRUCT_VER_ID
2442: where WK_STRUCT_VER_ID is null;
2443:
2444: PRINT_TIME ( ' populate_workplan_data 0003.5 ' ) ;

Line 2446: UPDATE pji_plan_extr_tmp TMP

2442: where WK_STRUCT_VER_ID is null;
2443:
2444: PRINT_TIME ( ' populate_workplan_data 0003.5 ' ) ;
2445:
2446: UPDATE pji_plan_extr_tmp TMP
2447: SET BASE_PLAN_VER_ID= (
2448: SELECT head.PLAN_VERSION_ID
2449: FROM pji_pjp_wbs_header head,
2450: pa_budget_versions bv

Line 2470: UPDATE pji_plan_extr_tmp TMP

2466: ELSE --- when p_workplan_flag ='N' bug#5554311
2467:
2468: PRINT_TIME ( ' populate_workplan_data 0003.5.1 ' ) ;
2469:
2470: UPDATE pji_plan_extr_tmp TMP
2471: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID,BASE_STRUCT_VER_ID,BASE_PLAN_VER_ID,
2472: WK_STRUCT_VER_ID,WK_PLAN_VER_ID)=
2473: (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 );
2474:

Line 2481: UPDATE pji_plan_extr_tmp TMP

2477: PRINT_TIME ( ' populate_workplan_data 0003.6 ' ) ;
2478:
2479:
2480:
2481: UPDATE pji_plan_extr_tmp TMP
2482: SET (CAL_TYPE,ORG_ID)=
2483: (
2484: 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,
2485: pa.ORG_ID

Line 2499: UPDATE pji_plan_extr_tmp TMP

2495: WHERE tmp.AS_OF_DATE is not null;
2496:
2497: PRINT_TIME ( ' populate_workplan_data 0003.7.1 ' ) ;
2498:
2499: UPDATE pji_plan_extr_tmp TMP
2500: SET (END_PERIOD_ID,PERIOD_ID)=
2501: (
2502: SELECT cal.CAL_PERIOD_ID ,DECODE(tmp.cal_type, 'A', 2048, 32) PERIOD_TYPE_ID
2503: FROM pji_time_cal_period_v cal,

Line 2523: FROM PJI_PLAN_EXTR_TMP;

2519: CAL_TYPE,PERIOD_ID,END_PERIOD_ID
2520: BULK COLLECT INTO
2521: l_project_id_tbl,l_wk_struct_ver_id_tbl,l_lpb_struct_ver_id_tbl,l_base_struct_ver_id_tbl,
2522: l_cal_type_tbl,l_period_id_tbl, l_end_period_id_tbl
2523: FROM PJI_PLAN_EXTR_TMP;
2524:
2525: PRINT_TIME ( ' populate_workplan_data 0003.9 ' ) ;
2526:
2527: IF p_program_rollup_flag='Y' and p_calling_context='SUMMARIZE' and p_workplan_flag ='Y' THEN

Line 2533: INSERT into PJI_PLAN_EXTR_TMP

2529: PRINT_TIME ( ' populate_workplan_data 0003.9.1 ' ) ;
2530:
2531: FOR i IN 1 .. l_project_id_tbl.count
2532: LOOP
2533: INSERT into PJI_PLAN_EXTR_TMP
2534: (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
2535: SELECT
2536: head.PROJECT_ID,
2537: MAX(DECODE(SUBSTR(den.RECORD_TYPE,1,1), 'W', head.plan_version_id, NULL)) wk_plan_ver_id,

Line 2631: INSERT into PJI_PLAN_EXTR_TMP

2627:
2628: FOR i IN 1 .. l_project_id_tbl.count
2629: LOOP
2630:
2631: INSERT into PJI_PLAN_EXTR_TMP
2632: (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
2633: SELECT
2634: head.PROJECT_ID,
2635: MAX(DECODE(den.RECORD_TYPE, 'W', head.plan_version_id, NULL)) wk_plan_ver_id,

Line 2692: UPDATE pji_plan_extr_tmp

2688: /* Start of changes for bug 5751250 */
2689:
2690: IF p_calling_context = 'MSP' THEN
2691:
2692: UPDATE pji_plan_extr_tmp
2693: SET WK_PLAN_VER_ID = -1, BASE_PLAN_VER_ID = -1, LPB_PLAN_VER_ID = -1;
2694:
2695: END IF;
2696:

Line 2708: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp

2704: DELETE FROM pji_fm_xbs_accum_tmp1
2705: WHERE rowid IN
2706: (
2707: SELECT tmp.rowid
2708: FROM pji_plan_extr_tmp head, pji_fm_xbs_accum_tmp1 tmp
2709: WHERE head.project_id=tmp.project_id
2710: );
2711:
2712: END IF;

Line 2716: DELETE FROM PJI_PLAN_EXTR_TMP tmp1

2712: END IF;
2713:
2714: PRINT_TIME ( ' populate_workplan_data 0003.10.1 ' ) ;
2715:
2716: DELETE FROM PJI_PLAN_EXTR_TMP tmp1
2717: WHERE EXISTS
2718: ( SELECT * FROM PJI_PLAN_EXTR_TMP tmp2
2719: WHERE tmp1.PROJECT_ID=tmp2.PROJECT_ID
2720: AND tmp1.ROWID > tmp2.ROWID );

Line 2718: ( SELECT * FROM PJI_PLAN_EXTR_TMP tmp2

2714: PRINT_TIME ( ' populate_workplan_data 0003.10.1 ' ) ;
2715:
2716: DELETE FROM PJI_PLAN_EXTR_TMP tmp1
2717: WHERE EXISTS
2718: ( SELECT * FROM PJI_PLAN_EXTR_TMP tmp2
2719: WHERE tmp1.PROJECT_ID=tmp2.PROJECT_ID
2720: AND tmp1.ROWID > tmp2.ROWID );
2721:
2722: IF g_debug_mode='Y' THEN

Line 3198: pji_plan_extr_tmp head

3194: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
3195: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id , 8), 8, 'a'), 'b') = 'a'
3196: or decode ( cc_src.curr_type, 'POU', DECODE(BITAND(fact.curr_record_type_id, 4), 4, 'a'), 'b') = 'a' )
3197: ) fact,
3198: pji_plan_extr_tmp head
3199: WHERE 1=1
3200: and fact.PROJECT_ID = head.PROJECT_ID
3201: and fact.PLAN_VERSION_ID in (head.WK_PLAN_VER_ID , head.BASE_PLAN_VER_ID,
3202: head.LPB_PLAN_VER_ID )

Line 3226: DELETE FROM PJI_PLAN_EXTR_TMP;

3222:
3223:
3224:
3225:
3226: DELETE FROM PJI_PLAN_EXTR_TMP;
3227:
3228: x_return_status := l_return_status;
3229:
3230: PRINT_TIME ( ' populate_workplan_data 0003.13 ' ) ;