DBA Data[Home] [Help]

APPS.OPI_EDW_OPI_JOB_RSRC_F_C dependencies on FND_INSTALLATION

Line 496: IF fnd_installation.get_app_info( 'OPI', l_status,

492: --RAISE l_iden_change_failure;
493: -- --------------------------------------------------------
494: -- Analyze the incremental table
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;

Line 638: IF fnd_installation.get_app_info( 'OPI', l_status,

634: Errbuf:=g_errbuf;
635: Retcode:=g_retcode;
636: l_exception_msg := Retcode || ':' || Errbuf;
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;