[Home] [Help]
36:
37:
38:
39: INSERT
40: INTO opi_edw_OPI_job_rsrc_inc(primary_key1,primary_key2,primary_key3,primary_key4,primary_key5,primary_key6,seq_id,view_id)
41: SELECT
42: DISTINCT
43: wor.organization_id,
44: wor.wip_entity_id,
100: ELSIF p_view_id = 2 THEN
101:
102:
103: INSERT
104: INTO opi_edw_opi_job_rsrc_inc(primary_key1,primary_key2,primary_key3,primary_key4,primary_key5,primary_key6,seq_id,view_id)
105: SELECT
106: DISTINCT
107: wt.organization_id,
108: wt.wip_entity_id,
495: -- --------------------------------------------------------
496: IF fnd_installation.get_app_info( 'OPI', l_status,
497: l_industry, l_opi_schema) THEN
498: fnd_stats.gather_table_stats(ownname=> l_opi_schema,
499: tabname=> 'OPI_EDW_OPI_JOB_RSRC_INC' );
500: END IF;
501:
502: -- --------------------------------------------------------
503: -- Pushing data to local staging table for view type 1
585:
586: -- CAN WE USE DELETE INSTEAD OF TRUNCATE, THIS WILL ENABLE US TO DELETE
587: -- RECORDS SELECTIVELY
588:
589: execute immediate 'truncate table '||l_opi_schema||'.opi_edw_opi_job_rsrc_inc ';
590:
591:
592:
593: -- --------------------------------------------
637:
638: IF fnd_installation.get_app_info( 'OPI', l_status,
639: l_industry, l_opi_schema) THEN
640: execute immediate 'truncate table ' || l_opi_schema
641: || '.opi_edw_opi_job_rsrc_inc ';
642: END IF;
643: edw_log.put_line('Identifying changed records have Failed');
644: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
645: raise;