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 2341: jty_tae_index_creation_pvt.dea_selectivity(p_trans_target, x_return_status);

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

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

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

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

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

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

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

Line 2399: jty_tae_index_creation_pvt.drop_table_indexes(

2395: 'API JTY_TAE_CONTROL_PVT.reduce_tx_oin_index_set ended with success');
2396: END IF; /* end IF ((p_process_tx_oin_sel = 'Y') OR (p_process_tx_oin_sel = 'R')) */
2397:
2398: IF (p_generate_indexes = 'Y') THEN
2399: jty_tae_index_creation_pvt.drop_table_indexes(
2400: p_table_name => p_trans_target
2401: , x_return_status => x_return_status);
2402:
2403: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

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

Line 2410: jty_tae_index_creation_pvt.create_index( p_trans_target

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

Line 2418: jty_tae_index_creation_pvt.create_index( p_trans_target

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

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

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

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

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