DBA Data[Home] [Help]

APPS.BIM_I_SGMT_CUST_FACTS_PKG dependencies on FND_INSTALLATION

Line 389: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);

385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: bis_collection_utilities.log('Running Initial Load of Segment Customer Facts');
388:
389: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
390:
391: bis_collection_utilities.log('Truncating Facts Table');
392:
393: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_facts' ;

Line 687: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);

683: bis_collection_utilities.log('Running Incremental Load of Segment Customer Facts');
684:
685: bis_collection_utilities.log('Inserting Segment Customer Details');
686:
687: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
688:
689: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';
690:
691: --SQL TO COLLECT PARTIES AND SEGMENT COMBINATION WHICH IS PRESENT IN FACT