[Home] [Help]
582: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);')) then
583: return;
584: end if;
585:
586: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i
587: (
588: WORKER_ID,
589: PROJECT_ID,
590: PROJECT_ORG_ID,
762: to_number(null) FORECAST_RAW_COST,
763: to_number(null) FORECAST_BURDENED_COST,
764: to_number(null) FORECAST_LABOR_HRS
765: from
766: PJI_FM_AGGR_FIN5 tmp5
767: where
768: tmp5.WORKER_ID = p_worker_id
769: group by
770: tmp5.PROJECT_ID,
1311: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);')) then
1312: return;
1313: end if;
1314:
1315: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_EN
1316: (
1317: WORKER_ID,
1318: PROJECT_ID,
1319: PROJECT_ORG_ID,
1395: sum(fin.QUANTITY) QUANTITY,
1396: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1397: from
1398: FII_TIME_DAY time,
1399: PJI_FM_AGGR_FIN5 fin
1400: where
1401: fin.WORKER_ID = p_worker_id and
1402: fin.PERIOD_TYPE_ID = 1 and
1403: fin.CALENDAR_TYPE = 'C' and
1444: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);')) then
1445: return;
1446: end if;
1447:
1448: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_PA
1449: (
1450: WORKER_ID,
1451: PROJECT_ID,
1452: PROJECT_ORG_ID,
1528: sum(fin.QUANTITY) QUANTITY,
1529: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1530: from
1531: FII_TIME_CAL_DAY_MV time,
1532: PJI_FM_AGGR_FIN5 fin
1533: where
1534: fin.WORKER_ID = p_worker_id and
1535: fin.PERIOD_TYPE_ID = 1 and
1536: fin.CALENDAR_TYPE = 'P' and
1577: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);')) then
1578: return;
1579: end if;
1580:
1581: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_GL
1582: (
1583: WORKER_ID,
1584: PROJECT_ID,
1585: PROJECT_ORG_ID,
1661: sum(fin.QUANTITY) QUANTITY,
1662: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1663: from
1664: FII_TIME_CAL_DAY_MV time,
1665: PJI_FM_AGGR_FIN5 fin
1666: where
1667: fin.WORKER_ID = p_worker_id and
1668: fin.PERIOD_TYPE_ID = 1 and
1669: fin.CALENDAR_TYPE = 'C' and
1707: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);')) then
1708: return;
1709: end if;
1710:
1711: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_WK
1712: (
1713: WORKER_ID,
1714: PROJECT_ID,
1715: PROJECT_ORG_ID,
1767: sum(fin.QUANTITY) QUANTITY,
1768: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1769: from
1770: FII_TIME_DAY time,
1771: PJI_FM_AGGR_FIN5 fin
1772: where
1773: fin.WORKER_ID = p_worker_id and
1774: fin.PERIOD_TYPE_ID = 1 and
1775: fin.CALENDAR_TYPE = 'C' and
3883: l_creation_date,
3884: l_created_by,
3885: l_last_update_login
3886: from
3887: PJI_FM_AGGR_FIN5 fin5
3888: where
3889: fin5.WORKER_ID = p_worker_id and
3890: (nvl(fin5.REVENUE , 0) <> 0 or
3891: nvl(fin5.LABOR_REVENUE , 0) <> 0 or
4005: fin5.BILL_LABOR_HRS,
4006: fin5.QUANTITY,
4007: fin5.BILL_QUANTITY
4008: from
4009: PJI_FM_AGGR_FIN5 fin5
4010: where
4011: fin5.WORKER_ID = p_worker_id
4012: union all -- partial refresh
4013: select /*+ ordered full(map) parallel(map)
4277: );
4278:
4279: -- truncate intermediate tables no longer required
4280: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4281: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN5' , 'NORMAL',null);
4282:
4283: commit;
4284:
4285: end MERGE_FIN_INTO_FPE;