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_UTILS

Line 58: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();

54:
55: l_degree NUMBER;
56:
57: BEGIN
58: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
59: -- Gather table stats
60: FND_STATS.GATHER_TABLE_STATS(
61: ownname => p_ownname
62: , tabname => p_tabname

Line 112: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();

108:
109: l_degree NUMBER;
110:
111: BEGIN
112: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
113: -- Gather table stats
114: FND_STATS.GATHER_TABLE_STATS(
115: ownname => p_ownname
116: , tabname => p_tabname

Line 573: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

569:
570: /* Added for Bug 13813361 Start */
571: l_process := PJI_PJP_SUM_MAIN.G_PROCESS || to_char(g_worker_id);
572: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE');
573: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
574:
575: IF (nvl(l_extraction_type,'N') = 'FULL' and PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') <> 'C') THEN
576:
577: GATHER_TEMP_STATS(p_ownname => l_pji_schema

Line 575: IF (nvl(l_extraction_type,'N') = 'FULL' and PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') <> 'C') THEN

571: l_process := PJI_PJP_SUM_MAIN.G_PROCESS || to_char(g_worker_id);
572: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE');
573: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
574:
575: IF (nvl(l_extraction_type,'N') = 'FULL' and PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE') <> 'C') THEN
576:
577: GATHER_TEMP_STATS(p_ownname => l_pji_schema
578: ,p_tabname => 'PJI_PJP_RMAP_FPR'
579: ,p_partname => 'P'||g_worker_id

Line 2331: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */

2327:
2328: BEGIN
2329:
2330: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2331: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */
2332:
2333: /* Added for Bug 13813361 Start */
2334: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2335: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name

Line 2334: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

2330: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2331: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */
2332:
2333: /* Added for Bug 13813361 Start */
2334: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2335: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
2336: FROM dba_indexes
2337: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
2338: AND table_owner = l_pji_schema ) LOOP

Line 2507: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

2503: WHERE 1=1
2504: AND worker_id = g_worker_id;
2505:
2506: /* Added for Bug 13813361 Start */
2507: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2508: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
2509: FROM dba_indexes
2510: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
2511: AND table_owner = l_pji_schema ) LOOP

Line 2536: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */

2532:
2533: BEGIN
2534:
2535: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2536: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME; /* Added for Bug 13813361 */
2537:
2538: INSERT /*+ append parallel(rl) */ INTO pji_fp_xbs_accum_f rl
2539: (
2540: PROJECT_ID

Line 2734: PJI_UTILS.g_max_roll_days := 1500; /5155692 /

2730:
2731: DELETE FROM PJI_FM_AGGR_DLY_RATES
2732: WHERE worker_id = g_worker_id;
2733:
2734: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
2735:
2736: INSERT INTO PJI_FM_AGGR_DLY_RATES (
2737: WORKER_ID ,
2738: PF_CURRENCY_CODE ,

Line 2747: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code

2743: MAU2)
2744: select worker_id,
2745: projfunc_currency_code,
2746: time_id,
2747: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code
2748: , DECODE ( g_currency_conversion_rule
2749: , 'S'
2750: , temp.start_date
2751: , 'E'

Line 2755: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),

2751: , 'E'
2752: , temp.end_date ))
2753: rate1,
2754: l_gl1_mau mau1,
2755: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
2756: 'Y',
2757: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(
2758: temp.projfunc_currency_code,
2759: DECODE ( g_currency_conversion_rule

Line 2757: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(

2753: rate1,
2754: l_gl1_mau mau1,
2755: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
2756: 'Y',
2757: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(
2758: temp.projfunc_currency_code,
2759: DECODE ( g_currency_conversion_rule
2760: , 'S'
2761: , temp.start_date

Line 2840: PJI_UTILS.g_max_roll_days := NULL;

2836: AND ver.project_id = ppa.project_id
2837: AND ver.worker_id = g_worker_id
2838: ) temp;
2839:
2840: PJI_UTILS.g_max_roll_days := NULL;
2841:
2842: /* Added for bug 13897252 starts */
2843: UPDATE PJI_FM_EXTR_PLNVER4 ver
2844: SET rate_dangling_flag = 'Y'

Line 4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

4097: ) spread_bl
4098: ,
4099: (
4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert

Line 4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

4100: select 1 INVERT_ID from dual union all
4101: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
4102: select 4 INVERT_ID from dual union all
4103: select 8 INVERT_ID from dual union all
4104: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4105: ) invert
4106: ) collapse_bl
4107: GROUP BY
4108: collapse_bl.PROJECT_ID

Line 4519: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4515:
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:

Line 4524: 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,
4525: p_tabname => 'PJI_FP_XBS_ACCUM_F',
4526: p_partname=> NULL,
4527: p_percent => 10);
4528:

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 4538: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME

4534: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4535: , partitioned
4536: FROM dba_indexes
4537: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
4538: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4539: AND status <> 'UNUSABLE') LOOP
4540:
4541: IF ind_lp.partitioned = 'YES' THEN
4542:

Line 4556: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME

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
4560:

Line 4574: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME

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
4578:

Line 4934: GATHER_TEMP_STATS1(p_ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4930: AND pjp1.rbs_element_id = fact.rbs_element_id(+);
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:

Line 4939: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(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,
4940: 'PJI_FP_AGGR_PJP2',
4941: 'PARTITION',
4942: 'P' || g_worker_id);
4943:

Line 4964: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

4960: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4961: , partitioned
4962: FROM dba_indexes
4963: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
4964: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4965:
4966: IF ind_lp.partitioned = 'YES' THEN
4967: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';
4968: ELSE

Line 4979: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

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';
4983: ELSE

Line 4993: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

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';
4997: ELSE

Line 5435: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

5431: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5432: , partitioned
5433: FROM dba_indexes
5434: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
5435: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5436:
5437: IF ind_lp.partitioned = 'YES' THEN
5438: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';
5439: ELSE

Line 5449: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

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';
5453: ELSE

Line 5463: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

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';
5467: ELSE

Line 6346: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');

6342: end if;
6343: end if;
6344:
6345: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
6346: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');
6347:
6348: if l_fpm_upgrade = 'P' then
6349: execute immediate 'alter session force parallel query';
6350: end if ;

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

6520:
6521: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
6522:
6523: /* Added for bug 13897252 */
6524: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_FP_AGGR_PJP1','NORMAL','P'||g_worker_id);
6525:
6526: IF (l_extraction_type IN ('PARTIAL', 'RBS', 'INCREMENTAL', 'FULL')) THEN
6527:
6528: /* Commented for bug 13897252 */

Line 6612: -- PJI_UTILS.SET_CURR_FUNCTION(p_process || '$' || to_char(l_seq));

6608: where PROCESS_NAME = p_process and
6609: STEP_NAME = p_step and
6610: START_DATE is null;
6611:
6612: -- PJI_UTILS.SET_CURR_FUNCTION(p_process || '$' || to_char(l_seq));
6613: PJI_UTILS.WRITE2LOG('Entering ' || p_step || ' for ' || p_process,
6614: true, 0);
6615: return true;
6616: end if;

Line 6613: PJI_UTILS.WRITE2LOG('Entering ' || p_step || ' for ' || p_process,

6609: STEP_NAME = p_step and
6610: START_DATE is null;
6611:
6612: -- PJI_UTILS.SET_CURR_FUNCTION(p_process || '$' || to_char(l_seq));
6613: PJI_UTILS.WRITE2LOG('Entering ' || p_step || ' for ' || p_process,
6614: true, 0);
6615: return true;
6616: end if;
6617:

Line 6640: -- PJI_UTILS.RESET_CURR_FUNCTION;

6636: END_DATE = sysdate
6637: where PROCESS_NAME = p_process and
6638: STEP_NAME = p_step;
6639:
6640: -- PJI_UTILS.RESET_CURR_FUNCTION;
6641: PJI_UTILS.WRITE2LOG('Completed ' || p_step || ' for ' || p_process,
6642: true, 0);
6643:
6644: end REGISTER_STEP_COMPLETION;

Line 6641: PJI_UTILS.WRITE2LOG('Completed ' || p_step || ' for ' || p_process,

6637: where PROCESS_NAME = p_process and
6638: STEP_NAME = p_step;
6639:
6640: -- PJI_UTILS.RESET_CURR_FUNCTION;
6641: PJI_UTILS.WRITE2LOG('Completed ' || p_step || ' for ' || p_process,
6642: true, 0);
6643:
6644: end REGISTER_STEP_COMPLETION;
6645:

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 21626: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME

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
21630:

Line 25821: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

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';
25825: ELSE

Line 25841: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

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';
25845: ELSE