[Home] [Help]
75:
76: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
77: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
78:
79: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i
80: (
81: WORKER_ID,
82: PROJECT_ID,
83: PROJECT_ORGANIZATION_ID,
643: sum(tmp4.BILL_LABOR_HRS),
644: sum(QUANTITY),
645: sum(BILL_QUANTITY)
646: from
647: PJI_FM_AGGR_FIN4 tmp4
648: where
649: tmp4.WORKER_ID = p_worker_id
650: group by
651: tmp4.PROJECT_ID,
804:
805: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
806: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
807:
808: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_EN
809: (
810: WORKER_ID,
811: PROJECT_ID,
812: PROJECT_ORG_ID,
890: sum(fin.QUANTITY) QUANTITY,
891: sum(fin.BILL_QUANTITY) BILL_QUANTITY
892: from
893: FII_TIME_DAY time,
894: PJI_FM_AGGR_FIN4 fin
895: where
896: fin.WORKER_ID = p_worker_id and
897: fin.PERIOD_TYPE_ID = 1 and
898: fin.CALENDAR_TYPE = 'C' and
940: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);')) then
941: return;
942: end if;
943:
944: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_PA
945: (
946: WORKER_ID,
947: PROJECT_ID,
948: PROJECT_ORG_ID,
1026: sum(fin.QUANTITY) QUANTITY,
1027: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1028: from
1029: FII_TIME_CAL_DAY_MV time,
1030: PJI_FM_AGGR_FIN4 fin
1031: where
1032: fin.WORKER_ID = p_worker_id and
1033: fin.PERIOD_TYPE_ID = 1 and
1034: fin.CALENDAR_TYPE = 'P' and
1076: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);')) then
1077: return;
1078: end if;
1079:
1080: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_GL
1081: (
1082: WORKER_ID,
1083: PROJECT_ID,
1084: PROJECT_ORG_ID,
1162: sum(fin.QUANTITY) QUANTITY,
1163: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1164: from
1165: FII_TIME_CAL_DAY_MV time,
1166: PJI_FM_AGGR_FIN4 fin
1167: where
1168: fin.WORKER_ID = p_worker_id and
1169: fin.PERIOD_TYPE_ID = 1 and
1170: fin.CALENDAR_TYPE = 'C' and
1209: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);')) then
1210: return;
1211: end if;
1212:
1213: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_WK
1214: (
1215: WORKER_ID,
1216: PROJECT_ID,
1217: PROJECT_ORG_ID,
1271: sum(fin.QUANTITY) QUANTITY,
1272: sum(fin.BILL_QUANTITY) BILL_QUANTITY
1273: from
1274: FII_TIME_DAY time,
1275: PJI_FM_AGGR_FIN4 fin
1276: where
1277: fin.WORKER_ID = p_worker_id and
1278: fin.PERIOD_TYPE_ID = 1 and
1279: fin.CALENDAR_TYPE = 'C' and
3390: l_creation_date,
3391: l_created_by,
3392: l_last_update_login
3393: from
3394: PJI_FM_AGGR_FIN4 fin4
3395: where
3396: fin4.WORKER_ID = p_worker_id and
3397: (nvl(fin4.RAW_COST , 0) <> 0 or
3398: nvl(fin4.BURDENED_COST , 0) <> 0 or
3507: fin4.BILL_LABOR_HRS,
3508: fin4.QUANTITY,
3509: fin4.BILL_QUANTITY
3510: from
3511: PJI_FM_AGGR_FIN4 fin4
3512: where
3513: fin4.WORKER_ID = p_worker_id
3514: union all -- partial refresh
3515: select /*+ ordered full(map) parallel(map)
3764: );
3765:
3766: -- truncate intermediate tables no longer required
3767: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3768: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN4' , 'NORMAL',null);
3769:
3770: commit;
3771:
3772: end MERGE_FIN_INTO_FPW;