850: l_dummy_var VARCHAR2(1) := '?' ;
851:
852: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
853: SELECT 'x'
854: FROM zx_rates_b
855: WHERE zx_rates_b.tax_rate_id = p_id;
856: BEGIN
857:
858: IF (p_ttdv_rec.tax_rate_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_rate_id IS NOT NULL)
851:
852: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
853: SELECT 'x'
854: FROM zx_rates_b
855: WHERE zx_rates_b.tax_rate_id = p_id;
856: BEGIN
857:
858: IF (p_ttdv_rec.tax_rate_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_rate_id IS NOT NULL)
859: THEN
871: 'tax_rate_id',
872: g_child_table_token ,
873: 'OKL_TAX_TRX_DETAILS',
874: g_parent_table_token ,
875: 'ZX_RATES_B');
876: l_return_status := OKC_API.G_RET_STS_ERROR;
877:
878: END IF;
879:
901: l_dummy_var VARCHAR2(1) := '?' ;
902:
903: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
904: SELECT 'x'
905: FROM zx_rates_b
906: WHERE zx_rates_b.tax_rate_code = p_code;
907: BEGIN
908:
909: IF (p_ttdv_rec.tax_rate_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_rate_code IS NOT NULL)
902:
903: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
904: SELECT 'x'
905: FROM zx_rates_b
906: WHERE zx_rates_b.tax_rate_code = p_code;
907: BEGIN
908:
909: IF (p_ttdv_rec.tax_rate_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_rate_code IS NOT NULL)
910: THEN
922: 'tax_rate_code',
923: g_child_table_token ,
924: 'OKL_TAX_TRX_DETAILS',
925: g_parent_table_token ,
926: 'ZX_RATES_B');
927: l_return_status := OKC_API.G_RET_STS_ERROR;
928:
929: END IF;
930:
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'
1978: FROM zx_rates_b
1979: WHERE zx_rates_b.tax_rate_id = p_id;
1980: l_okl_ttdv_tri okl_ttdv_tri_fk_csr%ROWTYPE;
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1975:
1976: CURSOR okl_ttdv_tri_fk_csr (p_id IN NUMBER) IS
1977: SELECT 'x'
1978: FROM zx_rates_b
1979: WHERE zx_rates_b.tax_rate_id = p_id;
1980: l_okl_ttdv_tri okl_ttdv_tri_fk_csr%ROWTYPE;
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1983: SELECT 'x'
1980: l_okl_ttdv_tri okl_ttdv_tri_fk_csr%ROWTYPE;
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1983: SELECT 'x'
1984: FROM zx_rates_b
1985: WHERE zx_rates_b.tax_rate_code = p_code;
1986: l_okl_ttdv_trc okl_ttdv_trc_fk_csr%ROWTYPE;
1987:
1988: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS
1981:
1982: CURSOR okl_ttdv_trc_fk_csr (p_code IN VARCHAR2) IS
1983: SELECT 'x'
1984: FROM zx_rates_b
1985: WHERE zx_rates_b.tax_rate_code = p_code;
1986: l_okl_ttdv_trc okl_ttdv_trc_fk_csr%ROWTYPE;
1987:
1988: CURSOR okl_ttdv_tei_fk_csr (p_id IN NUMBER) IS
1989: SELECT 'x'