DBA Data[Home] [Help]

APPS.ENI_DBI_PCO_LOAD_PKG dependencies on BIS_COLLECTION_UTILITIES

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 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 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 515: BIS_COLLECTION_UTILITIES.WRAPUP(

511: IF (p_collect_mode = 'INCR') THEN
512: ENI_DBI_PCO_LOAD_PKG.wait_for_workers('INCR');
513: ENI_DBI_PCO_LOAD_PKG.cleanup;
514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wait for workers is complete');
515: BIS_COLLECTION_UTILITIES.WRAPUP(
516: p_status => true,
517: p_period_from => sysdate,
518: p_period_to => g_collection_date);
519: ELSE

Line 522: BIS_COLLECTION_UTILITIES.WRAPUP(

518: p_period_to => g_collection_date);
519: ELSE
520: ENI_DBI_PCO_LOAD_PKG.wait_for_workers('INIT');
521: IF ((p_purge_fact = 'YES') OR (p_organization_id IS NULL)) THEN
522: BIS_COLLECTION_UTILITIES.WRAPUP(
523: p_status => true,
524: p_period_from => sysdate,
525: p_period_to => g_collection_date);
526: END IF;