DBA Data[Home] [Help]

APPS.OKL_COPY_ASSET_PVT dependencies on OKL_TXD_ASSETS_V

Line 1526: FROM Okl_Txd_Assets_V txd

1522: currency_conversion_type,
1523: currency_conversion_rate,
1524: currency_conversion_date
1525: -- Multi-Currency Change
1526: FROM Okl_Txd_Assets_V txd
1527: WHERE txd.tal_id = p_tal_id;
1528: BEGIN
1529: FOR r_okl_asdv_pk_csr IN c_okl_asdv_pk_csr(p_tal_id) LOOP
1530: x_txdv_tbl(i).ID := r_okl_asdv_pk_csr.ID;

Line 2765: FROM OKL_TXD_ASSETS_V

2761: IS
2762: SELECT 1
2763: FROM DUAL
2764: WHERE EXISTS (SELECT '1'
2765: FROM OKL_TXD_ASSETS_V
2766: WHERE tal_id = p_tal_id);
2767:
2768: CURSOR c_fa_line_id(p_cle_id OKL_K_LINES_V.ID%TYPE
2769: ,p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 2957: p_token1_value => 'OKL_TXD_ASSETS_V record');

2953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2954: OKL_API.set_message(p_app_name => G_APP_NAME,
2955: p_msg_name => G_NO_MATCHING_RECORD,
2956: p_token1 => G_COL_NAME_TOKEN,
2957: p_token1_value => 'OKL_TXD_ASSETS_V record');
2958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2960: OKL_API.set_message(p_app_name => G_APP_NAME,
2961: p_msg_name => G_NO_MATCHING_RECORD,

Line 2963: p_token1_value => 'OKL_TXD_ASSETS_V record');

2959: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2960: OKL_API.set_message(p_app_name => G_APP_NAME,
2961: p_msg_name => G_NO_MATCHING_RECORD,
2962: p_token1 => G_COL_NAME_TOKEN,
2963: p_token1_value => 'OKL_TXD_ASSETS_V record');
2964: RAISE OKL_API.G_EXCEPTION_ERROR;
2965: END IF;
2966: IF (l_txdv_tbl.COUNT > 0) THEN
2967: i := l_txdv_tbl.FIRST;