APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTY_TAE_INDEX_CREATION_PVT

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

150: WHERE source_id = p_source_id );
151: END IF;
152:
153: /* Calculate the selectivity of the columns in the denorm value table */
154: jty_tae_index_creation_pvt.SELECTIVITY(p_TABLE_NAME => p_table_name,
155: p_mode => p_mode,
156: p_source_id => p_source_id,
157: x_return_status => x_return_status);
158:

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

158:
159: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
160: jty_log(FND_LOG.LEVEL_EXCEPTION,
161: 'jtf.plsql.jty_terr_denorm_rules_pvt.create_dnmval_index.selectivity',
162: 'API jty_tae_index_creation_pvt.SELECTIVITY has failed');
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: /* Determine the indexes that need to be created */

Line 1663: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

1659: 'Number of rows inserted : ' || SQL%ROWCOUNT);
1660:
1661: /* analyze the denorm value table to caluclate the selectivity of the columns */
1662: IF (p_mode <> 'INCREMENTAL') THEN
1663: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1664: p_table_name => l_table_name
1665: , p_percent => 20
1666: , x_return_status => x_return_status );
1667: END IF;

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

1667: END IF;
1668:
1669: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1670: retcode := 2;
1671: errbuf := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for table ' || l_table_name;
1672: jty_log(FND_LOG.LEVEL_EXCEPTION,
1673: 'jtf.plsql.JTY_TERR_DENORM_RULES_PVT.process_attr_values.analyze_table_index',
1674: 'ANALYZE_TABLE_INDEX API has failed');
1675: