745: l_dummy_var VARCHAR2(1) := '?' ;
746:
747: CURSOR okl_ttdv_txs_id_fk_csr (p_id IN NUMBER) IS
748: SELECT 'x'
749: FROM Okl_tax_sources
750: WHERE id = p_id;
751: BEGIN
752:
753: IF (p_ttdv_rec.txs_id = OKL_API.G_MISS_NUM OR p_ttdv_rec.txs_id IS NULL)
766: 'txs_id',
767: g_child_table_token ,
768: 'OKL_TAX_TRX_DETAILS',
769: g_parent_table_token ,
770: 'OKL_TAX_SOURCES');
771: l_return_status := OKC_API.G_RET_STS_ERROR;
772:
773: END IF;
774: END IF;
1968: l_okl_ttdv_tax_call_type_code okl_ttdv_tax_call_t1%ROWTYPE;
1969:
1970: CURSOR okl_ttdv_txs_id_csr (p_id IN NUMBER) IS
1971: SELECT 'x'
1972: FROM Okl_Tax_Sources
1973: WHERE okl_tax_sources.id = p_id;
1974: l_okl_ttdv_txs_id okl_ttdv_txs_id_csr%ROWTYPE;
1975:
1976: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
1969:
1970: CURSOR okl_ttdv_txs_id_csr (p_id IN NUMBER) IS
1971: SELECT 'x'
1972: FROM Okl_Tax_Sources
1973: WHERE okl_tax_sources.id = p_id;
1974: l_okl_ttdv_txs_id okl_ttdv_txs_id_csr%ROWTYPE;
1975:
1976: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
1977: SELECT 'x'