eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTY_TAE_CONTROL_PVT dependencies on JTY_TAE_INDEX_CREATION_PVT

Line 2337: jty_tae_index_creation_pvt.dea_selectivity(p_trans_target, x_return_status);

2333: IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) THEN
2334: IF (p_process_tx_oin_sel = 'Y') THEN
2335: -- Analyze Selectivity and Get ordinals
2336: IF (p_mode = 'DATE EFFECTIVE') THEN
2337: jty_tae_index_creation_pvt.dea_selectivity(p_trans_target, x_return_status);
2338:
2339: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2340: x_msg_data := 'API jty_tae_index_creation_pvt.dea_selectivity has failed';
2341: RAISE FND_API.G_EXC_ERROR;

Line 2340: x_msg_data := 'API jty_tae_index_creation_pvt.dea_selectivity has failed';

2336: IF (p_mode = 'DATE EFFECTIVE') THEN
2337: jty_tae_index_creation_pvt.dea_selectivity(p_trans_target, x_return_status);
2338:
2339: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2340: x_msg_data := 'API jty_tae_index_creation_pvt.dea_selectivity has failed';
2341: RAISE FND_API.G_EXC_ERROR;
2342: END IF;
2343: ELSE
2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);

Line 2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);

2340: x_msg_data := 'API jty_tae_index_creation_pvt.dea_selectivity has failed';
2341: RAISE FND_API.G_EXC_ERROR;
2342: END IF;
2343: ELSE
2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);
2345:
2346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2347: x_msg_data := 'API jty_tae_index_creation_pvt.selectivity has failed';
2348: RAISE FND_API.G_EXC_ERROR;

Line 2347: x_msg_data := 'API jty_tae_index_creation_pvt.selectivity has failed';

2343: ELSE
2344: jty_tae_index_creation_pvt.selectivity(p_trans_target, p_mode, null, x_return_status);
2345:
2346: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2347: x_msg_data := 'API jty_tae_index_creation_pvt.selectivity has failed';
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: END IF; /* end IF (p_mode = 'DATE EFFECTIVE') */
2351:

Line 2397: jty_tae_index_creation_pvt.drop_table_indexes(

2393: END IF;
2394: END IF; /* end IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) */
2395:
2396: IF (p_generate_indexes = 'Y') THEN
2397: jty_tae_index_creation_pvt.drop_table_indexes(
2398: p_table_name => p_trans_target
2399: , x_return_status => x_return_status);
2400:
2401: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2402: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed.';

2398: p_table_name => p_trans_target
2399: , x_return_status => x_return_status);
2400:
2401: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2402: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed.';
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405:
2406: -- Build Indexes

Line 2408: jty_tae_index_creation_pvt.create_index( p_trans_target

2404: END IF;
2405:
2406: -- Build Indexes
2407: IF (p_mode = 'DATE EFFECTIVE') THEN
2408: jty_tae_index_creation_pvt.create_index( p_trans_target
2409: , p_trans_id
2410: , p_source_id
2411: , p_program_name
2412: , p_mode

Line 2416: jty_tae_index_creation_pvt.create_index( p_trans_target

2412: , p_mode
2413: , x_return_status
2414: , 'DEA_TRANS');
2415: ELSE
2416: jty_tae_index_creation_pvt.create_index( p_trans_target
2417: , p_trans_id
2418: , p_source_id
2419: , p_program_name
2420: , p_mode

Line 2426: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed.';

2422: , 'TRANS');
2423: END IF;
2424:
2425: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2426: x_msg_data := 'CALL to JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed.';
2427: RAISE FND_API.G_EXC_ERROR;
2428: END IF;
2429:
2430: -- debug message

Line 2434: 'API jty_tae_index_creation_pvt.create_index ended with success');

2430: -- debug message
2431: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2432: FND_LOG.string(FND_LOG.LEVEL_EVENT,
2433: 'jtf.plsql.JTY_TAE_CONTROL_PVT.decompose_terr_defns.create_index',
2434: 'API jty_tae_index_creation_pvt.create_index ended with success');
2435: END IF;
2436:
2437: END IF; /* end IF (p_generate_indexes = 'Y') */
2438: