DBA Data[Home] [Help]

APPS.JTF_TAE_CONTROL_PVT dependencies on JTF_TAE_INDEX_CREATION_PVT

Line 1210: l_selectivity_return_val := jtf_tae_index_creation_pvt.selectivity(l_trans_input_target);

1206: if p_process_tx_oin_sel = 'Y' or p_process_tx_oin_sel = 'R' then
1207: if p_process_tx_oin_sel = 'Y' then
1208: -- Analyze Selectivity and Get ordinals
1209: --dbms_output.put_line(' Analyze Selectivity and Get ordinals ');
1210: l_selectivity_return_val := jtf_tae_index_creation_pvt.selectivity(l_trans_input_target);
1211:
1212: IF l_selectivity_return_val <> 1 THEN
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;

Line 1245: jtf_tae_index_creation_pvt.drop_table_indexes(

1241:
1242: if p_generate_indexes = 'Y' then
1243: --dbms_output.put_line('Dropping and Generating Indexes');
1244: -- Drop Indexes
1245: jtf_tae_index_creation_pvt.drop_table_indexes(
1246: p_table_name => l_trans_input_target
1247: , x_return_status => l_return_status);
1248:
1249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1252: 'CALL to JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES ' ||

1248:
1249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1250:
1251: ERRBUF := 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS: [3]' ||
1252: 'CALL to JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES ' ||
1253: 'API has failed.';
1254: RAISE FND_API.G_EXC_ERROR;
1255:
1256: END IF;

Line 1259: jtf_tae_index_creation_pvt.create_index(

1255:
1256: END IF;
1257:
1258: -- Build Indexes
1259: jtf_tae_index_creation_pvt.create_index(
1260: p_table_name => l_trans_input_target
1261: , p_trans_object_type_id => l_trans_id
1262: , p_source_id => l_source_id
1263: , x_Return_Status => l_return_status

Line 1269: 'CALL to JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX ' ||

1265:
1266: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1267:
1268: ERRBUF := 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS: [4]' ||
1269: 'CALL to JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX ' ||
1270: 'API has failed.';
1271: RAISE FND_API.G_EXC_ERROR;
1272:
1273: END IF;

Line 1277: --JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

1273: END IF;
1274:
1275: -- Analyze Trans Input Target
1276: /* JDOCHERT: 04/10/03: bug#2896552 */
1277: --JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
1278: -- p_table_name => l_trans_input_target
1279: -- , p_percent => 5
1280: -- , x_Return_Status => l_return_status );
1281: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1283: -- 'CALL to JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX ' ||

1279: -- , p_percent => 5
1280: -- , x_Return_Status => l_return_status );
1281: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1282: -- ERRBUF := 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS: [5]' ||
1283: -- 'CALL to JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX ' ||
1284: -- 'API has failed.';
1285: -- RAISE FND_API.G_EXC_ERROR;
1286: -- END IF;
1287: --