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_PJP_PRG_PERF_ALL dependencies on PJI_FP_AGGR_PJP2

Line 4426: FROM PJI_FP_AGGR_PJP2 pjp2

4422: , NVL(pjp2.plan_type_id, -1) plan_type_id
4423: , pjp2.PLAN_TYPE_CODE
4424: , MIN(cal.start_date) min_txn_date
4425: , MAX(cal.end_date) max_txn_date
4426: FROM PJI_FP_AGGR_PJP2 pjp2
4427: , pji_time_cal_period_v cal
4428: WHERE
4429: pjp2.worker_id = g_worker_id
4430: AND pjp2.time_id = cal.cal_period_id

Line 4520: p_tabname => 'PJI_FP_AGGR_PJP2',

4516: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4517:
4518: -- gather statistics for PJI metadata tables
4519: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4520: p_tabname => 'PJI_FP_AGGR_PJP2',
4521: p_partname=>'P'|| g_worker_id,
4522: p_percent => 10);
4523:
4524: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

Line 4551: /* Disable Indexes PJI_FP_AGGR_PJP2*/

4547: END IF;
4548:
4549: END LOOP;
4550:
4551: /* Disable Indexes PJI_FP_AGGR_PJP2*/
4552: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4553: , partitioned
4554: FROM dba_indexes
4555: WHERE table_name = 'PJI_FP_AGGR_PJP2'

Line 4555: WHERE table_name = 'PJI_FP_AGGR_PJP2'

4551: /* Disable Indexes PJI_FP_AGGR_PJP2*/
4552: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4553: , partitioned
4554: FROM dba_indexes
4555: WHERE table_name = 'PJI_FP_AGGR_PJP2'
4556: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4557: AND status <> 'UNUSABLE') LOOP
4558:
4559: IF ind_lp.partitioned = 'YES' THEN

Line 4903: FROM pji_fp_aggr_pjp2 tmp

4899: , tmp.end_date
4900: , tmp.prg_level
4901: , tmp.record_type
4902: , tmp.rowid pjp_row_id
4903: FROM pji_fp_aggr_pjp2 tmp
4904: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
4905: WHERE 1 = 1
4906: AND tmp.worker_id = g_worker_id
4907: AND tmp.project_id = ver3.project_id

Line 4940: 'PJI_FP_AGGR_PJP2',

4936: p_partname=> NULL,
4937: p_percent => 10);
4938:
4939: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
4940: 'PJI_FP_AGGR_PJP2',
4941: 'PARTITION',
4942: 'P' || g_worker_id);
4943:
4944: DELETE /*+ rowid(fact) parallel(fact) */

Line 4974: /* Rebuild indexes on PJI_FP_AGGR_PJP2*/

4970: END IF;
4971:
4972: END LOOP;
4973:
4974: /* Rebuild indexes on PJI_FP_AGGR_PJP2*/
4975: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4976: , partitioned
4977: FROM dba_indexes
4978: WHERE table_name = 'PJI_FP_AGGR_PJP2'

Line 4978: WHERE table_name = 'PJI_FP_AGGR_PJP2'

4974: /* Rebuild indexes on PJI_FP_AGGR_PJP2*/
4975: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4976: , partitioned
4977: FROM dba_indexes
4978: WHERE table_name = 'PJI_FP_AGGR_PJP2'
4979: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4980:
4981: IF ind_lp.partitioned = 'YES' THEN
4982: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 5011: FROM (SELECT /+parallel(pji_fp_aggr_pjp2) rowid(pji_fp_aggr_pjp2) / rowid

5007: , MIN(rowid)
5008: , MAX(rowid)
5009: BULK COLLECT
5010: INTO l_pji_rowid_tab
5011: FROM (SELECT /*+parallel(pji_fp_aggr_pjp2) rowid(pji_fp_aggr_pjp2) */ rowid
5012: FROM pji_fp_aggr_pjp2
5013: WHERE worker_id = g_worker_id
5014: ORDER BY ROWID) pjp1
5015: GROUP BY TRUNC(ROWNUM/l_batch_size)

Line 5012: FROM pji_fp_aggr_pjp2

5008: , MAX(rowid)
5009: BULK COLLECT
5010: INTO l_pji_rowid_tab
5011: FROM (SELECT /*+parallel(pji_fp_aggr_pjp2) rowid(pji_fp_aggr_pjp2) */ rowid
5012: FROM pji_fp_aggr_pjp2
5013: WHERE worker_id = g_worker_id
5014: ORDER BY ROWID) pjp1
5015: GROUP BY TRUNC(ROWNUM/l_batch_size)
5016: ORDER BY 2;

Line 5160: FROM pji_fp_aggr_pjp2 tmp

5156: , tmp.CUSTOM13
5157: , tmp.CUSTOM14
5158: , tmp.CUSTOM15
5159: , tmp.PLAN_TYPE_CODE
5160: FROM pji_fp_aggr_pjp2 tmp
5161: , pji_pjp_wbs_header ver3 -- replaced ver3 with wbs header for project-to-program association event.
5162: WHERE 1 = 1
5163: AND tmp.worker_id = g_worker_id
5164: AND tmp.project_id = ver3.project_id

Line 5408: FROM pji_fp_aggr_pjp2 pjp1

5404: , pjp1.PLAN_TYPE_CODE
5405: );
5406:
5407: DELETE /*+ parallel(pjp1) */
5408: FROM pji_fp_aggr_pjp2 pjp1
5409: WHERE pjp1.worker_id = g_worker_id
5410: AND pjp1.rowid BETWEEN l_pji_rowid_tab(i).start_rowid
5411: AND l_pji_rowid_tab(i).end_rowid;
5412:

