APPS.PJI_FM_PLAN_MAINT dependencies on PJI_XBS_DENORM

Line 398: -- 3. ... populate pji xbs denorm table for wbs/programs.

394: percent => 10);
395:
396: --#bug 5356051
397: --
398: -- 3. ... populate pji xbs denorm table for wbs/programs.
399: --
400: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(l_worker_id);
401: l_count := 31;
402: print_time('FPM Upgr c ' || l_count);

Line 409: , tabname => 'PJI_XBS_DENORM'

405: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
406:
407: FND_STATS.GATHER_TABLE_STATS(
408: ownname => l_pji_schema
409: , tabname => 'PJI_XBS_DENORM'
410: , percent => 10
411: , degree => l_degree
412: );
413:

Line 415: indname => 'PJI_XBS_DENORM_N1',

411: , degree => l_degree
412: );
413:
414: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
415: indname => 'PJI_XBS_DENORM_N1',
416: percent => 10);
417:
418: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
419: indname => 'PJI_XBS_DENORM_N2',

Line 419: indname => 'PJI_XBS_DENORM_N2',

415: indname => 'PJI_XBS_DENORM_N1',
416: percent => 10);
417:
418: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
419: indname => 'PJI_XBS_DENORM_N2',
420: percent => 10);
421:
422: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
423: indname => 'PJI_XBS_DENORM_N3',

Line 423: indname => 'PJI_XBS_DENORM_N3',

419: indname => 'PJI_XBS_DENORM_N2',
420: percent => 10);
421:
422: FND_STATS.GATHER_INDEX_STATS(ownname => l_pji_schema,
423: indname => 'PJI_XBS_DENORM_N3',
424: percent => 10);
425:
426: --#bug 5356051
427:

Line 1148: DELETE FROM PJI_XBS_DENORM

1144:
1145: print_time ( 'deleted from pa_xbs_denorm table. # rows = ' || SQL%ROWCOUNT ) ;
1146:
1147: FORALL i IN 1..p_fp_version_ids.COUNT
1148: DELETE FROM PJI_XBS_DENORM
1149: WHERE sup_project_id = l_project_ids(i)
1150: AND l_wp_flags(i) = 'Y'
1151: AND ( struct_version_id = l_wbs_version_ids(i)
1152: OR (struct_type = 'PRG' AND sup_id = l_wbs_version_ids(i) AND sub_id = l_wbs_version_ids(i)));

Line 1154: print_time ( 'deleted from pji_xbs_denorm table. # rows = ' || SQL%ROWCOUNT ) ;

1150: AND l_wp_flags(i) = 'Y'
1151: AND ( struct_version_id = l_wbs_version_ids(i)
1152: OR (struct_type = 'PRG' AND sup_id = l_wbs_version_ids(i) AND sub_id = l_wbs_version_ids(i)));
1153:
1154: print_time ( 'deleted from pji_xbs_denorm table. # rows = ' || SQL%ROWCOUNT ) ;
1155:
1156: IF (p_commit = 'T') THEN COMMIT; END IF;
1157:
1158: print_time('DELETE_ALL_PVT: end.. successful.. ');

Line 1477: Below code is added to avoid changes to PA/PJI xbs denorm tables

1473: --Below code is commented out for publish performance fixes
1474: -------------------------------------------------------------------
1475: /*
1476: Bug 4075697:
1477: Below code is added to avoid changes to PA/PJI xbs denorm tables
1478: during copy/move/indent/outdent flows during plan update
1479: Structure changes will get processed in process updates flow
1480: IF NVL(Pa_Task_Pub1.G_CALL_PJI_ROLLUP, 'Y') = 'N' THEN
1481: Pa_Task_Pub1.G_CALL_PJI_ROLLUP := NULL;

Line 1872: print_time(' Updated PJI xbs denorm. ');

1868: Pji_Pjp_Sum_Rollup.rollup_acr_wbs;
1869: print_time(' Did AC lines rollup. ');
1870:
1871: Pji_Pjp_Sum_Rollup.update_xbs_denorm;
1872: print_time(' Updated PJI xbs denorm. ');
1873:
1874: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(
1875: p_worker_id => 1
1876: , p_extraction_type => 'ONLINE');