DBA Data[Home] [Help]

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_TAE_INDEX_CREATION_PVT

Line 125: jty_tae_index_creation_pvt.SELECTIVITY(p_TABLE_NAME => p_table_name,

121: WHERE source_id = p_source_id );
122: END IF;
123:
124: /* Calculate the selectivity of the columns in the denorm value table */
125: jty_tae_index_creation_pvt.SELECTIVITY(p_TABLE_NAME => p_table_name,
126: p_mode => p_mode,
127: p_source_id => p_source_id,
128: x_return_status => x_return_status);
129:

Line 134: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');

130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
131: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
133: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
134: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
135: END IF;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:

Line 1519: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

1515: END IF;
1516:
1517: /* analyze the denorm value table to caluclate the selectivity of the columns */
1518: IF (p_mode <> 'INCREMENTAL') THEN
1519: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1520: p_table_name => l_table_name
1521: , p_percent => 20
1522: , x_return_status => x_return_status );
1523: END IF;

Line 1527: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;

1523: END IF;
1524:
1525: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1526: retcode := 2;
1527: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1528: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
1530: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1531: 'ANALYZE_TABLE_INDEX API has failed');