APPS.PA_PPR_CONCURRENT_PROGRAM dependencies on PA_PJT_PROJ_BATCH

Line 390: insert into pa_pjt_proj_batch

386: ppr_log('1');
387: If l_calling_mode in ( 'INCREMENTAL' , 'FULL' ) then
388:
389:
390: insert into pa_pjt_proj_batch
391: (
392: WORKER_ID,
393: PROJECT_ID,
394: PJI_PROJECT_STATUS,

Line 588: insert into pa_pjt_proj_batch

584: when no_data_found then
585: null;
586: end ;
587:
588: insert into pa_pjt_proj_batch
589: (
590: WORKER_ID,
591: PROJECT_ID,
592: PJI_PROJECT_STATUS,

Line 637: -- insert into pa_pjt_proj_batch.

633: ppr_log('count '||SQL%rowcount);
634:
635: end if;
636:
637: -- insert into pa_pjt_proj_batch.
638:
639: commit;
640:
641:

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 663: from pa_pjt_proj_batch b1

659: and b1.project_id = log.ATTRIBUTE19
660: and log.event_type = 'RBS_PUSH'
661: union all
662: select project_id , 'AAA' event_type, -1 rbs_version_id
663: from pa_pjt_proj_batch b1
664: where p_calling_mode IN ( 'FULL','INCREMENTAL' )
665: and b1.worker_id = c_worker_id ;
666:
667: cursor c_rbs ( p_project_id number ) is

Line 1072: update pa_pjt_proj_batch

1068: IS
1069:
1070: BEGIN
1071:
1072: update pa_pjt_proj_batch
1073: set PJI_PROJECT_STATUS = 'Y'
1074: where WORKER_ID = p_worker_id and
1075: PROJECT_ID in (select PROJECT_ID
1076: from PA_PROJECTS_ALL

Line 1245: pa_pjt_proj_batch map,

1241: select
1242: distinct
1243: asg.RBS_VERSION_ID
1244: from
1245: pa_pjt_proj_batch map,
1246: PA_RBS_PRJ_ASSIGNMENTS asg
1247: where
1248: map.WORKER_ID = p_worker_id and
1249: asg.PROJECT_ID = map.PROJECT_ID and

Line 1393: from pa_pjt_proj_batch

1389: PROJECT_ORGANIZATION_ID,
1390: PROJECT_TYPE_CLASS,
1391: PRJ_CURRENCY_CODE,
1392: PROJECT_ACTIVE_FLAG
1393: from pa_pjt_proj_batch
1394: where worker_id = p_worker_id and
1395: project_id = p_project_id;
1396:
1397: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);

Line 1524: -- pa_pjt_proj_batch map,

1520: log.ATTRIBUTE18,
1521: log.ATTRIBUTE19,
1522: log.ATTRIBUTE20
1523: from
1524: -- pa_pjt_proj_batch map,
1525: PA_PJI_PROJ_EVENTS_LOG log
1526: where
1527: 1 = 2 AND --- OLAP OPEN ITEM : to support programs with new model. Need to resolve this,
1528: -- map.WORKER_ID = p_worker_id and

Line 1573: -- pa_pjt_proj_batch map,

1569: distinct
1570: asg.RBS_HEADER_ID,
1571: asg.RBS_VERSION_ID
1572: from
1573: -- pa_pjt_proj_batch map,
1574: PA_RBS_PRJ_ASSIGNMENTS asg
1575: where
1576: -- map.WORKER_ID = p_worker_id and
1577: asg.PROJECT_ID = p_project_id