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.OKL_AM_RECYCLE_TRMNT_PVT dependencies on OKL_TRX_CONTRACTS

Line 34: FROM OKL_TRX_CONTRACTS

30: khr_id,
31: tmt_status_code,--akrangan changed for sla tmt_status_code cr
32: tmt_recycle_yn,
33: date_transaction_occurred
34: FROM OKL_TRX_CONTRACTS
35: WHERE id = p_rcy_id;
36:
37: -- Cursor to get the DB values for the recycled transaction
38: CURSOR get_recycle_k_vals_csr (p_khr_id IN NUMBER) IS

Line 231: FROM OKL_TRX_CONTRACTS T,

227:
228: -- Cursor to get the contract details for the transaction being recycled
229: CURSOR contract_details_csr ( p_tcn_id IN NUMBER) IS
230: SELECT K.contract_number
231: FROM OKL_TRX_CONTRACTS T,
232: OKL_K_HEADERS_FULL_V K
233: WHERE T.id = p_tcn_id
234: AND T.khr_id = K.id;
235:

Line 236: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

232: OKL_K_HEADERS_FULL_V K
233: WHERE T.id = p_tcn_id
234: AND T.khr_id = K.id;
235:
236: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
237: lx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
238: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
239: l_api_name CONSTANT VARCHAR2(30) := 'recycle_termination';
240: l_api_version CONSTANT NUMBER := 1;

Line 237: lx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

233: WHERE T.id = p_tcn_id
234: AND T.khr_id = K.id;
235:
236: lp_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
237: lx_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
238: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
239: l_api_name CONSTANT VARCHAR2(30) := 'recycle_termination';
240: l_api_version CONSTANT NUMBER := 1;
241: l_contract_number VARCHAR2(200);

Line 303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

299: lp_tcnv_rec.id := p_recy_rec.p_transaction_id;
300: lp_tcnv_rec.tmt_recycle_yn := 'Y';
301:
302: IF (is_debug_statement_on) THEN
303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
304: END IF;
305: -- call update of transaction
306: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
307: p_api_version => p_api_version,

Line 306: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(

302: IF (is_debug_statement_on) THEN
303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
304: END IF;
305: -- call update of transaction
306: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
307: p_api_version => p_api_version,
308: p_init_msg_list => OKL_API.G_FALSE,
309: x_return_status => l_return_status,
310: x_msg_count => x_msg_count,

Line 315: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts , return status: ' || l_return_status);

311: x_msg_data => x_msg_data,
312: p_tcnv_rec => lp_tcnv_rec,
313: x_tcnv_rec => lx_tcnv_rec);
314: IF (is_debug_statement_on) THEN
315: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts , return status: ' || l_return_status);
316: END IF;
317:
318: -- raise exception if error
319: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 343: p_trx_source_table => 'OKL_TRX_CONTRACTS',

339: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_UTIL_PVT.process_messages');
340: END IF;
341: -- Save message from stack into transaction message table
342: OKL_AM_UTIL_PVT.process_messages(
343: p_trx_source_table => 'OKL_TRX_CONTRACTS',
344: p_trx_id => lx_tcnv_rec.id,
345: x_return_status => l_return_status);
346: IF (is_debug_statement_on) THEN
347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_UTIL_PVT.process_messages , return status: ' || l_return_status);