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_MERGE_HELPER

Line 2695: pji_merge_helper pjp1

2691: , pjp1.CUSTOM14
2692: , pjp1.CUSTOM15
2693: , pjp1.PLAN_TYPE_CODE
2694: FROM
2695: pji_merge_helper pjp1
2696: WHERE 1=1
2697: AND worker_id = g_worker_id;
2698:
2699: EXCEPTION

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

4527: p_percent => 10);
4528:
4529: IF UPPER(FND_PROFILE.VALUE('PJI_SUM_CLEANALL')) = 'Y' THEN
4530: /* Clear temporary table */
4531: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_MERGE_HELPER','NORMAL','P'||g_worker_id);
4532:
4533: /* Disable Indexes PJI_FP_XBS_ACCUM_F*/
4534: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4535: , partitioned

Line 4569: /* Disable Indexes PJI_MERGE_HELPER*/

4565: END IF;
4566:
4567: END LOOP;
4568:
4569: /* Disable Indexes PJI_MERGE_HELPER*/
4570: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4571: , partitioned
4572: FROM dba_indexes
4573: WHERE table_name = 'PJI_MERGE_HELPER'

Line 4573: WHERE table_name = 'PJI_MERGE_HELPER'

4569: /* Disable Indexes PJI_MERGE_HELPER*/
4570: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4571: , partitioned
4572: FROM dba_indexes
4573: WHERE table_name = 'PJI_MERGE_HELPER'
4574: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4575: AND status <> 'UNUSABLE') LOOP
4576:
4577: IF ind_lp.partitioned = 'YES' THEN

Line 4591: INTO pji_merge_helper helper

4587:
4588: /* Populate temporary table */
4589:
4590: INSERT /*+ append parallel(helper) */
4591: INTO pji_merge_helper helper
4592: (worker_id,
4593: record_type,
4594: prg_level,
4595: project_id,

Line 4935: p_tabname => 'PJI_MERGE_HELPER',

4931:
4932: COMMIT;
4933:
4934: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4935: p_tabname => 'PJI_MERGE_HELPER',
4936: p_partname=> NULL,
4937: p_percent => 10);
4938:
4939: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

Line 4948: FROM pji_merge_helper pmh

4944: DELETE /*+ rowid(fact) parallel(fact) */
4945: FROM pji_fp_xbs_accum_f fact
4946: WHERE EXISTS (SELECT /*+ parallel(pmh) use_hash(pmh)*/
4947: NULL
4948: FROM pji_merge_helper pmh
4949: WHERE fact.rowid = pmh.fact_row_id
4950: AND pmh.worker_id = g_worker_id);
4951:
4952: COMMIT;

Line 4988: /* Rebuild indexes on PJI_MERGE_HELPER*/

4984: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARALLEL';
4985: END IF;
4986: END LOOP;
4987:
4988: /* Rebuild indexes on PJI_MERGE_HELPER*/
4989: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4990: , partitioned
4991: FROM dba_indexes
4992: WHERE table_name = 'PJI_MERGE_HELPER'

Line 4992: WHERE table_name = 'PJI_MERGE_HELPER'

4988: /* Rebuild indexes on PJI_MERGE_HELPER*/
4989: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4990: , partitioned
4991: FROM dba_indexes
4992: WHERE table_name = 'PJI_MERGE_HELPER'
4993: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4994:
4995: IF ind_lp.partitioned = 'YES' THEN
4996: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 5458: -- Put indexes back PJI_MERGE_HELPER

5454: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARALLEL';
5455: END IF;
5456: END LOOP;
5457:
5458: -- Put indexes back PJI_MERGE_HELPER
5459: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5460: , partitioned
5461: FROM dba_indexes
5462: WHERE table_name = 'PJI_MERGE_HELPER'

Line 5462: WHERE table_name = 'PJI_MERGE_HELPER'

5458: -- Put indexes back PJI_MERGE_HELPER
5459: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5460: , partitioned
5461: FROM dba_indexes
5462: WHERE table_name = 'PJI_MERGE_HELPER'
5463: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5464:
5465: IF ind_lp.partitioned = 'YES' THEN
5466: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';

Line 5500: l_Batch_t(i).request_id,'PJI_MERGE_HELPER')) THEN -- Modified for Bug 13490251

5496: FOR i IN l_Batch_t.first..l_Batch_t.last LOOP
5497:
5498: IF (l_Batch_t(i).request_id > 0 ) THEN
5499: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
5500: l_Batch_t(i).request_id,'PJI_MERGE_HELPER')) THEN -- Modified for Bug 13490251
5501: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('RUNNING',
5502: l_Batch_t(i).request_id,'PJI_MERGE_HELPER')) THEN -- Modified for Bug 13490251
5503: l_Batch_t(i).request_status := 'RUNNING';
5504: ELSE

Line 5502: l_Batch_t(i).request_id,'PJI_MERGE_HELPER')) THEN -- Modified for Bug 13490251

5498: IF (l_Batch_t(i).request_id > 0 ) THEN
5499: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
5500: l_Batch_t(i).request_id,'PJI_MERGE_HELPER')) THEN -- Modified for Bug 13490251
5501: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('RUNNING',
5502: l_Batch_t(i).request_id,'PJI_MERGE_HELPER')) THEN -- Modified for Bug 13490251
5503: l_Batch_t(i).request_status := 'RUNNING';
5504: ELSE
5505: l_Batch_t(i).request_status := 'COMPLETED';
5506: END IF;