1535: l_dummy_var VARCHAR2(1) := '?' ;
1536:
1537: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1538: SELECT 'x'
1539: FROM fnd_currencies
1540: WHERE fnd_currencies.currency_code = p_code;
1541: BEGIN
1542:
1543: IF (p_ttdv_rec.tax_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_currency_code IS NOT NULL)
1536:
1537: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1538: SELECT 'x'
1539: FROM fnd_currencies
1540: WHERE fnd_currencies.currency_code = p_code;
1541: BEGIN
1542:
1543: IF (p_ttdv_rec.tax_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.tax_currency_code IS NOT NULL)
1544: THEN
1554: 'tax_currency_code',
1555: g_child_table_token ,
1556: 'OKL_TAX_TRX_DETAILS',
1557: g_parent_table_token ,
1558: 'FND_CURRENCIES');
1559: l_return_status := OKC_API.G_RET_STS_ERROR;
1560:
1561: END IF;
1562: END IF;
1583: l_dummy_var VARCHAR2(1) := '?' ;
1584:
1585: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1586: SELECT 'x'
1587: FROM fnd_currencies
1588: WHERE fnd_currencies.currency_code = p_code;
1589: BEGIN
1590:
1591: IF (p_ttdv_rec.trx_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.trx_currency_code IS NOT NULL)
1584:
1585: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
1586: SELECT 'x'
1587: FROM fnd_currencies
1588: WHERE fnd_currencies.currency_code = p_code;
1589: BEGIN
1590:
1591: IF (p_ttdv_rec.trx_currency_code <> OKL_API.G_MISS_CHAR AND p_ttdv_rec.trx_currency_code IS NOT NULL)
1592: THEN
1602: 'trx_currency_code',
1603: g_child_table_token ,
1604: 'OKL_TAX_TRX_DETAILS',
1605: g_parent_table_token ,
1606: 'FND_CURRENCIES');
1607: l_return_status := OKC_API.G_RET_STS_ERROR;
1608:
1609: END IF;
1610: END IF;
2034: l_okl_ttdv_tx_jur_id okl_ttdv_tx_jur_id_fk_csr%ROWTYPE;
2035:
2036: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2037: SELECT 'x'
2038: FROM fnd_currencies
2039: WHERE fnd_currencies.currency_code = p_code;
2040: l_okl_ttdv_tx_cur_cd okl_ttdv_tx_cur_cd_fk_csr%ROWTYPE;
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2035:
2036: CURSOR okl_ttdv_tx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2037: SELECT 'x'
2038: FROM fnd_currencies
2039: WHERE fnd_currencies.currency_code = p_code;
2040: l_okl_ttdv_tx_cur_cd okl_ttdv_tx_cur_cd_fk_csr%ROWTYPE;
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2043: SELECT 'x'
2040: l_okl_ttdv_tx_cur_cd okl_ttdv_tx_cur_cd_fk_csr%ROWTYPE;
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2043: SELECT 'x'
2044: FROM fnd_currencies
2045: WHERE fnd_currencies.currency_code = p_code;
2046: l_okl_ttdv_trx_cur_cd_fk_csr okl_ttdv_trx_cur_cd_fk_csr%ROWTYPE;
2047:
2048:
2041:
2042: CURSOR okl_ttdv_trx_cur_cd_fk_csr (p_code IN VARCHAR2) IS
2043: SELECT 'x'
2044: FROM fnd_currencies
2045: WHERE fnd_currencies.currency_code = p_code;
2046: l_okl_ttdv_trx_cur_cd_fk_csr okl_ttdv_trx_cur_cd_fk_csr%ROWTYPE;
2047:
2048:
2049: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;