APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 166: ,p_token1_value => g_okl_txl_cntrct_lns);

162: IF NOT (l_row_notfound) THEN
163: OKC_API.SET_MESSAGE(p_app_name => g_app_name
164: ,p_msg_name => okl_lla_cont_rev_trx_type
165: ,p_token1 => g_source_table
166: ,p_token1_value => g_okl_txl_cntrct_lns);
167: x_return_status := G_RET_STS_ERROR;
168: RAISE G_EXCEPTION_ERROR;
169: END IF;
170:

Line 258: FROM OKL_TXL_CNTRCT_LNS

254: --
255:
256: CURSOR ctrct_trx_lines_cur (p_tcn_id NUMBER) IS
257: SELECT ID
258: FROM OKL_TXL_CNTRCT_LNS
259: WHERE TCN_ID = p_tcn_id;
260:
261: CURSOR asset_trx_cur IS
262: SELECT DISTINCT TAS.ID TAS_ID,TAS.TRANSACTION_DATE

Line 354: OPEN dist_cur (G_OKL_TXL_CNTRCT_LNS, ctrct_trx_lines_rec.id);

350: IF l_trx_type_class = G_BOOKING THEN
351:
352: FOR ctrct_trx_lines_rec IN ctrct_trx_lines_cur (ctrct_trx_rec.id)
353: LOOP
354: OPEN dist_cur (G_OKL_TXL_CNTRCT_LNS, ctrct_trx_lines_rec.id);
355: FETCH dist_cur INTO l_found;
356: l_dist_not_found := dist_cur%NOTFOUND;
357: CLOSE dist_cur;
358: IF NOT l_dist_not_found THEN

Line 396: p_source_table => G_OKL_TXL_CNTRCT_LNS,

392: p_init_msg_list => l_init_msg_list,
393: x_return_status => l_return_status,
394: x_msg_count => l_msg_count,
395: x_msg_data => l_msg_data,
396: p_source_table => G_OKL_TXL_CNTRCT_LNS,
397: p_acct_date => p_transaction_date,
398: p_source_id_tbl => l_booking_source_id_tbl);
399: IF l_return_status = G_RET_STS_ERROR THEN
400: RAISE G_EXCEPTION_ERROR;

Line 430: p_source_table => G_OKL_TXL_CNTRCT_LNS,

426: p_init_msg_list => l_init_msg_list,
427: x_return_status => l_return_status,
428: x_msg_count => l_msg_count,
429: x_msg_data => l_msg_data,
430: p_source_table => G_OKL_TXL_CNTRCT_LNS,
431: p_acct_date => p_transaction_date,
432: p_source_id_tbl => l_upfronttax_source_id_tbl);
433:
434: IF l_return_status = G_RET_STS_ERROR THEN