Line 5444: -- Put indexes back PJI_FP_AGGR_PJP2

5440: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARALLEL';
5441: END IF;
5442: END LOOP;
5443:
5444: -- Put indexes back PJI_FP_AGGR_PJP2
5445: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5446: , partitioned
5447: FROM dba_indexes
5448: WHERE table_name = 'PJI_FP_AGGR_PJP2'

Line 5448: WHERE table_name = 'PJI_FP_AGGR_PJP2'

5444: -- Put indexes back PJI_FP_AGGR_PJP2
5445: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5446: , partitioned
5447: FROM dba_indexes
5448: WHERE table_name = 'PJI_FP_AGGR_PJP2'
5449: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5450:
5451: IF ind_lp.partitioned = 'YES' THEN
5452: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 21619: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_FP_AGGR_PJP2','NORMAL','P'||g_worker_id);

21615:
21616: begin
21617:
21618: /* Added for bug 13897252 starts */
21619: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_FP_AGGR_PJP2','NORMAL','P'||g_worker_id);
21620:
21621: /* Drop Indexes */
21622: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
21623: , partitioned

Line 21625: WHERE table_name = 'PJI_FP_AGGR_PJP2'

21621: /* Drop Indexes */
21622: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
21623: , partitioned
21624: FROM dba_indexes
21625: WHERE table_name = 'PJI_FP_AGGR_PJP2'
21626: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
21627: AND status <> 'UNUSABLE') LOOP
21628:
21629: IF ind_lp.partitioned = 'YES' THEN

Line 21643: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

