1295: l_dummy_var VARCHAR2(1) := '?' ;
1296:
1297: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
1298: SELECT 'x'
1299: FROM zx_regimes_b
1300: WHERE zx_regimes_b.tax_regime_id = p_id;
1301: BEGIN
1302:
1303: IF (p_ttdv_rec.tax_regime_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_regime_id IS NOT NULL)
1296:
1297: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
1298: SELECT 'x'
1299: FROM zx_regimes_b
1300: WHERE zx_regimes_b.tax_regime_id = p_id;
1301: BEGIN
1302:
1303: IF (p_ttdv_rec.tax_regime_id <> OKL_API.G_MISS_NUM AND p_ttdv_rec.tax_regime_id IS NOT NULL)
1304: THEN
1314: 'tax_regime_id',
1315: g_child_table_token ,
1316: 'OKL_TAX_TRX_DETAILS',
1317: g_parent_table_token ,
1318: 'ZX_REGIMES_B');
1319: l_return_status := OKC_API.G_RET_STS_ERROR;
1320:
1321: END IF;
1322: END IF;
1343: l_dummy_var VARCHAR2(1) := '?' ;
1344:
1345: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
1346: SELECT 'x'
1347: FROM zx_regimes_b
1348: WHERE zx_regimes_b.tax_regime_code = p_code;
1349: BEGIN
1350:
1351: IF (p_ttdv_rec.tax_regime_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_regime_code IS NOT NULL)
1344:
1345: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
1346: SELECT 'x'
1347: FROM zx_regimes_b
1348: WHERE zx_regimes_b.tax_regime_code = p_code;
1349: BEGIN
1350:
1351: IF (p_ttdv_rec.tax_regime_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_regime_code IS NOT NULL)
1352: THEN
1362: 'tax_regime_code',
1363: g_child_table_token ,
1364: 'OKL_TAX_TRX_DETAILS',
1365: g_parent_table_token ,
1366: 'ZX_REGIMES_B');
1367: l_return_status := OKC_API.G_RET_STS_ERROR;
1368:
1369: END IF;
1370: END IF;
2004: l_okl_ttdv_app_id okl_ttdv_app_id_fk_csr%ROWTYPE;
2005:
2006: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
2007: SELECT 'x'
2008: FROM zx_regimes_b
2009: WHERE zx_regimes_b.tax_regime_id = p_id;
2010: l_okl_ttdv_tx_reg_id okl_ttdv_tx_reg_id_fk_csr%ROWTYPE;
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2005:
2006: CURSOR okl_ttdv_tx_reg_id_fk_csr (p_id IN NUMBER) IS
2007: SELECT 'x'
2008: FROM zx_regimes_b
2009: WHERE zx_regimes_b.tax_regime_id = p_id;
2010: l_okl_ttdv_tx_reg_id okl_ttdv_tx_reg_id_fk_csr%ROWTYPE;
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2013: SELECT 'x'
2010: l_okl_ttdv_tx_reg_id okl_ttdv_tx_reg_id_fk_csr%ROWTYPE;
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2013: SELECT 'x'
2014: FROM zx_regimes_b
2015: WHERE zx_regimes_b.tax_regime_code = p_code;
2016: l_okl_ttdv_tx_reg_cd okl_ttdv_tx_reg_cd_fk_csr%ROWTYPE;
2017:
2018: CURSOR okl_ttdv_tx_id_fk_csr (p_id IN NUMBER) IS
2011:
2012: CURSOR okl_ttdv_tx_reg_cd_fk_csr (p_code IN VARCHAR2) IS
2013: SELECT 'x'
2014: FROM zx_regimes_b
2015: WHERE zx_regimes_b.tax_regime_code = p_code;
2016: l_okl_ttdv_tx_reg_cd okl_ttdv_tx_reg_cd_fk_csr%ROWTYPE;
2017:
2018: CURSOR okl_ttdv_tx_id_fk_csr (p_id IN NUMBER) IS
2019: SELECT 'x'