APPS.PJI_FM_SUM_MAIN dependencies on PJI_FM_PROJ_BATCH_MAP

Line 420: insert into PJI_FM_PROJ_BATCH_MAP

416: PJI_EXTRACTION_UTIL.UPDATE_EXTR_SCOPE;
417:
418: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
419:
420: insert into PJI_FM_PROJ_BATCH_MAP
421: (
422: WORKER_ID,
423: PROJECT_ID,
424: PROJECT_TYPE_CLASS,

Line 498: insert into PJI_FM_PROJ_BATCH_MAP

494: -- identify all projects in the same program groups as the above projects
495:
496: if ( l_extraction_type='PARTIAL' ) then -- Bug#5099574 starts
497:
498: insert into PJI_FM_PROJ_BATCH_MAP
499: (
500: WORKER_ID,
501: PROJECT_ID,
502: PROJECT_TYPE_CLASS,

Line 579: PJI_FM_PROJ_BATCH_MAP existing_projects

575: prg.STRUCT_TYPE = 'PRG' and
576: prg.SUP_PROJECT_ID = prj.PROJECT_ID and
577: emt.PROJ_ELEMENT_ID = prg.SUB_EMT_ID
578: ) active_projects,
579: PJI_FM_PROJ_BATCH_MAP existing_projects
580: where
581: (
582: (l_extraction_type = 'PARTIAL' and
583: status.EXTRACTION_STATUS Is not null)

Line 597: PJI_FM_PROJ_BATCH_MAP map,

593: ver1.PRG_GROUP in
594: (select
595: ver2.PRG_GROUP
596: from
597: PJI_FM_PROJ_BATCH_MAP map,
598: PA_PROJ_ELEMENT_VERSIONS ver2
599: where
600: ver2.PROJECT_ID = map.PROJECT_ID and
601: ver2.PRG_GROUP is not null

Line 615: PJI_FM_PROJ_BATCH_MAP map,

611: prg.PRG_GROUP in
612: (select /*+ ordered */
613: ver2.PRG_GROUP
614: from
615: PJI_FM_PROJ_BATCH_MAP map,
616: PA_PROJ_ELEMENT_VERSIONS ver2
617: where
618: ver2.PROJECT_ID = map.PROJECT_ID and
619: ver2.PRG_GROUP is not null

Line 633: PJI_FM_PROJ_BATCH_MAP ;

629: count(*)
630: into
631: l_count
632: from
633: PJI_FM_PROJ_BATCH_MAP ;
634:
635: if (l_count = 0) then
636:
637: rollback;

Line 651: from PJI_FM_PROJ_BATCH_MAP

647: LAST_UPDATE_DATE = sysdate
648: where l_extraction_type <> 'PARTIAL' and
649: EXTRACTION_STATUS is null and
650: PROJECT_ID in (select PROJECT_ID
651: from PJI_FM_PROJ_BATCH_MAP
652: where WORKER_ID = 1);
653:
654: -- Set global process parameters
655: --

Line 1486: 'PJI_FM_PROJ_BATCH_MAP',

1482:
1483: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1484:
1485: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1486: 'PJI_FM_PROJ_BATCH_MAP',
1487: 'NORMAL',
1488: null);
1489:
1490: WRAPUP_SETUP;