DBA Data[Home] [Help]

APPS.OKL_RCT_PVT dependencies on OKL_TRX_CSH_BATCH_B

Line 672: FROM okl_trx_csh_batch_b

668: x_return_status OUT NOCOPY VARCHAR2) IS
669:
670: CURSOR l_btc_id_csr IS
671: SELECT '1'
672: FROM okl_trx_csh_batch_b
673: WHERE id = p_rctv_rec.btc_id;
674:
675: l_dummy_var VARCHAR2(1):='0';
676:

Line 680: --check FK Relation with okl_trx_csh_batch_b

676:
677: BEGIN
678: x_return_status:=Okl_Api.G_RET_STS_SUCCESS;
679:
680: --check FK Relation with okl_trx_csh_batch_b
681: IF p_rctv_rec.btc_id IS NOT NULL THEN
682:
683: OPEN l_btc_id_csr;
684: FETCH l_btc_id_csr INTO l_dummy_var;

Line 698: p_token3_value => 'OKL_TRX_CSH_BATCH_B');

694: p_token1_value => 'BTC_ID',
695: p_token2 => G_CHILD_TABLE_TOKEN,
696: p_token2_value => G_VIEW,
697: p_token3 => G_PARENT_TABLE_TOKEN,
698: p_token3_value => 'OKL_TRX_CSH_BATCH_B');
699:
700: RAISE G_EXCEPTION_HALT_VALIDATION;
701: END IF;
702: END IF;