eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENI_DBI_PCO_LOAD_PKG dependencies on ENI_DBI_PART_COUNT_F

Line 110: l_last_collected_date := fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('ENI_DBI_PART_COUNT_F'));

106: IF(FND_INSTALLATION.GET_APP_INFO('ENI', l_status, l_industry, g_eni_schema))
107: THEN NULL;
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;

Line 241: DELETE FROM eni_dbi_part_count_f

237: NVL(bbom.common_assembly_item_id,bbom.assembly_item_id) = msi.inventory_item_id and
238: msi.bom_item_type <> 2 );
239: COMMIT; -- Commit the bills to be collected into the worker assignments table
240:
241: DELETE FROM eni_dbi_part_count_f
242: WHERE (assembly_item_id,organization_id) IN
243: (SELECT assembly_item_id, organization_id
244: FROM eni_dbi_pco_worker_assignments);
245: COMMIT;

Line 344: DELETE FROM ENI_DBI_PART_COUNT_F

340:
341: ELSE -- When Incremental collection
342:
343: -- Deleting from part count fact table the data for all the modified Bills.
344: DELETE FROM ENI_DBI_PART_COUNT_F
345: WHERE
346: (assembly_item_id,organization_id) IN
347: (SELECT assembly_item_id, organization_id FROM eni_dbi_pco_worker_assignments);
348: commit;

Line 350: INSERT INTO ENI_DBI_PART_COUNT_F(

346: (assembly_item_id,organization_id) IN
347: (SELECT assembly_item_id, organization_id FROM eni_dbi_pco_worker_assignments);
348: commit;
349:
350: INSERT INTO ENI_DBI_PART_COUNT_F(
351: assembly_item_id,
352: organization_id,
353: item_id_fk,
354: component_item_id,

Line 441: IF (BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'ENI_DBI_PART_COUNT_F') = false) then

437:
438: IF (p_collect_mode = 'INIT') THEN
439: IF ((p_purge_fact = 'YES') OR (p_organization_id IS NULL)) THEN
440:
441: IF (BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'ENI_DBI_PART_COUNT_F') = false) then
442: RAISE_APPLICATION_ERROR(-20000,l_error_msg);
443: END IF;
444:
445: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_f';

Line 445: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_f';

441: IF (BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'ENI_DBI_PART_COUNT_F') = false) then
442: RAISE_APPLICATION_ERROR(-20000,l_error_msg);
443: END IF;
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');

Line 462: -- delete from eni_dbi_part_count_f

458: (organization_id) VALUES (p_organization_id);
459: COMMIT;
460: END IF;
461: ELSE
462: -- delete from eni_dbi_part_count_f
463: -- where organization_id = p_organization_id;
464: -- COMMIT;
465:
466: SELECT NVL((SELECT 1 from eni_dbi_part_count_org_temp

Line 479: IF (BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'ENI_DBI_PART_COUNT_F') = false) then

475: END IF;
476:
477: ELSE
478: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_part_count_incr_temp';
479: IF (BIS_COLLECTION_UTILITIES.SETUP(p_object_name => 'ENI_DBI_PART_COUNT_F') = false) then
480: RAISE_APPLICATION_ERROR(-20000,l_error_msg);
481: END IF;
482: END IF;
483:

Line 591: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PART_COUNT_F';

587: o_error_msg := 'Warning';
588: ELSIF (NVL(p_error_occured,0) = 2) THEN
589: o_error_code := 2;
590: o_error_msg := 'Error occured';
591: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||g_eni_schema||'.ENI_DBI_PART_COUNT_F';
592: END IF;
593: END IF;
594: END LOOP;
595:

Line 683: EXECUTE IMMEDIATE 'truncate table '||g_eni_schema||'.eni_dbi_part_count_f';

679: worker_id = p_worker_id AND
680: assembly_item_id = l_inventory_item_id AND
681: organization_id = l_org_id;
682: COMMIT;
683: EXECUTE IMMEDIATE 'truncate table '||g_eni_schema||'.eni_dbi_part_count_f';
684: RETURN; -- Returning with out collecting remaining bills due to error
685: ELSE
686: ENI_DBI_UTIL_PKG.LOG('Increase the MAX_BOM_LEVEL value in the profile of the Organization ' || l_org_id);
687: ENI_DBI_UTIL_PKG.LOG('If the MAX_BOM_LEVEL value is 59, then this is max number of levels possible for explosion.');

Line 699: INSERT /+ APPEND / INTO eni_dbi_part_count_f

695:
696: FOR l_temp_var IN 1..1 LOOP
697: BEGIN
698: IF (p_collect_mode = 'INIT') THEN
699: INSERT /*+ APPEND */ INTO eni_dbi_part_count_f
700: (
701: assembly_item_id,
702: organization_id,
703: item_id_fk,

Line 793: EXECUTE IMMEDIATE 'truncate table '||g_eni_schema||'.eni_dbi_part_count_f';

789: -- Modified as part of the fix for the Bug # 3127260
790: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following error has occured while inserting into the Part Count fact table');
791: ENI_DBI_UTIL_PKG.LOG(l_error_code||':'||l_error_msg);
792: ENI_DBI_UTIL_PKG.LOG('An error prevented the INCREMENTAL part count collection from completing successfully');
793: EXECUTE IMMEDIATE 'truncate table '||g_eni_schema||'.eni_dbi_part_count_f';
794: RETURN; -- Return from the for loop after the explosion.
795: END;
796: END LOOP;
797: