[Home] [Help]
529: tmp1.CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S,
530: tmp1.PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
531: from
532: PJI_RM_WORK_TYPE_INFO wt,
533: PJI_RM_AGGR_RES1 tmp1
534: where
535: tmp1.WORKER_ID = p_worker_id and
536: tmp1.RECORD_TYPE <> 'N' and
537: 'NORMAL' = wt.RECORD_TYPE (+) and
757: )) then
758: return;
759: end if;
760:
761: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
762: (
763: WORKER_ID,
764: RECORD_TYPE,
765: PROJECT_ID,
827: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
828: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
829: from
830: FII_TIME_DAY time,
831: PJI_RM_AGGR_RES1 tmp1
832: where
833: tmp1.WORKER_ID = p_worker_id and
834: tmp1.RECORD_TYPE <> 'N' and
835: tmp1.PERIOD_TYPE_ID = 1 and
905: )) then
906: return;
907: end if;
908:
909: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
910: (
911: WORKER_ID,
912: RECORD_TYPE,
913: PROJECT_ID,
975: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
976: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
977: from
978: FII_TIME_CAL_DAY_MV time,
979: PJI_RM_AGGR_RES1 tmp1
980: where
981: tmp1.WORKER_ID = p_worker_id and
982: tmp1.RECORD_TYPE <> 'N' and
983: tmp1.PERIOD_TYPE_ID = 1 and
1054: )) then
1055: return;
1056: end if;
1057:
1058: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
1059: (
1060: WORKER_ID,
1061: RECORD_TYPE,
1062: PROJECT_ID,
1124: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
1125: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
1126: from
1127: FII_TIME_CAL_DAY_MV time,
1128: PJI_RM_AGGR_RES1 tmp1
1129: where
1130: tmp1.WORKER_ID = p_worker_id and
1131: tmp1.RECORD_TYPE <> 'N' and
1132: tmp1.PERIOD_TYPE_ID = 1 and
1193: )) then
1194: return;
1195: end if;
1196:
1197: insert /*+ append parallel(res1_i) */ into PJI_RM_AGGR_RES1 res1_i
1198: (
1199: WORKER_ID,
1200: RECORD_TYPE,
1201: PROJECT_ID,
1239: sum(tmp1.CONF_OVERCOM_HRS_S) CONF_OVERCOM_HRS_S,
1240: sum(tmp1.PROV_OVERCOM_HRS_S) PROV_OVERCOM_HRS_S
1241: from
1242: FII_TIME_DAY time,
1243: PJI_RM_AGGR_RES1 tmp1
1244: where
1245: tmp1.WORKER_ID = p_worker_id and
1246: tmp1.RECORD_TYPE <> 'N' and
1247: tmp1.PERIOD_TYPE_ID = 1 and
2140: l_creation_date CREATION_DATE,
2141: l_created_by CREATED_BY,
2142: l_last_update_login LAST_UPDATE_LOGIN
2143: from
2144: PJI_RM_AGGR_RES1 res1
2145: where
2146: WORKER_ID = p_worker_id and
2147: EXPENDITURE_ORGANIZATION_ID is not null and
2148: RECORD_TYPE <> 'N'
2187: l_creation_date CREATION_DATE,
2188: l_created_by CREATED_BY,
2189: l_last_update_login LAST_UPDATE_LOGIN
2190: from
2191: PJI_RM_AGGR_RES1 res1
2192: where
2193: WORKER_ID = p_worker_id and
2194: EXPENDITURE_ORGANIZATION_ID is not null and
2195: RECORD_TYPE <> 'N'
2377: JOB_ID,
2378: TIME_ID,
2379: PERIOD_TYPE_ID,
2380: CALENDAR_TYPE
2381: from PJI_RM_AGGR_RES1 res1
2382: where WORKER_ID = p_worker_id and
2383: RECORD_TYPE <> 'N') and
2384: nvl(CAPACITY_HRS, 0) = 0 and
2385: nvl(TOTAL_HRS_A, 0) = 0 and
2396: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);'
2397: );
2398:
2399: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
2400: 'PJI_RM_AGGR_RES1','NORMAL',null);
2401:
2402: commit;
2403:
2404: end CLEANUP_RMR;
3601:
3602: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3603:
3604: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3605: 'PJI_RM_AGGR_RES1','NORMAL',null);
3606:
3607: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3608: 'PJI_RM_AGGR_RES2','NORMAL',null);
3609: