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 1139: DELETE FROM PA_XBS_DENORM

1135:
1136: print_time ( 'deleted from rollup level status. # rows = ' || SQL%ROWCOUNT ) ;
1137:
1138: FORALL i IN 1..p_fp_version_ids.COUNT
1139: DELETE FROM PA_XBS_DENORM
1140: WHERE sup_project_id = l_project_ids(i)
1141: AND l_wp_flags(i) = 'Y'
1142: AND ( struct_version_id = l_wbs_version_ids(i)
1143: OR (struct_type = 'PRG' AND sup_id = l_wbs_version_ids(i) AND sub_id = l_wbs_version_ids(i)));

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

1141: AND l_wp_flags(i) = 'Y'
1142: AND ( struct_version_id = l_wbs_version_ids(i)
1143: OR (struct_type = 'PRG' AND sup_id = l_wbs_version_ids(i) AND sub_id = l_wbs_version_ids(i)));
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)

Line 1357: SELECT /*+ index(pxd PA_XBS_DENORM_N1) */ 1

1353: CURSOR c_wbs_vers_exist IS
1354: SELECT DISTINCT wbs_struct_version_id
1355: FROM pji_fm_extr_plnver3_t ver3
1356: WHERE EXISTS (
1357: SELECT /*+ index(pxd PA_XBS_DENORM_N1) */ 1
1358: FROM pa_xbs_denorm pxd
1359: WHERE 1=1
1360: AND struct_version_id IS NULL
1361: AND sup_id = ver3.wbs_struct_version_id

Line 1358: FROM pa_xbs_denorm pxd

1354: SELECT DISTINCT wbs_struct_version_id
1355: FROM pji_fm_extr_plnver3_t ver3
1356: WHERE EXISTS (
1357: SELECT /*+ index(pxd PA_XBS_DENORM_N1) */ 1
1358: FROM pa_xbs_denorm pxd
1359: WHERE 1=1
1360: AND struct_version_id IS NULL
1361: AND sup_id = ver3.wbs_struct_version_id
1362: );