APPS.OKL_CREATE_KLE_PVT dependencies on OKL_TXD_ASSETS_B

Line 3056: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

3052: -- Version : 1.0
3053: -- End of Commnets
3054: PROCEDURE Validate_asset_tax_book(x_return_status OUT NOCOPY VARCHAR2,
3055: p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
3056: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
3057: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) IS
3058: ln_asset_lines_dtls NUMBER := 0;
3059: CURSOR c_asset_lines_dtls_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
3060: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

Line 3060: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

3056: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
3057: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) IS
3058: ln_asset_lines_dtls NUMBER := 0;
3059: CURSOR c_asset_lines_dtls_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
3060: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
3061: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) is
3062: SELECT 1
3063: --FROM DUAL
3064: --WHERE EXISTS (SELECT '1'

Line 3065: FROM OKL_TXD_ASSETS_B txd,

3061: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) is
3062: SELECT 1
3063: --FROM DUAL
3064: --WHERE EXISTS (SELECT '1'
3065: FROM OKL_TXD_ASSETS_B txd,
3066: OKL_TXL_ASSETS_B txl
3067: WHERE txl.asset_number = p_asset_number
3068: AND txl.asset_number = txd.asset_number
3069: AND txl.tal_type IN ('CFA','CIB','CRB','CRL','CSP','CRV')

Line 10535: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when

10531: END IF;
10532:
10533: --Bug# 5530990
10534: -- Update Original Cost and Depreciation Cost in
10535: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when
10536: -- Add on line is added
10537: update_asset_cost(p_api_version => p_api_version,
10538: p_init_msg_list => p_init_msg_list,
10539: x_return_status => x_return_status,

Line 10782: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when

10778: END IF;
10779:
10780: --Bug# 5530990
10781: -- Update Original Cost and Depreciation Cost in
10782: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when
10783: -- Add on line is updated
10784: update_asset_cost(p_api_version => p_api_version,
10785: p_init_msg_list => p_init_msg_list,
10786: x_return_status => x_return_status,

Line 11017: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when

11013: END IF;
11014:
11015: --Bug# 5530990
11016: -- Update Original Cost and Depreciation Cost in
11017: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when
11018: -- Add on line is deleted
11019: update_asset_cost(p_api_version => p_api_version,
11020: p_init_msg_list => p_init_msg_list,
11021: x_return_status => x_return_status,

Line 12653: from okl_txd_assets_b txdb

12649: --cursor to get all the tax books
12650: CURSOR l_taxbook_csr(p_tal_id in number) is
12651: select txdb.tax_book,
12652: txdb.id
12653: from okl_txd_assets_b txdb
12654: where txdb.tal_id = p_tal_id;
12655:
12656: l_taxbook_rec l_taxbook_csr%ROWTYPE;
12657:

Line 12732: l_mg_txd_id okl_txd_assets_b.id%TYPE;

12728: from fa_additions
12729: where asset_id = p_asset_id;
12730:
12731: l_asset_number fa_additions.asset_number%TYPE;
12732: l_mg_txd_id okl_txd_assets_b.id%TYPE;
12733: --Bug# 3631094
12734:
12735: --Bug# 3783518 :
12736: CURSOR l_chk_rbk_csr (p_chr_id in NUMBER) is

Line 13329: --update okl_txd_Assets_b

13325: RAISE OKL_API.G_EXCEPTION_ERROR;
13326: END IF;
13327:
13328: If l_nbv is NOT NULL then
13329: --update okl_txd_Assets_b
13330: l_txdv_rec.id := l_taxbook_rec.id;
13331: l_txdv_rec.cost := l_nbv;
13332: OKL_TXD_ASSETS_PUB.UPDATE_TXD_ASSET_DEF
13333: (

Line 18769: -- Update Tax Book details - okl_txd_assets_b

18765: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18766: RAISE OKL_API.G_EXCEPTION_ERROR;
18767: END IF;
18768: --akrangan Bug# 5362977 start
18769: -- Update Tax Book details - okl_txd_assets_b
18770: update_asset_line_details(p_api_version => p_api_version,
18771: p_init_msg_list => p_init_msg_list,
18772: x_return_status => x_return_status,
18773: x_msg_count => x_msg_count,

Line 19649: -- Update Tax Book details - okl_txd_assets_b

19645: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19646: RAISE OKL_API.G_EXCEPTION_ERROR;
19647: END IF;
19648: --akrangan Bug# 5362977 start
19649: -- Update Tax Book details - okl_txd_assets_b
19650: update_asset_line_details(p_api_version => p_api_version,
19651: p_init_msg_list => p_init_msg_list,
19652: x_return_status => x_return_status,
19653: x_msg_count => x_msg_count,

Line 20462: -- Update Tax Book details - okl_txd_assets_b

20458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20459: RAISE OKL_API.G_EXCEPTION_ERROR;
20460: END IF;
20461: --Bug# 5176649 start
20462: -- Update Tax Book details - okl_txd_assets_b
20463: update_asset_line_details(p_api_version => p_api_version,
20464: p_init_msg_list => p_init_msg_list,
20465: x_return_status => x_return_status,
20466: x_msg_count => x_msg_count,