[Home] [Help]
86: where ROWNUM = 1;
87:
88: if (l_count > 0) then
89:
90: insert into PA_PJI_PROJ_EVENTS_LOG
91: (
92: EVENT_TYPE,
93: EVENT_ID,
94: EVENT_OBJECT,
102: LAST_UPDATE_LOGIN
103: )
104: select
105: 'PRG_CHANGE',
106: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,
107: -1,
108: 'I',
109: 'X',
110: prj.PROJECT_ID,
219:
220: else
221:
222: delete
223: from PA_PJI_PROJ_EVENTS_LOG
224: where EVENT_TYPE in ('WBS_CHANGE',
225: 'WBS_PUBLISH',
226: 'PRG_CHANGE'
227: -- 'RBS_ASSOC', The source system depends on
229: -- 'RBS_PUSH', processing of these events, so
230: -- 'RBS_DELETE' they must persist after truncate.
231: );
232:
233: insert into PA_PJI_PROJ_EVENTS_LOG
234: (
235: EVENT_TYPE,
236: EVENT_ID,
237: EVENT_OBJECT,
245: LAST_UPDATE_LOGIN
246: )
247: select
248: 'PRG_CHANGE',
249: PA_PJI_PROJ_EVENTS_LOG_S.NEXTVAL,
250: -1,
251: 'I',
252: 'X',
253: prj.PROJECT_ID,
265: from PA_XBS_DENORM den
266: where den.STRUCT_TYPE = 'PRG' and
267: den.SUP_PROJECT_ID = prj.PROJECT_ID) /*and
268: not exists (select 1
269: from PA_PJI_PROJ_EVENTS_LOG log
270: where log.EVENT_TYPE = 'PRG_CHANGE' and
271: log.EVENT_OBJECT = -1 and
272: log.ATTRIBUTE1 = prj.PROJECT_ID) Commented for bug 9340121 */
273: and prj.PROJECT_ID = fm_status.project_id /* Added for bug 8661279 */
625:
626: -- PJP intermediate summarization tables
627: delete from PJI_SYSTEM_PRC_STATUS where PROCESS_NAME like (PJI_PJP_SUM_MAIN.g_process || '%');
628: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_PJP_PROJ_BATCH_MAP', 'NORMAL', null);
629: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'PLANTYPE_UPG'; /*4882640 */
630: -------------------
631:
632: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FP_AGGR_XBS', 'NORMAL', null);
633: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pa_schema, 'PA_XBS_DENORM', 'NORMAL', null);