21639:
21640: if (p_worker_id =1) then
21641: -- Query for Partition 1
21642:
21643: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
21644: into PJI_FP_AGGR_PJP2 partition(P1)
21645:
21646: (
21647: WORKER_ID,

Line 21644: into PJI_FP_AGGR_PJP2 partition(P1)

21640: if (p_worker_id =1) then
21641: -- Query for Partition 1
21642:
21643: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
21644: into PJI_FP_AGGR_PJP2 partition(P1)
21645:
21646: (
21647: WORKER_ID,
21648: RECORD_TYPE,

Line 22061: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

22057:
22058: elsif (p_worker_id =2) then
22059: -- Query for Partition 2
22060:
22061: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
22062: into PJI_FP_AGGR_PJP2 partition(P2)
22063:
22064: (
22065: WORKER_ID,

Line 22062: into PJI_FP_AGGR_PJP2 partition(P2)

22058: elsif (p_worker_id =2) then
22059: -- Query for Partition 2
22060:
22061: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
22062: into PJI_FP_AGGR_PJP2 partition(P2)
22063:
22064: (
22065: WORKER_ID,
22066: RECORD_TYPE,

Line 22478: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

22474: nvl(sum(CUSTOM15), 0) = 0);
22475: elsif (p_worker_id =3) then
22476: -- Query for Partition 3
22477:
22478: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
22479: into PJI_FP_AGGR_PJP2 partition(P3)
22480:
22481: (
22482: WORKER_ID,

Line 22479: into PJI_FP_AGGR_PJP2 partition(P3)

22475: elsif (p_worker_id =3) then
22476: -- Query for Partition 3
22477:
22478: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
22479: into PJI_FP_AGGR_PJP2 partition(P3)
22480:
22481: (
22482: WORKER_ID,
22483: RECORD_TYPE,

Line 22895: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

22891: nvl(sum(CUSTOM15), 0) = 0);
22892: elsif (p_worker_id =4) then
22893: -- Query for Partition 4
22894:
22895: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
22896: into PJI_FP_AGGR_PJP2 partition(P4)
22897:
22898: (
22899: WORKER_ID,

Line 22896: into PJI_FP_AGGR_PJP2 partition(P4)

22892: elsif (p_worker_id =4) then
22893: -- Query for Partition 4
22894:
22895: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
22896: into PJI_FP_AGGR_PJP2 partition(P4)
22897:
22898: (
22899: WORKER_ID,
22900: RECORD_TYPE,

Line 23312: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

23308: nvl(sum(CUSTOM15), 0) = 0);
23309: elsif (p_worker_id =5) then
23310: -- Query for Partition 5
23311:
23312: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
23313: into PJI_FP_AGGR_PJP2 partition(P5)
23314:
23315: (
23316: WORKER_ID,

Line 23313: into PJI_FP_AGGR_PJP2 partition(P5)

23309: elsif (p_worker_id =5) then
23310: -- Query for Partition 5
23311:
23312: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
23313: into PJI_FP_AGGR_PJP2 partition(P5)
23314:
23315: (
23316: WORKER_ID,
23317: RECORD_TYPE,

Line 23729: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

23725: nvl(sum(CUSTOM15), 0) = 0);
23726: elsif (p_worker_id =6) then
23727: -- Query for Partition 6
23728:
23729: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
23730: into PJI_FP_AGGR_PJP2 partition(P6)
23731:
23732: (
23733: WORKER_ID,

Line 23730: into PJI_FP_AGGR_PJP2 partition(P6)

23726: elsif (p_worker_id =6) then
23727: -- Query for Partition 6
23728:
23729: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
23730: into PJI_FP_AGGR_PJP2 partition(P6)
23731:
23732: (
23733: WORKER_ID,
23734: RECORD_TYPE,

Line 24146: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

24142: nvl(sum(CUSTOM15), 0) = 0);
24143: elsif (p_worker_id =7) then
24144: -- Query for Partition 7
24145:
24146: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
24147: into PJI_FP_AGGR_PJP2 partition(P7)
24148:
24149: (
24150: WORKER_ID,

Line 24147: into PJI_FP_AGGR_PJP2 partition(P7)

24143: elsif (p_worker_id =7) then
24144: -- Query for Partition 7
24145:
24146: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
24147: into PJI_FP_AGGR_PJP2 partition(P7)
24148:
24149: (
24150: WORKER_ID,
24151: RECORD_TYPE,

Line 24563: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

24559: nvl(sum(CUSTOM15), 0) = 0);
24560: elsif (p_worker_id =8) then
24561: -- Query for Partition 8
24562:
24563: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
24564: into PJI_FP_AGGR_PJP2 partition(P8)
24565:
24566: (
24567: WORKER_ID,

Line 24564: into PJI_FP_AGGR_PJP2 partition(P8)

24560: elsif (p_worker_id =8) then
24561: -- Query for Partition 8
24562:
24563: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
24564: into PJI_FP_AGGR_PJP2 partition(P8)
24565:
24566: (
24567: WORKER_ID,
24568: RECORD_TYPE,

Line 24980: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

24976: nvl(sum(CUSTOM15), 0) = 0);
24977: elsif (p_worker_id =9) then
24978: -- Query for Partition 9
24979:
24980: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
24981: into PJI_FP_AGGR_PJP2 partition(P9)
24982:
24983: (
24984: WORKER_ID,

Line 24981: into PJI_FP_AGGR_PJP2 partition(P9)

24977: elsif (p_worker_id =9) then
24978: -- Query for Partition 9
24979:
24980: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
24981: into PJI_FP_AGGR_PJP2 partition(P9)
24982:
24983: (
24984: WORKER_ID,
24985: RECORD_TYPE,

Line 25397: insert /+ parallel(PJI_FP_AGGR_PJP2) / -- Added for bug 13897252

25393: nvl(sum(CUSTOM15), 0) = 0);
25394: elsif (p_worker_id =10) then
25395: -- Query for Partition 10
25396:
25397: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
25398: into PJI_FP_AGGR_PJP2 partition(P10)
25399:
25400: (
25401: WORKER_ID,

Line 25398: into PJI_FP_AGGR_PJP2 partition(P10)

25394: elsif (p_worker_id =10) then
25395: -- Query for Partition 10
25396:
25397: insert /*+ parallel(PJI_FP_AGGR_PJP2) */ -- Added for bug 13897252
25398: into PJI_FP_AGGR_PJP2 partition(P10)
25399:
25400: (
25401: WORKER_ID,
25402: RECORD_TYPE,

Line 25820: WHERE table_name = 'PJI_FP_AGGR_PJP2'

25816: -- Put the indexes back
25817: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
25818: , partitioned
25819: FROM dba_indexes
25820: WHERE table_name = 'PJI_FP_AGGR_PJP2'
25821: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
25822:
25823: IF ind_lp.partitioned = 'YES' THEN
25824: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 25840: WHERE table_name = 'PJI_FP_AGGR_PJP2'

25836: -- Put indexes back
25837: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
25838: , partitioned
25839: FROM dba_indexes
25840: WHERE table_name = 'PJI_FP_AGGR_PJP2'
25841: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
25842:
25843: IF ind_lp.partitioned = 'YES' THEN
25844: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';