APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on FND_INSTALLATION

Line 254: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_isc_schema)) THEN

250: l_industry VARCHAR2(30);
251:
252: BEGIN
253:
254: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_isc_schema)) THEN
255: l_stmt := 'TRUNCATE TABLE ' || l_isc_schema ||'.'||table_name;
256: EXECUTE IMMEDIATE l_stmt;
257: END IF;
258:

Line 667: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN

663:
664: COMMIT;
665:
666:
667: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
668: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
669: TABNAME => 'ISC_DBI_CHANGE_LOG');
670: END IF;
671:

Line 705: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN

701: IF l_delete_count > 0 THEN
702: BIS_COLLECTION_UTILITIES.Put_Line(' ');
703: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
704: FII_UTIL.Start_Timer;
705: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
706: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
707: TABNAME => 'ISC_TMP_BOOK_SUM2');
708: END IF;
709: FII_UTIL.Stop_Timer;

Line 2399: IF (FND_INSTALLATION.GET_APP_INFO('ONT', l_status, l_industry, l_ont_schema)) THEN

2395: -- --------------------------------------------
2396: -- Identify Change for Booked Orders Lines
2397: -- --------------------------------------------
2398:
2399: IF (FND_INSTALLATION.GET_APP_INFO('ONT', l_status, l_industry, l_ont_schema)) THEN
2400: l_stmt := 'TRUNCATE TABLE ' || l_ont_schema ||'.ONT_DBI_CHANGE_LOG';
2401: EXECUTE IMMEDIATE l_stmt;
2402: END IF;
2403:

Line 2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN

2431: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2432: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
2433: FII_UTIL.Start_Timer;
2434:
2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');

Line 2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN

2611: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2612: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
2613: FII_UTIL.Start_Timer;
2614:
2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');