APPS.PJI_FM_PLAN_MAINT dependencies on PA_XBS_DENORM

Line 360: -- 2. ... populate pa xbs denorm table for wbs/programs.

356: print_time('FPM Upgr z2 ' || l_count);
357:
358:
359: --
360: -- 2. ... populate pa xbs denorm table for wbs/programs.
361: --
362:
363: l_count := l_count + 1;
364: print_time('FPM Upgr b ' || l_count);

Line 379: , tabname => 'PA_XBS_DENORM'

375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: FND_STATS.GATHER_TABLE_STATS(
378: ownname => l_pa_schema
379: , tabname => 'PA_XBS_DENORM'
380: , percent => 10
381: , degree => l_degree
382: );
383:

Line 385: indname => 'PA_XBS_DENORM_N1',

381: , degree => l_degree
382: );
383:
384: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
385: indname => 'PA_XBS_DENORM_N1',
386: percent => 10);
387:
388: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
389: indname => 'PA_XBS_DENORM_N2',

Line 389: indname => 'PA_XBS_DENORM_N2',

385: indname => 'PA_XBS_DENORM_N1',
386: percent => 10);
387:
388: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
389: indname => 'PA_XBS_DENORM_N2',
390: percent => 10);
391:
392: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
393: indname => 'PA_XBS_DENORM_N3',

Line 393: indname => 'PA_XBS_DENORM_N3',

389: indname => 'PA_XBS_DENORM_N2',
390: percent => 10);
391:
392: FND_STATS.GATHER_INDEX_STATS(ownname => l_pa_schema,
393: indname => 'PA_XBS_DENORM_N3',
394: percent => 10);
395:
396: --#bug 5356051
397: --

Line 1182: DELETE FROM PA_XBS_DENORM

1178:
1179: print_time ( 'deleted from rollup level status. # rows = ' || SQL%ROWCOUNT ) ;
1180:
1181: FORALL i IN 1..p_fp_version_ids.COUNT
1182: DELETE FROM PA_XBS_DENORM
1183: WHERE sup_project_id = l_project_ids(i)
1184: AND l_wp_flags(i) = 'Y'
1185: AND ( struct_version_id = l_wbs_version_ids(i)
1186: OR (struct_type = 'PRG' AND sup_id = l_wbs_version_ids(i) AND sub_id = l_wbs_version_ids(i)));

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

1184: AND l_wp_flags(i) = 'Y'
1185: AND ( struct_version_id = l_wbs_version_ids(i)
1186: OR (struct_type = 'PRG' AND sup_id = l_wbs_version_ids(i) AND sub_id = l_wbs_version_ids(i)));
1187:
1188: print_time ( 'deleted from pa_xbs_denorm table. # rows = ' || SQL%ROWCOUNT ) ;
1189:
1190: FORALL i IN 1..p_fp_version_ids.COUNT
1191: DELETE FROM PJI_XBS_DENORM
1192: WHERE sup_project_id = l_project_ids(i)

Line 1411: FROM pa_xbs_denorm pxd

1407: SELECT DISTINCT wbs_struct_version_id
1408: FROM pji_fm_extr_plnver3_t ver3
1409: WHERE EXISTS (
1410: SELECT /*+ no_unnest */ 1 -- bug 7607077 asahoo - replaced index hint
1411: FROM pa_xbs_denorm pxd
1412: WHERE 1=1
1413: AND struct_version_id IS NULL
1414: AND sup_id = ver3.wbs_struct_version_id
1415: );