876: l_table_count NUMBER;
877:
878: BEGIN
879:
880: l_schema_name := FII_UTIL.get_schema_name('FII');
881:
882: EXECUTE IMMEDIATE 'truncate table '||l_schema_name||'.fii_ar_summary_gt';
883:
884:
1576: 2. We then insert all columns of corresponding gt table + session_id and report_region_code into debug tables.
1577: */
1578:
1579: l_table_count NUMBER := 0;
1580: l_schema_name VARCHAR2(10) := FII_UTIL.get_schema_name('FII');
1581:
1582: BEGIN
1583:
1584: SELECT COUNT(*) INTO l_table_count