[Home] [Help]
17: -- runs. In order to support error recovery we use tables
18: -- PJI_SYSTEM_PROCESS_STATUS and PJI_SYSTEM_PARAMETERS that store current
19: -- process status and process parameters such as batch id being processed.
20: -- The package accesses status tables through API package PJI_PROCESS_UTIL.
21: -- Scope of data extraction is defined by table PJI_ORG_EXTR_STATUS that
22: -- contains list of organizations for which we extract data.
23: -- We have to use persistent table, i.e. we cannot define scope dynamically
24: -- each time we run extraction because Table PJI_ORG_EXTR_STATUS may be
25: -- updated by multiple Project Intelligence data extraction processes running
20: -- The package accesses status tables through API package PJI_PROCESS_UTIL.
21: -- Scope of data extraction is defined by table PJI_ORG_EXTR_STATUS that
22: -- contains list of organizations for which we extract data.
23: -- We have to use persistent table, i.e. we cannot define scope dynamically
24: -- each time we run extraction because Table PJI_ORG_EXTR_STATUS may be
25: -- updated by multiple Project Intelligence data extraction processes running
26: -- in parallel.
27: -- In order to isolate the process from changes made to the table by
28: -- other extraction programs we create a snapshot of this table in
348: end if;
349:
350: select count(*)
351: into l_org_count
352: from PJI_ORG_EXTR_STATUS
353: where ROWNUM = 1;
354:
355: select count(*)
356: into l_project_count
448:
449: -- Update list of organizations to be extracted in case
450: -- users defined new organizations.
451: -- List of organizations is stored in table
452: -- PJI_ORG_EXTR_STATUS
453:
454: insert into PJI_ORG_EXTR_STATUS
455: (
456: ORGANIZATION_ID,
450: -- users defined new organizations.
451: -- List of organizations is stored in table
452: -- PJI_ORG_EXTR_STATUS
453:
454: insert into PJI_ORG_EXTR_STATUS
455: (
456: ORGANIZATION_ID,
457: STATUS,
458: CREATION_DATE,
469: distinct
470: org.ORGANIZATION_ID
471: from
472: PA_ALL_ORGANIZATIONS org,
473: PJI_ORG_EXTR_STATUS stat
474: where
475: org.ORGANIZATION_ID = stat.ORGANIZATION_ID (+) and
476: stat.ORGANIZATION_ID is null
477: ) org
501: else 'I'
502: end,
503: null
504: from
505: PJI_ORG_EXTR_STATUS sts;
506:
507: elsif (l_extraction_type = 'PARTIAL') then
508:
509: if (p_include_sub_org = 'Y') then
524: g_max_date,
525: 'P',
526: null
527: from
528: PJI_ORG_EXTR_STATUS sts,
529: PJI_ORG_DENORM orgs
530: where
531: p_prtl_schedule = 'Y' and
532: orgs.ORGANIZATION_ID = p_organization_id and
551: g_max_date,
552: 'P',
553: null
554: from
555: PJI_ORG_EXTR_STATUS sts
556: where
557: p_prtl_schedule = 'Y' and
558: sts.ORGANIZATION_ID = p_organization_id and
559: sts.STATUS = 'X';
578: null,
579: g_min_date,
580: g_max_date
581: from
582: PJI_ORG_EXTR_STATUS extr
583: where
584: extr.STATUS is null;
585:
586: end if;
584: extr.STATUS is null;
585:
586: end if;
587:
588: update PJI_ORG_EXTR_STATUS
589: set STATUS = 'X'
590: where l_extraction_type in ('FULL', 'INCREMENTAL') and
591: ORGANIZATION_ID IN (select map.ORGANIZATION_ID
592: from PJI_RM_ORG_BATCH_MAP map
1588:
1589: Customer can avoid this problem by, when they have no schedule data, not
1590: running schedule refresh.
1591:
1592: -- Bug 4892320. If pji_org_extr_status has 0 records then there is nothing to summarize and hence return.
1593: IF p_run_mode='R' THEN
1594:
1595: SELECT count(*)
1596: INTO l_org_count
1593: IF p_run_mode='R' THEN
1594:
1595: SELECT count(*)
1596: INTO l_org_count
1597: FROM pji_org_extr_status;
1598:
1599: IF l_org_count=0 THEN
1600:
1601: pji_utils.write2log('Nothing to summarize since pji_org_extr_status has 0 records');
1597: FROM pji_org_extr_status;
1598:
1599: IF l_org_count=0 THEN
1600:
1601: pji_utils.write2log('Nothing to summarize since pji_org_extr_status has 0 records');
1602: RETURN;
1603:
1604: END IF;
1605: