[Home] [Help]
428: If l_calling_mode = 'RBS' then
429:
430: ppr_log('2');
431:
432: insert into pa_pjt_events_02
433: (
434: WORKER_ID,
435: LOG_ROWID,
436: EVENT_TYPE,
546: sysdate CREATION_DATE,
547: -1 CREATED_BY,
548: -1 LAST_UPDATE_LOGIN
549: from
550: pa_pjt_events_02 log ,
551: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
552: PA_PROJECTS_ALL prj
553: where
554: log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE') and
573: rbs_asg.PROJECT_ID = prj.PROJECT_ID and
574: prj.pjt_rollup_enabled_flag = 'Y' )
575: and log.pjt_rollup_flag = 'N' ;
576:
577: delete from pa_pjt_events_02 log
578: where log.EVENT_TYPE in ('RBS_PUSH', 'RBS_DELETE')
579: and log.ATTRIBUTE16 = 'N' ;
580:
581:
617: 'INDIRECT', 'I') PROJECT_TYPE_CLASS,
618: prj.PROJECT_CURRENCY_CODE,
619: 'Y' PROJECT_ACTIVE_FLAG
620: from
621: pa_pjt_events_02 log,
622: PA_RBS_PRJ_ASSIGNMENTS rbs_asg,
623: PA_PROJECTS_ALL prj,
624: PA_PROJECT_TYPES_ALL pt
625: where
652: is
653:
654: cursor c1 ( c_worker_id number ) is
655: select project_id , log.event_type event_type, to_number(log.event_object) rbs_version_id
656: from pa_pjt_proj_batch b1 , pa_pjt_events_02 log --satya -- delete old_rbs_version from fact -- delete from pa_pjt_events and pa_pjt_events_02
657: where p_calling_mode = 'RBS'
658: and b1.worker_id = c_worker_id
659: and b1.project_id = log.ATTRIBUTE19
660: and log.event_type = 'RBS_PUSH'
1562: log.ATTRIBUTE18, -- push chain flag
1563: log.ATTRIBUTE19, -- project id
1564: ver.RBS_HEADER_ID ATTRIBUTE20 -- rbs header
1565: from
1566: pa_pjt_events_02 log,
1567: (
1568: select
1569: distinct
1570: asg.RBS_HEADER_ID,
1756: g_rbs_version_id_index_arr(c.EVENT_OBJECT) := 0 ;
1757:
1758: end if;
1759: delete
1760: from pa_pjt_events_02 a
1761: where ROWID = c.LOG_ROWID;
1762:
1763: end loop;
1764: