[Home] [Help]
304: -- Set PJI_PJP_EXTRACTION_UTILS to 1.
305: -- Store PJP summarization state by
306: -- a. inserting a row in PJI_SYSTEM_CONFIG_HIST with process name (PJI_EXTR1) and
307: -- extraction type (FULL) with system date as start date.
308: -- b. inserting rows in PJI_PJP_PROJ_BATCH_MAP with worker id and project id information.
309: -- Set values of system parameters PA_CALENDAR_FLAG and GL_CALENDAR_FLAG with that in pji_system_settings table.
310: -- Commit these changes.
311: --
312:
553: -- b. Delete records in PJI_SYSTEM_PRC_STATUS for process PJI_EXTR.
554: -- c. Delete records in PJI_SYSTEM_PARAMETERS for process PJI_EXTR1.
555: -- d. Set end date on PJI_SYSTEM_CONFIG_HIST for this process.
556: -- e. Set system parameter PJP_FPM_UPGRADE_DATE to sysdate.
557: -- f. Delete data from PJI_PJP_PROJ_BATCH_MAP for worker id l_worker_id = 1.
558: --
559:
560: PJI_FM_XBS_ACCUM_UTILS.FPM_UPGRADE_END;
561: l_count := l_count + 1;
1986: G2_BILL_BRDN_COST , G2_REVENUE_WRITEOFF , G2_SUP_INV_COMMITTED_COST ,
1987: G2_PO_COMMITTED_COST , G2_PR_COMMITTED_COST , G2_OTH_COMMITTED_COST ,
1988: ASSIGNMENT_ID , NAMED_ROLE --Bug#4590810
1989: FROM pji_fm_aggr_fin7 tmp
1990: ,PJI_PJP_PROJ_BATCH_MAP map
1991: ,pa_proj_fp_options ppfo
1992: WHERE
1993: tmp.PROJECT_ID=map.PROJECT_ID AND
1994: map.WORKER_ID = p_worker_id AND
2038: G2_REVENUE , G2_RAW_COST , G2_BRDN_COST ,
2039: G2_BILL_RAW_COST , G2_BILL_BRDN_COST , ASSIGNMENT_ID ,
2040: p_worker_id , 'A' , NAMED_ROLE --Bug#4590810
2041: FROM pji_fp_txn_accum tmp
2042: ,PJI_PJP_PROJ_BATCH_MAP map
2043: ,pa_proj_fp_options ppfo
2044: WHERE
2045: tmp.PROJECT_ID=map.PROJECT_ID AND
2046: map.WORKER_ID = p_worker_id AND