DBA Data[Home] [Help]

APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TXL_AP_INV_LNS_B

Line 194: ,p_token1_value => g_okl_txl_ap_inv_lns_b);

190: IF NOT (l_row_notfound) THEN
191: OKC_API.SET_MESSAGE(p_app_name => g_app_name
192: ,p_msg_name => okl_lla_cont_rev_trx_type
193: ,p_token1 => g_source_table
194: ,p_token1_value => g_okl_txl_ap_inv_lns_b);
195: x_return_status := G_RET_STS_ERROR;
196: RAISE G_EXCEPTION_ERROR;
197: END IF;
198:

Line 283: FROM OKL_TXL_AP_INV_LNS_B

279: AND b.khr_id = p_contract_id;
280:
281: CURSOR ap_inv_trx_lines_cur (p_tap_id NUMBER) IS
282: SELECT ID
283: FROM OKL_TXL_AP_INV_LNS_B
284: WHERE TAP_ID = p_tap_id;
285:
286: CURSOR trx_type_cur (p_try_id NUMBER) IS
287: SELECT TRX_TYPE_CLASS

Line 596: OPEN dist_cur (G_OKL_TXL_AP_INV_LNS_B, ap_inv_trx_lines_rec.id);

592: IF l_trx_type_class = G_FUNDING THEN
593: FOR ap_inv_trx_lines_rec IN ap_inv_trx_lines_cur (ap_inv_trx_rec.id)
594: LOOP
595:
596: OPEN dist_cur (G_OKL_TXL_AP_INV_LNS_B, ap_inv_trx_lines_rec.id);
597: FETCH dist_cur INTO l_found;
598: l_dist_not_found := dist_cur%NOTFOUND;
599: CLOSE dist_cur;
600:

Line 610: p_source_table => G_OKL_TXL_AP_INV_LNS_B,

606: x_return_status => l_return_status,
607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data,
609: p_source_id => ap_inv_trx_lines_rec.id,
610: p_source_table => G_OKL_TXL_AP_INV_LNS_B,
611: p_acct_date => p_transaction_date);
612:
613: IF l_return_status = G_RET_STS_ERROR THEN
614: RAISE G_EXCEPTION_ERROR;