eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_TXD_ASSETS_B

Line 1921: FUNCTION validate_txd_tax_book(p_asset_number IN OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE,

1917: -- History : BAKUCHIB 29-JUL-2003 - 3066346 created
1918: -- : BAKUCHIB 05-FEB-2004 - 3381853 Modified
1919: -- End of Commnets
1920: --------------------------------------------------------------------------------
1921: FUNCTION validate_txd_tax_book(p_asset_number IN OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE,
1922: x_fed_only_tax_book OUT NOCOPY OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
1923: x_fed_only OUT NOCOPY VARCHAR2)
1924: RETURN VARCHAR2 IS
1925: l_prog_name VARCHAR2(100) := 'VAL_TXD_TAX_BOOK';

Line 1922: x_fed_only_tax_book OUT NOCOPY OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

1918: -- : BAKUCHIB 05-FEB-2004 - 3381853 Modified
1919: -- End of Commnets
1920: --------------------------------------------------------------------------------
1921: FUNCTION validate_txd_tax_book(p_asset_number IN OKL_TXD_ASSETS_B.ASSET_NUMBER%TYPE,
1922: x_fed_only_tax_book OUT NOCOPY OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
1923: x_fed_only OUT NOCOPY VARCHAR2)
1924: RETURN VARCHAR2 IS
1925: l_prog_name VARCHAR2(100) := 'VAL_TXD_TAX_BOOK';
1926: g_process_error EXCEPTION;

Line 1930: lv_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;

1926: g_process_error EXCEPTION;
1927: G_NO_SETUP_TAX_BOOK CONSTANT VARCHAR2(200) := 'OKL_LLP_TAX_BOOK_MAP';
1928: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1929: i NUMBER := 0;
1930: lv_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
1931: -- Get the OKL_TXD_ASSETS_B info
1932: CURSOR l_txd_csr(p_asset_num VARCHAR2)
1933: IS
1934: SELECT tax_book

Line 1931: -- Get the OKL_TXD_ASSETS_B info

1927: G_NO_SETUP_TAX_BOOK CONSTANT VARCHAR2(200) := 'OKL_LLP_TAX_BOOK_MAP';
1928: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1929: i NUMBER := 0;
1930: lv_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
1931: -- Get the OKL_TXD_ASSETS_B info
1932: CURSOR l_txd_csr(p_asset_num VARCHAR2)
1933: IS
1934: SELECT tax_book
1935: FROM okl_txd_assets_v txd

Line 1949: tax_book okl_txd_assets_b.tax_book%TYPE := NULL ,

1945: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
1946: AND trns.object1_id1 = books.book_type_code
1947: AND books.book_type_code = p_book;
1948: TYPE tax_book_value_rec IS RECORD(
1949: tax_book okl_txd_assets_b.tax_book%TYPE := NULL ,
1950: value okl_sgn_translations.value%TYPE := NULL);
1951: TYPE tax_book_value_tbl IS TABLE OF tax_book_value_rec
1952: INDEX BY BINARY_INTEGER;
1953: lt_tax_book_value_tbl tax_book_value_tbl;

Line 1955: -- We scan thru OKL_TXD_ASSETS_B for tax book

1951: TYPE tax_book_value_tbl IS TABLE OF tax_book_value_rec
1952: INDEX BY BINARY_INTEGER;
1953: lt_tax_book_value_tbl tax_book_value_tbl;
1954: BEGIN
1955: -- We scan thru OKL_TXD_ASSETS_B for tax book
1956: FOR r_txd_csr IN l_txd_csr(p_asset_num => p_asset_number) LOOP
1957: OPEN l_txtrans_csr(p_book => r_txd_csr.tax_book);
1958: FETCH l_txtrans_csr INTO lt_tax_book_value_tbl(i).value,
1959: lt_tax_book_value_tbl(i).tax_book;

Line 2042: FUNCTION is_rep_pdt(--p_asset_number IN okl_txd_assets_b.asset_number%TYPE,

2038: -- History : BAKUCHIB 20-FEB-2004 - 3447917 created
2039: -- End of Commnets
2040: --------------------------------------------------------------------------------
2041: -- bug 4194673 fixed by HKPATEL
2042: FUNCTION is_rep_pdt(--p_asset_number IN okl_txd_assets_b.asset_number%TYPE,
2043: p_corp_book IN VARCHAR2,
2044: x_mg_tax_yn OUT NOCOPY VARCHAR2)
2045: RETURN VARCHAR2 IS
2046: l_prog_name VARCHAR2(100) := 'IS_REP_PDT';

Line 2050: CURSOR get_rep_tax_csr(p_asset_number okl_txd_assets_b.asset_number%TYPE)

2046: l_prog_name VARCHAR2(100) := 'IS_REP_PDT';
2047: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2048: lv_mg_tax_yn VARCHAR2(3) := 'N';
2049: /*
2050: CURSOR get_rep_tax_csr(p_asset_number okl_txd_assets_b.asset_number%TYPE)
2051: IS
2052: SELECT 'Y'
2053: FROM DUAL
2054: WHERE EXISTS (SELECT 'Y'

Line 2055: FROM okl_txd_assets_b txd

2051: IS
2052: SELECT 'Y'
2053: FROM DUAL
2054: WHERE EXISTS (SELECT 'Y'
2055: FROM okl_txd_assets_b txd
2056: WHERE txd.asset_number = p_asset_number
2057: AND txd.tax_book = fnd_profile.value('OKL_REPORTING_PDT_ASSET_BOOK'));
2058: */
2059: CURSOR get_rep_tax_csr(p_corp_book VARCHAR2)

Line 20061: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;

20057: l_api_version CONSTANT NUMBER := 1;
20058: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20059: lv_fed_only VARCHAR2(3) := 'N';
20060: ln_value NUMBER := 0;
20061: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
20062: lv_mg_tax_yn VARCHAR2(3) := 'N';
20063: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
20064: lv_currency_code okc_k_headers_b.currency_code%TYPE;
20065: l_rnd_basis_percent NUMBER;

Line 20108: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;

20104: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20105: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20106: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
20107: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
20108: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
20109: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
20110: lx_no_data_found BOOLEAN;
20111: -- l_sty_id NUMBER;
20112: l_sty_id strm_rec_type;

Line 20980: -- if there is multi gaap tax book create in okl_txd_assets_b table

20976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20977: EXIT WHEN(x_return_status = OKL_API.G_RET_STS_ERROR);
20978: END IF;
20979: -- If the reporting book is of deal type and if the
20980: -- if there is multi gaap tax book create in okl_txd_assets_b table
20981: -- then we go and generate the book dep streams for the Mg tax book
20982: -- else we do not generate stream for the Multi gaap
20983: IF lx_pdt_param_rec.deal_type = 'LEASEOP' AND lv_mg_tax_yn = 'Y' THEN
20984: --sechawla bug 8464912 : begin

Line 24677: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;

24673: ld_last_start_date okc_k_headers_b.start_date%TYPE;
24674: ld_last_end_date okc_k_headers_b.start_date%TYPE;
24675: ld_chr_end_date okc_k_headers_b.end_date%TYPE;
24676: -- End of BAKUCHIB modification bug#3121708
24677: lv_fed_only_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE := NULL;
24678: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
24679: lv_currency_code okc_k_headers_b.currency_code%TYPE;
24680: l_rnd_basis_percent NUMBER;
24681: l_level_type NUMBER;

Line 24712: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;

24708: l_feecap OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24709: l_capint OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24710: l_discount OKL_K_LINES.CAPITAL_AMOUNT%TYPE := 0;
24711: l_corp_dep_cost OKL_TXL_ASSETS_B.DEPRECIATION_COST%TYPE := 0;
24712: l_tax_dep_cost OKL_TXD_ASSETS_B.COST%TYPE := 0;
24713: l_lease_tax_owner okc_rules_b.rule_information1%TYPE := NULL;
24714: -- get the Contract Header info
24715: CURSOR l_hdr_csr(chrId NUMBER)
24716: IS