[Home] [Help]
399:
400: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
401: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
402:
403: insert /*+ noappend parallel(fin2_i) */ into PJI_FM_AGGR_FIN2 fin2_i -- in DANGLING_FIN_ROWS
404: ( --Bug 7139059
405: WORKER_ID,
406: DANGLING_RECVR_GL_RATE_FLAG,
407: DANGLING_RECVR_GL_RATE2_FLAG,
3201: from PJI_FM_DNGL_FIN fin
3202: where WORKER_ID = 0 and
3203: (RECORD_TYPE = 'M' or
3204: ROWID in (select ROW_ID
3205: from PJI_FM_AGGR_FIN2
3206: where WORKER_ID = p_worker_id)); */
3207: -- Commented above and added below for Bug 7357456
3208: -- Spliting the above delete into two different deletes statements
3209: delete from PJI_FM_DNGL_FIN where worker_id = 0 and record_type = 'M';
3207: -- Commented above and added below for Bug 7357456
3208: -- Spliting the above delete into two different deletes statements
3209: delete from PJI_FM_DNGL_FIN where worker_id = 0 and record_type = 'M';
3210:
3211: delete from PJI_FM_DNGL_FIN where worker_id = 0 and ROWID in (select row_id from PJI_FM_AGGR_FIN2 where worker_id = p_worker_id);
3212: -- End for Bug# 7357456
3213:
3214: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);');
3215:
3304:
3305: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
3306: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
3307:
3308: insert /*+ noappend parallel(fin2_i) */ into PJI_FM_AGGR_FIN2 fin2_i -- in FIN_SUMMARY
3309: ( --Bug 7139059
3310: WORKER_ID,
3311: DANGLING_RECVR_GL_RATE_FLAG,
3312: DANGLING_RECVR_GL_RATE2_FLAG,
4641: TOTAL_HRS_A,
4642: BILL_HRS_A,
4643: CBS_ELEMENT_ID /* Added for CBS Changes */
4644: from
4645: PJI_FM_AGGR_FIN2 fin2
4646: where
4647: WORKER_ID = p_worker_id and
4648: (DANGLING_RECVR_GL_RATE_FLAG is not null or
4649: DANGLING_RECVR_GL_RATE2_FLAG is not null or
4659: DANGLING_RECVR_PA_TIME_FLAG is not null or
4660: DANGLING_EXP_PA_TIME_FLAG is not null);
4661:
4662: delete /*+ parallel(fin2) */
4663: from PJI_FM_AGGR_FIN2 fin2
4664: where WORKER_ID = p_worker_id and
4665: (DANGLING_RECVR_GL_RATE_FLAG is not null or
4666: DANGLING_RECVR_GL_RATE2_FLAG is not null or
4667: DANGLING_RECVR_PA_RATE_FLAG is not null or
6122: RS_PA_CALENDAR_ID PA_CALENDAR_ID,
6123: sum(LABOR_HRS) TOTAL_HRS_A,
6124: sum(BILL_LABOR_HRS) BILL_HRS_A
6125: from
6126: PJI_FM_AGGR_FIN2
6127: where
6128: WORKER_ID = p_worker_id and
6129: PJI_RESOURCE_RECORD_FLAG = 'Y'
6130: group by
6479: fin2.TOTAL_HRS_A,
6480: fin2.BILL_HRS_A,
6481: fin2.PJI_PROJECT_RECORD_FLAG
6482: from
6483: PJI_FM_AGGR_FIN2 fin2
6484: where
6485: fin2.WORKER_ID = p_worker_id and
6486: fin2.PJI_PROJECT_RECORD_FLAG = 'Y'
6487: union all
6580: to_number(null) BILL_HRS_A,
6581: cmt.PJI_PROJECT_RECORD_FLAG
6582: from
6583: PJI_FM_PJI_CMT cmt,
6584: PJI_FM_AGGR_FIN2 fin2
6585: where
6586: fin2.WORKER_ID = p_worker_id and
6587: cmt.PJI_PROJECT_RECORD_FLAG = 'Y' and
6588: cmt.project_id = fin2.project_id and
6629: if PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null then
6630: /* Modified for bug 9483220 *
6631: delete from PJI_FM_PJI_CMT
6632: where project_id in (select distinct project_id
6633: from PJI_FM_AGGR_FIN2);
6634:
6635: insert into PJI_FM_PJI_CMT
6636: (
6637: WORKER_ID ,
6762: PO_LINE_ID ,
6763: RESOURCE_CLASS_CODE ,
6764: ASSIGNMENT_ID
6765: from
6766: PJI_FM_AGGR_FIN2 tmp2
6767: where
6768: tmp2.WORKER_ID = p_worker_id and
6769: tmp2.PJI_PROJECT_RECORD_FLAG = 'Y' and
6770: tmp2.RECORD_TYPE = 'M';
7646: 'NORMAL',
7647: null);
7648:
7649: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
7650: 'PJI_FM_AGGR_FIN2',
7651: 'NORMAL',
7652: null);
7653:
7654: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,