1242: END IF;
1243:
1244: -- gather table statistics
1245: --
1246: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_B');
1247:
1248: -- insert into _tl table
1249: --
1250: INSERT INTO hz_org_profiles_ext_tl ext (
1321: Write_Log(SQL%ROWCOUNT||' records inserted into org tl table.');
1322:
1323: -- gather table statistics
1324: --
1325: fnd_stats.gather_table_stats('AR', 'HZ_ORG_PROFILES_EXT_TL');
1326:
1327: END copy_org_extension;
1328:
1329:
1491: END IF;
1492:
1493: -- gather table statistics
1494: --
1495: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_B');
1496:
1497: -- insert into _tl table
1498: --
1499: INSERT INTO hz_per_profiles_ext_tl ext (
1570: Write_Log(SQL%ROWCOUNT||' records inserted into per tl table.');
1571:
1572: -- gather table statistics
1573: --
1574: fnd_stats.gather_table_stats('AR', 'HZ_PER_PROFILES_EXT_TL');
1575:
1576: END copy_per_extension;
1577:
1578: