[Home] [Help]
415: PJI_EXTRACTION_UTIL.UPDATE_EXTR_SCOPE;
416:
417: l_global_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
418:
419: insert into PJI_FM_PROJ_BATCH_MAP
420: (
421: WORKER_ID,
422: PROJECT_ID,
423: PROJECT_TYPE_CLASS,
493: -- identify all projects in the same program groups as the above projects
494:
495: if ( l_extraction_type='PARTIAL' ) then -- Bug#5099574 starts
496:
497: insert into PJI_FM_PROJ_BATCH_MAP
498: (
499: WORKER_ID,
500: PROJECT_ID,
501: PROJECT_TYPE_CLASS,
574: prg.STRUCT_TYPE = 'PRG' and
575: prg.SUP_PROJECT_ID = prj.PROJECT_ID and
576: emt.PROJ_ELEMENT_ID = prg.SUB_EMT_ID
577: ) active_projects,
578: PJI_FM_PROJ_BATCH_MAP existing_projects
579: where
580: (
581: (l_extraction_type = 'PARTIAL' and
582: status.EXTRACTION_STATUS Is not null)
592: ver1.PRG_GROUP in
593: (select
594: ver2.PRG_GROUP
595: from
596: PJI_FM_PROJ_BATCH_MAP map,
597: PA_PROJ_ELEMENT_VERSIONS ver2
598: where
599: ver2.PROJECT_ID = map.PROJECT_ID and
600: ver2.PRG_GROUP is not null
610: prg.PRG_GROUP in
611: (select /*+ ordered */
612: ver2.PRG_GROUP
613: from
614: PJI_FM_PROJ_BATCH_MAP map,
615: PA_PROJ_ELEMENT_VERSIONS ver2
616: where
617: ver2.PROJECT_ID = map.PROJECT_ID and
618: ver2.PRG_GROUP is not null
628: count(*)
629: into
630: l_count
631: from
632: PJI_FM_PROJ_BATCH_MAP ;
633:
634: if (l_count = 0) then
635:
636: rollback;
646: LAST_UPDATE_DATE = sysdate
647: where l_extraction_type <> 'PARTIAL' and
648: EXTRACTION_STATUS is null and
649: PROJECT_ID in (select PROJECT_ID
650: from PJI_FM_PROJ_BATCH_MAP
651: where WORKER_ID = 1);
652:
653: -- Set global process parameters
654: --
1481:
1482: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1483:
1484: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1485: 'PJI_FM_PROJ_BATCH_MAP',
1486: 'NORMAL',
1487: null);
1488:
1489: WRAPUP_SETUP;