APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_PJT_EVENTS

Line 432: insert into pa_pjt_events_02

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,

Line 550: pa_pjt_events_02 log ,

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

Line 577: delete from pa_pjt_events_02 log

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:

Line 621: pa_pjt_events_02 log,

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

Line 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

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'

Line 669: from PA_RBS_PRJ_ASSIGNMENTS ASSIGN, pa_rbs_versions_b rbsv, pa_pjt_events log

665: and b1.worker_id = c_worker_id ;
666:
667: cursor c_rbs ( p_project_id number ) is
668: select distinct assign.rbs_version_id , nvl(log.event_type,'AAA') event_type
669: from PA_RBS_PRJ_ASSIGNMENTS ASSIGN, pa_rbs_versions_b rbsv, pa_pjt_events log
670: where ASSIGN.project_id = p_project_id
671: and ASSIGN.reporting_usage_flag = 'Y'
672: AND ASSIGN.rbs_version_id = rbsv.rbs_version_id
673: AND rbsv.current_reporting_flag = 'Y'

Line 680: from PA_RBS_PRJ_ASSIGNMENTS prj, pa_pjt_events log, pa_rbs_versions_b rbsv

676: AND log.event_object (+) = assign.rbs_version_id;
677: /*
678: union all
679: select prj.rbs_version_id , log.event_type event_type
680: from PA_RBS_PRJ_ASSIGNMENTS prj, pa_pjt_events log, pa_rbs_versions_b rbsv
681: where prj.project_id = p_project_id
682: and log.event_type = 'RBS_ASSOC'
683: and log.attribute1 = prj.project_id
684: and reporting_usage_flag = 'Y'

Line 1308: pa_pjt_events

1304: ATTRIBUTE20 RBS_HEADER_ID,
1305: ATTRIBUTE2 OLD_RBS_VERSION_ID,
1306: EVENT_OBJECT NEW_RBS_VERSION_ID
1307: from
1308: pa_pjt_events
1309: where
1310: WORKER_ID = p_worker_id and
1311: EVENT_TYPE = 'RBS_PUSH' AND
1312: attribute19 = p_project_id;

Line 1566: pa_pjt_events_02 log,

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,

Line 1593: insert into pa_pjt_events

1589: if ( p_calling_mode = 'INCREMENTAL' ) then
1590:
1591: for c in events(p_worker_id) loop -- satya (removed p_project_id and added p_worker_id
1592:
1593: insert into pa_pjt_events
1594: (
1595: WORKER_ID,
1596: LOG_ROWID,
1597: EVENT_TYPE,

Line 1677: insert into pa_pjt_events

1673:
1674: i:= 0;
1675: for c in pjt_events_02 loop
1676:
1677: insert into pa_pjt_events
1678: (
1679: WORKER_ID,
1680: LOG_ROWID,
1681: EVENT_TYPE,

Line 1760: from pa_pjt_events_02 a

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: