APPS.FII_AR_REVENUE_B_C dependencies on FND_STATS

Line 2175: FND_STATS.gather_table_stats

2171: END IF;
2172:
2173: COMMIT;
2174:
2175: FND_STATS.gather_table_stats
2176: (ownname => g_fii_schema,
2177: tabname => 'FII_AR_REVENUE_ID');
2178:
2179: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';

Line 2181: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');

2177: tabname => 'FII_AR_REVENUE_ID');
2178:
2179: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
2180:
2181: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');
2182:
2183: RETURN(l_count);
2184:
2185: EXCEPTION

Line 3936: FND_STATS.gather_table_stats (ownname => g_fii_schema,

3932: greatest( to_date(p_gl_to_date,'YYYY/MM/DD HH24:MI:SS'),
3933: sysdate + 7 ) ) + 1 - ONE_SECOND;
3934:
3935: l_count := UPDATE_GLOBAL_START_DATE_TBL( g_gl_from_date );
3936: FND_STATS.gather_table_stats (ownname => g_fii_schema,
3937: tabname => 'FII_GLOBAL_START_DATES');
3938:
3939: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
3940:

Line 3941: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');

3937: tabname => 'FII_GLOBAL_START_DATES');
3938:
3939: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
3940:
3941: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');
3942:
3943: ELSE
3944:
3945: -----------------------------------------------------------------

Line 4300: FND_STATS.gather_table_stats

4296:
4297: AR_STG(p_sort_area_size, p_hash_area_size, p_parallel_query);
4298:
4299: -- perf tune
4300: FND_STATS.gather_table_stats
4301: (ownname => g_fii_schema,
4302: tabname => 'FII_AR_REVENUE_STG');
4303:
4304: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';

Line 4306: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');

4302: tabname => 'FII_AR_REVENUE_STG');
4303:
4304: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
4305:
4306: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');
4307:
4308: -- Bug 4942753: Changed to return 1 if any row exists
4309: BEGIN
4310: /*

Line 4538: FND_STATS.gather_table_stats (ownname => g_fii_schema,

4534: fii_util.put_timestamp;
4535: fii_util.put_line('Anayzing staging table before checking missing rates.');
4536: end if;
4537:
4538: FND_STATS.gather_table_stats (ownname => g_fii_schema,
4539: tabname => 'FII_AR_REVENUE_STG');
4540:
4541: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
4542:

Line 4543: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');

4539: tabname => 'FII_AR_REVENUE_STG');
4540:
4541: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
4542:
4543: fii_util.put_line('Altering session enable parallel DML after FND_STATS call, bug 4127183.');
4544:
4545:
4546: END IF;
4547:

Line 4999: -- FND_STATS.gather_table_stats

4995: fii_util.put_line('Parameters: view type='||l_num_parameter1);
4996: fii_util.put_line(' jobs sequence='||l_num_parameter2);
4997: end if;
4998: l_count := POPULATE_STG(l_num_parameter1,l_num_parameter2);
4999: -- FND_STATS.gather_table_stats
5000: -- (ownname => g_fii_schema,
5001: -- tabname => 'FII_AR_REVENUE_STG');
5002: ELSE
5003: g_errbuf := '