APPS.ENI_DBI_PCO_LOAD_PKG dependencies on DBMS_MVIEW

Line 112: dbms_mview.refresh('ENI_DBI_BOM_COMPONENTS_MV1','F');

108: END IF;
109:
110: l_last_collected_date := fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('ENI_DBI_PART_COUNT_F'));
111:
112: dbms_mview.refresh('ENI_DBI_BOM_COMPONENTS_MV1','F');
113:
114: select sysdate into g_collection_date from dual;
115: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PCO_WORKER_ASSIGNMENTS';
116:

Line 171: dbms_mview.refresh('ENI_DBI_BOM_COMPONENTS_MV2','F');

167:
168: DELETE FROM bom_implosion_temp;
169: END LOOP; -- Completed Implosion all the Modified Bills.
170: COMMIT;
171: dbms_mview.refresh('ENI_DBI_BOM_COMPONENTS_MV2','F');
172:
173: end collect_modified_bills;
174:
175: procedure assign_worker_ids(p_collect_mode IN VARCHAR2) is

Line 339: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','C');

335: END IF;
336:
337: IF (p_collect_mode = 'INIT') THEN -- when initial collection, complete refresh the MV
338:
339: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','C');
340:
341: ELSE -- When Incremental collection
342:
343: -- Deleting from part count fact table the data for all the modified Bills.

Line 371: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','F');

367: -1
368: FROM ENI_DBI_PART_COUNT_INCR_TEMP);
369: COMMIT;
370: BEGIN
371: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','F');
372: /* Bug 5130157
373: Full refresh might raise error ORA 12034
374: catch it and execute a full refresh instead
375: */

Line 380: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','C');

376: EXCEPTION
377: WHEN OTHERS THEN
378: l_error_code := SQLCODE;
379: IF l_error_code = -12034 THEN
380: DBMS_MVIEW.REFRESH('ENI_DBI_PART_COUNT_MV','C');
381: ELSE
382: RAISE;
383: END IF;
384: END;

Line 448: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV1','C');

444:
445: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_f';
446: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_org_temp';
447:
448: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV1','C');
449: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV2','C');
450:
451: IF (p_organization_id IS NULL) THEN
452: INSERT INTO eni_dbi_part_count_org_temp

Line 449: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV2','C');

445: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_f';
446: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_org_temp';
447:
448: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV1','C');
449: DBMS_MVIEW.REFRESH('ENI_DBI_BOM_COMPONENTS_MV2','C');
450:
451: IF (p_organization_id IS NULL) THEN
452: INSERT INTO eni_dbi_part_count_org_temp
453: (organization_id)