APPS.OKL_COPY_ASSET_PVT dependencies on OKL_TXL_ASSETS_B

Line 210: FROM OKL_TXL_ASSETS_B

206: IS
207: SELECT 1
208: FROM DUAL
209: WHERE EXISTS (SELECT '1'
210: FROM OKL_TXL_ASSETS_B
211: WHERE asset_number = p_asset_number);
212:
213: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
214: SELECT 1

Line 3301: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,

3297: x_msg_count OUT NOCOPY NUMBER,
3298: x_msg_data OUT NOCOPY VARCHAR2,
3299: p_itiv_rec IN itiv_rec_type,
3300: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3301: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3302: x_trxv_rec OUT NOCOPY trxv_rec_type,
3303: x_itiv_rec OUT NOCOPY itiv_rec_type) IS
3304:
3305: l_trxv_rec trxv_rec_type;

Line 3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,

3487: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
3488: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
3489: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3490: p_trans_type IN OKL_TRX_ASSETS.TAS_TYPE%TYPE,
3491: p_asset_number IN OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE,
3492: p_fin_cle_id IN OKC_K_LINES_V.ID%TYPE,
3493: x_trxv_rec OUT NOCOPY trxv_rec_type,
3494: x_itiv_rec OUT NOCOPY itiv_rec_type)
3495: IS

Line 4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;

4095: lx_fa_clev_rec clev_rec_type;
4096: lx_fa_klev_rec klev_rec_type;
4097:
4098: ln_txd_line_number NUMBER := 0;
4099: lv_gen_asset_number OKL_TXL_ASSETS_B.ASSET_NUMBER%TYPE;
4100: l_fa_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4101: l_fa_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;
4102: l_ib_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE;
4103: l_ib_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE;

Line 4687: -- Populate either Salvage percent or Salvage value in okl_txl_assets_b

4683: --l_chr_curr_code := l_chr_rec.CURRENCY_CODE;
4684: --l_func_curr_code := OKC_CURRENCY_API.GET_OU_CURRENCY(l_chr_rec.authoring_org_id);
4685:
4686: -- Bug# 3950089
4687: -- Populate either Salvage percent or Salvage value in okl_txl_assets_b
4688: IF (r_asset_info.percent_salvage_value IS NULL) THEN
4689:
4690: IF ( l_chr_curr_code <> l_func_curr_code ) Then
4691: l_talv_rec.salvage_value := NULL;